Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Support > Archive::Tutorials/Howto's > Tutorials--Outdated Use the Wiki > Tutorials::Submissions

Tutorials::Submissions Submit your tutorials here to be reviewed

 
 
Thread Tools Display Modes
  #1  
Old 04-23-2005, 02:53 AM
aragon
Sarnak
 
Join Date: Feb 2005
Location: Malaga-Spain
Posts: 40
Default Merchant id list - Spaw merchants tutorial

For example I want to create the merchant Caden_Zharik in POK(http://eqbeastiary.allakhazam.com/search.shtml?id=10510 with the correct items for sale.

Inside the game search for all the items the merchant has
Quote:
#itemsearch ITEMNAMEHERE
or using mysql.exe
Quote:
select id,name from items where name like 'ItemNamHere' ;
write down all the items ID.

With all the ID you need, type in mysql.exe:

type the items ID separate by coma:
Quote:
select i.merchantid from merchantlist i INNER JOIN items on i.item=items.id where items.id IN('9729,16592,13037,13106');
pick the merchant ID who has all the items.

Inside the game go to the correspondent area where the npc should be and type:
Quote:
#spawn Caden_Zharik 11 60 3 100000 0 41 0 0 220
the last number 220 is the merchantID you search before.

Ready, don't forget to save your merchant by typing:
Quote:
#npcspawn create

Last edited by aragon; 04-23-2005 at 01:16 PM..
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 03:32 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3