Raking WoT Player

[Scofield]

I have this wot that has the guild ranking that takes more chests ... I wanted to put another ranking of the players who caught ais chests

 

 
 
// ===== SQL ================================
// CREATE TABLE `gdt` (
// `guild_id` int(11) unsigned NOT NULL auto_increment,
// `tesouros` int(11) unsigned NOT NULL default '0',
// `pontos` int(11) unsigned NOT NULL default '0',
//  PRIMARY KEY  (`guild_id`)
// ) TYPE=MyISAM
 
 
// Warps
 
arena_room,99,25,0 warp tesouro1 1,1,prt_are_in,98,23
prt_are_in,97,30,0 warp tesouro2 1,1,arena_room,99,28
prt_are_in,142,13,0 warp tesouro3 1,1,prt_are_in,177,79
prt_are_in,177,74,0 warp tesouro4 1,1,prt_are_in,138,13
prt_are_in,55,13,0 warp tesouro5 1,1,prt_are_in,125,78
prt_are_in,125,74,0 warp tesouro6 1,1,prt_are_in,60,13
arena_room,99,88,0 warp tesouro7 1,1,izlude,128,222
prt_are_in,74,127,0 warp tesouro8 1,1,prt_are_in,98,10
prt_are_in,97,7,0 warp tesouro9 1,1,prt_are_in,74,129
 
 
izlude,128,225,0 script iz431 45,1,1,{
 
if(getcharid(2) == 0){
mes "Desculpe, mas você precisa de um clã para poder entrar na guerra.";
close;
}else{
set @rand, rand(6);
if(@rand == 0) warp "arena_room",120,87;
if(@rand == 1) warp "arena_room",114,102;
if(@rand == 2) warp "arena_room",87,102;
if(@rand == 3) warp "arena_room",79,88;
if(@rand == 4) warp "arena_room",113,74;
if(@rand == 5) warp "arena_room",85,74;
}
end;
}
 
prt_are_in,0,0,0 script TesouroEvent::TesouroKill -1,{
 
 
OnKilled:
Tesouro:
set @check, query_sql("SELECT tesouros,pontos FROM gdt WHERE guild_id='"+getcharid(2)+"' LIMIT 1", @tesouros, @pontos);
set @check_p, query_sql("SELECT charkill,pontokill FROM chargdt WHERE char_idd ='"+getcharid(0)+"' LIMIT 1", @charkill, @pontokill);
if(@check == 1){
set @tesouros, @tesouros + 1;
set @pontos, @pontos + 100;
query_sql("UPDATE gdt SET tesouros = '"+@tesouros+"' WHERE guild_id='"+getcharid(2)+"'");
query_sql("UPDATE gdt SET pontos = '"+@pontos+"' WHERE guild_id='"+getcharid(2)+"'");
if(@check_p == 1){
set @charkill, @charkill + 1;
set @pontokill, @pontokill + 10;
query_sql "SELECT `char_name` FROM `chargdt` WHERE `char_idd`='"+getcharid(0)+"'",@namecheck$;
if(@namecheck$=="0"){
query_sql("UPDATE chargdt SET char_name = '"+strcharinfo(0)+"' WHERE char_idd = '"+getcharid(0)+"'");
}
query_sql("UPDATE chargdt SET charkill = '"+@charkill+"' WHERE char_idd = '"+getcharid(0)+"'");
query_sql("UPDATE chargdt SET pontokill = '"+@pontokill+"' WHERE char_idd = '"+getcharid(0)+"'");
}
if(@check_p == 0){
query_sql("INSERT INTO chargdt (char_idd,charkill,char_name,pontokill) VALUES ('"+getcharid(0)+"','1','"+strcharinfo(0)+"','10')");
}
}else{
query_sql("INSERT INTO gdt (guild_id,tesouros,pontos) VALUES ('"+getcharid(2)+"','1','100')");
if(@check_p == 1){
set @charkill, @charkill + 1;
set @pontokill, @pontokill + 10;
query_sql("UPDATE chargdt SET charkill = '"+@charkill+"' WHERE char_idd = '"+getcharid(0)+"'");
query_sql("UPDATE chargdt SET pontokill = '"+@pontokill+"' WHERE char_idd = '"+getcharid(0)+"'");
}
 
if(@check_p == 0){
query_sql("INSERT INTO chargdt (char_idd,charkill,char_name,pontokill) VALUES ('"+getcharid(0)+"','1','"+strcharinfo(0)+"','10')");
}
 
}
 
announce "Guerra do Tesouro: " +strcharinfo(0)+ " do Clã ["+ getguildname(getcharid(2)) +"] conquistou um dos baús.",0;
end;
 
}
 
 
prt_are_in,0,0,0 script TesouroEvent::TesouroEvent -1,{
 
end;
 
OnHour01:
OnHour03:
OnHour05:
OnHour07:
OnHour09:
OnHour11:
OnHour13:
OnHour15:
OnHour17:
OnHour19:
OnHour21:
OnHour23:
 
announce "Guerra do Tesouro: Os tesouros vão surgir a qualquer momento!",0;
end;
 
OnClock0113:
OnClock0313:
OnClock0513:
OnClock0713:
OnClock0913:
OnClock1113:
OnClock1313:
OnClock1513:
OnClock1713:
OnClock1913:
OnClock2113:
OnClock2313:
 
announce "Guerra do Tesouro: Os tesouros surgirão em 2 minutos!",0;
end;
 
OnClock0115:
OnClock0315:
OnClock0515:
OnClock0715:
OnClock0915:
OnClock1115:
OnClock1315:
OnClock1515:
OnClock1715:
OnClock1915:
OnClock2115:
OnClock2315:
 
killmonsterall "prt_are_in";
 
set $@tesourocount, 1;
 
announce "Guerra do Tesouro: Os tesouros acabaram de surgir!",0;
 
set $@mob, 1324 + rand(13);
monster "prt_are_in",178,88,"Baú do Tesouro",$@mob,1,"TesouroKill::OnKilled";
 
set $@mob, 1338 + rand(12);
monster "prt_are_in",126,88,"Baú do Tesouro",$@mob,1,"TesouroKill::OnKilled";
 
set $@mob, 1352 + rand(11);
monster "prt_are_in",74,141,"Baú do Tesouro",$@mob,1,"TesouroKill::OnKilled";
 
end;
 
 
if(!GetCharID(2)) {
mes "Desculpe, mas você precisa de um clã para poder entrar na guerra.";
close;
}else{
set @rand, rand(6);
if(@rand == 0) warp "arena_room",120,87;
if(@rand == 1) warp "arena_room",114,102;
if(@rand == 2) warp "arena_room",87,102;
if(@rand == 3) warp "arena_room",79,88;
if(@rand == 4) warp "arena_room",113,74;
if(@rand == 5) warp "arena_room",85,74;
}
end;
}
 
prt_are_in,0,0,0 script TesouroEvent::TesouroKill -1,{
 
 
OnKilled:
Tesouro:
set @check, query_sql("SELECT tesouros,pontos FROM gdt WHERE guild_id='"+getcharid(2)+"' LIMIT 1", @tesouros, @pontos);
set @check_p, query_sql("SELECT charkill,pontokill FROM chargdt WHERE char_idd ='"+getcharid(0)+"' LIMIT 1", @charkill, @pontokill);
if(@check == 1){
set @tesouros, @tesouros + 1;
set @pontos, @pontos + 100;
query_sql("UPDATE gdt SET tesouros = '"+@tesouros+"' WHERE guild_id='"+getcharid(2)+"'");
query_sql("UPDATE gdt SET pontos = '"+@pontos+"' WHERE guild_id='"+getcharid(2)+"'");
if(@check_p == 1){
set @charkill, @charkill + 1;
set @pontokill, @pontokill + 10;
query_sql("UPDATE chargdt SET charkill = '"+@charkill+"' WHERE char_idd = '"+getcharid(0)+"'");
query_sql("UPDATE chargdt SET pontokill = '"+@pontokill+"' WHERE char_idd = '"+getcharid(0)+"'");
}
if(@check_p == 0){
query_sql("INSERT INTO chargdt (char_idd,charkill,char_name,pontokill) VALUES ('"+getcharid(0)+"','1','"+strcharinfo(0)+"','10')");
}
}else{
query_sql("INSERT INTO gdt (guild_id,tesouros,pontos) VALUES ('"+getcharid(2)+"','1','100')");
if(@check_p == 1){
set @charkill, @charkill + 1;
set @pontokill, @pontokill + 10;
query_sql("UPDATE chargdt SET charkill = '"+@charkill+"' WHERE char_idd = '"+getcharid(0)+"'");
query_sql("UPDATE chargdt SET pontokill = '"+@pontokill+"' WHERE char_idd = '"+getcharid(0)+"'");
}
 
if(@check_p == 0){
query_sql("INSERT INTO chargdt (char_idd,charkill,char_name,pontokill) VALUES ('"+getcharid(0)+"','1','"+strcharinfo(0)+"','10')");
}
 
}
announce "Guerra do Tesouro: " +strcharinfo(0)+ " do Clã ["+ getguildname(getcharid(2)) +"] conquistou um dos baús.",0;
end;
 
}
 
 
prt_are_in,0,0,0 script TesouroEvent::TesouroEvent -1,{
 
end;
 
OnClock1300:
OnClock1500:
OnClock1700:
OnClock1900:
OnClock2100:
OnClock2300:
OnClock0100:
OnClock0300:
OnClock0500:
OnClock0700:
OnClock0900:
OnClock1100:
 
announce "Guerra do Tesouro: Os tesouros surgirão a qualquer momento!",0;
end;
 
OnHour1313:
OnHour1513:
OnHour1713:
OnHour1913:
OnHour2113:
OnHour2313:
OnHour0113:
OnHour0313:
OnHour0513:
OnHour0713:
OnHour0913:
OnHour1113:
 
announce "Guerra do Tesouro: Os tesouros surgirão em 2 minutos!",0;
end;
 
OnHour1315:
OnHour1515:
OnHour1715:
OnHour1915:
OnHour2115:
OnHour2315:
OnHour0115:
OnHour0315:
OnHour0515:
OnHour0715:
OnHour0915:
OnHour1115:
 
killmonsterall "prt_are_in";
 
set $@tesourocount, 1;
 
announce "Guerra do Tesouro: Os tesouros acabaram de surgir!",0;
 
set $@mob, 1324 + rand(13);
monster "prt_are_in",178,88,"Baú do Tesouro",$@mob,1,"TesouroKill::OnKilled";
 
set $@mob, 1338 + rand(12);
monster "prt_are_in",126,88,"Baú do Tesouro",$@mob,1,"TesouroKill::OnKilled";
 
set $@mob, 1352 + rand(11);
monster "prt_are_in",74,141,"Baú do Tesouro",$@mob,1,"TesouroKill::OnKilled";
 
end;
 
}