vb.org Archive - Miscellaneous Hacks

Page 12 of 14

« First

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)

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 :)

qbn720

03-22-2009 06:34 AM

<font face="Tahoma">Excellent work Hassan, nice. I modified your original release and changed a few phrases. I'm not really using this for my staff, this is more for a role-playing thing and I'm using Usergroups as a way to denote rank. I'll be looking forward to the Pro version.</font>

Hornstar

03-23-2009 07:06 AM

I am just waiting for the official update from the coder before I re enable this modification, it has been disabled since day 1 because of the database errors and problems. Surely he could complie all the fixes in this thread and give us a good update.

System69

03-23-2009 08:10 AM

is there a way in 3.2 to make it viewable for non registered users? in the settings i speciefied no group to be blocked, but still the not registered member's can't see the staff page.

any ideas?

Saviour

03-24-2009 06:53 AM

Great mod...and thanks for sharing...

Any plans for re-coding this and making it XHTML compliant?

itviet

04-06-2009 06:05 AM

version 3.2 don't work with 3.8.2. Plz update :(

kushal

04-10-2009 04:19 PM

I am using 3.7.4 and this is the database error I am getting on upgrade to 3.2

Quote:

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

root's

04-14-2009 07:53 AM

Error of 3.8 db is also suitable for the most recent version yet

Blackheart_72

04-14-2009 08:54 AM

Uninstalled.

tipoboy

04-14-2009 09:34 AM

uninstalled due to very little support and i made my own version of a staff page anyways

therogueforums

04-16-2009 08:49 AM

This is an awesome mod, used it for a long time, but since the upgrade to 8.0, it's been busted. I'm afraid I'm going to have to uninstall.

Hornstar

04-17-2009 12:23 AM

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

04-17-2009 06:14 AM

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

tipoboy

04-17-2009 06:25 AM

Quote:

Originally Posted by FF|Skyrider (Post 1793073)

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

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

zefyx

04-24-2009 07:30 AM

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

04-24-2009 07:03 PM

Why do I get:

Quote:

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:

Quote:

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

04-25-2009 02:04 AM

Russian Version

FF|Skyrider, upload staff.php

Rickeo

04-25-2009 11:43 AM

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

flipstyle

04-26-2009 06:05 PM

Quote:

Originally Posted by Rickeo (Post 1798699)

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

04-27-2009 09:39 PM

will this work on 3.8?

tipoboy

04-27-2009 09:50 PM

Quote:

Originally Posted by SAReefer (Post 1800199)

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

rizelim

04-28-2009 05:53 PM

thanks ! Hasan...

SEW810

04-29-2009 03:35 PM

Working fine with vb 3.8.2

Thnx Hasann

People havin' DB crap, please overwrite staf.php with this one:
https://vborg.vbsupport.ru/showthrea...40#post1769340

Hasann

04-29-2009 06:16 PM

Quote:

Originally Posted by Rickeo (Post 1798699)

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

new update is there..

Quote:

Originally Posted by flipstyle (Post 1799454)

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

OK it is now fixed

Quote:

Originally Posted by SAReefer (Post 1800199)

will this work on 3.8?

yes fixed version will work on version 3.8.x

Quote:

Originally Posted by rizelim (Post 1800711)

thanks ! Hasan...

No Problem :)

Flood

05-03-2009 12:09 PM

Hey guys, i'm new to all this coding and stuff. Have a website. Managed to finally upload this mod. But the page is white (instead of my own backgound) and none of the pic/avators are showing up. Just a little red x. Can any explain in english, step by step, what i can do to correct these problems. Much appreciated in advance. Great mod by the way.

Edit: I'm using vb 3.7.3 incase you need to know

atmaca

05-04-2009 06:03 PM

Avatars not shown in IE8.

Flood

05-04-2009 06:59 PM

Just letting you know i got someone to help me out who knew what they where doing lol. All sorted now. Looks really good.

My Staff page

TPTP	05-11-2009 05:59 AM

I'm skimming through this thread and seeing a lot of people with issues getting it working. Is it working cleanly with 3.8.2, and are the posted install files correct, or are there other tweaks required?

System69

05-11-2009 06:02 AM

we did a hell of tweaks... that's the result on 3.8.2 -> http://www.e46fanatics.de/staff.php

System69

05-11-2009 01:47 PM

is there a way to get a "branding free" version?

imported_silkroad

05-25-2009 07:35 AM

Any idea why the skype icon does not show "online" status even when the skype user is online?

http://www.unix.com/staff.php

All times are GMT. The time now is 03:03 PM.

Page 12 of 14

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02066 seconds Memory Usage 1,830KB 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 (13)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 (40)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
Messages: