[lexzor]

PHP Code:

public client_putinserver(id)
{
    if (is_user_bot(id) || is_user_hltv(id) || !is_user_connected(id))
        return 

    g_iPlayedTime[id][Seconds] = 0
    g_iPlayedTime[id][Minutes] = 0
    g_iPlayedTime[id][Hours] = 0

    get_users_info(id)

    check_player_sql_info(id)
}

public check_player_sql_info(id)
{
    new szQuery[512], szData[1]
    szData[0] = id

    get_users_info(id)

    formatex(szQuery, charsmax(szQuery), "SELECT * FROM `%s` WHERE `name` = '%s'", g_szTables[5], g_iPlayersInfo[id][Name])
    SQL_ThreadQuery(g_SqlTuple, "GetPlayerData", szQuery, szData, 1)
}

public GetPlayerData(FailState, Handle:Query, szError[], ErrorCode, szData[], iSize)
{
    if(FailState || ErrorCode)
    {
        server_print(" ")
        server_print("[Advanced Panel] SQL ERROR: %s", szError)
        server_print(" ")
    }

    new id = szData[0]
    new szQuery[512]

    mysql_escape_string(g_iPlayersInfo[id][Name], charsmax(g_iPlayersInfo[][Name]))

    get_users_info(id)
    format_lastvisit_string(id)

    if(SQL_NumResults(Query) < 1)
    {
        copy(g_iPlayersInfo[id][LastVisit], charsmax(g_iPlayersInfo[][LastVisit]), g_iPlayersInfo[id][FirstSeen])

        formatex(szQuery, charsmax(szQuery), "INSERT INTO `%s` ( `name`,`ipaddress`,`steamid`,`frags`,`deaths`,`headshots`,`score`,`firstseen`,`lastvisit`,`total_played_time` ) VALUES ( '%s','%s','%s','0','0','0','0','%s','%s','00:00:00' )", 
        g_szTables[5], g_iPlayersInfo[id][Name], g_iPlayersInfo[id][Address], g_iPlayersInfo[id][AuthID], g_iPlayersInfo[id][FirstSeen], g_iPlayersInfo[id][LastVisit])

        SQL_ThreadQuery(g_SqlTuple, "FreeHandle", szQuery)
    }
    else 
    {
        formatex(szQuery, charsmax(szQuery), "UPDATE `%s` SET `lastvisit` = '%s'", g_szTables[5], g_iPlayersInfo[id][LastVisit])
        SQL_ThreadQuery(g_SqlTuple, "FreeHandle", szQuery)
    }
}

public FreeHandle(FailState, Handle:Query, szError[], ErrorCode, szData[], iSize)
{
    if(FailState || ErrorCode)
    {
        server_print(" ")
        server_print("[Advanced Panel] SQL ERROR: %s", szError)
        server_print(" ")
    }
    
    SQL_FreeHandle(Query);
} 


i read a topic where bugsy say this is not a code problem is a sqlx socket problem or smth like this and i was thinking that i don t need to post code and there is a simple solution like create a set_task for every id.

anyway, if you have any advices to improve the code tell me how