Forum Display Enhancements - Global Threads for VB3

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.

It is ESSENTIAL if you upgrade to this version from the original 1.0.1 version you UNINSTALL the old one first. This isn't a suggestion, this is a REQUIREMENT.

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.

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:
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 will work on vB 3.8.x and should work on 3.7.x too.

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.

[BirdOPrey5]

Reserved.

[Kaelon]

This looks really interesting. What is the performance impact? Can you tell us a bit about the queries you used?

[BirdOPrey5]

There is 1 additional query on each page view of forumdisplay.php.

The query is identical to the query that pulls all the threads for the specific forum you are viewing.. basically vbulletin queries the database for all threads in forum X (the forum you're viewing) LIMIT by the number of threads per page. The after vBulletin pulls its threads, this mod goes ahead and pulls all threads from forum Y (the global forum) LIMIT the number you set in options.

The 1 query adds no noticeable performance loss IMO.

[Hellmaster]

Does it work as a global announcement? But this is a Thread which can be replied?

[BirdOPrey5]

Basically it's like a global announcement that can be replied to... But it's listed as a thread (either above or below stickies) not listed as an announcement.

[MagicThemeParks]

Looks very cool. I may have to use this one too Joe

[blackberry]

its giving me following database error

Database error in vBulletin 3.8.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.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount, deletedcount

, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadread.readtime AS threadread
, threadredirect.expires
, post_user.displaygroupid AS post_user_displaygid, post_user.usergroupid AS post_user_usergid, last_post_user.displaygroupid AS last_post_user_displaygid, last_post_user.usergroupid AS last_post_user_usergid
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')

LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 2)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

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

MySQL Error : Unknown column 'post_user.displaygroupid' in 'field list'
Error Number : 1054
Request Date : Saturday, July 2nd 2011 @ 07:28:58 AM
Error Date : Saturday, July 2nd 2011 @ 07:28:58 AM
Script : http://+++++.com/forum/forumdisplay.php?f=92
Referrer : http://+++++.com/forum/index.php
IP Address : 94.172.151.125
Username :
Classname : vB_Database
MySQL Version : 5.0.92-community-log

[BirdOPrey5]

Do you have access to phpmyadmin?

I've seen on rare occasion people who don't have the field displaygroupid in their user table before.

Please go to phpmyadmin, browse to your database, and view the user table.

See if you have the column called displaygroupid.

If not you should go to STRUCTURE -> Add 1 filed after membergroupids and call it displaygroupid type smallint(5).

It is of course good practice to backup your database before changing it.

[blackberry]

I have both membergroupids and displaygroupid field both their values are 0 ?
Image attached