Administrative and Maintenance Tools - Advanced Warning System 3.6.7

Advaned Warning System

This is a port of aws and i release this with permission...(yes i did ask the original author)

This version of the warning includes

• 1 vbulletin 3.6.x product file (XML)
• 1 admincp navigation XML
• 1 functions file(functions_warning.php)
• 3 images
• 3 cronjobs
• 1 modcp file to allow moderators to view warnings information without having to give admincp access(mod_warn.php)
• 1 admincp file to manage the system options(admin_warn.php)
• 1 XML to control permissions(bitfield_aws.xml)

For a completer list of the system features you can refer to this

This version will also require vbulletin 3.6.x to run.If you run 3.5.x or any other release then 3.6.x you will see a message.

This system is tested for a long time and i believe it's stable enough for a public release HOWEVER since this is a major hack and i'm just human please consider this first public run still as "beta"

instructions ow howto install can be found in the docs directory within the zip

statistics

• 25 plugins
• 27 templates
• 5 new MySQL tables
• 3 standard vbulletin tables alterd (user,post,and usergroup)
• 827 phrases
• 47 settings

updates

A problem has been found where no link is provided to view your own warnings(normal users) in the member profile only i fixed this.To get the fix you will need to reedit your "MEMBERINFO" template and reimport product-aws.xml (set allow overwrite to yes)

15-9-2006
I moved the cron jobs from the install/uinstall code to the product file.
version check url now uses https://vborg.vbsupport.ru/misc.php?...rsion&t=124477

to upgrade read upgrade.txt in the docs directory

24-9-2006

a product depency whas added the system will no longer install on PHP 5 (in response to continued error reports on that PHP version)

to report a possible bug

please go the system bugtracker here you can use the folowwing account

username:bugreporter
password:awsbug

no need to register yourself


30-11-2006
People on PHP 5 can follow this instructions to avoid the PHP version related error message BUT remember you are on your own if you do this.I won't upgrade my PHP until PHP 5 is there main stable release (www.php.net)


1-1-2007
A bug has been reported in the system.This bug whas causing vbulletin to throw an error when you try to use admincp => users=> add a new user

Fatal error: Call to a member function clean_gpc() on a non-object in class_dm_user.php(2385) : eval()'d code on line 35

Solution

Edit plugin "AWS:warn link in usermanager" and replace all code with this

PHP Code:

$quicklinks["../Warn.php?" . $vbulletin->session->vars['sessionurl'] . "do=WarnUserNoPost&id=" . $vbulletin->GPC['userid']] = $vbphrase['aws_warn_user_admin']; 


i'll update the package when i get home


Another Bug is fixed

This release includes a fix for the problem "call to member function on a non object class_dm_user.php)" when you try to add a new user manaually (after submitting the form)

[HossMon]

I'm just upgrading my forums to v3.6 from 3.5 (not going to 3.7 just yet)
I had this installed and working on v3.5. After installing on 3.6 I now get this database error when selecting "Statistics - Warnings Per User" in the ACP

Invalid SQL:
SELECT COUNT(*) AS users FROM user WHERE warns > 0 OR alerts > 0 OR warning_bans > 0;

MySQL Error : Unknown column 'warns' in 'where clause'

Any ideas?
As this is just a test upgrade and not my live board, I have time to work thru this problem, but...

[sv1cec]

Try changing that statement to:

SELECT COUNT(*) AS users FROM user WHERE warnings > 0 OR alerts > 0 OR warning_bans > 0;

[HossMon]

Should I run it as a query or thru PHPmyAdmin?
Also, if I'm reading correctly this is in the User table, correct?

[HossMon]

Actually after further examination I think I see the problem. Though what the "proper" solution is, I'm not so sure of.

From the AWS xml file there is this

$install[] = "ALTER TABLE " . TABLE_PREFIX . "user
ADD COLUMN warns INT(5) DEFAULT '0',
ADD COLUMN warning_level INT(15) DEFAULT '0',
ADD COLUMN warning_bans INT(2) DEFAULT '0',
ADD COLUMN alerts INT(5) DEFAULT '0',
ADD COLUMN warn_notes SMALLINT DEFAULT '0'

However in my user table I have a column named warnings
But none named warns

Solved!
SHould anyone else run into this...
In phpmyadmin > select the user table > look for column named warns > tick the box and select/click the "change" operation > rename to warnings and save.

[HossMon]

Hey sv1cec if your around today.
I had all sorts of problems with this version. DB errors and way too many items to list. I'm not complaining, as I love AWS, but I uninstalled it and went back to the 3.5.4 version.
Which I did get to work using TMS and modifying a few of the template edits to work with vB 3.6.9

I have 1 problem that I've found so far. I'm getting the

The administrator has not specified any groups that contain banned users.

Please do so using the usergroup editor.

Error in ACP when trying to "View Banned Users". Which after reading thru the 3.5.4 thread I never did see a way to resolve. Is there a solution?

And before I run off, I'd just like to say thanks to both you and Delphi for all the work you two have put into this mod! :tup:

[sv1cec]

Well, I am not sure, there is no such message in the code I've written. so I guess:

1. Make sure there is at least one banned users usergroup.
2. Make sure you enter that usergroup in the appropriate area in the Warning Options, in the Admin CP.

[HossMon]

Thanks John
As it turns out... as in an old thread by yourself that I read after posting this... The link in the ACP > AWS area does not work.
However, the lin in the ACP Users > View Banned Users does!
I can live with that.

Thanks again

[sv1cec]

See?! How bright of me to write new code for viewing banned users, when there was already a script doing it? LoRL.

Just go into your admincp and change the link, in the AWS menu to the one that the Users menu points to.

[tehPARADOX]

Does anybody have a working kill_warns script that actually removes matured warnings?

[ViciousCode]

is there a mod like this for 3.7x?