• 0
ShiroNaito

Help > Ladder Announce gets rank promoted

Question

Good day .. I have miss @AnnieRuru 's script of pvp ladder with kill announce 

I would like to ask if is it possible to announce if the player from Rank #4 gets promoted to rank #3 .and if he Gets the #1 rank .

I mean just to inform players that "We have a new Champion" or "This player advanced on this rank"

 

Please help ..Here is the script ,Ive already added some features there please forgive me miss annie for adding some codes ..

 

 

 

Quote

//===== eAthena Script =======================================================
//= PVP ladder script with dota announcement ( SQL only )
//===== By: ==================================================================
//= ~AnnieRuru~
//===== Current Version: =====================================================
//= 2.9
//= 3.0 modified by Gerome
//===== Compatible With: =====================================================
//= eAthena SQL 14279, with MySQL 5.1
//=    rAthena
//===== 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
guild_vs1    mapflag    loadevent
guild_vs2    mapflag    loadevent
guild_vs3    mapflag    loadevent
guild_vs4    mapflag    loadevent
guild_vs5    mapflag    loadevent
pvp_y_8-2    mapflag    loadevent
pvp_y_8-4    mapflag    loadevent
pvp_y_8-5    mapflag    loadevent
pvp_y_5-2    mapflag    loadevent
prtg_cas01    mapflag    loadevent

-    script    DOTAPVP    -1,{
OnInit:
    /* *****************************************************************************************
    **                             CONFIGURATION
    ** ****************************************************************************************/
    
    /* ==================    Sound Effects    ===================================================/
    *-    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 .sound, 1;
    
    /* ==================    Announce Target flags    ===========================================/
    *- bc_all: Broadcast message is sent server-wide (default).
    *- bc_map: Message is sent to everyone in the same map as the source of the broadcast.
    *- bc_area: Message is sent to players in the vicinity of the source.
    *- bc_self: Message is sent only to current player.
    *- You cannot use more than one target flag.
    *- =======================================================================================*/
    set .announceFlag$, "bc_all";
    
    /* ==================    Announce Color ====================================================/
    *- The color parameter is a single number which can be in hexadecimal notation. 
    *- The color format is in RGB (0xRRGGBB).
    *- default "0xFFFF00" = Yellow
    *- =======================================================================================*/
    set .announceColor$,"0xFFFF00";
    
    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, 1;         // show message who kill you when die : 0 - off, 1 - on
    set .msg_kill, 1;        // show message you kill who when killed someone : 0 - off, 1 - on
    
    /* 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 .gmnokill, 0; 
    
    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, 20;     // 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",
        "pvp_y_5-2",
        "prtg_cas01",
        "prtg_cas02",
        "prtg_cas03",
        "prtg_cas04",
        "prtg_cas05",
        "payg_cas01",    
        "payg_cas02",
        "payg_cas03",
        "payg_cas04",
        "payg_cas05",
        "gefg_cas01",
        "gefg_cas02",
        "gefg_cas03",
        "gefg_cas04",
        "gefg_cas05",
        "aldeg_cas01",
        "aldeg_cas02",
        "aldeg_cas03",
        "aldeg_cas04",
        "aldeg_cas05",
        "arug_cas01",
        "arug_cas02",
        "arug_cas03",
        "arug_cas04",
        "arug_cas05",
        "schg_cas01",
        "schg_cas02",
        "schg_cas03",
        "schg_cas04",
        "schg_cas05";
        

    /* ==================    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, 75;

    // 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 ( getgroupid()    >=    .gmnokill ) end;
    getmapxy [email protected]$,[email protected],[email protected],BL_PC;
        #PvpPoints += 1;
        dispbottom "You have recieved 1 PVP Points.";
        dispbottom "You now have " +#PvpPoints+ " PVP Points.";
    if ( .maptrigger$ != "all" ) {
        for ( set [email protected], 0; [email protected] < .maptriggersize; set [email protected], [email protected] +1 ) {
            if ( [email protected]$ == .maptrigger$[[email protected]] ) break;
        }
        if ( [email protected] == .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 [email protected]$,"Beyond Godlike";
    else if ( @PlayersKilledStreak >= .godlike )
        set [email protected]$,"Godlike";
    else if ( @PlayersKilledStreak >= .monsterkill )
        set [email protected]$,"Monster Kill";
    else if ( @PlayersKilledStreak >= .wickedsick )
        set [email protected]$,"Wicked Sick";
    else if ( @PlayersKilledStreak >= .unstoppable )
        set [email protected]$,"Unstoppable";
    else if ( @PlayersKilledStreak >= .megakill )
        set [email protected]$,"Mega-kill";
    else if ( @PlayersKilledStreak >= .dominating )
        set [email protected]$,"Dominating";
    else if ( @PlayersKilledStreak >= .killingspree )
        set [email protected]$,"Killing Spree";
    if ( @PlayersKilledStreak >= .killingspree && killerrid == getcharid(3) )
        announce strcharinfo(0) +" has ended "+( (sex)?"him":"her" )+" own "+ [email protected]$ +"["+ @PlayersKilledStreak +"] streak "+( (.announcemap)?("at "+ [email protected]$):""),atoi(.announceFlag$), .announceColor$;
    else if ( @PlayersKilledStreak >= .killingspree )
        announce rid2name(killerrid) +" has ended "+ strcharinfo(0) +"'s "+ [email protected]$ +"["+ @PlayersKilledStreak +"] streak "+( (.announcemap)?("at "+ [email protected]$):""),atoi(.announceFlag$), .announceColor$;
    else if ( .announcekill && killerrid != getcharid(3) )
        announce rid2name(killerrid) +" has pawned "+ strcharinfo(0) +"'s head "+( (.announcemap)?("at "+ [email protected]$):""),atoi(.announceFlag$), .announceColor$;
    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 [email protected]_gid, getcharid(2);
    if ( [email protected]_gid ) {
        setd ".dota_sql_"+ [email protected]_gid +"_c", 0;
        if ( getd(".dota_sql_"+ [email protected]_gid +"_h") )
            query_sql "replace into ownladder values ( "+ [email protected]_gid +", '"+ escape_sql(getguildname([email protected]_gid)) +"', "+ getd(".dota_sql_"+ [email protected]_gid +"_c") +", "+ getd(".dota_sql_"+ [email protected]_gid +"_h") +", from_unixtime("+ getd(".dota_sql_"+ [email protected]_gid +"_t") +") )";
    }
    if ( killerrid == getcharid(3) || baselevel < .lvltokill ) end;
    if ( .minlvlrange ) set [email protected], baselevel;
    attachrid killerrid;
    if ( .minlvlrange && [email protected] + .minlvlrange < baselevel ) end;
    if ( .counttopunish ) {
        if ( @sitkillminute != gettime(2) ) {
            deletearray @sitkillid, 128;
            deletearray @sitkilltimes, 128;
            set @sitkillminute, gettime(2);
        }
        set [email protected], getarraysize(@sitkillid);
        for ( set [email protected],0; [email protected] < [email protected]; set [email protected], [email protected] +1 ) {
            if ( @sitkillid[[email protected]] != killedrid ) continue;
            else {
                set @sitkilltimes[[email protected]], @sitkilltimes[[email protected]] +1 ;
                if ( @sitkilltimes[[email protected]] >= .counttopunish ) {
                    warp "SavePoint",0,0;
                    announce strcharinfo(0) +" , Stop killing "+ rid2name(killedrid) + " !!!",0;
                    debugmes strcharinfo(0) +" is sit-killing "+ rid2name(killedrid) +" for "+ @sitkilltimes[[email protected]] + " times";
                    logmes "is sit-killing "+ rid2name(killedrid) +" for "+ @sitkilltimes[[email protected]] +" 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 [email protected]_gid, getcharid(2);
                    if ( [email protected]_gid ) {
                        if ( getd(".dota_sql_"+ [email protected]_gid +"_c") == getd(".dota_sql_"+ [email protected]_gid +"_h") ) {
                            setd ".dota_sql_"+ [email protected]_gid +"_h", getd(".dota_sql_"+ [email protected]_gid +"_h") +1 - .counttopunish;
                            setd ".dota_sql_"+ [email protected]_gid +"_t", gettimetick(2);
                        }
                        setd (".dota_sql_"+ [email protected]_gid +"_c"), getd(".dota_sql_"+ [email protected]_gid +"_c") +1 - .counttopunish;
                        query_sql "replace into ownladder values ( "+ [email protected]_gid +", '"+ escape_sql(getguildname([email protected]_gid)) +"', "+ getd(".dota_sql_"+ [email protected]_gid +"_c") +", "+ getd(".dota_sql_"+ [email protected]_gid +"_h") +", from_unixtime("+ getd(".dota_sql_"+ [email protected]_gid +"_t") +") )";
                    }
                    end;
                }
                break;
            }
        }
        if ( [email protected] == [email protected] ) {
            set @sitkillid[[email protected]], killedrid;
            set @sitkilltimes[[email protected]], 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 [email protected]$,"killingspree.wav","is on a KILLING SPREE","!";
    else if ( @PlayersKilledStreak == .dominating )
        setarray [email protected]$,"dominating.wav","is DOMINATING","!";
    else if ( @PlayersKilledStreak == .megakill )
        setarray [email protected]$,"megakill.wav","has a MEGA KILL","!";
    else if ( @PlayersKilledStreak == .unstoppable )
        setarray [email protected]$,"unstoppable.wav","is UNSTOPPABLE","!!";
    else if ( @PlayersKilledStreak == .wickedsick )
        setarray [email protected]$,"wickedsick.wav","is WICKED SICK","!!";
    else if ( @PlayersKilledStreak == .monsterkill )
        setarray [email protected]$,"monsterkill.wav","has a MONSTER KILL","!!";
    else if ( @PlayersKilledStreak == .godlike )
        setarray [email protected]$,"godlike.wav","is GODLIKE","!!!";
    else if ( @PlayersKilledStreak >= .holyshit && ( (@PlayersKilledStreak - .holyshit) % .continue == 0 ) )
        setarray [email protected]$,"holyshit.wav","is BEYOND GODLIKE",". Someone KILL "+( (sex)?"HIM":"HER" ) +"!!!!!!";
    if ( [email protected]$[1] != "" ) {
        announce strcharinfo(0) +" "+ [email protected]$[1] +"["+ @PlayersKilledStreak +"] "+( (.announcemap)?("at "+ [email protected]$):"") + [email protected]$[2],atoi(.announceFlag$), .announceColor$;
        if ( .sound == 1 ) soundeffectall [email protected]$[0],0,[email protected]$;
        else if ( .sound == 2 ) soundeffectall [email protected]$[0],0;
        else if ( .sound == 3 ) soundeffect [email protected]$[0],0;
    }
    set @dota_multikills, @dota_multikills + 1;
    deltimer "DOTAPVP::OnStreakReset";
    addtimer 18000,"DOTAPVP::OnStreakReset";
    set [email protected]_gid, getcharid(2);
    if ( [email protected]_gid && [email protected]_gid != [email protected]_gid ) {
        setd ".dota_sql_"+ [email protected]_gid +"_c", getd(".dota_sql_"+ [email protected]_gid +"_c") +1 ;
        if ( getd(".dota_sql_"+ [email protected]_gid +"_c") > getd(".dota_sql_"+ [email protected]_gid +"_h") ) {
            setd ".dota_sql_"+ [email protected]_gid +"_h", getd(".dota_sql_"+ [email protected]_gid +"_c");
            setd ".dota_sql_"+ [email protected]_gid +"_t", gettimetick(2);
        }
        query_sql "replace into ownladder values ( "+ [email protected]_gid +", '"+ escape_sql(getguildname([email protected]_gid)) +"', "+ getd(".dota_sql_"+ [email protected]_gid +"_c") +", "+ getd(".dota_sql_"+ [email protected]_gid +"_h") +", from_unixtime("+ getd(".dota_sql_"+ [email protected]_gid +"_t") +") )";
    }
    set [email protected]_multikills, @dota_multikills;
    set [email protected], getcharid(3);
    sleep 1500;
    if ( [email protected]_gid && [email protected]_gid != [email protected]_gid && getd(".dota_sql_"+ [email protected]_gid +"_c") >= .owned && ( ( getd(".dota_sql_"+ [email protected]_gid +"_c") - .owned ) % .owncontinue == 0 ) ) {
        announce "The guild ["+ getguildname([email protected]_gid) +"] is OWNING["+ getd(".dota_sql_"+ [email protected]_gid +"_c") +"] !!!",atoi(.announceFlag$), .announceColor$;
        if ( .sound == 1 ) soundeffectall "ownage.wav",0,[email protected]$;
        else if ( .sound == 2 ) soundeffectall "ownage.wav",0;
        else if ( .sound == 3 && attachrid([email protected]) ) soundeffect "ownage.wav",0;
    }
    sleep 1250;
    if ( !attachrid([email protected]) ) end;
    if ( [email protected]_multikills == 2 ) {
        announce strcharinfo(0) +" just got a Double Kill !",atoi(.announceFlag$), .announceColor$;
        if ( .sound == 1 ) soundeffectall "doublekill.wav",0,[email protected]$;
        else if ( .sound == 2 ) soundeffectall "doublekill.wav",0;
        else if ( .sound == 3 ) soundeffect "doublekill.wav",0;
    }
    else if ( [email protected]_multikills == 3 ) {
        announce strcharinfo(0) +" just got a Triple Kill !!!",atoi(.announceFlag$), .announceColor$;
        if ( .sound == 1 ) soundeffectall "triplekill.wav",0,[email protected]$;
        else if ( .sound == 2 ) soundeffectall "triplekill.wav",0;
        else if ( .sound == 3 ) soundeffect "triplekill.wav",0;
    }
    else if ( [email protected]_multikills == 4 ) {
        announce strcharinfo(0) +" just got a Ultra Kill !!!",atoi(.announceFlag$), .announceColor$;
        if ( .sound == 1 ) soundeffectall "ultrakill.wav",0,[email protected]$;
        else if ( .sound == 2 ) soundeffectall "ultrakill.wav",0;
        else if ( .sound == 3 ) soundeffect "ultrakill.wav",0;
    }
    else if ( [email protected]_multikills >= 5 ) {
        announce strcharinfo(0) +" is on a Rampage !!!",atoi(.announceFlag$), .announceColor$;
        if ( .sound == 1 ) soundeffectall "rampage.wav",0,[email protected]$;
        else if ( .sound == 2 ) soundeffectall "rampage.wav",0;
        else if ( .sound == 3 ) soundeffect "rampage.wav",0;
    }
    end;
OnStreakReset:
    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')", [email protected]$;
        dispbottom "Your highest Streak on : "+ [email protected]$;
    }
    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), [email protected], [email protected], [email protected];
            setd ".dota_sql_"+ getcharid(2) +"_c", [email protected];
            setd ".dota_sql_"+ getcharid(2) +"_h", [email protected];
            setd ".dota_sql_"+ getcharid(2) +"_t", [email protected];
        }
        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')", [email protected]$;
            dispbottom "Your guild highest Own on : "+ [email protected]$;
        }
        else
            dispbottom "Your guild is not in the ladder yet.";
    }
    end;
OnPCLoadMapEvent:
    if ( @dota_sql_kills == 0 && @dota_sql_deaths == 0 ) {
        if ( .maptrigger$ != "all" ) {
            getmapxy [email protected]$,[email protected],[email protected],BL_PC;
            for ( set [email protected], 0; [email protected] < .maptriggersize; set [email protected], [email protected] +1 ) {
                if ( [email protected]$ == .maptrigger$[[email protected]] ) break;
            }
            if ( [email protected] == .maptriggersize ) end;
        }
        query_sql "select kills, deaths, streaks, unix_timestamp(streaktime) from pvpladder where char_id = "+ getcharid(0), @dota_sql_kills, @dota_sql_deaths, @dota_sql_streaks, @dota_sql_streaktime;
    }
    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), [email protected], [email protected], [email protected];
        setd ".dota_sql_"+ getcharid(2) +"_c", [email protected];
        setd ".dota_sql_"+ getcharid(2) +"_h", [email protected];
        setd ".dota_sql_"+ getcharid(2) +"_t", [email protected];
    }
    end;
}

prontera,128,165,6    script    PvP Ladder    123,{
    set [email protected]$, strnpcinfo(0);
    while (1) {
        mes "["+ [email protected]$ +"]";
        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","PvP Shop","Explanation" ) ) {
            case 1:
                set [email protected], query_sql("select name, kills, deaths from pvpladder order by kills desc limit "+ getvariableofnpc(.showtotal,"DOTAPVP"), [email protected]$, [email protected], [email protected]);
                if ( [email protected] == 0 ) {
                    mes "["+ [email protected]$ +"]";
                    mes "The ladder currently is empty.";
                    next;
                }
                for ( set [email protected],0; [email protected] < [email protected]; set [email protected], [email protected] + getvariableofnpc(.showpage,"DOTAPVP") ) {
                    mes "["+ [email protected]$ +"]";
                    for ( set [email protected], [email protected]; [email protected] < (getvariableofnpc(.showpage,"DOTAPVP") + [email protected]) && [email protected] < [email protected]; set [email protected], [email protected] + 1 ) {
                        mes "^996600"+ ([email protected]+1) +": ^006699"+ [email protected]$[[email protected]] +" ^00AA00["+ [email protected][[email protected]] +"] ^FF0000<"+ [email protected][[email protected]] +">^000000";
                    }
                    next;
                }
                break;
            case 2:
                set [email protected], query_sql("select name, streaks, date_format(streaktime,'%a %e/%c/%y %r') from pvpladder where streaks >= "+ getvariableofnpc(.loweststreak,"DOTAPVP") +" order by streaks desc limit "+ getvariableofnpc(.showtotal,"DOTAPVP"), [email protected]$, [email protected], [email protected]$);
                if ( [email protected] == 0 ) {
                    mes "["+ [email protected]$ +"]";
                    mes "The ladder currently is empty.";
                    next;
                }
                for ( set [email protected],0; [email protected] < [email protected]; set [email protected], [email protected] + getvariableofnpc(.showpage,"DOTAPVP") ) {
                    mes "["+ [email protected]$ +"]";
                    for ( set [email protected], [email protected]; [email protected] < (getvariableofnpc(.showpage,"DOTAPVP") + [email protected]) && [email protected] < [email protected]; set [email protected], [email protected] + 1 ) {
                        mes "^996600"+ ([email protected]+1) +": ^006699"+ [email protected]$[[email protected]] +" ^70AC11{"+ [email protected][[email protected]] +"} ^000000on :";
                        mes "    ^EE8800"+ [email protected]$[[email protected]] +"^000000";
                    }
                    next;
                }
                break;
            case 3:
                set [email protected], query_sql("select name, highestown, date_format(owntime,'%a %e/%c/%y %r') from ownladder where highestown >= "+ getvariableofnpc(.lowestownage,"DOTAPVP") +" order by highestown desc limit "+ getvariableofnpc(.showtotal,"DOTAPVP"), [email protected]$, [email protected], [email protected]$);
                if ( [email protected] == 0 ) {
                    mes "["+ [email protected]$ +"]";
                    mes "The ladder currently is empty.";
                    next;
                }
                for ( set [email protected],0; [email protected] < [email protected]; set [email protected], [email protected] + getvariableofnpc(.showpage,"DOTAPVP") ) {
                    mes "["+ [email protected]$ +"]";
                    for ( set [email protected], [email protected]; [email protected] < (getvariableofnpc(.showpage,"DOTAPVP") + [email protected]) && [email protected] < [email protected]; set [email protected], [email protected] + 1 ) {
                        mes "^996600"+ ([email protected]+1) +": ^006699"+ [email protected]$[[email protected]] +" ^00AAAA("+ [email protected][[email protected]] +") ^000000on :";
                        mes "    ^EE8800"+ [email protected]$[[email protected]] +"^000000";
                    }
                    next;
                }
                break;
            case 4:
                if ( @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, [email protected]$;
                mes "["+ [email protected]$ +"]";
                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')", [email protected]$;
                        mes "    ^EE8800"+ [email protected]$ +"^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), [email protected], [email protected], [email protected];
                        set getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_c"), "DOTAPVP" ), [email protected];
                        set getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_h"), "DOTAPVP" ), [email protected];
                        set getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_t"), "DOTAPVP" ), [email protected];
                    }
                    mes "["+ [email protected]$ +"]";
                    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')", [email protected]$;
                        mes "    ^EE8800"+ [email protected]$ +"^000000";
                    }
                    next;
                }
                break;
            case 5:
                        callshop "PvP_Cash_Shop",1;
                        end;
            case 6:
                mes "["+ [email protected]$ +"]";
                mes "Explanation for Most Kills:";
                mes " ";
                mes "^996600Rank. ^006699NAME ^00AA00[Total Kills] ^FF0000<Deaths>^000000";
                mes " ";
                mes "--------------------------------";
                mes " ";
                mes "The ^00AA00Kills^000000 added when a player kills another player.";
                mes " ";
                mes "^FF0000Deaths^000000 count increase when a player killed by another player, or suicide (eg: Grand Cross).";
                mes " ";
                mes "A player killed by monsters, homunculus or pets will not add the kills or deaths count.";
                next;
                mes "["+ [email protected]$ +"]";
                mes "Explanation for Highest Streak:";
                mes " ";
                mes "^996600Rank. ^006699NAME ^70AC11{Highest Streak} ^000000on :";
                mes "    ^EE8800TIME^000000";
                mes " ";
                mes "--------------------------------";
                mes " ";
                mes "The ^70AC11Streak^000000 are added every time a player kills another player. It will reset upon log out, killed by another player, or suicide (eg: Sacrifice).";
                mes " ";
                mes "Then it record in the server the ^EE8800TIME^000000 when that player got that highest streak.";
                mes " ";
                mes "A player killed by monsters, homunculus or pets will not reset the streak.";
                mes " ";
                mes "--------------------------------";
                mes " ";
                mes "The numbers of straight kills to get these announcements are :";
                mes "^70AC11"+ getvariableofnpc(.killingspree,"DOTAPVP") +"^000000 : Killing Spree";
                mes "^70AC11"+ getvariableofnpc(.dominating,"DOTAPVP") +"^000000 : Dominating";
                mes "^70AC11"+ getvariableofnpc(.megakill,"DOTAPVP") +"^000000 : Mega Kill";
                mes "^70AC11"+ getvariableofnpc(.unstoppable,"DOTAPVP") +"^000000 : Unstoppable";
                mes "^70AC11"+ getvariableofnpc(.wickedsick,"DOTAPVP") +"^000000 : Wicked Sick";
                mes "^70AC11"+ getvariableofnpc(.monsterkill,"DOTAPVP") +"^000000 : Monster Kill";
                mes "^70AC11"+ getvariableofnpc(.godlike,"DOTAPVP") +"^000000 : Godlike";
                mes "^70AC11"+ getvariableofnpc(.holyshit,"DOTAPVP") +"^000000 : Beyond Godlike";
                next;
                mes "["+ [email protected]$ +"]";
                mes "Explanation for Longest Ownage:";
                mes " ";
                mes "^996600Rank. ^006699NAME ^00AAAA(Longest Ownage) ^000000on :";
                mes "    ^EE8800TIME^000000";
                mes " ";
                mes "--------------------------------";
                mes " ";
                mes "The ^00AAAAOwnage^000000 added every time any guild members killed another player that doesn't belong to his/her guild. It will reset when any of the guild member was killed by ANY player, including his/her guild member.";
                mes " ";
                mes "Then it record in the server the ^EE8800TIME^000000 when the guild got that longest ownage.";
                mes " ";
                mes "If the server went under maintainance, the current ownage will survive after the server restart.";
                mes " ";
                mes "Any guild member killed by monster, homunculus or pets will not reset the ownage count.";
                next;
                if ( getvariableofnpc(.lvltokill,"DOTAPVP") ) {
                    mes "["+ [email protected]$ +"]";
                    mes "You must kill another player with minimum base level of "+ getvariableofnpc(.lvltokill,"DOTAPVP") +", in order to get an announcement or get in the ladder.";
                    mes " ";
                    mes "It's possible for a base level 1 novice kills a base level 99 player and still can get in the ladder.";
                    mes "However when a player level 99 kills a level 1 novice will get nothing.";
                    next;
                }
                if ( getvariableofnpc(.counttopunish,"DOTAPVP") ) {
                    mes "["+ [email protected]$ +"]";
                    mes "Some noob players try to kill the same person over and over again in hope of getting his/her name appear in the ladder.";
                    mes "However if you trying to do the same thing on this ladder, your name will announce to the public, and your action will be recorded into the server to notify the GMs.";
                    next;
                }
                if ( getvariableofnpc(.minlvlrange,"DOTAPVP") ) {
                    mes "["+ [email protected]$ +"]";
                    mes "When you kill another player thats lower base level than you, the base level gap between you and that player must not more than "+ getvariableofnpc(.minlvlrange,"DOTAPVP") +".";
                    mes " ";
                    if ( getvariableofnpc(.minlvlrange,"DOTAPVP") >= 200)
                        mes "In other words, if your base level is 500, the player you killed must be at least level "+( 500 - getvariableofnpc(.minlvlrange,"DOTAPVP") )+" then only you will get the announcement and in the ladder.";
                    else if ( getvariableofnpc(.minlvlrange,"DOTAPVP") >= 70)
                        mes "In other words, if your base level is 255, the player you killed must be at least level "+( 255 - getvariableofnpc(.minlvlrange,"DOTAPVP") )+" then only you will get the announcement and in the ladder.";
                    else
                        mes "In other words, if your base level is 99, the player you killed must be at least level "+( 99 - getvariableofnpc(.minlvlrange,"DOTAPVP") )+" then only you will get the announcement and in the ladder.";
                    mes "Higher base level kills lower level gets nothing, however lower level player kills higher level will get the announcement.";
                    next;
                }
                break;
        }
    }
    

OnClock0900:
OnClock1400:
OnClock1900:
OnClock0000:
OnClock0020:
    announce "[Event]: Pvp Ladder Event has started and will end after an hour.",0;
    goto enable;
OnClock1000:
OnClock1500:
OnClock2000:
OnClock0100:
    announce "PvP Ladder Event is now closed. Better luck next time.",0;
    //disablenpc "PvP Ladder";
    goto disable;
    end;
    
enable:
    enablenpc "PvP Ladder";
        //waitingroom "PVP Ranking & Shop",0;
    end;
disable:
    disablenpc "PvP Ladder";
    end;    
    
    
    
OnInit:
    //waitingroom "[Top 20 PVP List]",0;
disablenpc "PvP Ladder";

}
//==================================
        //-- Call Shop
//==================================

-    pointshop    PvP_Cash_Shop    -1,#PvpPoints,40030:15,40031:15,40032:15,40033:15,40034:15,40035:15,13891:5,13892:5,13893:5,13894:5

 

Share this post


Link to post
Share on other sites

8 answers to this question

Recommended Posts

  • 2
Posted (edited)

-Please do use "Code TAG" or Attach the script file..

Add this at line 338: should look like this

+	query_sql("select name from pvpladder order by kills desc limit 10",[email protected]$);
+	for(.z=0;[email protected]<getarraysize([email protected]$);[email protected]++){
+		if([email protected]$[[email protected]][email protected]$[[email protected]]){
+				announce ((Sex)? "Mr. ":"Ms. ")+strcharinfo(0)+" has achieved rank "+([email protected]+1)+" in PvP Ladder after Killing "+rid2name(killedrid)+"!~",bc_all;
+			query_sql("select name from pvpladder order by kills desc limit 10", [email protected]$);
+			break;
+		}
+	}
    end;
OnStreakReset:

then Add this at OnInit: Line 34.

OnInit:
+	query_sql("select name from pvpladder order by kills desc limit 10", [email protected]$);

Up Vote and Answer if this helps.

EDIT 1: You have 2 OnInit, so i added the Line number.

Edited by Haruka Mayumi
  • MVP 1

Share this post


Link to post
Share on other sites
  • 1

Temporary Global Variable..

enable:
+   set [email protected],1;
    enablenpc "PvP Ladder";
        //waitingroom "PVP Ranking & Shop",0;
    end;
disable:
+   set [email protected],0;
    disablenpc "PvP Ladder";
    end;    

then add this after OnPCKillEvent:

OnPCKillEvent:
+	if([email protected]) end;

this will stop all the announce and records when killing.

  • Love 1

Share this post


Link to post
Share on other sites
  • 1
Posted (edited)

The script i gave doesn't have interaction with the menu. so you might added it incorrectly. here's i added it for you.

A video proof its working [HERE].

NOTE: It's really frustrating when copying code from QUOTE because it will give errors and change tabs into space. so please make sure that you post it on code.

pvpladder.txt

Edited by Haruka Mayumi
Added Video Link
  • Love 1

Share this post


Link to post
Share on other sites
  • 0
1 hour ago, Haruka Mayumi said:

-Please do use "Code TAG" or Attach the script file..

Add this at line 338: should look like this

+	query_sql("select name from pvpladder order by kills desc limit 10",[email protected]$);
+	for(.z=0;[email protected]<getarraysize([email protected]$);[email protected]++){
+		if([email protected]$[[email protected]][email protected]$[[email protected]]){
+				announce ((Sex)? "Mr. ":"Ms. ")+strcharinfo(0)+" has achieved rank "+([email protected]+1)+" in PvP Ladder after Killing "+rid2name(killedrid)+"!~",bc_all;
+			query_sql("select name from pvpladder order by kills desc limit 10", [email protected]$);
+			break;
+		}
+	}
    end;
OnStreakReset:

then Add this at OnInit:

OnInit:
+	query_sql("select name from pvpladder order by kills desc limit 10", [email protected]$);

Up Vote and Answer if this helps.

Hi thankyou ! didnt tried it yet ..I just have one more question please ?.. that npc is turning enable and disable .just like event npc ..Ive noticed that event Ladder is disabled it still storing pvp records of kills and deaths ..how can I disable that ? I want to stop storing data when npc is disabled to prevent Score abuse ..thanks

 

Share this post


Link to post
Share on other sites
  • 0

thankyou i will test it later ill let you know if it works on me ... Hmm how about terminating storation of databasa upon disabling script? Hmmm 

Share this post


Link to post
Share on other sites
  • 0
5 minutes ago, ShiroNaito said:

Hmm how about terminating storation of databasa upon disabling script?

What do you mean by it?. the script or a part of script?.

Share this post


Link to post
Share on other sites
  • 0
14 minutes ago, Haruka Mayumi said:

What do you mean by it?. the script or a part of script?.

Sorry for my bad english master ..

 

What I mean is ..that script was modified to become disabled OnInit ..and will be enabled OnClock ..but Ive noticed that even the script is disabled, it is still storing Deaths and Kill records ..hmmm that should be turned off when Npc is disabled to prevent abusing of ranking points 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...