Please remember to make use of the DML Wiki Manual of Style and Code of Conduct during your stay.

 Actions

Template

DragonListFromElements: Difference between revisions

From Dragon Mania Legends (DML) Wiki

(Also force first letter to be upper case)
No edit summary
Line 2: Line 2:
tables=DragonInfos
tables=DragonInfos
|fields=_pageName=Page
|fields=_pageName=Page
|where={{#if:{{{third|}}}<!--
|where={{#if:{{{second|}}}<!--
-->|cargocats LIKE "%{{#if:{{{breedable|}}}|Normally-Breedable|Standard}} Dragons%" AND (base="{{ucfirst:{{{base|}}}}}" AND second="{{ucfirst:{{{second|}}}}}" AND third="{{ucfirst:{{{third|}}}}}" OR
-->|{{#if:{{{third|}}}<!--  
--->|cargocats LIKE "%{{#if:{{{breedable|}}}|Normally-Breedable|Standard}} Dragons%" AND (base="{{ucfirst:{{{base|}}}}}" AND second="{{ucfirst:{{{second|}}}}}" AND third="{{ucfirst:{{{third|}}}}}" OR
base="{{ucfirst:{{{base|}}}}}" AND second="{{ucfirst:{{{third|}}}}}" AND third="{{ucfirst:{{{second|}}}}}" OR
base="{{ucfirst:{{{base|}}}}}" AND second="{{ucfirst:{{{third|}}}}}" AND third="{{ucfirst:{{{second|}}}}}" OR
base="{{ucfirst:{{{second|}}}}}" AND second="{{ucfirst:{{{third|}}}}}" AND third="{{ucfirst:{{{base|}}}}}" OR
base="{{ucfirst:{{{second|}}}}}" AND second="{{ucfirst:{{{third|}}}}}" AND third="{{ucfirst:{{{base|}}}}}" OR
base="{{ucfirst:{{{second|}}}}}" AND second="{{ucfirst:{{{base|}}}}}" AND third="{{ucfirst:{{{third|}}}}}" OR
base="{{ucfirst:{{{second|}}}}}" AND second="{{ucfirst:{{{base|}}}}}" AND third="{{ucfirst:{{{third|}}}}}" OR
base="{{ucfirst:{{{third|}}}}}" AND second="{{ucfirst:{{{base|}}}}}" AND third="{{ucfirst:{{{second|}}}}}" OR
base="{{ucfirst:{{{third|}}}}}" AND second="{{ucfirst:{{{base|}}}}}" AND third="{{ucfirst:{{{second|}}}}}" OR
base="{{ucfirst:{{{third|}}}}}" AND second="{{ucfirst:{{{second|}}}}}" AND third="{{ucfirst:{{{base|}}}}}")<!--
base="{{ucfirst:{{{third|}}}}}" AND second="{{ucfirst:{{{second|}}}}}" AND third="{{ucfirst:{{{base|}}}}}")<!-- not
-->|{{#if:{{ucfirst:{{{second|}}}}}<!--
--->|cargocats LIKE "%{{#if:{{{breedable|}}} | Normally-Breedable | Standard}} Dragons%" AND  
---->|cargocats LIKE "%{{#if:{{{breedable|}}} | Normally-Breedable | Standard}} Dragons%" AND  
(third IS NULL AND (base="{{ucfirst:{{{base|}}}}}" AND second="{{ucfirst:{{{second|}}}}}" OR
(third IS NULL AND (base="{{ucfirst:{{{base|}}}}}" AND second="{{ucfirst:{{{second|}}}}}" OR
second="{{ucfirst:{{{base|}}}}}" AND base="{{ucfirst:{{{second|}}}}}")<!--
second="{{ucfirst:{{{base|}}}}}" AND base="{{ucfirst:{{{second|}}}}}")}}<!--
---->|cargocats LIKE "%{{#if:{{{breedable|}}} | Normally-Breedable | Standard}} Dragons%" AND
-->|cargocats LIKE "%{{#if:{{{breedable|}}} | Normally-Breedable | Standard}} Dragons%" AND
"{{ucfirst:{{{base|}}}}}" AND second IS NULL AND third IS NULL<!--
"{{ucfirst:{{{base|}}}}}" AND second IS NULL AND third IS NULL}}
-->}}}}
|named args=yes
|named args=yes
|group by=_pageName
|group by=_pageName

Revision as of 16:57, 7 September 2023

Template documentation
Note: portions of the template sample may not be visible without values provided.
View or edit this template's documentation. (About template documentation)

Example(s)

{{DragonListFromElements| Fire | Fire }} gives:

Error: operator for the virtual field 'DragonInfos.cargocats' must be 'HOLDS', 'HOLDS NOT', 'HOLDS LIKE' or 'HOLDS NOT LIKE'.



{{DragonListFromElements| Fire }} gives:

Error: operator for the virtual field 'DragonInfos.cargocats' must be 'HOLDS', 'HOLDS NOT', 'HOLDS LIKE' or 'HOLDS NOT LIKE'.

{{DragonListFromElements| Fire | Water }} gives:

Error: operator for the virtual field 'DragonInfos.cargocats' must be 'HOLDS', 'HOLDS NOT', 'HOLDS LIKE' or 'HOLDS NOT LIKE'.

{{DragonListFromElements| Fire | Water | breedable = 1}} gives:

Error: operator for the virtual field 'DragonInfos.cargocats' must be 'HOLDS', 'HOLDS NOT', 'HOLDS LIKE' or 'HOLDS NOT LIKE'.

{{DragonListFromElements| water | fire }} gives:

Error: operator for the virtual field 'DragonInfos.cargocats' must be 'HOLDS', 'HOLDS NOT', 'HOLDS LIKE' or 'HOLDS NOT LIKE'.

{{DragonListFromElements| wind | earth }} gives:

Error: operator for the virtual field 'DragonInfos.cargocats' must be 'HOLDS', 'HOLDS NOT', 'HOLDS LIKE' or 'HOLDS NOT LIKE'.

{{DragonListFromElements| wind | earth | breedable = true}} gives:

Error: operator for the virtual field 'DragonInfos.cargocats' must be 'HOLDS', 'HOLDS NOT', 'HOLDS LIKE' or 'HOLDS NOT LIKE'.

{{DragonListFromElements| legendary | shadow | plant }} gives:

Error: operator for the virtual field 'DragonInfos.cargocats' must be 'HOLDS', 'HOLDS NOT', 'HOLDS LIKE' or 'HOLDS NOT LIKE'.

{{DragonListFromElements| ancient | shadow | plant }} gives:

Error: operator for the virtual field 'DragonInfos.cargocats' must be 'HOLDS', 'HOLDS NOT', 'HOLDS LIKE' or 'HOLDS NOT LIKE'.

{{DragonListFromElements| tyrant | light | wind }} gives:

Error: operator for the virtual field 'DragonInfos.cargocats' must be 'HOLDS', 'HOLDS NOT', 'HOLDS LIKE' or 'HOLDS NOT LIKE'.

See Also

Generates a Cargo-powered list of dragons based on the provided Element(s). Only Dragons that have ALL specified elements (and the same number of elements) are returned. Boss Dragons are excluded.

Template parameters

ParameterDescriptionTypeStatus
1st Specified Element1

Name of the first Element to find, which is searched for in the "base", "second", and "third" columns of the "DragonInfos" Cargo table. As such, values are automatically converted to an uppercase first letter for matching purposes.

Example
Fire
Stringrequired
2nd Specified Element2

Name of the second Element to find, which is searched for in the "base", "second", and "third" columns of the "DragonInfos" Cargo table. As such, values are automatically converted to an uppercase first letter for matching purposes.

Example
Water
Stringoptional
3rd Specified Element3

Name of the third Element to find, which is searched for in the "base", "second", and "third" columns of the "DragonInfos" Cargo table. As such, values are automatically converted to an uppercase first letter for matching purposes.

Stringoptional
breedablebreedable

If not empty, the list outputs only Dragons that are always breedable (Category:Normally-Breedable Dragons)

Default
false
Example
true
Booleanoptional

Template:DragonListFromElements-Cargo


This Wiki is created by players for other players and is not maintained by, or affiliated with, the game maker (Gameloft).
Cookies help us deliver our services. By using our services, you agree to our use of cookies.