Miscellaneous Hacks - Meet Our Staff

MEET OUR STAFF GOLD by

This Product brought to you by
Www.vBulletin-TR.Com

Description: Meet Our Staff Solution Better than vB.Org's

Note 1: I've finally decided to publish Pro version of this product to all of you.
Note 2: Paid version will come soon for vBulletin version 4.x.x. Series.

Go to for vBulletin Version 3.8.x Series of this product.. (please, click here..)

Comments, suggestions, translations, bugs, etc... are very welcome!
Support is only given to people who have clicked Mark as Installed.

Mark as Installed - Nominate for MOTM

Online Demo: www.vbulletin-tr.com/forum/staff.php?langid=1




http://img691.imageshack.us/img691/2...urstaffpro.jpg

Comments, suggestions, translations, bugs, etc... are very welcome!
Support is only given to people who have clicked Mark as Installed.

[atmaca]

I'm upgradeded to v3.2 and then getting db error:

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT usergroup.usergroupid, usergroup.title, usergroup.isstaff
COUNT(user.userid) AS membercount
FROM usergroup AS usergroup
LEFT JOIN user AS user ON (user.usergroupid = usergroup.usergroupid OR FIND_IN_SET(usergroup.usergroupid, user.membergroupids))
WHERE usergroup.isstaff = '1'
GROUP BY usergroup.usergroupid
ORDER BY usergroup.title ASC;

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 'COUNT(user.userid) AS membercount
FROM usergroup AS usergroup
LEFT JOIN user AS ' at line 2
Error Number  : 1064
Request Date  : Monday, March 16th 2009 @ 07:25:54 PM
Error Date    : Monday, March 16th 2009 @ 07:25:54 PM
Script        : ...../staff.php
Referrer      : .../index.php
IP Address    : ...
Username      : Supervisor
Classname     : vB_Database
MySQL Version : 5.0.45

[inciarco]

Originally Posted by atmaca

I'm upgradeded to v3.2 and then getting db error:

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT usergroup.usergroupid, usergroup.title, usergroup.isstaff
COUNT(user.userid) AS membercount
FROM usergroup AS usergroup
LEFT JOIN user AS user ON (user.usergroupid = usergroup.usergroupid OR FIND_IN_SET(usergroup.usergroupid, user.membergroupids))
WHERE usergroup.isstaff = '1'
GROUP BY usergroup.usergroupid
ORDER BY usergroup.title ASC;

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 'COUNT(user.userid) AS membercount
FROM usergroup AS usergroup
LEFT JOIN user AS ' at line 2
Error Number  : 1064
Request Date  : Monday, March 16th 2009 @ 07:25:54 PM
Error Date    : Monday, March 16th 2009 @ 07:25:54 PM
Script        : ...../staff.php
Referrer      : .../index.php
IP Address    : ...
Username      : Supervisor
Classname     : vB_Database
MySQL Version : 5.0.45

Read the Last Posts of this Thread regarding the Addition of a Comma on the staff.php File, it Solves all the Problems Regarding this Last Update of the Mod.

Thanks Hasann for the Update, with the Comma Solution provided by sheppardzwc a few Posts Above the Mod Works Fine and the New Features are Really Nice. :up:

My Best Regards.

[atmaca]

Originally Posted by inciarco

Read the Last Posts of this Thread regarding the Addition of a Comma on the staff.php File, it Solves all the Problems Regarding this Last Update of the Mod.

Thanks Hasann for the Update, with the Comma Solution provided by sheppardzwc a few Posts Above the Mod Works Fine and the New Features are Really Nice. :up:

My Best Regards.

Thank you

[Saviour]

running vb 3.8.1 PL1.

Problem is...staff link in vbadvanced Community menu is not working...even after adding staff.php to navbar replacements in Global Settings for vbadvanced.

Anyone else having this issue?

Works fine from the forum navbar, but not vbadvanced.

Update...

Well...in order to fix the issue, since nothing else was working, I had to edit the product xml and use the full url to the staff.php page. After editing the product url and re-installing the product (allowing overwrite)...all's good to go.

[Dr. Bantham]

Thanks for this mod!

It would be great to be able to limit the members to be included within the listing. For instance, I have an administrator account used only for automated posting and content which I do not wish to be directly assigned to my personal account. I do not, however, wish for members to identify this "bot" as an active administrator. Ideally, this could be achieved by having a defined list of member numbers to include or exclude. Alternatively, defining a usergroup would suffice, as a staff group could be created.

[cynthetiq]

why not make a new admin group and don't list it with your meet the staff mod.

[hobbybox]

this mod works perfectly - really love it...just one question - it lists the staff in alphbetical order - not according to the actually hiearchy of the levels. Is there a way to change the order in which they show?

[sunnycher]

Thank you!!!!!!!!


This works great on 3.8.1 with this fix!


Thank you SO much!!

Originally Posted by KSMatic

here is the staff.php file that needed to be fixed with "," for those who are getting database issues.

Copy this in to your forums/ directory file and bam, it works

[paintballer.ie]

Works great in 3.8.1 with the comma fix.

Thanks

EDIT

Make sure forum leaders option is turned on, if not it will not display

[onlyfree]

hey, i did the comma fix - but theres another problem now:

Datenbankfehler in vBulletin 3.8.1:

Invalid SQL:

		SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline,
			customavatar.width, customavatar.height, customavatar.width_thumb, customavatar.height_thumb
		FROM user AS user
		LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid
		LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid
		WHERE user.userid =;

MySQL-Fehler  : 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 6
Fehler-Nr.    : 1064
Fehler-Zeit   : Sunday, 22.03.2009 @ 03:23:25
Datum         : Sunday, 22.03.2009 @ 03:23:26
Skript        : http://www.meet-teens.de/staff.php
Referrer      : 
IP-Adresse    : 79.xxx.xxx.xxx
Benutzername  : Exiver
Klassenname   : vB_Database
MySQL-Version : 5.0.32-Debian_7etch8

and i can't find the line 6 (WHERE user.userid = where he gives this error (searched at staff.php)
anyone who can help

thanks