Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
| Geschlossen | ||
Bis auf den wahrscheinlich vn mir verursachten Fehler - Echt toll, da steckt Mühe dahinter!
Mi. 14.05.2008
11:02 Uhr
#2
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 | <?php # Copyright by Manuel# Support www.ilch.dedefined ('main') or die ( 'no direct access' );$query = "SELECT a.id, a.name, a.rep, c.erst as last, c.id as pid, c.timeFROM 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.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 border="0" cellpadding="2" cellspacing="2">';$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'] ); echo ' <tr><td valign="top"><b> » </b></td><td valign="bottom" width="105"><a href="?forum-showposts-'.$row['id'].'-p'.$row['page'].'#'.$row['pid'].'" title="'.$row['date'].'">'.((strlen($row['name'])<18) ? $row['name'] : substr($row['name'],0,22).'...').'</td><td width="30" style="font-size: 10px" align="center">von </td><td valign="bottom" style="font-size: 10px; padding-left: 10px;"><span>'.$row['last'].'</span></a></td></tr>';}echo '</table>';?> |
Mi. 14.05.2008
13:30 Uhr
#4
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 | <?php # Copyright by Manuel# Support www.ilch.dedefined ('main') or die ( 'no direct access' );$query = "SELECT a.id, a.name, a.rep, c.erst as last, c.id as pid, c.timeFROM 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.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>';$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'] ); echo '<tr><td valign="top"><b> » </b></td><td><a href="?forum-showposts-'.$row['id'].'-p'.$row['page'].'#'.$row['pid'].'" title="'.$row['date'].'">'.((strlen($row['name'])<18) ? $row['name'] : substr($row['name'],0,15).'...').'<br /><span class="smalfont"> von '.$row['last'].'</span></a></td></tr>';}echo '</table>';?> |
Mi. 14.05.2008
16:10 Uhr
#6
| Geschlossen | ||
 |
Zurück zu Design und Templates | |
