Jump to content

Diss

Members
 View Profile  See their activity

  • Posts

    207

  • Joined

  • Last visited

 Content Type 

Posts posted by Diss

    REJECTED FROM SERVER (3)

    in Client-side Support

    Posted

    sir i need to make a new grf?

    sir i used another RagexeRE and diff it works but i have a new error character info size error.,.,

    and cant make a new character cuz it will Dc.,.sorry bad english.,

     

    do you think sir i need to update my ragnarok? or renewal?

     

     

    try to get alexandria data folder v4

    Quests, Games: Breaker Room

    in Game, Event, Quest Script Releases

    Posted

     

    Please use rAthena ..... eAthena / 3Ceam doesnt support this kind of variable assign script....

    hi sir can you provide 1@room map i cant find one  ..

     

    just duplicate any map you want ... use your own map ...

     

    i dont know what map its good for this i thick the one you recommend is good ..

     

    but thanks ill find one if you cant provide thnx /thx

      sec_in02,172,162,4    script    Adv Breaker Room Manager    100,{

    if( select( "Rent a Room","View Ladder" ) == 1 ){
     
            if( !instance_id(1) ){ --------------------------------> error line 4

     

    Please use rAthena ..... eAthena / 3Ceam doesnt support this kind of variable assign script....

     

    how can i fix it 

        

    ManHunt Event RE-EDIT Please

    in Script Requests

    Posted · Edited by Capuche
    Thanks to use Code instead of Quote otherwise you BREAK the tab

    here the scenarios

     

    if the player A killed by the player B the player A cannot ressurected and cannot log out but if the player A announce to be haunted again it will killable and anyone can kill again but the player A nothing to do cannot log out ..

     

    sorry for my but english i hope you understand me ..

     

    my request ..

     

    i want this script if a player killed it will revive to revange .. ^_^

     

    credits to the owner of this script ..

     

    here the script ...

     //EMPERIUMRO ORIGINAL SCRIPT! DO NOT CLAIM THAT ITS YOURS! GIVE CREDIT TO THE SCRIPTER
// PROBLEM IS I DONT KNOW HIS NAME. BUT CREDITS TO HIM AND TO ME FOR SHARING. LOL!
prontera,156,159,3    script    Man-Hunt Event    831,{
    mes "[Man Hunt Event]";
    if(.MStatus)
        {
            mes "Status: ^00ff00ACTIVE!^000000";
            if(getgroupid() >= .GM)
                {
                    menu "Join Event",-,"Admin Commands",MHAdmin;
                    next;
                        if(.MStart)
                        {    mes "You can't join the event when it is ongoing.";
                            close;
                        }
                    set .ManHunt[.o], getcharid(3);
                    set .ManHuntN$[.o], strcharinfo(0);
                    set .o, .o + 1;
                    warp .MHMap$,0,0;
                    close;
                }
            else
                {
                    menu "Join Event",-;
                    if(.MStart)
                        {    mes "You can't join the event when it is ongoing.";
                            close;
                        }
                    set .ManHunt[.o], getcharid(3);
                    set .ManHuntN$[.o], strcharinfo(0);
                    set .o, .o + 1;
                    warp .MHMap$,0,0;
                    close;
                    close;
                }
        }
    else if(!.MStatus)
    {
        
        mes "Status: ^00ff00INACTIVE!^000000";
        mes "Man Hunt Points: "+MHPoint+"";
        if(getgroupid() >= .GM) 
            menu "Admin Commands",MHAdmin,"Claim Rewards",-;
        else
            menu "Claim Rewards",-;
        mes "There you go.";
        getitem .MHReward,MHPoint;
        set MHPoint, 0;
        close;
    }
        
MHAdmin:
        if(!.MStatus)
        {
            mes "Start Event?";
            menu "Start!",-;
            set .MStatus, 1;
            set .o, 0;
            announce "Man-Hunt Event warper will be closed in 3 minutes",0;
            setnpctimer 0;
            initnpctimer;
            close;
        }
        else if(.MStatus)
        {
            mes "End Event?";
            menu "End",-;
            set .MStatus, 0;
            deletearray .ManHunt[0],getarraysize(.ManHunt);
            deletearray .ManHuntN$[0],getarraysize(.ManHuntN$);    
            announce "A GM has ended the Man Hunt Event",0;
            stopnpctimer;
            close;
        }
    close;
    
OnClock0000:
OnClock0300:
OnClock0600:
OnClock0900:
OnClock1200:
OnClock1500:
OnClock1800:
OnClock2100:
        set .MStatus, 1;
        announce "Man-Hunt Event warper will be closed in 3 minutes",0;
        set .o, 0;
        setnpctimer 0;
        initnpctimer;
        end;
OnTimer60000:
        announce "Man-Hunt Event warper will be closed in 2 minutes",0;
        end;
OnTimer120000:
        announce "Man-Hunt Event warper will be closed in 60 Seconds",0;
        end;
        
OnTimer180000:
        announce "Man-Hunt Event warper is now closed.",0;
        sleep2 2000;
        mapannounce .MHMap$,"The goal is this event is to kill the target within 30 seconds.",0;
        sleep2 2000;
        mapannounce .MHMap$,"The one who managed to kill the target will gain 1 Man Hunt Point",0;
        sleep2 2000;
        mapannounce .MHMap$,"But if the target surivived, the target will gain 3 Man Hunt Points",0;
        sleep2 2000;
        mapannounce .MHMap$,"Enough explaining, let's do the Man-Hunt Event!",0;
        sleep2 2000;
        mapannounce .MHMap$,"Man-Hunt Event start!",0;
        atcommand "@doommap";
        atcommand "@raisemap";
        set .MStart,1;
        stopnpctimer;
        set .MRounds, 1;
        goto ManHuntStart;
        end;
        
OnTimer30000:
        if (.HuntedTimer)
        {
            mapannounce .MHMap$,"The Target, "+.ManHuntN$[.Target]+", managed to survive",0;
            atcommand "#killable "+.ManHuntN$[.Target]+"";
            atcommand "#size \""+.ManHuntN$[.Target]+"\" 0";
            sleep2 1000;
            if(attachrid(.ManHunt[.Target])) 
            {
                    set MHPoint, MHPoint + .MSurvive;
                    dispbottom "Gained "+.MSurvive+" Man Hunt Points.";
                    dispbottom "Current Man Hunt Points: "+MHPoint+"";
                    detachrid;                    
            }
            set .MRounds, .MRounds + 1;
            stopnpctimer;
            goto MHNextRound;
        }
        end;
        
ManHuntStart:
        if (getmapusers(.MHMap$) < .MHPlayer) goto MHPlayerLack;
        set .Target, rand(0,getarraysize(.ManHunt)-1);
        mapannounce .MHMap$,"[Round "+.MRounds+"] Our target is "+.ManHuntN$[.Target]+"!",0;
        atcommand "#killable "+.ManHuntN$[.Target]+"";
        atcommand "#size \""+.ManHuntN$[.Target]+"\" 2";
        setnpctimer 0;
        set .HuntedTimer, 1;
        initnpctimer;
        end;
        
OnPCDieEvent: //in victim's scope
    if (strcharinfo(3) == .MHMap$)
    {
    if( getcharid(3) == .ManHunt[.Target] ){
        if(attachrid(killerrid)) {
            announce ""+strcharinfo(0)+" has killed the target",0;
            set MHPoint, MHPoint + .MKill;
            atcommand "#killable "+.ManHuntN$[.Target]+"";
            atcommand "#size \""+.ManHuntN$[.Target]+"\" 0";
            dispbottom "Gained "+.MKill+" Man Hunt Points.";
            dispbottom "Current Man Hunt Points: "+MHPoint+"";
            set .MRounds, .MRounds + 1;
            stopnpctimer;
            detachrid;
            sleep2 500;
            atcommand "#alive "+.ManHuntN$[.Target]+"";
            goto MHNextRound;
        }
    }
    }
    end;
    
MHPlayerLack:
        mapannounce .MHMap$,"Failed to start Man-Hunt Event due to insufficient Players",0;
        sleep2 2000;
        mapannounce .MHMap$,"The minimum player required is "+.MHPlayer+" players",0;
        sleep2 2000;
        mapannounce .MHMap$,"All players will be warped to prontera in 2 seconds.",0;
        sleep2 2000;
        mapwarp .MHMap$,"prontera",150,150;
        set .MStatus, 0;
        set .HunterTimer, 0;
        set .Target, 0;
        set .MStart, 0;
        deletearray .ManHunt[0],getarraysize(.ManHunt);
        deletearray .ManHuntN$[0],getarraysize(.ManHuntN$);
        end;
        
    
MHNextRound:
    if (getmapusers(.MHMap$) < .MHPlayer) goto MHPlayerLack;
    if (.MRounds > .MRoundsMax)
            {
                sleep2 1000;
                announce "Man-Hunt Event ended.",0;
                sleep2 1000;
                set .MStatus, 0;
                set .HunterTimer, 0;
                deletearray .ManHunt[0],getarraysize(.ManHunt);
                deletearray .ManHuntN$[0],getarraysize(.ManHuntN$);
                mapannounce .MHMap$,"All Players will be warped to prontera in 5 seconds.",0;
                sleep2 5000;
                set .Target, 0;
                set .MStart, 0;
                mapwarp .MHMap$,"prontera",150,150;
                end;
            }
            else
            {
                announce "Next Round in 10 seconds.",0;
                sleep2 10000;
                goto ManHuntStart;
            }
    end;
OnPCLogOutEvent:
    if (.MStatus)
        if (getcharid(3) == .ManHunt[.Target])
        {
            mapannounce .MHMap$,"The target has logged out of this game. This round will be nulled.",0;
            set .MRounds, .MRounds + 1;
            goto MHNextRound;
        }
    end;
            
            
OnInit:
//start of config
    set .MHMap$, "cell_game"; // event map
    set .MHReward, 25000; // reward
    set .o, 0; // dont touch this
    set .GM, 99; // minimum gm lvl
    set .MRoundsMax, 10; // number of rounds
    set .MHPlayer, 3; // minimum players to start
    set .MSurvive, 3; // points para sa nagsurvive
    set .MKill, 1; // points para sa nakapatay
//end of config
    setarray .ManHunt[0],0;
    setarray .ManHuntN$[0],"";
    end;
}

     

     

     

    Thanks in Advance ..

    please EDIT my script ..

    in Script Requests

    Posted · Edited by Capuche
    To Code

    hi guys !! anyone can fix this script

     

    if can be the reward for this npc is random ex. gold, gold coin,etc

    //===== rAthena Script =======================================
//= Ai Daily Gold Giver
//===== By: ==================================================
//= Jupeto ( [email protected] )
//===== Current Version: =====================================
//= 1.0.0
//===== Compatible With: ===================================== 
//= rAthena SVN
//===== Description: =========================================
//= Earn guild points by taking quests either item or mob hunt
//===== Additional Comments: =================================  
// 1.0.0 Release
//============================================================
prontera,156,182,2    script    Daily Gold    54,{
    function SYS_ConvertTime;
    
    set .@npcname$, "[Daily Gold]"; // NPC Name
    set .@itemid, 969; // Item ID to give ( 969 is Gold )
    set .@itemamount, 20; // Amount of item to give
    set .@timdelay, 86400; // Time delay a user can get golds, 86400 is one day in seconds.
    mes .@npcname$;
    mes "Hello there.";
    mes "I am a special gold dealer, who will give you " + .@itemamount + " " + ( ( .@itemamount > 1 ) ? "pieces" : "piece" ) + " of " + getitemname( .@itemid ) + " once per day.";
    next;
    mes .@npcname$;
    mes "Would you like to get your free " + .@itemamount + " " + ( ( .@itemamount > 1 ) ? "pieces" : "piece" ) + " of " + getitemname( .@itemid ) + " now?";
    next;
    if(select("Yes","No") == 2) {
         mes .@npcname$;
         mes "Ok, good bye then.";
         close;
    }
    if(TimedGold > gettimetick(2)) {
         mes .@npcname$;
         mes "I am sorry " + strcharinfo(0) + ", but you can only get " + .@itemamount + " " + ( ( .@itemamount > 1 ) ? "pieces" : "piece" ) + " of " + getitemname( .@itemid ) + " once per day.";
         next;
         mes .@npcname$;
         mes "You have to wait for " + SYS_ConvertTime( TimedGold - gettimetick(2) ) + " left";
         close;
    }
    mes .@npcname$;
    mes "Ok, here goes!";
    close2;
    getitem .@itemid,.@itemamount;
    set TimedGold, gettimetick(2) + .@timdelay;
    dispbottom "Daily Gold : Please be reminded that you may only get " + .@itemamount + " " + ( ( .@itemamount > 1 ) ? "pieces" : "piece" ) + " of " + getitemname( .@itemid ) + " once per day.";
    
    function SYS_ConvertTime
    {        
        set @time, getarg( 0 );
        set @time$, "";
        
        set @days, @time / 86400;
        set @hours, ( @time / 3600 ) - ( @days * 24 );
        set @minutes, ( @time / 60 ) - ( @days * 1440 ) - ( @hours * 60 );
        set @seconds, @time % 60;
        
        set @seconds$, @seconds + " second" + ( ( @seconds < 2 ) ? "" : "s" );
        set @minutes$, @minutes + " minute" + ( ( @minutes < 2 ) ? "" : "s" );
        set @hours$, @hours + " hour" + ( ( @hours < 2 ) ? "" : "s" );
        set @days$, @days + " day" + ( ( @days < 2 ) ? "" : "s" );
        
        set @time$, @days$ + " " + @hours$ + " " + @minutes$ + " and " + @seconds$;
        
        return @time$;
    }
}

     

    thanks in advance !!

    change base lvl and job lvl svn 17400

    in General Support

    Posted

     

    It does have exp.txt.  You updated your SVN and never resolved the conflicts between the official files and yours.  That's why you're having these problems.

     

    Either you have to resolve them, or start over from a fresh SVN.

    that what i use TortoiseSVN to update my svn

     

    i download full clean svn 17400 theres no exp.txt too .

    It is renamed as Job_exp.txt http://svn.rathena.org/svn/rathena/trunk/db/re/job_exp.txt :)

    hays its work now finally thanks to you ..  hmm how about adding stats points ? ^_^

    nvm its solve !! thanks

    change base lvl and job lvl svn 17400

    in General Support

    Posted

    It does have exp.txt.  You updated your SVN and never resolved the conflicts between the official files and yours.  That's why you're having these problems.

     

    Either you have to resolve them, or start over from a fresh SVN.

    that what i use TortoiseSVN to update my svn

     

    i download full clean svn 17400 theres no exp.txt too .

    change base lvl and job lvl svn 17400

    in General Support

    Posted

    Job Level is in exp.txt db/re/exp.txt

    //Job - 2nd Classes & Baby 2nd Classes
50,7:8:9:10:11:12:13:14:15:16:17:18:19:20:21:4030:4031:4032:4033:4034:4035:4036:4037:4038:4039:4040:4041:4042:4043:4044:4051:4052,1,1600,2500,4200,7000,10300,15900,18900,20900,22600,24900,28800,31500,32000,33300,35100,40500,44100,46300,48500,50700,56000,59400,63500,68100,75000,85700,90500,96600,102600,108600,119700,126000,132300,138600,146100,157500,170600,180400,190300,196800,214900,225200,232000,245700,255900,279300,294000,308700,327000,345400,355761,366433,377425,388747,400409,412421,424793,437536,450662,464181,478106,492449,507222,522438,538111,554254,570881,588007,605647,623816,642530,661805,681659,702108,723171,744866,767211,790227,813933,838350,863500,889404,916086,943568,971875,1001031,1031061,1061992,1093851,1126666,1160465,1195278,1231136,1268070,1306112,1345295,1385653,1427222,1470038,1514139,1559563,1606349,1654539,1704175,1755300,1807958,1862196,1918061,1975602,2034870,2095916,2158793,2223556,2290262,2358969,2429738,2502630,2577708,2655039,2734690,2816730,2901231,2988267,3077914,3170251,3265358,3363318,3464217,3568143,3675187,3785442,3899005,4015975,4136454,4260547,4388363,4520013,4655613,4795281,4939139,5087313,5239932,5397129,5559042,5725813,5897587,6074514,6256749,6444451,6637784,6836917,7042024,7253284,7470882,7695008,7925858,8163633,8408541,8660796,8920619,9188237,9463883,9747799,10040232,10341438,10651680,10758196,10865777,10974434,11084178,11195019,11306969,11420038,11534238,11649580,11766075,11883735,12002572,12122597,12243822,12366260,12489922,12614821,12740969,12868378,12997061,13127031,13258301,13390883,13524791,13660038,13796638,13934604,14073949,14214688,14356834,14500402,14645405,14791858,14939776,15089173,15240064,15392464,15546388,15701851,15858869,16017457,16177631,16339407,16502800,16667827,16834505,17002848,17172876,17344604,17518049,17693228,17870160,18048861,18229348,18411641,18595756,18781713,18969528,19159223,19350816,19544323,19739767,19937165,20136535,20337901,20541278,20746690,20954156,21163697,21375332,21589085,21804974,22023023,22243254,22465686,22690342,22917245,23146416,23377879,23611658,23847774,24086251,24327114,24570384,24816087,25064248,25314890,25568038,25823718

    change that to desired job level.

     

     

    and i dont know about that, i guess try to redownload a clean svn again.

     

     

    but svn 17400 dont have exp.txt if i copy exp.txt in other svn there's a yellow triangle with exclamation point

    change base lvl and job lvl svn 17400

    in General Support

    Posted · Edited by Diss

    { "max_lv", &battle_config.max_lv, 99, 0, 127,

     

    to

     

    { "max_lv", &battle_config.max_lv, 99, 0, 255,

     

     

     

     

    change the red,not the blue.

     

    ok thank

     

    but how the job lvl still the same 70 ?

    can i ask something whe i update my svn there's no exp.txt and re/itemdb.txt have exclamation point in a yellow triangle and i have this

     

    re/itemdb.txt.mine

    re/itemdb.txt.svn17367

    re/itemdb.txt.svn17400 in a blue circle and question mark

     

    im just confuse to this 

    change base lvl and job lvl svn 17400

    in General Support

    Posted · Edited by Diss

    how to change base lvl and job i change this but nothing happen

     

    { "max_lv", &battle_config.max_lv, 99, 0, 127,

     

    to

     

    { "max_lv", &battle_config.max_lv, 99, 0, 255,

     

     

    #define MAX_LEVEL 99

     

    to 

     

    #define MAX_LEVEL 255

     

     

    there no exp.txt in svn 17400

     

    recompile

     

    still the same 99/70

     

    i want this 255/120

     

    thanks in advance

    [DDos Attack]connection lost after update to svn17400

    in General Support

    Posted · Edited by Diss
    Changed to [code]

    im having this problem after i recieve ddos attack detected i decide to update my svn to 17400 then i get this 
     
    anyone can help me 
     
    im making my test server
     
    charserv-sql.bat

     

4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
[Info]: Connection request of the char-server 'Diss Ragnarok Onlin' @ 25.60.37.1
4:6121 (account: 'demanidada', pass: 'demanidada', ip: '25.60.37.14')
[Notice]: Unknown account (account: demanidada, received pass: demanidada, ip: 2
5.60.37.14)
[Notice]: Connection of the char-server 'Diss Ragnarok Onlin' REFUSED.
[Info]: Closed connection from '25.60.37.14'.
 

     
    mapserv-sql.bat

     

    ok .. i know now .. DDos attack my ip.. when i change the ip to defualt(127.0.0.1) its works fine .. i just need to request my new ip add .

     

    thnx

     

    i need custom warper npc

    in Script Requests

    Posted

    sorry for new thread i dont know what im looking for ^_^

     

    probably i n need script custom warper npc where i can edit maps destination 

     

    ex mall,pvproom etc.

     

    thanks 

     

    opps and item remover script w/o requirements ..

     

    thnaks 

    Reflect"Reflection damage"

    in Source Releases

    Posted

    hi i need help about this 

     

    src\map\battle.c

    // Deals the same damage to targets in area. [pakpil]
     int battle_damage_area( struct block_list *bl, va_list ap) {
         unsigned int tick;
        int amotion, dmotion, damage;
        int amotion, dmotion, damage, return_, damage_;
         struct block_list *src;
     
        nullpo_ret(bl);
     
        tick=va_arg(ap, unsigned int);
        src=va_arg(ap,struct block_list *);
        amotion=va_arg(ap,int);
        dmotion=va_arg(ap,int);
        damage=va_arg(ap,int);
        if( bl->type == BL_MOB && ((TBL_MOB*)bl)->class_ == MOBID_EMPERIUM )
            return 0;
        if( bl != src && battle_check_target(src,bl,BCT_ENEMY) > 0 ) {
            map_freeblock_lock();
            if( src->type == BL_PC )
                battle_drain((TBL_PC*)src, bl, damage, damage, status_get_race(bl), is_boss(bl));
            if( amotion )
                battle_delay_damage(tick, amotion,src,bl,0,CR_REFLECTSHIELD,0,damage,ATK_DEF,0,true);
            else
                 status_fix_damage(src,bl,damage,0);
             clif_damage(bl,bl,tick,amotion,dmotion,damage,1,ATK_BLOCK,0);
             skill_additional_effect(src, bl, CR_REFLECTSHIELD, 1, BF_WEAPON|BF_SHORT|BF_NORMAL,ATK_DEF,tick);
            if( (return_=((TBL_PC*)bl)->bonus.short_weapon_damage_return) > 0 )
            {
                damage_=damage*return_/100;
                if(damage_>0)
                {
                    battle_delay_damage(tick, amotion,bl,src,0,CR_REFLECTSHIELD,0,damage_,ATK_DEF,0,true);
                    clif_damage(src,src,tick,amotion,dmotion,damage_,1,ATK_BLOCK,0);
                    skill_additional_effect(bl, src, CR_REFLECTSHIELD, 1, BF_WEAPON|BF_SHORT|BF_NORMAL,ATK_DEF,tick);
                }
            }
             map_freeblock_unlock();
         }

     then recompile 

     

    item_db2

     2101,Guard,Guard,5,500,,300,,20,,0,0xFFFFFFFF,7,2,32,,0,1,1,{},{bonus bShortWeaponDamageReturn,100; },{ },{}

     

     

    i think if i recieve the reflect and one who wear reflcet shield is going to recieve dmg but its nothing happen ano can help me ..

    need help in custom suit

    in Graphics Support

    Posted

    idnum2itemdisplaynametable = 30005#_Akatsuki_Suit#

     

    idnum2itemresnametable  = 30005#_Akatsuki_Suit#

     

    accessoryid = ACCESSORY_AKATSUKI_SUIT = 1004,

     

    accname = [ACCESSORY_IDs.ACCESSORY_AKATSUKI_SUIT] = "_Akatsuki_Suit", -----> its not my last item

     

    ¾ÆÀÌÅÛ

     

    _Akatsuki_Suit.spr

    _Akatsuki_Suit.act

     

    ¾Ç¼¼»ç¸®\¿©

     

    ¿©_Akatsuki_Suit.spr

    ¿©_Akatsuki_Suit.act

     

    ¾Ç¼¼»ç¸®\³²

    ³²_Akatsuki_Suit.spr

    ³²_Akatsuki_Suit.act

     

    item/collection

     

    _Akatsuki_Suit.bmp

     

    item_db2

     

    30005,_Akatsuki_suit,_Akatsuki_Suit,5,20,,400,,120,,0,0xFFFFFFFF,7,2,16,,94,0,1004,{ bonus bMdef,10; bonus bMaxHP,20*BaseLevel; bonus bMaxSP,5*BaseLevel; bonus2 bAddRace,RC_NonBoss,10; bonus2 bAddRace,RC_Boss,10; bonus bMatkRate,10; bonus bUnbreakableArmor,0; bonus bNoKnockback,0; },{},{}
     
    screenDissRagnarokOnlin006_zpsc1b2c28e.j
     

    item inventory and equip are gone

    in General Support

    Posted · Edited by Diss

    i update my svn to the latest i also excute the main.sql in mysql workbench

     

    and i got this error and bugged in char.sql when i logged in 

     

    Untitled2_zps6a539f6b.png

     

    i hope anyone can help

     

    thx

     

    before i excute the main.sql its work fine 

     

    now i excuted again the main.sql i got this 

     

    CREATE TABLE IF NOT EXISTS `auction` (   `auction_id` bigint(20) unsigned NOT NULL auto_increment,   `seller_id` int(11) unsigned NOT NULL default '0',   `seller_name` varchar(30) NOT NULL default '',   `buyer_id` int(11) unsigned NOT NULL default '0',   `buyer_name` varchar(30) NOT NULL default '',   `price` int(11) unsigned NOT NULL default '0',   `buynow` int(11) unsigned NOT NULL default '0',   `hours` smallint(6) NOT NULL default '0',   `timestamp` int(11) unsigned NOT NULL default '0',   `nameid` int(11) unsigned NOT NULL default '0',   `item_name` varchar(50) NOT NULL default '',   `type` smallint(6) NOT NULL default '0',   `refine` tinyint(3) unsigned NOT NULL default '0',   `attribute` tinyint(4) unsigned NOT NULL default '0',   `card0` smallint(11) NOT NULL default '0',   `card1` smallint(11) NOT NULL default '0',   `card2` smallint(11) NOT NULL default '0',   `card3` smallint(11) NOT NULL default '0',   `unique_id` bigint(20) unsigned NOT NULL default '0',   PRIMARY KEY  (`auction_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `cart_inventory` (   `id` int(11) NOT NULL auto_increment,   `char_id` int(11) NOT NULL default '0',   `nameid` int(11) NOT NULL default '0',   `amount` int(11) NOT NULL default '0',   `equip` mediumint(8) unsigned NOT NULL default '0',   `identify` smallint(6) NOT NULL default '0',   `refine` tinyint(3) unsigned NOT NULL default '0',   `attribute` tinyint(4) NOT NULL default '0',   `card0` smallint(11) NOT NULL default '0',   `card1` smallint(11) NOT NULL default '0',   `card2` smallint(11) NOT NULL default '0',   `card3` smallint(11) NOT NULL default '0',   `expire_time` int(11) unsigned NOT NULL default '0',   `bound` tinyint(3) unsigned NOT NULL default '0',   `unique_id` bigint(20) unsigned NOT NULL default '0',   PRIMARY KEY  (`id`),   KEY `char_id` (`char_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `char` (   `char_id` int(11) unsigned NOT NULL auto_increment,   `account_id` int(11) unsigned NOT NULL default '0',   `char_num` tinyint(1) NOT NULL default '0',   `name` varchar(30) NOT NULL DEFAULT '',   `class` smallint(6) unsigned NOT NULL default '0',   `base_level` smallint(6) unsigned NOT NULL default '1',   `job_level` smallint(6) unsigned NOT NULL default '1',   `base_exp` bigint(20) unsigned NOT NULL default '0',   `job_exp` bigint(20) unsigned NOT NULL default '0',   `zeny` int(11) unsigned NOT NULL default '0',   `str` smallint(4) unsigned NOT NULL default '0',   `agi` smallint(4) unsigned NOT NULL default '0',   `vit` smallint(4) unsigned NOT NULL default '0',   `int` smallint(4) unsigned NOT NULL default '0',   `dex` smallint(4) unsigned NOT NULL default '0',   `luk` smallint(4) unsigned NOT NULL default '0',   `max_hp` mediumint(8) unsigned NOT NULL default '0',   `hp` mediumint(8) unsigned NOT NULL default '0',   `max_sp` mediumint(6) unsigned NOT NULL default '0',   `sp` mediumint(6) unsigned NOT NULL default '0',   `status_point` int(11) unsigned NOT NULL default '0',   `skill_point` int(11) unsigned NOT NULL default '0',   `option` int(11) NOT NULL default '0',   `karma` tinyint(3) NOT NULL default '0',   `manner` smallint(6) NOT NULL default '0',   `party_id` int(11) unsigned NOT NULL default '0',   `guild_id` int(11) unsigned NOT NULL default '0',   `pet_id` int(11) unsigned NOT NULL default '0',   `homun_id` int(11) unsigned NOT NULL default '0',   `elemental_id` int(11) unsigned NOT NULL default '0',   `hair` tinyint(4) unsigned NOT NULL default '0',   `hair_color` smallint(5) unsigned NOT NULL default '0',   `clothes_color` smallint(5) unsigned NOT NULL default '0',   `weapon` smallint(6) unsigned NOT NULL default '0',   `shield` smallint(6) unsigned NOT NULL default '0',   `head_top` smallint(6) unsigned NOT NULL default '0',   `head_mid` smallint(6) unsigned NOT NULL default '0',   `head_bottom` smallint(6) unsigned NOT NULL default '0',   `robe` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',   `last_map` varchar(11) NOT NULL default '',   `last_x` smallint(4) unsigned NOT NULL default '53',   `last_y` smallint(4) unsigned NOT NULL default '111',   `save_map` varchar(11) NOT NULL default '',   `save_x` smallint(4) unsigned NOT NULL default '53',   `save_y` smallint(4) unsigned NOT NULL default '111',   `partner_id` int(11) unsigned NOT NULL default '0',   `online` tinyint(2) NOT NULL default '0',   `father` int(11) unsigned NOT NULL default '0',   `mother` int(11) unsigned NOT NULL default '0',   `child` int(11) unsigned NOT NULL default '0',   `fame` int(11) unsigned NOT NULL default '0',   `rename` SMALLINT(3) unsigned NOT NULL default '0',   `delete_date` INT(11) UNSIGNED NOT NULL DEFAULT '0',   `moves` int(11) unsigned NOT NULL DEFAULT '0',   PRIMARY KEY  (`char_id`),   UNIQUE KEY `name_key` (`name`),   KEY `account_id` (`account_id`),   KEY `party_id` (`party_id`),   KEY `guild_id` (`guild_id`),   KEY `online` (`online`) ) ENGINE=MyISAM AUTO_INCREMENT=150000
     
    CREATE TABLE IF NOT EXISTS `charlog` (   `time` datetime NOT NULL default '0000-00-00 00:00:00',   `char_msg` varchar(255) NOT NULL default 'char select',   `account_id` int(11) NOT NULL default '0',   `char_num` tinyint(4) NOT NULL default '0',   `name` varchar(23) NOT NULL default '',   `str` int(11) unsigned NOT NULL default '0',   `agi` int(11) unsigned NOT NULL default '0',   `vit` int(11) unsigned NOT NULL default '0',   `int` int(11) unsigned NOT NULL default '0',   `dex` int(11) unsigned NOT NULL default '0',   `luk` int(11) unsigned NOT NULL default '0',   `hair` tinyint(4) NOT NULL default '0',   `hair_color` int(11) NOT NULL default '0' ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `elemental` (   `ele_id` int(11) unsigned NOT NULL auto_increment,   `char_id` int(11) NOT NULL,   `class` mediumint(9) unsigned NOT NULL default '0',   `mode` int(11) unsigned NOT NULL default '1',   `hp` int(12) NOT NULL default '1',   `sp` int(12) NOT NULL default '1',   `max_hp` mediumint(8) unsigned NOT NULL default '0',   `max_sp` mediumint(6) unsigned NOT NULL default '0',   `atk1` MEDIUMINT(6) unsigned NOT NULL default '0',   `atk2` MEDIUMINT(6) unsigned NOT NULL default '0',   `matk` MEDIUMINT(6) unsigned NOT NULL default '0',   `aspd` smallint(4) unsigned NOT NULL default '0',   `def` smallint(4) unsigned NOT NULL default '0',   `mdef` smallint(4) unsigned NOT NULL default '0',   `flee` smallint(4) unsigned NOT NULL default '0',   `hit` smallint(4) unsigned NOT NULL default '0',   `life_time` int(11) NOT NULL default '0',   PRIMARY KEY  (`ele_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `friends` (   `char_id` int(11) NOT NULL default '0',   `friend_account` int(11) NOT NULL default '0',   `friend_id` int(11) NOT NULL default '0',   KEY  `char_id` (`char_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `hotkey` (  `char_id` INT(11) NOT NULL,  `hotkey` TINYINT(2) unsigned NOT NULL,  `type` TINYINT(1) unsigned NOT NULL default '0',  `itemskill_id` INT(11) unsigned NOT NULL default '0',  `skill_lvl` TINYINT(4) unsigned NOT NULL default '0',  PRIMARY KEY (`char_id`,`hotkey`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `global_reg_value` (   `char_id` int(11) unsigned NOT NULL default '0',   `str` varchar(255) NOT NULL default '',   `value` varchar(255) NOT NULL default '0',   `type` tinyint(1) NOT NULL default '3',   `account_id` int(11) unsigned NOT NULL default '0',   PRIMARY KEY  (`char_id`,`str`,`account_id`),   KEY `account_id` (`account_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `guild` (   `guild_id` int(11) unsigned NOT NULL auto_increment,   `name` varchar(24) NOT NULL default '',   `char_id` int(11) unsigned NOT NULL default '0',   `master` varchar(24) NOT NULL default '',   `guild_lv` tinyint(6) unsigned NOT NULL default '0',   `connect_member` tinyint(6) unsigned NOT NULL default '0',   `max_member` tinyint(6) unsigned NOT NULL default '0',   `average_lv` smallint(6) unsigned NOT NULL default '1',   `exp` bigint(20) unsigned NOT NULL default '0',   `next_exp` int(11) unsigned NOT NULL default '0',   `skill_point` tinyint(11) unsigned NOT NULL default '0',   `mes1` varchar(60) NOT NULL default '',   `mes2` varchar(120) NOT NULL default '',   `emblem_len` int(11) unsigned NOT NULL default '0',   `emblem_id` int(11) unsigned NOT NULL default '0',   `emblem_data` blob,   PRIMARY KEY  (`guild_id`,`char_id`),   UNIQUE KEY `guild_id` (`guild_id`),   KEY `char_id` (`char_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `guild_alliance` (   `guild_id` int(11) unsigned NOT NULL default '0',   `opposition` int(11) unsigned NOT NULL default '0',   `alliance_id` int(11) unsigned NOT NULL default '0',   `name` varchar(24) NOT NULL default '',   PRIMARY KEY  (`guild_id`,`alliance_id`),   KEY `alliance_id` (`alliance_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `guild_castle` (   `castle_id` int(11) unsigned NOT NULL default '0',   `guild_id` int(11) unsigned NOT NULL default '0',   `economy` int(11) unsigned NOT NULL default '0',   `defense` int(11) unsigned NOT NULL default '0',   `triggerE` int(11) unsigned NOT NULL default '0',   `triggerD` int(11) unsigned NOT NULL default '0',   `nextTime` int(11) unsigned NOT NULL default '0',   `payTime` int(11) unsigned NOT NULL default '0',   `createTime` int(11) unsigned NOT NULL default '0',   `visibleC` int(11) unsigned NOT NULL default '0',   `visibleG0` int(11) unsigned NOT NULL default '0',   `visibleG1` int(11) unsigned NOT NULL default '0',   `visibleG2` int(11) unsigned NOT NULL default '0',   `visibleG3` int(11) unsigned NOT NULL default '0',   `visibleG4` int(11) unsigned NOT NULL default '0',   `visibleG5` int(11) unsigned NOT NULL default '0',   `visibleG6` int(11) unsigned NOT NULL default '0',   `visibleG7` int(11) unsigned NOT NULL default '0',   PRIMARY KEY  (`castle_id`),   KEY `guild_id` (`guild_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `guild_expulsion` (   `guild_id` int(11) unsigned NOT NULL default '0',   `account_id` int(11) unsigned NOT NULL default '0',   `name` varchar(24) NOT NULL default '',   `mes` varchar(40) NOT NULL default '',   PRIMARY KEY  (`guild_id`,`name`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `guild_member` (   `guild_id` int(11) unsigned NOT NULL default '0',   `account_id` int(11) unsigned NOT NULL default '0',   `char_id` int(11) unsigned NOT NULL default '0',   `hair` tinyint(6) unsigned NOT NULL default '0',   `hair_color` smallint(6) unsigned NOT NULL default '0',   `gender` tinyint(6) unsigned NOT NULL default '0',   `class` smallint(6) unsigned NOT NULL default '0',   `lv` smallint(6) unsigned NOT NULL default '0',   `exp` bigint(20) unsigned NOT NULL default '0',   `exp_payper` tinyint(11) unsigned NOT NULL default '0',   `online` tinyint(4) unsigned NOT NULL default '0',   `position` tinyint(6) unsigned NOT NULL default '0',   `name` varchar(24) NOT NULL default '',   PRIMARY KEY  (`guild_id`,`char_id`),   KEY `char_id` (`char_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `guild_position` (   `guild_id` int(9) unsigned NOT NULL default '0',   `position` tinyint(6) unsigned NOT NULL default '0',   `name` varchar(24) NOT NULL default '',   `mode` tinyint(11) unsigned NOT NULL default '0',   `exp_mode` tinyint(11) unsigned NOT NULL default '0',   PRIMARY KEY  (`guild_id`,`position`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `guild_skill` (   `guild_id` int(11) unsigned NOT NULL default '0',   `id` smallint(11) unsigned NOT NULL default '0',   `lv` tinyint(11) unsigned NOT NULL default '0',   PRIMARY KEY  (`guild_id`,`id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `guild_storage` (   `id` int(10) unsigned NOT NULL auto_increment,   `guild_id` int(11) unsigned NOT NULL default '0',   `nameid` int(11) unsigned NOT NULL default '0',   `amount` int(11) unsigned NOT NULL default '0',   `equip` mediumint(8) unsigned NOT NULL default '0',   `identify` smallint(6) unsigned NOT NULL default '0',   `refine` tinyint(3) unsigned NOT NULL default '0',   `attribute` tinyint(4) unsigned NOT NULL default '0',   `card0` smallint(11) NOT NULL default '0',   `card1` smallint(11) NOT NULL default '0',   `card2` smallint(11) NOT NULL default '0',   `card3` smallint(11) NOT NULL default '0',   `expire_time` int(11) unsigned NOT NULL default '0',   `bound` tinyint(3) unsigned NOT NULL default '0',   `unique_id` bigint(20) unsigned NOT NULL default '0',   PRIMARY KEY  (`id`),   KEY `guild_id` (`guild_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `homunculus` (   `homun_id` int(11) NOT NULL auto_increment,   `char_id` int(11) NOT NULL,   `class` mediumint(9) unsigned NOT NULL default '0',   `prev_class` mediumint(9) NOT NULL default '0',   `name` varchar(24) NOT NULL default '',   `level` smallint(4) NOT NULL default '0',   `exp` int(12) NOT NULL default '0',   `intimacy` int(12) NOT NULL default '0',   `hunger` smallint(4) NOT NULL default '0',   `str` smallint(4) unsigned NOT NULL default '0',   `agi` smallint(4) unsigned NOT NULL default '0',   `vit` smallint(4) unsigned NOT NULL default '0',   `int` smallint(4) unsigned NOT NULL default '0',   `dex` smallint(4) unsigned NOT NULL default '0',   `luk` smallint(4) unsigned NOT NULL default '0',   `hp` int(12) NOT NULL default '1',   `max_hp` int(12) NOT NULL default '1',   `sp` int(12) NOT NULL default '1',   `max_sp` int(12) NOT NULL default '1',   `skill_point` smallint(4) unsigned NOT NULL default '0',   `alive` tinyint(2) NOT NULL default '1',   `rename_flag` tinyint(2) NOT NULL default '0',   `vaporize` tinyint(2) NOT NULL default '0',   PRIMARY KEY  (`homun_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `interlog` (   `time` datetime NOT NULL default '0000-00-00 00:00:00',   `log` varchar(255) NOT NULL default '' ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `inventory` (   `id` int(11) unsigned NOT NULL auto_increment,   `char_id` int(11) unsigned NOT NULL default '0',   `nameid` int(11) unsigned NOT NULL default '0',   `amount` int(11) unsigned NOT NULL default '0',   `equip` mediumint(8) unsigned NOT NULL default '0',   `identify` smallint(6) NOT NULL default '0',   `refine` tinyint(3) unsigned NOT NULL default '0',   `attribute` tinyint(4) unsigned NOT NULL default '0',   `card0` smallint(11) NOT NULL default '0',   `card1` smallint(11) NOT NULL default '0',   `card2` smallint(11) NOT NULL default '0',   `card3` smallint(11) NOT NULL default '0',   `expire_time` int(11) unsigned NOT NULL default '0',   `favorite` tinyint(3) unsigned NOT NULL default '0',   `bound` tinyint(3) unsigned NOT NULL default '0',   `unique_id` bigint(20) unsigned NOT NULL default '0',   PRIMARY KEY  (`id`),   KEY `char_id` (`char_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `ipbanlist` (   `list` varchar(255) NOT NULL default '',   `btime` datetime NOT NULL default '0000-00-00 00:00:00',   `rtime` datetime NOT NULL default '0000-00-00 00:00:00',   `reason` varchar(255) NOT NULL default '',   KEY (`list`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `login` (   `account_id` int(11) unsigned NOT NULL auto_increment,   `userid` varchar(23) NOT NULL default '',   `user_pass` varchar(32) NOT NULL default '',   `sex` enum('M','F','S') NOT NULL default 'M',   `email` varchar(39) NOT NULL default '',   `group_id` tinyint(3) NOT NULL default '0',   `state` int(11) unsigned NOT NULL default '0',   `unban_time` int(11) unsigned NOT NULL default '0',   `expiration_time` int(11) unsigned NOT NULL default '0',   `logincount` mediumint(9) unsigned NOT NULL default '0',   `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',   `last_ip` varchar(100) NOT NULL default '',   `birthdate` DATE NOT NULL DEFAULT '0000-00-00',   `character_slots` tinyint(3) unsigned NOT NULL default '0',   `pincode` varchar(4) NOT NULL DEFAULT '',   `pincode_change` int(11) unsigned NOT NULL DEFAULT '0',   PRIMARY KEY  (`account_id`),   KEY `name` (`userid`) ) ENGINE=MyISAM AUTO_INCREMENT=2000000
     
    INSERT INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`) VALUES ('1', 's1', 'p1', 'S','[email protected]')
     
    CREATE TABLE IF NOT EXISTS `auction` (   `auction_id` bigint(20) unsigned NOT NULL auto_increment,   `seller_id` int(11) unsigned NOT NULL default '0',   `seller_name` varchar(30) NOT NULL default '',   `buyer_id` int(11) unsigned NOT NULL default '0',   `buyer_name` varchar(30) NOT NULL default '',   `price` int(11) unsigned NOT NULL default '0',   `buynow` int(11) unsigned NOT NULL default '0',   `hours` smallint(6) NOT NULL default '0',   `timestamp` int(11) unsigned NOT NULL default '0',   `nameid` int(11) unsigned NOT NULL default '0',   `item_name` varchar(50) NOT NULL default '',   `type` smallint(6) NOT NULL default '0',   `refine` tinyint(3) unsigned NOT NULL default '0',   `attribute` tinyint(4) unsigned NOT NULL default '0',   `card0` smallint(11) NOT NULL default '0',   `card1` smallint(11) NOT NULL default '0',   `card2` smallint(11) NOT NULL default '0',   `card3` smallint(11) NOT NULL default '0',   `unique_id` bigint(20) unsigned NOT NULL default '0',   PRIMARY KEY  (`auction_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `auction` (   `auction_id` bigint(20) unsigned NOT NULL auto_increment,   `seller_id` int(11) unsigned NOT NULL default '0',   `seller_name` varchar(30) NOT NULL default '',   `buyer_id` int(11) unsigned NOT NULL default '0',   `buyer_name` varchar(30) NOT NULL default '',   `price` int(11) unsigned NOT NULL default '0',   `buynow` int(11) unsigned NOT NULL default '0',   `hours` smallint(6) NOT NULL default '0',   `timestamp` int(11) unsigned NOT NULL default '0',   `nameid` int(11) unsigned NOT NULL default '0',   `item_name` varchar(50) NOT NULL default '',   `type` smallint(6) NOT NULL default '0',   `refine` tinyint(3) unsigned NOT NULL default '0',   `attribute` tinyint(4) unsigned NOT NULL default '0',   `card0` smallint(11) NOT NULL default '0',   `card1` smallint(11) NOT NULL default '0',   `card2` smallint(11) NOT NULL default '0',   `card3` smallint(11) NOT NULL default '0',   `unique_id` bigint(20) unsigned NOT NULL default '0',   PRIMARY KEY  (`auction_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `cart_inventory` (   `id` int(11) NOT NULL auto_increment,   `char_id` int(11) NOT NULL default '0',   `nameid` int(11) NOT NULL default '0',   `amount` int(11) NOT NULL default '0',   `equip` mediumint(8) unsigned NOT NULL default '0',   `identify` smallint(6) NOT NULL default '0',   `refine` tinyint(3) unsigned NOT NULL default '0',   `attribute` tinyint(4) NOT NULL default '0',   `card0` smallint(11) NOT NULL default '0',   `card1` smallint(11) NOT NULL default '0',   `card2` smallint(11) NOT NULL default '0',   `card3` smallint(11) NOT NULL default '0',   `expire_time` int(11) unsigned NOT NULL default '0',   `bound` tinyint(3) unsigned NOT NULL default '0',   `unique_id` bigint(20) unsigned NOT NULL default '0',   PRIMARY KEY  (`id`),   KEY `char_id` (`char_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `char` (   `char_id` int(11) unsigned NOT NULL auto_increment,   `account_id` int(11) unsigned NOT NULL default '0',   `char_num` tinyint(1) NOT NULL default '0',   `name` varchar(30) NOT NULL DEFAULT '',   `class` smallint(6) unsigned NOT NULL default '0',   `base_level` smallint(6) unsigned NOT NULL default '1',   `job_level` smallint(6) unsigned NOT NULL default '1',   `base_exp` bigint(20) unsigned NOT NULL default '0',   `job_exp` bigint(20) unsigned NOT NULL default '0',   `zeny` int(11) unsigned NOT NULL default '0',   `str` smallint(4) unsigned NOT NULL default '0',   `agi` smallint(4) unsigned NOT NULL default '0',   `vit` smallint(4) unsigned NOT NULL default '0',   `int` smallint(4) unsigned NOT NULL default '0',   `dex` smallint(4) unsigned NOT NULL default '0',   `luk` smallint(4) unsigned NOT NULL default '0',   `max_hp` mediumint(8) unsigned NOT NULL default '0',   `hp` mediumint(8) unsigned NOT NULL default '0',   `max_sp` mediumint(6) unsigned NOT NULL default '0',   `sp` mediumint(6) unsigned NOT NULL default '0',   `status_point` int(11) unsigned NOT NULL default '0',   `skill_point` int(11) unsigned NOT NULL default '0',   `option` int(11) NOT NULL default '0',   `karma` tinyint(3) NOT NULL default '0',   `manner` smallint(6) NOT NULL default '0',   `party_id` int(11) unsigned NOT NULL default '0',   `guild_id` int(11) unsigned NOT NULL default '0',   `pet_id` int(11) unsigned NOT NULL default '0',   `homun_id` int(11) unsigned NOT NULL default '0',   `elemental_id` int(11) unsigned NOT NULL default '0',   `hair` tinyint(4) unsigned NOT NULL default '0',   `hair_color` smallint(5) unsigned NOT NULL default '0',   `clothes_color` smallint(5) unsigned NOT NULL default '0',   `weapon` smallint(6) unsigned NOT NULL default '0',   `shield` smallint(6) unsigned NOT NULL default '0',   `head_top` smallint(6) unsigned NOT NULL default '0',   `head_mid` smallint(6) unsigned NOT NULL default '0',   `head_bottom` smallint(6) unsigned NOT NULL default '0',   `robe` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',   `last_map` varchar(11) NOT NULL default '',   `last_x` smallint(4) unsigned NOT NULL default '53',   `last_y` smallint(4) unsigned NOT NULL default '111',   `save_map` varchar(11) NOT NULL default '',   `save_x` smallint(4) unsigned NOT NULL default '53',   `save_y` smallint(4) unsigned NOT NULL default '111',   `partner_id` int(11) unsigned NOT NULL default '0',   `online` tinyint(2) NOT NULL default '0',   `father` int(11) unsigned NOT NULL default '0',   `mother` int(11) unsigned NOT NULL default '0',   `child` int(11) unsigned NOT NULL default '0',   `fame` int(11) unsigned NOT NULL default '0',   `rename` SMALLINT(3) unsigned NOT NULL default '0',   `delete_date` INT(11) UNSIGNED NOT NULL DEFAULT '0',   `moves` int(11) unsigned NOT NULL DEFAULT '0',   PRIMARY KEY  (`char_id`),   UNIQUE KEY `name_key` (`name`),   KEY `account_id` (`account_id`),   KEY `party_id` (`party_id`),   KEY `guild_id` (`guild_id`),   KEY `online` (`online`) ) ENGINE=MyISAM AUTO_INCREMENT=150000
     
    CREATE TABLE IF NOT EXISTS `charlog` (   `time` datetime NOT NULL default '0000-00-00 00:00:00',   `char_msg` varchar(255) NOT NULL default 'char select',   `account_id` int(11) NOT NULL default '0',   `char_num` tinyint(4) NOT NULL default '0',   `name` varchar(23) NOT NULL default '',   `str` int(11) unsigned NOT NULL default '0',   `agi` int(11) unsigned NOT NULL default '0',   `vit` int(11) unsigned NOT NULL default '0',   `int` int(11) unsigned NOT NULL default '0',   `dex` int(11) unsigned NOT NULL default '0',   `luk` int(11) unsigned NOT NULL default '0',   `hair` tinyint(4) NOT NULL default '0',   `hair_color` int(11) NOT NULL default '0' ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `elemental` (   `ele_id` int(11) unsigned NOT NULL auto_increment,   `char_id` int(11) NOT NULL,   `class` mediumint(9) unsigned NOT NULL default '0',   `mode` int(11) unsigned NOT NULL default '1',   `hp` int(12) NOT NULL default '1',   `sp` int(12) NOT NULL default '1',   `max_hp` mediumint(8) unsigned NOT NULL default '0',   `max_sp` mediumint(6) unsigned NOT NULL default '0',   `atk1` MEDIUMINT(6) unsigned NOT NULL default '0',   `atk2` MEDIUMINT(6) unsigned NOT NULL default '0',   `matk` MEDIUMINT(6) unsigned NOT NULL default '0',   `aspd` smallint(4) unsigned NOT NULL default '0',   `def` smallint(4) unsigned NOT NULL default '0',   `mdef` smallint(4) unsigned NOT NULL default '0',   `flee` smallint(4) unsigned NOT NULL default '0',   `hit` smallint(4) unsigned NOT NULL default '0',   `life_time` int(11) NOT NULL default '0',   PRIMARY KEY  (`ele_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `friends` (   `char_id` int(11) NOT NULL default '0',   `friend_account` int(11) NOT NULL default '0',   `friend_id` int(11) NOT NULL default '0',   KEY  `char_id` (`char_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `hotkey` (  `char_id` INT(11) NOT NULL,  `hotkey` TINYINT(2) unsigned NOT NULL,  `type` TINYINT(1) unsigned NOT NULL default '0',  `itemskill_id` INT(11) unsigned NOT NULL default '0',  `skill_lvl` TINYINT(4) unsigned NOT NULL default '0',  PRIMARY KEY (`char_id`,`hotkey`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `global_reg_value` (   `char_id` int(11) unsigned NOT NULL default '0',   `str` varchar(255) NOT NULL default '',   `value` varchar(255) NOT NULL default '0',   `type` tinyint(1) NOT NULL default '3',   `account_id` int(11) unsigned NOT NULL default '0',   PRIMARY KEY  (`char_id`,`str`,`account_id`),   KEY `account_id` (`account_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `guild` (   `guild_id` int(11) unsigned NOT NULL auto_increment,   `name` varchar(24) NOT NULL default '',   `char_id` int(11) unsigned NOT NULL default '0',   `master` varchar(24) NOT NULL default '',   `guild_lv` tinyint(6) unsigned NOT NULL default '0',   `connect_member` tinyint(6) unsigned NOT NULL default '0',   `max_member` tinyint(6) unsigned NOT NULL default '0',   `average_lv` smallint(6) unsigned NOT NULL default '1',   `exp` bigint(20) unsigned NOT NULL default '0',   `next_exp` int(11) unsigned NOT NULL default '0',   `skill_point` tinyint(11) unsigned NOT NULL default '0',   `mes1` varchar(60) NOT NULL default '',   `mes2` varchar(120) NOT NULL default '',   `emblem_len` int(11) unsigned NOT NULL default '0',   `emblem_id` int(11) unsigned NOT NULL default '0',   `emblem_data` blob,   PRIMARY KEY  (`guild_id`,`char_id`),   UNIQUE KEY `guild_id` (`guild_id`),   KEY `char_id` (`char_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `guild_alliance` (   `guild_id` int(11) unsigned NOT NULL default '0',   `opposition` int(11) unsigned NOT NULL default '0',   `alliance_id` int(11) unsigned NOT NULL default '0',   `name` varchar(24) NOT NULL default '',   PRIMARY KEY  (`guild_id`,`alliance_id`),   KEY `alliance_id` (`alliance_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `guild_castle` (   `castle_id` int(11) unsigned NOT NULL default '0',   `guild_id` int(11) unsigned NOT NULL default '0',   `economy` int(11) unsigned NOT NULL default '0',   `defense` int(11) unsigned NOT NULL default '0',   `triggerE` int(11) unsigned NOT NULL default '0',   `triggerD` int(11) unsigned NOT NULL default '0',   `nextTime` int(11) unsigned NOT NULL default '0',   `payTime` int(11) unsigned NOT NULL default '0',   `createTime` int(11) unsigned NOT NULL default '0',   `visibleC` int(11) unsigned NOT NULL default '0',   `visibleG0` int(11) unsigned NOT NULL default '0',   `visibleG1` int(11) unsigned NOT NULL default '0',   `visibleG2` int(11) unsigned NOT NULL default '0',   `visibleG3` int(11) unsigned NOT NULL default '0',   `visibleG4` int(11) unsigned NOT NULL default '0',   `visibleG5` int(11) unsigned NOT NULL default '0',   `visibleG6` int(11) unsigned NOT NULL default '0',   `visibleG7` int(11) unsigned NOT NULL default '0',   PRIMARY KEY  (`castle_id`),   KEY `guild_id` (`guild_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `guild_expulsion` (   `guild_id` int(11) unsigned NOT NULL default '0',   `account_id` int(11) unsigned NOT NULL default '0',   `name` varchar(24) NOT NULL default '',   `mes` varchar(40) NOT NULL default '',   PRIMARY KEY  (`guild_id`,`name`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `guild_member` (   `guild_id` int(11) unsigned NOT NULL default '0',   `account_id` int(11) unsigned NOT NULL default '0',   `char_id` int(11) unsigned NOT NULL default '0',   `hair` tinyint(6) unsigned NOT NULL default '0',   `hair_color` smallint(6) unsigned NOT NULL default '0',   `gender` tinyint(6) unsigned NOT NULL default '0',   `class` smallint(6) unsigned NOT NULL default '0',   `lv` smallint(6) unsigned NOT NULL default '0',   `exp` bigint(20) unsigned NOT NULL default '0',   `exp_payper` tinyint(11) unsigned NOT NULL default '0',   `online` tinyint(4) unsigned NOT NULL default '0',   `position` tinyint(6) unsigned NOT NULL default '0',   `name` varchar(24) NOT NULL default '',   PRIMARY KEY  (`guild_id`,`char_id`),   KEY `char_id` (`char_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `guild_position` (   `guild_id` int(9) unsigned NOT NULL default '0',   `position` tinyint(6) unsigned NOT NULL default '0',   `name` varchar(24) NOT NULL default '',   `mode` tinyint(11) unsigned NOT NULL default '0',   `exp_mode` tinyint(11) unsigned NOT NULL default '0',   PRIMARY KEY  (`guild_id`,`position`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `guild_skill` (   `guild_id` int(11) unsigned NOT NULL default '0',   `id` smallint(11) unsigned NOT NULL default '0',   `lv` tinyint(11) unsigned NOT NULL default '0',   PRIMARY KEY  (`guild_id`,`id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `guild_storage` (   `id` int(10) unsigned NOT NULL auto_increment,   `guild_id` int(11) unsigned NOT NULL default '0',   `nameid` int(11) unsigned NOT NULL default '0',   `amount` int(11) unsigned NOT NULL default '0',   `equip` mediumint(8) unsigned NOT NULL default '0',   `identify` smallint(6) unsigned NOT NULL default '0',   `refine` tinyint(3) unsigned NOT NULL default '0',   `attribute` tinyint(4) unsigned NOT NULL default '0',   `card0` smallint(11) NOT NULL default '0',   `card1` smallint(11) NOT NULL default '0',   `card2` smallint(11) NOT NULL default '0',   `card3` smallint(11) NOT NULL default '0',   `expire_time` int(11) unsigned NOT NULL default '0',   `bound` tinyint(3) unsigned NOT NULL default '0',   `unique_id` bigint(20) unsigned NOT NULL default '0',   PRIMARY KEY  (`id`),   KEY `guild_id` (`guild_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `homunculus` (   `homun_id` int(11) NOT NULL auto_increment,   `char_id` int(11) NOT NULL,   `class` mediumint(9) unsigned NOT NULL default '0',   `prev_class` mediumint(9) NOT NULL default '0',   `name` varchar(24) NOT NULL default '',   `level` smallint(4) NOT NULL default '0',   `exp` int(12) NOT NULL default '0',   `intimacy` int(12) NOT NULL default '0',   `hunger` smallint(4) NOT NULL default '0',   `str` smallint(4) unsigned NOT NULL default '0',   `agi` smallint(4) unsigned NOT NULL default '0',   `vit` smallint(4) unsigned NOT NULL default '0',   `int` smallint(4) unsigned NOT NULL default '0',   `dex` smallint(4) unsigned NOT NULL default '0',   `luk` smallint(4) unsigned NOT NULL default '0',   `hp` int(12) NOT NULL default '1',   `max_hp` int(12) NOT NULL default '1',   `sp` int(12) NOT NULL default '1',   `max_sp` int(12) NOT NULL default '1',   `skill_point` smallint(4) unsigned NOT NULL default '0',   `alive` tinyint(2) NOT NULL default '1',   `rename_flag` tinyint(2) NOT NULL default '0',   `vaporize` tinyint(2) NOT NULL default '0',   PRIMARY KEY  (`homun_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `interlog` (   `time` datetime NOT NULL default '0000-00-00 00:00:00',   `log` varchar(255) NOT NULL default '' ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `inventory` (   `id` int(11) unsigned NOT NULL auto_increment,   `char_id` int(11) unsigned NOT NULL default '0',   `nameid` int(11) unsigned NOT NULL default '0',   `amount` int(11) unsigned NOT NULL default '0',   `equip` mediumint(8) unsigned NOT NULL default '0',   `identify` smallint(6) NOT NULL default '0',   `refine` tinyint(3) unsigned NOT NULL default '0',   `attribute` tinyint(4) unsigned NOT NULL default '0',   `card0` smallint(11) NOT NULL default '0',   `card1` smallint(11) NOT NULL default '0',   `card2` smallint(11) NOT NULL default '0',   `card3` smallint(11) NOT NULL default '0',   `expire_time` int(11) unsigned NOT NULL default '0',   `favorite` tinyint(3) unsigned NOT NULL default '0',   `bound` tinyint(3) unsigned NOT NULL default '0',   `unique_id` bigint(20) unsigned NOT NULL default '0',   PRIMARY KEY  (`id`),   KEY `char_id` (`char_id`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `ipbanlist` (   `list` varchar(255) NOT NULL default '',   `btime` datetime NOT NULL default '0000-00-00 00:00:00',   `rtime` datetime NOT NULL default '0000-00-00 00:00:00',   `reason` varchar(255) NOT NULL default '',   KEY (`list`) ) ENGINE=MyISAM
     
    CREATE TABLE IF NOT EXISTS `login` (   `account_id` int(11) unsigned NOT NULL auto_increment,   `userid` varchar(23) NOT NULL default '',   `user_pass` varchar(32) NOT NULL default '',   `sex` enum('M','F','S') NOT NULL default 'M',   `email` varchar(39) NOT NULL default '',   `group_id` tinyint(3) NOT NULL default '0',   `state` int(11) unsigned NOT NULL default '0',   `unban_time` int(11) unsigned NOT NULL default '0',   `expiration_time` int(11) unsigned NOT NULL default '0',   `logincount` mediumint(9) unsigned NOT NULL default '0',   `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',   `last_ip` varchar(100) NOT NULL default '',   `birthdate` DATE NOT NULL DEFAULT '0000-00-00',   `character_slots` tinyint(3) unsigned NOT NULL default '0',   `pincode` varchar(4) NOT NULL DEFAULT '',   `pincode_change` int(11) unsigned NOT NULL DEFAULT '0',   PRIMARY KEY  (`account_id`),   KEY `name` (`userid`) ) ENGINE=MyISAM AUTO_INCREMENT=2000000
     
    INSERT INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`) VALUES ('1', 's1', 'p1', 'S','[email protected]')
     
×
×
  • Create New...