Smart idea
You could avoid to give nodrop items a price.
'aint' statment is missing in the 3rd query and it overrides all the costs, even those which yet have been set.
I suggest not running the first query which sets 1000 to 'cost', and merge with it the second one :
Code:
update items set cost = 1000 + ( 100 * ( reclevel + reqlevel + ( hp * 10 ) + ( ac * 10 ) + ( mana * 10 ) + ( aagi * 10 ) + ( acha * 10 ) + ( asta * 10 ) + ( astr * 10 ) + ( adex * 10 ) + ( awis * 10 ) + ( aint * 10) + 1 ) + ( hasteproclvl * 100000 ) ) where bagtype=0 and cost=0;
by the same time, the last query also affects the items manually set, so lets merge it too.
Code:
update items set cost = 1000 + ( 100 * ( reclevel + reqlevel + ( hp * 10 ) + ( ac * 10 ) + ( mana * 10 ) + ( aagi * 10 ) + ( acha * 10 ) + ( asta * 10 ) + ( astr * 10 ) + ( adex * 10 ) + ( awis * 10 ) + ( aint * 10) + 1 ) + ( hasteproclvl * 100000 ) )+ ( cr+dr+pr+mr+fr) * 10000 ) where bagtype=0 and cost=0
I haven't tested this since i m at work with no eqemu DB available, but at least you ll get the idea. (still missing : the nodrop test.)