hi StyLe,
Bitte schön.
<?php
# Copyright by: Manuel
# Support: www.ilch.de
defined ('main') or die ( 'no direct access' );
$title = $allgAr['title'].' :: Forum';
$hmenu = $extented_forum_menu.'Forum'.$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu, 1);
$design->header();
if ($menu->get(1) == 'markallasread') {
user_markallasread ();
}
$tpl = new tpl ( 'forum/showforum' );
$tpl->out (0);
$category_array = array();
$forum_array = array();
$q = "SELECT
a.id, a.cid, a.name, a.besch,
a.topics, a.posts, b.name as topic,
c.id as pid, c.tid, b.rep, c.erst, c.time,
a.cid, k.name as cname
FROM prefix_forums a
LEFT JOIN prefix_forumcats k ON k.id = a.cid
LEFT JOIN prefix_posts c ON a.last_post_id = c.id
LEFT JOIN prefix_topics b ON c.tid = b.id
LEFT JOIN prefix_groupusers vg ON vg.uid = ".$_SESSION['authid']." AND vg.gid = a.view
LEFT JOIN prefix_groupusers rg ON rg.uid = ".$_SESSION['authid']." AND rg.gid = a.reply
LEFT JOIN prefix_groupusers sg ON sg.uid = ".$_SESSION['authid']." AND sg.gid = a.start
WHERE ((".$_SESSION['authright']." <= a.view AND a.view < 1)
OR (".$_SESSION['authright']." <= a.reply AND a.reply < 1)
OR (".$_SESSION['authright']." <= a.start AND a.start < 1)
OR vg.fid IS NOT NULL
OR rg.fid IS NOT NULL
OR sg.fid IS NOT NULL
OR -9 = ".$_SESSION['authright'].")
AND k.cid = 0
ORDER BY k.pos, a.pos";
$erg1 = db_query($q);
$xcid = 0;
while ($r = db_fetch_assoc($erg1) ) {
$r['topicl'] = $r['topic'];
$r['topic'] = html_enc_substr($r['topic'],0,23);
$r['ORD'] = forum_get_ordner($r['time'],$r['id']);
$r['mods'] = getmods($r['id']);
$r['datum'] = date('d.m.y - H:i', $r['time']);
$r['page'] = ceil ( ($r['rep']+1) / $allgAr['Fpanz'] );
$tpl->set_ar ($r);
if ($r['cid'] <> $xcid) {
$tpl->out(1);
//Unterkategorien
$sql = db_query("SELECT DISTINCT a.name as cname, a.id as cid FROM `prefix_forumcats` a LEFT JOIN `prefix_forums` b ON a.id = b.cid WHERE a.cid = {$r['cid']} AND a.id = b.cid ORDER BY a.pos, a.name");
while ($ucat = db_fetch_assoc($sql)) {
$tpl->set_ar_out($ucat,2);
}
//Unterkategorien - Ende
$xcid = $r['cid'];
}
$tpl->set_ar_out($r,3);
}
##### Moderartoren
$moda = '';
$erg= db_query("SELECT b.id as uid, b.name, b.recht,c.id FROM prefix_forummods a LEFT JOIN prefix_user b ON b.id = a.uid LEFT JOIN prefix_grundrechte c ON c.id = b.recht GROUP BY b.name ORDER BY b.id");
while ($row = db_fetch_object($erg)) {
$recht_name=@db_result(db_query('SELECT name FROM prefix_grundrechte WHERE id='.$row->recht),0);
switch($row->recht) {
case -9: case -8: case -7://Admins + CoAdmin + SideAdmin
$moda .= '<a href="index.php?user-details-'.$row->uid.'"><span style="color:#0000FF"><i><b><u>'.$row->name.'</u></b></i></span></a> , ';
break;
case -6: case -5://Leader + CoLeader
$moda .= '<a href="index.php?user-details-'.$row->uid.'"><span style="color:#daa520"><i><u>'.$row->name.'</u></i></span></a> , ';
break;
case -4: case -3://Member + Trialmember
$moda .= '<a href="index.php?user-details-'.$row->uid.'"><span style="color:#008000"><i><u>'.$row->name.'</u></i></span></a> , ';
break;
case -2: case -1://Superuser + User
$moda .= '<a href="index.php?user-details-'.$row->uid.'"><span style="color:#000000"><u>'.$row->name.'</u></span></a> , ';
break;
default: break;
}
}
# statistic #
$ges_online_user = ges_online();
$stats_array = array (
'privmsgpopup' => check_for_pm_popup (),
'topics' => db_result(db_query("SELECT COUNT(ID) FROM `prefix_topics`"),0),
'posts' => db_result(db_query("SELECT COUNT(ID) FROM `prefix_posts`"),0),
'users' => db_result(db_query("SELECT COUNT(ID) FROM `prefix_user`"),0),
'istsind' => ( $ges_online_user > 1 ? 'sind' : 'ist' ),
'gesonline' => $ges_online_user,
'gastonline' => ges_gast_online(),
'useronline' => ges_user_online(),
'userliste' => user_online_liste()
);
$tpl->set_ar_out($stats_array,4);
$design->footer();
?>
<table width="100%" cellpadding="0" cellspacing="0" class="border" border="0">
<tr class="Chead" >
<td >
<table width="100%" cellpadding="4" cellspacing="0" border="0">
<th width="58%" colspan="2" align="center" style="font-size:x-small;">{_lang_board}</th>
<th width="6%" align="center" valign="middle"style="font-size:x-small;">{_lang_post}</th>
<th width="6%" align="center" valign="middle"style="font-size:x-small;">{_lang_topic}</th>
<th width="25%" align="center"style="font-size:x-small;">{_lang_lastpost}</th>
</table></td></tr>
{EXPLODE}
<tr class="Cdark">
<td colspan="5" height="20"><strong><a href="index.php?forum-showcat-{cid}" style="color:#000000"> {cname}</a></strong></td>
</tr>
</table>
<table width="100%" cellpadding="4" cellspacing="1" class="border" border="0">{EXPLODE}<tr class="Cmite">
<td colspan="5"><strong> » <a href="index.php?forum-showcat-{cid}" style="color:#FFFFFF">{cname}</a></strong></td>
</tr>{EXPLODE}<tr class="Cnorm" cellspacing="1">
<td width="5%" align="center" valign="middle" class="Cdark"><img alt="" src="include/images/forum/{ORD}.png" border="0"></td>
<td width="53%" class="Cnorm">
<a href="index.php?forum-showtopics-{id}">{name}</a>
<br />
<span class="smalfont">{besch}
{mods}
</span>
</td>
<td align="center" class="Cdark" width="6%"><span class="smalfont">{posts}</span></td>
<td align="center" class="Cdark" width="6%"><span class="smalfont">{topics}</span></td>
<td class="Cdark" width="25%">
<span class="smalfont">
<a class="smalfont" title="{topicl}" href="index.php?forum-showposts-{tid}-p{page}#{pid}" style="color:#FFFFFF">{topic} <img src="include/images/forum/post.png" border="0"></a>
<br />
{_lang_from}: {erst}
</span>
</td>
</tr>{EXPLODE}
</table>
<table cellpadding="0" cellspacing="0" border="0" width="100%"><tr>
<td width="50%" valign="top">
<a href="index.php?forum-markallasread">{_lang_markallasread}</a>
</td><td width="50%" style="text-align: right" valign="top">
<a href="index.php?search-augt">{_lang_newtopicssincelastvisit}</a>
<br /><a href="index.php?search-aubt">{_lang_topicwithnoreply}</a>
<br /><a href="index.php?search-aeit">{_lang_ownposts}</a>
</td></tr></table>
<br />
<table width="100%" border="0" cellpadding="5" cellspacing="1" class="border">
<tr>
<td class="Chead" colspan="2"><div style="float:left"><b>Verantwortliche Moderators:</b></div><div style="float:right"><i><b>Legend:</b></i> [ <span style="color:#0000FF">Admin´s</span> ] , [ <span style="color:#daa520">Leader</span> ] , [ <span style="color:#008000">Member</span> ] , [ <span style="color:#000000">User</span> ]</div></td>
</tr><tr>
<td class="erstezeile">{moda}</td>
</tr><tr>
</table>
<br />
<table width="100%" border="0" cellpadding="5" cellspacing="1" class="border">
<tr class="Cmite">
<td class="Cdark">{_lang_it} {istsind} {gesonline} {_lang_guestsonline,ofthem} {useronline} {_if_{useronline}=='1'}{_lang_registredand}{/_endif}{_if_{useronline}!='1'}{_lang_registrededand}{/_endif} {gastonline} {_lang_guests}<br />
{userliste} </td>
</tr>
<tr class="Cmite">
<td><p><b>{users}</b> {_lang_membershaveritten}
<b>{posts}</b> {_lang_postsin}
<b>{topics}</b> {_lang_topics}</p>
</td>
</tr>
<tr class="Cnorm">
<td class="Cdark"><img src="include/images/forum/ntop.png" alt="neue Beiträge" border="0" align="middle" /> {_lang_newposts}
<img src="include/images/forum/top.png" alt="keine neuen Beiträge" border="0" align="middle" /> {_lang_nonewposts}
<img src="include/images/forum/ctop.png" alt="Thema geschlossen" border="0" align="middle" /> {_lang_topicclosed} <img src="include/images/forum/htop.png" alt="brisantes Thema" border="0" align="middle" /> brisantes Thema</td>
</tr>
{privmsgpopup}
</table>
<br />
Mfg littlecrow