Advertisement
tok124

SQL to update mobs

Jul 15th, 2014
218
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. UPDATE creature_template AS t
  2. INNER JOIN creature AS c
  3. ON t.entry = c.id
  4. SET
  5. t.Health_mod=250000
  6. WHERE
  7. c.map = 409;
  8.  
  9. UPDATE creature_template AS t
  10. INNER JOIN creature AS c
  11. ON t.entry = c.id
  12. SET
  13. t.minlevel=50000
  14. WHERE
  15. c.map = 409;
  16.  
  17. UPDATE creature_template AS t
  18. INNER JOIN creature AS c
  19. ON t.entry = c.id
  20. SET
  21. t.maxlevel=50000
  22. WHERE
  23. c.map = 409;
  24.  
  25. UPDATE creature_template AS t
  26. INNER JOIN creature AS c
  27. ON t.entry = c.id
  28. SET
  29. t.dmg_multiplier=10
  30. WHERE
  31. c.map = 409;
Advertisement
Advertisement
Advertisement
RAW Paste Data Copied
Advertisement