Item prices in current database

[Daeli]

Hi there,

just a small contribution to add the prices to the itemtemplate db. I guess the price Column is expressed in copper? If so this script will calculate the correct prices for your db.

Code: Select all

use dol;
update itemtemplate set price = gold * 10000 + silver * 100 + copper;


Greetings,
daeli

[Graveen]

Ty Daeli.

For all the chanegs related to Inventory changes, you can execute the script included here: viewtopic.php?f=59&t=16083

Precisely, it handles the case where one column is null instead of 0.

[Daeli]

Oh, sorry didn't see that post.