General
| 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
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 | Shield |
| 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 |