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)

[NFLfbJunkie]

I don't have the TMS MOD installed and have the AWS MOD, version 3.6.8, installed successfully. So what exactly do I need to upload and/or edit (templates/files) to upgrade to 3.6.9?

[SuperTaz]

I got this error when I tried to update to the latest version. Image is below.

[Magnumutz]

You have to install TMS as well.

[Delphiprogrammi]

Originally Posted by Junkie

I don't have the TMS MOD installed and have the AWS MOD, version 3.6.8, installed successfully. So what exactly do I need to upload and/or edit (templates/files) to upgrade to 3.6.9?

/docs/upgrade.txt

[NFLfbJunkie]

I assume I first need to create the table "warningtype" and then import the SQL dump from the "warning_types" table?

[Delphiprogrammi]

Originally Posted by Junkie

I assume I first need to create the table "warningtype" and then import the SQL dump from the "warning_types" table?

No the warningtype table will be created by the product import.However if that is your wish you can

[SQL]
CREATE TABLE IF NOT EXISTS warningype (
warningtypeid INT(15) NOT NULL AUTO_INCREMENT,
title varCHAR(255) NOT NULL,
warn_points INT(15) NOT NULL DEFAULT '0',
warn_desc text NOT NULL,
warn_maturity INT(5),
warn_permban tinyint(1),
warn_type tinyint(3),
warn_alert tinyint(1),
warn_alertcomment MEDIUMTEXT,
PRIMARY KEY (warningtypeid));
[/SQL]
you just caught a bug the install code in the product file is not correct updating that ...The above query will query the new table

[NFLfbJunkie]

So the route I need to take to upgarde to 3.6.9 is this then:

1. SQL Dump of the warning_types table. And what does 'dump' actually mean? Is this the same as 'export'.
2. Run the above query to set up the 'warningtype' table
3. Import what was dumped in to the new table.

Anything else? Do I need to import the product and/or remove from product-aws.xml:

PHP Code:

<dependency dependencytype="product" parentproductid="tms" minversion="1.0.0" maxversion="" /> 


[Delphiprogrammi]

Originally Posted by Junkie

PHP Code:

<dependency dependencytype="product" parentproductid="tms" minversion="1.0.0" maxversion="" /> 


you only need todo this if you do not have the tms installed or you are for some reason unwilling to install it this step will stop vBulletin from throwing an error message if this is not installed and you try to import the product

[NFLfbJunkie]

I think I almost got it. From my first step that I listed, can you tell me what actually an SQL dump is of a table? Does this mean exporting the table information? And if I do the three steps above, I do not need to reimport the product-aws.xml, correct?

[NFLfbJunkie]

If I have 'vb' as my table prefix for all of my tables, where in the above query do I need to add the prefix?