I can't view the Spot forum display... [Archive]

Walk Wit Me

04-30-06, 09:30 PM

this is what happens when I try to go to "The Spot"

<?php
/*======================================================================* \
|| #################################################################### ||
|| # || # ---------------------------------------------------------------- # ||
|| # Copyright ©2000–2005 Jelsoft Enterprises Ltd. All Rights Reserved. ||
|| # This file may not be redistributed in whole or significant part. # ||
|| # ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # ||
|| # http://www.vbulletin.com | http://www.vbulletin.com/license.html # ||
|| #################################################################### ||
\*====================================================================== */

// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

// #################### DEFINE IMPORTANT CONSTANTS #######################
define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'forumdisplay');

// ################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array('forumdisplay');

// get special data templates from the datastore
$specialtemplates = array(
'iconcache',
'mailqueue'
);

// pre-cache templates used by all actions
$globaltemplates = array();

// pre-cache templates used by specific actions
$actiontemplates = array(
'none' => array(
'FORUMDISPLAY',
'threadbit',
'threadbit_deleted',
'forumdisplay_announcement',
'forumhome_lastpostby',
'forumhome_forumbit_level1_post',
'forumhome_forumbit_level2_post',
'forumhome_forumbit_level1_nopost',
'forumhome_forumbit_level2_nopost',
'forumhome_subforumbit_nopost',
'forumhome_subforumseparator_nopost',
'forumdisplay_loggedinuser',
'forumhome_moderator',
'forumdisplay_moderator',
'forumdisplay_sortarrow',
'forumhome_subforumbit_post',
'forumhome_subforumseparator_post',
'forumrules'
)
);

// ####################### PRE-BACK-END ACTIONS ##########################
function exec_postvar_call_back()
{
global $_REQUEST, $session, $vboptions;

// jump from forumjump
switch ($_REQUEST['forumid'])
{
case 'search': $goto = 'search'; break;
case 'pm': $goto = 'private'; break;
case 'wol': $goto = 'online'; break;
case 'cp': $goto = 'usercp'; break;
case 'subs': $goto = 'subscription'; break;
case 'home':
case '-1': $goto = $vboptions['forumhome']; break;
}

if ($goto != '')
{
require_once('./includes/functions.php');
exec_header_redirect("$goto.php?$session[sessionurl_js]");
}
// end forumjump redirects
}

// ######################### REQUIRE BACK-END ############################
require_once('./global.php');

require_once('./includes/functions_forumlist.php');
require_once('./includes/functions_bigthree.php');
require_once('./includes/functions_forumdisplay.php');

// #######################################################################
// ######################## START MAIN SCRIPT ############################
// #######################################################################

// ############################### start mark forums read ###############################
if ($_REQUEST['do'] == 'markread')
{
$forumid = intval($_REQUEST['forumid']);

if (!$forumid)
{
if ($bbuserinfo['userid'])
{
$DB_site->query("UPDATE " . TABLE_PREFIX . "user SET lastactivity = " . TIMENOW . ", lastvisit=" . (TIMENOW - 1) . " WHERE userid=$bbuserinfo[userid]");
}
else
{
vbsetcookie('lastvisit', TIMENOW);
}

$url = "$vboptions[forumhome].php?$session[sessionurl]";
eval(print_standard_redirect('markread'));
}
else
{
// temp work around code, I need to find another way to mass set some values to the cookie
$bb_cache_forum_view = unserialize(convert_bbarray_cookie($_COOKIE[COOKIE_PREFIX . 'forum_view']));

require_once('./includes/functions_misc.php');
$childforums = fetch_child_forums($forumid, 'ARRAY');
foreach ($childforums AS $val)
{ // mark the forum and all child forums read
$bb_cache_forum_view["$val"] = TIMENOW;
}
set_bbarray_cookie('forum_view', $forumid, TIMENOW);

if ($foruminfo['parentid'] == -1)
{
$url = "$vboptions[forumhome].php?$session[sessionurl]";
}
else
{
$url = "forumdisplay.php?$session[sessionurl]f=$foruminfo[parentid]";
}
eval(print_standard_redirect('markread_single'));
}
}

// ############################### start enter password ###############################
if ($_REQUEST['do'] == 'doenterpwd')
{
globalize($_REQUEST, array('forumid' => INT, 'newforumpwd' => STR, 'url' => STR, 'postvars'));

$foruminfo = verify_id('forum', $forumid, 1, 1);

if ($foruminfo['password'] == $newforumpwd)
{
// set a temp cookie for guests
if (!$bbuserinfo['userid'])
{
set_bbarray_cookie('forumpwd', $forumid, md5($bbuserinfo['userid'] . $newforumpwd));
}
else
{
set_bbarray_cookie('forumpwd', $forumid, md5($bbuserinfo['userid'] . $newforumpwd), 1);
}

if ($url == "$vboptions[forumhome].php")
{
$url = "forumdisplay.php?$session[sessionurl]f=$forumid";
}
else if ($url != '' AND $url != 'forumdisplay.php')
{
$url = str_replace('"', '', $url);
}
else
{
$url = "forumdisplay.php?$session[sessionurl]f=$forumid";
}

// Allow POST based redirection...
if ($postvars)
{
$temp = unserialize($postvars);
if ($temp['do'] != 'doenterpwd')
{ // ...but prevent an infinite loop
$postvars = construct_hidden_var_fields($postvars);
$formfile = $url;
}
else
{
$postvars = '';
}
}
eval(print_standard_redirect('forumpasswordcorrect'));
}
else
{
$postvars = construct_post_vars_html();
eval(print_standard_error('forumpasswordincorrect'));
}
}

// ###### END SPECIAL PATHS

globalize($_REQUEST, array('perpage' => INT, 'pagenumber' => INT, 'daysprune' => INT));

// needs this to show error if forum does not exist
$foruminfo = verify_id('forum', $forumid, 1, 1);

// get permission to view forum
$_permsgetter_ = 'forumdisplay';
$forumperms = fetch_permissions($forumid);
if (!($forumperms & CANVIEW))
{
print_no_permission();
}

// check if there is a forum password and if so, ensure the user has it set
verify_forum_password($foruminfo['forumid'], $foruminfo['password']);

$show['newthreadlink'] = iif($foruminfo['allowposting'], true, false);
$show['threadicons'] = iif ($foruminfo['allowicons'], true, false);
$show['threadratings'] = iif ($foruminfo['allowratings'], true, false);

// get iforumcache - for use by makeforumjump and forums list
// fetch the forum even if they are invisible since its needed
// for the title but we'll unset that further down
cache_ordered_forums(1, 1);

if (!$daysprune)
{
if ($bbuserinfo['daysprune'] != 0)
{
$daysprune = $bbuserinfo['daysprune'];
}
else
{
$daysprune = iif($foruminfo['daysprune'], $foruminfo['daysprune'], 30);
}
}

// ### GET FORUMS, PERMISSIONS, MODERATOR iCACHES ########################
cache_moderators();

// draw nav bar
$navbits = array();
$parentlist = array_reverse(explode(',', substr($foruminfo['parentlist'], 0, -3)));
foreach ($parentlist AS $forumID)
{
$forumTitle = $forumcache["$forumID"]['title'];
$navbits["forumdisplay.php?$session[sessionurl]f=$forumID"] = $forumTitle;
}

// pop the last element off the end of the $nav array so that we can show it without a link
array_pop($navbits);

$navbits[''] = $foruminfo['title'];
$navbits = construct_navbits($navbits);
eval('$navbar = "' . fetch_template('navbar') . '";');

$moderatorslist = '';
$listexploded = explode(',', $foruminfo['parentlist']);
$showmods = array();
$show['moderators'] = false;
$totalmods = 0;
foreach ($listexploded AS $parentforumid)
{
if (!$imodcache["$parentforumid"])
{
continue;
}
foreach ($imodcache["$parentforumid"] AS $moderator)
{
if ($showmods["$moderator[userid]"] === true)
{
continue;
}
$showmods["$moderator[userid]"] = true;
if ($moderatorslist == '')
{
$show['moderators'] = true;
eval('$moderatorslist = "' . fetch_template('forumdisplay_moderator') . '";');
}
else
{
eval('$moderatorslist .= ", ' . fetch_template('forumdisplay_moderator') . '";');
}
$totalmods++;
}
}

// ### BUILD FORUMS LIST #################################################

$comma = '';

// get an array of child forum ids for this forum
$foruminfo['childlist'] = explode(',', $foruminfo['childlist']);

// define max depth for forums display based on $vboptions[forumhomedepth]
define('MAXFORUMDEPTH', $vboptions['forumdisplaydepth']);

if ($vboptions['showforumusers'])
{
$datecut = TIMENOW - $vboptions['cookietimeout'];
$forumusers = $DB_site->query("
SELECT user.username, (user.options & $_USEROPTIONS[invisible]) AS invisible, user.usergroupid, session.userid, session.inforum, session.lastactivity,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM " . TABLE_PREFIX . "session AS session
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > $datecut
ORDER BY" . iif($vboptions['showforumusers'] == 1, " username ASC,") . " lastactivity DESC
");

$numberregistered = 0;
$doneuser = array();

if ($bbuserinfo['userid'])
{

// fakes the user being in this forum
$bbuserinfo['joingroupid'] = iif($bbuserinfo['displaygroupid'], $bbuserinfo['displaygroupid'], $bbuserinfo['usergroupid']);
$loggedin = array(
'userid' => $bbuserinfo['userid'],
'username' => $bbuserinfo['username'],
'invisible' => $bbuserinfo['invisible'],
'invisiblemark' => $bbuserinfo['invisiblemark'],
'inforum' => $foruminfo['forumid'],
'lastactivity' => TIMENOW,
'musername' => fetch_musername($bbuserinfo, 'joingroupid')
);
$numberregistered = 1;
fetch_online_status($loggedin);
eval('$activeusers = "' . fetch_template('forumdisplay_loggedinuser') . '";');
$doneuser["$bbuserinfo[userid]"] = 1;
$comma = ', ';
}

$inforum = array();

$numberguest = 0;

// this require the query to have lastactivity ordered by DESC so that the latest location will be the first encountered.
while ($loggedin = $DB_site->fetch_array($forumusers))
{
if (empty($doneuser["$loggedin[userid]"]))
{
if (in_array($loggedin['inforum'], $foruminfo['childlist']) AND $loggedin['inforum'] != -1)
{
if (!$loggedin['userid'])
{
// this is a guest
$numberguest++;
$inforum["$loggedin[inforum]"]++;
}
else
{
$numberregistered++;
$inforum["$loggedin[inforum]"]++;
if (fetch_online_status($loggedin))
{
$loggedin['musername'] = fetch_musername($loggedin);
eval('$activeusers .= "' . $comma . fetch_template('forumdisplay_loggedinuser') . '";');
$comma = ', ';
}
}
}
if ($loggedin['userid'])
{
$doneuser["$loggedin[userid]"] = 1;
}
}
}

$totalonline = $numberregistered + $numberguest;
unset($joingroupid, $key, $datecut , $comma, $invisibleuser, $userinfo, $userid, $loggedin, $index, $value, $forumusers, $parentarray );

$show['activeusers'] = iif ($activeusers != '', true, false);
}
else
{
$show['activeusers'] = false;
}

// ######################################################################## #####
// get read status for this forum and children
$unreadchildforums = 0;
foreach ($foruminfo['childlist'] AS $val)
{
if ($val == -1 OR $val == $foruminfo['forumid'])
{
continue;
}

if ($forumcache["$val"]['lastpost'] >= intval(fetch_bbarray_cookie('forum_view', $val)) AND $forumcache["$val"]['lastpost'] >= $bbuserinfo['lastvisit'])
{
$unreadchildforums = 1;
}
}

$forumbits = construct_forum_bit($forumid);

if (can_moderate($forumid))
{
$show['adminoptions'] = true;
}
else
{
$show['adminoptions'] = false;
}
if ($permissions['adminpermissions'] & CANCONTROLPANEL)
{
$show['addmoderator'] = true;
}
else
{
$show['addmoderator'] = false;
}

$curforumid = $forumid;
construct_forum_jump();

/////////////////////////////////
if ($foruminfo['cancontainthreads'])
{
/////////////////////////////////
$bbforumview = intval(fetch_bbarray_cookie('forum_view', $foruminfo['forumid']));
if ($bbforumview > $bbuserinfo['lastvisit'])
{
$lastread = $bbforumview;
}
else
{
$lastread = $bbuserinfo['lastvisit'];
}

// get announcements

$announcebits = '';

$announcements = $DB_site->query("
SELECT
announcementid, startdate, title, announcement.views,
user.username, user.userid, user.usertitle, user.customtitle
FROM " . TABLE_PREFIX . "announcement AS announcement
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = announcement.userid)
WHERE startdate <= " . (TIMENOW - $vboptions['hourdiff']) . "
AND enddate >= " . (TIMENOW - $vboptions['hourdiff']) . "
AND " . fetch_forum_clause_sql($foruminfo['forumid'], 'forumid') . "
ORDER BY startdate DESC
" . iif($vboptions['oneannounce'], "LIMIT 1"));

while ($announcement = $DB_site->fetch_array($announcements))
{
if ($announcement['customtitle'] == 2)
{
$announcement['usertitle'] = htmlspecialchars_uni($announcement['usertitle']);
}
$announcement['postdate'] = vbdate($vboptions['dateformat'], $announcement['startdate'], false, true, false);
if ($announcement['startdate'] > $lastread)
{
$announcement['statusicon'] = 'new';
}
else
{
$announcement['statusicon'] = 'old';
}
$announcement['views'] = vb_number_format($announcement['views']);
$announcementidlink = iif(!$vboptions['oneannounce'] , "&announcementid=$announcement[announcementid]");

eval('$announcebits .= "' . fetch_template('forumdisplay_announcement') . '";');
}