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

[Kmaster]

Originally Posted by sv1cec

OK, the paged layout for the Warning Logs is done.

You have to add a new column in your warning_options table, using the following SQL Query (remember to use the TABLE_PREFIX if you are using one):

alter table `warning_options` add warnings_per_page int(3)

After you've done this, use the attached admin_warn.php file. Sorry I can't provide a detailed step-by-step mods write-up, too many changes to make it viable.

Let me know if it works.

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

I found this error, when use the new admin_warn.php

Database error in vBulletin 3.0.3:

Invalid SQL: select w.*,u.username as wusername,u.userid as wuserid,wt.*,wuser.username as warned_username_v,wuser.userid as warned_userid_v from
warnings w
left join user wuser on(wuser.userid=w.warned_user)
left join user u on(u.userid=w.warned_by)
left join warning_types wt on(wt.tid=w.warned_warning_id) ORDER BY w.warned_time DESC LIMIT 0,
mysql error: You have an error in your SQL syntax near '' at line 5

mysql error number: 1064

Date: Saturday 13th of November 2004 05:47:18 PM
Script: http://xxxxxxxx.xx/forums/admincp/ad...p?act=viewlogs
Referer: http://xxx.xx/forums/admincp/index.php?do=nav
Username: xxx
IP Address: xxx.x.xx.xxx

[sv1cec]

Originally Posted by Kmaster

I found this error, when use the new admin_warn.php

Database error in vBulletin 3.0.3:

Invalid SQL: select w.*,u.username as wusername,u.userid as wuserid,wt.*,wuser.username as warned_username_v,wuser.userid as warned_userid_v from
warnings w
left join user wuser on(wuser.userid=w.warned_user)
left join user u on(u.userid=w.warned_by)
left join warning_types wt on(wt.tid=w.warned_warning_id) ORDER BY w.warned_time DESC LIMIT 0,
mysql error: You have an error in your SQL syntax near '' at line 5

mysql error number: 1064

Date: Saturday 13th of November 2004 05:47:18 PM
Script: http://xxxxxxxx.xx/forums/admincp/ad...p?act=viewlogs
Referer: http://xxx.xx/forums/admincp/index.php?do=nav
Username: xxx
IP Address: xxx.x.xx.xxx

Try using the admin_warn.php attached here. It works in my 3.03.

Rgds

[Kmaster]

Originally Posted by sv1cec

Try using the admin_warn.php attached here. It works in my 3.03.

Rgds

that's weird, I won't work for me. Still got same error.
enclosed found attached my current use version, hope this can help!!
thanks a lot.


rgds,

[sv1cec]

Originally Posted by Kmaster

that's weird, I won't work for me. Still got same error.
enclosed found attached my current use version, hope this can help!!
thanks a lot.


rgds,

You are obviously using the new admin_warn.php with the page layout in the report. Did you remember to add the suggested column, in the warning_options table of your database? If not, you have to run the following query, and then go to your AdminCP/Warning System/Warning Options and fill in the number of rows per page, at the last field.

Let me know if it works.

The query is:

PHP Code:

alter table `warning_options` add warnings_per_page int(3) 


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

[Kmaster]

Originally Posted by sv1cec

You are obviously using the new admin_warn.php with the page layout in the report. Did you remember to add the suggested column, in the warning_options table of your database? If not, you have to run the following query, and then go to your AdminCP/Warning System/Warning Options and fill in the number of rows per page, at the last field.

Let me know if it works.

The query is:

PHP Code:

alter table `warning_options` add warnings_per_page int(3) 


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

Yes, I'd added the query into database.
still get same error.

[TCattitude]

Originally Posted by sv1cec

It all depends on what you mean by V2. If you are talking about the next version by Zero Tolerance, I do not know. If you are talking about my fully documented and enhanced hack, I hope it will be ready tomorrow.

All instructions are there, so that someone can make an install from scratch. It's just that this hack has evolved to something really big (19 new templates are required, plus several changes to existing templates) and I am trying to find a way to make the installation easier. I 'll try to immitate Zero Tolerance's installation method, but I am not good with XML and I do not want to release something like that, if I am not 100% sure it is OK. Tomorrow, I'll do some tests, for the automated installation.

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

Great news... i'll be waiting 4 that mod... hope soon

Good luck.

[sv1cec]

Originally Posted by Kmaster

Yes, I'd added the query into database.
still get same error.

OK, you added the column, but have you defined the Lines Per Page you want to see, in the Warning Options? What I can see from the error, is that it can't find the upper limit, something missing after "ORDER BY w.warned_time DESC LIMIT 0, " that comma. That's where it uses the lines per page.

Let me know.

Rgds

[sv1cec]

Originally Posted by TCattitude

Great news... i'll be waiting 4 that mod... hope soon

Good luck.

Well, I have almost everything ready, even the installation program is done (copied that from Zero Tolerance).

What I am waiting for, before releasing the hack, is Zero Tolerance's permission. You see, a lot of this code comes from his original hack, and I do not want to use it in a new hack, without his permission.

Rgds

[Torqued]

Originally Posted by sv1cec

Well, I have almost everything ready, even the installation program is done (copied that from Zero Tolerance).

What I am waiting for, before releasing the hack, is Zero Tolerance's permission. You see, a lot of this code comes from his original hack, and I do not want to use it in a new hack, without his permission.

Rgds

Any update on releasing this?

[sv1cec]

Originally Posted by Torqued

Any update on releasing this?

Anyone interested in acting as a guinea pig to test it out before releasing it?

My Sun run out of disk space, so I need to do some maintenance before I can test the whole installation thing. If someone is willing to try it out, it will speed things up significantly. All you need is a clean 3.0x installation (without Zero Tolerance's things).

I attach here the ... Features List, I think you will find it interesting:

- post- and non-post-related warnings
- hierarchical warning schema (mods can warn users, super mods can warn mods and users, admins can warn everyone, no same-level warnings)
- hidden or real warners
- customizable maximum warning points
- customizable ban days
- customizable ban user group and permanent ban user group
- supports incremental banning periods
- supports multiple warnings for the same post
- warned members are notified either by Private Message or e-mail
- maintains historical listings of issued warnings (even if deleted or expired)
- customizable warning types
- each warning type has predefined warning points associated with it
- each warning type has predefined maturity period, after which it is automatically removed
- reports for admin, and mods
- cron job included to automatically remove matured warnings
- uses vBulletin's cron job, to automatically unban banned users
- all options are setable in your AdminCP
- user warning points and number of bans viewable in your AdminCP user template.

rgds
--------------
John