Please help with query
g_i_PlayerID[id] = 116
PHP Code:
public Get_User_Group(FailState,Handle:Query,Error[],Errcode,Data[],DataSize)
{
if(FailState == TQUERY_CONNECT_FAILED)
return set_fail_state("Error connect MySql")
else if(FailState == TQUERY_QUERY_FAILED)
return set_fail_state("Error Query.")
if(Errcode)
return log_amx("Error MySql: %s",Error)
new id
id = Data[0]
if(SQL_MoreResults(Query))
{
new s_Request[512]
g_i_PlayerGroup[id] = SQL_ReadResult(Query,0)
log_to_file(g_szLogFile, "13. Get Player Group g_i_PlayerGroup = %d", g_i_PlayerGroup[id])
if(g_i_PlayerGroup[id] == 2)
{
g_s_PlayerGroupName[id] = "User"
}
format(s_Request,charsmax(s_Request), "SELECT parent FROM w4die_community_msg WHERE from = '%d'",g_i_PlayerID[id])
SQL_ThreadQuery(g_SqlTuple,"Get_User_Group_Name",s_Request, Data, 1)
SQL_NextRow(Query)
}
SQL_FreeHandle(Query)
return PLUGIN_CONTINUE
}
public Get_User_Group_Name(FailState,Handle:Query,Error[],Errcode,Data[],DataSize)
{
if(FailState == TQUERY_CONNECT_FAILED)
return set_fail_state("Error connect MySql")
else if(FailState == TQUERY_QUERY_FAILED)
return set_fail_state("Error Query.")
if(Errcode)
return log_amx("Error MySql: %s",Error)
new id
id = Data[0]
if(SQL_MoreResults(Query))
{
g_i_Player_Message[id] = SQL_ReadResult(Query,0)
log_to_file(g_szLogFile, "14. Get user message g_i_Player_Message = %d", g_i_Player_Message[id])
SQL_NextRow(Query)
}
SQL_FreeHandle(Query)
return PLUGIN_CONTINUE
}
error_log
Code:
L 09/29/2011 - 17:56:19: Info (map "de_dust2") (file "addons/amxmodx/logs/error_20110929.log")
L 09/29/2011 - 17:56:19: [AMXX] Plugin ("sql_test.amxx") is setting itself as failed.
L 09/29/2011 - 17:56:19: [AMXX] Plugin says: Ошибка запроса.
L 09/29/2011 - 17:56:19: [AMXX] Displaying debug trace (plugin "sql_test.amxx")
L 09/29/2011 - 17:56:19: [AMXX] Run time error 1: forced exit
L 09/29/2011 - 17:56:19: [AMXX] [0] sql_test.sma::Get_User_Group_Name (line 335)
mysql_log
Code:
L 09/29/2011 - 17:56:19: 1. Autorised player SteamID STEAM_0:0:19404857
L 09/29/2011 - 17:56:19: 3. Get SteamID STEAM_0:0:19404857
L 09/29/2011 - 17:56:19: 4. Get player in mysql SteamID STEAM_0:0:19404857
L 09/29/2011 - 17:56:19: 16. Get player Data
L 09/29/2011 - 17:56:19: 13. Get Player Group g_i_PlayerGroup = 2
MySql Data
from parent
116 2
118 2
116 2