Difference between revisions of "User:Mornsta/Sandbox6"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Mornsta-gpuser
>Mornsta-gpuser
(Blanked the page)
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
<div style="min-width:150px;margin:5px;text-align:center;border:1px solid #9aa99a;">
 
−
<div style="margin:5px 5px 0;font-weight:bold;background-color:#87cc93;">New Adventurers</div>
 
−
{{#cargo_query:tables=Adventurers
 
−
|fields=CONCAT('<div style="display:inline-block; width: 65px; margin: 0 3px 0 3px; vertical-align:top;">[[File:', Id, ' 0', VariationId,' r0',Rarity,'.png|60px|link=',_pageName,']]</br>[[' , _pageName, ']]</div>')
 
−
|where=ReleaseDate="{{#cargo_query:tables=Adventurers
 
−
|fields=ReleaseDate
 
−
|where= DATEDIFF(ReleaseDate,NOW()) <= 0
 
−
|group by=ReleaseDate
 
−
|order by=ReleaseDate DESC
 
−
|limit=1
 
−
|more results text=
 
−
|no html
 
−
}}"
 
−
|group by=_pageName
 
−
|order by= ReleaseDate DESC, Rarity DESC, Id DESC, VariationId
 
−
|more results text=
 
−
|delimiter=
 
−
|default=''No recent adventurers.''
 
−
}}
 
−
</div>
 
  
−
<div style="min-width:150px;margin:5px;text-align:center;border:1px solid #9aa99a;">
 
−
<div style="margin:5px 5px 0;font-weight:bold;background-color:#9a69c7;">New Dragons</div>
 
−
{{#cargo_query:tables=Dragons
 
−
|fields=CONCAT('<div style="display:inline-block; width: 65px; margin: 0 3px 0 3px; vertical-align:top;">[[File:', BaseId, ' 0', VariationId, '.png|60px|link=',_pageName,']]</br>[[' , _pageName, ']]</div>')
 
−
|where=ReleaseDate="{{#cargo_query:tables=Dragons
 
−
|fields=ReleaseDate
 
−
|where= DATEDIFF(ReleaseDate,NOW()) <= 0
 
−
|group by=ReleaseDate
 
−
|order by=ReleaseDate DESC
 
−
|limit=1
 
−
|more results text=
 
−
|no html
 
−
}}"
 
−
|order by=ReleaseDate DESC, Rarity DESC, BaseId DESC, VariationId
 
−
|more results text=
 
−
|delimiter=
 
−
|default=''No recent dragons.''
 
−
}}
 
−
</div>
 
−
 
−
<div style="min-width:150px;margin:5px;text-align:center;border:1px solid #9aa99a;">
 
−
<div style="margin:5px 5px 0;font-weight:bold;background-color:#699dc7;">New Wyrmprints</div>
 
−
{{#cargo_query:tables=Wyrmprints
 
−
|fields=CONCAT('<div style="display:inline-block; width: 65px; margin: 0 3px 0 3px; vertical-align:top;">[[File:', BaseId, ' 01', '.png|60px|link=',_pageName,']]</br>[[' , _pageName, ']]</div>')
 
−
|where=ReleaseDate="{{#cargo_query:tables=Wyrmprints
 
−
|fields=ReleaseDate
 
−
|where= DATEDIFF(ReleaseDate,NOW()) <= 0
 
−
|group by=ReleaseDate
 
−
|order by=ReleaseDate DESC
 
−
|limit=1
 
−
|more results text=
 
−
|no html
 
−
}}"
 
−
|group by=_pageName
 
−
|order by=ReleaseDate DESC, Rarity DESC, BaseId DESC
 
−
|more results text=
 
−
|delimiter=
 
−
|default=''No recent wyrmprints.''
 
−
}}
 
−
</div>
 

Latest revision as of 02:29, 23 March 2019

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