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 = "©$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 = "Dein Artikel wurde erfolgreich eingereicht.
Du kannst den Status unter www.buzzerstar.com/g.php?c=$p_shortcode einsehen!";
} else {
$status = "Es gab einen Fehler beim Speichern deiner Artikeldaten. Bitte versuche es in 10 Minuten erneut! Es gab folgende Fehlermeldung: $retVal";
}
$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);
?>