General
| Field | Value |
|---|---|
| entry | 1975 |
| class | Weapon |
| display_id | 1638 |
| sell_price | 57s 44c |
| inventory_type | 17: Two Handed Weapon |
| spellid_1 | 0 |
In-game view
Pysan's Old Greatsword
Weapon
Twohanded sword
Two Handed Weapon
Level 28 (Min 18)
58 – 79 Damage
Speed: 3.3
+6 Spirit
Buy price: 2g 87s 21c
Stackable: 1
Item dropped by (24)
4440
Razorfen Totemic
0.08%
4516
Death's Head Adept
0.06%
4522
Razorfen Dustweaver
0.06%
4525
Razorfen Earthbreaker
0.06%
4523
Razorfen Groundshaker
0.06%
4512
Rotting Agam'ar
0.06%
4538
Kraul Bat
0.04%
4514
Raging Agam'ar
0.04%
4532
Razorfen Beastmaster
0.04%
4442
Razorfen Defender
0.04%
4435
Razorfen Warrior
0.04%
4539
Greater Kraul Bat
0.03%
4427
Ward Guardian
0.03%
4519
Death's Head Seer
0.02%
4511
Agam'ar
0.02%
4515
Death's Head Acolyte
0.02%
4517
Death's Head Priest
0.02%
4518
Death's Head Sage
0.02%
4623
Quilguard Champion
0.02%
4531
Razorfen Beast Trainer
0.02%
4520
Razorfen Geomancer
0.02%
4530
Razorfen Handler
0.02%
4436
Razorfen Quilguard
0.02%
4437
Razorfen Warden
0.02%
Item details
UPDATE `item_template` SET `field`
= xxxx WHERE (`entry` = 1975);
| Field | Value |
|---|---|
| entry | 1975 |
| class | Weapon |
| subclass | Swordx |
| name | Pysan's Old Greatsword |
| description | |
| display_id | 1638 |
| quality | 3 |
| flags | None |
| buy_count | 1 |
| buy_price | 2g 87s 21c |
| sell_price | 57s 44c |
| inventory_type | 17: Two Handed Weapon |
| allowable_class | -1 |
| allowable_race | -1 |
| item_level | 28 |
| required_level | 18 |
| 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 | 6 |
| 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 | 3300 |
| range_mod | 0 |
| ammo_type | 0 |
| dmg_min1 | 58 |
| dmg_max1 | 79 |
| 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 | 1 |
| sheath | 1 |
| random_property | 0 |
| set_id | 0 |
| max_durability | 0 |
| area_bound | 0 |
| map_bound | 0 |
| duration | 0 |
| bag_family | 0 |
| disenchant_id | 42 |
| food_type | 0 |
| min_money_loot | 0 |
| max_money_loot | 0 |
| extra_flags | 0 |
| ignored | 0 |