General
| Field | Value |
|---|---|
| entry | 3857 |
| class | Trade_goods |
| display_id | 7340 |
| sell_price | 3s 75c |
| inventory_type | 0: Cannot Equip |
| spellid_1 | 0 |
In-game view
Coal
Trade_goods
Cannot Equip
Level 30
Buy price: 15s
Stackable: 10
Sold by (31)
790
Karen Taylor
960
Gunder Thornbush
989
Banalash
1148
Nerrist
1456
Kersok Prond
1690
Thrawn Boltar
2381
Micha Yance
2393
Christoph Jeffcoat
2810
Hammon Karwn
2821
Keena
2844
Hurklor
2847
Jansen Underwood
2999
Taur Stonehoof
3002
Kurm Stonehoof
3133
Herble Baubbletump
3167
Wuark
3356
Sumi
3358
Gorina
3367
Felika
3477
Hraq
3578
Dalaran Miner
3954
Dalria
3955
Shandrina
4256
Golnir Bouldertoe
4259
Thurgrum Deepforge
4597
Samuel Van Brunt
4599
Sarah Killian
4775
Felicia Doan
5411
Krinkle Goodsteel
5512
Kaita Deepforge
5514
Brooke Stonebraid
Item dropped by (20)
3578
Dalaran Miner
100%
2745
Ambassador Infernus
20.06%
2760
Burning Exile
18%
4038
Burning Destroyer
7.79%
4036
Rogue Flame Spirit
7.74%
4041
Scorched Basilisk
6.92%
4042
Singed Basilisk
6.56%
4035
Furious Stone Spirit
6.37%
4044
Blackened Basilisk
6.27%
4034
Enraged Stone Spirit
5.84%
4029
Blackened Ancient
5.71%
4027
Bloodfury Storm Witch
5.04%
4037
Burning Ravager
4.93%
4024
Bloodfury Slayer
4.92%
4023
Bloodfury Roguefeather
4.73%
4030
Vengeful Ancient
4.65%
4028
Charred Ancient
4.36%
4022
Bloodfury Harpy
4.06%
4026
Bloodfury Windcaller
4%
4025
Bloodfury Ambusher
3.73%
Item is a reagent for spell (1)
Item is a quest requirement (1)
3375
(not found)
Item details
UPDATE `item_template` SET `field`
= xxxx WHERE (`entry` = 3857);
| Field | Value |
|---|---|
| entry | 3857 |
| class | Trade_goods |
| subclass | -1x |
| name | Coal |
| description | |
| display_id | 7340 |
| quality | 1 |
| flags | None |
| buy_count | 1 |
| buy_price | 15s |
| sell_price | 3s 75c |
| inventory_type | 0: Cannot Equip |
| allowable_class | -1 |
| allowable_race | -1 |
| item_level | 30 |
| required_level | 0 |
| required_skill | 0: None |
| required_skill_rank | 0 |
| required_spell | 0 |
| required_honor_rank | 0 |
| required_city_rank | 0 |
| required_reputation_faction | 0 |
| required_reputation_rank | 0 |
| max_count | 0 |
| stackable | 10 |
| container_slots | 0 |
| stat_type1 | 0 |
| stat_value1 | 0 |
| stat_type2 | 0 |
| stat_value2 | 0 |
| stat_type3 | 0 |
| stat_value3 | 0 |
| stat_type4 | 0 |
| stat_value4 | 0 |
| stat_type5 | 0 |
| stat_value5 | 0 |
| stat_type6 | 0 |
| stat_value6 | 0 |
| stat_type7 | 0 |
| stat_value7 | 0 |
| stat_type8 | 0 |
| stat_value8 | 0 |
| stat_type9 | 0 |
| stat_value9 | 0 |
| stat_type10 | 0 |
| stat_value10 | 0 |
| delay | 0 |
| range_mod | 0 |
| ammo_type | 0 |
| dmg_min1 | 0 |
| dmg_max1 | 0 |
| dmg_type1 | 0 |
| dmg_min2 | 0 |
| dmg_max2 | 0 |
| dmg_type2 | 0 |
| dmg_min3 | 0 |
| dmg_max3 | 0 |
| dmg_type3 | 0 |
| dmg_min4 | 0 |
| dmg_max4 | 0 |
| dmg_type4 | 0 |
| dmg_min5 | 0 |
| dmg_max5 | 0 |
| dmg_type5 | 0 |
| block | 0 |
| armor | 0 |
| holy_res | 0 |
| fire_res | 0 |
| nature_res | 0 |
| frost_res | 0 |
| shadow_res | 0 |
| arcane_res | 0 |
| spellid_1 | 0 |
| spelltrigger_1 | 0 |
| spellcharges_1 | 0 |
| spellppmrate_1 | 0 |
| spellcooldown_1 | -1 |
| spellcategory_1 | 0 |
| spellcategorycooldown_1 | -1 |
| spellid_2 | 0 |
| spelltrigger_2 | 0 |
| spellcharges_2 | 0 |
| spellppmrate_2 | 0 |
| spellcooldown_2 | -1 |
| spellcategory_2 | 0 |
| spellcategorycooldown_2 | -1 |
| spellid_3 | 0 |
| spelltrigger_3 | 0 |
| spellcharges_3 | 0 |
| spellppmrate_3 | 0 |
| spellcooldown_3 | -1 |
| spellcategory_3 | 0 |
| spellcategorycooldown_3 | -1 |
| spellid_4 | 0 |
| spelltrigger_4 | 0 |
| spellcharges_4 | 0 |
| spellppmrate_4 | 0 |
| spellcooldown_4 | -1 |
| spellcategory_4 | 0 |
| spellcategorycooldown_4 | -1 |
| spellid_5 | 0 |
| spelltrigger_5 | 0 |
| spellcharges_5 | 0 |
| spellppmrate_5 | 0 |
| spellcooldown_5 | 0 |
| spellcategory_5 | 0 |
| spellcategorycooldown_5 | 0 |
| bonding | 0: No bind |
| page_text | 0 |
| page_language | 0 |
| page_material | 0 |
| start_quest | - |
| lock_id | 0 |
| material | 7 |
| sheath | 0 |
| random_property | 0 |
| set_id | 0 |
| max_durability | 0 |
| area_bound | 0 |
| map_bound | 0 |
| duration | 0 |
| bag_family | 0 |
| disenchant_id | 0 |
| food_type | 0 |
| min_money_loot | 0 |
| max_money_loot | 0 |
| extra_flags | 0 |
| ignored | 0 |