Jump to content

Question

2 answers to this question

Recommended Posts

  • 0
Posted (edited)

Well i dont know if is working, i hve found it in brAthena, so you can test it:

SQL addons:

ALTER TABLE `guild` ADD `pontos` INT(11) NOT NULL DEFAULT '0';

​BTW is in Portuguese

//====Changelog:
//====Script criador por Pixel 
//====Adicionado comandos adicionais por Duka
//====Adicionado tabela SQL na tabela guild por Duka
//====Adicionado npc Saída e Entrada por Duka
//====Adicionado barricadas , Rank por Duka
//==================TREASURE WAR============================

prontera,0,0,0	script	War of Treasure	-1,{


OnClock0950:
OnClock1350: 
OnClock1550:
OnClock1750:
OnClock1950:
OnClock2150:
OnClock2350:
initnpctimer;
announce "[Guerra do Tesouro] Os Báus surgirão em 10 minutos !",bc_all,0xADD8E6;
set .morto,0;
setcell "arena",140,140,160,160,cell_walkable,1;
setcell "arena",140,140,160,160,cell_walkable,1;

end;

OnTimer15000:
announce "[Guerra do Tesouro] Portal para salas dos Baús ao Norte de Izlude ! Corra",bc_all,0xADD8E6;
end;

OnTimer300000:
announce "[Guerra do Tesouro] Apressem-se os Báus aparecerão em 5 minutos !",bc_all,0xADD8E6;
disablenpc "exit";
end;

OnTimer540000:
announce "[Guerra do Tesouro] Em 1 minutos os Báus do Tesouro surgirão , apressem-se !",bc_all,0xADD8E6;
stopnpctimer;
end;

OnClock1000:
OnClock1400:
OnClock1600:
OnClock1800:
OnClock2000:
OnClock2200:
OnClock0000:
set .@bau,1324;  //id Bau da Wot
announce "[Guerra do Tesouro] Os Báus do tesouro apareceram !",bc_all,0xADD8E6;
monster "prt_are_in",178,140,"Bau do Tesouro",.@bau,1,"War of Treasure::OnThisMobDeath"; 
monster "prt_are_in",22,89,"Bau do Tesouro",.@bau,1,"War of Treasure::OnThisMobDeath";
end;


OnThisMobDeath:
set .morto,.morto+1;
announce "[Guerra do Tesouro] O Jogador "+strcharinfo(0)+" do clã "+strcharinfo(2)+" acaba de destruir um dos Baús!",bc_all,0xADD8E6;
Query_sql "UPDATE `guild` SET `pontos`=`pontos`+1 WHERE `guild_id`='"+getcharid(2)+"'";
if (.morto == 2) {
enablenpc "exit#tw";
}
end;
}



//Muros
prt_are_in,105,21,3,3	monster	Muro	1905,1,30,60,"War of Treasure::OnInit";
prt_are_in,92,23,5,5	monster	Muro	1905,1,30,60,"War of Treasure::OnInit";
prt_are_in,87,12,2,2	monster	Muro	1905,1,30,60,"War of Treasure::OnInit";
prt_are_in,107,12,4,4	monster	Muro	1905,1,30,60,"War of Treasure::OnInit";
prt_are_in,100,16,6,6	monster	Muro	1905,1,30,60,"War of Treasure::OnInit";
prt_are_in,97,19,3,3	monster	Muro	1905,1,30,60,"War of Treasure::OnInit";


//Portais
//izlude,128,225,0	warp	War Of Treasure1	1,1,arena_room,100,25
prt_are_in,55,13,0	warp	War Of Treasure#1	1,1,prt_are_in,177,129
prt_are_in,177,127,0	warp	War Of Treasure#2	1,1,prt_are_in,57,13
prt_are_in,21,75,0	warp	War Of Treasure#3	1,1,prt_are_in,140,13
prt_are_in,142,13,0	warp	War Of Treasure#4	1,1,prt_are_in,21,77
arena_room,76,87	warp	WarOfTreasure#5	1,1,prt_are_in,97,30


izlude,128,225,1	script	entrada	45,2,2,{ 
OnTouch:
if (getcharid(2) > 0 ) {
warp "arena_room",100,25;
end;
}
else {
mes "^FF0000 Você precisa estar em um Clã para participar desse evento. ^000000";
close; }
end;
}

prt_are_in,97,6,1	script	exit#tw	45,2,2,{
OnTouch:
warp "izlude",128,113;
end;
}

arena_room	mapflag	gvg
arena_room	mapflag	nowarp
arena_room	mapflag	nowarpto
arena_room	mapflag	noreturn
prt_are_in	mapflag	gvg
prt_are_in	mapflag	nowarp
prt_are_in	mapflag	nowarpto
prt_are_in	mapflag	noreturn


izlude,132,220,4	script	Guerra do Tesouro	857,{

mes "^3366FF[Rank Guerra do Tesouro]^000000";
mes "^999999Posição^000000  : ^339966Guild ^000000: ^000080Pontos^000000";
for(set .@i,0; .@i < 10; set .@i,.@i+1){
query_sql "select `name`,`pontos` from `guild` where `pontos` > 0 ORDER BY `pontos` DESC LIMIT 20",.@n$,.@p;
mes "^999999"+(.@i+1)+"^000000 : ^339966"+.@n$[.@i]+"^000000 : ^000080"+.@p[.@i]+"^000000";
if(.@p == 0) break;
}
close;
}

Hope is useful for you n.n.

Regards.​

Edited by Helly
  • Upvote 1
  • 0
Posted

Well i dont know if is working, i hve found it in brAthena, so you can test it:

SQL addons:

ALTER TABLE `guild` ADD `pontos` INT(11) NOT NULL DEFAULT '0';

​BTW is in Portuguese

//====Changelog:
//====Script criador por Pixel 
//====Adicionado comandos adicionais por Duka
//====Adicionado tabela SQL na tabela guild por Duka
//====Adicionado npc Saída e Entrada por Duka
//====Adicionado barricadas , Rank por Duka
//==================TREASURE WAR============================

prontera,0,0,0	script	War of Treasure	-1,{


OnClock0950:
OnClock1350: 
OnClock1550:
OnClock1750:
OnClock1950:
OnClock2150:
OnClock2350:
initnpctimer;
announce "[Guerra do Tesouro] Os Báus surgirão em 10 minutos !",bc_all,0xADD8E6;
set .morto,0;
setcell "arena",140,140,160,160,cell_walkable,1;
setcell "arena",140,140,160,160,cell_walkable,1;

end;

OnTimer15000:
announce "[Guerra do Tesouro] Portal para salas dos Baús ao Norte de Izlude ! Corra",bc_all,0xADD8E6;
end;

OnTimer300000:
announce "[Guerra do Tesouro] Apressem-se os Báus aparecerão em 5 minutos !",bc_all,0xADD8E6;
disablenpc "exit";
end;

OnTimer540000:
announce "[Guerra do Tesouro] Em 1 minutos os Báus do Tesouro surgirão , apressem-se !",bc_all,0xADD8E6;
stopnpctimer;
end;

OnClock1000:
OnClock1400:
OnClock1600:
OnClock1800:
OnClock2000:
OnClock2200:
OnClock0000:
set .@bau,1324;  //id Bau da Wot
announce "[Guerra do Tesouro] Os Báus do tesouro apareceram !",bc_all,0xADD8E6;
monster "prt_are_in",178,140,"Bau do Tesouro",.@bau,1,"War of Treasure::OnThisMobDeath"; 
monster "prt_are_in",22,89,"Bau do Tesouro",.@bau,1,"War of Treasure::OnThisMobDeath";
end;


OnThisMobDeath:
set .morto,.morto+1;
announce "[Guerra do Tesouro] O Jogador "+strcharinfo(0)+" do clã "+strcharinfo(2)+" acaba de destruir um dos Baús!",bc_all,0xADD8E6;
Query_sql "UPDATE `guild` SET `pontos`=`pontos`+1 WHERE `guild_id`='"+getcharid(2)+"'";
if (.morto == 2) {
enablenpc "exit#tw";
}
end;
}



//Muros
prt_are_in,105,21,3,3	monster	Muro	1905,1,30,60,"War of Treasure::OnInit";
prt_are_in,92,23,5,5	monster	Muro	1905,1,30,60,"War of Treasure::OnInit";
prt_are_in,87,12,2,2	monster	Muro	1905,1,30,60,"War of Treasure::OnInit";
prt_are_in,107,12,4,4	monster	Muro	1905,1,30,60,"War of Treasure::OnInit";
prt_are_in,100,16,6,6	monster	Muro	1905,1,30,60,"War of Treasure::OnInit";
prt_are_in,97,19,3,3	monster	Muro	1905,1,30,60,"War of Treasure::OnInit";


//Portais
//izlude,128,225,0	warp	War Of Treasure1	1,1,arena_room,100,25
prt_are_in,55,13,0	warp	War Of Treasure#1	1,1,prt_are_in,177,129
prt_are_in,177,127,0	warp	War Of Treasure#2	1,1,prt_are_in,57,13
prt_are_in,21,75,0	warp	War Of Treasure#3	1,1,prt_are_in,140,13
prt_are_in,142,13,0	warp	War Of Treasure#4	1,1,prt_are_in,21,77
arena_room,76,87	warp	WarOfTreasure#5	1,1,prt_are_in,97,30


izlude,128,225,1	script	entrada	45,2,2,{ 
OnTouch:
if (getcharid(2) > 0 ) {
warp "arena_room",100,25;
end;
}
else {
mes "^FF0000 Você precisa estar em um Clã para participar desse evento. ^000000";
close; }
end;
}

prt_are_in,97,6,1	script	exit#tw	45,2,2,{
OnTouch:
warp "izlude",128,113;
end;
}

arena_room	mapflag	gvg
arena_room	mapflag	nowarp
arena_room	mapflag	nowarpto
arena_room	mapflag	noreturn
prt_are_in	mapflag	gvg
prt_are_in	mapflag	nowarp
prt_are_in	mapflag	nowarpto
prt_are_in	mapflag	noreturn


izlude,132,220,4	script	Guerra do Tesouro	857,{

mes "^3366FF[Rank Guerra do Tesouro]^000000";
mes "^999999Posição^000000  : ^339966Guild ^000000: ^000080Pontos^000000";
for(set .@i,0; .@i < 10; set .@i,.@i+1){
query_sql "select `name`,`pontos` from `guild` where `pontos` > 0 ORDER BY `pontos` DESC LIMIT 20",.@n$,.@p;
mes "^999999"+(.@i+1)+"^000000 : ^339966"+.@n$[.@i]+"^000000 : ^000080"+.@p[.@i]+"^000000";
if(.@p == 0) break;
}
close;
}

Hope is useful for you n.n.

Regards.​

Thx =)

  • Upvote 1

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...