[MistaGee]

Hi,

I've extended the SQL admin scripts (both prefetch and threaded) to load admin groups by Server IP.

Before going into greater detail, I'm well aware that SourceBans does provide exactly this functionality, but I think it's somewhat overkill to install SourceBans _only_ for this, so I've modified their code to work with the standard admin plugins.

To use this, you need to have the following tables (aside the standard SourceMod tables) in your databases:

1. sm_servers:
   • id INT PRIMARY KEY
   • ip VARCHAR(15)
   • port INT
2. sm_servers_groups
   • server_id INT
   • group_id INT

To add an admin to one certain server, you need to do the following:

1. Create an admin group entry in sm_groups.
2. Create a server entry in sm_servers, that lists the server in question.
3. Link the group to the server(s) by entering the corresponding IDs to sm_servers_groups.
4. Add the admin to the group by entering their IDs into sm_admins_groups.
5. Give the group(!) all the permissions you want the user to have on this server.

In general, you need to change your Admin management to be group based to take full advantage of this. Admins will inherit their rights from the groups they are in, and what groups exist now depends on the server you're playing on.

If you want an Admin to have the same rights on every server, you don't need to put them into any groups, you just give them the rights they should have in sm_admins and that's it.

Regards
MistaGee

[HSFighter]

Excellent job MistaGee

I add this settings optional to the next relase of Sourcemod-Webadmin.
My planning for the multi-server support for SQL-Admins is no longer necessary yet.

If you want an Admin to have the same rights on every server, you don't need to put them into any groups, you just give them the rights they should have in sm_admins and that's it.

When i doun't add an group to "sm_servers_groups", has the group rights on every server?

Suggestion to the SM Development:
It will be nice to include this plugins in the SourceMod 1.2 Branch.

Regards
HSFighter

[MistaGee]

Originally Posted by HSFighter Excellent job MistaGee

Thanks

Originally Posted by HSFighter When i doun't add an group to "sm_servers_groups", has the group rights on every server?

No, Groups only exist on the servers they're linked to in sm_servers_groups. If they're not linked to any server, they won't exist on any.

Originally Posted by HSFighter Suggestion to the SM Development: It will be nice to include this plugins in the SourceMod 1.2 Branch.

Good point - A plugin of mine is already included in AMXmodX, but I still need one for SourceMod

Regards
MistaGee

[HSFighter]

The Sourcemod Webadmin supporting now this Plugin:

Originally Posted by HSFighter The necessary SQL-Tables will be create if you install or update to Sourcemod-Webadmin v2.0 or higher! You need to replace the "admin-sql-prefetch.smx" or "admin-sql-threaded.smx" plugin. If you doun't use SQL-Admins before, you need to install the "sql-admin-manager.smx" plugin to. This plugin is include with sourcemod packet. To activate the plugin-options in the webinterface enable the "Servergroups" in the "Interface" --> "Settings" menue.

[Undead46]

I do have a question, do I need to modify/add any tables? Or will the plugin do it for me?

[MistaGee]

the plugin doesn't do the initialization itself, so you will have to do this manually.

[Undead46]

What's the SQL I need to query then?

[MistaGee]

For MySQL, that would be:

CREATE TABLE `sm_servers` (
  `id` int(11) NOT NULL auto_increment,
  `ip` varchar(15) NOT NULL,
  `port` int(11) NOT NULL,
  `name` varchar(200) default NULL,
  PRIMARY KEY  (`id`)
);

CREATE TABLE `sm_servers_groups` (
  `server_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY  (`server_id`,`group_id`)
);

Hope that helps.

[el_matador]

where is the difference between threaded and prefetched plugin?

[Jumpman]

That im not understand MistaGee

In your first post you write this

sm_servers:

• id INT PRIMARY KEY
• ip VARCHAR(15)
• port INT

In your last post you write mysql sting should be

CREATE TABLE `sm_servers` (
`id` int(11) NOT NULL auto_increment,
`ip` varchar(15) NOT NULL,
`port` int(11) NOT NULL,
`name` varchar(200) default NULL,
PRIMARY KEY (`id`)
);

What to use the last post have one more table "name" should i use your first post or the last post ?