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

[jadkar]

OK I tried again with another port of this producr called 2.0. Still the same exact thing. I'm runnig CMPS and whenever the rule pops up an I ageee to it I get sent back to my main CMPS screen. Then once more if I try to except the rule it doe the same thing.... boncing me back to my min CMPS screen

I find it hard to believe that his doen't happen to anyone else. Any help with this would be much appreciated. I'm suprised people on these forums don;t use this hack mre ofter.

[AngusMacGyver]

I installed the hack and it works almost fine on 3.6.5. Only one issue does't work.
If I choose one usergroup which should see the message, all users of all usergroups see the message. What is wrong in my installation or with my parameters.

[Sax on the Web]

Installed and got a database error. Cannot get to admincp now. Please help!

==========================================
Database error in vBulletin 3.5.4:

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

MySQL Error : Table 'tmp.ruleshack' doesn't exist
Error Number : 1146
Date : Saturday, March 17th 2007 @ 05:17:30 PM
Script : http://forum.saxontheweb.net/

[Rickeo]

Amazing hack

[rjmjr69]

Originally Posted by Mr_Snob

i have this one ported for 3.6.4 and many features added if you would i release it at vb.org

Could you please release. Or PM a copy something? I know your work is good I can only imagine what OTHER features you have made. Thank you

[blogtorank]

Originally Posted by Black Widow

You have MySQL 5 installed.
use the zip file i uploaded just above your post.
It will work then.

Many thanks for the MySQL 5 version!

[stwilson]

Has anyone been able to get this working on 3.6.4 with MySQL 5? I have tried three different times and still only get a bunch of this:

input->clean_array_gpc('r', array('forumid' => TYPE_INT, 'title' => TYPE_STR, 'ruletext' => TYPE_STR, 'ruleurl' => TYPE_STR, 'userids' => TYPE_STR, 'usernames' => TYPE_STR, 'usergroup_all' => TYPE_INT, 'groupids' => TYPE_ARRAY_INT, 'memberids' => TYPE_ARRAY_INT, 'firstnewthread' => TYPE_INT, 'postmore' => TYPE_INT, 'postless' => TYPE_INT, 'joindateafter' => TYPE_STR, 'joindatebefore' => TYPE_STR, 'lastactiveafter' => TYPE_STR, 'lastactivebefore' => TYPE_STR, 'lastpostafter' => TYPE_STR, 'lastpostbefore' => TYPE_STR, 'active' => TYPE_INT, 'conditions' => TYPE_INT, 'action' => TYPE_STR, 'limitstart' => TYPE_INT, 'ruleid' => TYPE_INT, 'allowbbcode' => TYPE_INT, 'repeated' => TYPE_INT, 'childforum' => TYPE_INT, 'newthread' => TYPE_INT, 'newreply' => TYPE_INT, 'viewforum' => TYPE_INT, 'fileurl' => TYPE_STR, 'exactmatch' => TYPE_INT)); if ($vbulletin->GPC['action'] != 'kill') print_cp_header(); if ($_REQUEST['do'] == 'rule') { print_cp_header($vbphrase['ruleshack_rules_manager']); print_form_header('rulesagreement', 'submitrule'); construct_hidden_code('action', 'newrule'); print_table_header($vbphrase['ruleshack_rules_add']); print_input_row($vbphrase['ruleshack_rules_title'], 'title'); print_textarea_row($vbphrase['ruleshack_rules_text'], 'ruletext', ''); print_input_row($vbphrase['ruleshack_rules_url'], 'ruleurl', ''); print_description_row('', 0, 2, 'thead'); print_yes_no_row($vbphrase['allow_bbcode'], 'allowbbcode', 0); print_yes_no_row($vbphrase['ruleshack_rules_repeated'], 'repeated', 0); print_yes_no_row($vbphrase['ruleshack_rules_active'], 'active', 1); print_table_break(); //**************************** // USERGROUP

[blogtorank]

Originally Posted by stwilson

Has anyone been able to get this working on 3.6.4 with MySQL 5? I have tried three different times and still only get a bunch of this:

If you check two pages back you will see this post that one guy fixed it:

https://vborg.vbsupport.ru/showpost....&postcount=266

[stwilson]

Originally Posted by blogtorank

If you check two pages back you will see this post that one guy fixed it:

https://vborg.vbsupport.ru/showpost....&postcount=266

Guess I should have mentioned that in my post. I tried that fix and it produced the results I posted above. Still not working for me. I have uninstalled and reinstalled, followed the instructions to the letter and still the same results. Still looking for someone with 3.6.4 and MYSQL 5 and a running version of this MOD.

[dbirosel]

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

I need help with this too!!!!