#340 Items DB update

items table

bPvpDesc added above name field, below id

  `bPvpDesc` tinyint(1) unsigned NOT NULL DEFAULT '0',

flags_32768 tinyint(3) unsigned -> CURSED_flags_32768 tinyint(1) unsigned

between infusable and usable

  `merc_only` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `mount_only` tinyint(1) unsigned NOT NULL DEFAULT '0',

set_name is gone, replaced with set_id

| set_name | varchar(250)

  `set_id` int(10) unsigned DEFAULT NULL,

collectable_unk added after collectable before adornment_slot1

  `collectable_unk` tinyint(3) unsigned NOT NULL DEFAULT '0',

new quest fields added after offers_quest_id before soe_autoquest_id

  `offers_quest_name` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
  `required_by_quest_name` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,

removed

quest_unknown            | tinyint(3) unsigned 

added after soe_item_crc before lua_script

  `soe_item_id_unsigned` int(10) unsigned NOT NULL DEFAULT '0',
  `soe_item_crc_unsigned` int(10) unsigned NOT NULL DEFAULT '0',

added after lua_script before harvest

  `transmuted_material` tinyint(1) unsigned NOT NULL DEFAULT '0',

additional unknown fields added:

  `footer_unk_61` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `footer_unk_7` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `header_oversized1` smallint(6) NOT NULL DEFAULT '0',
  `header_oversized2` smallint(6) NOT NULL DEFAULT '0',
  `header_bytes5` binary(5) NOT NULL DEFAULT '0\0\0\0\0',
  `header_bytes10` binary(10) NOT NULL DEFAULT '0\0\0\0\0\0\0\0\0\0',
  `header_unk19` int(10) unsigned NOT NULL DEFAULT '0',
  `header_ftr_type_unk` int(10) unsigned NOT NULL DEFAULT '0',

new tables:

item_details_achievement_profile
item_details_reward_crate
item_details_reward_crate_item
item_details_reward_voucher
item_itemset_bonus
item_mod_stats
item_mod_strings
item_pvp_link

removed table:

item_details_skills

Side note from investigating the items again, this was already broke but focus effects with type 6, still need to fix the mapping in AoM

tov_itemstat_conversion is not mapping well for AoM

if(client->GetVersion() >= 60085 && tmp_subtype > 10)

tmp_subtype += 1;

resolves a good number of them, but not all

still need these tables implemented:

item_details_reward_voucher
item_pvp_link
item_details_achievement_profile