Hey all, i have spent the last few hours trying to figure out how to change the cost of items on vendors using the newest PEQ Kunark DB, which is difficult in that most of the tools like Mangoo's item editor doesn't seem compatible with this version yet...
I found a nice formula and thought it'd work nicely to set prices for my vendors (making it basically so all items are buyable, but using the following formula good items get really expensive really fast, so the price is what curbs the accessibility)
Here's the base formula;
Quote:
update items set cost = 1000*(1+reclevel+reqlevel+hp +ac+mana+aagi+acha+asta+astr+adex+awis+aint+hastep roclvl*100+(cr+dr+pr+mr+fr) *10+100*(spellid+5)/(spellid+5)) where bagtype=0 and cost=0 and nodrop=0 and damage=0 and delay=0
|
And for weapons
Quote:
update items set cost = 1000*(1+reclevel+reqlevel+hp +ac+mana+aagi+acha+asta+astr+adex+awis+aint+hastep roclvl*100+(cr+dr+pr+mr+fr) *10+100*(spellid+5)/(spellid+5)) where and cost=0 and nodrop=0 and damage>0 and delay>0
|
I wanted them to apply to all items so i removed cost and nodrop requirements, plus i removed the spellid thing since it appears that it'd always be 1, changing it into;
Quote:
update items set cost = 1000*(1+reclevel+reqlevel+hp +ac+mana+aagi+acha+asta+astr+adex+awis+aint+hastep roclvl*100+(cr+dr+pr+mr+fr) *10) where bagtype=0 and damage=0 and delay=0
|
And for weapons
Quote:
update items set cost = 1000*(1+reclevel+reqlevel+hp +ac+mana+aagi+acha+asta+astr+adex+awis+aint+hastep roclvl*100+(cr+dr+pr+mr+fr) *10) where damage>0 and delay>0
|
Then i proceeded to source it in (after backing up my DB of course) and, much to my expectations it didn't work (post i got it from was over 10 months old, so i didn't have alota faith)
So grumbling and cursing i dug through the collums of the item table, and found merchantprice... so i tried the above replacing 'cost' with 'merchantprice' ... source it in and restarted my server, still no luck...
So, anyone got any idea what field controls an items price for buying from a merchant? Did i have the right idea, or was i just waaaay off track? Can't seem to find any info on just straight-up price changing, only on doing LDoN merchant stuff, which doesn't direct me to the correct fields unfortunatly...
Thanks for any/all help you can offer!
Edit: Fixed the 'and and' syntax error for clarificaton