Offline |
|
Csatlakozott: 2017.02.01. 22:13 Hozzászólások: 33
Megköszönt másnak: 7 alkalommal Megköszönték neki: 4 alkalommal
|
Hello. Ebbe az sql mentésben mi a hiba? A táblát le generálja de sorokat nem csinál benne a regről. public client_disconnect(id) { if(!is_user_bot(id)) Update(id); Dollar[id] = 0; Szint[id] = 0; Oles[id] = 0; Skin[id] = 0; Registered[id] = 0; UserPassword[id] = ""; RegPassword[id] = ""; Loggedin[id] = false; Write[id] = false; Write2[id] = false; for(new i;i < MAX; i++) OsszesSkin[i][id] = 0; for(new i;i < LADA; i++) Lada[id][i] = 0; Kulcs[id] = 0; } public client_putinserver(id) { Dollar[id] = 0; Szint[id] = 0; Oles[id] = 0; Skin[id] = 0; Registered[id] = 0; UserPassword[id] = ""; RegPassword[id] = ""; Loggedin[id] = false; Write[id] = false; Write2[id] = false; for(new i;i < MAX; i++) OsszesSkin[i][id] = 0; for(new i;i < LADA; i++) Lada[id][i] = 0; 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 `torettoasd`"); Len += formatex(Query[Len], charsmax(Query)-Len, "(`Nev` varchar(32) NOT NULL, "); Len += formatex(Query[Len], charsmax(Query)-Len, "`Dollars` int(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,"); for(new i;i < MAX; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "`F%d` int(11) NOT NULL,", i); for(new i;i < LADA; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "`L%d` int(11) NOT NULL,", i); for(new i;i < 16; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "`S%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[id], 31); Data[0] = id; formatex(Query, charsmax(Query), "SELECT * FROM `torettoasd` 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) { Dollar[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Dollars")); Szint[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;i < MAX; i++) { new String[64]; formatex(String, charsmax(String), "F%d", i); OsszesSkin[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String)); } for(new i;i < LADA; i++) { new String[64]; formatex(String, charsmax(String), "L%d", i); Lada[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String)); } for(new i;i < 16; i++) { new String[64]; formatex(String, charsmax(String), "S%d", i); Gun[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[256]; new Len; new name[32]; get_user_name(id, name[id], 31); Len += formatex(Query[Len], charsmax(Query), "INSERT INTO `torettoasd` (`Nev`, "); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public Update(id) { static Query[10048]; new Len; new name[32]; get_user_name(id, name[id], 31); Len += formatex(Query[Len], charsmax(Query), "UPDATE `torettoasd` SET Dollars = ^"%i^", ",Dollar[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, "Jelszo = ^"%s^", ", RegPassword[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Regisztralva = ^"%i^", ", Registered[id]); for(new i=0;i < MAX; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "F%d = ^"%i^", ", i, OsszesSkin[i][id]); for(new i;i < LADA; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "L%d = ^"%i^", ", i, Lada[i][id]); for(new i;i < 16; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "S%d = ^"%i^", ", i, Gun[i][id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Kulcs = ^"%i^" WHERE Nev = ^"%s^";", Kulcs[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); }
Talán ha kell a reg is. public RegMenu(id) { new name[32], UserName[121], UserPassword[121]; get_user_name(id, name[id], 31); new Menu = menu_create("\rRegisztráciĂłs Rendszer^n\rStátusz: \dNem Regisztrált", "RegHandler"); formatex(UserName, charsmax(UserName), "\rFelhasználĂłnĂ©v: \d%s", name[id]); menu_additem(Menu, UserName, "1"); if(Write[id]) { formatex(UserPassword, charsmax(UserPassword), "\rJelszĂł: \d%s^n", RegPassword[id]); menu_additem(Menu, UserPassword, "2"); menu_additem(Menu, "\yRegisztrálás", "3"); } else { formatex(UserPassword, charsmax(UserPassword), "\rJelszĂł: \dIrd Be a jelszĂłt^n"); menu_additem(Menu, UserPassword, "2"); menu_additem(Menu, "\yRegisztrálás", "4"); } menu_setprop(Menu, MPROP_EXIT, MEXIT_ALL); menu_setprop(Menu, MPROP_EXITNAME, "KilĂ©pĂ©s"); menu_display(id, Menu, 0); return PLUGIN_HANDLED; } public LogMenu(id) { new name[32], UserName[121], UserPassword[121]; get_user_name(id, name[id], 31); new Menu = menu_create("\rRegisztráciĂłs Rendszer^n\rStátusz: \dRegisztrálva", "LogHandler"); formatex(UserName, charsmax(UserName), "\rFelhasználĂłnĂ©v: \d%s", name[id]); menu_additem(Menu, UserName, "1"); if(Write2[id]) { formatex(UserPassword, charsmax(UserPassword), "\rJelszĂł: \d%s^n", UserPassword[id]); menu_additem(Menu, UserPassword, "2"); } else { formatex(UserPassword, charsmax(UserPassword), "\rJelszĂł: \dIrd Be a jelszĂłt ^n"); menu_additem(Menu, UserPassword, "2"); } menu_additem(Menu, "\yBelĂ©pĂ©s", "3", 0); menu_additem(Menu, "\wElfelejtettem a \rJelszavam", "4", 0); menu_setprop(Menu, MPROP_EXIT, MEXIT_ALL); menu_setprop(Menu, MPROP_EXITNAME, "KilĂ©pĂ©s"); menu_display(id, Menu, 0); return PLUGIN_HANDLED; } public RegHandler(id, Menu, item) { if(item == MENU_EXIT) { menu_destroy(Menu); return PLUGIN_HANDLED; } new Data[9], access, callback, szName[64]; menu_item_getinfo(Menu, item, access, Data,charsmax(Data), szName,charsmax(szName), callback); new Key = str_to_num(Data); switch(Key) { case 1: { RegMenu(id); } case 2: { client_cmd(id, "messagemode REG_JELSZO"); } case 3: { Registered[id] = 1; Write[id] = false; client_printcolor(id, "!g* !nSikeresen regisztráltál a Szerverre. Jelszava:!t %s", RegPassword[id]); } case 4: { RegMenu(id); client_printcolor(id, "!g* !nNem adtál meg !tJelszot."); } } menu_destroy(Menu); return PLUGIN_HANDLED; } public LogHandler(id, Menu, item) { if(item == MENU_EXIT) { menu_destroy(Menu); return PLUGIN_HANDLED; } new Data[9], access, callback, szName[64]; menu_item_getinfo(Menu, item, access, Data,charsmax(Data), szName,charsmax(szName), callback); new Key = str_to_num(Data); switch(Key) { case 1: { LogMenu(id); } case 2: { client_cmd(id, "messagemode LOG_JELSZO"); } case 3: { if(equali(UserPassword[id], RegPassword[id])) { Write2[id] = false; Loggedin[id] = true; client_printcolor(id, "!g* !nSikeresen BejelentkeztĂ©l."); } else { client_printcolor(id, "!g* !nHibáss !JelszĂłt !nadtál meg!"); } } case 4: { client_printcolor(id, "!g* !nKeress fel minket fbn: Boris Bajin vagy Peter Korodi"); } } menu_destroy(Menu); return PLUGIN_HANDLED; }
A segitségeteket előre is köszönöm! Szép napot/estét!
_________________
|
|