They're for increasing the stats on items the damage, health armor, and levels of mobs.
So far I have this...
Code:
SELECT (items.stat_value1 + (items.stat_value1 * 1)),
(items.stat_value2 + (items.stat_value2 * 1)),
(items.stat_value3 + (items.stat_value3 * 1)),
(items.stat_value4 + (items.stat_value4 * 1)),
(items.stat_value5 + (items.stat_value5 * 1)),
(items.stat_value6 + (items.stat_value6 * 1)),
(items.stat_value7 + (items.stat_value7 * 1)),
(items.stat_value8 + (items.stat_value8 * 1)),
(items.stat_value9 + (items.stat_value9 * 1)),
(items.stat_value10 + (items.stat_value10 * 1)),
(items.dmg_min1 + (items.dmg_min1 * 1)),
(items.dmg_min2 + (items.dmg_min2 * 1)),
(items.dmg_min3 + (items.dmg_min3 * 1)),
(items.dmg_min4 + (items.dmg_min4 * 1)),
(items.dmg_min5 + (items.dmg_min5 * 1)),
(items.dmg_max1 + (items.dmg_max1 * 1)),
(items.dmg_max2 + (items.dmg_max2 * 1)),
(items.dmg_max3 + (items.dmg_max3 * 1)),
(items.dmg_max4 + (items.dmg_max4 * 1)),
(items.dmg_max5 + (items.dmg_max5 * 1)),
(items.armor + (items.armor * 1))
FROM items
WHERE entry = ('ItemID')
Code:
SELECT (creature_proto.minhealth + (creature_proto.minhealth * 1)),
(creature_proto.maxhealth + (creature_proto.maxhealth * 1)),
(creature_proto.minlevel + 10),
(creature_proto.maxlevel + 10),
(creature_proto.mindamage + (creature_proto.mindamage * 0.9)),
(creature_proto.maxdamage + (creature_proto.maxdamage * 0.9)),
(creature_proto.armor + (creature_proto.armor * 0.5))
FROM creature_proto
WHERE entry = ('NPCID')
But It doesn't CHANGE anything, ofcourse. Not sure how I could form a query that could update the item(s) with the new value??
New Fixed Versions @ Code Paster! thanks to NRK :P