UNIX_TIMESTAMP() ORDER BY id DESC"); $result_newsx = mysql_query("SELECT * FROM ".$prefix."news WHERE news_intern!='1' AND topnews_until>UNIX_TIMESTAMP() ORDER BY id DESC"); if ( mysql_num_rows ( $result_news_gesamtx ) > 0 ) { if(!$_REQUEST['news_start']) $_REQUEST['news_start'] = "1"; if(!$_REQUEST['news_show']) $_REQUEST['news_show'] = "4"; echo "

» Top-News

"; echo "

"; //checktable("news","titel varchar(255), autor varchar(255), inhalt text, timest int(15)"); if(!$_REQUEST['site']) $_REQUEST['site'] = 0; $proseite = 4; $seite_offiziell = $_REQUEST['site'] + 1; $seite = "Home"; $start = $proseite * $_REQUEST['site']; $end = $proseite; while($zeile = mysql_fetch_array($result_newsx)) { $thisid = $zeile['id']; $zeile['inhalt'] = preg_replace ( "=^(([^\n\r]{2,})((\n|\r){2}))(.*)=is" , "\\1
  Klapptext

" , $zeile['inhalt'] ); $commentcount[$thisid] = mysql_num_rows(mysql_query("SELECT * FROM ".$prefix."nc WHERE nc_id='".$thisid."' ORDER BY id ASC")); require("smilies.php"); $zeile['autor'] = htmlspecialchars ( $zeile['autor'] ); $m_qry = mysql_query ( "SELECT * FROM ".$prefix."members WHERE LOWER('".$zeile['autor']."') REGEXP LOWER(member_name) OR LOWER(member_name) LIKE '%".strtolower($zeile['autor'])."%' ORDER BY id DESC LIMIT 1" ) or die ( mysql_error () ); //if ( $_GET['1'] == "1" ) echo htmlspecialchars("SELECT * FROM ".$prefix."members WHERE LOWER('".$zeile['autor']."') REGEXP LOWER(member_name) OR LOWER(member_name) LIKE '%".strtolower($zeile['autor'])."%' ORDER BY id DESC LIMIT 1"); while ( $row_m = mysql_fetch_assoc ( $m_qry ) ) { $m_row['member_bild'] = $row_m['member_bild']; $m_row['id'] = $row_m['id']; } if ( mysql_num_rows ( $m_qry ) == 0 ) $m_row['member_bild'] = ""; if ( $m_row['member_bild'] != "" ) $imgtag = " "; else $imgtag = ""; echo "

"; echo "

	"; echo ""; echo ( "" ); echo ( " " ); echo ( " " ); echo ( " " ); echo ( "" ); echo ( " " ); echo ( " " ); echo ( " " ); echo ( " " ); echo ( " " ); echo ( "" ); echo ( " " ); echo ( " " ); echo ( " " ); echo ( " " ); echo ( " " ); echo ( " " ); echo ( " " ); echo ( "" ); echo ( " " ); echo ( "" ); echo ( "" ); echo ( "" ); echo ( "" ); echo ( "  ".stripslashes($zeile['titel'])." " ); echo ( " " ); if($zeile['news_bild']) echo ( "" ); echo stripslashes(nl2br(str_replace(" ","",$zeile['inhalt'])))." "; echo ( " " ); echo ( " " ); echo ( " " ); echo ( " " ); echo ( "" ); echo ( " Von ".htmlspecialchars($zeile['autor'])." am ".date("d.m.y",$zeile['timest'])." um ".date("H:i",$zeile['timest'])." Uhr " ); if($_COOKIE['level'] > 2) { echo ""; echo "--- Aktion wählen ---"; echo "Kommentieren (".$commentcount[$thisid].")"; echo "News bearbeiten"; echo "News löschen"; echo "Comment löschen"; echo ""; } else { echo " comments [".$commentcount[$thisid]."]"; } echo ( " " ); echo "

"; require("smilies.php"); } } if(!$_REQUEST['news_start']) $_REQUEST['news_start'] = "0"; if(!$_REQUEST['news_show']) $_REQUEST['news_show'] = "4"; echo "

» News

"; echo "

"; //checktable("news","titel varchar(255), autor varchar(255), inhalt text, timest int(15)"); if(!$_REQUEST['site']) $_REQUEST['site'] = 0; $proseite = 4; $seite_offiziell = $_REQUEST['site'] + 1; $seite = "Home"; $start = $proseite * $_REQUEST['site']; $end = $proseite; $result_news_gesamt = mysql_query("SELECT * FROM ".$prefix."news WHERE news_intern!='1' AND ( topnews_until='0' OR topnews_until<=UNIX_TIMESTAMP() ) ORDER BY id DESC"); $result_news = mysql_query("SELECT * FROM ".$prefix."news WHERE news_intern!='1' AND ( topnews_until='0' OR topnews_until<=UNIX_TIMESTAMP() ) ORDER BY id DESC LIMIT ".$_REQUEST['news_start'].",".$_REQUEST['news_show']); $max_seiten = floor(mysql_num_rows($result_news_gesamt) / $proseite); while($zeile = mysql_fetch_array($result_news)) { $thisid = $zeile['id']; $zeile['inhalt'] = preg_replace ( "=^(([^\n\r]{2,})((\n|\r){2}))(.*)=is" , "\\1
  Klapptext

" , $zeile['inhalt'] ); $commentcount[$thisid] = mysql_num_rows(mysql_query("SELECT * FROM ".$prefix."nc WHERE nc_id='".$thisid."' ORDER BY id ASC")); require("smilies.php"); $m_qry = mysql_query ( "SELECT * FROM ".$prefix."members WHERE ('".$zeile['autor']."') REGEXP member_name ORDER BY id DESC LIMIT 1" ); while ( $row_m = mysql_fetch_assoc ( $m_qry ) ) { $m_row['member_bild'] = $row_m['member_bild']; $m_row['id'] = $row_m['id']; } if ( mysql_num_rows ( $m_qry ) == 0 ) { $m_row['member_bild'] = ""; $m_row['id'] = 0; } if ( $m_row['member_bild'] != "" ) $imgtag = " "; else $imgtag = ""; echo "

"; echo "

	"; echo ""; echo ( "" ); echo ( " " ); echo ( " " ); echo ( " " ); echo ( "" ); echo ( " " ); echo ( " " ); echo ( " " ); echo ( " " ); echo ( " " ); echo ( "" ); echo ( " " ); echo ( " " ); echo ( " " ); echo ( " " ); echo ( " " ); echo ( " " ); echo ( " " ); echo ( "" ); echo ( " " ); echo ( "" ); echo ( "" ); echo ( "" ); echo ( "" ); echo ( "  ".stripslashes($zeile['titel'])." " ); echo ( " " ); if($zeile['news_bild']) echo ( "" ); echo stripslashes(nl2br(str_replace(" ","",$zeile['inhalt'])))." "; echo ( " " ); echo ( " " ); echo ( " " ); echo ( " " ); echo ( "" ); echo ( " Von ".htmlspecialchars($zeile['autor'])." am ".date("d.m.y",$zeile['timest'])." um ".date("H:i",$zeile['timest'])." Uhr " ); if($_COOKIE['level'] > 2) { echo ""; echo "--- Aktion wählen ---"; echo "Kommentieren (".$commentcount[$thisid].")"; echo "News bearbeiten"; echo "News löschen"; echo "Comment löschen"; echo ""; } else { echo " comments [".$commentcount[$thisid]."]"; } echo ( " " ); echo "

"; require("smilies.php"); } echo "

"; $maximal_news = mysql_num_rows(mysql_query("SELECT * FROM ".$prefix."news WHERE news_intern!='1' ORDER BY id DESC")); if($_REQUEST['news_show'] >= $maximal_news) $_REQUEST['news_start'] = "0"; echo "

"; echo "Zeige "; $showit = $_REQUEST['news_show']; $selected[$showit] = " selected"; echo "251020"; echo " News pro Seite"; if($_REQUEST['news_show'] < $maximal_news) { echo ", starte bei "; for($i=1;$i<=((floor(($maximal_news-1) / $_REQUEST['news_show'])+1)*$_REQUEST['news_show']);$i=$i+$_REQUEST['news_show']) { echo "".$i.""; } echo " "; } echo "  Anzeigen!      "; echo "

"; echo "

"; ?>

	"; } echo " ".$frage." "; if(!$voted) { echo ""; if($antworten) { foreach($antworten as $schluessel => $wert) { echo " ".$wert." "; } } echo "  Abstimmen!"; echo ""; } else { $i++; $result[$i] = mysql_query("SELECT * FROM ".$prefix."replies WHERE question='".$frageid."'"); $id=0; while($row=mysql_fetch_array($result[$i])) { $count[$id] = $row['counter']; $question[$id] = $row['antwort']; $id++; } foreach($count as $schluessel => $wert) { $insgesamt = $insgesamt + $wert; } foreach($question as $schluessel => $wert) { if($schluessel != (count($question) - 1)) { if($insgesamt) $prozent[$schluessel] = $count[$schluessel] / $insgesamt * 100; else $prozent[$schluessel] = 0; $prozent[$schluessel] = round($prozent[$schluessel],1); echo $question[$schluessel]." ".$prozent[$schluessel]."% (".$count[$schluessel].") "; } else { $thisteil = count($question) - 1; $prozent[$thisteil] = 100; for($i=0;$i<(count($question)-1);$i++) { $prozent[$thisteil] = $prozent[$thisteil] - $prozent[$i]; } if(!$insgesamt) $prozent[$thisteil] = 0; echo $question[$thisteil]." ".$prozent[$thisteil]."% (".$count[$thisteil].") "; } } echo " Insgesamt: [".$insgesamt."]"; echo " "; } ?> '".(time() - $Counter['Zeit'])."' AND stats_ip='".$_SERVER['REMOTE_ADDR']."'")) > 0) $donot = "1"; else $donot = "0"; $i++; $result[$i] = mysql_query("INSERT INTO ".$prefix."stats(stats_datum,stats_url,stats_ip,stats_donot) VALUES ('".time()."','index.php?".$_SERVER['QUERY_STRING']."','".$_SERVER['REMOTE_ADDR']."','".$donot."')"); $i++; $result[$i] = mysql_query("DELETE FROM ".$prefix."online WHERE stats_datum<'".(time() - $Counter['OnlineZeit'])."' OR stats_ip='".$_SERVER['REMOTE_ADDR']."'"); $i++; $result[$i] = mysql_query("INSERT INTO ".$prefix."online(stats_datum,stats_url,stats_ip) VALUES ('".time()."','index.php?".$_SERVER['QUERY_STRING']."','".$_SERVER['REMOTE_ADDR']."')"); include"counter/list.php"; ?>