From Church of Illuminati

Contents 1 TS config 1.1 listView 2 Trouble 3 Notes 3.1 Database 3.1.1 Bad code 3.1.2 Good code 4 See also 5 Bugs 5.1 TypoScript

TS config

pastOrFuture

If negative only events in the past are shown, if positive only events in the future are shown. If zero all events are shown. Today is regarded as future.

debug_query

0/1

listView

searchBox = 0

browseresults = 1

Trouble

more_info isn't a link

Make sure listView.linked_page_id isn't set to point to a nonexistant page.

Notes

Database

tx_julleevents_events.category är ett heltal, antalet relationer för event till kategori

Bad code

SELECT tx_julleevents_events.*, tx_julleevents_categories.uid as cuid 
FROM tx_julleevents_events,tx_julleevents_events_category_mm,tx_julleevents_categories 
WHERE tx_julleevents_events.uid=tx_julleevents_events_category_mm.uid_local 
AND tx_julleevents_categories.uid=tx_julleevents_events_category_mm.uid_foreign 
ORDER BY date

Good code

SELECT tx_julleevents_events.* 
FROM tx_julleevents_events,tx_julleevents_categories,tx_julleevents_events_category_mm 
WHERE tx_julleevents_events.uid=tx_julleevents_events_category_mm.uid_local 
AND tx_julleevents_categories.uid=tx_julleevents_events_category_mm.uid_foreign 
AND tx_julleevents_categories.uid IN (57) 
AND tx_julleevents_events.pid IN (17) 
AND tx_julleevents_events.deleted=0 
AND tx_julleevents_events.hidden=0 
AND (tx_julleevents_events.starttime<=1219909959) 
AND (tx_julleevents_events.endtime=0 
OR tx_julleevents_events.endtime>1219909959) 
ORDER BY date LIMIT 0,10

See also

• Typo3 database API
• exec_SELECTquery vs pi_list_query

Bugs

TypoScript

category property screws on csl, only int works as intended