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

[GoTTi]

great news delphi. lemme ask u, i have te AWS from 3.0x world installed still im sure in the DB. do i need to do anything special to make sure it is completely out of my system so i dont have problems with this? is there a uninstall older version or upgrade tool wth this? lemme know thanks.

[dai-kun]

Originally Posted by Delphiprogrammi

hi people,

Here it is.The system that uses phrases.To install import product-aws.xml(set overwrite to yes).Do the template edits (and other stuff) explained in readme.txt after that it should be ready to use

u forgot the product file in the new zip?

[Gooses]

Wait, so this works with vB 3.5.4?

[Delphiprogrammi]

Originally Posted by dai-kun

u forgot the product file in the new zip?

no includes/xml/ ...

[Delphiprogrammi]

Originally Posted by Gooses

Wait, so this works with vB 3.5.4?

yes it does

[dai-kun]

I have trouble running kill_alerts cron
Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE vb3_user SER alerts='0' WHERE userid='39752';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'alerts='0' WHERE userid='39752'' at line 1
Error Number : 1064
Date : Wednesday, May 17th 2006 @ 04:12:29 PM
Script : http://domain.com/forum/admincp/cron...cron&cronid=40

I think

	$vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."user SER alerts='{$alerts}' WHERE userid='{$warn['userid']}'");

should be:

	$vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."user SET alerts='{$alerts}' WHERE userid='{$warn['userid']}'");

Also.. for some reason, when the warnings expire, they do not show up anymore in the view warnings, but i can still see a "Warnings: 1" in their postbit. This been happening for a really long time and I just never brought it up :/

[Delphiprogrammi]

Originally Posted by dai-kun

I have trouble running kill_alerts cron
Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE vb3_user SER alerts='0' WHERE userid='39752';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'alerts='0' WHERE userid='39752'' at line 1
Error Number : 1064
Date : Wednesday, May 17th 2006 @ 04:12:29 PM
Script : http://domain.com/forum/admincp/cron...cron&cronid=40

I think

    $vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."user SER alerts='{$alerts}' WHERE userid='{$warn['userid']}'");

should be:

    $vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."user SET alerts='{$alerts}' WHERE userid='{$warn['userid']}'");

Also.. for some reason, when the warnings expire, they do not show up anymore in the view warnings, but i can still see a "Warnings: 1" in their postbit. This been happening for a really long time and I just never brought it up :/

1)you are right about the MySQL query that's a typo.I have updated the zip package

2)i think that problem is caused by the username cache vbulletin uses the system isn't yet implemented to use that.I have no experience with it so kinda scared i mess up hehe

[sv1cec]

Delphi,

I have entered your name in the supporters/co-authors. So you should be able to update the distribution files. If not, please contact the administrators, you can edit the hack with my blessings!

Rgds

[Marco van Herwaarden]

Originally Posted by Delphiprogrammi

hi people,

Here it is.The system that uses phrases.To install import product-aws.xml(set overwrite to yes).Do the template edits (and other stuff) explained in readme.txt after that it should be ready to use

zip file updated to include a fix for a typo in a MySQL query

Hi Delphiprogrammi,

Thank you very much for creating a new zip-file.

I have a few questions/remarks in your latest zip file:
- The updated files that are included in the thread start, are they still needed with your zip?
- The product file will with most installations never be uploaded to the forum directories. In the zip it is however located in includes/xml. Better move it outside of the upload directory.
- Readme is also most convenient if not between the files to upload, but on a higher level directory
- The includes/xml directory contain 2 files that i suppose shouldn't be there: vbulletin-adminhelp.xml & vbulletin-language.xml
- Is it correct that Warn.php start with an uppercase W?


If you are going to add your zip-file to the first post and have problems with that, sent me a PM please.

[Delphiprogrammi]

Originally Posted by MarcoH64

Hi Delphiprogrammi,

Thank you very much for creating a new zip-file.

I have a few questions/remarks in your latest zip file:
- The updated files that are included in the thread start, are they still needed with your zip?
- The product file will with most installations never be uploaded to the forum directories. In the zip it is however located in includes/xml. Better move it outside of the upload directory.
- Readme is also most convenient if not between the files to upload, but on a higher level directory
- The includes/xml directory contain 2 files that i suppose shouldn't be there: vbulletin-adminhelp.xml & vbulletin-language.xml
- Is it correct that Warn.php start with an uppercase W?


If you are going to add your zip-file to the first post and have problems with that, sent me a PM please.

1)No all the files the system uses have changed.Also the update instructions for the warn_notes features are already included in the product
2)i moved readme.txt to a directory called "docs"
3)i removed those files from /includes/xml they indeed shouldn't be there.I also moved the product file outside of the upload directory
4)that file always started with an uppercase "W" (i'll look into changing that )
5)I already sended a pm to Xenon about being unable to edit the hack settings.I did before you posted in this thread.Let's wait and see what he got to say.Maybe it is because the system that handles that things is being changed ?