Upcoming events
(Move old events, move others up, and add new dynamic event list and creation-box.) |
(no autofocus) |
||
(8 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
| tables = events | | tables = events | ||
| format = ul | | format = ul | ||
| fields = CONCAT('<strong>(',state,') ',DATE_FORMAT(start_date, '%Y %M %e, %W'),'</strong> | | fields = CONCAT('<strong>(',state,') ',DATE_FORMAT(start_date, '%Y %M %e, %W'),'</strong> — [[',_pageName,']] — ', location, '<br /><small>', IFNULL(description,'<em>No description</em>'),'</small>' ) | ||
| where = start_date>NOW() | | where = start_date > NOW() | ||
| order by = start_date ASC | | order by = start_date ASC | ||
| limit = 10 | | limit = 10 | ||
}} | }} | ||
{{#forminput:form=event |size=50 |button text=Create new event page |placeholder=Event title here |no autofocus }} | |||
[[Past events]] | [[Past events]] |
Revision as of 22:59, 9 November 2018
Error 1054: Unknown column 'state' in 'field list'
Function: CargoSQLQuery::run Query: SELECT `cargo__events`.`_pageID` AS `cargo_backlink_page_id_events`,CONCAT('<strong>(',state,') ',DATE_FORMAT(start_date, '%Y %M %e, %W'),'</strong> — ',_pageName,' — ', location, '<br /><small>', IFNULL(description,'<em>No description</em>'),'</small>' ) AS `CONCAT('<strong>(',state,') ',DATE FORMAT(start date, '%Y %M %e, %W'),'</strong> — ', pageName,' — ', location, '<br /><small>', IFNULL(description,'<em>No description</em>'),'</small>' )` FROM `cargo__events` WHERE start_date > NOW() ORDER BY `start_date` LIMIT 100