[DiscordArchive] I tried that SQL code and unfortunately it didn't work because the creature table doesn't have an "e
[DiscordArchive] I tried that SQL code and unfortunately it didn't work because the creature table doesn't have an "e
Original source
If multiple ids are provided, one is selected at random.
rektbyfaith
06-11-2023, 06:50 PM #11Archived author: Honey • Posted: 2023-06-11T18:50:31.408000+00:00
Original source
If multiple ids are provided, one is selected at random.
Original source
Neato!
rektbyfaith
06-11-2023, 06:50 PM #12Archived author: ritzmenardi • Posted: 2023-06-11T18:50:38.367000+00:00
Original source
Neato!
Original source
```sql
Select * from creature inner join creature_template on creature.id1=creature_template.entry and creature_template.type=8;
```
worked for my purposes, I think. I just changed "creature.entry" to "creature.id1"
tyvm for the help ❤️
rektbyfaith
06-11-2023, 06:51 PM #13Archived author: ritzmenardi • Posted: 2023-06-11T18:51:06.639000+00:00
Original source
```sql
Select * from creature inner join creature_template on creature.id1=creature_template.entry and creature_template.type=8;
```
worked for my purposes, I think. I just changed "creature.entry" to "creature.id1"
tyvm for the help ❤️
Original source
For anyone who's curious there are 7746 different critters instantiated in the world in base WotLK
rektbyfaith
06-11-2023, 06:52 PM #14Archived author: ritzmenardi • Posted: 2023-06-11T18:52:12.024000+00:00
Original source
For anyone who's curious there are 7746 different critters instantiated in the world in base WotLK
1 Guest(s)
1 Guest(s)