Difference between revisions of "User:Mornsta/Sandbox6"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Mornsta-gpuser
>Mornsta-gpuser
(Replaced content with "{{#time: r|2018/11/15 6:00 AM UTC}} {{#time: r|2018/11/15 6:00 AM}} {{#time: r|2018/11/15 6:00}}")
Line 1: Line 1:
−
{| class="wikitable sortable darkred" style="width:100%;justify-content:center"
+
{{#time: r|2018/11/15 6:00 AM UTC}}
−
|-
 
−
! 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=}}
 
−
|}
 
  
−
----
+
{{#time: r|2018/11/15 6:00 AM}}
−
Cargo by itself
+
 
−
{{#cargo_query:tables=EnemyPageLinks,EnemiesTest,Quests
+
{{#time: r|2018/11/15 6:00}}
−
|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"
 
−
|-
 
−
! 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}}
 
−
|}
 

Revision as of 15:38, 5 January 2019

Thu, 15 Nov 2018 06:00:00 +0000

Thu, 15 Nov 2018 06:00:00 +0000

Thu, 15 Nov 2018 06:00:00 +0000

Retrieved from "https://dlwiki.cherrymint.live/index.php?title=User:Mornsta/Sandbox6&oldid=207626"