Table Npc sql

This is not a Support area! Discuss about the Server here. Non-Server related discussion goes in Off-Topic Discussion.
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
User avatar
maneco2
Initiates
Initiates
Posts: 664
Joined: Sat Aug 24, 2013 7:10 am

Table Npc sql

Post by maneco2 »

English: I want to edit the sql of NPCs, but has no more npc ta table in navicat! how do? to deploy this...with the recent updates changed some things :D
--------
Portugues: Quero editar as sql dos npcs, mas nao tem mais ta tabela npc no navicat !!! como faço ?? para implantar isso...com os ultimos updates mudou algumas coisas :)


example:

Code: Select all

+++ dist/sql/game/npc.sql-(18853, 18853, "Glacier", 0, "", 0, "LineageNpcEV.freezing_stone", 26, 27, 85, "male", "L2Npc", 40, 4234.063127, 1846.8, 8.5, 3, 40, 43, 30, 21, 20, 20, 0, 0, 1188.87259, 361.78814, 811.84586, 264.74086, 253, 4, 333, 0, 0, 0, 1, 1, 0, 1),-(18854, 18854, "Archer's Breath", 0, "", 0, "LineageMonster5.ice_elemental_bomb", 20, 50, 85, "male", "L2Npc", 40, 57746.263171, 1846.8, 109.442979, 3, 40, 43, 30, 21, 20, 20, 0, 0, 5858.114, 578.86102, 4000.33245, 635.37806, 253, 4, 333, 0, 0, 0, 30, 80, 0, 1),-(18855, 18855, "Archery Knight", 0, "", 0, "LineageMonster5.ice_knight", 15, 31, 85, "male", "L2Npc", 40, 32596.260118, 1846.8, 109.442979, 3, 40, 43, 30, 21, 20, 20, 0, 0, 5858.114, 578.86102, 4000.33245, 635.37806, 253, 4, 333, 0, 0, 0, 20, 150, 0, 1),-(18856, 18856, "Archery Knight", 0, "", 0, "LineageMonster5.ice_knight", 15, 31, 85, "male", "L2Npc", 40, 800666.352021, 18468, 109.442979, 300, 40, 43, 30, 21, 20, 20, 0, 0, 16109.81349, 578.86102, 4000.33245, 635.37806, 253, 4, 333, 0, 0, 0, 20, 150, 0, 1),+(18853, 18853, "Glacier", 0, "", 0, "LineageNpcEV.freezing_stone", 26, 27, 85, "male", "L2Monster", 40, 8974.356864, 1607.4, 8.5, 3, 40, 43, 30, 21, 20, 20, 0, 0, 1250, 350, 900, 280, 253, 4, 333, 0, 0, 0, 25, 30, 0, 1),+(18854, 18854, "Archer's Breath", 0, "", 0, "LineageMonster5.ice_elemental_bomb", 20, 50, 85, "male", "L2Monster", 40, 8974.356864, 1607.4, 8.5, 3, 40, 43, 30, 21, 20, 20, 0, 0, 1200, 350, 600, 280, 253, 4, 333, 0, 0, 0, 25, 105, 0, 1),+(18855, 18855, "Archery Knight", 0, "", 0, "LineageMonster5.ice_knight", 15, 31, 85, "male", "L2Monster", 40, 8974.356864, 1607.4, 8.5, 3, 40, 43, 30, 21, 20, 20, 0, 0, 1200, 350, 600, 280, 253, 4, 333, 0, 0, 0, 25, 105, 0, 1),+(18856, 18856, "Archery Knight", 0, "", 0, "LineageMonster5.ice_knight", 15, 31, 85, "male", "L2Monster", 40, 8974.356864, 1607.4, 8.5, 3, 40, 43, 30, 21, 20, 20, 0, 0, 1050, 350, 600, 280, 253, 4, 333, 0, 0, 0, 25, 105, 0, 1),  
Cresceus
Posts: 238
Joined: Tue Jan 15, 2008 8:20 am
Location: Germany

Re: Table Npc sql

Post by Cresceus »

Take a look here: http://trac.l2jdp.com/browser/branches/ ... pcs/custom. Here is an example how to proceed with custom npcs now.

And enable here http://trac.l2jserver.com/browser/trunk ... properties the CustomNpcTable = False. Set it to True.

This should work for you.

Regards

P.S.: Ehh didn't you ask this before, maneco2? Here viewtopic.php?f=80&t=29310


P.P.S.: Maybe "CustomNpcTable" should be renamed? But this is really unimportant. (:
User avatar
maneco2
Initiates
Initiates
Posts: 664
Joined: Sat Aug 24, 2013 7:10 am

Re: Table Npc sql

Post by maneco2 »

Table not want! I want to change the status of the mobs
User avatar
maneco2
Initiates
Initiates
Posts: 664
Joined: Sat Aug 24, 2013 7:10 am

Re: Table Npc sql

Post by maneco2 »

put the custom Gm Shop, and not the to buy anything, has changed the html again??

Exemple:
MultisellData: can't find list id: 60 requested by player: admin, npcId:10002
MultisellData: can't find list id: 42 requested by player: admin, npcId:10002
MultisellData: can't find list id: 61 requested by player: admin, npcId:10002
...
Last edited by maneco2 on Fri Mar 07, 2014 9:16 am, edited 2 times in total.
Cresceus
Posts: 238
Joined: Tue Jan 15, 2008 8:20 am
Location: Germany

Re: Table Npc sql

Post by Cresceus »

Well, the retail NPCs are located one folder above /stats/npcs/custom...


file 18800-18900.xml

Code: Select all

    <npc id="18853" templateId="18853" clientName="Glacier" serverName="freezing_stone" level="85" type="warrior">        <agro_range>300</agro_range>        <clan_help_range>300</clan_help_range>        <collision>            <radius normal="26" special="26" />            <height normal="27" special="27" />        </collision>        <corpse_time>7</corpse_time>        <ex_crt_effect>1</ex_crt_effect>        <exp>19827360000</exp>        <speed>            <run ground="1" underWater="0" flying="0" />            <walk ground="1" underWater="0" flying="0" />        </speed>        <hit_time factor="0.46" skill_factor="-1" />        <base pAtk="1188.87259499001" randDmg="30" crit="4" atkSpd="253" reuseDelay="0" mAtk="811.84586495282" pDef="361.78814" mDef="264.74086" accuracy="5" evasion="0" />        <base_attack type="SWORD" range="40" />        <base_stats str="43" int="21" dex="30" wit="20" con="43" />        <base_damage_range unknown="0" direction="0" distance="80" width="120" />        <base_attribute>            <attack fire="0" water="0" wind="0" earth="0" holy="0" dark="0" />            <defend fire="20" water="20" wind="20" earth="20" holy="20" dark="20" unknown="0" />        </base_attribute>        <npc_ai>            <ai>freezing_stone</ai>            <ai_skill name="Buff" id="6301" level="1" /> <!-- Cold Mana's Fragment -->        </npc_ai>        <org hp="4234.06312688557" hp_regen="8.5" mp="1846.8" mp_regen="3" />        <race>CONSTRUCT</race>        <s_npc_prop_hp_rate>3</s_npc_prop_hp_rate>        <safe_height>100</safe_height>        <sex>MALE</sex>        <shield defence="0" rate="0" />        <skill_list>            <skill id="4416" level="2" /> <!-- Magic Creatures -->            <skill id="4408" level="11" /> <!-- HP Increase (3x) -->            <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="3" /> <!-- One-handed Sword -->            <skill id="4116" level="9" /> <!-- Resist M. Atk. -->            <skill id="4045" level="1" /> <!-- Resist Full Magic Attack -->        </skill_list>        <shots_count soul="0" spirit="0" />        <status canBeAttacked="true" canMove="true" eventFlag="false" hasSummoner="false" flying="false" passableDoor="false" showName="true" noSleepMode="false" targetable="true" undying="true" unique="false" unsowing="false" privateRespawnLog="true" />        <custom>            <type>L2Npc</type>            <ai minSkillChance="7" maxSkillChance="15" primarySkillId="0" minRangeSkill="0" minRangeChance="0" maxRangeSkill="0" maxRangeChance="0" spsChance="0" ssChance="0" isChaos="0" enemyClan="" enemyRange="0" dodge="0" aiType="fighter" />        </custom>    </npc>
Change this as you like. I have not tested it by myself yet, cause I didn't need it yet, but I guess it should work well if you copy the npcs you want to change and put them in the custom folder with the same retail ID of them. (Just like custom skills and custom items you know?)

So make a new xml in stats/npcs/custom and put within the monsters with the changes/stats as you wish.
Post Reply