rathena.kpaste.net RSS
Difference between
modified post 60f0ec by Anonymous on Wed 20th Feb 2013 08:02
original post d4f8e by Anonymous on Sun 17th Feb 2013 22:45
Download diff
Show
old version |
new version |
both versions
| 1 | 1 | // http://rathena.org/board/topic/78486-breaker-rankings-npc/ | |
| 2 | 2 | // NPC that: | |
| 3 | 3 | // - displays top 10 emperium breaker (Rank, Char Name, Guild Name, Breaker Points) | |
| 4 | 4 | // - when a player was the last to break the emp after the WoE he will get 1 point | |
| 5 | 5 | // - selection which enables the player to trade their points into TCG (item id: 7227) | |
| 6 | 6 | // but their break points are still displayed | |
| 7 | 7 | ||
| 8 | 8 | prontera,155,188,0 script Emp Break Ladder 910,{ | |
| 9 | 9 | switch(select("View Emp Break Ladder:Redeem points for TCG:More Info:" + ((getgmlevel()>=99) ? "Reset Ladder":""))) { | |
| 10 | 10 | case 1: | |
| 11 | 11 | query_sql "SELECT `char`.`name`, `char`.`class`, guild.`name`, CAST(`value` AS UNSIGNED) " + | |
| 12 | 12 | "FROM global_reg_value " + | |
| 13 | 13 | "LEFT JOIN `char` ON global_reg_value.char_id=`char`.char_id " + | |
| 14 | 14 | "LEFT JOIN `guild` ON `char`.guild_id=guild.guild_id " + | |
| 15 | 15 | "WHERE global_reg_value.`str`='breaker_points' " + | |
| 16 | 16 | "ORDER BY CAST(`value` AS UNSIGNED) DESC LIMIT 10", | |
| 17 | 17 | .@name$, .@job, .@guild$, .@points; | |
| 18 | 18 | mes "[Top 10 Emp Breakers]"; | |
| 19 | 19 | for (set .@i,0; .@i<getarraysize(.@name$); set .@i,.@i+1) { | |
| 20 | 20 | mes (.@i+1) +". ^0000FF"+ .@name$[.@i] +"^000000, "+jobname(.@job[.i@])+", "+ .@guild$[.@i] +" ("+ .@points[.@i] +((.@points[.@i]==1)?" pt":" pts")+")"; | |
| 21 | 21 | } | |
| 22 | 22 | break; | |
| 23 | 23 | case 2: | |
| 24 | 24 | mes "[Emp Break Ladder]"; | |
| 25 | 25 | mes "Total Emp Breaks: " + breaker_points; | |
| 26 | 26 | mes "Available Points: " + (breaker_points - breaker_tcg); | |
| 27 | 27 | ||
| 28 | 28 | if (breaker_points == 0) { | |
| 29 | 29 | mes "You have not broke the emp yet!"; | |
| 30 | 30 | } else if (breaker_points <= breaker_tcg) { | |
| 31 | 31 | mes "You've already exchanged all your points for TCG."; | |
| 32 | 32 | mes "Come back after you break the emp again!"; | |
| 33 | 33 | } else { | |
| 34 | 34 | set .@reward, breaker_points - breaker_tcg; | |
| 35 | 35 | if (select("Redeem points for "+.@reward+" TCG:Cancel") == 2) { | |
| 36 | 36 | mes "Come back if you change your mind."; | |
| 37 | 37 | } else if (checkweight(7227, .@reward) == 0) { | |
| 38 | 38 | mes "You are overweight or carrying too many items."; | |
| 39 | 39 | } else { | |
| 40 | 40 | getitem 7227, .@reward; | |
| 41 | 41 | set breaker_tcg, breaker_tcg + .@reward | |
| 42 | 42 | mes "Here are your "+.@reward+" TCG!"; | |
| 43 | 43 | } | |
| 44 | 44 | } | |
| 45 | 45 | break; | |
| 46 | 46 | case 3: | |
| 47 | 47 | mes "[Emp Break Ladder]"; | |
| 48 | 48 | mes "Each time you break the emp, you earn 1 point."; | |
| 49 | 49 | mes "Then, talk to me to redeem your point(s) for TCG."; | |
| 50 | 50 | break; | |
| 51 | 51 | case 4: | |
| 52 | 52 | if (getgmlevel() < 99) end; | |
| 53 | + | set .@AID, playerattached(); | |
| 53 | 54 | // reset for offline chars | |
| 54 | 55 | query_sql "DELETE FROM global_reg_value WHERE `str`='breaker_points'"; | |
| 55 | 56 | query_sql "DELETE FROM global_reg_value WHERE `str`='breaker_tcg'"; | |
| 56 | 57 | ||
| 57 | 58 | // for each online char, reset breaker_points to 0 | |
| 58 | 59 | while (getusers(1) > .@count) { | |
| 59 | 60 | set .@count, .@count + query_sql("SELECT account_id FROM `char` WHERE online=1 LIMIT 128 OFFSET "+.@count, .@account_id); | |
| 60 | 61 | set .@i, 0; | |
| 61 | 62 | while (.@i < getarraysize(.@account_id)) { | |
| 62 | 63 | if (attachrid(.@account_id[.@i])) | |
| 63 | 64 | doevent strnpcinfo(3)+"::OnResetBreakerPoints"; | |
| 64 | 65 | set .@i, .@i +1; | |
| 65 | 66 | } | |
| 66 | 67 | deletearray .@account_id, 128; | |
| 67 | 68 | sleep 1; // prevent infinity loop | |
| 68 | 69 | } | |
| 70 | + | attachrid .@AID; | |
| 69 | 71 | mes "Emp Break Ladder has been reset."; | |
| 70 | 72 | break; | |
| 71 | 73 | } | |
| 72 | 74 | close; | |
| 73 | 75 | ||
| 74 | 76 | OnResetBreakerPoints: | |
| 75 | 77 | set breaker_points, 0; | |
| 76 | 78 | set breaker_tcg, 0; | |
| 77 | 79 | end; | |
| 78 | 80 | } | |
| 79 | 81 |
Submit a correction or amendment below (click here to make a fresh posting)
After submitting an amendment, you'll be able to view the differences between the old and new posts easily.