Items - prices and tweaks for solo servers.

[strider51]

Hello all.
On my solo server, I've changed the items and pricing around to create a better experience for me. I thought I'd share these scripts.

1. Make everything droppable, and no Lore (some crazy good weapon combinations out there now)
2. Add a reasonable price to everything so that I can at least vendor the item to make plat to purchase spell casts and training (custom NPCs).
3. Remove all level caps on items so that I can twink out an ALT with awesome stuff for fun.


note: number 2 is done with a "pricemod" that takes into account item stats. It works well with weapons, and will only apply to items where the pricemod is positive. Here is a query to just see what the pricemod will be for items (does not alter tables)

--QUERY TO SEE THE PRICE MOD FOR ITEMS (BEFORE ADDING PRICES ( it looks for anything with price = 0) NOTE THIS IS COMMENTED OUT (OR SHOULD BE!)
--select id, name, price, damage, (name+ aagi+ ac+ acha+ adex+ aint+ asta+ astr+ attack+ awis+ damage+ endur+ dr+ fr+ haste+ hp+ regen+ mana+ mr+pr+range) as pricemod from items where price = 0 and (name+ aagi+ ac+ acha+ adex+ aint+ asta+ astr+ attack+ awis+ damage+ endur+ dr+ fr+ haste+ hp+ regen+ mana+ mr+pr+range)> 0;


Here are the actual queries that I used.


-- ITEMS AND PRICES (only for price=0 items)
UPDATE variables SET `value`='1' WHERE `varname`='MerchantsKeepItems';
UPDATE variables SET `value`='1' WHERE `varname`='DisableNoDrop';
INSERT INTO variables (`varname`, `value`, `information`) VALUES ('disablelore', '1', 'disables lore on items');

-- SET PRICE to the pricemod * 20,000 (or 20 plat)
update items set price =
(aagi+ ac+ acha+ adex+ aint+ asta+ astr+ attack+ awis+ damage+ endur+ dr+ fr+ haste+ hp+ regen+ mana+ mr+pr+range) * 20000
where price = 0
and (aagi+ ac+ acha+ adex+ aint+ asta+ astr+ attack+ awis+ damage+ endur+ dr+ fr+ haste+ hp+ regen+ mana+ mr+pr+range)> 0;

-- SET the price = the id on the rest of the items (more of a best guess here).
update items set price = id where price = 0;


-- NOW every item should have a price;

-- REMOVE ALL REQUIRED AND RECCOMENDED LEVELS ON ITEMS
update items set reclevel =0;
update items set reqlevel =0;



I hope that this is helpful to someone!!!

Thanks,

PS: remember always backup your tables before editing!
-mysqldump -u root -p eqdatabasename items > itemsTableBackup.sql