Offline |
|
|
Csatlakozott: 2019.06.30. 09:50 Hozzászólások: 29
Megköszönt másnak: 7 alkalommal Megköszönték neki: 3 alkalommal
|
Helló Írtam 1 kés rendszert Elején minden ment tökéletesen Most kicsit bővítettem nem hozza elő a menüt meg semmit. Valaki esetleg tud segíteni? Eror log L 07/10/2019 - 15:11:43: Start of error session. L 07/10/2019 - 15:11:43: Info (map "35hp_2_knifers") (file "addons/amxmodx/logs/error_20190710.log") L 07/10/2019 - 15:11:43: [AMXX] Plugin ("sqlrendszerkees.amxx") is setting itself as failed. L 07/10/2019 - 15:11:43: [AMXX] Plugin says: Query Error L 07/10/2019 - 15:11:43: [AMXX] Displaying debug trace (plugin "sqlrendszerkees.amxx", version "1.0") L 07/10/2019 - 15:11:43: [AMXX] Run time error 1: forced exit L 07/10/2019 - 15:11:43: [AMXX] [0] 6seq8d0z.sma.p::createTableThread (line 1089) forrás kód: } public plugin_cfg() { new Query[512]; new Len; g_SqlTuple = SQL_MakeDbTuple(SQL_INFO[0],SQL_INFO[1],SQL_INFO[2],SQL_INFO[3]) Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `table1`"); Len += formatex(Query[Len], charsmax(Query)-Len, "(`username` varchar(32) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`xp` float(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`szint` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`oles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`pont` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`fejloves` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Masodpercek` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`vanprefix` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`prefixneve` varchar(32) NOT NULL,"); SQL_ThreadQuery(g_SqlTuple,"createTableThread", Query) } public createTableThread(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED) set_fail_state("Nem tudtam csatlakozni az adatbazishoz."); else if(FailState == TQUERY_QUERY_FAILED) set_fail_state("Query Error"); if(Errcode) log_amx("Hibat dobtam: %s",Error); } public client_putinserver(id) { if(!is_user_bot(id)) get_user_name(id, name[id], charsmax(name)) load(id) } public client_disconnect(id) { if(!is_user_bot(id)) update(id) } public client_connect(id) { new nev[32] get_user_name(id, nev, 31) } public load(id) { new Query[512], Data[1] Data[0] = id formatex(Query, charsmax(Query), "SELECT * FROM `table1` WHERE username = ^"%s^";", name[id]) SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", Query, Data, 1) } public QuerySelectData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) { log_amx("%s", Error) return } else { new id = Data[0]; if(SQL_NumRows(Query) > 0) { Xp[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "xp")) Szint[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "szint")) Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "oles")) Pont[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "pont")) Halal[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "halal")) Fejloves[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "fejloves")) Masodpercek[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Masodpercek")) VanPrefix[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "vanprefix")) SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "prefixneve"), Chat_Prefix[id], charsmax(Chat_Prefix[])) } else { save(id) } } } public save(id) { new text[512]; formatex(text, charsmax(text), "INSERT INTO `table1` (`username`) VALUES (^"%s^");", name[id]) SQL_ThreadQuery(g_SqlTuple, "QuerySetData", text) } public QuerySetData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) { log_amx("%s", Error) return } } public update(id) { new Query[512], Len; Len += formatex(Query[Len], charsmax(Query), "UPDATE table1 SET "); Len += formatex(Query[Len], charsmax(Query)-Len, "xp = %i, ", Xp[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "szint = %i, ", Szint[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "oles = %i, ", Oles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "halal = %i, ", Halal[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "fejloves = %i, ", Fejloves[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "pont = %i WHERE username = ^"%s^";", Pont[id], name[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Masodpercek = ^"%i^", ", Masodpercek[id]+get_user_time(id)); Len += formatex(Query[Len], charsmax(Query)-Len, "vanprefix = ^"%i^", ", VanPrefix[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "prefixneve = ^"%s^", ", Chat_Prefix[id]); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public plugin_end() { SQL_FreeHandle(g_SqlTuple) }
_________________ Knife mód Hamarosan! by Speedy
|
|