hello.
i have this code:
PHP Code:
public client_putinserver(id)
{
insert_new_player(id)
}
public insert_new_player(id)
{
new Data[1]
Data[0] = id
new szTemp[512]
format(szTemp,charsmax(szTemp),"SELECT * FROM `%s` WHERE (`name` = '%s')", g_szONPlayer_Table, g_iPlayersInfo[id][Name])
SQL_ThreadQuery(g_SqlTuple,"register_client",szTemp,Data,1)
}
public register_client(FailState,Handle:Query,Error[],Errcode,Data[],DataSize)
{
if(FailState == TQUERY_CONNECT_FAILED)
{
log_amx("[Advanced Panel] Could not connect to SQL database. [%d] %s", Errcode, Error)
}
else if(FailState == TQUERY_QUERY_FAILED)
{
log_amx("[Advanced Panel] Load Query failed. [%d] %s", Errcode, Error)
}
new id
id = Data[0]
if(SQL_NumResults(Query) < 1)
{
for(new i = 0; i < DATA; i++)
{
if (equal(g_iPlayersInfo[id][i] ,"ID_PENDING"))
return PLUGIN_HANDLED
}
new szTemp[1024]
//get_users_info()
format(szTemp, charsmax(szTemp), "INSERT INTO `%s` ( `name` , `ip` , `steamid` , `frags` , `deaths`) VALUES ( `%s` , `%s` , `%s` , `%d` , `%d`)", g_szONPlayer_Table, g_iPlayersInfo[id][Name], g_iPlayersInfo[id][Address], g_iPlayersInfo[id][AuthID], g_iPlayersInfo[id][Frags], g_iPlayersInfo[id][Deaths])
SQL_ThreadQuery(g_SqlTuple,"IgnoreHandle",szTemp)
}
else
{
server_print("[Advanced Panel] Error sending data in table %s", g_szONPlayer_Table)
}
return PLUGIN_CONTINUE
}
but i get this error in console
Code:
L 05/03/2021 - 20:09:00: [MySQL] Function not found: IgnoreHandle
L 05/03/2021 - 20:09:00: [AMXX] Displaying debug trace (plugin "panel.amxx", version "1.0")
L 05/03/2021 - 20:09:00: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
L 05/03/2021 - 20:09:00: [AMXX] [0] panel.sma::register_client (line 430)
i m trying to get info about all connected players and put it in a database to create a panel, but i can't save.
some ideas?