View Full Version : Moderators Functions - Force Users to Read a Thread
boomer_ie
01-16-2009, 04:15 AM
This mod is not working for me either on vb 3.8.0, instructions followed, not showing anything in edit tools nor does the add new thread through admincp work it reports saved successfully but does not actually save!
rainyleaves
01-20-2009, 01:53 PM
I have installed the hack succesfull but they dont works..
My board is 3.8.0 Gold
I add New thread and I saved it in order display.
Works fine.
but nothing display on forum pages.
Frank Sinatra
01-22-2009, 08:29 PM
thankss works perfect :p
installed :up:
SimpleFTA
01-23-2009, 04:02 AM
Hi Abe, glad to see you're still supporting this mod.
This is a very useful hack, thanks. Is it possible to add an option to customize text instead of just using "The administrators want you to view a thread before you continue to browse the forum."?? If I could customize the message and edit font style this would be perfect mod for what I need.
-James
KelliH
01-24-2009, 07:33 PM
Installed in vB 3.7.3 Patch Level 1
In "Threads and Posts" drop down menu in Admin cp there is no "Force Thread" link
However, I can access it by typing the url
mywebsite.net/admincp/force_read_thread.php
Any idea why this is happening or how to fix it? Thanks.
Frank Sinatra
01-26-2009, 09:59 AM
still working perfect here, but..
there's a way to make it work with vbadvanced? if i have my forum in other folder, the url is:
http://www.xxxx.com/forum/showthread.php?t=3225
and vbadvanced show this:
http://www.xxxx.com/showthread.php?t=3225
geting error 404
thanks for any help :p
puertoblack2003
01-31-2009, 03:47 AM
not working for 3.8 when saving setting.It doesn't save at all
davidan
01-31-2009, 10:48 PM
Any chance this will get updated to work with 3.8.x? This is probably the most useful mod ever, and Miss it. The thing quit working when I upgraded to 3.8.0 and I had to remove it.
BlackJacket
02-05-2009, 02:26 PM
Please get this working for 3.8.x
Much needed!
HossMon
02-05-2009, 05:29 PM
Hey Abe could you read my post here plz
https://vborg.vbsupport.ru/showpost.php?p=1723433&postcount=602
I'm running 3.6.9 and I think I may have found the issue...
Ok here's Query
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 = '1')
WHERE thread.force_read = '1' AND (thread.force_read_expire_date = '0' OR thread.force_read_expire_date > '1233786721') AND (force_read_usergroups = '' OR force_read_usergroups LIKE '%-6-%') AND (force_read_forums = '') AND force_read_users.force_read_userid IS NULL
ORDER BY force_read_order ASC
But then I notice this for the force_read_users table...
1 SIMPLE force_read_users eq_ref PRIMARY PRIMARY 8 const,bst_db.thread.threadid 1 Using where; Using index; Not exists
Using where; Using index; Not exists
I believe that is what is driving MySQL nuts
jayzy1
02-14-2009, 03:22 PM
working fine on my v3.81
Get Through Guides (http://www.getthroughguides.co.uk/forum/index.php)
works gread also on 3.8.1 thx installed
crouzmind
02-18-2009, 05:16 PM
sir can i use this mod on VBULLETIN 3.8.1 ????
habanero68
02-22-2009, 06:05 AM
please explain how I use it in 3.8.1. I am not working, needs to be done. please
mrtroybaker
03-05-2009, 07:50 PM
Is there going to be an upgrade for Vbullite 3.8.x? I installed this version and everything works fine until after save. It says everyting saved but nothing shows up under "display order" Im guessing this is due to the different versions. Please help. This is one of the most useful hacks I have found.
HaS?R
03-11-2009, 08:18 PM
Thanks.Looks Nice.
BlueNinjaGo
03-13-2009, 07:13 PM
Installed and works great once you learn to use it correctly. Great job.
fr3akstar
03-20-2009, 08:08 AM
I have installed this on 3.8.1 but I don't get the option and I can't see the option to enable/diable per usergroup, its enabled in the products/plugins menu. Do you have to do something else after install?
Raptor
03-20-2009, 01:33 PM
yep works just fine on 3.8.1 PL1. If you are having problems then your board isn't right.
fr3akstar
03-20-2009, 01:48 PM
Thats a useful post Raptor. The board is a virgin 3.8.1 install. Thanks for your input though... not.
BlueNinjaGo
03-20-2009, 02:48 PM
I have installed this on 3.8.1 but I don't get the option and I can't see the option to enable/diable per usergroup, its enabled in the products/plugins menu. Do you have to do something else after install?
Can we get a screen shot perhaps? Might help us get a better idea of the issue you're facing.
fr3akstar
03-20-2009, 04:36 PM
Right it is working to an to an extent, the option does appear within the AdminCP to set a thread to Force Read. However I was under the impression that you also received an option within the Thread Tools for each thread. A friend is using version 1.1 of this mod and it works that way... Is that just not part of this mod anymore?
fr3akstar
03-20-2009, 04:46 PM
I don't have any options within USergroups to enable or disable the ability to set a thread to force read either, but from the screenshots I'm beginning to think this mod doesn't offer these options...
creative-friend
03-24-2009, 05:29 PM
Not working.....
BlueNinjaGo
03-24-2009, 06:27 PM
From what is provided, and from what I experienced when using it, only admins can say which threads are forced read. No one else.
And you can only set it in the ACP, not in the thread...
fr3akstar
03-24-2009, 07:08 PM
Ok well as I said I am a member of a site where they used the version 1.1 of this mod and it does have that capability which makes me wonder why this mod is now less capable than its predecessor.
creative-friend
03-25-2009, 08:46 PM
wel i tired to do it but its no working...
fr3akstar
03-26-2009, 03:08 AM
Its in the AdminCP at the bottom of the threads section like this:
https://vborg.vbsupport.ru/external/2009/03/17.jpg
c.oper
03-26-2009, 01:39 PM
Installed! Working fine in 3.8.1 PL1
creative-friend
03-28-2009, 07:02 PM
Its in the AdminCP at the bottom of the threads section like this:
https://vborg.vbsupport.ru/external/2009/03/17.jpg
yeah i know i did everything but when i made any thread for force nothing happend
check the Screenshot
https://vborg.vbsupport.ru/external/2009/04/26.jpg
Kobra Khan
03-29-2009, 06:52 PM
gr8 stuff but most of the time this doesn't work right for my members or my self
getting 404 error msg , using v 3.8.0
anyone know how to fix this, plz let me know.....thanks
geni57
03-30-2009, 06:43 PM
clicking uninstall. . does not work
StuRed
04-02-2009, 07:42 PM
Not working here on 3.8.1.
I did have it running on an older version.
Vitaly
04-05-2009, 01:53 PM
Abe1, lack of indexes seriously f@#kup mysql server when you have "forced" threads.
ALTER TABLE `thread` ADD INDEX `force_read` ( `force_read` , `force_read_expire_date` ) Test your mods with slow queries log option "log_queries_not_using_indexes" :)
It's also possible to optimize queries. Instead of checking forced threads at each page loads, status can be cached in sessions table. For example, to check only once per hour.
HossMon
04-06-2009, 09:35 AM
Abe1, lack of indexes seriously f@#kup mysql server when you have "forced" threads.
ALTER TABLE `thread` ADD INDEX `force_read` ( `force_read` , `force_read_expire_date` ) Test your mods with slow queries log option "log_queries_not_using_indexes" :)
It's also possible to optimize queries. Instead of checking forced threads at each page loads, status can be cached in sessions table. For example, to check only once per hour.
I believe this is exactly what I pointed out in this post.
https://vborg.vbsupport.ru/showpost.php?p=1735383&postcount=261
Question is why does it seem to only affect some of us?
Vitaly
04-06-2009, 03:20 PM
Question is why does it seem to only affect some of us?
I guess, that affects everybody :) . There are no reasons to guess - just make your sql-server log queries without indexes, and you will see almost all suspitious hacks.
Add that index and you'll be very surprised with server load. Don't forget to compare results :)
I like Abe1's modifications and his coding style. But I'm very surprised with DB design "holes". Have published fixes for Thanks & Groan hacks in apropriate threads.
mtlcore
04-07-2009, 12:53 AM
does this work on the latest?
lille L
04-07-2009, 08:41 AM
Installed! Working fine in 3.8.1 PL1
How?
I've innstalled it, and can make messages, but It dosent work out in the forum. No one is forced to anything... :D :D
BlueNinjaGo
04-07-2009, 03:48 PM
Did you go to the Admin CP -> Threads and post -> Force read ...?
HossMon
04-07-2009, 08:06 PM
Vitaly I hope you don't mind, but I sent you a PM regarding this issue.
HossMon
04-07-2009, 09:09 PM
Thank you again Vitaly!
As for the rest of you who have this installed...
I highly recommend you run Vitaly's query on your database and create the needed index. I ran it on mine, re-enabled this hack, and walla no more high server loads or errors.
I used phpMyAdmin to run the query, which worked just fine. However, I would recommend you turn off your board prior to running it, Or do so during a period of light board use.
HossMon
04-08-2009, 02:17 PM
How?
I've installed it, and can make messages, but It dosent work out in the forum. No one is forced to anything... :D :D
lille, one thing that is not explained very well...
When you create/add a new thread to be force read, in the box for thread ID, do not enter the complete link to the thread, enter only it's ID number.
For example, if you were going to 'force' this thread. You would enter ID number 172155
As for working in v3.8x, I cannot speak to that as I am running an older version.
tikichick
04-09-2009, 02:33 AM
Cannot install... I get "Invalid File". Any suggestions?
update: nevermind, I was trying to install the file in the xml folder. When I added the new product using the other xml file (not in the ftp folders) it worked like a charm.
Thanks for the mod!
Farman
04-13-2009, 06:04 PM
Thanks 4 sharing....I installed it on my vb 3.8.1, configured it, but nothing happen at the main page. I mean the Message is not appearing on the page for visiting the force thread. Any one tried it on 3.8.x?
trucker01
04-14-2009, 05:30 AM
well i think most if not all running the latest have the same problem with this hack. :(
it installs fine you can enter message and thread id but it doesnt save it meaning it isnt showing up as saved as shown in the Pics provided. btw these are the same Pics he used in the earlier version of this hack.
Developer Last Online: Mar 2009
and seeing that he has been last online in march i wonder if there will be any support at all in the future
i think i found what i did wrong here.
use an ftp programme and upload the folders, to the cpanel not the files within them
you would upload them to publichtml and allow overwrite
dont use the inbuild upload application
it worked for me :D
mariocaz
04-17-2009, 02:57 AM
Is this will be updated ??? also is not working for me in my 3.7.5 I can?t save the threads that I want to my users force to read. :(
It is an awesome hack so please help us!!!
creative-friend
04-17-2009, 11:23 AM
no 1 even helping me....
HossMon
04-18-2009, 04:58 PM
mariocaz, did you read this https://vborg.vbsupport.ru/showpost.php?p=1786603&postcount=293 and enter only the thread ID number after creating/posting the desired thread on your board?
creative-friend, I'd be happy to help with what I can. But your going to need to give us some more detailed information regarding what your issues are?
mariocaz
04-19-2009, 05:07 AM
Hi HossMon, thank you for answer me!!!
Yes only I am putting the ID of the thread and I clicked on Save but is not saving nothing, I am using 3.7.6, which version are u using ??
creative-friend
04-22-2009, 06:44 PM
mariocaz, did you read this https://vborg.vbsupport.ru/showpost.php?p=1786603&postcount=293 and enter only the thread ID number after creating/posting the desired thread on your board?
creative-friend, I'd be happy to help with what I can. But your going to need to give us some more detailed information regarding what your issues are?
When I select some thread it dont come like this
https://vborg.vbsupport.ru/external/2009/04/26.jpg
its just like that nothing happens what ever i do...
https://vborg.vbsupport.ru/external/2009/04/26.jpg
masterme
04-24-2009, 12:22 PM
Same here, added only forum ID, for testing chosen the admingroup only and forumwide, did the hookup adding as writen in the instructions txt, but same as above. I run 3.6.5
mariocaz
04-24-2009, 02:42 PM
Help us please!!!!
speedway
04-26-2009, 06:25 PM
Same here. Was working fine on 3.7.5, upgrade to 3.8.2 an nothing. Even uninstalled and reinstalled with no luck. Help would be appreciated.
GSeybold
04-26-2009, 08:02 PM
Hello
We tried this but still not working. No threads are saved. Says "Saved Successfully" but no threads apear.
lille, one thing that is not explained very well...
When you create/add a new thread to be force read, in the box for thread ID, do not enter the complete link to the thread, enter only it's ID number.
For example, if you were going to 'force' this thread. You would enter ID number 172155
As for working in v3.8x, I cannot speak to that as I am running an older version.
speedway
04-27-2009, 02:33 AM
When I select some thread it dont come like this
https://vborg.vbsupport.ru/attachment.php?attachmentid=76757&d=1204721719
its just like that nothing happens what ever i do...
https://vborg.vbsupport.ru/external/2009/04/26.jpg
Same here. Was working fine on 3.7.5, upgrade to 3.8.2 an nothing. Even uninstalled and reinstalled with no luck. Help would be appreciated.
Ok, all you guys having the same problem as me, a question...
Are you putting in the Thread ID or the Post ID? I am running VBSEO on my site and inadvertently put the POST id from the url and it didn't work (as above). Found the THREAD id and it DID WORK.
Moral of the story is make sure you are entering the Thread ID, not the Post ID.
Cheers
mariocaz
04-27-2009, 09:59 PM
I am entering the thread ID I am very sure, because this mod was working perfectly a few time ago, but now nothing.
Please help us!!
creative-friend
04-28-2009, 11:56 AM
Its Working Now...thanks
mariocaz
04-28-2009, 07:15 PM
But how ??
The Realist
04-30-2009, 04:52 PM
This does work.
Just add the thread ID and you then need to highlight what group has permission to view the forced thread and also highlight the post in questions section.
Once this has been done the hack works.
Regards
Bluefin221
05-01-2009, 02:33 PM
This also doesn't work for me, it does not save any option or indeed show up as any of the graphics.
BlueNinjaGo
05-01-2009, 06:55 PM
It worked for me w/o any edits
SVTCobraLTD
05-02-2009, 03:44 PM
Installed on 3.6.11 but it does not seem to be working. The one that is supposed to be forced to be read is still saved in the admincp but it is not forcing me to read it.
Dan Clement
05-03-2009, 11:41 PM
I can see this coming in handy in future. Thanks a lot! :D
SVTCobraLTD
05-05-2009, 10:28 AM
Installed on 3.6.11 but it does not seem to be working. The one that is supposed to be forced to be read is still saved in the admincp but it is not forcing me to read it.
Anyone?
HabboLan
05-06-2009, 12:21 AM
It's not allowing me to save the thread I am trying to force readers to view.
It says "Saved Successfully", but then doesn't work.
vithorius
05-06-2009, 07:56 AM
:eek: I have this situation on 3.6.11:
The hack works, but NEVER stops bugging me...
I mean, once I read the thread, it should be ok, but then... It gives me again the message that "the administrator wants me to read a thread..." and again, and again, and again...
Well... just what is happening? :confused:
I imported the xml through the admin panel, and then I went to FTP the files over, but I get an sql error, and I can't access the adminpanel or the site forums either.
Is there some way to reverse what I have done, or should we restore the latest backup (which is fairly old)
I guess what happened is the xml executed before the 2 folders were uploaded by FTP, so it didn't quite complete itself.
Is there a way to make the xml run again?
Thx
Total666
05-18-2009, 02:14 AM
I imported the xml through the admin panel, and then I went to FTP the files over, but I get an sql error, and I can't access the adminpanel or the site forums either.
Is there some way to reverse what I have done, or should we restore the latest backup (which is fairly old)
I guess what happened is the xml executed before the 2 folders were uploaded by FTP, so it didn't quite complete itself.
Is there a way to make the xml run again?
Thx
Do this
disable all plugins.
in includes / config.php
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php
define('DISABLE_HOOKS', true);
then you can disable the force thread in plug in manager ..
then remove the define('DISABLE_HOOKS', true);
Well its totally hosed now, gonna need a re-install
Well it came back for a few minutes, I got back in with no plugins working.
I disabled this plugin, (removed the disable plugins code ) then I get a database error, then I just get a blank page when going to the forum page.
Any idea what file will still have remnants of the botched install?
Thanks
Total666
05-18-2009, 03:38 PM
Well it came back for a few minutes, I got back in with no plugins working.
I disabled this plugin, (removed the disable plugins code ) then I get a database error, then I just get a blank page when going to the forum page.
Any idea what file will still have remnants of the botched install?
Thanks
disable all the plugins ( with the code ) . then uninstall the force thread from the plug in manager ..
then re-enable the plugins (with the code )
then start again ..
Total666
05-18-2009, 03:39 PM
I imported the xml through the admin panel, and then I went to FTP the files over, but I get an sql error, and I can't access the adminpanel or the site forums either.
Is there some way to reverse what I have done, or should we restore the latest backup (which is fairly old)
I guess what happened is the xml executed before the 2 folders were uploaded by FTP, so it didn't quite complete itself.
Is there a way to make the xml run again?
Thx
you should of ftped the files FIRST , then run the xml ...
HossMon
05-19-2009, 01:30 PM
It may have altered a table and currupted it on uninstall,
SSH into your server and run
mysqladmin flush-hosts
mysqladmin flush-tables
mysqladmin flush-threads
Then Stop mysqld
/etc/rc.d/init.d/mysql stop (may not be same on your server)
CD to your database dir
cd /var/lib/mysql/(yourdb)
And run
myisamchk -m *.MYI
Repair any tables that need so
myisamchk -B -r force_read_users.MYI
ExtremeDarkness
05-23-2009, 11:42 PM
I need a 3.8.2 version of this please, since this won't work on my forum's version.
yamahapaul
05-24-2009, 10:01 AM
I need a 3.8.2 version of this please, since this won't work on my forum's version.
me too please :up: :)
marshal_ramdev
05-31-2009, 08:00 AM
awesome :)
SVTCobraLTD
05-31-2009, 12:25 PM
Had this installed on 3.6.11 but members could no longer log into the site. Some could login but most could not. Anyone else have this issue?
GraphiX2004
06-01-2009, 10:14 PM
is this mod going to be updated for 3.8.1 or 3.8.2, it really anoys me how such a feature is an essential one but is not built into the stock build already
we have to now hope and wait the coder updates this otherwise it's useless from what i see
on a v3.8 board, what do these people at vbulletin think when they are designing it at all..
"i know lets add an option to the stock files where the admin's can make someone
read an important post from another admin before they continue great this sound like common sense, i know since this is a great idea and should be included but for the hell of it we wont that is just making it too easy for our customers and actually adding value to the cost of the licence for once.
Please can we have an update on this we got over 1,000 + members coming back
to our new forums and i now find out i can't make em read the new thread about changes.
Kobra Khan
06-03-2009, 07:29 PM
i have seen it on one site working on 3.8.2 version
wondering wut he did to make it work ??
Loki12
06-08-2009, 04:57 PM
i have seen it on one site working on 3.8.2 version
wondering wut he did to make it work ??
It works on my 3.8.1.
RichieBoy67
06-09-2009, 03:21 AM
I am upgrading a 3.6.8 version of this mod--Will a simple product overwrite upgrade this or will it cause problems?
Thanks
adamskiii
06-11-2009, 12:30 AM
not working for 3.8.2. Does not save the thread you specify.
Bro_Joey_Gowdy
06-12-2009, 04:18 AM
This needs updated to 3.8.x with an added feature "force users to read and reply to a thread".
captainbohica
06-19-2009, 06:13 AM
I imported the xml through the admin panel, and then I went to FTP the files over, but I get an sql error, and I can't access the adminpanel or the site forums either.
Is there some way to reverse what I have done, or should we restore the latest backup (which is fairly old)
I guess what happened is the xml executed before the 2 folders were uploaded by FTP, so it didn't quite complete itself.
Is there a way to make the xml run again?
Thx
Do this
disable all plugins.
in includes / config.php
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php
define('DISABLE_HOOKS', true);
then you can disable the force thread in plug in manager ..
then remove the define('DISABLE_HOOKS', true);
Well it came back for a few minutes, I got back in with no plugins working.
I disabled this plugin, (removed the disable plugins code ) then I get a database error, then I just get a blank page when going to the forum page.
Any idea what file will still have remnants of the botched install?
Thanks
disable all the plugins ( with the code ) . then uninstall the force thread from the plug in manager ..
then re-enable the plugins (with the code )
then start again ..
I had a similar error and was able to disable the plugins through the config file, disabled/uninstalled the force read plugin....
but when I logged in again, im back to square one with my error msg:
Warning: Unknown([path]/madp/detection.php): failed to open stream: No such file or directory in [path]/includes/functions_login.php(185) : eval()'d code on line 3
any other ideas how I can fix this?
captainbohica
06-19-2009, 09:11 AM
It may have altered a table and currupted it on uninstall,
SSH into your server and run
mysqladmin flush-hosts
mysqladmin flush-tables
mysqladmin flush-threads
Then Stop mysqld
/etc/rc.d/init.d/mysql stop (may not be same on your server)
CD to your database dir
cd /var/lib/mysql/(yourdb)
And run
myisamchk -m *.MYI
Repair any tables that need so
myisamchk -B -r force_read_users.MYI
help a n00b out.. what does all this mean ? lol
The Donkey Farm
07-05-2009, 03:52 PM
Works great for me in 3.8.1! Didn't work at first till I read replies made here and then made sure to enter in the thread ID. I was entering the post ID before. For any still having trouble make sure to just mouse over the thread title in your subforum and then use the last set of numbers shown in the url to enter into the first field of the force read then make sure to have your usergroups plus location highlighted then click save.
spillage
07-21-2009, 10:27 AM
Can you use an Announcement ID in place of a Thread ID for the Force Read?
ruger
08-10-2009, 05:56 AM
Had to remove since it was interfering with AWC Donations system.
bluej
08-20-2009, 12:53 AM
another great mod with no support, what a shame :(
turbosatan
08-21-2009, 03:10 PM
i have a strange issue.
i want all users to be forced to read a thread when they join.
so i added this and it seems to work fine most of the time. however if someone clicks on the link through to VBadvanced link directory then it just goes to that page. after that the user cannot login unless i reset the password.
Any ideas?
TheInsaneManiac
08-22-2009, 09:56 AM
Just got this email:
Invalid SQL:
INSERT INTO vb_force_read_users
(force_read_userid, force_read_threadid)
VALUES
('19096', '7639');
MySQL Error : Duplicate entry '19096-7639' for key 1
Error Number : 1062
Request Date : Saturday, August 22nd 2009 @ 03:48:47 AM
Error Date : Saturday, August 22nd 2009 @ 03:48:47 AM
Script :
Referrer :
IP Address :
Username : hellsingdeath
Classname : vB_Database
MySQL Version :
pablete
08-24-2009, 02:54 PM
can i force to read my forum rules before to continuo reading th forum?
what i have tu put in the AdCP that or i have to create a new thead with the rules and after i put the id of this thread?
Thank's
bluej
08-25-2009, 08:49 AM
can i force to read my forum rules before to continuo reading th forum?
what i have tu put in the AdCP that or i have to create a new thead with the rules and after i put the id of this thread?
Thank's
you could try this
https://vborg.vbsupport.ru/showthread.php?t=177559
timberball
08-26-2009, 05:47 AM
can i use this for a 3.8.x forum?
MikeWarner
08-29-2009, 04:54 PM
Great hack - I'll be using it soon as we are implementing new classifieds ads rules.
sat2006
08-29-2009, 07:19 PM
this products no working on vb3.8.3
why?
Nokia Tech
08-30-2009, 11:00 AM
Hi, Many thanks for this, Its great. Just installed and works perfect.
I have a small query, i am hoping you could help me with,
When you get the prompt saying you have to read the thread, i have noticed that its showing my older forum name, Would you possibly know where i can change this title.
I have searched through the ACP but cant find anything, Below is a pic of the problem.
Thanks for your help.
http://www.crazynokia.co.uk/AA.jpg
aleinside
09-01-2009, 06:59 AM
thanks you. it works fine for me with 3.8.4
goshalim
09-07-2009, 06:05 AM
This is an exellent mod !!!! I was waiting for that for a long time.
I have only one question .
Making someone to read something is very good , but do you thing that there is a option to force someone to accept or reject the post that he is reading ?
Like for exable o force someone to read one of my posts. But after reaning the post i give him the opriton like when he is first registering to accept it.
Awaiting for ideas please
s810car
09-11-2009, 12:16 AM
Just some friendly developer advice, you can chose to look at this and implement or not, but I would suggest either following what I did or the developer may have a better solution I didn't think of. I ran an EXPLAIN query on this SELECT query since it showed up in my slow queries log
$force_thread = $db->query_first("
SELECT *
FROM " . TABLE_PREFIX . "thread AS thread
LEFT JOIN " . TABLE_PREFIX . "force_read_users AS force_read_users ON (thread.threadid = force_read_users.force_read_threadid AND force_read_users.force_read_userid = '".$vbulletin->userinfo['userid']."')
WHERE thread.force_read = '1' AND (thread.force_read_expire_date = '0' OR thread.force_read_expire_date > '".TIMENOW."') AND (". implode(' OR ', $where_usergroups) .") AND (". implode(' OR ', $where_forums) .") AND force_read_users.force_read_userid IS NULL
ORDER BY force_read_order ASC
");
Obviously I entered in some values into it to make the variables work in phpMyAdmin. Here's what i found with my relatively small forum:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE thread ALL NULL NULL NULL NULL 11877 Using where; Using filesort
1 SIMPLE force_read_users eq_ref PRIMARY PRIMARY 8 const,temp1.thread.threadid 1 Using where; Using index; Not exists
I added a index to the 'thread.force_read' row (since its boolean and a super small length) and heres the improvement
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE thread ref force_read force_read 1 const 18 Using where; Using filesort
1 SIMPLE force_read_users eq_ref PRIMARY PRIMARY 8 const,temp1.thread.threadid 1 Using where; Using index; Not exists
Should give you a MUCH more efficient query, I only have a few threads in my forum that we use the force read for (like for new rules), so I would think a site that uses this all the time with a lot more threads would see a substantial improvement
PS apologize for the terrible formatting of the exlpain query, never could line up columns easy on vbulletin :(
socalsoccer
09-26-2009, 03:26 PM
3.8.1 error XML Error: Empty document at Line 1 when importing product.
JohnBee
10-03-2009, 02:00 AM
I found the original message could be a little dry.
Alisa Lindsay
10-03-2009, 11:51 AM
Downloaded, but not used yet. Looks like a great mod though.
RomainVL
10-17-2009, 04:25 AM
DL and in use now. It works perfectly on 3.8.4 ;)
griffinzx10
11-02-2009, 01:09 PM
does anyone know if this will also work on version 3.8.3?
griffinzx10
11-02-2009, 01:10 PM
DL and in use now. It works perfectly on 3.8.4 ;)
does anyone know if this will also work on version 3.8.3?
never mind, saw the last post...
griffinzx10
11-02-2009, 01:27 PM
ok just installed and it isnt working, when i put the info in the fields, and it says saving, the list that should show the threads i want to be viewed keeps showing as empty. Not sure what i did wrong, any help would be appreciated.
griffinzx10
11-03-2009, 07:47 AM
nevermind again, got it working, great hack, thanks
bluej
11-14-2009, 05:50 PM
nevermind again, got it working, great hack, thanks
i am having the same problem, do you mind sharing what you did to fix it?
bluej
11-14-2009, 06:13 PM
i am having the same problem, do you mind sharing what you did to fix it?
ok, got it, only need to enter the thread ID number and not the whole link to it :o
Dr.LoVe
11-15-2009, 01:58 AM
Does it work with 3.8.X Versions ??
taffy056
11-15-2009, 09:48 AM
This hack works with 3.8.x and happily it works with 4.0 also
Wired1
12-04-2009, 06:40 AM
Any ideas what would cause this ??
http://www.extremetesting.tv/weird.gif
Just figured out what it was and fixed it. It's an issue with the foreach loops that pulls the usergroup and location data. It doesn't clear out the temp array between loops, so it repeats the information from the preceding loops.
The database appears to be fine, although it was causing odd looping issues for me which I can't explain, but either way it works just fine for me now!
To fix it, you'll need to edit admincp\force_read_thread.php.
FIND:
print_cells_row($cell);
AFTER add:
unset($usergroups);
unset($forums);
MikeWarner
12-05-2009, 09:22 AM
Am I missing something - a setting maybe? I've had this installed for a few months and used it for the first time today, but I'm having a problem with it.
It all appeared to work fine, but it keeps telling people to read the thread over and over, instead of only asking people once.
Any help would be much appreciated. Thanks
Wired1
12-07-2009, 12:46 AM
Try my fix right above your post. Fixed the problem for me, although it really shouldn't have.
Fungsten
12-18-2009, 04:46 PM
Other suggestion- Instructions are not clear, I think some people may be taking an entire thread URL and pasting it into the thread ID box. What goes there is only the number of the thread, nothing else. That's why some of you do not see the thread. Try just he thread id number...
:up: Thank you!!
Fungsten
12-19-2009, 07:29 PM
:(
Any ideas?
Leo Brazil
01-06-2010, 09:43 AM
This hack works with 3.8.x and happily it works with 4.0 also
I've been using this one from a long time and I can confirm it works perfectly on 3.8.4
But are you sure this one can work good on 4.0 ? That would be great !!
was working tillthe upgrade 4.0.1 :(
SemperFideles
01-14-2010, 01:04 AM
was working tillthe upgrade 4.0.1 :(
Ditto.
Is anyone working to update this mid it is really useful for my forum
Covert-OPs_
01-27-2010, 02:24 AM
Damn this was one of my favorite apps...it sucks that it isn't working anymore.
Forum Lover
02-01-2010, 09:16 AM
Ah.. I am gonna miss it. :(
scahoy
02-02-2010, 10:38 PM
Can some one tell me where to find how to install this ? I am really new at this.
cheers
Jdm Ej1 Coupe
02-03-2010, 11:10 PM
working on 4.0.1 removed it all previous downloaded it again and installed with no issues!
Supramania
02-08-2010, 01:31 PM
working on 4.0.1 removed it all previous downloaded it again and installed with no issues!
Same here - this works on 4.0.1
karnevil
02-08-2010, 08:45 PM
Is there an update for 3.8 at all?
The option of force read does not appear in Threads & Post tab in ACP
KevinGupta
02-09-2010, 12:26 PM
waiting for vB 4.0.x version :D
Supramania
02-13-2010, 04:14 PM
Same here - this works on 4.0.1
I take that back - I had to disable it - it works 100% fine on the forum, but it makes the CMS have a "white page" error.
I hope someone takes this on for 4.0.X - it's a valuable tool for us and we really miss it.
Edit: Here's what shows (anonymized) in the error log when this plugin is enabled in 4.0.1 and you try to access the main content.php page if it helps at all:
[Sat Feb 13 11:43:37 2010] [error] [client xx.xx.xx.xx] PHP Fatal error: Call to a member function query_first() on a non-object in /path/to/my/site/htdocs/forums/packages/vbcms/controller/content.php(256) : eval()'d code on line 61
RedHacker
02-18-2010, 10:37 AM
Can be update to the version 4....?
Reef Man
02-19-2010, 08:16 PM
Does this work with Version 4.0.2?
tiengnhat
02-21-2010, 01:44 AM
Hello
Can you update this mod to VBB 4.x?
Thanks you!
Supramania
02-21-2010, 05:43 AM
Guys, if you look at everything in Abe's sig, everything he's done is version 3.
I suspect he's not running 4 on his board - once he does I'm sure we'll get a 4.x version.
mgurain
02-22-2010, 08:06 AM
This need to be ported to 3.8.x right ?
Supramania
02-25-2010, 02:10 AM
It ran fine on 3.8 for me. I need one that works on 4.0.2pl1
LifeAndDoctrine
02-26-2010, 10:51 AM
Anyone using it on 4.0.2. pl 1 and getting it working ?
Freddy BdV
02-27-2010, 07:14 PM
We run the vBulletin V 3.7.3 together with "Force a user to read a thread" V2.0
I can't find any possibilty in the ACP for editing the text of the announcement. This is really needed because we run a German forum and users need to understand the content.
Any useful hint is welcome. TXS in advance.
Supramania
02-27-2010, 08:42 PM
We run the vBulletin V 3.7.3 together with "Force a user to read a thread" V2.0
I can't find any possibilty in the ACP for editing the text of the announcement. This is really needed because we run a German forum and users need to understand the content.
Any useful hint is welcome. TXS in advance.
It's a phrase - you can find it in the ACP, or you can just edit the product-abe1_forceusersreadthread.xml and reupload it (and check overwrite):
- <phrase name="forceusersreadthread_read_thread" date="1204605671" username="Abe" version="">
- <![CDATA[
The administrators want you to view a thread before you continue to browse the forum.<br />
<br />
You can view the thread <a href="showthread.php?t={1}">here</a>.
]]>
</phrase>
Supramania
02-28-2010, 03:28 PM
Update: I just turned this back on in 4.0.2 and it's working fine. Both blogs & articles seem to work now.
maidos
03-03-2010, 02:07 PM
using 4.0.2 aswell but members are having issues of constantly being force read the same thread over and over again
Leo Brazil
03-03-2010, 07:10 PM
It cracks down vBCMS when it's on. On forums works fine.
LifeAndDoctrine
03-05-2010, 04:14 PM
Working on 4.0.2 well, so far.
Covert-OPs_
03-07-2010, 01:40 PM
Update: I just turned this back on in 4.0.2 and it's working fine. Both blogs & articles seem to work now.
The blog does work but it DOES NOT work with CMS.
Supramania
03-07-2010, 02:32 PM
The blog does work but it DOES NOT work with CMS.
The built in CMS? Do you mean it doesn't function? I actually like that it doesn't execute on the front page.
Or are you saying you get the CMS white screen error?
If so, you might want to try disabling all of your mods except this one, and then start turning them on one at a time until your CMS fails. If you're getting the white screen it's likely an incompatibility with another modification.
It works on my system with all 5 of my themes and the 37 other mods I have installed on my site.
Covert-OPs_
03-07-2010, 02:53 PM
The built in CMS? Do you mean it doesn't function? I actually like that it doesn't execute on the front page.
Or are you saying you get the CMS white screen error?
If so, you might want to try disabling all of your mods except this one, and then start turning them on one at a time until your CMS fails. If you're getting the white screen it's likely an incompatibility with another modification.
It works on my system with all 5 of my themes and the 37 other mods I have installed on my site.
I get a white screen error, if I disable the force read mod then the CMS works again. I'm curious how you got it to work did you do anything differently then in the instructions? Also what version of VB are you running?
Supramania
03-07-2010, 04:05 PM
I get a white screen error, if I disable the force read mod then the CMS works again.
Like I said above, try disabling your other mods. It's likely a conflict with another mod on your site.
I'm curious how you got it to work did you do anything differently then in the instructions?
Nothing special.
Also what version of VB are you running?
4.0.2pl1
Covert-OPs_
03-07-2010, 04:42 PM
Like I said above, try disabling your other mods. It's likely a conflict with another mod on your site.
You might have skipped over where I said that it only crashes when I enable the Force Read mod. I believe the issue is that I'm not 4.0.2 yet. We just did a host migration and apparently I updated the old host site...doing now to test on the live server.
Supramania
03-07-2010, 05:12 PM
You might have skipped over where I said that it only crashes when I enable the Force Read mod. I believe the issue is that I'm not 4.0.2 yet. We just did a host migration and apparently I updated the old host site...doing now to test on the live server.
Ah, ok in this case I'm sure that's it. On 4.0.1 I had problems. 4.0.2 fixed it.
However what I was saying is valid - in many cases I've found that it's two mods combined that cause a problem. In this case that's not it, but keep it in mind. I'm running a lot of mods plus a bunch of custom code - how things fit together in this 4 series isn't always intuitive or obvious.
Due to the SQL injection exploits in 4.0.1, you really need 4.0.2pl1 anyway.
Covert-OPs_
03-07-2010, 05:15 PM
Ah, ok in this case I'm sure that's it. On 4.0.1 I had problems. 4.0.2 fixed it.
However what I was saying is valid - in many cases I've found that it's two mods combined that cause a problem. In this case that's not it, but keep it in mind. I'm running a lot of mods plus a bunch of custom code - how things fit together in this 4 series isn't always intuitive or obvious.
Due to the SQL injection exploits in 4.0.1, you really need 4.0.2pl1 anyway.
Gotcha, I understand what you were saying now. I just finished the upgrade to 4.0.2 and everything is perfect, thanks again for your help!
we_lol
03-10-2010, 04:48 AM
<font size="2">hello..
this hack is probably working good, but the (Enable This Hack for Guests) Option not work. please help.</font>
Front Range 4x4
04-09-2010, 09:51 PM
A new install in 4.0.2 is not working, for those with it working was it installed prior to the upgrade?
mikem164
04-23-2010, 04:34 AM
Same here Ranger, Fresh install on 4.0.2 is not working...
tafreeh
04-28-2010, 03:46 PM
any update on this mod? does it still works for vb4.03?
New version added here: https://vborg.vbsupport.ru/showthread.php?t=241754
Daisyboo
07-19-2010, 11:25 AM
sorry post not needed :)
maxie
11-24-2010, 12:03 AM
nice hack..
have one question
i want to change the notice info
Administrator want you to read thread.. so on and so fort
to my on language
possible to change it ? edit that text ?
maxie
11-24-2010, 10:42 AM
i want to edit this part on this hack
The administrators want you to view a thread before you continue to browse the forum.
You can view the thread here.
i want to change it to my own language
how could i do that ?
Onefast1
12-01-2010, 03:08 PM
Go to your the force read thread settings and add vbadvaced to the list there.
Im using version 3.7.1 with vbadvanced 3.0.1, everything installed properly and looks to be correct but when I add a thread to be forced nothing happens. Tried logging out, logging in and doesn't force the thread to be viewed. I found this reference to vbadvanced but don't know where this needs to be added in the edit settings dialog? or does it just not work at all with vbadvanced?
Thanks for any help or direction.
Artes_Marciales
02-01-2011, 04:35 PM
Amazing Mod!!
TitanJeff
02-11-2011, 01:58 PM
Love this mod but hadn't used it in a while until today.
When I add a thread, it is no longer showing up on the list where the others are.
I'm using 3.8.6 p1. I too am using vBadvanced.
mito22
05-31-2011, 01:15 PM
Does it work on 3.8.6 LP2?
Cromags21
02-02-2012, 04:39 AM
A member on my site asked me if there was away to send force rad message to his usergroup, Now this member doesn't have any admin right on our forums. But he is in charge of this one usergroup.
Is there away to let him have the ability to use the force read thread to send a message to that 1 usergroup without being an Admin?
Like adding force read thread in the Tool drop down?
So usergroup leaders can use it as well.
LordNinja
05-04-2012, 08:29 AM
Love this mod but hadn't used it in a while until today.
When I add a thread, it is no longer showing up on the list where the others are.
I'm using 3.8.6 p1. I too am using vBadvanced.
same here I use vB 3.8.7 any solution for this?
tehPARADOX
08-03-2012, 05:25 AM
Thanks.
Midohash
08-06-2012, 02:18 AM
Great mod ... Installed ... Thank you
What Force Read Order 10 refers to? ... How can I align center the error message?
Midohash
08-06-2012, 02:20 AM
Does it work on 3.8.6 LP2?
Working well on 3.8.4
elwizard
11-15-2012, 09:39 AM
Is there a v 4.x version of this hack? Sorry for the inconveniences. Greetings ;)
dakotart.com
02-02-2013, 01:23 AM
wanted to clarify this also works on vb 3.8.7.
farsgsm
05-27-2013, 08:08 AM
does it works on 3.8.7?
yeuay
12-04-2015, 11:13 AM
does it works on 3.8.x ?
ArcadeSyndicate
12-04-2015, 02:08 PM
yes it does, i used it a couple of years ago too when i was on 3.8
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.