Mercenary Development Tracking

[fault]

I dont get it, everything is proper, rof2 client, i noticed that it reports 0/0 expansions, but eqemu has always done that, i can access all content, zones etc that are in eqemu and rof2.

just cant access these dog gone mercs


i even set account where expansion says 0 to 21 and went down from there and nothing.

[trevius]

And you added the Liaison NPC ID to your merc_merchant_entries table?

[fault]

Originally Posted by trevius

And you added the Liaison NPC ID to your merc_merchant_entries table?

thats the issue trevius. i looked in the table only the 2 liasons in crescent are there went to crescent and the box loads,

when i source the sql for that table it gives errors

why is there such a query used for this?

heres the sql that comes with eqemu

REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Barbarian Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Caynd')); 
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Orc Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Caynd'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Barbarian Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Aderrawyn'));	
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Orc Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Aderrawyn'));	
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Half Elf Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Jarenth'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Orc Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Jarenth'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Half Elf Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Rhilali'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Orc Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Rhilali'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Erudite Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Bomawyn'));	
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Kobold Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Bomawyn'));	
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Erudite Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Adiasean'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Kobold Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Adiasean'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Guktan Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Norerd'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Guktan Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Erohach'));	
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Gnome Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Frilikin'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Gnome Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Asirav'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Vah Shir Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Voelath'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Sporali Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Voelath'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Vah Shir Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Helind'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Sporali Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Helind'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Dwarf Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Rirak'));	
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Goblin Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Rirak'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Dwarf Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Cigosh'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Goblin Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Cigosh'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Iksar Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Jelab'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Froglok Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Jelab'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Kunark Goblin Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Jelab'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Iksar Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Frendad'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Froglok Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Frendad'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Kunark Goblin Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Frendad'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default High Elf Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Onaut'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Brownie Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Onaut'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default High Elf Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Rhenwan'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Brownie Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Rhenwan'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Wood Elf Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Prau'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Wood Elf Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Shabado'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Dark Elf Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Kedirakith'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Dark Elf Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Onay'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Human Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Drendle'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Human Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Vaehan'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Drakkin Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Aboekor'));	
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Drakkin Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Adew'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Ogre Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Daknot'));	
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Lizard Man Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Daknot'));	
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Ogre Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Rhorin'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Lizard Man Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Rhorin'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Troll Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Ulaurd'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Froglok Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Ulaurd'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Orc Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Ulaurd'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Troll Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Wedrijan'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Froglok Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Wedrijan'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Orc Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Wedrijan'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Halfling Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Jerbabi'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Halfling Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Guardian_Thaowyn'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Drakkin Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Mercenary_Mdjai'));
REPLACE INTO merc_merchant_entries ( merc_merchant_template_id, merchant_id ) VALUES ( (SELECT merc_merchant_template_id FROM merc_merchant_templates WHERE name = 'Default Drakkin Mercenaries'), (SELECT ID FROM npc_types WHERE name = 'Mercenary_Akana'));

and the error
[evlite] ERROR 1242: Subquery returns more than 1 row

[werebat]

The mercs.sql appears to be incomplete. I had to run the extra scripts from the below thread. Once I did that, the merc vendors worked fine and I was able to buy one.

http://www.eqemulator.org/forums/sho...ht=merc+failed

[trevius]

If your tables are not correct, you should be getting MySQL error messages in your world process window. Have you reviewed that window to see if any errors show up when your zones boot or when you right click on a Mercenary Liaison?