Compare commits

..

6 commits

Author SHA1 Message Date
b03d5e6618
Fix error in weapons (#199) 2025-03-30 21:08:04 -07:00
309a499446
Merge pull request #198 from jedmund/jedmund/202503-legfest
Adds items from the March 2025 Legend Festival/Event
2025-03-30 21:05:39 -07:00
832bf86d47 New items from March Legfest and Scenario Event 2025-03-31 00:02:25 -04:00
65a58d8b4c
Merge pull request #197 from jedmund/jedmund/20250327-new-items
Add new items from March 2025
2025-03-26 22:44:36 -07:00
92de40bbbf Add columns for Classic II and Collab Gacha 2025-03-27 01:37:53 -04:00
aaa046c01f Add new items 2025-03-27 01:37:42 -04:00
29 changed files with 519 additions and 796 deletions

View file

@ -34,16 +34,6 @@ class Character < ApplicationRecord
}
}
has_many :character_skills,
primary_key: 'granblue_id',
foreign_key: 'character_granblue_id'
has_many :skills,
through: :character_skills
has_many :charge_attacks,
-> { where(owner_type: 'character') },
primary_key: 'granblue_id',
foreign_key: 'owner_id'
AWAKENINGS = [
{ slug: 'character-balanced', name_en: 'Balanced', name_jp: 'バランス', order: 0 },
{ slug: 'character-atk', name_en: 'Attack', name_jp: '攻撃', order: 1 },

View file

@ -1,15 +0,0 @@
# frozen_string_literal: true
class CharacterSkill < ApplicationRecord
belongs_to :skill
belongs_to :alt_skill, class_name: 'Skill', optional: true
belongs_to :character, primary_key: 'granblue_id', foreign_key: 'character_granblue_id', optional: true
validates :character_granblue_id, presence: true
validates :position, presence: true
validates :position, uniqueness: { scope: %i[character_granblue_id unlock_level] }
scope :by_position, ->(position) { where(position: position) }
scope :unlocked_at, ->(level) { where('unlock_level <= ?', level) }
scope :improved_at, ->(level) { where('improve_level <= ?', level) }
end

View file

@ -1,14 +0,0 @@
# frozen_string_literal: true
class ChargeAttack < ApplicationRecord
belongs_to :skill
belongs_to :alt_skill, class_name: 'Skill', optional: true
validates :owner_id, presence: true
validates :owner_type, presence: true
validates :uncap_level, uniqueness: { scope: %i[owner_id owner_type] }
scope :for_character, -> { where(owner_type: 'character') }
scope :for_weapon, -> { where(owner_type: 'weapon') }
scope :by_uncap_level, ->(level) { where(uncap_level: level) }
end

View file

@ -1,16 +0,0 @@
# frozen_string_literal: true
class Effect < ApplicationRecord
belongs_to :effect_family, class_name: 'Effect', optional: true
has_many :child_effects, class_name: 'Effect', foreign_key: 'effect_family_id'
has_many :skill_effects
has_many :skills, through: :skill_effects
validates :name_en, presence: true
validates :effect_type, presence: true
enum effect_type: { buff: 1, debuff: 2, special: 3 }
scope :by_class, ->(effect_class) { where(effect_class: effect_class) }
scope :stackable, -> { where(stackable: true) }
end

View file

@ -1,24 +0,0 @@
# frozen_string_literal: true
class Skill < ApplicationRecord
has_many :skill_values
has_many :skill_effects
has_many :effects, through: :skill_effects
has_many :character_skills
has_many :weapon_skills
has_many :summon_calls
has_many :charge_attacks
has_many :alt_character_skills, class_name: 'CharacterSkill', foreign_key: 'alt_skill_id'
has_many :alt_summon_calls, class_name: 'SummonCall', foreign_key: 'alt_skill_id'
has_many :alt_charge_attacks, class_name: 'ChargeAttack', foreign_key: 'alt_skill_id'
validates :name_en, presence: true
validates :skill_type, presence: true
enum skill_type: { character: 1, weapon: 2, summon_call: 3, charge_attack: 4 }
enum border_type: { damage: 1, healing: 2, buff: 3, debuff: 4, field: 5 }
def value_at_level(level)
skill_values.find_by(level: level)
end
end

View file

@ -1,17 +0,0 @@
# frozen_string_literal: true
class SkillEffect < ApplicationRecord
belongs_to :skill
belongs_to :effect
validates :target_type, presence: true
validates :duration_type, presence: true
enum target_type: { self: 1, ally: 2, all_allies: 3, enemy: 4, all_enemies: 5 }
enum duration_type: { turns: 1, seconds: 2, indefinite: 3, one_time: 4 }
scope :local, -> { where(local: true) }
scope :global, -> { where(local: false) }
scope :permanent, -> { where(permanent: true) }
scope :undispellable, -> { where(undispellable: true) }
end

View file

@ -1,7 +0,0 @@
# frozen_string_literal: true
class SkillValue < ApplicationRecord
belongs_to :skill
validates :level, presence: true, uniqueness: { scope: :skill_id }
end

View file

@ -34,15 +34,6 @@ class Summon < ApplicationRecord
}
}
has_many :summon_calls,
primary_key: 'granblue_id',
foreign_key: 'summon_granblue_id'
has_many :summon_auras,
primary_key: 'granblue_id',
foreign_key: 'summon_granblue_id'
has_many :skills,
through: :summon_calls
def blueprint
SummonBlueprint
end

View file

@ -1,14 +0,0 @@
# frozen_string_literal.rb
class SummonAura < ApplicationRecord
belongs_to :summon, primary_key: 'granblue_id', foreign_key: 'summon_granblue_id', optional: true
validates :summon_granblue_id, presence: true
validates :aura_type, presence: true
validates :aura_type, uniqueness: { scope: %i[summon_granblue_id uncap_level] }
enum aura_type: { main: 1, sub: 2 }
enum boost_type: { weapon_skill: 1, elemental: 2, stat: 3 }
scope :by_uncap_level, ->(level) { where(uncap_level: level) }
end

View file

@ -1,12 +0,0 @@
# frozen_string_literal: true
class SummonCall < ApplicationRecord
belongs_to :skill
belongs_to :alt_skill, class_name: 'Skill', optional: true
belongs_to :summon, primary_key: 'granblue_id', foreign_key: 'summon_granblue_id', optional: true
validates :summon_granblue_id, presence: true
validates :uncap_level, uniqueness: { scope: :summon_granblue_id }
scope :by_uncap_level, ->(level) { where(uncap_level: level) }
end

View file

@ -36,15 +36,6 @@ class Weapon < ApplicationRecord
has_many :weapon_awakenings
has_many :awakenings, through: :weapon_awakenings
has_many :weapon_skills,
primary_key: 'granblue_id',
foreign_key: 'weapon_granblue_id'
has_many :skills,
through: :weapon_skills
has_many :charge_attacks,
-> { where(owner_type: 'weapon') },
primary_key: 'granblue_id',
foreign_key: 'owner_id'
SERIES_SLUGS = {
1 => 'seraphic',

View file

@ -1,15 +0,0 @@
# frozen_string_literal: true
class WeaponSkill < ApplicationRecord
belongs_to :skill
belongs_to :weapon, primary_key: 'granblue_id', foreign_key: 'weapon_granblue_id', optional: true
validates :weapon_granblue_id, presence: true
validates :position, presence: true
validates :position, uniqueness: { scope: %i[weapon_granblue_id unlock_level] }
scope :by_position, ->(position) { where(position: position) }
scope :unlocked_at, ->(level) { where('unlock_level <= ?', level) }
scope :by_series, ->(series) { where(skill_series: series) }
scope :by_modifier, ->(modifier) { where(skill_modifier: modifier) }
end

View file

@ -1,21 +0,0 @@
class CreateEffects < ActiveRecord::Migration[8.0]
def change
create_table :effects, id: :uuid do |t|
t.string :name_en, null: false
t.string :name_jp
t.text :description_en
t.text :description_jp
t.string :icon_path
t.integer :effect_type, null: false # 1=buff, 2=debuff, 3=special
t.string :effect_class # classification (cant_act, burn, poison)
t.uuid :effect_family_id # no foreign key here
t.boolean :stackable, default: false
t.timestamps null: false
end
add_foreign_key :effects, :effects, column: :effect_family_id
add_index :effects, :effect_class
add_index :effects, :name_en
end
end

View file

@ -1,17 +0,0 @@
class CreateSkills < ActiveRecord::Migration[8.0]
def change
create_table :skills, id: :uuid do |t|
t.string :name_en, null: false
t.string :name_jp
t.text :description_en
t.text :description_jp
t.integer :border_type # 1=red(dmg), 2=green(heal), 3=yellow(buff), 4=blue(debuff), 5=purple(field)
t.integer :cooldown
t.integer :skill_type # 1=character, 2=weapon, 3=summon call, 4=charge attack
t.timestamps null: false
end
add_index :skills, :name_en
add_index :skills, :skill_type
end
end

View file

@ -1,14 +0,0 @@
class CreateSkillValues < ActiveRecord::Migration[8.0]
def change
create_table :skill_values, id: :uuid do |t|
t.references :skill, type: :uuid, null: false
t.integer :level, null: false, default: 1 # skill level or uncap level
t.decimal :value # numeric value for multiplier
t.string :text_value # text description for non-numeric values
t.timestamps null: false
end
add_foreign_key :skill_values, :skills
add_index :skill_values, %i[skill_id level], unique: true
end
end

View file

@ -1,23 +0,0 @@
class CreateSkillEffects < ActiveRecord::Migration[8.0]
def change
create_table :skill_effects, id: :uuid do |t|
t.references :skill, type: :uuid, null: false
t.references :effect, type: :uuid, null: false
t.integer :target_type # 1=self, 2=ally, 3=all allies, 4=enemy, 5=all enemies
t.integer :duration_type # 1=turns, 2=seconds, 3=indefinite, 4=one-time
t.integer :duration_value # number of turns/seconds if applicable
t.text :condition # condition text
t.integer :chance # percentage chance to apply
t.decimal :value # value for effect if applicable
t.decimal :cap # cap for effect if applicable
t.boolean :local, default: true # local vs global effect
t.boolean :permanent, default: false # permanent
t.boolean :undispellable, default: false # can't be dispelled
t.timestamps null: false
end
add_foreign_key :skill_effects, :skills, name: 'fk_skill_effects_skills'
add_foreign_key :skill_effects, :effects, name: 'fk_skill_effects_effects'
add_index :skill_effects, %i[skill_id effect_id target_type]
end
end

View file

@ -1,19 +0,0 @@
class CreateCharacterSkills < ActiveRecord::Migration[8.0]
def change
create_table :character_skills, id: :uuid do |t|
t.string :character_granblue_id, null: false
t.references :skill, type: :uuid, null: false
t.integer :position, null: false # 1, 2, 3, 4 for skill slots
t.integer :unlock_level # level when skill unlocked
t.integer :improve_level # level when skill improved (+)
t.references :alt_skill, type: :uuid
t.text :alt_condition # condition for alt version
t.timestamps null: false
end
add_foreign_key :character_skills, :skills
add_foreign_key :character_skills, :skills, column: :alt_skill_id
add_index :character_skills, %i[character_granblue_id position]
add_index :character_skills, :character_granblue_id
end
end

View file

@ -1,19 +0,0 @@
class CreateWeaponSkills < ActiveRecord::Migration[8.0]
def change
create_table :weapon_skills, id: :uuid do |t|
t.string :weapon_granblue_id, null: false
t.references :skill, type: :uuid, null: false
t.integer :position, null: false # 1, 2, 3 for skill slots
t.string :skill_modifier # Modifier like "Might", "Majesty"
t.string :skill_series # Series like "Ironflame", "Hoarfrost"
t.string :skill_size # Size like "Small", "Medium", "Big", "Massive"
t.integer :unlock_level # level when skill unlocked
t.timestamps null: false
end
add_foreign_key :weapon_skills, :skills
add_index :weapon_skills, %i[weapon_granblue_id position]
add_index :weapon_skills, :weapon_granblue_id
add_index :weapon_skills, :skill_series
end
end

View file

@ -1,18 +0,0 @@
class CreateSummonAuras < ActiveRecord::Migration[8.0]
def change
create_table :summon_auras, id: :uuid do |t|
t.string :summon_granblue_id, null: false
t.text :description_en
t.text :description_jp
t.integer :aura_type # 1=main, 2=sub
t.integer :boost_type # 1=weapon skill, 2=elemental, 3=stat
t.string :boost_target # what is being boosted
t.decimal :boost_value # percentage value
t.integer :uncap_level # 0, 3, 4, 5 for uncap level
t.text :condition # any conditions
t.timestamps null: false
end
add_index :summon_auras, %i[summon_granblue_id aura_type uncap_level]
add_index :summon_auras, :summon_granblue_id
end
end

View file

@ -1,18 +0,0 @@
class CreateSummonCalls < ActiveRecord::Migration[8.0]
def change
create_table :summon_calls, id: :uuid do |t|
t.string :summon_granblue_id, null: false
t.references :skill, type: :uuid, null: false
t.integer :cooldown
t.integer :uncap_level # 0, 3, 4, 5 for uncap level
t.references :alt_skill, type: :uuid
t.text :alt_condition # condition for alt version
t.timestamps null: false
end
add_foreign_key :summon_calls, :skills
add_foreign_key :summon_calls, :skills, column: :alt_skill_id
add_index :summon_calls, %i[summon_granblue_id uncap_level]
add_index :summon_calls, :summon_granblue_id
end
end

View file

@ -1,17 +0,0 @@
class CreateChargeAttacks < ActiveRecord::Migration[8.0]
def change
create_table :charge_attacks, id: :uuid do |t|
t.string :owner_id, null: false # can be character_granblue_id or weapon_granblue_id
t.string :owner_type, null: false # "character" or "weapon"
t.references :skill, type: :uuid, null: false
t.integer :uncap_level # 0, 3, 4, 5 for uncap level
t.references :alt_skill, type: :uuid
t.text :alt_condition # condition for alt version
t.timestamps null: false
end
add_foreign_key :charge_attacks, :skills
add_foreign_key :charge_attacks, :skills, column: :alt_skill_id
add_index :charge_attacks, %i[owner_type owner_id uncap_level]
end
end

View file

@ -0,0 +1,6 @@
class AddClassicIiAndCollabToGacha < ActiveRecord::Migration[8.0]
def change
add_column :gacha, :classic_ii, :boolean, default: false
add_column :gacha, :collab, :boolean, default: false
end
end

File diff suppressed because it is too large Load diff

View file

@ -0,0 +1,7 @@
name_en,name_jp,granblue_id,rarity,element,series,flb,ulb,max_level,min_hp,max_hp,max_hp_flb,max_hp_ulb,min_atk,max_atk,max_atk_flb,max_atk_ulb,subaura,limit,transcendence,max_atk_xlb,max_hp_xlb,summon_id,release_date,flb_date,ulb_date,wiki_en,wiki_ja,gamewith,kamigame,transcendence_date,nicknames_en,nicknames_jp
,,2040361000,,,,true,,,,,,,,,,,,,,,,,,2025-03-10,,,,,,,,
,,2040363000,,,,true,,,,,,,,,,,,,,,,,,2025-03-10,,,,,,,,
,,2040368000,,,,true,,,,,,,,,,,,,,,,,,2025-03-10,,,,,,,,
,,2040366000,,,,true,,,,,,,,,,,,,,,,,,2025-03-10,,,,,,,,
,,2040381000,,,,true,,,,,,,,,,,,,,,,,,2025-03-10,,,,,,,,
,,2040385000,,,,true,,,,,,,,,,,,,,,,,,2025-03-10,,,,,,,,
1 name_en name_jp granblue_id rarity element series flb ulb max_level min_hp max_hp max_hp_flb max_hp_ulb min_atk max_atk max_atk_flb max_atk_ulb subaura limit transcendence max_atk_xlb max_hp_xlb summon_id release_date flb_date ulb_date wiki_en wiki_ja gamewith kamigame transcendence_date nicknames_en nicknames_jp
2 2040361000 true 2025-03-10
3 2040363000 true 2025-03-10
4 2040368000 true 2025-03-10
5 2040366000 true 2025-03-10
6 2040381000 true 2025-03-10
7 2040385000 true 2025-03-10

View file

@ -0,0 +1,5 @@
name_en,name_jp,granblue_id,rarity,element,proficiency1,proficiency2,gender,race1,race2,flb,min_hp,max_hp,max_hp_flb,min_atk,max_atk,max_atk_flb,base_da,base_ta,ougi_ratio,ougi_ratio_flb,special,ulb,max_hp_ulb,max_atk_ulb,character_id,wiki_en,release_date,flb_date,ulb_date,wiki_ja,gamewith,kamigame,nicknames_en,nicknames_jp
Basara (Grand),バサラ (リミテッドver),3040582000,3,6,10,7,1,2,,false,192,1128,,1740,8760,,,,,,false,false,,,{3271},Basara,2025-03-17,,,バサラ (SSR)リミテッドバージョン,489323,SSRバサラ,,
Mahira (Summer),マキラ(水着ver),3040584000,3,1,8,7,2,3,,false,281,1217,,1408,8915,,,,,,false,false,,,{3073},Mahira (Summer),2025-03-17,,,マキラ (SSR)水着バージョン,489328,SSR水着マキラ,,
Lu Woh (Summer),ル・オー(水着ver),3040583000,3,4,7,6,0,2,,false,236,1172,,1385,7820,,,,,,false,false,,,{3221},Lu Woh (Summer),2025-03-17,,,ル・オー (SSR)水着バージョン,490119,SSR水着ルオー,,
Joy (Event SSR),ジョイ(イベントSSR),3040588000,3,1,7,5,0,0,,false,108,1080,,1711,9011,,,,,,false,false,,,{2146},Joy (Event SSR),2025-03-11,,,ジョイ (SSR),489593,SSRジョイ,,
1 name_en name_jp granblue_id rarity element proficiency1 proficiency2 gender race1 race2 flb min_hp max_hp max_hp_flb min_atk max_atk max_atk_flb base_da base_ta ougi_ratio ougi_ratio_flb special ulb max_hp_ulb max_atk_ulb character_id wiki_en release_date flb_date ulb_date wiki_ja gamewith kamigame nicknames_en nicknames_jp
2 Basara (Grand) バサラ (リミテッドver) 3040582000 3 6 10 7 1 2 false 192 1128 1740 8760 false false {3271} Basara 2025-03-17 バサラ (SSR)リミテッドバージョン 489323 SSRバサラ
3 Mahira (Summer) マキラ(水着ver) 3040584000 3 1 8 7 2 3 false 281 1217 1408 8915 false false {3073} Mahira (Summer) 2025-03-17 マキラ (SSR)水着バージョン 489328 SSR水着マキラ
4 Lu Woh (Summer) ル・オー(水着ver) 3040583000 3 4 7 6 0 2 false 236 1172 1385 7820 false false {3221} Lu Woh (Summer) 2025-03-17 ル・オー (SSR)水着バージョン 490119 SSR水着ルオー
5 Joy (Event SSR) ジョイ(イベントSSR) 3040588000 3 1 7 5 0 0 false 108 1080 1711 9011 false false {2146} Joy (Event SSR) 2025-03-11 ジョイ (SSR) 489593 SSRジョイ

View file

@ -0,0 +1,8 @@
name_en,name_jp,granblue_id,rarity,element,proficiency,series,flb,ulb,max_level,max_skill_level,min_hp,max_hp,max_hp_flb,max_hp_ulb,min_atk,max_atk,max_atk_flb,max_atk_ulb,extra,ax_type,limit,ax,recruits,max_awakening_level,release_date,flb_date,ulb_date,wiki_en,wiki_ja,gamewith,kamigame,nicknames_en,nicknames_jp,transcendence,transcendence_date, , , , , , , , , , , , ,
Canifortis,天干地支刀・戌之威,1040917200,3,6,10,2,true,false,150,15,38,215,259,,474,2895,3500,,false,,false,false,3040582000,,2025-03-17,2025-03-17,,Canifortis,天干地支刀・戌之威 (SSR),490121,天干地支刀・戌之威,,,false,,,,,,,,,,,,,,
Tenth Crow of the Clutch,第十酉行筒,1040517200,3,1,9,99,false,false,100,10,33,196,,,434,2606,,,false,,false,false,3040584000,,2025-03-17,,,Tenth Crow of the Clutch,第十酉行筒 (SSR),490124,第十酉行筒,,,false,,,,,,,,,,,,,,
Lu Woh Float,ル・オー・フロート,1040817100,3,4,8,99,false,false,100,10,51,303,,,344,2073,,,false,,false,false,3040583000,,2025-03-17,,,Lu Woh Float,ル・オー・フロート (SSR),490125,ル・オー・フロート,,,false,,,,,,,,,,,,,,
Exo Heliocentrum,神杖エクス・ヘリオセント,1040424300,3,6,6,39,true,false,150,15,41,260,315,,333,2029,2453,,false,,false,false,,,2025-03-22,2025-03-22,,Exo Heliocentrum,神杖エクス・ヘリオセント (SSR),490430,神杖エクス・ヘリオセント,,,false,,,,,,,,,,,,,,
Onmyoji's Reito,陰陽之霊刀,1040917300,3,0,10,19,true,true,200,20,35,,,281,430,,,3856,false,,false,false,,,2025-03-25,2025-03-25,2025-03-25,Onmyoji%27s_Reito,陰陽之霊刀 (SSR),490757,陰陽之霊刀,,,false,,,,,,,,,,,,,,
Ouranosphaira Ravdos,ウラニアスフェラ・ラヴドス,1040424400,3,0,6,19,true,true,200,20,44,,,371,379,,,3390,false,,false,false,,,2025-03-25,2025-03-25,2025-03-25,Ouranosphaira Ravdos,ウラニアスフェラ・ラヴドス (SSR),490756,ウラニアスフェラ・ラヴドス,,,false,,,,,,,,,,,,,,
Cometa Sica,コメーテス・シーカ,1040121300,3,0,2,19,true,true,200,20,43,,,397,384,,,3251,false,,false,false,,,2025-03-25,2025-03-25,2025-03-25,Cometa Sica,コメーテス・シーカ (SSR),490753,コメーテス・シーカ,,,false,,,,,,,,,,,,,,
1 name_en name_jp granblue_id rarity element proficiency series flb ulb max_level max_skill_level min_hp max_hp max_hp_flb max_hp_ulb min_atk max_atk max_atk_flb max_atk_ulb extra ax_type limit ax recruits max_awakening_level release_date flb_date ulb_date wiki_en wiki_ja gamewith kamigame nicknames_en nicknames_jp transcendence transcendence_date
2 Canifortis 天干地支刀・戌之威 1040917200 3 6 10 2 true false 150 15 38 215 259 474 2895 3500 false false false 3040582000 2025-03-17 2025-03-17 Canifortis 天干地支刀・戌之威 (SSR) 490121 天干地支刀・戌之威 false
3 Tenth Crow of the Clutch 第十酉行筒 1040517200 3 1 9 99 false false 100 10 33 196 434 2606 false false false 3040584000 2025-03-17 Tenth Crow of the Clutch 第十酉行筒 (SSR) 490124 第十酉行筒 false
4 Lu Woh Float ル・オー・フロート 1040817100 3 4 8 99 false false 100 10 51 303 344 2073 false false false 3040583000 2025-03-17 Lu Woh Float ル・オー・フロート (SSR) 490125 ル・オー・フロート false
5 Exo Heliocentrum 神杖エクス・ヘリオセント 1040424300 3 6 6 39 true false 150 15 41 260 315 333 2029 2453 false false false 2025-03-22 2025-03-22 Exo Heliocentrum 神杖エクス・ヘリオセント (SSR) 490430 神杖エクス・ヘリオセント false
6 Onmyoji's Reito 陰陽之霊刀 1040917300 3 0 10 19 true true 200 20 35 281 430 3856 false false false 2025-03-25 2025-03-25 2025-03-25 Onmyoji%27s_Reito 陰陽之霊刀 (SSR) 490757 陰陽之霊刀 false
7 Ouranosphaira Ravdos ウラニアスフェラ・ラヴドス 1040424400 3 0 6 19 true true 200 20 44 371 379 3390 false false false 2025-03-25 2025-03-25 2025-03-25 Ouranosphaira Ravdos ウラニアスフェラ・ラヴドス (SSR) 490756 ウラニアスフェラ・ラヴドス false
8 Cometa Sica コメーテス・シーカ 1040121300 3 0 2 19 true true 200 20 43 397 384 3251 false false false 2025-03-25 2025-03-25 2025-03-25 Cometa Sica コメーテス・シーカ (SSR) 490753 コメーテス・シーカ false

View file

@ -0,0 +1,16 @@
name_en,name_jp,granblue_id,rarity,element,proficiency,series,flb,ulb,max_level,max_skill_level,min_hp,max_hp,max_hp_flb,max_hp_ulb,min_atk,max_atk,max_atk_flb,max_atk_ulb,extra,ax_type,limit,ax,recruits,max_awakening_level,release_date,flb_date,ulb_date,wiki_en,wiki_ja,gamewith,kamigame,nicknames_en,nicknames_jp,transcendence,transcendence_date, , , , , , , , , , , , ,
,,1040022600,,,,,true,,150,15,,,221,,,,2603,,,,,,,,,2025-03-14,,,,,,,,,,,,,,,,,,,,,,
,,1040216800,,,,,true,,150,15,,,264,,,,2380,,,,,,,,,2025-03-14,,,,,,,,,,,,,,,,,,,,,,
,,1040618900,,,,,true,,150,15,,,297,,,,2854,,,,,,,,,2025-03-10,,,,,,,,,,,,,,,,,,,,,,
,,1040713700,,,,,true,,150,15,,,270,,,,3048,,,,,,,,,2025-03-10,,,,,,,,,,,,,,,,,,,,,,
,,1040423400,,,,,true,,150,15,,,354,,,,2568,,,,,,,,,2025-03-10,,,,,,,,,,,,,,,,,,,,,,
,,1040916600,,,,,true,,150,15,,,247,,,,3125,,,,,,,,,2025-03-10,,,,,,,,,,,,,,,,,,,,,,
,,1040119100,,,,,true,,150,15,,,278,,,,2943,,,,,,,,,2025-03-10,,,,,,,,,,,,,,,,,,,,,,
,,1040518000,,,,,true,,150,15,,,213,,,,3267,,,,,,,,,2025-03-10,,,,,,,,,,,,,,,,,,,,,,
,,1040617200,,,,,true,,150,15,,,302,,,,2828,,,,,,,,,2025-03-10,,,,,,,,,,,,,,,,,,,,,,
,,1040916400,,,,,true,,150,15,,,214,,,,3288,,,,,,,,,2025-03-10,,,,,,,,,,,,,,,,,,,,,,
,,1040119600,,,,,true,,150,15,,,291,,,,2879,,,,,,,,,2025-03-10,,,,,,,,,,,,,,,,,,,,,,
,,1040816900,,,,,true,,150,15,,,335,,,,2659,,,,,,,,,2025-03-10,,,,,,,,,,,,,,,,,,,,,,
,,1040026000,,,,,true,,150,15,,,302,,,,2821,,,,,,,,,2025-03-10,,,,,,,,,,,,,,,,,,,,,,
,,1040816800,,,,,true,,150,15,,,366,,,,2507,,,,,,,,,2025-03-10,,,,,,,,,,,,,,,,,,,,,,
Decorus Sicarius,,1040121100,,,,,,,,,,,,,,,,,,,,,,,,,,Decorus Sicarius,,,,,,,,,,,,,,,,,,,,
1 name_en name_jp granblue_id rarity element proficiency series flb ulb max_level max_skill_level min_hp max_hp max_hp_flb max_hp_ulb min_atk max_atk max_atk_flb max_atk_ulb extra ax_type limit ax recruits max_awakening_level release_date flb_date ulb_date wiki_en wiki_ja gamewith kamigame nicknames_en nicknames_jp transcendence transcendence_date
2 1040022600 true 150 15 221 2603 2025-03-14
3 1040216800 true 150 15 264 2380 2025-03-14
4 1040618900 true 150 15 297 2854 2025-03-10
5 1040713700 true 150 15 270 3048 2025-03-10
6 1040423400 true 150 15 354 2568 2025-03-10
7 1040916600 true 150 15 247 3125 2025-03-10
8 1040119100 true 150 15 278 2943 2025-03-10
9 1040518000 true 150 15 213 3267 2025-03-10
10 1040617200 true 150 15 302 2828 2025-03-10
11 1040916400 true 150 15 214 3288 2025-03-10
12 1040119600 true 150 15 291 2879 2025-03-10
13 1040816900 true 150 15 335 2659 2025-03-10
14 1040026000 true 150 15 302 2821 2025-03-10
15 1040816800 true 150 15 366 2507 2025-03-10
16 Decorus Sicarius 1040121100 Decorus Sicarius

View file

@ -0,0 +1,4 @@
name_en,name_jp,granblue_id,rarity,element,proficiency1,proficiency2,gender,race1,race2,flb,min_hp,max_hp,max_hp_flb,min_atk,max_atk,max_atk_flb,base_da,base_ta,ougi_ratio,ougi_ratio_flb,special,ulb,max_hp_ulb,max_atk_ulb,character_id,wiki_en,release_date,flb_date,ulb_date,wiki_ja,gamewith,kamigame,nicknames_en,nicknames_jp
Seofon (Yukata),シエテ(浴衣ver),3040586000,3,5,1,10,1,1,,false,277,1277,,1777,9777,,,,,,false,false,,,{4007},Seofon (Yukata),2025-03-30,,,シエテ (SSR)浴衣バージョン,489325,SSR浴衣シエテ,,
Vikala (Yukata),ビカラ(浴衣ver),3040585000,3,6,3,7,2,1,,false,280,1550,,1600,8250,,,,,,false,false,,,{3150},Vikala (Yukata),2025-03-30,,,ビカラ (SSR)浴衣バージョン,491855,SSR浴衣ビカラ,,
,,3040087000,,,,,,,,true,300,1600,1900,1500,8000,9500,,,,,,,,,,,2016-06-30,2025-03-29,,ロザミア (SSR),33985,SSRロザミア,,
1 name_en name_jp granblue_id rarity element proficiency1 proficiency2 gender race1 race2 flb min_hp max_hp max_hp_flb min_atk max_atk max_atk_flb base_da base_ta ougi_ratio ougi_ratio_flb special ulb max_hp_ulb max_atk_ulb character_id wiki_en release_date flb_date ulb_date wiki_ja gamewith kamigame nicknames_en nicknames_jp
2 Seofon (Yukata) シエテ(浴衣ver) 3040586000 3 5 1 10 1 1 false 277 1277 1777 9777 false false {4007} Seofon (Yukata) 2025-03-30 シエテ (SSR)浴衣バージョン 489325 SSR浴衣シエテ
3 Vikala (Yukata) ビカラ(浴衣ver) 3040585000 3 6 3 7 2 1 false 280 1550 1600 8250 false false {3150} Vikala (Yukata) 2025-03-30 ビカラ (SSR)浴衣バージョン 491855 SSR浴衣ビカラ
4 3040087000 true 300 1600 1900 1500 8000 9500 2016-06-30 2025-03-29 ロザミア (SSR) 33985 SSRロザミア

View file

@ -0,0 +1,5 @@
name_en,name_jp,granblue_id,rarity,element,proficiency,series,flb,ulb,max_level,max_skill_level,min_hp,max_hp,max_hp_flb,max_hp_ulb,min_atk,max_atk,max_atk_flb,max_atk_ulb,extra,ax_type,limit,ax,recruits,max_awakening_level,release_date,flb_date,ulb_date,wiki_en,wiki_ja,gamewith,kamigame,nicknames_en,nicknames_jp,transcendence,transcendence_date, , , , , , , , , , , , ,
First Fling of the Mischief,第一子行弾弓,1040714000,3,6,5,99,true,false,150,15,46,236,284,,377,2460,2981,,false,,false,false,,,2025-03-30,2025-03-30,,First Fling of the Mischief,第一子行弾弓 (SSR),,第一子行弾弓,,,false,,,,,,,,,,,,,,
Prismatic Trientalis,七彩華刀,1040917900,3,5,10,99,false,false,100,10,18,174,,,515,2737,,,false,,false,false,,,2025-03-30,,,Prismatic Trientalis,七彩華刀 (SSR),,七彩華刀,,,false,,,,,,,,,,,,,,
Scarface,スカーフェイス,1040517300,3,5,9,98,false,false,100,10,11,132,,,408,2221,,,false,,false,false,,,2025-03-29,,,Scarface,スカーフェイス (SSR),491802,スカーフェイス,,,false,,,,,,,,,,,,,,
Henchman,ヘンチマン,1030109100,2,5,2,98,false,false,75,10,8,117,,,271,1368,,,false,,false,false,,,2025-03-29,,,Henchman,ヘンチマン (SR),,ヘンチマン,,,false,,,,,,,,,,,,,,
1 name_en name_jp granblue_id rarity element proficiency series flb ulb max_level max_skill_level min_hp max_hp max_hp_flb max_hp_ulb min_atk max_atk max_atk_flb max_atk_ulb extra ax_type limit ax recruits max_awakening_level release_date flb_date ulb_date wiki_en wiki_ja gamewith kamigame nicknames_en nicknames_jp transcendence transcendence_date
2 First Fling of the Mischief 第一子行弾弓 1040714000 3 6 5 99 true false 150 15 46 236 284 377 2460 2981 false false false 2025-03-30 2025-03-30 First Fling of the Mischief 第一子行弾弓 (SSR) 第一子行弾弓 false
3 Prismatic Trientalis 七彩華刀 1040917900 3 5 10 99 false false 100 10 18 174 515 2737 false false false 2025-03-30 Prismatic Trientalis 七彩華刀 (SSR) 七彩華刀 false
4 Scarface スカーフェイス 1040517300 3 5 9 98 false false 100 10 11 132 408 2221 false false false 2025-03-29 Scarface スカーフェイス (SSR) 491802 スカーフェイス false
5 Henchman ヘンチマン 1030109100 2 5 2 98 false false 75 10 8 117 271 1368 false false false 2025-03-29 Henchman ヘンチマン (SR) ヘンチマン false