Difference between revisions of "User:Eave/Sandbox"
Jump to navigation
Jump to search
>Eave |
>Eave |
||
| Line 14: | Line 14: | ||
| − | == | + | == Enemy Names == |
| − | + | {{#cargo_query:tables=EnemiesTest,EnemyPageLinks | |
| − | + | |join on=EnemiesTest.Name=EnemyPageLinks.Name | |
| − | + | |where=MissionType="Ciella's Wrath: Expert" | |
| − | {{# | + | |fields=CONCAT('[[', EnemyPageLinks._pageName, '|', EnemiesTest.Name, ']]')=Name, CONCAT('{{InlineIcon|Icon Element|', EnemiesTest.ElementalType,'}}')=Element, EnemiesTest.Tribe=Class, EnemiesTest.HP, EnemiesTest.Atk=Str, EnemiesTest.Def |
| − | | | + | |group by=EnemiesTest.MonsterId |
| − | | | + | |order by=EnemiesTest.HP DESC,EnemiesTest.Name |
| − | | | ||
| − | | | ||
}} | }} | ||
| − | + | {{#cargo_query:tables=EnemiesTest,EnemyPageLinks | |
| − | {{# | + | |join on=EnemiesTest.Name=EnemyPageLinks.Name |
| − | | | + | |where=MissionType="Ciella's Wrath: Expert" |
| − | | | + | |fields=IF(EnemyPageLinks._pageName, CONCAT('[[', EnemyPageLinks._pageName, '|', EnemiesTest.Name, ']]'), EnemiesTest.Name)=Name, CONCAT('{{InlineIcon|Icon Element|', EnemiesTest.ElementalType, '}}')=Element, EnemiesTest.Tribe=Class, EnemiesTest.HP, EnemiesTest.Atk=Str, EnemiesTest.Def |
| − | | | + | |group by=EnemiesTest.MonsterId |
| − | | | + | |order by=EnemiesTest.HP DESC,EnemiesTest.Name |
}} | }} | ||
| − | |||
| − | == Bad Thumbnails == | + | == Bad Mobile Thumbnails == |
[[File:110009 01 r05 portrait.png|150px]] | [[File:110009 01 r05 portrait.png|150px]] | ||
[[File:110274 01 r05 portrait.png|150px]] | [[File:110274 01 r05 portrait.png|150px]] | ||
[[File:110260_01_r05_portrait.png|150px]] | [[File:110260_01_r05_portrait.png|150px]] | ||
Revision as of 23:49, 24 June 2020
Boolean {{#if}} proof of concept using IsAffectedByTension
Void Volley (Should be TRUE)
Query result:
Error: Table Skills not found.
IF: TRUE
Abyssal Connection (Should be FALSE)
Query result:
Error: Table Skills not found.
IF: TRUE
Enemy Names
Error: Table EnemiesTest not found.
Error: Table EnemiesTest not found.