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']);
$deviceTypeMobile = $detect->isMobile();
$deviceTypeTablet = $detect->isTablet();
if (!is_numeric($page) || !isset($page) || empty($page) || strlen($page) <= 0 ){
$page = 0;
}
$imageRetArray = $func->getScreenResolutionFromUA();
$x = $imageRetArray["x"];
$y = $imageRetArray["y"];
$fontsize = $imageRetArray["fontsize"];
$picQuality = $imageRetArray["picQuality"];
$CurrentPage = $page;
$PageNext = $CurrentPage + 1;
$PageBack = $CurrentPage - 1;
$vor = "https://www.buzzerstar.com/?p=$PageNext";
$zurck = "https://www.buzzerstar.com/?p=$PageBack";
if ( $PageBack <= 0 ) { $PageBack = 0; $zurck = "/"; };
$page_html = "
<<< -";
$myrowbreakupcount = 1;
for ($i=1; $i<=5; $i++){
if ($i == $page ){
$page_html .= "[$i]-";
} else {
$page_html .= "$i-";
}
}
//$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,NOFOLLOW";
}
$all_row_count = 0;
$row_count = -1;
$pre_html = '';
$content_html .= $pre_html;
$h_tag_open = '';
$h_tag_close = '
';
$firstCount = 0;
while($rows = $stmt->fetch(PDO::FETCH_ASSOC)) {
$row_count++;
$all_row_count++;
$shortcode = "";
$headline = $rows["p_headline"];
$article = $rows["p_articletext"];
$author = $rows["p_authorname"];
$backlink = $rows["p_sourcelink"];
$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 = "https://www.buzzerstar.com/".$func->makeArticleLink($shortcode);
$list = preg_split("/[!?.]/", $article, -1, PREG_SPLIT_NO_EMPTY);
// $list = explode(". ", $article);
$first_nine_link = <<News Quelle
END;
$imageFiller =<<
FIN;
if ( $all_row_count > 0 && $all_row_count < 3){
$h_tag_open = '';
$h_tag_close = '
';
$imageFiller =<<
FIN;
} else if ( $all_row_count > 0 && $all_row_count < 6){
$h_tag_open = '';
$h_tag_close = '
';
} else if ( $all_row_count >= 6 && $all_row_count < 9){
$h_tag_open = '';
$h_tag_close = '
';
} else if ( $all_row_count >= 9 && $all_row_count < 12){
$h_tag_open = '';
$h_tag_close = '
';
} else if ( $all_row_count >= 12 && $all_row_count < 18){
$h_tag_open = '';
$h_tag_close = '
';
} else if ( $all_row_count >= 18){
$h_tag_open = '';
$h_tag_close = '
';
}
if ( $row_count == 3){
$row_count = 0;
$content_html .= $aft_html.$pre_html;
/*
if ($firstCount<1){
$content_html .=<<
Suche hier nach weiteren spannenden Nachrichten:
END;
} // if ($firstCount<=0){
$firstCount++;
*/
} // if ( $row_count == 3){
$content_html .=<<
$h_tag_open $headline $h_tag_close
$imageFiller
$pic_descr
$list[0]. $list[1].
END;
/*
News vom $timestamp in der Kategorie $category von $author
$first_nine_link
*/
/*
if ( $all_row_count == 1){
$content_html .=<<
END;
}
*/
if ($all_row_count < 9) {
$first_nine_link = <<News Quelle
END;
} else {
$first_nine_link = "";
}
}
$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 = '
END;
if ($deviceTypeMobile === TRUE && $deviceTypeTablet === FALSE ) {
$shareButtons =<<Teile mit deinen Freunden in Sozialen Netzwerken:
END;
} elseif ($deviceTypeMobile === FALSE || $deviceTypeTablet === TRUE) {
$shareButtons =<<Teile mit deinen Freunden in Sozialen Netzwerken:
END;
$shareholic_js =<<
var addthis_config = {
data_ga_property: 'UA-35911242-1',
data_ga_social: true
};
END;
} // } elseif ($deviceTypeMobile === FALSE || $deviceTypeTablet === FALSE ) {
$content = array_merge(
array('image'=>"https://www.buzzerstar.com/images/logo.png"),
array('copyright'=>$copy),
array('robots'=>"$robots"),
array('title'=>"Coole News auf BuzzerStar. Erzähl Sie weiter!"),
array('description'=>"Interessante, spannende und coole Nachrichten aus Entertainment, Kurioses, Lifestyle, Lustiges und Dating - teile deine News im Web!"),
array('author'=>"M.Sc. Sebastian Enger"),
array('html_content'=>$content_html),
array('page_content'=>$page_html),
array('canonical'=>"https://www.buzzerstar.com/"),
array('category_content'=>$category_content),
array('shareaholic_javascript'=>$shareholic_js),
array('inlineCSS'=>$func->getInlineCSS()),
array('share_this_content_buttons'=>$shareButtons)
);
$design->setPath( "/home/wwwbuzzerstar/tpl" );
$design->display_cache('startpage_de', $content, true, 3600*24*3);
$stmt = null; // doing this is mandatory for connection to get closed
$pdo = null;
exit(0);
?>