[ShadowRanger]

Hello there,

So I have some groups set up for my server with SourceMod using MySQL for saving all the data. The groups have been created and are added to the sm_groups table. But my question is, how do I actually add players to each group? I know how to do it with it for flatfile storage, but for MySQL I have no idea and can't find any info about it. Any ideas?

[DarkDeviL]

It's all documented in the wiki @ SQL Admins (SourceMod):

In "sm_admins", you have:

id=1
name=ShadowRanger
[...]

In sm_groups, you have:

id=1
flags=a
name=Moderator

id=2
flags=z
name=Root

You want to add admin id 1 (ShadowRanger) to the "Root" group (id 2), then in table sm_admins_groups, you add the admin id and group id connection, e.g.:

admin_id=1
group_id=2

-> sm_admins
-> sm_groups
-> sm_admins_groups

[ShadowRanger]

Originally Posted by arne1288 It's all documented in the wiki @ SQL Admins (SourceMod): In "sm_admins", you have: id=1 name=ShadowRanger [...] In sm_groups, you have: id=1 flags=a name=Moderator id=2 flags=z name=Root You want to add admin id 1 (ShadowRanger) to the "Root" group (id 2), then in table sm_admins_groups, you add the admin id and group id connection, e.g.: admin_id=1 group_id=2 -> sm_admins -> sm_groups -> sm_admins_groups

Thank you for the reply, I understand now. One more question though, is there a command that I can use to do this, or do I need to do the MySQL queries myself? I can't find any.

[DarkDeviL]

Originally Posted by ShadowRanger One more question though, is there a command that I can use to do this, or do I need to do the MySQL queries myself? I can't find any.

There is also included a separate plugin providing those that using commands, which you can also load if you want to.

Both the plugin as well as the commands are all documented in the link above.