Advanced Warning System (Beta Version)

Advanced Warning System


IF YOU ARE RUNNING vB 3.6, THERE IS A NEW THREAD FOR THIS HACK UNDER THAT VERSION. vB 3.6 USERS GO HERE:

https://vborg.vbsupport.ru/showthread.php?t=124477


This is a direct port of the Advanced Warning System, as it was implemented in vB 3.0.x. This port has all the features of AWS version 3.4.16, except the Notes.

For a complete description of AWS capabilities, please refer to the following thread:

https://vborg.vbsupport.ru/showthread.php?p=574374

The vB 3.5 compliant version of AWS includes:

1 Product XML (17 Plugins, 107 Phrases, 26 Templates, 43 Settings)
1 ACP Navigation XML
1 PHP Functions File
3 Images
2 PHP Frontend Files
1 PHP Admin CP File
1 PHP Mod CP File
3 PHP Cronjob Files

This port would not be possible, without the help of KirbyDE, to whom I am greatful. KirbyDE will also be responsible for supporting you here, with questions related to this particular release. Also, this port would not have been possible, without the help of Juan P hernandez, who offered me a free test system, in which the porting was performed.

The hack has been tested and it is believed to be bug-free, however since this is a major hack, I release it today (September 9th 2005) as beta.

I hope you all enjoy it.

History (Productversion)
3.5.b
Initial Version

3.5.b1
Fixed a typo that caused Errors in User Datamanager.
Fixed a wrong object reference in functions_warning.php

3.5.b2
Fixed a Bug that caused PHP Error Messages.
Fixed a Typo in the Install Code that causes mySQL Errors.
Updated the Template Edit instructions to be (hopefully) compatible with RC3

3.5.b3
Fixed User not showing up in automatic warning PMs
Fixed 2 missing Phrases
Fixed Hidden Warner being Used for Automatic Warnings
Fixed "View x's Warnings" Button in Usermanager not working

3.5.b4
Removed one unsued Phrase, added one missing Phrase
Fixed a Typo that caused PHP Errors when sending PMs
Fixed a Typo that caused PHP Errors upon Installation
Changed Product ID for Admin CP Navigation XML from vbulletin to aws, so it won't show up any longer if AWS is uninstalled/disabled.

A bug was found which didn't allow you to delete an entered Warning Type. Bug fixed in the current distribution file.

If you found a Bug, please report it at http://bugs.kirbydemos.ath.cx

This helps to keep issues organized, which can't be guaranteed if it's only posted in the Thread.
Thank you.

P.S.1: After you install the hack per the instructions, please update your installation with the separate files listed. They are newer files not included in the zip.

P.S.2: If you want to use the Notes feature, as it existed in AWS 3.4.16, please install AWS per the instructions in the zip file, and THEN follow the instructions included in the warn_notes_update_instructions.txt.

IMPORTANT NOTE: Please keep in mind that this hack is not supported. What this means is that I have no obligation to support it. The reason for that, is because I have no access to a vB 3.5 system any more, so I can't work on this hack any more. Andreas (or KirbyDE) who undertook the support of this version of the AWS hack in the beginning, is obviously too busy to support it. So you are on your own, at least as far as the interaction with vB is concerned. If you have an issue with the hack files themselves, I'll do my best to solve it, but without a test environment, it is not easy. So users of vB 3.5 beware!

P.S. May 31st 2006: The zip file uploaded today, should contain all the debugging done by Delphi, so it should be fine as it is. You do not need the other files listed at the right, only the zip. Download it and follow the instructions in it, for installing the hack. I leave the other files there, just in case some one needs them, they will be deleted later.

SV1CEC

[Delphiprogrammi]

Originally Posted by sv1cec

Do you have a table pmtext_warned in your database?

Hi John how are you ? still a coffee addict ? anyway i had to manually add that table vb3_pmtext_warned now it works fine

CREATE TABLE vb3_pmtext_warned (
`pmtextid` int(10) unsigned NOT NULL auto_increment, 
`fromuserid` int(10) unsigned not null,
`fromusername` varchar(50),
`title` varchar(250),
`before_title` varchar(250),
`message` mediumtext,
`before_message` mediumtext, 
`touserarray` mediumtext, 
`dateline` int(10) unsigned,
 PRIMARY KEY  (`pmtextid`), key (`fromuserid`)
) TYPE=MyISAM;

[Andreas]

@Delphiprogrammi
There was a slight Typo in the Product Install Code that caused Table pmtext_warned not to be created upon Installation.
But that should be fixed since 1.0.2

[aethro]

Howdy just tried installing it worked like a charm and making new posts works fine however when i go to reply to a post i get this error

Fatal error: Call to a member function on a non-object in /usr/home/**/**/**/includes/class_dm.php(474) : runtime-created function on line 1

Followed the instructions but still dont understand how this error popped up. Any thoughts on this greately appreciated

[Andreas]

I guess you do not run RC3, right?

[aethro]

Oh yeah duh lol i'll go upgrade Thanks for pointing that out

[Chris_D]

Been looking forward to this coming out for 3.5

I liked Zero Tolerance's warning hack. Very well made and lots of nice features, but unfortunately I like this because it gives you the chance to have pre-defined warnings where Zero's all seemed to be free-entry. This is much better for a bigger board.

[eNforce]

I get this error after sending a PM, but the pm does go through.

Parse error: parse error, unexpected '[' in /home/areyous/public_html/includes/class_dm_pm.php(523) : eval()'d code on line 96

I saw someone else had this problem, I skimmed through the posts but didn't see a fix myself. Was a fix posted?

[Andreas]

Plugin: AWS: Check PM-Title/Message for censored Words

Find

PHP Code:

if ($this->info['reparent'] AND $this-info['savecopy']) 


Replace

PHP Code:

if ($this->info['reparent'] AND $this->info['savecopy']) 


[wcbryant]

Just upgraded from RC2 to RC3 this morning, and installed AWS shortly thereafter. Everything seemed to go smoothly, and I've set the new options, but I'm getting some errors;

When warning a dummy account;

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
update user set warning_level='10', warnings='1' where userid='5264';

MySQL Error  : Unknown column 'warnings' in 'field list'
Error Number : 1054
Date         : Tuesday, September 13th 2005 @ 05:42:18 AM
Script       : http://www.sitename.com/forum/Warn.php
Referrer     : http://www.sitename.com/forum/Warn.php?do=WarnUser&id=5264&post=261259
IP Address   : xx.xx.xx.xx
Username     : Clarity
Classname    : vB_Database_MySQLi

When hitting (in admincp) Statistics - Warnings Per User;

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT COUNT(*) AS users FROM user AS user where warnings>0 OR alerts>0;

MySQL Error  : Unknown column 'warnings' in 'where clause'
Error Number : 1054
Date         : Tuesday, September 13th 2005 @ 05:54:06 AM
Script       : http://www.sitename.com/forum/admincp/admin_warn.php?act=viewwarnedusers&type=warnings
Referrer     : http://www.sitename.com/forum/admincp/index.php?do=nav
IP Address   : xx.xx.xx.xx
Username     : Clarity
Classname    : vB_Database_MySQLi

Sounds like I'm missing a column, but not sure how or why. Any ideas? Been poking around for about an hour, not sure where the issue is. I did have the 3.0.x version installed before moving up to 3.5.0, perhaps when it discovered the old tables, it didn't create some new one somehow? No idea.

[Andreas]

If you had the 3.0 Version installed, you should already have the Columns.

Anyway:

ALTER TABLE user ADD warnings INT(5) DEFAULT '0';
ALTER TABLE user ADD warning_level INT(15) DEFAULT '0';
ALTER TABLE user ADD warning_bans INT(2) DEFAULT '0';
ALTER TABLE user ADD alerts INT(5) DEFAULT '0';
ALTER TABLE user ADD warn_notes SMALLINT DEFAULT '0';

Currently these Colums are being added in 1 Query, so if 1 Column does already exist (but other's don't) it fails completely.
Might be a good idea to change that