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]

I am getting a database error after upgrading as well :/

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT user.*, usergroup.usergroupid, usergroup.isstaff, usergroup.title, user.options, usertextfield.*, userfield.*,
userfield.field2,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid
FROM vb3_user AS user
LEFT JOIN vb3_usergroup AS usergroup ON(vb3_usergroup.usergroupid = vb3_user.usergroupid)
LEFT JOIN vb3_userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN vb3_usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
WHERE vb3_usergroup.isstaff = '1'
AND (FIND_IN_SET('6', membergroupids) OR user.usergroupid = 6);

MySQL Error : Unknown column 'vb3_usergroup.isstaff' in 'where clause'
Error Number : 1054
Request Date : Wednesday, February 25th 2009 @ 01:03:07 AM
Error Date : Wednesday, February 25th 2009 @ 01:03:14 AM
Script : http://www..net/forums/staff.php?do=...oups&groupid=6
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.67-community

[Chadi]

Error

Database error in vBulletin 3.8.1:

Invalid SQL:
ALTER TABLE usergroup ADD staff INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error : Duplicate column name 'staff'
Error Number : 1060
Request Date : Wednesday, February 25th 2009 @ 12:08:08 AM
Error Date : Wednesday, February 25th 2009 @ 12:08:08 AM
Script : http://www.talkjesus.com/xxxxx/plugi...=productimport
Referrer : http://www.talkjesus.com/xxxxx/plugin.php?do=productadd
IP Address : xxxxx
Username : Chad
Classname : vB_Database
MySQL Version : 5.0.67-community

[Hasann]

I thought they're now fixed. Please upload all files overwrite and re-import product.xml file again.

[digicom]

just upgraded from 3.1 to 3.2 and now when i click link in nav bar i get this any ideas Hasann? thanks

[Hasann]

Originally Posted by digicom

just upgraded from 3.1 to 3.2 and now when i click link in nav bar i get this any ideas Hasann? thanks

have you been selected your staff groups?

[digicom]

Much Apprciated Hasann All Working Now! Thankyou :up:

[inciarco]

I Uploaded Files and Overwrited Product but an Error is Happening when Trying to Access "staff.php":

ZZZ is Table Prefix.

Perhaps the Table Prefix is missing on "WHERE usergroup.isstaff = " ?
(I can see the Prefix on "SELECT ZZZusergroup.usergroupid, ZZZusergroup.isstaff")

Database error in vBulletin 3.7.3:

Invalid SQL:

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

MySQL Error : Unknown column 'usergroup.isstaff' in 'where clause'
Error Number : 1054
Request Date : Wednesday, February 25th 2009 @ 10:39:29 AM
Error Date : Wednesday, February 25th 2009 @ 10:39:30 AM
Script : http://ZZZ/staff.php
Referrer : http://ZZZ/
IP Address : ZZZ
Username : ZZZ
Classname : ZZZDatabase
MySQL Version : 5.0.51a-community

[Chadi]

Still getting same database error

This time a different table

MySQL Error : Duplicate column name 'isstaff'

[Martell]

Database error

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT user.*, usergroup.usergroupid, usergroup.isstaff, usergroup.title, user.options, usertextfield.*, userfield.*,
userfield.field2,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid
FROM vB_user AS user
LEFT JOIN vB_usergroup AS usergroup ON(vB_usergroup.usergroupid = vB_user.usergroupid)
LEFT JOIN vB_userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN vB_usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
WHERE vB_usergroup.isstaff = '1';

MySQL Error : Unknown table 'vB_usergroup' in where clause
Error Number : 1109
Request Date : Thursday, February 26th 2009 @ 02:23:54 AM
Error Date : Thursday, February 26th 2009 @ 02:23:54 AM
Script : http://xxx/staff.php
Referrer :
IP Address : 91.207.170.131
Username : Martell
Classname : vb_database
MySQL Version : 4.1.22

[mindfawk]

Can you put the ZIP file back up for the 3.1 version? I didn't have any issues with it, this new version gives me the same data base issues as the others above.