User:Electricsheep/sandbox: Difference between revisions
Jump to navigation
Jump to search
Content added Content deleted
No edit summary |
|||
Line 1: | Line 1: | ||
__TOC__ |
__TOC__ |
||
=Cargo query test= |
=Cargo query test= |
||
TODO: account for daily reset at 4 |
|||
fix UL css |
|||
<ul> |
|||
{{#cargo_query: |
{{#cargo_query: |
||
tables = |
tables = events |
||
| fields = Image, |
| fields = Image, NameEN, date_format(Start_date, '%m/%d')=sdate, date_format(End_date, '%m/%d')=edate |
||
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL |
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 4 DAY) AND Category="Event" AND Server="JP" |
||
| order by = Start_date |
| order by = Start_date ASC |
||
| format = template |
| format = template |
||
| template = |
| template = FrontpageEvent |
||
| named args = yes |
| named args = yes |
||
| default = |
|||
}} |
}} |
||
</ul> |
|||
<ul> |
|||
{{#cargo_query: |
|||
tables = events |
|||
| fields = Image, NameEN, date_format(Start_date, '%m/%d')=sdate, date_format(End_date, '%m/%d')=edate |
|||
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 4 DAY) AND Category="Rewards" AND Server="JP" |
|||
| order by = Start_date ASC |
|||
| format = template |
|||
| template = FrontpageEvent |
|||
| named args = yes |
|||
| default = |
|||
}} |
|||
</ul> |
|||
<ul> |
<ul> |
||
{{#cargo_query: |
{{#cargo_query: |
||
tables = events |
tables = events |
||
| fields = Image, NameEN, date_format(Start_date, '%m/%d')=sdate, date_format(End_date, '%m/%d')=edate |
| fields = Image, NameEN, date_format(Start_date, '%m/%d')=sdate, date_format(End_date, '%m/%d')=edate |
||
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL |
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 4 DAY) AND Category="Login" AND Server="JP" |
||
| order by = |
| order by = Start_date ASC |
||
| format = template |
| format = template |
||
| template = FrontpageEvent |
| template = FrontpageEvent |
||
| named args = yes |
| named args = yes |
||
| intro = ---- |
|||
| default = |
|||
}} |
}} |
||
</ul> |
</ul> |
Revision as of 07:38, 17 February 2022
Cargo query test
TODO: account for daily reset at 4 fix UL css
- Say-Bing!: 07/08 - 07/08
- Special Summer Mission! RABBIT SQUAD and the Mystery of the Missing Shrimp: 07/08 - 07/08
- Double Normal Missions rewards: 07/08 - 07/08
- Double Hard Missions rewards: 07/08 - 07/08
- Double Bounty Hunts rewards: 07/08 - 07/08
Cargo query test table output
More...Image | Character | Period |
---|---|---|
Kayoko (New Year) rerun |
07/09/2024 12:00 — 07/16/2024 12:00 | |
Haruka (New Year) rerun |
07/09/2024 12:00 — 07/16/2024 12:00 | |
Aru (New Year) rerun |
07/09/2024 12:00 — 07/16/2024 12:00 | |
Mutsuki (New Year) rerun |
07/09/2024 12:00 — 07/16/2024 12:00 | |
Serika (New Year) rerun |
07/09/2024 12:00 — 07/16/2024 12:00 | |
Hare (Camping) | 06/25/2024 12:00 — 07/09/2024 12:00 | |
Kotama (Camping) | 06/25/2024 12:00 — 07/09/2024 12:00 | |
Akane (Bunny Girl) rerun |
06/18/2024 12:00 — 06/25/2024 12:00 | |
Neru (Bunny Girl) rerun |
06/18/2024 12:00 — 06/25/2024 12:00 | |
Karin (Bunny Girl) rerun |
06/18/2024 12:00 — 06/25/2024 12:00 | |
Asuna (Bunny Girl) rerun |
06/18/2024 12:00 — 06/25/2024 12:00 | |
Himari rerun |
06/11/2024 12:00 — 06/18/2024 12:00 | |
Eimi (Swimsuit) | 06/11/2024 12:00 — 06/18/2024 12:00 | |
Renge | 05/28/2024 12:00 — 06/11/2024 12:00 | |
Kikyou | 05/28/2024 12:00 — 06/11/2024 12:00 | |
Saori rerun |
05/21/2024 12:00 — 05/28/2024 12:00 | |
Hiyori rerun |
05/21/2024 12:00 — 05/28/2024 12:00 | |
Shun rerun |
05/21/2024 12:00 — 05/28/2024 12:00 | |
Kokona rerun |
05/21/2024 12:00 — 05/28/2024 12:00 | |
Yukari | 05/14/2024 12:00 — 05/21/2024 12:00 | |
Misaka Mikoto Collab character |
04/30/2024 12:00 — 05/14/2024 12:00 | |
Shokuhou Misaki Collab character |
04/30/2024 12:00 — 05/14/2024 12:00 | |
Shigure rerun |
04/23/2024 12:00 — 04/30/2024 12:00 | |
Megu rerun |
04/23/2024 12:00 — 04/30/2024 12:00 | |
Ui rerun |
04/23/2024 12:00 — 04/30/2024 12:00 | |
Hinata rerun |
04/23/2024 12:00 — 04/30/2024 12:00 | |
Cherino (Hot Spring) rerun |
04/16/2024 12:00 — 04/23/2024 12:00 | |
Chinatsu (Hot Spring) rerun |
04/16/2024 12:00 — 04/23/2024 12:00 | |
Nodoka (Hot Spring) rerun |
04/16/2024 12:00 — 04/23/2024 12:00 | |
Shigure (Hot Spring) | 04/16/2024 12:00 — 04/23/2024 12:00 | |
Ichika | 04/02/2024 12:00 — 04/16/2024 12:00 | |
Kasumi | 04/02/2024 12:00 — 04/16/2024 12:00 | |
Ako rerun |
04/02/2024 12:00 — 04/16/2024 12:00 | |
Iori rerun |
04/02/2024 12:00 — 04/16/2024 12:00 | |
Haruna (Sportswear) | 03/21/2024 12:00 — 04/02/2024 12:00 | |
Yuuka (Sportswear) rerun |
03/21/2024 12:00 — 04/02/2024 12:00 | |
Mari (Sportswear) rerun |
03/21/2024 12:00 — 04/02/2024 12:00 | |
Utaha (Cheerleader) rerun |
03/12/2024 12:00 — 03/21/2024 12:00 | |
Noa rerun |
03/12/2024 12:00 — 03/21/2024 12:00 | |
Kotori (Cheerleader) | 03/12/2024 12:00 — 03/21/2024 12:00 | |
Marina rerun |
02/27/2024 12:00 — 03/12/2024 12:00 | |
Cherino rerun |
02/27/2024 12:00 — 03/12/2024 12:00 | |
Meru Momiji |
02/27/2024 12:00 — 03/12/2024 12:00 | |
Izuna (Swimsuit) rerun |
02/20/2024 12:00 — 02/27/2024 12:00 | |
Chise (Swimsuit) rerun |
02/20/2024 12:00 — 02/27/2024 12:00 | |
Mimori (Swimsuit) | 02/20/2024 12:00 — 02/27/2024 12:00 | |
Sumire | 02/15/2024 12:00 — 02/20/2024 12:00 | |
Eimi rerun |
02/15/2024 12:00 — 02/20/2024 12:00 | |
Hanako (Swimsuit) Festival Gacha — 3★ characters rate is doubled to 6% Includes Mika, Hoshino (Swimsuit), Wakamo |
02/08/2024 12:00 — 02/15/2024 12:00 | |
Wakamo Festival rerun Includes Hanako (Swimsuit), Mika, Hoshino (Swimsuit) |
02/08/2024 12:00 — 02/15/2024 12:00 | |
Ui (Swimsuit) | 01/30/2024 12:00 — 02/08/2024 12:00 | |
Hinata (Swimsuit) | 01/30/2024 12:00 — 02/08/2024 12:00 | |
Wakamo (Swimsuit) rerun |
01/23/2024 12:00 — 01/30/2024 12:00 | |
Nonomi (Swimsuit) rerun |
01/23/2024 12:00 — 01/30/2024 12:00 | |
Shiroko (Swimsuit) | 01/23/2024 12:00 — 01/30/2024 12:00 | |
Shun (Kid) Kirino rerun |
01/16/2024 12:00 — 01/23/2024 12:00 | |
Saya (Casual) rerun |
01/16/2024 12:00 — 01/23/2024 12:00 | |
Kokona rerun |
01/16/2024 12:00 — 01/23/2024 12:00 | |
Hina (Swimsuit) rerun |
01/09/2024 12:00 — 01/16/2024 12:00 | |
Iori (Swimsuit) rerun |
01/09/2024 12:00 — 01/16/2024 12:00 | |
Miyako (Swimsuit) | 12/26/2023 12:00 — 01/09/2024 12:00 | |
Saki (Swimsuit) | 12/26/2023 12:00 — 01/09/2024 12:00 | |
Miyu rerun |
12/19/2023 12:00 — 12/26/2023 12:00 | |
Moe rerun |
12/19/2023 12:00 — 12/26/2023 12:00 | |
Miyako rerun |
12/12/2023 12:00 — 12/19/2023 12:00 | |
Saki rerun |
12/12/2023 12:00 — 12/19/2023 12:00 | |
Minori | 12/12/2023 12:00 — 12/19/2023 12:00 | |
Rumi | 11/28/2023 12:00 — 12/12/2023 12:00 | |
Mina | 11/28/2023 12:00 — 12/12/2023 12:00 | |
Azusa (Swimsuit) rerun |
11/21/2023 12:00 — 11/28/2023 12:00 | |
Mashiro (Swimsuit) rerun |
11/21/2023 12:00 — 11/28/2023 12:00 | |
Hifumi (Swimsuit) rerun |
11/21/2023 12:00 — 11/28/2023 12:00 | |
Kazusa rerun |
11/14/2023 12:00 — 11/21/2023 12:00 | |
Natsu Mari rerun |
11/14/2023 12:00 — 11/21/2023 12:00 | |
Reisa | 11/14/2023 12:00 — 11/21/2023 12:00 | |
Arisu (Maid) | 10/31/2023 12:00 — 11/14/2023 12:00 | |
Toki (Bunny Girl) | 10/31/2023 12:00 — 11/14/2023 12:00 | |
Kaho | 10/24/2023 12:00 — 10/31/2023 12:00 | |
Kaede rerun |
10/24/2023 12:00 — 10/31/2023 12:00 | |
Iroha rerun |
10/24/2023 12:00 — 10/31/2023 12:00 | |
Tsukuyo rerun |
10/24/2023 12:00 — 10/31/2023 12:00 | |
Marina rerun |
10/17/2023 12:00 — 10/24/2023 12:00 | |
Cherino rerun |
10/17/2023 12:00 — 10/24/2023 12:00 | |
Izuna Shizuko rerun |
10/10/2023 12:00 — 10/17/2023 12:00 | |
Mimori rerun |
10/10/2023 12:00 — 10/17/2023 12:00 | |
Kayoko (New Year) | 09/26/2023 12:00 — 10/10/2023 12:00 | |
Haruka (New Year) | 09/26/2023 12:00 — 10/10/2023 12:00 | |
Aru (New Year) rerun |
09/26/2023 12:00 — 10/10/2023 12:00 | |
Mutsuki (New Year) rerun |
09/26/2023 12:00 — 10/10/2023 12:00 | |
Serika (New Year) rerun |
09/26/2023 12:00 — 10/10/2023 12:00 | |
Shiroko (Riding) rerun |
09/19/2023 12:00 — 09/26/2023 12:00 | |
Azusa Hanako rerun |
09/19/2023 12:00 — 09/26/2023 12:00 | |
Koyuki | 09/05/2023 12:00 — 09/19/2023 12:00 | |
Shiroko rerun |
09/05/2023 12:00 — 09/19/2023 12:00 | |
Toki | 08/22/2023 12:00 — 09/05/2023 12:00 | |
Nagisa | 08/22/2023 12:00 — 09/05/2023 12:00 | |
Sakurako | 08/11/2023 12:00 — 08/22/2023 12:00 | |
Ui rerun |
08/11/2023 12:00 — 08/22/2023 12:00 | |
Hinata rerun |
08/11/2023 12:00 — 08/22/2023 12:00 | |
Megu | 08/01/2023 12:00 — 08/11/2023 12:00 |
Sounds test
<audio controls="" preload="none" src="https://static.miraheze.org/bluearchivewiki/8/80/Airi_Title.ogg"> Your browser does not support the <code>audio</code> element. </audio>
<audio id="voice-preview" src="https://static.miraheze.org/bluearchivewiki/8/80/Airi_Title.ogg"></audio>
<audio id="voice-preview" src="https://static.miraheze.org/bluearchivewiki/8/80/Airi_Title.ogg"></audio>
//static.miraheze.org/bluearchivewiki/8/8e/Icon_sound.png
//static.miraheze.org/bluearchivewiki/8/80/Airi_Title.ogg
//static.miraheze.org/bluearchivewiki/8/80/Airi_Title.ogg
Arona is busy
DPL transclusion test
{{CharacterAffectionTable}.default|Aru (New Year)=Aru (New Year)|Aru (New Year)=Aru (New Year)|=|=}}