Page 1 of 1

Problem making a GM shop

Posted: Thu Jun 19, 2014 3:42 am
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!

Re: Problem making a GM shop

Posted: Thu Jun 19, 2014 8:40 am
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

Re: Problem making a GM shop

Posted: Thu Jun 19, 2014 5:34 pm
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!

Re: Problem making a GM shop

Posted: Fri Jun 20, 2014 9:48 am
by UnAfraid
You must convert the sql to xml.
Check how other items or npcs are made and follow them as an example.