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.

[Hornstar]

your not the only one. Which is a shame, this mod has 31 pages so it obviously had some interest, but most of the replies in this mod have been about it not working.

[Skyrider]

Indeed, getting the same SQL error as above, uninstalled.

[tipoboy]

Originally Posted by FF|Skyrider

Indeed, getting the same SQL error as above, uninstalled.

please see this post:
https://vborg.vbsupport.ru/showpost....&postcount=407

[zefyx]

For those with SQL errors, go into phpMyAdmin & delete the table that say's it is du.plicating.

Hasaan, when upgrading from 3.0 to 3.2 on vBulletin 3.8.2 I get 0 results in the Meet Our Staff page & a Page not found in admincp's Usergroup settings, even though the file is obviously present.

[Skyrider]

Why do I get:

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 : Friday, April 24th 2009 @ 10:02:41 PM
Error Date : Friday, April 24th 2009 @ 10:02:41 PM

?

Heck, can't even uninstall this:

Database error in vBulletin 3.8.1:

Invalid SQL:
ALTER TABLE usergroup DROP staff;

MySQL Error : Can't DROP 'staff'; check that column/key exists

[TAIFUN_T]

Russian Version

FF|Skyrider, upload staff.php

[Rickeo]

Can we get an updated version of this useful mod please?

[flipstyle]

Originally Posted by Rickeo

Can we get an updated version of this useful mod please?

Yes please a update would be nice I had to revert back to the older version. The latest one has a db error.

[SAReefer]

will this work on 3.8?

[tipoboy]

Originally Posted by SAReefer

will this work on 3.8?

yes but please read the posts as there is problems regarding the latest version, and people have posted fixes regarding the problem