Danihcv

Tópico movido para dúvidas / pedidos resolvidos.

Tópico movido para dúvidas / pedidos resolvidos.

Tópico movido para dúvidas / pedidos resolvidos.

Tópico movido para dúvidas / pedidos resolvidos.

Tópico movido para dúvidas / pedidos resolvidos.

Tópico movido para dúvidas / pedidos resolvidos.

Tópico movido para dúvidas / pedidos resolvidos.

Tópico movido para dúvidas / pedidos resolvidos.

Tópico movido para dúvidas / pedidos resolvidos.

Tópico movido para dúvidas / pedidos resolvidos.

Tópico movido para dúvidas / pedidos resolvidos.

Tenta assim: local pointObj = 2160 --id do item "points" function getAccountPoints(cid) local res = db.getResult('SELECT `premium_points` FROM `accounts` WHERE id='..getPlayerAccountId(cid)..'') if(res:getID() == -1) then return false end local ret = res:getDataInt("premium_points") res:free() return tonumber(ret) end function onSay(cid, words, param) if param ~= "" then if param <= getAccountPoints(cid) then doPlayerAddItem(cid, pointObj, param) db.executeQuery('UPDATE `accounts` SET `premium_points`='..getAccountPoints(cid) - param..' WHERE id='.. getPlayerAccountId(cid)..'') newPoints = getAccountPoints(cid) doPlayerSendTextMessage(cid, 22, 'Você ainda possui '..newPoints..' premium points em sua conta.') else doPlayerSendCancel(cid, "Você não tem tantos premium points assim.") end else doPlayerSendCancel(cid, "Você precisa especificar um valor.") end return true end ~Agradecimentos ao Christofer Ricardo pela função getAccountPoints

Vá em data\creaturescripts e adicione essa tag ao arquivo creaturescripts.xml: <event type="advance" name="Advance8NPC" event="script" value="advance8npc.lua"/> Agora vá em data\creaturescripts\scritps e crie um arquivo chamado advance8npc.lua e coloque isso dentro: local pos = {x=100, y=100, z=7} local msg = "Parabéns! Você alcançou o level 8. Fale com o NPC para prosseguir sua caminhada" --vc pode editar essa mensagem, só precisa deixar ela dentro das aspas duplas! function onAdvance(cid, position) if getLevel(cid) == 8 then doTeleportThing(cid, pos) doPlayerSendTextMessage(cid, 18, msg) end return true end Agora vá em data\creaturescripts\scritps abra o arquivo login.lua e adicione isso antes do ultimo return true: registerCreatureEvent(cid, "Advance8NPC")

@@RetornoDeLaug, por favor, evite comentários que destoam do propósito do tópico e principalmente que ofendam/agridam qualquer pessoa.

Tópico movido para dúvidas / pedidos resolvidos.

Cruzamento com trilho de trem. Tipo uma parada dessa:

Confira o ultimo script que eu mandei aqui. Tem logo no inicio dele uma parte pra vc colocar a mensagem que vc quer que apareça pro player que está com o free bless. Vc pode colocar o que vc quiser, apenas deixe a mensagem entre as aspas duplas. Mas caso tenha dado erro, é por causa das functions que eu usei... Aqui está outra versão, que provavelmente funcionará pra tfs 1.1/1.2: local maxLevel = 10 --level maximo pro player ganhar bless local msg = "FREE BLESS" --mensagem dizendo que o player tem free bless. DEIXE ELA ENTRE ASPAS DUPLAS! local msgType = 18 --tipo de mensagem function onAdvance(cid, skill, oldLevel, newLevel) if player:getLevel(cid) <= maxLevel then for i = 1, 5 do player:addBlessing(cid, i) doPlayerSendTextMessage(cid, msgType, msg) end end return true end function onDeath(cid) if player:getLevel(cid) <= maxLevel then for i = 1, 5 do player:addBlessing(cid, i) end end return true end function onLogin(cid) if player:getLevel(cid) <= maxLevel then for i = 1, 5 do player:addBlessing(cid, i) doPlayerSendTextMessage(cid, msgType, msg) end end return true end

Não entendi muito bem... Seria mais facil botar uma area, com tds os treiners. Mas para entrar nessa area teria que passar por apenas 1 porta. E seria nessa porta que a checagem seria feita. Aí o player, como ele ñ é cego, veria que aql treiner X está ocupado, levando-o a procurar outro. Caso vc aceite essa minha sugestão, vamos lá: Em data\actions\scripts crie um arquivo chamado portaVoc.lua e coloque isso dentro: local voc = {1, 2, 3, 4} --vocações que podem acessar a porta function onUse(cid, item, frompos, item2, topos) for k, v in pairs(voc) do if getPlayerVocation(cid) == voc[v] then doSendMagicEffect(getCreaturePosition(cid), 2) else doPlayerSendCancel(cid, "Desculpe, para acessar esta área você precisa ser "..string.explode(getVocationInfo(voc[k]).name, ", ").."") return false end end return true end Agora vá em data\actions e coloque essa tag dentro do arquivo actions.xml: <action actionid="69785" script="portaVoc.lua" /> *preste atenção nesta parte: coloque a action id na PORTA igual à que vc colocar nessa tag acima. (nesse caso, eu botei pra ser 69785) Qualquer duvida, tamo ae.

Tópico movido para lixeira, qualquer dúvida entre em contato com qualquer membro da equipe.

@@gmstrikker, ao dar return TRUE, vc está retornando uma string basicamente, e não um sinal booleano. #EDIT: caso o seu pedido já tenha sido resolvido, pf marque o post que melhor respondeu sua duvida como Resolvido (esse botão s eencontra no rodapé de cada post)

Gameshow. *programa de TV com jogos de auditório

@@frank008, botei pra qnd o player morre e pra qnd o player loga: local maxLevel = 10 --level maximo pro player ganhar bless local msg = "Você atualmente tem o bless gratuito. Ele durará até o level "..maxLevel.."" function onAdvance(cid, skill, oldLevel, newLevel) if getPlayerLevel(cid) <= maxLevel then for i = 1, 5 do doPlayerAddBlessing(cid, i) end end return true end function onDeath(cid) if getPlayerLevel(cid) <= maxLevel then for i = 1, 5 do doPlayerAddBlessing(cid, i) doPlayerSendTextMessage(cid,18, msg) end end return true end function onLogin(cid) if getPlayerLevel(cid) <= maxLevel then for i = 1, 5 do doPlayerAddBlessing(cid, i) doPlayerSendTextMessage(cid,18, msg) end end return true end

Aqui. Vá em data\creaturescripts no arquivo creaturescripts.xml e adicione essas tags: <event type="advance" name="advanceBless" event="script" value="playerBless.lua"/> <event type="login" name="loginBless" event="script" value="playerBless.lua"/> <event type="death" name="deathBless" event="script" value="playerBless.lua"/> Agora vá em data\creaturescripts\scripts no arquivo login.lua e adicione isso antes do ultimo return true: registerCreatureEvent(cid, "advanceBless") registerCreatureEvent(cid, "loginBless") registerCreatureEvent(cid, "deathBless") Agora vá em data\creaturescripts\scripts e crie um arquivo chamado playerBless.lua e coloque isso dentro: local maxLevel = 10 --level maximo pro player ganhar bless function onAdvance(cid, skill, oldLevel, newLevel) if player:getLevel(cid) <= maxLevel then for i = 1, 5 do player:addBlessing(cid, i) end end return true end function onDeath(cid) if player:getLevel(cid) <= maxLevel then for i = 1, 5 do player:addBlessing(cid, i) end end return true end function onLogin(cid) if player:getLevel(cid) <= maxLevel then for i = 1, 5 do player:addBlessing(cid, i) end end return true end #CASO ESSE SCRIPT Ñ PEGUE, TENTE ASSIM: local maxLevel = 10 --level maximo pro player ganhar bless function onAdvance(cid, skill, oldLevel, newLevel) if getPlayerLevel(cid) <= maxLevel then for i = 1, 5 do doPlayerAddBlessing(cid, i) end end return true end function onDeath(cid) if getPlayerLevel(cid) <= maxLevel then for i = 1, 5 do doPlayerAddBlessing(cid, i) end end return true end function onLogin(cid) if getPlayerLevel(cid) <= maxLevel then for i = 1, 5 do doPlayerAddBlessing(cid, i) end end return true end

Olá, xTibianos. Hoje lhes trago mais uma lista de funções. Dessa vez é do TFS 1.1. Source functions - Funções da source addDamageCondition(condition, rounds, time, value) addEvent(callback, delay, ...) addOutfitCondition(condition, lookTypeEx, lookType, lookHead, lookBody, lookLegs, lookFeet) addOutfitCondition(condition, lookTypeEx, lookType, lookHead, lookBody, lookLegs, lookFeet[, lookAddons, lookMount]) canJoin(player) cleanMap() closeShopWindow(cid) Combat() combat:execute(creature, variant) combat:setArea(area) combat:setCallback(key, function) combat:setCondition(condition) combat:setFormula(type, mina, minb, maxa, maxb) combat:setOrigin(origin) combat:setParameter(key, value) Condition(conditionType[, conditionId = CONDITIONID_COMBAT]) condition:addDamage(rounds, time, value) condition:clone() condition:delete() condition:getEndTime() condition:getIcons() condition:getId() condition:getSubId() condition:getTicks() condition:getType() condition:setFormula(mina, minb, maxa, maxb) condition:setOutfit(lookTypeEx, lookType, lookHead, lookBody, lookLegs, lookFeet[, lookAddons[, lookMount]]) condition:setOutfit(outfit) condition:setParameter(key, value) condition:setTicks(ticks) Container(uid) container:addItem(itemId[, count/subType = 1[, index = INDEX_WHEREEVER[, flags = 0]]]) container:addItemEx(item[, index = INDEX_WHEREEVER[, flags = 0]]) container:getCapacity() container:getEmptySlots([recursive = false]) container:getItem(index) container:getItemCountById(itemId[, subType = -1]) container:getItemHoldingCount() container:getSize() container:hasItem(item) createCombatArea( {area}, <optional> {extArea} ) createCombatObject() createConditionObject(type) Creature(id or name or userdata) creature:addCondition(condition[, force = false]) creature:addHealth(healthChange) creature:addMana(manaChange[, animationOnLoss = false]) creature:canSee(position) creature:canSeeCreature(creature) creature:changeSpeed(delta) creature:getBaseSpeed() creature:getCondition(conditionType[, conditionId = CONDITIONID_COMBAT[, subId = 0]]) creature:getDamageMap() creature:getDescription(distance) creature:getDirection() creature:getFollowCreature() creature:getHealth() creature:getId() creature:getLight() creature:getMana() creature:getMaster() creature:getMaxHealth() creature:getMaxMana() creature:getName() creature:getOutfit() creature:getParent() creature:getPathTo(pos[, minTargetDist = 0[, maxTargetDist = 1[, fullPathSearch = true[, clearSight = true[, maxSearchDist = 0]]]]]) creature:getPosition() creature:getSkull() creature:getSpeed() creature:getSummons() creature:getTarget() creature:getTile() creature:isCreature() creature:isHealthHidden() creature:isInGhostMode() creature:isRemoved() Creature:onAreaCombat(tile, aggressive) or Creature.onAreaCombat(self, tile, aggressive) Creature:onChangeOutfit(outfit) or Creature.onChangeOutfit(self, outfit) Creature:onTargetCombat(target) or Creature.onTargetCombat(self, target) creature:registerEvent(name) creature:remove() creature:removeCondition(conditionType[, conditionId = CONDITIONID_COMBAT[, subId = 0[, force = false]]]) creature:say(text, type[, ghost = false[, target = nullptr[, position]]]) creature:setDirection(direction) creature:setDropLoot(doDrop) creature:setFollowCreature(followedCreature) creature:setHiddenHealth(hide) creature:setLight(color, level) creature:setMaster(master) creature:setMaxHealth(maxHealth) creature:setOutfit(outfit) creature:setSkull(skull) creature:setTarget(target) creature:teleportTo(position[, pushMovement = false]) creature:unregisterEvent(name) debugPrint(text) doAddContainerItem(uid, itemid, <optional> count/subtype) doAreaCombatCondition(cid, pos, area, condition, effect) doAreaCombatDispel(cid, pos, area, type, effect) doAreaCombatHealth(cid, type, pos, area, min, max, effect) doAreaCombatHealth(cid, type, pos, area, min, max, effect[, origin = ORIGIN_SPELL]) doAreaCombatMana(cid, pos, area, min, max, effect) doAreaCombatMana(cid, pos, area, min, max, effect[, origin = ORIGIN_SPELL]) doChallengeCreature(cid, target) doCombat(cid, combat, param) doCreateItem(itemid, <optional> type/count, pos) doCreateItem(itemid, type/count, pos) doCreateItemEx(itemid, <optional> count/subtype) doMoveCreature(cid, direction) doNpcSetCreatureFocus(cid) doPlayerAddItem(cid, itemid, <optional: default: 1> count, <optional: default: 1> canDropOnMap, <optional: default: 1>subtype) doPlayerAddItem(cid, itemid, <optional: default: 1> count/subtype, <optional: default: 1> canDropOnMap) doPlayerAddItem(uid, itemid, <optional: default: 1> count/subtype) doPlayerSetOfflineTrainingSkill(cid, skill) doPlayerSetOfflineTrainingSkill(cid, skillid) doSellItem(cid, itemid, amount, <optional> subtype, <optional> actionid, <optional: default: 1> canDropOnMap) doSetCreatureLight(cid, lightLevel, lightColor, time) doSetCreatureOutfit(cid, outfit, time) doSetItemOutfit(cid, item, time) doSetMonsterOutfit(cid, name, time) doTargetCombatCondition(cid, target, condition, effect) doTargetCombatDispel(cid, target, type, effect) doTargetCombatHealth(cid, target, type, min, max, effect) doTargetCombatHealth(cid, target, type, min, max, effect[, origin = ORIGIN_SPELL]) doTargetCombatMana(cid, target, min, max, effect) doTargetCombatMana(cid, target, min, max, effect[, origin = ORIGIN_SPELL) doTileAddItemEx(pos, uid) Game.createContainer(itemId, size[, position]) Game.createItem(itemId[, count[, position]]) Game.createMonster(monsterName, position[, extended = false[, force = false]]) Game.createNpc(npcName, position[, extended = false[, force = false]]) Game.createTile(position[, isDynamic = false]) Game.createTile(x, y, z[, isDynamic = false]) Game.getExperienceStage(level) Game.getGameState() Game.getHouses() Game.getMonsterCount() Game.getNpcCount() Game.getPlayerCount() Game.getPlayers() Game.getReturnMessage(value) Game.getSpectators(position[, multifloor = false[, onlyPlayer = false[, minRangeX = 0[, maxRangeX = 0[, minRangeY = 0[, maxRangeY = 0]]]]]]) Game.getTowns() Game.getWorldType() Game.loadMap(path) Game.setGameState(state) Game.setWorldType(type) Game.startRaid(raidName) getCreatureCondition(cid, condition[, subId]) getDepotId(uid) getDistanceTo(uid) getNpcCid() getNpcParameter(paramKey) getPlayerFlagValue(cid, flag) getPlayerInstantSpellCount(cid) getPlayerInstantSpellInfo(cid, index) getWaypointPosition(name) getWaypointPositionByName(name) getWorldLight() getWorldTime() getWorldUpTime() Group(id) group:getAccess() group:getFlags() group:getId() group:getMaxDepotItems() group:getMaxVipEntries() group:getName() Guild(id) guild:addMember(player) guild:addRank(id, name, level) guild:getId() guild:getMembersOnline() guild:getMotd() guild:getName() guild:getRankById(id) guild:getRankByLevel(level) guild:removeMember(player) guild:setMotd(motd) House(id) house:getAccessList(listId) house:getBedCount() house:getBeds() house:getDoorCount() house:getDoors() house:getExitPosition() house:getId() house:getName() house:getOwnerGuid() house:getRent() house:getTileCount() house:getTiles() house:getTown() house:setAccessList(listId, list) house:setOwnerGuid(guid[, updateDatabase = true]) isDepot(uid) isInArray(array, value) isInWar(cid, target) isMovable(uid) isMoveable(uid) isType(derived, base) isValidUID(uid) Item(uid) item:clone() item:decay() item:getActionId() item:getArticle() item:getAttribute(key) item:getCharges() item:getCount() item:getDescription(distance) item:getFluidType() item:getId() item:getName() item:getParent() item:getPluralName() item:getPosition() item:getSubType() item:getTile() item:getTopParent() item:getUniqueId() item:getWeight() item:hasAttribute(key) item:hasProperty(property) item:isItem() item:moveTo(position or cylinder) item:remove([count = -1]) item:removeAttribute(key) item:setActionId(actionId) item:setAttribute(key, value) item:split([count = 1]) item:transform(itemId[, count/subType = -1]) ItemType(id or name) itemType:getArmor() itemType:getArticle() itemType:getAttack() itemType:getCapacity() itemType:getCharges() itemType:getClientId() itemType:getDecayId() itemType:getDefense() itemType:getDescription() itemType:getElementDamage() itemType:getElementType() itemType:getExtraDefense() itemType:getFluidSource() itemType:getHitChance() itemType:getId() itemType:getName() itemType:getPluralName() itemType:getRequiredLevel() itemType:getShootRange() itemType:getSlotPosition() itemType:getTransformDeEquipId() itemType:getTransformEquipId() itemType:getType() itemType:getWeaponType() itemType:getWeight([count = 1]) itemType:hasSubType() itemType:isContainer() itemType:isCorpse() itemType:isDoor() itemType:isFluidContainer() itemType:isMovable() itemType:isReadable() itemType:isRune() itemType:isStackable() itemType:isWritable() ModalWindow(id, title, message) modalWindow:addButton(id, text) modalWindow:addChoice(id, text) modalWindow:getButtonCount() modalWindow:getChoiceCount() modalWindow:getDefaultEnterButton() modalWindow:getDefaultEscapeButton() modalWindow:getId() modalWindow:getMessage() modalWindow:getTitle() modalWindow:hasPriority() modalWindow:sendToPlayer(player) modalWindow:setDefaultEnterButton(buttonId) modalWindow:setDefaultEscapeButton(buttonId) modalWindow:setMessage(text) modalWindow:setPriority(priority) modalWindow:setTitle(text) Monster(id or userdata) monster:addFriend(creature) monster:addTarget(creature[, pushFront = false]) monster:getFriendCount() monster:getFriendList() monster:getSpawnPosition() monster:getTargetCount() monster:getTargetList() monster:getType() monster:isFriend(creature) monster:isIdle() monster:isInSpawnRange([position]) monster:isMonster() monster:isOpponent(creature) monster:isTarget(creature) monster:removeFriend(creature) monster:removeTarget(creature) monster:searchTarget([searchType = TARGETSEARCH_DEFAULT]) monster:selectTarget(creature) monster:setIdle(idle) MonsterType(id or name) monsterType:canPushCreatures() monsterType:canPushItems() monsterType:getArmor() monsterType:getAttackList() monsterType:getBaseSpeed() monsterType:getChangeTargetChance() monsterType:getChangeTargetSpeed() monsterType:getCombatImmunities() monsterType:getConditionImmunities() monsterType:getCorpseId() monsterType:getCreatureEvents() monsterType:getDefense() monsterType:getDefenseList() monsterType:getElementList() monsterType:getExperience() monsterType:getHealth() monsterType:getLight() monsterType:getLoot() monsterType:getManaCost() monsterType:getMaxHealth() monsterType:getMaxSummons() monsterType:getName() monsterType:getNameDescription() monsterType:getOutfit() monsterType:getRace() monsterType:getRunHealth() monsterType:getStaticAttackChance() monsterType:getSummonList() monsterType:getTargetDistance() monsterType:getVoices() monsterType:getYellChance() monsterType:getYellSpeedTicks() monsterType:isAttackable() monsterType:isConvinceable() monsterType:isHealthShown() monsterType:isHostile() monsterType:isIllusionable() monsterType:isPushable() monsterType:isSummonable() NetworkMessage() networkMessage:addByte(number) networkMessage:addDouble(number) networkMessage:addItem(item) networkMessage:addItemId(itemId) networkMessage:addPosition(position) networkMessage:addString(string) networkMessage:addU16(number) networkMessage:addU32(number) networkMessage:addU64(number) networkMessage:getByte() networkMessage:getPosition() networkMessage:getString() networkMessage:getU16() networkMessage:getU32() networkMessage:getU64() networkMessage:reset() networkMessage:sendToPlayer(player) networkMessage:skipBytes(number) Npc([id or name or userdata]) npc:closeShopWindow(player) npc:getParameter(key) npc:getSpeechBubble() npc:isNpc() npc:openShopWindow(cid, items, buyCallback, sellCallback) npc:setFocus(creature) npc:setMasterPos(pos[, radius]) npc:setSpeechBubble(speechBubble) onaddItem(moveitem, tileitem, pos) onAdvance(player, skill, oldLevel, newLevel) onBuy(player, itemid, count, amount, ignore, inbackpacks) onCastSpell(creature, var) onCastSpell(creature, var, isHotkey) onCreatureAppear(creature) onCreatureAppear(self, creature) onCreatureDisappear(creature) onCreatureDisappear(self, creature) onCreatureMove(creature, oldPos, newPos) onCreatureMove(self, creature, oldPosition, newPosition) onCreatureSay(creature, type, msg) onCreatureSay(self, creature, type, message) onDeath(creature, corpse, lasthitkiller, mostdamagekiller, lasthitunjustified, mostdamageunjustified) onDeEquip(player, item, slot) onEquip(player, item, slot) onExtendedOpcode(player, opcode, buffer) onGetPlayerMinMaxValues(...) onGetPlayerMinMaxValues(player, attackSkill, attackValue, attackFactor) onGetPlayerMinMaxValues(player, level, maglevel) onHealthChange(creature, attacker, primaryDamage, primaryType, secondaryDamage, secondaryType, origin) onJoin(player) onKill(creature, target) onLeave(player) onLogin(player) onLogout(player) onManaChange(creature, attacker, manaChange, origin) onModalWindow(player, modalWindowId, buttonId, choiceId) onPlayerCloseChannel(player) onPlayerEndTrade(player) onPrepareDeath(creature, killer) onRaid() onRecord(current, old) onRemoveItem(moveitem, tileitem, pos) onSay(player, words, param, type) onSpeak(player, type, message) onStepIn(creature, item, pos, fromPosition) onStepOut(creature, item, pos, fromPosition) onTargetCombat(creature, target) onTextEdit(player, item, text) onThink() onThink(creature, interval) onThink(self, interval) onTileCombat(creature, pos) onUse(player, item, fromPosition, target, toPosition, isHotkey) onUseWeapon(player, var) openShopWindow(cid, items, onBuy callback, onSell callback) os.mtime() party:addInvite(player) party:addMember(player) party:disband() party:getInviteeCount() party:getInvitees() party:getLeader() party:getMemberCount() party:getMembers() party:isSharedExperienceActive() party:isSharedExperienceEnabled() Party:onDisband() or Party.onDisband(self) Party:onJoin(player) or Party.onJoin(self, player) Party:onLeave(player) or Party.onLeave(self, player) party:removeInvite(player) party:removeMember(player) party:setLeader(player) party:setSharedExperience(active) party:shareExperience(experience) Player(id or name or userdata) player:addBlessing(blessing) player:addExperience(experience[, sendText = false]) player:addItem(itemId[, count = 1[, canDropOnMap = true[, subType = 1[, slot = CONST_SLOT_WHEREEVER]]]]) player:addItemEx(item[, canDropOnMap = false[, index = INDEX_WHEREEVER[, flags = 0]]]) player:addItemEx(item[, canDropOnMap = true[, slot = CONST_SLOT_WHEREEVER]]) player:addManaSpent(amount) player:addMapMark(position, type, description) player:addMoney(money) player:addMount(mountId) player:addOutfit(lookType) player:addOutfitAddon(lookType, addon) player:addPremiumDays(days) player:addSkillTries(skillType, tries) player:addSoul(soulChange) player:canLearnSpell(spellName) player:channelSay(speaker, type, text, channelId) player:forgetSpell(spellName) player:getAccountId() player:getAccountType() player:getBankBalance() player:getBaseMagicLevel() player:getCapacity() player:getClient() player:getContainerById(id) player:getContainerId(container) player:getContainerIndex(id) player:getDeathPenalty() player:getDepotChest(depotId[, autoCreate = false]) player:getEffectiveSkillLevel(skillType) player:getExperience() player:getFreeCapacity() player:getGroup() player:getGuid() player:getGuild() player:getGuildLevel() player:getGuildNick() player:getHouse() player:getInbox() player:getIp() player:getItemById(itemId, deepSearch[, subType = -1]) player:getItemCount(itemId[, subType = -1]) player:getLastLoginSaved() player:getLastLogout() player:getLevel() player:getMagicLevel() player:getManaSpent() player:getMaxSoul() player:getMoney() player:getParty() player:getPremiumDays() player:getSex() player:getSkillLevel(skillType) player:getSkillPercent(skillType) player:getSkillTries(skillType) player:getSkullTime() player:getSlotItem(slot) player:getSoul() player:getStamina() player:getStorageValue(key) player:getTown() player:getVocation() player:hasBlessing(blessing) player:hasLearnedSpell(spellName) player:hasMount(mountId) player:hasOutfit(lookType[, addon = 0]) player:isPlayer() player:isPzLocked() player:learnSpell(spellName) Player:onBrowseField(position) or Player.onBrowseField(self, position) Player:onGainExperience(source, exp, rawExp) Player:onGainSkillTries(skill, tries) Player:onLook(thing, position, distance) or Player.onLook(self, thing, position, distance) Player:onLookInBattleList(creature, position, distance) or Player.onLookInBattleList(self, creature, position, distance) Player:onLookInShop(itemType, count) or Player.onLookInShop(self, itemType, count) Player:onLookInTrade(partner, item, distance) or Player.onLookInTrade(self, partner, item, distance) Player:onLoseExperience(exp) Player:onMoveCreature(creature, fromPosition, toPosition) or Player.onMoveCreature(self, creature, fromPosition, toPosition) Player:onMoveItem(item, count, fromPosition, toPosition) or Player.onMoveItem(self, item, count, fromPosition, toPosition) Player:onTradeAccept(target, item, targetItem) Player:onTradeRequest(target, item) Player:onTurn(direction) or Player.onTurn(self, direction) player:openChannel(channelId) player:popupFYI(message) player:removeBlessing(blessing) player:removeExperience(experience[, sendText = false]) player:removeItem(itemId, count[, subType = -1[, ignoreEquipped = false]]) player:removeMoney(money) player:removeMount(mountId) player:removeOutfit(lookType) player:removeOutfitAddon(lookType, addon) player:removePremiumDays(days) player:save() player:sendChannelMessage(author, text, type, channelId) player:sendOutfitWindow() player:sendPrivateMessage(speaker, text[, type]) player:sendTextMessage(type, text[, position, primaryValue = 0, primaryColor = TEXTCOLOR_NONE[, secondaryValue = 0, secondaryColor = TEXTCOLOR_NONE]]) player:sendTutorial(tutorialId) player:setAccountType(accountType) player:setBankBalance(bankBalance) player:setCapacity(capacity) player:setGhostMode(enabled) player:setGroup(group) player:setGuild(guild) player:setGuildLevel(level) player:setGuildNick(nick) player:setMaxMana(maxMana) player:setSex(newSex) player:setSkullTime(skullTime) player:setStamina(stamina) player:setStorageValue(key, value) player:setTown(town) player:setVocation(id or name or userdata) player:showTextDialog(itemId[, text[, canWrite[, length]]]) Position([position]) Position([x = 0[, y = 0[, z = 0[, stackpos = 0]]]]) position:getDistance(positionEx) position:isSightClear(positionEx[, sameFloor = true]) position:sendDistanceEffect(positionEx, distanceEffect[, player = nullptr]) position:sendMagicEffect(magicEffect[, player = nullptr]) rawgetmetatable(metatableName) registerClass(className, baseClass, newFunction) registerEnum(value) registerEnumIn(tableName, value) registerGlobalMethod(functionName, function) registerGlobalVariable(name, value) registerMetaMethod(className, functionName, function) registerMethod(className, functionName, function) registerTable(tableName) registerVariable(tableName, name, value) saveServer() selfFollow(player) selfMove(direction) selfMoveTo(x,y,z) selfSay(words[, target]) selfTurn(direction) sendChannelMessage(channelId, type, message) sendGuildChannelMessage(guildId, type, message) setCombatArea(combat, area) setCombatCallBack(combat, key, function_name) setCombatCondition(combat, condition) setCombatFormula(combat, type, mina, minb, maxa, maxb) setCombatParam(combat, key, value) setConditionFormula(combat, mina, minb, maxa, maxb) setConditionFormula(condition, mina, minb, maxa, maxb) setConditionParam(condition, key, value) setmetatable(className, methodsTable) stopEvent(eventid) table.create(arrayLength, keyLength) Teleport(uid) teleport:getDestination() teleport:setDestination(position) Tile(position) Tile(x, y, z) tile:getBottomCreature() tile:getBottomVisibleCreature(creature) tile:getCreatureCount() tile:getCreatures() tile:getDownItemCount() tile:getFieldItem() tile:getGround() tile:getHouse() tile:getItemById(itemId[, subType = -1]) tile:getItemByTopOrder(topOrder) tile:getItemByType(itemType) tile:getItemCount() tile:getItemCountById(itemId[, subType = -1]) tile:getItems() tile:getPosition() tile:getThing(index) tile:getThingCount() tile:getThingIndex(thing) tile:getTopCreature() tile:getTopDownItem() tile:getTopItemCount() tile:getTopTopItem() tile:getTopVisibleCreature(creature) tile:getTopVisibleThing(creature) tile:hasFlag(flag) tile:hasProperty(property[, item]) tile:queryAdd(thing[, flags]) Town(id or name) town:getId() town:getName() town:getTemplePosition() Variant(number or string or position or thing) Variant:getNumber() Variant:getPosition() Variant:getString() version(CLIENT_VERSION_MIN) Vocation(id or name) vocation:getAttackSpeed() vocation:getBaseSpeed() vocation:getCapacityGain() vocation:getClientId() vocation:getDemotion() vocation:getDescription() vocation:getHealthGain() vocation:getHealthGainAmount() vocation:getHealthGainTicks() vocation:getId() vocation:getManaGain() vocation:getManaGainAmount() vocation:getManaGainTicks() vocation:getMaxSoul() vocation:getName() vocation:getPromotion() vocation:getRequiredManaSpent(magicLevel) vocation:getRequiredSkillTries(skillType, skillLevel) vocation:getSoulGainTicks() Data functions - Funções pra LUA Container.isContainer(self) Creature.getClosestFreePosition(self, position, extended) Creature.getPlayer(self) Creature.isItem(self) Creature.isMonster(self) Creature.isNpc(self) Creature.isPlayer(self) Creature.isTile(self) Creature:onAreaCombat(tile, isAggressive) Creature:onChangeOutfit(outfit) Creature:onTargetCombat(target) CreatureIndex(self, key) FocusModule.messageMatcher(keywords, message) FocusModule.onFarewell(cid, message, keywords, parameters) FocusModule.onGreet(cid, message, keywords, parameters) FocusModule:init(handler) FocusModule:new() Game.broadcastMessage(message, messageType) Game.convertIpToString(ip) Game.getReverseDirection(direction) Game.getSkillType(weaponType) Game.getStorageValue(key) Game.setStorageValue(key, value) Item.getType(self) Item.isContainer(self) Item.isCreature(self) Item.isPlayer(self) Item.isTeleport(self) Item.isTile(self) ItemIndex(self, key) ItemType.usesSlot(self, slot) KeywordHandler:addKeyword(keys, callback, parameters) KeywordHandler:getLastNode(cid) KeywordHandler:getRoot() KeywordHandler:moveUp(cid, steps) KeywordHandler:new() KeywordHandler:processMessage(cid, message) KeywordHandler:processNodeMessage(node, cid, message) KeywordHandler:reset(cid) KeywordModule:addKeyword(keywords, reply) KeywordModule:init(handler) KeywordModule:new() KeywordModule:parseKeywords(data) KeywordModule:parseParameters() KeywordNode:addChildKeyword(keywords, callback, parameters) KeywordNode:addChildKeywordNode(childNode) KeywordNode:checkMessage(message) KeywordNode:getKeywords() KeywordNode:getParameters() KeywordNode:getParent() KeywordNode:new(keys, func, param) KeywordNode:processMessage(cid, message) NpcHandler:addFocus(newFocus) NpcHandler:addModule(module) NpcHandler:cancelNPCTalk(events) NpcHandler:doNPCTalkALot(msgs, interval, pcid) NpcHandler:getCallback(id) NpcHandler:getMessage(id) NpcHandler:greet(cid) NpcHandler:isFocused(focus) NpcHandler:isInRange(cid) NpcHandler:new(keywordHandler) NpcHandler:onBuy(creature, itemid, subType, amount, ignoreCap, inBackpacks) NpcHandler:onCreatureAppear(creature) NpcHandler:onCreatureDisappear(creature) NpcHandler:onCreatureSay(creature, msgtype, msg) NpcHandler:onFarewell(cid) NpcHandler:onGreet(cid) NpcHandler:onPlayerCloseChannel(creature) NpcHandler:onPlayerEndTrade(creature) NpcHandler:onSell(creature, itemid, subType, amount, ignoreCap, inBackpacks) NpcHandler:onThink() NpcHandler:onTradeRequest(cid) NpcHandler:onWalkAway(cid) NpcHandler:parseMessage(msg, parseInfo) NpcHandler:processModuleCallback(id, ...) NpcHandler:releaseFocus(focus) NpcHandler:resetNpc(cid) NpcHandler:say(message, focus, publicize, shallDelay, delay) NpcHandler:setCallback(id, callback) NpcHandler:setKeywordHandler(newHandler) NpcHandler:setMaxIdleTime(newTime) NpcHandler:setMessage(id, newMessage) NpcHandler:unGreet(cid) NpcHandler:updateFocus() NpcSystem.getParameter(key) NpcSystem.parseParameters(npcHandler) Party:onDisband() Party:onJoin(player) Party:onLeave(player) Player.addSkillTries(...) Player.feed(self, food) Player.getClosestFreePosition(self, position, extended) Player.getDepotItems(self, depotId) Player.getLossPercent(self) Player.isPremium(self) Player.isUsingOtClient(self) Player.sendCancelMessage(self, message) Player.sendExtendedOpcode(self, opcode, buffer) Player:isPremium() Player:onBrowseField(position) Player:onGainExperience(source, exp, rawExp) Player:onGainSkillTries(skill, tries) Player:onLook(thing, position, distance) Player:onLookInBattleList(creature, distance) Player:onLookInShop(itemType, count) Player:onLookInTrade(partner, item, distance) Player:onLoseExperience(exp) Player:onMoveCreature(creature, fromPosition, toPosition) Player:onMoveItem(item, count, fromPosition, toPosition) Player:onTradeAccept(target, item, targetItem) Player:onTradeRequest(target, item) Player:onTurn(direction) Position.getNextPosition(self, direction, steps) Position.getTile(self) Position:getNextPosition(direction, steps) Position:moveUpstairs() ShopModule.messageMatcher(keywords, message) ShopModule.onConfirm(cid, message, keywords, parameters, node) ShopModule.onDecline(cid, message, keywords, parameters, node) ShopModule.requestTrade(cid, message, keywords, parameters, node) ShopModule.tradeItem(cid, message, keywords, parameters, node) ShopModule:addBuyableItem(names, itemid, cost, itemSubType, realName) ShopModule:addBuyableItemContainer(names, container, itemid, cost, subType, realName) ShopModule:addSellableItem(names, itemid, cost, realName, itemSubType) ShopModule:callbackOnBuy(cid, itemid, subType, amount, ignoreCap, inBackpacks) ShopModule:callbackOnModuleReset() ShopModule:callbackOnSell(cid, itemid, subType, amount, ignoreEquipped, _) ShopModule:getCount(message) ShopModule:getShopItem(itemId, itemSubType) ShopModule:init(handler) ShopModule:new() ShopModule:parseBuyable(data) ShopModule:parseBuyableContainers(data) ShopModule:parseParameters() ShopModule:parseSellable(data) ShopModule:reset() StdModule.bless(cid, message, keywords, parameters, node) StdModule.learnSpell(cid, message, keywords, parameters, node) StdModule.promotePlayer(cid, message, keywords, parameters, node) StdModule.say(cid, message, keywords, parameters, node) StdModule.travel(cid, message, keywords, parameters, node) Teleport.isTeleport(self) Tile.isCreature(self) Tile.isItem(self) Tile.isTile(self) TravelModule.bringMeTo(cid, message, keywords, parameters, node) TravelModule.listDestinations(cid, message, keywords, parameters, node) TravelModule.onConfirm(cid, message, keywords, parameters, node) TravelModule.onDecline(cid, message, keywords, parameters, node) TravelModule.travel(cid, message, keywords, parameters, node) TravelModule:addDestination(name, position, price, premium) TravelModule:init(handler) TravelModule:new() TravelModule:parseDestinations(data) TravelModule:parseParameters() broadcastMessage(message, messageType) canJoin(player) canPlayerLearnInstantSpell(cid, name) canPlayerWearOutfit(cid, lookType, addons) creatureSayCallback(cid, type, msg) destroyItem(cid, target, toPosition) doAddCondition(cid, conditionId) doAddContainerItemEx(uid, virtualId) doAddMapMark(cid, pos, type, description) doChangeSpeed(cid, delta) doChangeTypeItem(uid, newType) doConvinceCreature(cid, target) doCreateNpc(name, pos, ...) doCreateTeleport(itemId, destination, position) doCreatureAddHealth(cid, health) doCreatureChangeOutfit(cid, outfit) doCreatureSay(cid, text, type, ...) doCreatureSayWithDelay(cid, text, type, delay, e, pcid) doCreatureSayWithRadius(cid, text, type, radiusx, radiusy, position) doCreatureSetLookDir(cid, direction) doDecayItem(uid) doForceSummonCreature(name, pos) doMonsterChangeTarget(cid) doNpcSellItem(cid, itemid, amount, subType, ignoreCap, inBackpacks, backpack) doPlayerAddBlessing(cid, blessing) doPlayerAddExp(cid, exp, useMult, ...) doPlayerAddItemEx(cid, uid, ...) doPlayerAddMana(cid, mana, ...) doPlayerAddManaSpent(cid, mana) doPlayerAddMoney(cid, money) doPlayerAddMount(cid, mountId) doPlayerAddOutfit(cid, lookType, addons) doPlayerAddPremiumDays(cid, days) doPlayerAddSkillTry(cid, skillid, n) doPlayerAddSoul(cid, soul) doPlayerBuyItemContainer(cid, containerid, itemid, count, cost, charges) doPlayerFeed(cid, food) doPlayerJoinParty(cid, leaderId) doPlayerPopupFYI(cid, message) doPlayerRemOutfit(cid, lookType, addons) doPlayerRemoveItem(cid, itemid, count, ...) doPlayerRemoveMoney(cid, money) doPlayerRemoveMount(cid, mountId) doPlayerRemovePremiumDays(cid, days) doPlayerSellItem(cid, itemid, count, cost) doPlayerSendCancel(cid, text) doPlayerSendTextMessage(cid, type, text, ...) doPlayerSetBalance(cid, balance) doPlayerSetGuildLevel(cid, level) doPlayerSetGuildNick(cid, nick) doPlayerSetSex(cid, sex) doPlayerSetTown(cid, town) doPlayerSetVocation(cid, vocation) doPlayerTakeItem(cid, itemid, count) doRelocate(fromPos, toPos) doRemoveCondition(cid, conditionType, subId) doRemoveCreature(cid) doRemoveItem(uid, ...) doSendAnimatedText() doSendDistanceShoot(fromPos, toPos, distanceEffect, ...) doSendMagicEffect(pos, magicEffect, ...) doSendTutorial(cid, tutorialId) doSetCreatureDropLoot(cid, doDrop) doSetItemActionId(uid, actionId) doSetItemSpecialDescription(uid, desc) doSetItemText(uid, text) doSetMonsterTarget(cid, target) doShowTextDialog(cid, itemId, text) doSummonCreature(name, pos, ...) doTeleportThing(uid, dest, pushMovement) doTransformItem(uid, newItemId, ...) firstServerSaveWarning() getAccountNumberByPlayerName(name) getArticle(str) getBlessingsCost(level) getConfigInfo(info) getContainerCap(uid) getContainerCapById(itemId) getContainerItem(uid, slot) getContainerSize(uid) getCount(string) getCreatureBaseSpeed(cid) getCreatureHealth(cid) getCreatureMaster(cid) getCreatureMaxHealth(cid) getCreatureName(cid) getCreatureOutfit(cid) getCreaturePosition(cid) getCreatureSpeed(cid) getCreatureSummons(cid) getCreatureTarget(cid) getDistanceBetween(firstPosition, secondPosition) getExpForLevel(level) getFluidSourceType(itemId) getFormattedWorldTime() getGlobalStorageValue(key) getGuildId(guildName) getHouseAccessList(id, listId) getHouseByPlayerGUID(playerGUID) getHouseEntry(houseId) getHouseName(houseId) getHouseOwner(houseId) getHouseRent(id) getHouseTilesSize(houseId) getHouseTown(houseId) getIPByPlayerName(name) getItemDescriptions(itemId) getItemIdByName(name) getItemName(itemId) getItemRWInfo(uid) getItemWeight(itemId, ...) getItemWeightByUID(uid, ...) getMonsterFriendList(cid) getMonsterTargetList(cid) getMonthDayEnding(day) getMonthString(m) getOnlinePlayers() getPartyMembers(cid) getPlayerAccess(cid) getPlayerAccountType(cid) getPlayerBalance(cid) getPlayerBlessing(cid, blessing) getPlayerByName(name) getPlayerDepotItems(cid, depotId) getPlayerFood(cid) getPlayerFreeCap(cid) getPlayerGUID(cid) getPlayerGUIDByName(name) getPlayerGroupId(cid) getPlayerGuildId(cid) getPlayerGuildLevel(cid) getPlayerGuildName(cid) getPlayerGuildNick(cid) getPlayerGuildRank(cid) getPlayerIp(cid) getPlayerItemById(cid, deepSearch, itemId, ...) getPlayerItemCount(cid, itemId, ...) getPlayerLastLoginSaved(cid) getPlayerLearnedInstantSpell(cid, name) getPlayerLevel(cid) getPlayerLight(cid) getPlayerLookDir(cid) getPlayerLossPercent(cid) getPlayerMagLevel(cid) getPlayerMana(cid) getPlayerMasterPos(cid) getPlayerMaxMana(cid) getPlayerMoney(cid) getPlayerMount(cid, mountId) getPlayerName(cid) getPlayerParty(cid) getPlayerPosition(cid) getPlayerPremiumDays(cid) getPlayerSex(cid) getPlayerSkill(cid, skillId) getPlayerSkullType(cid) getPlayerSlotItem(cid, slot) getPlayerSoul(cid) getPlayerStorageValue(cid, key) getPlayerTown(cid) getPlayerVocation(cid) getPlayersByAccountNumber(accountNumber) getPlayersByIPAddress(ip, mask) getPromotedVocation(vocationId) getPvpBlessingCost(level) getSkillId(skillName) getSpectators(centerPos, rangex, rangey, multifloor, onlyPlayers) getThing(uid) getThingPos(uid) getThingfromPos(pos) getTibianTime() getTileHouseInfo(pos) getTileInfo(position) getTileItemById(position, itemId, ...) getTileItemByType(position, itemType) getTilePzInfo(position) getTileThingByPos(position) getTileThingByTopOrder(position, topOrder) getTopCreature(position) getTownId(townName) getTownName(townId) getTownTemplePosition(townId) getWorldCreatures(type) greetCallback(cid) hasProperty(uid, prop) internalBedTransform(item, targetItem, toPosition, ids) isContainer(uid) isCorpse(uid) isCreature(cid) isDruid(cid) isInRange(pos, fromPos, toPos) isItem(uid) isItemContainer(itemId) isItemDoor(itemId) isItemFluidContainer(itemId) isItemMovable(itemId) isItemRune(itemId) isItemStackable(itemId) isKnight(cid) isMonster(cid) isNpc(cid) isNumber(str) isPaladin(cid) isPlayer(cid) isPlayerGhost(cid) isPlayerPzLocked(cid) isPremium(cid) isSightClear(fromPos, toPos, floorCheck) isSorcerer(cid) isSummon(cid) msgcontains(message, keyword) onAddFocus(cid) onAddItem(moveitem, tileitem, position) onCastSpell(cid, var) onCastSpell(cid, var, isHotkey) onCastSpell(creature, var) onCastSpell(creature, var, isHotkey) onCastSpell(creature, variant, isHotkey) onCreatureAppear(cid) onCreatureDisappear(cid) onCreatureSay(cid, type, msg) onDeath(player, corpse, killer, mostDamage, unjustified, mostDamage_unjustified) onDeath(player, corpse, killer, mostDamageKiller, unjustified, mostDamageUnjustified) onExtendedOpcode(player, opcode, buffer) onGetFormulaValues(cid, level, maglevel) onGetFormulaValues(cid, skill, attack, factor) onGetFormulaValues(player, level, attack, factor) onLogin(player) onLogout(player) onRecord(current, old) onReleaseFocus(cid) onRemoveItem(item, tile, position) onSay(player, words, param) onSpeak(player, type, message) onStartup() onStepIn(creature, item, position, fromPosition) onStepOut(creature, item, position, fromPosition) onTargetCreature(creature, target) onTargetTile(creature, pos) onThink() onTime(interval) onUpdateDatabase() onUse(cid, item, fromPosition, target, toPosition, isHotkey) onUse(player, item, fromPosition, target, toPosition, isHotkey) onUseWeapon(player, var) playerLearnInstantSpell(cid, name) pushThing(thing) queryTileAddThing(thing, position, ...) registerCreatureEvent(cid, name) secondServerSaveWarning() serverSave() setGlobalStorageValue(key, value) setHouseAccessList(id, listId, listText) setHouseOwner(id, guid) setPlayerGroupId(cid, groupId) setPlayerStorageValue(cid, key, value) spellCallback(param) targetPositionToVariant(position) unregisterCreatureEvent(cid, name) useStamina(player) Créditos felzan

Beleza... Vamos lá... Eu estou muito enferrujado em sql, então vamos torcer pra dar certo... Sem contar que eu não tenho ctz se as sua table e colunas são exatamente da forma como eu as escrevi no script. Então, vamos ao teste. Aqui está o script de sacar. Se ele funcionar, aí vc me avise que eu faço os outros 2. Se ele ñ funcionar, diga qual o erro que deu e mande uma print da sua table accounts. local pointObj = 2160 --id do item "points" function onSay(cid, words, param) if param ~= "" then playerPoints = db.executeQuery("SELECT FROM `accounts` GET `premium_points` WHERE id='.. getPlayerAccountId(cid)..'") if param <= playerPoints then doPlayerAddItem(cid, pointObj, param) db.executeQuery("UPDATE accounts SET `premium_points`='..playerPoints-param..' WHERE id='.. getPlayerAccountId(cid)..'") playerPointsNew = db.executeQuery("SELECT FROM `accounts` GET `premium_points` WHERE id='.. getPlayerAccountId(cid)..'") doPlayerSendTextMessage(cid, 22, "Você ainda possui '..playerPointsNew..' premium points em sua conta no shopping.") else doPlayerSendCancel(cid, "Você não tem tantos premium points assim.") end else doPlayerSendCancel(cid, "Você precisa especificar um valor.") end return true end *caso não saiba instalar uma talkaction, avisa, que aí eu te ensino.