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

[mojo8850]

Ok.. Since No One Is Helping.. Especially The AUTOUR..!

This I How I Have Ran The Query:-

alter table warning_options
add `banned_usergroup_id` int(15) not null default '0',
add `protected_usergroups` varchar(255) not null default '';

However It Did Say In The Query That It Affected Rows:- 1

So Far It Working Brilliantly..

Correct Me If Wrong..!

Regards

Mr. Mojo

[sv1cec]

Originally Posted by mojo8850

Ok.. Guy's..

I Have Installed 1.0 Working Fine.. Now To Upgrade.. I Dont Understand What You Mean With This:-



Here Is My includes/config.php



So Help Please What Do I Do..! :ermm: :ermm: :ermm:

That means that when someone tells you to run a query like:

UPDATE `".TABLE_PREFIX."warning_options` SET version='3.0.2' WHERE oid=1

you should remove from there, the :

".TABLE_PREFIX."

thingy, because you are not using a table prefix.

Rgds

[mojo8850]

I See So The Query That I Ran Shown In Post #526..!

Was The Correct Method..!

[taffy056]

Hi,

How do I unistall this hack, I think its playing havoc on my board after I upgraded to 3.0.5?

taffy

[j_86]

Work backwards though the installer.

Why were you not using the re-release of this hack, the more stable, bug free and feature packed Advanced Warning System (AWS).

[taffy056]

Hi,

I am planning to use this, but first I need to get my forum up and running, don't think I should upgrade until that is sorted.

taffy

Originally Posted by JimpsEd

Work backwards though the installer.

Why were you not using the re-release of this hack, the more stable, bug free and feature packed Advanced Warning System (AWS).

[sv1cec]

Originally Posted by taffy056

Hi,

How do I unistall this hack, I think its playing havoc on my board after I upgraded to 3.0.5?

taffy

Taffy, this hack never got a 3.0.5 release. Zero Tolerance got this hack to version 1.5. Are you sure you are not mixing it up with the AWS (which is currently at 3.0.7, by the way)?

rgds

[taffy056]

Hi,

I meant vBulletin 3.0.5

Anyway I just deleted what I thought was everything in the database regarding this hack, but I get the following error when I try to reinstall.

Database error in vBulletin 3.0.5:
Invalid SQL: alter table user
add warning_level int(15) not null default '0';
mysql error: Duplicate column name 'warning_level'
mysql error number: 1060
Date: Sunday 09th of January 2005 03:50:26 PM
Script: http://www.mydomain.com/forum/admincp/install_warn.php
Referer: http://www.mydomain.com/forum/admincp/install_warn.php
Username: 
IP Address: 84.*.*.*

[sv1cec]

Run the following query:

ALTER TABLE `user` DROP COLUMN `warning_level`

Don't forget to add the table prefix in front of the table name, if you are using one.

Rgds

[taffy056]

Hi sv1cec,

Thanks for that, it worked with no problem

taffy

[lochie]

I skipped step 2 because I don't understand it. There is no instructions so what do I do?

[ - - Step 2 - - ]
New Phrases
Note: All phrase 'types' are: 'Control Panel Stop Message'

~~~~~~~~~~~~~~~~~
Var Name: warning_opt_updated
Content: Warning Options Updated
~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~
Var Name: warning_unban
Content: All Users Past Banned Limit Unbanned
~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~
Var Name: warning_warn_added
Content: Warning Type Added
~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~
Var Name: warning_warn_deleted
Content: Warning Type Deleted
~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~
Var Name: warning_warn_edited
Content: Warning Type Updated
~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~
Var Name: warning_warn_ndeleted
Content: Warning Type Not Deleted
~~~~~~~~~~~~~~~~~

This is all I had..

I don't want to continue with the upgrade until I sort this out just incase.

[Impulse]

Originally Posted by lochie

I skipped step 2 because I don't understand it. There is no instructions so what do I do?

[ - - Step 2 - - ]
New Phrases
Note: All phrase 'types' are: 'Control Panel Stop Message'

~~~~~~~~~~~~~~~~~
Var Name: warning_opt_updated
Content: Warning Options Updated
~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~
Var Name: warning_unban
Content: All Users Past Banned Limit Unbanned
~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~
Var Name: warning_warn_added
Content: Warning Type Added
~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~
Var Name: warning_warn_deleted
Content: Warning Type Deleted
~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~
Var Name: warning_warn_edited
Content: Warning Type Updated
~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~
Var Name: warning_warn_ndeleted
Content: Warning Type Not Deleted
~~~~~~~~~~~~~~~~~

This is all I had..

I don't want to continue with the upgrade until I sort this out just incase.

Go to your Admincp > Language & Phrases > Phrase Manager.

In that screen click the 'add Phrase' manager. There select the phrase type from the drop down menu, in your case this would be 'Control Panel Stop Message' (It's the last phrase type, so just scroll down in the drop down o.o)

Now, place the varnames in the varname box and the content thing in the text box. Leave the rest blank, hit save and you're done and just repeat the process over and over untill you've made them all.

I hope this explains it clear enough for you.

[DannyITR]

Is there any way to send an email when the user is banned? That is all this hack needs.

[sv1cec]

Originally Posted by DannyITR

Is there any way to send an email when the user is banned? That is all this hack needs.

Well, I am afraid you should upgrade to AWS. AWS has that feature you want, along with a lot more.

Rgds

[DannyITR]

Has anyone figure dout to allow multiple usergroups to see the users warnings but to remove the "warn user" link for the restr of them. I cannot get the code to work. I'm refering to post #17 on page 2 here.