Offline |
|
Csatlakozott: 2016.08.17. 18:52 Hozzászólások: 92
Megköszönt másnak: 25 alkalommal Megköszönték neki: 2 alkalommal
|
Hello. Ha igy írom meg a mentést miért hozz a szerver nevével külön sorokat? És miért tűnek el az mentet adatok? #include <sqlx> new Handle:g_SqlTuple; new const SQLINFO[][] = { "", // HOST "", // USERNAME "", // PASSWORD "" // DATABASE }; public client_disconnect(id) { if(!is_user_bot(id)) Update(id); } public client_putinserver(id) { Dollar[id] = EOS; Rang[id] = EOS; Oles[id] = EOS; Gun[id] = 1; Registered[id] = 0; UserPassword[id] = ""; RegPassword[id] = ""; Loggedin[id] = false; Write[id] = false; Write2[id] = false; for(new i;i < 112; i++) OsszesFegyver[i] = EOS; for(new i;i < 112; i++) OsszesSkin[i][id] = EOS; for(new i;i < 8; i++) Lada[i][id] = EOS; Kulcs[id] = 0; if(!is_user_bot(id)) Load(id); } public plugin_cfg() { 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 `ujgo_mod`"); Len += formatex(Query[Len], charsmax(Query)-Len, "(`Nev` varchar(32) NOT NULL, "); Len += formatex(Query[Len], charsmax(Query)-Len, "`Dollars` 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, "`Jelszo` varchar(32) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Regisztralva` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Osszes` int(11) NOT NULL, "); for(new i;i < 112; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "`Gun%d` int(11) NOT NULL,", i); for(new i;i < 8; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "`Chest%d` int(11) NOT NULL,", i); Len += formatex(Query[Len], charsmax(Query)-Len, "`Kulcs` int(11) NOT NULL, `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)"); SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query); } public Load(id) { static Query[10048]; new Data[1], Name[32]; get_user_name(id, Name, 31); Data[0] = id; formatex(Query, charsmax(Query), "SELECT * FROM `ujgo_mod` WHERE Nev = ^"%s^";", Name); 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) { SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Dollars"), Dollar[id]); Rang[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Szint")); Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Oles")); SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Jelszo"), RegPassword[id], charsmax(RegPassword[])); Registered[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Regisztralva")); for(new i=0;i<112;i++) OsszesFegyver[i] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Osszes")); for(new i=0;i < 112; i++) { new String[64]; formatex(String, charsmax(String), "Gun%d", i); OsszesSkin[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String)); } for(new i;i < 8; i++) { new String[64]; formatex(String, charsmax(String), "Chest%d", i); Lada[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String)); } Kulcs[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Kulcs")); } else { Save(id); } } } public Save(id) { static Query[10048]; new Len; new Name[32]; get_user_name(id, Name, 31); Len += formatex(Query[Len], charsmax(Query), "INSERT INTO `ujgo_mod` (`Nev`, "); Len += formatex(Query[Len], charsmax(Query)-Len, "`Dollars` ,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Szint` ,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Oles` ,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Jelszo`, "); Len += formatex(Query[Len], charsmax(Query)-Len, "`Regisztralva`, "); Len += formatex(Query[Len], charsmax(Query)-Len, "`Osszes`, "); for(new i;i < 112; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "`Gun%d` ,", i); for(new i;i < 8; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "`Chest%d` ,", i); Len += formatex(Query[Len], charsmax(Query)-Len, "`Kulcs`) VALUES (^"%s^" ,", Name); Len += formatex(Query[Len], charsmax(Query)-Len, "^"0^", "); Len += formatex(Query[Len], charsmax(Query)-Len, "^"0^", "); Len += formatex(Query[Len], charsmax(Query)-Len, "^"0^", "); Len += formatex(Query[Len], charsmax(Query)-Len, "^"0^", "); Len += formatex(Query[Len], charsmax(Query)-Len, "^"0^", "); Len += formatex(Query[Len], charsmax(Query)-Len, "^"0^", "); for(new i=0;i < 112; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "^"0^", "); for(new i;i < 8; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "^"0^", "); Len += formatex(Query[Len], charsmax(Query)-Len, "^"0^");"); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public Update(id) { static Query[10048]; new Len; new Name[32]; get_user_name(id, Name, 31); Len += formatex(Query[Len], charsmax(Query), "UPDATE `ujgo_mod` SET Dollars = ^"%i^", ",Dollar[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Szint = ^"%i^", ", Rang[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Oles = ^"%i^", ", Oles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Jelszo = ^"%s^", ", RegPassword[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Regisztralva = ^"%i^", ", Registered[id]); for(new i=0;i < 112; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "Osszes = ^"%i^", ", OsszesFegyver[i]); for(new i=0;i < 112; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "Gun%d = ^"%i^", ", i, OsszesSkin[i][id]); for(new i;i < 8; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "Chest%d = ^"%i^", ", i, Lada[i][id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Kulcs = ^"%i^" WHERE Nev = ^"%s^";", Kulcs[id], Name); 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); }
_________________ .:[BadboYs]:. Global Offensive
|
|