Hallo
Habe da mal eine Frage
Wie kann ich im Forum {lastregistuser} mit einbauen?
zb: Wir begrüßen unseren neuesten Benutzer: Test
Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
| Geschlossen | ||

$erg = db_query("SELECT id, name, regist FROM prefix_user ORDER BY regist DESC LIMIT 5");
$lastregistuser = '';
while ( $row = db_fetch_object($erg) )
{
$lastregistuser .= '<a class="box" href="?user-details-'.$row->id.'">'.$row->name.'</a>, ';
}
$lastregistuser = substr($lastregistuser, 0, -2);

<?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 = array();
$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: $color = '#ff0000'; break; //Super Administrator
case -8: $color = '#ff8c00'; break; //Co Administrator
case -7: $color = '#1e90ff'; break; //Super-Moderator
case -6: $color = '#9F00FF'; break; //Css Admin
case -5: $color = '#33E500'; break; //Coder und Designer
case -4: $color = '#ff1493'; break; //Member
case -3: $color = '#a0522d'; break; //Trialmember
case -2: case -1: default: $color = '#ffffff'; break; //User
}
$moda[] = '<a href="index.php?user-details-'.$row->uid.'" style="font-weight: bold; color:'.$color.'">'.$row->name.'</a>';
}
# 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(),
'moda' => implode(', ', $moda),
'userliste_today' => user_online_today_liste(),
);
$tpl->set_ar_out($stats_array,4);function user_online_today_liste(){
$OnListe = '';
$dif = mktime(0,0,0,date('m'),date('d'),date('Y'));
$erg = db_query("SELECT a.id, a.name, a.llogin, b.bez, a.spezrank FROM `prefix_user` a LEFT JOIN prefix_ranks b ON b.id = a.spezrank WHERE a.llogin > '". $dif."' ORDER BY llogin");
while($row = db_fetch_object($erg)) {
if ( $row->spezrank <> 0 ) {
$OnListe .= '<a class="'.$row->bez.'" title="'.$row->bez.'" href="index.php?user-details-'.$row->id.'">'.$row->name.'</a>, ';
} else {
$OnListe .= '<a href="index.php?user-details-'.$row->id.'">'.$row->name.'</a>, ';
}
}
$OnListe = substr($OnListe,0,strlen($OnListe) - 3);
return ($OnListe);
}
$design->footer();
?>

<?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 = array();
$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: $color = '#ff0000'; break; //Super Administrator
case -8: $color = '#ff8c00'; break; //Co Administrator
case -7: $color = '#1e90ff'; break; //Super-Moderator
case -6: $color = '#9F00FF'; break; //Css Admin
case -5: $color = '#33E500'; break; //Coder und Designer
case -4: $color = '#ff1493'; break; //Member
case -3: $color = '#a0522d'; break; //Trialmember
case -2: case -1: default: $color = '#ffffff'; break; //User
}
$moda[] = '<a href="index.php?user-details-'.$row->uid.'" style="font-weight: bold; color:'.$color.'">'.$row->name.'</a>';
}
# lastregistuser #
$erg = db_query("SELECT id, name, regist FROM prefix_user ORDER BY regist DESC LIMIT 5");
$lastregistuser = '';
while ( $row = db_fetch_object($erg) )
{
$lastregistuser .= '<a class="box" href="?user-details-'.$row->id.'">'.$row->name.'</a>, ';
}
$lastregistuser = substr($lastregistuser, 0, -2);
# statistic #
$ges_online_user = ges_online();
$stats_array = array (
'lastregistuser' => $lastregistuser,
'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(),
'moda' => implode(', ', $moda),
'userliste_today' => user_online_today_liste(),
);
$tpl->set_ar_out($stats_array,4);function user_online_today_liste(){
$OnListe = '';
$dif = mktime(0,0,0,date('m'),date('d'),date('Y'));
$erg = db_query("SELECT a.id, a.name, a.llogin, b.bez, a.spezrank FROM `prefix_user` a LEFT JOIN prefix_ranks b ON b.id = a.spezrank WHERE a.llogin > '". $dif."' ORDER BY llogin");
while($row = db_fetch_object($erg)) {
if ( $row->spezrank <> 0 ) {
$OnListe .= '<a class="'.$row->bez.'" title="'.$row->bez.'" href="index.php?user-details-'.$row->id.'">'.$row->name.'</a>, ';
} else {
$OnListe .= '<a href="index.php?user-details-'.$row->id.'">'.$row->name.'</a>, ';
}
}
$OnListe = substr($OnListe,0,strlen($OnListe) - 3);
return ($OnListe);
}
$design->footer();
?>

<?php
# Copyright by: Manuel
# Support: www.ilch.de
/**
* @name IlchBB Forum
* @version 3.1
* @author Florian Koerner
* @link http://www.koerner-ws.de/
* @license GNU General Public License
*/
defined ('main') or die ( 'no direct access' );
// IlchBB Forum 3.1 :: Loader :: Start
require_once ('include/contents/ilchbb_forum/ilchbb_loader.php');
// IlchBB Forum 3.1 :: Loader :: Ende
$title = $allgAr['title'].' :: Forum';
$hmenu = $extented_forum_menu.'Forum'.$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu, 1);
$design->header();
// IlchBB Forum 3.1 :: Extensions :: Start
$ilchbb_tpl = new tpl('ilchbb_forum/load_extensions');
$ilchbb_tpl->out(0);
// IlchBB Forum 3.1 :: Extensions :: End
if ($menu->get(1) == 'markallasread') {
$ilchBB->deleteNewTopics();
}
$tpl = new tpl ( 'ilchbb_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) ) {
// IlchBB Forum 3.1 :: Get Forum Status :: Start
$ord = $ilchBB->checkNewTopics($r['id']);
if ($ord === TRUE) {
$r['ORD'] = 'forum_unread';
$r['TORD'] = 'Neue Beiträge';
} else {
$r['ORD'] = 'forum_read';
$r['TORD'] = 'Keine neuen Beiträge';
}
// IlchBB Forum 3.1 :: Get Forum Status :: Ende
$r['topicl'] = $r['topic'];
$r['topic'] = html_enc_substr($r['topic'],0,23);
$r['mods'] = getmods($r['id']);
$r['datum'] = date('d.m.y - H:i', $r['time']);
$r['page'] = ceil ( ($r['rep']+1) / $allgAr['Fpanz'] );
$r['erst'] = forum_farbname($r['erst']);
$r['name'] = bbcode($r['name']);
$tpl->set_ar($r);
if ($r['cid'] <> $xcid) {
$tpl->out(1);
// IlchBB Forum 3.1 :: Set CSS Class :: Start
$class = 'ilchbb_Cmite';
// IlchBB Forum 3.1 :: Set CSS Class :: End
//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)) {
// IlchBB Forum 3.1 :: Change CSS Class :: Start
$class = ( $class == 'ilchbb_Cmite' ? 'ilchbb_Cnorm' : 'ilchbb_Cmite' );
$ucat['class'] = $class;
// IlchBB Forum 3.1 :: Change CSS Class :: Start
$tpl->set_ar_out($ucat,2);
}
//Unterkategorien - Ende
$xcid = $r['cid'];
}
// IlchBB Forum 3.1 :: Change CSS Class :: Start
$class = ( $class == 'ilchbb_Cmite' ? 'ilchbb_Cnorm' : 'ilchbb_Cmite' );
$r['class'] = $class;
// IlchBB Forum 3.1 :: Change CSS Class :: Start
$tpl->set_ar_out($r,3);
}
// IlchBB Forum 3.1 :: Online Today :: Start
if ($allgAr['ilchbb_forum_dayonline'] == 1) {
$time = mktime (0,0,0,date("n"),date("j"),date("Y"));
$query = 'SELECT `id`,`name` FROM `prefix_user` WHERE llogin > '.$time;
$query = db_query($query);
$cache = '';
while ($row = db_fetch_assoc($query)) {
if (!empty($cache)) $cache .= ', ';
$cache .= '<a href="index.php?user-details-'.$row['id'].'">'.$row['name'].'</a>';
}
$tpl->set('dayonline','<br /><br />Heute waren bereits online:<br />'.$cache);
} else {
$tpl->set('dayonline','');
}
// IlchBB Forum 3.1 :: Online Today :: End
# statistic #
$dif = date('Y-m-d H:i:s', time() - USERUPTIME);
$erg = db_query("SELECT DISTINCT uid, name, prefix_ranks.bez, spezrank FROM `prefix_online` left join prefix_user on prefix_user.id = prefix_online.uid left join prefix_ranks ON prefix_ranks.id = prefix_user.spezrank WHERE uid > 0 and uptime > '" . $dif . "'");
while ($row = db_fetch_object($erg))
{
if ($row->spezrank != 0)
{
$userliste .= '<a title="' . $row->bez . '" href="index.php?user-details-' . $row->uid . '"><b><i>' . forum_farbname($row->name) . '</i></b></a> , ';
} else {
$userliste .= '<a href="index.php?user-details-' . $row->uid . '">' . forum_farbname($row->name) . '</a> , ';
}
}
$userliste = substr($userliste, 0, strlen($userliste) - 3);
$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' => $userliste,
);
$tpl->set_ar_out($stats_array,4);
// IlchBB Forum 3.1 :: Copyright :: Start
$ilchbb_tpl->out(1);
// IlchBB Forum 3.1 :: Copryright :: End
$design->footer();
?>

<?php
# Copyright by: Manuel
# Support: www.ilch.de
/**
* @name IlchBB Forum
* @version 3.1
* @author Florian Koerner
* @link http://www.koerner-ws.de/
* @license GNU General Public License
*/
defined ('main') or die ( 'no direct access' );
// IlchBB Forum 3.1 :: Loader :: Start
require_once ('include/contents/ilchbb_forum/ilchbb_loader.php');
// IlchBB Forum 3.1 :: Loader :: Ende
$title = $allgAr['title'].' :: Forum';
$hmenu = $extented_forum_menu.'Forum'.$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu, 1);
$design->header();
// IlchBB Forum 3.1 :: Extensions :: Start
$ilchbb_tpl = new tpl('ilchbb_forum/load_extensions');
$ilchbb_tpl->out(0);
// IlchBB Forum 3.1 :: Extensions :: End
if ($menu->get(1) == 'markallasread') {
$ilchBB->deleteNewTopics();
}
$tpl = new tpl ( 'ilchbb_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) ) {
// IlchBB Forum 3.1 :: Get Forum Status :: Start
$ord = $ilchBB->checkNewTopics($r['id']);
if ($ord === TRUE) {
$r['ORD'] = 'forum_unread';
$r['TORD'] = 'Neue Beiträge';
} else {
$r['ORD'] = 'forum_read';
$r['TORD'] = 'Keine neuen Beiträge';
}
// IlchBB Forum 3.1 :: Get Forum Status :: Ende
$r['topicl'] = $r['topic'];
$r['topic'] = html_enc_substr($r['topic'],0,23);
$r['mods'] = getmods($r['id']);
$r['datum'] = date('d.m.y - H:i', $r['time']);
$r['page'] = ceil ( ($r['rep']+1) / $allgAr['Fpanz'] );
$r['erst'] = forum_farbname($r['erst']);
$r['name'] = bbcode($r['name']);
$tpl->set_ar($r);
if ($r['cid'] <> $xcid) {
$tpl->out(1);
// IlchBB Forum 3.1 :: Set CSS Class :: Start
$class = 'ilchbb_Cmite';
// IlchBB Forum 3.1 :: Set CSS Class :: End
//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)) {
// IlchBB Forum 3.1 :: Change CSS Class :: Start
$class = ( $class == 'ilchbb_Cmite' ? 'ilchbb_Cnorm' : 'ilchbb_Cmite' );
$ucat['class'] = $class;
// IlchBB Forum 3.1 :: Change CSS Class :: Start
$tpl->set_ar_out($ucat,2);
}
//Unterkategorien - Ende
$xcid = $r['cid'];
}
// IlchBB Forum 3.1 :: Change CSS Class :: Start
$class = ( $class == 'ilchbb_Cmite' ? 'ilchbb_Cnorm' : 'ilchbb_Cmite' );
$r['class'] = $class;
// IlchBB Forum 3.1 :: Change CSS Class :: Start
$tpl->set_ar_out($r,3);
}
// IlchBB Forum 3.1 :: Online Today :: Start
if ($allgAr['ilchbb_forum_dayonline'] == 1) {
$time = mktime (0,0,0,date("n"),date("j"),date("Y"));
$query = 'SELECT `id`,`name` FROM `prefix_user` WHERE llogin > '.$time;
$query = db_query($query);
$cache = '';
while ($row = db_fetch_assoc($query)) {
if (!empty($cache)) $cache .= ', ';
$cache .= '<a href="index.php?user-details-'.$row['id'].'">'.$row['name'].'</a>';
}
$tpl->set('dayonline','<br /><br />Heute waren bereits online:<br />'.$cache);
} else {
$tpl->set('dayonline','');
}
// IlchBB Forum 3.1 :: Online Today :: End
# lastregistuser #
$erg = db_query("SELECT id, name, regist FROM prefix_user ORDER BY regist DESC LIMIT 5");
$lastregistuser = '';
while ( $row = db_fetch_object($erg) )
{
$lastregistuser .= '<a class="box" href="?user-details-'.$row->id.'">'.$row->name.'</a>, ';
}
$lastregistuser = substr($lastregistuser, 0, -2);
# statistic #
$dif = date('Y-m-d H:i:s', time() - USERUPTIME);
$erg = db_query("SELECT DISTINCT uid, name, prefix_ranks.bez, spezrank FROM `prefix_online` left join prefix_user on prefix_user.id = prefix_online.uid left join prefix_ranks ON prefix_ranks.id = prefix_user.spezrank WHERE uid > 0 and uptime > '" . $dif . "'");
while ($row = db_fetch_object($erg))
{
if ($row->spezrank != 0)
{
$userliste .= '<a title="' . $row->bez . '" href="index.php?user-details-' . $row->uid . '"><b><i>' . forum_farbname($row->name) . '</i></b></a> , ';
} else {
$userliste .= '<a href="index.php?user-details-' . $row->uid . '">' . forum_farbname($row->name) . '</a> , ';
}
}
$userliste = substr($userliste, 0, strlen($userliste) - 3);
$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' => $userliste,
);
$tpl->set_ar_out($stats_array,4);
// IlchBB Forum 3.1 :: Copyright :: Start
$ilchbb_tpl->out(1);
// IlchBB Forum 3.1 :: Copryright :: End
$design->footer();
?>
<?php
# Copyright by: Manuel
# Support: www.ilch.de
/**
* @name IlchBB Forum
* @version 3.1
* @author Florian Koerner
* @link http://www.koerner-ws.de/
* @license GNU General Public License
*/
defined ('main') or die ( 'no direct access' );
// IlchBB Forum 3.1 :: Loader :: Start
require_once ('include/contents/ilchbb_forum/ilchbb_loader.php');
// IlchBB Forum 3.1 :: Loader :: Ende
$title = $allgAr['title'].' :: Forum';
$hmenu = $extented_forum_menu.'Forum'.$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu, 1);
$design->header();
// IlchBB Forum 3.1 :: Extensions :: Start
$ilchbb_tpl = new tpl('ilchbb_forum/load_extensions');
$ilchbb_tpl->out(0);
// IlchBB Forum 3.1 :: Extensions :: End
if ($menu->get(1) == 'markallasread') {
$ilchBB->deleteNewTopics();
}
$tpl = new tpl ( 'ilchbb_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) ) {
// IlchBB Forum 3.1 :: Get Forum Status :: Start
$ord = $ilchBB->checkNewTopics($r['id']);
if ($ord === TRUE) {
$r['ORD'] = 'forum_unread';
$r['TORD'] = 'Neue Beiträge';
} else {
$r['ORD'] = 'forum_read';
$r['TORD'] = 'Keine neuen Beiträge';
}
// IlchBB Forum 3.1 :: Get Forum Status :: Ende
$r['topicl'] = $r['topic'];
$r['topic'] = html_enc_substr($r['topic'],0,23);
$r['mods'] = getmods($r['id']);
$r['datum'] = date('d.m.y - H:i', $r['time']);
$r['page'] = ceil ( ($r['rep']+1) / $allgAr['Fpanz'] );
$r['erst'] = forum_farbname($r['erst']);
$r['name'] = bbcode($r['name']);
$tpl->set_ar($r);
if ($r['cid'] <> $xcid) {
$tpl->out(1);
// IlchBB Forum 3.1 :: Set CSS Class :: Start
$class = 'ilchbb_Cmite';
// IlchBB Forum 3.1 :: Set CSS Class :: End
//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)) {
// IlchBB Forum 3.1 :: Change CSS Class :: Start
$class = ( $class == 'ilchbb_Cmite' ? 'ilchbb_Cnorm' : 'ilchbb_Cmite' );
$ucat['class'] = $class;
// IlchBB Forum 3.1 :: Change CSS Class :: Start
$tpl->set_ar_out($ucat,2);
}
//Unterkategorien - Ende
$xcid = $r['cid'];
}
// IlchBB Forum 3.1 :: Change CSS Class :: Start
$class = ( $class == 'ilchbb_Cmite' ? 'ilchbb_Cnorm' : 'ilchbb_Cmite' );
$r['class'] = $class;
// IlchBB Forum 3.1 :: Change CSS Class :: Start
$tpl->set_ar_out($r,3);
}
// IlchBB Forum 3.1 :: Online Today :: Start
if ($allgAr['ilchbb_forum_dayonline'] == 1) {
$time = mktime (0,0,0,date("n"),date("j"),date("Y"));
$query = 'SELECT `id`,`name` FROM `prefix_user` WHERE llogin > '.$time;
$query = db_query($query);
$cache = '';
while ($row = db_fetch_assoc($query)) {
if (!empty($cache)) $cache .= ', ';
$cache .= '<a href="index.php?user-details-'.$row['id'].'">'.$row['name'].'</a>';
}
$tpl->set('dayonline','<br /><br />Heute waren bereits online:<br />'.$cache);
} else {
$tpl->set('dayonline','');
}
// IlchBB Forum 3.1 :: Online Today :: End
# statistic #
$dif = date('Y-m-d H:i:s', time() - USERUPTIME);
$erg = db_query("SELECT DISTINCT uid, name, prefix_ranks.bez, spezrank FROM `prefix_online` left join prefix_user on prefix_user.id = prefix_online.uid left join prefix_ranks ON prefix_ranks.id = prefix_user.spezrank WHERE uid > 0 and uptime > '" . $dif . "'");
while ($row = db_fetch_object($erg))
{
if ($row->spezrank != 0)
{
$userliste .= '<a title="' . $row->bez . '" href="index.php?user-details-' . $row->uid . '"><b><i>' . forum_farbname($row->name) . '</i></b></a> , ';
} else {
$userliste .= '<a href="index.php?user-details-' . $row->uid . '">' . forum_farbname($row->name) . '</a> , ';
}
}
$lgu = db_result(db_query("SELECT name FROM prefix_user ORDER BY id DESC LIMIT 1"), 0);
$userliste = substr($userliste, 0, strlen($userliste) - 3);
$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' => $userliste,
'lgu' => $lgu
);
$tpl->set_ar_out($stats_array,4);
// IlchBB Forum 3.1 :: Copyright :: Start
$ilchbb_tpl->out(1);
// IlchBB Forum 3.1 :: Copryright :: End
$design->footer();
?>

| Geschlossen | ||
![]() |
Zurück zu Module und Modifikationen | |