[Question] Adding NPC

[Tresiem573]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:4402
L2JDP Revision Number:4402

Okay, believe me when I say, I'm still learning here, and I have been using the search function to many variations of how to add an npc. I look at the post, and it's all gibberish to me. I've been using the search for the past hour now, and I have decided to just come out and ask... if this gets delete, no harm in trying.

But how the duck do you add in an npc for, example a GM Shop, like the one in the attachment? I placed the contents of the html folder in the C:\My Lineage 2 Server\gameserver\data\html\default folder, and the contents of the xml in the C:\My Lineage 2 Server\gameserver\data\multisell but other than that I dunno what to do next. There's been talk of loading something, but I need it REALLY dumbed down for me please.

[rychoo84]

on the basis of what you have written here I guess you forgot to load that NPC into database (look through that *.sql file inside the folder you attached). If I'm wrong and you have completed all the steps then just take your GM char ingame and type //spawn [id] where [id](without these brackets) is the ID of your desired NPC.

[Tresiem573]

Exactly, that's what I don't know how to do, I see people saying how to do it, but it tells me nothing about how to do it. But if it's how I think, and you right click on the database and click on "Execute SQL" then it always says "Loaded unseccessfully"

[rychoo84]

You probably got this error:

Code: Select all

 Column count doesn't match value count  

Your script needs to be simply updated due to that what's been said above(check the npc.sql or the npc table in DB which columns you have to add/delete to get it work)

This should work anyway:

Code: Select all

 INSERT INTO `npc` VALUES(90000,13114,'GM Shop',1,'Title',1,'LineageMonster4.Divine_Rogue',10.00,28.00,70,'male','L2Merchant',40,3862,1494,0.00,0.00,40,43,30,21,20,20,0,0,1303,471,607,382,253,0,333,0,0,NULL,0,60,60,0,0,'LAST_HIT','false'); 

[Tresiem573]

Yeah, I kinda started fooling around with that. All I did was put the files in where they should go, like above, then I went to custom_npc table in navicat, made a new row, typed in what it said in the sql file. Nothin' happened when I saved it no errors or anything, now the next test is to test it on my live server hosted by my friend.