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

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

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

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 hornstar1337

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.