Warning Hack V1.5

Version 1.5 Note: You must have v1 installed to upgrade, the upgrade process is small so there was no need to write out a fresh install.

It has come to my attention that a "decent" warning system isn't available here on vbulletin.org, which is quite a shame, and because forums like mine, and probably yours need a simple yet advanced warning system to keep things under wraps

Anyway, i thought i might aswell release what i made, prior to me getting off my ass... lol

Administration Features:
View Warning Logs
- Displays all warnings, warned user, warned by, link to the warned post, date, warning type, and the comment specified when the warning was given, and a remove warning link
(Remove will remove the log and also put the members warning level back down in accordance to how much it was increased by the selected warning removed)
Unban Banned Members
- A simple page that you should visit every few days, it will automatically ban any auto banned users by the warning system where there ban time has expired
Warning Options
- Here you can set the following:
-- Number of warn points before member is auto banned
-- Number of days a member is auto banned for
-- View Warnign Types
-- Add Warning Type
-- Add warning type has the following fields:
---- Name/Description/Warn Points Given

Forum Features:
Every post has "Warn [Name]" and "View [Names] Warnings"
These are only accessiable by a member group which is allowed to "moderate" (Moderating groups are auto detected)
Clicking the Warn link will bring you to a page where you view the user your warning, a link to review the warned post, members current warning level, and below the warning types, has a drop down menu to select the warning type, and a text field to put your comment for why this warning is been issued
Upon completing the warning form, the warned user will be Pm'ed from the person who warned them, with the comment put down and a link to the post

View Warnings link will display logs of only that specified user's warnings, the same features as the admin cp warning logs, only just for this user

Members can access only 1 page of the warning system, which is "View My Warnings", this link is added to the quick links drop down menu
Here they simple view there warnings, just like a moderator would, only without the remove warning link

V1.5 Features:
Protectable Usergroups:
No user's in these defined groups can be warned, or banned.
Root Admin Force Protection:
Userid 1 cannot be warned, canned be banned, this is not optional, this is forced for security.
New Unban Members Set Up:
Now displays all currently banned user's, what time they were banned, what time they are supposed to be unbanned. You may unban the user even if there time has not expired (You will be notificed if they have not served the time issued upon ban, but not stopped). Upon unbanning, you choose the members 'new' warning level and the user's usergroup to move them into
Set banned usergroup:
You can now easily choose from a drop down menu which usergroup user's are sent to if after been warned they are banned.

V1.5 Bug Fixes:
- User locations in 'Users online' shown as unknown if they are warning/viewing warnings (Priority: Medium)
- Unban members system renovated and now fully works (Priotity: Maximum)
- No mysql errors upon sending a pm if the PM table had been altered (Priotity: Maximum)
- New protectable usergroups to stop any group of your choice been banned (Priotity: Maximum)
- Last time visited didn't appear when error page occured (Priotity: Low)
- Un-used global in PM function (Priority: Low)

I hope you enjoy the system, my staff teamare very pleased with it and find it of great use, enjoy the hack

- Zero Tolerance

[sv1cec]

Originally Posted by beano33

I've installed Zero Tolerance's hack and it works as intended and will also be adding sv1cec expiration of warnings. I need help with a couple things to make it more effective for my board.

1) when members are unbanned they are sent to Coppa. How do I make it so it unbans them back to their original usergroup?

2) Can it be made to send the warning as both as PM and and Email? We don't give new users PM priveleges until they meet certain post count and length of membership criteria due to numerous incident of our PM system being used to spam.

Thanks!

When a user is banned, his usergroup id is preserved (at least in my code) and when he is unbanned, he is restored to the original user group. I am not sure what the original code does here, sorry.

I'll have to check the e-mail thing, I've been thinking about it too.

Rgds
------------
John

[sv1cec]

Originally Posted by Charlie O'Leary

For whatever reason some old warnings are not expiring even thought hey have maturity dates. Any idea what could be causing this? I have warnings from August that are still active even though they only have maturity times of 30.

First, make sure that your database tables have the structure below:

Field Type Null Key Default Extra
wid int(15) PRI auto_increment
warned_user int(15) 0
warned_by int(15) 0
warned_time int(15) 0
warned_reason text
warned_post int(15) 0
warned_warning_id int(15) 0
warned_status char(1) YES

warning_types

Field Type Null Key Default Extra
tid int(15) PRI auto_increment
warn_name varchar(255)
warn_points int(15) 0
warn_desc text
warn_maturity int(5) 0
warn_permban char(3)
warn_type char(3) YES

Make sure that those old warnings, do have a maturity period entered in the warning_types table. And finally make sure you have the cron script I've uploaded.

Rgds
-----------
John

[sv1cec]

Originally Posted by beano33

2) Can it be made to send the warning as both as PM and and Email? We don't give new users PM priveleges until they meet certain post count and length of membership criteria due to numerous incident of our PM system being used to spam.

Thanks!

Per your request, the notification can now be send, either as a PM or as an e-mail or as both.

Check the attached file.

Rgds
------------
John

[beano33]

Thanks John!

[sv1cec]

Originally Posted by beano33

Thanks John!

You are welcome Sir!

Rgds

[bnn121]

In postbit, find the following code:

PHP Code:

<if condition="$show['postcount']">#<a href="showpost.php?$session[sessionurl]p=$post[postid]&amp;postcount=$post[postcount]" target="new"><strong>$post[postcount]</strong></a> &nbsp;</if> 


Right above it, add:

PHP Code:

 
<!-- checks for warning system -->
<if condition="$post[usergroupid]!=6 AND $post[usergroupid]!=7 AND can_moderate($forum[forumid], '', $bbuserinfo[userid])"><a href='Warn.php?do=WarnUser&id=$post[userid]&post=$post[postid]'>Warn $post[username]</a> ?
</if>
<if condition="$post[usergroupid]!=6 AND $post[usergroupid]!=7 AND ($bbuserinfo[usergroupid]==7 OR $bbuserinfo[usergroupid]==6)">
<a href='Warn.php?do=ViewWarnings&id=$post[userid]'>View $post[username]'s Warnings</a> ?</if>
<if condition="$post[userid]==$bbuserinfo[userid] AND $post[usergroupid]==2 AND $post[warning_level]>0">
<a href='Warn.php?do=ViewMyWarnings'>View your Warnings</a> ?</if>
<!-- end of warning system --> 


In the above instructions I'm able to find that one line of code in my postbit and postbit_legacy templates for my first board style...now I have three more styles...and when I go to look for that first line of code...it does not find that exact line of code...what is finds is this.

PHP Code:

<if condition="$show['postcount']">? #<a href="showpost.php?$session[sessionurl]p=$post[postid]&amp;postcount=$post[postcount]" target="new"><strong>$post[postcount]</strong></a></if> 


I noticed that right after this part of the code

<if condition="$show['postcount']">

there is a period or dot or whatever that is.

Now all three of my other styles have this code in it...just like I qouted...but my first style is just like the instructions line of code.

Is there any reason to have that period or dot or whatever it is in that line of code for the other three styles?

In the original instructions of this hack it is said to find

PHP Code:

In template 'postbit' AND 'postbit_legacy'
Find:
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
<if condition="$show['postcount']">#<a
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Replace With:
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
<a href='Warn.php?do=WarnUser&id=$post[userid]&post=$post[postid]'>Warn $post[musername]</a> ? <a href='Warn.php?do=ViewWarnings&id=$post[userid]'>View $post[musername]'s Warnings</a>
                <if condition="$show['postcount']">? #<a
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ 


In refence to the first set of code i posted above ...once this original code is changed...where does this new code come in? Is the original modified code getting overwritten or is it getting put in between the origianl modded code?

[Roms]

Thanks for the warning system.

*Clicks install

[bnn121]

Database error in vBulletin 3.0.1:

Invalid SQL: update warning_options set
banned_limit='14',
points_before_banned='5',
banned_usergroup_id='8',
troll_usergroup_id='4',
protected_usergroups='6|15',
multiple_per_post='Yes',
send_pm_warning='$pmoption'
where oid='1'
mysql error: Unknown column 'send_pm_warning' in 'field list'

mysql error number: 1054

Script: /board/admincp/admin_warn.php
Referer: /board/admincp/admin_warn.php?act=view

This occured when I was in AdminCP attempting ot change the

Allow multiple warnings for the same post?
and
Send PM to the warned member

[bnn121]

I think I found the problem...either this is not to be in the database or it is.

I your mymods.txt it makes no mention of the

send_pm_warning

but yet its being called in your

admin_warn_php file

If this needs to be added to the database table under warning options...what should the varibles be?

[bnn121]

I fixed this issue...seems I had to many lines in my template...LOL

Still looking for some help with the two last post of mine...Thanks

Now...I have another issue...I'm seeing


10. Template warn_viewtype_row

at the lower right hand side of this screen shot.

how do I get ride of that?

[crd]

what about warning for non post related infractions.

Wow a lot of chat about this hack. I'm having a problem with people registering and sending spammy PM's. It would be nice if there was a way for users to click to report spam pm to some mod and it would go right to their profile with a warn this user right there . These spammers don't typically make posts so tying their warning to a post is not be very useful.

[rinkrat]

OK, I just installed but there is no clue as to what warning type's (sic) are. Can you do a quick run though of different sample warning types that can possibly be used with this system and how they are configured. It's hard for a new user to create one when it's not explained. You might want to just pre-configure a basic setup so it works out of the box.

[sv1cec]

Originally Posted by bnn121

Database error in vBulletin 3.0.1:

Invalid SQL: update warning_options set
banned_limit='14',
points_before_banned='5',
banned_usergroup_id='8',
troll_usergroup_id='4',
protected_usergroups='6|15',
multiple_per_post='Yes',
send_pm_warning='$pmoption'
where oid='1'
mysql error: Unknown column 'send_pm_warning' in 'field list'

mysql error number: 1054

Script: /board/admincp/admin_warn.php
Referer: /board/admincp/admin_warn.php?act=view

This occured when I was in AdminCP attempting ot change the

Allow multiple warnings for the same post?
and
Send PM to the warned member

You have to add the send_pm_warning field first, obviously, so install that mod first.

Rgds

[sv1cec]

Originally Posted by bnn121

Now...I have another issue...I'm seeing


10. Template warn_viewtype_row

at the lower right hand side of this screen shot.

how do I get ride of that?

Remove that line from the previous template mentioned. You just added that descriptive line, in the text of the previous template, which should be warn_viewtype_end (I think).

Rgds

[sv1cec]

Originally Posted by crd

what about warning for non post related infractions.

Wow a lot of chat about this hack. I'm having a problem with people registering and sending spammy PM's. It would be nice if there was a way for users to click to report spam pm to some mod and it would go right to their profile with a warn this user right there . These spammers don't typically make posts so tying their warning to a post is not be very useful.

The function for non-post related offenses is there already. When someone reports you an offensive PM, go to the User profile of the sender and warn him.

Rgds