<?php

header("Content-Type: text/html; 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("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
//header("Pragma: no-cache");

/*
//later: geo ip und spracheinstellungen
error_reporting(E_ALL);
ini_set('display_errors', '0');
*/

require_once( "/home/www/wwwbuzzerstar/library/Template.inc.php" );
require_once( "/home/www/wwwbuzzerstar/library/Config.inc.php" );
require_once( "/home/www/wwwbuzzerstar/library/Functions.inc.php" );
require_once( "/home/www/wwwbuzzerstar/library/Connection.inc.php");

$design 			= new Template();
$func	 			= new Functions();
$config 			= new Config();
$conn 				= new Connection();
$table 				= $config->sql_tablename_revision();
$pdo				= $conn->prepareQuery();
$design->setPath( "/home/www/wwwbuzzerstar/tpl/" );
$GoogleUserID		= md5($_SERVER['HTTP_USER_AGENT'] . $_SERVER['REMOTE_ADDR']);

/*
Parameter Execution
*/
$myFunction 		= $func->stripHtml($_REQUEST['myfunction']); // read / write
$p_headline 		= $func->stripHtml($_REQUEST['headline']);
$p_category 		= $func->stripHtml($_REQUEST['category']);
$p_tags1 			= $func->stripHtml($_REQUEST['tags1']);
$p_tags2 			= $func->stripHtml($_REQUEST['tags2']);
$p_tags3 			= $func->stripHtml($_REQUEST['tags3']);
$p_tags4 			= $func->stripHtml($_REQUEST['tags4']);
$p_tags5 			= $func->stripHtml($_REQUEST['tags5']);
$p_articletext 		= $func->stripHtml($_REQUEST['articletext']);
$p_sourcelink 		= $func->stripHtml($_REQUEST['sourcelink']);
$p_picture1 		= $func->stripHtml($_REQUEST['picture1']);
$p_picture2 		= $func->stripHtml($_REQUEST['picture2']);
$p_picture3 		= $func->stripHtml($_REQUEST['picture3']);
$p_hashtag 			= $func->stripHtml($_REQUEST['hashtag']);
$p_videolink 		= $func->stripHtml($_REQUEST['videolink']);
$p_twitterlink 		= $func->stripHtml($_REQUEST['twitterlink']);
$p_backlink 		= $func->stripHtml($_REQUEST['backlink']);
$p_paypallink 		= $func->stripHtml($_REQUEST['paypallink']);
$p_authorname 		= $func->stripHtml($_REQUEST['authorname']);
$p_picturedesc1		= $func->stripHtml($_REQUEST['picture_1_description']);

$p_sourcelink 		= str_ireplace("?rel=","?",$p_sourcelink);
$p_backlink 		= str_ireplace("?rel=","?",$p_backlink);

if(strpos($p_picture1, ' ') !== false){
   $array23 		= explode(' ',$p_picture1);
   $p_picture1 		= $array23[0];
}

$copyYear 			= 2012; 
$curYear 			= date('Y'); 
$year 				= $copyYear . (($copyYear != $curYear) ? '-' . $curYear : '');
$copy 				= "&copy;$year BuzzerStar.com, Sebastian Enger.";

$sessionid 			= md5($_SERVER['HTTP_USER_AGENT'] . $_SERVER['REMOTE_ADDR']);

if (stripos($myFunction, 'save') !== false){
	
	$writeArticle		= array(':headline' => $p_headline, ':category' => $p_category, ':tags' => "$p_tags1;$p_tags2;$p_tags3;$p_tags4;$p_tags5", ':articletext' => $p_articletext, ':sourcelink' => $p_sourcelink, ':picture1' => $p_picture1, ':picture2' => $p_picture2, ':picture3' => $p_picture3, ':hashtag' => $p_hashtag, ':videolink' => $p_videolink, ':twitterlink' => $p_twitterlink, ':backlink' => $p_backlink , ':paypallink' => $p_paypallink, ':authorname' => $p_authorname, ':shortcode' => $p_shortcode, ':picture_1_description' => $p_picturedesc1,':language' => $p_language);
	
	$serialize 		= serialize($writeArticle);
	$storeSession 	= array('p_cookie'=>$serialize,'p_sessionid'=>$sessionid);
	$retVal 		= $conn->insertRevision($pdo,$table,$storeSession);
	/*
	if ($retVal == 1){
		$status = "<span style=\"color:green\">Dein Artikel wurde erfolgreich eingereicht. <br />Du kannst den Status unter <b><strong><a href=\"/g.php?c=$p_shortcode\" target=\"_blank\">www.buzzerstar.com/g.php?c=$p_shortcode</a></strong></b> einsehen!</span>";
	} else {
		$status = "<span style=\"color:red\">Es gab einen Fehler beim Speichern deiner Artikeldaten. Bitte versuche es in 10 Minuten erneut! Es gab folgende Fehlermeldung: $retVal</span>";
	}
	
	$content = array_merge(
		array('canonical_tag'=>"http://www.buzzerstar.com/schreiben.php"),
		array('status'=>$status),
		array('copyright'=>$copy)
	);	
	$design->display_cache('write_article_de_successfull_post', $content, true, 3600*24*3);
	*/
	
	echo "Dein Artikel wurde am ".date('Y-m-d H:i:s')." gespeichert.";
	
} elseif (stripos($myFunction, 'restore') !== false){
	
	$stmt 				= $pdo->prepare("SELECT p_cookie FROM $table WHERE p_sessionid=:p_sessionid ORDER BY p_timestamp DESC LIMIT 1");
	$stmt->bindValue(':p_sessionid', $sessionid, PDO::PARAM_STR);
	$stmt->execute();
	$rows 				= $stmt->fetchAll(PDO::FETCH_ASSOC);
	$writeArticle		= unserialize($rows[0]["p_cookie"]);
	//print_r($stmt->errorInfo());
	$TagArray			= explode(";", $writeArticle[':tags']);
		
	$content = array_merge(
		array('headline'=>$writeArticle[':headline']),
		array('category'=>$writeArticle[':category']),
		array('tags1'=>$TagArray[0]),
		array('tags2'=>$TagArray[1]),
		array('tags3'=>$TagArray[2]),
		array('tags4'=>$TagArray[3]),
		array('tags5'=>$TagArray[4]),
		array('articletext'=>$writeArticle[':articletext']),
		array('sourcelink'=>$writeArticle[':sourcelink']),
		array('picture1'=>$writeArticle[':picture1']),
		array('picture2'=>$writeArticle[':picture2']),
		array('picture3'=>$writeArticle[':picture3']),
		array('hashtag'=>$writeArticle[':hashtag']),
		array('videolink'=>$writeArticle[':videolink']),
		array('twitterlink'=>$writeArticle[':twitterlink']),
		array('backlink'=>$writeArticle[':backlink']),
		array('paypallink'=>$writeArticle[':paypallink']),
		array('shortcode'=>$writeArticle[':shortcode']),
		array('authorname'=>$writeArticle[':authorname']),
		array('picture_1_description'=>$writeArticle[':picture_1_description']),
		array('language'=>$writeArticle[':language']),
		array('copyright'=>$copy),
		array('status'=>""),
		array('USER_ID'=>$GoogleUserID)
	);
	$design->display_cache('write_article_de_new', $content, true, 3600*24*3);
	
}
$stmt 				= null; // doing this is mandatory for connection to get closed
$pdo 				= null;
exit(0);
?>