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

[sv1cec]

Delphi, check this out https://vborg.vbsupport.ru/showpost....&postcount=740

[Delphiprogrammi]

Originally Posted by sv1cec

Delphi, check this out https://vborg.vbsupport.ru/showpost....&postcount=740

yeah i did that automatic warning work fine from private messages but they refuse to work from post / threads i already did that step described there.I even disabled all other products i have installed to sensure it isn't conflicting nope it's insane

[Borisch]

Hey,

I've been trying to get this one working all night but to no avail. All the files have been uploaded correctly and the templates have been changed accordingly. The problem is when installing the xml file. It seems as though none of the tables are created. At first I figured that it might be so that it stops on some SQL (ie a table already exists) and doesn't resume. However, this happens even if I make sure that there are no offending tables and columns in the database.

So I tried creating the tables and columns manually by simply executing the sql that the installation is supposed to take care of. However, this doesn't help since I still can't warn anyone. I get errors that the column doesn't exist.

Here is an excerpt of errors I get:

This is what I get when trying to warn someone:

Database error in vBulletin 3.5.3:
 
Invalid SQL:
update user set warning_level='4', warnings='1' where userid='111';
 
MySQL Error  : Unknown column 'warnings' in 'field list'

This is what I get when trying to view some statistics in the control panel:

Database error in vBulletin 3.5.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'

And so on and so forth. Now, some things works. I can add different warning types and change options and such. But I have no idea where this values are saved. If I create a warning type, it's not saved in the warning_types table as it is completely empty at all times. Even searching for the warning type in the database turns up empty. It's very strange and I have no idea what might be causing this. Has anyone else experienced these kinds of issues and been able to solve them somehow?

As can be seen from the error messages, I'm running vB 3.5.3. I'm also using the latest files posted in this thread.

[sv1cec]

Delphi,

Try using this plugin instead of the standard "AWS: Check Post-Title/Message for censored Words" one. Also, try using this functions_warning.php file, I do not remember if I've done any changes to it.

[sv1cec]

Are you using a table prefix, by any chance?

[Borisch]

Where do I check that?

EDIT: Nevermind, in config.php obviously. It's empty, so no, I', not using a table prefix.

What's really baking my noodle is why isn't the installer creating the proper tables? Is there some log which I can check for errors?

[Delphiprogrammi]

Originally Posted by Borisch

Where do I check that?

EDIT: Nevermind, in config.php obviously. It's empty, so no, I', not using a table prefix.

What's really baking my noodle is why isn't the installer creating the proper tables? Is there some log which I can check for errors?

you could try and open product-aws.xml and just before the SQL queries put this code

PHP Code:

$db->reporterror=1 


that should show you all errors occuerd when tryting to import the product.Do the same in the unistall code.When you get an error message from MySQL post it here .....

[Delphiprogrammi]

Originally Posted by sv1cec

Delphi,

Try using this plugin instead of the standard "AWS: Check Post-Title/Message for censored Words" one. Also, try using this functions_warning.php file, I do not remember if I've done any changes to it.

thank you John but it still refuses to work it's insane not your fault and not that big problem either.I think it has something todo with vbportal just guessing here but it worked fine before i purchased and installed vbportal

[Borisch]

Originally Posted by Delphiprogrammi

When you get an error message from MySQL post it here .....

Thanks for putting effort into helping me. However, I'm sad to admit that I don't get any error messages. At least not immediat errors. Are these errors supposed to show while your installing or in some log? The installation just looks as previously, ie. as it's supposed to look I presume.

[GoTTi]

question: this is upgradeable from 3.0.x correct?

if yes, whats the details on that for upgrading.

if no, what should i do about the current version of aws on my 308?