Advertisement
Guest User

Update Query

a guest
Oct 24th, 2014
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.40 KB | None | 0 0
  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 = health_mod * @Health, t.minlevel = @minlevel, t.maxlevel = @maxlevel, t.Mana_mod = Mana_mod * @Mana
  15. WHERE
  16. c.map = @MapID;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement