For those with problems in combination with vBAdvanced (asuming your talking about recent threads on homepage), you could do the following quick fix. Actually this could be an adviced change for all who use vBa, if they use my hack or not, it will reduce the load on the database server a little.
In modules/latesttopics.php find:
PHP Code:
$threads = $db->query_read("
SELECT
" . iif($mod_options['portal_threads_showrating'], 'IF(votenum >= ' . $vbulletin->options['showvotes'] . ', votenum, 0) AS numbvote, IF(votenum >= ' . $vbulletin->options['showvotes'] . ' AND votenum != 0, votetotal / votenum, 0) AS voteavg,') . "
thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
" . iif($mod_options['portal_threads_showsubscribed'] AND $vbulletin->userinfo['userid'], ', NOT ISNULL(subscribethread.subscribethreadid) AS subscribed') .
iif($mod_options['portal_threads_showicon'], ', thread.iconid AS threadiconid, iconpath AS threadiconpath') .
iif($mod_options['portal_threads_showforum'], ',thread.forumid, forum.title AS forumtitle') .
iif ($mod_options['portal_threads_showpreview'] AND $vbulletin->options['threadpreview'], ', post.pagetext AS preview') . "
FROM " . TABLE_PREFIX . "thread as thread
" . iif($mod_options['portal_threads_showicon'], ' LEFT JOIN ' . TABLE_PREFIX . 'icon USING (iconid)') .
iif($mod_options['portal_threads_showforum'], ' LEFT JOIN ' . TABLE_PREFIX . 'forum AS forum ON (thread.forumid = forum.forumid)') .
iif($mod_options['portal_threads_showpreview'] AND $vbulletin->options['threadpreview'], ' LEFT JOIN ' . TABLE_PREFIX . 'post AS post ON (post.postid = thread.firstpostid)') .
$deljoin .
iif ($mod_options['portal_threads_showsubscribed'] AND $vbulletin->userinfo['userid'], ' LEFT JOIN ' . TABLE_PREFIX . 'subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = ' . $vbulletin->userinfo['userid'] . ')') . "
WHERE open != 10 AND thread.visible = 1
$mods[threadids]
$mods[inforums]
$mods[exforums]
$notdeleted
ORDER BY $mod_options[portal_threads_orderby] $mod_options[portal_threads_direction]
LIMIT $mod_options[portal_threads_maxthreads]
");
and REPLACE by:
PHP Code:
$threads = $db->query_read("
SELECT
" . iif($mod_options['portal_threads_showrating'], 'IF(votenum >= ' . $vbulletin->options['showvotes'] . ', votenum, 0) AS numbvote, IF(votenum >= ' . $vbulletin->options['showvotes'] . ' AND votenum != 0, votetotal / votenum, 0) AS voteavg,') . "
thread.threadid, thread.forumid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
" . iif($mod_options['portal_threads_showsubscribed'] AND $vbulletin->userinfo['userid'], ', NOT ISNULL(subscribethread.subscribethreadid) AS subscribed') .
iif($mod_options['portal_threads_showicon'], ', thread.iconid AS threadiconid, iconpath AS threadiconpath') .
iif ($mod_options['portal_threads_showpreview'] AND $vbulletin->options['threadpreview'], ', post.pagetext AS preview') . "
FROM " . TABLE_PREFIX . "thread as thread
" . iif($mod_options['portal_threads_showicon'], ' LEFT JOIN ' . TABLE_PREFIX . 'icon USING (iconid)') .
iif($mod_options['portal_threads_showpreview'] AND $vbulletin->options['threadpreview'], ' LEFT JOIN ' . TABLE_PREFIX . 'post AS post ON (post.postid = thread.firstpostid)') .
$deljoin .
iif ($mod_options['portal_threads_showsubscribed'] AND $vbulletin->userinfo['userid'], ' LEFT JOIN ' . TABLE_PREFIX . 'subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = ' . $vbulletin->userinfo['userid'] . ')') . "
WHERE open != 10 AND thread.visible = 1
$mods[threadids]
$mods[inforums]
$mods[exforums]
$notdeleted
ORDER BY $mod_options[portal_threads_orderby] $mod_options[portal_threads_direction]
LIMIT $mod_options[portal_threads_maxthreads]
");
Now find:
PHP Code:
$mods['threadcount'] = $db->num_rows($threads);
while ($thread = $db->fetch_array($threads))
{
$bgclass = exec_switch_bg();
Add Under:
PHP Code:
// MarcoH64
if ($mod_options['portal_threads_showforum'])
{
$thread['forumtitle'] = $vbulletin->datastore->registry->forumcache["$thread[forumid]"]['title_clean'];
}
// /MarcoH64
This will remove reading the forum title from the database. Instead it will be using the values that are already in the datastore (in memory, no query needed).
PS Someone could suggest this as a change in the standard vBa package since it is anyway an improvement.
More Information