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]

Hey Delphi, since the Premium Modification Forum of AWS is not used any more, what you think if we ask the moderators to purge that forum from all previous messages and start using that forum for support of AWS 3.5 and 3.6?

Let me know.

[Delphiprogrammi]

Originally Posted by sv1cec

Hey Delphi, since the Premium Modification Forum of AWS is not used any more, what you think if we ask the moderators to purge that forum from all previous messages and start using that forum for support of AWS 3.5 and 3.6?

Let me know.

I see some questions are being asked about this system in the premium forum while support for the 3.5.x port is being provided here in this thread.So yes that will be a good idea if a mod wants todo that

[sv1cec]

I've already PMed a moderator and asked if it is possible to delete all previous threads from there. If not, we can just post an announcement here, that this hack will be supported in the Premium forum and work like that.

[RMS-Chef]

Originally Posted by Delphiprogrammi

that's normal since both systems use a database field called "warnings" and when you uninstall aws that field will be deleted ...... run

ALTER TABLE user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0';

keep TABLE_PREFIX in mind.....

this error will be gone now

So I should be OK if I uninstall this before the upgrade to v3.6?
This uninstall should drop the table but running the upgrade script should recreate it, yes?

I do love this hack but I would like to keep my board as default as possible. Perhaps if the infractions system does not work out for me and this becomes stable on v3.6 I would install it again but for the initial upgrade I plan to drop it.

[Delphiprogrammi]

Originally Posted by RMS-Chef

So I should be OK if I uninstall this before the upgrade to v3.6?
This uninstall should drop the table but running the upgrade script should recreate it, yes?

I do love this hack but I would like to keep my board as default as possible. Perhaps if the infractions system does not work out for me and this becomes stable on v3.6 I would install it again but for the initial upgrade I plan to drop it.

if you plan to upgrade to 3.6 uninstall aws.The "thing" with the database fields is fixed by now i'm just having a verry strange problem where the warning counter isn't updating itself sow i can't release a system that doesn't work properly he.For now uninstall it and you won't have a problem with that warnings database field

[Tayeb]

Hello,

In Admin CP Statistics Warning per User I am getting the following error:

Database error in vBulletin 3.5.5:

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 : Thursday, August 10th 2006 @ 10:47:21 PM
Script : http://mysite/admin/admin_warn.php?d...&type=warnings
Referrer : http://mysite/admin/index.php?do=nav
IP Address : xxx xxxx ssss
Username : xxxxxx
Classname : vb_database

Any idea? I have just installed the warning system.

I'll appreciate any help.

Tayeb

[Delphiprogrammi]

Originally Posted by Tayeb

Hello,

In Admin CP Statistics Warning per User I am getting the following error:

Database error in vBulletin 3.5.5:

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 : Thursday, August 10th 2006 @ 10:47:21 PM
Script : http://mysite/admin/admin_warn.php?d...&type=warnings
Referrer : http://mysite/admin/index.php?do=nav
IP Address : xxx xxxx ssss
Username : xxxxxx
Classname : vb_database

Any idea? I have just installed the warning system.

I'll appreciate any help.

Tayeb

you do not have a warnings field in your user table

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

keep tableprefixes in mind ...

[Delphiprogrammi]

hi people,

Just to keep users informed here are 5 screengrabs where this system runs on 3.6.0(gold)

[dutchbb]

Ok, I uninstalled this product after the upgrade to vbulletin 3.6, now the uninstaller has removed tables from the new infractions system!

Ii think it's the table 'warnings' but I'm not sure what else got removed or changed :s Is there a way to restore this, do a re-upgrade to 3.6 to rebuild the tables or something?

[dutchbb]

I'm sorry the answer was already posted above my post, please ignore it.