|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc. |
01-24-2011, 05:33 PM
|
Sarnak
|
|
Join Date: Oct 2006
Posts: 29
|
|
adding merchant via peq DB editor
hello,
i'm having some trouble adding a NPC merchant into the nexus.. i have gotten it to spawn where i'd like him but when its right clicked it acts like a normal non interactive npc.. i have made a merchantlist the npc just doesn't seem to use it. any help here?
|
01-24-2011, 05:41 PM
|
Developer
|
|
Join Date: Feb 2004
Location: UK
Posts: 1,540
|
|
What Class did you make the merchant ? I think Class 41 = Merchant.
|
|
|
|
01-24-2011, 05:41 PM
|
Sarnak
|
|
Join Date: Oct 2006
Posts: 29
|
|
hello,
i'm having some trouble adding a NPC merchant into the nexus.. i have gotten it to spawn where i'd like him but when its right clicked it acts like a normal non interactive npc.. i have made a merchantlist the npc just doesn't seem to use it. any help here?
Quote:
INSERT INTO npc_types (id, name, lastname, level, race, class, bodytype, hp, gender, texture, helmtexture, size, hp_regen_rate, mana_regen_rate, loottable_id, merchant_id, npc_spells_id, npc_faction_id, adventure_template_id, trap_template, mindmg, maxdmg, npcspecialattks, aggroradius, face, luclin_hairstyle, luclin_haircolor, luclin_eyecolor, luclin_eyecolor2, luclin_beardcolor, luclin_beard, drakkin_heritage, drakkin_tattoo, drakkin_details, armortint_id, armortint_red, armortint_green, armortint_blue, d_meele_texture1, d_meele_texture2, prim_melee_type, sec_melee_type, runspeed, MR, CR, DR, FR, PR, Corrup, see_invis, see_invis_undead, qglobal, AC, npc_aggro, spawn_limit, attack_speed, findable, STR, STA, DEX, AGI, _INT, WIS, CHA, see_hide, see_improved_hide, trackable, isbot, exclude, ATK, Accuracy, slow_mitigation, version, maxlevel, scalerate, private_corpse, unique_spawn_by_name) VALUES ('152025', 'locknarg', 'plate vendor', '80', '10', '1', '1', '100000000', '0', '0', '0', '10', '0', '0', '0', '346866', '0', '0', '0', '0', '3', '14', 'UMCNIDABfWOHL', '70', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '28', '28', '1.25', '3', '3', '3', '3', '3', '3', '0', '0', '1', '1181', '0', '0', '-0.725352', '1', '92', '92', '92', '92', '92', '92', '92', '0', '0', '1', '0', '1', '0', '0', '0', '0', '80', '100', '0', '0');
|
and
Quote:
UPDATE npc_types SET id='152025', name='locknarg', lastname='plate vendor', level='80', race='10', class='1', bodytype='1', hp='100000000', gender='0', texture='0', helmtexture='0', size='10', hp_regen_rate='0', mana_regen_rate='0', loottable_id='0', merchant_id='346866', npc_spells_id='0', npc_faction_id='0', adventure_template_id='0', trap_template='0', mindmg='3', maxdmg='14', npcspecialattks='UMCNIDABfWOHL', aggroradius='70', face='0', luclin_hairstyle='0', luclin_haircolor='0', luclin_eyecolor='0', luclin_eyecolor2='0', luclin_beardcolor='0', luclin_beard='0', drakkin_heritage='0', drakkin_tattoo='0', drakkin_details='0', armortint_id='0', armortint_red='0', armortint_green='0', armortint_blue='0', d_meele_texture1='0', d_meele_texture2='0', prim_melee_type='28', sec_melee_type='28', runspeed='1.25', MR='3', CR='3', DR='3', FR='3', PR='3', Corrup='3', see_invis='0', see_invis_undead='0', qglobal='1', AC='1181', npc_aggro='0', spawn_limit='0', attack_speed='-0.725352', findable='1', STR='92', STA='92', DEX='92', AGI='92', _INT='92', WIS='92', CHA='92', see_hide='0', see_improved_hide='0', trackable='1', isbot='0', exclude='1', ATK='0', Accuracy='0', slow_mitigation='0', version='0', maxlevel='80', scalerate='100', private_corpse='0', unique_spawn_by_name='1' WHERE id='152025';
|
|
|
|
|
01-24-2011, 05:45 PM
|
Sarnak
|
|
Join Date: Oct 2006
Posts: 29
|
|
Quote:
Originally Posted by Derision
What Class did you make the merchant ? I think Class 41 = Merchant.
|
that was it, ty for the speedy reply!
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 10:42 AM.
|
|
|
|
|
|
|
|
|
|
|
|
|