Pelf

sql fixes

Jan 8th, 2012
151
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.00 KB | None | 0 0
  1. //grim batol
  2. DELETE FROM creature WHERE id = 30622 AND map = 670;
  3. DELETE FROM creature WHERE id = 40600 AND map = 670;
  4. DELETE FROM creature WHERE id = 39390 AND map = 670;
  5. DELETE FROM creature WHERE id = 40355 AND map = 670;
  6. DELETE FROM creature WHERE id = 40320 AND map = 670;
  7. DELETE FROM creature WHERE id = 40357 AND map = 670;
  8. DELETE FROM creature WHERE id = 41040 AND map = 670;
  9. DELETE FROM creature WHERE id = 42608 AND map = 670;
  10. DELETE FROM creature WHERE id = 40228 AND map = 670;
  11. DELETE FROM creature WHERE id = 42570 AND map = 670;
  12. DELETE FROM creature WHERE id = 40030 AND map = 670;
  13. UPDATE creature_template SET flags_extra = 128 WHERE entry = 40030;
  14. UPDATE creature_template SET faction_a=16, faction_h=16 WHERE entry=40290;
  15. UPDATE creature_template SET MovementType=0 WHERE entry IN (39625, 40484);
  16. UPDATE creature SET MovementType=0 WHERE id IN (39625, 40484);
  17.  
  18. //blackrock caverns
  19. DELETE FROM creature WHERE id = 40447 AND map = 645;
  20. DELETE FROM creature WHERE id = 50284 AND map = 645;
Advertisement
Add Comment
Please, Sign In to add comment