Galera I would like a script that every 10s exebisse an animated text in the character that is in a guild that has more kills in sv. That is, top guild. The one that appears on the Modern website acc on the Top guild tab.
It would look like this:
She was going to appear rising and gone, after she appeared again. In all the characters you are in the top guild.
If necessary, my site executes this query to determine the top guild:
PS: use TFS 0.4 rev 3884, 8.6
It would look like this:
She was going to appear rising and gone, after she appeared again. In all the characters you are in the top guild.
If necessary, my site executes this query to determine the top guild:
PHP:
SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
COUNT(`g`.`name`) as `frags`
FROM `killers` k
LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id`
LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id`
LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id`
LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id`
WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1
GROUP BY `name`
ORDER BY `frags` DESC, `name` ASC
LIMIT 0, 4;
PS: use TFS 0.4 rev 3884, 8.6