Forum Display Enhancements - Global Threads

Description
If your forums are split up in such a way where certain groups of users only visit a certain forum, then you know it's difficult to get all your users to read an announcement. This mod displays a certain amount of threads from a specified "source" forum, and places it on the Forum Display page right after the Stickied threads. These threads are labeled with a "Global: " tag.

This mod is in beta, so install at your own risk, but will be supported. Please let me know of any bugs, or suggestions that you may have!

Install / Upgrade
Download the attached XML file, and import it at
Admin Control Panel > Plugins & Products > Manage Products > Add/Import Product

Remember to "Allow Overwrite" if you are upgrading.

Usage

1. Create a new forum that will be your "source" forum; that is, this forum will contain your global threads. Get the forumid of this forum.
   
2. In your AdminCP --> vBulletin Options --> Global Threads make sure you:
   • enable it
   • enter in the forumid of your source forum
   • set the number of threads from the source forum to display
3. Make a new thread in your "source" forum and it will be displayed globally in other forums.

Mod Info
1 - Query
1 - Phrase
1 - Template
3 - Plugins
0 - Template Edits


v1.0.1
Added the option to exclude certain forums.
v1.0.0b
Initial release.

Please click "Install" if you have installed this mod! Thanks!

[optrex]

vB 3.7 beta 6 is coming up with a 1064 mysql error with this hack enabled. Any fix please?

[SBlueman]

Is this modification still supported?

[bobster65]

Originally Posted by SBlueman

Is this modification still supported?

Developer Last Online: Jul 2007

[myown]

is it possible to add more than one forum as source forum?

[myown]

until now not compatible with 3.7 GOLD

[UncoderMom]

Anyone get this working on 3.7?
Here is the error I get.

Database error in vBulletin 3.7.0 Beta 4:

Invalid SQL:

SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason

, threadredirect.expires

FROM vb3_thread AS thread
LEFT JOIN vb3_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN vb3_subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)

LEFT JOIN vb3_post AS post ON(post.postid = thread.firstpostid)

LEFT JOIN vb3_threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)

WHERE thread.forumid = 2
ORDER BY dateline DESC
LIMIT 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 ' thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, th' at line 6
Error Number : 1064
Date : Saturday, May 10th 2008 @ 01:53:49 PM
Script :
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version : 4.1.22-standard

[randominity]

Sorry, been MIA again, just upgraded to 3.7, so I'll see about updating this soon

[myown]

that is a good news

[UncoderMom]

That is so awesome! Not having this has crippled my communication with my members! This is by far the best system! Thank you!!

[UncoderMom]

Originally Posted by randominity

Sorry, been MIA again, just upgraded to 3.7, so I'll see about updating this soon

Any luck?