I need help with add NPC

Results 1 to 3 of 3
  1. #1
    Novice shadow0ooo0 is offline
    MemberRank
    May 2009 Join Date
    2Posts

    shout I need help with add NPC

    Hello everyone can some one help me!
    i don't know how can i add NPC
    for exmaple : when i want add buffer { L2J Interlude }
    i put all the file in L2J Gameserver when i want Execute SQL i get this massege
    Code:
    [Err] 1146 - Table 'l2jdb.custom_npc' doesn't exist
    [Err] INSERT INTO custom_npc
       (`id`, `idTemplate`, `name`, `serverSideName`, `title`, `serverSideTitle`, `class`, `collision_radius`, `collision_height`, `level`, `sex`, `type`, `attackrange`, `hp`, `mp`, `hpreg`, `mpreg`, `str`, `con`, `dex`, `int`, `wit`, `men`, `exp`, `sp`, `patk`, `pdef`, `matk`, `mdef`, `atkspd`, `aggro`, `matkspd`, `rhand`, `lhand`, `armor`, `walkspd`, `runspd`, `faction_id`, `faction_range`, `isUndead`, `absorb_level`, `absorb_type`, `ss`, `bss`, `ss_rate`, `AI`)
    VALUES
       (40000, 32174, 'Buff Master', 1, 'Your Title', 1, 'LineageNPC2.K_F1_guard', 13.00, 22.50, 70, 'female', 'L2Npc', 40, 3862, 1493, 11.85, 2.78, 40, 43, 30, 21, 35, 10, 5879, 590, 1314, 470, 780, 382, 278, 0, 349, 0, 0, 0, 80, 120, '', 0, 0, 0, 'LAST_HIT', 0, 0, 0, 'fighter');
    [Msg] Finished - Unsuccessfully
    --------------------------------------------------
    plz some one help me with this

    the next question how can i disable weight penatly ?!!!!

    thanks for all !!


  2. #2
    Novice shadow0ooo0 is offline
    MemberRank
    May 2009 Join Date
    2Posts

    Re: I need help with add NPC

    i think i fixed : i download custom_npc.
    but i get other proplem !!

    [Err] 1136 - Column count doesn't match value count at row 1
    [Err] INSERT INTO custom_npc
    (`id`, `idTemplate`, `name`, `serverSideName`, `title`, `serverSideTitle`, `class`, `collision_radius`, `collision_height`, `level`, `sex`, `type`, `attackrange`, `hp`, `mp`, `hpreg`, `mpreg`, `str`, `con`, `dex`, `int`, `wit`, `men`, `exp`, `sp`, `patk`, `pdef`, `matk`, `mdef`, `atkspd`, `aggro`, `matkspd`, `rhand`, `lhand`, `armor`, `walkspd`, `runspd`, `faction_id`, `faction_range`, `isUndead`, `absorb_level`, `absorb_type`)
    VALUES
    (40000, 32174, 'Buff Master', 1, 'Set_BUFF', 1, 'LineageNPC2.K_F1_guard', 13.00, 22.50, 70, 'female', 'L2Npc', 40, 3862, 1493, 11.85, 2.78, 40, 43, 30, 21, 35, 10, 5879, 590, 1314, 470, 780, 382, 278, 0, 349, 0, 0, 0, 80, 120, '', 0, 0, 0, 'LAST_HIT', 0, 0, 0, 'fighter');
    [Msg] Finished - Unsuccessfully
    --------------------------------------------------

  3. #3
    ~ksemer~ DaRkAnGeL is offline
    MemberRank
    Oct 2006 Join Date
    Java_HomeLocation
    5,115Posts

    Re: I need help with add NPC

    the colums are different than your sql code. try to insert the line manually



Advertisement