[high]Credits[/high] NTLDR - For allowing me to port his vB3 hack of this
[high]Updates[/high] Version 1.1.0: Simple update to make this work with vBulletin 3.5.0 Beta 2 - If you are installing for the first time, follow the installation instructions - If you are upgrading, please delete the previous plugin, and upload the new one - This new plugin also has the uncached template fix
Version 1.1.1: Simple update to fix a permissions bug - Wasn't showing on my board because I had already fixed it and forgot about it lol - To upgrade, simply replace the plugin with the one attached
Version 1.1.2: Simple update to fix a permissions bug again - To upgrade, simply replace the plugin with the one attached
Chris
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
I should do a update with this plugin but now i cant find where i should write with forum who dosent should show in this plugin.
Can some one help me again.
In the forumhome_complete
PHP Code:
// #################### PROCESS LATEST THREADS #######################
// fetch the permissions for each forum
global $vbulletin;
$forumperms = array();
foreach($vbulletin->forumcache AS $forum) {
// ## HIDE FORUMS WITHOUT THE CANVIEW PERMISSION ##
if (!($forumperms[$forum["forumid"]] & $vbulletin->bf_ugp_forumpermissions['canview']) AND !$vbulletin->options['showprivateforums']) {
$limitfids .= ','.$forum['forumid'];
}
}
unset($forum);
if ($vbulletin->options['threadpreview'] > 0) {
$previewfield = ', post.pagetext AS preview';
$previewjoin = 'LEFT JOIN '.TABLE_PREFIX.'post AS post ON(post.postid = thread.firstpostid)';
}
$getthreads = $db->query_read("
## GET LATEST THREADS ##
SELECT thread.*,thread.iconid AS threadiconid $previewfield FROM ".TABLE_PREFIX."thread AS thread
LEFT JOIN ".TABLE_PREFIX."deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
$previewjoin WHERE open <> 10
AND forumid NOT IN (0$limitfids)
AND thread.visible = '1'
AND deletionlog.primaryid IS NULL
ORDER BY lastpost
DESC LIMIT 10");
Anybody who can tell me how to join forum.title to the following:
SELECT thread.*,thread.iconid AS threadiconid $previewfield, thread.lastposter AS lastposter
FROM ".TABLE_PREFIX."thread AS thread
LEFT JOIN ".TABLE_PREFIX."deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
$previewjoin
WHERE open <> 10
AND forumid NOT IN (0$limitfids)
AND forumid NOT IN (69,22,75)
AND thread.visible = '1'
AND deletionlog.primaryid IS NULL
ORDER BY lastpost
DESC LIMIT 15");
I have this working real nice took me awahile trying to figgure out how not to display certian forum the first few posts about that didnt fit it but the one on page 17 fixed it ,
How can i seperate the information down there so it isnt just one big line of data