View Single Post
  #5  
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