vb.org Archive
Page 13 of 21 « First 31112 13 1415 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Add Usergroup as Moderator (https://vborg.vbsupport.ru/showthread.php?t=93543)

stefaandk 01-16-2006 05:34 AM
Also having troubles on vB 3.5.3
MySQL 4.1.16

All works OK functionality wise but when I try to remove the actual moderators group I get this error:

Quote:

Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT moderatorusergroupid, 'Moderator_AA</i> from the forum <i>America's Army: The Weapons Cache (Private)' AS title
FROM TOGvB_moderatorusergroup
WHERE moderatorusergroupid = 1;

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 'Army: The Weapons Cache (Private)' AS title
FROM TOGvB_moderatorusergroup
' at line 1
Error Number : 1064
Date : Monday, January 16th 2006 @ 06:30:52 PM
Script : http://10.1.1.199/SITES/V6/forum/adm...rusergroup.php
Referrer : http://10.1.1.199/SITES/V6/forum/adm...rusergroupid=1
IP Address : 10.1.1.150
Username : Admin
Classname : vB_Database
Be a great addition, hopefully this can be resolved.

Submerge 02-06-2006 07:07 PM
Seems to be an error in 3.5.3. Darn, was looking forward to this.

007 03-15-2006 12:52 AM
Also getting an error.

It happens when editing a custom mod group in 3.5.4:

Quote:
Invalid SQL:

INSERT INTO moderator (userid, forumid, permissions, moderatorusergroupid, modusergroupid)
SELECT user.userid, moderatorusergroup.forumid, moderatorusergroup.permissions, moderatorusergroup.moderatorusergroupid, moderatorusergroup.usergroupid
FROM moderatorusergroup AS moderatorusergroup
LEFT JOIN user AS user ON (user.usergroupid=moderatorusergroup.usergroupid OR FIND_IN_SET(moderatorusergroup.usergroupid, user.membergroupids))
LEFT JOIN moderator AS moderator ON (moderator.userid=user.userid AND moderator.moderatorusergroupid=moderatorusergroup. moderatorusergroupid)
WHERE ISNULL(moderator.userid) AND (NOT ISNULL(user.userid)) AND moderatorusergroup.moderatorusergroupid=3;

MySQL Error : Not unique table/alias: 'moderator'

Andreas 03-17-2006 03:11 AM
This query executes just fine for me.
Which mySQL version do you use?

cOuNtErFiET 03-28-2006 04:16 AM
is there a way to get the groups so that the group in the moderator column is the same color as the members name (HTML Markup) fro the group? Like if a member is White the Usergroup Color would be white in the moderator column? im sure this is simple just don't know what to put

Raw Sugar 03-28-2006 07:53 PM
Is it possible to modify this so that Mods can also view the Style & Templates section and the Forum section? Or does anyone know of a way to change this?

EasyTarget 04-11-2006 07:57 PM
Quote:
Originally Posted by cOuNtErFiET
is there a way to get the groups so that the group in the moderator column is the same color as the members name (HTML Markup) fro the group? Like if a member is White the Usergroup Color would be white in the moderator column? im sure this is simple just don't know what to put
yeah, I'd like this change too.

I also got a mysql error when I added a group of which several members were already moderators. It then listed them as moderators twice and when I removed one of the instances from the show all moderators page the error popped up. (although apparently it still removed them and the usergroup, so I just added the usergroup again)

cOuNtErFiET 04-16-2006 02:05 AM
ok i don't think anyone knows what to put to call the HTML markup color for a name...lol no one has answered another post that i have that has to do with this too...might have to ask on vb.com i guess?

redlabour 06-08-2006 03:49 PM
Will it work in the Future with vBulletin 3.6 ?

held 07-28-2006 07:33 AM
I was just starting to create this mod, because I feel it should be default in vBulletin.

But since you created it allready, I will install it

Thanks


All times are GMT. The time now is 05:16 AM.
Page 13 of 21 « First 31112 13 1415 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.01247 seconds
  • Memory Usage 1,740KB
  • 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_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