KbuC2DsD

1//========================== SQL =========================================================
2
3DROP TABLE IF EXISTS `pvp`;
4CREATE TABLE `pvp` (
5  `char_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
6  `name` varchar(255) NOT NULL DEFAULT '0',
7  `class` int(11) UNSIGNED NOT NULL DEFAULT '0',
8  `kills` int(11) UNSIGNED NOT NULL DEFAULT '0',
9  `deaths` int(11) UNSIGNED NOT NULL DEFAULT '0',
10  KEY `char_id` (`char_id`),
11  KEY `kills` (`kills`),
12  KEY `deaths` (`deaths`)
13) ENGINE=MyISAM;
14
15//========================== Mostra Ranking ===============================================
16
17dispbottom "======= Ranking PvP =======";
18.@nba = query_sql( "select name, class, kills, deaths FROM pvp ORDER BY kills DESC LIMIT 10", @name$, @class$, @kills, @deaths );
19if ( !.@nba ) {
20dispbottom "O Ranking está vazio.";
21close;
22end;
23}
24for ( .@i = 0; .@i < .@nba; .@i++ ){
25dispbottom ""+(.@i+1)+"º | "+@name$[.@i]+" | Matou: "+@kills[.@i]+" | Morreu: "+@deaths[.@i]+" | Classe: "+jobname(atoi(@class$[.@i]))+"";
26}