Where is NPC Table in Database Game Server

[chuong2a]

L2J Server 6636
L2J DataPack 10437

I can't find NPC Table in Database Game Server in this version.
I have old code of GMShop which add into npc table
/* GM Shop */
Insert into `npc` Values (
'10002', '32237', 'Nicole', '1', 'GM Shop',
'1', 'LineageNPC2.k_hero_bowgun', '9.00', '23.00', '70',
'female', 'L2Merchant', '40', '2444', '1345',
'7.5', '2.7', '40', '43', '30',
'21', '20', '20', '0', '0',
'688', '295', '470', '216', '253',
'4', '333', '0', '0', '0',
'0', '0', '0', '1' );
How to add him?

[steinerrr]

As far as i understand the engine was changed. NPCs and buylists are now stored and can be changed in data/ files rather than as tables.

[chuong2a]

As far as i understand the engine was changed. NPCs and buylists are now stored and can be changed in data/ files rather than as tables.

Could you please give me details?
How to add NPC GMShop?

[zhort]

Go to data/stats/npcs/custom

[volix]

As far as i understand the engine was changed. NPCs and buylists are now stored and can be changed in data/ files rather than as tables.

Could you please give me details?
How to add NPC GMShop?

stable = mysql -> npc or custom_npc table
beta = datapack -> game/data/stats/npcs/ id-range.xml or /custom/id-range.xml (multisell in data/multisell/)

[chuong2a]

I have created an NPC (copy from existing NPC) and put it into folder J:\L2J Server 6636\game\data\stats\npcs.
I enter game and spawn it, it display system message Create Photo Snow at (location) but this NPC is not displayed, I can't target him.

Code: Select all

         <npc id="40002" level="55" type="L2Teleporter" name="Photo Snow" title="Photographer">        <!-- TODO: Must be confirmed -->        <race>  ELF  </race>        <sex>FEMALE</sex>        <stats str="40" int="21" dex="30" wit="20" con="43" men="25">            <vitals hp="1673.05473" hpRegen="6.5" mp="889.8" mpRegen="2.4" />            <attack physical="388.11142" magical="265.02979" attackSpeed="253" range="40" />            <defence physical="223.6362" magical="163.64727" />            <attribute>                <defence fire="20" water="20" wind="20" earth="20" holy="20" dark="20" />            </attribute>            <speed>                <walk ground="4" />                <run ground="180" />            </speed>        </stats>        <skill_list>            <skill id="4408" level="1" /> <!--HP Increase (1x) -->            <skill id="4409" level="1" /> <!--MP Increase (1x) -->            <skill id="4410" level="11" /> <!--Average P. Atk. -->            <skill id="4411" level="11" /> <!--Average M. Atk. -->            <skill id="4412" level="11" /> <!--Average P. Def. -->            <skill id="4413" level="11" /> <!--Average M. Def. -->            <skill id="4414" level="2" /> <!--Standard Type -->            <skill id="4415" level="1" /> <!--Bare Hands -->            <skill id="4416" level="7" /> <!--Spirits -->        </skill_list>        <collision>            <radius normal="9" />            <height normal="16.3" />        </collision>    </npc></list> 

[chuong2a]

What version of L2j Server which engine still not changed?

[Stalitsa]

L2J Server 6636
L2J DataPack 10437

I can't find NPC Table in Database Game Server in this version.
I have old code of GMShop which add into npc table
/* GM Shop */
Insert into `npc` Values (
'10002', '32237', 'Nicole', '1', 'GM Shop',
'1', 'LineageNPC2.k_hero_bowgun', '9.00', '23.00', '70',
'female', 'L2Merchant', '40', '2444', '1345',
'7.5', '2.7', '40', '43', '30',
'21', '20', '20', '0', '0',
'688', '295', '470', '216', '253',
'4', '333', '0', '0', '0',
'0', '0', '0', '1' );
How to add him?

Go to game/data/stats/npcs/custom/custom.xml

and add this:

Code: Select all

 <npc id="10002" displayId="32237" name="Nicole" usingServerSideName="true" title="GM Shop" usingServerSideTitle="true" type="'L2Merchant">        <collision>            <radius normal="9" />            <height normal="23" />        </collision></npc> 

and only if you use Beta....

[hylight]

Go to data/stats/npcs/custom

How do I run this former sql-script on xml files????

update npc set aggro = aggro + 100 where type like '%Monster' or type like '%Minion' or type like '%Boss';


sql is so much simpler and more powerful than xml files, why was this changed?

It might be slower to read, but this is done only once on server start.

[UnAfraid]

Because all static data should be in XML.
Database is for dynamic stuff.