[Solved] How to ignore the first 8 Characters when comparing two STEAMID32

vijayar · **Author**

I need help in resolving a nagging issue in this plugin - https://forums.alliedmods.net/showthread.php?t=286965

This issue occurs due to the mismatch when comparing user with "STEAM_0:0:12345" that is stored in the database & when the same user joins CSGO server, the ID converts to "STEAM_1:0:12345", fails the database check.

I understand that STEAM_0 or STEAM_1 prefix depends on the game and also the first 8 characters of can be ignored, when comparing 2 STEAMID32.

Can someone help in resolving this.

Specifically need it in the part of script that compares connecting client to the mysql database

PHP Code:


			
//Checks if the SteamID is in the database, if not the player will get kicked.

public void SQL_CheckSteamID(Handle owner, DBResultSet results, const char[] error, any data)

{

    int client = GetClientOfUserId(data); 

    if (client == 0 || !IsClientConnected(client)) return; //connected check if not found do return

    if (results == null || strlen(error) > 0)

    {

        LogError("[Mysql-Whitelist] Query failed! %s", error);

        KickClient(client, "Authorization failed, please try again later.");

    }

    else if(results.RowCount == 0)

    {

        PrintToServer(client, "User ID in Database is: %d", GetClientOfUserId(userid)); 

        KickClient(client, "You are not allowed to join this server");

    }

}

Complete source code is attached FYI

little_froy · *Last edited by little_froy; 07-01-2021 at 10:13.*

try
strcmp(STEAMID1[8], STEAMID2[8])
it means compare start from the NINE (from 0 to 8 )character ↓
S T E A M _ 1 : 0 : 1 2 3 4 5
0 1 2 3 4 5 6 7 8

**Silvers** · *Last edited by Silvers; 07-02-2021 at 01:32.*

I guess the database contains the "STEAM_0:0:" part? would be more efficient and optimized to completely remove "STEAM_0:0:" from the database and skip saving that part, reading that part etc. Then you can query from SteamID[8] like little_froy mentioned. Maybe you can just query from SteamID[8] position anyway using a partial matching sql query like "%12345" or something.

Something like:

PHP Code:


			
Format(query, sizeof(query), "SELECT steamid FROM %s WHERE steamid = '\%%s'", DB_Name, isteamid[8]);

Don't know if % needs escaping or not, or maybe %%. Been a while since I used percent in format.

vijayar · *Last edited by vijayar; 07-02-2021 at 04:21.*

Quote:

Originally Posted by little_froy

try
strcmp(STEAMID1[8], STEAMID2[8])
it means compare start from the NINE (from 0 to 8 )character ↓
S T E A M _ 1 : 0 : 1 2 3 4 5
0 1 2 3 4 5 6 7 8

Thanks for your help, I did come across this command but not sure where in the script should I insert this.

vijayar · *Last edited by vijayar; 07-02-2021 at 04:24.*

Quote:

Originally Posted by Silvers

I guess the database contains the "STEAM_0:0:" part? would be more efficient and optimized to completely remove "STEAM_0:0:" from the database and skip saving that part, reading that part etc. Then you can query from SteamID[8] like little_froy mentioned. Maybe you can just query from SteamID[8] position anyway using a partial matching sql query like "%12345" or something.

Something like:

PHP Code:


			
Format(query, sizeof(query), "SELECT steamid FROM %s WHERE steamid = '\%%s'", DB_Name, isteamid[8]);

Don't know if % needs escaping or not, or maybe %%. Been a while since I used percent in format.

Thanks for your help, partial matching query did not work.

Somewhow this should have been a simple match and continue. Bit frustating that the plugin only works when stored with STEAM_1 prefix. Unfortunately the plugin dev has not sorted this out and has retired from sourcemod work

**Silvers**

Try putting it like '\%%s\%' maybe it needs % on either side of the query. Been a while since I used mysql.

vijayar · *Last edited by vijayar; 07-02-2021 at 11:41.*

Quote:

Originally Posted by Silvers

Try putting it like '\%%s\%' maybe it needs % on either side of the query. Been a while since I used mysql.

Didnt work. Just to clarify (I am sourcemod noob/beginner btw) I am changing it the two places where Format command is being used. NOt sure if i am doing the right stuff.

This is the part of the script where connecting client is checked if admin or in the database and then processed accordingly

PHP Code:


			
//Check Player Access First Check!
public void OnClientAuthorized(int client, const char[] SteamID)
{
    if (IsFakeClient(client)) return; //Allow bots to skip this check.
    AdminId Admin = FindAdminByIdentity(AUTHMETHOD_STEAM, SteamID);
    if (AdmFlag != 0 && GetAdminFlags(Admin, Access_Effective) & AdmFlag) return;

    //Start Checking
    //Send a check query to the database to see if the user is in the database.
    char query[256];
    Format(query, sizeof(query), "SELECT steamid FROM %s WHERE steamid = 's%'", DB_Name, SteamID);
    db.Query(SQL_CheckSteamID, query, GetClientUserId(client), DBPrio_High);
}

//Double Check our client, just incase person randomly somehow bypassed OnClientAuthorized check.
public void OnClientPostAdminCheck(int client)
{
    if (!IsValidClient(client) || IsFakeClient(client)) return;
    
    //Do Same check as in OnClientAuthorized, just different method.
    char isteamid[64];
    if(GetClientAuthId(client, AuthId_Steam2, isteamid, sizeof(isteamid)))
    {
        if(AdmFlag != 0 && CheckAdmFlag(client)) return; //If Admin with Adm flag, Skip check.

        //Start Checking
        //Send a check query to the database to see if the user is in the database.
        char query[256];
        Format(query, sizeof(query), "SELECT steamid FROM %s WHERE steamid = 's%'", DB_Name, isteamid);
        db.Query(SQL_CheckSteamID, query, GetClientUserId(client), DBPrio_High);
    }
    else KickClient(client, "Please retry connecting!"); //Tell clients to retry.
}

//Checks if the SteamID is in the database, if not the player will get kicked.
public void SQL_CheckSteamID(Handle owner, DBResultSet results, const char[] error, any data)
{
    int client = GetClientOfUserId(data); 
    if (client == 0 || !IsClientConnected(client)) return; //connected check if not found do return
    if (results == null || strlen(error) > 0)
    {
        LogError("[Mysql-Whitelist] Query failed! %s", error);
        KickClient(client, "Authorization failed, please try again later.");
    }
    else if(results.RowCount == 0)
    {
        //PrintToServer(client, "User ID in Database is: %d", GetClientOfUserId(userid)); 
        KickClient(client, "You are not allowed to join this server");
    }
}

**Silvers**

Change 's%' to '\%%s\%'

Bacardi · *Last edited by Bacardi; 07-04-2021 at 11:22.*

Not 100% sure, haven't tested
https://www.w3schools.com/sql/sql_like.asp

Code:

if string is like this, isteamid[8]

"SELECT steamid FROM %s WHERE steamid LIKE '\%%s'" // Is like %1:12345

or

"SELECT steamid FROM %s WHERE steamid LIKE '________%s'" // Is like ________1:12345

vijayar

Quote:

Originally Posted by Bacardi

Not 100% sure, haven't tested
https://www.w3schools.com/sql/sql_like.asp

[code]
if string is like this, isteamid[8]

"SELECT steamid FROM %s WHERE steamid LIKE '\%%s'" // Is like %1:12345

or

"SELECT steamid FROM %s WHERE steamid LIKE '________%s'" // Is like ________1:12345

Thank you so much ! this worked!!!

PHP Code:


			
"SELECT steamid FROM %s WHERE steamid LIKE '________%s'"