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
|
Sajnos nem jó de viszont már le fordul nekem mert a másik módomból azt a részt kicseréltem viszont az sqltáblát nem hozza létre debugolom és ezt az erort kapom: L 07/19/2019 - 12:04:46: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery") L 07/19/2019 - 12:04:46: [AMXX] [0] 962ye324.sma.p::sql_load_user (line 1487) L 07/19/2019 - 12:04:46: [AMXX] [1] 962ye324.sma.p::client_putinserver (line 1452) Forrás: } public client_disconnect(id) { if(!is_user_bot(id)) { sql_update_user(id); } oles[id] = 0 pont[id] = 0 Euro[id] = 0 copy(name[id], charsmax(name[]), ""); } public client_putinserver(id) { if(!is_user_bot(id)) { get_user_name(id, name[id], charsmax(name)); sql_load_user(id); } awp[id] = 0 deagle[id] = 0 usp[id] = 0 glock[id] = 0 m4a1[id] = 0 ak47[id] = 0 } public sql_create_table() { g_SqlTuple = SQL_MakeDbTuple(SQLINFO[0], SQLINFO[1], SQLINFO[2], SQLINFO[3]); static Query[10048]; new Len; Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `d2mod`"); Len += formatex(Query[Len], charsmax(Query)-Len, "(`Nev` varchar(32) NOT NULL, "); Len += formatex(Query[Len], charsmax(Query)-Len, "`Euro` 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, `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)"); SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query); } public sql_load_user(id) { static Query[10048]; new Data[1], Name[32]; get_user_name(id, Name, 31); Data[0] = id; formatex(Query, charsmax(Query), "SELECT * FROM `d2mod` WHERE Nev = ^"%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) { oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "oles")); Euro[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Euro")); pont[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "pont")); } else { sql_save_user(id); } } } public sql_save_user(id) { static Query[256]; formatex(Query, charsmax(Query), "INSERT INTO `d2mod` (`Nev`) VALUES (^"%s^");", name[id]); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public sql_update_user(id) { static Query[10048]; new Len; Len += formatex(Query[Len], charsmax(Query), "UPDATE `d2mod` SET Euro = ^"%i^", ",Euro[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "oles = ^"%i^", ", oles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "pont = ^"%i^" WHERE Nev = ^"%s^";", pont[id], name[id]); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public createTableThread(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED) set_fail_state("[HIBA*] NEM TUDTAM CSATLAKOZNI AZ ADATBAZISHOZ!"); else if(FailState == TQUERY_QUERY_FAILED) set_fail_state("Query Error"); if(Errcode) log_amx("[HIBA*] HIBAT DOBTAM: %s",Error); } 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 plugin_end() { SQL_FreeHandle(g_SqlTuple); }
ahol most van az eror: } public client_putinserver(id) { if(!is_user_bot(id)) { get_user_name(id, name[id], charsmax(name)); sql_load_user(id); SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query); } public sql_load_user(id) { static Query[10048]; new Data[1], Name[32]; get_user_name(id, Name, 31); Data[0] = id; formatex(Query, charsmax(Query), "SELECT * FROM `d2mod` WHERE Nev = ^"%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) { oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "oles")); Euro[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Euro")); pont[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "pont"));
_________________ Knife mód Hamarosan! by Speedy
|
|