Jump to content

PVP, WoE, GVG: Woe Ranking List ( GvG, Emp Break, Guild Rank ) with Points and Shop


Recommended Posts


  • Group:  Members
  • Topic Count:  19
  • Topics Per Day:  0.01
  • Content Count:  398
  • Reputation:   246
  • Joined:  07/04/19
  • Last Seen:  

Woe Ranking List ( GvG, Emp Break, Guild Rank ) with Points and Shop


 

In response to this post : 

https://rathena.org/board/topic/122667-woe-ranking-script/

https://rathena.org/board/topic/121631-woe-rankings-script/#comment-373249

https://rathena.org/board/topic/96397-woe-ranking/

https://rathena.org/board/topic/109488-ranking-woe/
 

By downloading this file, you agree with my Terms of Service:

• You are not allowed remove my signature from any of the included files.
• You are not allowed claim my work as yours.

 

If you like it, give me a ?


 

  • Upvote 1
  • Love 8
  • Like 1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  145
  • Topics Per Day:  0.06
  • Content Count:  354
  • Reputation:   8
  • Joined:  04/16/18
  • Last Seen:  

functional, multipurpose, easy to use and very useful script. no doubt many servers will enjoy this script, thanks for sharing your work @BeWan

Edited by IsabelaFernandez
  • MVP 1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  96
  • Reputation:   20
  • Joined:  11/24/14
  • Last Seen:  

 

hi @BeWan First of all, thanks for the script, but I think it should be modified a little more. and add other functions if you can.
well, first when I test the scrip, all tops give the same information, murders, dead and emp. I think that part should be separated.
and I also noticed that the murders and deaths take it for the same data,
and already taking advantage, it will be possible to add the prize function per month, for example, the first places, receive a prize every 30 days.
Upon receiving your prize they are announced by the entire server, if it is not too much to ask.

pdt if something is not understood is why I am using the google translator

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  19
  • Topics Per Day:  0.01
  • Content Count:  398
  • Reputation:   246
  • Joined:  07/04/19
  • Last Seen:  

6 hours ago, JinYuichi said:

 

hi @BeWan First of all, thanks for the script, but I think it should be modified a little more. and add other functions if you can.
well, first when I test the scrip, all tops give the same information, murders, dead and emp. I think that part should be separated.
and I also noticed that the murders and deaths take it for the same data,
and already taking advantage, it will be possible to add the prize function per month, for example, the first places, receive a prize every 30 days.
Upon receiving your prize they are announced by the entire server, if it is not too much to ask.

pdt if something is not understood is why I am using the google translator

yes same information but different rank list when you choose on the 3 option(kills, deaths, emp break).

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  129
  • Topics Per Day:  0.03
  • Content Count:  660
  • Reputation:   85
  • Joined:  04/07/14
  • Last Seen:  

Amazing work bro!

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  104
  • Reputation:   15
  • Joined:  04/18/15
  • Last Seen:  

How can I add a shop to this good script? @BeWan

Link to comment
Share on other sites

  • 2 weeks later...

  • Group:  Members
  • Topic Count:  19
  • Topics Per Day:  0.01
  • Content Count:  398
  • Reputation:   246
  • Joined:  07/04/19
  • Last Seen:  

On 3/2/2020 at 11:01 PM, Jacktuloco said:

How can I add a shop to this good script? @BeWan

I already update the file. shop added ?

  • MVP 1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  96
  • Reputation:   20
  • Joined:  11/24/14
  • Last Seen:  

@BeWan Can you add rewards per month to the first top?, If it's not too much to ask

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  17
  • Topics Per Day:  0.01
  • Content Count:  66
  • Reputation:   0
  • Joined:  10/23/19
  • Last Seen:  

badass scripter as always. thank you for sharing this multi purpose npc. 

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  20
  • Topics Per Day:  0.01
  • Content Count:  73
  • Reputation:   1
  • Joined:  11/27/18
  • Last Seen:  

No emperium breaker statistics on Woe SE. How can i Fix it?

Also bug with nicknames. 2180 - another char on account of KeeperSura, but I killed KeeperSura, nickname is true.

image.png.850de771284dd8da388da2349458c1bf.png

Edited by 3TAJIOH
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  19
  • Topics Per Day:  0.01
  • Content Count:  398
  • Reputation:   246
  • Joined:  07/04/19
  • Last Seen:  

16 hours ago, 3TAJIOH said:

No emperium breaker statistics on Woe SE. How can i Fix it?

Go to: npc / guild2 / agit_main_se.txt

find:

OnStartArena:
	set .@GID,getcharid(2);

replace with this:

OnStartArena:
	set .@breaker$, strcharinfo(0);
	query_sql( "SELECT * FROM woe_ranking WHERE `PlayerName` = '"+strcharinfo(0)+"'", .@CharID, .@Name$, .@Kills, .@Deaths, .@EmpBreak);
	set .WoeBreakPoints, 1;
	set ToTalB , .@EmpBreak + .WoeBreakPoints;
	set .@GID,getcharid(2);
	
	if(.@Name$ == strcharinfo(0)){
	query_sql("UPDATE `woe_ranking` SET `EmpBreak` = '"+ToTalB+"' WHERE `PlayerName` = '"+strcharinfo(0)+"'");
	}else{
	query_sql("INSERT INTO `woe_ranking` (`Char_ID`,`PlayerName`,`Kills`,`Deaths`,`EmpBreak`) VALUES ('"+getcharid(0)+"', '"+strcharinfo(0)+"', '"+.@Kills+"', '"+.@Deaths+"', '"+ToTalB+"')"); 
	}

untested.

 

15 hours ago, 3TAJIOH said:

Also bug with nicknames. 2180 - another char on account of KeeperSura, but I killed KeeperSura, nickname is true.

image.png.850de771284dd8da388da2349458c1bf.png

npc script get or save the name of the character not the nickname.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  20
  • Topics Per Day:  0.01
  • Content Count:  73
  • Reputation:   1
  • Joined:  11/27/18
  • Last Seen:  

7 hours ago, BeWan said:

npc script get or save the name of the character not the nickname.

Yes, but the ID and name of character are not correct.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  19
  • Topics Per Day:  0.01
  • Content Count:  398
  • Reputation:   246
  • Joined:  07/04/19
  • Last Seen:  

2 hours ago, 3TAJIOH said:

Yes, but the ID and name of character are not correct.

im using this script too working fine. try not to use nickname.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  20
  • Topics Per Day:  0.01
  • Content Count:  73
  • Reputation:   1
  • Joined:  11/27/18
  • Last Seen:  

First killed SuperNovice by GM, then killed GM by SuperNovice. ID 8 is another character on Supernovice's account.

image.png.acb8152f40ced061d290483d418eca1d.png

Didn't change ur code.

}else if(strcharinfo(3) == "pvp_n_1-5"){ // This is PVP MAP restriction
	if(getcharid(3)==killedrid) end;
		set PvPpoints, PvPpoints+.PvP_Point;
		query_sql( "SELECT * FROM pvp_ranking WHERE `Char_ID` = '"+getcharid(0)+"'", .@CharID, .@Name$, .@Kills, .@Deaths);
		set ToTalPvPoints , .@Kills + .PvP_Point;
		
	if(getcharid(0) == .@CharID){
		query_sql("UPDATE `pvp_ranking` SET `Kills` = '"+ToTalPvPoints+"' WHERE `Char_ID` = '"+getcharid(0)+"'");
	}else{	
		query_sql("INSERT INTO `pvp_ranking` (`Char_ID`,`PlayerName`,`Kills`,`Deaths`) VALUES ('"+getcharid(0)+"', '"+strcharinfo(0)+"', '"+.PvP_Point+"', '"+.@Deaths+"')"); 
	}
		
		//This is the point system on the player, you can disable this anytime by adding comment " // "
		dispbottom "Вы убили "+rid2name(killedrid)+" и получили "+.PvP_Point+" очка.";
		attachrid(killedrid);
		set PvPpoints, PvPpoints-.PvP_Deductpoint;
		dispbottom "Вас убил "+rid2name(killerrid)+", Вы потеряли "+.PvP_Deductpoint+" очка.";
		
		////////query for the deaths
		query_sql( "SELECT `char_id`, `account_id` FROM `char` WHERE `account_id` =  '"+getcharid(3)+"' ", .@Cchar_id, .@Aid);
		query_sql( "SELECT * FROM pvp_ranking WHERE `Char_ID` = '"+.@Cchar_id+"'", .@CharID, .@Name$, .@Kills, .@Deaths);
		set ToTalDeathPvPoints , .@Deaths + .PvP_Deductpoint;
		
	if(.@CharID != .@Cchar_id){
		query_sql("INSERT INTO `pvp_ranking` (`Char_ID`,`PlayerName`,`Kills`,`Deaths`) VALUES ('"+.@Cchar_id+"', '"+strcharinfo(0)+"', '0', '"+ToTalDeathPvPoints+"')");
	}else{
		query_sql("UPDATE pvp_ranking SET Deaths = '"+ToTalDeathPvPoints+"' WHERE `Char_ID` = '"+.@Cchar_id+"'");
	}
		end;
	}
    }
	end;

 

After few kills image.png.028e7f11fb9f029a2ac2788e5bfba173.pngimage.png.9d9b2fce718ae0d0254cde465765307a.png

 

So after WOE image.png.c3b8fbe0fa2e6cc4bdcc38d2d9e75f0c.png

Edited by 3TAJIOH
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  6
  • Topics Per Day:  0.00
  • Content Count:  150
  • Reputation:   11
  • Joined:  12/03/18
  • Last Seen:  

Another one! Bewan!

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  19
  • Topics Per Day:  0.01
  • Content Count:  398
  • Reputation:   246
  • Joined:  07/04/19
  • Last Seen:  

@3TAJIOH its working fine on my test server but i will recheck it when i have free time.

Link to comment
Share on other sites

  • 1 month later...

  • Group:  Members
  • Topic Count:  16
  • Topics Per Day:  0.01
  • Content Count:  31
  • Reputation:   0
  • Joined:  08/09/17
  • Last Seen:  

Hello, I have a problem with pvp points, it doesn't take me even changing the map constraint

Link to comment
Share on other sites

  • 1 year later...

  • Group:  Members
  • Topic Count:  19
  • Topics Per Day:  0.01
  • Content Count:  398
  • Reputation:   246
  • Joined:  07/04/19
  • Last Seen:  

7 hours ago, merot19 said:

Guild Rank is not working guild rank now showing on the the top list

if i got free time. i will update this script.

  • Love 1
  • Like 1
Link to comment
Share on other sites

  • 9 months later...

  • Group:  Members
  • Topic Count:  67
  • Topics Per Day:  0.02
  • Content Count:  225
  • Reputation:   30
  • Joined:  10/21/12
  • Last Seen:  

Kill and Deaths counts same every time on latest git.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  139
  • Reputation:   55
  • Joined:  06/02/12
  • Last Seen:  

22 hours ago, qtdan said:

Kill and Deaths counts same every time on latest git.

Hi.

Find this line:

query_sql( "SELECT `char_id`, `account_id` FROM `char` WHERE `account_id` =  '"+getcharid(3)+"' ", .@Cchar_id, .@Aid);

Replace with:

.@Cchar_id = getcharid(0, rid2name(killedrid));

 

Find this line:

query_sql("INSERT INTO `woe_ranking` (`Char_ID`,`PlayerName`,`Kills`,`Deaths`,`EmpBreak`) VALUES ('"+.@Cchar_id+"', '"+strcharinfo(0)+"', '0', '"+TotalD+"', '"+.@EmpBreak+"')");

Replace with:

query_sql("INSERT INTO `woe_ranking` (`Char_ID`,`PlayerName`,`Kills`,`Deaths`,`EmpBreak`) VALUES ('"+.@Cchar_id+"', '" + rid2name(killedrid) + "', '0', '"+TotalD+"', '"+.@EmpBreak+"')");

 

Link to comment
Share on other sites

  • 1 month later...

  • Group:  Members
  • Topic Count:  19
  • Topics Per Day:  0.01
  • Content Count:  398
  • Reputation:   246
  • Joined:  07/04/19
  • Last Seen:  

a new version uploaded. kindly wait for the approval.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  76
  • Topics Per Day:  0.02
  • Content Count:  202
  • Reputation:   2
  • Joined:  07/09/12
  • Last Seen:  

Thanks

 

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  18
  • Topics Per Day:  0.00
  • Content Count:  48
  • Reputation:   1
  • Joined:  10/09/12
  • Last Seen:  

how to disable giving points for spamming kills on same player only at castle?

 

Edited by makuexile
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  19
  • Topics Per Day:  0.01
  • Content Count:  398
  • Reputation:   246
  • Joined:  07/04/19
  • Last Seen:  

12 hours ago, makuexile said:

how to disable giving points for spamming kills on same player only at castle?

 

i will add this kind of security in version 5.

Link to comment
Share on other sites

Join the conversation

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

Guest
Reply to this topic...

×   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.

×
×
  • Create New...