hellóó, valaki javítaná nekem? illetve ha nem nagy kérés nevet ne ellenőrizze bejelentkezéskor jatékos nevét tehát bármilyen névvel bármelyik felhasználóba be léphessen. Mert eddig úgy ment, hogy regisztráltál aarpi névvel jelszó: 1, felhasználónév: 2 de ha már aarpii névvel felmegyek bejelentkeznék nem engedi már, és regisztrálni kell ujból. Remélem érthető mit szeretnék. Előre is köszönöm
Kód: } 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 `derbyawpp2`"); Len += formatex(Query[Len], charsmax(Query)-Len, "(`Nev` varchar(32) NOT NULL, "); Len += formatex(Query[Len], charsmax(Query)-Len, "`Felhasznalonev` varchar(32) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Jelszo` varchar(32) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Regisztralt` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Euro` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`DropOles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Vip` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`VipIdo` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Masodpercek` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Coin` int(11) NOT NULL,"); for(new i;i < FEGYO; 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 < KULCS; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "`K%d` int(11) NOT NULL,", i); for(new i;i < 2; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "`S%d` int(11) NOT NULL, `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)", i); 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 `derbyawpp2` 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) { PP[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Coin")); Vip[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Vip")); VipIdo[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "VipIdo")); Euro[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Euro")); DropOles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "DropOles")); SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Felhasznalonev"), regFh[id], charsmax(regFh[])); SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Jelszo"), regJelszo[id], charsmax(regJelszo[])); Regisztralt[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Regisztralt")); idke[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "id")); for(new i;i < FEGYO; 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 < KULCS; i++) { new String[64]; formatex(String, charsmax(String), "K%d", i); Skin[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String)); } for(new i;i < 2; i++) { new String[64]; formatex(String, charsmax(String), "S%d", i); Skin[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String)); } } else { Save(id); } } } public Save(id) { static Query[256]; formatex(Query, charsmax(Query), "INSERT INTO `derbyawpp2` (`Nev`) VALUES (^"%s^");", name[id]); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public SQL_Update_Reg(id) { static Query[10048]; new Len;
Len += formatex(Query[Len], charsmax(Query), "UPDATE `derbyawpp2` SET Felhasznalonev = ^"%s^", ", regFh[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Jelszo = ^"%s^", ", regJelszo[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Regisztralt = ^"%i^" WHERE Nev = ^"%s^";", Regisztralt[id], name[id]);
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public Update(id) { static Query[10048]; new Len; Len += formatex(Query[Len], charsmax(Query), "UPDATE `derbyawpp2` Euro = ^"%i^", ",Euro[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "DropOles = ^"%i^", ", DropOles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Vip = ^"%i^", ", Vip[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "VipIdo = ^"%i^", ", VipIdo[id]-get_user_time(id)); Len += formatex(Query[Len], charsmax(Query)-Len, "Masodpercek = ^"%i^", ", Masodpercek[id]+get_user_time(id)); Len += formatex(Query[Len], charsmax(Query)-Len, "Coin = ^"%i^", ", PP[id]); for(new i=0;i < FEGYO; 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 < KULCS; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "K%d = ^"%i^", ", i, Kulcs[i][id]); for(new i;i < 2; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "S%d = ^"%i^", ", i, Skin[i][id]); Len += formatex(Query[Len], charsmax(Query)-Len, "WHERE Nev = ^"%s^";", 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; } }
|