[DiscordArchive] One other quick SQL query, if you don't mind - how could I display the display IDs of all creatures
[DiscordArchive] One other quick SQL query, if you don't mind - how could I display the display IDs of all creatures
Original source
One other quick SQL query, if you don't mind - how could I display the display IDs of all creatures that are inside a specific area ID?
rektbyfaith
10-20-2024, 03:05 PM #1Archived author: Snowcraft • Posted: 2024-10-20T15:05:57.730000+00:00
Original source
One other quick SQL query, if you don't mind - how could I display the display IDs of all creatures that are inside a specific area ID?
Original source
```sql
SET @AREAID := XXXX;
SELECT ct.`entry`, ct.`modelid1`, ct.`modelid2`, ct.`modelid3`, ct.`modelid4` FROM `creature` c
LEFT JOIN `creature_template` ct ON c.`id`=ct.`entry`
WHERE c.`areaId`=@AREAID;
```
rektbyfaith
10-20-2024, 07:02 PM #2Archived author: Meji • Posted: 2024-10-20T19:02:57.560000+00:00
Original source
```sql
SET @AREAID := XXXX;
SELECT ct.`entry`, ct.`modelid1`, ct.`modelid2`, ct.`modelid3`, ct.`modelid4` FROM `creature` c
LEFT JOIN `creature_template` ct ON c.`id`=ct.`entry`
WHERE c.`areaId`=@AREAID;
```
1 Guest(s)
1 Guest(s)