DEsMOn

Amazing bro...now its working awesome...!!! THANK YOU SOOOOOOOOOOOOOOO MUCH...!!!!!!!!!!!!!!!!

I've tried your given solution but doesn't count.

I've noticed 1 small issue where the mvp has multiple map spawn that doesn't count Example These 2 MVP has multiple spawn in field. Atroce MVP - Kill counts for ra_fild02 but doesn't count for ra_fild03,ra_fild04,ve_fild01,ve_fild02 AddMvp(1785,"ra_fild02","ra_fild03","ra_fild04","ve_fild01","ve_fild02"); Same for Orc Hero - Kill counts for gef_fild14 but doesn't count for gef_fild02 AddMvp(1087,"gef_fild14","gef_fild02"); Rest All fine... Thank you so much sir you are amazing if u can provide solution for above would be great . 1 Small NPC dedicated on your name small token of appreciation...!

No brother, MVP Kill count should be count for default map mvp spawns, not for summon by any mean( BB, @spawn) Thank you Sader Sir, Will test n update..!! I got this error

Hello rAthena Pro-Scripters, I'm Looking for MVP script 1) Which included GM reset command. So MVP Kills count will be set to 0 again (So i can start MVP race with reset). 2) And this Script should count only MVP which are spawned in map as default example pay_fild11 Eddga, gef_fild10 Orc Lord, gef_fil14 Orc Hero, etc. (Should not count Bloody branch MVP , @spawn MVPS, event MVPs) Thanks in advance...!!

Hello Everyone. I've noticed Players using Bloody branch in BBroom, But when Specially BEE spawns they leave die n leave room and MVP stays there. Because of this when new team try to go in same room they get this MVP by default. That's Why looking for solution when all player dies or Left room MVP/all Monster should auto wipe Or Add GM reset button in same script to remove clear all mob from all room. If its possible please reply... @Elysium Thanks in Advance..!! dali02,82,136,5 script Bloody Branch Room 403,{ setarray $@maps$[1], "alb2trea", "pvp_n_1-5", "pvp_n_2-5", "pvp_n_3-5", "pvp_n_4-5", "pvp_n_5-5"; for(set .@b,1; .@b < getarraysize($@maps$); set .@b,.@b + 1) { if(.@b==1){ set .@menu$, .@menu$ + "Public- "+((getmapusers($@maps$[.@b])>=30)?"^CD0000Closed^000000("+getmapusers($@maps$[.@b])+")":"^007700Open^000000("+getmapusers($@maps$[.@b])+")")+":"; } else { set .@menu$, .@menu$ + "Private["+(.@b-1)+"]- "+((getmapusers(""+$@maps$[.@b]+"")>=5)?"^CD0000Closed^000000("+getmapusers($@maps$[.@b])+")":"^007700Open^000000("+getmapusers($@maps$[.@b])+")")+":"; } } if(select(.@menu$)) { callfunc "GRfunction",$@maps$[@menu],@menu; } } function script GRfunction { if(getmapusers(getarg(0))<=30&&getarg(1)==1){ warp getarg(0),0,0; end; } if(!getmapusers(getarg(0))){ mes "Input a new password."; input($password$[getarg(1)]); next; warp getarg(0),0,0; end; } if(getmapusers(getarg(0))<=5&&getarg(1)!=1) { mes "This room is password protected please input the password now."; input(@name$); if(@name$==$password$[getarg(1)]){ mes "correct!"; next; warp getarg(0),0,0; end; } else { mes "Incorrect!"; close; } } else { mes "I'm sorry this room is full."; close; } } // Duplicates //============================================================ alberta,32,247,6 duplicate(Bloody Branch Room) BBroom#alb 403 comodo,188,162,6 duplicate(Bloody Branch Room) BBroom#com 403 morocc,171,102,6 duplicate(Bloody Branch Room) BBroom#moc 403 gonryun,168,116,6 duplicate(Bloody Branch Room) BBroom#gon 403 mid_camp,221,288,6 duplicate(Bloody Branch Room) BBroom#mid 403 payon,186,105,6 duplicate(Bloody Branch Room) BBroom#pay 403 dicastes01,207,189,3 duplicate(Bloody Branch Room) BBroom#dic 403 mora,43,153,6 duplicate(Bloody Branch Room) BBroom#mor 403 malangdo,152,112,3 duplicate(Bloody Branch Room) BBroom#mal 403 ayothaya,157,102,3 duplicate(Bloody Branch Room) BBroom#ayo 403 BBroom.txt

Hello Everyone... This script working fine.. i just need to do some modification of adding GM reset so all status will be reset to 0 again and can start new count is it possible to add ? If possible please reply..!! @Elysium Thanks in Advance.!! //===== rAthena Script ======================================= //= Hunting Missions //===== By: ================================================== //= Euphy //===== Current Version: ===================================== //= 1.4 //===== Compatible With: ===================================== //= rAthena Project //===== Description: ========================================= //= Random hunting missions. //= Rewards are based on quest difficulty. //= //= NOTE: Requires SQL mob database. //===== Additional Comments: ================================= //= 1.0 Initial script. //= 1.1 Small improvements and fixes. //= 1.2 Added party support and replaced blacklists with an //= SQL query, both thanks to AnnieRuru. //= 1.3 Re-added a blacklist adapted for the SQL query. //= 1.3a Added mission reset options. //= 1.3b Function updates. //= 1.4 Check for deleted characters, thanks to AnnieRuru. //= Syntax updates and style cleaning. //============================================================ prontera,141,174,6 script Hunting Missions 494,{ cutin "162elena_01",2; function Chk; mes "[Hunting Missions]"; mes "Hello, " + strcharinfo(0) + "!"; if (!#Mission_Delay) { next; mes "[Hunting Missions]"; mes "I can't find any records..."; mes "You must be new here!"; emotion ET_HUK; next; callsub Mission_Info; emotion ET_GO; #Mission_Delay = 1; close2; cutin "162elena_01",255; end; } mes rand(2) ? "Working hard, as always..." : "Not slacking, I hope..."; mes "Is there anything I can help"; mes "you with?"; mes " "; mes "^777777~ You've completed " + callfunc("F_InsertPlural",Mission_Total,"mission",0,"^0055FF%d^777777 %s") + ". ~^000000"; next; switch(select( ((!Mission0) ? " ~ New Mission::" : ": ~ Mission Status: ~ Abandon Mission") + ": ~ Information:~ View Top Hunters: ~ ^777777Cancel^000000")) { //~ Mission Shop: //)) { case 1: mes "[Hunting Missions]"; if (#Mission_Count) { mes "You've started a mission"; mes "on another character."; if (!@hm_char_del_check) { // check for deleted character query_sql("SELECT 1 FROM `char_reg_num` WHERE `key` = 'Mission0' AND `char_id` IN(SELECT `char_id` FROM `char` WHERE `account_id` = " + getcharid(3) + ")", .@i); if (!.@i) { next; mes "[Hunting Missions]"; mes "I can't seem to find any records"; mes "for that character, though..."; mes "One moment, please."; emotion ET_SCRATCH; #Mission_Count = 0; } @hm_char_del_check = 1; } close2; cutin "162elena_01",255; end; } if (#Mission_Delay > gettimetick(2) && .Delay) { mes "I'm afraid you'll have to wait " + callfunc("Time2Str",#Mission_Delay) + " before taking another mission."; close2; cutin "162elena_01",255; end; } mes "You must hunt:"; query_sql("SELECT ID FROM `" + .mob_db$ + "` WHERE left(Sprite, 4) != 'meta' AND left(Sprite, 2) != 'E_' AND ~Mode & 32 AND EXP > 0 AND MVP1id = 0 AND DropCardid > 4000 AND DropCardid < 5000 AND ID < 2000 AND instr('"+.Blacklist$+"',ID) = 0 ORDER BY rand() LIMIT " + .Quests, .@mob); for (.@i = 0; .@i < .Quests; .@i++) { setd "Mission" + .@i, .@mob[.@i]; setd "Mission" + .@i +"_", 0; } #Mission_Count = rand(.Count[0], .Count[1]); callsub Mission_Status; next; mes "[Hunting Missions]"; mes "Report back when"; mes "you've finished."; mes "Good luck!"; close2; cutin "162elena_01",255; end; case 2: mes "[Hunting Missions]"; mes "Mission status:"; callsub Mission_Status; close2; cutin "162elena_01",255; end; case 3: mes "[Hunting Missions]"; mes "Do you really want to"; mes "abandon your mission?"; if (.Reset < 0 && .Delay) mes "Your delay time will not be reset."; else if (.Reset > 0) mes "It will cost " + callfunc("F_InsertComma",.Reset) + " Zeny."; next; switch(select(" ~ Abandon...: ~ ^777777Cancel^000000")) { case 1: if (.Reset > 0) { if (Zeny < .Reset) { mes "[Hunting Missions]"; mes "You don't have enough"; mes "Zeny to drop this mission."; emotion ET_SORRY; close2; cutin "162elena_01",255; end; } Zeny -= .Reset; emotion ET_MONEY; } mes "[Hunting Missions]"; mes "Alright, I've dropped"; mes "your current mission."; specialeffect2 EF_STORMKICK4; for (.@i = 0; .@i < .Quests; .@i++) { setd "Mission"+.@i, 0; setd "Mission"+.@i+"_", 0; } #Mission_Count = 0; if (.Reset < 0 && .Delay) #Mission_Delay = gettimetick(2) + (.Delay * 3600); close2; cutin "162elena_01",255; end; case 2: mes "[Hunting Missions]"; mes "I knew you were kidding!"; mes "Keep up the good work."; emotion ET_SMILE; close2; cutin "162elena_01",255; end; } case 4: callsub Mission_Info; close2; cutin "162elena_01",255; end; /*case 5: mes "[Hunting Missions]"; mes "You have ^0055FF" + #Mission_Points + "^000000 Mission Points."; mes "Use them well!"; callshop "missionshop",1; end;*/ case 5: mes "[Hunting Missions]"; mes "The top hunters are:"; query_sql("SELECT char_id AS id, (SELECT `name` FROM `char` WHERE char_id = id),`value` FROM `char_reg_num` WHERE `key` = 'Mission_Total' ORDER BY CAST(`value` AS SIGNED) DESC LIMIT 5", .@id, .@name$, .@val); for (.@i = 0; .@i < 5; .@i++) mes " [Rank " + (.@i+1) + "] " + ((.@name$[.@i] == "") ? "^777777none" : "^0055FF" + .@name$[.@i]+"^000000 : ^FF0000" + .@val[.@i] + " pt.") + "^000000"; close2; cutin "162elena_01",255; end; case 6: mes "[Hunting Missions]"; mes "Nothing? Okay..."; emotion ET_SCRATCH; close2; cutin "162elena_01",255; end; } end; Mission_Status: @f = 0; deletearray .@j[0], getarraysize(.@j); for (.@i = 0; .@i < .Quests; .@i++) { .@j[.@i] = getd("Mission" + .@i); .@j[.Quests] = .@j[.Quests] + strmobinfo(3,.@j[.@i]); .@j[.Quests+1] = .@j[.Quests+1] + (strmobinfo(6,.@j[.@i]) / (getbattleflag("base_exp_rate") / 100) * .Modifier[0]); .@j[.Quests+2] = .@j[.Quests+2] + (strmobinfo(7,.@j[.@i]) / (getbattleflag("job_exp_rate") / 100) * .Modifier[1]); mes " > "+Chk(getd("Mission"+.@i+"_"),#Mission_Count) + strmobinfo(1,.@j[.@i]) + " (" + getd("Mission"+.@i+"_") + "/" + #Mission_Count + ")^000000"; } // Reward formulas: .@Mission_Points = 3 + (.@j[.Quests] / .Quests / 6); .@Base_Exp = #Mission_Count * .@j[.Quests+1] / 5; .@Job_Exp = #Mission_Count * .@j[.Quests+2] / 5; .@Zeny = #Mission_Count * .Quests * .@j[.@i] * .Modifier[2]; next; mes "[Hunting Missions]"; mes "Mission rewards:"; //mes " > Mission Points: ^0055FF" + .@Mission_Points + "^000000"; mes " > Base Experience: ^0055FF" + callfunc("F_InsertComma",.@Base_Exp) + "^000000"; mes " > Job Experience: ^0055FF" + callfunc("F_InsertComma",.@Job_Exp) + "^000000"; //mes " > Zeny: ^0055FF" + callfunc("F_InsertComma",.@Zeny) + "^000000"; mes " > Zeny: you will be rewarded ranging 500,000z to 1,000,000"; mes " > Special Prize: ^0055FF 6 BLACK TREASURE BOX^000000"; mes " > 90% Chance to get this Rare reward: ^0055FF1 Ancient Silver Coin^000000"; if (@f) { @f = 0; return; } next; mes "[Hunting Missions]"; mes "Oh, you're done!"; mes "Good work."; set .@FINISHERNAME$, strcharinfo(0); mes "Here's your reward."; emotion ET_BEST; specialeffect2 EF_ANGEL; specialeffect2 EF_TRUESIGHT; //#Mission_Points += .@Mission_Points; BaseExp += .@Base_Exp; JobExp += .@Job_Exp; //Zeny += .@Zeny; .@zenyrand = rand(100000,2000000); Zeny += .@zenyrand; getitem 12715,10; //Treasure Box getitem 7960,1; announce "Player [ "+.@FINISHERNAME$+" ] has completely done doing Hunting Mission, More POWER to you!.",bc_all; for (.@i = 0; .@i < .Quests; .@i++) { setd "Mission" + .@i, 0; setd "Mission" + .@i+"_", 0; } #Mission_Count = 0; if (.Delay) #Mission_Delay = gettimetick(2) + (.Delay * 3600); Mission_Total++; if (Mission_Total == 1) query_sql("INSERT INTO `char_reg_num` (`char_id`,`key`,`index`,`value`) VALUES (" + getcharid(0) + ",'Mission_Total','0',1)"); else query_sql("UPDATE `char_reg_num` SET `value` = " + Mission_Total + " WHERE `char_id` = " + getcharid(0) + " AND `key` = 'Mission_Total'"); close2; cutin "162elena_01",255; end; Mission_Info: mes "[Hunting Missions]"; mes "If you so choose, I can assign"; mes "you a random hunting quest."; mes "Some are easier than others, but"; mes "the rewards increase with difficulty."; next; mes "[Hunting Missions]"; mes "Missions points are shared"; mes "amongst all your characters."; if (.Delay) mes "Delay time is, too."; mes "You can't take missions on"; mes "multiple characters at once."; next; mes "[Hunting Missions]"; mes "You can start a quest"; mes (.Delay ? "every " + ((.Delay == 1) ? "hour." : .Delay + " hours.") : "whenever you want."); mes "That's everything~"; return; function Chk { if (getarg(0) < getarg(1)) { @f = 1; return "^FF0000"; } else return "^00FF00"; } OnNPCKillEvent: if (!getcharid(1) || !.Party) { if (!#Mission_Count || !Mission0) end; for (.@i = 0; .@i < .Quests; .@i++) { if (strmobinfo(1,killedrid) == strmobinfo(1,getd("Mission" + .@i))) { if (getd("Mission" + .@i + "_") < #Mission_Count) { dispbottom "[Hunting Mission] Killed " + (set(getd("Mission" + .@i + "_"),getd("Mission" + .@i + "_") + 1)) + " of " + #Mission_Count + " " + strmobinfo(1,killedrid) + "."; end; } } } } else if (.Party) { .@mob = killedrid; getmapxy(.@map1$,.@x1,.@y1,BL_PC); getpartymember getcharid(1),1; getpartymember getcharid(1),2; for (.@i = 0; .@i < $@partymembercount; .@i++) { if (isloggedin($@partymemberaid[.@i], $@partymembercid[.@i])) { set .@Mission_Count, getvar(#Mission_Count, $@partymembercid[.@i]); set .@Mission0, getvar(Mission0, $@partymembercid[.@i]); set .@HP, readparam(HP, $@partymembercid[.@i]); if (.@Mission_Count && .@Mission0 && .@HP > 0) { getmapxy(.@map2$,.@x2,.@y2,BL_PC); if ((.@map1$ == .@map2$ || .Party == 1) && (distance(.@x1,.@y1,.@x2,.@y2) <= 30 || .Party < 3)) { for (.@j = 0; .@j < .Quests; .@j++) { .@my_mob_id = getvar( getd("Mission"+.@j),$@partymembercid[.@i] ); .@my_count = getvar( getd("Mission"+.@j+"_"), $@partymembercid[.@i] ); if (strmobinfo(1,.@mob) == strmobinfo(1,.@my_mob_id)) { if (.@my_count < .@Mission_Count) { setd "Mission"+.@j+"_", (.@my_count+1), $@partymembercid[.@i]; dispbottom "[Hunting Mission] Killed " + (.@my_count+1) + " of " + .@Mission_Count + " " + strmobinfo(1,.@mob) + ".", 0x777777, $@partymembercid[.@i]; break; } } } } } } } } end; OnInit: .Delay = 5; // Quest delay, in hours (0 to disable). .Quests = 5; // Number of subquests per mission (increases rewards). .Party = 2; // Party options: 0 (exclude party kills), 1 (include party kills), 2 (same map only), 3 (screen area only) .Reset = 0; // Reset options: -1 (abandoning mission sets delay time), 0 (no delay time), [Zeny] (cost to abandon mission, no delay time) setarray .Count[0], // Min and max monsters per subquest (increases rewards). 25,25; setarray .Modifier[0], // Multipliers for Base Exp, Job Exp, and Zeny rewards. ORIGINALE � /100 /100 60 getbattleflag("base_exp_rate")/50,getbattleflag("job_exp_rate")/50,2; .mob_db$ = // Table name of SQL mob database (checkre(0))?"mob_db_re":"mob_db"; setarray .Shop[0], // Reward items: <ID>,<point cost> (about 10~20 points per hunt). 7619,40,6225,40,12208,50,616,60,7620,60,6226,60,12264,70,6241,80,12214,100,6240,120,13610,160,16259,160,13611,240,16258,240,16395,320,16393,480,12103,500,12246,2000; .Blacklist$ = // Blacklisted mob IDs. "1701,1259,1295,1291,1038,1039,1046,1059,1062,1086,1087,1088,1089,1090,1091,1092,1093,1096,1108,1112,1115,1120,1147,1150,"+ "1631,1632,1391,1157,1159,1183,1186,1190,1198,1200,1203,1204,1205,1212,1220,1221,1234,1235,1244,1245,1250,1251,1252,"+ "1987,1259,1621,1392,1262,1268,1272,1283,1286,1287,1288,1289,1290,1293,1294,1296,1298,1299,1300,1301,1302,1303,1304,"+ "1830,1305,1270,1633,1306,1307,1308,1309,1311,1312,1313,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1335,"+ "1829,1670,1336,1337,1338,1339,1340,1341,1342,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1355,"+ "1356,1735,1668,1357,1358,1359,1360,1361,1362,1363,1373,1388,1389,1395,1396,1397,1398,1399,1418,1447,1449,1456,"+ "1485,1486,1587,1584,1487,1492,1502,1515,1520,1529,1530,1542,1568,1576,1582,1583,1588,1591,1592,1593,1605,1607,"+ "1609,1610,1611,1612,1618,1623,1626,1630,1634,1635,1636,1637,1638,1639,1640,1641,1642,1643,1644,1645,"+ "1646,1647,1648,1649,1650,1651,1658,1674,1676,1677,1678,1679,1681,1685,1688,1689,1700,1703,1704,1705,"+ "1706,1707,1708,1709,1710,1711,1712,1719,1720,1731,1733,1734,1751,1754,1755,1756,1763,1764,1765,1766,"+ "1767,1768,1779,1783,1785,1791,1795,1796,1797,1799,1800,1801,1802,1803,1804,1805,1806,1807,1808,1809,"+ "1810,1813,1814,1817,1825,1829,1831,1832,1833,1834,1835,1839,1840,1845,1846,1847,1848,1849,1850,1852,"+ "1853,1870,1871,1872,1873,1874,1876,1877,1879,1885,1889,1891,1894,1897,1899,1902,1903,1904,1905,1906,"+ "1907,1908,1909,1910,1911,1912,1913,1914,1915,1916,1917,1918,1919,1920,1921,1922,1923,1924,1925,1929,"+ "1930,1931,1932,1933,1934,1935,1936,1938,1939,1940,1941,1942,1943,1944,1945,1946,1947,1951,1952,1953,"+ "1954,1956,1957,1958,1959,1960,1961,1962,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,"+ "1976,1977,1978,1979,1980,1981,1983,1990,1991,2001,2010,2017,2018,2019,2022,2030,2031,2039,2040,2041,"+ "2052,2057,2067,2068,2079,2080,2087,2093,2097,2102,2106,2107,2135,2138,2139,2140,2141,2142,2143,2156,"+ "2157,2161,2162,2163,2164,2165,2166,2167,2168,2169,2170,2171,2172,2173,2174,2175,2176,2177,2178,2179,"+ "2180,2181,2182,2183,2184,2185,2186,2187,2188,2189,2190,2191,2192,2193,2194,2196,2198,2202,2206,2208,"+ "1247,1861,"+ "2221,2222,2223,2224,2225,2226,2227,2228,2229,2230,2231,2232,2233,2234,2235,2236,2237,2238,2239,2240,2241,2242,2243,2244,2249,2251,2253,2255,2288,2317,2318,2319,2320,2321,2322,2323,2325,2326,2327,2328,2329,2332,2333,2335,2336,2337,2341,2342,2345,2346,2347,2348,2349,2350,2351,2362,2378,2408,2409,2410,2411,2413,2415,2416,2417,2419,2420,2421,2422,2423,2424,2425,2426,2427,2441,2442,2443,2444,2445,2446,2447,2448,2449,2473,2474,2475,2476,2482,2528,2529,2530,2532,2533,2534,2535,2540,2541,2542,2562,2563,2564,2603,2604,2605,2606,2607,2608,2609,2610,2611,2612,2613,2614,2615,2616,2618,2619,2620,2621,2622,2623,2624,2625,2626,2627,2628,2629,2630,2631,2632,2633,2634,2635,2636,2637,2638,2639,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684,2685,2686,2687,2688,2689,2690,2691,2692,2693,2694,2695,2696,2697,2698,2699,2700,2701,2702,2703,2704,2705,2706,2707,2708,2709,2710,2711,2712,2713,2714,2715,2716,2717,2718,2719,2720,2721,2722,2723,2724,2725,2726,2727,2728,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,2741,2742,2743,2744,2745,2746,2747,2748,2749,2750,2751,2752,2753,2754,2755,2756,2757,2758,2759,2760,2761,2762,2763,2764,2765,2766,2767,2768,2769,2770,2771,2772,2773,2774,2775,2776,2777,2778,2779,2780,2781,2784,2785,2786,2788,2789,2790,2791,2792,2793,2794,2795,2796,2797,2798,2799,2800,2801,2802,2803,2804,2805,2806,2807,2808,2809,2810,2811,2812,2813,2814,2815,2816,2817,2818,2819,2820,2821,2822,2823,2824,2825,2826,2827,2828,2830,2831,2832,2833,2834,2835,2836,2837,2838,2839,2840,2841,2842,2843,2844,2845,2846,2847,2849,2850,2851,2852,2853,2854,2855,2856,2857,2858,2859,2860,2861,2862,2863,2864,2865,2866,2867,2868,2869,2870,2871,2872,2873,2874,2875,2876,2877,2878,2879,2880,2881,2882,2883,2884,2885,2886,2887,2888,2889,2890,2891,2892,2893,2894,2895,2896,2897,2898,2899,2900,2901,2902,2903,2904,2905,2907,2908,2909,2910,2911,2912,2913,2920,2921,2922,2923,2942,2959,2961,2987,2988,2992,2994,2996,2998,2999,3029,3038,3039,3040,3041,3073,3074,3091,3092,3096,3097,3100,3108,3109,3122,3123,3124,3175,3176,3177,3178,3179,3180,3181,3202,3203,3254,3450,3473,3474,3475,3484,3495,3503,3504,3505,3506,3508"; end; } //- pointshop missionshop -1,#Mission_Points,501:60,502:60,503:100 hunting_mission.txt

Ohhh Thank you for reply sir..!!!

Thank you so much done..! I changed and its solved..!! query_sql("TRUNCATE TABLE `ragnarok`.`ownladder`;"); query_sql("TRUNCATE TABLE `ragnarok`.`pvpladder`;"); 1 More question..i wanna do this to same for Hunting Mission n MVP ladder should i post new topic or u can help here?

Hello Sir, Thank you for reply I'm getting this in my CMD now. I've deleted table of pvpladder & ownladder & created Again still same issue. [SQL]: DB error - Table 'your sql database.pvpladder' doesn't exist [Debug]: at F:\rAthena\src\map\script.cpp:16873 - TRUNCATE TABLE `YOUR SQL DATABASE`.`pvpladder`; [Debug]: Source (NPC): RESET_PVP (invisible/not on a map) [SQL]: DB error - Table 'your sql database.ownladder' doesn't exist [Debug]: at F:\rAthena\src\map\script.cpp:16873 - TRUNCATE TABLE `YOUR SQL DATABASE`.`ownladder`; [Debug]: Source (NPC): RESET_PVP (invisible/not on a map) [SQL]: DB error - Table 'ragnarok.pvpladder' doesn't exist [Debug]: at F:\rAthena\src\map\script.cpp:16873 - SELECT `char`.`char_id`, `char`.`name`, `char`.`guild_id`, `char`.`class`, `char`.`sex`, `char`.`hair`, `char`.`hair_color`, `char`.`clothes_color`, `char`.`body`, `char`.`head_top`, `char`.`head_mid`, `char`.`head_bottom`, `char`.`robe`, `pvpladder`.`kills`, `pvpladder`.`streaks`, `pvpladder`.`deaths` FROM `char` RIGHT JOIN `pvpladder` ON `char`.`char_id` = `pvpladder`.`char_id` ORDER BY `kills` DESC LIMIT 10 [Debug]: Source (NPC): DOTAPVP (invisible/not on a map)

Hello Everyone... This script working fine.. i just need to do some modification of adding GM reset so all status will be reset to 0 again and can start new count is it possible to add ? If possible please reply..!! //====== rAthena Script ====================================================== //= PVP ladder script with dota announcement //===== By: ================================================================== //= AnnieRuru //===== Current Version: ===================================================== //= 3.6 //===== Compatible With: ===================================================== //= rAthena 2020-10-20, with MySQL 8.0 //===== Description: ========================================================= //= PVP ladder store in SQL table //= plus anti-sit-killer feature //===== Topic ================================================================ //= https://herc.ws/board/topic/18871-dota-pvp-ladder/ //===== Additional Comments: ================================================= //= add PVP Ladder statue due to popular demand //============================================================================ /* CREATE TABLE `pvpladder` ( `char_id` INT PRIMARY KEY, `name` VARCHAR(24) NOT NULL DEFAULT '', `streaks` INT DEFAULT 0, `kills` INT DEFAULT 0, `deaths` INT DEFAULT 0, `streaktime` DATETIME, KEY (`kills`), KEY (`streaks`) ) ENGINE = MyISAM; CREATE TABLE `ownladder` ( `guild_id` INT PRIMARY KEY, `name` VARCHAR(24) NOT NULL DEFAULT '', `currentown` INT DEFAULT 0, `highestown` INT DEFAULT 0, `owntime` DATETIME, KEY (`highestown`) ) ENGINE = MyISAM; */ // add all the maps that you want this script to trigger ... all pvp and event maps perhaps ? // but if you already enable "all" maps, then can comment all these guild_vs1 mapflag loadevent guild_vs2 mapflag loadevent guild_vs3 mapflag loadevent pvp_y_1-2 mapflag loadevent guild_vs5 mapflag loadevent aldeg_cas01 mapflag loadevent aldeg_cas02 mapflag loadevent aldeg_cas03 mapflag loadevent aldeg_cas04 mapflag loadevent aldeg_cas05 mapflag loadevent gefg_cas01 mapflag loadevent gefg_cas02 mapflag loadevent gefg_cas03 mapflag loadevent gefg_cas04 mapflag loadevent gefg_cas05 mapflag loadevent payg_cas01 mapflag loadevent payg_cas02 mapflag loadevent payg_cas03 mapflag loadevent payg_cas04 mapflag loadevent payg_cas05 mapflag loadevent prtg_cas01 mapflag loadevent prtg_cas02 mapflag loadevent prtg_cas03 mapflag loadevent prtg_cas05 mapflag loadevent arug_cas01 mapflag loadevent arug_cas02 mapflag loadevent arug_cas03 mapflag loadevent arug_cas04 mapflag loadevent arug_cas05 mapflag loadevent schg_cas01 mapflag loadevent schg_cas02 mapflag loadevent schg_cas03 mapflag loadevent schg_cas04 mapflag loadevent schg_cas05 mapflag loadevent - script DOTAPVP FAKE_NPC,{ OnInit: // Config .sound = 1; // soundeffect : 0 - disable, 1 - play soundeffect to all players on map, 2 - play soundeffect to an area around the killer, 3 - play soundeffect to killer only .dota_bc_flag = 0; // announce to : 0 - global, 1 - map .mapname_announcement = 1; // announce the map name in the announcement ? : 0 - off, 1 - on .killannounce = 1; // announce who pawn who's head : 0 - off, 1 - on .msg_die = 1; // show message who kill you when die : 0 - off, 1 - on .msg_kill = 1; // show message you kill who when killed someone : 0 - off, 1 - on .gmnokill = false; // GMs are not suppose to kill players. A GM with <this number> level or higher will do nothing. IF set to 60, GM60 and above kill any player will not get anything : 0 - off .killingspree = 3; .dominating = 4; .megakill = 5; .unstoppable = 6; .wickedsick = 7; .monsterkill = 8; .godlike = 9; .holyshit = 10; .continue = 1; // after beyond-godlike, every <this number> kills will make announcement again .owned = 5; // how many times the guild has to kill to announce ownage .owncontinue = 1; // after ownage, every <this number> guild cumulative kills will make ownage announce again // .min_gm_menu = 90; // minimum level of GM can use the GM menu on ladder npc .showtotal = 20; // show the length of ladder. .showpage = 10; // set the views per page. .loweststreak = 3; // mininum streak count allow to show in highest streak ladder. Default 3 means must at least have killing spree streak to display in ladder .lowestownage = 5; // mininum ownage count allow to show in longest ownage ladder. Default 5 means must at least have 5 ownage counts to display in ladder setarray .maptrigger$, // only these maps will trigger this script // "all", // uncomment this to allow load all maps "guild_vs1", "guild_vs2", "guild_vs3", "pvp_y_1-2", "aldeg_cas01", "aldeg_cas02", "aldeg_cas03", "aldeg_cas04", "aldeg_cas05", "gefg_cas01", "gefg_cas02", "gefg_cas03", "gefg_cas04", "gefg_cas05", "payg_cas01", "payg_cas02", "payg_cas03", "payg_cas04", "payg_cas05", "prtg_cas01", "prtg_cas02", "prtg_cas03", "prtg_cas04", "prtg_cas05", "arug_cas01", "arug_cas02", "arug_cas03", "arug_cas04", "arug_cas05", "schg_cas01", "schg_cas02", "schg_cas03", "schg_cas04", "schg_cas05", "guild_vs5"; .showstatue = 10; // number of statues. This number must match with the number of duplicates at the end of the script .fix_custom_sprite = true; // if your server has custom animated sprite that overlaps the sprite animation repeatedly on the statues, enable this // anti-sit-killer system // a player must kill another player with this minimum <this number> base level to get the announcement and in the ladder. // Otherwise only have streak ended announcement and killed player's streak reset. // Its possible for a level 1 novice to kill a level 99 player and he/she will still get in the ladder // but a level 99 kill a level 1 player will get nothing // 0 - off this system ( default is 55, pk setting ) .lvltokill = 0; // when a player kill another same player <this number> times in a row, the player is warp back to save point. // and the player's streak, kills, and ownage count will deduct accordingly // 0 - off this system .counttopunish = 6; // minimum level range to kill another player // eg. when set to 20, player level 99 needs to kill another player with minimum level of 79 to get announcement and increase the kill rank. // but a player with base level 50 kills a level 99 will also get the announcement // higher base level cannot kill lower level, but lower level can kill higher level // 0 - off this system .minlvlrange = 0; setmapflag "pvp_y_1-2",mf_nobranch; // Config ends ------------------------------------------------------------------------------------------ // to prevent bug happen if (.dota_bc_flag < 0 || .dota_bc_flag > 1) .dota_bc_flag = 0; if (.continue < 1) .continue = 1; if (.owncontinue < 1) .owncontinue = 1; if (.gmnokill <= 0) .gmnokill = 100; if (.lvltokill <= 1) .lvltokill = 0; if (.counttopunish <= 1) .counttopunish = 0; .maptriggersize = getarraysize(.maptrigger$); sleep 1; OnTimer30000: // refresh every 30 seconds. Note the `char` table is unrealiable, player still need to perform certain task to save the character -> see 'save_settings' in conf\map-server.conf .@query$ = "SELECT `char`.`char_id`, `char`.`name`, `char`.`guild_id`, `char`.`class`, `char`.`sex`, `char`.`hair`, `char`.`hair_color`, `char`.`clothes_color`, `char`.`body`, `char`.`head_top`, `char`.`head_mid`, `char`.`head_bottom`, `char`.`robe`, " + "`pvpladder`.`kills`, `pvpladder`.`streaks`, `pvpladder`.`deaths` " + "FROM `char` RIGHT JOIN `pvpladder` ON `char`.`char_id` = `pvpladder`.`char_id` ORDER BY `kills` DESC LIMIT "+ .showstatue; .@nb = query_sql(.@query$, .@cid, .@name$, .@guild_id, .@class, .@sex$, .@hair, .@hair_color, .@clothes_color, .@body, .@head_top, .@head_mid, .@head_bottom, .@robe, .@kills, .@streaks, .@deaths); if (.fix_custom_sprite) { for (.@i = 0; .@i < .@nb; ++.@i) { setunitdata .statue[.@i +1], UNPC_HEADTOP, 0; setunitdata .statue[.@i +1], UNPC_HEADMIDDLE, 0; setunitdata .statue[.@i +1], UNPC_HEADBOTTOM, 0; setunitdata .statue[.@i +1], UNPC_ROBE, 0; } } for (.@i = 0; .@i < .@nb; ++.@i) { setunitdata .statue[.@i +1], UNPC_CLASS, .@class[.@i]; setunitdata .statue[.@i +1], UNPC_SEX, (.@sex$[.@i] == "F")? SEX_FEMALE:SEX_MALE; setunitdata .statue[.@i +1], UNPC_HAIRSTYLE, .@hair[.@i]; setunitdata .statue[.@i +1], UNPC_HAIRCOLOR, .@hair_color[.@i]; setunitdata .statue[.@i +1], UNPC_CLOTHCOLOR, .@clothes_color[.@i]; setunitdata .statue[.@i +1], UNPC_BODY2, .@body[.@i]; setunitdata .statue[.@i +1], UNPC_HEADTOP, .@head_top[.@i]; setunitdata .statue[.@i +1], UNPC_HEADMIDDLE, .@head_mid[.@i]; setunitdata .statue[.@i +1], UNPC_HEADBOTTOM, .@head_bottom[.@i]; setunitdata .statue[.@i +1], UNPC_ROBE, .@robe[.@i]; setnpcdisplay "pvp_ladder_statue#"+(.@i +1), .@name$[.@i]; .statue_name$[.@i +1] = .@name$[.@i]; .statue_guild$[.@i +1] = getguildname(.@guild_id[.@i]); .statue_kills[.@i +1] = .@kills[.@i]; .statue_streaks[.@i +1] = .@streaks[.@i]; .statue_deaths[.@i +1] = .@deaths[.@i]; } for (.@i = .@nb; .@i < .showstatue; ++.@i) setunitdata .statue[.@i +1], UNPC_CLASS, HIDDEN_WARP_NPC; initnpctimer; end; // script start. OnPCKillEvent: if (getgmlevel() >= .gmnokill) end; .@map$ = strcharinfo(3); if (.maptrigger$ != "all") { while (.@i < .maptriggersize && .@map$ != .maptrigger$[.@i]) ++.@i; if (.@i == .maptriggersize) end; } .@killername$ = strcharinfo(0); .@killeraid = getcharid(3); .@killercid = getcharid(0); .@killerguildid = getcharid(2); .@killerbaselevel = BaseLevel; attachrid killedrid; .@victimname$ = strcharinfo(0); .@victimaid = getcharid(3); .@victimcid = getcharid(0); .@victimguildid = getcharid(2); .@victimbaselevel = BaseLevel; if (.@killeraid != .@victimaid && (.msg_die || .msg_kill)) { if (.msg_die) message .@victimname$, "You have been killed by "+ .@killername$; if (.msg_kill) message .@killername$, "You just killed "+ .@victimname$; } if (@PlayersKilledStreak >= .holyshit) .@streakname$ = "Beyond Godlike"; else if (@PlayersKilledStreak >= .godlike) .@streakname$ = "Godlike"; else if (@PlayersKilledStreak >= .monsterkill) .@streakname$ = "Monster Kill"; else if (@PlayersKilledStreak >= .wickedsick) .@streakname$ = "Wicked Sick"; else if (@PlayersKilledStreak >= .unstoppable) .@streakname$ = "Unstoppable"; else if (@PlayersKilledStreak >= .megakill) .@streakname$ = "Mega-kill"; else if (@PlayersKilledStreak >= .dominating) .@streakname$ = "Dominating"; else if (@PlayersKilledStreak >= .killingspree) .@streakname$ = "Killing Spree"; if (@PlayersKilledStreak >= .killingspree && .@killeraid == .@victimaid) announce sprintf("%s has ended %s own %s[%d] streak %s", .@killername$, (Sex)?"him":"her", .@streakname$, @PlayersKilledStreak, (.mapname_announcement)?("at "+ .@map$):""), bc_blue|.dota_bc_flag; else if (@PlayersKilledStreak >= .killingspree) announce sprintf("%s has ended %s's %s[%d] streak %s", .@killername$, .@victimname$, .@streakname$, @PlayersKilledStreak, (.mapname_announcement)?("at "+ .@map$):""), bc_blue|.dota_bc_flag; else if (.killannounce && .@killeraid != .@victimaid) announce sprintf("%s has pawned %s's head %s", .@killername$, .@victimname$, (.mapname_announcement)?("at "+ .@map$):""), bc_blue|.dota_bc_flag; @PlayersKilledStreak = 0; ++@dota_sql_deaths; @dota_multikills = 0; if (.@victimguildid) .guild_current_ownage[.@victimguildid] = 0; if (.@killeraid == .@victimaid || .@victimbaselevel < .lvltokill || (.minlvlrange && .@victimbaselevel + .minlvlrange < .@killerbaselevel)) { query_sql sprintf("replace into pvpladder values (%d, '%s', %d, %d, %d, from_unixtime(%d))", .@victimcid, escape_sql(.@victimname$), @dota_sql_streaks, @dota_sql_kills, @dota_sql_deaths, @dota_sql_streaktime); if (.@victimguildid && .guild_highest_ownage[.@victimguildid]) query_sql sprintf("replace into ownladder values (%d, '%s', %d, %d, from_unixtime(%d))", .@victimguildid, escape_sql(getguildname(.@victimguildid)), .guild_current_ownage[.@victimguildid], .guild_highest_ownage[.@victimguildid], .guild_ownage_time[.@victimguildid]); end; } .@victim_kills = @dota_sql_kills; .@victim_deaths = @dota_sql_deaths; .@victim_streaks = @dota_sql_streaks; .@victim_streaktime = @dota_sql_streaktime; attachrid killerrid; if (.counttopunish) { if (@sitkillminute != gettime(DT_MINUTE)) { deletearray @sitkill; @sitkillminute = gettime(DT_MINUTE); } ++@sitkill[.@victimaid]; if (@sitkill[.@victimaid] >= .counttopunish) { warp "SavePoint", 0,0; announce .@killername$ +" , Stop killing "+ .@victimname$ + " !!!", bc_all; debugmes .@killername$ +" is sit-killing "+ .@victimname$ +" for "+ @sitkill[.@victimaid] + " times"; logmes "is sit-killing "+ .@victimname$ +" for "+ @sitkill[.@victimaid] +" times"; if (@PlayersKilledStreak == @dota_sql_streaks) { @dota_sql_streaks = @dota_sql_streaks +1 - .counttopunish; @dota_sql_streaktime = gettimetick(2); } @PlayersKilledStreak = @PlayersKilledStreak +1 - .counttopunish; @dota_sql_kills = @dota_sql_kills +1 - .counttopunish; if (@PlayersKilledStreak < 0) @PlayersKilledStreak = 0; if (@dota_sql_kills < 0) @dota_sql_kills = 0; if (@dota_sql_streaks < 0) @dota_sql_streaks = 0; query_sql sprintf("replace into pvpladder values (%d, '%s', %d, %d, %d, from_unixtime(%d)), (%d, '%s', %d, %d, %d, from_unixtime(%d))", .@killercid, escape_sql(.@killername$), @dota_sql_streaks, @dota_sql_kills, @dota_sql_deaths, @dota_sql_streaktime, .@victimcid, escape_sql(.@victimname$), .@victim_streaks, .@victim_kills, .@victim_deaths, .@victim_streaktime); if (.@killerguildid) { if (.guild_current_ownage[.@killerguildid] == .guild_highest_ownage[.@killerguildid]) { .guild_highest_ownage[.@killerguildid] = .guild_highest_ownage[.@killerguildid] +1 - .counttopunish; .guild_ownage_time[.@killerguildid] = gettimetick(2); } .guild_current_ownage[.@killerguildid] = .guild_current_ownage[.@killerguildid] +1 - .counttopunish; if (.guild_current_ownage[.@killerguildid] < 0) .guild_current_ownage[.@killerguildid] = 0; if (.guild_highest_ownage[.@killerguildid] < 0) .guild_highest_ownage[.@killerguildid] = 0; if (.@victimguildid && .guild_highest_ownage[.@victimguildid]) query_sql sprintf("replace into ownladder values (%d, '%s', %d, %d, from_unixtime(%d)), (%d, '%s', %d, %d, from_unixtime(%d))", .@killerguildid, escape_sql(getguildname(.@killerguildid)), .guild_current_ownage[.@killerguildid], .guild_highest_ownage[.@killerguildid], .guild_ownage_time[.@killerguildid], .@victimguildid, escape_sql(getguildname(.@victimguildid)), .guild_current_ownage[.@victimguildid], .guild_highest_ownage[.@victimguildid], .guild_ownage_time[.@victimguildid]); else query_sql sprintf("replace into ownladder values (%d, '%s', %d, %d, from_unixtime(%d))", .@killerguildid, escape_sql(getguildname(.@killerguildid)), .guild_current_ownage[.@killerguildid], .guild_highest_ownage[.@killerguildid], .guild_ownage_time[.@killerguildid]); } else if (.@victimguildid && .guild_highest_ownage[.@victimguildid]) query_sql sprintf("replace into ownladder values (%d, '%s', %d, %d, from_unixtime(%d))", .@victimguildid, escape_sql(getguildname(.@victimguildid)), .guild_current_ownage[.@victimguildid], .guild_highest_ownage[.@victimguildid], .guild_ownage_time[.@victimguildid]); end; } } ++@PlayersKilledStreak; ++@dota_sql_kills; if (@PlayersKilledStreak > @dota_sql_streaks) { @dota_sql_streaks = @PlayersKilledStreak; @dota_sql_streaktime = gettimetick(2); } if (@PlayersKilledStreak == .killingspree) setarray .@streakname$, "killingspree.wav", "is on a KILLING SPREE", "!"; else if (@PlayersKilledStreak == .dominating) setarray .@streakname$, "dominating.wav", "is DOMINATING", "!"; else if (@PlayersKilledStreak == .megakill) setarray .@streakname$, "megakill.wav", "has a MEGA KILL", "!"; else if (@PlayersKilledStreak == .unstoppable) setarray .@streakname$, "unstoppable.wav", "is UNSTOPPABLE", "!!"; else if (@PlayersKilledStreak == .wickedsick) setarray .@streakname$, "wickedsick.wav", "is WICKED SICK", "!!"; else if (@PlayersKilledStreak == .monsterkill) setarray .@streakname$, "monsterkill.wav", "has a MONSTER KILL", "!!"; else if (@PlayersKilledStreak == .godlike) setarray .@streakname$, "godlike.wav", "is GODLIKE", "!!!"; else if (@PlayersKilledStreak >= .holyshit && ((@PlayersKilledStreak - .holyshit) % .continue == 0)) setarray .@streakname$,"holyshit.wav", "is BEYOND GODLIKE",". Someone KILL "+( (Sex)?"HIM":"HER" ) +"!!!!!!"; if (getstrlen(.@streakname$[1])) { announce sprintf("%s %s[%d] %s%s", .@killername$, .@streakname$[1], @PlayersKilledStreak, (.mapname_announcement)?("at "+ .@map$):"", .@streakname$[2]), bc_blue|.dota_bc_flag; if (.sound == 1) soundeffectall .@streakname$[0], 0, .@map$; else if (.sound == 2) soundeffectall .@streakname$[0], 0; else if (.sound == 3) soundeffect .@streakname$[0], 0; } ++@dota_multikills; deltimer "DOTAPVP::OnStreakReset"; addtimer 18000, "DOTAPVP::OnStreakReset"; query_sql sprintf("replace into pvpladder values (%d, '%s', %d, %d, %d, from_unixtime(%d)), (%d, '%s', %d, %d, %d, from_unixtime(%d))", .@killercid, escape_sql(.@killername$), @dota_sql_streaks, @dota_sql_kills, @dota_sql_deaths, @dota_sql_streaktime, .@victimcid, escape_sql(.@victimname$), .@victim_streaks, .@victim_kills, .@victim_deaths, .@victim_streaktime); if (.@killerguildid && .@killerguildid != .@victimguildid) { ++.guild_current_ownage[.@killerguildid]; if (.guild_current_ownage[.@killerguildid] > .guild_highest_ownage[.@killerguildid] ) { .guild_highest_ownage[.@killerguildid] = .guild_current_ownage[.@killerguildid]; .guild_ownage_time[.@killerguildid] = gettimetick(2); } if (.@victimguildid && .guild_highest_ownage[.@victimguildid]) query_sql sprintf("replace into ownladder values (%d, '%s', %d, %d, from_unixtime(%d)), (%d, '%s', %d, %d, from_unixtime(%d))", .@killerguildid, escape_sql(getguildname(.@killerguildid)), .guild_current_ownage[.@killerguildid], .guild_highest_ownage[.@killerguildid], .guild_ownage_time[.@killerguildid], .@victimguildid, escape_sql(getguildname(.@victimguildid)), .guild_current_ownage[.@victimguildid], .guild_highest_ownage[.@victimguildid], .guild_ownage_time[.@victimguildid]); else query_sql sprintf("replace into ownladder values (%d, '%s', %d, %d, from_unixtime(%d))", .@killerguildid, escape_sql(getguildname(.@killerguildid)), .guild_current_ownage[.@killerguildid], .guild_highest_ownage[.@killerguildid], .guild_ownage_time[.@killerguildid]); } else if (.@victimguildid && .guild_highest_ownage[.@victimguildid]) query_sql sprintf("replace into ownladder values (%d, '%s', %d, %d, from_unixtime(%d))", .@victimguildid, escape_sql(getguildname(.@victimguildid)), .guild_current_ownage[.@victimguildid], .guild_highest_ownage[.@victimguildid], .guild_ownage_time[.@victimguildid]); .@dota_multikills = @dota_multikills; sleep 1500; if (.@killerguildid && .@killerguildid != .@victimguildid && .guild_current_ownage[.@killerguildid] >= .owned && ((.guild_current_ownage[.@killerguildid] - .owned) % .owncontinue == 0)) { if ( .dota_bc_flag ) mapannounce .@map$, "The guild ["+ getguildname(.@killerguildid) +"] is OWNING["+ .guild_current_ownage[.@killerguildid] +"] !!!", bc_blue; else announce "The guild ["+ getguildname(.@killerguildid) +"] is OWNING["+ .guild_current_ownage[.@killerguildid] +"] !!!", bc_blue; if ( .sound == 1 ) soundeffectall "ownage.wav",0,.@map$; else if ( .sound == 2 ) soundeffectall "ownage.wav",0; else if ( .sound == 3 && attachrid(.@killeraid) ) soundeffect "ownage.wav",0; } sleep 1250; if (!attachrid(.@killeraid)) end; if (.@dota_multikills == 2) { if (.dota_bc_flag) mapannounce .@map$, .@killername$ +" just got a Double Kill !", bc_blue; else announce strcharinfo(0) +" just got a Double Kill !", bc_blue; if (.sound == 1) soundeffectall "doublekill.wav", 0, .@map$; else if (.sound == 2) soundeffectall "doublekill.wav", 0; else if (.sound == 3) soundeffect "doublekill.wav", 0; } else if (.@dota_multikills == 3) { if (.dota_bc_flag) mapannounce .@map$, .@killername$ +" just got a Triple Kill !!!", bc_blue; else announce strcharinfo(0) +" just got a Triple Kill !!!", bc_blue; if (.sound == 1) soundeffectall "triplekill.wav", 0, .@map$; else if (.sound == 2) soundeffectall "triplekill.wav", 0; else if (.sound == 3) soundeffect "triplekill.wav", 0; } else if (.@dota_multikills == 4) { if (.dota_bc_flag) mapannounce .@map$, .@killername$ +" just got a Ultra Kill !!!", bc_blue; else announce strcharinfo(0) +" just got a Ultra Kill !!!", bc_blue; if (.sound == 1) soundeffectall "ultrakill.wav", 0, .@map$; else if (.sound == 2) soundeffectall "ultrakill.wav", 0; else if (.sound == 3) soundeffect "ultrakill.wav", 0; } else if (.@dota_multikills >= 5) { if (.dota_bc_flag) mapannounce .@map$, .@killername$ +" is on a Rampage !!!", bc_blue; else announce strcharinfo(0) +" is on a Rampage !!!", bc_blue; if (.sound == 1) soundeffectall "rampage.wav", 0, .@map$; else if (.sound == 2) soundeffectall "rampage.wav", 0; else if (.sound == 3) soundeffect "rampage.wav", 0; } end; OnStreakReset: @dota_multikills = 0; end; OnPCLoginEvent: if (.maptrigger$ != "all") end; OnPCLoadMapEvent: if (!@dota_sql_kills && !@dota_sql_deaths) { if (.maptrigger$ != "all") { .@map$ = strcharinfo(3); while (.@i < .maptriggersize && .@map$ != .maptrigger$[.@i]) ++.@i; if (.@i == .maptriggersize) end; } query_sql "select kills, deaths, streaks, unix_timestamp(streaktime) from pvpladder where char_id = "+ getcharid(0), @dota_sql_kills, @dota_sql_deaths, @dota_sql_streaks, @dota_sql_streaktime; } .@guildid = getcharid(2); if (.@guildid && !.guild_highest_ownage[.@guildid]) { query_sql "select currentown, highestown, unix_timestamp(owntime) from ownladder where guild_id = "+ .@guildid, .@c, .@h, .@t; .guild_current_ownage[.@guildid] = .@c; .guild_highest_ownage[.@guildid] = .@h; .guild_ownage_time[.@guildid] = .@t; } end; } prontera,180,194,3 script PvP-StatsViewer 4_GEFFEN_11,{ .@npcname$ = strnpcinfo(0); while (true) { mes "["+ .@npcname$ +"]"; mes "Hello "+ strcharinfo(0) +"..."; mes "If you want to I can show you your PVP stats."; next; switch (select("Most Kills","Highest Streak","Longest Ownage","Own Information","Explanation")) { mes "["+ .@npcname$ +"]"; case 1: .@nb = query_sql("select name, kills, deaths from pvpladder order by kills desc limit "+ getvariableofnpc(.showtotal, "DOTAPVP"), .@name$, .@kills, .@deaths); if (!.@nb) { mes "The ladder currently is empty."; next; } for (.@j = 0; .@j < .@nb; .@j += getvariableofnpc(.showpage,"DOTAPVP")) { for (.@i = .@j; .@i < (getvariableofnpc(.showpage,"DOTAPVP") + .@j) && .@i < .@nb; ++.@i) mes "^996600"+ (.@i+1) +": ^006699"+ .@name$[.@i] +" ^00AA00["+ .@kills[.@i] +"] ^FF0000<"+ .@deaths[.@i] +">^000000"; next; } break; case 2: .@nb = query_sql("select name, streaks, date_format(streaktime,'%a %e/%c/%y %r') from pvpladder where streaks >= "+ getvariableofnpc(.loweststreak,"DOTAPVP") +" order by streaks desc limit "+ getvariableofnpc(.showtotal,"DOTAPVP"), .@name$, .@streak, .@time$); if (!.@nb) { mes "The ladder currently is empty."; next; } for (.@j = 0; .@j < .@nb; .@j += getvariableofnpc(.showpage,"DOTAPVP") ) { for ( .@i = .@j; .@i < (getvariableofnpc(.showpage,"DOTAPVP") + .@j) && .@i < .@nb; ++.@i) { mes "^996600"+ (.@i+1) +": ^006699"+ .@name$[.@i] +" ^70AC11{"+ .@streak[.@i] +"} ^000000on :"; mes " ^EE8800"+ .@time$[.@i] +"^000000"; } next; } break; case 3: .@nb = query_sql("select name, highestown, date_format(owntime,'%a %e/%c/%y %r') from ownladder where highestown >= "+ getvariableofnpc(.lowestownage,"DOTAPVP") +" order by highestown desc limit "+ getvariableofnpc(.showtotal,"DOTAPVP"), .@name$, .@owned, .@time$); if (!.@nb) { mes "The ladder currently is empty."; next; } for (.@j = 0; .@j < .@nb; .@j += getvariableofnpc(.showpage,"DOTAPVP")) { for (.@i = .@j; .@i < (getvariableofnpc(.showpage,"DOTAPVP") + .@j) && .@i < .@nb; ++.@i ) { mes "^996600"+ (.@i+1) +": ^006699"+ .@name$[.@i] +" ^00AAAA("+ .@owned[.@i] +") ^000000on :"; mes " ^EE8800"+ .@time$[.@i] +"^000000"; } next; } break; case 4: if (!@dota_sql_kills && !@dota_sql_deaths) query_sql "select kills, deaths, streaks, unix_timestamp(streaktime), date_format(streaktime,'%a %e/%c/%y %r') from pvpladder where char_id = "+ getcharid(0), @dota_sql_kills, @dota_sql_deaths, @dota_sql_streaks, @dota_sql_streaktime, .@time1$; else query_sql "select date_format(from_unixtime("+ @dota_sql_streaktime +"),'%a %e/%c/%y %r')", .@time1$; if (!@dota_sql_kills && !@dota_sql_deaths) mes "You not yet kill any player."; else { mes "Your Current Streak : ^70AC11{"+ @PlayersKilledStreak +"}^000000"; mes "Your Total Kills : ^00AA00["+ @dota_sql_kills +"]^000000"; mes "Your Death Counts : ^FF0000<"+ @dota_sql_deaths +">^000000"; if (@dota_sql_kills || @dota_sql_streaks) { mes "Highest Streak was ^70AC11{"+ @dota_sql_streaks +"}^000000 on :"; mes " ^EE8800"+ .@time1$ +"^000000"; } } next; .@guildid = getcharid(2); if (.@guildid) { if (!getvariableofnpc(.guild_ownage_time[.@guildid], "DOTAPVP")) { query_sql "select currentown, highestown, unix_timestamp(owntime), date_format(owntime,'%a %e/%c/%y %r') from ownladder where guild_id = "+ .@guildid, .@c, .@h, .@t, .@time2$; set getvariableofnpc(.guild_current_ownage[.@guildid], "DOTAPVP"), .@c; set getvariableofnpc(.guild_highest_ownage[.@guildid], "DOTAPVP"),.@h; set getvariableofnpc(.guild_ownage_time[.@guildid], "DOTAPVP"), .@t; } else query_sql "select date_format( from_unixtime("+ getvariableofnpc(.guild_ownage_time[.@guildid], "DOTAPVP") +"),'%a %e/%c/%y %r')", .@time2$; mes "["+ .@npcname$ +"]"; if (!getvariableofnpc(.guild_ownage_time[.@guildid], "DOTAPVP")) { mes "Your guild not yet kill any player."; } else { mes "Your guild name : ^006699"+ strcharinfo(2) +"^000000"; mes "Current Owning : ^00AAAA("+ getvariableofnpc(.guild_current_ownage[.@guildid], "DOTAPVP") +")^000000"; mes "Longest Ownage was ^00AAAA("+ getvariableofnpc(.guild_highest_ownage[.@guildid], "DOTAPVP") + ")^000000 on :"; mes " ^EE8800"+ .@time2$ +"^000000"; } next; } break; case 5: mes "Explanation for Most Kills:"; mes " "; mes "^996600Rank. ^006699NAME ^00AA00[Total Kills] ^FF0000<Deaths>^000000"; mes " "; mes "--------------------------------"; mes " "; mes "The ^00AA00Kills^000000 added when a player kills another player."; mes " "; mes "^FF0000Deaths^000000 count increase when a player killed by another player, or suicide (eg: Grand Cross)."; mes " "; mes "A player killed by monsters, homunculus or pets will not add the kills or deaths count."; next; mes "["+ .@npcname$ +"]"; mes "Explanation for Highest Streak:"; mes " "; mes "^996600Rank. ^006699NAME ^70AC11{Highest Streak} ^000000on :"; mes " ^EE8800TIME^000000"; mes " "; mes "--------------------------------"; mes " "; mes "The ^70AC11Streak^000000 are added every time a player kills another player. It will reset upon log out, killed by another player, or suicide (eg: Sacrifice)."; mes " "; mes "Then it record in the server the ^EE8800TIME^000000 when that player got that highest streak."; mes " "; mes "A player killed by monsters, homunculus or pets will not reset the streak."; mes " "; mes "--------------------------------"; mes " "; mes "The numbers of straight kills to get these announcements are :"; mes "^70AC11"+ getvariableofnpc(.killingspree,"DOTAPVP") +"^000000 : Killing Spree"; mes "^70AC11"+ getvariableofnpc(.dominating,"DOTAPVP") +"^000000 : Dominating"; mes "^70AC11"+ getvariableofnpc(.megakill,"DOTAPVP") +"^000000 : Mega Kill"; mes "^70AC11"+ getvariableofnpc(.unstoppable,"DOTAPVP") +"^000000 : Unstoppable"; mes "^70AC11"+ getvariableofnpc(.wickedsick,"DOTAPVP") +"^000000 : Wicked Sick"; mes "^70AC11"+ getvariableofnpc(.monsterkill,"DOTAPVP") +"^000000 : Monster Kill"; mes "^70AC11"+ getvariableofnpc(.godlike,"DOTAPVP") +"^000000 : Godlike"; mes "^70AC11"+ getvariableofnpc(.holyshit,"DOTAPVP") +"^000000 : Beyond Godlike"; next; mes "["+ .@npcname$ +"]"; mes "Explanation for Longest Ownage:"; mes " "; mes "^996600Rank. ^006699NAME ^00AAAA(Longest Ownage) ^000000on :"; mes " ^EE8800TIME^000000"; mes " "; mes "--------------------------------"; mes " "; mes "The ^00AAAAOwnage^000000 added every time any guild members killed another player that doesn't belong to his/her guild. It will reset when any of the guild member was killed by ANY player, including his/her guild member."; mes " "; mes "Then it record in the server the ^EE8800TIME^000000 when the guild got that longest ownage."; mes " "; mes "If the server went under maintainance, the current ownage will survive after the server restart."; mes " "; mes "Any guild member killed by monster, homunculus or pets will not reset the ownage count."; next; if (getvariableofnpc(.lvltokill,"DOTAPVP")) { mes "["+ .@npcname$ +"]"; mes "You must kill another player with minimum base level of "+ getvariableofnpc(.lvltokill,"DOTAPVP") +", in order to get an announcement or get in the ladder."; mes " "; mes "It's possible for a base level 1 novice kills a base level 99 player and still can get in the ladder."; mes "However when a player level 99 kills a level 1 novice will get nothing."; next; } if (getvariableofnpc(.counttopunish,"DOTAPVP")) { mes "["+ .@npcname$ +"]"; mes "Some noob players try to kill the same person over and over again in hope of getting his/her name appear in the ladder."; mes "However if you trying to do the same thing on this ladder, your name will announce to the public, and your action will be recorded into the server to notify the GMs."; next; } if (getvariableofnpc(.minlvlrange,"DOTAPVP")) { mes "["+ .@npcname$ +"]"; mes "When you kill another player thats lower base level than you, the base level gap between you and that player must not more than "+ getvariableofnpc(.minlvlrange,"DOTAPVP") +"."; mes " "; if (getvariableofnpc(.minlvlrange,"DOTAPVP") >= 200) mes "In other words, if your base level is 500, the player you killed must be at least level "+(500 - getvariableofnpc(.minlvlrange,"DOTAPVP"))+" then only you will get the announcement and in the ladder."; else if (getvariableofnpc(.minlvlrange,"DOTAPVP") >= 70) mes "In other words, if your base level is 255, the player you killed must be at least level "+(255 - getvariableofnpc(.minlvlrange,"DOTAPVP"))+" then only you will get the announcement and in the ladder."; else mes "In other words, if your base level is 99, the player you killed must be at least level "+(99 - getvariableofnpc(.minlvlrange,"DOTAPVP"))+" then only you will get the announcement and in the ladder."; mes "Higher base level kills lower level gets nothing, however lower level player kills higher level will get the announcement."; next; } break; } } } - script pvp_ladder_statue FAKE_NPC,{ .@id = getelementofarray(getvariableofnpc(.npcgid, "DOTAPVP"), getnpcid(0)); mes "^996600[TOP "+ .@id +"]"; mes "^006699Name : "+ getelementofarray(getvariableofnpc(.statue_name$, "DOTAPVP"), .@id); .@guildname$ = getelementofarray(getvariableofnpc(.statue_guild$, "DOTAPVP"), .@id); mes "^00AAAAGuild : "+((.@guildname$ == "null")? "^AAAAAANone": .@guildname$); mes "^00AA00Total Kills : ["+ getelementofarray(getvariableofnpc(.statue_kills, "DOTAPVP"), .@id) +"]"; mes "^70AC11Highest Streaks : ["+ getelementofarray(getvariableofnpc(.statue_streaks, "DOTAPVP"), .@id) +"]"; mes "^FF0000Deaths : <"+ getelementofarray(getvariableofnpc(.statue_deaths, "DOTAPVP"), .@id) +">"; close; OnInit: .@id = strnpcinfo(2); set getvariableofnpc(.statue[.@id], "DOTAPVP"), getnpcid(0); set getvariableofnpc(.npcgid[getnpcid(0)], "DOTAPVP"), .@id; end; } prontera,138,170,4 duplicate(pvp_ladder_statue) pvp_ladder_statue#1 1_F_MARIA prontera,135,168,4 duplicate(pvp_ladder_statue) pvp_ladder_statue#2 1_F_MARIA prontera,141,168,4 duplicate(pvp_ladder_statue) pvp_ladder_statue#3 1_F_MARIA prontera,87,141,4 duplicate(pvp_ladder_statue) pvp_ladder_statue#4 1_F_MARIA prontera,88,145,4 duplicate(pvp_ladder_statue) pvp_ladder_statue#5 1_F_MARIA prontera,83,144,4 duplicate(pvp_ladder_statue) pvp_ladder_statue#6 1_F_MARIA prontera,89,150,4 duplicate(pvp_ladder_statue) pvp_ladder_statue#7 1_F_MARIA prontera,90,154,4 duplicate(pvp_ladder_statue) pvp_ladder_statue#8 1_F_MARIA prontera,93,158,4 duplicate(pvp_ladder_statue) pvp_ladder_statue#9 1_F_MARIA prontera,96,160,4 duplicate(pvp_ladder_statue) pvp_ladder_statue#10 1_F_MARIA 1pvpladder.txt

Yes Thank you...!! Added 1 "," and worked xD

Hello If this topic is in wrong section please move it but Guide me whats wrong in this? 1848,EVENT Baphomet@WZ_VERMILION,chase,85,21,2000,1000,5000,no,target,always,0,,,,,,, [Error]: sv_readdb: Insufficient columns in line 5857 of "db/pre-re/mob_skill_db.txt" (found 18, need at least 19).

Hellow Everyone...!! Can any 1 guide me to solve this ? its My offline server [SQL]: DB error - Unknown column 'unique_id' in 'field list' [Debug]: at F:\rAthena\src\login\loginlog.cpp:96 - INSERT INTO `loginlog`(`time`,`ip`,`user`,`rcode`, `unique_id`,`log`) VALUES (NOW(), '0.0.0.0', 'login server', '100', '0', 'login server started') [Info]: Connection request of the char-server 'NostalgicRO' @ 127.0.0.1:6121 (account: 'user1', ip: '127.0.0.1') [SQL]: DB error - Unknown column 'unique_id' in 'field list' [Debug]: at F:\rAthena\src\login\loginlog.cpp:96 - INSERT INTO `loginlog`(`time`,`ip`,`user`,`rcode`, `unique_id`,`log`) VALUES (NOW(), '127.0.0.1', 'user1', '100', '0', 'charserver - [email protected]:6121') [Notice]: Authentication accepted (account: user1, id: 1, ip: 127.0.0.1)

Dear sir I've added item list but can't see any shop //ADD YOUR ITEMS HERE - pointshop KOEPOINTS -1,#KOEPOINTS,501:1,13259:50,13258:50,13257:50,7521:150,7522:150,7523:150,7524:250 I'm Sorry I'm not aware of Code BOX.

Hellow Sir can u explain what changes u did i checked whole script didn't see any changes expect announcement line Can u explain a bit so i can solve it if i face this issue Thank you ? When i tested ur solution i got this error in CMD

Hellow Everyone...!! Can any one guide me how to enable KOE point shop According to this its not working Can some 1 guide here? - script KoE Shop 590,{ mes "[ KOE POINTS ]"; mes "You can spend your KOE Points here"; mes "^FFFFFF_^000000"; set #KOEPOINTS,(#KOEPOINTS+@KOEPOINTS); set @KOEPOINTS,0; mes "You current points: ^0000FF"+#KOEPOINTS+"^000000"; callshop "KOEPOINTS",1; end; } //ADD YOUR ITEMS HERE - pointshop KOEPOINTS -1,#KOEPOINTS,501:1 // Flags - script ::koe_flag GUILD_FLAG,{ if (!getd("$koe_"+strnpcinfo(2))) end; mes "[King of Emperium Hill]"; mes "The Current King of Emperium Hill at ^0055FF"+strnpcinfo(1)+"^000000 is the [ ^0055FF"+ getguildname(getd("$koe_"+strnpcinfo(2))) +"^000000 ] guild."; close; OnAgitInit: //Uncomment this line to make the emblem stay after @reloadscript OnRevKoE: if(getd("$koe_"+strnpcinfo(2))) flagemblem getd("$koe_"+strnpcinfo(2)); end; }

Hello Everyone I've Notice this error pop ups in CMD when player get rewards [Error]: buildin_strcharinfo: fatal error ! player not attached! [Debug]: Function: strcharinfo (1 parameter): [Debug]: Data: number value=0 [Debug]: Source (NPC): Invasion NPC at prontera (155,185) Can some explain or guide how to fix this? Thank you... //================================================Name====================================================== // Goblin Invasion NPC (Official Release Name) //===============================================Version==================================================== // 1.2 //===============================================Author===================================================== // ____ _____ ______ __ __ __ _______ __ _____ __ __ _______ // | __ \ _ \| __ \| | \ | |/ ___ \ | | / / | \ | |/ ___ \ // | |__| | \ \ |__| | | \| | | _\_/ | |/ /| | \| | | _\_/ // | __/ | | /| | | | |_ \ | | | | | | | |_ \ // | |\ \_/ / |\ \| | |\ | \_/ | | |\ \| | |\ | \_/ | // |__| \_____/|__| \__\__|__| \__|\______/ |__| \__\__|__| \__|\______/ //----------------------------------------Script Last Update 2020------------------------------------------- //==============================================Changelog=================================================== // 1.0 * // - Initial Release // 1.1 // - Added Host Event by GMAccess // 1.2 // - Remove all error from Latest rAthena // - Maximize script // - Fix some dialog of NPC // - Added Mapflag for the Event Map //========================================================================================================== prontera,155,185,6 script Invasion NPC 459,{ set .gm,50;//GM Level to access the GM Menu. Default: 50 // GM menu //It allows GMs Level 50 or more to Start and Stop invasions. if (getgmlevel()>.gm) { if (.mobs_left) { mes "[Invasion]"; mes "An invasion is in progress.."; mes "Location: " + .Map$; mes "^FF0000"+.mobs_left+"^000000 Goblins left"; mes " "; mes "Stop invasion?"; if(select("No:Yes")==1) close; donpcevent "Invasion NPC::OnTimer1805000"; mes "Invasion stopped"; announce "The Invasion has been stopped by "+strcharinfo(0),bc_all; close; } mes "[Invasion]"; mes "Please customize the Invasion event before starting it."; mes "Note - The Goblin Leader drops x5 of the prize."; Main: next; mes "[Invasion]"; switch(select("Item [" + getitemname(.ItemID) + "]:Start Event")) { case 1: mes "Which item would you like the Goblin Leader to drop?"; mes "Please input the item ID:"; input .ItemID; goto Main; case 2: mes "Starting the event now..."; close2; goto OnStart; } // If a player clicks the NPC, it displays: mes "[Invasion]"; mes .mobs_left+" have invaded "+.Map$[.rand_map]+"!"; close; ///////////////////////// //The actual NPC Script// ///////////////////////// OnMinute50: // Change this to your liking OnStart: set .mobs_left, 1; sleep 1000; set $@ran, rand(1,6); if ($@ran == 6) set .Map$,"guild_vs3"; if ($@ran == 5) set .Map$,"guild_vs3"; if ($@ran == 4) set .Map$,"guild_vs3"; if ($@ran == 3) set .Map$,"guild_vs3"; if ($@ran == 2) set .Map$,"guild_vs3"; if ($@ran == 1) set .Map$,"guild_vs3"; sleep 1000; announce "[ Rune-Midgard Guard ]: We have trouble here in the town " + .Map$ + "!", bc_all; sleep 5000; announce "[ Rune-Midgard Guard ]: Everyone, we need your help to get rid of these Goblins!", bc_all; monster .Map$,0,0,"Goblin",1258,10,"Invasion NPC::OnMyMobDead"; monster .Map$,0,0,"Goblin",1299,1,"Invasion NPC::OnMyMobDead"; set .mobs_left, 11; end; OnTimer1805000: // 30 minutes later, kills all the mobs. killmonster .Map$,"Invasion NPC::OnMyMobDead"; set .mobs_left, 0; OnStop://When the event is stopped by a GM, or all monsters dead. killmonster .Map$,"Invasion NPC::OnMyMobDead"; killmonster .Map$,"Invasion NPC::OnSpecialMobDead"; announce "It seems that "+strcharinfo(0)+" has ended the Invasion!",bc_all; end; OnMyMobDead: //When a Goblin is killed set .mobs_left, .mobs_left-1; if (.mobs_left==0) { announce "[ Rune-Midgard Guard ]: Everyone, thankyou for helping to get rid of these Goblins!", bc_all; getitem .ItemID,20; //Change the [5] to the amount you wish to hand out. donpcevent "Invasion NPC::OnStop"; //announce "[Invasion NPC]: "+strcharinfo(0)+" has killed the last "+.mobname$+".",bc_all; } else { //announce "["+.mobs_left+"/200] Goblins left.",bc_map; //announce "["+.mobs_left+"-"+200+"="+.mobs_left+"] Goblins left.",bc_map; //announce "[("+.mobs_left+")-(200)="+.mobs_left+"] Goblins left.",bc_map; announce "[ "+strcharinfo(0)+" ] has killed a Goblin. There are now "+.mobs_left+" Goblin left.",bc_map; } end; } end; }

I tried your solution..!! now this error in CMD [Error]: buildin_getitem: Player with map id '2000013' is not found. [Warning]: Unexpected type for argument 1. Expected string. [Debug]: Data: variable name='prontera' index=0 [Debug]: Function: warpparty [Debug]: Source (NPC): Alon Event Warper at prontera (132,190) [Error]: get_val_: fatal error ! player not attached! [Debug]: Function: warpparty (4 parameters): [Debug]: Data: variable name='prontera' index=0 [Debug]: Data: number value=156 [Debug]: Data: number value=191 [Debug]: Data: variable name='.@pid' index=0 [Debug]: Source (NPC): Alon Event Warper at prontera (132,190)

Hello Everyone, I'm looking for guide n script where can use special woe supplies like WoE Ad bottles which should be usable in Castle only. Should not be used outside castle to avoid miss use. Can any 1 guide?

Hello Everyone...!! I'm getting this error in CMD when wave 10 is over they get rewards but they don't get auto warp out. [Error]: buildin_getcharid: fatal error ! player not attached! [Debug]: Function: getcharid (1 parameter): [Debug]: Data: number value=1 [Debug]: Source (NPC): Alon Event Warper at prontera (132,190) 2nd Error for Announcement issue so i've commented out. [Error]: buildin_announce: fatal error ! player not attached! [Debug]: Function: announce (2 parameters): [Debug]: Data: string value="Alon Event Employee: Well done. All the monster are dead!" [Debug]: Data: number value=1 [Debug]: Source (NPC): Alon Event Warper at prontera (132,190) Can Any one guide to fix? Thanks in advance..!! //================================================Name===================================================== // Alon Event Tagalog (Official Release Name) // Wave Event English //===============================================Version=================================================== // 1.4 //===============================================Author==================================================== // ____ _____ ______ __ __ __ _______ __ _____ __ __ _______ // | __ \ _ \| __ \| | \ | |/ ___ \ | | / / | \ | |/ ___ \ // | |__| | \ \ |__| | | \| | | _\_/ | |/ /| | \| | | _\_/ // | __/ | | /| | | | |_ \ | | | | | | | |_ \ // | |\ \_/ / |\ \| | |\ | \_/ | | |\ \| | |\ | \_/ | // |__| \_____/|__| \__\__|__| \__|\______/ |__| \__\__|__| \__|\______/ //----------------------------------------Script Last Update 2020------------------------------------------- //==============================================Changelog=================================================== // 1.0 * // - Initial Release // 1.1 // - Added Host Event by GMAccess // - Fix bug during onclocktime initiation // 1.2 // - Maximize script // - Fix some dialog of NPC // - Added Mapflag for the Event Map // 1.3 // - Fix script behavior // 1.4 // - Remove all error from Latest rAthena //========================================================================================================== prontera,132,190,6 script Alon Event Warper 421,{ set .@GMAccess,90; // required GM Level to access if( .AEventOpen == 0) goto EventClose; mes "[ Alon ]"; mes "Alon Event is now open. You need to be in a party with "+.PartyMember+" members to enter. Good luck!"; next; switch(select("Register","Exit")){ case 1: if( .ARegister == 1) goto AlreadyStarted; if ( getcharid(1) == 0 ) { goto DeniedToTalkIfNoParty; } if ( getpartyleader( getcharid(1), 2 ) != getcharid(0) ) { goto DeniedMemberToRegister; } getpartymember getcharid(1), 1; if ( $@partymembercount < .PartyMember ) { goto CheckMemberSize; } getpartymember getcharid(1), 2; set @Count,0; for ( set .@i, 0; .@i < $@partymembercount; set .@i, .@i +1 ){ if ( isloggedin($@partymemberaid[.@i]) ){ set @Count,@Count+1; } } if( @Count < .PartyMember ) goto CheckIfAllMemberOnline; announce ""+getpartyname( getcharid(1) )+" party has started Alon Event",bc_all; warpparty .Map$,0,0,getcharid(1); set .ARegister,1; sleep 10000; mapannounce "pvp_n_1-5","Alon Event Employee: Welcome to Alon Event.",bc_map; sleep 7500; mapannounce "pvp_n_1-5","Alon Event Employee: Every time the round increase and you manage to reach, the monster could be stronger than before.",bc_map; sleep 7500; mapannounce "pvp_n_1-5","Alon Event Employee: You could win up some Unique prize upon you finished the whole event.",bc_map; sleep 7500; mapannounce "pvp_n_1-5","Alon Event Employee: So what are we waiting for?",bc_map; sleep 7500; mapannounce "pvp_n_1-5","Wave 1!",bc_map; sleep 7500; goto Wave1; case 2: close; } Wave1: monster "pvp_n_1-5",0,0,"--ja--",1200,1,"Alon Event Warper::OnWave1"; monster "pvp_n_1-5",0,0,"--ja--",1618,1,"Alon Event Warper::OnWave1"; monster "pvp_n_1-5",0,0,"--ja--",1262,1,"Alon Event Warper::OnWave1"; monster "pvp_n_1-5",0,0,"--ja--",1205,1,"Alon Event Warper::OnWave1"; monster "pvp_n_1-5",0,0,"--ja--",1203,1,"Alon Event Warper::OnWave1"; monster "pvp_n_1-5",0,0,"--ja--",1204,1,"Alon Event Warper::OnWave1"; monster "pvp_n_1-5",0,0,"--ja--",1076,10,"Alon Event Warper::OnWave1"; monster "pvp_n_1-5",0,0,"--ja--",1053,10,"Alon Event Warper::OnWave1"; monster "pvp_n_1-5",0,0,"--ja--",1249,10,"Alon Event Warper::OnWave1"; monster "pvp_n_1-5",0,0,"--ja--",1247,10,"Alon Event Warper::OnWave1"; monster "pvp_n_1-5",0,0,"--ja--",1161,10,"Alon Event Warper::OnWave1"; monster "pvp_n_1-5",0,0,"--ja--",1951,10,"Alon Event Warper::OnWave1"; monster "pvp_n_1-5",0,0,"--ja--",1010,10,"Alon Event Warper::OnWave1"; monster "pvp_n_1-5",0,0,"--ja--",1083,10,"Alon Event Warper::OnWave1"; monster "pvp_n_1-5",0,0,"--ja--",1240,10,"Alon Event Warper::OnWave1"; monster "pvp_n_1-5",0,0,"--ja--",1089,10,"Alon Event Warper::OnWave1"; monster "pvp_n_1-5",0,0,"--ja--",1090,1,"Alon Event Warper::OnWave1"; set .wave1,107; end; Wave2: monster "pvp_n_1-5",0,0,"--ja--",1039,1,"Alon Event Warper::OnWave2"; monster "pvp_n_1-5",0,0,"--ja--",1096,1,"Alon Event Warper::OnWave2"; monster "pvp_n_1-5",0,0,"--ja--",1059,1,"Alon Event Warper::OnWave2"; monster "pvp_n_1-5",0,0,"--ja--",1582,1,"Alon Event Warper::OnWave2"; monster "pvp_n_1-5",0,0,"--ja--",1785,1,"Alon Event Warper::OnWave2"; monster "pvp_n_1-5",0,0,"--ja--",1073,10,"Alon Event Warper::OnWave2"; monster "pvp_n_1-5",0,0,"--ja--",1033,10,"Alon Event Warper::OnWave2"; monster "pvp_n_1-5",0,0,"--ja--",1176,10,"Alon Event Warper::OnWave2"; monster "pvp_n_1-5",0,0,"--ja--",1120,10,"Alon Event Warper::OnWave2"; monster "pvp_n_1-5",0,0,"--ja--",1870,10,"Alon Event Warper::OnWave2"; monster "pvp_n_1-5",0,0,"--ja--",1974,10,"Alon Event Warper::OnWave2"; monster "pvp_n_1-5",0,0,"--ja--",1975,10,"Alon Event Warper::OnWave2"; monster "pvp_n_1-5",0,0,"--ja--",1706,10,"Alon Event Warper::OnWave2"; monster "pvp_n_1-5",0,0,"--ja--",1379,10,"Alon Event Warper::OnWave2"; monster "pvp_n_1-5",0,0,"--ja--",1096,1,"Alon Event Warper::OnWave2"; set .wave1,96; end; Wave3: monster "pvp_n_1-5",0,0,"--ja--",1252,1,"Alon Event Warper::OnWave3"; monster "pvp_n_1-5",0,0,"--ja--",1389,1,"Alon Event Warper::OnWave3"; monster "pvp_n_1-5",0,0,"--ja--",1046,1,"Alon Event Warper::OnWave3"; monster "pvp_n_1-5",0,0,"--ja--",1120,1,"Alon Event Warper::OnWave3"; monster "pvp_n_1-5",0,0,"--ja--",1866,10,"Alon Event Warper::OnWave3"; monster "pvp_n_1-5",0,0,"--ja--",1867,10,"Alon Event Warper::OnWave3"; monster "pvp_n_1-5",0,0,"--ja--",1868,10,"Alon Event Warper::OnWave3"; monster "pvp_n_1-5",0,0,"--ja--",1869,10,"Alon Event Warper::OnWave3"; monster "pvp_n_1-5",0,0,"--ja--",1870,10,"Alon Event Warper::OnWave3"; monster "pvp_n_1-5",0,0,"--ja--",1974,10,"Alon Event Warper::OnWave3"; monster "pvp_n_1-5",0,0,"--ja--",1036,10,"Alon Event Warper::OnWave3"; monster "pvp_n_1-5",0,0,"--ja--",1153,10,"Alon Event Warper::OnWave3"; monster "pvp_n_1-5",0,0,"--ja--",1865,10,"Alon Event Warper::OnWave3"; monster "pvp_n_1-5",0,0,"--ja--",1015,10,"Alon Event Warper::OnWave3"; monster "pvp_n_1-5",0,0,"--ja--",1871,1,"Alon Event Warper::OnWave3"; monster "pvp_n_1-5",0,0,"--ja--",1647,1,"Alon Event Warper::OnWave3"; set .wave1,106; end; Wave4: monster "pvp_n_1-5",0,0,"--ja--",1115,1,"Alon Event Warper::OnWave4"; monster "pvp_n_1-5",0,0,"--ja--",1038,1,"Alon Event Warper::OnWave4"; monster "pvp_n_1-5",0,0,"--ja--",1150,1,"Alon Event Warper::OnWave4"; monster "pvp_n_1-5",0,0,"--ja--",1157,1,"Alon Event Warper::OnWave4"; monster "pvp_n_1-5",0,0,"--ja--",1657,10,"Alon Event Warper::OnWave4"; monster "pvp_n_1-5",0,0,"--ja--",1656,10,"Alon Event Warper::OnWave4"; monster "pvp_n_1-5",0,0,"--ja--",1655,10,"Alon Event Warper::OnWave4"; monster "pvp_n_1-5",0,0,"--ja--",1654,10,"Alon Event Warper::OnWave4"; monster "pvp_n_1-5",0,0,"--ja--",1653,10,"Alon Event Warper::OnWave4"; monster "pvp_n_1-5",0,0,"--ja--",1682,10,"Alon Event Warper::OnWave4"; monster "pvp_n_1-5",0,0,"--ja--",1681,10,"Alon Event Warper::OnWave4"; monster "pvp_n_1-5",0,0,"--ja--",1613,10,"Alon Event Warper::OnWave4"; monster "pvp_n_1-5",0,0,"--ja--",1613,10,"Alon Event Warper::OnWave4"; monster "pvp_n_1-5",0,0,"--ja--",1261,10,"Alon Event Warper::OnWave4"; monster "pvp_n_1-5",0,0,"--ja--",1658,1,"Alon Event Warper::OnWave4"; monster "pvp_n_1-5",0,0,"--ja--",1646,1,"Alon Event Warper::OnWave4"; set .wave1,106; end; Wave5: monster "pvp_n_1-5",0,0,"--ja--",1648,1,"Alon Event Warper::OnWave5"; monster "pvp_n_1-5",0,0,"--ja--",1112,1,"Alon Event Warper::OnWave5"; monster "pvp_n_1-5",0,0,"--ja--",1518,1,"Alon Event Warper::OnWave5"; monster "pvp_n_1-5",0,0,"--ja--",1388,1,"Alon Event Warper::OnWave5"; monster "pvp_n_1-5",0,0,"--ja--",1251,1,"Alon Event Warper::OnWave5"; monster "pvp_n_1-5",0,0,"--ja--",1955,10,"Alon Event Warper::OnWave5"; set .wave1,15; end; Wave6: monster "pvp_n_1-5",0,0,"--ja--",1649,1,"Alon Event Warper::OnWave6"; monster "pvp_n_1-5",0,0,"--ja--",1087,1,"Alon Event Warper::OnWave6"; monster "pvp_n_1-5",0,0,"--ja--",1373,1,"Alon Event Warper::OnWave6"; monster "pvp_n_1-5",0,0,"--ja--",1492,1,"Alon Event Warper::OnWave6"; monster "pvp_n_1-5",0,0,"--ja--",1688,1,"Alon Event Warper::OnWave6"; set .wave1,5; end; Wave7: monster "pvp_n_1-5",0,0,"--ja--",1650,1,"Alon Event Warper::OnWave7"; monster "pvp_n_1-5",0,0,"--ja--",1719,1,"Alon Event Warper::OnWave7"; monster "pvp_n_1-5",0,0,"--ja--",1685,1,"Alon Event Warper::OnWave7"; monster "pvp_n_1-5",0,0,"--ja--",1190,1,"Alon Event Warper::OnWave7"; monster "pvp_n_1-5",0,0,"--ja--",1272,1,"Alon Event Warper::OnWave7"; set .wave1,5; end; Wave8: monster "pvp_n_1-5",0,0,"--ja--",1651,1,"Alon Event Warper::OnWave8"; monster "pvp_n_1-5",0,0,"--ja--",1623,1,"Alon Event Warper::OnWave8"; monster "pvp_n_1-5",0,0,"--ja--",1086,1,"Alon Event Warper::OnWave8"; monster "pvp_n_1-5",0,0,"--ja--",1159,1,"Alon Event Warper::OnWave8"; monster "pvp_n_1-5",0,0,"--ja--",1289,1,"Alon Event Warper::OnWave8"; set .wave1,5; end; Wave9: monster "pvp_n_1-5",0,0,"--ja--",1646,1,"Alon Event Warper::OnWave9"; monster "pvp_n_1-5",0,0,"--ja--",1647,1,"Alon Event Warper::OnWave9"; monster "pvp_n_1-5",0,0,"--ja--",1648,1,"Alon Event Warper::OnWave9"; monster "pvp_n_1-5",0,0,"--ja--",1649,1,"Alon Event Warper::OnWave9"; monster "pvp_n_1-5",0,0,"--ja--",1650,1,"Alon Event Warper::OnWave9"; monster "pvp_n_1-5",0,0,"--ja--",1651,1,"Alon Event Warper::OnWave9"; monster "pvp_n_1-5",0,0,"--ja--",1147,1,"Alon Event Warper::OnWave9"; monster "pvp_n_1-5",0,0,"--ja--",1312,1,"Alon Event Warper::OnWave9"; monster "pvp_n_1-5",0,0,"--ja--",1418,1,"Alon Event Warper::OnWave9"; monster "pvp_n_1-5",0,0,"--ja--",1511,1,"Alon Event Warper::OnWave9"; monster "pvp_n_1-5",0,0,"--ja--",1583,1,"Alon Event Warper::OnWave9"; monster "pvp_n_1-5",0,0,"--ja--",1751,1,"Alon Event Warper::OnWave9"; monster "pvp_n_1-5",0,0,"--ja--",1832,1,"Alon Event Warper::OnWave9"; monster "pvp_n_1-5",0,0,"--ja--",1873,1,"Alon Event Warper::OnWave9"; monster "pvp_n_1-5",0,0,"--ja--",1779,1,"Alon Event Warper::OnWave9"; set .wave1,4; end; Wave10: monster "pvp_n_1-5",0,0,"--ja--",1955,10,"Alon Event Warper::OnWave10"; set .wave1,10; end; OnWave1: set .wave1, .wave1 -1; if (.wave1 == 0) { //announce "Alon Event Employee: Well done. All the monster are dead!",bc_map; sleep 2500; mapannounce "pvp_n_1-5","Wave 2!",bc_map; sleep 2500; goto Wave2; } end; OnWave2: set .wave1, .wave1 -1; if (.wave1 == 0) { //announce "Alon Event Employee: Well done. All the monster are dead!",bc_map; sleep 2500; mapannounce "pvp_n_1-5","Wave 3!",bc_map; sleep 2500; goto Wave3; } end; OnWave3: set .wave1, .wave1 -1; if (.wave1 == 0) { //announce "Alon Event Employee: Well done. All the monster are dead!",bc_map; sleep 2500; mapannounce "pvp_n_1-5","Wave 4!",bc_map; sleep 2500; goto Wave4; } end; OnWave4: set .wave1, .wave1 -1; if (.wave1 == 0) { //announce "Alon Event Employee: Well done. All the monster are dead!",bc_map; sleep 2500; mapannounce "pvp_n_1-5","Wave 5!",bc_map; sleep 2500; goto Wave5; } end; OnWave5: set .wave1, .wave1 -1; if (.wave1 == 0) { //announce "Alon Event Employee: Well done. All the monster are dead!",bc_map; sleep 2500; mapannounce "pvp_n_1-5","Wave 6!",bc_map; sleep 2500; goto Wave6; } end; OnWave6: set .wave1, .wave1 -1; if (.wave1 == 0) { //announce "Alon Event Employee: Well done. All the monster are dead!",bc_map; sleep 2500; mapannounce "pvp_n_1-5","Wave 7!",bc_map; sleep 2500; goto Wave7; } end; OnWave7: set .wave1, .wave1 -1; if (.wave1 == 0) { //announce "Alon Event Employee: Well done. All the monster are dead!",bc_map; sleep 2500; mapannounce "pvp_n_1-5","Wave 8!",bc_map; sleep 2500; goto Wave8; } end; OnWave8: set .wave1, .wave1 -1; if (.wave1 == 0) { //announce "Alon Event Employee: Well done. All the monster are dead!",bc_map; sleep 2500; mapannounce "pvp_n_1-5","Wave 9!",bc_map; sleep 2500; goto Wave9; } end; OnWave9: set .wave1, .wave1 -1; if (.wave1 == 0) { //announce "Alon Event Employee: Well done. All the monster are dead!",bc_map; sleep 2500; mapannounce "pvp_n_1-5","Wave 10!",bc_map; sleep 2500; goto Wave10; } end; OnWave10: set .wave1, .wave1 -1; if (.wave1 == 0) { //announce "Yeehaaa !! We Beat ALL the Monster!!!",bc_map; sleep 5000; //announce "Congratulation to Team [ "+getpartyname( getcharid(1) )+" ] who had just finished the Alon Event. ",0; for ( .@i = 0; .@i < $@partymembercount; .@i++ ) getitem 7227, 1, $@partymemberaid[.@i]; warpparty prontera,156,191,getcharid(1); set .AEventOpen,0; set .ARegister,0; } end; //---------------------------------------------------------NPC Check Message Here------------------------------------------------------------ EventOpen: mes "[ Alon ]"; mes "Alon event are still open."; close; EventClose: mes "[ Alon ]"; mes "Alon Event are currently close please try again later."; close; AlreadyStarted: mes "[ Alon ]"; mes ""+getpartyname( getcharid(1) )+" already inside the event."; close; DeniedToTalkIfNoParty: mes "[ Alon ]"; mes "You must be in a party to be able to register."; close; DeniedMemberToRegister: mes "[ Alon ]"; mes "Sorry you are not eligible to register your party."; close; CheckMemberSize: mes "[ Alon ]"; mes "Please check your party again. You must have party of "+ .PartyMember +" to be able to register."; close; CheckIfAllMemberOnline: mes "[ Alon ]"; mes "You must have "+ .PartyMember +" party members online to be able to complete the registration."; close; //-----------------------------------------------------------End of NPC Message------------------------------------------------------------ OnClock0800: OnClock1306: OnClock2000: announce "Alon Event are now Open for Registration!.",bc_all; set .AEventOpen,1; set .ARegister,0; end; OnInit: set .PartyMember,2; set .Map$,"pvp_n_1-5"; // Dont try to edit this if you dont know what are you doing by Poring King set .AEventOpen,0; set .ARegister,0; } pvp_n_1-5 mapflag noloot pvp_n_1-5 mapflag nomobloot pvp_n_1-5 mapflag nomvploot pvp_n_1-5 mapflag pvp off pvp_n_1-5 mapflag noexp pvp_n_1-5 mapflag nobaseexp pvp_n_1-5 mapflag nojobexp alon-event.txt

Thank you so much sir..!!! ur great..!!

I've added Map but seems doesn't working his spawning on same map Prontera ?

Thank you so much sir so many ways to do amazing ? Thank you so much Sir 1 NPC dedicated on your name small appreciation ??? by this script i faced this error in CMD how to solve? [Error]: Loading NPC file: npc/custom/NEWGpackNPC.txt script error on npc/custom/NEWGpackNPC.txt line 18 parse_simpleexpr: unmatched ')' 13 : if (gettime(DT_DAYOFWEEK) == TUESDAY 14 : || gettime(DT_DAYOFWEEK) == THURSDAY 15 : || gettime(DT_DAYOFWEEK) == SUNDAY 16 : ) { 17 : if (gettime(DT_HOUR) == 17 || (gettime(DT_HOUR) == 18 && gettime(DT_MINUTE) <= 30) * 18 : 'h'ideoffnpc strnpcinfo(3); 19 : } 20 : end; 21 : 22 : } 23 :

Hello Everyone, Need some guide to fix MVP only spawn at Prontera doesn't spawn in different map can some 1 guide to fix? Thanks in advance..!!! //================================================================// // World Boss Script // Created by PottScilgrim //================================================================// - script WorldBossEvent -1,{ //================================================================// // Change the "OnClock" times to be when you want the event to begin //================================================================// //OnClock<hour><minute>: //OnMinute<minute>: //OnHour<hour>: //On<weekday><hour><minute>: //OnDay<month><day>: OnClock0005: OnClock0200: OnClock0400: OnClock0600: OnClock0800: OnClock1000: OnClock1200: OnClock1400: OnClock1600: OnClock1800: OnClock2000: OnClock2200: if(.WBMAPS$[1] == "") { if(.WBMOBID[1] == 0){ monster .WBMAPS$[0],0,0,"[World Boss]",.WBMOBID[0],1,"WorldBossEvent::OnWBDead",2; } else { monster .WBMAPS$[0],0,0,"[World Boss]",.WBMOBID[rand(getarraysize(.WBMOBID))],1,"WorldBossEvent::OnWBDead",2; } } else { if(.WBMOBID[1] == 0){ monster .WBMAPS$[rand(getarraysize(.WBMAPS$))],0,0,"[World Boss]",.WBMOBID[0],1,"WorldBossEvent::OnWBDead",2; } else { monster .WBMAPS$[rand(getarraysize(.WBMAPS$))],0,0,"[World Boss]",.WBMOBID[rand(getarraysize(.WBMOBID))],1,"WorldBossEvent::OnWBDead",2; } } //announce "[World Boss]: The world boss has spawned!",bc_all; announce ("[World Boss Event]: The world boss has spawned atspawn at "+.WBMAPS$+"",bc_all); end; //================================================================// // This event fires off when the world boss is killed //================================================================// OnWBDead: announce "[World Boss]: "+ strcharinfo(0)+" landed the final blow against the world boss!",bc_all; getitem .sprize,.sprizeamt; // Gives only the winning player this prize addrid 1,0; // Attaches all players on the current map getitem .mprize,.mprizeamt; // Gives all players a prize end; //================================================================// // These are the NPC settings //================================================================// OnInit: // Add your world boss mob ID's here. If you only need one, just put one. setarray .WBMOBID, 1848,1847; // Add the maps for your world boss event here. If you only want one, just add one. setarray .WBMAPS$, "prontera","geffen"; // This is the special prize for the player that lands the final hit. .sprize = 22654; .sprizeamt = 100; // This is the prize that gets given to all players on the event map when it is killed .mprize = 22654; .mprizeamt = 20; end; } Worldbossevent2.txt