Template:Roles text parser/queryV2

--> 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
Virtual Reflection	SR_Basic_Lunatic_NATK	Lunatic - Charge Activate Lunatic status Charge on user (3 turns) 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)
Kuchinawa	SR_Kaleido_TmCrtRt_TmMCrtRt_NATK	Link Ability (Kuchinawa) Link Ability When Torn Earth 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: Magic Critical rate of all party members +100% When 4 Arcadia characters are on the frontline: (Kaleido) change element of all party members to earth
Ewella AS	SR_Basic_Kaleido_Flexible_NATK	Ministerium Stack Virtus on ally in the slot to user's right and Stack Virtus on self. User gains Kaleido based on Stacked ally's Type Personality and Flexible based on weapon type (Permanent) Virtus add 1/6 of each of the ally with Virtus stat (except HP/MP) to the corresponding stat of user Virtus add 1/6 of each of user's stat (except HP/MP) to the corresponding stat of the ally with Virtus Effects on game mechanics: Lunatic - Sacrifice is not affected by +END\+SPR parts from stack Base Damage: +STATS increase STAT_stacks parts of damage. SPD damage is affected greater than PWR or INT damage Both direct damage and skill multipliers non-standard stats scaling are affected (Radica AS, Cynthia, Heena...) Stacks are removed if User or Ally with Virtus Stack are not in the frontline at turn start or if Virtus is applied to a diffrent ally Replaces the basic attack
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: (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: (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 Elemental Break (Earth) When 3 Grit are stacked: Perform the strongest unique skill (i.e. Itto-Ryu: Stone Strike/Itto-Ryu: Earth 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) (?) (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 Elemental Break (Earth) When 3 Grit are stacked: Perform the strongest unique skill (i.e. Itto-Ryu: Stone Strike/Itto-Ryu: Earth 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) (?) (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 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: (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 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: (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 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 element (Permanent) When multiple 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 to the selected element is removed, skill needs to be reused in order to detect a new (if there is any)
Oboro	SR_Basic_Lunatic_NATK	Lunatic - Charge Activate Lunatic status Charge on user (3 turns) 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: (Kaleido) change element of all party members to water
Orleya AS	SR_Basic_Lunatic_NATK	Lunatic - Charge Activate Lunatic status Charge on user (3 turns) 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)
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 Inflict Rage (3 turns) Give a 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 Thunder (Kaleido) (3 turns)
Kamlanage	SR_Basic_Lunatic_NATK	Lunatic - Charge Activate Lunatic status Charge on user (3 turns) 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) 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 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 based on the weapon type of the ally with devotion (permanent) (Kaleido) change user's element based on element of the ally with devotion If ally has no element, defaults to water For multiple elements, defaults to Fire/Earth/Wind/Water unless in Shade/Thunder/Crystal Zone For Aisha or Cyrus Albright, defaults to water unless in matching Zone Unaffected by further Zone changes Type attack buff doubled for ally with devotion	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 Pendulum on user (Kaleido) change element of user attacks to target's element (permanent) When multiple - 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 to the selected element is removed, skill needs to be reused in order to detect a new (if there is any)
Iphi	SR_Pre_Zone_Shade_MentalFocus_Kaleido_NATK	Walpurgisnacht Deploy Biting Shade Stance and: Apply 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 Blood Contract, give all party members in front line Blood Contract stacks (excluding self) When in Biting Shade Stance: (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 Morale stack + (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 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 element (Permanent) When multiple 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 to the selected element is removed, skill needs to be reused in order to detect a new (if there is any)
Orleya	SR_Basic_Lunatic_NATK	Lunatic - Charge Activate Lunatic status Charge on user (3 turns) 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) 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) 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) 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) 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)