Template: Event
Tag: Rollback |
ignoring sub-pages |
||
| Line 158: | Line 158: | ||
| tables = events | | tables = events | ||
| fields = CONCAT('[[',_pageName,']]<br><small>',DATE_FORMAT(start_date, '%e %M %Y'),'</small>')=prev_event | | fields = CONCAT('[[',_pageName,']]<br><small>',DATE_FORMAT(start_date, '%e %M %Y'),'</small>')=prev_event | ||
| where = _pageID != '{{PAGEID}}' AND region = '{{{region|{{{state|}}}}}}' AND start_date IS NOT NULL AND start_date < '{{{start_date}}}' | | where = _pageID != '{{PAGEID}}' AND region = '{{{region|{{{state|}}}}}}' AND start_date IS NOT NULL AND start_date < '{{{start_date}}}' AND _pageName NOT LIKE '%/%' | ||
| order by = start_date DESC | | order by = start_date DESC | ||
| limit = 1 | | limit = 1 | ||
| Line 167: | Line 167: | ||
| tables = events | | tables = events | ||
| fields = CONCAT('[[',_pageName,']]<br><small>',DATE_FORMAT(start_date, '%e %M %Y'),'</small>')=next_event | | fields = CONCAT('[[',_pageName,']]<br><small>',DATE_FORMAT(start_date, '%e %M %Y'),'</small>')=next_event | ||
| where = _pageID != '{{PAGEID}}' AND region = '{{{region|{{{state|}}}}}}' AND start_date IS NOT NULL AND start_date > '{{{start_date}}}' | | where = _pageID != '{{PAGEID}}' AND region = '{{{region|{{{state|}}}}}}' AND start_date IS NOT NULL AND start_date > '{{{start_date}}}' AND _pageName NOT LIKE '%/%' | ||
| order by = start_date ASC | | order by = start_date ASC | ||
| limit = 1 | | limit = 1 | ||
Revision as of 04:59, 13 November 2025
This template defines the table "events". View table.
Event
Event
Link (if applicable): Copy link – or download calendar item (.ics)
[edit] 
Template documentation
Template documentationOnce an event name has been supplied in the following box and you have clicked "Create Event Page", you will find a new page titled "Creating PAGENAME", containing a preloaded template information which you need to fill in accordance with the guidance given. The guidelines are included within <!-- and --> and your responses need to remain out of them. Any text between <!-- and --> does not appear in the reading mode. The following image has some ideas that could help:
