Emistry

Annie's PVP Ladder required you to clear the temporary variables too in case if you want to reset ranking, else you will end up with faulty ranking after reset. query_sql("TRUNCATE TABLE `pvpladder`"); query_sql("TRUNCATE TABLE `ownladder`"); addrid(0); @PlayersKilledStreak = 0; @dota_sql_deaths = 0; @dota_multikills = 0; @dota_sql_streaks = 0; @dota_sql_streaktime = 0; @dota_sql_kills = 0; full script //====== 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 [email protected]$ = "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; [email protected] = query_sql([email protected]$, [email protected], [email protected]$, [email protected]_id, [email protected], [email protected]$, [email protected], [email protected]_color, [email protected]_color, [email protected], [email protected]_top, [email protected]_mid, [email protected]_bottom, [email protected], [email protected], [email protected], [email protected]); if (.fix_custom_sprite) { for ([email protected] = 0; [email protected] < [email protected]; [email protected]) { setunitdata .statue[[email protected] +1], UNPC_HEADTOP, 0; setunitdata .statue[[email protected] +1], UNPC_HEADMIDDLE, 0; setunitdata .statue[[email protected] +1], UNPC_HEADBOTTOM, 0; setunitdata .statue[[email protected] +1], UNPC_ROBE, 0; } } for ([email protected] = 0; [email protected] < [email protected]; [email protected]) { setunitdata .statue[[email protected] +1], UNPC_CLASS, [email protected][[email protected]]; setunitdata .statue[[email protected] +1], UNPC_SEX, ([email protected]$[[email protected]] == "F")? SEX_FEMALE:SEX_MALE; setunitdata .statue[[email protected] +1], UNPC_HAIRSTYLE, [email protected][[email protected]]; setunitdata .statue[[email protected] +1], UNPC_HAIRCOLOR, [email protected]_color[[email protected]]; setunitdata .statue[[email protected] +1], UNPC_CLOTHCOLOR, [email protected]_color[[email protected]]; setunitdata .statue[[email protected] +1], UNPC_BODY2, [email protected][[email protected]]; setunitdata .statue[[email protected] +1], UNPC_HEADTOP, [email protected]_top[[email protected]]; setunitdata .statue[[email protected] +1], UNPC_HEADMIDDLE, [email protected]_mid[[email protected]]; setunitdata .statue[[email protected] +1], UNPC_HEADBOTTOM, [email protected]_bottom[[email protected]]; setunitdata .statue[[email protected] +1], UNPC_ROBE, [email protected][[email protected]]; setnpcdisplay "pvp_ladder_statue#"+([email protected] +1), [email protected]$[[email protected]]; .statue_name$[[email protected] +1] = [email protected]$[[email protected]]; .statue_guild$[[email protected] +1] = getguildname([email protected]_id[[email protected]]); .statue_kills[[email protected] +1] = [email protected][[email protected]]; .statue_streaks[[email protected] +1] = [email protected][[email protected]]; .statue_deaths[[email protected] +1] = [email protected][[email protected]]; } for ([email protected] = [email protected]; [email protected] < .showstatue; [email protected]) setunitdata .statue[[email protected] +1], UNPC_CLASS, HIDDEN_WARP_NPC; initnpctimer; end; // script start. OnPCKillEvent: if (getgmlevel() >= .gmnokill) end; [email protected]$ = strcharinfo(3); if (.maptrigger$ != "all") { while ([email protected] < .maptriggersize && [email protected]$ != .maptrigger$[[email protected]]) [email protected]; if ([email protected] == .maptriggersize) end; } [email protected]$ = strcharinfo(0); [email protected] = getcharid(3); [email protected] = getcharid(0); [email protected] = getcharid(2); [email protected] = BaseLevel; attachrid killedrid; [email protected]$ = strcharinfo(0); [email protected] = getcharid(3); [email protected] = getcharid(0); [email protected] = getcharid(2); [email protected] = BaseLevel; if ([email protected] != [email protected] && (.msg_die || .msg_kill)) { if (.msg_die) message [email protected]$, "You have been killed by "+ [email protected]$; if (.msg_kill) message [email protected]$, "You just killed "+ [email protected]$; } if (@PlayersKilledStreak >= .holyshit) [email protected]$ = "Beyond Godlike"; else if (@PlayersKilledStreak >= .godlike) [email protected]$ = "Godlike"; else if (@PlayersKilledStreak >= .monsterkill) [email protected]$ = "Monster Kill"; else if (@PlayersKilledStreak >= .wickedsick) [email protected]$ = "Wicked Sick"; else if (@PlayersKilledStreak >= .unstoppable) [email protected]$ = "Unstoppable"; else if (@PlayersKilledStreak >= .megakill) [email protected]$ = "Mega-kill"; else if (@PlayersKilledStreak >= .dominating) [email protected]$ = "Dominating"; else if (@PlayersKilledStreak >= .killingspree) [email protected]$ = "Killing Spree"; if (@PlayersKilledStreak >= .killingspree && [email protected] == [email protected]) announce sprintf("%s has ended %s own %s[%d] streak %s", [email protected]$, (Sex)?"him":"her", [email protected]$, @PlayersKilledStreak, (.mapname_announcement)?("at "+ [email protected]$):""), bc_blue|.dota_bc_flag; else if (@PlayersKilledStreak >= .killingspree) announce sprintf("%s has ended %s's %s[%d] streak %s", [email protected]$, [email protected]$, [email protected]$, @PlayersKilledStreak, (.mapname_announcement)?("at "+ [email protected]$):""), bc_blue|.dota_bc_flag; else if (.killannounce && [email protected] != [email protected]) announce sprintf("%s has pawned %s's head %s", [email protected]$, [email protected]$, (.mapname_announcement)?("at "+ [email protected]$):""), bc_blue|.dota_bc_flag; @PlayersKilledStreak = 0; [email protected]_sql_deaths; @dota_multikills = 0; if ([email protected]) .guild_current_ownage[[email protected]] = 0; if ([email protected] == [email protected] || [email protected] < .lvltokill || (.minlvlrange && [email protected] + .minlvlrange < [email protected])) { query_sql sprintf("replace into pvpladder values (%d, '%s', %d, %d, %d, from_unixtime(%d))", [email protected], escape_sql([email protected]$), @dota_sql_streaks, @dota_sql_kills, @dota_sql_deaths, @dota_sql_streaktime); if ([email protected] && .guild_highest_ownage[[email protected]]) query_sql sprintf("replace into ownladder values (%d, '%s', %d, %d, from_unixtime(%d))", [email protected], escape_sql(getguildname([email protected])), .guild_current_ownage[[email protected]], .guild_highest_ownage[[email protected]], .guild_ownage_time[[email protected]]); end; } [email protected]_kills = @dota_sql_kills; [email protected]_deaths = @dota_sql_deaths; [email protected]_streaks = @dota_sql_streaks; [email protected]_streaktime = @dota_sql_streaktime; attachrid killerrid; if (.counttopunish) { if (@sitkillminute != gettime(DT_MINUTE)) { deletearray @sitkill; @sitkillminute = gettime(DT_MINUTE); } [email protected][[email protected]]; if (@sitkill[[email protected]] >= .counttopunish) { warp "SavePoint", 0,0; announce [email protected]$ +" , Stop killing "+ [email protected]$ + " !!!", bc_all; debugmes [email protected]$ +" is sit-killing "+ [email protected]$ +" for "+ @sitkill[[email protected]] + " times"; logmes "is sit-killing "+ [email protected]$ +" for "+ @sitkill[[email protected]] +" 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))", [email protected], escape_sql([email protected]$), @dota_sql_streaks, @dota_sql_kills, @dota_sql_deaths, @dota_sql_streaktime, [email protected], escape_sql([email protected]$), [email protected]_streaks, [email protected]_kills, [email protected]_deaths, [email protected]_streaktime); if ([email protected]) { if (.guild_current_ownage[[email protected]] == .guild_highest_ownage[[email protected]]) { .guild_highest_ownage[[email protected]] = .guild_highest_ownage[[email protected]] +1 - .counttopunish; .guild_ownage_time[[email protected]] = gettimetick(2); } .guild_current_ownage[[email protected]] = .guild_current_ownage[[email protected]] +1 - .counttopunish; if (.guild_current_ownage[[email protected]] < 0) .guild_current_ownage[[email protected]] = 0; if (.guild_highest_ownage[[email protected]] < 0) .guild_highest_ownage[[email protected]] = 0; if ([email protected] && .guild_highest_ownage[[email protected]]) query_sql sprintf("replace into ownladder values (%d, '%s', %d, %d, from_unixtime(%d)), (%d, '%s', %d, %d, from_unixtime(%d))", [email protected], escape_sql(getguildname([email protected])), .guild_current_ownage[[email protected]], .guild_highest_ownage[[email protected]], .guild_ownage_time[[email protected]], [email protected], escape_sql(getguildname([email protected])), .guild_current_ownage[[email protected]], .guild_highest_ownage[[email protected]], .guild_ownage_time[[email protected]]); else query_sql sprintf("replace into ownladder values (%d, '%s', %d, %d, from_unixtime(%d))", [email protected], escape_sql(getguildname([email protected])), .guild_current_ownage[[email protected]], .guild_highest_ownage[[email protected]], .guild_ownage_time[[email protected]]); } else if ([email protected] && .guild_highest_ownage[[email protected]]) query_sql sprintf("replace into ownladder values (%d, '%s', %d, %d, from_unixtime(%d))", [email protected], escape_sql(getguildname([email protected])), .guild_current_ownage[[email protected]], .guild_highest_ownage[[email protected]], .guild_ownage_time[[email protected]]); end; } } [email protected]; [email protected]_sql_kills; if (@PlayersKilledStreak > @dota_sql_streaks) { @dota_sql_streaks = @PlayersKilledStreak; @dota_sql_streaktime = gettimetick(2); } if (@PlayersKilledStreak == .killingspree) setarray [email protected]$, "killingspree.wav", "is on a KILLING SPREE", "!"; else if (@PlayersKilledStreak == .dominating) setarray [email protected]$, "dominating.wav", "is DOMINATING", "!"; else if (@PlayersKilledStreak == .megakill) setarray [email protected]$, "megakill.wav", "has a MEGA KILL", "!"; else if (@PlayersKilledStreak == .unstoppable) setarray [email protected]$, "unstoppable.wav", "is UNSTOPPABLE", "!!"; else if (@PlayersKilledStreak == .wickedsick) setarray [email protected]$, "wickedsick.wav", "is WICKED SICK", "!!"; else if (@PlayersKilledStreak == .monsterkill) setarray [email protected]$, "monsterkill.wav", "has a MONSTER KILL", "!!"; else if (@PlayersKilledStreak == .godlike) setarray [email protected]$, "godlike.wav", "is GODLIKE", "!!!"; else if (@PlayersKilledStreak >= .holyshit && ((@PlayersKilledStreak - .holyshit) % .continue == 0)) setarray [email protected]$,"holyshit.wav", "is BEYOND GODLIKE",". Someone KILL "+( (Sex)?"HIM":"HER" ) +"!!!!!!"; if (getstrlen([email protected]$[1])) { announce sprintf("%s %s[%d] %s%s", [email protected]$, [email protected]$[1], @PlayersKilledStreak, (.mapname_announcement)?("at "+ [email protected]$):"", [email protected]$[2]), bc_blue|.dota_bc_flag; if (.sound == 1) soundeffectall [email protected]$[0], 0, [email protected]$; else if (.sound == 2) soundeffectall [email protected]$[0], 0; else if (.sound == 3) soundeffect [email protected]$[0], 0; } [email protected]_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))", [email protected], escape_sql([email protected]$), @dota_sql_streaks, @dota_sql_kills, @dota_sql_deaths, @dota_sql_streaktime, [email protected], escape_sql([email protected]$), [email protected]_streaks, [email protected]_kills, [email protected]_deaths, [email protected]_streaktime); if ([email protected] && [email protected] != [email protected]) { ++.guild_current_ownage[[email protected]]; if (.guild_current_ownage[[email protected]] > .guild_highest_ownage[[email protected]] ) { .guild_highest_ownage[[email protected]] = .guild_current_ownage[[email protected]]; .guild_ownage_time[[email protected]] = gettimetick(2); } if ([email protected] && .guild_highest_ownage[[email protected]]) query_sql sprintf("replace into ownladder values (%d, '%s', %d, %d, from_unixtime(%d)), (%d, '%s', %d, %d, from_unixtime(%d))", [email protected], escape_sql(getguildname([email protected])), .guild_current_ownage[[email protected]], .guild_highest_ownage[[email protected]], .guild_ownage_time[[email protected]], [email protected], escape_sql(getguildname([email protected])), .guild_current_ownage[[email protected]], .guild_highest_ownage[[email protected]], .guild_ownage_time[[email protected]]); else query_sql sprintf("replace into ownladder values (%d, '%s', %d, %d, from_unixtime(%d))", [email protected], escape_sql(getguildname([email protected])), .guild_current_ownage[[email protected]], .guild_highest_ownage[[email protected]], .guild_ownage_time[[email protected]]); } else if ([email protected] && .guild_highest_ownage[[email protected]]) query_sql sprintf("replace into ownladder values (%d, '%s', %d, %d, from_unixtime(%d))", [email protected], escape_sql(getguildname([email protected])), .guild_current_ownage[[email protected]], .guild_highest_ownage[[email protected]], .guild_ownage_time[[email protected]]); [email protected]_multikills = @dota_multikills; sleep 1500; if ([email protected] && [email protected] != [email protected] && .guild_current_ownage[[email protected]] >= .owned && ((.guild_current_ownage[[email protected]] - .owned) % .owncontinue == 0)) { if ( .dota_bc_flag ) mapannounce [email protected]$, "The guild ["+ getguildname([email protected]) +"] is OWNING["+ .guild_current_ownage[[email protected]] +"] !!!", bc_blue; else announce "The guild ["+ getguildname([email protected]) +"] is OWNING["+ .guild_current_ownage[[email protected]] +"] !!!", bc_blue; if ( .sound == 1 ) soundeffectall "ownage.wav",0,[email protected]$; else if ( .sound == 2 ) soundeffectall "ownage.wav",0; else if ( .sound == 3 && attachrid([email protected]) ) soundeffect "ownage.wav",0; } sleep 1250; if (!attachrid([email protected])) end; if ([email protected]_multikills == 2) { if (.dota_bc_flag) mapannounce [email protected]$, [email protected]$ +" 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, [email protected]$; else if (.sound == 2) soundeffectall "doublekill.wav", 0; else if (.sound == 3) soundeffect "doublekill.wav", 0; } else if ([email protected]_multikills == 3) { if (.dota_bc_flag) mapannounce [email protected]$, [email protected]$ +" 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, [email protected]$; else if (.sound == 2) soundeffectall "triplekill.wav", 0; else if (.sound == 3) soundeffect "triplekill.wav", 0; } else if ([email protected]_multikills == 4) { if (.dota_bc_flag) mapannounce [email protected]$, [email protected]$ +" 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, [email protected]$; else if (.sound == 2) soundeffectall "ultrakill.wav", 0; else if (.sound == 3) soundeffect "ultrakill.wav", 0; } else if ([email protected]_multikills >= 5) { if (.dota_bc_flag) mapannounce [email protected]$, [email protected]$ +" is on a Rampage !!!", bc_blue; else announce strcharinfo(0) +" is on a Rampage !!!", bc_blue; if (.sound == 1) soundeffectall "rampage.wav", 0, [email protected]$; 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 ([email protected]_sql_kills && [email protected]_sql_deaths) { if (.maptrigger$ != "all") { [email protected]$ = strcharinfo(3); while ([email protected] < .maptriggersize && [email protected]$ != .maptrigger$[[email protected]]) [email protected]; if ([email protected] == .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; } [email protected] = getcharid(2); if ([email protected] && !.guild_highest_ownage[[email protected]]) { query_sql "select currentown, highestown, unix_timestamp(owntime) from ownladder where guild_id = "+ [email protected], [email protected], [email protected], [email protected]; .guild_current_ownage[[email protected]] = [email protected]; .guild_highest_ownage[[email protected]] = [email protected]; .guild_ownage_time[[email protected]] = [email protected]; } end; } prontera,180,194,3 script PvP-StatsViewer 4_GEFFEN_11,{ [email protected]$ = strnpcinfo(0); while (true) { mes "["+ [email protected]$ +"]"; mes "Hello "+ strcharinfo(0) +"..."; mes "If you want to I can show you your PVP stats."; next; mes "["+ [email protected]$ +"]"; switch (select( "Most Kills", "Highest Streak", "Longest Ownage", "Own Information", "Explanation", (getgmlevel() >= 99 ? "^FF0000[GM] Reset Ranking^000000" : "") )) { case 1: [email protected] = query_sql("select name, kills, deaths from pvpladder order by kills desc limit "+ getvariableofnpc(.showtotal, "DOTAPVP"), [email protected]$, [email protected], [email protected]); if ([email protected]) { mes "The ladder currently is empty."; next; } for ([email protected] = 0; [email protected] < [email protected]; [email protected] += getvariableofnpc(.showpage,"DOTAPVP")) { for ([email protected] = [email protected]; [email protected] < (getvariableofnpc(.showpage,"DOTAPVP") + [email protected]) && [email protected] < [email protected]; [email protected]) mes "^996600"+ ([email protected]+1) +": ^006699"+ [email protected]$[[email protected]] +" ^00AA00["+ [email protected][[email protected]] +"] ^FF0000<"+ [email protected][[email protected]] +">^000000"; next; } break; case 2: [email protected] = 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"), [email protected]$, [email protected], [email protected]$); if ([email protected]) { mes "The ladder currently is empty."; next; } for ([email protected] = 0; [email protected] < [email protected]; [email protected] += getvariableofnpc(.showpage,"DOTAPVP") ) { for ( [email protected] = [email protected]; [email protected] < (getvariableofnpc(.showpage,"DOTAPVP") + [email protected]) && [email protected] < [email protected]; [email protected]) { mes "^996600"+ ([email protected]+1) +": ^006699"+ [email protected]$[[email protected]] +" ^70AC11{"+ [email protected][[email protected]] +"} ^000000on :"; mes " ^EE8800"+ [email protected]$[[email protected]] +"^000000"; } next; } break; case 3: [email protected] = 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"), [email protected]$, [email protected], [email protected]$); if ([email protected]) { mes "The ladder currently is empty."; next; } for ([email protected] = 0; [email protected] < [email protected]; [email protected] += getvariableofnpc(.showpage,"DOTAPVP")) { for ([email protected] = [email protected]; [email protected] < (getvariableofnpc(.showpage,"DOTAPVP") + [email protected]) && [email protected] < [email protected]; [email protected] ) { mes "^996600"+ ([email protected]+1) +": ^006699"+ [email protected]$[[email protected]] +" ^00AAAA("+ [email protected][[email protected]] +") ^000000on :"; mes " ^EE8800"+ [email protected]$[[email protected]] +"^000000"; } next; } break; case 4: if ([email protected]_sql_kills && [email protected]_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, [email protected]$; else query_sql "select date_format(from_unixtime("+ @dota_sql_streaktime +"),'%a %e/%c/%y %r')", [email protected]$; if ([email protected]_sql_kills && [email protected]_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"+ [email protected]$ +"^000000"; } } next; [email protected] = getcharid(2); if ([email protected]) { if (!getvariableofnpc(.guild_ownage_time[[email protected]], "DOTAPVP")) { query_sql "select currentown, highestown, unix_timestamp(owntime), date_format(owntime,'%a %e/%c/%y %r') from ownladder where guild_id = "+ [email protected], [email protected], [email protected], [email protected], [email protected]$; set getvariableofnpc(.guild_current_ownage[[email protected]], "DOTAPVP"), [email protected]; set getvariableofnpc(.guild_highest_ownage[[email protected]], "DOTAPVP"),[email protected]; set getvariableofnpc(.guild_ownage_time[[email protected]], "DOTAPVP"), [email protected]; } else query_sql "select date_format( from_unixtime("+ getvariableofnpc(.guild_ownage_time[[email protected]], "DOTAPVP") +"),'%a %e/%c/%y %r')", [email protected]$; mes "["+ [email protected]$ +"]"; if (!getvariableofnpc(.guild_ownage_time[[email protected]], "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[[email protected]], "DOTAPVP") +")^000000"; mes "Longest Ownage was ^00AAAA("+ getvariableofnpc(.guild_highest_ownage[[email protected]], "DOTAPVP") + ")^000000 on :"; mes " ^EE8800"+ [email protected]$ +"^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 "["+ [email protected]$ +"]"; 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 "["+ [email protected]$ +"]"; 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 "["+ [email protected]$ +"]"; 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 "["+ [email protected]$ +"]"; 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 "["+ [email protected]$ +"]"; 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; case 6: mes "Want reset ^FF0000PvP Ranking^000000?"; if (select("- ^17AA24Yes^000000", "^FF0000No^000000") == 1) { mes "Ranking will be cleared."; close2; donpcevent strnpcinfo(3)+"::OnReset"; end; } break; } } OnReset: query_sql("TRUNCATE TABLE `pvpladder`"); query_sql("TRUNCATE TABLE `ownladder`"); addrid(0); @PlayersKilledStreak = 0; @dota_sql_deaths = 0; @dota_multikills = 0; @dota_sql_streaks = 0; @dota_sql_streaktime = 0; @dota_sql_kills = 0; end; } - script pvp_ladder_statue FAKE_NPC,{ [email protected] = getelementofarray(getvariableofnpc(.npcgid, "DOTAPVP"), getnpcid(0)); mes "^996600[TOP "+ [email protected] +"]"; mes "^006699Name : "+ getelementofarray(getvariableofnpc(.statue_name$, "DOTAPVP"), [email protected]); [email protected]$ = getelementofarray(getvariableofnpc(.statue_guild$, "DOTAPVP"), [email protected]); mes "^00AAAAGuild : "+(([email protected]$ == "null")? "^AAAAAANone": [email protected]$); mes "^00AA00Total Kills : ["+ getelementofarray(getvariableofnpc(.statue_kills, "DOTAPVP"), [email protected]) +"]"; mes "^70AC11Highest Streaks : ["+ getelementofarray(getvariableofnpc(.statue_streaks, "DOTAPVP"), [email protected]) +"]"; mes "^FF0000Deaths : <"+ getelementofarray(getvariableofnpc(.statue_deaths, "DOTAPVP"), [email protected]) +">"; close; OnInit: [email protected] = strnpcinfo(2); set getvariableofnpc(.statue[[email protected]], "DOTAPVP"), getnpcid(0); set getvariableofnpc(.npcgid[getnpcid(0)], "DOTAPVP"), [email protected]; 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

dali02,82,136,5 script Bloody Branch Room 403,{ setarray [email protected]$[1], "alb2trea", "pvp_n_1-5", "pvp_n_2-5", "pvp_n_3-5", "pvp_n_4-5", "pvp_n_5-5"; for(set [email protected],1; [email protected] < getarraysize([email protected]$); set [email protected],[email protected] + 1) { if([email protected]==1){ set [email protected]$, [email protected]$ + "Public- "+((getmapusers([email protected]$[[email protected]])>=30)?"^CD0000Closed^000000("+getmapusers([email protected]$[[email protected]])+")":"^007700Open^000000("+getmapusers([email protected]$[[email protected]])+")")+":"; } else { set [email protected]$, [email protected]$ + "Private["+([email protected])+"]- "+((getmapusers(""[email protected]$[[email protected]]+"")>=5)?"^CD0000Closed^000000("+getmapusers([email protected]$[[email protected]])+")":"^007700Open^000000("+getmapusers([email protected]$[[email protected]])+")")+":"; } } if(select([email protected]$)) { callfunc "GRfunction",[email protected]$[@menu],@menu; } } function script GRfunction { if(!getmapusers(getarg(0))) killmonster getarg(0), "All"; 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 you can just wipe it right before player enter a room that has no player inside.

instance_db.yml - Id: 1 Name: Endless Tower TimeLimit: 14400 Enter: Map: [email protected] X: 50 Y: 355 NPC script prontera,155,181,5 script Sample 757,{ [email protected]_name$ = "Endless Tower"; if (!is_party_leader()) end; switch(select( "Create", "Enter", "Destroy" )) { case 1: instance_create([email protected]_name$, IM_PARTY); break; case 2: switch(instance_enter([email protected]_name$)) { case IE_NOMEMBER: mes "ERROR: Party not found."; break; case IE_NOINSTANCE: mes "ERROR: Party does not have an instance."; break; case IE_OTHER: mes "ERROR: Unknown error."; break; default: break; } break; case 3: instance_destroy; break; } close; }

prontera,155,181,5 script Sample 757,{ if (select("Enter", "Cancel") == 1) { if (getmapusers("thana_boss")) { mes "Someone's already inside."; } else { for ([email protected] = 7436; [email protected] <= 7439; [email protected]++) if (!countitem([email protected])) getitem [email protected]; warp thana_boss, 0, 0; end; } } close; }

try change https://github.com/rathena/rathena/blob/master/src/map/skill.cpp#L18432 if( sd->special_state.no_gemstone == 2 ) // Remove all Magic Stone required for all skills for VIP. into if( sd->special_state.no_gemstone >= 1 ) // Remove all Magic Stone required for all skills for VIP.

Showcase forum is good to have, at least it allow member to showcase their idea and content. Afterall, Scripting Forum is the most popular category in the forum. It enable more interaction between members. On the other hand, advertising for product is fine, we have the forum to do it and the rules to follow. But the problem is that a lot member try to make use of showcase title to somehow advertise their product, bypass forum rules, and the forum mods have a hard time to tell whether they are actually just for showcase or advertising a product. At the same time, if a member planning to advertising a product, the forum would prefer them to use the IP Download System which enable forum to earn some commission to stay alive, however the payout is terrible, so most of the member just skip it and use other way (ex: showcase) to advertise their product. Honestly, some time we just would like to hear some feedback about the showcase idea or content to improve it, not the annoying PM for Sales! How much? If you have "feedback", My Discord is xyz blablabla.... Members nowadays just love to create a showcase topic (or even attempts to join as staff team), just so that they could showcase their product and boost their sales. Anyway, if really want to enable showcase forum, I really hope the forum consider to make a way to make it clear that the topic is either just showcase idea or showcase a product, remove they grey area. Members should be only can showcase their idea or content but shouldn't be allow to showcase a product there unless they followed the forum rules and earned the right to advertise it. Same should apply to graphic showcase forum. Thx for reading, just my 2cents...

if (.map$ == strcharinfo(3) && !(agitcheck() || agitcheck2() || agitcheck3()) {

- script Sample -1,{ OnInit: .map$ = "prtg_cas01"; setmapflag(.map$, MF_LOADEVENT); end; OnPCLoadMapEvent: if (.map$ == strcharinfo(3) && !(agitcheck() || agitcheck2() || agitcheck3()) { [email protected]_guild_id = getcastledata(.map$, CD_GUILD_ID); if ([email protected]_guild_id && getcharid(2) != [email protected]_guild_id) { mes "You aren't allow to enter this area."; close2; warp "SavePoint", 0, 0; } } end; }

if you are asking for a way to find out what is the date of the exe you are using.... you can try this https://openkore.com/wiki/ServerType#Packets the PEviewer allow you to find out the exe date

https://rathena.org/board/topic/129917-help-flux-error-message-failed-to-importreplace-rows-from-table/?do=findComment&comment=402631

may try something like this. update the sql to retrieve from the correct table and fields.

may try something like this. update the sql to retrieve from the correct table and fields.

may try this. https://pastebin.com/raw/4xgQ2Krr however, this cant auto handle the scenario where the player left the guild after he registered as the member who using the GTB during WOE. But if you are a guild master, then you may try to use the command [at]gmreset to force your guild member (even if left guild) reset it.

try this - script Sample -1,{ end; OnTouchNPC: [email protected] = getattachedrid(); if ([email protected]) { getunitdata [email protected], [email protected]; if (getmonsterinfo([email protected][UMOB_CLASS], MOB_MVPEXP)) unitwarp 0,"this", -1, -1; } end; }

Script: | bonus bBaseAtk,2600; if (!agitcheck() && !agitcheck2() && !agitcheck3()) bonus2 bHPDrainRate, 1000, 100; just change your item_db instead of adding another script function