Anonymous

<?php

/*
------=![Uebersicht v 1]!=-------
------=![Autor: Rock@wulf]!=-------
------=![Kontakt: http://www.silentforces.de/]!=-------
------=![Dieses Modul ist für das ilch Clanscript v1.1]!=-------
------=![This module works with ilch Clanscript v1.1]!=-------
------=![ilch Clanscript: http://www.ilch.de/]!=-------*/

defined ('main') or die ( 'no direct access' );

$title = $allgAr['title'].' :: Übersicht';
$hmenu = 'Übersicht';
$design = new design ( $title , $hmenu );
$design->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'].='<tr class="Cnorm"><td>&nbsp;&nbsp; <b> &raquo; </b> &nbsp;<a class="box" href="?user-details-'.$rowu->id.'">'.$datumu.'&nbsp;'.$guser.'&nbsp;ist&nbsp;'.$rowu->recht.'</a></td></tr>';
}
$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'].='<tr><td width="90%" class="Cnorm" align="left"><b>&raquo;</b><a class="box" href="?news-'.$row->news_id.'">&nbsp;'.$row->news_title.'</a></td></tr>';
}
$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'].='<tr><td width="90%" class="Cnorm" align="left"><b> &raquo; </b><a class="box" href="?forum-showposts-'.$row->id.'-p'.$row->page.'#'.$row->pid.'">'.$row->name.' von '.$row->last.'</a><br /></td></tr>';
}
$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'].='<tr class="Cnorm"><td><a class="box" href="?gbook"><b> &raquo; </b>&nbsp;&nbsp;'.$datumg.'&nbsp;'.$nameg.'</a></td></tr>';
}
$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'].='<tr class="Cnorm"><td><b> &raquo; </b> &nbsp;<a class="box" href="?downloads-'.$rowdt->cid.'">'.$rowdt->cat.'</a>&nbsp;<a class="box" href="?downloads-show-'.$rowdt->id.'"> &raquo; &nbsp;'.$name.'</a></td></tr>';
}
$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'].='<tr class="Cnorm"><td> <b> &raquo; </b> &nbsp;<a class="box" href="?downloads-'.$rowdn->cid.'">'.$rowdn->cat.'</a>&nbsp;<a class="box" href="?downloads-show-'.$rowdn->id.'"> &raquo; &nbsp;'.$name.'</a></td></tr>';
}
$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'].='<tr class="'.$class.'"><td> &raquo; &nbsp;<a class="box" href="?links-'.$rowdt->cid.'">'.$rowdt->cat.'</a>&nbsp;<a class="box" href="?links-s'.$rowdt->id.'"> &raquo; &nbsp;'.$rowdt->name.'</a></td></tr>';
}
$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'].='<tr class="'.$class.'"><td> &raquo; &nbsp;<a class="box" href="?links-'.$rowdn->cid.'">'.$rowdn->cat.'</a>&nbsp;<a class="box" href="?links-s'.$rowdn->id.'"> &raquo; &nbsp;'.$rowdn->name.'</a></td></tr>';
}
$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='<tr><td colspan="2">kein War geplant</td></tr>';
} else {
while ($row = @db_fetch_object($erg) ) {
if(empty($row->tag)){
$gegner=$row->gegner;
}else{
$gegner=$row->tag;
}
$aus['WARSN'].='<tr><td class="Cnorm"><img src="include/images/wargames/'.$row->game.'.gif" alt="'.$row->game.'" border="0"></td><td class="Cnorm"><a class="box" href="?wars-more-'.$row->id.'">'.$row->time.' - '.$gegner.'</a></td></tr>';
}
}
$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'].='<tr><td class="Cnorm"><img src="include/images/wargames/'.$row->game.'.gif" alt="'.$row->game.'" border="0"></td><td colspan="2" class="Cnorm"><a class="box" style="color:#'.$farb2.';" href="?wars-more-'.$row->id.'">'.$row->owp.' zu '.$row->opp.'-'.$gegner.'</a></td></tr>';
}
$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'].='<a title="'.$row['art_title'].'" href="index.php?articles-show-A'.$row['art_id'].'">'.((strlen($row['art_title'])<18) ? $row['art_title'] : substr($row['art_title'],0,15).'...').'</a><br>';
       }
}
}
$tpl->out(12);

$design->footer();
?>