Difference between revisions of "User:Mornsta/Sandbox6"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Mornsta-gpuser
>Mornsta-gpuser
Line 1: Line 1:
−
{{{!}} class="wikitable" style="width:100%"
+
<div style="min-width:150px;margin:5px;text-align:center;border:1px solid #9aa99a;">
−
{{!}}- style="text-align:center;"
+
<div style="margin:5px 5px 0;font-weight:bold;background-color:#87cc93;">New Adventurers</div>
−
! Level !! HP +% !! Str +% !! Damage +% {{Tooltip|(Event)|This Damage boost will only be active during its associated event and will disappear after the event ends.}} !! {{Rupies}} Cost !! Materials Needed
+
{{#cargo_query:tables=Adventurers
−
!Total Materials to Max Level!! Build Time
+
|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>')
−
{{!}}- style="text-align:right;"
+
|where=ReleaseDate="{{#cargo_query:tables=Adventurers
−
{{!}}  1 {{!}}{{!}} 1 {{!}}{{!}} 0 {{!}}{{!}} 5 {{!}}{{!}} — {{!}}{{!}} style="text-align:left;" {{!}} —
+
|fields=ReleaseDate
−
|style="text-align:left;"|{{{{{1|}}}-}} x7,816{{!}}{{!}} —
+
|where= DATEDIFF(ReleaseDate,NOW()) <= 0
−
{{!}}- style="text-align:right;"
+
|group by=ReleaseDate
−
{{!}}  2 {{!}}{{!}} 1.5 {{!}}{{!}} 0 {{!}}{{!}} 10 {{!}}{{!}} 100 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x3
+
|order by=ReleaseDate DESC
−
|style="text-align:left;"|{{{{{1|}}}-}} x7,816{{!}}{{!}} 3 min
+
|limit=1
−
{{!}}- style="text-align:right;"
+
|more results text=
−
{{!}}  3 {{!}}{{!}} 1.5 {{!}}{{!}} 0.5 {{!}}{{!}} 15 {{!}}{{!}} 200 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x5
+
|no html
−
|style="text-align:left;"|{{{{{1|}}}-}} x7,813{{!}}{{!}} 3 min
+
}}"
−
{{!}}- style="text-align:right;"
+
|group by=_pageName
−
{{!}}  4 {{!}}{{!}} 2 {{!}}{{!}} 0.5 {{!}}{{!}} 20 {{!}}{{!}} 300 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x7
+
|order by= ReleaseDate DESC, Rarity DESC, Id DESC, VariationId
−
|style="text-align:left;"|{{{{{1|}}}-}} x7,808{{!}}{{!}} 3 min
+
|more results text=
−
{{!}}- style="text-align:right;"
+
|delimiter=
−
{{!}}  5 {{!}}{{!}} 2 {{!}}{{!}} 1 {{!}}{{!}} 25 {{!}}{{!}} 400 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x10
+
|default=''No recent adventurers.''
−
|style="text-align:left;"|{{{{{1|}}}-}} x7,801{{!}}{{!}} 3 min
+
}}
−
{{!}}- style="text-align:right;"
+
</div>
−
{{!}}  6 {{!}}{{!}} 2.5 {{!}}{{!}} 1 {{!}}{{!}} 30 {{!}}{{!}} 500 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x12
+
 
−
|style="text-align:left;"|{{{{{1|}}}-}} x7,791{{!}}{{!}} 5 min
+
<div style="min-width:150px;margin:5px;text-align:center;border:1px solid #9aa99a;">
−
{{!}}- style="text-align:right;"
+
<div style="margin:5px 5px 0;font-weight:bold;background-color:#9a69c7;">New Dragons</div>
−
{{!}}  7 {{!}}{{!}} 2.5 {{!}}{{!}} 1.5 {{!}}{{!}} 35 {{!}}{{!}} 600 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x15
+
{{#cargo_query:tables=Dragons
−
|style="text-align:left;"|{{{{{1|}}}-}} x7,779{{!}}{{!}} 5 min
+
|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>')
−
{{!}}- style="text-align:right;"
+
|where=ReleaseDate="{{#cargo_query:tables=Dragons
−
{{!}}  8 {{!}}{{!}} 3 {{!}}{{!}} 1.5 {{!}}{{!}} 40 {{!}}{{!}} 700 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x18
+
|fields=ReleaseDate
−
|style="text-align:left;"|{{{{{1|}}}-}} x7,764{{!}}{{!}} 5 min
+
|where= DATEDIFF(ReleaseDate,NOW()) <= 0
−
{{!}}- style="text-align:right;"
+
|group by=ReleaseDate
−
{{!}}  9 {{!}}{{!}} 3 {{!}}{{!}} 2 {{!}}{{!}} 45 {{!}}{{!}} 800 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x21
+
|order by=ReleaseDate DESC
−
|style="text-align:left;"|{{{{{1|}}}-}} x7,746{{!}}{{!}} 10 min
+
|limit=1
−
{{!}}- style="text-align:right;"
+
|more results text=
−
{{!}} 10 {{!}}{{!}} 3.5 {{!}}{{!}} 2 {{!}}{{!}} 50 {{!}}{{!}} 1,000 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x25
+
|no html
−
|style="text-align:left;"|{{{{{1|}}}-}} x7,725{{!}}{{!}} 10 min
+
}}"
−
{{!}}- style="text-align:right;"
+
|order by=ReleaseDate DESC, Rarity DESC, BaseId DESC, VariationId
−
{{!}} 11 {{!}}{{!}} 3.5 {{!}}{{!}} 2.5 {{!}}{{!}} 55 {{!}}{{!}} 1,200 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x30
+
|more results text=
−
|style="text-align:left;"|{{{{{1|}}}-}} x7,700{{!}}{{!}} 30 min
+
|delimiter=
−
{{!}}- style="text-align:right;"
+
|default=''No recent dragons.''
−
{{!}} 12 {{!}}{{!}} 4 {{!}}{{!}} 2.5 {{!}}{{!}} 60 {{!}}{{!}} 1,400 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x50
+
}}
−
|style="text-align:left;"|{{{{{1|}}}-}} x7,670{{!}}{{!}} 30 min
+
</div>
−
{{!}}- style="text-align:right;"
+
 
−
{{!}} 13 {{!}}{{!}} 4 {{!}}{{!}} 3 {{!}}{{!}} 65 {{!}}{{!}} 1,600 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x70
+
<div style="min-width:150px;margin:5px;text-align:center;border:1px solid #9aa99a;">
−
|style="text-align:left;"|{{{{{1|}}}-}} x7,620{{!}}{{!}} 30 min
+
<div style="margin:5px 5px 0;font-weight:bold;background-color:#699dc7;">New Wyrmprints</div>
−
{{!}}- style="text-align:right;"
+
{{#cargo_query:tables=Wyrmprints
−
{{!}} 14 {{!}}{{!}} 4.5 {{!}}{{!}} 3 {{!}}{{!}} 70 {{!}}{{!}} 1,800 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x90
+
|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>')
−
|style="text-align:left;"|{{{{{1|}}}-}} x7,550{{!}}{{!}} 30 min
+
|where=ReleaseDate="{{#cargo_query:tables=Wyrmprints
−
{{!}}- style="text-align:right;"
+
|fields=ReleaseDate
−
{{!}} 15 {{!}}{{!}} 4.5 {{!}}{{!}} 3.5 {{!}}{{!}} 75 {{!}}{{!}} 2,000 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x120
+
|where= DATEDIFF(ReleaseDate,NOW()) <= 0
−
|style="text-align:left;"|{{{{{1|}}}-}} x7,460{{!}}{{!}} 30 min
+
|group by=ReleaseDate
−
{{!}}- style="text-align:right;"
+
|order by=ReleaseDate DESC
−
{{!}} 16 {{!}}{{!}} 5 {{!}}{{!}} 3.5 {{!}}{{!}} 80 {{!}}{{!}} 2,200 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x150
+
|limit=1
−
|style="text-align:left;"|{{{{{1|}}}-}} x7,340{{!}}{{!}} 1 hr
+
|more results text=
−
{{!}}- style="text-align:right;"
+
|no html
−
{{!}} 17 {{!}}{{!}} 5 {{!}}{{!}} 4 {{!}}{{!}} 85 {{!}}{{!}} 2,400 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x180
+
}}"
−
|style="text-align:left;"|{{{{{1|}}}-}} x7,190{{!}}{{!}} 1 hr
+
|group by=_pageName
−
{{!}}- style="text-align:right;"
+
|order by=ReleaseDate DESC, Rarity DESC, BaseId DESC
−
{{!}} 18 {{!}}{{!}} 5.5 {{!}}{{!}} 4 {{!}}{{!}} 90 {{!}}{{!}} 2,600 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x210
+
|more results text=
−
|style="text-align:left;"|{{{{{1|}}}-}} x7,010{{!}}{{!}} 1 hr
+
|delimiter=
−
{{!}}- style="text-align:right;"
+
|default=''No recent wyrmprints.''
−
{{!}} 19 {{!}}{{!}} 5.5 {{!}}{{!}} 4.5 {{!}}{{!}} 95 {{!}}{{!}} 2,800 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x250
+
}}
−
|style="text-align:left;"|{{{{{1|}}}-}} x6,800{{!}}{{!}} 1 hr
+
</div>
−
{{!}}- style="text-align:right;"
 
−
{{!}} 20 {{!}}{{!}} 6 {{!}}{{!}} 4.5 {{!}}{{!}} 100 {{!}}{{!}} 3,000 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x300
 
−
|style="text-align:left;"|{{{{{1|}}}-}} x6,550{{!}}{{!}} 1 hr
 
−
{{!}}- style="text-align:right;"
 
−
{{!}} 21 {{!}}{{!}} 6 {{!}}{{!}} 5 {{!}}{{!}} 105 {{!}}{{!}} 3,200 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x350
 
−
|style="text-align:left;"|{{{{{1|}}}-}} x6,250{{!}}{{!}} 6 hr
 
−
{{!}}- style="text-align:right;"
 
−
{{!}} 22 {{!}}{{!}} 6.5 {{!}}{{!}} 5 {{!}}{{!}} 110 {{!}}{{!}} 3,400 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x400
 
−
|style="text-align:left;"|{{{{{1|}}}-}} x5,900{{!}}{{!}} 6 hr
 
−
{{!}}- style="text-align:right;"
 
−
{{!}} 23 {{!}}{{!}} 6.5 {{!}}{{!}} 5.5 {{!}}{{!}} 115 {{!}}{{!}} 3,600 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x450
 
−
|style="text-align:left;"|{{{{{1|}}}-}} x5,500{{!}}{{!}} 6 hr
 
−
{{!}}- style="text-align:right;"
 
−
{{!}} 24 {{!}}{{!}} 7 {{!}}{{!}} 5.5 {{!}}{{!}} 120 {{!}}{{!}} 3,800 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x500
 
−
|style="text-align:left;"|{{{{{1|}}}-}} x5,050{{!}}{{!}} 6 hr
 
−
{{!}}- style="text-align:right;"
 
−
{{!}} 25 {{!}}{{!}} 7 {{!}}{{!}} 6 {{!}}{{!}} 125 {{!}}{{!}} 4,000 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x550
 
−
|style="text-align:left;"|{{{{{1|}}}-}} x4,550{{!}}{{!}} 6 hr
 
−
{{!}}- style="text-align:right;"
 
−
{{!}} 26 {{!}}{{!}} 7.5 {{!}}{{!}} 6 {{!}}{{!}} 130 {{!}}{{!}} 4,200 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x600
 
−
|style="text-align:left;"|{{{{{1|}}}-}} x4,000{{!}}{{!}} 12 hr
 
−
{{!}}- style="text-align:right;"
 
−
{{!}} 27 {{!}}{{!}} 7.5 {{!}}{{!}} 6.5 {{!}}{{!}} 135 {{!}}{{!}} 4,400 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x700
 
−
|style="text-align:left;"|{{{{{1|}}}-}} x3,400{{!}}{{!}} 12 hr
 
−
{{!}}- style="text-align:right;"
 
−
{{!}} 28 {{!}}{{!}} 8 {{!}}{{!}} 6.5 {{!}}{{!}} 140 {{!}}{{!}} 4,600 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x800
 
−
|style="text-align:left;"|{{{{{1|}}}-}} x2,700{{!}}{{!}} 12 hr
 
−
{{!}}- style="text-align:right;"
 
−
{{!}} 29 {{!}}{{!}} 8 {{!}}{{!}} 7 {{!}}{{!}} 145 {{!}}{{!}} 4,800 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x900
 
−
|style="text-align:left;"|{{{{{1|}}}-}} x1,900{{!}}{{!}} 12 hr
 
−
{{!}}- style="text-align:right;"
 
−
{{!}} 30 {{!}}{{!}} 8.5 {{!}}{{!}} 7 {{!}}{{!}} 150 {{!}}{{!}} 5,000 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x1,000
 
−
|style="text-align:left;"|{{{{{1|}}}-}} x1,000{{!}}{{!}} 12 hr
 
−
{{!}}- style="text-align:right;"
 
−
{{!}}style="text-align:center;" colspan="4"{{!}}Total {{!}}{{!}} 66,600 {{!}}{{!}} style="text-align:left;" {{!}} {{{{{1|}}}-}} x7,816
 
−
|style="text-align:left;"|{{{{{1|}}}-}} x7,816{{!}}{{!}} 4.1 days
 
−
{{!}}}
 

Revision as of 08:07, 16 January 2019

New Adventurers
Error: Table Adventurers not found.
New Dragons
Error: Table Dragons not found.
New Wyrmprints
Error: Table Wyrmprints not found.
Retrieved from "https://dlwiki.cherrymint.live/index.php?title=User:Mornsta/Sandbox6&oldid=215444"