I'm taking uber items OFF vendors in the MW055 database

[RexChaos]

To anyone who doesn't want to spend the ridiculous amounts of time, I'll be uploading the merchants table as an .sql file soon. I am in the process of hand editing each row to take out any uber equipment from the vendors.

This means nobody can buy mithril helms, scepters of destruction, kunark class armor, etc. I'm sure there may be a few servers who want a little less uber merchants. I may miss a few items here and there (cmon it's 8892 rows), but if at least one person finds this useful, then I'm happy.

I'm hoping to have this complete by Monday evening.

[smogo]

for a start, you may want to use the following SQL queries :

delete from merchantlist using merchantlist, items where merchantlist.item=items.id  and items.cost > 100000;

will remove all entries in merchant list where item cost is above 100000

and

delete from merchantlist using merchantlist, items where merchantlist.item=items.id  and items.name like '%Paineel%';

will get you rid of entries in merchant list where name contains Paineel.

i hope this can save you time

[RexChaos]

Those would have come in handy...but I'm already done. Hehe...those are good and they would have saved me a lot of time, but I just replaced the offending items with good old used merchant gloves. I wasn't sure if I could just delete those rows or if that would mess something up with the merchant window item slot placement.

There were some that had prices of 0 that I took out or repriced.

If anyone has any feedback, I'm all for it. Let me know if you find any remnants of gear that shouldn't be there. I left a few armor types in that the prices weren't too bad on as well.

http://www.geocities.com/titaniumguild/eqemu/eqemu.htm

[Shadow-Wolf]

I cant test it out as I have to go to class but i will when i get home and have time..

[KhaN]

Rex, i love you. We got the same point of view on MW forums :p

[RexChaos]

It's good to be loved.