[vijayar]

Changed database name. Recomplied the scriptfile provided with latest sourcemod. Getting this error

L 06/18/2021 - 12:004: [SM] Exception reported: Invalid database Handle 0 (error: 4)
L 06/18/2021 - 12:004: [SM] Blaming: simple_mysql_whitelister.smx
L 06/18/2021 - 12:004: [SM] Call stack trace:
L 06/18/2021 - 12:004: [SM] [0] Database.Query
L 06/18/2021 - 12:004: [SM] [1] Line 417, simple_mysql_whitelister.sp::Server_Command_A dd

[vijayar]

Originally Posted by vijayar Changed database name. Recomplied the scriptfile provided with latest sourcemod. Getting this error L 06/18/2021 - 12:004: [SM] Exception reported: Invalid database Handle 0 (error: 4) L 06/18/2021 - 12:004: [SM] Blaming: simple_mysql_whitelister.smx L 06/18/2021 - 12:004: [SM] Call stack trace: L 06/18/2021 - 12:004: [SM] [0] Database.Query L 06/18/2021 - 12:004: [SM] [1] Line 417, simple_mysql_whitelister.sp::Server_Command_A dd

Figured out that the above message comes when you try to add/delete a Steam ID just after the server has started and the first user has not joined. Join the server either as admin or as normal user once and post that the server commands works.

Further the issue pertaining to STEAM_0: and ingame STEAM_1: has been resolved thanks to Bacardi who shared the method wherein the first 8 characters in the Steam are ignored. Now you can store the Steam ID in its regular form i.e STEAM_0:0:123456.

Find attached the modified script.

[Ryan2]

No need to worry about MySQL injection etc because it just gets players STEAMID, correct? Just thought I'd ask.

[vijayar]

Originally Posted by Ryan2 No need to worry about MySQL injection etc because it just gets players STEAMID, correct? Just thought I'd ask.

Didn't understand your query. This plugin allows you to add & manage Steam ID you want to whitelist on the server, manually through console or admin account in server. You can also insert the Steam ID directly into the mysql database.

[Teamkiller324]

Using OnClientConnect would be instant kick as it's fired before player_connect but could be too early to call the steamid, you could possibly use event player_connect or OnClientConnected otherwise since you can get the steamid there, these are called before OnClientAuthorized.

Here's a slight change in code.