Difference between revisions of "User:Mornsta/Sandbox6"

Revision as of 12:33, 5 January 2019

Name	HP	Str	Def	Element	Tribe	Quest Error: Table EnemyPageLinks not found.

Cargo by itself

Error: Table EnemyPageLinks not found.

Base

Name	HP	Str	Def	Element	Tribe	Quest Error: Table EnemyPageLinks not found.

@@ Line 1: / Line 1: @@
+{| class="wikitable sortable darkred" style="width:100%;justify-content:center"
+|-
+! Name
+! HP
+! Str
+! Def
+! Element
+! Tribe
+! Quest
+{{#cargo_query:tables=EnemyPageLinks,EnemiesTest,Quests
+|join on= EnemiesTest.Name=EnemyPageLinks.Name,EnemiesTest.MissionType=Quests.QuestViewName
+|where=EventName LIKE "%Fortune from Afar%"
+|fields=CONCAT('[[', EnemyPageLinks._pageName, '|', EnemiesTest.Name, ']]')=Name,EnemiesTest.HP=HP,EnemiesTest.Atk=Str,EnemiesTest.Def=Def,EnemiesTest.ElementalType=Element,EnemiesTest.Tribe=Tribe,CONCAT('[[', Quests._pageName, '|', EnemiesTest.MissionType, ']]')=Quest
+|group by=EnemiesTest.MonsterId
+|order by=EnemiesTest.HP DESC,EnemiesTest.Name
+|format=template
+|template=EventEnemyTableEntry
+|named args=yes
+|default=}}
+|}
+----
+Cargo by itself
+{{#cargo_query:tables=EnemyPageLinks,EnemiesTest,Quests
+|join on= EnemiesTest.Name=EnemyPageLinks.Name,EnemiesTest.MissionType=Quests.QuestViewName
+|where=EventName LIKE "%Fortune from Afar%"
+|fields=CONCAT('[[', EnemyPageLinks._pageName, '|', EnemiesTest.Name, ']]')=Name,EnemiesTest.HP=HP,EnemiesTest.Atk=Str,EnemiesTest.Def=Def,EnemiesTest.ElementalType=Element,EnemiesTest.Tribe=Tribe,CONCAT('[[', Quests._pageName, '|', EnemiesTest.MissionType, ']]')=Quest
+|group by=EnemiesTest.MonsterId
+|order by=EnemiesTest.HP DESC,EnemiesTest.Name
+|named args=yes}}
+----
+Base
 {| class="wikitable sortable darkred" style="width:100%;justify-content:center"
 |-