AlliedModders - [ASAM] Alternative SQL Admins Manager

ASAM 1.3 released

1. SQLite support added
2. DB-management plugin has separated to db-creation and db-management plugins.

[More detailed info]

Setup:
1. create db with admin-dbcreator.smx and remove this plugin after process ends (for reduse server load).
2. create all need groups, accounts and links (user-groups) with admin-manager.smx. we recommend to use this plugin at only ONE from your servers.
3. all servers must have sm_admin_filter variable (see 1.2 version readme for more detailed info)
4. most usable plugin: admin-connector.smx (threaded and utf8-resdy)

* * * * * *

[INFO about ASAM 1.2]
some as original plugins, there are two files:

admin-connector.sp
threaded, utf8-ready, connects to central mysql db for admins and rights.

admin-manager.sp
act as admin interface for work with admins accounts (add\del\change)

Basic changes of plugins:

1. MySQL support only, SQ-light support removed (for reduse plugin size)
2. All overrides from DB tables has removed.
3. Builtin code page for DB connection (native multilanguage UTF8 )
4. Multi server configuration support: single DB can contain all admins and groups with different rights for different servers.
5. Steam-only identification (for reduse plugin size)
6. The logic is simplified for rights management: rights, immunity and server group can be applied to groups only, not to admins.

Important: administrators MUST be a group members!

7. New CVar for server (put it to sourcemod.cfg) identification:

// Server Group Identity
// Can be any word, corresponding with word at database's server column. Empty by default.
sm_admin_filter

Warning: GROUP with not filled (empty) SERVER value is ALL SERVERS admins group. Members of this group can connect to ANY server.

Examples:

if not filled - all admins who members of group with "not filled" server value at db can obtain admins rights at this server, but nothing more.
csserver - all admins who members of group with "not filled" AND at group with "csserver" server value at db can obtain admins rights at this server.
ggserver - all admins who members of group with "not filled" AND at group with "ggserver" server value at db can obtain admins rights at this server.

Basic changes of DB scheme:

1. All override db tables has removed.
2. Groups immunity table (it sets to Groups directly now) has removed.
2. New column added: server for binding GROUP to SERVER (if you need split your admins to concrete servers)
(oops... we lost sv_config table, will be fixed asap)

Note: for initial creating tables at new database (bd must be created as UTF8 ), please use sm_create_adm_tables console command...

New syntax for plugins:

sm_sql_addadmin "ALIAS" "STEAM"
sm_sql_addgroup "GROUP" "RIGHTS" "IMMUNITY LEVEL" "SERVER"

Adding admins to groups:

For single group: sm_sql_setadmingroups "STEAM" "GROUP"
For multiple groups: sm_sql_setadmingroups "STEAM" "GROUP1" "GROUP2" "GROUP3" etc

- - - - - - - - - - - - -
Based on the original SQL plugins by AlliedModders LLC.
At rewrite process all (we hope) errors of plugin has been fixed.
Best regardz, AngelX.