Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SELECT entry, name FROM `creature_template` WHERE `ScriptName` LIKE '%boss_four_horsemen%' LIMIT 0,1000;
- +-------+-----------------+
- | entry | name |
- +-------+-----------------+
- | 16063 | Sir Zeliek |
- | 16064 | Thane Korth'azz |
- | 16065 | Lady Blaumeux |
- | 30549 | Baron Rivendare |
- +-------+-----------------+
- 4 rows in set
- mysql> SELECT entry, name FROM `creature_template` WHERE `ScriptName` LIKE '%boss_four_horsemen%' LIMIT 0,1000;
- +-------+-----------------+
- | entry | name |
- +-------+-----------------+
- | 16063 | Sir Zeliek |
- | 16064 | Thane Korth'azz |
- | 16065 | Lady Blaumeux |
- | 30549 | Baron Rivendare |
- +-------+-----------------+
- 4 rows in set
- mysql> select guid, id, position_x, position_y, position_z, orientation from creature where id in (select entry from creature_template WHERE `ScriptName` LIKE '%boss_four_horsemen%');
- +--------+-------+------------+------------+------------+-------------+
- | guid | id | position_x | position_y | position_z | orientation |
- +--------+-------+------------+------------+------------+-------------+
- | 130961 | 16064 | 2520.5 | -2955.38 | 245.635 | 5.58505 |
- | 130962 | 16065 | 2517.62 | -2959.38 | 245.636 | 5.72468 |
- | 130963 | 30549 | 2524.32 | -2951.28 | 245.633 | 5.42797 |
- | 130964 | 16063 | 2528.79 | -2948.58 | 245.633 | 5.2709 |
- +--------+-------+------------+------------+------------+-------------+
- 4 rows in set
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement