[DiscordArchive] Hello, some npc have lootid which can be found in creature_loot_template table
[DiscordArchive] Hello, some npc have lootid which can be found in creature_loot_template table
Original source
Hello, some npc have lootid which can be found in creature_loot_template table
But some npc's lootid is 0 but the item is in them, which table should I refer to to find this item?
rektbyfaith
10-28-2022, 06:38 PM #1Archived author: blacknightt • Posted: 2022-10-28T18:38:30.569000+00:00
Original source
Hello, some npc have lootid which can be found in creature_loot_template table
But some npc's lootid is 0 but the item is in them, which table should I refer to to find this item?
Original source
give a specific example
rektbyfaith
10-28-2022, 06:46 PM #2Archived author: Dreadmaster • Posted: 2022-10-28T18:46:14.013000+00:00
Original source
give a specific example
Original source
If lootid is 0, the creature entry is the loot id
rektbyfaith
10-28-2022, 07:11 PM #3Archived author: Revision • Posted: 2022-10-28T19:11:25.172000+00:00
Original source
If lootid is 0, the creature entry is the loot id
Original source
https://wotlkdb.com/?npc=25001#drops
[Embed: Abyssal Flamewalker - NPC - WotLK Database 3.3.5a]
Abyssal Flamewalker - NPC - WotLK Database 3.3.5a. WotLKDB.com is a fully featured database for World of Warcraft Wrath of the Lich King, patch 3.3.5a.
https://wotlkdb.com/?npc=25001
rektbyfaith
10-28-2022, 07:37 PM #4Archived author: blacknightt • Posted: 2022-10-28T19:37:32.025000+00:00
Original source
https://wotlkdb.com/?npc=25001#drops
[Embed: Abyssal Flamewalker - NPC - WotLK Database 3.3.5a]
Abyssal Flamewalker - NPC - WotLK Database 3.3.5a. WotLKDB.com is a fully featured database for World of Warcraft Wrath of the Lich King, patch 3.3.5a.
https://wotlkdb.com/?npc=25001
Original source
There are 13 items for this creature in the database, but it shows 351
From which table do the numbers of the rest of the items come?
rektbyfaith
10-28-2022, 07:38 PM #5Archived author: blacknightt • Posted: 2022-10-28T19:38:40.313000+00:00
Original source
There are 13 items for this creature in the database, but it shows 351
From which table do the numbers of the rest of the items come?
Original source
The rest comes from references
rektbyfaith
10-28-2022, 07:53 PM #6Archived author: Revision • Posted: 2022-10-28T19:53:03.676000+00:00
Original source
The rest comes from references
Original source
![[Image: unknown.png?ex=690c5434&is=690b02b4&hm=e...9a7128c80&]](https://cdn.discordapp.com/attachments/284406375495368704/1035642731025936404/unknown.png?ex=690c5434&is=690b02b4&hm=e832441f04634caecd8992eeaa6905c0ed312ff1ac581a9a085d2ee9a7128c80&)
rektbyfaith
10-28-2022, 07:54 PM #7Archived author: Revision • Posted: 2022-10-28T19:54:28.474000+00:00
Original source
Original source
It does list 2 entries from other creatures because I couldn't be bothered with removing the wildcard but you get the idea
rektbyfaith
10-28-2022, 07:55 PM #8Archived author: Revision • Posted: 2022-10-28T19:55:28.128000+00:00
Original source
It does list 2 entries from other creatures because I couldn't be bothered with removing the wildcard but you get the idea
Original source
```
SET @Entry := 25001;
SELECT * FROM creature_loot_template WHERE Entry = @Entry AND Reference = 0
UNION
SELECT * FROM reference_loot_template WHERE Entry IN (SELECT Reference FROM creature_loot_template WHERE Entry = @Entry AND Reference > 0)
```
That'll show you a list of all 351 items.
rektbyfaith
10-28-2022, 08:02 PM #9Archived author: Revision • Posted: 2022-10-28T20:02:55.005000+00:00
Original source
```
SET @Entry := 25001;
SELECT * FROM creature_loot_template WHERE Entry = @Entry AND Reference = 0
UNION
SELECT * FROM reference_loot_template WHERE Entry IN (SELECT Reference FROM creature_loot_template WHERE Entry = @Entry AND Reference > 0)
```
That'll show you a list of all 351 items.
Original source
thank you
rektbyfaith
10-28-2022, 08:09 PM #10Archived author: blacknightt • Posted: 2022-10-28T20:09:56.688000+00:00
Original source
thank you
1 Guest(s)
1 Guest(s)