Advanced Warning System (AWS)

Advanced Warning System Version 3.5.0

The AWS version for vB 3.5 has been released. You can download it and get support in this thread:

https://vborg.vbsupport.ru/showthread.php?p=770032


Advanced Warning System Version 3.4.16 (latest stable release for vB 3.0.x)


LATEST ANNOUNCEMENT

The AWS has its own Premium Forum here at vBulletin.org, so please use that for questions and discussion on this hack.

The Permium Forum is located at :

https://vborg.vbsupport.ru/forumdisplay.php?f=105





This Warning System owes its existence to Zero Tolerance's Warning Hack (https://vborg.vbsupport.ru/showthread.php?t=65336). I liked the idea, so I installed Zero's hack in my forums site. However, as in most cases, I was not fully satisfied with the way it worked, so I started customizing it. Other people in the thread above, asked questions, which I had already answered by my customizing work, so I answered, giving away those parts of the code, that I had modified.

In the long run, I almost hijacked the thread and the hack from Zero, so I guess I owe him an apology. However, the mods I did have compiled a new, more complete warning system, with much more functionality. Several members from that thread, asked if this could be released as a new hack, so after discussing it with Zero, here it is.

What it does? Well, it is a Warning System, which means it allows you (the administrative team of your site, in other words the admins, the supermods and the mods), to define offences, which the members of your forum should NOT commit. But as we all know, there are instances where members do not follow the rules. In that case, this warning system, allows you to issue a warning to the member who commited the offence. The warning has some points associated with it, as well as a period over which it is valid. When a member gathers enough points, he is banned from your forums, for a predefined period of time. That's mostly it, but below, you can find a short list of features:

Full warning system with:

- post- and non-post-related warnings
- hierarchical warning schema
- hidden or real warners
- customizable maximum warning points
- automatically bans members who reached the maximum warning points
- customizable ban days
- customizable ban user group and permanent ban user group
- customizable restore user group, where users are restored after they get unbanned
- customizable option for who can see the warning level of the members
- automatically issued warnings for posts which contain censored words
- automatically issued warnings for private messages which contain censored words
- supports incremental banning periods
- supports multiple warnings for the same post
- warned members are notified either by Private Message or e-mail when they are warned and when one of the warnings they have received is either deleted or expired
- 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 deleted
- reports for admin, mods and members
- 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 Manager.
- statistics show warning per type, warnings per warner, bans per user.
- Allows you to warn a user from your AdminCP/User Manager.
- Large "Warn" sign, in posts which have received a warning, for mods, supermods and admins, to easily distinguish those posts.
- Ability to remove user's avatar, signature or usage of the Private Messaging system, depending on the warning points he has collected.
- Supports non-standard admins, supermods and mods user groups.
- Allows you to save a copy of the warning send to the warned user, in a predefined forum.
- Allows you to issue "Alerts" (warnings without warning points, for first-time offenders)
- Allows you to add private or public notes for a user, either post-specific or not. Notes appear in the postbit, above each user's message.
- etc.

Admitedly, this is not an easy hack to install. It requires 20 new templates and modifications to some existing ones too. It requires five new tables and modifications to some others. It requires several new phrases. I've tried to make the installation, as easy as I could, by automating certain tasks in an automatic installer. The installer will add the new templates for you, add the new tables required and change the existing ones, and will add the required new phrases. You will have to manually edit the existing templates and the php files though. I also included an upgrade script, which will upgrade those who are using Zero Tolerance's warning hack (version 1.5) to this one. An uninstaller is also included, which removes what the installer installs.

Please keep in mind, that this is a very difficult hack to install. For this reason, I strongly recommend that you back up your database before starting the installation. I also suggest that you keep copies of each file and template you edit, so that you can always revert to a previous stable condition. Finally, I strongly suggest that you always run the latest release.

The zip file always contains both the instructions and the files required to install the latest version. If you have installed a previous version and want to upgrade to the latest, there is a text file attached, in the zip with upgrade instructions. Follow them.

In this thread, you will also find a more detailed document describing the features of this hack, as well as a document describing its version evolution.

Also keep in mind that the installer, will add the AWS templates only to your default style. If you want to use them in another one, you may try this Zero Tolerance's hack, which copies the templates to other styles you may have.

Another thing, the installation instructions were written when vB was at release 3.0.3, so you may expect to find some differences, with the latest files and templates. As far as I can tell, I haven't faced any such case, but I post this reservation here, since I do not have the time to recheck all the instructions for compliance with the latest vB release. The hack has been installed and is working fine with the vBulletin version shown at the top of this thread.

Finally, if you are using more than one style, the installer will install the templates only in the default one. If you want to use the rest of your styles, here is a hack, that will do this for you.

This hack can also be integrated with Zero Tolerance's vBChat. However, since I am using a heavily-modified version of vBChat, I haven't included instructions, on how to patch the original vBChat files, in the documentation. If you are interested in having AWS issue automatic warnings when one of your user enters a censored word in a vBChat message, or if you want your moderators to be able to warn a user, who misbehaves in vBChat, please post a thread in this forum and I'll help you through.

This is my first officially released hack, so please don't be to harsh with me, if I broke any rules or made any mistakes. The mods have been tested extensively, both by me and two volunteers (thank you gentlemen), but I am only human.

Closing, let me thank Zero Tolerance, who got me started in this, and who owns a big part of the code of this hack. I definnitely couldn't have done it, without his code.

Special Note
For those who upgrade from Zero Tolerance's hack to my AWS, even though I have included a script which will do some of the work automatically, not everything is done by that script. Read the installation instructions carefully. You have to run the upgrade script first and then do several things manually. If you just run the upgrade script and just upload the files, the AWS will not work properly. If you have any questions, please do not hesitate to post here.

Also, let me add here, that version 3.3.0 wouldn't have been possible without the contribution of Revan.

And a couple of warnings:

PLEASE DOWNLOAD THE LATEST ZIP FILE FROM HERE, BEFORE YOU START INSTALLING THIS HACK. JUST BECAUSE YOU DOWNLOADED IT A COUPLE OF DAYS AGO, THAT DOES NOT MEAN IT IS THE LATEST VERSION. MAKE SURE YOU DOWNLOAD THE ZIP, JUST BEFORE YOU START INSTALLING THIS HACK.


LATEST VERSION

Version 3.4.16 (released Thursday August 25th, 2005 GMT 18:18)

A couple of bugs fixed in this version. One is related to the Notes feature, and it allowed plain users to see the notes entered, if the "Who can view warning points" setting was set to "All".

Features.txt a new version of this file has been uploaded on April 4th2 005 GMT 09:30, which covers the latest additions to the hack. The original Features.txt file hasn't been updated since the first release of this hack, so it was time for an update.

John

[Revan]

Originally Posted by sv1cec

Raven,

Its Revan damit

Originally Posted by sv1cec

Your idea of using $vboptions is a solid one, I didn't think of that, as I used ZT's original structure and I just used that table for my hack as well. The query for the options is indeed a pain. I wish I had thought about it, because now, I have to go back and edit all the files (not too ddifficult) and all the templates (gosh I hate that)! Darn!!!

I have already done this, the hack is now working 100 % using $vboptions

Originally Posted by sv1cec

And indeed, the code needs some cleaning work. Now that I've finished installing the other hack I mentioned above (the Inline Moderation Hack, great one), I think I'll spend some time cleaning up the mess.

I just need to clean the 800 lines in Warn.php, and then make the templates XHTML compliant, and this will be done too

Originally Posted by sv1cec

Of course, your help is welcome, don't forget I started this from ZT's code, so a lot of the code is not mine either. An installer which will take into consideration the styles thing would be a great help, as I do not have any additional styles and I can't even help users with this issue. I just do not know how to handle them.

I offered to write a datastore installer, not template installer. And the installer as-is did take my substyles into consideration, it installed in the default style (parent style), and this auto added templates to the child styles

Originally Posted by sv1cec

As for the Yes/No/Yes thing on the drop down menus, I am not sure I can do something about it, I am using vB's standard method, and that's how they show up after you set the value once.

Is that so... Weird, seeing as I already fixed it
Its not vB standard at all mate

PHP Code:

    $permoption = "
        <option value=\"No\" " . iif($warn['warn_permban'] == 'No', 'selected="selected"') . ">No</option>
        <option value=\"Yes\" " . iif($warn['warn_permban'] == 'Yes', 'selected="selected"') . ">Yes</option>
    ";
    $typoption = "
        <option value=\"No\" " . iif($warn['warn_type'] == 'No', 'selected="selected"') . ">No</option>
        <option value=\"Yes\" " . iif($warn['warn_type'] == 'Yes', 'selected="selected"') . ">Yes</option>
    "; 


This works like a charm


I'll get back to you about this once Im done with the cleanup


//peace

[sv1cec]

Originally Posted by Revan

Its Revan damit

I have already done this, the hack is now working 100 % using $vboptions

I just need to clean the 800 lines in Warn.php, and then make the templates XHTML compliant, and this will be done too

I offered to write a datastore installer, not template installer. And the installer as-is did take my substyles into consideration, it installed in the default style (parent style), and this auto added templates to the child styles

Is that so... Weird, seeing as I already fixed it
Its not vB standard at all mate

PHP Code:

    $permoption = "
        <option value=\"No\" " . iif($warn['warn_permban'] == 'No', 'selected="selected"') . ">No</option>
        <option value=\"Yes\" " . iif($warn['warn_permban'] == 'Yes', 'selected="selected"') . ">Yes</option>
    ";
    $typoption = "
        <option value=\"No\" " . iif($warn['warn_type'] == 'No', 'selected="selected"') . ">No</option>
        <option value=\"Yes\" " . iif($warn['warn_type'] == 'Yes', 'selected="selected"') . ">Yes</option>
    "; 


This works like a charm


I'll get back to you about this once Im done with the cleanup


//peace

Revan,

Sorry for the name mixup! I know I shouldn't type, before I have a full glass of coffee in my system.

Re. vboptions, good work, let's see it. I did some maintenance work on my site, and moved the warn_options query to the global.php file, in that way it is executed only once, that should help reduce the queries counter.

Re. Yes/No/Yes issue, what can I say, you are a much better coder than I am. Going to change this now.

Rgds

[Revan]

Originally Posted by sv1cec

Sorry for the name mixup! I know I shouldn't type, before I have a full glass of coffee in my system.

Hehe no worries mate

Originally Posted by sv1cec

Re. vboptions, good work, let's see it.

I'll get to work on the Warn.php right now then

Originally Posted by sv1cec

I did some maintenance work on my site, and moved the warn_options query to the global.php file, in that way it is executed only once, that should help reduce the queries counter.

Cool, Im all for query optimisations

Originally Posted by sv1cec

Re. Yes/No/Yes issue, what can I say, you are a much better coder than I am. Going to change this now.

Meh, I just entered debug mode, stole the code vB uses to create the "Date Format" (Yesterday/Today etc) and modded it to fit this


//peace

[mcyates]

FAO sv1cec
================
Quality hack,

I installed it perfectly a couple of weeks ago, but i restarted my forum but kept the same database but i can't install the latest version. What i need is some SQL code which i can put in phpmyadmin which will remove them all and let me install it properly.

Or you could just let me know where all the warning database tables / columns are so i can manually remove them. Also i had Zero Tolerance's Warning Hack installed before yours, so some of their tables / columns might need removing.

Thanks in advance, i just need this hack installed again as it was very usefull.

I sit waiting.....

[rh2004]

Hi when I run the install I always get this error?

Database error in vBulletin 3.0.3:

Invalid SQL: INSERT INTO `warning_options` values ('1','Yes', 'No', '','0','7','10','8','6','8','0','Yes','3','All','Yes','Yes','No','Yes','Yes','15')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Sunday 05th of December 2004 10:40:05 PM
Script: /adminpanel/install_warn.php[/url]
Referer: 
Username:
IP:

Can you help

Also what do I ned to do to my other templates, so it works?

[+d-cipher]

Originally Posted by rh2004

Hi when I run the install I always get this error?

Database error in vBulletin 3.0.3:
 
 Invalid SQL: INSERT INTO `warning_options` values ('1','Yes', 'No', '','0','7','10','8','6','8','0','Yes','3','All','Yes','Yes','No','Yes','Yes','15')
 mysql error: Column count doesn't match value count at row 1
 
 mysql error number: 1136
 
 Date: Sunday 05th of December 2004 10:40:05 PM
 Script: /adminpanel/install_warn.php[/url]
 Referer: 
 Username:
 IP:

Can you help

Also what do I ned to do to my other templates, so it works?

Same for me.

[sv1cec]

Originally Posted by +d-cipher

Same for me.

Sorry folks, change that line in install_warn.php, with the one below:

PHP Code:

$install[]="INSERT INTO `".TABLE_PREFIX."warning_options` values ('1','Yes', 'Yes','No', '','0','7','10','8','6', '6','8','0','Yes','3','All','Yes','Yes','No','Yes','Yes','15')"; 


The difference is one more 'Yes' in the beginning.

Sorry for the inconvenience.

[sv1cec]

Originally Posted by mcyates

FAO sv1cec
================
Quality hack,

I installed it perfectly a couple of weeks ago, but i restarted my forum but kept the same database but i can't install the latest version. What i need is some SQL code which i can put in phpmyadmin which will remove them all and let me install it properly.

Or you could just let me know where all the warning database tables / columns are so i can manually remove them. Also i had Zero Tolerance's Warning Hack installed before yours, so some of their tables / columns might need removing.

Thanks in advance, i just need this hack installed again as it was very usefull.

I sit waiting.....

The following tables are used by this hack (and Zero's):

warning_options
warning_types
warnings

If you had installed version 2.0 and above, you would also have a table named pmtext_warned.

Zero was using another table for banned users, called banned_members. All these should be in your database, and should be useable again.

If you want to delete them and start from scratch, just make sure you do not use a TABLE_PREFIX. If you do, add that in the installation script.

I would suggest that you do not start with Zero's hack, go directly to the installation of this one, the installation procedure is much easier.

Let me know if that helps.

Rgds

[Delphy]

Hiya,

Just found this hack and tried installing from scratch. I get an error:

Invalid SQL: INSERT INTO `warning_options` values ('1','Yes', 'Yes','No', '','0','7','10','8','6','8','0','Yes','3','All','Y es','Yes','No','Yes','Yes','15 ')
mysql error: Column count doesn't match value count at row 1

Looking at the script, the "`max_no_bans` int(5)," column is missing from the insert statement. Adding this back in (Line 208 of install_warn.php) makes it work.

I guessed at a value for max_no_bans - can you tell me what it *should* be?

Regards
Delphy

[sv1cec]

Originally Posted by Delphy

Hiya,

Just found this hack and tried installing from scratch. I get an error:

Invalid SQL: INSERT INTO `warning_options` values ('1','Yes', 'Yes','No', '','0','7','10','8','6','8','0','Yes','3','All','Y es','Yes','No','Yes','Yes','15')
mysql error: Column count doesn't match value count at row 1

Looking at the script, the "`max_no_bans` int(5)," column is missing from the insert statement. Adding this back in (Line 208 of install_warn.php) makes it work.

I guessed at a value for max_no_bans - can you tell me what it *should* be?

Regards
Delphy

Delphy,

It was not the max number of bans which was missing, it is the aprotected_usergroups.

Try changing that line to:

PHP Code:

$install[]="INSERT INTO `".TABLE_PREFIX."warning_options` values ('1','Yes', 'Yes','No', '','0','7','10','8','6', '6','8','0','Yes','3','All','Yes','Yes','No','Yes','Yes','15')"; 


Mind you, I just uploaded a new version, so you may want to download the latest zip.

Rgds