Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 03-18-2013, 06:17 PM
dagulus2
Hill Giant
 
Join Date: Feb 2013
Posts: 220
Default

I had this behavior on merchants who did not actually have a merchant list assigned to them.
Reply With Quote
  #2  
Old 03-18-2013, 06:40 PM
Dhrystone
Sarnak
 
Join Date: Feb 2013
Posts: 31
Default

Straight off my database at the moment:

Code:
mysql> SELECT id, Name, Price, sellrate FROM  items WHERE  Name LIKE  'Rusty Dagger';
+-------+--------------+-------+----------+
| id    | Name         | Price | sellrate |
+-------+--------------+-------+----------+
|  7007 | Rusty Dagger |    30 |        5 |
| 13346 | Rusty Dagger |    30 |        1 |
| 94100 | Rusty Dagger |     0 |        9 |
+-------+--------------+-------+----------+
3 rows in set (0.00 sec)

mysql> select * from rule_values where rule_name like 'Merchant:BuyCostMod';
+------------+---------------------+------------+-----------------------------+
| ruleset_id | rule_name           | rule_value | notes                       |
+------------+---------------------+------------+-----------------------------+
|          1 | Merchant:BuyCostMod | 0.95       | Modifier for NPC buy price. |
+------------+---------------------+------------+-----------------------------+
1 row in set (0.00 sec)
The 7007 item sell rate is 5 because I'm testing it.

When I sell 7007 to Katha Firespinner at indifferent she gives me 1g 4s. When she lists it the price is 1g 4s 2c. At a sellrate of 4 she lists it at 1g 1s 4c.

When I sell 13346 to her she gives me the same price. But I can buy it back from her at only 4s 3c.

The same pattern holds for all items. Anytime the sellrate is under 5 it's a plat exploit. All items I have checked so far. But on the official PEQ server all is well. Katha buys a malachite from me at 4s 8c and sells it for 5s 2c. But on my server which should have the same database she pays me 1g s 3c for that malachite but only sells it for 4s 7c!!

Thanks!
Dhry

EDIT: I have temporarily fixed this by adding 5 to all sellrates in the items table.
Reply With Quote
  #3  
Old 03-18-2013, 07:23 PM
Dhrystone
Sarnak
 
Join Date: Feb 2013
Posts: 31
Default

And why I'm at it, is there a way to refresh the merchants after a change without re-starting the server? I tried the various reload commands and zoned but nothing changes until I restart.

Dhry.
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 06:11 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