Hi @ll
hab hier ne box von der 1.0.5er hab sie soweit zum laufen gebracht möcht aber gern das das datum mit angezeigt wird z.b. von: User vom: 18.18.1800
kann mir dabei jemand helfen?
hier der code:
<?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,15";
$resultID = db_query($query);
echo '<marquee direction="up" width="160" height="120" scrollAmount="1" scrolldelay="1" onMouseover="this.scrollAmount=0" onMouseout="this.scrollAmount=1" style="border:none;"><p align="center">letzten 15<br>Forum einträge</p><hr>';
while ($row = db_fetch_object($resultID)) {
$query2 = "SELECT id, name, recht FROM `prefix_user` WHERE name = '$row->last'";
$result = db_query($query2);
$row2 = db_fetch_object($result);
echo '<b> » </b><a title="Last Post zum Thema '.$row->name.'" href="?forum-showposts-'.$row->id.'#'.$row->pid.'">'.$row->name.'</a><br> von: <a href="?user-='.$row2->id.'">'.$row->last.'</a><br>';
}
echo '<hr>';
?>
verwendete ilchClan Version: 1.1
betroffene Homepage: nkeclan.de.ki
