[MatoBoost]

Hi, I need a plugin that is able to take STEAMID from MySQL database and assign flag A to it (basically simplest VIP plugin available).
Game is CS:GO.

No need for configuration files, no need to put database into databases.cfg, keep it simplest as possible.

I can put MySQL database info into plugin by myself, just please make it obvious where should I put what .

If needed I can pay for it, but I suppose it wont be expensive since it SHOULD be simple.

[nhnkl159]

https://forums.alliedmods.net/showthread.php?t=292183

check out this.

[MatoBoost]

Originally Posted by nhnkl159 https://forums.alliedmods.net/showthread.php?t=292183 check out this.

I already found it, but there are tons of things that I dont need. We are going to have everything completely automated through MySQL and stuff, so all what I need is plugin that can take STEAMID from MySQL database.

[Mr.Freeman]

Just use SELECT and WHERE when your where is the players steam id, however you stored it (AuthId_Steam2, AuthId_Steam3, etc.)

[headline]

Originally Posted by MatoBoost No need for configuration files, no need to put database into databases.cfg, keep it simplest as possible. I can put MySQL database info into plugin by myself, just please make it obvious where should I put what .

This is bad practice. We've seen plenty of db credentials hard-coded into plugin binaries that have been dumped publicly, and there's reasons as to why DB info is stored in databases.cfg.

Edit: If you tell me your table name, and steamid column name for your database I'll make you this plugin and post it for you here on the forums. All I'd ask is that you donate a few bucks to alliedmodders using the donation button at the top right

[MatoBoost]

Originally Posted by Headline This is bad practice. We've seen plenty of db credentials hard-coded into plugin binaries that have been dumped publicly, and there's reasons as to why DB info is stored in databases.cfg. Edit: If you tell me your table name, and steamid column name for your database I'll make you this plugin and post it for you here on the forums. All I'd ask is that you donate a few bucks to alliedmodders using the donation button at the top right

I wanted it as simple as possible, so I thought it will be harder to make it read from databases.cfg, that's why wanted it "hardcoded".

Now the "problem" is that it's not me who wants a plugin like this but it's my friend, he is just not that good in English so that is why I am writing this. Thing is that it depends on him if he is willing to donate a few bucks to AlliedModders for a plugin, I asked ESKO about it and he wanted 15 euros lol. Anyway if he is willing to donate I will reply here, if not I will just close the thread.

[Mr.Freeman]

Would you like someone to just write a generic one in which you can edit the table names?

[DJ Tsunami]

Why not just use the generic one that comes with SourceMod: SQL Admins

[sim242]

Originally Posted by DJ Tsunami Why not just use the generic one that comes with SourceMod: SQL Admins

^ This. Surely the easiest approach would be to use the default SQL_Admins plugin to store admins in a database like Tsunami said and then a small custom plugin that connects to the same database and adds anything you want to add automatically.

[MatoBoost]

Originally Posted by sim242 ^ This. Surely the easiest approach would be to use the default SQL_Admins plugin to store admins in a database like Tsunami said and then a small custom plugin that connects to the same database and adds anything you want to add automatically.

This actually includes everything what we need and nothing more! I will just edit the name of database in the plugin (just for our databases.cfg so we will know exactly what is it) and we are good to go! Thanks for this information!