das hab ich gesucht
vielen dank das reicht mir denke ich schon.
EDIT: Ok die Warnung ist wohl nicht für umsonst da. was wurde denn inbezug auf diese Box am Forum geändert wenn man den Ilchbb Forenmod verwendet?
Code meiner Last Forumbox:
<?php
# Copyright by Manuel
# Support www.ilch.de
defined ('main') or die ( 'no direct access' );
$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
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,5";
echo '<table>';
$resultID = db_query($query);
while ($row = db_fetch_assoc($resultID)) {
$row['date'] = date('d.m.y - H:i',$row['time']);
$row['page'] = ceil ( ($row['rep']+1) / $allgAr['Fpanz'] );
$row['datum'] = date('d.m.y',$row['time']);
$row['ORD'] = forum_get_ordner($row['time'],$row['id'],$row['fid']);
$bild = '<img src="include/extras/lastforum/'.$row["ORD"].'.png" border="0" height="14" width="14" alt="" />';
echo '<tr><td width="25%">'.$row['datum'].'</td><td width="65%"><a class="forumlink" href="?forum-showposts-'.$row['id'].'-p'.$row['page'].'#'.$row['pid'].'" title="'.$row['date'].'">'.((strlen($row['name'])<18) ? $row['name'] : substr($row['name'],0,20).'...').'</a></td><td width="10%" align="right"><b>'.$bild.''.$row['rep'].'</b></td></tr>';
}
echo '</table><hr>';
?>
so sieht das ganze momentan aus:
rmb-gaming.de/TeamZodiacx/index.php?news
Zuletzt modifiziert von Chester am 12.03.2011 - 17:58:37
Zitat
