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

[SamirDarji]

Originally Posted by sv1cec

My friend, if you had no warnings in ZT's hack, delete everything and start from scratch. Why bother?

I guess I misunderstood the uinstaller the first time I read it. I thought I'd have to redo all the template mods. That would be a pain.

Originally Posted by sv1cec

The query above is the one which modifies ZT's table to mine, but it is an older version, it does not have the 'version' column, download the last zip and get it from the upgrade_warn.php file.

Will do. I'll try run the query first, but if that doesn't work, I'll uninstall and install from scratch.

[sv1cec]

Originally Posted by SamirDarji

I guess I misunderstood the uinstaller the first time I read it. I thought I'd have to redo all the template mods. That would be a pain.


Will do. I'll try run the query first, but if that doesn't work, I'll uninstall and install from scratch.

I double-checked (sometimes, you never know what YOU have done), and the uninstaller removes only the templates that the hack adds. Not the ones, which existed and you modified. And of course, it does not change the php files you changed.

Rgds

[SamirDarji]

Well, here's what I got back from the SQL Query:

Database forum - Table warning_options running on hsvtest.ods.org 
Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 527
STR: "
SQL: alter table warning_options 
add `hierarchical` char(3),
add `automatic` char(3),
add `automatic_warner` int(10) unsigned,
add `warner` int(15),
add `troll_usergroup_id` varchar(10),
add `aprotected_usergroups` varchar(0),
add `restore_groupid` smallint(5) unsigned,
add `incr_ban_days` char(3),
add `max_no_bans` int(5),
add `viewoption` char(3),
add `multiple_per_post` char(3),
add `send_pm_warning` char(3),
add `send_em_warning` char(3),
add `historical` char(3),
add `allowoffpost` char(3),
add `warnings_per_page` int(3)";

SQL-query :  

alter table warning_options add `hierarchical` char(3), add `automatic` char(3), add `automatic_warner` int(10) unsigned, add `warner` int(15), add `troll_usergroup_id` varchar(10), add `aprotected_usergroups` varchar(0), add `restore_groupid` smallint(5) unsigned, add `incr_ban_days` char(3), add `max_no_bans` int(5), add `viewoption` char(3), add `multiple_per_post` char(3), add `send_pm_warning` char(3), add `send_em_warning` char(3), add `historical` char(3), add `allowoffpost` char(3), add `warnings_per_page` int(3)"; 

MySQL said: 


Too big column length for column 'aprotected_usergroups' (max = 255). Use BLOB instead

I ran it in both phpmyadmin and through admincp. Anything else left to try before I just uninstall and reinstall?

[sv1cec]

Originally Posted by SamirDarji

Well, here's what I got back from the SQL Query:

Database forum - Table warning_options running on hsvtest.ods.org 
Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 527
STR: "
SQL: alter table warning_options 
add `hierarchical` char(3),
add `automatic` char(3),
add `automatic_warner` int(10) unsigned,
add `warner` int(15),
add `troll_usergroup_id` varchar(10),
add `aprotected_usergroups` varchar(0),
add `restore_groupid` smallint(5) unsigned,
add `incr_ban_days` char(3),
add `max_no_bans` int(5),
add `viewoption` char(3),
add `multiple_per_post` char(3),
add `send_pm_warning` char(3),
add `send_em_warning` char(3),
add `historical` char(3),
add `allowoffpost` char(3),
add `warnings_per_page` int(3)";

SQL-query :  

alter table warning_options add `hierarchical` char(3), add `automatic` char(3), add `automatic_warner` int(10) unsigned, add `warner` int(15), add `troll_usergroup_id` varchar(10), add `aprotected_usergroups` varchar(0), add `restore_groupid` smallint(5) unsigned, add `incr_ban_days` char(3), add `max_no_bans` int(5), add `viewoption` char(3), add `multiple_per_post` char(3), add `send_pm_warning` char(3), add `send_em_warning` char(3), add `historical` char(3), add `allowoffpost` char(3), add `warnings_per_page` int(3)"; 

MySQL said: 


Too big column length for column 'aprotected_usergroups' (max = 255). Use BLOB instead

I ran it in both phpmyadmin and through admincp. Anything else left to try before I just uninstall and reinstall?

The query is NOT the one you should be running. I told you to download the zip file again and extract the upgrade_warn.php from the zip and look in that file for the query. The query you are running does not include the column 'version' and it has a mistake in the column `aprotected_usergroups', which has a length of 0.

You said you have no TABLE_PREFIX, so run this query here:

alter table warning_options
add `version` char(10),
add `hierarchical` char(3),
add `automatic` char(3),
add `automaticpm` char(3),
add `automatic_warner` int(10) unsigned,
add `warner` int(15),
add `troll_usergroup_id` varchar(10),
add `aprotected_usergroups` varchar(10),
add `restore_groupid` smallint(5) unsigned,
add `incr_ban_days` char(3),
add `max_no_bans` int(5),
add `viewoption` char(3),
add `multiple_per_post` char(3),
add `send_pm_warning` char(3),
add `send_em_warning` char(3),
add `historical` char(3),
add `allowoffpost` char(3),
add `warnings_per_page` int(3)

Rgds

[SamirDarji]

Originally Posted by sv1cec

The query is NOT the one you should be running. I told you to download the zip file again and extract the upgrade_warn.php from the zip and look in that file for the query. The query you are running does not include the column 'version' and it has a mistake in the column `aprotected_usergroups', which has a length of 0.

You said you have no TABLE_PREFIX, so run this query here:

alter table warning_options
add `version` char(10),
add `hierarchical` char(3),
add `automatic` char(3),
add `automaticpm` char(3),
add `automatic_warner` int(10) unsigned,
add `warner` int(15),
add `troll_usergroup_id` varchar(10),
add `aprotected_usergroups` varchar(10),
add `restore_groupid` smallint(5) unsigned,
add `incr_ban_days` char(3),
add `max_no_bans` int(5),
add `viewoption` char(3),
add `multiple_per_post` char(3),
add `send_pm_warning` char(3),
add `send_em_warning` char(3),
add `historical` char(3),
add `allowoffpost` char(3),
add `warnings_per_page` int(3)

Rgds

Ooops!! I forgot to get the newest zip. It's been a crazy day. Trying to change headlights in my car and it was so cold that my frozen hands couldn't do anything for more than 15 mins. So I was going back and forth between this and the car.

[SamirDarji]

That worked. Should I go ahead and run the other query that put the default options in the tables or should I just go ahead and set the warning options through admincp?

[nubian]

can somebody please help me.
i cannot find this...

   $post[reputationdisplay]</if>

in my postbit.
the only thing that comes close to that is this:

   <div class="smallfont">
 		 		<if condition="$post['joindate']"><div>$vbphrase[join_date]: $post[joindate]</div></if>
 		 		<if condition="$post['field2']"><div>$vbphrase[location_perm]: $post[field2]</div></if>
 		 		<if condition="$post['age']"><div>$vbphrase[age]: $post[age]</div></if>
 					<div>
 		 		 $vbphrase[posts]: $post[posts]
 					</div>
 		 		<if condition="$show['reputation']"><if condition="$show['reppower']">$vbphrase[reppower]: $post[reppower] </if><div>$post[reputationdisplay]</div></if>
 		 		<div>$post[icqicon] $post[aimicon] $post[msnicon] $post[yahooicon]</div>
   				</div>

do i just add it under this line of code?

<if condition="$show['reputation']"><if condition="$show['reppower']">$vbphrase[reppower]: $post[reppower] </if><div>$post[reputationdisplay]</div></if>

i have a virgin postbit template from v 3.0.3
i'm very new to coding
thanks in advance

[nubian]

with my post above i've used my best guess.
looked like some of the lines were in that exact letter case.

i have another problem.
everythign seems to be okay but when i try to enter threads it looks like the image below.
i've re-enter the lines of codes neccesary for showthread.php and functions_showthread.php

can any of you tell me why it's doing this.
please help
thanks in advance

[SamirDarji]

Originally Posted by nubian

with my post above i've used my best guess.
looked like some of the lines were in that exact letter case.

i have another problem.
everythign seems to be okay but when i try to enter threads it looks like the image below.
i've re-enter the lines of codes neccesary for showthread.php and functions_showthread.php

can any of you tell me why it's doing this.
please help
thanks in advance

Sounds like a template issue to me rather than a php one. Check over your template changes and make sure they are correct too.

[TRStealth]

Originally Posted by TRStealth

I'm getting a problem:

Database error in vBulletin 3.0.3:

Invalid SQL: update warning_options set
hierarchical='No',
automatic='No',
automaticpm='No',
warner='1',
automatic_warner='1',
banned_limit='5',
points_before_banned='10',
banned_usergroup_id='8',
troll_usergroup_id='8',
protected_usergroups='5|6|7|11|14|5|6|9|13|15|12|10',
aprotected_usergroups='11|14|5|6|9|13|15|12|10',
restore_groupid='',
incr_ban_days='Yes',
max_no_bans='2',
viewoption='Mgm',
multiple_per_post='No',
send_pm_warning='Yes',
send_em_warning='No',
historical='Yes',
allowoffpost='Yes',
warnings_per_page='30'
 where oid='1'
mysql error: Unknown column 'automaticpm' in 'field list'

mysql error number: 1054

Date: Sunday 12th of December 2004 07:14:35 PM
Script: http://www.enclave1.net/forums/admincp/admin_warn.php
Referer: http://www.enclave1.net/forums/admincp/admin_warn.php?act=manageoptions
Username: Stealth
IP Address: xx.xx.xx.xx

Also, when I go to Warn.php?do=ViewMyWarnings , it just comes out as a blank page.

I fixed the view warnings thing, but can anyone tell me why I'm getting the SQL Error?