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 Triple_T

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

you need a slightly different query for the infraction system

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

*= don't forget table prefixes

[Tayeb]

Dear Delphi,

On permanent banning I got the following error:

Database error in vBulletin 3.5.5:

Invalid SQL:

UPDATE user SET
usergroupid = 4,
displaygroupid = 4,
warnings=2,
warning_bans = 1,
usertitle = 'Permanently Banned'
WHERE userid = 1571;

MySQL Error : Unknown column 'warning_bans' in 'field list' Error Number : 1054
Date : Monday, August 14th 2006 @ 10:07:12 AM
Script : http://myiwc.com/forums/Warn.php
Referrer : http://myiwc.com/forums/Warn.php?do=...571&post=25317
IP Address : xx.xxx.xx.xx
Username : xxx
Classname : vb_database

Can you help please? The other problem got sorted out with your help.

Tayeb

[Delphiprogrammi]

Originally Posted by Tayeb

Dear Delphi,

On permanent banning I got the following error:

Database error in vBulletin 3.5.5:

Invalid SQL:

UPDATE user SET
usergroupid = 4,
displaygroupid = 4,
warnings=2,
warning_bans = 1,
usertitle = 'Permanently Banned'
WHERE userid = 1571;

MySQL Error : Unknown column 'warning_bans' in 'field list' Error Number : 1054
Date : Monday, August 14th 2006 @ 10:07:12 AM
Script : http://myiwc.com/forums/Warn.php
Referrer : http://myiwc.com/forums/Warn.php?do=...571&post=25317
IP Address : xx.xxx.xx.xx
Username : xxx
Classname : vb_database

Can you help please? The other problem got sorted out with your help.

Tayeb

you don't have a warning_bans field in the user table ? try this

DESCRIBE user;

if the warning_bans field is not there

ALTER TABLE user ADD warning_bans INT(2) DEFAULT '0';

*=keep table prefixes in mind or the queries won't work

[UZFRED]

How can I fully uninstall this modification so I'm sure nothing is left in my database?

[Delphiprogrammi]

Originally Posted by UZFRED

How can I fully uninstall this modification so I'm sure nothing is left in my database?

uninstall the product.All associated settings & phrases & templates will be deleted (don't forget to delete the files from your webspace)If you are still able to find database entries that belong to this system then you have a verry old version installed which you have never deleted ?

if you used a version from before 3.5.x (thus before the product system was introduced) and you didin't run the uninstaller before installing the 3.5.x port then that stuff will be still in your databse

[dutchbb]

Originally Posted by Delphiprogrammi

you need a slightly different query for the infraction system

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

*= don't forget table prefixes

Oops! Already done the query that was posted earlyer (ALTER TABLE user ADD warnings INT(5) DEFAULT '0'; ), when i try it again with the query you posted I got

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

#1060 - Duplicate column name 'warnings'

What should I do?
Thank you

[Delphiprogrammi]

Originally Posted by Triple_T

Oops! Already done the query that was posted earlyer (ALTER TABLE user ADD warnings INT(5) DEFAULT '0'; ), when i try it again with the query you posted I got




What should I do?
Thank you

if the warning_bans field is in the user table MySQL should not tell you the field is missing ..

[Delphiprogrammi]

3.6.0 is running on my live board we are getting there ....

[dutchbb]

Originally Posted by Delphiprogrammi

if the warnings field is in the user table MySQL should not tell you the field is missing ..

I know... the warning field is there, but I used a slightly different query to make it. See my posts. Is that a problem?

[Delphiprogrammi]

Originally Posted by Triple_T

I know... the warning field is there, but I used a slightly different query to make it. See my posts. Is that a problem?

yes that can cause database errors run this

ALTER TABLE user DROP warning_bans;
ALTER TABLE user ADD COLUMN warning_bans INT(2) DEFAULT '0';

now i would test it.Define a warningtype that would cause a ban when it get's issued and see what happends