Page 1 of 1
Where is NPC Table in Database Game Server
Posted: Sun Sep 21, 2014 8:28 am
by 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?
Re: Where is NPC Table in Database Game Server
Posted: Sun Sep 21, 2014 8:36 am
by 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.
Re: Where is NPC Table in Database Game Server
Posted: Sun Sep 21, 2014 8:38 am
by chuong2a
steinerrr wrote: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?
Re: Where is NPC Table in Database Game Server
Posted: Sun Sep 21, 2014 12:23 pm
by zhort
Go to data/stats/npcs/custom
Re: Where is NPC Table in Database Game Server
Posted: Sun Sep 21, 2014 12:26 pm
by volix
chuong2a wrote:steinerrr wrote: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/)
Re: Where is NPC Table in Database Game Server
Posted: Sun Sep 21, 2014 4:47 pm
by 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>
Re: Where is NPC Table in Database Game Server
Posted: Sun Sep 21, 2014 5:09 pm
by chuong2a
What version of L2j Server which engine still not changed?
Re: Where is NPC Table in Database Game Server
Posted: Sun Sep 21, 2014 7:14 pm
by Stalitsa
chuong2a wrote: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....
Re: Where is NPC Table in Database Game Server
Posted: Mon Nov 24, 2014 10:53 pm
by hylight
zhort wrote: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.
Re: Where is NPC Table in Database Game Server
Posted: Tue Nov 25, 2014 5:07 pm
by UnAfraid
Because all static data should be in XML.
Database is for dynamic stuff.