[DiscordArchive] But for each of the tables, yes?
[DiscordArchive] But for each of the tables, yes?
Original source
But for each of the tables, yes?
rektbyfaith
04-08-2021, 03:23 PM #1Archived author: ReynoldsCahoon • Posted: 2021-04-08T15:23:27.532000+00:00
Original source
But for each of the tables, yes?
Original source
I'm using
```sql
SELECT
it.name,
flt.Chance AS 'fishing_loot',
clt.Chance AS 'creature_loot',
golt.Chance AS 'gameobject_loot',
clt.Chance AS 'item_loot',
delt.Chance AS 'disenchant_loot',
proslt.Chance AS 'prospecting_loot',
mlt.Chance AS 'milling_loot',
pplt.Chance AS 'pickpocketing_loot',
slt.Chance AS 'skinning_loot',
rlt.Chance AS 'reference_loot'
FROM
item_template it
LEFT JOIN
fishing_loot_template flt
ON
flt.Item = it.entry
LEFT JOIN
creature_loot_template clt
ON
clt.Item = it.entry
LEFT JOIN
gameobject_loot_template golt
ON
golt.Item = it.entry
LEFT JOIN
item_loot_template ilt
ON
ilt.Item = it.entry
LEFT JOIN
disenchant_loot_template delt
ON
delt.Item = it.entry
LEFT JOIN
prospecting_loot_template proslt
ON
proslt.Item = it.entry
LEFT JOIN
milling_loot_template mlt
ON
mlt.Item = it.entry
LEFT JOIN
pickpocketing_loot_template pplt
ON
pplt.Item = it.entry
LEFT JOIN
skinning_loot_template slt
ON
slt.Item = it.entry
LEFT JOIN
reference_loot_template rlt
ON
rlt.Item = it.entry
WHERE
it.entry = 3336
```
To check all(?) tables at once for a specific item. The results of this query are `NULL` for all fields but the last (`reference_loot_template`) and it's chance is `0`.
Does this mean the item has no chance to drop, or am I missing a table?
https://classic.wowhead.com/item=3336/flesh-piercer
[Embed: Flesh Piercer]
This green dagger has an item level of 29. It is looted from Daggerspine Screamer. Added in Classic World of Warcraft. Always up to date with the latest patch.
https://classic.wowhead.com/item=3336/flesh-piercer
rektbyfaith
04-08-2021, 03:41 PM #2Archived author: ReynoldsCahoon • Posted: 2021-04-08T15:41:40.156000+00:00
Original source
I'm using
```sql
SELECT
it.name,
flt.Chance AS 'fishing_loot',
clt.Chance AS 'creature_loot',
golt.Chance AS 'gameobject_loot',
clt.Chance AS 'item_loot',
delt.Chance AS 'disenchant_loot',
proslt.Chance AS 'prospecting_loot',
mlt.Chance AS 'milling_loot',
pplt.Chance AS 'pickpocketing_loot',
slt.Chance AS 'skinning_loot',
rlt.Chance AS 'reference_loot'
FROM
item_template it
LEFT JOIN
fishing_loot_template flt
ON
flt.Item = it.entry
LEFT JOIN
creature_loot_template clt
ON
clt.Item = it.entry
LEFT JOIN
gameobject_loot_template golt
ON
golt.Item = it.entry
LEFT JOIN
item_loot_template ilt
ON
ilt.Item = it.entry
LEFT JOIN
disenchant_loot_template delt
ON
delt.Item = it.entry
LEFT JOIN
prospecting_loot_template proslt
ON
proslt.Item = it.entry
LEFT JOIN
milling_loot_template mlt
ON
mlt.Item = it.entry
LEFT JOIN
pickpocketing_loot_template pplt
ON
pplt.Item = it.entry
LEFT JOIN
skinning_loot_template slt
ON
slt.Item = it.entry
LEFT JOIN
reference_loot_template rlt
ON
rlt.Item = it.entry
WHERE
it.entry = 3336
```
To check all(?) tables at once for a specific item. The results of this query are `NULL` for all fields but the last (`reference_loot_template`) and it's chance is `0`.
Does this mean the item has no chance to drop, or am I missing a table?
https://classic.wowhead.com/item=3336/flesh-piercer
[Embed: Flesh Piercer]
This green dagger has an item level of 29. It is looted from Daggerspine Screamer. Added in Classic World of Warcraft. Always up to date with the latest patch.
https://classic.wowhead.com/item=3336/flesh-piercer
Original source
*(because this would explain why my farming of Daggerspine Naga's on ChromieCraft yielded no dagger after hours of farming)*
rektbyfaith
04-08-2021, 03:48 PM #3Archived author: ReynoldsCahoon • Posted: 2021-04-08T15:48:49.938000+00:00
Original source
*(because this would explain why my farming of Daggerspine Naga's on ChromieCraft yielded no dagger after hours of farming)*
Original source
Welp, think I found the issue. Going to attempt my first PR.
rektbyfaith
04-08-2021, 04:30 PM #4Archived author: ReynoldsCahoon • Posted: 2021-04-08T16:30:17.401000+00:00
Original source
Welp, think I found the issue. Going to attempt my first PR.