vb.org Archive
Page 45 of 55 « First 354344 45 4647 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Miscellaneous Hacks - Meet Our Staff (https://vborg.vbsupport.ru/showthread.php?t=184491)

atmaca 03-16-2009 04:29 PM
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

inciarco 03-16-2009 04:37 PM
Quote:
Originally Posted by atmaca (Post 1769757)
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.

:)

atmaca 03-16-2009 04:39 PM
Quote:
Originally Posted by inciarco (Post 1769761)
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 ;)

Saviour 03-16-2009 06:05 PM
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.

Dr. Bantham 03-18-2009 12:34 AM
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.

cynthetiq 03-18-2009 01:01 AM
why not make a new admin group and don't list it with your meet the staff mod.

hobbybox 03-18-2009 01:23 PM
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?

sunnycher 03-18-2009 04:15 PM
Thank you!!!!!!!!


This works great on 3.8.1 with this fix!


Thank you SO much!!



Quote:
Originally Posted by KSMatic (Post 1769340)
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 :)

paintballer.ie 03-19-2009 07:21 PM
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

onlyfree 03-22-2009 01:28 AM
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 :)


All times are GMT. The time now is 10:27 AM.
Page 45 of 55 « First 354344 45 4647 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01565 seconds
  • Memory Usage 1,752KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete