Offline |
|
Csatlakozott: 2016.06.20. 10:23 Hozzászólások: 489
Megköszönt másnak: 47 alkalommal Megköszönték neki: 15 alkalommal
|
Sziasztok! Próbáltam a táblából vissza olvastatni az adatot, de valamiért nem sikerül. Valamikor 0-t ír valamikor 49. Pedig az SQL-adatbázisban létrehozza az id táblát.
Forrás:new ID_L[33]; 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 `teszt`"); 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, "`Masodpercek` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`AutoB` int(11) 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, "`Regisztralt` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Erteke` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Kicucc` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Kirakva` 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 < STK; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "`St%d` int(11) NOT NULL,", i); for(new i;i < 14; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "`Skin%d` int(11) NOT NULL,", i); Len += formatex(Query[Len], charsmax(Query)-Len, "`Kulcs` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`arany` 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]; Data[0] = id; formatex(Query, charsmax(Query), "SELECT * FROM `teszt` 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) { SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Felhasznalonev"), regFh[id], charsmax(regFh[])); SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Jelszo"), regJelszo[id], charsmax(regJelszo[])); SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "id"), ID_L[id], charsmax(ID_L[])); Rang[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Szint")); AutoB[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "AutoB")); Kulcs[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Kulcs")); Masodpercek[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Masodpercek")); Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Oles")); Regisztralt[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Regisztralt")); Erteke[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Erteke")); kicucc[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Kicucc")); kirakva[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Kirakva")); arany[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "arany")); Dollar[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Dollars")); 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 < STK; i++) { new String[64]; formatex(String, charsmax(String), "St%d", i); Statrak[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String)); } for(new i;i < 14; i++) { new String[64]; formatex(String, charsmax(String), "Skin%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 `teszt` (`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 `teszt` 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); }
Mi lehet a probléma?
_________________ BfS* #Team ~Global Offensive IP: 217.144.54.193:27148
|
|