· 7 years ago · Sep 15, 2018, 08:00 PM
1/*
2CREATE TABLE IF NOT EXISTS `rwoe` (
3 `guild_id` mediumint(6) NOT NULL DEFAULT '0',
4 `kills` smallint(11) NOT NULL DEFAULT '0',
5 `deaths` smallint(11) NOT NULL DEFAULT '0',
6 `kd` smallint(11) NOT NULL DEFAULT '0',
7 UNIQUE KEY `guild_id` (`guild_id`)
8) ENGINE=MyISAM DEFAULT CHARSET=latin1;
9
10CREATE TABLE IF NOT EXISTS `rwoep` (
11 `name` varchar(30) NOT NULL DEFAULT '',
12 `kills` smallint(11) NOT NULL DEFAULT '0',
13 `deaths` smallint(11) NOT NULL DEFAULT '0',
14 `kd` smallint(11) NOT NULL DEFAULT '0',
15 UNIQUE KEY `name` (`name`)
16) ENGINE=MyISAM DEFAULT CHARSET=latin1;
17*/
18- script rguildg -1,{
19
20 if(gettime(DT_DAYOFMONTH) == 1){
21 query_sql "TRUNCATE TABLE rwoe";
22 end;
23 }
24
25 OnPCKillEvent:
26 if(agitcheck() == false) end;
27 for( .@c = 1; .@c<getarraysize(.wcastle$); .@c++ )
28 if(strcharinfo(3) != .wcastle$) end;
29 if (!getcharid(2) || killedrid==getcharid(0)) end;
30 set .@castles$, strcharinfo(3);
31 set @GID,getcharid(2);
32 mapannounce .@castles$,"O jogador [ "+strcharinfo(0)+" ] da Guild [ "+getguildname(@GID)+" ] derrotou: [ "+rid2name(killedrid)+" ].",8;
33 query_sql "INSERT INTO `rwoe` (`guild_id`,`kills`) VALUES ("+getcharid(2)+",1) ON DUPLICATE KEY UPDATE `kills`=`kills`+1 ";
34 query_sql "INSERT INTO `rwoep` (`name`,`kills`) VALUES ('"+strcharinfo(0)+"',1) ON DUPLICATE KEY UPDATE `kills`=`kills`+1 ";
35 end;
36
37 OnPCDieEvent:
38 if(agitcheck() == false) end;
39 for( .@c = 1; .@c<getarraysize(.wcastle$); .@c++ )
40 if(strcharinfo(3) != .wcastle$) end;
41 if (!getcharid(2) || killedrid==getcharid(0)) end;
42 query_sql "INSERT INTO `rwoe` (`guild_id`,`deaths`) VALUES ("+getcharid(2)+",1) ON DUPLICATE KEY UPDATE `deaths`=`deaths`+1 ";
43 query_sql "INSERT INTO `rwoep` (`name`,`deaths`) VALUES ('"+strcharinfo(0)+"',1) ON DUPLICATE KEY UPDATE `deaths`=`deaths`+1";
44 end;
45
46
47 OnInit:
48 setarray .wcastle$[0],
49 "prtg_cas01","prtg_cas02","prtg_cas03","prtg_cas04","prtg_cas05",
50 "payg_cas01","payg_cas02","payg_cas03","payg_cas04","payg_cas05",
51 "gefg_cas01","gefg_cas02","gefg_cas03","gefg_cas04","gefg_cas05",
52 "aldeg_cas01","aldeg_cas02","aldeg_cas03","aldeg_cas04","aldeg_cas05",
53 "arug_cas01","arug_cas02","arug_cas03","arug_cas04","arug_cas05",
54 "schg_cas01","schg_cas02","schg_cas03","schg_cas04","schg_cas05";
55 end;
56}
57prontera,151,179,6 script Rank 903,{
58
59 menu "[+] TOP 3 Guildas",R_G,"[+] TOP 10 Player",R_PW;
60
61 R_G:
62 query_sql "UPDATE `rwoe` SET `kd`= (`kills`-`deaths`) WHERE `rwoe`.`guild_id` >=1";
63 query_sql "SELECT `guild_id`,`kills`,`deaths`,`kd` FROM `rwoe` ORDER BY `kd` DESC LIMIT 3",.@guild_id,.@kills,.@deaths,.@kd;
64 for (.@i=0; .@i<getarraysize(.@guild_id); .@i++) {
65 mes "[Ranking Guildas - TOP "+(.@i+1)+" ]";
66 mes "Guild: ^0000FF"+getguildname(.@guild_id[.@i])+"^000000";
67 mes "LÃder: ^0000FF"+getguildmaster(.@guild_id[.@i])+"^000000";
68 mes "^00FF00Abates:^000000 "+.@kills[.@i];
69 mes "^FF0000Mortes:^000000 "+.@deaths[.@i];
70 mes "Aproveitamento: "+.@kd[.@i];
71 next;
72 }
73 if (!getarraysize(.@guild_id) || .@guild_id==0) {
74 mes "[Ranking Guildas]";
75 mes "Não tem TOP Guildas no momento.";
76 close;
77 end;
78 }
79 close;
80 end;
81 R_PW:
82 query_sql "SELECT `name`,`kills`,`deaths`,`kd` FROM `rwoep` ORDER BY `kills` DESC LIMIT 5",.@name,.@killsp,.@deathsp,.@kdp;
83 if (!getarraysize(.@name) || .@name==0) {
84 mes "[Ranking Players]";
85 mes "Não tem TOP Players no momento.";
86 close;
87 end;
88 }
89 for (.@i=0; .@i<getarraysize(.@name); .@i++) {
90 mes "[Ranking Players - TOP 10 ]";
91 mes (.@i+1)+"- "+.@name[.@i]+" -"+.@killsp;
92 }
93 close;
94 end;
95 }