<?php

require_once("/usr/lib/wangerin/standard_functions.php");

$like = urlencode(substr($_SERVER["PATH_INFO"],1));

if (!$like) $like = "installfest' OR activity LIKE 'linuxaften";

foreach(query("		###############################################
			SELECT	*
			FROM	dates
			LEFT JOIN activities USING(activity)
			WHERE	CONCAT(date,' ',CASE
							WHEN NOT(ISNULL(dates.start))		THEN dates.start
							WHEN NOT(ISNULL(activities.start))	THEN activities.start
												ELSE '00:00'
						END) >= NOW() AND
				(activity LIKE '".$like."%')
			ORDER BY date
			LIMIT 1
			###############################################") AS $next)
	echo json_encode($next,JSON_PRETTY_PRINT);