Miscellaneous Hacks - Rules and User Agreement Hack

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
Install-difficulty: Easy
Port of: 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 & this
-> 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

[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]

Originally Posted by 1996 328ti

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]

Originally Posted by moonclamp

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/...ved-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....&postcount=208

Laters

[Kriminal]

Originally Posted by 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?

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]

Originally Posted by Kriminal

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]

Originally Posted by nimonogi

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!