Danihcv

Agora 7... :/

Não entendi o que vc quis dizer mt bem... :s Melhor esperar ele explicar um pouco melhor...

Pode postar seu vocations.xml aqui??

Amigo, seu problema está na sua data base. Veja se vc tem uma table chamada z_ots_comunication. E me mande uma foto de sua data base, com todas as suas tables. E caso tenha a table z_ots_comunication em sua data base, abra ela e me mande um print também. Abraços.

Mesmo problema... :/

Bom galera, meu ot é 10.10 TFS, o script de rank que uso é esse: local config = { MaxPlayer = 20, fight_skills = { ['fist'] = 0, ['club'] = 1, ['sword'] = 2, ['axe'] = 3, ['distance'] = 4, ['shielding'] = 5, ['fishing'] = 6, ['dist'] = 4, ['shield'] = 5, ['fish'] = 6, }, other_skills = { [''] = "level", ['level'] = "level", ['magic'] = "maglevel", ['health'] = "healthmax", ['mana'] = "manamax" }, vocations = { ['sorcerer'] = {1,5}, ['druid'] = {2,6}, ['paladin'] = {3,7}, ['knight'] = {4,8} }, storages = { ['frags'] = 824544 } } function onSay(cid, words, param) local param,str = string.lower(param),"" if not config.fight_skills[param] and not config.other_skills[param] and not config.vocations[param] and not config.storages[param] then doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "este rank não existe.") return true end str = "--[ RANK "..(param == "" and "LEVEL" or string.upper(param)).." ]--\n\n" query = config.fight_skills[param] and db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = "..config.fight_skills[param].." ORDER BY `value` DESC;") or config.other_skills[param] and db.getResult("SELECT `name`, `"..config.other_skills[param].."` FROM `players` WHERE `id` > 6 AND `group_id` < 2 ORDER BY `"..config.other_skills[param].."` DESC, `name` ASC;") or config.storages[param] and db.getResult("SELECT `player_id`, `value` FROM `player_storage` WHERE `key` = "..config.storages[param].." ORDER BY cast(value as INTEGER) DESC;") or db.getResult("SELECT `name`, `level` FROM `players` WHERE `group_id` <= 2 AND `vocation` = "..config.vocations[param][1].." or `vocation` = "..config.vocations[param][2].." ORDER BY `level` DESC;") if (query:getID() ~= -1) then k = 1 while true do str = str .. "\n " .. k .. ". "..(config.fight_skills[param] or query:getDataString("name")).." - [" .. query:getDataInt((config.fight_skills[param] and "value" or config.storages[param] and "value" or config.vocations[param] and "level" or config.other_skills[param])) .. "]" k = k + 1 if not(query:next()) or k > config.MaxPlayer then break end end query:free() end doShowTextDialog(cid,6500, str) return true end Ele funciona perfeitamente para ranking de level, magic level, health e mana. Porém quando quando uso o comando pra mostrar o ranking da sword, por exemplo, aí aparecem os top 10 com o numero 2 ao invés dos nomes dos players mas os níveis de swords aparecem certos. Alguem ajuda pfpfpf!! Dou REP+ Abraços.

Pow cara, não conheço ot pokemon, mas se o sistema de monstros/criaturas for igual ao ot normal vc faz o seguinte: va no arquivo do pokemon, abra-o com bloco de notas ou qualquer outro editor de sua preferencia, e onde tem <flag hostile="1"/> vc põe assim: <flag hostile="0"/> Se o sistema de monster for igual aos ots normais, então vai dar certo. Abraços.

@UP

Não funcionou aqui nenhum dos dois, acho que ta faltando eu fazer alguma coisa, alguem poderia explicar um pouco mais detalhado?? Abraços.

Coloco no creaturescript.xml tb ne??

Queria fazer uma coisa semelhante só que pondo dias de premium ao invés de vip... Pode ajudar??

kkk que dahora vei!!

Tenta esse, coloca em data/globalevents/scripts: local config = { storage = STORAGE VIP, tempo = 3, } function onThink(cid, interval, lastExecution) if getPlayerStorageValue(cid, config.storage) == 1 then SendText(cid) end return TRUE end function SendText(cid) doSendMagicEffect(getPlayerPosition(cid), 41) doSendAnimatedText(getCreaturePosition(cid), "VIP Char!", math.random(0, 54)) addEvent(SendText, config.tempo*1000, cid) return TRUE end E no globalevents.xml adiciona: <globalevent name="vipEffect" interval="3" script="vipEffect.lua"/> Peguei esse script feito pelo Kimoszin e deu uma editada rápida. Vê se pega.

Amigo, faz o que o companheiro disse com o seu movements.xml antigo: Abraços.

Sim, use o sqlite editor, no momento não posso te passar link pq estou pelo celular :s mas tenho ctz que vc encontra facil pra baixar. Se tiver dificuldades pra mexer nele basta procurar um tutorial, caso não encontre me comunique e farei um bem detalhado. Abraços.

Toda positividade eu desejo a você, Pois precisamos disso, nos dias de luta, O medo cega os nossos sonhos, O medo cega os nossos sonhos, Mina linda eu quero morar na sua rua, Você deixou saudade, você deixou saudade, Quero te ver outra vez, quero te ver outra vez, Você deixou saudade

Mudaria sim, mas tb eh bem fácil de configurar. Pra saber as coordenadas eh soh usar o RME.

Soh procurar um mapa global pra baixar e substituir na pasta data/world Mas vc tem q renomear o novo mapa pra ficar com o msm nome do mapa antigo, ou ir no config.lua e mudar o nome antigo do mapa pra o novo. Abraços!

Aqui deu um erro quando eu fui entrar com outra conta pelo mesmo pc pra testar:

Problema resolvido, via skype!!! Tópico ja pode ser fechado.

Faz assim, tenta esse bank.lua: local config = { pin = false, -- players can protect their money with pin code (like in cash machines) (true/false) pinMinLength = 4, -- minimum pin length pinMaxLength = 4, -- maximum pin length pinStorage = 3006, -- only if pin enabled (used to store player pin) transferDisabledVocations = {0} -- disable non vocation characters } local talkState = {} local count = {} local transfer = {} local pin = {} local keywordHandler = KeywordHandler:new() local npcHandler = NpcHandler:new(keywordHandler) NpcSystem.parseParameters(npcHandler) function onCreatureAppear(cid) npcHandler:onCreatureAppear(cid) end function onCreatureDisappear(cid) npcHandler:onCreatureDisappear(cid) end function onCreatureSay(cid, type, msg) npcHandler:onCreatureSay(cid, type, msg) end function onThink() npcHandler:onThink() end if(config.pin) then bank_pin = { get = function(cid) return getPlayerStorageValue(cid, config.pinStorage) end, set = function(cid, code) return setPlayerStorageValue(cid, config.pinStorage, code) end, logged = function(cid) return pin[cid] == bank_pin.get(cid) end, validate = function(code) if(not isNumber(code)) then return false end local length = tostring(code):len() return (length >= config.pinMinLength and length <= config.pinMaxLength) end } end if(not getPlayerBalance) then getPlayerBalance = function(cid) local result = db.getResult("SELECT `balance` FROM `players` WHERE `id` = " .. getPlayerGUID(cid)) if(result:getID() == -1) then return false end local value = tonumber(result:getDataString("balance")) result:free() return value end doPlayerSetBalance = function(cid, balance) db.executeQuery("UPDATE `players` SET `balance` = " .. balance .. " WHERE `id` = " .. getPlayerGUID(cid)) return true end doPlayerWithdrawMoney = function(cid, amount) local balance = getPlayerBalance(cid) if(amount > balance or not doPlayerAddMoney(cid, amount)) then return false end doPlayerSetBalance(cid, balance - amount) return true end doPlayerDepositMoney = function(cid, amount) if(not doPlayerRemoveMoney(cid, amount)) then return false end doPlayerSetBalance(cid, getPlayerBalance(cid) + amount) return true end doPlayerTransferMoneyTo = function(cid, target, amount) local balance = getPlayerBalance(cid) if(amount > balance) then return false end local tid = getPlayerByName(target) if(tid > 0) then doPlayerSetBalance(tid, getPlayerBalance(tid) + amount) else if(playerExists(target) == FALSE) then return false end db.executeQuery("UPDATE `player_storage` SET `value` = `value` + '" .. amount .. "' WHERE `player_id` = (SELECT `id` FROM `players` WHERE `name` = '" .. escapeString(player) .. "') AND `key` = '" .. balance_storage .. "'") end doPlayerSetBalance(cid, getPlayerBalance(cid) - amount) return true end end if(not doPlayerSave) then local function doPlayerSave(cid) return true end end local function getPlayerVocationByName(name) local result = db.getResult("SELECT `vocation` FROM `players` WHERE `name` = " .. db.escapeString(name)) if(result:getID() == -1) then return false end local value = result:getDataString("vocation") result:free() return value end local function isValidMoney(money) return (isNumber(money) and money > 0 and money < 4294967296) end local function getCount(string) local b, e = string:find("%d+") local money = b and e and tonumber(string:sub(b, e)) or -1 if(isValidMoney(money)) then return money end return -1 end function greetCallback(cid) talkState[cid], count[cid], transfer[cid], pin[cid] = 0, nil, nil, nil return true end function creatureSayCallback(cid, type, msg) if(not npcHandler:isFocused(cid)) then return false end ---------------------------- pin ------------------------- if(config.pin) then if(talkState[cid] == "verify-pin") then talkState[cid] = 0 pin[cid] = getCount(msg) if(not bank_pin.logged(cid)) then selfSay("Invalid pin code entered. Please try again.", cid) return true end selfSay("You have been successfully logged in.", cid) elseif(talkState[cid] == "new-pin") then talkState[cid] = 0 if(bank_pin.get(cid) ~= -1 and not bank_pin.logged(cid)) then selfSay("Please login before attempting to change your pin code.", cid) talkState[cid] = "verify-pin" return true end if(msgcontains(msg, 'reset') or msgcontains(msg, 'remove') or msgcontains(msg, 'clear')) then selfSay("Pin code has been removed.", cid) pin[cid] = nil bank_pin.set(cid, -1) return true end pin[cid] = getCount(msg) if(bank_pin.validate(pin[cid])) then selfSay("Pin code successfully changed.", cid) bank_pin.set(cid, pin[cid]) else local str = "" if(config.pinMinLength ~= config.pinMaxLength) then str = config.pinMinLength .. " - " .. config.pinMaxLength else str = config.pinMinLength end selfSay("Invalid pin code entered. Your pin should contain " .. str .. " digits", cid) end return true elseif(msgcontains(msg, 'balance') or msgcontains(msg, 'deposit') or msgcontains(msg, 'withdraw') or msgcontains(msg, 'transfer')) then if(bank_pin.get(cid) ~= -1 and not bank_pin.logged(cid)) then selfSay("Please tell me your bank pin code before making any transactions.", cid) talkState[cid] = "verify-pin" return true end talkState[cid] = 0 elseif(msgcontains(msg, 'login')) then talkState[cid] = "verify-pin" return true elseif(msgcontains(msg, 'pin')) then selfSay("Please tell me your new pin code.", cid) talkState[cid] = "new-pin" return true end end ---------------------------- help ------------------------ if msgcontains(msg, 'advanced') then if isInArray(config.transferDisabledVocations, getPlayerVocation(cid)) then selfSay("Once you are on the Tibian mainland, you can access new functions of your bank account, such as transferring money to other players safely or taking part in house auctions.", cid) else selfSay("Renting a house has never been this easy. Simply make a bid for an auction. We will check immediately if you have enough money.", cid) end talkState[cid] = 0 elseif msgcontains(msg, 'help') or msgcontains(msg, 'functions') then selfSay("You can check the {balance} of your bank account, {deposit} money or {withdraw} it. You can also {transfer} money to other characters, provided that they have a vocation.", cid) talkState[cid] = 0 elseif msgcontains(msg, 'bank') then npcHandler:say("We can change money for you. You can also access your bank account.", cid) talkState[cid] = 0 elseif msgcontains(msg, 'job') then npcHandler:say("I work in this bank. I can change money for you and help you with your bank account.", cid) talkState[cid] = 0 ---------------------------- balance --------------------- elseif msgcontains(msg, 'balance') then selfSay("Your account balance is " .. getPlayerBalance(cid) .. " gold.", cid) talkState[cid] = 0 ---------------------------- deposit --------------------- elseif msgcontains(msg, 'deposit all') and getPlayerMoney(cid) > 0 then count[cid] = getPlayerMoney(cid) if not isValidMoney(count[cid]) then selfSay("Sorry, but you can't deposit that much.", cid) talkState[cid] = 0 return false end if count[cid] < 1 then selfSay("You don't have any money to deposit in you inventory..", cid) talkState[cid] = 0 else selfSay("Would you really like to deposit " .. count[cid] .. " gold?", cid) talkState[cid] = 2 end elseif msgcontains(msg, 'deposit') then selfSay("Please tell me how much gold it is you would like to deposit.", cid) talkState[cid] = 1 elseif talkState[cid] == 1 then count[cid] = getCount(msg) if isValidMoney(count[cid]) then selfSay("Would you really like to deposit " .. count[cid] .. " gold?", cid) talkState[cid] = 2 else selfSay("Is isnt valid amount of gold to deposit.", cid) talkState[cid] = 0 end elseif talkState[cid] == 2 then if msgcontains(msg, 'yes') then if not doPlayerDepositMoney(cid, count[cid]) then selfSay("You don\'t have enough gold.", cid) else selfSay("Alright, we have added the amount of " .. count[cid] .. " gold to your balance. You can withdraw your money anytime you want to. Your account balance is " .. getPlayerBalance(cid) .. ".", cid) doPlayerSave(cid) end elseif msgcontains(msg, 'no') then selfSay("As you wish. Is there something else I can do for you?", cid) end talkState[cid] = 0 ---------------------------- withdraw -------------------- elseif msgcontains(msg, 'withdraw') then selfSay("Please tell me how much gold you would like to withdraw.", cid) talkState[cid] = 6 elseif talkState[cid] == 6 then count[cid] = getCount(msg) if isValidMoney(count[cid]) then selfSay("Are you sure you wish to withdraw " .. count[cid] .. " gold from your bank account?", cid) talkState[cid] = 7 else selfSay("Is isnt valid amount of gold to withdraw.", cid) talkState[cid] = 0 end elseif talkState[cid] == 7 then if msgcontains(msg, 'yes') then if not doPlayerWithdrawMoney(cid, count[cid]) then selfSay("There is not enough gold on your account. Your account balance is " .. getPlayerBalance(cid) .. ". Please tell me the amount of gold coins you would like to withdraw.", cid) talkState[cid] = 0 else selfSay("Here you are, " .. count[cid] .. " gold. Please let me know if there is something else I can do for you.", cid) talkState[cid] = 0 doPlayerSave(cid) end elseif msgcontains(msg, 'no') then selfSay("As you wish. Is there something else I can do for you?", cid) talkState[cid] = 0 end ---------------------------- transfer -------------------- elseif msgcontains(msg, 'transfer') then selfSay("Please tell me the amount of gold you would like to transfer.", cid) talkState[cid] = 11 elseif talkState[cid] == 11 then count[cid] = getCount(msg) if getPlayerBalance(cid) < count[cid] then selfSay("You dont have enough money on your bank account.", cid) talkState[cid] = 0 return true end if isValidMoney(count[cid]) then selfSay("Who would you like transfer " .. count[cid] .. " gold to?", cid) talkState[cid] = 12 else selfSay("Is isnt valid amount of gold to transfer.", cid) talkState[cid] = 0 end elseif talkState[cid] == 12 then transfer[cid] = msg if getCreatureName(cid) == transfer[cid] then selfSay("Ekhm, You want transfer money to yourself? Its impossible!", cid) talkState[cid] = 0 return true end if isInArray(config.transferDisabledVocations, getPlayerVocation(cid)) then selfSay("Your vocation cannot transfer money.", cid) talkState[cid] = 0 end if playerExists(transfer[cid]) then selfSay("So you would like to transfer " .. count[cid] .. " gold to \"" .. transfer[cid] .. "\" ?", cid) talkState[cid] = 13 else selfSay("Player with name \"" .. transfer[cid] .. "\" doesnt exist.", cid) talkState[cid] = 0 end elseif talkState[cid] == 13 then if msgcontains(msg, 'yes') then local targetVocation = getPlayerVocationByName(transfer[cid]) if not targetVocation or isInArray(config.transferDisabledVocations, targetVocation) or not doPlayerTransferMoneyTo(cid, transfer[cid], count[cid]) then selfSay("This player does not exist on this world or have no vocation.", cid) else selfSay("You have transferred " .. count[cid] .. " gold to \"" .. transfer[cid] .."\".", cid) transfer[cid] = nil doPlayerSave(cid) end elseif msgcontains(msg, 'no') then selfSay("As you wish. Is there something else I can do for you?", cid) end talkState[cid] = 0 ---------------------------- money exchange -------------- elseif msgcontains(msg, 'chdsadadasangedasdadasf') then npcHandler:say("How many platinum coins would you like to get?", cid) talkState[cid] = 14 elseif talkState[cid] == 14 then if getCount(msg) == -1 or getCount(msg) == 0 then npcHandler:say("Hmm, can I help you with something else?", cid) talkState[cid] = 0 else count[cid] = getCount(msg) npcHandler:say("So you would like me to change " .. count[cid] * 100 .. " of your gold coins into " .. count[cid] .. " platinum coins?", cid) talkState[cid] = 15 end elseif talkState[cid] == 15 then if msgcontains(msg, 'yes') then if doPlayerRemoveItem(cid, 2148, count[cid] * 100) then doPlayerAddItem(cid, 2152, count[cid]) npcHandler:say("Here you are.", cid) else npcHandler:say("Sorry, you do not have enough gold coins.", cid) end else npcHandler:say("Well, can I help you with something else?", cid) end talkState[cid] = 0 elseif msgcontains(msg, 'chandsadadsagefdsfsdfds platinum') then npcHandler:say("Would you like to change your platinum coins into gold or crystal?", cid) talkState[cid] = 16 elseif talkState[cid] == 16 then if msgcontains(msg, 'gold') then npcHandler:say("How many platinum coins would you like to change into gold?", cid) talkState[cid] = 17 elseif msgcontains(msg, 'crystal') then npcHandler:say("How many crystal coins would you like to get?", cid) talkState[cid] = 19 else npcHandler:say("Well, can I help you with something else?", cid) talkState[cid] = 0 end elseif talkState[cid] == 17 then if getCount(msg) == -1 or getCount(msg) == 0 then npcHandler:say("Hmm, can I help you with something else?", cid) talkState[cid] = 0 else count[cid] = getCount(msg) npcHandler:say("So you would like me to change " .. count[cid] .. " of your platinum coins into " .. count[cid] * 100 .. " gold coins for you?", cid) talkState[cid] = 18 end elseif talkState[cid] == 18 then if msgcontains(msg, 'yes') then if doPlayerRemoveItem(cid, 2152, count[cid]) then npcHandler:say("Here you are.", cid) doPlayerAddItem(cid, 2148, count[cid] * 100) else npcHandler:say("Sorry, you do not have enough platinum coins.", cid) end else npcHandler:say("Well, can I help you with something else?", cid) end talkState[cid] = 0 elseif talkState[cid] == 19 then if getCount(msg) == -1 or getCount(msg) == 0 then npcHandler:say("Hmm, can I help you with something else?", cid) talkState[cid] = 0 else count[cid] = getCount(msg) npcHandler:say("So you would like me to change " .. count[cid] * 100 .. " of your platinum coins into " .. count[cid] .. " crystal coins for you?", cid) talkState[cid] = 20 end elseif talkState[cid] == 20 then if msgcontains(msg, 'yes') then if doPlayerRemoveItem(cid, 2152, count[cid] * 100) then npcHandler:say("Here you are.", cid) doPlayerAddItem(cid, 2160, count[cid]) else npcHandler:say("Sorry, you do not have enough platinum coins.", cid) end else npcHandler:say("Well, can I help you with something else?", cid) end talkState[cid] = 0 elseif msgcontains(msg, 'cdsadhangedsfsfcdsfdsf crystal') then npcHandler:say("How many crystal coins would you like to change into platinum?", cid) talkState[cid] = 21 elseif talkState[cid] == 21 then if getCount(msg) == -1 or getCount(msg) == 0 then npcHandler:say("Hmm, can I help you with something else?", cid) talkState[cid] = 0 else count[cid] = getCount(msg) npcHandler:say("So you would like me to change " .. count[cid] .. " of your crystal coins into " .. count[cid] * 100 .. " platinum coins for you?", cid) talkState[cid] = 22 end elseif talkState[cid] == 22 then if msgcontains(msg, 'yes') then if doPlayerRemoveItem(cid, 2160, count[cid]) then npcHandler:say("Here you are.", cid) doPlayerAddItem(cid, 2152, count[cid] * 100) else npcHandler:say("Sorry, you do not have enough crystal coins.", cid) end else npcHandler:say("Well, can I help you with something else?", cid) end talkState[cid] = 0 elseif msgcontains(msg, 'changfasfafsafase') then npcHandler:say("There are three different coin types in Tibia: 100 gold coins equal 1 platinum coin, 100 platinum coins equal 1 crystal coin. So if you'd like to change 100 gold into 1 platinum, simply say '{dasdsdadasd gold}' and then '1 platinum'.", cid) talkState[cid] = 0 end return true end npcHandler:setCallback(CALLBACK_GREET, greetCallback) npcHandler:setCallback(CALLBACK_MESSAGE_DEFAULT, creatureSayCallback) npcHandler:addModule(FocusModule:new())

Pode colocar seu bank.lua aqui?? Fica mais facil de identificar o erro...

Aparece algum erro??

Pow cara, parabéns, tb tava procurando há um tempo, e como não achei... Já tinha desistido.

Ok, como pedido, aqui vai um tutorial mais detalhado das configurações da columns. Vou colocar quais "caixinhas" vc deve deixar selecionadas em cada column: Na column id basta selecionar o Data type como INTERGER e marcar a Primary key: Na column player_id basta selecionar o Data type como INTERGER e marcar Not NULL: Na column channel_id basta selecionar o Data type como INTERGER, marcar Not NULL, Default value, e configurar o Default value como está na imagem: Na column text basta selecionar o Data type como VARCHAR, colocar o size como 255 e marcar o Not NULL: Na column date basta selecionar o Data type como INTERGER, marcar Not NULL, Default value, e configurar o Default value como está na imagem: Agora aperte Ok, depois Add e agora Create: Agora encontre a table criada (player_statements), clique nela com o botão direito do mouse, e selecione Edit table: E por fim vamos adicionar a Foreign key. Siga as imagens (AS IMAGENS ESTÃO LITERALMENTE PASSO-A-PASSO) : Clique no + : Aparecerá uma nova linha na parte de Table constraints (do lado do +) : Agora clique na setinha ao lado de onde está escrito Primary key e selecione Foreign key: Agora clique em Configure e abrirá uma nova janelinha: Nela, clique na setinha ao lado da barra de Foreign key e selecione a table players: Agora marque player_id, clique na setinha e selecione id: Agora clique Ok e depois Change. Pronto, agora seu problema está resolvido. Para vc ter certeza de que está tudo certo, novamente clique com o botão direito na table nova (player_statements), clique em Edit table, e clique em DLL. Nessa parte, se tudo está igual à imagem, então está tudo certo mesmo: OBS.: Na parte dos "DEFAULT" não importa se o 0 estiver entre aspas simples ' ou entre parenteses ( . Espero ter ajudado! Se puder dar rep, pra dar aquela força, seria de imensa ajuda. Se ainda persistir algum erro, pode me comunicar! Abraços!