4images Forum & Community

4images Issues / Ausgaben => Discussion & Troubleshooting => Topic started by: tansamalaja on November 15, 2006, 10:44:39 AM

Title: Adding a big number of users to a usergroup
Post by: tansamalaja on November 15, 2006, 10:44:39 AM

How can I add 1500 Users to a usergroup without doing it for every single User?

I searched mysql but I didn't find the option to refer the usergroup-id to the user-id...

Can anybody help?

Title: Re: Adding a big number of users to a usergroup
Post by: Acidgod on November 15, 2006, 06:30:49 PM

How many Users do you have in the DB?

Title: Re: Adding a big number of users to a usergroup
Post by: tansamalaja on November 15, 2006, 09:40:35 PM

1500

Title: Re: Adding a big number of users to a usergroup
Post by: mawenzi on November 15, 2006, 10:32:04 PM

... all users in one usergroup ...  :roll:
... and that makes sense ...

Title: Re: Adding a big number of users to a usergroup
Post by: tansamalaja on November 16, 2006, 10:35:12 AM

Very funny, we have our reasons and they are completely logical.

Everybody is then in the Usergroup "Comments allowed" and when he makes silly comments or Spam we delete his membership in this usergroup and he can't comment anymore but he can still upload and view pics...

Makes very much sense or not?

There is apparently no other possibility to control single user.

So please, can anybody give me a hint how I can manage this with a sql querie and not user by user...