sql_tablename_publish_de(); $shortcode_passkey = $config->shortcode_passkey(); $pdo = $conn->prepareQuery(); $design->setPath( "/home/www/wwwbuzzerstar/tpl/" ); $GoogleUserID = md5($_SERVER['HTTP_USER_AGENT'] . $_SERVER['REMOTE_ADDR']); $p_shortcode = $func->uniqueID($shortcode_passkey); $deviceTypeMobile = $detect->isMobile(); $deviceTypeTablet = $detect->isTablet(); $countryCode = $geoip->getCountryCode(); $status = ""; /* Parameter Execution */ $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']); $request_captcha = htmlspecialchars($_REQUEST['captcha']); $p_sourcelink = str_ireplace("?rel=","?",$p_sourcelink); $p_backlink = str_ireplace("?rel=","?",$p_backlink); $ImageFiles = array(); $ImageTexts = array(); $ImageFiles = $func->getTextBetweenTags($p_articletext,'[IMG]','[/IMG]'); $ImageTexts = $func->getTextBetweenTags($p_articletext,'[IMGTEXT]','[/IMGTEXT]'); if (count($ImageFiles)>=1){ $p_slidercontent = ""; for ($i=0;$i<=count($ImageFiles);$i++){ $pic_desc_key = array_key_exists($i,$ImageTexts); $pic_descr_content = ""; if ( $pic_desc_key === TRUE ){ $pic_descr_content = $ImageTexts[$i]; } else { $pic_descr_content = "BuzzerStar präsentiert dir dieses interessante Bild aus dem Internet"; } $pic_descr_lang = $func->GetLanguageFromString($pic_descr_content); $p_shortcode_1 = $func->uniqueID($shortcode_passkey); $image->downloadPictureExtra($p_picture1,$pic_descr_lang,$pic_descr_content,$p_shortcode_1); $p_slidercontent .= "$p_shortcode_1;"; }//for ($i=0;$i<=count($ImageFiles);$i++;){ $stmt = $pdo->prepare("UPDATE $table SET p_slidercontent=? WHERE p_shortcode=?"); $stmt->execute(array($p_sliderconten, $p_shortcode)); //$affected_rows = $stmt->rowCount(); } // image->downloadPictureExtra(image,lang, pic_desc, pic_file) // make shortcode in function, // getLanuage($ImageTexts[0]) // foreach image link push link to "p_slidercontent" in this format: picture1_id;picture2_id; // if count $ImageFiles >= 2 else show 1 picture at the end if(strpos($p_picture1, ' ') !== false){ $array23 = explode(' ',$p_picture1); $p_picture1 = $array23[0]; } if ( stripos($p_backlink, 'http') === false || empty($p_backlink) || strlen($p_backlink)<=7){ $p_backlink = "http://www.buzzerstar.com/"; } $copyYear = 2012; $curYear = date('Y'); $year = $copyYear . (($copyYear != $curYear) ? '-' . $curYear : ''); $copy = "©$year BuzzerStar.com - M.Sc. Sebastian Enger"; if (!empty($p_headline) && !empty($p_articletext) && !empty($p_sourcelink) && !empty($p_picturedesc1) && !empty($request_captcha) ){ $p_headline_lang = $func->GetLanguageFromString($p_headline); $p_articletext_lang = $func->GetLanguageFromString($p_articletext); $p_picturedesc1_lang = $func->GetLanguageFromString($p_picturedesc1); $array = array($p_headline_lang => 1, $p_articletext_lang => 2, $p_picturedesc1_lang => 3 ); if ( $array['de'] >= 2 ){ $p_language = "de"; } else { $p_language = $p_articletext_lang; } /* if (empty($_SESSION['captcha']) || trim(strtolower($request_captcha)) != $_SESSION['captcha']) { $captcha_message = "Ungültiger Bildcode - Artikel wurde nicht gespeichert."; $style = "

$captcha_message

"; // store content to tmp table $content = array_merge( array('canonical_tag'=>"http://www.buzzerstar.com/schreiben.php"), array('status'=>$style), array('copyright'=>$copy) ); $design->display_cache('write_article_de_successfull_post', $content, true, 3600*24*3); exit(0); } else { $captcha_message = "Gültiger Bildcode"; $style = "

$captcha_message

"; // store content to publish table unset($_SESSION['captcha']); } */ $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); $retVal = $conn->insertArticle($pdo,$table,$writeArticle); 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"; } $image->downloadPicture($p_picture1); $content = array_merge( array('canonical_tag'=>"http://www.buzzerstar.com/schreiben.php"), array('status'=>$status), array('copyright'=>$copy), array('USER_ID'=>$GoogleUserID) ); $design->display_cache('write_article_de_successfull_post', $content, true, 3600*24*3); $func->sendmyMail($p_authorname,$p_headline ); } else { $content = array_merge( array('headline'=>""), array('category'=>""), array('tags1'=>""), array('tags2'=>""), array('tags3'=>""), array('status'=>""), array('tags4'=>""), array('tags5'=>""), array('articletext'=>""), array('sourcelink'=>""), array('picture1'=>""), array('picture2'=>""), array('picture3'=>""), array('hashtag'=>""), array('videolink'=>""), array('twitterlink'=>""), array('backlink'=>""), array('paypallink'=>""), array('shortcode'=>""), array('authorname'=>""), array('picture_1_description'=>""), array('picturedescription1'=>""), array('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); /* Mobile Dection if ($deviceTypeMobile === TRUE && $deviceTypeTablet === FALSE && preg_match('/(DE|CH|AT|LI)/i',$countryCode)){ header("HTTP/1.1 301 Moved Permanently"); header("Location: http://www.youtube-mp3.mobi/m/"); // we have a mobile device exit(0); } else if ($deviceTypeMobile === TRUE && $deviceTypeTablet === FALSE){ header("HTTP/1.1 301 Moved Permanently"); header("Location: http://www.youtube-mp3.mobi/m/en/"); // we have a mobile device exit(0); } */ ?>