vB Staff Titles

vB Staff Title

Show your support and vote this hack for HotM September!!

vBulletin 3.5.0 RC 3
www.vBHackers.com

What this does
This will give you the option to add an additional title for staff members, or any user you would like to add. This can be done with conditions only, like if userid = X show this. But this will make things much eaiser to edit and manage. And I spend alot of time in the ACP.

New Features Since Last Release

• Option to turn the staff title on/off per user.
  This is good so if you want to temporarily disable someones staff title, but don't want to lose the settings.
• HTML Mark Available now
  This will make it more customizable

Show rank in your members profile
To show the rank in your members profile. Please see this post


Note:
This hack will work for vBulletin Version 3.5.0 RC-1 and RC-2 ONLY!
This is a port from my original hack which can be found here. Had a couple of PMs about it so I said why not.

To do list...

• Time to install: 3 minutes
• Queries to run: 4
• File Mods: 0
• Templates to edit: 1
• Templates to add: 0
• New Phrases: 4
• New Plugins: 2

Please read carefully and make all the necessary changes as stated. This is will work if installed properly.
PLEASE REMEMBER TO BACKUP BEFORE YOU BEGIN! If you like this hack

Click It For Support!

Help & Support
Before asking for support Please make sure you have done all necessary changes! If you still need support please post a reply here.

Please post bugs and errors here. Hope you like, feedback welcomed.




Version Info:
v1.1: Fixed Missing Phrase
v1.0: Released

[MissKalunji]

Originally Posted by Smiry Kin's

How do i add this to vbulletin 3.5.2 i would really like a release,

thanks

install then go to user / search the user uw anna add the title to (or you can do it through usergroup
you gon have : something that says custome user title (should be around the bottom

add the custom title or html for images and your good 2 go

[Smiry Kin's]

Originally Posted by MissKalunji

install then go to user / search the user uw anna add the title to (or you can do it through usergroup
you gon have : something that says custome user title (should be around the bottom

add the custom title or html for images and your good 2 go

wha?!

Could you make installer man??

[vBSEO]

Excellent! Installed (with member info mod)

[MissKalunji]

Originally Posted by Smiry Kin's

wha?!

Could you make installer man??

get the pluging / upload it in product....then go to user profile....and set it there...

[Xplorer4x4]

I seemed to get this error when attemptin to use on my new server which makes me thinkg it is a PHP/MySQL conflict.

MySQL V5
PHP v4.4.1 & PHP v5.1.1

Not sure which is in effect.

Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE user SET
	passworddate = FROM_UNIXTIME(1136455772),
	password = 'fb98a3830432d6ff9ad9ac5a5a1b7d4e',
	### Bitfield: user.options ###
		options = IF(options & 8, options - 8, options),
		options = IF(options & 1024, options - 1024, options),
		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 & 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),
	usertitle = 'Administrator',
	customtitle = 0,
	username = 'Xplorer4x4',
	email = '',
	languageid = 0,
	homepage = '',
	birthday_search = '1984-10-22',
	birthday = '10-22-1984',
	showbirthday = 2,
	icq = '',
	aim = '',
	yahoo = '',
	msn = '',
	skype = '',
	parentemail = '',
	posts = 592,
	referrerid = 0,
	ipaddress = '',
	vbookie_cash = 500,
	ucash = '2230.54',
	isstaffrank = '0',
	staffrank = '',
	staffrank_opentag = '',
	staffrank_closetag = '',
	alerts = 0,
	warnings = 0,
	warning_level = 0,
	warning_bans = 0,
	usergroupid = 6,
	reputationlevelid = 5,
	reputation = 23,
	pmpopup = 1,
	autosubscribe = -1,
	threadedmode = 0,
	showvbcode = 2,
	styleid = 0,
	timezoneoffset = '-6',
	daysprune = 0,
	joindate = 1132099380,
	lastactivity = 1136455740,
	lastpost = 1136455620,
	membergroupids = ''
WHERE userid = 1;

MySQL Error  : Unknown column 'isstaffrank' in 'field list'
Error Number : 1054
Date		 : Thursday, January 5th 2006 @ 10:09:32 AM
Script	   : /admincp/user.php
Referrer	 : /admincp/user.php?do=edit&u=1
IP Address   : 
Username	 : Xplorer4x4
Classname	: vb_database

[Breath]

I've just tried it on a mysql5 forum. Seems to be an issue directly with mysql5.

[Breath]

After some further playing it seems the hack is no longer installing the isstaffrank field in the db.

[Breath]

Ok heres's a fix for it.

Open the xml file and change

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD (isstaffrank INT(6) UNSIGNED NOT NULL DEFAULT '')");

to

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD (isstaffrank INT(6) UNSIGNED NOT NULL)");

This does the trick on mysql5

[sinaluna]

I would like members to be able to use this. Is there any way this can be set in the User CP? Thanks!

[Breath]

Originally Posted by sinaluna

I would like members to be able to use this. Is there any way this can be set in the User CP? Thanks!

What would be the point of that are members can use custom titles anyway?