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 Remi

Hi

Can some one kindly tell me how to disable sending the PM when warning a member.

All what I need realy is changing the usergroup ID.

Thanks

Comment out the following code:

PHP Code:

eval('$messageb .= "' . fetch_template('warn_pm') . '";');
$title="You have been warned";
$to=$user['userid'];
$from=$bbuserinfo['userid'];
SendPM($messageb,$title,$to,$from); 


in your warn.php file.

I've also made some changes to make this an option in the "Control Warnings" part of AdminCP, so if some one wants to use that, please download the two files supplied here (they contain the version which supports the historical listing of warnings).

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

[Rick Sample]

Originally Posted by sv1cec

TABLE_PREFIX is a variable you define when you installed the vB software. It can be found in includes/config.php

As for running a query, go into your AdminCP and scroll the left column all the way to the end. You should see something like "Execute SQL Query". Click on it and a window will open in the right side, where you type the query the author suggests.

Rgds

cool, but do I type in all those lines seperatly or all at once?

[SamirDarji]

Cut and paste. That's what I did.

[sv1cec]

Originally Posted by muscle-mustangs

cool, but do I type in all those lines seperatly or all at once?

It's a single SQL statement (command), so you just copy the whole thing and paste it in the big box in your AdminCP "Execute SQL Query".

Rgds
---------
John

[sv1cec]

Originally Posted by JimpsEd

A suggestion sv1; to be able to clear warning history for a user/all users via the admin panel.

Sorry I didn't answer sooner on this one.

What do you mean to "clear warning history"? You can always remove a warning from a member, either from the admincp or if you are an admin/mod, from the normal "Show XYZ's warnings". Just erasing all history? I do not see a point in this. I mean why do you want to clear the whole warnings history for some members?

The fact that now the tables register the past warnings, for ever, may necessitate a "hard erase" function, to completely delete erroneous or warnings issued during testing. But I can hardly see that as a need for more code, you can do that with an SQL Query, no need to add it to the hack (at least in my opinion).

If you could elaborate, maybe I could look into it.

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

[msimplay]

i just gotta say thank you for everything @ sv1cec
you may not be the author of the hack but you certainly have contributed a lot of code which helped me so i'd like to thank you

[j_86]

It is just as you described For forums who ant to "Clean Out" etc. maybe once a year or something like that.

[SamirDarji]

Originally Posted by msimplay

i just gotta say thank you for everything @ sv1cec
you may not be the author of the hack but you certainly have contributed a lot of code...

Ditto.

[Rick Sample]

cool, I'm still having troubles. I looked in my config.php file for Table_prefex and it is blank so I took it out like the instructions suggested.

I just put this in their:
add `banned_usergroup_id` int(15) not null default '0',
add `protected_usergroups` varchar(255) not null default '';

And I get this error message:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 'add `banned_usergroup_id` int(15) not null default '0',
add `p

Any thoughts?

[sv1cec]

For those who thanked me, gentlemen, it's been a pleasure contributing to this community. And my mods just made use of an initially great hack, so I claim no lawrels.

As for the deleting feature, I still am not sure. What we'll have? A list of all the warnings, like in the "Warnings Log", with check boxes next to each warning, so that the admin can check which ones he wants to delete? OK, then do we do any maths with the warning points accumulated by the members? This can get messy and I do not see a reason for it.

What I could easily come up with, is a function which would allow the admin to prune old, inactive warnings. Say that a questions is asked like "How many days do you want to leave in the warnings table?" (or whatever, meaning "before which date, shall I delete inactive warnings?") and then delete those warnings which were rendered inactive (i.e. either matured or were removed) before that date.

Would that cover you? That doesn't need any points mathematics, or anything.

Let me know.

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