Forum Display Enhancements - Global Threads for VB4

This mod is based off a VB 3.6 mod by randominity here:
https://vborg.vbsupport.ru/showthread.php?t=129626
He gave me permission to further develop this mod.

This mod allows you to display "global threads" in your forums. Global Threads are threads that show up in every forum (or forums you specify) as opposed to just a single forum.

This is perfect for important site news, forum wide polls, and anything worthwhile to be displayed forum wide.

New Version: 2.02 - Fixed a conflict with the "Thread Links" mod.
New Version: 2.01 - 1 Bug Fix, +1 Extra Option (Choose to display above or below sticky divider if you have one.)

I know you could make an announcement but people ignore announcements, and you can't reply to them like threads. These are real threads and if you don't take away permission people can reply to it like any other thread. Replies in any forum show up in all forums.

Same thread in multiple forums: (VB3 Version)
http://www.juot.net/forums/forumdisplay.php?f=48
http://www.juot.net/forums/forumdisplay.php?f=43
http://www.juot.net/forums/forumdisplay.php?f=20
(It's under the sticky threads.)

This mod requires a little work on your side- you must first create a "global forum." I suggest calling it "Global Forum" and in the forum manager when creating it, choose to "Set Active" set to "No" so it won't show up in your forum lists but will be accessible directly by you to post new threads in.

I have greatly increased the number of options over the original mod and believe I have implemented all the good suggestions ever made for the original mod.

This version won't work on any vBulletin version less than 4.0.0.

I have marked this as BETA as there is 1 unresolved minor bug- it has been a bug since this mod came out but no one seems to have noticed or cared. When showing global threads the small arrow indicating if you had posts in the global thread won't snow.

See screenshots for a Global Thread example. The Global Thread globe icon is optional.

Full instructions in zip file.

Please Mark as Installed if you use this.

Note: See post #95 for info on how to fix this mod for VB 4.1.7.

See post #126 for an updated threadbit_global template for VB Versions 4.1.10 and above.

Note- I have released a new and better global thread mod and will no longer be supporting this version.

New Mod Link: https://vborg.vbsupport.ru/showthread.php?t=279156

[Taurus1]

I am getting the following database error with this enabled:

Database error in vBulletin 4.1.1:

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,post.thankscache,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
thread.prefixid, thread.taglist, hiddencount, deletedcount,
user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadread.readtime AS threadread
, threadredirect.expires
, firstpostid,modification.mod_installcount,usermod. mod_tagged,usermod.mod_installed,usermod.mod_downl oaded,modification.last_update
FROM vbthread AS thread
LEFT JOIN vbuser AS user ON (user.userid = thread.lastposterid)
LEFT JOIN vbuserlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 3)
LEFT JOIN vbdeletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN vbsubscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 3 AND canview = 1)
LEFT JOIN vbthreadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 3)
LEFT JOIN vbpost AS post ON(post.postid = thread.firstpostid)

LEFT JOIN vbthreadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
WHERE thread.forumid = 223
ORDER BY lastpost DESC
LIMIT 5;

MySQL Error : Unknown column 'modification.mod_installcount' in 'field list'
Error Number : 1054
Request Date : Tuesday, February 1st 2011 @ 05:38:58 AM
Error Date : Tuesday, February 1st 2011 @ 05:38:58 AM
Script : http://creativx.net/forums/forumdisplay.php?f=25
Referrer : http://creativx.net/forums/
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.1.54

Please help.

[BadgerDog]

Installed on 4.04pl1 for testing with thanks ... :up:

Regards,
Doug

Edit: Set-up as per instructions (see attached pic), added "Global Messages Forum" and ENABLED mod.

Created a post in the new "Global Messages Forum" and hit submit ....

Nothing appears in any of the forums specified, however post appears in "Global Messages Forum".

[BirdOPrey5]

Originally Posted by Taurus1

I am getting the following database error with this enabled:

Database error in vBulletin 4.1.1:

Invalid SQL:

SELECT
...

MySQL Error : Unknown column 'modification.mod_installcount' in 'field list'
Error Number : 1054
Request Date : Tuesday, February 1st 2011 @ 05:38:58 AM
Error Date : Tuesday, February 1st 2011 @ 05:38:58 AM
Script : http://creativx.net/forums/forumdisplay.php?f=25
Referrer : http://creativx.net/forums/
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.1.54

Please help.

Hi, I see the problem... I forgot to remove 1 hook from the code and another modification you have is interfering with the query.

I will release an update to fix this bug shortly. In the mean time if you want to fix it you can go to Plugin Manager -> Edit the plugin titled: Query Global Threads
Find this line:

$hook_query_fields

And simply erase it, hit save, and it should work.

Or wait for my next update later today.

Originally Posted by BadgerDog

Installed on 4.04pl1 for testing with thanks ... :up:

Regards,
Doug

Edit: Set-up as per instructions (see attached pic), added "Global Messages Forum" and ENABLED mod.

Created a post in the new "Global Messages Forum" and hit submit ....

Nothing appears in any of the forums specified, however post appears in "Global Messages Forum".

Is the mod still enabled? If so please give me the forumid of your global forum. I will take a look.

My guess off hand is you have the permissions set wrong- users need to be able to view the forum and threads... here is a screenshot of proper forum permissions:

[Taurus1]

Thank you very very much!! Works perfectly now!!! You ROCK big time mate!!

[BadgerDog]

Originally Posted by BirdOPrey5

Is the mod still enabled? If so please give me the forumid of your global forum. I will take a look.

My guess off hand is you have the permissions set wrong- users need to be able to view the forum and threads... here is a screenshot of proper forum permissions:

Thanks for the quick response ... :up:

Yes, enabled and I checked forum permissions and they are fine...

In fact, I'm an Admin who created the seed post and all permissions for the forum are on, yet I can't see any of the posts.

Can I send you AdminCP access privately to have a look?

Regards,
Doug

[BirdOPrey5]

You can PM me access info but please first try this new version, 2.01 I just released just in case your problem is related to the bug fix. :up:

The new version also ads an option where you can display global threads above or below a sticky divider if you have one.

[BadgerDog]

Originally Posted by BirdOPrey5

You can PM me access info but please first try this new version, 2.01 I just released just in case your problem is related to the bug fix. :up:

The new version also ads an option where you can display global threads above or below a sticky divider if you have one.

Downloaded and installed v2.01 on our v4.04pl1.

Re-checked all settings ....

Deleted old test post from "Global Messages Forum" and created a new one... submitted it ...

It doesn't show up in any of the forums listed in the "included" listing.

Should there be spaces in list? ie: 1, 2, 3 versus 1,2,3 the way I have it?

I'll get you the login information. Sure like to get this working as it could add a lot of value to the nature of how we operate our forums.

Thanks for your help ... :up:

Regards,
Doug

[BirdOPrey5]

1,2,3 or 1, 2, 3 both work, I tested it both ways... will take a look when you PM me info.

[BadgerDog]

Originally Posted by BirdOPrey5

1,2,3 or 1, 2, 3 both work, I tested it both ways... will take a look when you PM me info.

Thanks ...

Sent you a PM ....

Also, sent you a PayPal donation for this, as well as other mods and work you've done that we've started using. Been meaning to do that for a while now ...

Regards,
Doug

[TheLastSuperman]

Awesome Joe, I like how you updated this quite handy imo!