Template:Character Skill In Table/Build table from query
From Another Eden Wiki
Input Parameters[edit]
Usage:
- This Template builds an entire table at once with a SINGLE query.
- If you want to build a table piecemeal, e.g. to provide a custom sorting, or select which matches to a query are displayed or not, then you should use the lower-level parent one instead that handles rows one at a time.
Required parameter, specifying type of cargo query:
- one of descriptionlike, where, or namelike or vclike
Additional optional parameters:
- extraheader
- collapsible
- collapsed
- centered
- additionalrow
- addtoexisting (adds/chains to existing table, skipping creation of header & footer)
example descriptionlike[edit]
{{Character Skill In Table/Build table from query|descriptionlike=%[[Barrier Piercing|Barrier Pierce]]%|additionalrow=Additional row text goes here}}
Character(s) | Skill & Effects | ||||
---|---|---|---|---|---|
None
Buff Type attack of the user +50% and Critical rate and Magic critical rate of user +100% (3 moves)
50 N/A
50 | |||||
None
Passive Stellar Burst Activation BonusWhen Stellar Burst is activated with user and Gauge has majority light:
N/A
None
Passive Stellar Burst Activation BonusWhen Stellar Burst is activated with user and Gauge has majority light:
N/A
| |||||
Earth
Blunt Deploy Roaring Bash Stance and awaken Another Zone (3 turns-) (many times per battle) and Earth type blunt attack on all enemies (XL)
82 82
Earth
Blunt Deploy Roaring Bash Stance and awaken Another Zone (3 turns-) (many times per battle) and Earth type blunt attack on all enemies (XXL)
70 70 | |||||
Crystal
Piercing Crystal type piercing attack all enemies (XL)
82 82
Crystal
Piercing Crystal type piercing attack all enemies (XXL)
70 70 | |||||
Fire
Slash Fire type slash attack on a single enemy x2 (XL) and Physical Resistance and Type Resistance -25% (5 turns)
53 53 | |||||
Crystal
Slash 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
0 0
Crystal
Slash 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
0 0 | |||||
None
Buff/Healing Target a single party member. Give them Link [???% x Mod] (3 turns) and Barrier Pierce (1 time) and Restores Target's statuses and remove debuffs
109 N/A
109
None
Buff/Healing Target a single party member. Give them Link [???% x Mod] (5 turns) and Barrier Pierce (3 times) and Restores Target's statuses and remove debuffs
93 N/A
93 | |||||
Thunder
Slash Perform the strongest unique skill (i.e. Itto-Ryu: Radiant/Itto-Ryu: Bolt/Itto-Ryu: Haze) that has been learned
95 95
Thunder
Slash Perform the strongest unique skill (i.e. Itto-Ryu: Radiant/Itto-Ryu: Bolt/Itto-Ryu: Haze) that has been learned with an XXL Modifier
80 80 | |||||
None
Status Start of Turn ActivationState is activated when user has 3 Blast Bolt stacked and provides the following effects:
0 N/A
0 | |||||
Wind
Piercing Wind type piercing attack on a single enemy (XL) and Guaranteed Critical
48 48 | |||||
Water
Slash Water type slash attack on all enemies (XL) and increase user critical rate by 100%, magical crit rate by 100% and type attack by 50% (3 moves)
62 62 | |||||
water
Slash PreemptiveConsumes all Iceburst on all enemies to perform the following:
0 0 | |||||
Wind
Slash Wind type slash attack on a single enemy x2 (XL, increase skill damage 5 times 5x of the standard skill multiplier of 200% ) and Guaranteed Critical
49 49 | |||||
Fire
Slash Fire type slash attack on a single enemy x3 (XL) and Inflict 3 stacks of Elemental Break (Fire) and Inflict Pain
51 51 | |||||
None
Select PreemptiveTarget a single party member.
0 N/A
0 | |||||
Crystal
Magic Crystal type magic attack on a single enemy (XL) and inflict Poison (3 turns)
49 49 | |||||
Thunder
Piercing Thunder type piercing attack on all enemies x2 (XL) and inflict Pain (3 turns, ignore target resistance, pain modifier [80%])
50 50 | |||||
Earth
Piercing Earth type piercing attack on all enemies (XL)
52 52 | |||||
Wind
Piercing Removes Any Active Stance and Deploy Wind King Stance and awaken Another Zone (3 turns) and Wind type piercing attack on all enemies x 3 (XL) and ignores target's defense (Def=0 in Damage Formula)
85 85
Wind
Piercing Removes Any Active Stance and Deploy Wind King Stance and awaken Another Zone (3 turns) and Wind type piercing attack on all enemies x 3 (XXL) and ignores target's defense (Def=0 in Damage Formula)
71 71 | |||||
Earth
Magic Earth type magic attack on a single enemy (M) and inflict Stun
22 22 | |||||
None
Healing Restore all party members' and all enemies' HP (M) and Intelligence +20% and type resistance -20% (3 turns)
20 20 | |||||
Moke (5★)
|
None
Buff AuraActivation condition: When any (Special) type effect is active
0 N/A
0 | ||||
Additional row text goes here |
example namelike[edit]
{{Character Skill In Table/Build table from query|namelike=Lunatic%}}
Character(s) | Skill & Effects |
---|---|
Thunder
Status Activate Lunatic status Charge on user (3 turns)
0 0 | |
None
Status Activate Lunatic status Copy on user (3 turns)
0 N/A
0 | |
None
Status Activate Lunatic with Status Mind's Eye on user (3 turns).
0 0 | |
None
Status Activate Lunatic with Status Risktaker on user (3 turns).
0 0 | |
Shade
Status Activate Lunatic status Sacrifice on user (3 turns)
0 N/A
0 | |
Shade
Status Stack 1 Power Level on user and Activate Lunatic status Sacrifice on user (3 turns)
0 N/A
0 | |
None
Status Activate Lunatic with Status Static on user (3 turns)
0 N/A
0 | |
None
Status Activate Lunatic with Status Mind's Eye on user (3 turns).
0 0 | |
None
Status PreemptiveActivate Lunatic with Status Risktaker on user (3 turns).
0 0 |
example using optional params[edit]
{{Character Skill In Table/Build table from query|descriptionlike=%ecover [[Another Force|AF gauge]]%|extraheader=Another Force Restore Skills|collapsible=yes|centered=yes}}
Character(s) | Skill & Effects |
---|
example using vclike[edit]
{{Character Skill In Table/Build table from query|centered=yes|vclike=%[[Mental Focus (Status Effect)|Mental Focus]]%|extraheader=Mental Focus Valor Chants}}Lua error: Error 1054: Unknown column 'aewikicargo__Grasta.VCCharacter' in 'on clause' (10.124.0.4) Function: CargoSQLQuery::run Query: SELECT `aewikicargo__ValorChants`.`ValorChantName` AS `vc`,`aewikicargo__Grasta`.`Name` AS `vcgrasta` FROM `aewikicargo__ValorChants` LEFT OUTER JOIN `aewikicargo__Grasta` ON ((`aewikicargo__ValorChants`.`CharacterName`=`aewikicargo__Grasta`.`VCCharacter`)) WHERE `aewikicargo__ValorChants`.`ValorChantName`!="-" AND `aewikicargo__ValorChants`.`Description` LIKE "%Mental Focus%" AND `aewikicargo__ValorChants`.`Level`=3 ORDER BY `aewikicargo__ValorChants`.`ValorChantName`,`aewikicargo__Grasta`.`Name` LIMIT 100 .
Character(s) | Skill & Effects |
---|
example using addtoexisting[edit]
{| class="wikitable centered" ! Character(s) !! Skill & Effects |+ Skill hodgepodge known to be short! |- {{Character Skill In Table|skill=Elixir Ray}} {{Character Skill In Table/Build table from query|addtoexisting=true|descriptionlike=%Activates Lunatic conditioned effects of skills%}} {{Character Skill In Table|skill=Blood Contract}} |}
Character(s) | Skill & Effects |
---|---|
None
Healing Restore user's HP +50% and MP +50% and restore 1 Lunatic activation on basic attack if no activations left.
45 N/A
45 | |
None
Stack Battle StartBlood Contract effects:
N/A
| |
None
Buff SongActivate Song (3 turns) with effect
Disrupted by Sleep, Confusion, Stone, Stun, Freeze, Knockback, Death 50 N/A
50 | |
None
Buff SongActivate Song (3 turns) with effect
Disrupted by Sleep, Confusion, Stone, Stun, Freeze, Knockback, Death 50 N/A
50 |
Template:Character Skill In Table/Build table from query/doc