Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. SET
  2. /* Edit these values */
  3. @Health = 10,
  4. @Mana = 10,
  5. @minlevel = 255,
  6. @maxlevel = 255,
  7. @MapID = 548;
  8.  
  9. /* Do not edit anything under this text unless you know what you are doing */
  10. UPDATE creature_template AS t
  11. INNER JOIN creature AS c
  12. ON t.entry = c.id
  13. SET
  14. t.Health_mod = t.health_mod / @Health, t.minlevel = @minlevel, t.maxlevel = @maxlevel, t.Mana_mod = t.Mana_mod / @Mana
  15. WHERE
  16. c.map = @MapID;