Adding a piece of armor to the server.

[Diana]

Server Rev: 6564
Datapack Rev: 10359
Hello!
I'm wanting to add this piece of armor to my server which I found online. In the folder which I downloaded there were things to be replaced in the Data/Stats/items and Data/Stats/Skills. Which I did replace. There was also and sql which had to be executed and it alters data in armorsets table, but! I'm running an l2jgs database which does not have that table named "Armorsets" anymore. I was told that it was moved to armorsets. I tried replacing the file in armorsets folder instead of items but I still get the same error "The item does not exist".
So what do I need to exactly change in the server files or database to make it appear?
Thanks for the assistance!

[UnAfraid]

armorsets table is moved to data/stats/armorsets as xmls.

[Diana]

armorsets table is moved to data/stats/armorsets as xmls.

Okay here are the things I tried because I can't understand what to do with the armor sets folder.

-there are two three files for the armor piece which I'm trying to add. 1)armor.xml 2) armor ability.xml and 3) armor.sql (obviously can't be executed).

1) as the Read Me said, I tried executing the SQL file first but that failed because Armors table is no longer in the database so there I IGNORED the SQL file (which could be what I'm doing wrong but I don't know where else to enter the information inside it to).

2) I then copied the armor.xml to the armorsets folder inside the data/stats and the ability.xml to the skills folder in data/stats (it gives me an error when running the game server about the ability file so I'm thinking it needs to go somewhere else)

3) since I couldn't spawn the armor piece in game, I tried moving the armor.xml to the items folder in data/stats but the item still doesn't exist.

So I am thinking that I need to input the SQL information into something in the armorsets folder and if so then where and in what format should it be entered? And where do I need to exactly place the armor.xml and ability.xml or should I just copy the content they carry and put it the elegia armor instead?
Please clarify, that would be really appreciated.
Thanks in advance!

[UnAfraid]

You must convert the SQLto XML dont try to execute the SQL because you dont need it anymore since this information is readed from the the xmls.

[Diana]

Okay and how do I do that?
Also what should I do with armor.xml and armor_ability.xml just leave them in the armorsets folder?

let me also include everything in the package so you can have a more detailed view.

http://pastebin.com/KagXnXV7 <-- The SQL
http://pastebin.com/vXJ6VLeL <-- Armor_Ability.xml
http://pastebin.com/WptJnX5u <-- Armor.xml

Now if you could tell me what to do with each one of these that would be much appreciated because I'm definitely lost here. I also have not the slightest idea how to change SQL to XML, because this is the first time I ever try to make a server.
Thank you very much for the assistance.

[UnAfraid]

Items are fine but skills aint.

Replace

Code: Select all

<set name="operateType" val="OP_PASSIVE" />

with

Code: Select all

<set name="operateType" val="P />

Remove

Code: Select all

<set name="skillType" val="BUFF" />

Replace

Code: Select all

<set name="target" val="TARGET_SELF" />

with

Code: Select all

<set name="target" val="SELF" />

[Diana]

Items are fine but skills aint.

Replace

Code: Select all

<set name="operateType" val="OP_PASSIVE" />

with

Code: Select all

<set name="operateType" val="P />

Remove

Code: Select all

<set name="skillType" val="BUFF" />

Replace

Code: Select all

<set name="target" val="TARGET_SELF" />

with

Code: Select all

<set name="target" val="SELF" />

I get these errors when I run game server. Armor_Ability is places in stats/skills and armor_set is in stats/items.

Jun 24, 2014 12:30:44 PM com.l2jserver.gameserver.engines.DocumentBase parse
SEVERE: Error loading file C:\Users\Dominator\Desktop\Server\game\data\stats\skills\Olympus_Ability.xml
org.xml.sax.SAXParseException; systemId: file:/C:/Users/Dominator/Desktop/Server/game/data/stats/skills/Olympus_Ability.xml; lineNumber: 37; columnNumber: 4; The value of attribute "val" associated with an element type "null" must not contain the '<' character.
at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown Source)
at javax.xml.parsers.DocumentBuilder.parse(Unknown Source)
at com.l2jserver.gameserver.engines.DocumentBase.parse(DocumentBase.java:151)
at com.l2jserver.gameserver.engines.DocumentEngine.loadSkills(DocumentEngine.java:88)
at com.l2jserver.gameserver.engines.DocumentEngine.loadAllSkills(DocumentEngine.java:97)
at com.l2jserver.gameserver.datatables.SkillTable.load(SkillTable.java:60)
at com.l2jserver.gameserver.datatables.SkillTable.<init>(SkillTable.java:47)
at com.l2jserver.gameserver.datatables.SkillTable$SingletonHolder.<clinit>(SkillTable.java:222)
at com.l2jserver.gameserver.datatables.SkillTable.getInstance(SkillTable.java:217)
at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:216)
at com.l2jserver.gameserver.GameServer.main(GameServer.java:470)

[UnAfraid]

file:/C:/Users/Dominator/Desktop/Server/game/data/stats/skills/Olympus_Ability.xml;
lineNumber: 37;
columnNumber : 4;
The value of attribute "val" associated with an element type "null" must not contain the '<' character.

[Diana]

Ughh I can't find the error >.<, there's nothing at line 37
http://pastebin.com/EKy7fCv3

[Diana]

Ughh I can't find the error >.<, there's nothing at line 37
http://pastebin.com/EKy7fCv3

Nevermind! everything's fixed and I got it working. Thanks very much for your time

[UnAfraid]

<set name="operateType" val="P />
You are missing one " after the P e.g. "P"

[Diana]

<set name="operateType" val="P />
You are missing one " after the P e.g. "P"

Yeah I noticed