Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.7 > vBulletin 3.7 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Meet Our Staff Details »»
Meet Our Staff
Version: 1.0, by Hasann Hasann is offline
Developer Last Online: Jun 2021 Show Printable Version Email this Page

Category: Miscellaneous Hacks - Version: 3.7.6 Rating:
Released: 07-05-2008 Last Update: 12-25-2009 Installs: 565
DB Changes Uses Plugins Auto-Templates
Additional Files Translations  
No support by the author.

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.

Supporters / CoAuthors

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #442  
Old 03-16-2009, 04:29 PM
atmaca's Avatar
atmaca atmaca is offline
 
Join Date: Jan 2008
Location: Turkey/Gaziantep
Posts: 64
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

Code:
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
Reply With Quote
  #443  
Old 03-16-2009, 04:37 PM
inciarco's Avatar
inciarco inciarco is offline
 
Join Date: Mar 2007
Posts: 758
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by atmaca View Post
I'm upgradeded to v3.2 and then getting db error:

Code:
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.

Reply With Quote
  #444  
Old 03-16-2009, 04:39 PM
atmaca's Avatar
atmaca atmaca is offline
 
Join Date: Jan 2008
Location: Turkey/Gaziantep
Posts: 64
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by inciarco View Post
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
Reply With Quote
  #445  
Old 03-16-2009, 06:05 PM
Saviour's Avatar
Saviour Saviour is offline
 
Join Date: Apr 2007
Posts: 743
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #446  
Old 03-18-2009, 12:34 AM
Dr. Bantham's Avatar
Dr. Bantham Dr. Bantham is offline
 
Join Date: Feb 2007
Posts: 164
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #447  
Old 03-18-2009, 01:01 AM
cynthetiq's Avatar
cynthetiq cynthetiq is offline
 
Join Date: Jul 2005
Location: NYC
Posts: 190
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

why not make a new admin group and don't list it with your meet the staff mod.
Reply With Quote
  #448  
Old 03-18-2009, 01:23 PM
hobbybox hobbybox is offline
 
Join Date: May 2008
Posts: 105
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #449  
Old 03-18-2009, 04:15 PM
sunnycher sunnycher is offline
 
Join Date: Mar 2005
Location: FL
Posts: 235
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thank you!!!!!!!!


This works great on 3.8.1 with this fix!


Thank you SO much!!



Quote:
Originally Posted by KSMatic View Post
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
Reply With Quote
  #450  
Old 03-19-2009, 07:21 PM
paintballer.ie's Avatar
paintballer.ie paintballer.ie is offline
 
Join Date: Jan 2009
Posts: 105
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #451  
Old 03-22-2009, 01:28 AM
onlyfree onlyfree is offline
 
Join Date: Jan 2006
Posts: 32
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

Code:
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
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:40 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.11541 seconds
  • Memory Usage 2,322KB
  • Queries Executed 26 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (3)bbcode_code
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete