weist du was genau geändert werden muss ?
weil habs versucht, irgendwann hat er dann nur das 2te forum angezeigt^^
(hoffe mal das es der teil ist oder ?)
$q = "
SELECT DISTINCT
a.fid as fid,
a.name as titel,
'foru' as typ,
a.id as id,
`time`,
c.erst as autor
FROM prefix_posts c
LEFT JOIN prefix_topics a ON a.id = c.tid
LEFT JOIN prefix_forums b ON 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 (((b.view >= ".$_SESSION['authright']." AND b.view <= 0) OR
(b.reply >= ".$_SESSION['authright']." AND b.reply <= 0) OR
(b.start >= ".$_SESSION['authright']." AND b.start <= 0)) OR
(vg.fid IS NOT NULL OR rg.fid IS NOT NULL OR sg.fid IS NOT NULL OR ".$_SESSION['authright']." = -9))
AND (".$str_forum." 1 = 1)
AND (".$str_forum_a." 1 = 1)
AND (time >= ". $x .")
GROUP BY a.id
ORDER BY time DESC";
MfG