Helló.Ezt valaki javítaná?
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 mentes (nev varchar(32),arany INT(11), kill INT(11), szint INT(11), fegyver1 INT(11), fegyver2 INT(11), fegyver3 INT(11), fegyver4 INT(11), fegyver5 INT(11), fegyver6 INT(11), fegyver7 INT(11), fegyver8 INT(11), fegyver9 INT(11), fegyver10 INT(11))") //létrehozzuk a pontrendszer táblát név és pont sorokkal 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 betoltes(id) { new szNev[32], szTemp[512] get_user_name(id, szNev, charsmax(szNev)) new Data[1] Data[0] = id format(szTemp,charsmax(szTemp),"SELECT * FROM `mentes` WHERE (`mentes`.`nev` = '%s')", szNev) 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("Kapcsolodas sikertelen. [%d] %s", Errcode, Error) } else if(FailState == TQUERY_QUERY_FAILED) { log_amx("A QUERY betoltese sikertelen.[%d] %s", Errcode, Error) } new id id = Data[0] if(SQL_NumResults(Query) < 1) { new szNev[32] get_user_name(id, szNev, charsmax(szNev)) new szTemp[1024] format(szTemp,charsmax(szTemp),"INSERT INTO `mentes` ( `nev` , `arany` , `kill` , `szint` , `fegyver1` , `fegyver2` , `fegyver3` , `fegyver4` , `fegyver5` , `fegyver6` , `fegyver7` , `fegyver8` , `fegyver9` , `fegyver10`)VALUES ('%s','0','0','0','0','0','0','0','0','0','0','0','0','0');",szNev) SQL_ThreadQuery(g_SqlTuple,"IgnoreHandle",szTemp) } else { Gold[id] = SQL_ReadResult(Query, 1) Kill[id] = SQL_ReadResult(Query, 2) Szint[id] = SQL_ReadResult(Query, 3) GoSkins[0][id] = SQL_ReadResult(Query, 4) GoSkins[1][id] = SQL_ReadResult(Query, 5) GoSkins[2][id] = SQL_ReadResult(Query, 6) GoSkins[3][id] = SQL_ReadResult(Query, 7) GoSkins[4][id] = SQL_ReadResult(Query, 8) GoSkins[5][id] = SQL_ReadResult(Query, 9) GoSkins[6][id] = SQL_ReadResult(Query, 10) GoSkins[7][id] = SQL_ReadResult(Query, 11) GoSkins[8][id] = SQL_ReadResult(Query, 12) GoSkins[9][id] = SQL_ReadResult(Query, 13) } return PLUGIN_HANDLED } public mentes(id) { new szNev[32], szTemp[1024] get_user_name(id, szNev, charsmax(szNev)) format(szTemp,charsmax(szTemp),"UPDATE `mentes` SET `arany`, `kill`, `szint`, `fegyver1`, `fegyver2`, `fegyver3`, `fegyver4`, `fegyver5`, `fegyver6`, `fegyver7`, `fegyver8`, `fegyver9`, `fegyver10` = '%i' WHERE `mentes`.`nev` = '%s';",Gold[id], Kill[id], Szint[id], GoSkins[0][id], GoSkins[1][id], GoSkins[2][id], GoSkins[3][id], GoSkins[4][id], GoSkins[5][id], GoSkins[6][id], GoSkins[7][id], GoSkins[8][id], GoSkins[9][id], szNev) SQL_ThreadQuery(g_SqlTuple,"IgnoreHandle",szTemp) } public IgnoreHandle(FailState,Handle:Query,Error[],Errcode,Data[],DataSize) { SQL_FreeHandle(Query) return PLUGIN_HANDLED }
Szerver indításnál ezt a hibát dobja:
Kód: L 07/27/2015 - 23:16:18: [AMXX] Plugin ("globaloffensive.amxx") is setting itself as failed. L 07/27/2015 - 23:16:18: [AMXX] Plugin says: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'kill INT(11), szint INT(11), fegyver1 INT(11), fegyver2 INT(11), fegyver3 INT(11' at line 1 L 07/27/2015 - 23:16:18: [AMXX] Displaying debug trace (plugin "globaloffensive.amxx") L 07/27/2015 - 23:16:18: [AMXX] Run time error 1: forced exit L 07/27/2015 - 23:16:18: [AMXX] [0] globaloffensive.sma::MySql_Init (line 293)
|