The Arcive of Official vBulletin Modifications Site.

Advanced Warning System (Beta Version) · **Released**: 09-08-2005

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 · #**1072** 08-05-2006, 07:28 AM

hi people,

If you use this system availible right now on a vbulletin 3.6.x system (whatever version) the "view banned users" in the aws menu will not work

reason = jelsoft changed the isbannedgroup permission to isnotbannedgroup

I fixed this already...

Delphiprogrammi · #**1073** 08-05-2006, 07:37 AM

Quote:

Originally Posted by sv1cec

Well, if vB is using one of AWS columns, you'd better create new ones. You never know if a user will activate both the AWS and vB's infractions together.

Allright that will mean new fields because the infractions system cannot be disabled.You can only take away permissions to give or view them.Jelsoft stole our field lol

MajorFm.com · #**1074** 08-05-2006, 10:17 AM

Ok small problem, just installed, i had the previous version already installed on my previous version of vb, so i want to keep all existing warn data, so i assume i don't delete existing tables etc...

I got this error when importing the product:

Code:

Database error in vBulletin 3.5.4:

Invalid SQL:

				INSERT INTO setting
				(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
				VALUES
				(
					'warn_hierarchical',
					'warning',
					'1',
					'1',
					'free',
					'yesno',
					2,
					0,
					1,
					'aws'
	),
	(
					'warn_automatic',
					'warning',
					'0',
					'1',
					'free',
					'yesno',
					3,
					0,
					1,
					'aws'
	),
	(
					'warn_automaticpm',
					'warning',
					'0',
					'0',
					'free',
					'yesno',
					4,
					0,
					1,
					'aws'
	),
	(
					'warn_autocomments',
					'warning',
					'0',
					'0',
					'free',
					'yesno',
					5,
					0,
					1,
					'aws'
	),
	(
					'warn_automatic_warner',
					'warning',
					'11223',
					'1',
					'free',
					'',
					6,
					0,
					1,
					'aws'
	),
	(
					'warn_warner',
					'warning',
					'0',
					'0',
					'free',
					'',
					7,
					0,
					1,
					'aws'
	),
	(
					'warn_collector',
					'warning',
					'1',
					'1',
					'free',
					'',
					8,
					0,
					1,
					'aws'
	),
	(
					'warn_banned_limit',
					'warning',
					'7',
					'7',
					'free',
					'',
					9,
					0,
					1,
					'aws'
	),
	(
					'warn_points_before_banned',
					'warning',
					'90',
					'10',
					'free',
					'',
					10,
					0,
					1,
					'aws'
	),
	(
					'warn_warnings_before_banned',
					'warning',
					'3',
					'10',
					'free',
					'',
					11,
					0,
					1,
					'aws'
	),
	(
					'warn_banned_usergroup_id',
					'warning',
					'8',
					'8',
					'free',
					'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">(COPPA) Users Awaiting Moderation(id4)</option>\r\n<option value=\\\"6\\\" \" . iif($setting[\'value\']==\'6\',\'selected=\"selected\"\') . \">Administrators(id6)</option>\r\n<option value=\\\"7\\\" \" . iif($setting[\'value\']==\'7\',\'selected=\"selected\"\') . \">Moderators(id7)</option>\r\n<option value=\\\"2\\\" \" . iif($setting[\'value\']==\'2\',\'selected=\"selected\"\') . \">Registered Users(id2)</option>\r\n<option value=\\\"5\\\" \" . iif($setting[\'value\']==\'5\',\'selected=\"selected\"\') . \">Super Moderators(id5)</option>\r\n<option value=\\\"1\\\" \" . iif($setting[\'value\']==\'1\',\'selected=\"selected\"\') . \">Unregistered / Not Logged In(id1)</option>\r\n<option value=\\\"4\\\" \" . iif($setting[\'value\']==\'4\',\'selected=\"selected\"\') . \">Users Awaiting Email Confirmation(id3)</option>\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">Banned Users(id8)</option>\r\n<option value=\\\"9\\\" \" . iif($setting[\'value\']==\'9\',\'selected=\"selected\"\') . \">Permanent_Ban(id9)</option>\r\n</select>',
					12,
					0,
					1,
					'aws'
	),
	(
					'warn_protected_usergroups',
					'warning',
					'6',
					'',
					'free',
					'',
					13,
					0,
					1,
					'aws'
	),
	(
					'warn_troll_usergroup_id',
					'warning',
					'8',
					'9',
					'free',
					'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">(COPPA) Users Awaiting Moderation(id4)</option>\r\n<option value=\\\"6\\\" \" . iif($setting[\'value\']==\'6\',\'selected=\"selected\"\') . \">Administrators(id6)</option>\r\n<option value=\\\"7\\\" \" . iif($setting[\'value\']==\'7\',\'selected=\"selected\"\') . \">Moderators(id7)</option>\r\n<option value=\\\"2\\\" \" . iif($setting[\'value\']==\'2\',\'selected=\"selected\"\') . \">Registered Users(id2)</option>\r\n<option value=\\\"5\\\" \" . iif($setting[\'value\']==\'5\',\'selected=\"selected\"\') . \">Super Moderators(id5)</option>\r\n<option value=\\\"1\\\" \" . iif($setting[\'value\']==\'1\',\'selected=\"selected\"\') . \">Unregistered / Not Logged In(id1)</option>\r\n<option value=\\\"4\\\" \" . iif($setting[\'value\']==\'4\',\'selected=\"selected\"\') . \">Users Awaiting Email Confirmation(id3)</option>\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">Banned Users(id8)</option>\r\n<option value=\\\"9\\\" \" . iif($setting[\'value\']==\'9\',\'selected=\"selected\"\') . \">Permanent_Ban(id9)</option>\r\n</select>',
					14,
					0,
					1,
					'aws'
	),
	(
					'warn_restore_groupid',
					'warning',
					'0',
					'2',
					'free',
					'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">(COPPA) Users Awaiting Moderation(id4)</option>\r\n<option value=\\\"6\\\" \" . iif($setting[\'value\']==\'6\',\'selected=\"selected\"\') . \">Administrators(id6)</option>\r\n<option value=\\\"7\\\" \" . iif($setting[\'value\']==\'7\',\'selected=\"selected\"\') . \">Moderators(id7)</option>\r\n<option value=\\\"2\\\" \" . iif($setting[\'value\']==\'2\',\'selected=\"selected\"\') . \">Registered Users(id2)</option>\r\n<option value=\\\"5\\\" \" . iif($setting[\'value\']==\'5\',\'selected=\"selected\"\') . \">Super Moderators(id5)</option>\r\n<option value=\\\"1\\\" \" . iif($setting[\'value\']==\'1\',\'selected=\"selected\"\') . \">Unregistered / Not Logged In(id1)</option>\r\n<option value=\\\"4\\\" \" . iif($setting[\'value\']==\'4\',\'selected=\"selected\"\') . \">Users Awaiting Email Confirmation(id3)</option>\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">Banned Users(id8)</option>\r\n<option value=\\\"9\\\" \" . iif($setting[\'value\']==\'9\',\'selected=\"selected\"\') . \">Permanent_Ban(id9)</option>\r\n</select>',
					15,
					0,
					1,
					'aws'
	),
	(
					'warn_incr_ban_days',
					'warning',
					'1',
					'1',
					'free',
					'yesno',
					16,
					0,
					1,
					'aws'
	),
	(
					'warn_max_no_bans',
					'warning',
					'3',
					'3',
					'free',
					'',
					17,
					0,
					1,
					'aws'
	),
	(
					'warn_bans_mature',
					'warning',
					'0',
					'0',
					'free',
					'',
					18,
					0,
					1,
					'aws'
	),
	(
					'warn_viewoption',
					'warning',
					'Mgm',
					'Mgm',
					'free',
					'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"All\\\" \" . iif($setting[\'value\']==\'All\',\'selected=\"selected\"\') . \">All</option>\r\n<option value=\\\"Mgm\\\" \" . iif($setting[\'value\']==\'Mgm\',\'selected=\"selected\"\') . \">Mgm</option>\r\n</select>',
					19,
					0,
					1,
					'aws'
	),
	(
					'warn_multiple_per_post',
					'warning',
					'0',
					'1',
					'free',
					'yesno',
					20,
					0,
					1,
					'aws'
	),
	(
					'warn_send_em_warning',
					'warning',
					'1',
					'1',
					'free',
					'yesno',
					21,
					0,
					1,
					'aws'
	),
	(
					'warn_send_pm_warning',
					'warning',
					'1',
					'0',
					'free',
					'yesno',
					22,
					0,
					1,
					'aws'
	),
	(
					'warn_email_on_ban',
					'warning',
					'1',
					'1',
					'free',
					'yesno',
					23,
					0,
					1,
					'aws'
	),
	(
					'warn_historical',
					'warning',
					'1',
					'1',
					'free',
					'yesno',
					24,
					0,
					1,
					'aws'
	),
	(
					'warn_allowoffpost',
					'warning',
					'1',
					'1',
					'free',
					'yesno',
					25,
					0,
					1,
					'aws'
	),
	(
					'warn_warnings_per_page',
					'warning',
					'0',
					'15',
					'free',
					'',
					26,
					0,
					1,
					'aws'
	),
	(
					'warn_textbutoption',
					'warning',
					'Text',
					'Text',
					'free',
					'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"Text\\\" \" . iif($setting[\'value\']==\'Text\',\'selected=\"selected\"\') . \">Text</option>\r\n<option value=\\\"Buttons\\\" \" . iif($setting[\'value\']==\'Buttons\',\'selected=\"selected\"\') . \">Buttons</option>\r\n</select>',
					26,
					0,
					1,
					'aws'
	),
	(
					'warn_modoption',
					'warning',
					'All',
					'Own',
					'free',
					'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"Own\\\" \" . iif($setting[\'value\']==\'Own\',\'selected=\"selected\"\') . \">Own</option>\r\n<option value=\\\"All\\\" \" . iif($setting[\'value\']==\'All\',\'selected=\"selected\"\') . \">All</option>\r\n</select>',
					28,
					0,
					1,
					'aws'
	),
	(
					'warn_sig_thresshold',
					'warning',
					'0',
					'0',
					'free',
					'',
					29,
					0,
					1,
					'aws'
	),
	(
					'warn_avatar_thresshold',
					'warning',
					'0',
					'0',
					'free',
					'',
					30,
					0,
					1,
					'aws'
	),
	(
					'warn_aprotected_usergroups',
					'warning',
					'',
					'',
					'free',
					'',
					31,
					0,
					1,
					'aws'
	),
	(
					'warn_pmcutoff',
					'warning',
					'0',
					'0',
					'free',
					'',
					32,
					0,
					1,
					'aws'
	),
	(
					'warn_admingroups',
					'warning',
					'6',
					'',
					'free',
					'',
					33,
					0,
					1,
					'aws'
	),
	(
					'warn_smodgroups',
					'warning',
					'5',
					'',
					'free',
					'',
					34,
					0,
					1,
					'aws'
	),
	(
					'warn_modgroups',
					'warning',
					'7',
					'',
					'free',
					'',
					35,
					0,
					1,
					'aws'
	),
	(
					'warn_includepost',
					'warning',
					'1',
					'0',
					'free',
					'yesno',
					36,
					0,
					1,
					'aws'
	),
	(
					'warn_savecopy',
					'warning',
					'1',
					'0',
					'free',
					'yesno',
					37,
					0,
					1,
					'aws'
	),
	(
					'warn_savecopyalert',
					'warning',
					'1',
					'0',
					'free',
					'yesno',
					38,
					0,
					1,
					'aws'
	),
	(
					'warn_savecopyforum',
					'warning',
					'166',
					'',
					'free',
					'',
					39,
					0,
					1,
					'aws'
	),
	(
					'warn_allowalerts',
					'warning',
					'1',
					'0',
					'free',
					'yesno',
					40,
					0,
					1,
					'aws'
	),
	(
					'warn_allowalertscomment',
					'warning',
					'1',
					'0',
					'free',
					'yesno',
					41,
					0,
					1,
					'aws'
	),
	(
					'warn_alertslifetime',
					'warning',
					'30',
					'0',
					'free',
					'',
					42,
					0,
					1,
					'aws'
	),
	(
					'warn_allownotes',
					'warning',
					'1',
					'1',
					'free',
					'yesno',
					43,
					0,
					1,
					'aws'
	),
	(
					'warn_version',
					'warning',
					'3.4.16',
					'3.5.4',
					'free',
					'',
					44,
					0,
					1,
					'aws'
	);

MySQL Error  : Duplicate entry 'warn_hierarchical' for key 1
Error Number : 1062
Date         : Saturday, August 5th 2006 @ 11:16:40 AM
Script       : http://www.majorfm.com/forum/admincp/plugin.php
Referrer     : http://www.majorfm.com/forum/admincp...?do=productadd
IP Address   : 82.25.***.***
Username     : AJ
Classname    : vb_database

Please advise what do to, in done everything else but see no changes on my forum!

Hornstar · #**1075** 08-06-2006, 11:44 AM

I've now upgraded to VB3.6 uninstalled this hack to use the infractions (may install this again if it becomes supported for 3.6 but until then am trying to get used to infractions lol.)

however I just got a database error and i think part of the code is not removed in the database. How do I uninstall it completely?

Thanks

Delphiprogrammi · #**1076** 08-06-2006, 12:45 PM

Quote:

Originally Posted by MajorFm.com

Ok small problem, just installed, i had the previous version already installed on my previous version of vb, so i want to keep all existing warn data, so i assume i don't delete existing tables etc...

I got this error when importing the product:

Please advise what do to, in done everything else but see no changes on my forum!

previous version ? the vb 3 version ? then you must run uninstall.php before you install the 3.5.x version.You must create a back from this tables

user
warnings
warning_types
pmtext_warned
warn_notes
ban_dates
post

then you can restore this later on .....I suggest you start with clean 3.5.x files you can try to run this

Code:

SELECT * FROM " . TABLE_PREFIX . "setting WHERE varname like 'warn_%';

that will return all the settings used by the system.If you don't want them any longer

Code:

DELETE  FROM " . TABLE_PREFIX . "setting WHERE varname like 'warn_%';

allthrough be carefull with this and keep tableprefixex in mind

Delphiprogrammi · #**1077** 08-06-2006, 12:45 PM

Quote:

Originally Posted by hornstar1337

I've now upgraded to VB3.6 uninstalled this hack to use the infractions (may install this again if it becomes supported for 3.6 but until then am trying to get used to infractions lol.)

however I just got a database error and i think part of the code is not removed in the database. How do I uninstall it completely?

Thanks

and what would the database error be ?

d2sector · #**1078** 08-07-2006, 08:09 AM

I have un-installed it to use the vb 3.6.0 infraction system and im getting this error. ?

Code:

Database error in vBulletin 3.6.0:

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, options + 32),
		options = IF(options & 2048, options, options + 2048),
		options = IF(options & 4096, options, options + 4096),
		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 - 64, options),
		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 = 'GFX Freak and SuperMod',
	customtitle = 2,
	username = 'FrogMan',
	email = '',
	languageid = 0,
	homepage = '',
	birthday_search = '1983-08-16',
	birthday = '08-16-1983',
	showbirthday = 2,
	icq = '',
	aim = '',
	yahoo = '',
	msn = '',
	skype = '',
	parentemail = '',
	referrerid = 0,
	ipaddress = '196.25.255.210',
	posts = 1979,
	usergroupid = 6,
	displaygroupid = 0,
	reputationlevelid = 5,
	reputation = 32,
	warnings = 0,
	infractions = 0,
	ipoints = 0,
	autosubscribe = 0,
	threadedmode = 0,
	showvbcode = 2,
	styleid = 0,
	timezoneoffset = '2',
	daysprune = 0,
	joindate = 1125867720,
	lastactivity = 1154904420,
	lastpost = 1154904360,
	membergroupids = ''
WHERE userid = 10184;

MySQL Error  : Unknown column 'warnings' in 'field list'
Error Number : 1054
Date         : Monday, August 7th 2006 @ 04:08:00 AM

Delphiprogrammi · #**1079** 08-07-2006, 08:35 AM

Quote:

Originally Posted by d2sector

I have un-installed it to use the vb 3.6.0 infraction system and im getting this error. ?

Code:

 
Database error in vBulletin 3.6.0:
 
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, options + 32),
        options = IF(options & 2048, options, options + 2048),
        options = IF(options & 4096, options, options + 4096),
        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 - 64, options),
        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 = 'GFX Freak and SuperMod',
    customtitle = 2,
    username = 'FrogMan',
    email = '',
    languageid = 0,
    homepage = '',
    birthday_search = '1983-08-16',
    birthday = '08-16-1983',
    showbirthday = 2,
    icq = '',
    aim = '',
    yahoo = '',
    msn = '',
    skype = '',
    parentemail = '',
    referrerid = 0,
    ipaddress = '196.25.255.210',
    posts = 1979,
    usergroupid = 6,
    displaygroupid = 0,
    reputationlevelid = 5,
    reputation = 32,
    warnings = 0,
    infractions = 0,
    ipoints = 0,
    autosubscribe = 0,
    threadedmode = 0,
    showvbcode = 2,
    styleid = 0,
    timezoneoffset = '2',
    daysprune = 0,
    joindate = 1125867720,
    lastactivity = 1154904420,
    lastpost = 1154904360,
    membergroupids = ''
WHERE userid = 10184;
 
MySQL Error  : Unknown column 'warnings' in 'field list'
Error Number : 1054
Date         : Monday, August 7th 2006 @ 04:08:00 AM

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

Code:

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

keep TABLE_PREFIX in mind.....

this error will be gone now

Hornstar · #**1080** 08-07-2006, 11:32 AM

That was the database error I have above.

I tried

Code:

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

But got this error

Code:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'gamerzne_backup.user' doesn't exist

What should I try now?

Hornstar · #**1081** 08-07-2006, 11:51 AM

ALTER TABLE vb3_user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0'; I had the table prefix in the wrong spot.

Thanks.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.15671 seconds Memory Usage 2,357KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (8)bbcode_code (4)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!