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:
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 | <?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