CrystalClear/Sandbox2

Events

Need a new Cargo column for storing event dragons (currently a DPL3 function, as needed cargo function is broken in this version and hasn't been verified working correctly in latest version), need a new column for icons that replaces "note" one used. Needs template formatting to work with all values.

Event Name	Event Date	Event Type	Prize Dragon(s)
Cake Craze (23/01/02)	2023-01-02	Cake Craze	Arctic
Clan Siege (23/01/02)	2023-01-02	Clan
Movie Marathon (23/01/02)	2023-01-02	Movie Marathon
Bottomless Dungeon (23/01/02)	2023-01-02	Bottomless Dungeon	Jellyfish
Dragonmaster Pass (23/01/04)	2023-01-04	Milestone Rewards	Sabertooth

More...

6 June 2023

Other

Reminder for myself (in progress): Need to test the next version.

Sunrise Dragon

Another

Seems it is _categories that isn't working correctly. Interesting, likely due to them being added in the template used on these pages without page touch/save. Nope, that's not it. Some pages have categories, some don't. Even when they exist on page save.

{{#cargo_query:
tables=EventInfos, _pageData
|fields=EventInfos.type=Type, EventInfos._pageName=Event Name, EventInfos.started=Started, EventInfos.duration=Duration, EventInfos.ended=Ended
|where=_pageData._fullText MATCHES '"dragon{{=}}Sunrise" "prize{{=}}Sunrise" "dungeonoffer{{=}}Sunrise" "di{{!}}Sunrise{{!}}2"'
|join on=EventInfos._pageName=_pageData._pageName
|order by=EventInfos.started ASC
|limit=5
}}

Type	Event Name	Started	Duration	Ended
Solo	Lighting the Way (16/02/05)	2016-02-05	10 Days 5 Hours	2016-02-15
Relay	Boss Challenge (18/02/26)	2018-02-26	7 Days	2018-03-05
Castle	Heaven & Earth (19/09/27)	2019-09-27	10 Days	2019-10-07
Bottomless Dungeon	Bottomless Dungeon (21/11/08)	2021-11-08	7 Days	2021-11-15
Gem Spending	Gem Extravaganza (22/04/25)	2022-04-25	4 Days	2022-04-29

More...

New test

Still missing one result (Boss Challenge (18/02/26)) from Sunrise Dragon events (this is just finding and listing event pages that contain the query conditions ("where" text) and displaying page name and excerpts of full text, without formatting into a proper event table). Not sure why all full-text matches aren't provided. I need an accurate count of events containing the condition text. Swapping quote type doesn't work. Null edit on missing event page doesn't work. Event is in the table of results that should be found.

{{#cargo_query:
tables=_pageData
|fields=_pageName=Event,_fullText=Result
|where=_fullText MATCHES '"dragon{{=}}Sunrise" "prize{{=}}Sunrise" "dungeonoffer{{=}}Sunrise" "di{{!}}Sunrise{{!}}2"' AND _categories HOLDS 'Events'
}}

Event	Result
Bottomless Dungeon (21/11/08)	prize= Pigsy \|dungeonoffer= Sunrise \|note= \|icons=Ancient Ticket (Shadow), Ancient (Element) \|text=The event took place during the Origin of ...
Gem Extravaganza (22/04/25)	type=Gem Spending \|duration=4 Days \|prize=Torch \|dragon=Sunrise \|vip=VIP ...
Lighting the Way (16/02/05)	==Rewards & Timetable== [[File:Lighting the Way (16.02.05) Promotion 2.jpg\|300px\|right]] The amount of Food ...

Old test

{{#cargo_query:
tables=_pageData
|fields=_pageName=Event,_fullText=Result
|where=_fullText MATCHES '"prize=Sunrise" "dragon=Sunrise" "File:Sunrise"' AND _categories HOLDS 'Events'
}}

Event	Result
Gem Extravaganza (22/04/25)	type=Gem Spending \|duration=4 Days \|prize=Torch \|dragon=Sunrise \|vip=VIP ...
Lighting the Way (16/02/05)	==Rewards & Timetable== [[File:Lighting the Way (16.02.05) Promotion 2.jpg\|300px\|right]] The amount of Food ...

User