2 files changed, 53 insertions, 0 deletions
diff --git a/app/models/character.rb b/app/models/character.rb
index ebda598..1e75b63 100644
--- a/app/models/character.rb
+++ b/app/models/character.rb
@@ -3,11 +3,14 @@ class Character < ApplicationRecord
   belongs_to :activity, optional: true
   has_many :character_items
   has_many :items, through: :character_items
+  has_many :character_skills
   validates :name, presence: true
   validates_length_of :name, maximum: 15, message: "can't be longer than 15 characters"
   validates_uniqueness_of :name, message: "is already being used"
   validates_format_of :name, with: /\A[a-z]+\z/i, message: "must consist of letters only"
 
+  after_create :create_skills
+
   def shift_item(gid, amount)
     CharacterItem.transaction do
       item = self.character_items.find_or_initialize_by(item: Item.find_by_gid(gid))
@@ -15,4 +18,9 @@ class Character < ApplicationRecord
       item.save
     end
   end
+
+  private
+    def create_skills
+      Skill.all.each { |skill| self.character_skills.create(skill: skill, xp: 0) }
+    end
 end
diff --git a/app/models/character_skill.rb b/app/models/character_skill.rb
new file mode 100644
index 0000000..189f386
--- /dev/null
+++ b/app/models/character_skill.rb
@@ -0,0 +1,45 @@
+class CharacterSkill < ApplicationRecord
+  belongs_to :character
+  belongs_to :skill
+  validates :skill_id, uniqueness: { scope: :character_id }
+  validates :xp, numericality: { greater_than_or_equal_to: 0, only_integer: true }
+
+  scope :ordered_by_skill_name, -> { includes(:skill).order("skills.name") }
+
+  XP_TOTALS_PER_LEVEL = [
+    0, 117, 436, 959, 1685, 2615, 3749, 5088, 6634, 8387, 10347, 12517, 14897,
+    17489, 20296, 23318, 26559, 30022, 33709, 37624, 41773, 46158, 50788,
+    55667, 60804, 66207, 71886, 77853, 84122, 90706, 97626, 104899, 112551,
+    120608, 129101, 138067, 147545, 157584, 168239, 179572, 191657, 204576,
+    218427, 233319, 249382, 266761, 285626, 306173, 328626, 353243, 380324,
+    410211, 443300, 480046, 520974, 566687, 617881, 675357, 740038, 812987,
+    895428, 988769, 1094635, 1214895, 1351701, 1507535, 1685252, 1888141,
+    2119991, 2385164, 2688687, 3036344, 3434803, 3891738, 4415991, 5017743,
+    5708720, 6502428, 7414420, 8462610, 9667629, 11053238, 12646801, 14479834,
+    16588636, 19015009, 21807100, 25020357, 28718640, 32975498, 37875637,
+    43516611, 50010775, 57487528, 66095898, 76007520, 87420069, 100561203,
+    115693120, 133117791, 153182996, 176289273, 202897924, 233540227,
+    268828058, 309466113, 356265990, 410162408, 472231880, 543714231,
+    626037362, 720845790, 830033503, 955781810, 1100602922, 1267390153,
+    1459475733, 1680697391, 1935475040, 2228899094
+  ].freeze
+
+  def level
+    XP_TOTALS_PER_LEVEL.each_with_index do |total, index|
+      return index if total > self.xp
+    end
+  end
+
+  def total_xp_for_next_level
+    xp_required_for_level(level + 1)
+  end
+
+  def xp_to_next_level
+    total_xp_for_next_level - self.xp
+  end
+
+  private
+    def xp_required_for_level(level)
+      level <= 120 ? XP_TOTALS_PER_LEVEL[level - 1] : nil
+    end
+end