Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Tools

Development::Tools 3rd Party Tools for EQEMu (DB management tools, front ends, etc...)

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 04-01-2018, 03:08 AM
GRUMPY
Discordant
 
Join Date: Oct 2016
Posts: 445
Default

I use this editor myself, I like it a lot.
In the items table there is two columns to control the pricing of any items on merchants.
One is price and the other is sellrate. The sellrate value can, (and does) increase the base price you set
on an item. If the sellrate is set to 1, then it won't mod the base price. If you want a query to practice
with, it would be like this:

Code:
UPDATE items SET price = 100000 WHERE name LIKE '%crude defiant';
UPDATE items SET sellrate = 1 WHERE name LIKE '%crude defiant';
Of course you would need to add lines for the other named defiant gear.
Reply With Quote
 


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 01:09 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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3