[You9]

Hey, so i have system with SQL where i save money when player disconnect or change team (not spammable). But sometimes players lose their money when it's going to 0.

Database code what i use:

code

PHP Code:

public void GotDatabase(Handle owner, Handle hndl, char[] error, any data)
{
    if(hndl == INVALID_HANDLE)
        SetFailState("Database error: %s", error);
    
    statsDatabase = hndl;
}

void UpdateUserDatabase(int client)
{
    if (GameRules_GetProp("m_bWarmupPeriod") != 0)
        return;
        
    if (!IsValidClient(client))
        return;
        
    char kNimi[MAX_NAME_LENGTH], kNimi_Escape[2*sizeof kNimi+1], SteamID[48];
    GetClientName(client, kNimi, sizeof kNimi);
    SQL_EscapeString(statsDatabase, kNimi, kNimi_Escape, sizeof kNimi_Escape);
    GetClientAuthId(client, AuthId_Engine, SteamID, sizeof SteamID);
    DB_UserMoney[client] = GetClientMoney(client);
                
    //DB Query
    char db_query[255];
    Format(db_query, sizeof(db_query), "UPDATE `userStats` SET `Money` = '%i', `Lastly_Name` = '%s' WHERE `SteamID` = '%s';", DB_UserMoney[client], kNimi_Escape, SteamID);
    SQL_TQuery(statsDatabase, DB_CallbackEnd, db_query);
}

public void DB_CallbackEnd(Handle owner, Handle hndl, const char[] error, any data)
{
    if (hndl == INVALID_HANDLE)
        LogError("[SQL ERROR] %s", error);
} 


And it's not database loading problem, because i log query's. And there i can see when player gets 350$, and next disconnect somehow 0$.

[Drixevel]

Based on the code you've show, everything looks fine. One thing I do have to say is looking at what 'GetClientMoney' returns would probably be a good place to start with this issue.

[You9]

Originally Posted by redwerewolf Based on the code you've show, everything looks fine. One thing I do have to say is looking at what 'GetClientMoney' returns would probably be a good place to start with this issue.

'GetClientMoney' function:

PHP Code:

stock int GetClientMoney(int client) {
    return GetEntProp(client, Prop_Send, "m_iAccount");
} 


Weird is that, it's only sometimes make that bug.

[You9]

Is that possible, if player disconnect then game is already "removed" his money and return 0?