Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building
Reload this Page Merchant limits

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 12-03-2006, 02:06 PM
sylverwolf
Sarnak
  
Join Date: May 2005
Posts: 54
Default Merchant limits
I found an ancient post that merchants inventory was limited to 80. Is this still the case? Reason I ask is I have finally broken down the ranger class by slot and in the process of filling merchants. Filtering out melee weapons yielded over 2k.
__________________
He Had died of natural causes--because a dagger in the heart naturally kills you. --Drizzt Do'Urden
Reply With Quote
  #2  
Old 12-06-2006, 02:45 PM
GeorgeS
Forum Guide
  
Join Date: Sep 2003
Location: California
Posts: 1,475
Default
Running sql

SELECT merchantid,COUNT(merchantid) as c from merchantlist GROUP BY merchantid

This returns many merchants with >80 items. All are <100 however...


GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #3  
Old 12-07-2006, 12:17 AM
mattmeck
Guest
  
Posts: n/a
Default
The more items in a merchants inventory the more memory it uses when a player opens the inventory.

Back in S2K we attempted to have a merchant have an ungodly amount of items and it would crash the zone and ocasionaly the server.

It actualy uses less recorces to have more merchents with less items then less merchants with more items.
Reply With Quote
  #4  
Old 12-07-2006, 02:05 AM
sylverwolf
Sarnak
  
Join Date: May 2005
Posts: 54
Default
Roger that. Thanks for the info. Right now I'm only using the bazaar for starter gear and planning to spread around the others.
__________________
He Had died of natural causes--because a dagger in the heart naturally kills you. --Drizzt Do'Urden
Reply With Quote
Reply

« Previous Thread | Next Thread »

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:08 PM.

EQEmulator - Archive - Top

 

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