Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELETE ctm FROM creature_template_movement ctm INNER JOIN creature_template ct ON ctm.CreatureId = ct.difficulty_entry_1;
- DELETE ctm FROM creature_template_movement ctm INNER JOIN creature_template ct ON ctm.CreatureId = ct.difficulty_entry_2;
- DELETE ctm FROM creature_template_movement ctm INNER JOIN creature_template ct ON ctm.CreatureId = ct.difficulty_entry_3;
- 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;
- 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;
- 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