vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Moderators Functions - Force Users to Read a Thread (https://vborg.vbsupport.ru/showthread.php?t=151737)

Meghwar 10-18-2007 11:47 PM

Hi Abe1

I did follow all the info and add's and when i import the product i get the Error below....

Any idea how can i solve that

index = VbPortal
Forum=Vbulletin 3.6.8

regards

Abe

Quote:

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT force_read_thread.force_read_threadid AS threadid
FROM force_read_thread AS force_read_thread
LEFT JOIN force_read_read AS force_read_read ON (force_read_thread.force_read_threadid = force_read_read.force_read_threadid AND force_read_read.force_read_userid = '1')
WHERE force_read_read.force_read_userid IS NULL
AND force_read_thread.force_read_usergroupid IN (0,6)
AND (force_read_thread.expire_date = 0 OR force_read_thread.expire_date > '1192754513')
AND
(
force_read_thread.force_read_forumid IN ()
OR force_read_thread.force_read_forumid = 0 AND (force_read_thread.force_read_location = 0 OR force_read_thread.force_read_location & 64)
);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
OR force_read_thread.force_read_forumid = 0 AND (force_read_thread.forc' at line 9
Error Number : 1064
Date : Thursday, October 18th 2007 @ 05:41:54 PM
Script : http://www.****.com/forum/index.php
Referrer : http://www.****.com/forum/showthread.php?p=58933
IP Address : **********
Username : Meghwar
Classname : vb_database

haytham 10-19-2007 11:29 AM

I installed it but never tried it as a user till today. Admins. a piece of advice. Don't over do this because when you get new members they will spend hours forced to read the threads you force them to. I think that's a good way to drive them away.
I am trying to figure out now what (reset) means. I am afraid if I reset, then users will be forced to see the threads again. What I want to do is cancel some of the threads I have users go to.

Meghwar 10-19-2007 03:47 PM

Quote:

Originally Posted by Meghwar (Post 1363417)
Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT force_read_thread.force_read_threadid AS threadid
FROM force_read_thread AS force_read_thread
LEFT JOIN force_read_read AS force_read_read ON (force_read_thread.force_read_threadid = force_read_read.force_read_threadid AND force_read_read.force_read_userid = '1')
WHERE force_read_read.force_read_userid IS NULL
AND force_read_thread.force_read_usergroupid IN (0,6)
AND (force_read_thread.expire_date = 0 OR force_read_thread.expire_date > '1192754513')
AND
(
force_read_thread.force_read_forumid IN ()
OR force_read_thread.force_read_forumid = 0 AND (force_read_thread.force_read_location = 0 OR force_read_thread.force_read_location & 64)
);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
OR force_read_thread.force_read_forumid = 0 AND (force_read_thread.forc' at line 9
Error Number : 1064
Date : Thursday, October 18th 2007 @ 05:41:54 PM
Script : http://www.****.com/forum/index.php
Referrer : http://www.****.com/forum/showthread.php?p=58933
IP Address : **********
Username : Meghwar
Classname : vb_database

Please any help....

Abe1 10-21-2007 02:35 AM

Quote:

Originally Posted by Schnee (Post 1360712)
Before I proceed with this, does it work with vBadvanced?

I marked it as installed, got one error and quickly backed out the template changes.

Thanks if anyone knows the answer.

Yes, all you have to do is when you make a force read, don't let it be active on 3rd party pages.




Quote:

Originally Posted by perfphysio (Post 1362997)
Also in the drop down you can select to make users read this thread or to manage the thread viewing (expiry etc). Can we just have a simple remove force read for a thread that switches this off.

Also I made three to be viewed to see if on viewing on the user was forced to read a second and then a third in order. It seems this was so for the first two and the third was ignored. It this meant to be this way?

Many thanks :)

It should make you view all 3. Just it would be in any order.







Quote:

Originally Posted by EragonSN (Post 1363225)
Would be nice to have this for subforums too, so here is what I want xD

I run a small forum, gaming servers, with several subforums, for different games, but players from the other games, ain't really interested in the rules from a different game...

So, would it be possible to have a "YOU MUST READ" Sign or error, when you enter a specific forum only, and the thread will be in that forum too, users who don't access that part are left out...

Hope you understand what I mean :P

Doesn't it work for subforums now?






Quote:

Originally Posted by Meghwar (Post 1363417)
Hi Abe1

I did follow all the info and add's and when i import the product i get the Error below....

Any idea how can i solve that

index = VbPortal
Forum=Vbulletin 3.6.8

regards

Abe

All you have to do is when you make a force read, don't let it be active on 3rd party pages.

maidos 10-21-2007 01:36 PM

suggestion: can u set time of how long they must stay on the thread, since my user just click the link and go on

too_cool_3 10-22-2007 02:10 AM

Just merged a thread that used to be set as force read... and now my new members are getting an error...again, all memeber that alread viewed it are fine...
i'm having to delete it now, but i will try just disabling it first to see if it stops the error... when u come up with a fix, let me know... by the way im using vbadvanced too, if that makes a difference.

chikkoo 10-23-2007 08:10 AM

I just installed this in 2 test forums, 1 with vbadvanced one without vbadvanced.

The one without vbadvanced works fine.

The one with vbadvaced gives error while login from vbadvanced, it's searching for the thread without the forum path (sub folder).

Can somebody tell me where to add the correct path?

777connect 10-25-2007 12:40 PM

This was very easy to install. But I can't seem to get it work. I go to the setting and manage it and set it for uses in all locations, but yet it still works as if it is not set. If I go back to manage it, it is like nothing has been set. Like it did not save the settings.

Direct Vision 10-26-2007 07:51 AM

It worked for me but the only problem is this.

when my members will try to enter their user name and password, they have 2 boxes to choose from to enter them the small normal one at the top and the other in the big box that come as vb mssage.

when i enter in the normal small one the message comes but it won't redirect to the thread it will have the /forums missing.

And when i enter in the user and pass in the vb message box in will work good

what do you think i should do??

haytham 10-26-2007 08:17 AM

Is there a way to know all the threads that have been marked for forced reading so I can stop it or cancel it from threads of my choice? Moderators have been using this too much and now any new user has to spend ages trying to get into the forum as he is continuously redirected to read a thread...really annoying.


All times are GMT. The time now is 12:45 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01484 seconds
  • Memory Usage 1,756KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete