query($sql);
$onlineusers="";
$offlineusers="";
while ($buddy=$DB_site->fetch_array($buddys)) {
if ($doneuser[$buddy[userid]]) {
continue;
}
$doneuser[$buddy[userid]]=1;
if ((!$buddy[invisible] or $bbuserinfo['usergroupid']==6) and $buddy[lastactivity]>$datecut) {
$onoff="on";
} else {
$onoff="off";
}
eval("\$var = \"".gettemplate("usercp_buddy")."\";");
if ($onoff=="on") {
$onlineusers.=$var;
} else {
$offlineusers.=$var;
}
}
// ############################### start private messages ###############################
function makefolderjump() {
global $bbuserinfo;
//get all folder names (for dropdown)
//reference with $foldernames[#] .
if ($bbuserinfo[pmfolders]) {
$allfolders = split("\n", trim($bbuserinfo[pmfolders]));
while (list($key,$val)=each($allfolders)) {
$thisfolder = split("\|\|\|", $val);
$folderjump .= "";
}
}
return $folderjump;
} #end makefolderjump
//get ignorelist info
//generates a hash, in the form of $ignore[(userid)]
//run checks to it by seeing if $ignore[###] returns anything
//if so, then user is ignored
$folderjump = makefolderjump();
$foldername = $inboxname;
$sender = "Sender";
if ($bbuserinfo[pmfolders]) {
$allfolders = split("\n", trim($bbuserinfo[pmfolders]));
while (list($key,$val)=each($allfolders)) {
$thisfolder = split("\|\|\|", $val);
$foldernames[$thisfolder[0]] = $thisfolder[1];
}
}
if (trim($bbuserinfo[ignorelist])!="") {
$ignoreusers="AND privatemessage.fromuserid<>".implode(" AND privatemessage.fromuserid<>",explode(" ",$bbuserinfo[ignorelist]));
} else {
$ignoreusers="";
}
$messagedone=0;
//different retrival methods based on which table
$messages = $DB_site->query("SELECT privatemessage.*,touser.username AS tousername,fromuser.username AS fromusername,icon.title AS icontitle,icon.iconpath FROM privatemessage,user AS touser,user AS fromuser LEFT JOIN icon ON icon.iconid=privatemessage.iconid WHERE privatemessage.userid='$bbuserinfo[userid]' AND folderid=0 AND touser.userid=privatemessage.touserid AND fromuser.userid=privatemessage.fromuserid AND messageread=0 $ignoreusers ORDER BY dateline DESC");
while ($privatemessage=$DB_site->fetch_array($messages)) {
// get the more useful of the to/from field
$privatemessage[displayuserid]=$privatemessage[fromuserid];
$privatemessage[displayusername]=$privatemessage[fromusername];
$privatemessage[datesent]=vbdate($dateformat,$privatemessage[dateline]);
$privatemessage[timesent]=vbdate($timeformat,$privatemessage[dateline]);
//date/time comparisons for new vs. old messages
//additionally, mark folder if replied to
$privatemessage[folder] = "{imagesfolder}/newpm.gif";
//get icon for this message
if ($privatemessage[iconid]) {
$privatemessage[icon]="";
} else {
$privatemessage[icon]=" ";
}
//run it through the template
if ($privatemessage[deleteprompt]) {
eval("\$privmsgsbit .= \"".gettemplate("usercp_pmdeletedbit")."\";");
} else {
if ($permissions[cantrackpm] && $permissions[candenypmreceipts] && $privatemessage[receipt]==1) {
eval("\$privatemessage[denyreceipt] = \"".gettemplate("privfolder_denyreceipt")."\";");
}
eval("\$privmsgsbit .= \"".gettemplate("usercp_pmmessagebit")."\";");
}
$messagedone=1;
} //end while
if ($messagedone) {
eval("\$privatemessages .= \"".gettemplate("usercp_messages")."\";");
} else {
eval("\$privatemessages .= \"".gettemplate("usercp_nomessages")."\";");
}
// ############################### start subscribed forums ###############################
$forums=$DB_site->query("SELECT * FROM forum,subscribeforum WHERE subscribeforum.forumid=forum.forumid AND userid=$bbuserinfo[userid] ORDER BY title");
$totalforums=$DB_site->num_rows($forums);
if ($totalforums>0) {
while ($forum=$DB_site->fetch_array($forums)) {
$forumperms=getpermissions($forum[forumid]);
if (!$hideprivateforums) {
$forumperms[canview]=1;
}
if ($forumperms[canview]) {
$forumshown=1;
// do light bulb
if ($bbuserinfo[lastvisitdate]=="Never") {
$forum[onoff]="on";
} else {
if (isset($bbforumview[$forum['forumid']]) and $bbforumview[$forum['forumid']]>$bbuserinfo['lastvisit']) {
$userlastvisit=$bbforumview[$forum['forumid']];
} else {
$userlastvisit=$bbuserinfo['lastvisit'];
}
if ($userlastvisit<$forum['lastpost']) {
$forum[onoff]="on";
} else {
$forum[onoff]="off";
}
}
if ((!$forumperms['canpostnew'] and $showlocks) or $forum['allowposting']==0) {
$forum[onoff].="lock";
}
// prepare template vars
if (!$showforumdescription) {
$forum[description]="";
}
// dates
if ($forum[lastpost]>0) {
$forum[lastpostdate]=vbdate($dateformat,$forum[lastpost]);
$forum[lastposttime]=vbdate($timeformat,$forum[lastpost]);
eval("\$forum[lastpostinfo] = \"".gettemplate("forumhome_lastpostby")."\";");
} else {
$forum[lastpostinfo]="Never";
}
eval("\$forumbits .= \"".gettemplate("usercp_forumbit")."\";");
} // if can view
} // while forums
eval("\$forumlist = \"".gettemplate("usercp_forums")."\";");
} else {
eval("\$forumlist = \"".gettemplate("usercp_noforums")."\";");
}
// ############################### start new subscribed to threads ###############################
if (!$bbuserinfo[lastvisit]) {
$thelastvisit = time();
} else {
$thelastvisit = $bbuserinfo[lastvisit];
}
$daysprune=intval((time()-$thelastvisit)/86400);
$dotuserid = "";
$dotjoin = "";
if ($showdots and $bbuserinfo[userid] >= 1) {
$dotuserid = "DISTINCT post.userid,";
$dotjoin = "LEFT JOIN post ON (thread.threadid = post.threadid AND post.userid = '$bbuserinfo[userid]')";
}
$getthreadids=$DB_site->query("
SELECT thread.threadid
FROM thread,subscribethread
WHERE subscribethread.threadid=thread.threadid
AND subscribethread.userid='$bbuserinfo[userid]'
AND thread.visible=1
AND lastpost>$bbuserinfo[lastvisit]
");
$totalthreads=$DB_site->num_rows($getthreadids);
$threadids="thread.threadid IN (0";
while ($thread=$DB_site->fetch_array($getthreadids)) {
$threadids.=",".$thread[threadid];
}
$threadids.=")";
$threads=$DB_site->query("SELECT $dotuserid icon.title as icontitle,icon.iconpath,thread.threadid,thread.title,
lastpost,forumid,pollid,open,replycount,postusername,postuserid,lastposter,thread.dateline,views,
thread.iconid,notes,thread.visible
FROM thread
LEFT JOIN icon ON (icon.iconid = thread.iconid)
$dotjoin
WHERE $threadids
ORDER BY lastpost DESC
");
if ($totalthreads>0) {
// check to see if there are any threads to display. If there are, do so, otherwise, show message
if (($bbuserinfo[maxposts] != -1) and ($bbuserinfo[maxposts] != 0))
{ $maxposts = $bbuserinfo[maxposts]; }
while ($thread=$DB_site->fetch_array($threads)) {
if (($thread[replycount]+1)>$maxposts and $linktopages) {
$totalpages=($thread[replycount]+1)/$maxposts;
if ($totalpages!=intval($totalpages)) {
$totalpages=intval($totalpages)+1;
}
$acurpage=0;
$pagenumbers="";
while ($acurpage++<$totalpages) {
if ($acurpage==$maxmultipage) {
eval("\$pagenumbers .= \"".gettemplate("forumdisplay_multipagenav_more")."\";");
break;
} else {
eval("\$pagenumbers .= \"".gettemplate("forumdisplay_multipagenav_pagenumber")."\";");
}
}
eval("\$thread[pagenav] = \"".gettemplate("forumdisplay_multipagenav")."\";");
} else {
$thread[pagenav]="";
}
$threadicon=" ";
if ($thread[iconid]!=0)
{
$thread[icon]="";
}
if ($thread[pollid]!=0) {
$thread[icon]="";
}
if ($wordwrap!=0) {
$thread[title]=dowordwrap($thread[title]);
}
$replies=$thread[replycount];
$views=$thread[views];
$thread[lastreplydate]=vbdate($dateformat,$thread[lastpost]);
$thread[lastreplytime]=vbdate($timeformat,$thread[lastpost]);
$thread[gotonew]="";
$thread[newoldhot]="folder";
if (!$thread[open]) {
$thread[newoldhot]="lock".$thread[newoldhot];
}
if ($thread[replycount]>=$hotnumberposts or $thread[views]>=$hotnumberviews and $usehotthreads) {
$thread[newoldhot]="hot".$thread[newoldhot];
}
if ($bbuserinfo[lastvisitdate]=="Never") {
$thread[newoldhot]="new".$thread[newoldhot];
} elseif ($thread[lastpost]>$bbuserinfo[lastvisit]) {
if (!isset($bbthreadview) or $bbthreadview[$thread[threadid]]<$thread[lastpost]) {
$thread[newoldhot]="new".$thread[newoldhot];
}
eval("\$thread[gotonew] = \"".gettemplate("forumdisplay_gotonew")."\";");
}
if ($showdots and $bbuserinfo[userid] >= 1 and $bbuserinfo[userid] == $thread[userid]) {
$thread[newoldhot] = "dot_" . $thread[newoldhot];
}
eval("\$threadbits .= \"".gettemplate("subscribe_threadbit")."\";");
}
eval("\$threadslist = \"".gettemplate("subscribe_threads")."\";");
} else {
eval("\$threadslist = \"".gettemplate("subscribe_nothreads")."\";");
}
// draw cp nav bar
$cpnav[1]="{firstaltcolor}";
$cpmenu[1]="class=\"fjsel\" selected";
$cpnav[2]="{secondaltcolor}";
$cpnav[3]="{secondaltcolor}";
$cpnav[4]="{secondaltcolor}";
$cpnav[5]="{secondaltcolor}";
$cpnav[6]="{secondaltcolor}";
$cpnav[7]="{secondaltcolor}";
eval("\$cpnav = \"".gettemplate("usercpnav")."\";");
$frmjmpsel['usercp'] = "selected";
makeforumjump();
eval("dooutput(\"".gettemplate("usercp")."\");");
?>
![\"Poll\"](\"{imagesfolder}/poll.gif\")
";
}
if ($wordwrap!=0) {
$thread[title]=dowordwrap($thread[title]);
}
$replies=$thread[replycount];
$views=$thread[views];
$thread[lastreplydate]=vbdate($dateformat,$thread[lastpost]);
$thread[lastreplytime]=vbdate($timeformat,$thread[lastpost]);
$thread[gotonew]="";
$thread[newoldhot]="folder";
if (!$thread[open]) {
$thread[newoldhot]="lock".$thread[newoldhot];
}
if ($thread[replycount]>=$hotnumberposts or $thread[views]>=$hotnumberviews and $usehotthreads) {
$thread[newoldhot]="hot".$thread[newoldhot];
}
if ($bbuserinfo[lastvisitdate]=="Never") {
$thread[newoldhot]="new".$thread[newoldhot];
} elseif ($thread[lastpost]>$bbuserinfo[lastvisit]) {
if (!isset($bbthreadview) or $bbthreadview[$thread[threadid]]<$thread[lastpost]) {
$thread[newoldhot]="new".$thread[newoldhot];
}
eval("\$thread[gotonew] = \"".gettemplate("forumdisplay_gotonew")."\";");
}
if ($showdots and $bbuserinfo[userid] >= 1 and $bbuserinfo[userid] == $thread[userid]) {
$thread[newoldhot] = "dot_" . $thread[newoldhot];
}
eval("\$threadbits .= \"".gettemplate("subscribe_threadbit")."\";");
}
eval("\$threadslist = \"".gettemplate("subscribe_threads")."\";");
} else {
eval("\$threadslist = \"".gettemplate("subscribe_nothreads")."\";");
}
// draw cp nav bar
$cpnav[1]="{firstaltcolor}";
$cpmenu[1]="class=\"fjsel\" selected";
$cpnav[2]="{secondaltcolor}";
$cpnav[3]="{secondaltcolor}";
$cpnav[4]="{secondaltcolor}";
$cpnav[5]="{secondaltcolor}";
$cpnav[6]="{secondaltcolor}";
$cpnav[7]="{secondaltcolor}";
eval("\$cpnav = \"".gettemplate("usercpnav")."\";");
$frmjmpsel['usercp'] = "selected";
makeforumjump();
eval("dooutput(\"".gettemplate("usercp")."\");");
?>