<?php

###########################
### Autor: Sebastian Enger / M.Sc.
### Copyright: Sebastian Enger
### Licence: Commercial / BuzzerStar
### Version: 1.0.0c  - 08-11-2015@12:53 Uhr
### Contact: sebastian.enger@gmail.com
### Viiral.de und BuzzerStar.com Kooperation
###########################

//error_reporting(E_ALL);
//ini_set('display_errors', '0');

//error_reporting(E_ALL);
require_once("Config.inc.php");
require_once("Connection.inc.php");

$config 			= new Config();
$conn 				= new Connection();
$pdo				= $conn->prepareQuery();
$table 				= $config->sql_tablename_publish_de();

header("Content-Type: text/plain; charset=UTF-8");
header("Expires: on, 01 Jan 1970 00:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header('X-UA-Compatible: IE=edge,chrome=1');
header("Pragma: cache");

$re = '/# Split sentences on whitespace between them.
			(?<=                # Begin positive lookbehind.
			  [.!?]             # Either an end of sentence punct,
			| [.!?][\'"]        # or end of sentence punct and quote.
			)                   # End positive lookbehind.
			(?<!                # Begin negative lookbehind.
			  Mr\.              # Skip either "Mr."
			| Mrs\.             # or "Mrs.",
			| Ms\.              # or "Ms.",
			| Jr\.              # or "Jr.",
			| Dr\.              # or "Dr.",
			| Prof\.            # or "Prof.",
			| Sr\.              # or "Sr.",
			| T\.V\.A\.         # or "T.V.A.",
			| [\d{1,}]
			| [0-9{1,}]
								# or... (you get the idea).
			)                   # End negative lookbehind.
			\s+                 # Split on whitespace between sentences.
			/ix';
	
$stmt = $pdo->prepare("SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC");
$stmt->execute();

while($rows = $stmt->fetch(PDO::FETCH_ASSOC)) {
	$headline			= $rows["post_title"];
	$excerpt			= $rows["post_excerpt"];
	$linkingcode		= $rows["guid"];
	$sentences 			= preg_split($re, $rows["post_content"], -1, PREG_SPLIT_NO_EMPTY);
	echo "$headline###$excerpt###$linkingcode###$sentences[0] $sentences[1]\n";
}

$stmt 	= null; // doing this is mandatory for connection to get closed
$pdo   	= null;
		
exit(0);
?>