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 msimplay

i'd still like expirable warnings

My mods provide for a "Warn Maturity". The warnings are automatically removed after they mature.

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

[msimplay]

Originally Posted by sv1cec

My mods provide for a "Warn Maturity". The warnings are automatically removed after they mature.

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

from which page in this thread do i start searching ur mods a rough estimate please

[BeasTboyz]

Hey John, the first problem has been solved, the semicolon worked no problem.

I still have a problem with the private messaging though. The lines are uncommented just how you said to do and the next lines are just like yours. The SQL error is still the same though. You can view my Warn.php here if you want to verify anything for yourself.

Also, I warned my test account up to a ban and it went to the correct usergroup in the correct ban log (the one built into vB), but it said the ban was permanent. I have it set to 3 days in the Admin CP. If you have any idea what is going on with that I'd appreciate it.


Thanks for all the help,

Matt

Edit: just saw you run m1911.org, very Congrats on getting the forums running, I hadn't even seen them before. I always used http://forums.1911forum.com/ Anyhow, just wanted to let you know I've learned a LOT from your site

[sv1cec]

Matt,

Thanks for the nice words about M1911.ORG, appreciated. Yes, we have our own forums site running since June.

As for the mods, there were a couple of minor mistakes in your warn.php, so I had them corrected. I guess the problem with the eval statement was a dot, just before the = sign. Anyway, I attached it here.

Let me know if it works.

Rgds

[msimplay]

i hope two idea's i've seen on these forums make it into version 2.0
Expirable warnings
Can't warn same post twice

[BeasTboyz]

sv1cec, It didn't work. The first problem I had was that I needed a new colum in warn_types called warn_maturity. I made that, but now I'm still getting the problem with the PM function:

Database error in vBulletin 3.0.3:

Invalid SQL: insert into vb3_pmtext values ('','1','Matt','You have been warned','Dear BeasTboyz,

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

The reason you have been warned is because  Other reasons not listed (Warning Type = Miscellaneous), for which you have been given  2  point(s).

The post for which you are warned can be seen here.

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

=======================================
test
=======================================

Your total Warning Level at the moment is:  5  point(s).

If you reach the maximum of 6, you will be banned from the Forums, for 3 days.

To see details about all the warnings you have received, until now, please click here.

Please reply back if you have a dispute.','a:1:{i:5;s:9:\"BeasTboyz\";}','4','1096279642','1','1')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Monday 27th of September 2004 05:07:22 AM
Script: http://www.observedtrials.net/vb/Warn.php
Referer: http://www.observedtrials.net/vb/War...d=5&post=73439
Username: Matt
IP Address: xx.xx.xx.xx

Is the problem with the pmtextid column in my vb3_pmtext table? It seems like its possibly trying to enter the wrong pmtextid (*) instead of the next relevant number? This is just a shot in the dark here of course, I don't really know.

If you have any ideas I'd appreciate it .

Matt

[sv1cec]

Originally Posted by BeasTboyz

sv1cec, It didn't work. The first problem I had was that I needed a new colum in warn_types called warn_maturity. I made that, but now I'm still getting the problem with the PM function:

Is the problem with the pmtextid column in my vb3_pmtext table? It seems like its possibly trying to enter the wrong pmtextid (*) instead of the next relevant number? This is just a shot in the dark here of course, I don't really know.

If you have any ideas I'd appreciate it .

Matt

Matt,

I found a few more differences between your warn.php and mine. I am attaching your file with the new code. It is in the SQL Query that inserts those values in the omtext table. The problem is that I haven't touched that part of the code myself, so I guess we have a ... version discrepancy here.

Let me know if this one works.

John

[sv1cec]

Originally Posted by msimplay

i hope two idea's i've seen on these forums make it into version 2.0
Expirable warnings
Can't warn same post twice

Expirable warnings are there today, you will just have to figure out some things yourself, as I haven't kept notes on my changes.

As for not warning the same post twice, I think I've got it working by adding the following code:

PHP Code:

if($postwarnedalready=$DB->query_first("select warned_post from ".TABLE_PREFIX."warnings where warned_post='{$_GET['post']}'"))
{
RunError("This post has already been warned for. You cannot issue another warning for it.");
} 


in your warn.php file, just before the line :

PHP Code:

// User Exists? 


The User Exists line is found twince in the code, I am not sure if you should add the above if statement in both instances, I think you should. Let me know if it works OK.

Rgds

John

[msimplay]

Originally Posted by sv1cec

Expirable warnings are there today, you will just have to figure out some things yourself, as I haven't kept notes on my changes.

As for not warning the same post twice, that's easy to implement, only one query to the warnings table. However, I do not have the time to do it right now. If I manage to get it, I'll post the code here.

Rgds

yeh i found the expirable warnings bit it will suffice for now
however it would be good to have it intergrated into the hack itself for example the way it was in mikes warning hack for vb2

Spamming expires 30 days
Rudeness expires 1 day
Signature expires 30 days

its settable per warning but the way i found in this thread was as a whole 30 days from the time set per warning

[BeasTboyz]

Originally Posted by sv1cec

Matt,

I found a few more differences between your warn.php and mine. I am attaching your file with the new code. It is in the SQL Query that inserts those values in the omtext table. The problem is that I haven't touched that part of the code myself, so I guess we have a ... version discrepancy here.

Let me know if this one works.

John

Wow John, thanks for all of your help!

It appears to be working great now except for two small things.

1.) If a user has a warning level of 5 and the ban level is 6 and I give them a warning worth 2 points it takes the level up to 6, but when I remove the warning it keeps an extra point in "reserve" that I can't seem to erase. I can of course go into the my user table and remove it from the last column, but I thought I'd let you know in case you want to fix it.

2.) At the bottom of the Warn.php interface (on the site) it says "Once you reach warning level 6, you will be banned for 3 days". Well, I'm not banning them, I have a usergroup on my site I add them to called the Kiddie Korner, and that is the only place they're allowed to post. I would like to say "Once you reach warning level 6, you will be moved to the Kiddie Korner for 3 days"