Offline |
|
|
Csatlakozott: 2016.03.05. 20:56 Hozzászólások: 663
Megköszönt másnak: 27 alkalommal Megköszönték neki: 124 alkalommal
|
Így van megcsinálva:Ezt a hibaüzenetet dobja a hlds:L 08/21/2016 - 11:18:45: Start of error session. L 08/21/2016 - 11:18:45: Info (map "de_dust2") (file "addons/amxmodx/logs/error_20160821.log") L 08/21/2016 - 11:18:45: [AMXX] Plugin ("SQLmentes.amxx") is setting itself as failed. L 08/21/2016 - 11:18:45: [AMXX] Plugin says: Query Error L 08/21/2016 - 11:18:45: [AMXX] Displaying debug trace (plugin "SQLmentes.amxx") L 08/21/2016 - 11:18:45: [AMXX] Run time error 1: forced exit L 08/21/2016 - 11:18:45: [AMXX] [0] rdm5z293.sma.p::createTableThread (line 1091)
Jelen esetben a 17. sorban írja a hibát (line 1091)public plugin_cfg() { static Query[512]; //static s_sText[ 512 ]; g_sSqlTuple = SQL_MakeDbTuple(SQL_INFO[0],SQL_INFO[1],SQL_INFO[2],SQL_INFO[3]) new len len = formatex( Query, charsmax( Query ), "CREATE TABLE IF NOT EXISTS `TESZTMENTES` (`username` varchar(32) NOT NULL,`valami_ertek` int(11) NOT NULL,`ak47_st1` int(11) NOT NULL,`ak47_st2` int(11) NOT NULL,`ak47_st3` int(11) NOT NULL,`ak47_st4` int(11) NOT NULL,,`ak47_st5` int(11) NOT NULL,`ak47_st6` int(11) NOT NULL") len += formatex( Query[ len ], charsmax( Query ) - len, "`m4a1_st1` int(11) NOT NULL,`m4a1_st2` int(11) NOT NULL,`m4a1_st3` int(11) NOT NULL,`m4a1_st4` int(11) NOT NULL,`m4a1_st5` int(11) NOT NULL,`m4a1_st6` int(11) NOT NULL,`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY") SQL_ThreadQuery(g_sSqlTuple,"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 load(id) { new Query[512], Data[1] Data[0] = id formatex(Query, charsmax(Query), "SELECT * FROM `TESZTMENTES` WHERE username = ^"%s^";", name[id]) SQL_ThreadQuery(g_sSqlTuple, "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) { // Ha talált legalább 1 sort, akkor ezek történnek. awp_st[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "valami_ertek")) ak47_st[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ak47_st1")) ak47_st[2][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ak47_st2")) ak47_st[3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ak47_st3")) ak47_st[4][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ak47_st4")) ak47_st[5][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ak47_st5")) ak47_st[6][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ak47_st6")) m4a1_st[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "m4a1_st1")) m4a1_st[2][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "m4a1_st2")) m4a1_st[3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "m4a1_st3")) m4a1_st[4][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "m4a1_st4")) m4a1_st[5][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "m4a1_st5")) m4a1_st[6][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "m4a1_st6")) // Ez a parancs szöveg, szám és float esetében is másképp van, ehhez infó lentebb. } else { // Ha nem talált sort, mert még nem volt a szerveren, akkor készítünk neki egyet. save(id) // Ehhez infó a Játékos sorainak létrehozásánál. } } } public save(id) { new text[512]; formatex(text, charsmax(text), "INSERT INTO `TESZTMENTES` (`username`, `valami_ertek`) VALUES (^"%s^", ^"0^");", name[id]) SQL_ThreadQuery(g_sSqlTuple, "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) { static text[512]; //static s_sText[ 512 ]; new len; len = formatex( text, charsmax( text ), "UPDATE `TESZTMENTES` SET valami_ertek = ^"%i^",ak47_st1 = ^"%i^",ak47_st2 = ^"%i^",ak47_st3 = ^"%i^",ak47_st4 = ^"%i^",ak47_st5 = ^"%i^",ak47_st6 = ^"%i^"", awp_st[1][id],ak47_st[1][id],ak47_st[2][id],ak47_st[3][id],ak47_st[4][id],ak47_st[5][id],ak47_st[6][id]); len += formatex( text[ len ], charsmax( text ) - len, "m4a1_st1 = ^"%i^",m4a1_st2 = ^"%i^",m4a1_st3 = ^"%i^",m4a1_st4 = ^"%i^",m4a1_st5 = ^"%i^",m4a1_st6 = ^"%i^" WHERE username = ^"%s^";", m4a1_st[1][id],m4a1_st[2][id],m4a1_st[3][id],m4a1_st[4][id],m4a1_st[5][id],m4a1_st[6][id], name[id]); SQL_ThreadQuery(g_sSqlTuple, "QuerySetData", text ) } public client_disconnect(id) { if(!is_user_bot(id)) { update(id) } awp_st[1][id] = 0 ak47_st[1][id] = 0 ak47_st[2][id] = 0 ak47_st[3][id] = 0 ak47_st[4][id] = 0 ak47_st[5][id] = 0 ak47_st[6][id] = 0 m4a1_st[1][id] = 0 m4a1_st[2][id] = 0 m4a1_st[3][id] = 0 m4a1_st[4][id] = 0 m4a1_st[5][id] = 0 m4a1_st[6][id] = 0 copy(name[id], charsmax(name[]), "") }
|
|