Advertisement
Guest User

Untitled

a guest
Mar 17th, 2019
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.35 KB | None | 0 0
  1. DELETE ctm FROM creature_template_movement ctm INNER JOIN creature_template ct ON ctm.CreatureId = ct.difficulty_entry_1;
  2. DELETE ctm FROM creature_template_movement ctm INNER JOIN creature_template ct ON ctm.CreatureId = ct.difficulty_entry_2;
  3. DELETE ctm FROM creature_template_movement ctm INNER JOIN creature_template ct ON ctm.CreatureId = ct.difficulty_entry_3;
  4. INSERT INTO creature_template_movement (CreatureId, Ground, Swim, Flight, Rooted, Chase, Random) SELECT diff_entry, Ground, Swim, Flight, Rooted, Chase, Random FROM creature_template_movement ctm JOIN (SELECT entry, difficulty_entry_1 AS diff_entry  FROM creature_template  WHERE difficulty_entry_1 > 0) CT ON CTM.CreatureId = CT.entry;
  5. INSERT INTO creature_template_movement (CreatureId, Ground, Swim, Flight, Rooted, Chase, Random) SELECT diff_entry, Ground, Swim, Flight, Rooted, Chase, Random FROM creature_template_movement ctm JOIN (SELECT entry, difficulty_entry_2 AS diff_entry  FROM creature_template  WHERE difficulty_entry_2 > 0) CT ON CTM.CreatureId = CT.entry;
  6. INSERT INTO creature_template_movement (CreatureId, Ground, Swim, Flight, Rooted, Chase, Random) SELECT diff_entry, Ground, Swim, Flight, Rooted, Chase, Random FROM creature_template_movement ctm JOIN (SELECT entry, difficulty_entry_3 AS diff_entry  FROM creature_template  WHERE difficulty_entry_3 > 0) CT ON CTM.CreatureId = CT.entry;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement