Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET
- @health = 10,
- @mana = 10,
- @minlevel = 255,
- @maxlevel = 255,
- @mindmg = 10,
- @maxdmg = 10,
- @MapID = 548;
- UPDATE creature_template
- SET HealthModifier = HealthModifier * @health, ManaModifier = ManaModifier * @mana, minlevel = @minlevel, maxlevel = @maxlevel, mindmg = mindmg * @mindmg, maxdmg = maxdmg * @maxdmg
- WHERE entry IN (SELECT id FROM creatures WHERE map = @MapID);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement