Aureon Posted January 26, 2016 Group: Members Topic Count: 34 Topics Per Day: 0.01 Content Count: 281 Reputation: 14 Joined: 10/14/13 Last Seen: October 9, 2017 Share Posted January 26, 2016 (edited) Can anyone make this? This is also an important script especially for events. for example, an event that kills a summoned poring and will rank 1st, 2nd and 3rd using EVENTPOINTS (as the permanent char variable) query using sql. whoever will be ranked 1st will receive -> 1 gold coin whoever will be ranked 2nd will receive -> 1 silver coin whoever will be ranked 3rd will receive -> 1 bronze coin Please share this to everyone, thanks! Edited January 26, 2016 by Aureon Quote Link to comment Share on other sites More sharing options...
0 Aureon Posted January 27, 2016 Group: Members Topic Count: 34 Topics Per Day: 0.01 Content Count: 281 Reputation: 14 Joined: 10/14/13 Last Seen: October 9, 2017 Author Share Posted January 27, 2016 bump? Quote Link to comment Share on other sites More sharing options...
0 yuchinin Posted January 28, 2016 Group: Members Topic Count: 12 Topics Per Day: 0.00 Content Count: 120 Reputation: 48 Joined: 07/23/13 Last Seen: August 27, 2021 Share Posted January 28, 2016 Idea sharing or script requesting Quote Link to comment Share on other sites More sharing options...
0 PandaLovesHamster Posted January 28, 2016 Group: Members Topic Count: 51 Topics Per Day: 0.01 Content Count: 452 Reputation: 35 Joined: 12/18/14 Last Seen: May 30, 2016 Share Posted January 28, 2016 Question, will event points reset every after event? If yes then you can do a query to delete the event points in the database. You can simply put OnMobKill the points gained from killing the mobs.After which you can do a for loop or a while loop to determine who has the most points during the event, rewarding them and then deleting the event points in the database. Quote Link to comment Share on other sites More sharing options...
0 Aureon Posted January 30, 2016 Group: Members Topic Count: 34 Topics Per Day: 0.01 Content Count: 281 Reputation: 14 Joined: 10/14/13 Last Seen: October 9, 2017 Author Share Posted January 30, 2016 after the event, the rankings in the NPC will show 1st - prize: gold, 2nd - prize : silver, 3rd - prize: bronze... once the event will be triggered to start again, that's the time the ranking will automatically reset.can anyone please share this script to us? Quote Link to comment Share on other sites More sharing options...
0 Stolao Posted January 30, 2016 Group: Developer Topic Count: 48 Topics Per Day: 0.01 Content Count: 1443 Reputation: 344 Joined: 10/17/12 Last Seen: Sunday at 01:58 PM Share Posted January 30, 2016 after the event, the rankings in the NPC will show 1st - prize: gold, 2nd - prize : silver, 3rd - prize: bronze... once the event will be triggered to start again, that's the time the ranking will automatically reset. can anyone please share this script to us? If you give me details I can add this to my autoevent script for you after the event, the rankings in the NPC will show 1st - prize: gold, 2nd - prize : silver, 3rd - prize: bronze... once the event will be triggered to start again, that's the time the ranking will automatically reset. can anyone please share this script to us? If you give me details I can add this to my autoevent script for you Quote Link to comment Share on other sites More sharing options...
0 Aureon Posted January 31, 2016 Group: Members Topic Count: 34 Topics Per Day: 0.01 Content Count: 281 Reputation: 14 Joined: 10/14/13 Last Seen: October 9, 2017 Author Share Posted January 31, 2016 after the event, the rankings in the NPC will show 1st - prize: gold, 2nd - prize : silver, 3rd - prize: bronze... once the event will be triggered to start again, that's the time the ranking will automatically reset. can anyone please share this script to us? If you give me details I can add this to my autoevent script for you after the event, the rankings in the NPC will show 1st - prize: gold, 2nd - prize : silver, 3rd - prize: bronze... once the event will be triggered to start again, that's the time the ranking will automatically reset. can anyone please share this script to us? If you give me details I can add this to my autoevent script for you @stolao: wow! you are now a script dev~ congrats! @topic: For example, Kill the Poring Event. Event will be triggered every hour Event will last for 5 minutes Once the event started, it will summon a lot of poring Every time the player kills a poring, they gain 1 point At the end of the event, rankings (1st, 2nd and 3rd) will be announced and can be displayed in the NPC. If the player ranked as 1st - the player can get his reward (ex: Gold Coin) in the NPC. If the player ranked as 2nd - the player can get his reward (ex: Silver Coin) in the NPC. If the player ranked as 3rd - the player can get his reward (ex: Bronze Coin) in the NPC. Once the event will be triggered to start again, the rankings will reset. Thank you in advance! Quote Link to comment Share on other sites More sharing options...
0 Aureon Posted February 5, 2016 Group: Members Topic Count: 34 Topics Per Day: 0.01 Content Count: 281 Reputation: 14 Joined: 10/14/13 Last Seen: October 9, 2017 Author Share Posted February 5, 2016 bump? Event will be triggered every hour Event will last for 5 minutes Once the event started, it will summon a lot of poring Every time the player kills a poring, they gain 1 point At the end of the event, rankings (1st, 2nd and 3rd) will be announced and can be displayed in the NPC. If the player ranked as 1st - the player can get his reward (ex: Gold Coin) in the NPC. If the player ranked as 2nd - the player can get his reward (ex: Silver Coin) in the NPC. If the player ranked as 3rd - the player can get his reward (ex: Bronze Coin) in the NPC. Once the event will be triggered to start again, the rankings will reset. Quote Link to comment Share on other sites More sharing options...
0 benching Posted February 6, 2016 Group: Members Topic Count: 26 Topics Per Day: 0.01 Content Count: 350 Reputation: 43 Joined: 09/07/12 Last Seen: August 30, 2019 Share Posted February 6, 2016 try thishttps://rathena.org/board/files/file/3429-monster-invasion-top-3/ you probably need to wait for approval before you can download Quote Link to comment Share on other sites More sharing options...
0 Aureon Posted February 8, 2016 Group: Members Topic Count: 34 Topics Per Day: 0.01 Content Count: 281 Reputation: 14 Joined: 10/14/13 Last Seen: October 9, 2017 Author Share Posted February 8, 2016 try this https://rathena.org/board/files/file/3429-monster-invasion-top-3/ you probably need to wait for approval before you can download Sad. The file you posted seems not working. Quote Link to comment Share on other sites More sharing options...
0 yuchinin Posted February 8, 2016 Group: Members Topic Count: 12 Topics Per Day: 0.00 Content Count: 120 Reputation: 48 Joined: 07/23/13 Last Seen: August 27, 2021 Share Posted February 8, 2016 (edited) This shall work~Just done it~ Thumb up if work~ Note: Remember to change <TAB> with your keyboard tab. poring_w01,100,100,5<TAB>script<TAB>Poring Ranking Npc<TAB>1002,{ function claimReward; mes "[ "+strnpcinfo(0)+" ]"; if(.status){ mes "Please come to me after the event end."; end; } claimReward(); end; OnMinute00: .status = 1; deletearray .charid,getarraysize(.charid); deletearray .val,getarraysize(.val); query_sql("DELETE FROM global_reg_value where str = '"+.variable_use$+"'"); announce "Poring Ranking Event has just started!",0; monster strnpcinfo(4),0,0,"--ja--",.mob_id,.mob_amt,strnpcinfo(3)+"::OnKill"; do{ sleep 1000; .tick += 1; }while(.tick <= .event_duration); .status = 0; killmonsterall strnpcinfo(4); announce "Poring Ranking Event has just end!",0; .@num = query_sql("SELECT char_id,value FROM global_reg_value where str = '"+.variable_use$+"' order by CAST(`value` AS SIGNED) desc limit 3",.charid,.val); for(.@x=0;.@x<.@num;.@x++){ announce "Rank "+(.@x+1)+" ["+rid2name(.charid[.@x])+" ] "+.variable_use$+": "+.val[.@x],0; } announce "Please claim the reward from "+strnpcinfo(0)+"!",0; announce "Poring Ranking Event has just ended!",0; end; OnKill: if(attachrid(getcharid(3))){ set getd(.variable_use$),getd(.variable_use$)+1; dispbottom "You gain "+.point_earn+" "+.variable_use$+" on killing "+getmonsterinfo(.mob_id,0)+"!"; } end; function claimReward { for(.@x=0;.@x<.@num;.@x++){ if(getcharid(0)==.charid[.@x]){ mes "Congratulation "+strcharinfo(0),"You Rank on "+(.@x+1)+" with "+getd(.variable_use$)+" "+.variable_use$; mes "You will been rewarded "+.prize_amt[.@x]+" x "+getitemname(.prize[.@x]); close2; getitem .prize[.@x],.prize_amt[.@x]; warp "SavePoint",0,0; break; } } mes "You get "+getd(.variable_use$)+" "+.variable_use$+" and fail to kick in first 3 rank.","Try harder next time!"; close2; warp "SavePoint",0,0; end; } OnInit: .mob_id = 1002; // mob id to spawn .mob_amt = 100; // mob amount to spawn .point_earn = 1; // point earn on each kill setarray .prize,671,675,673; // prize id list to get setarray .prize_amt,1,1,1; // prize amt list to get .event_duration = 5*60; // event duration .variable_use$ = "EVENTPOINTS"; // variable use } Edited February 8, 2016 by yuchinin 1 Quote Link to comment Share on other sites More sharing options...
0 benching Posted February 8, 2016 Group: Members Topic Count: 26 Topics Per Day: 0.01 Content Count: 350 Reputation: 43 Joined: 09/07/12 Last Seen: August 30, 2019 Share Posted February 8, 2016 try this https://rathena.org/board/files/file/3429-monster-invasion-top-3/ you probably need to wait for approval before you can download Sad. The file you posted seems not working. it works to me, and im sure that i re-upload the right one, anyway, just use yuchinin work 1 Quote Link to comment Share on other sites More sharing options...
Question
Aureon
Can anyone make this?
This is also an important script especially for events.
for example, an event that kills a summoned poring and will rank 1st, 2nd and 3rd using EVENTPOINTS (as the permanent char variable) query using sql.
whoever will be ranked 1st will receive -> 1 gold coin
whoever will be ranked 2nd will receive -> 1 silver coin
whoever will be ranked 3rd will receive -> 1 bronze coin
Please share this to everyone,
thanks!
Edited by AureonLink to comment
Share on other sites
11 answers to this question
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.