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.

[sgrisole]

I installed version 3.2 and now I get the following error when visiting staff.php

Database error in vBulletin 3.7.4:

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 A' at line 2
Error Number  : 1064
Request Date  : Saturday, March 14th 2009 @ 11:43:48 AM
Error Date    : Saturday, March 14th 2009 @ 11:43:48 AM
Classname     : vB_Database
MySQL Version : 5.0.67-community

I tried to uninstall / reinstall the product several times but it didn't fix the problem...
BTW is the PRO version available somewhere?

[tidefans]

I am getting this same error

Originally Posted by sgrisole

I installed version 3.2 and now I get the following error when visiting staff.php

Database error in vBulletin 3.7.4:

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 A' at line 2
Error Number  : 1064
Request Date  : Saturday, March 14th 2009 @ 11:43:48 AM
Error Date    : Saturday, March 14th 2009 @ 11:43:48 AM
Classname     : vB_Database
MySQL Version : 5.0.67-community

I tried to uninstall / reinstall the product several times but it didn't fix the problem...
BTW is the PRO version available somewhere?

[cookiepants]

Database error here too. I'd like to try it before paying for one. I've tried all versions here and will remove until the DB issue is resolved. Thanks!

[Lynne]

It looks like it's just missing a comma before the COUNT part of the select statement. Did someone try just addig in the comma and seeing if the error goes away?

[sgrisole]

Thanks Lynne, that made the page work, but now for some reason the moderators aren't listed when I click on the "moderators" link in staff.php. Only the admins are shown. Yes, I already added the "moderators" group to the staff usergroups in the options.
Any idea?

edit: I found out what was causing the problem and fixed it: the "moderators" group was not set as the primary group for moderators, so they didn't show up in the staff.php page. Now I have one more thing to adjust... Is there any way to have both the admins and moderators displayed on the same page? There are only two admins and 3 moderators in my board, so it would be nice to have them displayed on the same page.

[Switch02]

This version work on vb 3.8.1?

Thanks

[sheppardzwc]

Originally Posted by Switch02

This version work on vb 3.8.1?

Thanks

I don't know if it does or not, currently fixing an SQL error that Lynne supplied the answer to, and will post back later.

EDIT: Working perfectly for me.

http://www.toontownhall.com/forums/showgroups.php

Just remember to add a comma after the usergroup.istaff comment in the SQL query. (in staff.php by default)

SELECT usergroup.usergroupid, usergroup.title, usergroup.isstaff,
COUNT(user.userid) AS membercount

[cynthetiq]

I did the update from 2.0 to 3.2 with the , for the SQL query. I get nothing on the staff.php page, not even a single name. if I use the 3.1 staff.php, I get names, broken up groups, but no title for the group, and no avatars for the individuals.

[cynthetiq]

some of it is my fault. I didn't declare the groups....

now that I di dthat. here's a screen cap

[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