Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::General Support

Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself.

Reply
 
Thread Tools Display Modes
  #1  
Old 10-05-2014, 09:03 PM
vindr3d
Fire Beetle
 
Join Date: Aug 2011
Posts: 21
Default Adding items to a merchant

Hey guys.

I am having trouble adding items to my newly created NPC. I have made him and checked to see that he can be right clicked on. The only thing that pops up is a "Cloth Cap". I went to the merchantlist table and added his ID with the slot and item number I want him to sell but they do not show up when I restart everything and click on him. (I want to make him an epic 1.0 vendor for everyone)

What I find weird is that it doesn't have anything in the merchantlist table for his ID for the cloth cap.

It took me probably 4-5 hours to figure out how to create a working merchant(still pretty new at this) because there is a guide to make an NPC but not a merchant.

As always, I appreciate any help/everyones knowledge of getting me this far with the server!!!
Reply With Quote
  #2  
Old 10-05-2014, 09:33 PM
jdoran
Hill Giant
 
Join Date: Jul 2012
Posts: 212
Default

As I recall there is a list of items a vendor might have, and each vendor is then associated with that table.

The 'merchant_id' is the id of the table, and should match merchantid in 'merchantlist'. I haven't done this in a while, and may be off base. But that is as near as I can recall.

Edit: I should be more clear. I am talking about the merchant_id in npc_types matching the id in merchantlist.
Reply With Quote
  #3  
Old 10-05-2014, 10:56 PM
vindr3d
Fire Beetle
 
Join Date: Aug 2011
Posts: 21
Default

Yes. I just double checked. Both are id 189528.

Should i Maybe start with slot 2 since slot 1 on him is magically taken by the "Cloth Cap"?
Reply With Quote
  #4  
Old 10-05-2014, 10:59 PM
vindr3d
Fire Beetle
 
Join Date: Aug 2011
Posts: 21
Default

nope...just started server and checked...i have the beastlord epics (mh and oh) and bard epic set to be sold by him(slots 2-4) but it still just shows "Cloth Cap"(slot 1 i would assume even though there is no entry for it)

I tried GeorgeS' tool but it kept giving me a database connection error. I followed the instructions provided.



Edit: sorry I fail at editing, I keep quick replying. I have the 3 epics listed in the merchantlist table under the NPC's merchant ID with the other default values (faction required -100, level required 0, alt currency cost 0, classes required 65535, probability 100).

Last edited by vindr3d; 10-05-2014 at 11:01 PM.. Reason: fail at editing
Reply With Quote
  #5  
Old 10-05-2014, 11:02 PM
Kingly_Krab
Administrator
 
Join Date: May 2013
Location: United States
Posts: 1,589
Default

Mind running these queries and posting the results?
Code:
SELECT * FROM `merchantlist` WHERE `merchantid` = '189528';
Code:
SELECT * FROM `npc_types` WHERE `merchant_id` = '189528';
Reply With Quote
  #6  
Old 10-05-2014, 11:24 PM
vindr3d
Fire Beetle
 
Join Date: Aug 2011
Posts: 21
Default

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.0.9-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use peq
Database changed
MariaDB [peq]> SELECT * FROM `merchantlist` WHERE `merchantid` = '189528';
+------------+------+-------+------------------+----------------+---------------
----+------------------+-------------+
| merchantid | slot | item | faction_required | level_required | alt_currency_c
ost | classes_required | probability |
+------------+------+-------+------------------+----------------+---------------
----+------------------+-------------+
| 189528 | 2 | 8495 | -100 | 0 |
0 | 65535 | 100 |
| 189528 | 3 | 8496 | -100 | 0 |
0 | 65535 | 100 |
| 189528 | 4 | 20542 | -100 | 0 |
0 | 65535 | 100 |
+------------+------+-------+------------------+----------------+---------------
----+------------------+-------------+
3 rows in set (0.00 sec)

MariaDB [peq]>


MariaDB [peq]> SELECT * FROM `npc_types` WHERE `merchant_id` = '189528';
Empty set (0.10 sec)

MariaDB [peq]>



The second query I guess is the problem?




EDIT: I just found the problem. In npc_types table, the merchant ID was different than what I had set it to for the actual ID in the merchantlist table. I changed it to 189528 and then loaded the server. The 3 epics I set the NPC to sell showed up.

Thank you for the help cause without your posts, I wouldn't of even looked at it this much farther.

THANK YOU THANK YOU!!

Last edited by vindr3d; 10-05-2014 at 11:30 PM.. Reason: herp derp
Reply With Quote
  #7  
Old 10-05-2014, 11:38 PM
Kingly_Krab
Administrator
 
Join Date: May 2013
Location: United States
Posts: 1,589
Default

Glad your issue was resolved.
Reply With Quote
  #8  
Old 10-05-2014, 11:40 PM
vindr3d
Fire Beetle
 
Join Date: Aug 2011
Posts: 21
Default

For those looking to make a new merchant, make sure you make the class "41". This is the shop keeper class.
Reply With Quote
  #9  
Old 12-02-2023, 04:54 AM
Drathil
Fire Beetle
 
Join Date: Feb 2016
Posts: 2
Default Wow

Quote:
Originally Posted by vindr3d View Post
For those looking to make a new merchant, make sure you make the class "41". This is the shop keeper class.
You my friend, are a life saver. Thank you.
Reply With Quote
Reply

Thread Tools
Display Modes

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 10:49 PM.


 

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