ilch.de :: Forum :: Ilch Clan 1.1 :: Allgemein

lastnews.php

<?php
#   Copyright by C.C.A.A.
#	Support www.DragonDesigns.de

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

$sql ='SELECT
          a.news_kat as kate,
          UNIX_TIMESTAMP(a.news_time) as time,      
          a.news_title as title,
          a.news_id as nid,      
          b.name as uname,
          b.id as uid          
          FROM prefix_news as a
          LEFT JOIN prefix_user as b ON a.user_id = b.id
          WHERE news_recht >= '.$_SESSION['authright'].'
          ORDER BY a.news_time DESC
          LIMIT 0,4';

$erg = db_query($sql);
echo '<table width="100%" style="padding-top:10px;" cellspacing="1" cellpadding="3">';
while ($row = db_fetch_object($erg)) {  
echo'<tr>';
echo'<td><table width="100%" border="0" cellspacing="0" cellpadding="0">';
echo'<tr>';
echo'<td rowspan="2" align="center" valign="middle"><img style="padding-right:5px;" src="include/images/icons/lastcat.png" width="16" height="16" /></td>';
echo'<td width="100%" colspan="2" align="left"><a class="lasttitle" href="index.php?news-'.$row->nid.'">'.((strlen($row->title)<30) ? $row->title : substr($row->title,0,27).'...').'</a></td>';
echo'</tr>';
echo'<tr>';
echo'<td width="70%" style="font-family: Verdana, Arial, Helvetica, sans-serif;font-weight:bold;color:#b4b4b4;font-size:7px;" align="left">'.$lang[date('l', $row->time)].', '.date('d. M  Y', $row->time).'|'.date('H:i',$row->time).'Uhr</td>';
echo'<td width="30%" style="font-family: Verdana, Arial, Helvetica, sans-serif;font-weight:bold;color:#cd0404;font-size:7px;" align="left">Autor:&nbsp;<a class="lastautor" href="index.php?user-details-'.$row->uid.'">'.$row->uname.'</a></td>';
echo'</tr>';
echo'</table></td>';
echo'</tr>';
}
echo '</table>';
?>

lastwars.php

<?php
#   Copyright by Manuel
#   Support www.ilch.de


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

$farbe = '';
$farb2 = '';

echo '<table style="padding-top:10px" width="100%" border="0" cellspacing="1" cellpadding="3">';
$erg = db_query('SELECT DATE_FORMAT(datime,"%d.%M.%Y - %H:%i") as datum,tag, owp, opp, gegner, id, game, wlp FROM prefix_wars WHERE status = "3" ORDER BY datime DESC LIMIT 4');
while ($row = db_fetch_object($erg) ) {
    $row->tag = ( empty($row->tag) ? $row->gegner : $row->tag );

  if ($row->wlp == 1) {
    $bild = 'include/images/icons/win.png';

  } elseif ($row->wlp == 2) {
    $bild = 'include/images/icons/los.png';

  } elseif ($row->wlp == 3) {
    $bild = 'include/images/icons/pad.png';

  }

     
echo'<tr>';
echo'<td><table width="100%" border="0" cellspacing="0" cellpadding="0">';
echo'<tr>';
echo'<td style="padding-right:10px" rowspan="2" align="left" valign="middle">'.get_wargameimg($row->game).'</td>';
echo'<td style="padding-right:10px;font-weight:bold;color:#cd0404;font-size:10px;" rowspan="2" align="left" valign="middle">VS</td>';
echo'<td width="80%"><a class="lasttitle" href="index.php?wars-more-'.$row->id.'">'.$row->tag.'</a></td>';
echo'<td width="20%" rowspan="2" align="left" valign="middle"><table width="42" border="0" cellspacing="0" cellpadding="0">';
echo'<tr>';
echo'<td style="color:#000;font-weight:bold;font-size:9px;" background="'.$bild.'" width="42" height="16" align="center" valign="middle">'.$row->owp.':'.$row->opp.'</td>';
echo'</tr>';
echo'</table></td>';
echo'</tr>';
echo'<tr>';
echo'<td style="font-weight:bold;color:#b4b4b4;font-size:7px;">'.$row->datum.' Uhr</td>';
echo'</tr>';
echo'</table></td>';
echo'</tr>';

}
echo '</table>';
?>

lastforum.php

<?php 
#   Copyright by C.C.A.A
#   Support www.DragonDesigns.de

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


$query = "SELECT a.id, a.name, a.rep, a.erst as autor, b.id as fid, c.erst as last, c.id as pid, c.time , c.erstid as erstid
  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
  LEFT JOIN prefix_forumcats d ON d.id = b.cid AND b.id = a.fid
  LEFT JOIN prefix_groupusers vg ON vg.uid = ".$_SESSION['authid']." AND vg.gid = b.view
  LEFT JOIN prefix_groupusers rg ON rg.uid = ".$_SESSION['authid']." AND rg.gid = b.reply
  LEFT JOIN prefix_groupusers sg ON sg.uid = ".$_SESSION['authid']." AND sg.gid = b.start
WHERE ((".$_SESSION['authright']." <= b.view AND b.view < 1) 
   OR (".$_SESSION['authright']." <= b.reply AND b.reply < 1)
   OR (".$_SESSION['authright']." <= b.start AND b.start < 1)
	 OR vg.fid IS NOT NULL
	 OR rg.fid IS NOT NULL
	 OR sg.fid IS NOT NULL
	 OR -9 >= ".$_SESSION['authright'].")
ORDER BY c.time DESC
LIMIT 0,4";
echo '<table width="100%" style="padding-top:10px;" cellspacing="1" cellpadding="3">';
$resultID = db_query($query);
while ($row = db_fetch_assoc($resultID)) {
	$row['page'] = ceil ( ($row['rep']+1)  / $allgAr['Fpanz'] );
	$row['ORD']  = forum_get_ordner($row['time'],$row['id'],$row['fid']);

echo'<tr>';
echo'<td><table width="100%" border="0" cellspacing="0" cellpadding="0">';
echo'<tr>';
echo'<td rowspan="2" align="center" valign="middle"><img style="padding-right:5px;" src="include/images/forum/'.$row['ORD'].'.png" width="20" height="20" /></td>';
echo'<td width="100%" colspan="2" align="left"><a class="lasttitle" href="?forum-showposts-'.$row['id'].'-p'.$row['page'].'#'.$row['pid'].'" title="'.$row['date'].'">'.((strlen($row['name'])<37) ? $row['name'] : substr($row['name'],0,34).'...').'</a></td>';
echo'</tr>';
echo'<tr>';
echo'<td width="60%" style="font-family: Verdana, Arial, Helvetica, sans-serif;font-weight:bold;color:#cd0404;font-size:7px;" align="left">Autor:&nbsp;<a class="lastautor">'.$row['autor'].'</a></td>';
echo'<td width="40%" style="font-family: Verdana, Arial, Helvetica, sans-serif;font-weight:bold;color:#cd0404;font-size:7px;" align="left">letzter:&nbsp;<a class="lastautor" href="index.php?user-details-'.$row['erstid'].'">'.$row['last'].'</a></td>';
echo'</tr>';
echo'</table></td>';
echo'</tr>';
}
echo '</table>';
?>

Das mit dem bilder bzw icon guck ich mir nachher nochmal an wenn ich zuhause bin

Geschlossen

	Zurück zu Allgemein

Beitrag zur Merkliste hinzufügen

ilch Forum » Ilch Clan 1.1 » Allgemein » Scroll News, Wars, Forum