BeWan Posted February 28, 2020 Group: Members Topic Count: 19 Topics Per Day: 0.01 Content Count: 398 Reputation: 247 Joined: 07/04/19 Last Seen: 11 hours ago Share Posted February 28, 2020 View File 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 Submitter BeWan Submitted 02/26/2020 Category PvP, GvG, WoE, Battleground Video Content Author BeWan 1 8 1 Quote Link to comment Share on other sites More sharing options...
IsabelaFernandez Posted February 28, 2020 Group: Members Topic Count: 146 Topics Per Day: 0.06 Content Count: 355 Reputation: 8 Joined: 04/16/18 Last Seen: August 22 Share Posted February 28, 2020 (edited) functional, multipurpose, easy to use and very useful script. no doubt many servers will enjoy this script, thanks for sharing your work @BeWan Edited February 28, 2020 by IsabelaFernandez 1 Quote Link to comment Share on other sites More sharing options...
JinYuichi Posted February 29, 2020 Group: Members Topic Count: 8 Topics Per Day: 0.00 Content Count: 110 Reputation: 29 Joined: 11/24/14 Last Seen: Yesterday at 12:05 PM Share Posted February 29, 2020 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 Quote Link to comment Share on other sites More sharing options...
BeWan Posted February 29, 2020 Group: Members Topic Count: 19 Topics Per Day: 0.01 Content Count: 398 Reputation: 247 Joined: 07/04/19 Last Seen: 11 hours ago Author Share Posted February 29, 2020 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). Quote Link to comment Share on other sites More sharing options...
Gidz Cross Posted March 2, 2020 Group: Members Topic Count: 130 Topics Per Day: 0.03 Content Count: 667 Reputation: 88 Joined: 04/07/14 Last Seen: 10 minutes ago Share Posted March 2, 2020 Amazing work bro! Quote Link to comment Share on other sites More sharing options...
JackTheGorrion Posted March 2, 2020 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 113 Reputation: 15 Joined: 04/18/15 Last Seen: 10 hours ago Share Posted March 2, 2020 How can I add a shop to this good script? @BeWan Quote Link to comment Share on other sites More sharing options...
BeWan Posted March 10, 2020 Group: Members Topic Count: 19 Topics Per Day: 0.01 Content Count: 398 Reputation: 247 Joined: 07/04/19 Last Seen: 11 hours ago Author Share Posted March 10, 2020 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 1 Quote Link to comment Share on other sites More sharing options...
JinYuichi Posted March 10, 2020 Group: Members Topic Count: 8 Topics Per Day: 0.00 Content Count: 110 Reputation: 29 Joined: 11/24/14 Last Seen: Yesterday at 12:05 PM Share Posted March 10, 2020 @BeWan Can you add rewards per month to the first top?, If it's not too much to ask Quote Link to comment Share on other sites More sharing options...
ScarrFace Posted March 11, 2020 Group: Members Topic Count: 17 Topics Per Day: 0.01 Content Count: 66 Reputation: 0 Joined: 10/23/19 Last Seen: August 28 Share Posted March 11, 2020 badass scripter as always. thank you for sharing this multi purpose npc. Quote Link to comment Share on other sites More sharing options...
3TAJIOH Posted March 14, 2020 Group: Members Topic Count: 20 Topics Per Day: 0.01 Content Count: 73 Reputation: 1 Joined: 11/27/18 Last Seen: August 4 Share Posted March 14, 2020 (edited) 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. Edited March 14, 2020 by 3TAJIOH Quote Link to comment Share on other sites More sharing options...
BeWan Posted March 15, 2020 Group: Members Topic Count: 19 Topics Per Day: 0.01 Content Count: 398 Reputation: 247 Joined: 07/04/19 Last Seen: 11 hours ago Author Share Posted March 15, 2020 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. npc script get or save the name of the character not the nickname. Quote Link to comment Share on other sites More sharing options...
3TAJIOH Posted March 15, 2020 Group: Members Topic Count: 20 Topics Per Day: 0.01 Content Count: 73 Reputation: 1 Joined: 11/27/18 Last Seen: August 4 Share Posted March 15, 2020 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. Quote Link to comment Share on other sites More sharing options...
BeWan Posted March 15, 2020 Group: Members Topic Count: 19 Topics Per Day: 0.01 Content Count: 398 Reputation: 247 Joined: 07/04/19 Last Seen: 11 hours ago Author Share Posted March 15, 2020 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. Quote Link to comment Share on other sites More sharing options...
3TAJIOH Posted March 15, 2020 Group: Members Topic Count: 20 Topics Per Day: 0.01 Content Count: 73 Reputation: 1 Joined: 11/27/18 Last Seen: August 4 Share Posted March 15, 2020 (edited) First killed SuperNovice by GM, then killed GM by SuperNovice. ID 8 is another character on Supernovice's account. 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 So after WOE Edited March 15, 2020 by 3TAJIOH Quote Link to comment Share on other sites More sharing options...
PsyOps Posted March 18, 2020 Group: Members Topic Count: 6 Topics Per Day: 0.00 Content Count: 150 Reputation: 11 Joined: 12/03/18 Last Seen: 13 minutes ago Share Posted March 18, 2020 Another one! Bewan! Quote Link to comment Share on other sites More sharing options...
BeWan Posted March 19, 2020 Group: Members Topic Count: 19 Topics Per Day: 0.01 Content Count: 398 Reputation: 247 Joined: 07/04/19 Last Seen: 11 hours ago Author Share Posted March 19, 2020 @3TAJIOH its working fine on my test server but i will recheck it when i have free time. Quote Link to comment Share on other sites More sharing options...
Chywoner Posted April 24, 2020 Group: Members Topic Count: 16 Topics Per Day: 0.01 Content Count: 31 Reputation: 0 Joined: 08/09/17 Last Seen: September 27 Share Posted April 24, 2020 Hello, I have a problem with pvp points, it doesn't take me even changing the map constraint Quote Link to comment Share on other sites More sharing options...
BeWan Posted February 20, 2022 Group: Members Topic Count: 19 Topics Per Day: 0.01 Content Count: 398 Reputation: 247 Joined: 07/04/19 Last Seen: 11 hours ago Author Share Posted February 20, 2022 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. 1 1 Quote Link to comment Share on other sites More sharing options...
dantoki Posted December 3, 2022 Group: Members Topic Count: 67 Topics Per Day: 0.02 Content Count: 229 Reputation: 32 Joined: 10/21/12 Last Seen: 3 hours ago Share Posted December 3, 2022 Kill and Deaths counts same every time on latest git. Quote Link to comment Share on other sites More sharing options...
Racaae Posted December 4, 2022 Group: Members Topic Count: 0 Topics Per Day: 0 Content Count: 187 Reputation: 81 Joined: 06/02/12 Last Seen: Tuesday at 10:42 AM Share Posted December 4, 2022 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+"')"); Quote Link to comment Share on other sites More sharing options...
BeWan Posted January 27, 2023 Group: Members Topic Count: 19 Topics Per Day: 0.01 Content Count: 398 Reputation: 247 Joined: 07/04/19 Last Seen: 11 hours ago Author Share Posted January 27, 2023 a new version uploaded. kindly wait for the approval. Quote Link to comment Share on other sites More sharing options...
Eros Posted January 29, 2023 Group: Members Topic Count: 76 Topics Per Day: 0.02 Content Count: 202 Reputation: 2 Joined: 07/09/12 Last Seen: June 7, 2023 Share Posted January 29, 2023 Thanks Quote Link to comment Share on other sites More sharing options...
makuexile Posted January 29, 2023 Group: Members Topic Count: 18 Topics Per Day: 0.00 Content Count: 48 Reputation: 1 Joined: 10/09/12 Last Seen: June 8, 2023 Share Posted January 29, 2023 (edited) how to disable giving points for spamming kills on same player only at castle? Edited January 29, 2023 by makuexile Quote Link to comment Share on other sites More sharing options...
BeWan Posted January 30, 2023 Group: Members Topic Count: 19 Topics Per Day: 0.01 Content Count: 398 Reputation: 247 Joined: 07/04/19 Last Seen: 11 hours ago Author Share Posted January 30, 2023 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.