[nismoskyline86]

I need a very simple plugin, it will check a database for values such as flags, and then apply the admin flag to that steamID. preferably with adjustable query settings and it would need to run along side sourcebans but be a separate system.

Essentially we have way to many VIPs and we want to take them out of sourcebans and just store them in a database for the server to reference every cycle.

Does this exist? or would this be something I would need to have custom made?

Thank you in advance guys!

[minimoney1]

if I understand correctly, then yes.
It's already in SM, in the disabled folder.
You go to configs/sql-init-scripts\mysq\create_admins.sql
Import that into your desired MySQL database, then move the plugin
sql-admin-manager.smx
from the disabled folder to the plugins folder.
Then set up a database configuration in databases.cfg as either "admins" or just in the "default" one, and that should be all, you can either modify the database manually to add admins (VIPs in this case) or you can use these commands:
sm_sql_addadmin
sm_sql_deladmin
sm_sql_addgroup
sm_sql_delgroup
sm_sql_setadmingroups
You might also want to take a look at Sourcemod Webadmin:
http://forums.alliedmods.net/showthread.php?t=60174

[nismoskyline86]

and this wont interfere with sourcebans?

[minimoney1]

It should not, I'm not exactly sure though.

[recon0]

EDIT: See the next two posts.

It should work fine. Make sure you don't have *ANY* flat file admin plugins enabled, or you may have issues as the plugins race each other to update the files.

Note that SourceBans has an option to backup configs locally. Make sure you turn that OFF.

[Dr. McKay]

Originally Posted by recon0 It should work fine. Make sure you don't have *ANY* flat file admin plugins enabled, or you may have issues as the plugins race each other to update the files. Note that SourceBans has an option to backup configs locally. Make sure you turn that OFF.

I'm using SourceBans with the backup configs option enabled, admins-flatfile, and admins-sql, and it's working fine...

[recon0]

Originally Posted by Dr. McKay I'm using SourceBans with the backup configs option enabled, admins-flatfile, and admins-sql, and it's working fine...

Yeah. On second thought, only SourceBans writes to the files, so it'd be fine.