$tccell2s colspan=5>Birthdays for ".date('F j',ctime()).': '; else $blist.=', '; $users[$user[id]]=$user; $y=date('Y',ctime())-date('Y',$user[birthday]); $namecolor=getnamecolor($user[sex],$user[powerlevel]); $blist.="$user[name] ($y)"; } $onlinetime=ctime()-300; $onusers=mysql_query("SELECT id,name,powerlevel,lastactivity,sex,minipic FROM users WHERE lastactivity>$onlinetime OR lastposttime>$onlinetime ORDER BY name"); $numonline=mysql_num_rows($onusers); $numguests=mysql_result(mysql_query("SELECT count(*) FROM guests WHERE date>$onlinetime"),0,0); if ($numguests) $guestcount=" | $numguests guest".($numguests>1?"s":""); for ($numon=0; $onuser=mysql_fetch_array($onusers);$numon++) { if($numon) { $onlineusers.=', '; } $namecolor=explode("=", getnamecolor($onuser[sex],$onuser[powerlevel])); $namecolor=$namecolor[1]; $namelink="$onuser[name]"; if($onuser['minipic']) { $onuser['minipic']=' '; } if($onuser[lastactivity]<=$onlinetime) { $namelink="($namelink)"; } $onlineusers.="$onuser[minipic]$namelink"; } if($onlineusers) $onlineusers=': '.$onlineusers; if($log){ $headlinks.=' - Mark all forums read'; $header=makeheader($header1,$headlinks,$header2); } if($log) $logmsg="You are logged in as $loguser[name]."; $posts[d]=mysql_result(mysql_query('SELECT COUNT(*) FROM posts WHERE date>'.(ctime()-86400)),0,0); $posts[h]=mysql_result(mysql_query('SELECT COUNT(*) FROM posts WHERE date>'.(ctime()-3600)),0,0); $lastuser=mysql_fetch_array(mysql_query('SELECT id,name,sex,powerlevel FROM users ORDER BY id DESC LIMIT 1')); $misc=mysql_fetch_array(mysql_query('SELECT * FROM misc')); if($posts[d]>$misc[maxpostsday]) mysql_query("UPDATE misc SET maxpostsday=$posts[d],maxpostsdaydate=".ctime()); if($posts[h]>$misc[maxpostshour]) mysql_query("UPDATE misc SET maxpostshour=$posts[h],maxpostshourdate=".ctime()); if($numonline>$misc[maxusers]) mysql_query("UPDATE misc SET maxusers=$numonline,maxusersdate=".ctime().",maxuserstext='".addslashes($onlineusers)."'"); $namecolor=getnamecolor($lastuser[sex],$lastuser[powerlevel]); /*// index sparkline $sprkq = mysql_query('SELECT COUNT(id),date FROM posts WHERE date >="'.(time()-3600).'" GROUP BY (date % 60) ORDER BY date'); $sprk = array(); while ($r = mysql_fetch_row($sprkq)) { array_push($sprk,$r[0]); } // print_r($sprk); $sprk = implode(",",$sprk); */ if ($_GET['oldcounter']) { $statsblip = "$posts[d] posts during the last day, $posts[h] posts during the last hour."; } else { $statsblip = $sql->resultq("SELECT COUNT(*) FROM `threads` WHERE `lastpostdate` > '". (ctime() - 86400) ."'") ." threads and ". $sql->resultq("SELECT COUNT(*) FROM `users` WHERE `lastposttime` > '". (ctime() - 86400) ."'") ." users active during the last day."; } print "$header
$tblstart $tccell1s>

$logmsg

$count[u] registered users Latest registered user: $lastuser[name]

$blist $tccell2s>$count[t] threads and $count[p] posts in the board | $statsblip $tccell1s>$numonline user".($numonline>1?'s':'')." currently online$onlineusers$guestcount "; $new=' '; if($log){ $pmsgnum=0; $pmsgnew=0; $maxid=mysql_result(mysql_query("SELECT max(id) FROM pmsgs WHERE userto=$loguserid"),0,0); $pmsgs=mysql_query("SELECT userfrom,date,u.id,name,sex,powerlevel FROM pmsgs p,pmsgs_text,users AS u WHERE p.id=0$maxid AND u.id=p.userfrom AND p.id=pid") or print mysql_error(); if($pmsg=@mysql_fetch_array($pmsgs)){ $pmsgnum=mysql_result(mysql_query("SELECT COUNT(*) FROM pmsgs WHERE userto=$loguserid"),0,0); $pmsgnew=mysql_result(mysql_query("SELECT COUNT(*) FROM pmsgs WHERE userto=$loguserid AND msgread=0"),0,0); if($pmsgnew) $new=$statusicons['new']; $namecolor=getnamecolor($pmsg[sex],$pmsg[powerlevel]); $lastmsg="Last message from $pmsg[name] on ".date($dateformat,$pmsg[date]+$tzoff); } $privatebox=" $tblstart $tccellhs colspan=2>Private messages $tccell1>$new $tccell2l>Private messages -- You have $pmsgnum private messages ($pmsgnew new). $lastmsg $tblend
"; } $forumlist=" $tccellh>  $tccellh>Forum $tccellh>Threads $tccellh>Posts $tccellh>Last post "; $categories=mysql_query("SELECT id,name FROM categories WHERE (!minpower OR minpower<=$loguser[powerlevel]) ORDER BY id"); $forums=mysql_query("SELECT f.*,u.id AS uid,name,sex,powerlevel FROM forums f LEFT JOIN users u ON f.lastpostuser=u.id WHERE (!minpower OR minpower<=$loguser[powerlevel]) ORDER BY catid,forder"); $mods=mysql_query("SELECT u.id,name,sex,powerlevel,forum FROM users u INNER JOIN forummods m ON u.id=m.user INNER JOIN forums f ON f.id=m.forum WHERE (!minpower OR minpower<=$power) ORDER BY catid,forder,name"); $forum=mysql_fetch_array($forums); $mod=mysql_fetch_array($mods); while($category=mysql_fetch_array($categories)) { $forumlist.="$category[name]"; for (;$forum[catid]==$category[id];$modlist='') { for ($m=0;$mod[forum]==$forum[id];$m++) { $namecolor=getnamecolor($mod[sex],$mod[powerlevel]); $modlist.=($m?', ':'')."$mod[name]"; $mod=mysql_fetch_array($mods); } if($m) $modlist="$smallfont(moderated by: $modlist)"; $namecolor=getnamecolor($forum[sex],$forum[powerlevel]); if($forum[numposts]){ $forumlastpost="". date($dateformat,$forum[lastpostdate]+$tzoff); $by="$smallfont
by $forum[name]". ($forum['lastpostid'] ? " ". $statusicons['getnew'] ."" : "") .""; } else { $forumlastpost='-------- --:-- --'; $by=''; } $new=' '; if ($log && $forum[lastpostdate]>$postread[$forum[id]]) { $newcount = mysql_result(mysql_query("SELECT COUNT(*) FROM `threads` WHERE `id` NOT IN (SELECT `tid` FROM `threadsread` WHERE `uid` = '$loguser[id]' AND `read` = 1) AND `lastpostdate` > '". $postread[$forum[id]] ."' AND `forum` = '$forum[id]'"), 0); } if ((($forum[lastpostdate]>$postread[$forum[id]] and $log) or (!$log and $forum[lastpostdate]>ctime()-3600)) and $forum[numposts]) { $new = $statusicons['new'] ."
". generatenumbergfx($newcount); } if($forum[lastpostdate]>$category[lastpostdate]){ $category[lastpostdate]=$forum[lastpostdate]; $category[l]=$forumlastpost.$by; } if ($forum[id] == 30 && false) { $forum[numthreads] = "∞"; $forum[numposts] = "∞"; $forumlastpost = "Herpin and derpin"; $by = ""; $forumlastuser = ""; } if($cat=='' or $cat==$category[id]) $forumlist.=" $tccell1>$new $tccell2l>$forum[title]
$smallfont$forum[description]
$modlist $tccell1>$forum[numthreads] $tccell1>$forum[numposts] $tccell2>$forumlastpost$by$forumlastuser "; $forum=mysql_fetch_array($forums); } } print "$tblend
$privatebox ". adbox() ."
$tblstart$forumlist$tblend$footer"; printtimedif($startingtime); } ?>