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 jacks0_0

How to show Comments in Post ? Who Can help me ?

you need to enable the comments system if you want that under warning options.Also download "warn_notes_update_instructions"

[doopz]

nm misreaded.

loving the mod

[jacks0_0]

How to show Comments in Post ? Who Can help me ?

Anyone ?

[Delphiprogrammi]

Originally Posted by jacks0_0

Anyone ?

https://vborg.vbsupport.ru/showpost....postcount=1112

also i don't have the time nor the patience to answer the same question multiple times

[iamnofear]

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 '
'',
'',
'<i>The user did not enter a title</i>',
'',
'[QUOT' at line 4

I got this error, How can I fix it >?

[SnapOff Racing]

everything works PERFECT for me except look what it did to my postbit!



can anyone please help me to get things where they should be?

[SnapOff Racing]

the add not and warn links should be above the post...i have no idea why everything got jumbled...prompt assistance would be greatly appreciated

[sv1cec]

I can answer that. You are using a custom set of templates. Obviously the instructions refer to the standard set.

Also, please keep in mind that the instructions in this thread are for those of you running vB 3.5. If you are running vB 3.6, there is a dedicated thread for this hack under that vB version. Here it is:

https://vborg.vbsupport.ru/showthread.php?t=124477

[SnapOff Racing]

please disregard, i found the issue...couple lines of code were off in the postbit legacy

[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.