diff options
| author | Shauren <none@none> | 2010-08-04 10:34:30 +0200 |
|---|---|---|
| committer | Shauren <none@none> | 2010-08-04 10:34:30 +0200 |
| commit | b7d34dcb534a14098f1666bf6de38d9895642191 (patch) | |
| tree | 20e02e2ec035463ff8070277d69d665ab76bf104 /sql | |
| parent | 846aa122605e6862b3c0a58e2d741c379aa1a3ef (diff) | |
Cleaned up item flags: separated item proto flags and item field flags
Implemented use of:
ITEM_PROTO_FLAG_PROSPECTABLE and ITEM_PROTO_FLAG_MILLABLE now checked instead of bag family mask
ITEM_PROTO_FLAG_SMART_LOOT for profession recipes, player has to have skillline and not know the recipe
ITEM_PROTO_FLAG_OPENABLE item has to have it set to use item_loot_template
ITEM_PROTO_FLAG_NOT_USEABLE_IN_ARENA if this is set item can never be used in arena
ITEM_FLAG_UNLOCKED marks unlocked items
Simplified BoA check for mail sending
Stackable items are no longer refundable
Removed useless code that always set ITEM_FIELD_FLAGS equal to proto flags
Unlocking items (lockpicking) is now blizzlike
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/9160_characters_item_instance.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/9160_characters_item_instance.sql b/sql/updates/9160_characters_item_instance.sql new file mode 100644 index 00000000000..5ee6abc4082 --- /dev/null +++ b/sql/updates/9160_characters_item_instance.sql @@ -0,0 +1,3 @@ +SET @allowedFlags := 0x00000001 | 0x00000008 | 0x00000200 | 0x00001000 | 0x00008000 | 0x00010000; + +UPDATE `item_instance` SET `flags` = (`flags` & @allowedFlags); |