Jump to content

BlindRO

Members
 View Profile  See their activity

  • Posts

    9

  • Joined

  • Last visited

 Content Type 

Posts posted by BlindRO

    WEPON REDUCE ASPD

    in Script Requests

    Posted

    1652,Dragon_Staff,Dragon Staff,5,20,,0,100,,1,4,0x000810200,7,2,2,4,80,1,10,
    THIS IS WEPON STAFF IF EQUIPS ASPD REDUCE -16 I WANT CHANGE IF EQUIP THIS WEPON -2 ONLY REDUCE ON ASPD ! PLEASE HELP ME THANK YOU

    gold room how remove ranking !

    in Scripting Support

    Posted · Edited by Patskie
    code 

    /*
create table gold_ranking (
char_id int(11) primary key,
name varchar(23) default '',
gold_points int(11) default 0,
key (gold_points)
) engine = innodb;

create table gold_ranking_today (
char_id int(11) primary key,
name varchar(23) default '',
gold_points_today int(11) default 0,
key (gold_points_today)
) engine = innodb;

*/


prontera,165,195,5    script    Gold Room    848,{

OnMenu:

        OnMain:
        mes "[ Gold Room ]";
        mes "Welcome, ^ff0000" +strcharinfo(0)+ "!^000000";
        mes "We rank players based on their performance on farming Gold.";
        mes " ";

        [email protected]$  = "SELECT `name`, IF(@d=t.`gold_points`, @r, @r:[email protected]), @d:=t.`gold_points`, @i:[email protected]+1 ";
        [email protected]$ += "FROM `gold_ranking` t, (SELECT @d:=0, @r:=0, @i:=1)q ";
        [email protected]$ += "ORDER BY `gold_points` DESC LIMIT 1";
        [email protected] = query_sql([email protected]$, [email protected]$, [email protected], [email protected], [email protected]);
        

        query_sql "select gold_points from `gold_ranking` where char_id = "+ getcharid(0), [email protected];


    menu "Enter ^ff0000Gold Room^000000 ^3333cc(" + getmapusers("ordeal_1-2") + ")^000000",L_Enter,"",L_Total,"",L_Today,"Cancel",L_Cancel;

        L_Total:
        clear;
        mes "[ Gold Ladder ]";
        mes "^73acde<Rank>^000000 ^40cc39<Name>^000000 ^cc4f39<Points>^000000";

        [email protected]$  = "SELECT `name`, IF(@d=t.`gold_points`, @r, @r:[email protected]), @d:=t.`gold_points`, @i:[email protected]+1 ";
        [email protected]$ += "FROM `gold_ranking` t, (SELECT @d:=0, @r:=0, @i:=1)q ";
        [email protected]$ += "ORDER BY `gold_points` DESC LIMIT 10";
        [email protected] = query_sql([email protected]$, [email protected]$, [email protected], [email protected], [email protected]);

        if ( [email protected] ) {
            mes " ^777777-- Ladder is currently empty.^000000";
            close;
        }
        for ( [email protected] = 0; [email protected] < [email protected]; [email protected] )
            mes "^73acde"+ [email protected][[email protected]] +".^000000 ^40cc39"+ [email protected]$[[email protected]] +" : ^000000 ^cc4f39<"+ [email protected][[email protected]] +">^000000";
        end;
        
        L_Today:
        clear;
        mes "[ Gold Ladder ]";
        mes "^73acde<Rank>^000000 ^40cc39<Name>^000000 ^ffad33<Points>^000000";

        [email protected]$  = "SELECT `name`, IF(@d=t.`gold_points_today`, @r, @r:[email protected]), @d:=t.`gold_points_today`, @i:[email protected]+1 ";
        [email protected]$ += "FROM `gold_ranking_today` t, (SELECT @d:=0, @r:=0, @i:=1)q ";
        [email protected]$ += "ORDER BY `gold_points_today` DESC LIMIT 10";
        [email protected] = query_sql([email protected]$, [email protected]$, [email protected], [email protected], [email protected]);

        if ( [email protected] ) {
            mes " ^777777-- Ladder is currently empty.^000000";
            close;
        }
        for ( [email protected] = 0; [email protected] < [email protected]; [email protected] )
            mes "^73acde"+ [email protected][[email protected]] +".^000000 ^40cc39"+ [email protected]$[[email protected]] +" : ^000000 ^ffad33<"+ [email protected][[email protected]] +">^000000";
        end;

L_Enter:
    specialeffect 253;
    showscript "'" + strcharinfo(0) + "' entered!",getnpcid(0),AREA;
    warp "ordeal_1-2",0,0;
    end;

L_Cancel:
    end;

OnNPCKillEvent:
    if (killedrid == 1369) {
        if(!$gold_hour) {
            [email protected] = 1;            
        }
        else if($gold_hour) {
            [email protected] = rand(1,3);
        }
            getitem 969,[email protected];
            if([email protected] == 1){
            query_sql "insert into gold_ranking values ( "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) ) +"', 1 ) on duplicate key update name = '"+ escape_sql( strcharinfo(0) )+"', gold_points = gold_points + 1";
            query_sql "insert into gold_ranking_today values ( "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) ) +"', 1 ) on duplicate key update name = '"+ escape_sql( strcharinfo(0) )+"', gold_points_today = gold_points_today + 1";
            }
            if([email protected] == 2){
            query_sql "insert into gold_ranking values ( "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) ) +"', 1 ) on duplicate key update name = '"+ escape_sql( strcharinfo(0) )+"', gold_points = gold_points + 2";
            query_sql "insert into gold_ranking_today values ( "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) ) +"', 1 ) on duplicate key update name = '"+ escape_sql( strcharinfo(0) )+"', gold_points_today = gold_points_today + 2";
            }
            query_sql "select gold_points from `gold_ranking` where char_id = "+ getcharid(0), [email protected];
            query_sql "select gold_points_today from `gold_ranking_today` where char_id = "+ getcharid(0), [email protected]_today;
            end;
    }
    end;

OnClock0000:
    npctalk "Daily ladder has been reset!";
    query_sql "TRUNCATE TABLE `gold_ranking_today`";
    end;

    
}

ordeal_1-2    mapflag    pvp
ordeal_1-2    mapflag    nowarpto
ordeal_1-2    mapflag    nodrop
ordeal_1-2    mapflag    nobranch
ordeal_1-2    mapflag    nosave
ordeal_1-2    mapflag    nomemo
ordeal_1-2    mapflag    noloot


ordeal_1-2    monster    Golden Peco    1369,500
ordeal_1-2    monster    Golden Peco    1369,500
ordeal_1-2    monster    Golden Peco    1369,300

     

    Dummy Punching Bag

    in Scripting Support

    Posted

    how ser

     please help me 
      

    -    script    Punching Bag4    -1,{
OnInit:
OnDummyKill:
    monster "prontera",192,162,"Punching Balls",1905,1,"Punching Bag4::OnDummyKill";
    end;
}
    -    script    Punching Bag5    -1,{
OnInit:
OnDummyKill:
    monster "prontera",197,162,"Punching Balls",1905,1,"Punching Bag5::OnDummyKill";
    end;
}


     

    On 1/17/2015 at 6:07 PM, Emistry said:

    OnInit:

    setmapflag( "payon",mf_monster_noteleport );

    ser ia have a quest about on goldroom how remove ranking to my gold room script 

    /*
create table gold_ranking (
char_id int(11) primary key,
name varchar(23) default '',
gold_points int(11) default 0,
key (gold_points)
) engine = innodb;

create table gold_ranking_today (
char_id int(11) primary key,
name varchar(23) default '',
gold_points_today int(11) default 0,
key (gold_points_today)
) engine = innodb;

*/


prontera,165,195,5    script    Gold Room    848,{

OnMenu:

        OnMain:
        mes "[ Gold Room ]";
        mes "Welcome, ^ff0000" +strcharinfo(0)+ "!^000000";
        mes "We rank players based on their performance on farming Gold.";
        mes " ";

        [email protected]$  = "SELECT `name`, IF(@d=t.`gold_points`, @r, @r:[email protected]), @d:=t.`gold_points`, @i:[email protected]+1 ";
        [email protected]$ += "FROM `gold_ranking` t, (SELECT @d:=0, @r:=0, @i:=1)q ";
        [email protected]$ += "ORDER BY `gold_points` DESC LIMIT 1";
        [email protected] = query_sql([email protected]$, [email protected]$, [email protected], [email protected], [email protected]);
        

        query_sql "select gold_points from `gold_ranking` where char_id = "+ getcharid(0), [email protected];


    menu "Enter ^ff0000Gold Room^000000 ^3333cc(" + getmapusers("ordeal_1-2") + ")^000000",L_Enter,"",L_Total,"",L_Today,"Cancel",L_Cancel;

        L_Total:
        clear;
        mes "[ Gold Ladder ]";
        mes "^73acde<Rank>^000000 ^40cc39<Name>^000000 ^cc4f39<Points>^000000";

        [email protected]$  = "SELECT `name`, IF(@d=t.`gold_points`, @r, @r:[email protected]), @d:=t.`gold_points`, @i:[email protected]+1 ";
        [email protected]$ += "FROM `gold_ranking` t, (SELECT @d:=0, @r:=0, @i:=1)q ";
        [email protected]$ += "ORDER BY `gold_points` DESC LIMIT 10";
        [email protected] = query_sql([email protected]$, [email protected]$, [email protected], [email protected], [email protected]);

        if ( [email protected] ) {
            mes " ^777777-- Ladder is currently empty.^000000";
            close;
        }
        for ( [email protected] = 0; [email protected] < [email protected]; [email protected] )
            mes "^73acde"+ [email protected][[email protected]] +".^000000 ^40cc39"+ [email protected]$[[email protected]] +" : ^000000 ^cc4f39<"+ [email protected][[email protected]] +">^000000";
        end;
        
        L_Today:
        clear;
        mes "[ Gold Ladder ]";
        mes "^73acde<Rank>^000000 ^40cc39<Name>^000000 ^ffad33<Points>^000000";

        [email protected]$  = "SELECT `name`, IF(@d=t.`gold_points_today`, @r, @r:[email protected]), @d:=t.`gold_points_today`, @i:[email protected]+1 ";
        [email protected]$ += "FROM `gold_ranking_today` t, (SELECT @d:=0, @r:=0, @i:=1)q ";
        [email protected]$ += "ORDER BY `gold_points_today` DESC LIMIT 10";
        [email protected] = query_sql([email protected]$, [email protected]$, [email protected], [email protected], [email protected]);

        if ( [email protected] ) {
            mes " ^777777-- Ladder is currently empty.^000000";
            close;
        }
        for ( [email protected] = 0; [email protected] < [email protected]; [email protected] )
            mes "^73acde"+ [email protected][[email protected]] +".^000000 ^40cc39"+ [email protected]$[[email protected]] +" : ^000000 ^ffad33<"+ [email protected][[email protected]] +">^000000";
        end;

L_Enter:
    specialeffect 253;
    showscript "'" + strcharinfo(0) + "' entered!",getnpcid(0),AREA;
    warp "ordeal_1-2",0,0;
    end;

L_Cancel:
    end;

OnNPCKillEvent:
    if (killedrid == 1369) {
        if(!$gold_hour) {
            [email protected] = 1;            
        }
        else if($gold_hour) {
            [email protected] = rand(1,3);
        }
            getitem 969,[email protected];
            if([email protected] == 1){
            query_sql "insert into gold_ranking values ( "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) ) +"', 1 ) on duplicate key update name = '"+ escape_sql( strcharinfo(0) )+"', gold_points = gold_points + 1";
            query_sql "insert into gold_ranking_today values ( "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) ) +"', 1 ) on duplicate key update name = '"+ escape_sql( strcharinfo(0) )+"', gold_points_today = gold_points_today + 1";
            }
            if([email protected] == 2){
            query_sql "insert into gold_ranking values ( "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) ) +"', 1 ) on duplicate key update name = '"+ escape_sql( strcharinfo(0) )+"', gold_points = gold_points + 2";
            query_sql "insert into gold_ranking_today values ( "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) ) +"', 1 ) on duplicate key update name = '"+ escape_sql( strcharinfo(0) )+"', gold_points_today = gold_points_today + 2";
            }
            query_sql "select gold_points from `gold_ranking` where char_id = "+ getcharid(0), [email protected];
            query_sql "select gold_points_today from `gold_ranking_today` where char_id = "+ getcharid(0), [email protected]_today;
            end;
    }
    end;

OnClock0000:
    npctalk "Daily ladder has been reset!";
    query_sql "TRUNCATE TABLE `gold_ranking_today`";
    end;

    
}

ordeal_1-2    mapflag    pvp
ordeal_1-2    mapflag    nowarpto
ordeal_1-2    mapflag    nodrop
ordeal_1-2    mapflag    nobranch
ordeal_1-2    mapflag    nosave
ordeal_1-2    mapflag    nomemo
ordeal_1-2    mapflag    noloot


ordeal_1-2    monster    Golden Peco    1369,500
ordeal_1-2    monster    Golden Peco    1369,500
ordeal_1-2    monster    Golden Peco    1369,300


     

    mdef formula

    in Source Support

    Posted

    Anyone can Help me about this ?

    I want to change mdef formula

    my server is Frost Server .. but when anyone get to 99 mdef .. the players that 99 mdef wont freeze and the magic damage is only 1..

    i want to change the mdef to 99 mdef = 30% magic reduction only .. forget about the freeze ..

    Please Help mee Thx  :)

×
×
  • Create New...

Important Information

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

  I accept