About this hack:
This hack allows you to set a thread as 'must read' by your members. Right now, if you make a post and want all your members to read it, you have no way of enforcing it. This hack will give an error message similar to the one you get when you need to change you password, saying that the admins want you to read a certain thread before they continue using the forum.
Once a user reads a thread, they wont be bugged to read it again.
You can set all usergroups or just certain onces that must read a thread.
You can set to site wide or just some forums.
Option to Force Guests
This hack added one query to every page on your forum a member goes to.
Files edited: 0
Templates edited: 0
Files to upload: 3 (1 via ACP, 2 via FTP)
Time to install: 1 minute
Updates:
Updates: Version 2.10 (05/02/10):
First release of this hack for vb 4.0.
Added link in "Administrative" drop down on the showthread page to edit force read settings.
Please post your comments or suggestions for this hack. I read ALL posts.
MAKE SURE YOU CLICK INSTALL! You will get an email when a new version is released.
Invalid SQL:
SELECT *
FROM thread AS thread
LEFT JOIN force_read_users AS force_read_users ON (thread.threadid = force_read_users.force_read_threadid AND force_read_users.force_read_userid = '150409')
WHERE thread.force_read = '1' AND (thread.force_read_expire_date = '0' OR thread.force_read_expire_date > '1320959203') AND (force_read_usergroups = '' OR force_read_usergroups LIKE '%-2-%') AND (force_read_forums = '' OR force_read_forums LIKE '%-72-%' OR force_read_forums LIKE '%-70-%') AND force_read_users.force_read_userid IS NULL
ORDER BY force_read_order ASC;
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, November 10th 2011 @ 11:06:43 PM
Error Date : Thursday, November 10th 2011 @ 11:07:21 PM
Invalid SQL:
SELECT *
FROM thread AS thread
LEFT JOIN force_read_users AS force_read_users ON (thread.threadid = force_read_users.force_read_threadid AND force_read_users.force_read_userid = '150409')
WHERE thread.force_read = '1' AND (thread.force_read_expire_date = '0' OR thread.force_read_expire_date > '1320959203') AND (force_read_usergroups = '' OR force_read_usergroups LIKE '%-2-%') AND (force_read_forums = '' OR force_read_forums LIKE '%-72-%' OR force_read_forums LIKE '%-70-%') AND force_read_users.force_read_userid IS NULL
ORDER BY force_read_order ASC;
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, November 10th 2011 @ 11:06:43 PM
Error Date : Thursday, November 10th 2011 @ 11:07:21 PM
??
That's an issue with your host, not vBulletin. Contact your host with that error
Invalid SQL:
SELECT *
FROM thread AS thread
LEFT JOIN force_read_users AS force_read_users ON (thread.threadid = force_read_users.force_read_threadid AND force_read_users.force_read_userid = '150409')
WHERE thread.force_read = '1' AND (thread.force_read_expire_date = '0' OR thread.force_read_expire_date > '1320959203') AND (force_read_usergroups = '' OR force_read_usergroups LIKE '%-2-%') AND (force_read_forums = '' OR force_read_forums LIKE '%-72-%' OR force_read_forums LIKE '%-70-%') AND force_read_users.force_read_userid IS NULL
ORDER BY force_read_order ASC;
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, November 10th 2011 @ 11:06:43 PM
Error Date : Thursday, November 10th 2011 @ 11:07:21 PM
??
I was getting same error after installing 4.1.9. It is on the host. I had my wait_timeout: set way too low. It's set at 120 now, but the default goes as high as 28800 on my host. I'd contact them. It caused me to have all kinds of db errors in a lot of mods. I don't know why with this upgrade there was such an issue, but after raising that, no more db errors at all, just like before 4.1.9. I hate upgrading due to all the problems it causes. Had I not installed vbseo and checked their specs, I would have never known. I had everything I needed except that one setting needing to be raised slightly. I don't know if I would have had ever figured it out with those specs though. It sure had me going nuts for awhile. I was not at all used to db errors. I am now db error free again and kept my mods too.