Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
| Geschlossen | ||
Sa. 25.02.2006
09:39 Uhr
#2
Sa. 25.02.2006
09:51 Uhr
#4
Sa. 25.02.2006
21:54 Uhr
#6
Sa. 25.02.2006
23:42 Uhr
#7
Sa. 25.02.2006
23:50 Uhr
#8
So. 26.02.2006
11:51 Uhr
#9
<?php
# Copyright by Manuel
# Support www.ilch.de
# Überarbeitet von Stefan Jungbauer
# Coder from www.zocker-eppingen.de
defined ('main') or die ( 'no direct access' );
$query = <<< query
SELECT a.id, a.name, c.time, c.erst as last, c.id as pid
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 gv ON b.view = gv.gid AND gv.uid = {$_SESSION['authid']}
LEFT JOIN prefix_groupusers gm ON b.mods = gm.gid AND gm.uid = {$_SESSION['authid']}
LEFT JOIN prefix_groupusers gs ON b.start = gs.gid AND gs.uid = {$_SESSION['authid']}
LEFT JOIN prefix_groupusers gr ON b.reply = gr.gid AND gr.uid = {$_SESSION['authid']}
WHERE
( b.view = 0 OR b.reply = 0 OR b.start = 0 OR b.mods = 0 )
OR
( {$_SESSION['authright']} = -5 )
OR
( b.view >= {$_SESSION['authright']} OR b.mods >= {$_SESSION['authright']} OR b.start >= {$_SESSION['authright']} OR b.reply >= {$_SESSION['authright']} )
OR
( gv.uid IS NOT NULL OR gm.uid IS NOT NULL OR gs.uid IS NOT NULL OR gr.uid IS NOT NULL )
ORDER BY c.time DESC
LIMIT 0,5
query;
$resultID = db_query($query);
while ($row = db_fetch_object($resultID)) {
$time = date('d.m.y - H:i',$row->time);
echo '<b> » </b><a href="?m=forum&um=showposts&tid='.$row->id.'#'.$row->pid.'">'.$row->name.' von '.$row->last.', '.$time.'</a><br />';
}
?>
| Geschlossen | ||
 |
Zurück zu Allgemein | |