So das die box funktioniert.
Das ist die box die ich aktuell benutz
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 | <?php # Copyright by C.C.A.A# Support www.DragonDesigns.dedefined ('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.startWHERE ((".$_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 DESCLIMIT 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>';?> |
Und die möchte ich mit drin haben bzw teile davon.
Und zwar das man sieht wenn ein Thema dicht gemacht wurde oder es ein Brisantes thema ist usw..
Also das man die icons ord, nord, cord und hord sieht
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 | <?php # Copyright by Manuel Staechele# Support www.ilch.dedefined ('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 katFROM 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.startWHERE ((".$_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 DESCLIMIT 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>';?> |
