vB Staff Titles

vB Staff Title

vBulletin 3.5.0 RC 2
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

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.

Illustrious · 01-17-2007, 08:26 PM

Quote:

Originally Posted by Crys

Where is the phpmyadmin? I have no such folder or file in the ftp. Closest thing I have would be the admincp which has a user.php file within. If so, where in the file?

I'm honestly not very familiar with all this so if you could show me or attach screen shots, that would make it so much more helpful.

Thanks,

~ Crys ^^

phpmyadmin is usually backend, you can find it in the cpanel if you have it. You have to insert the line into the SQL.

Xplorer4x4 · 02-04-2007, 12:16 PM

I get the same error mentioned above:

Quote:

Fatal error: Field isstaffrank is not defined in $validfields in class vb_datamanager_user in /includes/class_dm.php on line 485

The think I can't understand is when i go into phpmyadmin all the proper tables exist, and seem to have the proper values(INT(6) UNSIGNED NOT NULL).

I suppose I will try a manual install of the mentioned table, but seeing that it does exist with proper values baffles me as to why the error exists.

Thanks for all your time.

02-04-2007, 05:27 PM

enter that into ur sql tab in phpmyadmin

ALTER TABLE user ADD (isstaffrank INT(6) UNSIGNED NOT NULL DEFAULT '')");

Xplorer4x4 · 02-05-2007, 01:53 AM

I got this error:

Quote:

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 70
STR: "
SQL: ALTER TABLE user ADD (isstaffrank INT(6) UNSIGNED NOT NULL DEFAULT '')")

SQL query:

ALTER TABLE user ADD (isstaffrank INT(6) UNSIGNED NOT NULL DEFAULT '')")

MySQL said: Documentation
#1064 - 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 '")' at line 1

02-05-2007, 01:57 AM

woops forgot to take off end column, try

ALTER TABLE user ADD (isstaffrank INT(6) UNSIGNED NOT NULL DEFAULT '');

Xplorer4x4 · 02-05-2007, 02:06 AM

Ok i ran it and it said table existed. So I dropped the table and run the query, but i still get the same error.

Quote:

Fatal error: Field isstaffrank is not defined in $validfields in class vb_datamanager_user in /includes/class_dm.php on line 485

02-05-2007, 02:08 AM

im installing this now, ill try and fix asap

Xplorer4x4 · 02-05-2007, 02:11 AM

Thank You

02-05-2007, 02:13 AM

ok i just insatlled on 3.6.4 and it ran great, what version are you on?

Xplorer4x4 · 02-05-2007, 02:25 AM

I am on 3.6.4 as well

LinkBacks (?) LinkBack to this Thread: http://www.vbhackers.com/f76/vb-staff-titles-1754/
Posted By	For	Type	Date
3.6.4 - vB Staff Titles - ôîðóì vBulletin.net.ru	This thread	Refback	01-27-2007 03:08 PM
3.6.4 - vB Staff Titles - ôîðóì vBulletin.net.ru	This thread	Refback	01-27-2007 02:41 AM
Mods for ic - Lan1	This thread	Refback	12-02-2006 11:29 PM

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Staff Positions	Ken Iovino	Announcements	0	12-27-2005 04:37 PM
'vB Staff Titles'	Martyn	vBulletin Modification Requests	0	12-01-2005 10:05 PM
Users Only Allowed to Send PMs to Staff (staff excluded)	firas	vBulletin Modification Requests	3	09-08-2005 05:04 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)