Require Users to Sign a Contract Before Posting in an Individual Forum

This is a port of this mod:
https://vborg.vbsupport.ru/showthread.php?t=76835

This little mod forces users to read and sign a "contract" before it allows them to post in certain forums of your choosing. It also allows you to "ticket" users who break your forum rules. After 3 tickets, the user can no longer post in the forum.

You may define a different contract for each of your forums if you so choose.
-------------------------------
YOU may easily extend this idea to make readers sign a contract before reading a certain forum. I do not need this feature and will not be adding it at this time.

-------------
Template Conditionals You May Like to Use for the Ticket System:

<if condition="$post[reqcontract]">

- In the postbit, this lets you see if tickets are required in the forum.

<if condition="$post[ticket]">

- Check to see if the user has a ticket. This way, you don't have to show the number of tickets for people who don't have any.

<if condition="is_member_of($bbuserinfo,5,6)">

- use this to see if the person reading the post is an admin or supermod. If they are, you can show them the links that will ticket users.

Putting it all together, an example way to use the tickets in the postbit:

<if condition="$post[reqcontract]">
<if condition="is_member_of($bbuserinfo,5,6)">
<if condition="$post[ticket]">
User's Tickets in this forum: $post[ticket]<br />
</if>
<a href="ticket.php?do=addticket&forumid=$post[forumid]&userid=$post[userid]">Ticket User</a><br />
<if condition="$post[ticket]">
<a href="ticket.php?do=rticket&forumid=$post[forumid]&userid=$post[userid]">Remove One Ticket</a><br />
<a href="ticket.php?do=cticket&forumid=$post[forumid]&userid=$post[userid]">Clear the user's tickets</a><br />
</if>
</if>
</if>

A huge thank you to LiveWire, Boofo and HellSatan for testing this out.

Installation on 3.5 RC1 is as simple as importing the product, changing two existing phrases and making one template change.
------------------------------

This hack will always be free, however your donations are kindly accepted and will help towards further development. If you donate, please leave me some info (either your forum site or username at vB.org) so that I can thank you.


Amy

[amykhar]

No. Feel free to add that in if you so desire.

[Mu5icMan]

i have no idea where to start for adding a log file. Is there a coder here who can add it?

[Bad Bunny]

Originally Posted by amykhar

The other phrases are installed by the product.

I had a blank tcat because it wasn't a global phrase. So I looked in the template, and found the phrase used, and changed it to global.

[Bad Bunny]

It seemed to work fine, until I added a contract to a new forum, and tried to sign it, and got this error.

Database error in vBulletin 3.5.0 Release Candidate 1:

Invalid SQL:

UPDATE user
SET contracts = 10,11
WHERE userid = 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 '11
WHERE userid = 1' at line 2
Error Number : 1064

[amykhar]

Bunny, get the new zip. I was sure I had fixed that in the zip file, but I guess I didn't.

Reupload contracts.php and tickets.php

Amy

[Bad Bunny]

Originally Posted by amykhar

Bunny, get the new zip. I was sure I had fixed that in the zip file, but I guess I didn't.

Reupload contracts.php and tickets.php

Amy

Will do. Thanks.

[Bad Bunny]

Originally Posted by Bad Bunny

Will do. Thanks.

Unfortunately, I did delete my copy of the zip, and downloaded the new zip, and uploaded, overwriting my files on the server, and I still have the same exact error. Maybe I have to clear my cache on this site.
[high]* Bad Bunny goes to do that and try again
[/high]

EDIT>>
I deleted the folder yet again, cleared my cache, downloaded the zip, overwrote my files, and I still have the same error.

[amykhar]

When I look in the zip, I see the correct file. I reuploaded it again though. Try one more time.

[Bad Bunny]

Originally Posted by amykhar

When I look in the zip, I see the correct file. I reuploaded it again though. Try one more time.

How can I know if it is the right file?

[amykhar]

It will have this in it.

 	   		$db->query_write("
			UPDATE " . TABLE_PREFIX . "user
			SET contracts = '$contractlist'
			WHERE userid = " . $vbulletin->userinfo['userid']."
		");