User:ChaoticShadow/sandbox/8: Difference between revisions

From Sekaipedia
Content added Content deleted
mNo edit summary
mNo edit summary
 
(12 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{ #invoke:Chart | bar chart
<div style="display: inline-block; margin-right: 5px">
| height = 750
<div style="border-radius:6px; background-color:#FFA900; font-weight: bold; text-align: center; margin-bottom: 5px; padding: 5px">Hard Preview</div>
| width = 500
<div style="display:flex; flex-wrap:wrap; gap: 5px">
| stack = 1
<div style="flex: 1 0 1px; text-align: center;"><youtube width="320" height="180">BfO7ceHcMW4</youtube></div>
| group 1 = 1: 1: 1: 1
<div style="display:grid; grid-template-columns: 1fr 1fr; grid-auto-rows: min-content; gap: 5px">
| group 2 = 3: 3: 2: 2
<div style="border-radius:6px; background-color:#a7ee75; padding: 5px 10px">Release Date</div>
| group 3 = 2: 3: 3: 2
<div style="padding: 5px">2021/08/18</div>
| group 4 = 5: 4: 5: 5
<div style="border-radius:6px; background-color:#a7ee75; padding: 5px 10px">Illust</div>
| group 5 = 0: 0: 1: 0
<div style="padding: 5px">Sidu</div>
| colors = turquoise : grey : orange: pink : purple
<div style="border-radius:6px; background-color:#a7ee75; padding: 5px 10px">Movie</div>
| group names = 1* : 2* : 3* : 4* : Birthday
<div style="padding: 5px">Lye</div>
| x legends = Ichika : Saki : Honami : Shiho
</div>
| y tick marks = 5
</div>
}}
</div>


{{#cargo_query:
<div style="display: inline-block; margin-right: 5px">
tables=Cards
<div style="border-radius:6px; background-color:#FFA900; font-weight: bold; text-align: center; margin-bottom: 5px; padding: 5px">Hard Preview</div>
|fields=COUNT(Cards.card_id)
<div style="display:flex; flex-wrap:wrap; gap: 5px">
|where=card_id > 0 AND card_character = 'Hoshino Ichika'
<div style="flex: 1 0 1px; text-align: center;"><youtube width="320" height="180">BfO7ceHcMW4</youtube></div>
|group by=Cards.rarity
<div style="display:grid; grid-template-columns: 1fr 1fr; grid-auto-rows: min-content; gap: 5px">
|order by=Cards.rarity ASC
<div style="border-radius:6px; background-color:#a7ee75; padding: 5px 10px">Release Date</div>
|format=list
<div style="padding: 5px">2021/08/18</div>
|delimiter=:
<div style="border-radius:6px; background-color:#a7ee75; padding: 5px 10px">Illust</div>
}}
<div style="padding: 5px">Sidu</div>
<div style="border-radius:6px; background-color:#a7ee75; padding: 5px 10px">Movie</div>
<div style="padding: 5px">Lye</div>
</div>
</div>
</div>


{{#cargo_query:
tables=Cards
|fields=COUNT(Cards.card_id)
|where=card_id > 0 AND card_character = 'Tenma Saki'
|group by=Cards.rarity
|order by=Cards.rarity ASC
|format=list
|delimiter= :
}}


{{#cargo_query:
<div style="display: inline-block; margin-right: 5px">
tables=Cards
<div style="border-radius:6px; background-color:#FFA900; font-weight: bold; text-align: center; margin-bottom: 5px; padding: 5px">Hard Preview</div>
|fields=COUNT(Cards.card_id)
<div style="display:flex; flex-wrap:wrap; gap: 5px">
|where=card_id > 0 AND card_character = 'Mochizuki Honami'
<div style="flex: 1 0 1px; text-align: center;"><youtube width="320" height="180">BfO7ceHcMW4</youtube></div>
|group by=Cards.rarity
<div style="display:grid; grid-template-columns: 1fr 1fr; grid-auto-rows: min-content; gap: 5px">
|order by=Cards.rarity ASC
<div style="border-radius:6px; background-color:#a7ee75; padding: 5px 10px">Release Date</div>
|format=list
<div style="padding: 5px">2021/08/18</div>
|delimiter= :
<div style="border-radius:6px; background-color:#a7ee75; padding: 5px 10px">Illust</div>
}}
<div style="padding: 5px">Sidu</div>

<div style="border-radius:6px; background-color:#a7ee75; padding: 5px 10px">Movie</div>

<div style="padding: 5px">Lye</div>
{{#cargo_query:
</div>
tables=Cards
</div>
|fields=COUNT(Cards.card_id)
</div>
|where=card_id > 0 AND card_character = 'Hinomori Shiho'
|group by=Cards.rarity
|order by=Cards.rarity ASC
|format=list
|delimiter= :
}}

{{#cargo_query:
tables=Cards
|fields=Cards.card_character, Cards.rarity, COUNT(Cards.card_character)
|where=Cards.card_id > 0
|group by=Cards.card_character, Cards.rarity
|limit=200
|format=table
}}

Latest revision as of 09:22, 29 November 2021

3
6
9
12
15
Ichika
Saki
Honami
Shiho
  •   1*
  •   2*
  •   3*
  •   4*
  •   Birthday
Error: No database table exists named "Cards".
Error: No database table exists named "Cards".
Error: No database table exists named "Cards".


Error: No database table exists named "Cards".
Error: No database table exists named "Cards".
Cookies help us deliver our services. By using our services, you agree to our use of cookies.