function playerExists(name) return (getPlayerGUIDByName(name) ~= 0) end function onSay(player, words, param) if player:getGroup():getId() < 2 then return false end local split = param:splitTrimmed("-") -- Se reproduce el sonido en cualquier interacción playSoundPlayer(player, "depot.ogg") if not split[01] then player:sendCancelMessage("@AdmPanel 0") return false end local tid = Player(split[01]) local PlayOn = true local PlayLabel = 01 if(not tid) then PlayOn = false PlayLabel = 00 if getPlayerGUIDByName(split[01]) > 0 then tid = getPlayerGUIDByName(split[01]) else player:popupFYI("Este jugador n�o existe.") player:sendCancelMessage("@AdmPanel 0") return false end end if split[02] then if _DEBUG_MODE then local _TYPE = { ["00"] = 'Inventario abierto', ["01"] = 'Destruccion de articulos del inventario', ["02"] = 'Destruccion de habilidades de armas del inventario', ["03"] = 'Lleva mochila', ["04"] = 'Destruyendo objeto en la mochila', ["05"] = 'Quitar o agregar dinero', ["06"] = 'Habilidad de destruccion de armas dentro de la mochila', ["07"] = 'Reiniciando cliente', ["08"] = 'Cerrando Cliente', ["09"] = 'Cambio de maestría', ["10"] = 'Especialista en cambio', ["11"] = 'Cambiando GoTo', } if _TYPE[split[02]] then print("[TALK - ADM] " ..player:getName().. " - " .._TYPE[split[02]]) else print("[TALK - ADM] " ..player:getName().. " - " ..split[02]) end end if split[02] == "00" then -- ABRIR INVENTARIO local GOLD = 0 local ONLI = 0 for _INVENTARIO = 01, 09 do if PlayOn then local A = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_01) local B = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_02) local C = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_03) local D = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_04) local E = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_05) local F = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_06) local G = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_07) local H = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_08) local I = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_09) local J = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_10) player:sendCancelMessage("@loadInfo 01 " .._INVENTARIO.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J) else local A = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_01.. ' AND `player_id` = ' ..tid .. ';') local B = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_02.. ' AND `player_id` = ' ..tid .. ';') local C = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_03.. ' AND `player_id` = ' ..tid .. ';') local D = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_04.. ' AND `player_id` = ' ..tid .. ';') local E = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_05.. ' AND `player_id` = ' ..tid .. ';') local F = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_06.. ' AND `player_id` = ' ..tid .. ';') local G = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_07.. ' AND `player_id` = ' ..tid .. ';') local H = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_08.. ' AND `player_id` = ' ..tid .. ';') local I = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_09.. ' AND `player_id` = ' ..tid .. ';') local J = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_10.. ' AND `player_id` = ' ..tid .. ';') if A then A = result.getDataInt(A, "value") else A = 0 end if B then B = result.getDataInt(B, "value") else B = 0 end if C then C = result.getDataInt(C, "value") else C = 0 end if D then D = result.getDataInt(D, "value") else D = 0 end if E then E = result.getDataInt(E, "value") else E = 0 end if F then F = result.getDataInt(F, "value") else F = 0 end if G then G = result.getDataInt(G, "value") else G = 0 end if H then H = result.getDataInt(H, "value") else H = 0 end if I then I = result.getDataInt(I, "value") else I = 0 end if J then J = result.getDataInt(J, "value") else J = 0 end player:sendCancelMessage("@loadInfo 01 " .._INVENTARIO.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J) end end if PlayOn then GOLD = PlayerGoldCoins(tid, 00) ONLI = tid:getStorageValue(_SYSTEM.ONLINE_COIN) else local G_1 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[01].. ' AND `player_id` = ' ..tid .. ';') local G_2 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[02].. ' AND `player_id` = ' ..tid .. ';') local G_3 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[03].. ' AND `player_id` = ' ..tid .. ';') local G_4 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[04].. ' AND `player_id` = ' ..tid .. ';') local G_5 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[05].. ' AND `player_id` = ' ..tid .. ';') local G_6 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[06].. ' AND `player_id` = ' ..tid .. ';') local G_7 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[07].. ' AND `player_id` = ' ..tid .. ';') local G_8 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[08].. ' AND `player_id` = ' ..tid .. ';') local G_9 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[09].. ' AND `player_id` = ' ..tid .. ';') local G_10 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[10].. ' AND `player_id` = ' ..tid .. ';') local ONL = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.ONLINE_COIN.. ' AND `player_id` = ' ..tid .. ';') if G_1 then G_1 = result.getDataInt(G_1, "value") else G_1 = 0 end if G_2 then G_2 = result.getDataInt(G_2, "value") else G_2 = 0 end if G_3 then G_3 = result.getDataInt(G_3, "value") else G_3 = 0 end if G_4 then G_4 = result.getDataInt(G_4, "value") else G_4 = 0 end if G_5 then G_5 = result.getDataInt(G_5, "value") else G_5 = 0 end if G_6 then G_6 = result.getDataInt(G_6, "value") else G_6 = 0 end if G_7 then G_7 = result.getDataInt(G_7, "value") else G_7 = 0 end if G_8 then G_8 = result.getDataInt(G_8, "value") else G_8 = 0 end if G_9 then G_9 = result.getDataInt(G_9, "value") else G_9 = 0 end if G_10 then G_10 = result.getDataInt(G_10, "value") else G_10 = 0 end if ONL then ONL = result.getDataInt(ONL, "value") else ONL = 0 end GOLD = G_1 + G_2 + G_3 + G_4 + G_5 + G_6 + G_7 + G_8 + G_9 + G_10 ONLI = ONL end player:sendCancelMessage("@AdmPanel 1 " ..GOLD.. " " ..ONLI.. " " ..PlayLabel) return false end if split[02] == "01" then -- DESTRUINDO ITENS DO INVENTARIO local _INVENTARIO = tonumber(split[03]) if PlayOn then tid:setStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_01, nil) tid:setStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_02, nil) tid:setStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_03, nil) tid:setStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_04, nil) tid:setStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_05, nil) tid:setStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_06, nil) tid:setStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_07, nil) tid:setStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_08, nil) tid:setStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_09, nil) tid:setStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_10, nil) doInventario(tid, 00, 04, 00) tid:sendCancelMessage("@StarCliente") else db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[_INVENTARIO].UID_01.. " AND `player_id` = " ..tid.. ");") db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[_INVENTARIO].UID_02.. " AND `player_id` = " ..tid.. ");") db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[_INVENTARIO].UID_03.. " AND `player_id` = " ..tid.. ");") db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[_INVENTARIO].UID_04.. " AND `player_id` = " ..tid.. ");") db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[_INVENTARIO].UID_05.. " AND `player_id` = " ..tid.. ");") db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[_INVENTARIO].UID_06.. " AND `player_id` = " ..tid.. ");") db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[_INVENTARIO].UID_07.. " AND `player_id` = " ..tid.. ");") db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[_INVENTARIO].UID_08.. " AND `player_id` = " ..tid.. ");") db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[_INVENTARIO].UID_09.. " AND `player_id` = " ..tid.. ");") db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[_INVENTARIO].UID_10.. " AND `player_id` = " ..tid.. ");") end addEvent(function() for _INVENTARIO = 01, 09 do if PlayOn then local A = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_01) local B = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_02) local C = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_03) local D = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_04) local E = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_05) local F = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_06) local G = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_07) local H = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_08) local I = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_09) local J = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_10) player:sendCancelMessage("@loadInfo 01 " .._INVENTARIO.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J) else local A = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_01.. ' AND `player_id` = ' ..tid .. ';') local B = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_02.. ' AND `player_id` = ' ..tid .. ';') local C = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_03.. ' AND `player_id` = ' ..tid .. ';') local D = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_04.. ' AND `player_id` = ' ..tid .. ';') local E = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_05.. ' AND `player_id` = ' ..tid .. ';') local F = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_06.. ' AND `player_id` = ' ..tid .. ';') local G = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_07.. ' AND `player_id` = ' ..tid .. ';') local H = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_08.. ' AND `player_id` = ' ..tid .. ';') local I = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_09.. ' AND `player_id` = ' ..tid .. ';') local J = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_10.. ' AND `player_id` = ' ..tid .. ';') if A then A = result.getDataInt(A, "value") else A = 0 end if B then B = result.getDataInt(B, "value") else B = 0 end if C then C = result.getDataInt(C, "value") else C = 0 end if D then D = result.getDataInt(D, "value") else D = 0 end if E then E = result.getDataInt(E, "value") else E = 0 end if F then F = result.getDataInt(F, "value") else F = 0 end if G then G = result.getDataInt(G, "value") else G = 0 end if H then H = result.getDataInt(H, "value") else H = 0 end if I then I = result.getDataInt(I, "value") else I = 0 end if J then J = result.getDataInt(J, "value") else J = 0 end player:sendCancelMessage("@loadInfo 01 " .._INVENTARIO.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J) end end if PlayOn then GOLD = PlayerGoldCoins(tid, 00) ONLI = tid:getStorageValue(_SYSTEM.ONLINE_COIN) else local G_1 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[01].. ' AND `player_id` = ' ..tid .. ';') local G_2 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[02].. ' AND `player_id` = ' ..tid .. ';') local G_3 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[03].. ' AND `player_id` = ' ..tid .. ';') local G_4 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[04].. ' AND `player_id` = ' ..tid .. ';') local G_5 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[05].. ' AND `player_id` = ' ..tid .. ';') local G_6 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[06].. ' AND `player_id` = ' ..tid .. ';') local G_7 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[07].. ' AND `player_id` = ' ..tid .. ';') local G_8 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[08].. ' AND `player_id` = ' ..tid .. ';') local G_9 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[09].. ' AND `player_id` = ' ..tid .. ';') local G_10 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[10].. ' AND `player_id` = ' ..tid .. ';') local ONL = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.ONLINE_COIN.. ' AND `player_id` = ' ..tid .. ';') if G_1 then G_1 = result.getDataInt(G_1, "value") else G_1 = 0 end if G_2 then G_2 = result.getDataInt(G_2, "value") else G_2 = 0 end if G_3 then G_3 = result.getDataInt(G_3, "value") else G_3 = 0 end if G_4 then G_4 = result.getDataInt(G_4, "value") else G_4 = 0 end if G_5 then G_5 = result.getDataInt(G_5, "value") else G_5 = 0 end if G_6 then G_6 = result.getDataInt(G_6, "value") else G_6 = 0 end if G_7 then G_7 = result.getDataInt(G_7, "value") else G_7 = 0 end if G_8 then G_8 = result.getDataInt(G_8, "value") else G_8 = 0 end if G_9 then G_9 = result.getDataInt(G_9, "value") else G_9 = 0 end if G_10 then G_10 = result.getDataInt(G_10, "value") else G_10 = 0 end if ONL then ONL = result.getDataInt(ONL, "value") else ONL = 0 end GOLD = G_1 + G_2 + G_3 + G_4 + G_5 + G_6 + G_7 + G_8 + G_9 + G_10 ONLI = ONL end player:sendCancelMessage("@AdmPanel 1 " ..GOLD.. " " ..ONLI.. " " ..PlayLabel) return false end, 500) return false end if split[02] == "02" then -- DESTRUINDO SKILLS DA ARMA DO INVENTARIO local SKILL_POS = tonumber(split[03]) if SKILL_POS == 01 then if PlayOn then tid:setStorageValue(_SYSTEM.INVENTARIO[04].UID_04, nil) else db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[04].UID_04.. " AND `player_id` = " ..tid.. ");") end end if SKILL_POS == 02 then if PlayOn then tid:setStorageValue(_SYSTEM.INVENTARIO[04].UID_05, nil) else db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[04].UID_05.. " AND `player_id` = " ..tid.. ");") end end if SKILL_POS == 03 then if PlayOn then tid:setStorageValue(_SYSTEM.INVENTARIO[04].UID_06, nil) else db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._SYSTEM.INVENTARIO[04].UID_06.. " AND `player_id` = " ..tid.. ");") end end if PlayOn then doInventario(tid, 00, 04, 00) tid:sendCancelMessage("@StarCliente") end addEvent(function() for _INVENTARIO = 01, 09 do if PlayOn then local A = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_01) local B = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_02) local C = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_03) local D = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_04) local E = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_05) local F = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_06) local G = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_07) local H = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_08) local I = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_09) local J = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_10) player:sendCancelMessage("@loadInfo 01 " .._INVENTARIO.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J) else local A = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_01.. ' AND `player_id` = ' ..tid .. ';') local B = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_02.. ' AND `player_id` = ' ..tid .. ';') local C = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_03.. ' AND `player_id` = ' ..tid .. ';') local D = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_04.. ' AND `player_id` = ' ..tid .. ';') local E = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_05.. ' AND `player_id` = ' ..tid .. ';') local F = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_06.. ' AND `player_id` = ' ..tid .. ';') local G = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_07.. ' AND `player_id` = ' ..tid .. ';') local H = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_08.. ' AND `player_id` = ' ..tid .. ';') local I = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_09.. ' AND `player_id` = ' ..tid .. ';') local J = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_10.. ' AND `player_id` = ' ..tid .. ';') if A then A = result.getDataInt(A, "value") else A = 0 end if B then B = result.getDataInt(B, "value") else B = 0 end if C then C = result.getDataInt(C, "value") else C = 0 end if D then D = result.getDataInt(D, "value") else D = 0 end if E then E = result.getDataInt(E, "value") else E = 0 end if F then F = result.getDataInt(F, "value") else F = 0 end if G then G = result.getDataInt(G, "value") else G = 0 end if H then H = result.getDataInt(H, "value") else H = 0 end if I then I = result.getDataInt(I, "value") else I = 0 end if J then J = result.getDataInt(J, "value") else J = 0 end player:sendCancelMessage("@loadInfo 01 " .._INVENTARIO.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J) end end if PlayOn then GOLD = PlayerGoldCoins(tid, 00) ONLI = tid:getStorageValue(_SYSTEM.ONLINE_COIN) else local G_1 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[01].. ' AND `player_id` = ' ..tid .. ';') local G_2 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[02].. ' AND `player_id` = ' ..tid .. ';') local G_3 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[03].. ' AND `player_id` = ' ..tid .. ';') local G_4 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[04].. ' AND `player_id` = ' ..tid .. ';') local G_5 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[05].. ' AND `player_id` = ' ..tid .. ';') local G_6 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[06].. ' AND `player_id` = ' ..tid .. ';') local G_7 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[07].. ' AND `player_id` = ' ..tid .. ';') local G_8 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[08].. ' AND `player_id` = ' ..tid .. ';') local G_9 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[09].. ' AND `player_id` = ' ..tid .. ';') local G_10 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[10].. ' AND `player_id` = ' ..tid .. ';') local ONL = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.ONLINE_COIN.. ' AND `player_id` = ' ..tid .. ';') if G_1 then G_1 = result.getDataInt(G_1, "value") else G_1 = 0 end if G_2 then G_2 = result.getDataInt(G_2, "value") else G_2 = 0 end if G_3 then G_3 = result.getDataInt(G_3, "value") else G_3 = 0 end if G_4 then G_4 = result.getDataInt(G_4, "value") else G_4 = 0 end if G_5 then G_5 = result.getDataInt(G_5, "value") else G_5 = 0 end if G_6 then G_6 = result.getDataInt(G_6, "value") else G_6 = 0 end if G_7 then G_7 = result.getDataInt(G_7, "value") else G_7 = 0 end if G_8 then G_8 = result.getDataInt(G_8, "value") else G_8 = 0 end if G_9 then G_9 = result.getDataInt(G_9, "value") else G_9 = 0 end if G_10 then G_10 = result.getDataInt(G_10, "value") else G_10 = 0 end if ONL then ONL = result.getDataInt(ONL, "value") else ONL = 0 end GOLD = G_1 + G_2 + G_3 + G_4 + G_5 + G_6 + G_7 + G_8 + G_9 + G_10 ONLI = ONL end player:sendCancelMessage("@AdmPanel 1 " ..GOLD.. " " ..ONLI.. " " ..PlayLabel) return false end, 500) return false end if split[02] == "03" then -- CARREGANDO BACKPACK local SLOT_BAG = tonumber(split[03]) local EXT_BAG = tonumber(split[04]) for _BAG = 01, 20 do if PlayOn then local A = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_01) local B = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_02) local C = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_03) local D = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_04) local E = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_05) local F = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_06) local G = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_07) local H = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_08) local I = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_09) local J = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_10) local EXT = tid:getStorageValue(_SYSTEM.EXTENSION_BACK[SLOT_BAG].UID_01) player:sendCancelMessage("@loadInfo 02 " .._BAG.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J.. " " ..SLOT_BAG.. " " ..EXT_BAG.. " " ..EXT) else local A = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_01.. ' AND `player_id` = ' ..tid .. ';') local B = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_02.. ' AND `player_id` = ' ..tid .. ';') local C = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_03.. ' AND `player_id` = ' ..tid .. ';') local D = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_04.. ' AND `player_id` = ' ..tid .. ';') local E = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_05.. ' AND `player_id` = ' ..tid .. ';') local F = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_06.. ' AND `player_id` = ' ..tid .. ';') local G = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_07.. ' AND `player_id` = ' ..tid .. ';') local H = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_08.. ' AND `player_id` = ' ..tid .. ';') local I = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_09.. ' AND `player_id` = ' ..tid .. ';') local J = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_10.. ' AND `player_id` = ' ..tid .. ';') local EXT = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.EXTENSION_BACK[SLOT_BAG].UID_01.. ' AND `player_id` = ' ..tid .. ';') if A then A = result.getDataInt(A, "value") else A = 0 end if B then B = result.getDataInt(B, "value") else B = 0 end if C then C = result.getDataInt(C, "value") else C = 0 end if D then D = result.getDataInt(D, "value") else D = 0 end if E then E = result.getDataInt(E, "value") else E = 0 end if F then F = result.getDataInt(F, "value") else F = 0 end if G then G = result.getDataInt(G, "value") else G = 0 end if H then H = result.getDataInt(H, "value") else H = 0 end if I then I = result.getDataInt(I, "value") else I = 0 end if J then J = result.getDataInt(J, "value") else J = 0 end if EXT then EXT = result.getDataInt(EXT, "value") else EXT = 0 end player:sendCancelMessage("@loadInfo 02 " .._BAG.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J.. " " ..SLOT_BAG.. " " ..EXT_BAG.. " " ..EXT) end end return false end if split[02] == "04" then -- DESTRUINDO ITEMS DA BACKPACK local SLOT_BAG = tonumber(split[03]) local EXT_BAG = tonumber(split[04]) local POS_BAG = tonumber(split[05]) if PlayOn then tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_01, nil) tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_02, nil) tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_03, nil) tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_04, nil) tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_05, nil) tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_06, nil) tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_07, nil) tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_08, nil) tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_09, nil) tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_10, nil) doBackpack(tid, 00, SLOT_BAG, EXT_BAG, 01) tid:sendCancelMessage("@OpenBackpack " ..SLOT_BAG) else db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_01.. " AND `player_id` = " ..tid.. ");") db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_02.. " AND `player_id` = " ..tid.. ");") db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_03.. " AND `player_id` = " ..tid.. ");") db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_04.. " AND `player_id` = " ..tid.. ");") db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_05.. " AND `player_id` = " ..tid.. ");") db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_06.. " AND `player_id` = " ..tid.. ");") db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_07.. " AND `player_id` = " ..tid.. ");") db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_08.. " AND `player_id` = " ..tid.. ");") db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_09.. " AND `player_id` = " ..tid.. ");") db.query("UPDATE `player_storage` SET `value` = 0 WHERE (`key` = " .._BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_10.. " AND `player_id` = " ..tid.. ");") end addEvent(function() for _BAG = 01, 20 do if PlayOn then local A = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_01) local B = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_02) local C = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_03) local D = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_04) local E = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_05) local F = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_06) local G = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_07) local H = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_08) local I = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_09) local J = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_10) local EXT = tid:getStorageValue(_SYSTEM.EXTENSION_BACK[SLOT_BAG].UID_01) player:sendCancelMessage("@loadInfo 02 " .._BAG.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J.. " " ..SLOT_BAG.. " " ..EXT_BAG.. " " ..EXT) else local A = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_01.. ' AND `player_id` = ' ..tid .. ';') local B = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_02.. ' AND `player_id` = ' ..tid .. ';') local C = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_03.. ' AND `player_id` = ' ..tid .. ';') local D = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_04.. ' AND `player_id` = ' ..tid .. ';') local E = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_05.. ' AND `player_id` = ' ..tid .. ';') local F = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_06.. ' AND `player_id` = ' ..tid .. ';') local G = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_07.. ' AND `player_id` = ' ..tid .. ';') local H = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_08.. ' AND `player_id` = ' ..tid .. ';') local I = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_09.. ' AND `player_id` = ' ..tid .. ';') local J = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_10.. ' AND `player_id` = ' ..tid .. ';') local EXT = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.EXTENSION_BACK[SLOT_BAG].UID_01.. ' AND `player_id` = ' ..tid .. ';') if A then A = result.getDataInt(A, "value") else A = 0 end if B then B = result.getDataInt(B, "value") else B = 0 end if C then C = result.getDataInt(C, "value") else C = 0 end if D then D = result.getDataInt(D, "value") else D = 0 end if E then E = result.getDataInt(E, "value") else E = 0 end if F then F = result.getDataInt(F, "value") else F = 0 end if G then G = result.getDataInt(G, "value") else G = 0 end if H then H = result.getDataInt(H, "value") else H = 0 end if I then I = result.getDataInt(I, "value") else I = 0 end if J then J = result.getDataInt(J, "value") else J = 0 end if EXT then EXT = result.getDataInt(EXT, "value") else EXT = 0 end player:sendCancelMessage("@loadInfo 02 " .._BAG.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J.. " " ..SLOT_BAG.. " " ..EXT_BAG.. " " ..EXT) end end end, 500) end if split[02] == "05" then -- REMOVENDO OU ADICIONANDO DINHEIRO local VALUE = tonumber(split[03]) local ACTION = tonumber(split[04]) if PlayOn then PlayerGoldCoins(tid, ACTION, VALUE) doBackpack(tid, 11) else if ACTION == 01 then -- RETIRAR local G_1 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[01].. ' AND `player_id` = ' ..tid .. ';') local G_2 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[02].. ' AND `player_id` = ' ..tid .. ';') local G_3 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[03].. ' AND `player_id` = ' ..tid .. ';') local G_4 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[04].. ' AND `player_id` = ' ..tid .. ';') local G_5 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[05].. ' AND `player_id` = ' ..tid .. ';') local G_6 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[06].. ' AND `player_id` = ' ..tid .. ';') local G_7 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[07].. ' AND `player_id` = ' ..tid .. ';') local G_8 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[08].. ' AND `player_id` = ' ..tid .. ';') local G_9 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[09].. ' AND `player_id` = ' ..tid .. ';') local G_10 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[10].. ' AND `player_id` = ' ..tid .. ';') local ONL = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.ONLINE_COIN.. ' AND `player_id` = ' ..tid .. ';') if G_1 then G_1 = result.getDataInt(G_1, "value") else G_1 = 0 end if G_2 then G_2 = result.getDataInt(G_2, "value") else G_2 = 0 end if G_3 then G_3 = result.getDataInt(G_3, "value") else G_3 = 0 end if G_4 then G_4 = result.getDataInt(G_4, "value") else G_4 = 0 end if G_5 then G_5 = result.getDataInt(G_5, "value") else G_5 = 0 end if G_6 then G_6 = result.getDataInt(G_6, "value") else G_6 = 0 end if G_7 then G_7 = result.getDataInt(G_7, "value") else G_7 = 0 end if G_8 then G_8 = result.getDataInt(G_8, "value") else G_8 = 0 end if G_9 then G_9 = result.getDataInt(G_9, "value") else G_9 = 0 end if G_10 then G_10 = result.getDataInt(G_10, "value") else G_10 = 0 end if ONL then ONL = result.getDataInt(ONL, "value") else ONL = 0 end end end addEvent(function() local GOLD = PlayerGoldCoins(tid, 00) local ONLI = tid:getStorageValue(_SYSTEM.ONLINE_COIN) player:sendCancelMessage("@AdmPanel 1 " ..GOLD.. " " ..ONLI) end, 500) return end if split[02] == "06" then -- DESTRUINDO SKILL ARMA DENTRO DA BACKPACK local SLOT_BAG = tonumber(split[03]) local EXT_BAG = tonumber(split[04]) local POS_BAG = tonumber(split[05]) local SKILL_POS = tonumber(split[06]) if SLOT_BAG == 04 then if SKILL_POS == 01 then tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_04, nil) end if SKILL_POS == 02 then tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_05, nil) end if SKILL_POS == 03 then tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_06, nil) end else if SKILL_POS == 01 then tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_06, nil) end if SKILL_POS == 02 then tid:setStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][POS_BAG].UID_07, nil) end end doBackpack(tid, 00, SLOT_BAG, EXT_BAG, 01) tid:sendCancelMessage("@OpenBackpack " ..SLOT_BAG) addEvent(function() for _BAG = 01, 20 do local A = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_01) local B = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_02) local C = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_03) local D = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_04) local E = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_05) local F = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_06) local G = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_07) local H = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_08) local I = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_09) local J = tid:getStorageValue(_BACKPACK[SLOT_BAG][EXT_BAG][_BAG].UID_10) player:sendCancelMessage("@loadInfo 02 " .._BAG.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J.. " " ..SLOT_BAG.. " " ..EXT_BAG) end end, 500) end if split[02] == "07" then -- REINICIANDO CLIENTE if PlayOn then tid:sendCancelMessage("@ClientSystem 00") addEvent(function() for _INVENTARIO = 01, 09 do if PlayOn then local A = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_01) local B = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_02) local C = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_03) local D = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_04) local E = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_05) local F = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_06) local G = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_07) local H = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_08) local I = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_09) local J = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_10) player:sendCancelMessage("@loadInfo 01 " .._INVENTARIO.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J) else local A = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_01.. ' AND `player_id` = ' ..tid .. ';') local B = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_02.. ' AND `player_id` = ' ..tid .. ';') local C = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_03.. ' AND `player_id` = ' ..tid .. ';') local D = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_04.. ' AND `player_id` = ' ..tid .. ';') local E = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_05.. ' AND `player_id` = ' ..tid .. ';') local F = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_06.. ' AND `player_id` = ' ..tid .. ';') local G = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_07.. ' AND `player_id` = ' ..tid .. ';') local H = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_08.. ' AND `player_id` = ' ..tid .. ';') local I = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_09.. ' AND `player_id` = ' ..tid .. ';') local J = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_10.. ' AND `player_id` = ' ..tid .. ';') if A then A = result.getDataInt(A, "value") else A = 0 end if B then B = result.getDataInt(B, "value") else B = 0 end if C then C = result.getDataInt(C, "value") else C = 0 end if D then D = result.getDataInt(D, "value") else D = 0 end if E then E = result.getDataInt(E, "value") else E = 0 end if F then F = result.getDataInt(F, "value") else F = 0 end if G then G = result.getDataInt(G, "value") else G = 0 end if H then H = result.getDataInt(H, "value") else H = 0 end if I then I = result.getDataInt(I, "value") else I = 0 end if J then J = result.getDataInt(J, "value") else J = 0 end player:sendCancelMessage("@loadInfo 01 " .._INVENTARIO.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J) end end if PlayOn then GOLD = PlayerGoldCoins(tid, 00) ONLI = tid:getStorageValue(_SYSTEM.ONLINE_COIN) else local G_1 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[01].. ' AND `player_id` = ' ..tid .. ';') local G_2 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[02].. ' AND `player_id` = ' ..tid .. ';') local G_3 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[03].. ' AND `player_id` = ' ..tid .. ';') local G_4 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[04].. ' AND `player_id` = ' ..tid .. ';') local G_5 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[05].. ' AND `player_id` = ' ..tid .. ';') local G_6 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[06].. ' AND `player_id` = ' ..tid .. ';') local G_7 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[07].. ' AND `player_id` = ' ..tid .. ';') local G_8 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[08].. ' AND `player_id` = ' ..tid .. ';') local G_9 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[09].. ' AND `player_id` = ' ..tid .. ';') local G_10 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[10].. ' AND `player_id` = ' ..tid .. ';') local ONL = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.ONLINE_COIN.. ' AND `player_id` = ' ..tid .. ';') if G_1 then G_1 = result.getDataInt(G_1, "value") else G_1 = 0 end if G_2 then G_2 = result.getDataInt(G_2, "value") else G_2 = 0 end if G_3 then G_3 = result.getDataInt(G_3, "value") else G_3 = 0 end if G_4 then G_4 = result.getDataInt(G_4, "value") else G_4 = 0 end if G_5 then G_5 = result.getDataInt(G_5, "value") else G_5 = 0 end if G_6 then G_6 = result.getDataInt(G_6, "value") else G_6 = 0 end if G_7 then G_7 = result.getDataInt(G_7, "value") else G_7 = 0 end if G_8 then G_8 = result.getDataInt(G_8, "value") else G_8 = 0 end if G_9 then G_9 = result.getDataInt(G_9, "value") else G_9 = 0 end if G_10 then G_10 = result.getDataInt(G_10, "value") else G_10 = 0 end if ONL then ONL = result.getDataInt(ONL, "value") else ONL = 0 end GOLD = G_1 + G_2 + G_3 + G_4 + G_5 + G_6 + G_7 + G_8 + G_9 + G_10 ONLI = ONL end player:sendCancelMessage("@AdmPanel 1 " ..GOLD.. " " ..ONLI.. " " ..PlayLabel) return false end, 500) return false end end if split[02] == "08" then -- FECHANDO CLIENTE if PlayOn then tid:sendCancelMessage("@ClientSystem 01") addEvent(function() for _INVENTARIO = 01, 09 do if PlayOn then local A = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_01) local B = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_02) local C = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_03) local D = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_04) local E = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_05) local F = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_06) local G = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_07) local H = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_08) local I = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_09) local J = tid:getStorageValue(_SYSTEM.INVENTARIO[_INVENTARIO].UID_10) player:sendCancelMessage("@loadInfo 01 " .._INVENTARIO.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J) else local A = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_01.. ' AND `player_id` = ' ..tid .. ';') local B = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_02.. ' AND `player_id` = ' ..tid .. ';') local C = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_03.. ' AND `player_id` = ' ..tid .. ';') local D = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_04.. ' AND `player_id` = ' ..tid .. ';') local E = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_05.. ' AND `player_id` = ' ..tid .. ';') local F = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_06.. ' AND `player_id` = ' ..tid .. ';') local G = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_07.. ' AND `player_id` = ' ..tid .. ';') local H = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_08.. ' AND `player_id` = ' ..tid .. ';') local I = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_09.. ' AND `player_id` = ' ..tid .. ';') local J = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.INVENTARIO[_INVENTARIO].UID_10.. ' AND `player_id` = ' ..tid .. ';') if A then A = result.getDataInt(A, "value") else A = 0 end if B then B = result.getDataInt(B, "value") else B = 0 end if C then C = result.getDataInt(C, "value") else C = 0 end if D then D = result.getDataInt(D, "value") else D = 0 end if E then E = result.getDataInt(E, "value") else E = 0 end if F then F = result.getDataInt(F, "value") else F = 0 end if G then G = result.getDataInt(G, "value") else G = 0 end if H then H = result.getDataInt(H, "value") else H = 0 end if I then I = result.getDataInt(I, "value") else I = 0 end if J then J = result.getDataInt(J, "value") else J = 0 end player:sendCancelMessage("@loadInfo 01 " .._INVENTARIO.. " " ..A.. " " ..B.. " " ..C.. " " ..D.. " " ..E.. " " ..F.. " " ..G.. " " ..H.. " " ..I.. " " ..J) end end if PlayOn then GOLD = PlayerGoldCoins(tid, 00) ONLI = tid:getStorageValue(_SYSTEM.ONLINE_COIN) else local G_1 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[01].. ' AND `player_id` = ' ..tid .. ';') local G_2 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[02].. ' AND `player_id` = ' ..tid .. ';') local G_3 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[03].. ' AND `player_id` = ' ..tid .. ';') local G_4 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[04].. ' AND `player_id` = ' ..tid .. ';') local G_5 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[05].. ' AND `player_id` = ' ..tid .. ';') local G_6 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[06].. ' AND `player_id` = ' ..tid .. ';') local G_7 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[07].. ' AND `player_id` = ' ..tid .. ';') local G_8 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[08].. ' AND `player_id` = ' ..tid .. ';') local G_9 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[09].. ' AND `player_id` = ' ..tid .. ';') local G_10 = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.GOLD_COIN[10].. ' AND `player_id` = ' ..tid .. ';') local ONL = db.storeQuery('SELECT `value` FROM `player_storage` WHERE `key` = ' .._SYSTEM.ONLINE_COIN.. ' AND `player_id` = ' ..tid .. ';') if G_1 then G_1 = result.getDataInt(G_1, "value") else G_1 = 0 end if G_2 then G_2 = result.getDataInt(G_2, "value") else G_2 = 0 end if G_3 then G_3 = result.getDataInt(G_3, "value") else G_3 = 0 end if G_4 then G_4 = result.getDataInt(G_4, "value") else G_4 = 0 end if G_5 then G_5 = result.getDataInt(G_5, "value") else G_5 = 0 end if G_6 then G_6 = result.getDataInt(G_6, "value") else G_6 = 0 end if G_7 then G_7 = result.getDataInt(G_7, "value") else G_7 = 0 end if G_8 then G_8 = result.getDataInt(G_8, "value") else G_8 = 0 end if G_9 then G_9 = result.getDataInt(G_9, "value") else G_9 = 0 end if G_10 then G_10 = result.getDataInt(G_10, "value") else G_10 = 0 end if ONL then ONL = result.getDataInt(ONL, "value") else ONL = 0 end GOLD = G_1 + G_2 + G_3 + G_4 + G_5 + G_6 + G_7 + G_8 + G_9 + G_10 ONLI = ONL end player:sendCancelMessage("@AdmPanel 1 " ..GOLD.. " " ..ONLI.. " " ..PlayLabel) return false end, 500) end end if split[02] == "09" then -- MAESTRIA local MAESTRIA = tonumber(split[03]) if PlayOn then local MAESTRIA_NAME = { [01] = {N = "REGEN", V = 02}; [02] = {N = "TANKER", V = 03}; [03] = {N = "SHOOTER", V = 04}; [04] = {N = "VITAL", V = 05}; [05] = {N = "LUCKY", V = 06}; } if MAESTRIA < 06 then tid:setStorageValue(_SYSTEM.MAESTRIA[01], MAESTRIA) player:popupFYI("Maestria alterada para [ " ..MAESTRIA_NAME[MAESTRIA].N.. " ].") else tid:setStorageValue(_SYSTEM.MAESTRIA[01], nil) player:popupFYI("Maestria removida com sucesso.") end doInventario(tid, 03) else player:popupFYI("Este jugador n�o est� online.") return false end end if split[02] == "10" then -- ESPECIALISTA local ESPECIALISTA = tonumber(split[03]) if PlayOn then local ESPECIALISTA_NAME = { [01] = "Pistola"; [02] = "Metralhadora"; [03] = "Espingarda"; [04] = "Rifle"; } if ESPECIALISTA < 05 then tid:setStorageValue(_SYSTEM.ESPECIALISTA[01], ESPECIALISTA) player:popupFYI("Especialidade alterada para [ " ..ESPECIALISTA_NAME[ESPECIALISTA].. " ].") else tid:setStorageValue(_SYSTEM.ESPECIALISTA[01], nil) player:popupFYI("Especialidade removida com sucesso.") end else player:popupFYI("Este jugador n�o est� online.") return false end end if split[02] == "11" then -- GOTO local target = Creature(split[01]) if target then local isGhost = not player:isInGhostMode() player:teleportTo(target:getPosition()) if isGhost then player:getPosition():sendMagicEffect(CONST_ME_TELEPORT) end else player:popupFYI("Jogador n�o encontrado.") return false end return false end if split[02] == "12" then -- MODO GHOST local position = player:getPosition() local isGhost = not player:isInGhostMode() player:setGhostMode(isGhost) if isGhost then player:sendTextMessage(MESSAGE_INFO_DESCR, "You are now invisible.") position:sendMagicEffect(CONST_ME_YALAHARIGHOST) else player:sendTextMessage(MESSAGE_INFO_DESCR, "You are visible again.") position.x = position.x + 1 position:sendMagicEffect(CONST_ME_SMOKE) end return false end if split[02] == "13" then -- BANIMENTOS local banDays = tonumber(split[03]) local banDesc = split[04] local banType = tonumber(split[05]) if banDesc == "0" then banDesc = "" end if banType == 01 then local accountId = getAccountNumberByPlayerName(split[01]) if accountId == 0 then return false end local resultId = db.storeQuery("SELECT 1 FROM `account_bans` WHERE `account_id` = " .. accountId) if resultId ~= false then result.free(resultId) return false end local timeNow = os.time() db.query("INSERT INTO `account_bans` (`account_id`, `reason`, `banned_at`, `expires_at`, `banned_by`) VALUES (" .. accountId .. ", " .. db.escapeString(banDesc) .. ", " .. timeNow .. ", " .. timeNow + (banDays * 86400) .. ", " .. player:getGuid() .. ")") local target = Player(split[01]) if target then player:popupFYI(target:getName() .. " has been banned.") target:remove() else player:popupFYI(split[01] .. " has been banned.") end else local resultId = db.storeQuery("SELECT `name`, `lastip` FROM `players` WHERE `name` = " .. db.escapeString(split[01])) if resultId == false then return false end local targetName = result.getString(resultId, "name") local targetIp = result.getNumber(resultId, "lastip") result.free(resultId) local targetPlayer = Player(split[01]) if targetPlayer then targetIp = targetPlayer:getIp() targetPlayer:remove() end if targetIp == 0 then return false end resultId = db.storeQuery("SELECT 1 FROM `ip_bans` WHERE `ip` = " .. targetIp) if resultId ~= false then player:popupFYI(targetName .. " is already IP banned.") result.free(resultId) return false end local timeNow = os.time() db.query("INSERT INTO `ip_bans` (`ip`, `reason`, `banned_at`, `expires_at`, `banned_by`) VALUES (" .. targetIp .. ", '" ..banDesc.. "', " .. timeNow .. ", " .. timeNow + (banDays * 86400) .. ", " .. player:getGuid() .. ")") player:popupFYI(targetName .. " has been IP banned.") end player:sendCancelMessage("@MonitBot#6") return false end else player:sendCancelMessage("@AdmPanel 0") return false end return false end