Jump to content

Yoona

Members
 View Profile  See their activity

  • Posts

    567

  • Joined

  • Last visited

 Content Type 

Posts posted by Yoona

    @request IP based Freebies

    in Script Requests

    Posted

    Execute this on your database

    CREATE TABLE IF NOT EXISTS `freebies` (
  `id` int(11) NOT NULL auto_increment,
  `account_id` int(11) NOT NULL default '0',
  `name` varchar(23) NOT NULL default '',
  `last_ip` varchar(100) NOT NULL default '',
  PRIMARY KEY (`account_id`),
  KEY (`id`)
) ENGINE=MyISAM;

     

    Then try this code : 

     

     

    prontera,150,150,0    script    Freebies    100,{
    mes .NPC$;
    mes "Wanna get the freebies " +strcharinfo(0)+ "?";
    if (select("Yes:No") - 1) close;
    mes .NPC$;
    mes "Let me check if you are really a new member";
    next;
    query_sql("SELECT last_ip FROM `login` WHERE account_id = "+getcharid(3)+"", .@lastip$);
    query_sql("SELECT last_ip FROM `freebies`", .@freebiesip$);
    if (.@lastip$ == .@freebiesip$) {
            mes .NPC$;
            mes "You already got the freebies " +strcharinfo(0);
            close;
    }
    query_sql("INSERT INTO `freebies` VALUES (NULL," + getcharid(3) + ",'" + escape_sql(strcharinfo(0)) + "','" + .@lastip$ + "')");
    for ( set .@x,0; .@x < getarraysize(.freebie_item); set .@x,.@x + 1 ) {
            getitem .freebie_item[.@x], ..quantity[.@x];
    }
    
    close;
    
    OnInit:
        set .NPC$, "[ " strnpcinfo(1)+ " ]";
        setarray .freebie_item[0],607,608;
        setarray .quantity[0],1,1;
}

    Did not test though. Post if an error occured.

    there's an Error at line 17, what should i do ????

    Requesting

    in Script Requests

    Posted

    ? the link is alive

    http://pastebin.com/u7QKZPk7

     

    CREATE TABLE IF NOT EXISTS `callfrnd` (
`id` int(11) NOT NULL auto_increment,
`account_id` int(11) NOT NULL default '0',
`name` varchar(23) NOT NULL default '',
`last_ip` varchar(100) NOT NULL default '',
`last_ip2` varchar(100) NOT NULL default '',
`ref_name` varchar(23) NOT NULL default '',
`ref_id` int(11) NOT NULL default '0',
`mins` tinyint(3) unsigned NOT NULL default '0',
`days` tinyint(3) unsigned NOT NULL default '0',
`task_end` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`account_id`),
KEY (`id`)
) ENGINE=MyISAM;

    thanks! =) more power to you and GOD bless!

    Is this a Rare Script?

    in Script Requests

    Posted

    Was it @questitem or just "questitem" in chat anytime ?, do u have to type something in the whisper box ?

    nope, no need to whisper it you just need to type the special word like "questitem" <= this is just an example =)

     

    and then a dynamic NPC will pop up..

    I've seen some servers had it set to whisper the server itself which is by default located in the whisper menu perhaps that's what you've done?

    hmm, whisper menu? i am asking if someone have this kind of script ^_^

    Maybe you're talking about @createquest? I didn't quite understand what did you want. Here you can find my @createquest command.

     

    http://forum.brathena.org/index.php/topic/17475-admin-quest-creator-createquest/

    nope, not like this =) but thanks for the response!

    Requesting

    in Script Requests

    Posted

    A Invite a Friend NPC

     

    that can do like this:

     

    - Check the IP for each Invited Player.

    - Recieve 100 Cash Points when the Inviter got the requirements.

    - To recieve the prize you need to have 5 invited players and need's write the inivter In game name.

     

     

     

    Thanks in advance =)

    Soulinker Job

    in Database Requests

    Posted

    How can i change this job? cos hes/her skill cant be use on other players like Esma Estun can someone help me with this?

     

     

    Please =) thanks! and more power to all RO Lover's out there!

    GOLD exchanger

    in Script Requests

    Posted · Edited by Capuche
    Script in code

    Try this.. you can edit it by yourself..

     

     

    //==============================================================================//
//=[Script Release : Credit Exchanger]
//=[Easy Modification]
//============================================================================//
//=[Script : DaemonSpade]
//==============================================================================//
//=[Idea Came From : DaemonSpade]
//=[Special Thanks to : Emistry]
//==============================================================================//
//= Description
//==============================================================================//
//=1. This Script Has Capacity Exchange
//= Zeny Capacity is 2,000,000,000z
//=A.Non Zeny Eater
//=B.Zeny/Credit Limiter Make it Exact
//=Example A: You Have 2b Zeny & You Exchange a Coin/Credit
//= The NPC Will Ask You Agian How Many Credits or Zeny You Will Exchanged
//=Example B: It Reads Your Zeny so The NPC Know The Max of Credit You Can Exchange Dont Put Wrong Ammount of Credit/Coin
//= The NPC Will Ask You Agian How Many Credits or Zeny You Will Exchanged
//==============================================================================//
//= Rules for using this script
//=1. Do not claim it as yours.
//=2. Do not change the credits.
//=3. Do not sell the script to earn money.
//==============================================================================//

prontera,164,196,4 script Credit Exchanger 416,{

//====================================[Customization Area]==========================//
set .npcname$,"^0000EE[Zeny Exchanger]^000000"; //NPC Name
set .coinname$,"^0000EEGold Coin^000000"; //Name of Item as Coin Used
set .CoinID,671; // Credit ID Set to Red Potion
set .zeny,10000000; // Credit Price Set by 10,000,000 or 10m
set .capzeny,1000000000; //Zeny Capacity Set by 2,000,000,000 or 2b
//==============================================================================//
// Check Line 89 To Edit The Chat/Pub Name Like This:
// waitingroom "Credit Exchanger",0;
//==============================================================================//

PlayerMode:
mes .npcname$;
mes "Hello there "+strcharinfo(0);
mes "Rule's Of Exchange";
mes "1 ^0000EE"+.coinname$+"^000000 is [^0000EE"+.zeny+"z^000000]";
mes "Zeny Exchange Capacity is [^0000EE"+.capzeny+"z^000000]";
switch(select("(Gold Coin) to (Zeny):(Zeny) to (Gold COin)")) {
Case 1:
next;
mes .npcname$;
mes "How many Gold Coins to exchange?";
mes "Put The Credit Amount";
mes "Put ^0000EE[0]^000000 to Cancel";
mes "1 ^0000EE"+.coinname$+"^000000 is [^0000EE"+.zeny+"z^000000]";
mes "Zeny Exchange Capacity is [^0000EE"+.capzeny+"z^000000]";
next;
do{
input @Credit,0,countitem(.CoinID);
if( @Credit < 1 ) close;
}while( ( ( @Credit * .zeny ) + Zeny ) > .capzeny );
next;
mes .npcname$;
mes "Thanks";
delitem .CoinID,@Credit;
set Zeny, Zeny + ( @Credit * .zeny );
dispbottom "Zeny Exchange Finished";
close;

Case 2:
next;
mes .npcname$;
mes "How much Gold Coin you like to Gain?";
mes "Put The Zeny Amount";
mes "Put ^0000EE[0]^000000 to Cancel";
mes "1 ^0000EE"+.coinname$+"^000000 is [^0000EE"+.zeny+"z^000000]";
mes "Zeny Exchange Capacity is [^0000EE"+.capzeny+"z^000000]";
next;
input @Credit,0,( Zeny / .zeny );
if( @Credit < 1 ) close;
next;
mes .npcname$;
mes "Thanks.";
set Zeny, Zeny - ( @Credit * .zeny);
getitem .CoinID,@Credit;
dispbottom "Zeny Exchange Finished";
close;

OnInit:
waitingroom "Zeny Exchanger",0;
end;
}
close;
}

     


    I Need Help =(

    in Client Requests

    Posted · Edited by Yoona

    Sorry if make the wrong thread for this =( i just really need it badly..

     

     

    if can someone give me an Custom weapon for this Jobs?

     

     

    Clown/Gypsy

    Assassin Cross ( Dagger )

    Gunslinger

    Ninja

     

     

    I really need it TSR is still Down, =( sorry if im asking for too much.. i will respect your decisions..

    HP %

    in Database Requests

    Posted

    Check your db/(pre-)re/job_db1.txt file.

    Look at this: JobID,Weight,HPFactor,HPMultiplicator,...

    Adjust your HPFactor and HPMultiplcator for your job.

    thanks Mysterious! i will inform you if somethings went wrong =)

    MATK BUG?

    in Database Requests

    Posted

    maybe your using the renewal stats?

     

    check this:

    #define RENEWAL

     

    And do it like this:

    //#define RENEWAL

     

    then recompile your Trunk

     

    you can see this at trunk/src/config/renewal.h

     

     

    correct me if im wrong =)

    No Card Drop

    in Database Requests

    Posted

    maybe you didn't reloadbattleconf ? or reload your server after changing that?

     

     

    or your should do the custom drop rate script it helps but you need to modify all the monster card drops.

    item ID

    in Database Requests

    Posted · Edited by Yoona

    You should Explore, to understand all of it

     

    its not wrong to ask question but youre question is not that hard

     

    Mr Patskie and Critica is right learn the basic scripting

     

    Goggle is always Online use him and search the basic scripting..

     

    Im also a Newbie but i learn and understand all of it =) i hope you too..

    rAthena Revision 17339

    in Database Support

    Posted

    It doesn't.

    1736,ALIOT,Aliot,Aliot,112,15669,1,2448,1836,2,608,697,106,15,111,56,55,42,62,75,10,12,1,6,60,0x318D,200,1296,432,360,0,0,0,0,0,0,0,7512,2000,7507,3000,2516,10,6214,200,1810,10,985,10,13405,15,0,0,0,0,4402,1
    If it does, it's not related to the official (unmodified) files.

    ohh thanks Euphy its already fixed =)

×
×
  • Create New...