[xines]

Simple Mysql Whitelist
Mysql database whitelister to control player access to server[s].

Currently Tested [CSS][CS:GO]

Description:

Spoiler

As i've seen some "Advanced" and "old/outdated" mysql whitelist's i decided to rewrite one more Simple yet functional whitelist to today's standards including all code being written in SourcePawn Transitional Syntax.

Plugin used as Base: https://forums.alliedmods.net/showthread.php?t=162859

Requirements:

• A mysql database (obviously)

Ingame Commands:

• All Ingame commands including menu requires Admin-Root access.

• sm_whitelist Opens the menu to list/remove
• sm_whitelist_add Add a steamid to the database.
• sm_whitelist_delete Deletes a steamid from the database.
• sm_whitelist_list List all SteamIDs in the database.

Server Commands:

• sm_server_whitelist_add Add a steamid to the database. Useable by Rcon or Console
• sm_server_whitelist_delete Deletes a steamid from the database. Useable by Rcon or Console

Cvars:

• sm_whitelist_adminflag "0" Admin flag required [a -> z] [0 = OFF].

Installation:

Spoiler

Step 1. Throw the compiled smx into plugins folder.

Step 2. Head to your addons\sourcemod\configs\databases.cfg and put the below with correct information.

"whitelister" //do not change this name
{
	"driver"			"mysql"
	"host"				"Your hostname here"
	"database"			"mysql_whitelist" //Database table name here
	"user"				"Username here"
	"pass"				"Password here"
}

Step 3.
Once everything is set, you'll have to add yourself to the database,
this is done either by using:
1. Server command called sm_server_whitelist_add by console/rcon.
2. Or by going to your mysql database name, then click it, and click the database table name, then you'll see a "insert" button click this, now you'll see a box where you simply put your steam2 id, they look like this STEAM_0:0:12345678 Then you click "GO"

Then your done and ready to load up the server and connect! From there you can add steamids by being ingame straight to the database.

Changelog:

1.0 - Plugin release
1.1 - Added flags support and minor code edits.
1.2 - Added bots to be allowed!
1.3 - New method for faster player kick.
1.4 - Threaded queries been updated for safer use.
1.5 - Added ServerCommands, Optimized mysql and fixed reported bugs.

[Addicted.]

Nice plugin. Can confirm this works on CS:GO.

[sneaK]

Very nice!

Feature request: Can you add flag support? For example, I would like everyone in the MySQL database to be able to connect to the server, but also users with the A flag.

[xines]

Originally Posted by oaaron99 Nice plugin. Can confirm this works on CS:GO.

Thank you, good to know added to tested list!

Originally Posted by blackhawk74 Very nice! Feature request: Can you add flag support? For example, I would like everyone in the MySQL database to be able to connect to the server, but also users with the A flag.

Thank you
By default everyone is not allowed to get into the server, that's why you whitelist them in.

Flags can be added, tho it will require me to take down function OnClientAuthorized and replace with OnClientPostAdminCheck, this will slow down the auto kick speed when not allowed into the server.
Done

[Addicted.]

Originally Posted by xines Flags can be added, tho it will require me to take down function OnClientAuthorized and replace with OnClientPostAdminCheck, this will slow down the auto kick speed when not allowed into the server.

Well you can make it so that if a flag is set then it will use OnClientPostAdminCheck and if not, use OnClientAuthorized

[Potato Uno]

IIRC doing it beyond OnClientAuthorized will kick the client AFTER they have downloaded the map, if any.

If you want to kick them before they download the map, use OnClientAuthorized. There is also a way to get admin flags from a plain steam ID (forgot how).

[xines]

Originally Posted by oaaron99 Well you can make it so that if a flag is set then it will use OnClientPostAdminCheck and if not, use OnClientAuthorized

Yeah very possible with a global variable, but it's no big deal as the client never gets into the server before OnClientPostAdminCheck have been fired .

Originally Posted by Potato Uno IIRC doing it beyond OnClientAuthorized will kick the client AFTER they have downloaded the map, if any. If you want to kick them before they download the map, use OnClientAuthorized. There is also a way to get admin flags from a plain steam ID (forgot how).

Yes sounds about right, however, the SteamID would require i think GetUserFlagBits function, and there's been more than enough information about why not to use this, so for now OnClientPostAdminCheck is the right option to choose.

[Potato Uno]

I found the relevant code. Feel free to use it if you want:

PHP Code:

public void OnClientAuthorized(int iClient, const char[] SteamID)
{
    AdminId Admin = FindAdminByIdentity(AUTHMETHOD_STEAM, SteamID);
    if (!GetAdminFlag(Admin, Admin_Custom1)) // change flag to whatever
        KickClient(iClient, "reason here");
} 


[xines]

Originally Posted by Potato Uno I found the relevant code. Feel free to use it if you want: PHP Code: public void OnClientAuthorized(int iClient, const char[] SteamID) {     AdminId Admin = FindAdminByIdentity(AUTHMETHOD_STEAM, SteamID);     if (!GetAdminFlag(Admin, Admin_Custom1)) // change flag to whatever         KickClient(iClient, "reason here"); }

Looks good, however, i'm unsure of this method due to asherkins answer here: https://forums.alliedmods.net/showthread.php?t=97165 I would need his opinion about this .

[Potato Uno]

Asherkin uses it himself in his connect extension's plugin.

You can still bolt a second check in postadmin to be super safe.

I use that code to prevent non-admins from getting into a server and it never failed me.