• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[REQUEST] animatedtext top guild script

Matheuuss

New Member
Joined
Nov 20, 2018
Messages
25
Reaction score
0
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:
25008-46ee056bf695b054d8361027252f8ea9.png
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:
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
 

Similar threads

Back
Top