Development::Database/World BuildingWorld Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.
Does anybody know what syntax I would use to divide all the values in a given column by a certain decimal? In other words, I want to play around with coin drops and I want to reduce the values in the min and maxcash columns by X% with as few queries as possible. I've tried a few different ways so far but they either came back with a syntax error or reduced all the values to 0. Thanks for any help.
Thanks a lot! That's perfect. I never tried 'columnname=columname*decimalvalue' although now that makes perfect sense. Without it, I would be multiplying 0 by the decimal, which would explain all those times I ended up with all 0s
Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.