Problem making a GM shop

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
ChatX
Posts: 2
Joined: Thu Jun 19, 2014 2:52 am

Problem making a GM shop

Post by ChatX »

Hello,
So I just recently made my own server to play around with.
with the datapack 10359 and server 6564
Im trying to add a GM shop and also a custom armor set which I found using google. Both the armor set and the GM shop supposedly work with freya highfive which is the same as the server I have.
The problem Im facing is when Im trying to execute the sql files which are included with the GM shop and the custom armor. Whenever I try executing it into l2jgs, I get an error similar to this

"[Err] 1146 - Table 'l2jgs.custom_npcaidata' doesn't exist
[Err] INSERT INTO `custom_npcaidata` VALUES ('10002', '7', '15', '0', '1000', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, '300', null, '0', '0', 'fighter');
[Msg] Finished - Unsuccessfully
--------------------------------------------------
"
I have tried more than one GM shop, and many different custom armors but they all give me similar errors.
Does anyone know what I can do to fix it, or can give me a GM shop that will work for my revision? :)
Please be as detailed as possible, this is my first time creating a server.
Thanks!
User avatar
UnAfraid
L2j Veteran
L2j Veteran
Posts: 4199
Joined: Mon Jul 23, 2007 4:25 pm
Location: Bulgaria
Contact:

Re: Problem making a GM shop

Post by UnAfraid »

Those sql tables was moved to the Datapack.
for npcs check data/stats/npcs/
for items data/stats/items
for armorsets data/stats/armorsets
Image
ChatX
Posts: 2
Joined: Thu Jun 19, 2014 2:52 am

Re: Problem making a GM shop

Post by ChatX »

Okay so for example how would I add this buffer "viewtopic.php?f=4&t=26995" to my client if I can't execute the SQL? What would I have to do to make it work after copying the files included into my game server?
Sorry if I'm asking an obvious question but it's my first time and I'll probably learn after doing one example.
So thanks for the cooperation!
User avatar
UnAfraid
L2j Veteran
L2j Veteran
Posts: 4199
Joined: Mon Jul 23, 2007 4:25 pm
Location: Bulgaria
Contact:

Re: Problem making a GM shop

Post by UnAfraid »

You must convert the sql to xml.
Check how other items or npcs are made and follow them as an example.
Image
Post Reply