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 puertoblack2003

beautiful hack love it.Installed..Is there a solution About the avatar i read members talking about it but no one answered...my members wants the avatar to show...but i'll wait for the answer:surprised:

if you want to ALWAYS allow members to keep there avatar simply set the avatar cut off setting to 0 (zero) and submit the form.This setting is under the "additional restrictions" header in the manage warning options page

[Delphiprogrammi]

no more issues for over a week i have taken away the beta tag ooh well issues i'm able to reproduce anyway i mean.

[wrestlepower]

hi, when i try to manage the warning types, i get the following DB error:

Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT * FROM warning_types ORDER BY warn_points,warn_maturity,warn_name;

MySQL Error : Unknown column 'warn_maturity' in 'order clause'
Error Number : 1054
Date : Saturday, September 23rd 2006 @ 07:25:15 PM
Script : http://www.wrestlepower.net/admincp/...rn.php?do=view
Referrer : http://www.wrestlepower.net/admincp/index.php?do=nav
IP Address : My IP
Username : Duff
Classname : vb_database


EDIT: Just noticed i also get a DB error when i try to update a user profile as well. I've uninstalled and re-installed to no avail. Its the same one that has been reported earlier.


Any ideas?

[Delphiprogrammi]

Originally Posted by wrestlepower

hi, when i try to manage the warning types, i get the following DB error:

Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT * FROM warning_types ORDER BY warn_points,warn_maturity,warn_name;

MySQL Error : Unknown column 'warn_maturity' in 'order clause'
Error Number : 1054
Date : Saturday, September 23rd 2006 @ 07:25:15 PM
Script : http://www.wrestlepower.net/admincp/...rn.php?do=view
Referrer : http://www.wrestlepower.net/admincp/index.php?do=nav
IP Address : My IP
Username : Duff
Classname : vb_database


EDIT: Just noticed i also get a DB error when i try to update a user profile as well. I've uninstalled and re-installed to no avail. Its the same one that has been reported earlier.


Any ideas?

ALTER TABLE warning_types ADD COLUM warning_maturity INT(5);
ALTER TABLE user ADD COLUMN warns INT(5) DEFAULT '0';

are you uising by any chance PHP 5 ?

[wrestlepower]

nope, 4.4.2 acording to my cpanelx.

Also, dont mean to be rude, but what does that code box actually mean? A lot of the guys asking for help are going to be n00bs like myself, and that means nothing to me. Where do i add the code? do i replace something with that code?

[V3RT1G0]

thx... very nice hack to have!

[Delphiprogrammi]

Originally Posted by wrestlepower

nope, 4.4.2 acording to my cpanelx.

Also, dont mean to be rude, but what does that code box actually mean? A lot of the guys asking for help are going to be n00bs like myself, and that means nothing to me. Where do i add the code? do i replace something with that code?

That's SQL code that would "maually" add the things missing (your error messages)todo this you will need to open phpMyAdmin select te database you use hit the "SQL" link paste the code into the textbox and hit go.After that you should get a message like "your query has been excuted successfully"

[sql]
ALTER TABLE warning_types ADD COLUM warning_maturity INT(5);
ALTER TABLE user ADD COLUMN warns INT(5) DEFAULT '0';
[/sql]

[valuemdsupport]

Hi Delphiprogrammi,

In this new version, the cron jobs are just deactivating warnings? The users will still see that inactive warnings and i have to remove them from admincp completely if i don't want they can see inactive warnings. Is that right? Sorry, this may be a stupid question but i have to know how it works.

Thanks.

[Delphiprogrammi]

Originally Posted by valuemdsupport

Hi Delphiprogrammi,

In this new version, the cron jobs are just deactivating warnings? The users will still see that inactive warnings and i have to remove them from admincp completely if i don't want they can see inactive warnings. Is that right? Sorry, this may be a stupid question but i have to know how it works.

Thanks.

Normal users cannot see inactive warnings and yeah they will still show up in the warning log but only to people who have permissions to view the warning log

[wrestlepower]

Originally Posted by Delphiprogrammi

That's SQL code that would "maually" add the things missing (your error messages)todo this you will need to open phpMyAdmin select te database you use hit the "SQL" link paste the code into the textbox and hit go.After that you should get a message like "your query has been excuted successfully"

[sql]
ALTER TABLE warning_types ADD COLUM warning_maturity INT(5);
ALTER TABLE user ADD COLUMN warns INT(5) DEFAULT '0';
[/sql]

thanks for explaining that. Anyway, ive run the queries and still get the db error when i try to manage the warning types as well as the second db error when i try to update a user. I've posted the error details again so you dont have to look for them.

When i try to manage warning types, i get;

Invalid SQL:
SELECT * FROM warning_types ORDER BY warn_points,warn_maturity,warn_name;

MySQL Error : Unknown column 'warn_maturity' in 'order clause'
Error Number : 1054
Date : Monday, September 25th 2006 @ 05:57:42 PM
Script : http://www.wrestlepower.net/admincp/...rn.php?do=view
Referrer : http://www.wrestlepower.net/admincp/index.php?do=nav
IP Address : My IP
Username : Duff
Classname : vb_database

and when i try to manage a user, i get;
Invalid SQL:


MySQL Error : Unknown column 'alerts' in 'field list'
Error Number : 1054
Date : Monday, September 25th 2006 @ 05:59:17 PM
Script : http://www.wrestlepower.net/admincp/user.php?do=update
Referrer : http://www.wrestlepower.net/admincp/...do=edit&u=1488
IP Address : My IP
Username : Duff
Classname : vb_database



EDIT: Seem to have figured out the first bit about manage warning types. The SQL code you gave said warning_maturity, yet the error i was getting mentioned warn_maturity, so i simply swapped the warning and replaced it with warn, ran the SQL again and it worked. Still stuck with the user changing problems though.

EDIT2: OK, everything seems to be fine now. Again, just swapped the words from the error message i was getting (alerts) with what you had in the SQL (warns) and it all worked out.





OH FFS, i just cant get this right

Getting an error when i go into the warning log.

Invalid SQL:
SELECT w.*,u.username AS wusername,u.userid AS wuserid,wt.*,wuser.username AS warned_username_v,wuser.userid AS warned_userid_v, ruser.username AS removed_by_v, (w.warned_time+wt.warn_maturity*24*60*60) AS maturitydate FROM
warnings w
LEFT JOIN user wuser ON(wuser.userid=w.warned_user)
LEFT JOIN user u ON(u.userid=w.warned_by)
LEFT JOIN user ruser ON(ruser.userid=w.removed_by)
LEFT JOIN warning_types wt ON(wt.tid=w.warned_warning_id) ORDER BY w.warned_time DESC LIMIT 0, 15;

MySQL Error : Unknown column 'w.removed_by' in 'on clause'
Error Number : 1054
Date : Monday, September 25th 2006 @ 06:14:24 PM
Script : http://www.wrestlepower.net/admincp/...hp?do=viewlogs
Referrer : http://www.wrestlepower.net/admincp/index.php?do=nav
IP Address : MY IP
Username : Duff
Classname : vb_database