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)

[Delphiprogrammi]

Originally Posted by mrpotatohead

Thanks for this...

...but I recevied this error when trying to install the product:

Database error in vBulletin 3.6.4:
 
Invalid SQL:
 
                INSERT INTO setting
                    (varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, validationcode, blacklist, product)
                VALUES
                    (
                    'warn_hierarchical',
                    'warning',
                    '0',
                    '1',
                    'free',
                    'yesno',
                    2,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_automatic',
                    'warning',
                    '0',
                    '1',
                    'free',
                    'yesno',
                    3,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_automaticpm',
                    'warning',
                    '0',
                    '0',
                    'free',
                    'yesno',
                    4,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_autocomments',
                    'warning',
                    '0',
                    '0',
                    'free',
                    'yesno',
                    5,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_automatic_warner',
                    'warning',
                    '2137',
                    '1',
                    'free',
                    '',
                    6,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_warner',
                    'warning',
                    '0',
                    '0',
                    'free',
                    '',
                    7,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_collector',
                    'warning',
                    '1',
                    '1',
                    'free',
                    '',
                    8,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_banned_limit',
                    'warning',
                    '2147483647',
                    '7',
                    'free',
                    '',
                    9,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_points_before_banned',
                    'warning',
                    '10',
                    '10',
                    'free',
                    '',
                    10,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_warnings_before_banned',
                    'warning',
                    '3',
                    '10',
                    'free',
                    '',
                    11,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_banned_usergroup_id',
                    'warning',
                    '13',
                    '8',
                    'number',
                    '',
                    12,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_protected_usergroups',
                    'warning',
                    '65717',
                    '',
                    'free',
                    '',
                    13,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_troll_usergroup_id',
                    'warning',
                    '13',
                    '9',
                    'number',
                    '',
                    14,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_restore_groupid',
                    'warning',
                    '18',
                    '2',
                    'number',
                    '',
                    15,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_incr_ban_days',
                    'warning',
                    '0',
                    '1',
                    'free',
                    'yesno',
                    16,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_max_no_bans',
                    'warning',
                    '0',
                    '3',
                    'free',
                    '',
                    17,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_bans_mature',
                    'warning',
                    '0',
                    '0',
                    'free',
                    '',
                    18,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_viewoption',
                    'warning',
                    'All',
                    'Mgm',
                    'free',
                    '<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"All\\\" \" . iif($setting[\'value\']==\'All\',\'selected=\"selected\"\') . \">All</option>\r\n<option value=\\\"Mgm\\\" \" . iif($setting[\'value\']==\'Mgm\',\'selected=\"selected\"\') . \">Mgm</option>\r\n</select>',
                    19,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_multiple_per_post',
                    'warning',
                    '1',
                    '1',
                    'free',
                    'yesno',
                    20,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_send_em_warning',
                    'warning',
                    '1',
                    '1',
                    'free',
                    'yesno',
                    21,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_send_pm_warning',
                    'warning',
                    '1',
                    '0',
                    'free',
                    'yesno',
                    22,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_email_on_ban',
                    'warning',
                    '1',
                    '1',
                    'free',
                    'yesno',
                    23,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_historical',
                    'warning',
                    '1',
                    '1',
                    'free',
                    'yesno',
                    24,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_allowoffpost',
                    'warning',
                    '1',
                    '1',
                    'free',
                    'yesno',
                    25,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_warnings_per_page',
                    'warning',
                    '20',
                    '15',
                    'free',
                    '',
                    26,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_textbutoption',
                    'warning',
                    'Text',
                    'Text',
                    'free',
                    '<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"Text\\\" \" . iif($setting[\'value\']==\'Text\',\'selected=\"selected\"\') . \">Text</option>\r\n<option value=\\\"Buttons\\\" \" . iif($setting[\'value\']==\'Buttons\',\'selected=\"selected\"\') . \">Buttons</option>\r\n</select>',
                    26,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_modoption',
                    'warning',
                    'All',
                    'Own',
                    'free',
                    '<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"Own\\\" \" . iif($setting[\'value\']==\'Own\',\'selected=\"selected\"\') . \">Own</option>\r\n<option value=\\\"All\\\" \" . iif($setting[\'value\']==\'All\',\'selected=\"selected\"\') . \">All</option>\r\n</select>',
                    28,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_sig_thresshold',
                    'warning',
                    '0',
                    '0',
                    'free',
                    '',
                    29,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_avatar_thresshold',
                    'warning',
                    '0',
                    '0',
                    'free',
                    '',
                    30,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_pic_thresshold',
                    'warning',
                    '0',
                    '0',
                    'free',
                    '',
                    31,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_pmcutoff',
                    'warning',
                    '0',
                    '0',
                    'free',
                    '',
                    32,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_admingroups',
                    'warning',
                    '6',
                    '',
                    'free',
                    '',
                    33,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_sigpic_thresshold',
                    'warning',
                    '0',
                    '0',
                    'free',
                    '',
                    33,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_smodgroups',
                    'warning',
                    '5',
                    '',
                    'free',
                    '',
                    34,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_aprotected_usergroups',
                    'warning',
                    '17',
                    '',
                    'free',
                    '',
                    34,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_modgroups',
                    'warning',
                    '7',
                    '',
                    'free',
                    '',
                    35,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_includepost',
                    'warning',
                    '1',
                    '0',
                    'free',
                    'yesno',
                    36,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_savecopy',
                    'warning',
                    '1',
                    '0',
                    'free',
                    'yesno',
                    37,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_savecopyalert',
                    'warning',
                    '1',
                    '0',
                    'free',
                    'yesno',
                    38,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_savecopyforum',
                    'warning',
                    '38',
                    '',
                    'free',
                    '',
                    39,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_allowalerts',
                    'warning',
                    '1',
                    '0',
                    'free',
                    'yesno',
                    40,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_allowalertscomment',
                    'warning',
                    '1',
                    '0',
                    'free',
                    'yesno',
                    41,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_alertslifetime',
                    'warning',
                    '0',
                    '0',
                    'free',
                    '',
                    42,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_allownotes',
                    'warning',
                    '1',
                    '1',
                    'free',
                    'yesno',
                    43,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    ),
    (
                    'warn_version',
                    'warning',
                    '3.4.11',
                    '3.6.1',
                    'free',
                    '',
                    44,
                    0,
                    1,
                    '',
                    0,
                    'aws'
    );
 
MySQL Error  : Duplicate entry 'warn_hierarchical' for key 1
Error Number : 1062
Date         : Thursday, December 21st 2006 @ 08:33:11 PM
Script       : http://www.bigbrotherwebsite.net/for...=productimport
Referrer     : http://www.bigbrotherwebsite.net/for...?do=productadd
IP Address   : 86.149.221.27
Username     : Big Brother
Classname    : vb_database

Any ideas?!

that's obvious you already had the system installed and tryed to install again over the existing installation.If you want to delete all settings used by the system you run

[SQL]
"DELETE FROM" . TABLE_PREFIX . "setting WHERE varname LIKE 'warn_%'";
[/SQL]

[Delphiprogrammi]

Originally Posted by Artificial_Alex

Uhh.I need help installing this ;-;

Status: Not Installed

why you didn't install it ?

[Artificial_Alex]

I did install it o_o;;;;;;;;;;;;;;;;;

[mrpotatohead]

Originally Posted by Delphiprogrammi

that's obvious you already had the system installed and tryed to install again over the existing installation.If you want to delete all settings used by the system you run

[SQL]
"DELETE FROM" . TABLE_PREFIX . "setting WHERE varname LIKE 'warn_%'";
[/SQL]

Thanks, gave that a go running that query and it came up with this:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"DELETE FROM" . TABLE_PREFIX . "setting WHERE varname LIKE 'warn_%'"' at line 1

Guess it's easy when you know how?! I've deleted all the tables in my database with the prefix warn_ and the warnings ones etc., if that is what the query is meant to achieve... but still no luck!

The error relates to the tables that don't even exist - I had previously installed AWS on my previous server, and had moved the board recently - but stopped using AWS for a while - and now want to reinstall it...


Thanks for your help m8 btw,


- Joe

[Delphiprogrammi]

Originally Posted by mrpotatohead

Thanks, gave that a go running that query and it came up with this:




Guess it's easy when you know how?! I've deleted all the tables in my database with the prefix warn_ and the warnings ones etc., if that is what the query is meant to achieve... but still no luck!

The error relates to the tables that don't even exist - I had previously installed AWS on my previous server, and had moved the board recently - but stopped using AWS for a while - and now want to reinstall it...


Thanks for your help m8 btw,


- Joe

[SQL]
DELETE FROM setting WHERE varname LIKE 'warn_%';
[/SQL]

that will remove all settings used by the system.Your MySQL returned an error because "TABLE_PREFIX" is only parsed in vbulletin's PHP files and not when you run a query through PhpMyAdmin (or the tool in the admincp) the above query will work.Deleting the tables added by this hack will not delete all data used.You can perfectly stop using the system but leave it installed by disabling it in the admincp.

[Delphiprogrammi]

Originally Posted by Artificial_Alex

I did install it o_o;;;;;;;;;;;;;;;;;

if you want to uninstall the system delete the product and all of it's files (when you do this you will loose all (aws related) database information)

[tank14]

How come I only see this? Warning Level : 90 I want to see how many warning he or she got ect..

[Delphiprogrammi]

Originally Posted by tank14

How come I only see this? Warning Level : 90 I want to see how many warning he or she got ect..

you got the necesarry rights to view that information ?

[tank14]

Originally Posted by Delphiprogrammi

you got the necesarry rights to view that information ?

Yup, But I also want all to see it. I am the root admin, but at clantemplates.com they use this and it shows everyone.

[tank14]

btw its in the legacy postbit