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