#340 Items DB update

Open
3 jaren geleden werd geopend door image · 3 opmerkingen

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',
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', ```
image reageerde 3 jaren geleden
Medewerker

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
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 ```
image reageerde 3 jaren geleden
Medewerker

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

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
image reageerde 3 jaren geleden
Medewerker

still need these tables implemented:

item_details_reward_voucher
item_pvp_link
item_details_achievement_profile
still need these tables implemented: ``` item_details_reward_voucher item_pvp_link item_details_achievement_profile ```
Sign in to join this conversation.
Laden...
Annuleren
Opslaan
Er is nog geen inhoud.