Miscellaneous Hacks - Advanced Rules and User Agreement Hack v2.0.0

This modification contains a security vulnerability, you are hereby advised to uninstall until further notice.
- vBulletin.org Staff

Advanced Rules and User Agreement Hack v2.0.0
------------------------------------------------------------
This Hack is Port of UAE's Rules and User Agreement Hack.
And I have this one together combined with my old
"Rules Hack v1.5"

Hack Version: 2.0.0
vB-version: 3.6.4
Developers: UAE and Hasann
Install-difficulty: Easy
Port of: Rules and User Agreement Hack

Requested Here: Hasann was wondering if you and uae who wrote the Rules and User Agreement Hack could get together and combine your modifications into one package?

Introduction:

Advanced 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.

Whats New in this Port Hack?: List of all Rules shows you in /rules.php

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 5 Plugins, and 60 Phrases

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

New templates for this Hack: 5
rules
rulesbit
rulesview
ruleshack_rules
ruleshack_rulesbit

File-edits: 0

Template-edits: 1
MEMBERINFO
navbar

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


################################################## ###########################
############################## TEMPLATE EDITS ###############################
################################################## ###########################

******************************* IN NAVBAR TEMPLATE *******************************

FIND

<td class="vbmenu_control"><a href="memberlist.php$session[sessionurl_q]">$vbphrase[members_list]</a></td>

ABOVE ADD

<td class="vbmenu_control"><a href="rules.php$session[sessionurl_q]">$vbphrase[rules]</a></td>

******************************* IN MEMBERINFO TEMPLATE *******************************

FIND

            <if condition="$vboptions['usereferrer']">

ABOVE ADD

<!-- [START HACK='Rules and User Agreement' by UAE AND HASANN VERSION='2.0.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' by UAE AND HASANN VERSION='2.0.0' CHANGEID= 1 ] -->

################################################## ###########################
############################ EDITS END #############################
################################################## ###########################


PLEASE REMEMBER TO BACKUP BEFORE YOU BEGIN!

[biggeorge]

One problem I just noticed... the rule is being displayed for Unregistered users, although I do not have it checked in User & Usergroup Options.

Any ideas how I can stop this from happening?

[ElForro]

I'm having this Database error.. But i can't reproduce the error... it seems to be random... I think it has to be with VBSeo, but I don't know... any clue?

Database error in vBulletin 3.6.7:

Invalid SQL:
SELECT * FROM foro_ruleshack 
			WHERE (fileurl LIKE 'http://www.elforro.com.ar/fcgi-bin4/php?vbseourl=famosas-y-famosos/51430-backs-cirio-xime-y-claudia-fernandez.html target='_blank'' AND exactmatch = 1 ) 
			OR (fileurl LIKE 'http://www.elforro.com.ar/fcgi-bin4/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 '_blank'' AND exactmatch = 1 ) 
			OR (fileurl LIKE 'http://www.elforro.com.ar/f' at line 2
Error Number : 1064

[ssslippy]

I get database errors whenever there is a ' in a link url.

[PamelaE]

I have the same database errors. Not good. So uninstalled it.

[0tolerance]

i get the database error... and it renders most of my site useless and half of the admin options, so i disabled it.. hoping for a fix to this soon.

the product isnt creating the database tables.