[Guide]How to Import NPC normally

[EdenEternal]

First of all Hello Maxcheaters.

Serveral days Users Contact to me and Ask to help add Gmshop,Global GK,Buffer and etc.

So i tired to explain.

Also forum is full with topics with chronicle npcs requests...

I decided to open topic about how to import NPC normally.

 

Let's Start.

 

i took L2J-Teon.

for example we download some GMShop

first of all we must add sql file yes?

Go Navicat

Right Click on l2jdb and select Execute Batch File

Select GMshop-s sql and press Start.

We Got Error

[Err] 1136 - Column count doesn't match value count at row 1

What we must do?

 

1.Just Click On table npc and then Export Wizard

 

 

2.We must select export format. Select SQL script file(*.sql)

 

 

3.Below Export to Click ...

 

 

4.Save File to desktop

 

 

5.Click 3 times Next and then Start

 

 

6.If you see this all is ok

 

[Msg] [Exp] Table Type - SQL script file
[Msg] [Exp] Getting and Exporting data ...
[Msg] [Exp] Export table [npc]
[Msg] [Exp] Export to - C:\Documents and Settings\Leki\Desktop\npc.sql
[Msg] [Exp] Finished - Successfully

 

7.Now go to desktop and open npc.sql with Notepad.

 

 

8.Now you must choose how your gmshop must like? ID you can view Here

 

9.Say you choose Mew the Cat(14177)

 

10.Press Ctrl+F and write 14177

 

11.You see Mew the Cat's SQL script copy it

 

INSERT INTO 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
   (14177, 14177, 'Mew the Cat', 0, '', 0, 'Monster.cutie_cat', 8.00, 15.00, 78, 'female', 'L2Npc', 40, 7085, 2057, 13.43, 3.09, 40, 43, 30, 21, 20, 25, 0, 0, 1715, 555, 1069, 520, 278, 0, 333, 0, 0, 0, 52, 154, NULL, 0, 0, 0, 'LAST_HIT', 0, 0, 0, 'fighter');

 

12.Now you must change some things...

 

INSERT INTO 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

  (NPC_ID, 14177, 'NPC_NAME', 1, 'NPC_TITLE', 1, 'Monster.cutie_cat', 8.00, 15.00, 78, 'female', 'NPC_TYPE', 40, 7085, 2057, 13.43, 3.09, 40, 43, 30, 21, 20, 25, 0, 0, 1715, 555, 1069, 520, 278, 0, 333, 0, 0, 0, 52, 154, NULL, 0, 0, 0, 'LAST_HIT', 0, 0, 0, 'fighter');

 

*NPC_TYPE

GMShop - L2Merchant

Gatekeeper - L2Teleporter

Monster - L2Monster

Raid Boss - L2RaidBoss

Grand Boss  - L2GrandBoss

Minion - L2Minion

Other Npc - L2Npc

 

Save it in *.sql file and execute :)

 

That all :) Thanks for writing i hope i help :)

 

Credits for Guide to me :)

 

P.s  I hope some1 will give me karma

[`Rοmeο]

Good Share Leki Thnx :)

[Rzeszut]

Good Guide ,Thank's Leki :)

[Onix]

excellent guide and good work, thnx for it ;)

[BloodyIcon]

good work and nice guide!!

[99razor99]

[Err] 1062 - Duplicate entry '1' for key 1

[Err] INSERT INTO `npc` VALUES (1, 1, 'Thomas D. Turkey', 0, 'Misguided Holiday Scrooge', 0, 'LineageMonster4.br_crazy_turkey', 20.00, 30.00, 70, 'male', 'L2Npc', 40, 3862, 1494, 0.00, 0.00, 40, 43, 30, 21, 20, 20, 0, 0, 1303, 471, 607, 382, 253, 0, 333, 0, 0, 0, 0, 30, 132, 0, 0, 'LAST_HIT', 'false');

[Msg] Finished - Unsuccessfully

--------------------------------------------

 

And this info i have (i step by step in your guide)

[leeleatherwood]

[Err] 1062 - Duplicate entry '1' for key 1

[Err] INSERT INTO `npc` VALUES (1, 1, 'Thomas D. Turkey', 0, 'Misguided Holiday Scrooge', 0, 'LineageMonster4.br_crazy_turkey', 20.00, 30.00, 70, 'male', 'L2Npc', 40, 3862, 1494, 0.00, 0.00, 40, 43, 30, 21, 20, 20, 0, 0, 1303, 471, 607, 382, 253, 0, 333, 0, 0, 0, 0, 30, 132, 0, 0, 'LAST_HIT', 'false');

[Msg] Finished - Unsuccessfully

--------------------------------------------

 

And this info i have (i step by step in your guide)

 

He forgot to mention in his guide you need to change the NPC ID.

 

The NPC_ID is the first number after VALUES, in your case its 1, change it to any number that is not already in use, for instance 77701.

 

Then you will be working.

[HellRanger]

Good guide that you can do it for make an .sql file for one mod/npc/armor/weapon/item that you make and you dont know to create .sql file for each project (l2j server dont have the same .sql files like the l2j teon that you use for example).

[Andrutz]

[Err] 1146 - Table 'l2jdb.npc' doesn't exist

[Err] INSERT INTO `npc` VALUES (1, 1, 'Thomas D. Turkey', 0, 'Misguided Holiday Scrooge', 0, 'LineageMonster4.br_crazy_turkey', 25.00, 35.00, 80, 'male', 'L2Npc', 40, 680.000000000000000, 2000.000000000000000, 0.000000000000000, 0.900000000000000, 40, 43, 30, 21, 20, 20, 0, 0, 8.47458, 60000.00000, 5.78704, 200000.00000, 253, 1, 0, 333, 0, 0, 0, 19.50000, 160.00000, 1, 1, 0, 1);

[Msg] Finished - Unsuccessfully

--------------------------------------------------

 

Can you help me?

[monsterbg]

Goood one. Thanks

[monsterbg]

Goood one. Thanks

[monsterbg]

Goood one. Thanks