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 wcbryant

I recently uninstalled this add-on through the product manager, as I've been having some slow load issues, and I've been going out of my way to cut down on the number of hacks I use. After doing so, when admins try to create new user accounts through admincp, they're getting this error;

Database error in vBulletin 3.6.4:
 
Invalid SQL:
UPDATE user SET
    ### Bitfield: user.options ###
        options = IF(options & 8, options - 8, options),
        options = IF(options & 1024, options, options + 1024),
        options = IF(options & 16, options, options + 16),
        options = IF(options & 256, options - 256, options),
        options = IF(options & 512, options - 512, options),
        options = IF(options & 32, options - 32, options),
        options = IF(options & 2048, options, options + 2048),
        options = IF(options & 131072, options - 131072, options),
        options = IF(options & 4096, options - 4096, options),
        options = IF(options & 1, options, options + 1),
        options = IF(options & 2, options, options + 2),
        options = IF(options & 4, options, options + 4),
        options = IF(options & 64, options, options + 64),
        options = IF(options & 128, options - 128, options),
        options = IF(options & 32768, options - 32768, options),
    ### Bitfield: user.adminoptions ###
        adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
        adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
    usertitle = 'Newbie',
    customtitle = 0,
    username = '*',
    email = '*@yahoo.com',
    languageid = 0,
    homepage = '',
    birthday_search = '',
    birthday = '',
    showbirthday = 2,
    icq = '',
    aim = '',
    yahoo = '',
    msn = '',
    skype = '',
    parentemail = '',
    referrerid = 0,
    ipaddress = '164.62.*.*',
    posts = 6,
    vbookie_cash = 500,
    usergroupid = 2,
    membergroupids = '22',
    reputationlevelid = 2,
    reputation = -750,
    warnings = 0,
    infractions = 0,
    ipoints = 0,
    pmpopup = 1,
    autosubscribe = -1,
    threadedmode = 0,
    showvbcode = 2,
    styleid = 0,
    timezoneoffset = '-5',
    daysprune = -1,
    joindate = 1102184940,
    lastactivity = 1165522680,
    lastpost = 1165522140,
    vbp_receivespoints = 1,
    vbp_storeaccess = 1,
    vbbux = 993.911,
    vbbank = 0,
    vbp_nextbankinterest = 0,
    vbp_genericperm = 0,
    vbp_modperm = 0,
    vbp_adminperm = 0,
    vbp_nametextcolor = '',
    vbp_nameglowcolor = '',
    vbp_nameshadowcolor = '',
    vbp_namefonttype = '',
    vbp_titletextcolor = '',
    vbp_titleglowcolor = '',
    vbp_titleshadowcolor = '',
    vbp_titlefonttype = '',
    vbp_changealwaysitems = '',
    ### Bitfield: user.vbp_displayflags ###
        vbp_displayflags = IF(vbp_displayflags & 1, vbp_displayflags - 1, vbp_displayflags),
        vbp_displayflags = IF(vbp_displayflags & 2, vbp_displayflags - 2, vbp_displayflags),
        vbp_displayflags = IF(vbp_displayflags & 4, vbp_displayflags - 4, vbp_displayflags),
        vbp_displayflags = IF(vbp_displayflags & 8, vbp_displayflags - 8, vbp_displayflags),
        vbp_displayflags = IF(vbp_displayflags & 16, vbp_displayflags - 16, vbp_displayflags),
        vbp_displayflags = IF(vbp_displayflags & 32, vbp_displayflags - 32, vbp_displayflags),
        vbp_displayflags = IF(vbp_displayflags & 64, vbp_displayflags - 64, vbp_displayflags),
        vbp_displayflags = IF(vbp_displayflags & 128, vbp_displayflags - 128, vbp_displayflags),
    ### Bitfield: user.vbp_otherflags ###
        vbp_otherflags = IF(vbp_otherflags & 1, vbp_otherflags - 1, vbp_otherflags),
        vbp_otherflags = IF(vbp_otherflags & 2, vbp_otherflags - 2, vbp_otherflags),
        vbp_otherflags = IF(vbp_otherflags & 4, vbp_otherflags - 4, vbp_otherflags),
        vbp_otherflags = IF(vbp_otherflags & 8, vbp_otherflags - 8, vbp_otherflags),
        vbp_otherflags = IF(vbp_otherflags & 16, vbp_otherflags - 16, vbp_otherflags),
        vbp_otherflags = IF(vbp_otherflags & 32, vbp_otherflags - 32, vbp_otherflags),
        vbp_otherflags = IF(vbp_otherflags & 64, vbp_otherflags - 64, vbp_otherflags),
        vbp_otherflags = IF(vbp_otherflags & 256, vbp_otherflags - 256, vbp_otherflags),
    ### Bitfield: user.vbp_immunity ###
        vbp_immunity = IF(vbp_immunity & 1, vbp_immunity - 1, vbp_immunity),
        vbp_immunity = IF(vbp_immunity & 2, vbp_immunity - 2, vbp_immunity),
        vbp_immunity = IF(vbp_immunity & 4, vbp_immunity - 4, vbp_immunity),
        vbp_immunity = IF(vbp_immunity & 8, vbp_immunity - 8, vbp_immunity),
        vbp_immunity = IF(vbp_immunity & 16, vbp_immunity - 16, vbp_immunity),
        vbp_immunity = IF(vbp_immunity & 32, vbp_immunity - 32, vbp_immunity),
        vbp_immunity = IF(vbp_immunity & 64, vbp_immunity - 64, vbp_immunity),
    displaygroupid = '2'
WHERE userid = 1719;
 
MySQL Error  : Unknown column 'warnings' in 'field list'
Error Number : 1054
Date         : Thursday, December 7th 2006 @ 01:18:30 PM
Script       : http://www.buckeyeplanet.com/forum/admincp/user.php?do=update
Referrer     : http://www.buckeyeplanet.com/forum/admincp/user.php?do=edit&u=1719
IP Address   : 165.166.*.*
Username     : (admin-name)
Classname    : vB_Database_MySQLi

I've read through the archive I used to download, and tried to page through these 75 pages as best I can looking for a clear cut solution, but if one exists, I've over looked it.

Is this as easy as running a couple queries to complete the uninstall, and if so, where might I find those (I have no real comfort level with mysql myself), either way, will any change I make interfere with vB's built in warning system?

Thanks in advance for any help. I probably should have just left AWS disabled instead of flat uninstalling it, but like I said, trying to slim down.

the warnings field belongs the vbulletin infractions system.Hoever if you used the system on a 3.5.x (any release) then this would cause that field to be deleted when you uninstalled this hack.This problem can be solved by

[SQL]
ALTER TABLE user ADD COLUMN warnings INT UNSIGNED NOT NULL DEFAULT '0';
[/SQL]

Your problem is most likely caused by running vb 3.5.x then you upgraded to 3.6 and you uninstalled the 3.5.x version of this hack which would delete the warnings field.Run the query and that error should be gone

[wcbryant]

Thanks so much, Delphi, that did the trick. Felt silly asking, and figured it would be something simple like that, but didn't want to make anything worse.

[tank14]

In the advanced warning system, I get an error, when I try to add a number here...Warnings Number LimitMembers are also banned when they accumulate this number of warnings....I would much rather use this, but when I change it, it goes completely BLANK...LOL Please help I love this hack system =P

[tank14]

I noticed something else, I dont even get a little question mark on it.

[tank14]

I also have this???

Database error in vBulletin 3.6.4:

Invalid SQL:
UPDATE user SET warning_level='10', warnings='1' WHERE userid='2';

MySQL Error : Unknown column 'warning_level' in 'field list'
Error Number : 1054
Date : Sunday, December 31st 2006 @ 04:53:29 PM
Script : http://xboxcrave.com/vb/Warn.php
Referrer : http://xboxcrave.com/vb/Warn.php?do=...r&id=2&post=18
IP Address : 69.243.173.129
Username : Jagged X sL4Sh
Classname : vb_database

[tank14]

Sorry, I went to vb 3.6.x for the version I need..Thanks!

[kofoid]

None of the template edits work when I import the product. I have tried 3 times now, both overwrite and fresh install. Any ideas??

[Delphiprogrammi]

Originally Posted by kofoid

None of the template edits work when I import the product. I have tried 3 times now, both overwrite and fresh install. Any ideas??

that's normal.You need to edit each template seperatly.We are not allowed to distrubute anything that's part of vbulletin.So you need to goto your style manager and edit this vBulletin templates

• postbit & postbit_legacy
• MEMBERINFO
• memberinfo_resultbits
• navbar
• pm_newpm

if you do not understand howto do this give me a yell and i will explain in detail