Byłbym wdzięczny gdyby ktoś mógł mi powiedzieć gdzie jest błąd lub naprawić
Cały kod :
#include <amxmodx> #include <csx> #include <sqlx> #define PLUGIN "test" #define VERSION "1.0" #define AUTHOR "speedkill" new Host[] = "" new User[] = "" new Pass[] = "" new Db[] = "" new Handle:g_SqlTuple new g_Error[512] new stats[33] public plugin_init() { register_plugin(PLUGIN, VERSION, AUTHOR) set_task(1.0, "MySql_Init") } public MySql_Init() { g_SqlTuple = SQL_MakeDbTuple(Host,User,Pass,Db) new ErrorCode,Handle:SqlConnection = SQL_Connect(g_SqlTuple,ErrorCode,g_Error,charsmax(g_Error)) if(SqlConnection == Empty_Handle) set_fail_state(g_Error) new Handle:Queries Queries = SQL_PrepareQuery(SqlConnection,"CREATE TABLE IF NOT EXISTS top15 (name varchar(255),stats varchar(255),deaths varchar(255))") if(!SQL_Execute(Queries)) { SQL_QueryError(Queries,g_Error,charsmax(g_Error)) set_fail_state(g_Error) } SQL_FreeHandle(Queries) SQL_FreeHandle(SqlConnection) } public plugin_end() { SQL_FreeHandle(g_SqlTuple) } public Load_MySql(id) { new name[32], szTemp[512] get_user_name(id, name, 31) new Data[1] Data[0] = id format(szTemp,charsmax(szTemp),"SELECT * FROM `top15` WHERE (`top15`.`name` = '%s')", 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("Load - Could not connect to SQL database. [%d] %s", Errcode, Error) } else if(FailState == TQUERY_QUERY_FAILED) { log_amx("Load Query failed. [%d] %s", Errcode, Error) } new id id = Data[0] if(SQL_NumResults(Query) < 1) { new stats[8], bodyhits[8]; get_user_stats(id, stats, bodyhits); new name[32] get_user_name(id, name, 31) new szTemp[512] format(szTemp,charsmax(szTemp),"INSERT INTO `top15` ( `name` , `stats`, `deaths`)VALUES ('%s','%d','%d');",name,stats,stats[1]) SQL_ThreadQuery(g_SqlTuple,"IgnoreHandle",szTemp) } else { stats[id] = SQL_ReadResult(Query, 1) } return PLUGIN_HANDLED } public Save_MySql(id) { new szTemp[512] new stats[8], bodyhits[8]; get_user_stats(id, stats, bodyhits); new name[32] get_user_name(id, name, 31) format(szTemp,charsmax(szTemp),"UPDATE `top15` SET stats='%d' , deaths='%d' WHERE name=%s",stats,stats[1],name) SQL_ThreadQuery(g_SqlTuple,"IgnoreHandle",szTemp) } public IgnoreHandle(FailState,Handle:Query,Error[],Errcode,Data[],DataSize) { SQL_FreeHandle(Query) return PLUGIN_HANDLED } public client_putinserver(id) { Load_MySql(id) } public client_disconnect(id) { Save_MySql(id) }Pozdrawiam speedkill ;]