Rules and User Agreement Hack

[uae]

This modification currently contains a vulnerability. You are hereby advised to disable this modification until such time that the author provides a fix.
- vBulletin.org Staff

Rules and User Agreement Hack-------------------------------------
Hack Version: 1.1.5
vB-version: 3.5
Developer: WwW.UAEWEB.CoM (http://www.uaeweb.com/)
Install-difficulty: Easy
Port of: https://vborg.vbsupport.ru/showt...threadid=77666 (https://vborg.vbsupport.ru/showt...threadid=77666)

Introduction:
Rules and User Agreement Hack Is an agreement rules systems, that requires user to agree to each individual forum or/and pages rules within the whole board community ?if applicable? prior to permission them to different action (Viewing a Forum, Posting New Thread for the first time, Posting New Thread, Posting Reply).

This will limit the forum breaches that occur often due to unawareness of the rules and agreement. This shall automate the manual procedures that are followed by users to read the ?rules and agreement? and will enforce to some extent the users to be aware of rules in place. Moreover this will eliminate the options of any denial by certain users of not being aware of ?rules and agreements? being in place for the desired forum.

This can also be used as alerts, broadcasts, messages and tutorials? etc to certain individual, multi users or groups.

Features:

Unlimited* Rule(s).
An Individual Forum can have multi rules agreement.
An Individual FILE within your forum can have mutli rules agreement.
List All Rules that user has agreed to from his/her profile page "if a url was provided".
Edit/Delete Rule(s).
Reset Rule(s) Manually or with Cron Job.
Rules can use bbcode.
Set to show a rule(s) agreement in any selected forum/page (file url) IF:- User's Usergroup is Y.
- User's Additional Usergroups is Y.
- User's User Id is X.
- User's User Name is XXX.
- User's first time posting a new thread in this forum.
- User's has posts greater than x posts.
- User's has posts less than x posts.
- User's Join Date is After (yyyy-mm-dd).
- User's Join Date is Befor (yyyy-mm-dd).
- User's Last Activiy is After (yyyy-mm-dd).
- User's Last Activiy is Befor (yyyy-mm-dd).
- User's Last Post is After (yyyy-mm-dd).
- User's Last Post is Befor (yyyy-mm-dd).
* Can Use Conditionals.

Fully "phrased" so translations are made easy.Settings in the Admin CP:

List Rule(s).
Add New Rule(s).
Edit / Delete Rule(s).
Reset Rule(s).
Activate and Inactivate Rule(s)Screenshots:

See attachments.

Hack Installation Details:

1 Product XML with 3 Plugins, and 45 Phrases

New files for this Hack: 3
/admincp/rulesagreement.php
/includes/cron/cron_ruleshack.php
/includes/xml/cpnav_rulesagreement.xml

New templates for this Hack: 2
ruleshack_rules
ruleshack_rulesbit

File-edits: 0

Template-edits: 1
MEMBERINFO

New DB tables for this Hack: 1
ruleshack

DB Tables modified for this Hack: 1
user

How to Install:
To install this hack, simply download the zip file, Unzip it to a directory on your computer and follow the steps from README.txt

History:
1.0.0
Initial Version for vBulletin 3.5

1.1.0
Added Rule(s) from URL
Fixed typo in Phrase

1.1.1
Fixed bug with new registration
-> to upgrade, import product-rulesagreement.xml and set Allow Overwrite to yes

1.1.2
Fixed bug with Reseting Rules every 12 hours
-> to upgrade, import product-rulesagreement.xml and set Allow Overwrite to yes

1.1.3
Fixed bug with with TABLE_PREFIX missing
-> to upgrade, import product-rulesagreement.xml and set Allow Overwrite to yes


1.1.4
Fixed bug with with Template / memberinfo Agreed Rules List
-> to upgrade, import product-rulesagreement.xml and set Allow Overwrite to yes

1.1.5
Fixed bug with this (https://vborg.vbsupport.ru/showpost.php?p=796736&postcount=68) & this (https://vborg.vbsupport.ru/showpost.php?p=797534&postcount=69)
-> to upgrade, import product-rulesagreement.xml and set Allow Overwrite to yes

PLEASE REMEMBER TO BACKUP BEFORE YOU BEGIN!

If you like this hack, please be kind and click on https://vborg.vbsupport.ru/ (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=97699) :)

[SnowBot]

WOW this looks great, i will give this a try. Thanks for your efforts :)

[Wasim]

Ive been looking for something like this for quite a while. Thanks!

There is just one rule hack I need, and that is a quiz hack when you register for the forum to quiz you if you have read the rules.

[sickboy6ths]

VERY interesting hack... problem is when I try to import the product I get this error and I have no clue what is wrong (already installed more products, without problems :S)

Fatal error: Cannot use object of type mysqli_result as array in admincp\plugin.php(1226) : eval()'d code on line 35

[Mu5icMan]

Can this be edited so it records the people who have signed the contract and when.

[PixelFx]

Can this be edited so it records the people who have signed the contract and when.

thank you so much been wanting something like this for a long time.

[COBRAws]

/me installs

[uae]

VERY interesting hack... problem is when I try to import the product I get this error and I have no clue what is wrong (already installed more products, without problems :S)

Fatal error: Cannot use object of type mysqli_result as array in admincp\plugin.php(1226) : eval()'d code on line 35

I'll look into this.

[uae]

Can this be edited so it records the people who have signed the contract and when.
If you look at the first screenshot image you'll see the records of the rules people have signed, unless you're talking about a new seprate page where it will list all users.

For the date of when the user has signed, I think that can be easly added, I'll need some time tho.

[Basboss]

wow this one has it all
installed here :)

[ixian]

AWESOME hack, thanks!

[hbalagh1]

great hack thank just what i needed :)

[xtreme-mobile]

will this hack allow you to set the rules to show before they enter the specific forum rather than when they try to post etc?

on the VB 3.0 version you did there was a addon which done this, is this standard now?

regards

dean

[hbalagh1]

will this hack allow you to set the rules to show before they enter the specific forum rather than when they try to post etc?


on the VB 3.0 version you did there was a addon which done this, is this standard now?

regards

dean
it will let you before they read

[xtreme-mobile]

great will be installing this then :D

[hbalagh1]

Found a typo :)

"When Viewing Froum" under Rules Options

[uae]

Found a typo :)

"When Viewing Froum" under Rules Options
Fixed :)

[thedvs]

what an absolutely amazing bloody ****ing brilliant hack
well done uae

*INSTALLED*

[hbalagh1]

would this mod have anything kind of modification to the registration process... When a user tries to register on my site and they click on the sites rules box and hit ok it gives them this error

You have chosen not to accept the forum rules, so registration can not continue.

Click here to return to the main forums page, or click the 'Back' button on your browser if you now want to agree with the forum rules

[thedvs]

One problem I have found, on my custom skin when I add

<!-- [START HACK='Rules and User Agreement' AUTHOR='WwW.UAEWEB.COM' VERSION='1.1.0' CHANGEID= 1 ] -->
<if condition="$agreedrules">
<fieldset class="fieldset">
<legend>$vbphrase[ruleshack_agreed]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
<tr>
<td>
<phrase 1="$userinfo[username]">$vbphrase[ruleshack_x_has_agreed_to_the_following_rules]</phrase>
</td>
</tr>
$agreedrules
</table>
</fieldset>
</if>
<!-- [END HACK='Rules and User Agreement' AUTHOR='WwW.UAEWEB.COM' VERSION='1.1.0' CHANGEID= 1 ] -->

To the member info it doesnt show above the referrals at all.
I have my agreement to reset every 12 hours too if that helps

[hbalagh1]

One problem I have found, on my custom skin when I add

<!-- [START HACK='Rules and User Agreement' AUTHOR='WwW.UAEWEB.COM' VERSION='1.1.0' CHANGEID= 1 ] -->
<if condition="$agreedrules">
<fieldset class="fieldset">
<legend>$vbphrase[ruleshack_agreed]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
<tr>
<td>
<phrase 1="$userinfo[username]">$vbphrase[ruleshack_x_has_agreed_to_the_following_rules]</phrase>
</td>
</tr>
$agreedrules
</table>
</fieldset>
</if>
<!-- [END HACK='Rules and User Agreement' AUTHOR='WwW.UAEWEB.COM' VERSION='1.1.0' CHANGEID= 1 ] -->

To the member info it doesnt show above the referrals at all.
I have my agreement to reset every 12 hours too if that helps

I read in the set up that you have to have a url listed for that function to work :)

[hbalagh1]

I uninstalled this mod so now i can have users register again, so there is definitially some kind of issue there
would this mod have anything kind of modification to the registration process... When a user tries to register on my site and they click on the sites rules box and hit ok it gives them this error

You have chosen not to accept the forum rules, so registration can not continue.

Click here to return to the main forums page, or click the 'Back' button on your browser if you now want to agree with the forum rules

[thedvs]

@hbalagh1 url to what exactly? a file, txt file......

[hbalagh1]

url to your rules page (from what i understand) im not using that feature

[thedvs]

errr do you mean the forum url or an outside page?

[hbalagh1]

this isn't my mod so i really don't know, im guessing it would be something like yourdomain.com/rules.php

[hbalagh1]

have you checked to see if you can have new registrations after adding this hack, cause i had to uninstall it

[thedvs]

just checked & yes i have the same problem, damn :(

[hbalagh1]

glad it wasn't just me :(

Hope it gets fixed soon so i can add it back :)

[Valter]

This is really great hack. I'll try it when uae fix bugs mentioned above. Thanks bro.

[uae]

Sorry for that,

Problem been fixed, just import the latest product-rulesagreement.xml from the zip file and set Allow Overwrite to YES.

[DBs]

When I attempt to reset a rule I get the following error message:

Warning: Cannot modify header information - headers already sent by (output started at /data/websites/forums.freddyshouse.com/includes/adminfunctions.php:236) in /includes/functions.php on line 2346

Warning: Cannot modify header information - headers already sent by (output started at /data/websites/forums.freddyshouse.com/includes/adminfunctions.php:236) in /includes/functions.php on line 2349

but the rule IS reset.

Also, can you explain the following option and provide an example (I'm confused, just can't get the rule listed in memberinfo)

Rule's Page URL (Optional) If you leave it empty, Rule will not be listed in MEMBRIFNO.

Many thanks.

[uae]

When I attempt to reset a rule I get the following error message:

Warning: Cannot modify header information - headers already sent by (output started at /data/websites/forums.freddyshouse.com/includes/adminfunctions.php:236) in /includes/functions.php on line 2346

Warning: Cannot modify header information - headers already sent by (output started at /data/websites/forums.freddyshouse.com/includes/adminfunctions.php:236) in /includes/functions.php on line 2349

but the rule IS reset.

Also, can you explain the following option and provide an example (I'm confused, just can't get the rule listed in memberinfo)
Rule's Page URL (Optional) If you leave it empty, Rule will not be listed in MEMBRIFNO.
Many thanks.

I have no idea about the error you're getting, but I'll look into it.

Regarding Rules Page URL

Now, if you add a url in that field, and a user submit to agree on the rule, you will be able to see the rule tilte with a link to the rules page if there was one in his/her profile page.

The idea behind this is that you may want to add a rule but you don't want others to see what poeple has agreed on unless you use the url field.

[thedvs]

Is the rules url meant to be the forums URL or a url to a php/html rules page?

[uae]

Is the rules url meant to be the forums URL or a url to a php/html rules page?

if you are talking about the Rule's Page URL field which is just under the rule's text field in the Add New Rule Page in ADMINCP, that would be the url to the rules and agreement page you've got already, if there was one, filling this field with a url will have the rules listed in the member profile page whenever they submit to agree on that rules.

Leaving that field empty, will not list the rules in the member profile page even if they submit to agree on the rules.

Think of it as an option weather you want others to see what rules a specific user has agreed on when viewing their profile page.

But if you were talking about the from File URL field which is at the very end of the Add New Rule Page in ADMINCP, then that would be the page you want to show the rules at whenever a user try to view it.

[thedvs]

Thank you... all works perfectly now!
Great job uae! :)

[thedvs]

Seems to be a problem with the 12 hour reset now, after the 12 hours it asks you again to sign the rules, you agree... then instead of letting you continue viewing threads it keeps asking for you to sign the rules again. Any ideas? To me it seems to be a cron issue.

[uae]

Seems to be a problem with the 12 hour reset now, after the 12 hours it asks you again to sign the rules, you agree... then instead of letting you continue viewing threads it keeps asking for you to sign the rules again. Any ideas? To me it seems to be a cron issue.
did you install the latest version?

[thedvs]

yes i did

[Delphiprogrammi]

hi people,

i get this MySQL error while trying to add the product XML


Database error in vBulletin 3.5.0:

Invalid SQL:
INSERT INTO cron (weekday, day, hour, minute, filename, loglevel, title )
VALUES (-1, -1, 0, 'a:1:{i:0;i:-1;}', './includes/cron/cron_ruleshack.php', 1,
'Rules and User Agreement Hack Reset');

MySQL Error : Table 'delphipr_forums.cron' doesn't exist
Error Number : 1146
Date : Sunday, October 9th 2005 @ 01:48:11 AM
Script : plugin.php
Referrer : plugin.php?do=productadd
IP Address :
Username :
Classname : vb_database


seems like . "TABLE_PREFIX ." thingy is missing somewhere

[uae]

Seems to be a problem with the 12 hour reset now, after the 12 hours it asks you again to sign the rules, you agree... then instead of letting you continue viewing threads it keeps asking for you to sign the rules again. Any ideas? To me it seems to be a cron issue.
Can you go to the Scheduled Task Manager and go to edit Rules and User Agreement Hack Reset
does it look like this:

Title: Rules and User Agreement Hack Reset
Day of the Week: *
Day of the Month: *
Hour: 0
Minute: *
Log Entries: yes
Filename: ./includes/cron/cron_ruleshack.php

[uae]

hi people,
i get this MySQL error while trying to add the product XML
seems like . "TABLE_PREFIX ." thingy is missing somewhere
Sorry for that, just get the latest product xml file and import it with Allow Overwrite to YES.

[LadyBeth]

NICE! Clicking install....
Beth

[Delphiprogrammi]

well... ,

This refuses to work for me.I managed to get past the MySQL error that was pretty simple


INSERT INTO vb3_cron(weekday,day,hour,minute,filename,loglevel ,title)VALUES(-1,-1,0,'a:1:{i:0;i:-1;}','./includes/cron/cron_ruleshack.php',1,'Rules and User Agreement Hack Reset');


but i don't have a link called "rules manager" under the forums&moderator navgroup and yes i did uploaded the XML file which should take care of that

[Yorixz]

Perfect hack, just what I was looking for, thanks so much!

[uae]

well... ,

This refuses to work for me.I managed to get past the MySQL error that was pretty simple
but i don't have a link called "rules manager" under the forums&moderator navgroup and yes i did uploaded the XML file which should take care of that
mmm, that's weird... did you upload cpnav_rulesagreement.xml to the xml directory?

Just upload it first, then import the product xml file, and last, refresh your admincp page and see the links, should be there!!

[Delphiprogrammi]

mmm, that's weird... did you upload cpnav_rulesagreement.xml to the xml directory?

Just upload it first, then import the product xml file, and last, refresh your admincp page and see the links, should be there!!

i was to fast in posting :surprised: i saw you updated the package and all is working fine now no more MySQL errors and i have those links in my admincp

thanks for this one i like it

[dethfire]

there seems to be a bug:
When I set some rules I know I was the first to agree to them, however, I went to members profiles right after I agreed, some members who went even online and it said they had agreed to the rules which was impossible.

I think it is just the template error because if I click reset rule in admin it tells me only 1 user has agreed. However every members profile says they agreed to all of them.

[Mickie D]

great release :)

one thing if you choose a rule applys to a guest does it work on cookies or something, or wont it work with guests ?

thanks for the hack will install this weekend whatever the answer ;)

[dethfire]

I got members who say they have to repeatedly reagree to guidelines over and over again, like it doesn't register that they already signed it.

[JohnBee]

I installed the hack on a custom vB page but the styles are lost, any ideas?
Using vBadvanced 2.0, vB3.5 Gold, the UA pops up but the style is n/A until its passed

[Whissi]

I used "URL" and said "showthread.php".
If I click any user, it tells me, that the user has just accept the agreement...

But it is my testboard - this user can't accept, because he didn't know that :)

[uae]

great release :)
one thing if you choose a rule applys to a guest does it work on cookies or something, or wont it work with guests ?
thanks for the hack will install this weekend whatever the answer ;)
Yes it uses cookies for guests.

[uae]

I got members who say they have to repeatedly reagree to guidelines over and over again, like it doesn't register that they already signed it.

Have you installed the latest version??


I installed the hack on a custom vB page but the styles are lost, any ideas?
Using vBadvanced 2.0, vB3.5 Gold, the UA pops up but the style is n/A until its passed

I haven't tried the hack with vBadvanced, but I'll give it a try and see.

I used "URL" and said "showthread.php".
If I click any user, it tells me, that the user has just accept the agreement...
But it is my testboard - this user can't accept, because he didn't know that

Said only showthread.php, or the full url to http://www.blabla.com/forum/showthread.php ??
You should use the full url to that file.

[JohnBee]

Fantastic uae I really like the hack, its a perfect companion to vBadvanced pages on a site. :D

Looking forward to using it!

[Whissi]

Said only showthread.php, or the full url to http://www.blabla.com/forum/showthread.php ??
You should use the full url to that file.
I said only "showthread.php", but I tried the full url, reset'ed the agreement.
I reload a profilwindow -> No agreement mentioned.
I accepted the agreement and reloaded the profilwindows of an different user (a user who cannot accept, because he don't no the forum) and vBulletin tells me: This user has accepted.

It seems, that the memberinfo display the own information, not the infos from the user the profil you are browsing...

[dethfire]

It seems, that the memberinfo display the own information, not the infos from the user the profil you are browsing...

Right, this is happening on my forum too

[Whissi]

I found another error:
The template "ruleshack_rules" isn't xhtml valid.
<input type="hidden" name="oldurl" value="$urluri">
should be
<input type="hidden" name="oldurl" value="$urluri" />

[Mr Chad]

is this working right now?

[uae]

I said only "showthread.php", but I tried the full url, reset'ed the agreement.
I reload a profilwindow -> No agreement mentioned.
I accepted the agreement and reloaded the profilwindows of an different user (a user who cannot accept, because he don't no the forum) and vBulletin tells me: This user has accepted.
It seems, that the memberinfo display the own information, not the infos from the user the profil you are browsing...
Sorry for that, Fixed now...just Import the latest xml product 1.1.4

I found another error:
The template "ruleshack_rules" isn't xhtml valid.

Thanks, now it's fixed with version 1.1.4

[Whissi]

Sorry for thatNo problem. :)
I have to thank you for the grate hack!

[Oblivion Knight]

Just what I was looking for, many thanks.! :)

[Whissi]

Question:
Only user could see their own list of accepted agreements. I don't recognize why? Why did you do this... I thought every user should see if other members has accepted or not.

[uae]

Question:
Only user could see their own list of accepted agreements. I don't recognize why? Why did you do this... I thought every user should see if other members has accepted or not.
R u sure about that?? have you got the latest version?
cos everyone/anyone could see others accepted rules!

[dethfire]

R u sure about that?? have you got the latest version?
cos everyone/anyone could see others accepted rules!

I confirm, with the update a user can only see their own accepted rules, not anyone elses.

[uae]

I confirm, with the update a user can only see their own accepted rules, not anyone elses.
Man, this thing is working just fine with me, could anybody else confirm it :ermm:

[bigmonay2k]

work like a charm dude, thanks

[JohnBee]

Any news on the vBadvanced missing template issue? - I suspect the problem is that the script looks for the .css paths assuming it is in the /forum/ dir but since vBa will allow you to run pages at the root of your site (homepage) location then the paths don't work out and the MOD cannot display properly.

I was wondering if there was a location we could add a chdir command to the scripts to compensate or otherwise enter a new path to help it find the .css data.

And of course your help is much appreciated on this.

[dethfire]

Man, this thing is working just fine with me, could anybody else confirm it :ermm:

I found something interesting. If I select a user from a last post link on the homepage or within a forum nothing renders for the rules and guidelines. However, if I goto a post and click the users name and with the drop down select "view profile" the user agreement stuff renders fine. I found the difference of url for each way of viewing a users profile:

This URL style will result in the agreement info working:
http://www.physicsforums.com/member.php?u=26624

This URL style will result in a failure of the agreement info showing:
http://www.physicsforums.com/member.php?find=lastposter&f=65

[uae]

Any news on the vBadvanced missing template issue? - I suspect the problem is that the script looks for the .css paths assuming it is in the /forum/ dir but since vBa will allow you to run pages at the root of your site (homepage) location then the paths don't work out and the MOD cannot display properly.

I was wondering if there was a location we could add a chdir command to the scripts to compensate or otherwise enter a new path to help it find the .css data.

And of course your help is much appreciated on this.
Will you please try installing the latest product v1.1.5?
let's see if that will solve our problem with vBadvanced page.

I found something interesting. If I select a user from a last post link on the homepage or within a forum nothing renders for the rules and guidelines. However, if I goto a post and click the users name and with the drop down select "view profile" the user agreement stuff renders fine. I found the difference of url for each way of viewing a users profile:

This URL style will result in the agreement info working:
http://www.physicsforums.com/member.php?u=26624
This URL style will result in a failure of the agreement info showing:
http://www.physicsforums.com/member...lastposter&f=65
Thanks again, product file has been updated :)

[thedvs]

where are the scheduled task setup instructions in the readme for cron?

[nexialys]

yeah, i found another tick...

>> function fetch_user_agreed_rules($uinfo = '')

the $uinfo is not used at all nowhere...

and a request for the memberinfo: make it possible to choose what usergroups have access to these details... i don't see why i would let all my users see who agreed to X rules...
maybe let own users and admins see these details is more appropriate, so i would like a new field in the settings where we can add usergroupids... ;)

[uae]

where are the scheduled task setup instructions in the readme for cron?
That's being done with the process of the installation, so no need for a setup instructions :)
just look at the sechduled task manager after you got the hack installed, you'll see it listed there...

[thedvs]

ah cool one uae, great updates :)

[JohnBee]

WORKS with vBadvanced! :up:
thank you uae, your hack is both useful and appreciated :D [INSTALLED]

[Whissi]

I only want that admins, mods, super-mods, registered user have to sign the contract.
If they don't have sign the contract, they aren't allow do anythink (read fourm, post forum, pms...)!

But guests are allowed to "read" the forum...

Is it possible? How should the settings look like...

[uae]

yeah, i found another tick...

>> function fetch_user_agreed_rules($uinfo = '')

the $uinfo is not used at all nowhere...

and a request for the memberinfo: make it possible to choose what usergroups have access to these details... i don't see why i would let all my users see who agreed to X rules...
maybe let own users and admins see these details is more appropriate, so i would like a new field in the settings where we can add usergroupids... ;)Thanx nexi, that thing "$uinfo = ''" has been removed, even if you leave it, it won't harm nothing :) but the product xml file has been updated.

and if you don't want anyone to see what a member has agreed on, in his/her profile page, and would like to restrict that for admins/mods/and maybe the user him/her self
add this code with the template edit

<if condition="$bbuserinfo['usergroupid']==5 or $bbuserinfo['usergroupid']==6 or $bbuserinfo['userid']==$userinfo[userid]">

TEMPLATE EDIT COMES HERE

</if> change the usergroup ids to whatever you like.

[TheRayden]

Amazing hack, love it!!

[xtreme-mobile]

ive found a massive problem with this hack

since installing this new members cant register it always says they havent accepted the T&C so cant register!!! when i disable the plugin it works fine again :(

[Oblivion Knight]

ive found a massive problem with this hack

since installing this new members cant register it always says they havent accepted the T&C so cant register!!! when i disable the plugin it works fine again :(Apparantly this was fixed some time ago.. Are you using the latest version?

[xtreme-mobile]

Apparantly this was fixed some time ago.. Are you using the latest version?

V 1.1.0

ill try using the V 1.1.5 and see if thats any better


***UPDATE***

works fine with V1.1.5 installed ;)

[lucky64]

Cannot wait to try this...

[Hornstar]

Excellent hack, exactly what i needed to keep put a disclaimer on certain forums, and a overall disclaimer.....Thankyou very much

[LadyBeth]

This works for both new and existing users, right?
B~

[RED_LINE]

installs

Thanks for your efforts

Regards,

[m.s]

Hi,

my forum (3.5.1.) is on a domain (eg. www.forum.de), which is a subdirectory on another domain (eg.www.site.de/vbulletin).

If I accept a rule, i would be redirected to www.site.de/newthread.php..., but the right path must be www.forum.de/newthread.php...

Where is the error?

[Robert Basil]

Great hack! But...

I can't find a setting to have this displayed for all forums when posting a new thread or reply. I don't want to have to make a new rule set for each individual forum (we don't have any sub forums). I tried to set it for the main category but of course this did not work.

Any suggestions?

[redlabour]

How can i choose to set "All Forums" ??

[redlabour]

Nobody ?

[klaush]

Looking for that since month for our sales-sections in our forum!

Thanks...

Installed under 3.5.2.!:-)

[Firestar.chkn]

Great hack! But...

I can't find a setting to have this displayed for all forums when posting a new thread or reply. I don't want to have to make a new rule set for each individual forum (we don't have any sub forums). I tried to set it for the main category but of course this did not work.

Any suggestions?

Just add the rule to the main category and add the checkbox "include in child forums" and it will add it for all forums.

Awesome hack, btw. I love it, and will be using it all the time :) Installs :)

[kommuni]

Just add the rule to the main category and add the checkbox "include in child forums" and it will add it for all forums.

Awesome hack, btw. I love it, and will be using it all the time :) Installs :)

Just add the rule to the main category and add the checkbox "include in child forums" and it will add it for all forums.

I have about 8 Categories on top level... i don't see any category "above"?!

Would be great if this option could be added. My users should agree to new rules when logging into the forums next time - regardless where they login... This doesn't seem to be possible so far.

Thanks!

[redlabour]

I have about 8 Categories on top level... i don't see any category "above"?!

Would be great if this option could be added. My users should agree to new rules when logging into the forums next time - regardless where they login... This doesn't seem to be possible so far.

Thanks!

Same at me !

[vibe]

When I click on agree and submit, browser takes me to this URL

http://www.agalico.com/php/php.exe?f=65...

Security Alert! The PHP CGI cannot be accessed directly.

This PHP CGI binary was compiled with force-cgi-redirect enabled. This means that a page will only be served up if the REDIRECT_STATUS CGI variable is set, e.g. via an Apache Action directive.

Can anyone help me figure it out why? I'v been trying to troubleshoot this problem forever, still having find out why.

Thanks.

[redlabour]

I have about 8 Categories on top level... i don't see any category "above"?!

Would be great if this option could be added. My users should agree to new rules when logging into the forums next time - regardless where they login... This doesn't seem to be possible so far.

Thanks!

Anybody supporting this Hack ?

[steven s]

I want people to read an agreement before
linking to /newthread.php?do=hpde
Is this possible?
Edit: nevermind. I figured it out.

[kommuni]

Hi together,

as there doesn't seem to be anymore support for this hack, i helped myself and found a solution for that previously named problem.

I'll post it here and you may use it at your own risk!

With this modification, you're able to setup rules for every page. With such a global rule everyone first has to agree to this rule before beeing able to read any of your forums (or even gallery, arcade, any hack that uses vb-templateparser).

the only thing you need to modify is the template_parser plugin from the rules & agreementhack. Just xchange the complete code with this:


$hackagree = array();

$vbulletin->input->clean_array_gpc('p', array('hackagree' => TYPE_ARRAY_INT, 'forumid' => TYPE_INT, 'oldurl' => TYPE_STR, 'do' => TYPE_STR));
$ruleids = implode(",", $vbulletin->GPC['hackagree']);

$scripturl1 = iif ($_SERVER['SCRIPT_URI'], $_SERVER['SCRIPT_URI'], "http://" . $_SERVER['HTTP_HOST'] . $_SERVER['SCRIPT_NAME']);
$urluri = $scripturl1 . iif($_SERVER['QUERY_STRING'], "?" . $_SERVER['QUERY_STRING']);

if ($ruleids)
{
//Lets see if this user has agreed or not (Update agreed ruleid)
update_rules($ruleids, $vbulletin->GPC['forumid']);
}
else
{

if ($vbulletin->GPC['hackagree']<>1)
{
// Check for all list of RULE to be apply for this page...
$ruletext = check_newrules($vbulletin->GPC['forumid']);

if ($ruletext)
{
$navbits = array();
$parentlist = array_reverse(explode(',', substr($foruminfo['parentlist'], 0, -3)));
foreach ($parentlist AS $forumID)
{
$forumTitle = $forumcache["$forumID"]['title'];
$navbits["forumdisplay.php?$session[sessionurl]f=$forumID"] = $forumTitle;
}

// parse headinclude, header & footer
$admincpdir =& $vbulletin->config['Misc']['admincpdir'];
$modcpdir =& $vbulletin->config['Misc']['modcpdir'];

$navbits[''] = $vbphrase['ruleshack_rules_and_agreement'];
$navbits = construct_navbits($navbits);
if (empty($navbar))
eval('$navbar = "' . fetch_template('navbar') . '";');
if (empty($headinclude))
eval('$headinclude = "' . fetch_template('headinclude') . '";');
if (empty($header))
eval('$header = "' . fetch_template('header') . '";');

if (defined('VBA_PORTAL'))
{
require_once(DIR . '/includes/vba_cmps_include_bottom.php');
}
if (empty($footer))
eval('$footer = "' . fetch_template('footer') . '";');


if ($_REQUEST['do'] == 'postreply')
{
$rule = array();
$rule['postreply'] = 1;
$rule['wysiwyg'] = $_REQUEST['wysiwyg'];
$rule['quickreply'] = $_REQUEST['quickreply'];
$rule['message'] = addslashes($_REQUEST['message']);
$rule['fromquickreply'] = $_REQUEST['fromquickreply'];
$rule['t'] = $_REQUEST['t'];
$rule['p'] = $_REQUEST['p'];
$rule['parseurl'] = $_REQUEST['parseurl'];
}

eval('print_output("' . fetch_template('ruleshack_rules') . '");');
exit;
}
}
}

// function "check_rulesneed" to find any rules exist for this page....
function check_rulesneeded()
{
global $vbulletin, $urluri, $scripturl1;

$ruleneed = $vbulletin->db->query_first("SELECT * FROM " . TABLE_PREFIX . "ruleshack
WHERE (fileurl LIKE '" . $urluri . "' AND exactmatch = 1 )
OR (fileurl LIKE '" . $scripturl1 . "%' AND exactmatch = 0 )
OR (fileurl LIKE 'all' AND exactmatch = 0) AND active = 1 ORDER BY ruleid");

if (!$ruleneed)
return false;
else
return true;
}

// function "check_newrules" to find all the rules to be agreed by this user
function check_newrules($fid = 0)
{
global $vbulletin, $foruminfo, $vbphrase, $stylevar, $urluri, $scripturl1;

if ((!$fid) and (!check_rulesneeded()))
return false;

//Lets check what rule(s) this user should get

$vbulletin->userinfo['agreedrule'] = iif($vbulletin->userinfo['agreedrule'], $vbulletin->userinfo['agreedrule'], '0');

$parents = iif($vbulletin->forumcache[$vbulletin->GPC['forumid']]['parentlist'], $vbulletin->forumcache[$vbulletin->GPC['forumid']]['parentlist'], '0');

$parentids = array();
$parentids = iif($parents, explode(',', str_replace(' ', '', $parents)), 0);

if (($_COOKIE[COOKIE_PREFIX . 'rules']) and ($vbulletin->userinfo['userid']==0))
foreach($_COOKIE[COOKIE_PREFIX . 'rules'] AS $key => $value)
{
$allrules .= " :: " . $key;
$vbulletin->userinfo['agreedrule'] .= iif($vbulletin->userinfo['agreedrule']!='',",","") . $value;
}

$sql = "SELECT * from " . TABLE_PREFIX . "ruleshack
WHERE
(
(forumid = $fid)
OR
(fileurl LIKE '" . $urluri . "' AND exactmatch = 1 )
OR
(fileurl LIKE '" . $scripturl1 . "%' AND exactmatch = 0 )
OR
(fileurl LIKE 'all' AND exactmatch = 0 )
OR
(forumid IN ($parents))
)
AND
(ruleid not in (" . $vbulletin->userinfo['agreedrule'] . "))
AND
active = 1
ORDER BY ruleid";

$rule = $vbulletin->db->query($sql);

$i = 1;
while ($rules = $vbulletin->db->fetch_array($rule))
{

$flag = 0;
$condflag = 0;
$groupflag = 0;
$memberflag = 0;

// Lets start our rules

// Rule #1 : USER is from Selected Usergroup(s)
if ($rules['groupids'])
{
$gids = array();
$gids = explode(',', str_replace(' ', '', $rules['groupids']));
if (in_array($vbulletin->userinfo['usergroupid'], $gids))
{
$flag = 1;
$groupflag = 1;
}
}

// Rule #2 : USRE is from Selected Membergroup(s)
if ($rules['memberids'])
{
$mids = array();
$mgids = explode(',', str_replace(' ', '', $vbulletin->userinfo['membergroupids']));
$mids = explode(',', str_replace(' ', '', $rules['memberids']));

foreach ($mgids as $ids)
{
if (in_array($ids, $mids))
{
$flag = 1;
$memberflag = 1;
}
}
}

if ( ($groupflag==1) or ($memberflag==1) )
$condflag = 1;
else
$condflag = 0;

// Rule #4 : USER is from Selected Userid(s)
if ($rules['userids'])
{
$uids = array();
$uids = explode(',', str_replace(' ', '', $rules['userids']));
if (in_array($vbulletin->userinfo['userid'], $uids))
{
$flag = 1;
$condflag = 1;
}else {
$condflag = 0;
}
}

// Rule #5 : USER is from Selected Username(s)
if ($rules['usernames'])
{
$unames = array();
$unames = explode(',', str_replace(' ', '', $rules['usernames']));
if (in_array($vbulletin->userinfo['username'], $unames))
{
$flag = 1;
$condflag = 1;
}else {
$condflag = 0;
}
}

// All the Condition from Rule #6 - Rule #13 for VB Users....
if ($vbulletin->userinfo['userid'] > 0 )
{
// Rule #6 : User has More than X post(s)
if ($rules['postmore'])
{
if ($vbulletin->userinfo['posts'] > $rules['postmore'])
{
$flag = 1;
$condflag = 1;
}else {
$condflag = 0;
}
}

// Rule #7 : User has Less than X post(s)
if ($rules['postless'])
{
if ($vbulletin->userinfo['posts'] < $rules['postless'])
{
$flag = 1;
$condflag = 1;
}else {
$condflag = 0;
}
}

// Rule #8 : Join date is After xxx Date
if ($rules['joindateafter'])
{
if ($vbulletin->userinfo['joindate'] > $rules['joindateafter'])
{
$flag = 1;
$condflag = 1;
}else {
$condflag = 0;
}
}

// Rule #9 : Join date is Before xxx Date
if ($rules['joindatebefore'])
{
if ($vbulletin->userinfo['joindate'] < $rules['joindatebefore'])
{
$flag = 1;
$condflag = 1;
}else {
$condflag = 0;
}
}

// Rule #10 : Last visit is After xxx Date
if ($rules['lastactiveafter'])
{
if ($vbulletin->userinfo['lastvisit'] > $rules['lastactiveafter'])
{
$flag = 1;
$condflag = 1;
}else {
$condflag = 0;
}
}

// Rule #11 : Last visit is Before xxx Date
if ($rules['lastactivebefore'])
{
if ($vbulletin->userinfo['lastvisit'] < $rules['lastactivebefore'])
{
$flag = 1;
$condflag = 1;
}else {
$condflag = 0;
}
}

// Rule #12 : Last post is After xxx Date
if ($rules['lastpostafter'])
{
if ($vbulletin->userinfo['lastpost'] > $rules['lastpostafter'])
{
$flag = 1;
$condflag = 1;
}else {
$condflag = 0;
}
}

// Rule #13 : Last post is Before xxx Date
if ($rules['lastpostbefore'])
{
if ($vbulletin->userinfo['lastpost'] < $rules['lastpostbefore'])
{
$flag = 1;
$condflag = 1;
}else {
$condflag = 0;
}
}
}
// All the Condition from Rule #6 - Rule #13 for VB Users....

// Rule #14 : Rule apply for Child forum....
if (($parentids) and ($fid != $rules['forumid']))
{
if ((in_array($rules['forumid'], $parentids)==1) and ($rules['childforum']==1))
{
$flag = 1;
$condflag = 1;
}
else {
$condflag = 0;
}
}

// Rules from URL
$flag = 0;
if ($condflag == 1)
{
if ($rules['fileurl'])
{
$urlpos = strrpos($urluri, $rules['fileurl']);
// Rule #14 : Show Rules on URL match.....
if (($rules['fileurl'] == $urluri) and ($rules['exactmatch']==1))
{
$flag = 1;
$condflag = 1;
} else {
$condflag = 0;
}

// Rule #15 : Show Rules on URL match.....
if (($urlpos) and ($rules['exactmatch']==0))
{
$flag = 1;
$condflag = 1;
} else {
$condflag = 0;
}
// Rule #14 + 15 : Show Rules regardless to URL.....
if(($rules['fileurl']=='all') and ($rules['exactmatch']==0))
{
$flag = 1;
$condflag = 1;
} else {
$condflag = 0;
}


}

// Rule #16 : First Thread ever in this Forum by this User
if (($rules['firstnewthread']) and ($fid!=0) and ($_REQUEST['do'] == 'newthread'))
{
$result = $vbulletin->db->query_first("SELECT * from " . TABLE_PREFIX . "thread
WHERE forumid = $fid and postuserid = " . $vbulletin->userinfo['userid'] . " ");
if (!$result)
{
$flag = 1;
$condflag = 1;
}else {
$condflag = 0;
}
}


// Rule #17 : Show Rules on New Thread....
if ($rules['newthread'])
{
if ($_REQUEST['do'] == 'newthread')
{
$flag = 1;
$condflag = 1;
}else {
$condflag = 0;
}
} else {
$condflag = 0;
}

// Rule #18 : Show Rules on New Post....
if ($rules['newreply'])
{
if ($_REQUEST['do'] == 'newreply' or $_REQUEST['do'] == 'postreply')
{
$flag = 1;
$condflag = 1;
}else
$condflag = 0;
} else {
$condflag = 0;
}

// Rule #19 : Show Rules on View Forum....
if ($rules['viewforum'])
{
if (($fid) and ($_REQUEST['do'] != 'newreply' and $_REQUEST['do'] != 'newthread' and $_REQUEST['do'] != 'postreply'))
{
$flag = 1;
$condflag = 1;
}else {
$condflag = 0;
}
}
} else {
$condflag = 0;
}

// Rules End ... Thank you

if ($rules['conditions'])
if ($condflag == 0)
$flag = 0;

if ($flag == 1)
{
$ruletitle = $rules['ruletitle'];
$ruleid = $rules['ruleid'];
if ($rules['allowbbcode'])
{
require_once(DIR . '/includes/class_bbcode.php');
$bbcode_parser =& new vB_BbCodeParser($vbulletin, fetch_tag_list());
$ruletextbit = $bbcode_parser->parse($rules['ruletext']);
}
else
{
$ruletextbit = $rules['ruletext'];
}
eval('$ruletext .= "' . fetch_template('ruleshack_rulesbit') . '";');
$i++;
}
}
return $ruletext;
}

function update_rules($rid = '', $f = 0)
{
global $vbulletin ;

// You gotta agree on this

if ($rid)
{
$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "user SET agreedrule = '" .
iif($vbulletin->userinfo['agreedrule'], $vbulletin->userinfo['agreedrule'] . ",", "") . $rid . "'
WHERE userid = " . $vbulletin->userinfo['userid']);

vbsetcookie("rules[". $rid ."]",$rid);

if ($_REQUEST['do'] != 'postreply')
exec_header_redirect($vbulletin->GPC['oldurl']);
}

return 1;
}

function fetch_user_agreed_rules()
{
global $vbulletin, $threadinfo, $userinfo;

if ($_REQUEST['find'] == 'lastposter' AND $userinfo)
{
$uid = $userinfo['userid'];
}
$uid = iif($_REQUEST['u'], $_REQUEST['u'], $uid);
if ($uid > 0)
{
$Ruser = fetch_userinfo($uid);
$ruleids = iif($Ruser['agreedrule'], $Ruser['agreedrule'], 0);
$result = $vbulletin->db->query("SELECT * from " . TABLE_PREFIX . "ruleshack
WHERE ruleid in ($ruleids) AND ruleurl <> ''");

while ($ruleinfo = $vbulletin->db->fetch_array($result))
{
$agreedrules .= "<tr><td><a href='" . $ruleinfo['ruleurl'] . "'>" . $ruleinfo['ruletitle'] . "</a></td></tr>";
}
}
return $agreedrules;
}

Then setup a rule with URL "all" (just type in these three letters in the url field) and set exact match to no.

That's all.

It's kind of a 'dirty' solution but it's working and should not have any negative consequences. I've setup some new forumrules for my 15k+ board and it's working very well.

Best,
Frank

[bcrooms]

How can I change the text in this hack......I want the checkbox to have a Mission Statement of my own writing in it. Where do I change that?

-B

[uae]

Hi together,
Then setup a rule with URL "all" (just type in these three letters in the url field) and set exact match to no.

That's all.

It's kind of a 'dirty' solution but it's working and should not have any negative consequences. I've setup some new forumrules for my 15k+ board and it's working very well.

Best,
Frank

Sorry guys, but I have been busy with the vB Pager hack and did not have the time to add any new featurs to the rules hack.

kommuni, again, I haven't tried your changes yet, but I'll do that as soon as I get the time.


bcrooms, I'm sorry, but I did not get it, are you talking about this text "I have read, and agree to abide by the ....."

if so, then you need to edit phrase "ruleshack_agree_abide_by_rules"
and if you were talking about a whole new rules, then you will need to create a new rule and add whatever text...all that can be done from your ADMINCP, just look @ the screen shots!

[kommuni]

Sorry guys, but I have been busy with the vB Pager

so where is it? :)

[Simplicity]

Im using vb 3.5.3 and get the following error when trying to import the product xml.

Database error in vBulletin 3.5.3:

Invalid SQL:
INSERT INTO cron (weekday, day, hour, minute, filename, loglevel, title )
VALUES (-1, -1, 0, 'a:1:{i:0;i:-1;}', './includes/cron/cron_ruleshack.php', 1,
'Rules and User Agreement Hack Reset');

MySQL Error : Table 'vbsd.cron' doesn't exist
Error Number : 1146
Date : Thursday, January 5th 2006 @ 11:11:05 PM
Script : http://www.mydomain/alpha/forum/admincp/plugin.php
Referrer : http://www.mydomain/alpha/forum/admincp/plugin.php?do=productadd
IP Address : #hidden#
Username : #hidden#
Classname : vB_Database

I see that I am missing a table, is this something vbulletin is supposed to create on installation or do I need to manually create the table?

[moonclamp]

Just want to clarify something before I start.

Down the bottom of the admin page it has an option of applying the rule on "first time posting a thread" and on a "new reply"

Does this mean that the rule will have to be agreed for every single reply or just the first reply in that forum?

If all those boxes were ticked (ie viewing, thread posting, replying) would the user have to agree to the same rules repeatedly for every single action?

[IrPr]

Im using vb 3.5.3 and get the following error when trying to import the product xml.



I see that I am missing a table, is this something vbulletin is supposed to create on installation or do I need to manually create the table?

works fine on 3.5.3 for me

seems u must add db prefix manually, but i donno how

[blackpudding]

help - this was working for the first few days but now it is showing every time a user clicks on a message.

it is set for When Viewing Forum, set to reset every 12 hours but everyone, including me, is having to agree every page view.

any ideas?

thanks

[Developer]

installed

[2fast4ya]

its not showing up on the memberinfo page... why?

[exnor]

This hack doesn't work with MySQLi...

When importing the product XML:

Fatal error: Cannot use object of type mysqli_result as array in /my/webroot/admincp/plugin.php(1239) : eval()'d code on line 35

[2fast4ya]

its not showing up on the memberinfo page... why?

help please :(

[kurtbarker]

hey guyz, just a couple of questions... i've installed it and no problems yet, but I am yet to use it. I just need clarification of a couple of things.

Include Child Forums < Does this mean the rule will cover the child forums automatically, or does this mean it asks the user to approve the rule in the child forums as well

First Time Posting a Thread in this Forum > Does this apply to users that haven't posted in the forum at all, or to all users that haven't posted in a forum SINCE the implementation of the rule mod

New Thread Posting > Does this rule get asked everytime you create a new thread, or only once.

New Reply Posting > Does this rule come up on every reply, or only once per forum?

When Viewing Forum > I asume this only comes up once per forum

Sorry for all the questions guyz but it seems that if you do the wrong thing you could bombard your users with rule acceptance screens.

If I leave the User or Usergroups to send to [blank], will it send to everyone?

Last thing: Rule's Page URL > what goes in here... I asume the actual rule goes in the "Rule's Text", so does the forum or thread link relating to the rule go in here?

Thanks guyz,
Kurt

[Dreamchaser]

Installed in vB 3.5.3 and works great! Clicked Install :)!!

[IrPr]

seems doesnt work with Danny.VBT Profile Commenting System :(

[argash]

I've just installed and everything seems to be working fine just one small problem the user profile is not displaying that what rules a user has agreed to. I've double checked that I edited the template properly yet its still not working. Any ideas?

For example: http://www.texasmagicleague.com/forums/member.php?u=14

[argash]

upon further examination it doesnt look like anything is stored in the $agreedrules variable thus the if statement is failing

[kurtbarker]

hey mate, I stoped using this hack when my questions weren't answered... found is really hard to distinguish what I had to 'check' to implement a rule, now using another on this site...

but in regards to your question, did you provide a link? coz as far as i've read, without the link field fill in, it won't show you the agreed to rules

[IrPr]

seems doesnt work with Danny.VBT Profile Commenting System :(

is it possible to use another hook location or exclude some area ( THIS_SCRIPT ) ?

[vietfancy]

great hacks! installed

[argash]

if you are talking about the Rule's Page URL field which is just under the rule's text field in the Add New Rule Page in ADMINCP, that would be the url to the rules and agreement page you've got already, if there was one, filling this field with a url will have the rules listed in the member profile page whenever they submit to agree on that rules.. Ok I got that part working. Now I would like it to were when I click on a rules set that a user has agreed to that It display that ruleset. How can I find the URL for that?

[LJR]

Hey this is neat! Got it running on my test server great. Will be installing live very soon.

Thanks

[Diggazz]

Another great hack UAE great work

[dethfire]

Just a small bug. It is possible to post in a forum without applying to it's rules. Simply going directly to a topic, and logging in afterwards.

[dxguru]

What would be good is this ...

Instead of having to set up a 2nd page to use for the MEMBERINFO link, why not have that link go to a templated page that shows the text you have entered in the rule?

[TeaTree]

Installed really easliy and works brilliantly-Thanks!

[blackpudding]

i'm having problems with this on our board. the problem seems to happen after midnight. the agreement keeps coming up, and often after you tick it the next page says that the post was too short and the text box comes back blank, which wipes your message out!

i've just reset it manually and it seems ok again.

any ideas? thanks

[designBox]

This is exactly what i was looking for.
Thank you very much for this usefull (and needed) contribution.

INSTALL clicked. :)

[dxguru]

I tried copying the "Agreed Rules" from the MEMBERINFO template to the USERCP template but nothing shows up.

Has anybody been able to do this successfully?

[dxguru]

Have also found a possible bug ... rules are working fine except they appear when a member first views the forum even though I dont have that option selected (I do have all the others ticked)

[dxguru]

Another issue ...

I have a rule that covers 'all' forums (using the hack provided earlier) and an additional rule for a specific forum.

If I go to the specific forum I will get the Site Rule and then access to the forum. What happened to the forum specific rule?

[ryansmith]

I have an issue too.

I have been using this for quite a while, and I love it. However, tonight I logged out of my forum and viewed it as a Guest. While in Guest mode, if I clicked on a forum, it brought me to the Rules I have set for that forum. I checked "I agree" and tried to proceed, but then it tells me I'm not logged in/must be a member.

I checked in the AdminCP under the "Edit Rule" option and the only usergroups selected are the registered members and my moderators... there's no checkbox next to Unregistered/Not logged in, COPPA, or Users Awaiting Email Confirmation.

Any idea how to work around this? I'd like guests to be able to see our forums still. I only need them to agree to the rules if they are joining and posting.

Ryan

[Smiry Kin's]

does this work with 3.5.4 ? i really need something like this? :S

[Smiry Kin's]

hmm seems to work in 3.5.4 no problem yet..

anyone have a rough spam template? if you get what i mean??. .lol

[King Internet]

i'll probably modify this like hell but thanks ;) saves me from writing my own for sure

one thing i'd like to see maybe in the base version is a javascript timer to wait at least like 20 seconds before they can click the agree button, most people might just breeze through it like the rules at registration.

[Quarterbore]

I got it installed and I am posting here so it is easier for me to find this later... I really needed this one lately!

[bada_bing]

Sounds like a great hack I will keep this in mind

[jadkar]

Did anyone ever figure out or fix why this hack will not work with MySQLi :(

I have this running in DEV with great results but it's not loading in my production environment because I use MySQLi there.

Conversely, does anyone know if I can disable MySQLi while my forum is up and running? Or can this only be enabled/disabled during the install??

If someone can answer my question it would be greatly appreciated :)

Thanks

[IrPr]

SQL ERROR !
when opening http://forum.domain.com/index.php?\
i got this error
caused by \ near quotation mark --> \'

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM ruleshack
WHERE (fileurl LIKE 'http://forum.domain.com/index.php?\' AND exactmatch = 1 )
OR (fileurl LIKE 'http://forum.domain.com/index.php%' AND exactmatch = 0 ) AND active = 1 ORDER BY ruleid;

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 'http://forum.domain.com/index.php%' AND exactmatch = 0 ) AND active = 1 ORDER' at line 2
Error Number : 1064
Date : Saturday, March 18th 2006 @ 10:19:28 PM
Script : http://forum.domain.com/index.php?\
Referrer :
IP Address : PRIVATE;)
Username : ME!
Classname : vb_database


HOW TO FIX?

[rmwebs]

Does this alow google and other crawlers to be able to see the threads? Otherwise half your content wont get indexed...

[kurtbarker]

easy way to check this is *provided you have it installed* sign out of your forum, go directly to the thread link, and see if you get the rules page, or the content

[TheHeartSmasher]

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM vbruleshack
WHERE (fileurl LIKE 'http://www.teamcronus.net/forums/private.php' AND exactmatch = 1 )
OR (fileurl LIKE 'http://www.teamcronus.net/forums/private.php%' AND exactmatch = 0 ) AND active = 1 ORDER BY ruleid;

MySQL Error : Table 'forumsvb.vbruleshack' doesn't exist
Error Number : 1146
Date : Sunday, April 16th 2006 @ 08:43:45 PM
Script : http://www.teamcronus.net/forums/private.php
Referrer : http://www.teamcronus.net/forums/private.php?do=newpm&pmid=18
IP Address : 000.000.000.000
Username : TheHeartSmasher
Classname : vb_database

I get that error when I installed the product

[Rude Awakening]

Excellent hack. Works perfect for what Im working on. You have no idea how much in need I was for something like this :)

Props!

[antialiasis]

When I try to import it, I get "Importing Product - Please Wait..." and it never seems to finish being imported.

[JD210]

When I click on agree and submit, browser takes me to this URL

http://www.agalico.com/php/php.exe?f=65...

Security Alert! The PHP CGI cannot be accessed directly.

This PHP CGI binary was compiled with force-cgi-redirect enabled. This means that a page will only be served up if the REDIRECT_STATUS CGI variable is set, e.g. via an Apache Action directive.

I ran into the exact same problem. Any idea why and what is causing it?

[bashy]

Hi peeps

I appear to have an uncached template for "forumrules"
The only thing that i can think of thats caused this would be this hack perhaps?

Can anyone advise please?

[Rude Awakening]

UAE if you ever manage to see this I've got a slight problem. I've noticed that some of the other guys have this issue too.

I wanted the Rules hack to only work for the Registered Users and not Guests. I wanted the Guests to freely surf the forums, but once registered, required to accept the Rules.

Right now even a guest is required to accept the hack which is pretty bad for Crawlers and Bots. I might be missing something but until then I'll have to uninstall.

Thanks.

Update:

Although I didnt find a way to solve the problem above, I did find a way around it. Instead of having it show up when "viewing" a thread I switched it to "new thread" and "new reply". Guests cant post replies or new threads on my forums anyways. :)

Sometimes you just gotta beat the system ;)

[Bubble #5]

How should we fix this?

Instead of becoming part of the Forums and Moderators section, it started its own Forum and Moderators section so now we have two of them showing :(

How/where do we rename it?

[Bubble #5]

What are the two new templates called, and where (what section) can we find them?

[SimCityForum]

I've discovered one can force a SQL error by adding a single quote to an URL for a registration confirmation (e.g. http://gfxcontests.com/register.html?a=act&u=312&i=19120597'). Apparently there isn't an error checking to clean URLs of stray single quotes before passing them into the SQL string to look for rules that belong to said URL.

A full version of the error result is:
Database error in vBulletin 3.5.3:

Invalid SQL:
SELECT * FROM tblruleshack
WHERE (fileurl LIKE 'http://gfxcontests.com/register.html?a=act&u=312&i=19120597'' AND exactmatch = 1 )
OR (fileurl LIKE 'http://gfxcontests.com/register.html%' AND exactmatch = 0 ) AND active = 1 ORDER BY ruleid;

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 'http://gfxcontests.com/register.html%' AND exactmatch = 0 ) AND
Error Number : 1064
Date : Thursday, May 4th 2006 @ 08:30:57 PM
Script : http://gfxcontests.com/register.html?a=act&u=312&i=19120597'


Notice how feeding the extra single quote into the URL passes straight into the SQL statement. I could see someone exploiting this to force a SQL injection.

The solution to this error is to find the following statements in the product-rulesagreement.xml file;

$ruleneed = $vbulletin->db->query_first("SELECT * FROM " . TABLE_PREFIX . "ruleshack
WHERE (fileurl LIKE '" . $urluri . "' AND exactmatch = 1 )
OR (fileurl LIKE '" . $scripturl1 . "%' AND exactmatch = 0 ) AND active = 1 ORDER BY ruleid");


AND


$sql = "SELECT * from " . TABLE_PREFIX . "ruleshack
WHERE
(
(forumid = $fid)
OR
(fileurl LIKE '" . $urluri . "' AND exactmatch = 1 )
OR
(fileurl LIKE '" . $scripturl1 . "%' AND exactmatch = 0 )
OR
(forumid IN ($parents))
)
AND
(ruleid not in (" . $vbulletin->userinfo['agreedrule'] . "))
AND
active = 1
ORDER BY ruleid";


and add the following code above the two statements above:

$urluri = addslashes($urluri);
$scripturl1 = addslashes($scripturl1);


If you have already installed this mod, then use the plugin manager to find "Hook Location : parse_templates" and edit "Rules And User Agreement" to add in the code above.

[bashy]

Hi

Whoopsy, wrong hack :o

[arossphoto]

Is there any way to use this with paid subscriptions, so the user has to agree to my rules regarding cancellations, refunds, etc?

Thanks,

Andrew

[Bubble #5]

Is there any way to use this with paid subscriptions, so the user has to agree to my rules regarding cancellations, refunds, etc?

Ummm... shouldn't that be handled before the initial payment is made? ;)

[arossphoto]

Ummm... shouldn't that be handled before the initial payment is made? ;)

Yes, of course. That's what I'm talking about.

[Bubble #5]

Yes, of course. That's what I'm talking about.
Oh OK, 'cuss it sounded like you were trying to handle this at the time of the refund ;) You might want to have a look at Bills Easy PayPal hack. You could easily customize it for what you have in mind :)

[arossphoto]

You might want to have a look at Bills Easy PayPal hack. You could easily customize it for what you have in mind :)

Really? Maybe I'll ask over there, but I had a look at it and I don't see any mention of rules or T&C prior to purchase.

[JohnBee]

Very strange..
I installed the hack and although everything slipped in without a hitch there is no rule or agreement popup when I enter the assigned forum.

I ran this before on an earlier forum, worked fine. But this time its as though its not even installed (front end wise) everything is there as far as the CP is concerned.

Any ideas?

[JohnBee]

Okay I found it!

This MOD "vbPluginOrder 1.0" does not seem to allow the agreement page to come up, I will look into it with the author.

thx

[JohnBee]

I have one small question, is it possible to adjust the size of the user agreement form? I find it a little short for my needs.

[Robbed]

I have one small question, is it possible to adjust the size of the user agreement form? I find it a little short for my needs.

I went to this template ruleshack_rulesbit

Found this line

<div class="page" style="border:thin inset; padding:$stylevar[cellpadding]px;<if condition="!is_browser('konqueror')"> height:750px; overflow:auto</if>">

Change the bolded number to suit your needs.

[Robbed]

When I use a forum link OR

from File URL e.g: http://www.DOAIMN.com/FORUM/file.php

Why does it apply to everyone?

[JohnBee]

I went to this template ruleshack_rulesbit

Found this line

<div class="page" style="border:thin inset; padding:$stylevar[cellpadding]px;<if condition="!is_browser('konqueror')"> height:750px; overflow:auto</if>">

Change the bolded number to suit your needs.

I'm afraid that does not work :(
I think that is a conditional for overflow in alternate browsers or something not sure, whatever it is it does not change the height of the R&A form.

[ang2el]

it looks cool, I will install it

[angB]

I am getting this error each time I try and upload--> XML Error: not well-formed (invalid token) at Line 1 or XML Error: unknown at Line 0. What could be the challenge? Thanks!

[webgroup]

Just by installing the product I got this error in the whole forum:

Fatal error: Cannot redeclare check_rulesneeded() (previously declared in /home/xxxx/public_html/xxxxx/global.php(503) : eval()'d code:80) in /home/xxxxxx/public_html/xxxxxx/global.php(503) : eval()'d code on line 548

PLUS, i got this error message on my email:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM vbnewruleshack
WHERE (fileurl LIKE 'http://www.xxxxxxx.net/xxxxxx/member.php?s=&u=10538' AND exactmatch = 1 )
OR (fileurl LIKE 'http://www.xxxxxx.net/xxxxxxx/member.php%' AND exactmatch = 0 ) AND active = 1 ORDER BY ruleid;

MySQL Error : Table 'XXXX.vbnewruleshack' doesn't exist Error Number : 1146
Date : Thursday, June 1st 2006 @ 12:25:58 PM
Script : http://www.xxxxxxxxx.net/xxxx/member.php?s=&u=10538



I'm running 3.5.4, any ideas???

[imranbaig]

This is a Great Hack!
Thank you very much m8

[webgroup]

Just by installing the product I got this error in the whole forum:

Fatal error: Cannot redeclare check_rulesneeded() (previously declared in /home/xxxx/public_html/xxxxx/global.php(503) : eval()'d code:80) in /home/xxxxxx/public_html/xxxxxx/global.php(503) : eval()'d code on line 548

PLUS, i got this error message on my email:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM vbnewruleshack
WHERE (fileurl LIKE 'http://www.xxxxxxx.net/xxxxxx/member.php?s=&u=10538' AND exactmatch = 1 )
OR (fileurl LIKE 'http://www.xxxxxx.net/xxxxxxx/member.php%' AND exactmatch = 0 ) AND active = 1 ORDER BY ruleid;

MySQL Error : Table 'XXXX.vbnewruleshack' doesn't exist Error Number : 1146
Date : Thursday, June 1st 2006 @ 12:25:58 PM
Script : http://www.xxxxxxxxx.net/xxxx/member.php?s=&u=10538



I'm running 3.5.4, any ideas???

anybody?

[Essam]

is there way or script to see who agreed for the rule in individual page ?

[Bubble #5]

is there way or script to see who agreed for the rule in individual page ?
Everyone who can access that forum has agreed to it. A list wouldn't be needed as that would be redundant :bunny:

[redlabour]

Will it work in the Future with vBulletin 3.6 (http://www.vbulletin.com/forum/showthread.php?t=187654) ?

[TheHeartSmasher]

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM vbruleshack
WHERE (fileurl LIKE 'http://www.teamcronus.net/' AND exactmatch = 1 )
OR (fileurl LIKE 'http://www.teamcronus.net/%' AND exactmatch = 0 ) AND active = 1 ORDER BY ruleid;

MySQL Error : Table 'xxxxxxx.vbruleshack' doesn't exist
Error Number : 1146
Date : Thursday, June 8th 2006 @ 05:54:56 PM
Script : http://www.teamcronus.net/
Referrer : http://www.teamcronus.net/forums/memberlist.php?ltr=V&pp=0&sort=username&order=asc
IP Address : xxxxxxxxxxx
Username : TheHeartSmasher
Classname : vb_database

This is the error I get

Do you have a sql statment that I can use to create the table, or if anyone has one please post it.for the vbruleshack table.

I see two versions this one and a version 1.1.1 that always comes back even after I uninstall.

[webgroup]

Just by installing the product I got this error in the whole forum:

Fatal error: Cannot redeclare check_rulesneeded() (previously declared in /home/xxxx/public_html/xxxxx/global.php(503) : eval()'d code:80) in /home/xxxxxx/public_html/xxxxxx/global.php(503) : eval()'d code on line 548

PLUS, i got this error message on my email:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM vbnewruleshack
WHERE (fileurl LIKE 'http://www.xxxxxxx.net/xxxxxx/member.php?s=&u=10538' AND exactmatch = 1 )
OR (fileurl LIKE 'http://www.xxxxxx.net/xxxxxxx/member.php%' AND exactmatch = 0 ) AND active = 1 ORDER BY ruleid;

MySQL Error : Table 'XXXX.vbnewruleshack' doesn't exist Error Number : 1146
Date : Thursday, June 1st 2006 @ 12:25:58 PM
Script : http://www.xxxxxxxxx.net/xxxx/member.php?s=&u=10538



I'm running 3.5.4, any ideas???


Anybody?

[Quarterbore]

Strange new error on my website.... Trying to figure out is this mod is related...

Today I reformated my forums so that all my forums are now children under one form and the main reason I did this was to allow me to use this rules hack on all of my forums when I update my Code Of Conduct....

Well, I made the change this morning and I created a new rule for my "Updated Code" and I applied it to my new parent forum and all children (ALL FORUMS ON MY WEBSITE).

Well, after doing this I have got more then a few complaints about the following error:

Fatal error: Call to undefined function: preg_replace() in /home/MYSERVER/public_html/includes/class_core.php on line 1871

Following is the code from the includes file:


function strip_sessionhash(&$string)
{
$string = preg_replace('/(s|sessionhash)=[a-z0-9]{32}?&?/', '', $string);
return $string;
}

I have not turned off the rule yet as I am trying to see if there is any pattern to who is getting the error. I am also curious if there would be a problem if I have a rule that affects the parent and childern if one of the children has a second rule that also applies to it?

I have tried to reproduce the error on my computers with no luck but I have heard from half a dozen people that have had issues... Several of those are on AOL of all places so who knows...

[SupremeWeapon]

doesnt work for me. doesnt pull up any type of rules page when the selected area is reached.

[Bubble #5]

Will it work in the Future with vBulletin 3.6 ?
Does anyone know if it's safe to install this in 3.6.2? :confused:

[COBRAws]

Does anyone know if it's safe to install this in 3.6.2? :confused:
3.6.2 doesnt exist.


Im getting this SQL error

Database error in vBulletin 3.5.4:

Invalid SQL:
INSERT INTO ruleshack
(forumid, ruletitle, ruletext, ruleurl, firstnewthread, groupids, memberids, userids,
usernames, postmore, postless, joindateafter, joindatebefore,
lastactiveafter, lastactivebefore, lastpostafter, lastpostbefore,
conditions, allowbbcode, active, repeat, childforum, newthread, newreply, viewforum, fileurl, exactmatch)
values ('58', 'Seccion Pedidos', 'texto de regla', 'http://xxxxxxxxx/forumdisplay.php?f=58', '1',
'4,6,15,3,1,14,7,2,18,17,19,12,10,5,8', '', '', '', '0',
'0', UNIX_TIMESTAMP(''),
UNIX_TIMESTAMP(''), UNIX_TIMESTAMP(''),
UNIX_TIMESTAMP(''), UNIX_TIMESTAMP(''),
UNIX_TIMESTAMP(''), '0', '1', '1', '0', '0', '1', '1', '0', '',
'0');

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 'repeat, childforum, newthread, newreply, viewforum, fileurl, exactmatch)
' at line 5
Error Number : 1064
Date : Tuesday, June 27th 2006 @ 06:54:16 PM
Script : http://xxxxxxxxx/admincp/rulesagreement.php
Referrer : http://xxxxxxxxx/admincp/rulesagreement.php?do=rule
IP Address : xxxxxxxxx
Username : xxxxxxxxx
Classname : vB_Database_MySQLi

[shoupz]

great hack, i got it working but it doesnt show up in the profile after i did the templete edit, but still great hack! cheers.

[Blue-Inc]

Great Modification, works perfectly. Thank you for making it.

[COBRAws]

Great Modification, works perfectly. Thank you for making it.
You guys using MySQL 4 or 5?

[Brian31fl]

is there a guide on how to use it like setting up a rule?

[Blue-Inc]

You guys using MySQL 4 or 5?

MyQSL 4 ;)

is there a guide on how to use it like setting up a rule?

Look at the screen shot(s).

[Brian31fl]

MyQSL 4 ;)



Look at the screen shot(s).

that still doesnt show ecatly what to fill in and explain how it used

[COBRAws]

MyQSL 4 ;)
I supposed. I use MySQL 5 and this hack doesnt work.

[Ugga Bugga]

what does this step mean?

Step 4. Import product-rulesagreement.xml

[TMAC]

what does this step mean?

That means to go to your plugin sytem and import the file. You will find this near the bottom of your left hand admin control panel navigation menu.


This is a great hack, easy to install and works great! Testeted.

Clicks Install:)

[blackshadowc4p]

Question: I have just one forun where I enabled this (installed version 1.1.5). Altough I have it to show only for Full Members, all my moderators, supermods and me (only admin on primary usergroup, no secondary usergroup) have to agree with the rule. Why?

[Hornstar]

Originally Posted by uae
if you are talking about the Rule's Page URL field which is just under the rule's text field in the Add New Rule Page in ADMINCP, that would be the url to the rules and agreement page you've got already, if there was one, filling this field with a url will have the rules listed in the member profile page whenever they submit to agree on that rules..

Where do I find the URL to insert, im confused on this step.

[tommykjensen]

Will this be updated for vb 3.6 ?

[Peter_Rosado]

I'm having trouble with the profile of a user:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * from theprefixofthedb_ruleshack
WHERE ruleid in (5,3,2,) AND ruleurl <> '';

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 ') AND ruleurl <> ''' at line 2
Error Number : 1064
Date : Monday, July 24th 2006 @ 12:31:28 PM
Script : http://www.mundopoesia.com/foros/member.php?u=3874
Referrer : http://www.mundopoesia.com/foros/private.php?
IP Address :
Username :
Classname : vb_database


The other profiles work well.

[Treak]

DUDE this hack is insane and works like a charm can you for your nex instalment add a mod to it where you can RESTRICT users under 18 from accessing certain forums and or Subforums?
i have a NWS or Not Work Safe subforum in my offtopic section and i want only those that are 18 and up to be able to view it according to the rules.. you can't set permissions based on age in vBulletin but maybe your hack can include that? to where they cannot view the rules cause they are not 18 so they won't see the rules... so they cannot enter that section of the forum cause they cannot agree.. its kinda like setting permissions thru your rules without editing anyone users permissions on the actual forum it self does this make sense?

[ixian]

What's to stop someone from just lying about their age? Which, to access NWS forums, they most certainly will. Seems kind of pointless to me.

[Treak]

What's to stop someone from just lying about their age? Which, to access NWS forums, they most certainly will. Seems kind of pointless to me.
you can choose to have them set that up before they even join.. and you can make it to where they can not edit that part via user permissions.. just not forum specific..

[Treak]

Originally Posted by uae
if you are talking about the Rule's Page URL field which is just under the rule's text field in the Add New Rule Page in ADMINCP, that would be the url to the rules and agreement page you've got already, if there was one, filling this field with a url will have the rules listed in the member profile page whenever they submit to agree on that rules..



Where do I find the URL to insert, im confused on this step.

OK !!! EVERYONE PAY ATTENTION!!!!

this is the easiest way to do this!

go to the section you plan on posting this user agreement for ..

for example.. lets say you have like i have a Not Work Safe Section in your Forum and you want to Set Rules and User Agreements for members so that way when they first VIEW! that NWS forum they have to agree to the rules or else they cannot view that section! GO TO YOUR NWS OR WHATEVER FORUM YOU WANT THE RULES FOR! MAKE A NEW STICKY THREAD! and name it NWS RULES! or whatever your forum name happens to be.

after you have laid out your rules in that thread.. close that thread so no one else can post there.. just all they can do is view those rules..

k now click on that thread so you can see your post... copy that URL from your browser and INSERT THAT LINK INTO THE URL AT THE TOP OF THE NEW RULE! WHERE IT ASKS YOU FOR THE URL FOR THE RULES PAGE!

now! when they view it and agree to it! and you view their PROFILE you will see they agreed to the NWS forum rules! and now when you click on that link that says NWS FORUM RULES! it takes you right to the RULES you POSTED! inside the NWS Forum!

you can use the same rules you just posted.. VIA COPY AND PASTE! and paste them into the New Rule your making for that forum!


so!! this is the effect you get!!

When the User now goes to view the NWS Section of your board they get the rules that THEY MUST AGREE TO! before they can view the forums there! once they click agree they are taken to the NWS forum

now! inside the forum you have your sticky thread up top that has the NWS rules! so the link in their user profile that says they agreed to NWS rules ! THAT LINK WILL TAKE YOU TO YOUR STUCK THREAD THAT HAS YOUR RULES IN IT!!!

hope that clarified alot for you guys.. if not i suck at life and please delete my post lol

[redlabour]

It will be nice if i can check different Sections/Forums to pull the Users to a Rule.

[soletrader]

How do I edit the text in the user agreement?

[louis_chypher]

Originally Posted by uae
if you are talking about the Rule's Page URL field which is just under the rule's text field in the Add New Rule Page in ADMINCP, that would be the url to the rules and agreement page you've got already, if there was one, filling this field with a url will have the rules listed in the member profile page whenever they submit to agree on that rules..



Where do I find the URL to insert, im confused on this step.

Hi, There is a modification Rules Hack for vBulletin 3.5.x by Hasann (https://vborg.vbsupport.ru/showthread.php?t=104044) that I use to create rule pages that holds the rules for my web site. I go to those pages of rules I created with Rules Hack for vBulletin 3.5.x by Hasann (https://vborg.vbsupport.ru/showthread.php?t=104044), copy the urls and paste them into the url location for this modification.

It would be great if this modification could be combined with the Rules Hack for vBulletin 3.5.x by Hasann (https://vborg.vbsupport.ru/showthread.php?t=104044) modification. nudge, nudge.

[louis_chypher]

you can choose to have them set that up before they even join.. and you can make it to where they can not edit that part via user permissions.. just not forum specific..


Hi, While there is nothing to stop anyone from lieing about their age you can protect yourself (your site) by using a few 'tricks', like adding the modification

Age Lock is an all-in-one Forum locking facillity that works off the users age instead of there permissions. It gives you the abillity to keep those Under 18's out of your adult sections (https://vborg.vbsupport.ru/showthread.php?t=118496) and by enabling the COPPA and thorough a modification to the register.php line 99 to reflect only allowing those who say they are 18 or over to access the site:

if ($vbulletin->GPC['year'] < ($current['year'] - 18) OR ($vbulletin->GPC['year'] == ($current['year'] - 18) AND $vbulletin->GPC['month'] <= $current['month']))

That's about the best one can do *shrug*.

[mhammed]

great hack,
but the font size rules is too small . how can I increase it

[louis_chypher]

great hack,
but the font size rules is too small . how can I increase it

<font size=X>rule text</font> works for me.

[mhammed]

<font size=X>rule text</font> works for me.
very easy to say :D
but where you put this in the code? :surprised:

[Chris Lang]

I've installed this hack, and it works fine for the forums, but I can't get it to function with Private.php (PMs)

I'm using the format http://mydomain.com/forum/private.php (and every variation, including www, etc) but no luck. Any ideas?

[Neo_obs]

I've installed this hack, and it works fine for the forums, but I can't get it to function with Private.php (PMs)

I'm using the format http://mydomain.com/forum/private.php (and every variation, including www, etc) but no luck. Any ideas?

disregard I fixed this the conditionals were set up wrong

[ryansmith]

Is this going to be released for vB 3.6, or is someone working on something similar?

[moonclamp]

My webhost recently upgraded our version of mySQL to 5.0.21

Ever since then I have been getting the following error email:

Invalid SQL:
SELECT * FROM vb_ruleshack WHERE repeat = 1 AND active = 1;

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 '= 1 AND active = 1' at line 1 Error Number : 1064
Date : Sunday, August 6th 2006 @ 12:30:00 AM
Script : http://xxxxx/forums/cron.php?&rand=463803
Referrer : http://xxxxx/forums/showthread.php?t=3943&page=4
IP Address : 1xx.9x.21.xx
Username : Unregistered
Classname : vB_DatabaseIt doesn't seem to affect anyone, just getting loads of emails telling me about the error.

None of my rules reset themselves, is it safe to just turn off the cron?

[Lionel]

How can I make those rules bilingual?

[Cibox.de]

Doesn't work with 3.6.
Is there an update planned?

[Whissi]

What's the problem?

[Chicago_VLNU_4s]

how come it's not working when i try to test post a new message? i have it aimed to the proper thread and i selected the Rules to show up by clicking yes for all options and the only rules screen i get is the first time visiting that thread.... any ideas?

[Aaron RV]

work on vb 3.6.0?

[dethfire]

no it doesn't work yet, really need though

[COBRAws]

My webhost recently upgraded our version of mySQL to 5.0.21

Ever since then I have been getting the following error email:

It doesn't seem to affect anyone, just getting loads of emails telling me about the error.

None of my rules reset themselves, is it safe to just turn off the cron?
I have the same problem, posted in reply #172 (https://vborg.vbsupport.ru/showpost.php?p=1016989&postcount=172)

No help provided yet. :S ill have to un-install this hack.
For the old rules it works great, but when trying to set up new ones, it doesnt.

[Ntfu2]

Fix for 3.6 attached. Basically just changed the title in cron to varname

I did this on a fresh install of the modifciation on 3.6 and worked fine. I can not assume the same for previous installs, so please test on your test board first.

[alfaowner]

Should this work on a file location as my example: http://www.xyz.com/forum/classifieds/index.php ?? As currently I cannot get it to work for url's. I am running 3.5.4

[steven s]

Should this work on a file location as my example: http://www.xyz.com/forum/classifieds/index.php ?? As currently I cannot get it to work for url's. I am running 3.5.4
Yes it should. I use this before someone can view myforum/newthread.php?do=hpde
Also check your usergroups.

[heyitsjeremy]

great mod. but could a countdown timer be done for this as well ? so before anyone can proceed, he/she has to wait for the timer to countdown ?

and other then making it to appear in different forums/sub forums, could i make it appear for specific threads ?

[alfaowner]

Yes it should. I use this before someone can view myforum/newthread.php?do=hpde
Also check your usergroups.

Thanks for the reply 1996 328ti,

What would I check in usergroups exactly? Sorry for being a bit dim here.

[Kriminal]

My webhost recently upgraded our version of mySQL to 5.0.21

Ever since then I have been getting the following error email:

It doesn't seem to affect anyone, just getting loads of emails telling me about the error.

None of my rules reset themselves, is it safe to just turn off the cron?

The word repeat is reserved for MySQL 5, and cannot be used as field name
http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

I'm trying to bypass this error renaming the field name or doing something with the query; when I get any solution I'll post it here.

[Simplicity]

What would need to be edited for version 3.6, from what I can see the ruleshack table wouldnt be created, any other problems in the other files?

[The Realist]

Working fine with 3.6.0 using https://vborg.vbsupport.ru/showpost.php?p=1063222&postcount=208

Laters

[Kriminal]

What would need to be edited for version 3.6, from what I can see the ruleshack table wouldnt be created, any other problems in the other files?

I think it wolud be the same problem: "repeat" could not be a field name in MySQL 5
I finally made a modification to original plugin, changing repeat for repeated everywhere it appears.
PLEASE, backup before using this. It's working for me, but it doesn't means that it would work for everybody.

[alfaowner]

what can be checked if it is not protecting forum/classifieds/index.php

many thanks

[nimonogi]

I think it wolud be the same problem: "repeat" could not be a field name in MySQL 5
I finally made a modification to original plugin, changing repeat for repeated everywhere it appears.
PLEASE, backup before using this. It's working for me, but it doesn't means that it would work for everybody.

The installation process was successfull but when i'm trying to Add New Rule i'm getting a mysql error.


Database error in vBulletin 3.6.1:

Invalid SQL:
INSERT INTO ruleshack
(forumid, ruletitle, ruletext, ruleurl, firstnewthread, groupids, memberids, userids,
usernames, postmore, postless, joindateafter, joindatebefore,
lastactiveafter, lastactivebefore, lastpostafter, lastpostbefore,
conditions, allowbbcode, active, repeated, childforum, newthread, newreply, viewforum, fileurl, exactmatch)
values ('6', 'Text', 'Text[/b]', '', '0',
'2', '', '', '', '0',
'10', UNIX_TIMESTAMP(''),
UNIX_TIMESTAMP(''), UNIX_TIMESTAMP(''),
UNIX_TIMESTAMP(''), UNIX_TIMESTAMP(''),
UNIX_TIMESTAMP(''), '1', '1', '1', '1', '1', '1', '0', '0', '',
'0');

MySQL Error : Unknown column 'repeated' in 'field list'
Error Number : 1054
Date : Friday, September 22nd 2006 @ 05:55:25 AM
Script : http://www.domain.com/admincp/rulesagreement.php?do=submitrule
Referrer : http://www.domain.com/login.php?do=login
IP Address : ***
Username : ***
Classname : vb_database

[Kriminal]

The installation process was successfull but when i'm trying to Add New Rule i'm getting a mysql error.


Database error in vBulletin 3.6.1:

Invalid SQL:
INSERT INTO ruleshack
(forumid, ruletitle, ruletext, ruleurl, firstnewthread, groupids, memberids, userids,
usernames, postmore, postless, joindateafter, joindatebefore,
lastactiveafter, lastactivebefore, lastpostafter, lastpostbefore,
conditions, allowbbcode, active, repeated, childforum, newthread, newreply, viewforum, fileurl, exactmatch)
values ('6', 'Text', 'Text[/b]', '', '0',
'2', '', '', '', '0',
'10', UNIX_TIMESTAMP(''),
UNIX_TIMESTAMP(''), UNIX_TIMESTAMP(''),
UNIX_TIMESTAMP(''), UNIX_TIMESTAMP(''),
UNIX_TIMESTAMP(''), '1', '1', '1', '1', '1', '1', '0', '0', '',
'0');

MySQL Error : Unknown column 'repeated' in 'field list'
Error Number : 1054
Date : Friday, September 22nd 2006 @ 05:55:25 AM
Script : http://www.domain.com/admincp/rulesagreement.php?do=submitrule
Referrer : http://www.domain.com/login.php?do=login
IP Address : ***
Username : ***
Classname : vb_database


If you have installed this hack previously, yo must alter table manually and change field repeat as repeated.
You may run this query:

alter table `ruleshack` change `repeat` `repeated` smallint (1) DEFAULT '0' NOT NULL

[nimonogi]

Thanks a lot!

[COBRAws]

I think it wolud be the same problem: "repeat" could not be a field name in MySQL 5
I finally made a modification to original plugin, changing repeat for repeated everywhere it appears.
PLEASE, backup before using this. It's working for me, but it doesn't means that it would work for everybody.
Hey Kirminal, never saw you around ;)
Cheers

[Kriminal]

Hey Kirminal, never saw you around ;)
Cheers
Because psico (https://vborg.vbsupport.ru/member.php?u=71) was in charge to support the forum; but now I assumed all technical task... and the first one is moving a hardly hacked 3.010 to 3.61. :nervous:

So, thanks for noticing and sorry for my english.

[trackpads]

Mega thanks for getting this to run in 3.6! I will try it out tonight!!

Thanks!!!

-Jason

[oldfan]

anyone get the template "memberinfo" too work?

[Silver_Seagull]

I'm running 3.5.4 and this hack isn't applying the rules to the usergroups I select. It is applying them to everyone, regardless of usergroups selected.

It is also randomly only applying the rule display to only Replies, or only New Threads....despite having First Time Posting a Thread in this Forum, New Thread Posting and New Reply Posting checked.

Is this broken?

[sduckie2k5]

^^^ Same here, chose all usergroups except mods and admin and it still applies to them as well.

[cyberbeggar]

I am getting this error message after accepting the rules:

Method Not Allowed
The requested method POST is not allowed for the URL /index.html.


--------------------------------------------------------------------------------

Apache/1.3.34 Server at www.mysite.com Port 80

[cyberbeggar]

I am getting this error message after accepting the rules:


Anyone?

[jadkar]

I installed vBSEO after this hack has been running for about a year and now it's dead. Does anyone have any expirence using this with vBSEO??

My problem is that as soon as a user agrees to the rules and clicks submit it bounces them back to the main forum index page. :(:(

This hack was instrumental on my site if this can't work does anyone know of a similar one??

Please help :)

[Greek Wizard]

Fix for 3.6 attached. Basically just changed the title in cron to varname

I did this on a fresh install of the modifciation on 3.6 and worked fine. I can not assume the same for previous installs, so please test on your test board first.

Thanks for that.

Installed on a decently modified 3.6.2 and seems to work perfectly.

[tamborinegal]

Thanks so much, this is a great hack! Just what I needed.

Thanks! :)

Clancy

[VietPirates]

^^^ Same here, chose all usergroups except mods and admin and it still applies to them as well.

Same here. It applies to every usergroup.

[MrPHD]

Installed and working fine on 3.6.4. Thanks

[Desesperao]

Installed and working fine on 3.6.4. Thanks
Working fine on 3.6.4?.

I have installed it and it does not work :(

I have imported the product but it gives me error. Any idea?

(vBulletin 3.6.4)

Warning: Invalid argument supplied for foreach() in /includes/functions_cron.php on line 95

Database error in vBulletin 3.6.4:

Invalid SQL:
INSERT INTO cron (weekday, day, hour, minute, filename, loglevel, title )
VALUES (-1, -1, 0, 'a:1:{i:0;i:-1;}', './includes/cron/cron_ruleshack.php', 1,
'Rules and User Agreement Hack Reset');

MySQL Error : Unknown column 'title' in 'field list'
Error Number : 1054
Date : Monday, December 11th 2006 @ 01:23:56 PM
Script : xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/plugin.php?do=productimport
Referrer : xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/admincp/plugin.php?do=productadd
IP Address : xxxxxxxxxxxx
Username : xxxxxxxxxxx
Classname : vb_database

[egyptsons]

looks good

[TMAC]

I would pay for this hack if it was not available free. Thank you again.

[Desesperao]

Please, I need help

https://vborg.vbsupport.ru/showpost.php?p=1136245&postcount=234

[Desesperao]

anybody? :(

[bradyb]

Hi all,

I can see this mod is coded for the 3.x.x. version but I get this message when I execute the installer from the admincp on my 3.6.4 forums:

Fatal error: Call to a member function query_first() on a non-object in /home/XXXXX/public_html/admincp/newthread_rules_install_1_00.php on line 138

Any ideas?

[DPSR]

Anybody update this hack please as it is giving error while adding new rules :(:(

[Bison]

The title table has been removed in vB 3.64 for some unknow reason. That's why this hack is broken. Unless your brave and like dibbling into the database, try creating a 'title' column under CRON table in your database.

[clearchannel]

I take it, it's not going to be possible to make this work in 3.6.4.

OK I've read the responses for those who do have it working, but apprently they are either unwilling to share or they don't actually have it working. Thats a shame.

I will contact the author of this script and offer to pay to port it into my fourms.

[Aur-Phala.Com]

anyone got this workin for 3.6??

[Staxed]

guess this still isn't working for 3.6?

[Bison]

still waiting for this one for 3.6.4 myself. One day someone will port this one over..

[Smoothie]

still waiting for this one for 3.6.4 myself. One day someone will port this one over..yes, hopefully soon! Looks like a great add-on.

[Desesperao]

Anybody update this hack?

PLEASE, HELPPPPPPPPPPPPPPPP

[LadyBeth]

Waiting here also ;)

[cagefighter]

WOW this looks great, i will give this a try. Thanks for your efforts :)

I get same error when trying to install

[michaelk]

Working fine on 3.6.4?.

I have installed it and it does not work :(

I have imported the product but it gives me error. Any idea?

(vBulletin 3.6.4)


Working fine on vb 3.6.4

Open product-rulesagreement.xml

search 2x :

$xxx = $db->query("INSERT INTO " . TABLE_PREFIX . "cron (weekday, day, hour, minute, filename, loglevel, title )

and replace 2x :

$xxx = $db->query("INSERT INTO " . TABLE_PREFIX . "cron (weekday, day, hour, minute, filename, loglevel, varname )


Only, if mySQL 5 one uses:

Implement the following Querry:

alter table `ruleshack` change `repeat` `repeated` smallint (1) DEFAULT '0' NOT NULL

SEARCH in all files of the Hacks:

"repeat" and replace with "repeated"


have fun ;)