I'm on 4.0.5 still and the forumdisplay.php edit isn't possible. The original appears as:
Code:
($hook = vBulletinHook::fetch_hook('forumdisplay_query_threadscount')) ? eval($hook) : false;
# Include visible IN (0,1,2) in order to hit upon the 4 column index
$threadscount = $db->query_first_slave("
SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > $lastread AND open <> 10, 1, 0)) AS newthread
$hook_query_fields
FROM " . TABLE_PREFIX . "thread AS thread
$tachyjoin
$hook_query_joins
WHERE forumid = $foruminfo[forumid]
AND sticky = 0
$prefix_filter
$visiblethreads
$globalignore
$limitothers
$datecut
$hook_query_where
");
$totalthreads = $threadscount['threads'];
$newthreads = $threadscount['newthread'];
Removing the $hook_query_where causes database errors. I tried replacing the entire section with the "this is what your code should look like" and the forums run fine until I enable the product. When enabled, it causes this error on forumdisplay:
Quote:
vBulletin Message
Unable to add cookies, header already sent.
File: /home/novoci5/public_html/forums/vb/exception/templatefatalerror.php
Line: 67
|
Is there a way to make this work without upgrading?