vb.org Archive
Page 4 of 6 « First 23 4 56
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

Jonathan Young 07-29-2006 10:05 PM
Is this problem still within 3.54? Looking to install it, but i won't if people are having problems. I also hope this is updated for 3.6.

cynix2 08-09-2006 09:29 PM
has anyone tested this out on 3.6?

redlabour 08-12-2006 03:29 PM
Quote:
Originally Posted by cynix2
has anyone tested this out on 3.6?
Works perfect - Thread can moved to 3.6 Section ! ;)

Slyfox1 08-14-2006 07:26 AM
Quote:
Originally Posted by redlabour
Works perfect - Thread can moved to 3.6 Section ! ;)
I installed this on 3.6 and it all seems to work fine, except I get "Usergroup Moderator" in normal link colour apposed to displaying the people within the group? orjust reading the group name and the colour assoaiated?

Ideas?

JohnBee 10-20-2006 02:40 AM
Great hack.

I have a question, my forum home moderator column is not equal in width when different length of group names appear between forums. It's purely cosmetic but kinda of annoying because on a fluid layout the columns are all off between the forum sections.

I wish there was a way to lock down a width, based on the longest usergroup name that way the forum layout would be evenly distributed.

Any chance this could be implemented?

Makc666 10-31-2006 10:00 PM
Quote:
Originally Posted by JohnBee
Great hack.

I have a question, my forum home moderator column is not equal in width when different length of group names appear between forums. It's purely cosmetic but kinda of annoying because on a fluid layout the columns are all off between the forum sections.

I wish there was a way to lock down a width, based on the longest usergroup name that way the forum layout would be evenly distributed.

Any chance this could be implemented?
Can you please post a screenshot about what you are speaking about.
thanks

JohnBee 11-01-2006 09:48 AM
Is it possible to remove the , separator between the usergroups in the forumhome?

Been Told 11-17-2006 08:37 PM
I can't believe this is not a standard feature of vB! A fantastic and hugely usefull mod. Works like a charm.
Thank you so very much!

Edit: I run a 3.6.3 board in case anyone wonders about compatibility with the newest version of vB.

Binoy 12-17-2006 12:24 AM
any updates for this hack for 3.6.x???

CouchMonkey 12-27-2006 06:45 PM
Yeah, I am using this for 3.6.4 with only one problem. The moderator section just runs off the page if you have several moderators.

Please see the attached Image.

Any help would be appreciated.

CouchMonkey 12-27-2006 06:57 PM
Nevermind, I am an idiot. Please forget that last comment.

Great hack :)

Sres 01-25-2007 08:13 AM
This is fantastic! Installed :)

taheri6 01-28-2007 07:17 AM
Quote:
Originally Posted by CouchMonkey (Post 1145958)
Nevermind, I am an idiot. Please forget that last comment.

Great hack :)

I have this same problem after first install and adding two usergroups as moderators, the Administrators and a custom secondary usergroup.

How do I fix it?

they show up as

Quote:
amin.taheriSmokey, MeowDumbAssDucky, TreeSyke o_OVery Very GoodLV8BallSiK WiT iTt0ggLeDashSKSShane$coobNoWeeWee
Sometimes the comma gets placed, and the majority of the time it doesnt.

Slyfox1 01-28-2007 11:34 PM
It would be nice if the MOD would pick up the colour associated to the group being assigned and display it where applicable.

Sly

kellogs 08-25-2007 06:19 AM
does it work with 3.6.8?

TigerWare 08-26-2007 06:46 AM
Quote:
Originally Posted by kellogs (Post 1325272)
does it work with 3.6.8?
Yes, I have it installed on 3.6.8 and it works fine. :up:

PinkDaisy 09-05-2007 12:03 PM
This doesn't show up for me. All my settings in ACP are right and so forth, but not showing up in my moderator column.

Alfa1 09-05-2007 01:18 PM
Can others confirm that this doesn't show up in the moderator column? That would be just what I need!

Edit: never mind I found it. You forgot to apply the template edits.

lostgirl815 09-08-2007 09:17 PM
A great mod - thanks! I looked for this forever, so I'm bumping it.

majorxp 11-01-2007 05:40 AM
Brilliant! Thanks!

SBlueman 12-15-2007 06:07 PM
Quote:
Originally Posted by Slyfox1 (Post 1169390)
It would be nice if the MOD would pick up the colour associated to the group being assigned and display it where applicable.

Sly
Does anyone know how to do this? I'd like this to display like this:

Usergroup Name

instead of

Usergroup Name

on my site.

SBlueman 12-22-2007 05:41 PM
Quote:
Originally Posted by SBlueman (Post 1401687)
Does anyone know how to do this? I'd like this to display like this:

Usergroup Name

instead of

Usergroup Name

on my site.
Anyone?

redlabour 01-29-2008 04:57 PM
Does it still work in 3.7?

Andreas 01-29-2008 05:01 PM
It should. Let me know if it does not and i'll take a look at what is needed to make it compatible.

Abe1 01-31-2008 01:29 AM
Works for me.

jluerken 02-04-2008 11:27 AM
Hi Andreas,

I have a small issue with this hack.
If you add more than one group to the list of moderators, only one is shown in the moderator column.

Can you please check this? (vBulletin 3.7 beta4)

Kind regards
jluerken

Mephisteus 02-04-2008 11:39 AM
Andreas, whilst I respect that you don't re-release this for every vB version out there you might want to at least say it works in 3.6 and 3.7 in the first post ;) Plenty of hacks don't and it's a shame to just see this one lumped in with that category while it does work :p

Andreas 02-18-2008 09:10 AM
@jluerken
I guess I never thought there could be several usergroups fo one forum ;)
This is a bug that needs to be fixed.
If a fixed version isn't available within 2 weeks from now, please remind me via PM on vBGo.

Spoiler 02-20-2008 02:46 PM
Hi,

is it possible to make the moderatorgroup available for the calenders?
I have a group, that only have to moderate a calender so that would be very nice.

redlabour 04-23-2008 11:24 AM
Quote:
Originally Posted by Andreas (Post 1445792)
@jluerken
I guess I never thought there could be several usergroups fo one forum ;)
This is a bug that needs to be fixed.
If a fixed version isn't available within 2 weeks from now, please remind me via PM on vBGo.
Done :)


All times are GMT. The time now is 04:59 AM.
Page 4 of 6 « First 23 4 56
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.01310 seconds
  • Memory Usage 1,819KB
  • 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
  • (12)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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