Offline |
![Nagyúr Nagyúr](./images/ranks/hl17.png) |
![Avatar](./download/file.php?avatar=8199_1677267378.jpg) |
Csatlakozott: 2016.03.05. 20:56 Hozzászólások: 663
Megköszönt másnak: 27 alkalommal Megköszönték neki: 124 alkalommal
|
JohanCorn írta: Nem, nem és nem. Úgy értettem, hogy... - Nos, véleményem szerint a 2048 édes kevés annyi dolog esetén. Hogy ez bebizonyosodjon nem kell mást tenned, mint a Query-t kiíratod egy fájlba. Ez nem bonyolult alapból az amxmodx tartalmaz log funkciót is. - log_to_file("Query.txt", szQuery);
- Ha a dokumentumban a teljes parancs végig lesz írva, akkor nem ez a probléma. Amennyiben viszont nincs benne a teljes parancssor, akkor kevés a 2048. Ez kell a végén legyen: - Nem volt elég a karakterszám ezért növeltem valamint 2 részre osztottam az updatet.public sql_update_account(id) { static szQuery[10032], len log_to_file("Query.txt", szQuery); new c[191] new client_name[33] get_user_name(id, client_name, 32) formatex(c, 190, "%s", client_name) replace_all(c, 190, "\", "\\") replace_all(c, 190, "'", "\'") len += formatex(szQuery[len], charsmax(szQuery), "UPDATE csgo_teszt SET ") len += formatex(szQuery[len], charsmax(szQuery)-len,"Olesek = '%i', ", g_Kills[id]) len += formatex(szQuery[len], charsmax(szQuery)-len,"Rang = '%i', ", g_Rang[id]) len += formatex(szQuery[len], charsmax(szQuery)-len,"Dollar = '%i', ", g_Dollar[id]) len += formatex(szQuery[len], charsmax(szQuery)-len,"Kulcs = '%i', ", g_Key[id]) len += formatex(szQuery[len], charsmax(szQuery)-len,"Skinek = '%i', ", g_WeapSwitch[id]) len += formatex(szQuery[len], charsmax(szQuery)-len,"Premium = '%i', ", g_Premium[id]) len += formatex(szQuery[len], charsmax(szQuery)-len,"Ido = '%i', ", g_Time[id]+get_user_time(id)) for(new i;i < d_FGY; i++) len += formatex(szQuery[len], charsmax(szQuery)-len,"F%d = '%i', ", i, g_Weapon[i][id]) for(new i;i < STAWP+1; i++) len += formatex(szQuery[len], charsmax(szQuery)-len,"A%d = '%i', ", i, g_sTAWP[i][id]) for(new i;i < STAK47+1; i++) len += formatex(szQuery[len], charsmax(szQuery)-len,"K%d = '%i', ", i, g_sTAK[i][id]) for(new i;i < STCOLT+1; i++) len += formatex(szQuery[len], charsmax(szQuery)-len,"M%d = '%i', ", i, g_sTM4[i][id]) len += formatex(szQuery[len], charsmax(szQuery)-len,"Jatekosnev = '%s' ", c) SQL_ThreadQuery(g_SqlTuple,"QuerySetData", szQuery) sql_update_account_1(id); } public sql_update_account_1(id) { static szQuery[10032], len log_to_file("Query.txt", szQuery); new c[191] new client_name[33] get_user_name(id, client_name, 32) formatex(c, 190, "%s", client_name) replace_all(c, 190, "\", "\\") replace_all(c, 190, "'", "\'") len += formatex(szQuery[len], charsmax(szQuery), "UPDATE csgo_teszt SET ") for(new i;i < STDEAGLE+1; i++) len += formatex(szQuery[len], charsmax(szQuery)-len,"G%d = '%i', ", i, g_sTDG[i][id]) for(new i;i < STUSP+1; i++) len += formatex(szQuery[len], charsmax(szQuery)-len,"S%d = '%i', ", i, g_sTUSP[i][id]) for(new i;i < STKNIFE+1; i++) len += formatex(szQuery[len], charsmax(szQuery)-len,"K%d = '%i', ", i, g_sTKNIFE[i][id]) for(new i;i < d_LMAX; i++) len += formatex(szQuery[len], charsmax(szQuery)-len,"L%d = '%i', ", i, g_Case[i][id]) for(new i;i < SKINS; i++) len += formatex(szQuery[len], charsmax(szQuery)-len,"Skin%d = '%i', ", i, Skin[i][id]) len += formatex(szQuery[len], charsmax(szQuery)-len,"WHERE Id = '%i'", g_Id[id]) SQL_ThreadQuery(g_SqlTuple,"QuerySetData", szQuery) }
Query.txt:L 08/03/2017 - 17:29:27: UPDATE csgo_teszt SET Olesek = '0', Rang = '0', Dollar = '0', Kulcs = '0', Skinek = '1', Premium = '0', Ido = '83', F0 = '0', F1 = '0', F2 = '0', F3 = '0', F4 = '0', F5 = '0', F6 = '0', F7 = '0', F8 = '0', F9 = '0', F10 = '0', F11 = '0', F12 = '0', F13 = '0', F14 = '0', F15 = '0', F16 = '0', F17 = '0', F18 = '0', F19 = '0', F20 = '0', F21 = '0', F22 = '0', F23 = '0', F24 = '0', F25 = '0', F26 = '0', F27 = '0', F28 = '0', F29 = '0', F30 = '0', F31 = '0', F32 = '0', F33 = '0', F34 = '0', F35 = '0', F36 = '0', F37 = '0', F38 = '0', F39 = '0', F40 = '0', F41 = '0', F42 = '0', F43 = '0', F44 = '0', F45 = '0', F46 = '0', F47 = '0', F48 = '0', F49 = '0', F50 = '0', F51 = '0', F52 = '0', F53 = '0', F54 = '0', F55 = '0', F56 = '0', F57 = '0', F58 = '0', F59 = '0', F60 = '0', F61 = '0', F62 = '0', F63 = '0', F64 = '0', F65 = '0', F66 = '0', F67 = '0', F68 = '0', F69 = '0', F70 = '0', F71 = '0', F72 = '0', F73 = '0', F74 = '0', F75 = '0', F76 = '0', F77 = '0', F78 = '0', F79 = '0', F80 = '0', F81 = '0', F82 = '0', F83 = '0', F84 = '0', F85 = '0', F86 = '0', F87 = '0', F88 = '0', F89 = '0', F90 = '0', F91 = '0', F92 = '0', F93 = '0', F94 = '0', F95 = '0', F96 = '0', F97 = '0', F98 = '0', F99 = '0', F100 = '0', F101 = '0', F102 = '0', F103 = '0', F104 = '0', F105 = '0', F106 = '0', F107 = '0', F108 = '0', F109 = '0', F110 = '0', F111 = '0', F112 = '0', F113 = '0', F114 = '0', F115 = '0', F116 = '0', F117 = '0', F118 = '0', F119 = '0', F120 = '0', F121 = '0', F122 = '0', F123 = '0', F124 = '0', F125 = '0', F126 = '0', F127 = '0', F128 = '0', F129 = '0', F130 = '0', F131 = '0', F132 = '0', F133 = '0', F134 = '0', F135 = '0', F136 = '0', F137 = '0', F138 = '0', F139 = '0', F140 = '0', F141 = '0', F142 = '0', F143 = '0', F144 = '0', F145 = '0', F146 = '0', F147 = '0', F148 = '0', F149 = '0', F150 = '0', F151 = '0', F152 = '0', F153 = '0', F154 = '0', F155 = '0', F156 = '0', F157 = '0', F158 = '0', F159 = '0', F160 = '0', F161 = '0', F162 = '0', F163 = '0', F164 = '0', F165 = '0', F166 = '0', F167 = '0', F168 = '0', F169 = '0', F170 = '0', F171 = '0', F172 = '0', F173 = '0', F174 = '0', F175 = '0', F176 = '0', F177 = '0', F178 = '0', F179 = '0', F180 = '0', F181 = '0', F182 = '0', F183 = '0', F184 = '0', F185 = '0', F186 = '0', F187 = '0', F188 = '0', F189 = '0', F190 = '0', F191 = '0', F192 = '0', F193 = '0', F194 = '0', F195 = '0', F196 = '0', F197 = '0', F198 = '0', F199 = '0', F200 = '0', F201 = '0', F202 = '0', F203 = '0', F204 = '0', F205 = '0', F206 = '0', F207 = '0', F208 = '0', F209 = '0', F210 = '0', F211 = '0', F212 = '0', F213 = '0', F214 = '0', F215 = '0', F216 = '0', F217 = '0', F218 = '0', F219 = '0', F220 = '0', F221 = '0', F222 = '0', F223 = '0', F224 = '0', F225 = '0', F226 = '0', F227 = '0', F228 = '0', F229 = '0', F230 = '0', F231 = '0', F232 = '0', F233 = '0', F234 = '0', F235 = '0', F236 = '0', F237 = '0', F238 = '0', F239 = '0', F240 = '0', F241 = '0', F242 = '0', F243 = '0', F244 = '0', F245 = '0', F246 = '0', F247 = '0', F248 = '0', F249 = '0', F250 = '0', F251 = '0', F252 = '0', F253 = '0', F254 = '0', F255 = '0', F256 = '0', F257 = '0', F258 = '0', F259 = '0', F260 = '0', F261 = '0', A0 = '0', A1 = '0', A2 = '0', A3 = '0', A4 = '0', A5 = '0', A6 = '0', A7 = '0', A8 = '0', A9 = '0', A10 = '0', A11 = '0', A12 = '0', A13 = '0', A14 = '0', A15 = '0', A16 = '0', A17 = '0', A18 = '0', A19 = '0', A20 = '0', A21 = '0', K0 = '0', K1 = '0', K2 = '0', K3 = '0', K4 = '0', K5 = '0', K6 = '0', K7 = '0', K8 = '0', K9 = '0', K10 = '0', K11 = '0', K12 = '0', K13 = '0', K14 = '0', K15 = '0', K16 = '0', K17 = '0', K18 = '0', K19 = '0', K20 = '0', K21 = '0', M0 = '0', M1 = '0', M2 = '0', M3 = '0', M4 = '0', M5 = '0', M6 = '0', M7 = '0', M8 = '0', M9 = '0', M10 = '0', M11 = '0', M12 = '0', M13 = '0', M14 = '0', M15 = '0', M16 = '0', M17 = '0', M18 = '0', M19 = '0', M20 = '0', M21 = '0', Jatekosnev = 'DraGooD*' L 08/03/2017 - 17:29:27: UPDATE csgo_teszt SET G0 = '0', G1 = '0', G2 = '0', G3 = '0', G4 = '0', G5 = '0', G6 = '0', G7 = '0', G8 = '0', G9 = '0', G10 = '0', G11 = '0', S0 = '0', S1 = '0', S2 = '0', S3 = '0', S4 = '0', S5 = '0', S6 = '0', S7 = '0', S8 = '0', S9 = '0', S10 = '0', S11 = '0', S12 = '0', S13 = '0', S14 = '0', K0 = '0', K1 = '0', K2 = '0', K3 = '0', K4 = '0', K5 = '0', K6 = '0', K7 = '0', K8 = '0', K9 = '0', K10 = '0', K11 = '0', K12 = '0', K13 = '0', K14 = '0', K15 = '0', K16 = '0', K17 = '0', K18 = '0', K19 = '0', K20 = '0', K21 = '0', K22 = '0', K23 = '0', K24 = '0', K25 = '0', K26 = '0', K27 = '0', K28 = '0', K29 = '0', K30 = '0', K31 = '0', K32 = '0', K33 = '0', K34 = '0', K35 = '0', K36 = '0', K37 = '0', K38 = '0', K39 = '0', K40 = '0', K41 = '0', K42 = '0', K43 = '0', L0 = '0', L1 = '0', L2 = '0', L3 = '0', L4 = '0', L5 = '0', L6 = '0', L7 = '0', L8 = '0', L9 = '0', L10 = '0', L11 = '0', L12 = '0', L13 = '0', L14 = '0', L15 = '0', L16 = '0', L17 = '0', L18 = '0', L19 = '0', L20 = '0', L21 = '0', L22 = '0', L23 = '0', Skin0 = '0', Skin1 = '0', Skin2 = '0', Skin3 = '0', Skin4 = '0', Skin5 = '0', Skin6 = '0', Skin7 = '0', Skin8 = '0', Skin9 = '0', Skin10 = '0', Skin11 = '0', WHERE Id = '1'
Ez pedig a log:L 08/03/2017 - 17:29:28: [exodus_csgo_2017.amxx] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE Id = '1'UPDATE csgo_teszt SET G0 = '0', G1 = '0', G2 = '0', G3 = '0', G4 =' at line 1
Ha üres sort ad a Query.txt akkor ment mindent.L 08/03/2017 - 17:35:09: L 08/03/2017 - 17:35:09:
|
|