<?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%" cellspacing="1" cellpadding="5">';
$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/extras/lastforum/'.$row['ORD'].'.png" width="18" height="18" /></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'])<40) ? $row['name'] : substr($row['name'],0,37).'...').'</a></td>';
echo'</tr>';
echo'<tr>';
echo'<td width="60%" style="font-family: Verdana, Arial, Helvetica, sans-serif;font-weight:bold;color:#ff3c00;font-size:7px;" align="left">Autor: <a class="lastautor">'.$row['autor'].'</a></td>';
echo'<td width="40%" style="font-family: Verdana, Arial, Helvetica, sans-serif;font-weight:bold;color:#ff3c00;font-size:7px;" 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>';
?>
@ Outi77,
der Aufwand wäre mir im Moment zu groß, da man ja alles anpassen müsste, z.B. Gbook, Downloads, etc...
Da fehlt mir im Moment leider die Zeit zu.
LG, Galle
Zuletzt modifiziert von Galle81 am 05.05.2017 - 17:19:27
Mo. 01.05.2017
17:30 Uhr
#1
umsetzen. Dazu wird allerdings ein ftp Zugang benötigt.
