Jump to content

[Guide]How to Import NPC normally


Recommended Posts

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

 

59132782.png

 

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

 

15428436.png

 

3.Below Export to Click ...

 

68364004.png

 

4.Save File to desktop

 

42001186.png

 

5.Click 3 times Next and then Start

 

26262611.png

 

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.

 

30344604.png

 

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

Link to comment
Share on other sites

  • 3 weeks later...

[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)

Link to comment
Share on other sites

  • 3 weeks later...

[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.

Link to comment
Share on other sites

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).

Link to comment
Share on other sites

  • 8 months later...

[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?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...