Database

Alpha 0.5.3

Coarse Blasting Powder

Item

General

Item model

Field Value
entry 4364
class Trade_goods
display_id 6396
sell_price 4c
inventory_type 0: Cannot Equip
spellid_1 0

In-game view

Coarse Blasting Powder

Item icon

Trade_goods
Cannot Equip
Level 15

Buy price: 16c

Stackable: 20

Sold by (14)

1448 Neal Allen (limit 4) 1694 Loslor Rudge (limit 4) 2682 Fradd Swiftgear (limit 4) 2683 Namdo Bizzfizzle (limit 4) 2684 Rizz Loosebolt (limit 4) 2685 Mazk Snipeshot (limit 4) 2687 Gnaz Blunderflame (limit 4) 2688 [PH] Ruppo Zipcoil (limit 4) 3133 Herble Baubbletump (limit 4) 3413 Sovik (limit 4) 3495 Gagsprocket (limit 4) 4587 Elizabeth Van Talen (limit 4) 5175 Gearcutter Cogspinner (limit 4) 5519 Billibub Cogspinner (limit 4)

Item dropped by (31)

2520 Remote-Controlled Golem 100% 622 Goblin Engineer 5.26% 1731 Goblin Craftsman 5.09% 4070 Venture Co. Builder 5.04% 3992 Venture Co. Engineer 4.7% 4074 XT:9 4.28% 3471 Tinkerer Sniggles 4.13% 642 Sneed's Shredder 4% 3993 Venture Co. Machine Smith 2.11% 4073 XT:4 2.04% 458 Murloc Hunter 0.12% 3375 Bael'dun Foreman 0.08% 3374 Bael'dun Excavator 0.06% 4417 Defias Taskmaster 0.06% 3392 Prospector Khazgorm 0.06% 4418 Defias Wizard 0.04% 3947 Goblin Shipbuilder 0.04% 3286 Venture Co. Overseer 0.04% 3378 Bael'dun Officer 0.02% 3377 Bael'dun Rifleman 0.02% 3376 Bael'dun Soldier 0.02% 590 Defias Looter 0.02% 550 Defias Messenger 0.02% 589 Defias Pillager 0.02% 657 Defias Pirate 0.02% 4416 Defias Strip Miner 0.02% 641 Goblin Woodcarver 0.02% 517 Murloc Oracle 0.02% 127 Murloc Tidehunter 0.02% 171 Murloc Warrior 0.02% 3283 Venture Co. Enforcer 0.02%

Item is a reagent for spell (5)

3930 Heavy Shot 3931 Coarse Dynamite 3933 Small Seaforium Charge 3937 Large Copper Bomb 3941 Small Bronze Bomb

Item is produced by spell (1)

3929 Coarse Blasting Powder

Item details

UPDATE `item_template` SET `field` = xxxx WHERE (`entry` = 4364);
Field Value
entry 4364
class Trade_goods
subclass -1x
name Coarse Blasting Powder
description
display_id 6396
quality 1
flags None
buy_count 1
buy_price 16c
sell_price 4c
inventory_type 0: Cannot Equip
allowable_class -1
allowable_race -1
item_level 15
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 20
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 8
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