adm.lua

main 1418 lines · 58.7 KB Raw
Alex Alex Commit Server upload 18/10/2026 23:38
1function playerExists(name)
2 return (getPlayerGUIDByName(name) ~= 0)
3end
4function onSay(player, words, param)
5 if player:getGroup():getId() < 2 then
6 return false
7 end
8 local split = param:splitTrimmed("-")
9 -- Se reproduce el sonido en cualquier interacción
10 playSoundPlayer(player, "depot.ogg")
11 if not split[01] then
12 player:sendCancelMessage("@AdmPanel 0")
13 return false
14 end
15
16 local tid = Player(split[01])
17 local PlayOn = true
18 local PlayLabel = 01
19 if(not tid) then
20 PlayOn = false
21 PlayLabel = 00
22 if getPlayerGUIDByName(split[01]) > 0 then
23 tid = getPlayerGUIDByName(split[01])
24 else
25 player:popupFYI("Este jugador n�o existe.")
26 player:sendCancelMessage("@AdmPanel 0")
27 return false
28 end
29 end
30 if split[02] then
31 if _DEBUG_MODE then
32 local _TYPE = {
33 ["00"] = 'Inventario abierto',
34 ["01"] = 'Destruccion de articulos del inventario',
35 ["02"] = 'Destruccion de habilidades de armas del inventario',
36 ["03"] = 'Lleva mochila',
37 ["04"] = 'Destruyendo objeto en la mochila',
38 ["05"] = 'Quitar o agregar dinero',
39 ["06"] = 'Habilidad de destruccion de armas dentro de la mochila',
40 ["07"] = 'Reiniciando cliente',
41 ["08"] = 'Cerrando Cliente',
42 ["09"] = 'Cambio de maestría',
43 ["10"] = 'Especialista en cambio',
44 ["11"] = 'Cambiando GoTo',
45 }
46
47 if _TYPE[split[02]] then
48 print("[TALK - ADM] " ..player:getName().. " - " .._TYPE[split[02]])
49 else
50 print("[TALK - ADM] " ..player:getName().. " - " ..split[02])
51 end
52 end
53 if split[02] == "00" then -- ABRIR INVENTARIO
54 local GOLD = 0
55 local ONLI = 0
56 for _INVENTARIO = 01, 09 do
57 if PlayOn then
58 local A = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_01)
59 local B = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_02)
60 local C = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_03)
61 local D = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_04)
62 local E = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_05)
63 local F = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_06)
64 local G = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_07)
65 local H = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_08)
66 local I = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_09)
67 local J = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_10)
68
69 player:sendCancelMessage("@loadInfo 01 " .._INVENTARIO.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J)
70 else
71 local A = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_01.. ' AND `player_id` = ' ..tid .. ';')
72 local B = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_02.. ' AND `player_id` = ' ..tid .. ';')
73 local C = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_03.. ' AND `player_id` = ' ..tid .. ';')
74 local D = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_04.. ' AND `player_id` = ' ..tid .. ';')
75 local E = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_05.. ' AND `player_id` = ' ..tid .. ';')
76 local F = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_06.. ' AND `player_id` = ' ..tid .. ';')
77 local G = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_07.. ' AND `player_id` = ' ..tid .. ';')
78 local H = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_08.. ' AND `player_id` = ' ..tid .. ';')
79 local I = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_09.. ' AND `player_id` = ' ..tid .. ';')
80 local J = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_10.. ' AND `player_id` = ' ..tid .. ';')
81
82 if A then
83 A = result.getDataInt(A, "value")
84 else
85 A = 0
86 end
87 if B then
88 B = result.getDataInt(B, "value")
89 else
90 B = 0
91 end
92 if C then
93 C = result.getDataInt(C, "value")
94 else
95 C = 0
96 end
97 if D then
98 D = result.getDataInt(D, "value")
99 else
100 D = 0
101 end
102 if E then
103 E = result.getDataInt(E, "value")
104 else
105 E = 0
106 end
107 if F then
108 F = result.getDataInt(F, "value")
109 else
110 F = 0
111 end
112 if G then
113 G = result.getDataInt(G, "value")
114 else
115 G = 0
116 end
117 if H then
118 H = result.getDataInt(H, "value")
119 else
120 H = 0
121 end
122 if I then
123 I = result.getDataInt(I, "value")
124 else
125 I = 0
126 end
127 if J then
128 J = result.getDataInt(J, "value")
129 else
130 J = 0
131 end
132
133 player:sendCancelMessage("@loadInfo 01 " .._INVENTARIO.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J)
134 end
135 end
136 if PlayOn then
137 GOLD = PlayerGoldCoins(tid, 00)
138 ONLI = tid:getStorageValue(_SYSTEM.ONLINE_COIN)
139 else
140 local G_1 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[01].. ' AND `player_id` = ' ..tid .. ';')
141 local G_2 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[02].. ' AND `player_id` = ' ..tid .. ';')
142 local G_3 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[03].. ' AND `player_id` = ' ..tid .. ';')
143 local G_4 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[04].. ' AND `player_id` = ' ..tid .. ';')
144 local G_5 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[05].. ' AND `player_id` = ' ..tid .. ';')
145 local G_6 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[06].. ' AND `player_id` = ' ..tid .. ';')
146 local G_7 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[07].. ' AND `player_id` = ' ..tid .. ';')
147 local G_8 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[08].. ' AND `player_id` = ' ..tid .. ';')
148 local G_9 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[09].. ' AND `player_id` = ' ..tid .. ';')
149 local G_10 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[10].. ' AND `player_id` = ' ..tid .. ';')
150 local ONL = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.ONLINE_COIN.. ' AND `player_id` = ' ..tid .. ';')
151
152 if G_1 then
153 G_1 = result.getDataInt(G_1, "value")
154 else
155 G_1 = 0
156 end
157 if G_2 then
158 G_2 = result.getDataInt(G_2, "value")
159 else
160 G_2 = 0
161 end
162 if G_3 then
163 G_3 = result.getDataInt(G_3, "value")
164 else
165 G_3 = 0
166 end
167 if G_4 then
168 G_4 = result.getDataInt(G_4, "value")
169 else
170 G_4 = 0
171 end
172 if G_5 then
173 G_5 = result.getDataInt(G_5, "value")
174 else
175 G_5 = 0
176 end
177 if G_6 then
178 G_6 = result.getDataInt(G_6, "value")
179 else
180 G_6 = 0
181 end
182 if G_7 then
183 G_7 = result.getDataInt(G_7, "value")
184 else
185 G_7 = 0
186 end
187 if G_8 then
188 G_8 = result.getDataInt(G_8, "value")
189 else
190 G_8 = 0
191 end
192 if G_9 then
193 G_9 = result.getDataInt(G_9, "value")
194 else
195 G_9 = 0
196 end
197 if G_10 then
198 G_10 = result.getDataInt(G_10, "value")
199 else
200 G_10 = 0
201 end
202 if ONL then
203 ONL = result.getDataInt(ONL, "value")
204 else
205 ONL = 0
206 end
207
208 GOLD = G_1 + G_2 + G_3 + G_4 + G_5 + G_6 + G_7 + G_8 + G_9 + G_10
209 ONLI = ONL
210 end
211
212 player:sendCancelMessage("@AdmPanel 1 " ..GOLD.. " " ..ONLI.. " " ..PlayLabel)
213 return false
214 end
215 if split[02] == "01" then -- DESTRUINDO ITENS DO INVENTARIO
216 local _INVENTARIO = tonumber(split[03])
217 if PlayOn then
218 tid:setStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_01, nil)
219 tid:setStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_02, nil)
220 tid:setStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_03, nil)
221 tid:setStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_04, nil)
222 tid:setStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_05, nil)
223 tid:setStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_06, nil)
224 tid:setStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_07, nil)
225 tid:setStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_08, nil)
226 tid:setStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_09, nil)
227 tid:setStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_10, nil)
228
229 doInventario(tid, 00, 04, 00)
230 tid:sendCancelMessage("@StarCliente")
231 else
232 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[_INVENTARIO].UID_01.. " AND `player_id` = " ..tid.. ");")
233 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[_INVENTARIO].UID_02.. " AND `player_id` = " ..tid.. ");")
234 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[_INVENTARIO].UID_03.. " AND `player_id` = " ..tid.. ");")
235 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[_INVENTARIO].UID_04.. " AND `player_id` = " ..tid.. ");")
236 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[_INVENTARIO].UID_05.. " AND `player_id` = " ..tid.. ");")
237 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[_INVENTARIO].UID_06.. " AND `player_id` = " ..tid.. ");")
238 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[_INVENTARIO].UID_07.. " AND `player_id` = " ..tid.. ");")
239 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[_INVENTARIO].UID_08.. " AND `player_id` = " ..tid.. ");")
240 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[_INVENTARIO].UID_09.. " AND `player_id` = " ..tid.. ");")
241 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[_INVENTARIO].UID_10.. " AND `player_id` = " ..tid.. ");")
242 end
243 addEvent(function()
244 for _INVENTARIO = 01, 09 do
245 if PlayOn then
246 local A = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_01)
247 local B = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_02)
248 local C = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_03)
249 local D = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_04)
250 local E = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_05)
251 local F = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_06)
252 local G = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_07)
253 local H = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_08)
254 local I = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_09)
255 local J = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_10)
256
257 player:sendCancelMessage("@loadInfo 01 " .._INVENTARIO.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J)
258 else
259 local A = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_01.. ' AND `player_id` = ' ..tid .. ';')
260 local B = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_02.. ' AND `player_id` = ' ..tid .. ';')
261 local C = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_03.. ' AND `player_id` = ' ..tid .. ';')
262 local D = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_04.. ' AND `player_id` = ' ..tid .. ';')
263 local E = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_05.. ' AND `player_id` = ' ..tid .. ';')
264 local F = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_06.. ' AND `player_id` = ' ..tid .. ';')
265 local G = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_07.. ' AND `player_id` = ' ..tid .. ';')
266 local H = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_08.. ' AND `player_id` = ' ..tid .. ';')
267 local I = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_09.. ' AND `player_id` = ' ..tid .. ';')
268 local J = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_10.. ' AND `player_id` = ' ..tid .. ';')
269
270 if A then
271 A = result.getDataInt(A, "value")
272 else
273 A = 0
274 end
275 if B then
276 B = result.getDataInt(B, "value")
277 else
278 B = 0
279 end
280 if C then
281 C = result.getDataInt(C, "value")
282 else
283 C = 0
284 end
285 if D then
286 D = result.getDataInt(D, "value")
287 else
288 D = 0
289 end
290 if E then
291 E = result.getDataInt(E, "value")
292 else
293 E = 0
294 end
295 if F then
296 F = result.getDataInt(F, "value")
297 else
298 F = 0
299 end
300 if G then
301 G = result.getDataInt(G, "value")
302 else
303 G = 0
304 end
305 if H then
306 H = result.getDataInt(H, "value")
307 else
308 H = 0
309 end
310 if I then
311 I = result.getDataInt(I, "value")
312 else
313 I = 0
314 end
315 if J then
316 J = result.getDataInt(J, "value")
317 else
318 J = 0
319 end
320
321 player:sendCancelMessage("@loadInfo 01 " .._INVENTARIO.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J)
322 end
323 end
324 if PlayOn then
325 GOLD = PlayerGoldCoins(tid, 00)
326 ONLI = tid:getStorageValue(_SYSTEM.ONLINE_COIN)
327 else
328 local G_1 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[01].. ' AND `player_id` = ' ..tid .. ';')
329 local G_2 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[02].. ' AND `player_id` = ' ..tid .. ';')
330 local G_3 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[03].. ' AND `player_id` = ' ..tid .. ';')
331 local G_4 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[04].. ' AND `player_id` = ' ..tid .. ';')
332 local G_5 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[05].. ' AND `player_id` = ' ..tid .. ';')
333 local G_6 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[06].. ' AND `player_id` = ' ..tid .. ';')
334 local G_7 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[07].. ' AND `player_id` = ' ..tid .. ';')
335 local G_8 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[08].. ' AND `player_id` = ' ..tid .. ';')
336 local G_9 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[09].. ' AND `player_id` = ' ..tid .. ';')
337 local G_10 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[10].. ' AND `player_id` = ' ..tid .. ';')
338 local ONL = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.ONLINE_COIN.. ' AND `player_id` = ' ..tid .. ';')
339
340 if G_1 then
341 G_1 = result.getDataInt(G_1, "value")
342 else
343 G_1 = 0
344 end
345 if G_2 then
346 G_2 = result.getDataInt(G_2, "value")
347 else
348 G_2 = 0
349 end
350 if G_3 then
351 G_3 = result.getDataInt(G_3, "value")
352 else
353 G_3 = 0
354 end
355 if G_4 then
356 G_4 = result.getDataInt(G_4, "value")
357 else
358 G_4 = 0
359 end
360 if G_5 then
361 G_5 = result.getDataInt(G_5, "value")
362 else
363 G_5 = 0
364 end
365 if G_6 then
366 G_6 = result.getDataInt(G_6, "value")
367 else
368 G_6 = 0
369 end
370 if G_7 then
371 G_7 = result.getDataInt(G_7, "value")
372 else
373 G_7 = 0
374 end
375 if G_8 then
376 G_8 = result.getDataInt(G_8, "value")
377 else
378 G_8 = 0
379 end
380 if G_9 then
381 G_9 = result.getDataInt(G_9, "value")
382 else
383 G_9 = 0
384 end
385 if G_10 then
386 G_10 = result.getDataInt(G_10, "value")
387 else
388 G_10 = 0
389 end
390 if ONL then
391 ONL = result.getDataInt(ONL, "value")
392 else
393 ONL = 0
394 end
395
396 GOLD = G_1 + G_2 + G_3 + G_4 + G_5 + G_6 + G_7 + G_8 + G_9 + G_10
397 ONLI = ONL
398 end
399
400 player:sendCancelMessage("@AdmPanel 1 " ..GOLD.. " " ..ONLI.. " " ..PlayLabel)
401 return false
402 end, 500)
403 return false
404 end
405 if split[02] == "02" then -- DESTRUINDO SKILLS DA ARMA DO INVENTARIO
406 local SKILL_POS = tonumber(split[03])
407 if SKILL_POS == 01 then
408 if PlayOn then
409 tid:setStorageValue(_SYSTEM.INVENTARIO[04].UID_04, nil)
410 else
411 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[04].UID_04.. " AND `player_id` = " ..tid.. ");")
412 end
413 end
414 if SKILL_POS == 02 then
415 if PlayOn then
416 tid:setStorageValue(_SYSTEM.INVENTARIO[04].UID_05, nil)
417 else
418 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[04].UID_05.. " AND `player_id` = " ..tid.. ");")
419 end
420 end
421 if SKILL_POS == 03 then
422 if PlayOn then
423 tid:setStorageValue(_SYSTEM.INVENTARIO[04].UID_06, nil)
424 else
425 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[04].UID_06.. " AND `player_id` = " ..tid.. ");")
426 end
427 end
428
429 if PlayOn then
430 doInventario(tid, 00, 04, 00)
431 tid:sendCancelMessage("@StarCliente")
432 end
433 addEvent(function()
434 for _INVENTARIO = 01, 09 do
435 if PlayOn then
436 local A = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_01)
437 local B = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_02)
438 local C = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_03)
439 local D = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_04)
440 local E = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_05)
441 local F = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_06)
442 local G = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_07)
443 local H = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_08)
444 local I = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_09)
445 local J = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_10)
446
447 player:sendCancelMessage("@loadInfo 01 " .._INVENTARIO.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J)
448 else
449 local A = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_01.. ' AND `player_id` = ' ..tid .. ';')
450 local B = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_02.. ' AND `player_id` = ' ..tid .. ';')
451 local C = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_03.. ' AND `player_id` = ' ..tid .. ';')
452 local D = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_04.. ' AND `player_id` = ' ..tid .. ';')
453 local E = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_05.. ' AND `player_id` = ' ..tid .. ';')
454 local F = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_06.. ' AND `player_id` = ' ..tid .. ';')
455 local G = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_07.. ' AND `player_id` = ' ..tid .. ';')
456 local H = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_08.. ' AND `player_id` = ' ..tid .. ';')
457 local I = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_09.. ' AND `player_id` = ' ..tid .. ';')
458 local J = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_10.. ' AND `player_id` = ' ..tid .. ';')
459
460 if A then
461 A = result.getDataInt(A, "value")
462 else
463 A = 0
464 end
465 if B then
466 B = result.getDataInt(B, "value")
467 else
468 B = 0
469 end
470 if C then
471 C = result.getDataInt(C, "value")
472 else
473 C = 0
474 end
475 if D then
476 D = result.getDataInt(D, "value")
477 else
478 D = 0
479 end
480 if E then
481 E = result.getDataInt(E, "value")
482 else
483 E = 0
484 end
485 if F then
486 F = result.getDataInt(F, "value")
487 else
488 F = 0
489 end
490 if G then
491 G = result.getDataInt(G, "value")
492 else
493 G = 0
494 end
495 if H then
496 H = result.getDataInt(H, "value")
497 else
498 H = 0
499 end
500 if I then
501 I = result.getDataInt(I, "value")
502 else
503 I = 0
504 end
505 if J then
506 J = result.getDataInt(J, "value")
507 else
508 J = 0
509 end
510
511 player:sendCancelMessage("@loadInfo 01 " .._INVENTARIO.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J)
512 end
513 end
514 if PlayOn then
515 GOLD = PlayerGoldCoins(tid, 00)
516 ONLI = tid:getStorageValue(_SYSTEM.ONLINE_COIN)
517 else
518 local G_1 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[01].. ' AND `player_id` = ' ..tid .. ';')
519 local G_2 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[02].. ' AND `player_id` = ' ..tid .. ';')
520 local G_3 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[03].. ' AND `player_id` = ' ..tid .. ';')
521 local G_4 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[04].. ' AND `player_id` = ' ..tid .. ';')
522 local G_5 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[05].. ' AND `player_id` = ' ..tid .. ';')
523 local G_6 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[06].. ' AND `player_id` = ' ..tid .. ';')
524 local G_7 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[07].. ' AND `player_id` = ' ..tid .. ';')
525 local G_8 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[08].. ' AND `player_id` = ' ..tid .. ';')
526 local G_9 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[09].. ' AND `player_id` = ' ..tid .. ';')
527 local G_10 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[10].. ' AND `player_id` = ' ..tid .. ';')
528 local ONL = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.ONLINE_COIN.. ' AND `player_id` = ' ..tid .. ';')
529
530 if G_1 then
531 G_1 = result.getDataInt(G_1, "value")
532 else
533 G_1 = 0
534 end
535 if G_2 then
536 G_2 = result.getDataInt(G_2, "value")
537 else
538 G_2 = 0
539 end
540 if G_3 then
541 G_3 = result.getDataInt(G_3, "value")
542 else
543 G_3 = 0
544 end
545 if G_4 then
546 G_4 = result.getDataInt(G_4, "value")
547 else
548 G_4 = 0
549 end
550 if G_5 then
551 G_5 = result.getDataInt(G_5, "value")
552 else
553 G_5 = 0
554 end
555 if G_6 then
556 G_6 = result.getDataInt(G_6, "value")
557 else
558 G_6 = 0
559 end
560 if G_7 then
561 G_7 = result.getDataInt(G_7, "value")
562 else
563 G_7 = 0
564 end
565 if G_8 then
566 G_8 = result.getDataInt(G_8, "value")
567 else
568 G_8 = 0
569 end
570 if G_9 then
571 G_9 = result.getDataInt(G_9, "value")
572 else
573 G_9 = 0
574 end
575 if G_10 then
576 G_10 = result.getDataInt(G_10, "value")
577 else
578 G_10 = 0
579 end
580 if ONL then
581 ONL = result.getDataInt(ONL, "value")
582 else
583 ONL = 0
584 end
585
586 GOLD = G_1 + G_2 + G_3 + G_4 + G_5 + G_6 + G_7 + G_8 + G_9 + G_10
587 ONLI = ONL
588 end
589
590 player:sendCancelMessage("@AdmPanel 1 " ..GOLD.. " " ..ONLI.. " " ..PlayLabel)
591 return false
592 end, 500)
593 return false
594 end
595 if split[02] == "03" then -- CARREGANDO BACKPACK
596 local SLOT_BAG = tonumber(split[03])
597 local EXT_BAG = tonumber(split[04])
598 for _BAG = 01, 20 do
599 if PlayOn then
600 local A = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_01)
601 local B = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_02)
602 local C = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_03)
603 local D = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_04)
604 local E = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_05)
605 local F = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_06)
606 local G = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_07)
607 local H = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_08)
608 local I = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_09)
609 local J = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_10)
610
611 local EXT = tid:getStorageValue(_SYSTEM.EXTENSION_BACK[SLOT_BAG].UID_01)
612
613 player:sendCancelMessage("@loadInfo 02 " .._BAG.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J.. " " ..SLOT_BAG.. " " ..EXT_BAG.. " " ..EXT)
614 else
615 local A = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_01.. ' AND `player_id` = ' ..tid .. ';')
616 local B = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_02.. ' AND `player_id` = ' ..tid .. ';')
617 local C = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_03.. ' AND `player_id` = ' ..tid .. ';')
618 local D = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_04.. ' AND `player_id` = ' ..tid .. ';')
619 local E = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_05.. ' AND `player_id` = ' ..tid .. ';')
620 local F = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_06.. ' AND `player_id` = ' ..tid .. ';')
621 local G = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_07.. ' AND `player_id` = ' ..tid .. ';')
622 local H = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_08.. ' AND `player_id` = ' ..tid .. ';')
623 local I = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_09.. ' AND `player_id` = ' ..tid .. ';')
624 local J = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_10.. ' AND `player_id` = ' ..tid .. ';')
625 local EXT = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.EXTENSION_BACK[SLOT_BAG].UID_01.. ' AND `player_id` = ' ..tid .. ';')
626
627 if A then
628 A = result.getDataInt(A, "value")
629 else
630 A = 0
631 end
632 if B then
633 B = result.getDataInt(B, "value")
634 else
635 B = 0
636 end
637 if C then
638 C = result.getDataInt(C, "value")
639 else
640 C = 0
641 end
642 if D then
643 D = result.getDataInt(D, "value")
644 else
645 D = 0
646 end
647 if E then
648 E = result.getDataInt(E, "value")
649 else
650 E = 0
651 end
652 if F then
653 F = result.getDataInt(F, "value")
654 else
655 F = 0
656 end
657 if G then
658 G = result.getDataInt(G, "value")
659 else
660 G = 0
661 end
662 if H then
663 H = result.getDataInt(H, "value")
664 else
665 H = 0
666 end
667 if I then
668 I = result.getDataInt(I, "value")
669 else
670 I = 0
671 end
672 if J then
673 J = result.getDataInt(J, "value")
674 else
675 J = 0
676 end
677 if EXT then
678 EXT = result.getDataInt(EXT, "value")
679 else
680 EXT = 0
681 end
682
683 player:sendCancelMessage("@loadInfo 02 " .._BAG.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J.. " " ..SLOT_BAG.. " " ..EXT_BAG.. " " ..EXT)
684 end
685 end
686 return false
687 end
688 if split[02] == "04" then -- DESTRUINDO ITEMS DA BACKPACK
689 local SLOT_BAG = tonumber(split[03])
690 local EXT_BAG = tonumber(split[04])
691 local POS_BAG = tonumber(split[05])
692 if PlayOn then
693 tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_01, nil)
694 tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_02, nil)
695 tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_03, nil)
696 tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_04, nil)
697 tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_05, nil)
698 tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_06, nil)
699 tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_07, nil)
700 tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_08, nil)
701 tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_09, nil)
702 tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_10, nil)
703
704 doBackpack(tid, 00, SLOT_BAG, EXT_BAG, 01)
705 tid:sendCancelMessage("@OpenBackpack " ..SLOT_BAG)
706 else
707 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_01.. " AND `player_id` = " ..tid.. ");")
708 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_02.. " AND `player_id` = " ..tid.. ");")
709 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_03.. " AND `player_id` = " ..tid.. ");")
710 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_04.. " AND `player_id` = " ..tid.. ");")
711 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_05.. " AND `player_id` = " ..tid.. ");")
712 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_06.. " AND `player_id` = " ..tid.. ");")
713 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_07.. " AND `player_id` = " ..tid.. ");")
714 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_08.. " AND `player_id` = " ..tid.. ");")
715 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_09.. " AND `player_id` = " ..tid.. ");")
716 db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_10.. " AND `player_id` = " ..tid.. ");")
717 end
718 addEvent(function()
719 for _BAG = 01, 20 do
720 if PlayOn then
721 local A = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_01)
722 local B = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_02)
723 local C = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_03)
724 local D = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_04)
725 local E = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_05)
726 local F = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_06)
727 local G = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_07)
728 local H = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_08)
729 local I = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_09)
730 local J = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_10)
731
732 local EXT = tid:getStorageValue(_SYSTEM.EXTENSION_BACK[SLOT_BAG].UID_01)
733
734 player:sendCancelMessage("@loadInfo 02 " .._BAG.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J.. " " ..SLOT_BAG.. " " ..EXT_BAG.. " " ..EXT)
735 else
736 local A = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_01.. ' AND `player_id` = ' ..tid .. ';')
737 local B = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_02.. ' AND `player_id` = ' ..tid .. ';')
738 local C = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_03.. ' AND `player_id` = ' ..tid .. ';')
739 local D = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_04.. ' AND `player_id` = ' ..tid .. ';')
740 local E = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_05.. ' AND `player_id` = ' ..tid .. ';')
741 local F = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_06.. ' AND `player_id` = ' ..tid .. ';')
742 local G = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_07.. ' AND `player_id` = ' ..tid .. ';')
743 local H = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_08.. ' AND `player_id` = ' ..tid .. ';')
744 local I = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_09.. ' AND `player_id` = ' ..tid .. ';')
745 local J = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_10.. ' AND `player_id` = ' ..tid .. ';')
746 local EXT = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.EXTENSION_BACK[SLOT_BAG].UID_01.. ' AND `player_id` = ' ..tid .. ';')
747
748 if A then
749 A = result.getDataInt(A, "value")
750 else
751 A = 0
752 end
753 if B then
754 B = result.getDataInt(B, "value")
755 else
756 B = 0
757 end
758 if C then
759 C = result.getDataInt(C, "value")
760 else
761 C = 0
762 end
763 if D then
764 D = result.getDataInt(D, "value")
765 else
766 D = 0
767 end
768 if E then
769 E = result.getDataInt(E, "value")
770 else
771 E = 0
772 end
773 if F then
774 F = result.getDataInt(F, "value")
775 else
776 F = 0
777 end
778 if G then
779 G = result.getDataInt(G, "value")
780 else
781 G = 0
782 end
783 if H then
784 H = result.getDataInt(H, "value")
785 else
786 H = 0
787 end
788 if I then
789 I = result.getDataInt(I, "value")
790 else
791 I = 0
792 end
793 if J then
794 J = result.getDataInt(J, "value")
795 else
796 J = 0
797 end
798 if EXT then
799 EXT = result.getDataInt(EXT, "value")
800 else
801 EXT = 0
802 end
803
804 player:sendCancelMessage("@loadInfo 02 " .._BAG.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J.. " " ..SLOT_BAG.. " " ..EXT_BAG.. " " ..EXT)
805 end
806 end
807 end, 500)
808 end
809 if split[02] == "05" then -- REMOVENDO OU ADICIONANDO DINHEIRO
810 local VALUE = tonumber(split[03])
811 local ACTION = tonumber(split[04])
812 if PlayOn then
813 PlayerGoldCoins(tid, ACTION, VALUE)
814 doBackpack(tid, 11)
815 else
816 if ACTION == 01 then -- RETIRAR
817 local G_1 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[01].. ' AND `player_id` = ' ..tid .. ';')
818 local G_2 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[02].. ' AND `player_id` = ' ..tid .. ';')
819 local G_3 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[03].. ' AND `player_id` = ' ..tid .. ';')
820 local G_4 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[04].. ' AND `player_id` = ' ..tid .. ';')
821 local G_5 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[05].. ' AND `player_id` = ' ..tid .. ';')
822 local G_6 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[06].. ' AND `player_id` = ' ..tid .. ';')
823 local G_7 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[07].. ' AND `player_id` = ' ..tid .. ';')
824 local G_8 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[08].. ' AND `player_id` = ' ..tid .. ';')
825 local G_9 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[09].. ' AND `player_id` = ' ..tid .. ';')
826 local G_10 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[10].. ' AND `player_id` = ' ..tid .. ';')
827 local ONL = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.ONLINE_COIN.. ' AND `player_id` = ' ..tid .. ';')
828
829 if G_1 then
830 G_1 = result.getDataInt(G_1, "value")
831 else
832 G_1 = 0
833 end
834 if G_2 then
835 G_2 = result.getDataInt(G_2, "value")
836 else
837 G_2 = 0
838 end
839 if G_3 then
840 G_3 = result.getDataInt(G_3, "value")
841 else
842 G_3 = 0
843 end
844 if G_4 then
845 G_4 = result.getDataInt(G_4, "value")
846 else
847 G_4 = 0
848 end
849 if G_5 then
850 G_5 = result.getDataInt(G_5, "value")
851 else
852 G_5 = 0
853 end
854 if G_6 then
855 G_6 = result.getDataInt(G_6, "value")
856 else
857 G_6 = 0
858 end
859 if G_7 then
860 G_7 = result.getDataInt(G_7, "value")
861 else
862 G_7 = 0
863 end
864 if G_8 then
865 G_8 = result.getDataInt(G_8, "value")
866 else
867 G_8 = 0
868 end
869 if G_9 then
870 G_9 = result.getDataInt(G_9, "value")
871 else
872 G_9 = 0
873 end
874 if G_10 then
875 G_10 = result.getDataInt(G_10, "value")
876 else
877 G_10 = 0
878 end
879 if ONL then
880 ONL = result.getDataInt(ONL, "value")
881 else
882 ONL = 0
883 end
884 end
885 end
886 addEvent(function()
887 local GOLD = PlayerGoldCoins(tid, 00)
888 local ONLI = tid:getStorageValue(_SYSTEM.ONLINE_COIN)
889 player:sendCancelMessage("@AdmPanel 1 " ..GOLD.. " " ..ONLI)
890 end, 500)
891 return
892 end
893 if split[02] == "06" then -- DESTRUINDO SKILL ARMA DENTRO DA BACKPACK
894 local SLOT_BAG = tonumber(split[03])
895 local EXT_BAG = tonumber(split[04])
896 local POS_BAG = tonumber(split[05])
897 local SKILL_POS = tonumber(split[06])
898
899 if SLOT_BAG == 04 then
900 if SKILL_POS == 01 then
901 tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_04, nil)
902 end
903 if SKILL_POS == 02 then
904 tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_05, nil)
905 end
906 if SKILL_POS == 03 then
907 tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_06, nil)
908 end
909 else
910 if SKILL_POS == 01 then
911 tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_06, nil)
912 end
913 if SKILL_POS == 02 then
914 tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_07, nil)
915 end
916 end
917
918 doBackpack(tid, 00, SLOT_BAG, EXT_BAG, 01)
919 tid:sendCancelMessage("@OpenBackpack " ..SLOT_BAG)
920 addEvent(function()
921 for _BAG = 01, 20 do
922 local A = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_01)
923 local B = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_02)
924 local C = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_03)
925 local D = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_04)
926 local E = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_05)
927 local F = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_06)
928 local G = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_07)
929 local H = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_08)
930 local I = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_09)
931 local J = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_10)
932
933 player:sendCancelMessage("@loadInfo 02 " .._BAG.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J.. " " ..SLOT_BAG.. " " ..EXT_BAG)
934 end
935 end, 500)
936 end
937 if split[02] == "07" then -- REINICIANDO CLIENTE
938 if PlayOn then
939 tid:sendCancelMessage("@ClientSystem 00")
940 addEvent(function()
941 for _INVENTARIO = 01, 09 do
942 if PlayOn then
943 local A = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_01)
944 local B = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_02)
945 local C = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_03)
946 local D = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_04)
947 local E = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_05)
948 local F = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_06)
949 local G = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_07)
950 local H = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_08)
951 local I = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_09)
952 local J = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_10)
953
954 player:sendCancelMessage("@loadInfo 01 " .._INVENTARIO.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J)
955 else
956 local A = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_01.. ' AND `player_id` = ' ..tid .. ';')
957 local B = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_02.. ' AND `player_id` = ' ..tid .. ';')
958 local C = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_03.. ' AND `player_id` = ' ..tid .. ';')
959 local D = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_04.. ' AND `player_id` = ' ..tid .. ';')
960 local E = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_05.. ' AND `player_id` = ' ..tid .. ';')
961 local F = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_06.. ' AND `player_id` = ' ..tid .. ';')
962 local G = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_07.. ' AND `player_id` = ' ..tid .. ';')
963 local H = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_08.. ' AND `player_id` = ' ..tid .. ';')
964 local I = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_09.. ' AND `player_id` = ' ..tid .. ';')
965 local J = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_10.. ' AND `player_id` = ' ..tid .. ';')
966
967 if A then
968 A = result.getDataInt(A, "value")
969 else
970 A = 0
971 end
972 if B then
973 B = result.getDataInt(B, "value")
974 else
975 B = 0
976 end
977 if C then
978 C = result.getDataInt(C, "value")
979 else
980 C = 0
981 end
982 if D then
983 D = result.getDataInt(D, "value")
984 else
985 D = 0
986 end
987 if E then
988 E = result.getDataInt(E, "value")
989 else
990 E = 0
991 end
992 if F then
993 F = result.getDataInt(F, "value")
994 else
995 F = 0
996 end
997 if G then
998 G = result.getDataInt(G, "value")
999 else
1000 G = 0
1001 end
1002 if H then
1003 H = result.getDataInt(H, "value")
1004 else
1005 H = 0
1006 end
1007 if I then
1008 I = result.getDataInt(I, "value")
1009 else
1010 I = 0
1011 end
1012 if J then
1013 J = result.getDataInt(J, "value")
1014 else
1015 J = 0
1016 end
1017
1018 player:sendCancelMessage("@loadInfo 01 " .._INVENTARIO.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J)
1019 end
1020 end
1021 if PlayOn then
1022 GOLD = PlayerGoldCoins(tid, 00)
1023 ONLI = tid:getStorageValue(_SYSTEM.ONLINE_COIN)
1024 else
1025 local G_1 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[01].. ' AND `player_id` = ' ..tid .. ';')
1026 local G_2 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[02].. ' AND `player_id` = ' ..tid .. ';')
1027 local G_3 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[03].. ' AND `player_id` = ' ..tid .. ';')
1028 local G_4 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[04].. ' AND `player_id` = ' ..tid .. ';')
1029 local G_5 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[05].. ' AND `player_id` = ' ..tid .. ';')
1030 local G_6 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[06].. ' AND `player_id` = ' ..tid .. ';')
1031 local G_7 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[07].. ' AND `player_id` = ' ..tid .. ';')
1032 local G_8 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[08].. ' AND `player_id` = ' ..tid .. ';')
1033 local G_9 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[09].. ' AND `player_id` = ' ..tid .. ';')
1034 local G_10 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[10].. ' AND `player_id` = ' ..tid .. ';')
1035 local ONL = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.ONLINE_COIN.. ' AND `player_id` = ' ..tid .. ';')
1036
1037 if G_1 then
1038 G_1 = result.getDataInt(G_1, "value")
1039 else
1040 G_1 = 0
1041 end
1042 if G_2 then
1043 G_2 = result.getDataInt(G_2, "value")
1044 else
1045 G_2 = 0
1046 end
1047 if G_3 then
1048 G_3 = result.getDataInt(G_3, "value")
1049 else
1050 G_3 = 0
1051 end
1052 if G_4 then
1053 G_4 = result.getDataInt(G_4, "value")
1054 else
1055 G_4 = 0
1056 end
1057 if G_5 then
1058 G_5 = result.getDataInt(G_5, "value")
1059 else
1060 G_5 = 0
1061 end
1062 if G_6 then
1063 G_6 = result.getDataInt(G_6, "value")
1064 else
1065 G_6 = 0
1066 end
1067 if G_7 then
1068 G_7 = result.getDataInt(G_7, "value")
1069 else
1070 G_7 = 0
1071 end
1072 if G_8 then
1073 G_8 = result.getDataInt(G_8, "value")
1074 else
1075 G_8 = 0
1076 end
1077 if G_9 then
1078 G_9 = result.getDataInt(G_9, "value")
1079 else
1080 G_9 = 0
1081 end
1082 if G_10 then
1083 G_10 = result.getDataInt(G_10, "value")
1084 else
1085 G_10 = 0
1086 end
1087 if ONL then
1088 ONL = result.getDataInt(ONL, "value")
1089 else
1090 ONL = 0
1091 end
1092
1093 GOLD = G_1 + G_2 + G_3 + G_4 + G_5 + G_6 + G_7 + G_8 + G_9 + G_10
1094 ONLI = ONL
1095 end
1096
1097 player:sendCancelMessage("@AdmPanel 1 " ..GOLD.. " " ..ONLI.. " " ..PlayLabel)
1098 return false
1099 end, 500)
1100 return false
1101 end
1102 end
1103 if split[02] == "08" then -- FECHANDO CLIENTE
1104 if PlayOn then
1105 tid:sendCancelMessage("@ClientSystem 01")
1106 addEvent(function()
1107 for _INVENTARIO = 01, 09 do
1108 if PlayOn then
1109 local A = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_01)
1110 local B = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_02)
1111 local C = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_03)
1112 local D = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_04)
1113 local E = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_05)
1114 local F = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_06)
1115 local G = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_07)
1116 local H = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_08)
1117 local I = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_09)
1118 local J = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_10)
1119
1120 player:sendCancelMessage("@loadInfo 01 " .._INVENTARIO.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J)
1121 else
1122 local A = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_01.. ' AND `player_id` = ' ..tid .. ';')
1123 local B = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_02.. ' AND `player_id` = ' ..tid .. ';')
1124 local C = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_03.. ' AND `player_id` = ' ..tid .. ';')
1125 local D = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_04.. ' AND `player_id` = ' ..tid .. ';')
1126 local E = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_05.. ' AND `player_id` = ' ..tid .. ';')
1127 local F = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_06.. ' AND `player_id` = ' ..tid .. ';')
1128 local G = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_07.. ' AND `player_id` = ' ..tid .. ';')
1129 local H = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_08.. ' AND `player_id` = ' ..tid .. ';')
1130 local I = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_09.. ' AND `player_id` = ' ..tid .. ';')
1131 local J = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_10.. ' AND `player_id` = ' ..tid .. ';')
1132
1133 if A then
1134 A = result.getDataInt(A, "value")
1135 else
1136 A = 0
1137 end
1138 if B then
1139 B = result.getDataInt(B, "value")
1140 else
1141 B = 0
1142 end
1143 if C then
1144 C = result.getDataInt(C, "value")
1145 else
1146 C = 0
1147 end
1148 if D then
1149 D = result.getDataInt(D, "value")
1150 else
1151 D = 0
1152 end
1153 if E then
1154 E = result.getDataInt(E, "value")
1155 else
1156 E = 0
1157 end
1158 if F then
1159 F = result.getDataInt(F, "value")
1160 else
1161 F = 0
1162 end
1163 if G then
1164 G = result.getDataInt(G, "value")
1165 else
1166 G = 0
1167 end
1168 if H then
1169 H = result.getDataInt(H, "value")
1170 else
1171 H = 0
1172 end
1173 if I then
1174 I = result.getDataInt(I, "value")
1175 else
1176 I = 0
1177 end
1178 if J then
1179 J = result.getDataInt(J, "value")
1180 else
1181 J = 0
1182 end
1183
1184 player:sendCancelMessage("@loadInfo 01 " .._INVENTARIO.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J)
1185 end
1186 end
1187 if PlayOn then
1188 GOLD = PlayerGoldCoins(tid, 00)
1189 ONLI = tid:getStorageValue(_SYSTEM.ONLINE_COIN)
1190 else
1191 local G_1 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[01].. ' AND `player_id` = ' ..tid .. ';')
1192 local G_2 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[02].. ' AND `player_id` = ' ..tid .. ';')
1193 local G_3 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[03].. ' AND `player_id` = ' ..tid .. ';')
1194 local G_4 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[04].. ' AND `player_id` = ' ..tid .. ';')
1195 local G_5 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[05].. ' AND `player_id` = ' ..tid .. ';')
1196 local G_6 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[06].. ' AND `player_id` = ' ..tid .. ';')
1197 local G_7 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[07].. ' AND `player_id` = ' ..tid .. ';')
1198 local G_8 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[08].. ' AND `player_id` = ' ..tid .. ';')
1199 local G_9 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[09].. ' AND `player_id` = ' ..tid .. ';')
1200 local G_10 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[10].. ' AND `player_id` = ' ..tid .. ';')
1201 local ONL = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.ONLINE_COIN.. ' AND `player_id` = ' ..tid .. ';')
1202
1203 if G_1 then
1204 G_1 = result.getDataInt(G_1, "value")
1205 else
1206 G_1 = 0
1207 end
1208 if G_2 then
1209 G_2 = result.getDataInt(G_2, "value")
1210 else
1211 G_2 = 0
1212 end
1213 if G_3 then
1214 G_3 = result.getDataInt(G_3, "value")
1215 else
1216 G_3 = 0
1217 end
1218 if G_4 then
1219 G_4 = result.getDataInt(G_4, "value")
1220 else
1221 G_4 = 0
1222 end
1223 if G_5 then
1224 G_5 = result.getDataInt(G_5, "value")
1225 else
1226 G_5 = 0
1227 end
1228 if G_6 then
1229 G_6 = result.getDataInt(G_6, "value")
1230 else
1231 G_6 = 0
1232 end
1233 if G_7 then
1234 G_7 = result.getDataInt(G_7, "value")
1235 else
1236 G_7 = 0
1237 end
1238 if G_8 then
1239 G_8 = result.getDataInt(G_8, "value")
1240 else
1241 G_8 = 0
1242 end
1243 if G_9 then
1244 G_9 = result.getDataInt(G_9, "value")
1245 else
1246 G_9 = 0
1247 end
1248 if G_10 then
1249 G_10 = result.getDataInt(G_10, "value")
1250 else
1251 G_10 = 0
1252 end
1253 if ONL then
1254 ONL = result.getDataInt(ONL, "value")
1255 else
1256 ONL = 0
1257 end
1258
1259 GOLD = G_1 + G_2 + G_3 + G_4 + G_5 + G_6 + G_7 + G_8 + G_9 + G_10
1260 ONLI = ONL
1261 end
1262
1263 player:sendCancelMessage("@AdmPanel 1 " ..GOLD.. " " ..ONLI.. " " ..PlayLabel)
1264 return false
1265 end, 500)
1266 end
1267 end
1268 if split[02] == "09" then -- MAESTRIA
1269 local MAESTRIA = tonumber(split[03])
1270 if PlayOn then
1271 local MAESTRIA_NAME = {
1272 [01] = {N = "REGEN", V = 02};
1273 [02] = {N = "TANKER", V = 03};
1274 [03] = {N = "SHOOTER", V = 04};
1275 [04] = {N = "VITAL", V = 05};
1276 [05] = {N = "LUCKY", V = 06};
1277 }
1278
1279 if MAESTRIA < 06 then
1280 tid:setStorageValue(_SYSTEM.MAESTRIA[01], MAESTRIA)
1281 player:popupFYI("Maestria alterada para [ " ..MAESTRIA_NAME[MAESTRIA].N.. " ].")
1282 else
1283 tid:setStorageValue(_SYSTEM.MAESTRIA[01], nil)
1284 player:popupFYI("Maestria removida com sucesso.")
1285 end
1286
1287 doInventario(tid, 03)
1288 else
1289 player:popupFYI("Este jugador n�o est� online.")
1290 return false
1291 end
1292 end
1293 if split[02] == "10" then -- ESPECIALISTA
1294 local ESPECIALISTA = tonumber(split[03])
1295 if PlayOn then
1296 local ESPECIALISTA_NAME = {
1297 [01] = "Pistola";
1298 [02] = "Metralhadora";
1299 [03] = "Espingarda";
1300 [04] = "Rifle";
1301 }
1302
1303 if ESPECIALISTA < 05 then
1304 tid:setStorageValue(_SYSTEM.ESPECIALISTA[01], ESPECIALISTA)
1305 player:popupFYI("Especialidade alterada para [ " ..ESPECIALISTA_NAME[ESPECIALISTA].. " ].")
1306 else
1307 tid:setStorageValue(_SYSTEM.ESPECIALISTA[01], nil)
1308 player:popupFYI("Especialidade removida com sucesso.")
1309 end
1310 else
1311 player:popupFYI("Este jugador n�o est� online.")
1312 return false
1313 end
1314 end
1315 if split[02] == "11" then -- GOTO
1316 local target = Creature(split[01])
1317 if target then
1318 local isGhost = not player:isInGhostMode()
1319
1320 player:teleportTo(target:getPosition())
1321 if isGhost then
1322 player:getPosition():sendMagicEffect(CONST_ME_TELEPORT)
1323 end
1324 else
1325 player:popupFYI("Jogador n�o encontrado.")
1326 return false
1327 end
1328 return false
1329 end
1330 if split[02] == "12" then -- MODO GHOST
1331 local position = player:getPosition()
1332 local isGhost = not player:isInGhostMode()
1333
1334 player:setGhostMode(isGhost)
1335 if isGhost then
1336 player:sendTextMessage(MESSAGE_INFO_DESCR, "You are now invisible.")
1337 position:sendMagicEffect(CONST_ME_YALAHARIGHOST)
1338 else
1339 player:sendTextMessage(MESSAGE_INFO_DESCR, "You are visible again.")
1340 position.x = position.x + 1
1341 position:sendMagicEffect(CONST_ME_SMOKE)
1342 end
1343 return false
1344 end
1345 if split[02] == "13" then -- BANIMENTOS
1346 local banDays = tonumber(split[03])
1347 local banDesc = split[04]
1348 local banType = tonumber(split[05])
1349
1350 if banDesc == "0" then
1351 banDesc = ""
1352 end
1353 if banType == 01 then
1354 local accountId = getAccountNumberByPlayerName(split[01])
1355 if accountId == 0 then
1356 return false
1357 end
1358
1359 local resultId = db.storeQuery("SELECT 1 FROM `account_bans` WHERE `account_id` = " .. accountId)
1360 if resultId ~= false then
1361 result.free(resultId)
1362 return false
1363 end
1364
1365 local timeNow = os.time()
1366 db.query("INSERT INTO `account_bans` (`account_id`, `reason`, `banned_at`, `expires_at`, `banned_by`) VALUES (" ..
1367 accountId .. ", " .. db.escapeString(banDesc) .. ", " .. timeNow .. ", " .. timeNow + (banDays * 86400) .. ", " .. player:getGuid() .. ")")
1368
1369 local target = Player(split[01])
1370 if target then
1371 player:popupFYI(target:getName() .. " has been banned.")
1372 target:remove()
1373 else
1374 player:popupFYI(split[01] .. " has been banned.")
1375 end
1376 else
1377 local resultId = db.storeQuery("SELECT `name`, `lastip` FROM `players` WHERE `name` = " .. db.escapeString(split[01]))
1378 if resultId == false then
1379 return false
1380 end
1381
1382 local targetName = result.getString(resultId, "name")
1383 local targetIp = result.getNumber(resultId, "lastip")
1384 result.free(resultId)
1385
1386 local targetPlayer = Player(split[01])
1387 if targetPlayer then
1388 targetIp = targetPlayer:getIp()
1389 targetPlayer:remove()
1390 end
1391
1392 if targetIp == 0 then
1393 return false
1394 end
1395
1396 resultId = db.storeQuery("SELECT 1 FROM `ip_bans` WHERE `ip` = " .. targetIp)
1397 if resultId ~= false then
1398 player:popupFYI(targetName .. " is already IP banned.")
1399 result.free(resultId)
1400 return false
1401 end
1402
1403 local timeNow = os.time()
1404 db.query("INSERT INTO `ip_bans` (`ip`, `reason`, `banned_at`, `expires_at`, `banned_by`) VALUES (" ..
1405 targetIp .. ", '" ..banDesc.. "', " .. timeNow .. ", " .. timeNow + (banDays * 86400) .. ", " .. player:getGuid() .. ")")
1406 player:popupFYI(targetName .. " has been IP banned.")
1407 end
1408
1409 player:sendCancelMessage("@MonitBot#6")
1410 return false
1411 end
1412 else
1413 player:sendCancelMessage("@AdmPanel 0")
1414 return false
1415 end
1416 return false
1417end
1418
Top