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)

[jian]

It doesn't work properly.

Whenever I try to change something in the admincp for a user, it gives.

Invalid SQL:
UPDATE vb3_user SET
### Bitfield: vb3_user.options ###
options = IF(options & 8, options - 8, options),
etc etc etc
MySQL Error : Unknown column 'warns' in 'field list'

[Delphiprogrammi]

Originally Posted by jian

It doesn't work properly.

Whenever I try to change something in the admincp for a user, it gives.

Invalid SQL:
UPDATE vb3_user SET
### Bitfield: vb3_user.options ###
options = IF(options & 8, options - 8, options),
etc etc etc
MySQL Error : Unknown column 'warns' in 'field list'

hmmmz your warns field is gone ?

ALTER TABLE vb3_user ADD COLUMN warns INT(5) DEFAULT '0';

[outlaw621]

Originally Posted by Delphiprogrammi

Seems there is indeed a problem.If you login as a normal user (registerd without any special rights) a link should be provided to view your own warnings and this is missing.I just spotted this bug trying to fix it right now

problem found and fixed updating zip file ...

Thank you. Updated and will advise if there are any problems.

[sv1cec]

Hey Delphi, congratulations on this! Nice work!

From what I read, you also added some permission features, good! One thing I changed in my forum site, was that I made the name of the Automatic Warning variable. As you may remember, the old AWS required you to create a warning type called "ObsceneWords", for the automatic warnings. With a few changes, it is now up to the admin to decide how this warning type should be called.

Again, nice work buddy!

[Mirage Guardian]

I did the upgrade & the old warnings sill ok.
But I got this database error:

Database error in vBulletin 3.6.0:
Invalid SQL:
SELECT COUNT(*) AS users FROM user WHERE warns>0 OR alerts>0;
MySQL Error : Unknown column 'warns' in 'where clause'
Error Number : 1054

now what to do?

[Delphiprogrammi]

Originally Posted by Mirage Guardian

I did the upgrade & the old warnings sill ok.
But I got this database error:

now what to do?

you did not reimport the product xml.Wheter you set "allow overwrite to" yes or no my guess is that you didn't touched the products system.Because if you try to add a product that's already there (and allow overwrite is set to no) vbulletin will stop you.....

you need to run

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

and you should be up and running again.That error most likely occources when you click the statistics link (warings per user) in the admincp

[valuemdsupport]

Hi,

Can you please look into my problem. The problem is warnings and alerts aren't correct. When i deleted a warning or an alert, the warnings or the alerts didn't decrease. See the attachment, you'll understand my problem. So, can you please tell me how to fix this by myseft or wait for new updates from you.

Thanks.

[chipet]

PHP Code:

$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
    <title>$vboptions[bbtitle] - $pagetitle</title>
$headinclude
</head>
<body>
$header
$navbar
<BR>
<if condition="$bbuserinfo[userid]=='0'">


<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
    <td class="tcat" colspan="3">Guest - No Permissions</td>
</tr>
<tr>
    <td class="thead">Unable To View</td>
</tr>
<tr>
    <td class="alt1" colspan="1">$vbphrase[aws_nopermissions]</td>
</tr>
</table>
<br/>

<else />


$warn_page
<br />
</if>

$footer
</body>
</html> 


This is the WARN style templet, whats wrong? Because I cant se the warn person text in the threads.
should it look like this in the 3.6.0 version?

[Delphiprogrammi]

Originally Posted by valuemdsupport

Hi,

Can you please look into my problem. The problem is warnings and alerts aren't correct. When i deleted a warning or an alert, the warnings or the alerts didn't decrease. See the attachment, you'll understand my problem. So, can you please tell me how to fix this by myseft or wait for new updates from you.

Thanks.

can i ask ? when you deleted the warnings did you used the checkboxes and click the "complete removal" button or did you did you do it through the confirmation pages all one by one.Seems to be working ok here

[Delphiprogrammi]

Originally Posted by chipet

PHP Code:

$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
    <title>$vboptions[bbtitle] - $pagetitle</title>
$headinclude
</head>
<body>
$header
$navbar
<BR>
<if condition="$bbuserinfo[userid]=='0'">
 
 
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
    <td class="tcat" colspan="3">Guest - No Permissions</td>
</tr>
<tr>
    <td class="thead">Unable To View</td>
</tr>
<tr>
    <td class="alt1" colspan="1">$vbphrase[aws_nopermissions]</td>
</tr>
</table>
<br/>
 
<else />
 
 
$warn_page
<br />
</if>
 
$footer
</body>
</html> 


This is the WARN style templet, whats wrong? Because I cant se the warn person text in the threads.
should it look like this in the 3.6.0 version?

you should only get that error when you are not logged in ... remember to set the proper permissions for each usergroup