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

[hello]

i have installed and upgraded the warning hack but normal members can warn other members is there a setting to make it so that admins and mod or supermods can warn

[WebTechTalk]

Nice man! I'm clicking install button now!

[sicloan]

I have found a very annoying problem with this hack.

No offense but your function ParseInput wasnt very good and it is not handling the comments the way i want. It is not giving good pm results. Meaning i get the ASCII characters in my PM's when recieving a warning notice.

First i would like to thank the admin's over at www.battleforums.com for pointing this out. Proper grammar can really improve a forum's appearance and that is one of the reasons i want help with this problem.

I tried to use a function by vbulletin but thats not working. If you could please modify it that would be great.

[j_86]

Why not use the template mod suggested further back in this thread?

[WebTechTalk]

hmmm...I'm getting a Who is Online error aswel...having my programmer check it out.

[hello]

can someone please answer my question

[sv1cec]

Originally Posted by hello

can someone please answer my question

Check page 14, the answer should be there.

Rgds

[sicloan]

Originally Posted by sicloan

I have found a very annoying problem with this hack.

No offense but your function ParseInput wasnt very good and it is not handling the comments the way i want. It is not giving good pm results. Meaning i get the ASCII characters in my PM's when recieving a warning notice.

First i would like to thank the admin's over at www.battleforums.com for pointing this out. Proper grammar can really improve a forum's appearance and that is one of the reasons i want help with this problem.

I tried to use a function by vbulletin but thats not working. If you could please modify it that would be great.

If you didn know what i meant by this. Basically when i add a warning to someone, and i put a moderation comment on the warning, with apostrophe's or quotations, i get the ascii vaule. " or the number whatever it is.

[sv1cec]

Originally Posted by sicloan

If you didn know what i meant by this. Basically when i add a warning to someone, and i put a moderation comment on the warning, with apostrophe's or quotations, i get the ascii vaule. " or the number whatever it is.

As I said before, you can replace the PM thing with a template-based message. However, I haven't registered all the changes I made, so it's not easy for me to provide step-by-step instructions. If you want, I can provide you with my files, for you to figure out.

Rgds

[sicloan]

Yea if you could send those my way that'd be great. Just pm me.

Also, I know it has something to do with the way the message is parsed from the database. ParseInput() is a decent function but it does not seem to deal with it the right way. And the pm text SHOULD be the same, unless you made a custom function for send_pm() but i didnt notice anything.

Thanks for the help, and i hope i can figure this problem out.

~Sicloan

[Koutaru]

Set it up with no problems! Thanks again for such an awesome hack and awesome work I'd expect no less from you.

[sv1cec]

Originally Posted by Koutaru

Set it up with no problems! Thanks again for such an awesome hack and awesome work I'd expect no less from you.

For those who want to use a template for the PM send to the warned user, all you have to do is to create a template called "warn_pm" with the following contents:

Dear $user[username],

You have been warned for one of your posts, which violated the Forums Rules.

The reason you have been warned is because [b][i] $warn_type[warn_desc] [/i][/b](Warning Type = $warn_type[warn_name]), for which you have been given [b] $warn_type[warn_points] [/b] point(s).

The post for which you are warned can be seen [URL="$vboptions[bburl]/showthread.php?p=$_POST[post]"]here[/URL].

The admin/moderator who warned you, entered this comment: 

=======================================
[i]$_POST[comment][/i]
=======================================

Your total Warning Level at the moment is: [b] $level [/b] point(s).

If you reach the maximum of [b]$warn_options[points_before_banned][/b], you will be banned from the Forums, for [b]$warn_options[banned_limit][/b] days.

To see details about all the warnings you have received, until now, please click [URL="$vboptions[bburl]/Warn.php?do=ViewMyWarnings"]here[/URL].

Please reply back if you have a dispute.

Then in the warn.php file, comment out the following lines:

PHP Code:

$messageb="You have been warned for one of your posts: [url={$vboptions[bburl]}/showthread.php?p={$_POST['post']}]click here to see it[/url]. Your warning level is now: {$level}. Click on the [b]Quick Links[/b] menu above and select [b]View Your Warnings[/b], to see details about all the warnings you have received. The person who warned you, entered this comment: [i]{$_POST['comment']}[/i]. Please reply back if you have a dispute.";
$messageb=ParseInput($messageb); 


In case your message looks different than mine (I might have changed it), please comment out the two lines which start with $messageb.

Right below those two lines, add the following:

PHP Code:

eval('$messageb .= "' . fetch_template('warn_pm') . '";'); 


Of course the template can be edited at will.

I hope this helps.

---------
John

[sv1cec]

One issue I had with this hack, is the fact that it uses a separate table, to maintain those members which get banned. If you do that, then you have to manually change their status to unbanned, when the banning period expires.

Why can't we use the normal table, in which vB stores the banned users, called "userban"? In that way, we can have the vB's cron job take care of the unbanning.

For those who are interested in this, all you have to do, is the followings:

In your warn.php file, find the following line:

PHP Code:

$DB->query("insert into ".TABLE_PREFIX."banned_members values ('','{$user['userid']}','".time()."','{$time_unban}')"); 


Replace it, with the followings:

PHP Code:

        if($warn_type['warn_permban']=="Yes")
            {$liftdate=0;
             }
            else
            {$liftdate=$time_unban;
             }
                 $usergroupid=8
        $DB_site->query("
            INSERT INTO " . TABLE_PREFIX . "userban
            (userid, usergroupid, displaygroupid, customtitle, usertitle, adminid, bandate, liftdate)
            VALUES
            ($user[userid], $user[usergroupid], $user[displaygroupid], $user[customtitle], '" . addslashes($user['usertitle']) . "', $bbuserinfo[userid], " . TIMENOW . ", $liftdate)");
        $DB_site->query("
                UPDATE " . TABLE_PREFIX . "user SET
                usergroupid = $usergroupid,
                displaygroupid = $usergroupid
                WHERE userid = $user[userid]
            "); 


Of course, in this case, you do not use the option "Unban banned users" in your AdminCP, since the bans will no longer be in the table this hack is using, but in the table vB is creating.

Also, it is obvious, that if you use this mod of mine, any future improvements by the author of this hack, might not work, so use at your own risk.

I'll try to help anyone who has issues with the above mods, but I can't promise any response times.

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

[Mosh]

* jd clicks install *

I have been testing this for a while, it is great just installed it on my live forum.

I have made a few changes mostly conditionals so only staff can see the warn and view warn text in the postbit template, also added a Warn Level indicator for everyone (except staff) to see, also added the same in the MEMBERINFO template.

Thank you.

JD.

[BeasTboyz]

I get SQL errors when trying to send the message using both the original method by Zero Tolerance, and the template method by sv1cec

Here is the error with the stock code:

Database error in vBulletin 3.0.3:

Invalid SQL: insert into vb3_pmtext values ('','1','Matt','You have been warned','You have been warned for one of your posts: click here to see it. Your warning level is now: 5. Click on the Quick Links menu above and select View Your Warnings, to see details about all the warnings you have received. The person who warned you, entered this comment: test. Please reply back if you have a dispute.','a:1:{i:5;s:9:\"BeasTboyz\";}','4','1096165529','1','1')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Saturday 25th of September 2004 09:25:29 PM
Script: http://www.observedtrials.net/vb/Warn.php
Referer: http://www.observedtrials.net/vb/War...d=5&post=73439

I also can not use the ban fix created by sv1cec two posts up. I get an invalid T_VARIABLE on line 250, which happens to be the first instance of the code below:

        $DB_site->query("

If anyone knows how to fix these problems I would appreciate it, I've tried quite a few different things but I'm a novice at this sort of thing.

Thanks!