missing sql armor weapons etcitem

[kenfalcogt]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision 6276:
L2JDP Revision 10031:
hi all great job l2j for this highfive revision if any of you near die pls leave me your brain finally can use the client wint server.
just a question but file.sql like armor etcitem weapon they have changed name couse i cant find it.
sorry about english
thx for any help Always been very usefull.

[Cresceus]

Hi,
they can be found in /game/data/stats/
It is not necessary to keep them in the database.

[kenfalcogt]

thx a lot i was checking all file in data and i saw a lot of news too mutch for my brain at once lol i will need a lot of time now to lern it thx again for help as usual fast and usefull

[kenfalcogt]

why why this change im too old to learn and too Young to die:)
how can i create a custom item now??? could someone help me with sample so i can learn new sytem way.
be patient pls
i had read documentation.txt inside game/data/skill/ but im not so skilled to understand all and my english not so good .

[Cresceus]

You can copy an existing item or skill and put it into the custom folder, which must be in the /data/stat/items/ oder data/stats/skills/ folder.

If no custom folder exists, then just create one.

If you want to change an existing skill or item, you have to copy the xml, in which the skill/item is located, delete everything what you don't need and change the attributes or whatever you want to.
Here it's important to keep the original item_id or skill_id in the customs! On this way you make sure that the original skill/item will be "replaced" on server startup.

Secondly you have to switch custom load to True in the general.properties to make the custom folders be loaded on start up.


If you want to make a completly new item or skill (you can only display existing icons etc. I think you know what i mean), you just have to choose an not used id for the item or the skill. And you can use the attribute "displayId" to choose the icon/skill_animation/armor_texture or whatever of your choice.



One thing in addition: As far as I know you can not make a passive skill to an acitve one. Even if you make it custom.


And another thing: The icons of custom items are shown as an black box in multisells. I'm going to make bug report for that. Maybe someone is so kind to fix that.


I hope I didn't forgett anything and I could help you.

Regards


P.S.: The xml-file in the custom folder can be named whatever you like. You just have to make sure that the inner structure is the came as the other xml-files in the item or skill folder.

[kenfalcogt]

thx a lot you explain very well now im gonna try if im able to do it i hope so i will try till i will get thx again for help:):)

[kenfalcogt]

i made this change but give me this error
BuyListData: Could not parse 260785.xml file: schema_reference.4: lettura del do
cumento di schema "../xsd/buylist.xsd" non riuscita perchÚ 1) non Þ stato possib
ile trovare il documento; 2) non Þ stato possibile leggere il documento; 3) l'el
emento radice del documento non Þ <xsd:schema>.
STEP ONE modded file
<?xml version="1.0" encoding="UTF-8"?>
<list xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../xsd/items.xsd">
<item id="485" type="Armor" name="Tattoo of Power">
<set name="icon" val="icon.weapon_voodoo_doll_i00" />
<set name="default_action" val="equip" />
<set name="armor_type" val="light" />
<set name="bodypart" val="chest" />
<set name="immediate_effect" val="1" />
<set name="material" val="dyestuff" />
<set name="weight" val="4200" />
<set name="price" val="28400" />
<for>
<add order="0x10" stat="pDef" val="100" />
<add order="0x10" stat="mDef" val="100" />
<set order="0x08" stat="pAtk" val="100" />
<set order="0x08" stat="mAtk" val="100" />
<enchant order="0x0C" stat="pDef" val="0" />
<enchant order="0x0C" stat="mDef" val="0" />
</for>
</item>
<item id="486" type="Armor" name="Tattoo of Fire">
<set name="icon" val="icon.weapon_voodoo_doll_i00" />
<set name="default_action" val="equip" />
<set name="armor_type" val="light" />
<set name="bodypart" val="chest" />
<set name="immediate_effect" val="1" />
<set name="crystal_count" val="276" />
<set name="crystal_type" val="d" />
<set name="material" val="dyestuff" />
<set name="weight" val="4050" />
<set name="price" val="117000" />
<set name="enchant_enabled" val="1" />
<for>
<add order="0x10" stat="pDef" val="200" />
<add order="0x10" stat="mDef" val="200" />
<set order="0x08" stat="pAtk" val="200" />
<set order="0x08" stat="mAtk" val="200" />
<enchant order="0x0C" stat="pDef" val="0" />
<enchant order="0x0C" stat="mDef" val="0" />
</for>
</item>
<item id="489" type="Armor" name="Tattoo of Bravery">
<set name="icon" val="icon.weapon_voodoo_doll_i00" />
<set name="default_action" val="equip" />
<set name="armor_type" val="light" />
<set name="bodypart" val="chest" />
<set name="immediate_effect" val="1" />
<set name="crystal_count" val="428" />
<set name="crystal_type" val="c" />
<set name="material" val="dyestuff" />
<set name="weight" val="4100" />
<set name="price" val="825000" />
<set name="enchant_enabled" val="1" />
<for>
<add order="0x10" stat="pDef" val="300" />
<add order="0x10" stat="mDef" val="300" />
<set order="0x08" stat="pAtk" val="300" />
<set order="0x08" stat="mAtk" val="300" />
<enchant order="0x0C" stat="pDef" val="0" />
<enchant order="0x0C" stat="mDef" val="0" />
</for>
</item>
<item id="490" type="Armor" name="Tattoo of Blood">
<set name="icon" val="icon.weapon_voodoo_doll_i00" />
<set name="default_action" val="equip" />
<set name="armor_type" val="light" />
<set name="bodypart" val="chest" />
<set name="immediate_effect" val="1" />
<set name="crystal_count" val="277" />
<set name="crystal_type" val="a" />
<set name="material" val="dyestuff" />
<set name="weight" val="3800" />
<set name="price" val="2671000" />
<set name="enchant_enabled" val="1" />
<for>
<add order="0x10" stat="pDef" val="500" />
<add order="0x10" stat="mDef" val="500" />
<set order="0x08" stat="pAtk" val="500" />
<set order="0x08" stat="mAtk" val="500" />
<enchant order="0x0C" stat="pDef" val="0" />
<enchant order="0x0C" stat="mDef" val="0" />
</for>
</item>
<item id="494" type="Armor" name="Tattoo of Doom">
<set name="icon" val="icon.weapon_voodoo_doll_i00" />
<set name="default_action" val="equip" />
<set name="armor_type" val="light" />
<set name="bodypart" val="chest" />
<set name="immediate_effect" val="1" />
<set name="crystal_count" val="321" />
<set name="crystal_type" val="b" />
<set name="material" val="dyestuff" />
<set name="weight" val="4100" />
<set name="price" val="1857000" />
<set name="enchant_enabled" val="1" />
<for>
<add order="0x10" stat="pDef" val="400" />
<add order="0x10" stat="mDef" val="400" />
<set order="0x08" stat="pAtk" val="400" />
<set order="0x08" stat="mAtk" val="400" />
<enchant order="0x0C" stat="pDef" val="0" />
<enchant order="0x0C" stat="mDef" val="0" />
</for>
</item>
</list>
STEP 2
<?xml version="1.0" encoding="UTF-8"?>
<list xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/buylist.xsd">
<npcs>
<npc>260785</npc> <!-- Biggerstaff -->
</npcs>
<item id="485" /> <!-- Pledge Shield -->
<item id="486" /> <!-- Food for Wyvern -->
<item id="489" /> <!-- Pledge Shield --> <!-- Scroll of Escape: Clan Hall -->
<item id="490" /> <!-- Pledge Shield -->
<item id="494" /> <!-- Pledge Shield -->
</list>
STEP3
made npc 260785 and 260785 html
RESULT
BuyListData: Could not parse 260785.xml file: schema_reference.4: lettura del do
cumento di schema "../xsd/buylist.xsd" non riuscita perchÚ 1) non Þ stato possib
ile trovare il documento; 2) non Þ stato possibile leggere il documento; 3) l'el
emento radice del documento non Þ <xsd:schema>.

pls help me

[Hyrelius]

Please use

Code: Select all

[code=xml]...

[/code] tags to format the source code. It's unreadable the way it is now.
According to what you wrote it basically says that the changes you made do not match the schema-file "buylist.xsd", which defines what xml-elements and attributes are allowed and where they may be placed. Perhaps you have a spelling error or a missing bracket somewhere.

Regarding the items: you cannot create an entirely new item (say with an entirely new name) without having to modify the client (which may not be discussed on this forum).

I think the problems regarding skill-related changes come from the fact, that skills are also defined on the client-side within the files skillgrp.dat and skillname-e.dat.

Regarding the black boxes for skills: I also have discovered, that this happens when you have customized skill with a displayId. The buff either does not appear in the buff bar at all - or a black box appears instead. My guess is that the displayId is not used in this case, yet it cannot find a suitable 16x16 icon for the skill, because it is not defined in the skillgrp.dat. I haven't found a fix for this matter.

[kenfalcogt]

thx for reply im not gonna change client in any way and you got it the problem couse other thing i think i made it well

[kazuhikosama]

hi there im kinda new on h5 l2j server and i had the same tought about missing tables armor, weapons and etcitem on the db, i was just wondering how to duplicate an item, i mean the same appearance but with differents stats, description and name and ofc different id, i want to know how to do this, do i need to create a new xml file and copy entirely the item i wish to duplicate and just change the stats, but what about the texture? will it show when i load the server or i need to do something else?

[Cresceus]

[xml]<?xml version="1.0" encoding="UTF-8"?><list xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../xsd/items.xsd">     <item id="50300" type="Armor" name="Knight's Cloak">        <set name="displayId" val="13687" />        <set name="icon" val="icon.vesper_cloack_i00" />        <set name="default_action" val="EQUIP" />        <set name="bodypart" val="back" />        <set name="immediate_effect" val="true" />        <set name="material" val="CLOTH" />        <set name="weight" val="220" />        <set name="price" val="28671000" />        <set name="is_tradable" val="false" />        <set name="is_dropable" val="false" />        <set name="is_sellable" val="false" />    </item></list>[/xml]

This is how an item duplicate may look like.
You can change any stats, but you cannot change the desciption or anything what is shown in the client. For this you need to modify the client, what is not allowed to be discussed on this forum.