[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

[BirdOPrey5]

I re-checked this mod and "displaygroupid" is never queried by this mod so I'm thinking there is probably a conflict with another mod you may be running.

There might be an easy fix...

If you go to your Admin CP -> Plugin Manager -> Edit the Plugin Query Global Threads

Find the code:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

and just delete it.

Let me know if you still get the error and if not does it look like everything is working- this change will only affect global threads.

[blackberry]

yep working fine now thanks

[home9000]

Dear BirdOPrey5

any one he in the coventry list will get database error

[BirdOPrey5]

Originally Posted by home9000

Dear BirdOPrey5

any one he in the coventry list will get database error

Indeed it does.

For a quick fix go to your Admin CP -> Plugin Manager find the plugin Query Global Threads and edit it.

Find the 3 instances of "replycount" (no quotes) and replace them all with "thread.replycount" (also no quotes.)

That will fix the database error. I will incorporate the fix into the next release. Thank you for letting me know.

[home9000]

Originally Posted by BirdOPrey5

Indeed it does.

For a quick fix go to your Admin CP -> Plugin Manager find the plugin Query Global Threads and edit it.

Find the 3 instances of "replycount" (no quotes) and replace them all with "thread.replycount" (also no quotes.)

That will fix the database error. I will incorporate the fix into the next release. Thank you for letting me know.

Your are the best
Thanks too much it's working fine now