Chests contain no currency

sij1nk commented 3 years ago

Original report: https://github.com/chromiecraft/chromiecraft/issues/965

WHAT CLIENT DO YOU PLAY ON?

[ ] enGB
[x] enUS
[ ] other (specify)

FACTION

[x] Alliance
[x] Horde

CONTENT PHASE:

[x] Generic
[ ] 1-19
[ ] 20-29
[ ] 30-39
[ ] 40-49
[ ] 50-59

CURRENT BEHAVIOUR:

Currently looting several solid chests in Duskwood, but also other areas. I notice they do not contain any silver in them

EXPECTED BLIZZLIKE BEHAVIOUR:

I expect at least some silver in them. Depending on the zone, it should be more silver.

SOURCE:

https://www.youtube.com/watch?v=xYmQtBNusrs

STEPS TO REPRODUCE THE PROBLEM:

Go to duskwood
Loot several chests
Notice none of them have currency in them.

EXTRA NOTES:

AC HASH/COMMIT:

https://github.com/chromiecraft/azerothcore-wotlk/commit/34da0cda5195dede48cb0406b23248330d6249cb

OPERATING SYSTEM:

Ubuntu 20.04

MODULES:

OTHER CUSTOMIZATIONS:

None.

SERVER:

ChromieCraft

--- Want to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/99411957-chests-contain-no-currency?utm_campaign=plugin&utm_content=tracker%2F40032087&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F40032087&utm_medium=issues&utm_source=github).

sij1nk commented 3 years ago

Can confirm on 4eaa422. No gameobjects with their name ending with "Chest" contain money.

SELECT gt.entry, gt.name, mingold, maxgold FROM `gameobject_template` gt JOIN `gameobject_template_addon` gta ON gt.entry = gta.entry WHERE gt.name LIKE "%Chest";

+--------+----------------------------------+---------+---------+
| entry  | name                             | mingold | maxgold |
+--------+----------------------------------+---------+---------+
|     32 | Sunken Chest                     |       0 |       0 |
|     33 | Locked Chest                     |       0 |       0 |
|     38 | Captain Sanders Chest            |       0 |       0 |
|   1166 | Alexston's Chest                 |       0 |       0 |
|   1560 | Storage Chest                    |       0 |       0 |
|   1562 | Marshal Haggard's Chest          |       0 |       0 |
|   1765 | Worn Wooden Chest                |       0 |       0 |
|   2716 | Trelane's Chest                  |       0 |       0 |
|   2734 | Waterlogged Chest                |       0 |       0 |
|   2843 | Battered Chest                   |       0 |       0 |
|   2844 | Tattered Chest                   |       0 |       0 |
|   2845 | Tattered Chest                   |       0 |       0 |
|   2846 | Tattered Chest                   |       0 |       0 |
|   2847 | Tattered Chest                   |       0 |       0 |
|   2849 | Battered Chest                   |       0 |       0 |
|   2850 | Solid Chest                      |       0 |       0 |
|   2852 | Solid Chest                      |       0 |       0 |
|   2855 | Solid Chest                      |       0 |       0 |
|   2857 | Solid Chest                      |       0 |       0 |
|   3239 | Benedict's Chest                 |       0 |       0 |
|   3715 | Tattered Chest                   |       0 |       0 |
|   4096 | Tattered Chest                   |       0 |       0 |
|   4149 | Solid Chest                      |       0 |       0 |
|  13949 | Pitted Iron Chest                |       0 |       0 |
|  19021 | Rusty Chest                      |       0 |       0 |
|  19022 | Worn Chest                       |       0 |       0 |
|  28024 | Caravan Chest                    |       0 |       0 |
|  35251 | Karnitol's Chest                 |       0 |       0 |
|  37098 | Perrine's Chest                  |       0 |       0 |
|  50961 | Malem Chest                      |       0 |       0 |
|  58369 | Stolen Iron Chest                |       0 |       0 |
|  74447 | Large Iron Bound Chest           |       0 |       0 |
|  74448 | Large Solid Chest                |       0 |       0 |
|  75293 | Large Battered Chest             |       0 |       0 |
|  75295 | Large Iron Bound Chest           |       0 |       0 |
|  75296 | Large Iron Bound Chest           |       0 |       0 |
|  75297 | Large Iron Bound Chest           |       0 |       0 |
|  75298 | Large Solid Chest                |       0 |       0 |
|  75299 | Large Solid Chest                |       0 |       0 |
|  75300 | Large Solid Chest                |       0 |       0 |
|  92423 | Damaged Chest                    |       0 |       0 |
| 105578 | Tattered Chest                   |       0 |       0 |
| 105579 | Tattered Chest                   |       0 |       0 |
| 105581 | Tattered Chest                   |       0 |       0 |
| 106318 | Battered Chest                   |       0 |       0 |
| 106319 | Battered Chest                   |       0 |       0 |
| 111095 | Tattered Chest                   |       0 |       0 |
| 123214 | Duskwood Chest                   |       0 |       0 |
| 123329 | Baelog's Chest                   |       0 |       0 |
| 124072 | Duskwood Chest                   |       0 |       0 |
| 124388 | Garrett Family Chest             |       0 |       0 |
| 124389 | Krom Stoutarm's Chest            |       0 |       0 |
| 126260 | Ancient Chest                    |       0 |       0 |
| 131978 | Large Mithril Bound Chest        |       0 |       0 |
| 131979 | Large Darkwood Chest             |       0 |       0 |
| 141596 | Witch Doctor's Chest             |       0 |       0 |
| 142184 | Captain's Chest                  |       0 |       0 |
| 144054 | Shay's Chest                     |       0 |       0 |
| 144111 | Smite's Chest                    |       0 |       0 |
| 149036 | Marvon's Chest                   |       0 |       0 |
| 153451 | Solid Chest                      |       0 |       0 |
| 153453 | Solid Chest                      |       0 |       0 |
| 153454 | Solid Chest                      |       0 |       0 |
| 153462 | Large Solid Chest                |       0 |       0 |
| 153463 | Large Solid Chest                |       0 |       0 |
| 153464 | Large Solid Chest                |       0 |       0 |
| 153468 | Large Mithril Bound Chest        |       0 |       0 |
| 153469 | Large Mithril Bound Chest        |       0 |       0 |
| 164910 | Ornate Chest                     |       0 |       0 |
| 176225 | Arko'niran's Chest               |       0 |       0 |
| 176634 | Kerlonian's Chest                |       0 |       0 |
| 176944 | Old Treasure Chest               |       0 |       0 |
| 177544 | Joseph's Chest                   |       0 |       0 |
| 177786 | Rackmore's Chest                 |       0 |       0 |
| 178084 | Felix's Chest                    |       0 |       0 |
| 178144 | Troll Chest                      |       0 |       0 |
| 178464 | Dark Cleric Salem's Chest        |       0 |       0 |
| 178504 | Stolen Chest                     |       0 |       0 |
| 179345 | Deeprun Chest                    |       0 |       0 |
| 179516 | Fengus's Chest                   |       0 |       0 |
| 179545 | The Prince's Chest               |       0 |       0 |
| 179697 | Arena Treasure Chest             |       0 |       0 |
| 180024 | Mysterious Deadmines Chest       |       0 |       0 |
| 180055 | Mysterious Wailing Caverns Chest |       0 |       0 |
| 181238 | Dented Chest                     |       0 |       0 |
| 181239 | Worn Chest                       |       0 |       0 |
| 181366 | Four Horsemen Chest              |       0 |       0 |
| 181665 | Burial Chest                     |       0 |       0 |
| 181798 | Fel Iron Chest                   |       0 |       0 |
| 181800 | Heavy Fel Iron Chest             |       0 |       0 |
| 181802 | Adamantite Bound Chest           |       0 |       0 |
| 181804 | Felsteel Chest                   |       0 |       0 |
| 184304 | Locked Chest                     |       0 |       0 |
| 184716 | Coilskar Chest                   |       0 |       0 |
| 184740 | Wicker Chest                     |       0 |       0 |
| 184793 | Primitive Chest                  |       0 |       0 |
| 184930 | Solid Fel Iron Chest             |       0 |       0 |
| 184931 | Bound Fel Iron Chest             |       0 |       0 |
| 184932 | Bound Fel Iron Chest             |       0 |       0 |
| 184933 | Solid Fel Iron Chest             |       0 |       0 |
| 184934 | Bound Fel Iron Chest             |       0 |       0 |
| 184935 | Solid Fel Iron Chest             |       0 |       0 |
| 184936 | Bound Adamantite Chest           |       0 |       0 |
| 184937 | Solid Adamantite Chest           |       0 |       0 |
| 184938 | Bound Adamantite Chest           |       0 |       0 |
| 184939 | Solid Adamantite Chest           |       0 |       0 |
| 184940 | Bound Adamantite Chest           |       0 |       0 |
| 184941 | Solid Adamantite Chest           |       0 |       0 |
| 185119 | Dust Covered Chest               |       0 |       0 |
| 185168 | Reinforced Fel Iron Chest        |       0 |       0 |
| 185169 | Reinforced Fel Iron Chest        |       0 |       0 |
| 185220 | Massive Treasure Chest           |       0 |       0 |
| 185224 | Cabal Chest                      |       0 |       0 |
| 185225 | Cabal Chest                      |       0 |       0 |
| 185226 | Cabal Chest                      |       0 |       0 |
| 185503 | Barrow Chest                     |       0 |       0 |
| 185569 | Maggoc's Treasure Chest          |       0 |       0 |
| 186658 | Kraz's Chest                     |       0 |       0 |
| 187023 | Unlocked Chest                   |       0 |       0 |
| 187264 | Darkspine Ore Chest              |       0 |       0 |
| 187347 | Craig's Chest                    |       0 |       0 |
| 187892 | Ice Chest                        |       0 |       0 |
| 188192 | Ice Chest                        |       0 |       0 |
| 188518 | Gan'jo's Chest                   |       0 |       0 |
| 189298 | Cedar Chest                      |       0 |       0 |
| 190586 | Tribunal Chest                   |       0 |       0 |
| 190663 | Dark Runed Chest                 |       0 |       0 |
| 192918 | Brigg's Chest                    |       0 |       0 |
| 193426 | Four Horsemen Chest              |       0 |       0 |
| 193597 | Dark Runed Chest                 |       0 |       0 |
| 193996 | Tribunal Chest                   |       0 |       0 |
| 195665 | Argent Crusade Tribute Chest     |       0 |       0 |
| 195666 | Argent Crusade Tribute Chest     |       0 |       0 |
| 195667 | Argent Crusade Tribute Chest     |       0 |       0 |
| 195668 | Argent Crusade Tribute Chest     |       0 |       0 |
| 195669 | Argent Crusade Tribute Chest     |       0 |       0 |
| 195670 | Argent Crusade Tribute Chest     |       0 |       0 |
| 195671 | Argent Crusade Tribute Chest     |       0 |       0 |
| 195672 | Argent Crusade Tribute Chest     |       0 |       0 |
| 201710 | The Captain's Chest              |       0 |       0 |
| 202212 | The Captain's Chest              |       0 |       0 |
| 202336 | The Captain's Chest              |       0 |       0 |
| 202337 | The Captain's Chest              |       0 |       0 |
+--------+----------------------------------+---------+---------+

UltraNix commented 3 years ago

We need to parse this data from some source, e.g. wowhead

ntrna commented 3 years ago

I have also not found any uncommon or rarer BoEs in Solid Chests in particular.

Kitzunu commented 3 years ago

Use webarchives if you want to get that data from wowhead, so we get accurate 335 data

damnablebear commented 1 year ago

I don't know if this helps, but the video used as the source doesn't actually seem to show a Solid Chest giving money (which is what the ChromieCraft issue was opened for) - but this video does, at the timestamp indicated: https://www.youtube.com/live/BsDtxHvbwlo?si=IaEfBPXsuiC-AtVP&t=866

azerothcore / azerothcore-wotlk