SHOW:
|
|
- or go back to the newest paste.
1 | mysql> SELECT entry, name FROM `creature_template` WHERE `ScriptName` LIKE '%boss_four_horsemen%' LIMIT 0,1000; | |
2 | +-------+-----------------+ | |
3 | | entry | name | | |
4 | +-------+-----------------+ | |
5 | | 16063 | Sir Zeliek | | |
6 | | 16064 | Thane Korth'azz | | |
7 | | 16065 | Lady Blaumeux | | |
8 | | 30549 | Baron Rivendare | | |
9 | +-------+-----------------+ | |
10 | 4 rows in set | |
11 | ||
12 | - | mysql> select guid, id from creature where id in (select entry from creature_template WHERE `ScriptName` LIKE '%boss_four_horsemen%'); |
12 | + | |
13 | - | +--------+-------+ |
13 | + | |
14 | - | | guid | id | |
14 | + | |
15 | - | +--------+-------+ |
15 | + | |
16 | - | | 130961 | 16064 | |
16 | + | |
17 | - | | 130962 | 16065 | |
17 | + | |
18 | - | | 130963 | 30549 | |
18 | + | |
19 | - | | 130964 | 16063 | |
19 | + | |
20 | - | +--------+-------+ |
20 | + | |
21 | 4 rows in set | |
22 | ||
23 | 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%'); | |
24 | +--------+-------+------------+------------+------------+-------------+ | |
25 | | guid | id | position_x | position_y | position_z | orientation | | |
26 | +--------+-------+------------+------------+------------+-------------+ | |
27 | | 130961 | 16064 | 2520.5 | -2955.38 | 245.635 | 5.58505 | | |
28 | | 130962 | 16065 | 2517.62 | -2959.38 | 245.636 | 5.72468 | | |
29 | | 130963 | 30549 | 2524.32 | -2951.28 | 245.633 | 5.42797 | | |
30 | | 130964 | 16063 | 2528.79 | -2948.58 | 245.633 | 5.2709 | | |
31 | +--------+-------+------------+------------+------------+-------------+ | |
32 | 4 rows in set |