So das die box funktioniert.
Das ist die box die ich aktuell benutze
<?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,5";
echo '<table width="100%" style="padding-top:0px; padding-bottom:2px;" 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="1" cellpadding="6">';
echo'<tr>';
echo'<td rowspan="2" align="center" valign="middle"><img style="padding-right:5px;" src="include/images/forum/'.$row['ORD'].'.png" width="22" height="22" /></td>';
echo'<td width="100%" colspan="2" align="left"><b><a style="color:#888;" 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></b></td>';
echo'</tr>';
echo'<tr>';
echo'<td width="55%" style="font-family: Verdana, Arial, Helvetica, sans-serif;color:#888;font-size:9px;" align="left">Autor: <a class="lastautor">'.$row['autor'].'</a></td>';
echo'<td width="50%" style="font-family: Verdana, Arial, Helvetica, sans-serif;color:#888;font-size:9px;" align="left">letzter: <a class="lastautor" href="index.php?user-details-'.$row['erstid'].'">'.$row['last'].'</a></td>';
echo'</tr>';
echo'</table></td>';
echo'</tr>';
}
echo '</table>';
?>
Hier funktionieren folgendes Foren Icons
Aber ich würd auch gerne diese icons noch mit drine haben so das sie auch angezeigt werden
wie zb:
Also das man die icons sieht:
ord:
nord:
cord:
hord:
Leider weiß ich nicht wie das geht..
Es gibs zwar diese lastforum box
<?php
# Copyright by Manuel Staechele
# Support www.ilch.de
defined ('main') or die ( 'no direct access' );
$query = "SELECT a.id, a.name, a.rep,b.name as top, b.id as fid, c.erst as last, c.erstid, c.id as pid, c.time, d.name as kat
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,5";
echo '<link rel="stylesheet" type="text/css" href="include/extras/lastforum/lastforum.css">';
echo '<div>';
$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['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="Bild" />';
echo '<div class="topic_eintrag"><a href="?forum-showposts-'.$row['id'].'-p'.$row['page'].'#'.$row['pid'].'" title="'.$row['date'].' von '.$row['last'].'">'.$bild.'<span>'.((strlen($row['name'])<18) ? $row['name'] : substr($row['name'],0,40).'...').'</span></a></div>';
}
echo '</div>';
?>
Aber leider wird hier nicht der Author und der letzte der da rein geschrieben hat angezeigt..
Deswegen würd ich gern so haben das bei der oberen box die icons angezeigt werden ich ich aufgezählt habe..
Hoffe ihr versteht was ich meine und koennt mir helfen <3
betroffene Homepage: externer Link
