Template:Roles text parser/queryV2

From Another Eden Wiki

--> self reminder about DB tables used:

  • s. - skill data
  • c. - characters data
  • sk. - sidekicks
    • only c or sk is connected to skill instance, other are NULL
  • cns. - character Normal style data, to pick up NS names
Character DynamicRoles Skill Targets per row
Sazanca SR_Kaleido_TmTypResGrpBF_NATK Link Ability (Sazanca)
Link Ability
When Raging Fire Stance is deployed additional effects occur depending on number of Arcadia Characters on the front lines
  • When 2 or more Arcadia characters are on the frontline: Wind Type Resistance of all party members +30%
  • When 4 Arcadia characters are on the frontline: Fire (Kaleido) change element of all party members to fire
Melpiphia SR_Kaleido_TmCrtDmg_TmMCrtDmg_NATK Link Ability (Melpiphia)
Link Ability
When Wind King Stance is deployed additional effects occur depending on number of Arcadia Characters on the front lines
  • When 2 or more Arcadia characters are on the frontline: Critical Damage and Magic Critical Damage of all party members +20%
  • When 4 Arcadia characters are on the frontline: Wing (Kaleido) change element of all party members to wind
Blooming Blade SR_Zone_Earth_ZoneAwakenMulti_Kaleido_InfEBrk_TypGrpDBF_ATKAOE_ATKEarth_ATKSlash Itto-Ryu: Stampede
Earth type Slash attack on all enemies (XXL) and Inflict 3 stacks of St elemental break32.png Elemental Break (Earth)
  • When 3 Grit are stacked: Perform the strongest unique skill (i.e. Itto-Ryu: Pebble/Itto-Ryu: Dance/Itto-Ryu: Hawk Talon) that has been learned and Earth Type Resistance of all enemies -100% (Current Turn Only) and Elemental Break count increased (x2)
  • When Used During Stellar Burst: +5900% damage (Multiplier x60) and Deploy Torn Earth Stance and awaken Another Zone (3 turns-) (many times per battle) (?)
    • Earth (Kaleido) change element of party members to Earth (Current turn only)
Blooming Blade SR_Zone_Earth_ZoneAwakenMulti_Kaleido_InfEBrk_TypGrpDBF_ATKAOE_ATKEarth_ATKSlash_ModType111 Itto-Ryu: Stampede
Earth type Slash attack on all enemies (XL) and Inflict 3 stacks of St elemental break32.png Elemental Break (Earth)
  • When 3 Grit are stacked: Perform the strongest unique skill (i.e. Itto-Ryu: Pebble/Itto-Ryu: Dance/Itto-Ryu: Hawk Talon) that has been learned and Earth Type Resistance of all enemies -100% (Current Turn Only) and Elemental Break count increased (x2)
  • When Used During Stellar Burst: +5900% damage (Multiplier x60) and Deploy Torn Earth Stance and awaken Another Zone (3 turns-) (many times per battle) (?)
    • Earth (Kaleido) change element of party members to Earth (Current turn only)
Thillelille ES SR_BrrrPierce_Kaleido_ATKAOE_ATKCrystal_ATKSlash_ModType11 Sword In Heart
Crystal type slash attack on all enemies x4 (XL,
increase skill damage 50 times. 50x of the standard skill multiplier of 160% 
) and Barrier Pierce St ignore barrier.png ignore Barriers: Damage Reduction and Status Immunity
  • Does not ignore resistances, Barriers on target are not consumed, inflict status from equipment also ignores immunity
  • Can only be used during Sword-wielding Savior mode, other wise attack fails
  • Ends Sword-wielding Savior mode
  • When used during Stellar Burst: Crystal (Kaleido) change all Luring Shadow Party members to Crystal (Current turn only)
    • When Sidekick is present: Stack +5 Charge
Thillelille ES SR_BrrrPierce_Kaleido_ATKAOE_ATKCrystal_ATKSlash_ModType111 Sword In Heart
Crystal type slash attack on all enemies x4 (XXL,
increase skill damage 50 times. 50x of the standard skill multiplier of 210% 
) and Barrier Pierce St ignore barrier.png ignore Barriers: Damage Reduction and Status Immunity
  • Does not ignore resistances, Barriers on target are not consumed, inflict status from equipment also ignores immunity
  • Can only be used during Sword-wielding Savior mode, other wise attack fails
  • Ends Sword-wielding Savior mode
  • When used during Stellar Burst: Crystal (Kaleido) change all Luring Shadow Party members to Crystal (Current turn only)
    • When Sidekick is present: Stack +5 Charge
Alma AS SR_Kaleido_NATK Brain Record
Place a Skill stack power type2.png Scope on a single enemy
  • When not in Another Force: Detect stats on a single enemy
    • Displayed stats will reflect any active stat buff/debuff on the enemy
  • (Kaleido) change element of user attacks to target's Weakness.png element (Permanent)
    • When multiple Weakness.png choice is random. Crystal weakness is always chosen if it's present.
    • Non-type attacks become elemental without change in skill multiplier
    • Skills from equipment also change
    • Effect is based on when skill was used
      • If Weakness.png to the selected element is removed, skill needs to be reused in order to detect a new Weakness.png (if there is any)
Oboro SR_Basic_Lunatic_NATK Lunatic - Charge
Activate Lunatic status Charge on user (3 turns)
  • Awaken thunder.png Charge: For each hit (including damage to self), add Thunder-type attack (XS)
    • Attack type is determined by the original attack
    • Regardless of whether there is an active Stance or not, each additional attack increases AF bar by 0.5% and combo multiplier in AF by 1%
    • If the original attack was absorbed, extra attacks will not hit but will still increase AF bar and combo multiplier
    • Not affected by Kaleido
  • Replaces the basic attack until used (1 activation)
Wryz SR_Kaleido_TmSpdBF_NATK Link ability (Wryz)
Link Ability
When Sacred Water Stance is deployed additional effects occur depending on number of Arcadia Characters on the front lines
  • When 2 or more Arcadia characters are on the frontline: Speed of all party members +30%
  • When 4 Arcadia characters are on the frontline: Water (Kaleido) change element of all party members to water
Orleya AS SR_ZoneAwaken_Kaleido_InfRage_PwrDBFAoE_IntDBFAoE_SpdDBFAoE_NATK Défense du tonnerre
Power, Intelligence and Speed of all enemies -50% (1 turn) and Rage.png Inflict Rage (3 turns)
  • Give a Status Barrier.png Barrier to user with 50% damage reduction to Thunder Type Attacks (3 times)
  • When in an Elemental/Attack Type Stance: Once per battle: awaken Another Zone (2 turns)
  • When in an Awakened Thundering Stance: Debuff effects x1.5 (-75%)
    • Change element of all enemies to ThunderThunder (Kaleido) (3 turns)
Orleya AS SR_Basic_Lunatic_NATK Lunatic - Charge
Activate Lunatic status Charge on user (3 turns)
  • Awaken thunder.png Charge: For each hit (including damage to self), add Thunder-type attack (XS)
    • Attack type is determined by the original attack
    • Regardless of whether there is an active Stance or not, each additional attack increases AF bar by 0.5% and combo multiplier in AF by 1%
    • If the original attack was absorbed, extra attacks will not hit but will still increase AF bar and combo multiplier
    • Not affected by Kaleido
  • Replaces the basic attack until used (1 activation)
Kamlanage SR_Basic_Lunatic_NATK Lunatic - Charge
Activate Lunatic status Charge on user (3 turns)
  • Awaken thunder.png Charge: For each hit (including damage to self), add Thunder-type attack (XS)
    • Attack type is determined by the original attack
    • Regardless of whether there is an active Stance or not, each additional attack increases AF bar by 0.5% and combo multiplier in AF by 1%
    • If the original attack was absorbed, extra attacks will not hit but will still increase AF bar and combo multiplier
    • Not affected by Kaleido
  • Replaces the basic attack until used (1 activation)
Velette SR_Basic_Lunatic_NATK Lunatic - Charge
Activate Lunatic status Charge on user (3 turns)
  • Awaken thunder.png Charge: For each hit (including damage to self), add Thunder-type attack (XS)
    • Attack type is determined by the original attack
    • Regardless of whether there is an active Stance or not, each additional attack increases AF bar by 0.5% and combo multiplier in AF by 1%
    • If the original attack was absorbed, extra attacks will not hit but will still increase AF bar and combo multiplier
    • Not affected by Kaleido
  • Replaces the basic attack until used (1 activation)
Nona AS SR_Kaleido_Flexible_TmCrtRt_AllDmgGrpBF_ATKST_ATKWater_ATKPiercing Castigo
Water type piercing attack on random enemies x3 (XL) and Water type attack of all party members +30% (3 turns) and Critical rate of all party members +100% (1 move)
  • When there is an ally with Skill stack power type2.png Devotion stack on the front line:
    • Increase number of attacks by +3
    • (Kaleido) change element of type attack buff according to the attribute personality of the ally with devotion
    • Grants Flexible to user according to the weapon type of the ally with devotion (permanent)
    • (Kaleido) change user's element according to attribute personality of the ally with devotion
      • If ally with devotion does not have an element, defaults to water.
      • If ally with devotion has multiple elements, defaults to Fire/Earth/Wind/Water unless in a Shade/Thunder/Crystal Zone
      • In the case of Aisha, defaults to water unless in a Fire Zone
    • Increase effect of type attack buff for ally with devotion (2 times)

several targets
Dewey AS SR_Kaleido_ATKST_ATKWater_ATKBlunt Vapeur Hypnotique
Water type blunt attack on a single enemy (XL) and Power of user +50% and Speed of user +50% (3 turns)
  • When enemy has an active buff:
    • Removes all buffs from target
    • Power and Speed effect increases (100%)
    • When not in Clock Burst State: Stacks 5 Skill stack power type1.png Pendulum on user
  • (Kaleido) change element of user attacks to target's Weakness.png element (permanent)
    • When multiple Weakness.png - choice is random.
    • Non-type attacks become elemental without change in skill multiplier
    • Skills from equipment also change
    • Effect is based on when skill was used
      • If Weakness.png to the selected element is removed, skill needs to be reused in order to detect a new Weakness.png (if there is any)
Iphi SR_Pre_Zone_Shade_MentalFocus_Kaleido_NATK Walpurgisnacht
Deploy Biting Shade Stance and:
  • Apply Status Mental Focus.png Mental Focus on all party members (5 turns):
    • Magic damage of each party member: +0.23% x MaxMP (CAP: +250% at 1087MP+, Multiplier: x3.5)
  • If no party member in front or back line has Skill stack power type2.png Blood Contract, give all party members in front line Skill stack power type2.png Blood Contract stacks (excluding self)
  • When in Biting Shade Stance: Shade (Kaleido) change element of all party members to shade (current turn only)
Noble Blossom SR_Basic_Kaleido_NATK Morale
Target a single party member. Give them Skill stack power type2.png Morale stack + Fire (Kaleido) change element to fire (Permanent) and stack Morale on self.
  • If target is self: Stack 3 Morale on self.
  • Replaces the basic attack when not in Another Force.
Necoco AS SR_Pre_Kaleido_TmWkBF_TmPwrBF_TmIntBF_TmSpdBF_StBF_SBF_KBF_ABF_LBF_BBF_FBF_HBF_AnBF_NATK Scintillant Spirit
Power, Intelligence, Speed, and any weapon equipped characters' damage of all party members +50% (current turn only) and Weakness Multiplier of all party members +1 (current turn only)
  • In any elemental zone:
    • (Kaleido) change the attack type of all enemies and allies to match active elemental zone (current turn only)
    • Guiding Light characters only:
      • Strength/Intelligence/Speed/Weapon damage type buff effect increase (+75%)
Alma SR_Kaleido_NATK Brain Record
Place a Skill stack power type2.png Scope on a single enemy
  • When not in Another Force: Detect stats on a single enemy
    • Displayed stats will reflect any active stat buff/debuff on the enemy
  • (Kaleido) change element of user attacks to target's Weakness.png element (Permanent)
    • When multiple Weakness.png choice is random. Crystal weakness is always chosen if it's present.
    • Non-type attacks become elemental without change in skill multiplier
    • Skills from equipment also change
    • Effect is based on when skill was used
      • If Weakness.png to the selected element is removed, skill needs to be reused in order to detect a new Weakness.png (if there is any)
Orleya SR_Basic_Lunatic_NATK Lunatic - Charge
Activate Lunatic status Charge on user (3 turns)
  • Awaken thunder.png Charge: For each hit (including damage to self), add Thunder-type attack (XS)
    • Attack type is determined by the original attack
    • Regardless of whether there is an active Stance or not, each additional attack increases AF bar by 0.5% and combo multiplier in AF by 1%
    • If the original attack was absorbed, extra attacks will not hit but will still increase AF bar and combo multiplier
    • Not affected by Kaleido
  • Replaces the basic attack until used (1 activation)
Silver Striker SR_Basic_Lunatic_NATK Lunatic - Charge
Activate Lunatic status Charge on user (3 turns)
  • Awaken thunder.png Charge: For each hit (including damage to self), add Thunder-type attack (XS)
    • Attack type is determined by the original attack
    • Regardless of whether there is an active Stance or not, each additional attack increases AF bar by 0.5% and combo multiplier in AF by 1%
    • If the original attack was absorbed, extra attacks will not hit but will still increase AF bar and combo multiplier
    • Not affected by Kaleido
  • Replaces the basic attack until used (1 activation)
Melina ES SR_Basic_Lunatic_NATK Lunatic - Charge
Activate Lunatic status Charge on user (3 turns)
  • Awaken thunder.png Charge: For each hit (including damage to self), add Thunder-type attack (XS)
    • Attack type is determined by the original attack
    • Regardless of whether there is an active Stance or not, each additional attack increases AF bar by 0.5% and combo multiplier in AF by 1%
    • If the original attack was absorbed, extra attacks will not hit but will still increase AF bar and combo multiplier
    • Not affected by Kaleido
  • Replaces the basic attack until used (1 activation)
Skull SR_Basic_Lunatic_NATK Lunatic - Charge
Activate Lunatic status Charge on user (3 turns)
  • Awaken thunder.png Charge: For each hit (including damage to self), add Thunder-type attack (XS)
    • Attack type is determined by the original attack
    • Regardless of whether there is an active Stance or not, each additional attack increases AF bar by 0.5% and combo multiplier in AF by 1%
    • If the original attack was absorbed, extra attacks will not hit but will still increase AF bar and combo multiplier
    • Not affected by Kaleido
  • Replaces the basic attack until used (1 activation)
Victor SR_Basic_Lunatic_NATK Lunatic - Charge
Activate Lunatic status Charge on user (3 turns)
  • Awaken thunder.png Charge: For each hit (including damage to self), add Thunder-type attack (XS)
    • Attack type is determined by the original attack
    • Regardless of whether there is an active Stance or not, each additional attack increases AF bar by 0.5% and combo multiplier in AF by 1%
    • If the original attack was absorbed, extra attacks will not hit but will still increase AF bar and combo multiplier
    • Not affected by Kaleido
  • Replaces the basic attack until used (1 activation)