prepareQuery(); $table = $config->sql_tablename_publish_de(); $pdo = $conn->prepareQuery(); $action = $func->stripHtml($_REQUEST['a']); $shortid = $func->stripHtml($_REQUEST['sid']); $p_isdelete = $func->stripHtml($_REQUEST['del']); if (stripos($action, 'set_online_simple') !== false ){ if ( $p_isdelete == 1 && strlen($p_isdelete) == 1 ){ $sql = "DELETE FROM $table WHERE p_shortcode = :shortcode LIMIT 1;"; $stmt = $pdo->prepare($sql); $stmt->bindParam(':shortcode', $shortid, PDO::PARAM_STR); $stmt->execute(); } else { $p_isonline = 1; $stmt = $pdo->prepare("UPDATE $table SET p_isonline=? WHERE p_shortcode=?"); $stmt->execute(array($p_isonline,$shortid)); } $stmt = null; // doing this is mandatory for connection to get closed $pdo = null; header("Location: /manage/"); exit(0); } elseif (stripos($action, 'set_online_advanced') !== false){ } elseif (stripos($action, 'show_advanced') !== false){ /* */ } else if ( empty($action) || strlen($action) <=0 || !isset($action) || empty($shortid) || strlen($shortid) <=0 || !isset($shortid) ) { //echo "trying to get from db"; $stmt = $pdo->prepare("SELECT * FROM $table WHERE id>0 AND p_isonline='0' ORDER BY p_timestamp DESC LIMIT 30;"); $stmt->execute(); $content_html = '

'; while($rows = $stmt->fetch(PDO::FETCH_ASSOC)) { $headline = trim($rows["p_headline"]); $author = trim($rows["p_authorname"]); $backlink = trim($rows["p_backlink"]); $shortcode = trim($rows["p_shortcode"]); $article = trim($rows["p_articletext"]); $pic_desc = trim($rows["p_picture_1_description"]); $videolink = trim($rows["p_videolink"]); $SSDTube->identify($videolink, true); $EmbeddedVideo = $SSDTube->embed; if (stripos($videolink, "https")===false){ $error = "Videolink ist kein HTTPS LINK - eventuelle Bildbeschreibung und Videolink vertauscht?"; } $text_short = substr($article,0,250). "..."; //$neuertext = wordwrap( $headline, 75, "
"); $content_html .= <<

Schlagzeile: $headline

Artikelauszug: $article

Bilder und Videos:
Bildunterschrift: $pic_desc
Video: $videolink - $error
$EmbeddedVideo

Artikel freischalten: Artikel (sofort) freischalten

Artikel löschen: Artikel (sofort) löschen

END; } if ( stripos($content_html, 'Schlagzeile') === false){ $content_html .= 'Es warten keine Einträge auf deine Administration!'; } $content_html .= '

'; } $copyYear = 2012; $curYear = date('Y'); $year = $copyYear . (($copyYear != $curYear) ? '-' . $curYear : ''); $copy = "©$year BuzzerStar.com - M.Sc. Sebastian Enger"; $content = array_merge( array('image'=>"http://www.buzzerstar.com/images/logo_header.png"), // change for final version array('copyright'=>$copy), array('robots'=>"NOINDEX,NOFOLLOW,NONE"), array('html_content'=>$content_html) ); $design->setPath( "/home/www/wwwbuzzerstar/tpl-new/" ); $design->display_cache('administration_simple', $content, true, 3600*24*3); $stmt = null; // doing this is mandatory for connection to get closed $pdo = null; exit(0); ?>