Jump to content

MikZ

Members
  • Content Count

    461
  • Joined

  • Last visited

Posts posted by MikZ


  1. Used this npc/custom/quests/quest_shop.txt
     

    //===== Hercules Script ======================================
    //= Euphy's Quest Shop
    //===== By: ==================================================
    //= Euphy
    //===== Current Version: =====================================
    //= 1.6a
    //===== Description: =========================================
    //= A dynamic quest shop based on Lunar's, with easier config.
    //= Includes support for multiple shops & cashpoints.
    //= Item Preview script by ToastOfDoom.
    //===== Additional Comments: =================================
    //= 1.0 Initial script.
    //= 1.2 Added category support.
    //= 1.3 More options and fixes.
    //= 1.4 Added debug settings.
    //= 1.5 Replaced categories with shop IDs.
    //= 1.6 Added support for purchasing stackables.
    //= 1.6a Added support for previewing costumes and robes.
    //============================================================
    
    // Shop NPCs -- supplying no argument displays entire menu.
    //	callfunc "qshop"{,<shop ID>{,<shop ID>{,...}}};
    //============================================================
    prontera,164,203,6	script	Quest Shop#1	4_M_MOCASS2,{ callfunc "qshop"; }
    
    
    // Script Core
    //============================================================
    -	script	quest_shop	FAKE_NPC,{
    function Add; function Chk; function Slot; function A_An;
    OnInit:
    	freeloop(1);
    
    // -----------------------------------------------------------
    //  Basic shop settings.
    // -----------------------------------------------------------
    
    	set .Announce,1;	// Announce quest completion? (1: yes / 0: no)
    	set .ShowSlot,1;	// Show item slots? (2: all equipment / 1: if slots > 0 / 0: never)
    	set .ShowID,0;  	// Show item IDs? (1: yes / 0: no)
    	set .ShowZeny,0;	// Show Zeny cost, if any? (1: yes / 0: no)
    	set .MaxStack,100;	// Max number of quest items purchased at one time.
    
    // -----------------------------------------------------------
    //  Points variable -- optional quest requirement.
    //	setarray .Points$[0],"<variable name>","<display name>";
    // -----------------------------------------------------------
    
    	setarray .Points$[0],"#CASHPOINTS","Cash Points";
    
    // -----------------------------------------------------------
    //  Shop IDs -- to add shops, copy dummy data at bottom of file.
    //	setarray .Shops$[1],"<Shop 1>","<Shop 2>"{,...};
    // -----------------------------------------------------------
    
    	setarray .Shops$[1],"Headgears","Weapons","Other";
    
    // -----------------------------------------------------------
    //  Quest items -- do NOT use a reward item more than once!
    //	Add(<shop ID>,<reward ID>,<reward amount>,
    //	    <Zeny cost>,<point cost>,
    //	    <required item ID>,<required item amount>{,...});
    // -----------------------------------------------------------
    
    	Add(1,5022,1,0,0,7086,1,969,10,999,40,1003,50,984,2);
    	Add(1,5032,1,0,0,1059,250,2221,1,2227,1,7063,600);
    	Add(1,5027,1,0,0,2252,1,1036,400,7001,50,4052,1);
    	Add(1,5045,1,0,0,2252,1,1054,450,943,1200);
    
    	Add(2,1224,1,0,0,7297,30,969,10,999,50,714,10);
    	Add(2,1225,1,0,0,7292,30,969,10,999,50,714,10);
    
    	Add(3,531,1,3,0,512,1,713,1);
    	Add(3,532,1,3,0,513,1,713,1);
    	Add(3,533,1,3,0,514,1,713,1);
    	Add(3,534,1,3,0,515,1,713,1);
    
    // -----------------------------------------------------------
    
    	freeloop(0);
    	set .menu$,"";
    	for(set .@i,1; .@i<=getarraysize(.Shops$); set .@i,.@i+1) {
    		set .menu$, .menu$+.Shops$[.@i]+":";
    		npcshopdelitem "qshop"+.@i,909;
    	}
    	end;
    
    OnMenu:
    	set .@size, getarraysize(@i);
    	if (!.@size) set .@i, select(.menu$);
    	else if (.@size == 1) set .@i, @i[0];
    	else {
    		for(set .@j,0; .@j<.@size; set .@j,.@j+1)
    			set .@menu$, .@menu$+.Shops$[@i[.@j]]+":";
    		set .@i, @i[select(.@menu$)-1];
    	}
    	deletearray @i[0],getarraysize(@i);
    	if (.Shops$[.@i] == "") {
    		message strcharinfo(PC_NAME),"An error has occurred.";
    		end;
    	}
    	dispbottom "Select one item at a time.";
    	callshop "qshop"+.@i,1;
    	npcshopattach "qshop"+.@i;
    	end;
    
    OnBuyItem:
    	// .@q[] : RewardID, BoughtAmt, RewardAmt, BaseAmt, ReqZeny, ReqPts, { ReqItem, ReqAmt, ... }
    	setarray .@q[0],@bought_nameid[0],((@bought_quantity[0] > .MaxStack)?.MaxStack:@bought_quantity[0]);
    	copyarray .@q[3],getd(".q_"+.@q[0]+"[0]"),getarraysize(getd(".q_"+.@q[0]));
    	set .@q[2],.@q[1]*.@q[3];
    	if (!.@q[2] || .@q[2] > 30000) {
    		message strcharinfo(PC_NAME),"You can't purchase that many "+getitemname(.@q[0])+".";
    		end;
    	}
    	mes "[Quest Shop]";
    	mes "Reward: ^0055FF"+((.@q[2] > 1)?.@q[2]+"x ":"")+Slot(.@q[0])+"^000000";
    	mes "Requirements:";
    	if (.@q[4]) mes " > "+Chk(Zeny,.@q[4]*.@q[1])+(.@q[4]*.@q[1])+" Zeny^000000";
    	if (.@q[5]) mes " > "+Chk(getd(.Points$[0]),.@q[5]*.@q[1])+(.@q[5]*.@q[1])+" "+.Points$[1]+" ("+getd(.Points$[0])+"/"+(.@q[5]*.@q[1])+")^000000";
    	if (.@q[6]) for(set .@i,6; .@i<getarraysize(.@q); set .@i,.@i+2)
    		mes " > "+Chk(countitem(.@q[.@i]),.@q[.@i+1]*.@q[1])+((.ShowID)?"{"+.@q[.@i]+"} ":"")+Slot(.@q[.@i])+" ("+countitem(.@q[.@i])+"/"+(.@q[.@i+1]*.@q[1])+")^000000";
    	next;
    	setarray @qe[1], getiteminfo(.@q[0], ITEMINFO_LOC), getiteminfo(.@q[0], ITEMINFO_VIEWSPRITE);
    	if (@qe[2] > 0 && ((@qe[1] & EQP_HEAD_LOW) || (@qe[1] & EQP_HEAD_TOP) || (@qe[1] & EQP_HEAD_MID) || (@qe[1] & EQP_COSTUME_HEAD_TOP) || (@qe[1] & EQP_COSTUME_HEAD_MID) || (@qe[1] & EQP_COSTUME_HEAD_LOW) || (@qe[1] & EQP_GARMENT) || (@qe[1] & EQP_COSTUME_GARMENT)))
    		set .@preview,1;
    	addtimer 1000, strnpcinfo(NPC_NAME)+"::OnEnd";
    	while(1) {
    		switch(select(" ~ Purchase ^0055FF"+ getitemname(.@q[0]) +"^000000", ((.@preview && !@qe[7])?" ~ Preview...": ""), " ~ ^777777Cancel^000000")) {
    		case 1:
    			if (@qe[0]) {
    				mes "[Quest Shop]";
    				mes "You're missing one or more quest requirements.";
    				close;
    			}
    			if (!checkweight(.@q[0],.@q[2])) {
    				mes "[Quest Shop]";
    				mes "^FF0000You need "+(((.@q[2] * getiteminfo(.@q[0], ITEMINFO_WEIGHT)) + Weight - MaxWeight) / 10)+" additional weight capacity to complete this trade.^000000";
    				close;
    			}
    			if (.@q[4]) Zeny -= (.@q[4]*.@q[1]);
    			if (.@q[5]) setd .Points$[0], getd(.Points$[0])-(.@q[5]*.@q[1]);
    			if (.@q[6]) for(set .@i,6; .@i<getarraysize(.@q); set .@i,.@i+2)
    				delitem .@q[.@i],.@q[.@i+1]*.@q[1];
    			getitem .@q[0],.@q[2];
    			if (.Announce) announce strcharinfo(PC_NAME)+" has created "+((.@q[2] > 1)?.@q[2]+"x "+getitemname(.@q[0]):A_An(getitemname(.@q[0])))+"!",0;
    			specialeffect(EF_FLOWERLEAF, AREA, playerattached());
    			close;
    		case 2:
    			setarray @qe[3], getlook(LOOK_HEAD_BOTTOM), getlook(LOOK_HEAD_TOP), getlook(LOOK_HEAD_MID), getlook(LOOK_ROBE), 1;
    			if ((@qe[1] & 1) || (@qe[1] & 4096)) changelook LOOK_HEAD_BOTTOM, @qe[2];
    			else if ((@qe[1] & 256) || (@qe[1] & 1024)) changelook LOOK_HEAD_TOP, @qe[2];
    			else if ((@qe[1] & 512) || (@qe[1] & 2048)) changelook LOOK_HEAD_MID, @qe[2];
    			else if ((@qe[1] & 4) || (@qe[1] & 8192)) changelook LOOK_ROBE, @qe[2];
    			break;
    		case 3:
    			close;
    		}
    	}
    
    OnEnd:
    	if (@qe[7]) {
    		changelook LOOK_HEAD_BOTTOM, @qe[3];
    		changelook LOOK_HEAD_TOP, @qe[4];
    		changelook LOOK_HEAD_MID, @qe[5];
    		changelook LOOK_ROBE, @qe[6];
    	}
    	deletearray @qe[0],8;
    	end;
    
    function Add {
    	if (getitemname(getarg(1)) == "null") {
    		consolemes(CONSOLEMES_WARNING, "Quest reward #"+getarg(1)+" invalid (skipped).");
    		return;
    	}
    	setarray .@j[0],getarg(2),getarg(3),getarg(4);
    	for(set .@i,5; .@i<getargcount(); set .@i,.@i+2) {
    		if (getitemname(getarg(.@i)) == "null") {
    			consolemes(CONSOLEMES_WARNING,  "Quest requirement #"+getarg(.@i)+" invalid (skipped).");
    			return;
    		} else
    			setarray .@j[.@i-2],getarg(.@i),getarg(.@i+1);
    	}
    	copyarray getd(".q_"+getarg(1)+"[0]"),.@j[0],getarraysize(.@j);
    	npcshopadditem "qshop"+getarg(0),getarg(1),((.ShowZeny)?getarg(3):0);
    	return;
    }
    
    function Chk {
    	if (getarg(0) < getarg(1)) {
    		set @qe[0],1;
    		return "^FF0000";
    	} else
    		return "^00FF00";
    }
    
    function Slot {
    	set .@s$,getitemname(getarg(0));
    	switch(.ShowSlot) {
    		case 1: if (!getitemslots(getarg(0))) return .@s$;
    		case 2: if (getiteminfo(getarg(0), ITEMINFO_TYPE) == IT_WEAPON || getiteminfo(getarg(0), ITEMINFO_TYPE) == IT_ARMOR) return .@s$+" ["+getitemslots(getarg(0))+"]";
    		default: return .@s$;
    	}
    }
    
    function A_An {
    	setarray .@A$[0],"a","e","i","o","u";
    	set .@B$, "_"+getarg(0);
    	for(set .@i,0; .@i<5; set .@i,.@i+1)
    		if (compare(.@B$,"_"+.@A$[.@i])) return "an "+getarg(0);
    	return "a "+getarg(0);
    }
    }
    
    function	script	qshop	{
    	deletearray @i[0],getarraysize(@i);
    	for(set .@i,0; .@i<getargcount(); set .@i,.@i+1)
    		set @i[.@i],getarg(.@i);
    	doevent "quest_shop::OnMenu";
    	end;
    }
    
    
    // Dummy shop data -- copy as needed.
    //============================================================
    -	shop	qshop1	FAKE_NPC,909:-1
    -	shop	qshop2	FAKE_NPC,909:-1
    -	shop	qshop3	FAKE_NPC,909:-1
    -	shop	qshop4	FAKE_NPC,909:-1
    -	shop	qshop5	FAKE_NPC,909:-1

     


  2. 1 hour ago, Patskie said:

    Based on the error the source is coming from npc @ prontera 163 185 but you are showing a fake npc here. Are you calling that posted script from multiple npc's? 

     

    Hi @Patskie, yes I am duplicating it.

     

    alberta,25,240,6	duplicate(Healer)	Healer#alb	4_PORING
    aldebaran,135,118,6	duplicate(Healer)	Healer#alde	4_PORING
    amatsu,200,79,4	duplicate(Healer)	Healer#ama	4_PORING
    ayothaya,207,169,6	duplicate(Healer)	Healer#ayo	4_PORING
    comodo,184,158,6	duplicate(Healer)	Healer#com	4_PORING
    einbech,57,36,6	duplicate(Healer)	Healer#einbe	4_PORING
    einbroch,57,202,6	duplicate(Healer)	Healer#einbr	4_PORING
    geffen,115,72,6	duplicate(Healer)	Healer#gef	4_PORING
    gonryun,156,122,6	duplicate(Healer)	Healer#gon	4_PORING
    hugel,89,150,6	duplicate(Healer)	Healer#hug	4_PORING
    izlude,125,118,5	duplicate(Healer)	Healer#izl	4_PORING
    jawaii,250,139,4	duplicate(Healer)	Healer#jaw	4_PORING
    lighthalzen,152,100,6	duplicate(Healer)	Healer#lhz	4_PORING
    louyang,226,103,4	duplicate(Healer)	Healer#lou	4_PORING
    manuk,272,144,6	duplicate(Healer)	Healer#man	4_PORING
    mid_camp,203,289,6	duplicate(Healer)	Healer#mid	4_PORING
    moc_ruins,72,164,4	duplicate(Healer)	Healer#moc	4_PORING
    morocc,153,97,6	duplicate(Healer)	Healer#mor	4_PORING
    moscovia,220,191,4	duplicate(Healer)	Healer#mos	4_PORING
    niflheim,212,182,5	duplicate(Healer)	Healer#nif	4_PORING
    payon,179,106,4	duplicate(Healer)	Healer#pay	4_PORING
    prontera,163,185,4	duplicate(Healer)	Healer#prt	4_PORING
    rachel,125,116,6	duplicate(Healer)	Healer#rac	4_PORING
    splendide,201,153,4	duplicate(Healer)	Healer#spl	4_PORING
    thor_camp,249,74,4	duplicate(Healer)	Healer#thor	4_PORING
    umbala,105,148,3	duplicate(Healer)	Healer#umb	4_PORING
    veins,217,121,4	duplicate(Healer)	Healer#ve	4_PORING
    xmas,143,136,4	duplicate(Healer)	Healer#xmas	4_PORING
    yuno,164,45,4	duplicate(Healer)	Healer#yuno	4_PORING
    
    // Duplicates (Renewal)
    //============================================================
    brasilis,194,221,6	duplicate(Healer)	Healer#bra	4_PORING
    dewata,195,187,4	duplicate(Healer)	Healer#dew	4_PORING
    dicastes01,201,194,4	duplicate(Healer)	Healer#dic	4_PORING
    ecl_in01,45,60,4	duplicate(Healer)	Healer#ecl	4_PORING
    malangdo,132,114,6	duplicate(Healer)	Healer#mal	4_PORING
    malaya,205,205,6	duplicate(Healer)	Healer#ma	4_PORING
    mora,55,152,4	duplicate(Healer)	Healer#mora	4_PORING

     


  3. 8>ExtendedBG.c
    8>D:\games\SQL\Hercules-stable\src\plugins\ExtendedBG.c(2084,13): error C2039: 'skillitem': is not a member of 'map_session_data'
    8>D:\games\SQL\Hercules-stable\src\map\pc.h(187): message : see declaration of 'map_session_data'
    8>D:\games\SQL\Hercules-stable\src\plugins\ExtendedBG.c(4052,37): error C2039: 'skillitem': is not a member of 'map_session_data'
    8>D:\games\SQL\Hercules-stable\src\map\pc.h(187): message : see declaration of 'map_session_data'
    8>D:\games\SQL\Hercules-stable\src\plugins\ExtendedBG.c(4089,11): error C2039: 'skillitem': is not a member of 'map_session_data'
    8>D:\games\SQL\Hercules-stable\src\map\pc.h(187): message : see declaration of 'map_session_data'
    8>D:\games\SQL\Hercules-stable\src\plugins\ExtendedBG.c(4102,6): error C2039: 'skillitem': is not a member of 'map_session_data'
    8>D:\games\SQL\Hercules-stable\src\map\pc.h(187): message : see declaration of 'map_session_data'
    8>D:\games\SQL\Hercules-stable\src\plugins\ExtendedBG.c(4102,22): error C2039: 'skillitemlv': is not a member of 'map_session_data'
    8>D:\games\SQL\Hercules-stable\src\map\pc.h(187): message : see declaration of 'map_session_data'
    8>D:\games\SQL\Hercules-stable\src\plugins\ExtendedBG.c(5466,19): error C2039: 'autocast': is not a member of '<unnamed-tag>'
    8>D:\games\SQL\Hercules-stable\src\map\pc.h(198): message : see declaration of '<unnamed-tag>'
    8>Done building project "ExtendedBG.vcxproj" -- FAILED.

    Someone please help. willing to pay if not that much. thanks!


  4. Good day!

    I know i have been requesting for several times now.
    But again, may i request to clean this DOTA PVP script I kept getting error player not attached on it.


    image.png.162b0f3c18d92358959ed3a7a870f749.png

     

    Here's the script.

    Spoiler
    
    //===== eAthena Script =======================================================
    //= PVP ladder script with dota announcement ( SQL only )
    //===== By: ==================================================================
    //= ~AnnieRuru~
    //===== Current Version: =====================================================
    //= 2.9
    //===== Compatible With: =====================================================
    //= eAthena SQL 14279, with MySQL 5.1
    //===== Description: =========================================================
    //= PVP ladder store in SQL table
    //= plus anti-sit-killer feature
    //===== Topic ================================================================
    //= http://www.eathena.ws/board/index.php?showtopic=177918
    //===== Additional Comments: =================================================
    //= still don't have modify value option, will be done ... in next year ...
    //============================================================================
    
    //	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
    final_dest	mapflag	loadevent
    guild_vs1	mapflag	loadevent
    guild_vs2	mapflag	loadevent
    guild_vs3	mapflag	loadevent
    guild_vs4	mapflag	loadevent
    guild_vs5	mapflag	loadevent
    cell_game	mapflag	loadevent
    ordeal_2-1	mapflag	loadevent
    pvp_y_1-2	mapflag	loadevent
    payg_cas04	mapflag	loadevent
    payg_cas05	mapflag	loadevent
    prtg_cas04	mapflag	loadevent
    arug_cas01	mapflag	loadevent
    gefg_cas03	mapflag	loadevent
    schg_cas02	mapflag	loadevent
    
    -	script	DOTAPVP	-1,{
    OnInit:
    // Config
    	set .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
    	set .Announce, 0; // announce to : 0 - global, 1 - map
    	set .announcemap, 1; // announce the map name in the announcement ? : 0 - off, 1 - on
    
    	set .announcekill, 1; // announce who pawn who's head : 0 - off, 1 - on
    	set .msg_die, 0; // show message who kill you when die : 0 - off, 1 - on
    	set .msg_kill, 0; // show message you kill who when killed someone : 0 - off, 1 - on
    
    	set .gmnokill, 0; // 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
    
    	set .killingspree, 3;
    	set .dominating, 4;
    	set .megakill, 5;
    	set .unstoppable, 6;
    	set .wickedsick, 7;
    	set .monsterkill, 8;
    	set .godlike, 9;
    	set .holyshit, 10;
    	set .continue, 1; // after beyond-godlike, every <this number> kills will make announcement again
    
    	set .owned, 5; // how many times the party/guild has to kill to announce ownage
    	set .owncontinue, 1; // after ownage, every <this number> party/guild cumulative kills will make ownage announce again
    
    	set .min_gm_menu, 90; // minimum level of GM can use the GM menu on ladder npc
    
    	set .showtotal, 10; // show the length of ladder. Note : Maximum value = 128
    	set .showpage, 10;	// set the views per page. Note : Maximum value = 128
    	set .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
    	set .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",
    		"guild_vs4",
    		"guild_vs5",
    		"ordeal_2-1",
    		"final_dest",
    		"cell_game",
    		"payg_cas04",
    		"payg_cas05",
    		"prtg_cas04",
    		"arug_cas01",
    		"gefg_cas03",
    		"schg_cas02",
    		"pvp_y_1-2";
    
    
    //	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 )
    	set .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
    	set .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
    	set .minlvlrange, 0;
    
    
    // Config ends ------------------------------------------------------------------------------------------
    
    //	to prevent bug happen
    	if ( .Announce < 0 || .Announce > 1 ) set .Announce, 0;
    	if ( .continue < 1 ) set .continue, 1;
    	if ( .owncontinue < 1 ) set .owncontinue, 1;
    	if ( .gmnokill <= 0 ) set .gmnokill, 100;
    	if ( .lvltokill <= 1 ) set .lvltokill, 0;
    	if ( .counttopunish <= 1 ) set .counttopunish, 0;
    	set .maptriggersize, getarraysize(.maptrigger$);
    	end;
    
    //	script start.
    OnPCKillEvent:
    	if ( getgmlevel() >= .gmnokill ) end;
    	getmapxy .@map$, .@x, .@y, 0;
    	if ( .maptrigger$ != "all" ) {
    		for ( set .@i, 0; .@i < .maptriggersize; set .@i, .@i +1 ) {
    			if ( .@map$ == .maptrigger$[.@i] ) break;
    		}
    		if ( .@i == .maptriggersize ) end;
    	}
    	attachrid killedrid;
    	if ( killerrid != getcharid(3) && ( .msg_die || .msg_kill ) ) {
    		if ( .msg_die ) message strcharinfo(0),"You have been killed by "+ rid2name(killerrid);
    		if ( .msg_kill ) message rid2name(killerrid),"You just killed "+ strcharinfo(0);
    	}
    	if ( @PlayersKilledStreak >= .holyshit )
    		set .@streakname$,"Beyond Godlike";
    	else if ( @PlayersKilledStreak >= .godlike )
    		set .@streakname$,"Godlike";
    	else if ( @PlayersKilledStreak >= .monsterkill )
    		set .@streakname$,"Monster Kill";
    	else if ( @PlayersKilledStreak >= .wickedsick )
    		set .@streakname$,"Wicked Sick";
    	else if ( @PlayersKilledStreak >= .unstoppable )
    		set .@streakname$,"Unstoppable";
    	else if ( @PlayersKilledStreak >= .megakill )
    		set .@streakname$,"Mega-kill";
    	else if ( @PlayersKilledStreak >= .dominating )
    		set .@streakname$,"Dominating";
    	else if ( @PlayersKilledStreak >= .killingspree )
    		set .@streakname$,"Killing Spree";
    	if ( @PlayersKilledStreak >= .killingspree && killerrid == getcharid(3) )
    		announce strcharinfo(0) +" has ended "+( (Sex)?"him":"her" )+" own "+ .@streakname$ +"["+ @PlayersKilledStreak +"] streak "+( (.announcemap)?("at "+ .@map$):""),16|.Announce;
    	else if ( @PlayersKilledStreak >= .killingspree )
    		announce rid2name(killerrid) +" has ended "+ strcharinfo(0) +"'s "+ .@streakname$ +"["+ @PlayersKilledStreak +"] streak "+( (.announcemap)?("at "+ .@map$):""),16|.Announce;
    	else if ( .announcekill && killerrid != getcharid(3) )
    		announce rid2name(killerrid) +" has pawned "+ strcharinfo(0) +"'s head "+( (.announcemap)?("at "+ .@map$):""),16|.Announce;
    	set @PlayersKilledStreak,0;
    	set @dota_sql_deaths, @dota_sql_deaths +1;
    	set @dota_multikills,0;
    	query_sql "replace into pvpladder values ( "+ getcharid(0) +", '"+ escape_sql(strcharinfo(0)) +"', "+ @dota_sql_streaks +", "+ @dota_sql_kills +", "+ @dota_sql_deaths +", from_unixtime("+ @dota_sql_streaktime +") )";
    	set .@killed_gid, getcharid(2);
    	if ( .@killed_gid ) {
    		setd ".dota_sql_"+ .@killed_gid +"_c", 0;
    		if ( getd(".dota_sql_"+ .@killed_gid +"_h") )
    			query_sql "replace into ownladder values ( "+ .@killed_gid +", '"+ escape_sql(getguildinfo(GUILDINFO_NAME, getcharid(CHAR_ID_GUILD))) +"', "+ getd(".dota_sql_"+ .@killed_gid +"_c") +", "+ getd(".dota_sql_"+ .@killed_gid +"_h") +", from_unixtime("+ getd(".dota_sql_"+ .@killed_gid +"_t") +") )";
    	}
    	if ( killerrid == getcharid(3) || BaseLevel < .lvltokill ) end;
    	if ( .minlvlrange ) set .@killedlvl, BaseLevel;
    	attachrid killerrid;
    	if ( .minlvlrange && .@killedlvl + .minlvlrange < BaseLevel ) end;
    	if ( .counttopunish ) {
    		if ( @sitkillminute != gettime(2) ) {
    			deletearray @sitkillid, 128;
    			deletearray @sitkilltimes, 128;
    			set @sitkillminute, gettime(2);
    		}
    		set .@sitkillsize, getarraysize(@sitkillid);
    		for ( set .@i,0; .@i < .@sitkillsize; set .@i, .@i +1 ) {
    			if ( @sitkillid[.@i] != killedrid ) continue;
    			else {
    				set @sitkilltimes[.@i], @sitkilltimes[.@i] +1 ;
    				if ( @sitkilltimes[.@i] >= .counttopunish ) {
    					warp "SavePoint",0,0;
    					announce strcharinfo(0) +" , Stop killing "+ rid2name(killedrid) + " !!!",0;
    					consolemes(CONSOLEMES_WARNING,  strcharinfo(0) +" is sit-killing "+ rid2name(killedrid) +" for "+ @sitkilltimes[.@i] + " times");
    					logmes "is sit-killing "+ rid2name(killedrid) +" for "+ @sitkilltimes[.@i] +" times";
    					if ( @PlayersKilledStreak == @dota_sql_streaks ) {
    						set @dota_sql_streaks, @dota_sql_streaks +1 - .counttopunish;
    						set @dota_sql_streaktime, gettimetick(2);
    					}
    					set @PlayersKilledStreak, @PlayersKilledStreak +1 - .counttopunish;
    					set @dota_sql_kills, @dota_sql_kills +1 - .counttopunish;
    					query_sql "replace into pvpladder values ( "+ getcharid(0) +", '"+ escape_sql(strcharinfo(0)) +"', "+ @dota_sql_streaks +", "+ @dota_sql_kills +", "+ @dota_sql_deaths +", from_unixtime("+ @dota_sql_streaktime +") )";
    					set .@killer_gid, getcharid(2);
    					if ( .@killer_gid ) {
    						if ( getd(".dota_sql_"+ .@killer_gid +"_c") == getd(".dota_sql_"+ .@killer_gid +"_h") ) {
    							setd ".dota_sql_"+ .@killer_gid +"_h", getd(".dota_sql_"+ .@killer_gid +"_h") +1 - .counttopunish;
    							setd ".dota_sql_"+ .@killer_gid +"_t", gettimetick(2);
    						}
    						setd (".dota_sql_"+ .@killer_gid +"_c"), getd(".dota_sql_"+ .@killer_gid +"_c") +1 - .counttopunish;
    						query_sql "replace into ownladder values ( "+ .@killer_gid +", '"+ escape_sql(getguildinfo(GUILDINFO_NAME, getcharid(CHAR_ID_GUILD))) +"', "+ getd(".dota_sql_"+ .@killer_gid +"_c") +", "+ getd(".dota_sql_"+ .@killer_gid +"_h") +", from_unixtime("+ getd(".dota_sql_"+ .@killer_gid +"_t") +") )";
    					}
    					end;
    				}
    				break;
    			}
    		}
    		if ( .@i == .@sitkillsize ) {
    			set @sitkillid[.@i], killedrid;
    			set @sitkilltimes[.@i], 1;
    		}
    	}
    	set @PlayersKilledStreak, @PlayersKilledStreak +1 ;
    	set @dota_sql_kills, @dota_sql_kills +1 ;
    	if ( @PlayersKilledStreak > @dota_sql_streaks ) {
    		set @dota_sql_streaks, @PlayersKilledStreak;
    		set @dota_sql_streaktime, gettimetick(2);
    	}
    	query_sql "replace into pvpladder values ( "+ getcharid(0) +", '"+ escape_sql(strcharinfo(0)) +"', "+ @dota_sql_streaks +", "+ @dota_sql_kills +", "+ @dota_sql_deaths +", from_unixtime("+ @dota_sql_streaktime +") )";
    	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 ( .@streakname$[1] != "" ) {
    		announce strcharinfo(0) +" "+ .@streakname$[1] +"["+ @PlayersKilledStreak +"] "+( (.announcemap)?("at "+ .@map$):"") + .@streakname$[2],16|.Announce;
    		if ( .sound == 1 ) soundeffectall .@streakname$[0],0,.@map$;
    		else if ( .sound == 2 ) soundeffectall .@streakname$[0],0;
    		else if ( .sound == 3 ) soundeffect .@streakname$[0],0;
    	}
    	set @dota_multikills, @dota_multikills + 1;
    	deltimer "DOTAPVP::OnStreakReset";
    	addtimer 18000,"DOTAPVP::OnStreakReset";
    	set .@killer_gid, getcharid(2);
    	if ( .@killer_gid && .@killer_gid != .@killed_gid ) {
    		setd ".dota_sql_"+ .@killer_gid +"_c", getd(".dota_sql_"+ .@killer_gid +"_c") +1 ;
    		if ( getd(".dota_sql_"+ .@killer_gid +"_c") > getd(".dota_sql_"+ .@killer_gid +"_h") ) {
    			setd ".dota_sql_"+ .@killer_gid +"_h", getd(".dota_sql_"+ .@killer_gid +"_c");
    			setd ".dota_sql_"+ .@killer_gid +"_t", gettimetick(2);
    		}
    		query_sql "replace into ownladder values ( "+ .@killer_gid +", '"+ escape_sql(getguildinfo(GUILDINFO_NAME, getcharid(CHAR_ID_GUILD))) +"', "+ getd(".dota_sql_"+ .@killer_gid +"_c") +", "+ getd(".dota_sql_"+ .@killer_gid +"_h") +", from_unixtime("+ getd(".dota_sql_"+ .@killer_gid +"_t") +") )";
    	}
    	set .@dota_multikills, @dota_multikills;
    	set .@origin, getcharid(3);
    	sleep 1500;
    	if ( .@killer_gid && .@killer_gid != .@killed_gid && getd(".dota_sql_"+ .@killer_gid +"_c") >= .owned && ( ( getd(".dota_sql_"+ .@killer_gid +"_c") - .owned ) % .owncontinue == 0 ) ) {
    		if ( .Announce ) mapannounce .@map$, "The guild ["+ getguildinfo(GUILDINFO_NAME, getcharid(CHAR_ID_GUILD)) +"] is OWNING["+ getd(".dota_sql_"+ .@killer_gid +"_c") +"] !!!",16;
    		else announce "The guild ["+ getguildinfo(GUILDINFO_NAME, getcharid(CHAR_ID_GUILD)) +"] is OWNING["+ getd(".dota_sql_"+ .@killer_gid +"_c") +"] !!!",16;
    		if ( .sound == 1 ) soundeffectall "ownage.wav",0,.@map$;
    		else if ( .sound == 2 ) soundeffectall "ownage.wav",0;
    		else if ( .sound == 3 && attachrid(.@origin) ) soundeffect "ownage.wav",0;
    	}
    	sleep 1250;
    	if ( !attachrid(.@origin) ) end;
    	if ( .@dota_multikills == 2 ) {
    		if ( .Announce ) mapannounce .@map$, strcharinfo(0) +" just got a Double Kill !",16;
    		else announce strcharinfo(0) +" just got a Double Kill !",16;
    		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 ( .Announce ) mapannounce .@map$, strcharinfo(0) +" just got a Triple Kill !!!",16;
    		else announce strcharinfo(0) +" just got a Triple Kill !!!",16;
    		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 ( .Announce ) mapannounce .@map$, strcharinfo(0) +" just got a Ultra Kill !!!",16;
    		else announce strcharinfo(0) +" just got a Ultra Kill !!!",16;
    		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 ( .Announce ) mapannounce .@map$, strcharinfo(0) +" is on a Rampage !!!",16;
    		else announce strcharinfo(0) +" is on a Rampage !!!",16;
    		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:
    	set @dota_multikills, 0;
    	end;
    OnWhisperGlobal:
    	if ( @spam_dotapvp + 3 >= gettimetick(2) ) // 3 seconds interval so player don spam this command
    		end;
    	set @spam_dotapvp, gettimetick(2);
    	if ( @dota_sql_kills == 0 && @dota_sql_deaths == 0 )
    		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;
    	if ( @dota_sql_kills || @dota_sql_deaths ) {
    		dispbottom "Your current Streak      : "+ @PlayersKilledStreak;
    		dispbottom "Your total Kills               : "+ @dota_sql_kills;
    		dispbottom "Your total Deaths          : "+ @dota_sql_deaths;
    		dispbottom "Your highest Streak      : "+ @dota_sql_streaks;
    		query_sql "select date_format( from_unixtime("+ @dota_sql_streaktime +"),'%a %e/%c/%y %r')", .@time1$;
    		dispbottom "Your highest Streak on : "+ .@time1$;
    	}
    	else
    		dispbottom "You are not in the pvp ladder yet.";
    	if ( getcharid(2) ) {
    		if ( getd(".dota_sql_"+ getcharid(2) +"_h") == 0 ) {
    			query_sql "select currentown, highestown, unix_timestamp(owntime) from ownladder where guild_id = "+ getcharid(2), .@c, .@h, .@t;
    			setd ".dota_sql_"+ getcharid(2) +"_c", .@c;
    			setd ".dota_sql_"+ getcharid(2) +"_h", .@h;
    			setd ".dota_sql_"+ getcharid(2) +"_t", .@t;
    		}
    		if ( getd(".dota_sql_"+ getcharid(2) +"_h") ) {
    			dispbottom "Your guild current Own      : "+ getd(".dota_sql_"+ getcharid(2) +"_c");
    			dispbottom "Your guild highest Own      : "+ getd(".dota_sql_"+ getcharid(2) +"_h");
    			query_sql "select date_format( from_unixtime("+ getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_t"), "DOTAPVP" ) +"),'%a %e/%c/%y %r')", .@time2$;
    			dispbottom "Your guild highest Own on : "+ .@time2$;
    		}
    		else
    			dispbottom "Your guild is not in the ladder yet.";
    	}
    	end;
    OnPCLoginEvent:
    	if ( .maptrigger$ != "all" ) end;
    OnPCLoadMapEvent:
    	if ( @dota_sql_kills == 0 && @dota_sql_deaths == 0 ) {
    		if ( .maptrigger$ != "all" ) {
    			getmapxy .@map$, .@x, .@y, 0;
    			for ( set .@i, 0; .@i < .maptriggersize; set .@i, .@i +1 ) {
    				if ( .@map$ == .maptrigger$[.@i] ) break;
    			}
    			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;
    	}
    	if ( getcharid(2) && getd(".dota_sql_"+ getcharid(2) +"_h") == 0 ) {
    		query_sql "select currentown, highestown, unix_timestamp(owntime) from ownladder where guild_id = "+ getcharid(2), .@c, .@h, .@t;
    		setd ".dota_sql_"+ getcharid(2) +"_c", .@c;
    		setd ".dota_sql_"+ getcharid(2) +"_h", .@h;
    		setd ".dota_sql_"+ getcharid(2) +"_t", .@t;
    	}
    	end;
    }
    
    prontera,165,174,5	script	PvP-StatsViewer	4_BULLETIN_BOARD2,{
    	set .@npcname$, strnpcinfo(0);
    	while (1) {
    		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" ) ) {
    			case 1:
    				set .@nb, query_sql("select name, kills, deaths from pvpladder order by kills desc limit "+ getvariableofnpc(.showtotal,"DOTAPVP"), .@name$, .@kills, .@deaths);
    				if ( .@nb == 0 ) {
    					mes "["+ .@npcname$ +"]";
    					mes "The ladder currently is empty.";
    					next;
    				}
    				for ( set .@j,0; .@j < .@nb; set .@j, .@j + getvariableofnpc(.showpage,"DOTAPVP") ) {
    					mes "["+ .@npcname$ +"]";
    					for ( set .@i, .@j; .@i < (getvariableofnpc(.showpage,"DOTAPVP") + .@j) && .@i < .@nb; set .@i, .@i + 1 ) {
    						mes "^996600"+ (.@i+1) +": ^006699"+ .@name$[.@i] +" ^00AA00["+ .@kills[.@i] +"] ^FF0000<"+ .@deaths[.@i] +">^000000";
    					}
    					next;
    				}
    				break;
    			case 2:
    				set .@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 == 0 ) {
    					mes "["+ .@npcname$ +"]";
    					mes "The ladder currently is empty.";
    					next;
    				}
    				for ( set .@j,0; .@j < .@nb; set .@j, .@j + getvariableofnpc(.showpage,"DOTAPVP") ) {
    					mes "["+ .@npcname$ +"]";
    					for ( set .@i, .@j; .@i < (getvariableofnpc(.showpage,"DOTAPVP") + .@j) && .@i < .@nb; set .@i, .@i + 1 ) {
    						mes "^996600"+ (.@i+1) +": ^006699"+ .@name$[.@i] +" ^70AC11{"+ .@streak[.@i] +"} ^000000on :";
    						mes "    ^EE8800"+ .@time$[.@i] +"^000000";
    					}
    					next;
    				}
    				break;
    			case 3:
    				set .@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 == 0 ) {
    					mes "["+ .@npcname$ +"]";
    					mes "The ladder currently is empty.";
    					next;
    				}
    				for ( set .@j,0; .@j < .@nb; set .@j, .@j + getvariableofnpc(.showpage,"DOTAPVP") ) {
    					mes "["+ .@npcname$ +"]";
    					for ( set .@i, .@j; .@i < (getvariableofnpc(.showpage,"DOTAPVP") + .@j) && .@i < .@nb; set .@i, .@i + 1 ) {
    						mes "^996600"+ (.@i+1) +": ^006699"+ .@name$[.@i] +" ^00AAAA("+ .@owned[.@i] +") ^000000on :";
    						mes "    ^EE8800"+ .@time$[.@i] +"^000000";
    					}
    					next;
    				}
    				break;
    			case 4:
    				if ( @dota_sql_kills == 0 && @dota_sql_deaths == 0 )
    					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$;
    				mes "["+ .@npcname$ +"]";
    				if ( @dota_sql_kills == 0 && @dota_sql_deaths == 0 )
    					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 :";
    						query_sql "select date_format( from_unixtime("+ @dota_sql_streaktime +"),'%a %e/%c/%y %r')", .@time1$;
    						mes "    ^EE8800"+ .@time1$ +"^000000";
    					}
    				}
    				next;
    				if ( getcharid(2) ) {
    					if ( getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_h"), "DOTAPVP" ) == 0 ) {
    						query_sql "select currentown, highestown, unix_timestamp(owntime) from ownladder where guild_id = "+ getcharid(2), .@c, .@h, .@t;
    						set getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_c"), "DOTAPVP" ), .@c;
    						set getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_h"), "DOTAPVP" ), .@h;
    						set getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_t"), "DOTAPVP" ), .@t;
    					}
    					mes "["+ .@npcname$ +"]";
    					if ( getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_h"), "DOTAPVP" ) == 0 ) {
    						mes "Your guild not yet kill any player.";
    					} else {
    						mes "Your guild name : ^006699"+ strcharinfo(2) +"^000000";
    						mes "Current Owning  : ^00AAAA("+ getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_c"), "DOTAPVP" ) +")^000000";
    						mes "Longest Ownage was ^00AAAA("+ getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_h"), "DOTAPVP" ) + ")^000000 on :";
    						query_sql "select date_format( from_unixtime("+ getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_t"), "DOTAPVP" ) +"),'%a %e/%c/%y %r')", .@time2$;
    						mes "    ^EE8800"+ .@time2$ +"^000000";
    					}
    					next;
    				}
    				break;
    			case 5:
    				mes "["+ .@npcname$ +"]";
    				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;
    		}
    	}
    }

     

     


  5. Good day!

    May I request to clean my script. I kept getting infinity loop error despite placing freeloop(true/false)
    Please help me. thanks!

    Here's the script.

    //===== Hercules Script ======================================
    //= Healer
    //===== By: ==================================================
    //= Euphy
    //===== Current Version: =====================================
    //= 1.2
    //===== Description: =========================================
    //= Basic healer script.
    //===== Additional Comments: =================================
    //= 1.0 Initial script.
    //= 1.1 Aligned coordinates with @go.
    //= 1.2 Fix variables and character stuck at healing
    //============================================================
    function	script	H_VIPBuff	{
    		query_sql( "SELECT CAST( `vip` AS DATE ),DATEDIFF( IFNULL(`vip`,NOW()),NOW() ), TIMESTAMPDIFF(SECOND, NOW(), `vip`) FROM `login` WHERE `account_id` = "+getcharid(3)+" LIMIT 1", .@vip_date$, .@day, .@vip_second);
    		if ( .@day > 0 || .@vip_second > 0) {
    		return true;
    	end;
    }
    		return false;
    }
    
    -	script	Healer	FAKE_NPC,{
    
    	.@price = 0;	// Zeny required for heal
    	.@Buffs = 1;	// Also buff players? (1: yes / 0: no)
    	.@Delay = 2;	// Heal delay, in seconds
    
    	if (@HD > gettimetick(2)) end;
    	if (.@price) {
    		message strcharinfo(PC_NAME),"Healing costs "+.@price+" Zeny.";
    		if (Zeny < .@price) end;
    		if(select("^0055FFHeal^000000", "^777777Cancel^000000") == 2) close;
    		Zeny -= .@price;
    	}
    
    	specialeffect(EF_HEAL2, AREA, playerattached()); percentheal 100,100;
    
    	if (callfunc ("H_VIPBuff")) {
    
    	sc_end SC_STONE;
    	sc_end SC_FREEZE;
    	sc_end SC_STUN;
    	sc_end SC_SLEEP;
    	sc_end SC_POISON;
    	sc_end SC_CURSE;
    	sc_end SC_SILENCE;
    	sc_end SC_CONFUSION;
    	sc_end SC_BLIND;
    	sc_end SC_BLOODING;
    	sc_end SC_DPOISON;
    	sc_end SC_FEAR;
    	sc_end SC_COLD;
    	sc_end SC_BURNING;
    	sc_end SC_DEEP_SLEEP;
    	sc_end SC_DEC_AGI;
    	sc_end SC_BROKENARMOR;
    	sc_end SC_BROKENWEAPON;
    	sc_end SC_NOEQUIPWEAPON;
    	sc_end SC_NOEQUIPSHIELD;
    	sc_end SC_NOEQUIPARMOR;
    	sc_end SC_NOEQUIPHELM;
    	sc_end SC__STRIPACCESSARY;
    	sc_end SC_PROPERTYUNDEAD;
    	sc_end SC_ORCISH;
    	sc_end SC_BERSERK;
    	sc_end SC_SKE;
    	sc_end SC_SWOO;
    	sc_end SC_SKA;
    	sc_end SC_SLOWDOWN;
    	sc_end SC_FROSTMISTY;
    	sc_end SC_ILLUSION;
    	sc_end SC_BITESCAR;
    
    		//sc_start SC_CASH_PLUSEXP,.exp_bonus_duration,.bonus_vip_exp_rate;
    		//sc_start SC_CASH_RECEIVEITEM,.bonus_duration,.bonus_vip_drop_rate;
    
    		specialeffect(EF_INCAGILITY, AREA, playerattached());
    		sc_start SC_INC_AGI,240000,10;
    		specialeffect(EF_BLESSING, AREA, playerattached());
    		sc_start SC_BLESSING,240000,10;
           		specialeffect(EF_KYRIE, AREA, playerattached());
    		sc_start SC_KYRIE, 120000, 3;
    		specialeffect( EF_IMPOSITIO, AREA, playerattached());
    		sc_start SC_IMPOSITIO, 60000, 3;
    		specialeffect(EF_GLORIA, AREA, playerattached());
    		sc_start SC_GLORIA, 30000, 3;
    
    
    	if( getbrokenid(1) ) repairall;
    		getinventorylist;
    		while( .@i < @inventorylist_count ){
    
    	getinventorylist;
    	freeloop(true);
    
    	for( .@i = 0; .@i < @inventorylist_count; .@i++ ) {
    		if ( @inventorylist_identify[.@i] == 1 )
    			continue;
    		else if ( getskilllv(MC_IDENTIFY) == 1 && Sp >= 10 )
    			heal 0,0; // lol... this is supposed to reduce their SP by 10, whatever
    		else if ( countitem(Spectacles) )
    			delitem Spectacles,1;
    		else if ( getskilllv(RG_COMPULSION) && Zeny >= ( 100 - ( 5 + 4 * getskilllv(RG_COMPULSION) ) )* 2/5 )
    			Zeny -= ( 100 - ( 5 + 4 * getskilllv(RG_COMPULSION) ) )* 2/5;
    		else if ( getskilllv(MC_DISCOUNT) && Zeny >= ( 100 - ( 5 + 2 * getskilllv(MC_DISCOUNT) ) )* 2/5 )
    			Zeny -= ( 100 - ( 5 + 2 * getskilllv(MC_DISCOUNT) ) )* 2/5;
    		else if ( Zeny >= 40 )
    			Zeny -= 40;
    		else
    			break;
    		delitem2 @inventorylist_id[.@i], 1, 0, @inventorylist_refine[.@i], @inventorylist_attribute[.@i], @inventorylist_card1[.@i], @inventorylist_card2[.@i], @inventorylist_card3[.@i], @inventorylist_card4[.@i];
    		getitem2 @inventorylist_id[.@i], 1, 1, @inventorylist_refine[.@i], 0, @inventorylist_card1[.@i], @inventorylist_card2[.@i], @inventorylist_card3[.@i], @inventorylist_card4[.@i];
    		.@icount++;
    	}
    	freeloop(false);
    
    	if ( .@icount )
    		message strcharinfo(0), "Identified "+ .@icount +" Items.";
    	}
    }
    else {
    	if (.@Buffs) {
    		specialeffect(EF_INCAGILITY, AREA, playerattached());
    		sc_start SC_INC_AGI,240000,5;
    		specialeffect(EF_BLESSING, AREA, playerattached());
    		sc_start SC_BLESSING,240000,5;
    }
    	if (.@Delay) @HD = gettimetick(2)+.@Delay;
    	end;
    
    }
    }
    

    image.png.afb32c8ad4bcc6ae154a15660b487ac2.png


  6. Good day!

    May I know if this is bug, at some point pecopeco head band only give +1 asp in stat if you reach 185 aspd but below  180 aspd it give you +2. Cant reach the 190 aspd.
    Can someone please confirm or explain why? Here's the item and script i am running pre-renewal server. already diable renewal aspd.

     

    		bonus bSpeedRate,25;
    		bonus bAspdRate,5;
    		bonus bVariableCastrate,5;

     

    image.png.ce29873c023d21fa89f884fdf6afce76.png


  7. Good day!

    May I request help,

    I don't know how to get rid of these error. I am running PRE-RE but im getting error for RENEWAL MONSTER THAT are not included in the script.

    Please help me. thanks!

    image.png.39f22e118e209d73e0393686cb2c3e03.png

     

    Script:

    prontera,164,165,4	script	MVP Checker::convex	2_BULLETIN_BOARD,{
       
        for( .@i = 0; .@i < getarraysize( $MVP_MobID ); .@i++ ) {
            if($MVP_Status[.@i] == 2){
                .status$[.@i] = "^008000ALIVE^000000";
            } else .status$[.@i] = "^ff0000DEAD^000000";
        mes ""+getmonsterinfo($MVP_MobID[.@i],MOB_NAME)+"" + "^000000 (^008080" + $MVP_Maps$[.@i] + "^000000) "+.status$[.@i]+"";
        }
         close;  
        OnNPCKillEvent:
        if( getmonsterinfo(killedrid, MOB_MVPEXP) > 0 )
            for( set .@i,0; .@i < getarraysize($MVP_MobID); set .@i, .@i+1 )
            {
                if( (killedrid == $MVP_MobID[.@i]) && (strcharinfo(3) == $MVP_Maps$[.@i])) {
                    $MVP_Status[.@i] = 1;
                    $MVP_TimeStamp[.@i] = gettimetick(2);
                }    
            }
        end;
     
    OnInit:
        setarray $MVP_MobID[0],	1511,1785,1785,1785,1785,1785,1039,1272,1272,1719,
    		1046,1046,1389,1112,1115,1115,1418,1252,1768,1086,
    		1885,1832,1734,1688,1373,1147,1147,1059,1150,1087,
    		1087,1190,1038,1157,1159,1623,1492,1251,1583,1312,
    		1751,1685,1630,1871,1873,1658;
                               
        setarray $MVP_Maps$[0],"moc_pryd06","ra_fild02","ra_fild03","ra_fild04","ve_fild01","ve_fild02","prt_maze03","gl_chyard","gld_dun04","abyss_03",
    		"gef_dun02","gld_dun02","gef_dun01","treasure02","gld_dun01","pay_fild11","gon_dun03","xmas_fild01","ra_san05","prt_sewb4",
    		"mosk_dun03","thor_v03","kh_dun02","ayo_dun02","niflheim","gld_dun03","anthell02","mjolnir_04","pay_dun04","gef_fild02",
    		"gef_fild14","gef_fild10","moc_pryd04","in_sphinx5","moc_fild17","ein_dun02","ama_dun03","xmas_dun02","beach_dun","tur_dun04",
    		"odin_tem03","jupe_core","lou_dun03","abbey02","abbey03","lhz_dun02";
                               
        setarray $MVP_ResTime[0],60,240,180,300,180,360,120,60,480,180,
    		120,480,60,120,480,120,94,120,300,60,
    		120,660,120,420,91,480,120,120,60,1440,
    		60,120,60,60,120,125,91,60,300,60,
    		480,120,117,120,730,120;
                           
    //Respawn only undead MVP's on server start or reload                    
        for( set .@i,0; .@i < getarraysize($MVP_MobID); set .@i, .@i+1 )
        {
            //check whether MPV is alive or $MVP_Status variable is not yet set.  
            //1 - Dead, 2 - Alive
            if ( $MVP_Status[.@i] == 2 || $MVP_Status[.@i] == 0 || $MVP_TimeStamp[.@i] == 0  ) {  
                //monster $MVP_maps$[.@i],0,0,"--ja--",$MVP_MobID[.@i],1;
                $MVP_Status[.@i] = 2;
            } else { // don't respawn MVP and wait for next spawn time
                $MVP_Status[.@i] = 1;
            }    
        }
       
    startnpctimer;
        OnTimer60000: //check every 60 seconds
            for( set .@i,0; .@i < getarraysize($MVP_MobID); set .@i, .@i+1 )
            {
                set .@time, $MVP_ResTime[.@i]*60;
                if( ($MVP_TimeStamp[.@i] + .@time) <= gettimetick(2) && $MVP_Status[.@i] == 1 ) {
                    //monster $MVP_Maps$[.@i],0,0,"--ja--",$MVP_MobID[.@i],1;
                    //Defines last respawn
                    $MVP_TimeStamp[.@i] = gettimetick(2);
                    $MVP_Status[.@i] = 2;
                }
            }
            setnpctimer 0;
    end;
    }

     


  8. 2 hours ago, Chatterboy said:

    You sure no error in your GRF? 

    Yes, I am sure. because what I did is just extract my.grf then use the data.
     

    2 hours ago, Chatterboy said:

    you can view using GRF EDITOR if there is a misconvert language ASCII to KOREAN when repacking the data folder to your.grf 

    Which folder should I check?

    By the way I am patching file as ASCII, would it affect?


  9. 1 minute ago, Tio Akima said:

     

    which path does your hexed take first?
    * read data folder first
    * read first grf

     

    when you use your data folder, the client may actually be reading the kro data.grf first to avoid causing problems ...

    well, try to change the sprite of this mob that is giving problems ...
    Alias, enter the mobs folder, and check that the monster is there and that the file is not damaged.


    I tried locating the monster but I can't find that sprite. even downloading the latest KRO. data.grf and rdata.grf I cant find that sprite name. 
    Where can I also locate it in my folder to change it?


  10. Do you have idea why my client crashed

    If I use my .grf my client crashes and have these  sprite error but if I just use the data folder works fine.

    00# [FAIL] sprite\¸ó½ºÅÍ\Ãʺ¸ÀÚ.act [266 ms]
    01# [FAIL] sprite\¸ó½ºÅÍ\Ãʺ¸ÀÚ.act [266 ms]
    02# [FAIL] sprite\¸ó½ºÅÍ\Ãʺ¸ÀÚ.spr [266 ms]
    03# [FAIL] sprite\¸ó½ºÅÍ\Ãʺ¸ÀÚ.spr [266 ms]


    Client crashed.

    1=my.grf
    2=palletes.grf
    3=data.grf
    4=rdata.grf

     

    Vs


    1=data (consisting all in my.grf)
    2=palletes.grf
    3=data.grf
    4=rdata.grf


  11. Good day Master Scripters!

    Please help me how to make this accurate, script say red(DeadMVP) but upon checking in MAP MVP is ALIVE and KICKING.

     

    // https://www.eathena.ws/board/index.php?&act=attach&type=post&id=5866
    
    //===== eAthena Script =======================================
    //= Super Convex Mirror
    //===== By: ==================================================
    //= Brian
    //===== Current Version: =====================================
    //= 1.0
    //===== Compatible With: =====================================
    //= eAthena SVN
    //===== Description: =========================================
    //= Detects if every MVP is alive or dead.
    //===== Additional Comments: =================================
    //= http://www.eathena.ws/board/index.php?showtopic=242050
    //============================================================
    
    geffen,140,173,5	script	MVP Checker::convex	882,{
    	for( .@i = 0; .@i < getarraysize( .mvp_name$ ); .@i++ ) {
    		switch (.@i) {
    			case 42:
    				.@alive = ( $@thana_summon < 6 || mobcount( "thana_boss", "#Death::OnThanaDead" ) );
    			break;
    			default:
    				.@alive = mobcount( .mvp_map$[.@i], "" );
    			break;
    		}
    		
    		if ( .display_type == 2 )
    			.@menu$ = .@menu$ + ( ( .@alive ) ? "^008000" : "^FF0000" ) + .mvp_name$[.@i] + "^000000 (" + .mvp_map$[.@i] + "):";
    		else if ( .display_type == 1 )
    			mes ( ( .@alive ) ? "^FF0000" : "^008000" ) + .mvp_name$[.@i] + "^000000 (" + .mvp_map$[.@i] + ")";
    	}
    	
    	if ( .display_type == 1 ) close;
    	
    	.@num = select( .@menu$ ) - 1;
    	
    	if (.warp_to_mvp == 1)
    		warp .mvp_map$[.@num],0,0;
    	else if(.warp_to_mvp == 2) {
    		sleep2 1000;
    		sc_start SC_BOSSMAPINFO,600000,0;
    	}
    	end;
    
    	OnInit:
    		 // 0 = disabled, 1 = enabled, 2 = enabled + SC_BOSSMAPINFO
    		.warp_to_mvp = 0;
    		
    		setarray .mvp_map$, 
    			"moc_pryd06","ra_fild03","ra_fild04","ve_fild01","ve_fild02",
    			"lou_dun03","prt_maze03","abbey03",
    			"gl_chyard","abyss_03","gef_dun02","gef_dun01","treasure02",
    			"pay_fild10","gon_dun03","abbey02","xmas_fild01","ra_san05",
    			"prt_sewb4","mosk_dun03","thor_v03","ama_dun03",
    			"kh_dun02","ayo_dun02","niflheim","anthell02",
    			"mjolnir_04","pay_dun04","gef_fild03","gef_fild10",
    			"moc_pryd04","in_sphinx5","moc_fild17","ein_dun02","xmas_dun02",
    			"beach_dun","thana_boss","tur_dun04","odin_tem03",
    			"jupe_core","lhz_dun02";
    
    		setarray .mvp_name$, 
    			"AmonRa","Atroce","Atroce","Atroce","Atroce",
    			"Bacsojin","Baphomet","Beelzebub",
    			"DarkLord","Detale","Doppelganger","Dracula","Drake",
    			"Eddga","EvilSnakeLord","FallenBishop","Garm","GloomUnderNight",
    			"GoldenThiefBug","Gopinich","Ifrit","IncantationSamurai",
    			"KielD01","LadyTanee","LordofDeath","Maya",
    			"Mistress","MoonlightFlower","OrcHero","OrcLord",
    			"Osiris","Pharaoh","Phreeoni","RSX0806","Stormy Knight",
    			"TaoGunka","Thanatos","TurtleGeneral","ValkyrieRandgris",
    			"Vesper","Ygnizem";
    		
    		.display_type = 1;
    		
    		if( .warp_to_mvp > 0 )
    			.display_type = 2;
    	end;
    }

     


  12. Good day!

    For clarification is it necessary to have @reloadmobdb in floating rate? I am only changing the exp rate and not the drop rate. Thanks!
     

    -	script	WeekFloatingRates	-1,{
    
    	OnInit:
    	set $@brate,rand(15000,25000);
    	set $@jrate,rand(15000,25000);
    
    	OnMon1100:
    	OnMon2300:
    	OnTue0600:
    	OnTue1500:
    	OnWed0000:
    	OnWed1000:
    	OnWed1900:
    	OnThu0200:
    	OnThu1200:
    	OnThu2100:
    	OnFri0600:
    	OnFri1500:
    	OnFri2300:
    
    		setbattleflag "base_exp_rate", 10000;
    		setbattleflag "job_exp_rate", 10000;
    		atcommand "@reloadmobdb";
    		announce "Bonus Happy Hour Experience has ended.",bc_all,0x00FFFF;
    		end;
    
    	OnMon0600:
    	OnMon1800:
    	OnTue0200:
    	OnTue1100:
    	OnTue2000:
    	OnWed0400:
    	OnWed1400:
    	OnWed2300:
    	OnThu0600:
    	OnThu1600:
    	OnFri0000:
    	OnFri1100:
    	OnFri1900:
    		setbattleflag "base_exp_rate", $@brate;
    		setbattleflag "job_exp_rate", $@jrate;
    		
        		announce "Happy Hour Experience bonus has just started! Check @rates for rate info!!",bc_all,0x00FFFF;
    		end;
    }

     


  13. Good day!

    May I know what spr and act is this? I can't seem to find in data.grf and rdata.grf. thanks!

     

    00# [FAIL] sprite\¸ó½ºÅÍ\Ãʺ¸ÀÚ.act [266 ms]
    01# [FAIL] sprite\¸ó½ºÅÍ\Ãʺ¸ÀÚ.act [266 ms]
    02# [FAIL] sprite\¸ó½ºÅÍ\Ãʺ¸ÀÚ.spr [266 ms]
    03# [FAIL] sprite\¸ó½ºÅÍ\Ãʺ¸ÀÚ.spr [266 ms]


  14. Good day!
    May I request to place weekly reward of Top 10 players in this PVP ladder by @AnnieRuru. and can also view previous weeks ranking. please tnx.
     

    Spoiler
    
    //===== eAthena Script =======================================================
    //= PVP ladder script with dota announcement ( SQL only )
    //===== By: ==================================================================
    //= ~AnnieRuru~
    //===== Current Version: =====================================================
    //= 2.9
    //===== Compatible With: =====================================================
    //= eAthena SQL 14279, with MySQL 5.1
    //===== Description: =========================================================
    //= PVP ladder store in SQL table
    //= plus anti-sit-killer feature
    //===== Topic ================================================================
    //= http://www.eathena.ws/board/index.php?showtopic=177918
    //===== Additional Comments: =================================================
    //= still don't have modify value option, will be done ... in next year ...
    //============================================================================
    
    //	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
    final_dest	mapflag	loadevent
    guild_vs1	mapflag	loadevent
    guild_vs2	mapflag	loadevent
    guild_vs3	mapflag	loadevent
    guild_vs4	mapflag	loadevent
    guild_vs5	mapflag	loadevent
    cell_game	mapflag	loadevent
    ordeal_2-1	mapflag	loadevent
    pvp_y_1-2	mapflag	loadevent
    
    
    -	script	DOTAPVP	-1,{
    OnInit:
    	query_sql "select datediff( curdate(), '"+ $mvp_rank_1st_sunday +"' ) /7", .this_week_index;
    	if ( .this_week_index == $mvp_rank_week_index ) end;
    	.@query$  = "SELECT char_id, `name`, IF(@d=t.`mvp_kills`, @r, @r:=@i), @d:=t.`mvp_kills`, @i:=@i+1 ";
    	.@query$ += "FROM `mvp_rank` t, (SELECT @d:=0, @r:=0, @i:=1)q ";
    	.@query$ += "ORDER BY `mvp_kills` DESC LIMIT 10";
    	.@nb = query_sql(.@query$, .@cid, .@name$, .@rank, .@kills, .@dummy);
    	if ( .@nb ) {
    		for ( .@i = 0; .@i < .@nb; ++.@i ) {
    			.@reward_query$[.@i] = "( "+ .@cid[.@i] +", "+ $mvp_rank_week_index +", "+ .@rank[.@i] +" )";
    			.@archive_query$[.@i] = "( "+ $mvp_rank_week_index +", "+ .@rank[.@i] +", "+ .@cid[.@i] +", '"+ escape_sql(.@name$[.@i]) +"', "+ .@kills[.@i] +" )";
    		}
    	//	query_sql "truncate table mvp_rank_archive"; // uncomment this line if you love to periodically clean your data
    		query_sql "insert into mvp_rank_reward values "+ implode( .@reward_query$, ", " );
    		query_sql "insert into mvp_rank_archive values "+ implode( .@archive_query$, ", " );
    		query_sql "truncate table mvp_rank";
    	}
    	$mvp_rank_week_index = .this_week_index;
    	end;
    
    // Config
    	set .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
    	set .Announce, 1; // announce to : 0 - global, 1 - map
    	set .announcemap, 1; // announce the map name in the announcement ? : 0 - off, 1 - on
    
    	set .announcekill, 1; // announce who pawn who's head : 0 - off, 1 - on
    	set .msg_die, 0; // show message who kill you when die : 0 - off, 1 - on
    	set .msg_kill, 0; // show message you kill who when killed someone : 0 - off, 1 - on
    
    	set .gmnokill, 0; // 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
    
    	set .killingspree, 3;
    	set .dominating, 4;
    	set .megakill, 5;
    	set .unstoppable, 6;
    	set .wickedsick, 7;
    	set .monsterkill, 8;
    	set .godlike, 9;
    	set .holyshit, 10;
    	set .continue, 1; // after beyond-godlike, every <this number> kills will make announcement again
    
    	set .owned, 5; // how many times the party/guild has to kill to announce ownage
    	set .owncontinue, 1; // after ownage, every <this number> party/guild cumulative kills will make ownage announce again
    
    	set .min_gm_menu, 90; // minimum level of GM can use the GM menu on ladder npc
    
    	set .showtotal, 10; // show the length of ladder. Note : Maximum value = 128
    	set .showpage, 10;	// set the views per page. Note : Maximum value = 128
    	set .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
    	set .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",
    		"guild_vs4",
    		"guild_vs5",
    		"ordeal_2-1",
    		"final_dest",
    		"cell_game",
    		"pvp_y_1-2";
    
    
    //	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 )
    	set .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
    	set .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
    	set .minlvlrange, 0;
    
    
    // Config ends ------------------------------------------------------------------------------------------
    
    //	to prevent bug happen
    	if ( .Announce < 0 || .Announce > 1 ) set .Announce, 0;
    	if ( .continue < 1 ) set .continue, 1;
    	if ( .owncontinue < 1 ) set .owncontinue, 1;
    	if ( .gmnokill <= 0 ) set .gmnokill, 100;
    	if ( .lvltokill <= 1 ) set .lvltokill, 0;
    	if ( .counttopunish <= 1 ) set .counttopunish, 0;
    	set .maptriggersize, getarraysize(.maptrigger$);
    	end;
    
    //	script start.
    OnPCKillEvent:
    	if ( getgmlevel() >= .gmnokill ) end;
    	getmapxy .@map$, .@x, .@y, 0;
    	if ( .maptrigger$ != "all" ) {
    		for ( set .@i, 0; .@i < .maptriggersize; set .@i, .@i +1 ) {
    			if ( .@map$ == .maptrigger$[.@i] ) break;
    		}
    		if ( .@i == .maptriggersize ) end;
    	}
    	attachrid killedrid;
    	if ( killerrid != getcharid(3) && ( .msg_die || .msg_kill ) ) {
    		if ( .msg_die ) message strcharinfo(0),"You have been killed by "+ rid2name(killerrid);
    		if ( .msg_kill ) message rid2name(killerrid),"You just killed "+ strcharinfo(0);
    	}
    	if ( @PlayersKilledStreak >= .holyshit )
    		set .@streakname$,"Beyond Godlike";
    	else if ( @PlayersKilledStreak >= .godlike )
    		set .@streakname$,"Godlike";
    	else if ( @PlayersKilledStreak >= .monsterkill )
    		set .@streakname$,"Monster Kill";
    	else if ( @PlayersKilledStreak >= .wickedsick )
    		set .@streakname$,"Wicked Sick";
    	else if ( @PlayersKilledStreak >= .unstoppable )
    		set .@streakname$,"Unstoppable";
    	else if ( @PlayersKilledStreak >= .megakill )
    		set .@streakname$,"Mega-kill";
    	else if ( @PlayersKilledStreak >= .dominating )
    		set .@streakname$,"Dominating";
    	else if ( @PlayersKilledStreak >= .killingspree )
    		set .@streakname$,"Killing Spree";
    	if ( @PlayersKilledStreak >= .killingspree && killerrid == getcharid(3) )
    		announce strcharinfo(0) +" has ended "+( (Sex)?"him":"her" )+" own "+ .@streakname$ +"["+ @PlayersKilledStreak +"] streak "+( (.announcemap)?("at "+ .@map$):""),16|.Announce;
    	else if ( @PlayersKilledStreak >= .killingspree )
    		announce rid2name(killerrid) +" has ended "+ strcharinfo(0) +"'s "+ .@streakname$ +"["+ @PlayersKilledStreak +"] streak "+( (.announcemap)?("at "+ .@map$):""),16|.Announce;
    	else if ( .announcekill && killerrid != getcharid(3) )
    		announce rid2name(killerrid) +" has pawned "+ strcharinfo(0) +"'s head "+( (.announcemap)?("at "+ .@map$):""),16|.Announce;
    	set @PlayersKilledStreak,0;
    	set @dota_sql_deaths, @dota_sql_deaths +1;
    	set @dota_multikills,0;
    	query_sql "replace into pvpladder values ( "+ getcharid(0) +", '"+ escape_sql(strcharinfo(0)) +"', "+ @dota_sql_streaks +", "+ @dota_sql_kills +", "+ @dota_sql_deaths +", from_unixtime("+ @dota_sql_streaktime +") )";
    	set .@killed_gid, getcharid(2);
    	if ( .@killed_gid ) {
    		setd ".dota_sql_"+ .@killed_gid +"_c", 0;
    		if ( getd(".dota_sql_"+ .@killed_gid +"_h") )
    			query_sql "replace into ownladder values ( "+ .@killed_gid +", '"+ escape_sql(getguildinfo(GUILDINFO_NAME, getcharid(CHAR_ID_GUILD))) +"', "+ getd(".dota_sql_"+ .@killed_gid +"_c") +", "+ getd(".dota_sql_"+ .@killed_gid +"_h") +", from_unixtime("+ getd(".dota_sql_"+ .@killed_gid +"_t") +") )";
    	}
    	if ( killerrid == getcharid(3) || BaseLevel < .lvltokill ) end;
    	if ( .minlvlrange ) set .@killedlvl, BaseLevel;
    	attachrid killerrid;
    	if ( .minlvlrange && .@killedlvl + .minlvlrange < BaseLevel ) end;
    	if ( .counttopunish ) {
    		if ( @sitkillminute != gettime(2) ) {
    			deletearray @sitkillid, 128;
    			deletearray @sitkilltimes, 128;
    			set @sitkillminute, gettime(2);
    		}
    		set .@sitkillsize, getarraysize(@sitkillid);
    		for ( set .@i,0; .@i < .@sitkillsize; set .@i, .@i +1 ) {
    			if ( @sitkillid[.@i] != killedrid ) continue;
    			else {
    				set @sitkilltimes[.@i], @sitkilltimes[.@i] +1 ;
    				if ( @sitkilltimes[.@i] >= .counttopunish ) {
    					warp "SavePoint",0,0;
    					announce strcharinfo(0) +" , Stop killing "+ rid2name(killedrid) + " !!!",0;
    					consolemes(CONSOLEMES_WARNING,  strcharinfo(0) +" is sit-killing "+ rid2name(killedrid) +" for "+ @sitkilltimes[.@i] + " times");
    					logmes "is sit-killing "+ rid2name(killedrid) +" for "+ @sitkilltimes[.@i] +" times";
    					if ( @PlayersKilledStreak == @dota_sql_streaks ) {
    						set @dota_sql_streaks, @dota_sql_streaks +1 - .counttopunish;
    						set @dota_sql_streaktime, gettimetick(2);
    					}
    					set @PlayersKilledStreak, @PlayersKilledStreak +1 - .counttopunish;
    					set @dota_sql_kills, @dota_sql_kills +1 - .counttopunish;
    					query_sql "replace into pvpladder values ( "+ getcharid(0) +", '"+ escape_sql(strcharinfo(0)) +"', "+ @dota_sql_streaks +", "+ @dota_sql_kills +", "+ @dota_sql_deaths +", from_unixtime("+ @dota_sql_streaktime +") )";
    					set .@killer_gid, getcharid(2);
    					if ( .@killer_gid ) {
    						if ( getd(".dota_sql_"+ .@killer_gid +"_c") == getd(".dota_sql_"+ .@killer_gid +"_h") ) {
    							setd ".dota_sql_"+ .@killer_gid +"_h", getd(".dota_sql_"+ .@killer_gid +"_h") +1 - .counttopunish;
    							setd ".dota_sql_"+ .@killer_gid +"_t", gettimetick(2);
    						}
    						setd (".dota_sql_"+ .@killer_gid +"_c"), getd(".dota_sql_"+ .@killer_gid +"_c") +1 - .counttopunish;
    						query_sql "replace into ownladder values ( "+ .@killer_gid +", '"+ escape_sql(getguildinfo(GUILDINFO_NAME, getcharid(CHAR_ID_GUILD))) +"', "+ getd(".dota_sql_"+ .@killer_gid +"_c") +", "+ getd(".dota_sql_"+ .@killer_gid +"_h") +", from_unixtime("+ getd(".dota_sql_"+ .@killer_gid +"_t") +") )";
    					}
    					end;
    				}
    				break;
    			}
    		}
    		if ( .@i == .@sitkillsize ) {
    			set @sitkillid[.@i], killedrid;
    			set @sitkilltimes[.@i], 1;
    		}
    	}
    	set @PlayersKilledStreak, @PlayersKilledStreak +1 ;
    	set @dota_sql_kills, @dota_sql_kills +1 ;
    	if ( @PlayersKilledStreak > @dota_sql_streaks ) {
    		set @dota_sql_streaks, @PlayersKilledStreak;
    		set @dota_sql_streaktime, gettimetick(2);
    	}
    	query_sql "replace into pvpladder values ( "+ getcharid(0) +", '"+ escape_sql(strcharinfo(0)) +"', "+ @dota_sql_streaks +", "+ @dota_sql_kills +", "+ @dota_sql_deaths +", from_unixtime("+ @dota_sql_streaktime +") )";
    	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 ( .@streakname$[1] != "" ) {
    		announce strcharinfo(0) +" "+ .@streakname$[1] +"["+ @PlayersKilledStreak +"] "+( (.announcemap)?("at "+ .@map$):"") + .@streakname$[2],16|.Announce;
    		if ( .sound == 1 ) soundeffectall .@streakname$[0],0,.@map$;
    		else if ( .sound == 2 ) soundeffectall .@streakname$[0],0;
    		else if ( .sound == 3 ) soundeffect .@streakname$[0],0;
    	}
    	set @dota_multikills, @dota_multikills + 1;
    	deltimer "DOTAPVP::OnStreakReset";
    	addtimer 18000,"DOTAPVP::OnStreakReset";
    	set .@killer_gid, getcharid(2);
    	if ( .@killer_gid && .@killer_gid != .@killed_gid ) {
    		setd ".dota_sql_"+ .@killer_gid +"_c", getd(".dota_sql_"+ .@killer_gid +"_c") +1 ;
    		if ( getd(".dota_sql_"+ .@killer_gid +"_c") > getd(".dota_sql_"+ .@killer_gid +"_h") ) {
    			setd ".dota_sql_"+ .@killer_gid +"_h", getd(".dota_sql_"+ .@killer_gid +"_c");
    			setd ".dota_sql_"+ .@killer_gid +"_t", gettimetick(2);
    		}
    		query_sql "replace into ownladder values ( "+ .@killer_gid +", '"+ escape_sql(getguildinfo(GUILDINFO_NAME, getcharid(CHAR_ID_GUILD))) +"', "+ getd(".dota_sql_"+ .@killer_gid +"_c") +", "+ getd(".dota_sql_"+ .@killer_gid +"_h") +", from_unixtime("+ getd(".dota_sql_"+ .@killer_gid +"_t") +") )";
    	}
    	set .@dota_multikills, @dota_multikills;
    	set .@origin, getcharid(3);
    	sleep 1500;
    	if ( .@killer_gid && .@killer_gid != .@killed_gid && getd(".dota_sql_"+ .@killer_gid +"_c") >= .owned && ( ( getd(".dota_sql_"+ .@killer_gid +"_c") - .owned ) % .owncontinue == 0 ) ) {
    		if ( .Announce ) mapannounce .@map$, "The guild ["+ getguildinfo(GUILDINFO_NAME, getcharid(CHAR_ID_GUILD)) +"] is OWNING["+ getd(".dota_sql_"+ .@killer_gid +"_c") +"] !!!",16;
    		else announce "The guild ["+ getguildinfo(GUILDINFO_NAME, getcharid(CHAR_ID_GUILD)) +"] is OWNING["+ getd(".dota_sql_"+ .@killer_gid +"_c") +"] !!!",16;
    		if ( .sound == 1 ) soundeffectall "ownage.wav",0,.@map$;
    		else if ( .sound == 2 ) soundeffectall "ownage.wav",0;
    		else if ( .sound == 3 && attachrid(.@origin) ) soundeffect "ownage.wav",0;
    	}
    	sleep 1250;
    	if ( !attachrid(.@origin) ) end;
    	if ( .@dota_multikills == 2 ) {
    		if ( .Announce ) mapannounce .@map$, strcharinfo(0) +" just got a Double Kill !",16;
    		else announce strcharinfo(0) +" just got a Double Kill !",16;
    		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 ( .Announce ) mapannounce .@map$, strcharinfo(0) +" just got a Triple Kill !!!",16;
    		else announce strcharinfo(0) +" just got a Triple Kill !!!",16;
    		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 ( .Announce ) mapannounce .@map$, strcharinfo(0) +" just got a Ultra Kill !!!",16;
    		else announce strcharinfo(0) +" just got a Ultra Kill !!!",16;
    		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 ( .Announce ) mapannounce .@map$, strcharinfo(0) +" is on a Rampage !!!",16;
    		else announce strcharinfo(0) +" is on a Rampage !!!",16;
    		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:
    	set @dota_multikills, 0;
    	end;
    OnWhisperGlobal:
    	if ( @spam_dotapvp + 3 >= gettimetick(2) ) // 3 seconds interval so player don spam this command
    		end;
    	set @spam_dotapvp, gettimetick(2);
    	if ( @dota_sql_kills == 0 && @dota_sql_deaths == 0 )
    		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;
    	if ( @dota_sql_kills || @dota_sql_deaths ) {
    		dispbottom "Your current Streak      : "+ @PlayersKilledStreak;
    		dispbottom "Your total Kills               : "+ @dota_sql_kills;
    		dispbottom "Your total Deaths          : "+ @dota_sql_deaths;
    		dispbottom "Your highest Streak      : "+ @dota_sql_streaks;
    		query_sql "select date_format( from_unixtime("+ @dota_sql_streaktime +"),'%a %e/%c/%y %r')", .@time1$;
    		dispbottom "Your highest Streak on : "+ .@time1$;
    	}
    	else
    		dispbottom "You are not in the pvp ladder yet.";
    	if ( getcharid(2) ) {
    		if ( getd(".dota_sql_"+ getcharid(2) +"_h") == 0 ) {
    			query_sql "select currentown, highestown, unix_timestamp(owntime) from ownladder where guild_id = "+ getcharid(2), .@c, .@h, .@t;
    			setd ".dota_sql_"+ getcharid(2) +"_c", .@c;
    			setd ".dota_sql_"+ getcharid(2) +"_h", .@h;
    			setd ".dota_sql_"+ getcharid(2) +"_t", .@t;
    		}
    		if ( getd(".dota_sql_"+ getcharid(2) +"_h") ) {
    			dispbottom "Your guild current Own      : "+ getd(".dota_sql_"+ getcharid(2) +"_c");
    			dispbottom "Your guild highest Own      : "+ getd(".dota_sql_"+ getcharid(2) +"_h");
    			query_sql "select date_format( from_unixtime("+ getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_t"), "DOTAPVP" ) +"),'%a %e/%c/%y %r')", .@time2$;
    			dispbottom "Your guild highest Own on : "+ .@time2$;
    		}
    		else
    			dispbottom "Your guild is not in the ladder yet.";
    	}
    	end;
    OnPCLoginEvent:
    	if ( .maptrigger$ != "all" ) end;
    OnPCLoadMapEvent:
    	if ( @dota_sql_kills == 0 && @dota_sql_deaths == 0 ) {
    		if ( .maptrigger$ != "all" ) {
    			getmapxy .@map$, .@x, .@y, 0;
    			for ( set .@i, 0; .@i < .maptriggersize; set .@i, .@i +1 ) {
    				if ( .@map$ == .maptrigger$[.@i] ) break;
    			}
    			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;
    	}
    	if ( getcharid(2) && getd(".dota_sql_"+ getcharid(2) +"_h") == 0 ) {
    		query_sql "select currentown, highestown, unix_timestamp(owntime) from ownladder where guild_id = "+ getcharid(2), .@c, .@h, .@t;
    		setd ".dota_sql_"+ getcharid(2) +"_c", .@c;
    		setd ".dota_sql_"+ getcharid(2) +"_h", .@h;
    		setd ".dota_sql_"+ getcharid(2) +"_t", .@t;
    	}
    	end;
    }
    
    prontera,165,174,5	script	PvP-StatsViewer	4_BULLETIN_BOARD2,{
    	set .@npcname$, strnpcinfo(0);
    	while (1) {
    		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" ) ) {
    			case 1:
    				set .@nb, query_sql("select name, kills, deaths from pvpladder order by kills desc limit "+ getvariableofnpc(.showtotal,"DOTAPVP"), .@name$, .@kills, .@deaths);
    				if ( .@nb == 0 ) {
    					mes "["+ .@npcname$ +"]";
    					mes "The ladder currently is empty.";
    					next;
    				}
    				for ( set .@j,0; .@j < .@nb; set .@j, .@j + getvariableofnpc(.showpage,"DOTAPVP") ) {
    					mes "["+ .@npcname$ +"]";
    					for ( set .@i, .@j; .@i < (getvariableofnpc(.showpage,"DOTAPVP") + .@j) && .@i < .@nb; set .@i, .@i + 1 ) {
    						mes "^996600"+ (.@i+1) +": ^006699"+ .@name$[.@i] +" ^00AA00["+ .@kills[.@i] +"] ^FF0000<"+ .@deaths[.@i] +">^000000";
    					}
    					next;
    				}
    				break;
    			case 2:
    				set .@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 == 0 ) {
    					mes "["+ .@npcname$ +"]";
    					mes "The ladder currently is empty.";
    					next;
    				}
    				for ( set .@j,0; .@j < .@nb; set .@j, .@j + getvariableofnpc(.showpage,"DOTAPVP") ) {
    					mes "["+ .@npcname$ +"]";
    					for ( set .@i, .@j; .@i < (getvariableofnpc(.showpage,"DOTAPVP") + .@j) && .@i < .@nb; set .@i, .@i + 1 ) {
    						mes "^996600"+ (.@i+1) +": ^006699"+ .@name$[.@i] +" ^70AC11{"+ .@streak[.@i] +"} ^000000on :";
    						mes "    ^EE8800"+ .@time$[.@i] +"^000000";
    					}
    					next;
    				}
    				break;
    			case 3:
    				set .@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 == 0 ) {
    					mes "["+ .@npcname$ +"]";
    					mes "The ladder currently is empty.";
    					next;
    				}
    				for ( set .@j,0; .@j < .@nb; set .@j, .@j + getvariableofnpc(.showpage,"DOTAPVP") ) {
    					mes "["+ .@npcname$ +"]";
    					for ( set .@i, .@j; .@i < (getvariableofnpc(.showpage,"DOTAPVP") + .@j) && .@i < .@nb; set .@i, .@i + 1 ) {
    						mes "^996600"+ (.@i+1) +": ^006699"+ .@name$[.@i] +" ^00AAAA("+ .@owned[.@i] +") ^000000on :";
    						mes "    ^EE8800"+ .@time$[.@i] +"^000000";
    					}
    					next;
    				}
    				break;
    			case 4:
    				if ( @dota_sql_kills == 0 && @dota_sql_deaths == 0 )
    					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$;
    				mes "["+ .@npcname$ +"]";
    				if ( @dota_sql_kills == 0 && @dota_sql_deaths == 0 )
    					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 :";
    						query_sql "select date_format( from_unixtime("+ @dota_sql_streaktime +"),'%a %e/%c/%y %r')", .@time1$;
    						mes "    ^EE8800"+ .@time1$ +"^000000";
    					}
    				}
    				next;
    				if ( getcharid(2) ) {
    					if ( getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_h"), "DOTAPVP" ) == 0 ) {
    						query_sql "select currentown, highestown, unix_timestamp(owntime) from ownladder where guild_id = "+ getcharid(2), .@c, .@h, .@t;
    						set getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_c"), "DOTAPVP" ), .@c;
    						set getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_h"), "DOTAPVP" ), .@h;
    						set getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_t"), "DOTAPVP" ), .@t;
    					}
    					mes "["+ .@npcname$ +"]";
    					if ( getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_h"), "DOTAPVP" ) == 0 ) {
    						mes "Your guild not yet kill any player.";
    					} else {
    						mes "Your guild name : ^006699"+ strcharinfo(2) +"^000000";
    						mes "Current Owning  : ^00AAAA("+ getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_c"), "DOTAPVP" ) +")^000000";
    						mes "Longest Ownage was ^00AAAA("+ getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_h"), "DOTAPVP" ) + ")^000000 on :";
    						query_sql "select date_format( from_unixtime("+ getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_t"), "DOTAPVP" ) +"),'%a %e/%c/%y %r')", .@time2$;
    						mes "    ^EE8800"+ .@time2$ +"^000000";
    					}
    					next;
    				}
    				break;
    			case 5:
    				mes "["+ .@npcname$ +"]";
    				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;
    		}
    	}
    }

     

     


  15. 12 hours ago, meko said:

    inarray() is not a script command of Hercules (see the docs in doc/script_commands.txt) and is also not included in the "Array manipulation functions" script

     

    You should either replace it with a for() loop or if you want to use Array manipulation functions you should use array_exists() like so:

    // with Array manipulation functions: if (!array_exists(.@unique_id, get_unique_id())) { ... } // with a for() loop: .@size = getarraysize(.@unique_id); for (.@k = 0; .@k < .@size; ++.@k) { if (.@unique_id[.@k] == get_unique_id()) { break; } ... }

    
    // with Array manipulation functions:
    
    if (!array_exists(.@unique_id, get_unique_id())) {
    	...
    }
    
    
    
    
    // with a for() loop:
    
    .@size = getarraysize(.@unique_id);
    for (.@k = 0; .@k < .@size; ++.@k) {
    	if (.@unique_id[.@k] == get_unique_id()) {
    		break;
    	}
    
    	...
    }

     

    Keep in mind that get_unique_id() is also not part of Hercules so if you don't have a plugin that provides it or source mods (not recommended) it will not work

    Will check on this. once i do server maintenance.

     

     

    3 hours ago, Zhao Chow said:

    get_unique_id() is a part of gepard modification

    Yes have gepard modification. Just don't know on the array thing.


  16. Good day!

    I need it has something to do with this but honestly I really cant understand it. tried everything. Please help me.

     

     

    -	script	WoE Reward	FAKE_NPC,{
    OnAgitEnd: callsub S_AgitEnd, 0, 20;
    OnAgitEnd2: callsub S_AgitEnd, 20, 30;
    S_AgitEnd:
    	.@start = getarg(0);
    	.@end = getarg(1);
    	for ( .@i = .@start; .@i < .@end; ++.@i ) {
    		.@guild_id = getcastledata( .castle$[.@i], CD_GUILD_ID );
    		if ( .@guild_id ) {
    			deletearray .@unique_id;
    			getguildmember .@guild_id, 1;
    			getguildmember .@guild_id, 2;
    			for ( .@j = 0; .@j < $@guildmembercount; ++.@j ) {
    				if ( isloggedin( $@guildmemberaid[.@j], $@guildmembercid[.@j] ) ) {
    					attachrid $@guildmemberaid[.@j];
    					if ( inarray( .@unique_id, get_unique_id() ) == -1 ) {
    						dispbottom "Reward given for conquered "+ getcastlename(.castle$[.@i]) +"("+ .castle$[.@i] +")";
    						getitem 31509, 1;
    						getitem 12103, 1;
    						getitem 16770, 1;
    						getitem 6380, 15;
    						getitem 31510, 1;
    						.@unique_id[ getarraysize(.@unique_id) ] = get_unique_id();
    					}
    				}
    			}
    		}
    	}
    	end;
    OnInit:
    	setarray .castle$[0],
    		"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";
    	end;
    }

     


  17. On 4/9/2020 at 9:36 AM, 4144 said:

    well gepard not prevent cheaters. it create some issues for botters only. Real protection can be only server side.

    from log this is packets with wrong skill id. you can ignore them or add some code for disconnect players with wrong skill sent.

     

    remove code what you add before, and place this code:

    if (skill->get_index(skill_id) == 0) { sockt->eof(fd); ShowWarning("Wrong skill detected %d. Player disconnected\n", skill_id); return; }

    This code should disconnect anyone who using skill what was not added to skill_db.

     

    Yes, will try again next update. I don't know why. I just copy paste your snippet. Will get  back to you. thanks!

     

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.