gem 'wow_dbc'

require 'wow_dbc'

# Correct field names for the Item.dbc file
field_names = {
  id: :uint32,
  class: :uint32,
  subclass: :uint32,
  sound_override_subclass: :int32,
  material: :uint32,
  displayid: :uint32,
  inventory_type: :uint32,
  sheath_type: :uint32
}

# Open the Item.dbc file
dbc = WowDBC::DBCFile.new('path/to/your/Item.dbc', field_names)
dbc.read

# Find a specific item (e.g., Warglaive of Azzinoth, ID: 32837)
warglaive = dbc.find_by(:id, 32837).first
puts "Warglaive of Azzinoth: #{warglaive}"

# Update a single field of the Warglaive
dbc.update_record(warglaive[:id], :sheath_type, 3)  # Assuming 3 represents a different sheath type

# Update multiple fields of the Warglaive
dbc.update_record_multi(warglaive[:id], { material: 5, inventory_type: 17 })  # Assuming 5 is a different material and 17 is Two-Hand

# Create a new empty item record
new_item_index = dbc.create_record
puts "New empty item index: #{new_item_index}"

# Create a new item record with initial values
initial_values = {
  id: 99999,
  class: 2,  # Weapon
  subclass: 7,  # Warglaives
  sound_override_subclass: -1,  # No override
  material: warglaive[:material],
  displayid: warglaive[:displayid],
  inventory_type: 17,  # Two-Hand
  sheath_type: 3
}
new_item_index = dbc.create_record_with_values(initial_values)
puts "New custom item index: #{new_item_index}"

# Read the newly created item
new_item = dbc.get_record(new_item_index)
puts "Newly created item: #{new_item}"

# Delete an item (be careful with this!)
# dbc.delete_record(new_item_index)

# Write changes back to the same file(update)
dbc.write

# Write to a new file
dbc.write_to('path/to/your/NewItem.dbc')

# Reading header information
header = dbc.header
puts "Total items: #{header[:record_count]}"
puts "Fields per item: #{header[:field_count]}"

# Finding all two-handed weapons
two_handed_weapons = dbc.find_by(:inventory_type, 17)  # 17 represents Two-Hand weapons

puts 'Two-handed weapons:'
two_handed_weapons.each do |item|
  puts "Item ID: #{item[:id]}, Class: #{item[:class]}, Subclass: #{item[:subclass]}, Display ID: #{item[:displayid]}"
end