Difference between revisions of "Dragalia Lost Wiki:Missing Enemy Pages"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Eave
(include a query for missing enemy names as well)
>Eave
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
Note that some entries, such as "Weak Point" do not need pages, as they are included as extra parts on enemies such as [[Qitian Dasheng]]. Create pages with your best judgement.
 
Note that some entries, such as "Weak Point" do not need pages, as they are included as extra parts on enemies such as [[Qitian Dasheng]]. Create pages with your best judgement.
  
{{#cargo_query:tables=EnemiesTest=et,EnemyPageLinks=ep
+
{{#cargo_query:tables=EnemiesTest=et,EnemyPageLinks=ep,_pageData=pages
|join on=et.Name=ep.Name
+
|join on=et.Name=ep.Name,et.Name=pages._pageName
 
|fields=CONCAT('[[',et.Name,'|',et.Name,']]')=Name
 
|fields=CONCAT('[[',et.Name,'|',et.Name,']]')=Name
|where=et.Name IS NOT NULL AND et.Name != "" AND ep.Name IS NULL AND et.PartsNode IS NULL
+
|where=et.Name IS NOT NULL AND et.Name != "" AND ep.Name IS NULL AND et.PartsNode IS NULL AND (pages._isRedirect IS NULL OR pages._isRedirect='0')
 
|limit=99999
 
|limit=99999
 
|group by=et.Name
 
|group by=et.Name
Line 10: Line 10:
 
|format=ul
 
|format=ul
 
}}
 
}}
 +
 +
Template copy for convenience:
 +
<pre>
 +
{{EnemyHeader
 +
|Name=
 +
}}
 +
</pre>
  
 
== Missing Enemy Names ==
 
== Missing Enemy Names ==
 +
Please add any enemies that need name overrides to: [[:Template:EnemyData/NameOverrides]]
 +
 
{{#cargo_query:tables=EnemiesTest
 
{{#cargo_query:tables=EnemiesTest
|fields=DataId,ElementalType,Tribe
+
|fields=DataId,MissionType,ElementalType,Tribe
 
|where=Name IS NULL OR Name = ""
 
|where=Name IS NULL OR Name = ""
 
|limit=99999
 
|limit=99999
|group by=Name
+
|group by=DataId
 
|order by=DataId
 
|order by=DataId
|format=ul
 
 
}}
 
}}

Latest revision as of 00:40, 25 June 2020

Note that some entries, such as "Weak Point" do not need pages, as they are included as extra parts on enemies such as Qitian Dasheng. Create pages with your best judgement.

Error: Table EnemiesTest not found.

Template copy for convenience:

{{EnemyHeader
|Name=
}}

Missing Enemy Names

Please add any enemies that need name overrides to: Template:EnemyData/NameOverrides

Error: Table EnemiesTest not found.