The Green Tower

Item

General

Item model

Field Value
entry 1204
class Armor
display_id 1644
sell_price 1g 25s 77c
inventory_type 14: Shield
spellid_1 18097 (not found)

In-game view

The Green Tower

Item icon

Armor
Shield
Shield
Level 41 (Min 36)

+7 Spirit
+13 Stamina

420 Armor
25 Block
Casts:
18097 (not found)

Buy price: 6g 28s 86c

Stackable: 1

NPCs that drop this as reference loot (98)

2306 Baron Vardus 0% 1562 Bloodsail Mage 0% 1561 Bloodsail Raider 0% 1563 Bloodsail Swashbuckler 0% 1564 Bloodsail Warlock 0% 2944 Boss Tho'grun 0% 2571 Boulderfist Lord 0.01% 690 Cold Eye Basilisk 0% 813 Colonel Kurzen 0.01% 2287 Crushridge Warmonger 0.01% 2596 Daggerspine Sorceress 0% 769 Deathstrike Tarantula 0% 2715 Dustbelcher Brute 0% 2717 Dustbelcher Mauler 0% 2718 Dustbelcher Shaman 0% 2716 Dustbelcher Wyrmhunter 0% 2729 Elder Crag Coyote 0% 1557 Elder Mistvale Gorilla 0% 2791 Enraged Rock Elemental 0% 5429 Fire Roc 0% 4331 Firemane Ash Tail 0.01% 4329 Firemane Scout 0.01% 2611 Fozruk 0.01% 5300 Frayfeather Hippogryph 0% 2831 Giant Buzzard 0% 5419 Glasshide Basilisk 0% 5232 Gordunni Brute 0% 5229 Gordunni Ogre 0% 5237 Gordunni Ogre Mage 0% 5240 Gordunni Warlock 0% 2736 Greater Rock Elemental 0% 744 Green Scalebane 0.01% 742 Green Wyrmkin 0.01% 5335 Hatecrest Screamer 0% 5331 Hatecrest Warrior 0% 5332 Hatecrest Wave Rider 0% 2691 Highvale Outrunner 0% 5268 Ironfur Bear 0% 1551 Ironjaw Basilisk 0% 4863 Jadespine Basilisk 0.01% 687 Jungle Stalker 0% 4685 Ley Hunter 0% 5286 Longtooth Runner 0% 2423 Lord Aliden Perenolde 0% 2597 Lord Falconcrest 0.01% 2923 Mangy Silvermane 0% 2783 Marez Cowl 0.01% 750 Marsh Inkspewer 0% 747 Marsh Murloc 0% 678 Mosh'Ogg Mauler 0.01% 709 Mosh'Ogg Warmonger 0.01% 1907 Naga Explorer 0% 2320 Nagaz 0% 2734 Ridge Stalker Patriarch 0% 5428 Roc 0% 92 Rock Elemental 0% 5647 Sandfury Firecaller 0.01% 5648 Sandfury Shadowcaster 0.01% 1087 Sawtooth Snapper 0% 2725 Scalding Whelp 0% 745 Scalebane Captain 0.01% 4303 Scarlet Abbot 0.01% 4302 Scarlet Champion 0.01% 5422 Scorpid Hunter 0% 5423 Scorpid Tail Lasher 0% 4323 Searing Hatchling 0% 768 Shadow Panther 0% 2924 Silvermane Wolf 0% 696 Skullsplitter Axe Thrower 0% 669 Skullsplitter Hunter 0% 780 Skullsplitter Mystic 0% 782 Skullsplitter Scout 0% 667 Skullsplitter Warrior 0% 2544 Southern Sand Crawler 0% 5425 Starving Blisterpaw 0% 2893 Stonevault Bonesnapper 0% 4855 Stonevault Brawler 0.01% 2892 Stonevault Seer 0.01% 2894 Stonevault Shaman 0% 2585 Stromgarde Vindicator 0.01% 765 Swampwalker Elder 0% 2247 Syndicate Enforcer 0% 766 Tangled Horror 0% 2420 Targ 0.01% 1550 Thrashtail Basilisk 0% 2657 Trained Razorbeak 0% 674 Venture Co. Strip Miner 0% 2927 Vicious Owlbeast 0% 5618 Wastewander Bandit 0% 5617 Wastewander Shadow Mage 0% 5616 Wastewander Thief 0% 2651 Witherbark Hideskinner 0% 2649 Witherbark Scalper 0% 2650 Witherbark Zealot 0% 5253 Woodpaw Brute 0% 5249 Woodpaw Mongrel 0% 5254 Woodpaw Mystic 0% 5251 Woodpaw Trapper 0%

Item details

UPDATE `item_template` SET `field` = xxxx WHERE (`entry` = 1204);
Field Value
entry 1204
class Armor
subclass Bucklerx
name The Green Tower
description
display_id 1644
quality 4
flags None
buy_count 1
buy_price 6g 28s 86c
sell_price 1g 25s 77c
inventory_type 14: Shield
allowable_class -1
allowable_race -1
item_level 41
required_level 36
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 1
container_slots 0
stat_type1 6: Spirit
stat_value1 7
stat_type2 7: Stamina
stat_value2 13
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 25
armor 420
holy_res 0
fire_res 0
nature_res 0
frost_res 0
shadow_res 0
arcane_res 0
spellid_1 18097 (not found)
spelltrigger_1 1
spellcharges_1 0
spellppmrate_1 0
spellcooldown_1 0
spellcategory_1 0
spellcategorycooldown_1 0
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 1
sheath 4
random_property 0
set_id 0
max_durability 120
area_bound 0
map_bound 0
duration 0
bag_family 0
disenchant_id 61
food_type 0
min_money_loot 0
max_money_loot 0
extra_flags 0
ignored 0