Forum Display Enhancements - All Topic - Master Forums - Shows threads from multiple forums in one forum

This a complete and total upgrade to version 2.0!

New Version: 2.2

NOTE: VB 4.2.0(and over) Users DO NOT do the Manual File Edit on forumdisplay.php in the directions.

1 manual file edit is required to fix a bug where the thread count may be wrong in the master forum. Details in instructions in zip file.

You can now specify an * to denote "all forums" when creating a master forum. See instructions for details.

In addition this mod will be able to auto edit your templates if you run the standard threadbit template, otherwise there are instructions in the zip file for manual template edits if needed.

New in 2.2: Show or hide sticky threads from slave forums on the master forum.

What does this mod do? - Basically this is only the most awesomest mod ever for vBulletin. You can now view threads from other forums in "Master Forums" you designate.

For example on my site "Off Topic" is my "Master Forum" and virtually all other forums are assigned to the Master Forum offering user's the ability to browse 1 forum while seeing threads from many others.

New in version 2.0: You can now have multiple master forums.

See the screen shots for an example.

All instructions are included in the zip file.

As pointed out by phpdesk you must have at least 1 thread in your master forum for this to work.

I have tested this on VB 4.0.8 and am sure it will work on all 4.0/4.1 versions to date. There is a separate version for VB 3.x.

You can mostly ignore all posts in this thread up to post #25. Old posts are no longer relevant to this new version. (Note: post #7 is still relevant if you have only 1 master forum.)

------------------------------------------------------

Please "Mark as Installed" if you use this.
Donations always appreciated. :up:
Nominate MOTM if you LOVE it!

[Alan_SP]

Yes, that's it. :up:

Now it works excellent. I merged both options (for including and excluding), removed your debugging info (appeared on top of page in excluding forums), removed option for including all forums in excluding part and I hope that everything will work as intended.

I tested it on my server and now everything works as far as I can tell. I had strange bug, but really strange bug when sometimes excluding forums became including ones after reinstall and where reinstalling product again helped. I'm not sure why, but I changed plugin execution order for excluding forums plugins to 6 and tried 3 times to reinstall mod and it worked all 3 times fine. If someone would have problems, just try to reinstall.

I attached modified version and BirdOPrey5 I hope you'll to use it too (and support it). This is really excellent mod. :up:

Only suggestion is if names of forums in threadbit could become links to these forums? This may be very useful, especially if users would like to open new threads in appropriate forums.

[Cybertims]

Database error in vBulletin 4.1.3 Beta 1:

Invalid SQL:

SELECT COUNT(*) AS threads,
(
SELECT COUNT(*) AS newthread
FROM thread AS thread
WHERE forumid = 12
AND lastpost > 1303460427
AND open <> 10
AND sticky = 0

AND visible IN (0,1,2)



*/ WHERE forumid > 0 AND sticky = 0 AND visible IN (0,1,2)
) AS newthread

FROM thread AS thread

/*
WHERE forumid = 12
AND sticky = 0

AND visible IN (0,1,2)



*/ WHERE forumid > 0 AND sticky = 0 AND visible IN (0,1,2);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*/ WHERE forumid > 0 AND sticky = 0 AND visible IN (0,1,2)
) AS newthre' at line 14
Error Number : 1064
Request Date : Friday, April 22nd 2011 @ 10:21:32 AM
Error Date : Friday, April 22nd 2011 @ 10:21:32 AM
Script : *****/forumdisplay.php/12-Master-Forum
Referrer : ******/index.php
IP Address : *****
Username : ****
Classname : vB_Database
MySQL Version : 5.0.91-log

I continually get this error above as soon as I turn on the product. I have created a forum called master forum which has ID of 12, I add 12|* and always get the above error when trying to view the new forum section.

Cheers

[BirdOPrey5]

Oh, the Master Forum needs at least 1 normal thread in it for this to work. Make a new thread before enabling the product.

[Cybertims]

Originally Posted by BirdOPrey5

Oh, the Master Forum needs at least 1 normal thread in it for this to work. Make a new thread before enabling the product.

It does have 1 normal thread in it already.

[BirdOPrey5]

It looks like maybe you didn't make the file edit as explained in the instructions.

You must edit forumdisplay.php, find the code below and delete the line in red and then save and re-upload the file.

	($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,
	  (
	   SELECT COUNT(*) AS newthread
	   FROM " . TABLE_PREFIX . "thread AS thread
	   WHERE forumid = $foruminfo[forumid]
	    AND lastpost > $lastread
	    AND open <> 10
	    AND sticky = 0
	    $prefix_filter
	    $visiblethreads
	    $globalignore
	    $limitothers
	    $datecut
	    $hook_query_where	 
	  ) 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'];

[Alan_SP]

Originally Posted by BirdOPrey5

Oh, the Master Forum needs at least 1 normal thread in it for this to work. Make a new thread before enabling the product.

When I tested merging including and excluding options I used only empty forums for Master forums. And it worked without any problems (well, with new code for excluding it does). So I think that you don't have to have any threads in Master forums.

Only problem is you don't see on forum display (index page) that Master forums has any threads. They show only their own threads. At least it looks like that for me...

[BirdOPrey5]

Originally Posted by Alan_SP

When I tested merging including and excluding options I used only empty forums for Master forums. And it worked without any problems (well, with new code for excluding it does). So I think that you don't have to have any threads in Master forums.

Only problem is you don't see on forum display (index page) that Master forums has any threads. They show only their own threads. At least it looks like that for me...

That is true, forumdisplay won't show threads from the slave forums, only the master. I have no plans to changing this anytime soon, it would require more plugins and probably more file edits.

[Alan_SP]

This is not problem for me. I'll write in forum description that there's no information about actual Master forums content and that they look inside themselves.

Master forums are excellent idea and very useful. :up:

[BirdOPrey5]

Noted that for some reason vBulletin used a different version of forumdiplay.php on VB 4.0.7. You DO NOT need to do the manual file edit on 4.0.7, it will just work. I know you MUST do the file edit on 4.0.8 and above and 4.0.4, not sure about 4.0.5/6.

[vbandroid]

Originally Posted by BirdOPrey5

That is true, forumdisplay won't show threads from the slave forums, only the master. I have no plans to changing this anytime soon, it would require more plugins and probably more file edits.

This is a great mod! Thanks. I was wondering if its possible to have some sort of work around for this? perhaps add a condition code to the master board, like if forum id=X, then pull stats from a,b,c. That we can manually add. I'm not very good at this but would this be possible?