A Project for Chronicle 4 based on L2JServer.


    DnR question for you

    Share
    avatar
    xlinkinx

    Posts : 164
    Join date : 2012-12-11
    Age : 25

    DnR question for you

    Post  xlinkinx on 5th January 2014, 13:00

    you can realize the following table NPC?

    Code:
    DROP TABLE IF EXISTS `npc`;
    CREATE TABLE `npc` (
      `ordinal` smallint(4) unsigned NOT NULL default '0',
      `id` int(11) unsigned NOT NULL default '0',
      `name` varchar(45) default NULL,
      `title` varchar(25) NOT NULL default '',
      `class` varchar(40) default NULL,
      `collision_radius` decimal(5,2) default NULL,
      `collision_height` decimal(5,2) default NULL,
      `level` int(11) default NULL,
      `sex` varchar(6) default NULL,
      `type` varchar(20) default NULL,
      `ai_type` varchar(20) default NULL,
      `attackrange` int(11) default NULL,
      `hp` int(11) default NULL,
      `base_hp_regen` double(11,3) NOT NULL default '0.000',
      `mp` int(11) default NULL,
      `base_mp_regen` double(11,3) NOT NULL default '0.000',
      `str` int(11) default NULL,
      `con` int(11) default NULL,
      `dex` int(11) default NULL,
      `int` int(11) default NULL,
      `wit` int(11) default NULL,
      `men` int(11) default NULL,
      `exp` int(11) default NULL,
      `sp` int(11) default NULL,
      `patk` int(11) default NULL,
      `pdef` int(11) default NULL,
      `matk` int(11) default NULL,
      `mdef` int(11) default NULL,
      `atkspd` int(11) default NULL,
      `aggro` int(11) default NULL,
      `matkspd` int(11) default NULL,
      `rhand` int(11) default NULL,
      `lhand` int(11) default NULL,
      `armor` int(11) default NULL,
      `walkspd` int(11) default NULL,
      `runspd` int(11) default NULL,
      `faction_id` varchar(40) default NULL,
      `faction_range` int(11) default NULL,
      `last_editor` varchar(50) default 'Local',
      `last_changed` varchar(20) default NULL,
      `displayId` int(11) NOT NULL default '0',
      `shield_defense_rate` int(11) default NULL,
      `shield_defense` int(11) default NULL,
      `corpse_time` int(11) default NULL,
      `base_rand_dam` int(11) default NULL,
      `base_critical` int(11) default NULL,
      `physical_hit_modify` int(11) default NULL,
      `base_reuse_delay` int(11) default NULL,
      `physical_avoid_modify` int(11) default NULL,
      `hit_time_factor` double(11,2) default '0.00',
      `ss` int(4) DEFAULT '0',
      `bss` int(4) DEFAULT '0',
      `ss_rate` int(3) DEFAULT '0',
      PRIMARY KEY  (`id`),
      KEY `map_flag` (`map_flag`,`boss_flag`)
    ) ENGINE=MyISAM;

    Well, or the like, that would be an opportunity to transfer the stats with PTS c4.
    avatar
    DnR
    Admin
    Admin

    Posts : 1027
    Join date : 2012-12-03

    Re: DnR question for you

    Post  DnR on 5th January 2014, 14:28

    I' m afraid you have to rely on current NPC table for the time being.
    Thanks a lot.
    avatar
    xlinkinx

    Posts : 164
    Join date : 2012-12-11
    Age : 25

    Re: DnR question for you

    Post  xlinkinx on 5th January 2014, 15:14

    DnR wrote:I' m afraid you have to rely on current NPC table for the time being.
    Thanks a lot.
    and if you add at least some features of me above? I just have left in stock for 2-3 months, and then I'll install your server, but still can not seem to solve the java or java TCP unnecessarily closer to me and do it for themselves it would be easy, but with PTS likely arise problems.

    Sponsored content

    Re: DnR question for you

    Post  Sponsored content


      Current date/time is 18th November 2017, 17:37