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

[scootman]

Install great job Thanks

[sinaluna]

Originally Posted by Breath

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

The same reason that staff need it. Custom titles are already being used and a separate line is needed for other purposes.

[Xplorer4x4]

Originally Posted by 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

Just a warning that I got a datbase error when I did this and now I get one when i try to add any product.

Here is the error:

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 '-End Error Mess = 'a:4:{s:17:\"custom_link_added\";s:44:\"The custom link has su' at line 1
Error Number : 1064

[Logikos]

Originally Posted by 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

hmmm, I've just installed on 3.5.3 and everything works fine.

[Logikos]

The only problem I saw was a incorrect phrase. Fixed and updated.

/tag

[LincolnForums]

doesnt work on mysql5 or php5 not sure which

[Xplorer4x4]

Originally Posted by 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

Now I get a datbase error everytime i install ANY plug in. The error is to large to fit in this thread, so canb some one please help me repair the problem.
https://vborg.vbsupport.ru/attachmen...chmentid=42063

[Dark s.s. Trunk]

I like but i get one error it overrides the admin titles doesnt add a second.. and everything was dune to the instructions..

[craiovaforum]

can this be modified to do it per usergroup?