Moderators Functions - Force Users to Read a Thread

vB 3.7 version of this hack here: https://vborg.vbsupport.ru/showthread.php?t=172155

Force Users to Read a Thread 2.0

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: 2 (1 via ACP, 2 via FTP)
• Time to install: 1 minute

Updates:

Version 2.0 (03/05/08):

• First Release of this Hack for vb3.7
• MAJOR update. Hack totally re-writen. You must uninstall old version before upgrading.
• Fixed just about all bugs. (like if you delete a thread...)
• No more template edit. Everything done in ACP.
• Permissions for by who ever has ACP access with threads and posts
• Force Guests to read a thread now.
• Works for BOTH vb3.6 AND vb3.7

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.

Pictures:

• The error message.
• The universal options.
• Where you go to set the settings.
• The list of forums that have force read settings.
• The edit/add screen.

[mc0676]

OK, than it's not a mine problem.

[Saviour]

Abe...

Just uninstalled and installed the new version. I'm getting a database error page when clicking on the Force Read Thread link in the ACP.

Any idea what's causing this?

I have vB 3.6.8 PL2 installed.

[Saviour]

Just made sure...went over everything twice...same issue.

Still getting the Database error page.

Here's the error:

Database error in vBulletin 3.6.8:
 
Invalid SQL:
 
   SELECT  administrator.*,
    userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
    language.phrasegroup_thread AS phrasegroup_thread,
    language.phrasegroup_threadmanage AS phrasegroup_threadmanage,
    language.phrasegroup_prefix AS phrasegroup_prefix,
    language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
    language.phrasegroup_global AS phrasegroup_global,
    language.options AS lang_options,
    language.languagecode AS lang_code,
    language.charset AS lang_charset,
    language.locale AS lang_locale,
    language.imagesoverride AS lang_imagesoverride,
    language.dateoverride AS lang_dateoverride,
    language.timeoverride AS lang_timeoverride,
    language.registereddateoverride AS lang_registereddateoverride,
    language.calformat1override AS lang_calformat1override,
    language.calformat2override AS lang_calformat2override,
    language.logdateoverride AS lang_logdateoverride,
    language.decimalsep AS lang_decimalsep,
    language.thousandsep AS lang_thousandsep
 
   FROM user AS user
   LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
   LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN administrator AS administrator ON (administrator.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
 
   WHERE user.userid = 1;
 
MySQL Error  : Unknown column 'language.phrasegroup_prefix' in 'field list'
Error Number : 1054
Date         : Wednesday, March 5th 2008 @ 08:06:59 AM
Script       : http://www.xxxxxx.com/forums/admincp/force_read_thread.php
Referrer     : http://www.xxxxxx.com/forums/admincp/index.php?do=nav
IP Address   : 
Username     :
Classname    : vb_database

[Abe1]

Originally Posted by Saviour

Just made sure...went over everything twice...same issue.

Still getting the Database error page.

Anyone can post the query and error? Right click and show source.

[Biggles]

I'm getting the same error too, Abe1. I am also running vB 3.6.8 PL2.

Database error message reads as follows:

MySQL Error : Unknown column 'language.phrasegroup_prefix' in 'field list'
Error Number : 1054
Date : Wednesday, March 5th 2008 @ 09:21:29 AM
Script : http://www.xxxxxxxxxxxxxx.com/forums...ead_thread.php
Referrer : http://www.xxxxxxxxxxxxxx.com/forums...dex.php?do=nav
IP Address : 81.153.66.74
Username :
Classname : vB_Database

Please advise. I like the concept but can't use it yet.

Biggles

[Saviour]

Abe...look at my previous post.

[Abe1]

I think i got it. Just a file change. Will update in a few min. Only effects vb3.6.x users.

[mc0676]

Abe1 i've uninstalled this mod and i attend correction of the error but WHY i receive THIS error after i've unistalled ?!?!!?!?

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT *
FROM vb_thread AS thread
LEFT JOIN vb_force_read_users AS force_read_users ON (thread.threadid = force_read_users.force_read_threadid AND force_read_users.force_read_userid = '418')
WHERE thread.force_read = '1' AND (thread.force_read_expire_date = '0' OR thread.force_read_expire_date > '1204728706') AND (force_read_usergroups = '' OR force_read_usergroups LIKE '%-25-%' OR force_read_usergroups LIKE '%-26-%' OR force_read_usergroups LIKE '%-2-%') AND (force_read_forums = '') AND force_read_users.force_read_userid IS NULL
ORDER BY force_read_order ASC;

MySQL Error : Table 'vwgolfcommunity_com_vb.vb_force_read_users' doesn't exist
Error Number : 1146
Date : Wednesday, March 5th 2008 @ 03:51:46 PM
Script : http://www.vwgolfcommunity.com/vbull...gc_chatbox.php
Referrer : http://www.vwgolfcommunity.com/vbulletin/index.php
IP Address : 79.7.143.76
Username : diac82
Classname : vB_Database

[Abe1]

Zip file updated. admincp/force_read_thread.php file updated to fix error for vb3.6.x users.

[Abe1]

Originally Posted by mc0676

Abe1 i've uninstalled this mod and i attend correction of the error but WHY i receive THIS error after i've unistalled ?!?!!?!?

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT *
FROM vb_thread AS thread
LEFT JOIN vb_force_read_users AS force_read_users ON (thread.threadid = force_read_users.force_read_threadid AND force_read_users.force_read_userid = '418')
WHERE thread.force_read = '1' AND (thread.force_read_expire_date = '0' OR thread.force_read_expire_date > '1204728706') AND (force_read_usergroups = '' OR force_read_usergroups LIKE '%-25-%' OR force_read_usergroups LIKE '%-26-%' OR force_read_usergroups LIKE '%-2-%') AND (force_read_forums = '') AND force_read_users.force_read_userid IS NULL
ORDER BY force_read_order ASC;

MySQL Error : Table 'vwgolfcommunity_com_vb.vb_force_read_users' doesn't exist
Error Number : 1146
Date : Wednesday, March 5th 2008 @ 03:51:46 PM
Script : http://www.vwgolfcommunity.com/vbull...gc_chatbox.php
Referrer : http://www.vwgolfcommunity.com/vbulletin/index.php
IP Address : 79.7.143.76
Username : diac82
Classname : vB_Database

Do you have some hack that caches plug-ins?