gmstrikker

Gesior.pl fixou essa lib, o que vcs precisam mudar é: --- Trocar o trigger pra: [code] DELIMITER $$ CREATE TRIGGER guilds_update BEFORE UPDATE ON players FOR EACH ROW BEGIN IF old.rank_id <> new.rank_id THEN SET new.guild_id = COALESCE((SELECT guild_id FROM guild_ranks WHERE id = new.rank_id), 0); END IF; END$$ DELIMITER ; [/code] --- Trocar: [code] UPDATE guilds SET points = (1 + (SELECT points FROM guilds WHERE id = 2)) WHERE id = 2 UPDATE guilds SET balance = (SELECT balance FROM guilds WHERE `id` = 2) + 150000 WHERE `id` = 2 [/code] Pra: [code] UPDATE guilds SET points = points + 1 WHERE id = 2 UPDATE guilds SET balance = balance + 150000 WHERE `id` = 2 [/code]

Alguém tem alguma ideia de como colocar isso pra rodar? isso seria da hora pra maioria dos servidores...

1) usando o primeiro comando: CREATE TRIGGER `rank_id update` AFTER UPDATE OF rank_id ON players BEGIN UPDATE players SET guild_id = IFNULL((SELECT guild_id FROM guild_ranks WHERE `id` = rank_id), 0); Error SQL query: CREATE TRIGGER `rank_id update` AFTER UPDATE OF rank_id ON players BEGIN UPDATE players SET guild_id = IFNULL((SELECT guild_id FROM guild_ranks WHERE `id` = rank_id), 0) MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'OF rank_id ON players BEGIN UPDATE players SET guild_id = IFNULL((SELECT guild_i' at line 1 2) usando o segundo comando: Usando o segundo deu um erro que parece que a "entidade" rank_id já está criada ALTER TABLE `players` ADD `rank_id` VARCHAR(20); erro: Error SQL query: ALTER TABLE `players` ADD `rank_id` VARCHAR(20) MySQL said: #1060 - Duplicate column name 'rank_id'

Caramba dei UP mais de 10 dias e nenhuma resposta, esse fórum morreu mesmo, que triste

Tem um sistema aqui no fórum magnifico que deveria ter em todos os OTs, é sobre tasks pra guildas, imaginem a interatividade que isso proporciona pra um servidor... Mas eu vi que muita gente está com esse erro na hora de instalar igual ao meu e ninguem conseguiu ajudar, será que algum membro novo consegue salvar a gente? O sistema é esse aqui: O erro acontece na hora de executar a talkaction /agsinstall que vem dentro do sistema e eu postei o código acima <talkaction words="/agsinstall" access="5" event="script" value="advanced_guild_system_install.lua"/> function onSay(cid, words, param) installAdvancedGuildSystem() end que usa a função de ot/libs/guildlib.lua [5:30:59.549] mysql_real_query(): SELECT points FROM guilds; - MYSQL ERROR: Unknown column 'points' in 'field list' (1054) [5:31:01.692] mysql_real_query(): CREATE TRIGGER [`rank_id update`] AFTER UPDATE OF rank_id ON players BEGIN UPDATE players SET guild_id = IFNULL((SELECT guild_id FROM guild_ranks WHERE `id` = rank_id), 0); END; - MYSQL ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '[`rank_id update`] AFTER UPDATE OF rank_id ON players BEGIN UPDATE players SET g' at line 1 (1064) Advanced Guild System could NOT be installed.

Tentei aqui e não funcionou, gostaria mt de usar esse sistema Quando eu uso o talkaction pra instalar o sistema: <talkaction words="/agsinstall" access="5" event="script" value="advanced_guild_system_install.lua"/> /agsinstall [5:30:59.549] mysql_real_query(): SELECT points FROM guilds; - MYSQL ERROR: Unknown column 'points' in 'field list' (1054) [5:31:01.692] mysql_real_query(): CREATE TRIGGER [`rank_id update`] AFTER UPDATE OF rank_id ON players BEGIN UPDATE players SET guild_id = IFNULL((SELECT guild_id FROM guild_ranks WHERE `id` = rank_id), 0); END; - MYSQL ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '[`rank_id update`] AFTER UPDATE OF rank_id ON players BEGIN UPDATE players SET g' at line 1 (1064) Advanced Guild System could NOT be installed.

Coloquei a virgula no final do último, tentei colocar todos os monstros com letras minusculas, como no script padrão e nada mudou 00:43 Arthur The Guild Tasker: I have the following tasks for your guild: . Which one do you want?

Encontrei aqui nesse fórum esse sistema incrivel de guild task, onde uma guild tem uma task para matar certos monstros e depois ganham uma recompensa. O problema é que configurei minha lista de monstros da task, mas quando falo com o NPC ele não entrega nenhuma task, acho que fiz alguma coisa errado... Sistema full: Fala com NPC: 10:45 Arthur: Strikker, would you like to get some tasks? 10:45 Strikker [20]: tasks 10:45 Arthur: Do you want to start a task, reset a task, finish your task, check your guild's progress or information about guild tasks? 10:46 Strikker [20]: start 10:46 Arthur: I have the following tasks for your guild: . Which one do you want? lib/guildtask_lib.lua -- Storages GT = { kills = 51, totalKills = 52, task = 53, time = 54, -- Customization starts here -- Monsters monsters = { {names = {"Troll"}, totalKills = 2000, money = 600000, points = 1, minPoints = 0}, {names = {"Rotworm"}, totalKills = 2000, money = 600000, points = 1, minPoints = 1}, {names = {"Goblin"}, totalKills = 2000, money = 600000, points = 1, minPoints = 2}, {names = {"Dwarf"}, totalKills = 2000, money = 600000, points = 1, minPoints = 3}, {names = {"Amazon"}, totalKills = 2000, money = 600000, points = 1, minPoints = 4}, {names = {"Carrion Worm"}, totalKills = 2000, money = 600000, points = 1, minPoints = 5}, {names = {"Valkyrie"}, totalKills = 2000, money = 600000, points = 1, minPoints = 6}, {names = {"Skeleton"}, totalKills = 2000, money = 600000, points = 1, minPoints = 7}, {names = {"Minotaur"}, totalKills = 2000, money = 600000, points = 1, minPoints = 8}, {names = {"Ghoul"}, totalKills = 2000, money = 600000, points = 1, minPoints = 9}, {names = {"Elf"}, totalKills = 2000, money = 600000, points = 1, minPoints = 10}, {names = {"Dwarf Soldier"}, totalKills = 2000, money = 600000, points = 1, minPoints = 11}, {names = {"Tarantula"}, totalKills = 2000, money = 600000, points = 1, minPoints = 12}, {names = {"Cyclops"}, totalKills = 2000, money = 600000, points = 1, minPoints = 13}, {names = {"Larva"}, totalKills = 2000, money = 600000, points = 1, minPoints = 14}, {names = {"Nomad"}, totalKills = 2000, money = 600000, points = 1, minPoints = 15}, {names = {"Tortoise"}, totalKills = 2000, money = 600000, points = 1, minPoints = 16}, {names = {"Terramite"}, totalKills = 2000, money = 600000, points = 1, minPoints = 17}, {names = {"Crocodile"}, totalKills = 2000, money = 600000, points = 1, minPoints = 18}, {names = {"Scarab"}, totalKills = 40000, money = 800000, points = 1, minPoints = 19}, {names = {"Kongra"}, totalKills = 40000, money = 800000, points = 1, minPoints = 20}, {names = {"Sibang"}, totalKills = 40000, money = 800000, points = 1, minPoints = 21}, {names = {"Mammoth"}, totalKills = 40000, money = 800000, points = 1, minPoints = 22}, {names = {"Cyclops Drone"}, totalKills = 40000, money = 800000, points = 1, minPoints = 23}, {names = {"Cyclops Smith"}, totalKills = 40000, money = 800000, points = 1, minPoints = 24}, {names = {"Demon Skeleton"}, totalKills = 40000, money = 800000, points = 1, minPoints = 25}, {names = {"Wyvern"}, totalKills = 40000, money = 800000, points = 1, minPoints = 26}, {names = {"Vampire"}, totalKills = 40000, money = 800000, points = 1, minPoints = 27}, {names = {"Zombie"}, totalKills = 40000, money = 800000, points = 1, minPoints = 28}, {names = {"Mutated Rat"}, totalKills = 40000, money = 30000, points = 1, minPoints = 29}, {names = {"Dwarf Guard"}, totalKills = 40000, money = 800000, points = 1, minPoints = 30}, {names = {"Dragon"}, totalKills = 40000, money = 800000, points = 1, minPoints = 31}, {names = {"Ice Witch"}, totalKills = 40000, money = 800000, points = 1, minPoints = 32}, {names = {"Frost Giantess"}, totalKills = 40000, money = 800000, points = 1, minPoints = 33}, {names = {"Ice Golem"}, totalKills = 40000, money = 800000, points = 1, minPoints = 34}, {names = {"Stone Golem"}, totalKills = 40000, money = 800000, points = 1, minPoints = 35}, {names = {"Giant Spider"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 36}, {names = {"Dragon Lord"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 37}, {names = {"Frost Dragon"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 38}, {names = {"Wyrm"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 39}, {names = {"Hydra"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 40}, {names = {"Warlock"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 41}, {names = {"Slick Water Elemental"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 42}, {names = {"Water Elemental"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 43}, {names = {"Earth Elemental"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 44}, {names = {"Crystal Spider"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 45}, {names = {"Black Knight"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 46}, {names = {"Hero"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 47}, {names = {"Demon"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 48}, {names = {"Serpent Spawn"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 49}, {names = {"Werewolf"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 50}, {names = {"Destroyer"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 51}, {names = {"Mutated Tiger"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 52}, {names = {"Grim Reaper"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 53}, {names = {"Juggernaut"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 54}, {names = {"Hand of Cursed Fate"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 55} }, -- Other variables waitTime = 1440, -- Tempo de espera para começar outra task após entregar uma } -- Customization ends here function doResetGuildTask(guild_id, resetTime) for _, stgkey in ipairs({GT.kills, GT.totalKills, GT.task, GT.time}) do setGuildStorageValue(guild_id, stgkey, 0) end if resetTime then setGuildStorageValue(guild_id, GT.time, os.time() + GT.waitTime * 60) end return true end function doStartGuildTask(guild_id, task) local taskInfo = GT.monsters[task] setGuildStorageValue(guild_id, GT.totalKills, taskInfo.totalKills) setGuildStorageValue(guild_id, GT.task, task) setGuildStorageValue(guild_id, GT.kills, 0) return true end function getGuildTaskWaitTime(guild) local nextTime = getGuildStorageValue(guild, GT.time) if nextTime > os.time() then return nextTime - os.time() else return 0 end end function doCompleteGuildTask(guild_id) local taskInfo = GT.monsters[getGuildStorageValue(guild_id, GT.task)] doGuildAddPoints(guild_id, taskInfo.points) doGuildAddBalance(guild_id, taskInfo.money) doResetGuildTask(guild_id, true) return true end O que eu fiz de errado?

up

Quando eu tento pegar uma task: 10:45 Arthur: Strikker, would you like to get some tasks? 10:45 Strikker [20]: tasks 10:45 Arthur: Do you want to start a task, reset a task, finish your task, check your guild's progress or information about guild tasks? 10:46 Strikker [20]: start 10:46 Arthur: I have the following tasks for your guild: . Which one do you want? guildtask_lib.lua -- Storages GT = { kills = 51, totalKills = 52, task = 53, time = 54, -- Customization starts here -- Monsters monsters = { {names = {"Troll"}, totalKills = 2000, money = 600000, points = 1, minPoints = 0}, {names = {"Rotworm"}, totalKills = 2000, money = 600000, points = 1, minPoints = 1}, {names = {"Goblin"}, totalKills = 2000, money = 600000, points = 1, minPoints = 2}, {names = {"Dwarf"}, totalKills = 2000, money = 600000, points = 1, minPoints = 3}, {names = {"Amazon"}, totalKills = 2000, money = 600000, points = 1, minPoints = 4}, {names = {"Carrion Worm"}, totalKills = 2000, money = 600000, points = 1, minPoints = 5}, {names = {"Valkyrie"}, totalKills = 2000, money = 600000, points = 1, minPoints = 6}, {names = {"Skeleton"}, totalKills = 2000, money = 600000, points = 1, minPoints = 7}, {names = {"Minotaur"}, totalKills = 2000, money = 600000, points = 1, minPoints = 8}, {names = {"Ghoul"}, totalKills = 2000, money = 600000, points = 1, minPoints = 9}, {names = {"Elf"}, totalKills = 2000, money = 600000, points = 1, minPoints = 10}, {names = {"Dwarf Soldier"}, totalKills = 2000, money = 600000, points = 1, minPoints = 11}, {names = {"Tarantula"}, totalKills = 2000, money = 600000, points = 1, minPoints = 12}, {names = {"Cyclops"}, totalKills = 2000, money = 600000, points = 1, minPoints = 13}, {names = {"Larva"}, totalKills = 2000, money = 600000, points = 1, minPoints = 14}, {names = {"Nomad"}, totalKills = 2000, money = 600000, points = 1, minPoints = 15}, {names = {"Tortoise"}, totalKills = 2000, money = 600000, points = 1, minPoints = 16}, {names = {"Terramite"}, totalKills = 2000, money = 600000, points = 1, minPoints = 17}, {names = {"Crocodile"}, totalKills = 2000, money = 600000, points = 1, minPoints = 18}, {names = {"Scarab"}, totalKills = 40000, money = 800000, points = 1, minPoints = 19}, {names = {"Kongra"}, totalKills = 40000, money = 800000, points = 1, minPoints = 20}, {names = {"Sibang"}, totalKills = 40000, money = 800000, points = 1, minPoints = 21}, {names = {"Mammoth"}, totalKills = 40000, money = 800000, points = 1, minPoints = 22}, {names = {"Cyclops Drone"}, totalKills = 40000, money = 800000, points = 1, minPoints = 23}, {names = {"Cyclops Smith"}, totalKills = 40000, money = 800000, points = 1, minPoints = 24}, {names = {"Demon Skeleton"}, totalKills = 40000, money = 800000, points = 1, minPoints = 25}, {names = {"Wyvern"}, totalKills = 40000, money = 800000, points = 1, minPoints = 26}, {names = {"Vampire"}, totalKills = 40000, money = 800000, points = 1, minPoints = 27}, {names = {"Zombie"}, totalKills = 40000, money = 800000, points = 1, minPoints = 28}, {names = {"Mutated Rat"}, totalKills = 40000, money = 30000, points = 1, minPoints = 29}, {names = {"Dwarf Guard"}, totalKills = 40000, money = 800000, points = 1, minPoints = 30}, {names = {"Dragon"}, totalKills = 40000, money = 800000, points = 1, minPoints = 31}, {names = {"Ice Witch"}, totalKills = 40000, money = 800000, points = 1, minPoints = 32}, {names = {"Frost Giantess"}, totalKills = 40000, money = 800000, points = 1, minPoints = 33}, {names = {"Ice Golem"}, totalKills = 40000, money = 800000, points = 1, minPoints = 34}, {names = {"Stone Golem"}, totalKills = 40000, money = 800000, points = 1, minPoints = 35}, {names = {"Giant Spider"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 36}, {names = {"Dragon Lord"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 37}, {names = {"Frost Dragon"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 38}, {names = {"Wyrm"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 39}, {names = {"Hydra"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 40}, {names = {"Warlock"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 41}, {names = {"Slick Water Elemental"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 42}, {names = {"Water Elemental"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 43}, {names = {"Earth Elemental"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 44}, {names = {"Crystal Spider"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 45}, {names = {"Black Knight"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 46}, {names = {"Hero"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 47}, {names = {"Demon"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 48}, {names = {"Serpent Spawn"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 49}, {names = {"Werewolf"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 50}, {names = {"Destroyer"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 51}, {names = {"Mutated Tiger"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 52}, {names = {"Grim Reaper"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 53}, {names = {"Juggernaut"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 54}, {names = {"Hand of Cursed Fate"}, totalKills = 60000, money = 1200000, points = 1, minPoints = 55} }, -- Other variables waitTime = 1440, -- Tempo de espera para começar outra task após entregar uma } -- Customization ends here function doResetGuildTask(guild_id, resetTime) for _, stgkey in ipairs({GT.kills, GT.totalKills, GT.task, GT.time}) do setGuildStorageValue(guild_id, stgkey, 0) end if resetTime then setGuildStorageValue(guild_id, GT.time, os.time() + GT.waitTime * 60) end return true end function doStartGuildTask(guild_id, task) local taskInfo = GT.monsters[task] setGuildStorageValue(guild_id, GT.totalKills, taskInfo.totalKills) setGuildStorageValue(guild_id, GT.task, task) setGuildStorageValue(guild_id, GT.kills, 0) return true end function getGuildTaskWaitTime(guild) local nextTime = getGuildStorageValue(guild, GT.time) if nextTime > os.time() then return nextTime - os.time() else return 0 end end function doCompleteGuildTask(guild_id) local taskInfo = GT.monsters[getGuildStorageValue(guild_id, GT.task)] doGuildAddPoints(guild_id, taskInfo.points) doGuildAddBalance(guild_id, taskInfo.money) doResetGuildTask(guild_id, true) return true end

upppppppppppp

Então, tive uma ideia, mas não faço por falta de habilidade, seria legal se tivesse aqui no fórum pra todo mundo usar seria MUITO útil para todos Dez de quem tem um OT mapa global à quem tem um OT mapa proprio... Um remake de okolnir só que sem gelo, mas pra uma area de Dragons e DLs como é darashia, isso seria util de mais, pq cave de dragon e dl em ot cheio é um inferno, todo mundo quer upar nesses monstrinhos

Já usou elfbot? Quando você no X ou aperta shift+f12 ele some o menu E fica de alguma forma dentro do client do tibia aparentemente Ai vc aperta shift+f12 ele volta novamente, tem outra função q é a shift+f11 que da luz pro jogo do elfbot também Só essas duas coisas não estão funcionando... Ficar jogando com o elfbot na frente do client atrapalha, só precisava arrumar isso Não sei oq é bind de hotkeys, nem shell, nada, comecei a usar linux faz pouco tempo

Saquei, mas deve ter alguma gambiarra, algum jeito de arrumar isso... O foda é achar sem saber oq pesquisar

Antes de formatar eu tinha tentado, formatei pra ver se era normal, e continua sem funcionar O estranho é que se eu coloco uma hotkey no shift+f12 ela funciona (no caso do tibia, mas não abre o elfbot) Tem alguma ideia do que pode ser? comecei a usar linux faz pouco tempo, o unico problema q eu tive q não consigo arrumar é esse