Jump to content

jedwynne

Members
  • Posts

    68
  • Joined

  • Last visited

Posts posted by jedwynne

  1. In a for statement you can set several initialization statements:

    for(x=100, y=0; x!=y ;x--,y++){}

    Just need to put a comma :o

    i think 2 initialization wont work inside 1 for loop in npc script i have tried it

    @DevilEvil, i agree to @deathscythe13 i tried this...

    for (set .@x,0,set .@y,0; .@x <= 100;set .@x,.@x + 1,set .@y,.@y + 1)
    

    but im having an error

  2. // Structure of Database:
    // SkillID,CastingTime,AfterCastActDelay,AfterCastWalkDelay,Duration1,Duration2,Cool Down,Fixed Casting Time
    //== Explained:
    // CastingTime : time to cast this skill, in miliseconds
    // AfterCastActDelay : "normal" delay, character cannot use skills, in miliseconds
    // AfterCastWalkDleay : amount of time before character can move again, in miliseconds
    // Duration1 / Duration2 : usually the durations used by the skill, at special cases it is used to hold special data
    // Cool Down : amount of time until character can re-use this skill, in miliseconds
    // Fixed Casting Time: the skills fixed casting time (when 0, uses 20% of cast time)
    //== Extra
    // On all fields you can use ':' as a delimiter to level-specific values,
    // - Example using SM_PROVOKE
    // - Original:6,0,0,0,30000,0,1000
    // - ModifiedTo:6,0,0,0,30000,0,1000:2500:3000:etc
    // - Makes lvl 1 have 1000 (1s) cool down, lvl 2 2500 (2.5s), lvl 3 3000, and so on.
    //==========================================
    

  3. you can import SQL file...

    here are the sql query for char table

    --
    -- Table structure for table `char`
    --
    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',
     PRIMARY KEY  (`char_id`),
     KEY `account_id` (`account_id`),
     KEY `party_id` (`party_id`),
     KEY `guild_id` (`guild_id`),
     KEY `name` (`name`),
     KEY `online` (`online`)
    ) ENGINE=MyISAM AUTO_INCREMENT=150000;
    

×
×
  • Create New...