[GoldTreeServers]

Hello. I try update players activity points but not updating :/ IDK how to do it but I try something

PHP Code:

public Action:CheckActivity(Handle:hTimer, any:client)
{
    if(GetConVarInt(cvar_enable))
    {
        decl String:szSteamId[64], String:experience[1];
        new Float:Activity = playerActicity[client] / 10.0;
        new Float:ActivityTotal = (Activity * 1);
        experience[0] = RoundToNearest(Float:ActivityTotal);
        
        GetClientAuthString(client, szSteamId, sizeof(szSteamId));
        
        if (GetTrieValue(g_hPoints, szSteamId, playerExp[client]))
        {
            SetTrieString(g_hPoints, szSteamId, experience[0]);
            
            decl String:szQuery[512];
            SQL_EscapeString(hDatabase, experience[0], experience[0], sizeof(experience));
            SQL_EscapeString(hDatabase, szSteamId, szSteamId, sizeof(szSteamId));
            FormatEx(szQuery, sizeof(szQuery), "UPDATE ActivityPoints SET points = '%s' WHERE `steamid` LIKE '%s'", experience[0], szSteamId);
        }
        
        PrintToChat(client, experience);
        playerExp[client] = playerExp[client] + experience[0];
        
        CreateTimer(60.0, CheckActivity, client);
        if(!(playerActicity[client] <= 0) && playerActicity[client] >= 25)
        {
            playerActicity[client] -= 25;
        }
        else
        {
            if(!(playerActicity[client] <= 0) && playerActicity[client] >= 10)
            {
                playerActicity[client] -= 10;
            }
            else
            {
                if(!(playerActicity[client] <= 0) && playerActicity[client] >= 0)
                {
                    playerActicity[client] = 0;
                }
            }
        }
    }
} 


[wyd3x]

LIKE '%s'

wt?
you need do:
WHERE 'steamid' = '%s' "), steamid

[asherkin]

You can't use the same buffer for input and output with SQL_EscapeString.

[GoldTreeServers]

Originally Posted by asherkin You can't use the same buffer for input and output with SQL_EscapeString.

What you mean?

[Bimbo1]

you have to create another string, empty, in order to store the output of sql_escapestring.

[Bimbo1]

well, it doesn't need to be empty. i hope you got the idea.