[GUIDE]Make Xml,SQL,Dat Files For Your Server(WOrk With ALL Packs)

Vkouk · July 7, 2009

Hello From me..I make this guide to learn to someone when make his new custom item how to put it into his server.So let's start.1st you need this http://rapidshare.com/files/253118248/Logiciels_L2.rar..But i am going to see now how to put it into at Gracia Final Client..Also you have to do the same for all clients and packs... The weapon,armor sql you take it from your db..And weapongrp,itemname,armorgrp dat files you find it from your FileEdit..First find ID of item that you want..First you open weapon.sql ..For example:

INSERT INTO `weapon` VALUES ('6592', 'Angel Slayer - Haste', 'rhand', 'true', '950', '1', '1', 'adamantaite', 's', '246', '5', 'dagger', '12', '-3.00000', '0', '0', '0', '433', '0', '132', '-1', '-1', '48800000', '2052', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3564-1;');

So we change id from 6592,for example to 60000 whatever id we want..And name we change it and put the name that we want..Close it and Save it..SQL is ready now..Now lets check dat files..Itemname-e:

For dat files we take the same weapon.

6592	Angel Slayer	Haste	<Soul Crystal Enhancement>\n Increases Atk. Spd. by about 7%. Increases damage inflicted during PvP.	-1	0	0			0	0												0		1

Change again ID and the Name..Close it and after save it..Now check and weapongrp.

0	6592	1	1	7	10	0	LineageWeapons.angel_slayer_m00_wp			Name_Of_UTX				0	0	0	0	0	1	0	0	icon.weapon_angel_slayer_i01					-1	950	47	1	0	0		1		27	1	0		1	LineageWeapons.angel_slayer_m00_wp	1	1	Name_Of_UTX 4	"ItemSound.dagger_6|ItemSound.sword_small_2|ItemSound.sword_mid_2|ItemSound.public_sword_shing_7"	ItemSound.itemdrop_dagger	ItemSound.itemequip_dagger		5	246	132	3	5	12	-3	0	0	0	433	0	1	1	1000	0	-1	0	LineageEffect.c_u004		LineageWeapons.rangesample		0	0	0	"0,6"	"0,1"	0	0	0	0	0	"1,1"	"0,7"	"0,7"	7	0	0	0	0	0	0	0	0	4	-1	-1	-1

Now we change again Id as the other..And also change this Lines

LineageWeaponsTex.forgotten_blade_t00_wp

with the name that we choose to make our UTX.So we can see the weapon.Close it and save it..

Now you have your new Custom Weapons for your Server.

Lets see now for Armor..It isn't sometink different..So let's see.

1st you have to find the original id of your armor..Px i select a part of draconic armor.

INSERT INTO `armor` VALUES ('6379', 'Draconic Leather Armor', 'fullarmor', 'true', 'light', '4950', 'leather', 's', '0', '-1', '-1', '249', '0', '0', '17400000', '748', 'true', 'true', 'true', 'true', '0-0', '0-0;');

Nothink special..Just change again ID and Name..Close save and ready..;)..

After lets see for itemname-e dat.:

6379	Draconic Leather Armor		Full body armor.	-1	4	4	"6379|6382,11486|6380,11483|6381,11484"	"DEX+1, STR+1, CON-2, Atk. Spd./P. Atk, +4%, Max MP 289, and weight limit +5759."	0	0												6	"When all set items are enchanted by 6 or higher, M. Def. and Evasion will increase."	1

Again the same change ID and name.So let's see and for armorgrp dat.:

1	6379	0	3	4	3	0	dropitems.drop_MFighter_m011_t89_u_m00			mfighter.mfighter_m011_t89_u				0	0	0	0	0	1	0	0	icon.armor_t89_ul_i00	icon.armor_t89_u_i00	icon.armor_t89_l_i00			4294967295	4950	19	1	0	0		1		8	2	"Fighter.MFighter_m011_u|Fighter.MFighter_m011_l"	2	"mfighter.mfighter_m011_t89_u|MFighter.MFighter_m011_t89_l"	2	"|"	"00-FF|00-FF"	2	"|"		2	"Fighter.FFighter_m011_u|Fighter.FFighter_m011_l"	2	"FFighter.FFighter_m011_t89_u|FFighter.FFighter_m011_t89_l"	2	"|"	"00-FF|00-FF"	2	"|"		2	"DarkElf.MDarkElf_m001_u|DarkElf.MDarkElf_m007_l"	2	"MDarkElf.MDarkElf_m001_t89_u|MDarkElf.MDarkElf_m007_t89_l"	2	"|"	"00-FF|00-FF"	2	"|"		2	"DarkElf.FDarkElf_m007_u|DarkElf.FDarkElf_m008_l"	2	"FDarkElf.FDarkElf_m007_t89_u|FDarkElf.FDarkElf_m008_t89_l"	2	"|"	"00-FF|00-FF"	2	"|"		2	"Dwarf.MDwarf_m004_u|Dwarf.MDwarf_m008_l"	2	"MDwarf.MDwarf_m004_t89_u|MDwarf.MDwarf_m008_t89_l"	2	"|"	"00-FF|00-FF"	2	"|"		2	"Dwarf.FDwarf_m004_u|Dwarf.FDwarf_m008_l"	2	"FDwarf.FDwarf_m004_t89_u|FDwarf.FDwarf_m008_t89_l"	2	"|"	"00-FF|00-FF"	2	"|"		2	"Elf.MElf_m008_u|Elf.MElf_m007_l"	2	"MElf.MElf_m008_t89_u|MElf.MElf_m007_t89_l"	2	"|"	"00-FF|00-FF"	2	"|"		2	"Elf.FElf_m008_u|Elf.FElf_m004_l"	2	"FElf.FElf_m008_t89_u|FElf.FElf_m004_t89_l"	2	"|"	"00-FF|00-FF"	2	"|"		2	"Magic.MMagic_m011_u|Magic.MMagic_m011_l"	2	"MMagic.MMagic_m011_t89_u|MMagic.MMagic_m011_t89_l"	2	"|"	"00-FF|00-FF"	2	"|"		2	"Magic.FMagic_m011_u|Magic.FMagic_m011_l"	2	"FMagic.FMagic_m011_t89_u|FMagic.FMagic_m011_t89_l"	2	"|"	"00-FF|00-FF"	2	"|"		2	"Orc.MOrc_m007_u|Orc.MOrc_m006_l"	2	"MOrc.MOrc_m007_t89_u|MOrc.MOrc_m006_t89_l"	2	"|"	"00-FF|00-FF"	2	"|"		2	"Orc.FOrc_m007_u|Orc.FOrc_m006_l"	2	"FOrc.FOrc_m007_t89_u|FOrc.FOrc_m006_t89_l"	2	"|"	"00-FF|00-FF"	2	"|"		2	"Shaman.MShaman_m007_u|Shaman.MShaman_m007_l"	2	"MShaman.MShaman_m007_t89_u|MShaman.MShaman_m007_t89_l"	2	"|"	"00-FF|00-FF"	2	"|"		2	"Shaman.FShaman_m007_u|Shaman.FShaman_m007_l"	2	"FShaman.FShaman_m007_t89_u|FShaman.FShaman_m007_t89_l"	2	"|"	"00-FF|00-FF"	2	"|"		2	"Kamael.mkamael_m009_u|Kamael.mkamael_m009_l"	3	"mkamael.mkamael_m009_t89_u|mkamael.mkamael_m009_t89_l|mkamael.mkamael_m009_t89_ut"	2	"Kamael.Mkamael_m000_w_ad00|Kamael.Mkamael_m009_l_ad00"	"77-5F|6C-5F"	2	"Mkamael.Mkamael_m000_t00_w|mkamael.mkamael_m009_t89_ut"		2	"Kamael.fkamael_m008_u|Kamael.fkamael_m008_l"	3	"fkamael.fkamael_m008_t89_u|fkamael.fkamael_m008_t89_l|fkamael.fkamael_m008_t89_ut"	2	"Kamael.Fkamael_m000_w_ad00|Kamael.Fkamael_m008_l_ad00"	"77-5F|6C-5F"	2	"Fkamael.Fkamael_m000_t00_w|fkamael.fkamael_m008_t89_ut"		1		1		0			0			LineageEffect.p_u002_a	4	"ItemSound.shield_bone_1|ItemSound.armor_leather_2|ItemSound.armor_leather_3|ItemSound.armor_leather_8"	ItemSound.itemdrop_armor_leather	ItemSound.itemequip_armor_leather	1	0	1	5	0	249	0	0	0

Also you have to change some lines with the name that you used at Unreal..

Lets make and our xml.Take a xml and delete all other thinks that had inside..Go to c:/l2-server/gameserver/data/stats/weapon

and find again ID of weapon that you want px.

<?xml version="1.0" encoding="UTF-8"?>
<list>
<item id="6592" name="Angel Slayer - Haste">
  <for>
    <set val="246" order="0x08" stat="pAtk"/>
    <set val="132" order="0x08" stat="mAtk"/>
    <set val="12" order="0x08" stat="rCrit"/>
    <add val="-3" order="0x10" stat="accCombat"/>
    <set val="433" order="0x08" stat="pAtkSpd"/>
    <enchant val="0" order="0x0C" stat="pAtk"/>
    <enchant val="0" order="0x0C" stat="mAtk"/>
  </for>
</item>
</list>

Now change again ID and name with the same that you choose before..

So let's make now and our xml for armor..

Find again ID.

<?xml version="1.0" encoding="UTF-8"?>
<list>
<item id="6379" name="Draconic Leather Armor"> 
  <for> 
<add val="249" order="0x10" stat="pDef"/>
    <enchant val="0" order="0x0C" stat="pDef"/>
  </for> 
</item>
</list>

Change again ID and the Name close it and save it..

This Guide Has Finished..I hope you like it..

Ps:You need a clear Txt,a clear sql file and a clear xml...

Credits to Legollas®.

CriticalError · July 7, 2009

god nice job mate i think is a realy nice guide thanks a lot and keep working :)

Cook · July 7, 2009

DAMN my Ideas Are awesome!

NICE guide!

but I must make a private server cause I deleted my old one!

oh and does it work on Gracia Final?

Oh And I also need some help seting up my server!

I'm not going to put it online!

Upload on my PC only!Can someone help me?

THNX!

Vkouk · July 7, 2009

DAMN my Ideas Are awesome!

NICE guide!

but I must make a private server cause I deleted my old one!

oh and does it work on Gracia Final?

This is for all packs and for all clients man..

Cook · July 7, 2009

Ok but can someone help me do my PC server?

So I can make custom things!?

PLZ :) :) :) :) :) :) :) :) :) :) :) :) :) :) PLZ

Morian · July 7, 2009

Awesome guide Legollas really good, step by step! Keep up man!

tiranous · July 7, 2009

yeah you safe my life with this +1 from me for your work .... Awesome Guide

Vkouk · July 7, 2009

yeah you same my life with this +1 from me for your work .... anwoeme Guide

Thanks a lot man..And thanks all of you guys for your good words.

neptun444 · July 7, 2009

awesome guide but if u can make a bit space i mean make the post in parts its kinda confusing :P

Vkouk · July 7, 2009

awesome guide but if u can make a bit space i mean make the post in parts its kinda confusing :P

You mean to put some spaces?

Cook · July 7, 2009

OK seems I've got a prob!

I changed everything, no errors!

in database I changed ID and name of dragonic Bow focus.

changed ID to 60000 and name to IceBow.

Then went to itemname-e.dat.changed ID to 60000 and name to IceBow.

Then went to weapongrp.dat. changed ID to 60000 and changed where ever there was LineageWeaponsTex.draconic_bow_t00_wp to IceBow.IceBow.

I also put the IceBow.utx in systextures!

I log in game...no error.

I try to spawn item.

and says The item does not exist!

I'm tired of having problems when there shouldn't be any!

If someone can help me plz!

Vkouk · July 8, 2009

OK seems I've got a prob!

I changed everything, no errors!

in database I changed ID and name of dragonic Bow focus.

changed ID to 60000 and name to IceBow.

Then went to itemname-e.dat.changed ID to 60000 and name to IceBow.

Then went to weapongrp.dat. changed ID to 60000 and changed where ever there was LineageWeaponsTex.draconic_bow_t00_wp to IceBow.IceBow.

I also put the IceBow.utx in systextures!

I log in game...no error.

I try to spawn item.

and says The item does not exist!

I'm tired of having problems when there shouldn't be any!

If someone can help me plz!

Dat files you did it succesfully?

Cook · July 8, 2009

Yeah saved it as 413 and had no errors!

I can open them again with file edit with no problem!

I go to the line and have it a it is!

for instance 60000 IceBow etc. etc. etc.

Everything is correct!

But when I log in Game and go to item spawn and use ID 60000 and hit spawn...

I don't get an error but I see on system window Item Does Not Exist

milosina · July 8, 2009

good job legollas :)

Vkouk · July 8, 2009

Yeah saved it as 413 and had no errors!

I can open them again with file edit with no problem!

I go to the line and have it a it is!

for instance 60000 IceBow etc. etc. etc.

Everything is correct!

But when I log in Game and go to item spawn and use ID 60000 and hit spawn...

I don't get an error but I see on system window Item Does Not Exist

Change id and try again..Xml files did you make it?

[GUIDE]Make Xml,SQL,Dat Files For Your Server(WOrk With ALL Packs)

Recommended Posts

Vkouk

CriticalError

Cook

Vkouk

Cook

Morian

tiranous

Vkouk

neptun444

Vkouk

Cook

Vkouk

Cook

milosina

Vkouk

Join the conversation

Posts

Topics

Browse

Activity

Store