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;
}
}
}
}
}