View Single Post
Author Message
GoldTreeServers
Senior Member
Join Date: Dec 2012
Old 11-29-2013 , 11:06   Database problem
Reply With Quote #1

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:hTimerany: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(clientszSteamIdsizeof(szSteamId));
        
        if (
GetTrieValue(g_hPointsszSteamIdplayerExp[client]))
        {
            
SetTrieString(g_hPointsszSteamIdexperience[0]);
            
            
decl String:szQuery[512];
            
SQL_EscapeString(hDatabaseexperience[0], experience[0], sizeof(experience));
            
SQL_EscapeString(hDatabaseszSteamIdszSteamIdsizeof(szSteamId));
            
FormatEx(szQuerysizeof(szQuery), "UPDATE ActivityPoints SET points = '%s' WHERE `steamid` LIKE '%s'"experience[0], szSteamId);
        }
        
        
PrintToChat(clientexperience);
        
playerExp[client] = playerExp[client] + experience[0];
        
        
CreateTimer(60.0CheckActivityclient);
        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;
                }
            }
        }
    }

GoldTreeServers is offline