User:Electricsheep/sandbox: Difference between revisions
Jump to navigation
Jump to search
Content added Content deleted
No edit summary |
|||
Line 1:
__TOC__
=Cargo query test=
TODO: account for daily reset at 4
fix UL css
<ul>
{{#cargo_query:
tables =
| fields = Image,
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL
| order by = Start_date
| format = template
| template =
| 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>
{{#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
| order by =
| format = template
| template = FrontpageEvent
| named args = yes
| intro = ----
| default =
}}
</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)|=|=}}