Help Add Npc From Sql To Xml

[Kouma]

Hello everyone!

 

I wanna ask you some help about the new way to add npc in ur server!

Can u tell me if this one is correct because i search in forum and i dont find a specific way!

 

Npc sql: INSERT INTO `npc` VALUES ('36600', '36397', 'Augument Manager', '1', '[server Name]', '1', 'Npc.a_smith_MDwarf', '22.00', '26.00', '80', 'male', 'L2Trainer', '40', '540452.000000000000000', '5243.000000000000000', null, null, '40', '43', '30', '21', '20', '20', '0', '0', '453.00000', '638.00000', '838.00000', '8383.00000', '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0'); 

 

Default npc xml:

</npc>

<npc id="900100" displayId="20432" level="1" name="Elpy" type="L2EventMonster">

<stats str="40" int="21" dex="30" wit="20" con="43" men="20">

<vitals hp="40" hpRegen="3" mp="36" mpRegen="1" />

<attack physical="8" magical="7" />

<defence physical="25" magical="40" />

</stats>

<status undying="false" />

<collision>

<radius normal="5" />

<height normal="4.5" />

</collision>

</npc>

 

Default custom npc xml: 

<npc id="50007" displayId="31324" name="Andromeda" usingServerSideName="true" title="Wedding Manager" usingServerSideTitle="true" type="L2Npc">

<collision>

<radius normal="8" />

<height normal="23" />

</collision>

</npc>

 

[SweeTs]

Follow the structure your pack is using.

[Kouma]

There is no way to convert sql to xml?

[ton3]

its not that hard to change sql for xml, just  use your default custom npc template and change whatever u want for a new npc.

 

<npc id="36600" displayId="36397" name="Augument Manager" usingServerSideName="true" title="[Server Name]" usingServerSideTitle="true" type="L2Npc">
<collision>
<radius normal="8" /> (just change this to adjust your npc)
<height normal="25" /> (just change this to adjust your npc)
</collision>
</npc>

Edited August 28, 2015 by ton3