prepareQuery(); $table = $config->sql_tablename_publish_de(); $table_img = $config->sql_tablename_pictures(); $shortcode_passkey = $config->shortcode_passkey(); $pdo = $conn->prepareQuery(); $picpath = $config->picture_storepath(); $maxPageCount = $config->index_max_results(); $page = $func->stripHtml($_REQUEST['p']); $GoogleUserID = md5($_SERVER['HTTP_USER_AGENT'] . $_SERVER['REMOTE_ADDR']); $deviceTypeMobile = $detect->isMobile(); $deviceTypeTablet = $detect->isTablet(); if ($deviceTypeMobile === FALSE || $deviceTypeTablet === FALSE ) { $shareaholic = ""; } if (!is_numeric($page) || !isset($page) || empty($page) || strlen($page) <= 0 ){ $page = 0; } // root navigation caluclation: $root_navigation_htmlcontent =<<

END; $arr1 = $config->category_to_show(); foreach ($arr1 as &$value) { $stmt = $pdo->prepare("SELECT * FROM $table WHERE id>0 AND p_isonline=1 AND p_category=:p_category ORDER BY p_timestamp DESC LIMIT 4;"); $array = array(':p_category' => $value ); $stmt->execute($array); $r_count = 0; while($rows = $stmt->fetch(PDO::FETCH_ASSOC)) { $headline = $rows["p_headline"]; $shortcode = $rows["p_shortcode"]; $pic_descr = $rows["p_picture_1_description"]; $category_id = $rows["p_category"]; $catg_array = $config->array_category(); $category = $catg_array[$category_id]; $categoryLink = "http://www.buzzerstar.com/kategorie/".$category; $linkingcode = "http://www.buzzerstar.com/".$func->makeArticleLink($shortcode); if ($r_count == 0){ $root_navigation_htmlcontent .=<<
$category
- $headline
END; $content = array_merge( array('image'=>"http://www.buzzerstar.com/images/logo.png"), array('copyright'=>$copy), array('root_navigation'=>$root_navigation_htmlcontent), array('robots'=>"$robots"), array('title'=>"Unglaubliche Neuigkeiten die Dich bewegen. Erzähl Sie weiter!"), array('description'=>"Interessante, lustige, freche und humorvolle Neuigkeiten aus Entertainment, Lifestyle, Technik, Lustiges und Tiere - komm lies und schreib einen Artikel!"), array('author'=>"M.Sc. Sebastian Enger"), array('html_content'=>$content_html), array('page_content'=>$page_html), array('category_content'=>$category_content), array('shareaholic'=>$shareaholic), array('shareaholic_javascript'=>$shareholic_js), array('share_this_content_buttons'=>$shareButtons), array('USER_ID'=>$GoogleUserID) ); $design->setPath( "/home/wwwbuzzerstar/devel/tpl/" ); $design->display_cache('startpage_v2', $content, true, 3600*24*3); $stmt = null; // doing this is mandatory for connection to get closed $pdo = null; exit(0); $CurrentPage = $page; $PageNext = $CurrentPage + 1; $PageBack = $CurrentPage - 1; $vor = "/?p=$PageNext"; $zurck = "/?p=$PageBack"; if ( $PageBack <= 0 ) { $PageBack = 0; $zurck = "/"; }; /* $stmt3 = $pdo->prepare("SELECT * FROM $table WHERE id>0 AND p_isonline=1 ORDER BY p_timestamp DESC LIMIT 600;"); $stmt3->execute(); $myRowCountRR = $stmt3->rowCount(); $resultRechnung = round(($myRowCountRR/$maxPageCount), 0, PHP_ROUND_HALF_DOWN); */ $page_html = "
<<< - "; $myrowbreakupcount = 1; for ($i=1; $i<=5; $i++){ if ($i == $page ){ $page_html .= "[$i] - "; } elseif ($i == ($page+1) ){ $page_html .= "$i - "; } elseif ( $myrowbreakupcount == 7 ){ // zeilenumbruch nach 10 Seiten $myrowbreakupcount = 1; $page_html .= "$i -
"; } elseif ( $i != $resultRechnung ) { $page_html .= "$i - "; } elseif ( $i >= $resultRechnung ) { $page_html = preg_replace('# - $#', '', $page_html); } $myrowbreakupcount++; } //$page_html .= " Nächste Seite
"; //$page_html = substr($page_html, 0, -38).""; $page_html .= " >>> "; $from = ( $maxPageCount * $page ); $stmt = $pdo->prepare("SELECT * FROM $table WHERE id>0 AND p_isonline=1 ORDER BY p_timestamp DESC LIMIT $from, $maxPageCount;"); $stmt->execute(); $myRowCount = $stmt->rowCount(); if ( $myRowCount >= 1 ){ $robots = "INDEX,FOLLOW,ALL"; } else { $robots = "NOINDEX,FOLLOW"; } $all_row_count = 0; $row_count = 0; $pre_html = '
'; $aft_html = '
'; $content_html .= $pre_html; $h_tag_open = '
'; $h_tag_close = '
'; while($rows = $stmt->fetch(PDO::FETCH_ASSOC)) { $row_count++; $all_row_count++; $headline = $rows["p_headline"]; $article = $rows["p_articletext"]; $author = $rows["p_authorname"]; $backlink = $rows["p_backlink"]; $shortcode = $rows["p_shortcode"]; $category_id = $rows["p_category"]; $pic_descr = $rows["p_picture_1_description"]; $catg_array = $config->array_category(); $category = $catg_array[$category_id]; $list_time = explode(" ",trim($rows["p_timestamp"])); $timestamp = $list_time[0]." um ".$list_time[1] ." Uhr"; $linkingcode = "http://www.buzzerstar.com/".$func->makeArticleLink($shortcode); $list = explode(". ", $article); $content_html .=<< $h_tag_open
$headline
$h_tag_close
Veröffentlicht am $timestamp in der Kategorie $category

Bildbeschreibung: $pic_descr

$list[0]. $list[1].

Dieser Artikel wurde von BuzzerStar Autor $author verfasst.
END; if ( $row_count == 3){ $row_count = 0; $h_tag_open = '
'; $h_tag_close = '
'; $content_html .= $aft_html.$pre_html; } } $content_html .= ''; $copyYear = 2012; $curYear = date('Y'); $year = $copyYear . (($copyYear != $curYear) ? '-' . $curYear : ''); $copy = "©$year BuzzerStar.com - M.Sc. Sebastian Enger"; $LinkableCatgID = $config->category_to_show(); $category_content = '
Beliebte: '; foreach ($LinkableCatgID as $keyCatg ){ $linkableCodeCatg = $func->buildCategoryLink($keyCatg); $catgName = $func->categoryIDtoName($keyCatg); $category_content .=<<$catgName - END; } $linkableCodeCatg = $func->buildCategoryLink(22); $catgName = $func->categoryIDtoName(22); $category_content .=<<$catgName
END; if ($deviceTypeMobile === TRUE && $deviceTypeTablet === FALSE ) { $shareButtons =<<Teile mit deinen Freunden in Sozialen Netzwerken:

END; } elseif ($deviceTypeMobile === FALSE || $deviceTypeTablet === FALSE ) { $shareButtons =<<Teile mit deinen Freunden in Sozialen Netzwerken:

END; $shareaholic = ""; $shareholic_js =<< END; } $content = array_merge( array('image'=>"http://www.buzzerstar.com/images/logo.png"), array('copyright'=>$copy), array('robots'=>"$robots"), array('title'=>"Unglaubliche Neuigkeiten die Dich bewegen. Erzähl Sie weiter!"), array('description'=>"Interessante, lustige, freche und humorvolle Neuigkeiten aus Entertainment, Lifestyle, Technik, Lustiges und Tiere - komm lies und schreib einen Artikel!"), array('author'=>"M.Sc. Sebastian Enger"), array('html_content'=>$content_html), array('page_content'=>$page_html), array('category_content'=>$category_content), array('shareaholic'=>$shareaholic), array('shareaholic_javascript'=>$shareholic_js), array('share_this_content_buttons'=>$shareButtons), array('USER_ID'=>$GoogleUserID) ); $design->setPath( "/home/wwwbuzzerstar/devel/tpl/" ); $design->display_cache('startpage_v2', $content, true, 3600*24*3); $stmt = null; // doing this is mandatory for connection to get closed $pdo = null; exit(0); ?>

'; $h_tag_close = '

Veröffentlicht am $timestamp in der Kategorie $category

$list[0]. $list[1].

'; $h_tag_close = '