<?php

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

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

$data = array();
$installfest = 0;
foreach($q = query_array("		###############################################
			SELECT	date,
				activity,
				location,
#//				IF(ISNULL(start),	'activities.start',	'dates.start'	) AS start,
#//				IF(ISNULL('dates.end'),	'activities.end',		'dates.end'	) AS end,
'x'
			FROM	dates
#//			LET JOIN activities USING(activity)
			WHERE	date >= DATE(NOW()) AND
				date < DATE(DATE_ADD(NOW(), INTERVAL 80 DAY))
			ORDER BY date
			###############################################") AS $event)
	if ($installfest < 2) {
		if ($event["activity"] == "Installfest")
			$installfest++;
		$event["xxxxx"] = $installfest;
		$data[] = $event;
	}
echo json_encode($data,JSON_PRETTY_PRINT);
print_r($q);