header();
$tpl = new tpl ( 'uebersicht.htm' );
include ('include/includes/func/uebersicht.php');//Konfiguration eingelesen.
$tpl->out(0);
$aus['USER']='';
$aus['NEWS']='';
$aus['FORUM']='';
$aus['GBOOK']='';
$aus['DOWNB']='';
$aus['DOWNN']='';
$aus['LINKB']='';
$aus['LINKN']='';
$aus['TUTN']='';
$aus['WARSN']='';
$aus['WARSL']='';
//Die lezten Registrierten USER
if($lastuser){
$ergu = db_query("SELECT a.id, a.name, a.regist, b.name as recht FROM prefix_user as a LEFT JOIN prefix_grundrechte as b ON b.id=a.recht ORDER BY regist DESC LIMIT 0,".$ulimit);
while ($rowu = @db_fetch_object($ergu) ) {
$datumu =date('d.m.y - H:m',$rowu->regist);
$user = $rowu->name;
$guser = substr($user, 0, 13);
$aus['USER'].='| » '.$datumu.' '.$guser.' ist '.$rowu->recht.' |
';
}
$tpl->set_ar_out($aus,1);
}
//Die lezten News
if($lastnews){
$abf = 'SELECT *FROM prefix_news WHERE news_recht >= '.$_SESSION['authright'].' ORDER BY news_time DESC LIMIT 0,'.$newslimit;
$erg = db_query($abf);
while ($row = @db_fetch_object($erg)) {
$aus['NEWS'].='| » '.$row->news_title.' |
';
}
$tpl->set_ar_out($aus,2);
}
//Die lezten Foren
if($lastforum){
$query = "SELECT a.id, a.name, a.rep, c.erst as last, c.id as pid, c.time
FROM prefix_topics a
LEFT JOIN prefix_forums b ON b.id = a.fid
LEFT JOIN prefix_posts c ON c.id = a.last_post_id
WHERE (b.view >= ".$_SESSION['authright']." OR b.reply >= ".$_SESSION['authright']." OR b.start >= ".$_SESSION['authright'].")
ORDER BY c.time DESC
LIMIT 0,".$forumlimit;
$resultID = db_query($query);
while ($row = @db_fetch_object($resultID)) {
$row->page = ceil ( ($row->rep+1) / $allgAr['Fpanz'] );
$aus['FORUM'].=' » '.$row->name.' von '.$row->last.'
|
';
}
$tpl->set_ar_out($aus,3);
}
//Die lezten Gbookeintraege
#beim gb moddet einfach WHERE stat=1 hinter prefix_gbook einfügen
if($lastgb){
$abfg = "SELECT * FROM prefix_gbook WHERE stat=1 ORDER BY id DESC LIMIT 0,".$gblimit;
$ergg = db_query($abfg);
while ($rowg = @db_fetch_object($ergg)) {
$datumg =date('d.m.y',$rowg->time);
$nameg = $rowg->name;
$aus['GBOOK'].='| » '.$datumg.' '.$nameg.' |
';
}
$tpl->set_ar_out($aus,4);
}
//Die 5 belibtesten downs
if($beldown){
$abfdt = "SELECT a.id, a.name, a.time, b.name as cat, b.id as cid FROM prefix_downloads a LEFT JOIN prefix_downcats b ON b.id=a.cat WHERE a.cat >= 0 AND b.recht >= ".$_SESSION['authright']." ORDER BY a.downs DESC LIMIT 0,".$beldlimit;
$ergdt = db_query($abfdt);
while ($rowdt = @db_fetch_object($ergdt)) {
$name = $rowdt->name;
$aus['DOWNB'].='| » '.$rowdt->cat.' » '.$name.' |
';
}
$tpl->set_ar_out($aus,5);
}
//Die Neusten 5 downs
if($newdown){
$abfdn = 'SELECT a.id, a.name, b.name as cat, b.id as cid FROM prefix_downloads a LEFT JOIN prefix_downcats b ON b.id=a.cat WHERE a.cat >= 0 AND b.recht >= '.$_SESSION['authright'].' ORDER BY id DESC LIMIT 0,'.$newdlimit;
$ergdn = db_query($abfdn);
while ($rowdn = @db_fetch_object($ergdn)) {
$name = $rowdn->name;
$aus['DOWNN'].='| » '.$rowdn->cat.' » '.$name.' |
';
}
$tpl->set_ar_out($aus,6);
}
//Die 5 belibtesten links
if($bellink){
$abfdt = "SELECT a.id, a.name, b.name as cat, b.id as cid FROM prefix_links a LEFT JOIN prefix_linkcats b ON b.id=a.cat ORDER BY hits DESC LIMIT 0,".$belllimit;
$ergdt = db_query($abfdt);
$class = 'Cdark';
while ($rowdt = @db_fetch_object($ergdt)) {
$aus['LINKB'].='| » '.$rowdt->cat.' » '.$rowdt->name.' |
';
}
$tpl->set_ar_out($aus,7);
}
//Die Neusten 5 links
if($newlink){
$abfdn = 'SELECT a.id, a.name, b.name as cat, b.id as cid FROM prefix_links a LEFT JOIN prefix_linkcats b ON b.id=a.cat ORDER BY id DESC LIMIT 0,'.$newllimit;
$ergdn = db_query($abfdn);
$class = 'Cdark';
while ($rowdn = @db_fetch_object($ergdn)) {
$aus['LINKN'].='| » '.$rowdn->cat.' » '.$rowdn->name.' |
';
}
$tpl->set_ar_out($aus,8);
}
//Die nächsten Wars
if($nextwars){
$akttime = date('Y-m-d');
$erg = db_query("SELECT DATE_FORMAT(datime,'%d.%m.%Y - %H:%i:%s') as time, id, game, gegner, tag FROM prefix_wars WHERE status = 2 AND datime > '".$akttime."' ORDER BY datime LIMIT 0,".$nwlimit);
if ( db_num_rows($erg) == 0 ) {
$warsn='| kein War geplant |
';
} else {
while ($row = @db_fetch_object($erg) ) {
if(empty($row->tag)){
$gegner=$row->gegner;
}else{
$gegner=$row->tag;
}
$aus['WARSN'].=' | '.$row->time.' - '.$gegner.' |
';
}
}
$tpl->set_ar_out($aus,9);
}
//Die lezten Wars
if($lastwars){
$erg = db_query('SELECT * FROM prefix_wars WHERE status = "3" ORDER BY datime DESC LIMIT 0,'.$lwlimit);
while ($row = @db_fetch_object($erg) ) {
if ($row->wlp == 1) {
$farbe = 'C8E1B8';
$farb2 = '00FF00';
} elseif ($row->wlp == 2) {
$farbe = 'D8B9B9';
$farb2 = 'FF0000';
} elseif ($row->wlp == 3) {
$farbe = 'FDFBB7';
$farb2 = 'FFFF00';
}
if(empty($row->tag)){
$gegner=$row->gegner;
}else{
$gegner=$row->tag;
}
$aus['WARSL'].=' | '.$row->owp.' zu '.$row->opp.'-'.$gegner.' |
';
}
$tpl->set_ar_out($aus,10);
}
$tpl->out(11);
//Die Neusten 5 Tutorials
if($newtut){
$ergdntut = db_query("SELECT art_title, art_id, DATE_FORMAT(art_time,'%d.%m.%Y') as datum
FROM `prefix_artsys_articles` artsys LEFT JOIN `prefix_artsys_cats` ON id = art_cat
WHERE art_status = 1 AND (".$_SESSION['authright']." <= recht OR (art_cat = 0 AND recht IS NULL)) ORDER by art_time DESC LIMIT 0,".$newtlimit."")OR die(mysql_error());
if(mysql_num_rows($ergdntut)){
while($row = db_fetch_assoc($ergdntut)){
$aus['TUTN'].=''.((strlen($row['art_title'])<18) ? $row['art_title'] : substr($row['art_title'],0,15).'...').'
';
}
}
}
$tpl->out(12);
$design->footer();
?>