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.

[Hasann]

this is the last version that I post here will never be any fixed or updated light version
sorry guys I must working on Meet Our Staff PRO v1.0

[Martell]

When opening /forum/staff.php, the following error:

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT usergroup.usergroupid, usergroup.title, usergroup.isstaff
COUNT(user.userid) AS membercount
FROM vB_usergroup AS usergroup
LEFT JOIN vB_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 vB_usergroup AS usergroup
LEFT JOIN vB_' at line 2
Error Number : 1064
Request Date : Saturday, February 28th 2009 @ 11:58:27 AM
Error Date : Saturday, February 28th 2009 @ 11:58:28 AM
Script : http://xxx/staff.php
Referrer : http://xxx/index.php
IP Address : 91.207.170.131
Username : Martell
Classname : vb_database
MySQL Version : 4.1.22

[veenuisthebest]

Originally Posted by Hasann

this is the last version that I post here will never be any fixed or updated light version
sorry guys I must working on Meet Our Staff PRO v1.0

I was thinking about installing this. But it seems everybody is having db errors in this version. Won't you be releasing a fix for this or atleast provide 3.2 again before leaving this mod.

Thanks!

[Hasann]

Originally Posted by veenuisthebest

I was thinking about installing this. But it seems everybody is having db errors in this version. Won't you be releasing a fix for this or atleast provide 3.2 again before leaving this mod.

Thanks!

OKAY
please try this version

[mindfawk]

Where can we purchase the pro version?

[Hornstar]

not sure why people will want to buy the pro version if you cant even get the lite version working for all. I am still getting the database error after installing the new version today.

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT usergroup.usergroupid, usergroup.title, usergroup.isstaff
COUNT(user.userid) AS membercount
FROM vb3_usergroup AS usergroup
LEFT JOIN vb3_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 vb3_usergroup AS usergroup
LEFT JOIN vb' at line 2
Error Number  : 1064
Request Date  : Saturday, February 28th 2009 @ 06:04:30 PM
Error Date    : Saturday, February 28th 2009 @ 06:04:30 PM
Script        : http://www..net/forums/staff.php
Referrer      : 
IP Address    :
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.67-community

[inciarco]

Originally Posted by hornstar1337

not sure why people will want to buy the pro version if you cant even get the lite version working for all. I am still getting the database error after installing the new version today.

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT usergroup.usergroupid, usergroup.title, usergroup.isstaff
COUNT(user.userid) AS membercount
FROM vb3_usergroup AS usergroup
LEFT JOIN vb3_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 vb3_usergroup AS usergroup
LEFT JOIN vb' at line 2
Error Number  : 1064
Request Date  : Saturday, February 28th 2009 @ 06:04:30 PM
Error Date    : Saturday, February 28th 2009 @ 06:04:30 PM
Script        : http://www..net/forums/staff.php
Referrer      : 
IP Address    :
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.67-community

I Got that Same Error Too.

I thin is Important for Hasann to Get this Last Version 3.2 Working to Successfully Lauch His Pro Version; this is the FrontPage for Users to Motivate to Acquire the Pro One.

My Best Regards.

[hobbybox]

So I was going to give this a try - I uploaded staff.php and imported the file however I have looked EVERYWHERE in the admin area and cannot locate any link to set this application up. Does anyone have an idea where I find the link to set it up?

[hobbybox]

just figured out - there were no admin files in the zip files to upload - that makes a lot of sense

[DragonMasterNYC]

Ok so I updated it and now it looks like something is wrong with the phrases for the menu in the Admin CP, and also when I go to the meet our staff settings nothing comes up except the setting group drop down and save and reset buttons.

Please get back to me as soon as you get a chance.

Thanks ahead of time.