Search results

how did you solve it?

amazing job, he did exactly what I asked for and better than I expected even the guy's a best !

hmm now that you mentioned it.. maybe a sea with pointi stones? and there are also some shark things you can place on the water available on RME so it could be a hard to get island with a sinked ship @Udun

I want an 8.6 hunt with acid, as dark as you can make it :p make it big like a hunt where some 5 people could hunt with fast spawn monsters

server has been reseted yesterday, now is the best time to come in new players gain 2 days of donate access for free once they reach their first reset

this query is just showing the number of players in each guild that have more than 1 frag, can anyone help? SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, COUNT(`g`.`name`) as `frags` FROM `players` p LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id` LEFT JOIN `guilds` g ON...

when I remove the where is shows this I think that it is showing the ammount of member of that guild instead of the frags? dunno the query is clearly missing something tho

yep, still shows only 1 frag even tho players have like 8 each since you said this solved for you, can you share the query you're using with me?

yes I did and I'm executing this query on phpmyadmin

same stuff :/

I got to this query SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, COUNT(`g`.`name`) as `frags` FROM `players` p LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id` LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id` WHERE `p`.`frags_all` > 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC...

bump?

I'm using [Znote AAC] Most powerful guilds (TFS 0.3/4 and 1.0) (https://otland.net/threads/znote-aac-most-powerful-guilds-tfs-0-3-4-and-1-0.209045/) (no table design) and tfs 0.4 the select query is SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, COUNT(`g`.`name`) as `frags` FROM `killers` k...

I'm using tfs 0.4 rev 3777 (Fir3element/3777 (https://github.com/Fir3element/3777)) and I'd like to know how I can make it so a player gets extra hp and health based on a storage value for example: Knights gain 5 mana and 20 health per level (just like in vocations.xml) if the storage value is...

yeah I know it's hard to judge someone even when you know them but the owner of Utorion is someone that has contributed a LOT for the community, the guy knows a shit ton of tibia and has an amazing team by the looks of things, he's successful because he's a smart, hard working guy. I actually...

I'm kinda interested now do you know how to make it for 0.4 moustafa?

xikini's answer help me in what I want to do and the whole talk here also teached me some stuff :P thank yall

did anyone create a pr on the tfs github with this? if not, please

cause I have a project is 0.x, converting everything to 1.3 rn when it is running could cause a lot of trouble Shadow_ that would lead me to the exact problem I listed, I would be able to check if the player is using x weapon but I wouldn't be able to verify if the damage he's dealing right now...

I can actually think of some ways to make life steal work, you just need some creativity and inspiration (by that I mean there's x script that makes y and based on that you can create z)