query("SELECT title,template FROM template WHERE title='redirect_login' OR title='error_nopermission' OR title='smiliebit' OR title='smilies' OR title='bbcode' OR title='faq' OR title='welcometext' OR title='logoutcode' OR title='newposts' OR title='todayposts' OR title='logincode' OR title='loggedinuser' OR title='loggedinusers' OR title='forumbit' OR title='categorybit' OR title='forumhome'"); while ($temp=$DB_site->fetch_array($temps)) { $templatecache["$temp[title]"]=$temp[template]; } if (isset($action)==0 or $action=="") { $action="showforums"; } if ($action=="login") { verifyusername($username,$password); if ($url!="" and $url!="index.php") { $username=urlencode($username); if (strpos($url,"?")>0) { $url.="&username=$username&password=".substr(md5($password),0,strlen($password)); } else { $url.="?username=$username&password=".substr(md5($password),0,strlen($password)); } header("Location: $url"); } else { eval("echo standardredirect(\$bbtitle,\"".gettemplate("redirect_login")."\",\"index.php\");"); } exit; } $permissions=getpermissions($bbuserid,$bbusergroupid); if ($permissions[canview]!=1) { eval("echo standarderror(\$bbtitle,\"".gettemplate("error_nopermission")."\");"); exit; } if ($action=="showsmilies") { $smiliebits = ""; $smilies=$DB_site->query("SELECT smilietext,title,smiliepath FROM smilie ORDER BY title"); while ($smilie=$DB_site->fetch_array($smilies)) { $smilietext=$smilie[smilietext]; $smiliepath=$smilie[smiliepath]; $title=$smilie[title]; eval("\$smiliebits .= \"".gettemplate("smiliebit")."\";"); } eval("echo dovars(\"".gettemplate("smilies")."\");"); } if ($action=="bbcode") { eval("echo dovars(\"".gettemplate("bbcode")."\");"); } if ($action=="faq") { eval("echo dovars(\"".gettemplate("faq")."\");"); } if ($action=="showforums") { $numbersmembers=$DB_site->query_first("SELECT COUNT(userid) AS users FROM user"); $numbermembers=$numbersmembers[users]; // get total posts $countposts=$DB_site->query_first("SELECT COUNT(postid) AS posts FROM post"); $totalposts=$countposts[posts]; if ($totalposts=="") { $totalposts=0; } $countthreads=$DB_site->query_first("SELECT COUNT(threadid) AS threads FROM thread"); $totalthreads=$countthreads[threads]; if ($totalthreads=="") { $totalthreads=0; } // get newest member $getnewestusers=$DB_site->query_first("SELECT username,userid FROM user ORDER BY userid DESC LIMIT 1"); $newusername=$getnewestusers[username]; $newuserid=$getnewestusers[userid]; // if user is know, then welcome if ($bbusername!="") { $username=$bbusername; eval("\$welcometext = \"".gettemplate("welcometext")."\";"); eval("\$logincode = \"".gettemplate("logoutcode")."\";"); eval("\$newposts = \"".gettemplate("newposts")."\";"); } else { eval("\$newposts = \"".gettemplate("todayposts")."\";"); eval("\$logincode = \"".gettemplate("logincode")."\";"); } if (isset($categoryid)!=0 and $categoryid!=0) { $categoryid = verifyid("category",$categoryid); $selcategoryid=$categoryid; $categoriesonly=1; } if ($displayloggedin==1) { $datecut=time()-$cookietimeout; $numberguest=0; $numberregistered=0; if ($logged=$DB_site->query("SELECT userid FROM session")) { while($thislogged=$DB_site->fetch_array($logged)) { if ($thislogged[userid]==0) { $numberguest++; } else { $numberregistered++; } } } $totalonline = $numberguest+$numberregistered; $numbervisible=0; $activeusers = ""; $loggedins=$DB_site->query("SELECT DISTINCT user.userid,username,session.location FROM user,session WHERE session.userid=user.userid AND session.userid<>0 AND invisible=0 ORDER BY username"); if ($loggedin=$DB_site->fetch_array($loggedins)) { $numbervisible++; $userid=$loggedin[userid]; $username=$loggedin[username]; $location=$loggedin[location]; eval("\$activeusers .= \"".gettemplate("loggedinuser")."\";"); while ($loggedin=$DB_site->fetch_array($loggedins)) { $numbervisible++; $userid=$loggedin[userid]; $username=$loggedin[username]; $location=$loggedin[location]; eval("\$activeusers .= \", ".gettemplate("loggedinuser")."\";"); } } $numberinvisible=$numberregistered-$numbervisible; eval("\$loggedinusers = \"".gettemplate("loggedinusers")."\";"); } $tempforumbits = ""; $forumbits = ""; $categorys=$DB_site->query("SELECT categoryid,title,displayorder FROM category WHERE displayorder<>0 ORDER BY displayorder"); while ($category=$DB_site->fetch_array($categorys)) { $categoryid=$category[categoryid]; $categorytitle=htmlspecialchars($category[title]); $forumshown=0; $tempforumbits=""; if ($categoriesonly==0 or $categoryid==$selcategoryid) { // make the forum bits $forums=$DB_site->query("SELECT forumid,title,description,displayorder,lastpost,lastposter,replycount,threadcount,allowposting FROM forum WHERE active=1 AND displayorder<>0 AND categoryid=$categoryid ORDER BY displayorder"); while ($forum=$DB_site->fetch_array($forums)) { if ($hideprivateforums==1 ) { $getperms=getpermissions($bbuserid,$bbusergroupid,$forum[forumid]); } else { $getperms[canview]=1; } if ($getperms[canview]==1) { $forumshown=1; // do light bulb if ($lastvisitdate=="Never") { $onoff="on"; } else { if ($bblastvisit<$forum[lastpost]) { $onoff="on"; } else { $onoff="off"; } } // $getperms=getpermissions($bbuserid,$bbusergroupid,$forum[forumid]); if ($forum[allowposting]==0) { // or $getperms[canpostnew]==0) { $onoff.="lock"; } // prepare template vars $forumid=$forum[forumid]; $forumtitle=htmlspecialchars($forum[title]); if ($showforumdescriptions==1) { $forumdescription=$forum[description]; } // post and thread counts $numberposts=$forum[replycount]; $numberthreads=$forum[threadcount]; // dates if ($forum[lastpost]>0) { $lastpostdate=date($dateformat,$forum[lastpost]+(($timeoffset+$bbtimezoneoffset)*3600)); $lastposttime=date($timeformat,$forum[lastpost]+(($timeoffset+$bbtimezoneoffset)*3600)); $lastposter="by $forum[lastposter]"; } else { $lastpostdate="Never"; $lastposttime=""; $lastposter=""; } if (!$modcache) { $forumsmods=$DB_site->query("SELECT user.username,user.usergroupid,forumid FROM forumpermission,user WHERE user.usergroupid=forumpermission.usergroupid AND canadminedit=1"); while($mods=$DB_site->fetch_array($forumsmods)) { $fid = $mods[forumid]; if ($modcache[$fid]) { $modcache[$fid] .= ", ".htmlspecialchars($mods[username]); } else { $modcache[$fid] = htmlspecialchars($mods[username]); } } } $moderators = $modcache[$forumid]; if (!$moderators) { $moderators = " "; } eval("\$tempforumbits .= \"".gettemplate("forumbit")."\";"); } // if can view } // while forums } else { $forumshown=1; } // if show this category if ($usecategories==1 and $forumshown==1) { eval("\$forumbits .= \"".gettemplate("categorybit")."\";"); } $forumbits.=$tempforumbits; } // while categories eval("echo dovars(\"".gettemplate("forumhome")."\");"); } ?>