spaceapi.php

<?php
	header('Content-Type: application/json');
	header('Access-Control-Allow-Origin: *');
	header('Cache-Control: no-cache');

        $wankerlink = mysql_pconnect('localhost', 'wanker', 'b2SGyye48tJjtjyY', false) or print(mysql_error());
        mysql_select_db('warpzone_wanker', $wankerlink) or print("FehlerS:" . mysql_error());

        $wankerQuery = "SELECT tempLounge, tempWerkstatt, tuerOffen, unix_timestamp(time) as time, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(time) as age FROM zonenstatus ORDER BY time DESC LIMIT 1";
        $wankerResult = mysql_query($wankerQuery, $wankerlink) or print("FehlerQ:" . mysql_error($wankerLink));
        $wankerZonenArray = mysql_fetch_array($wankerResult) or print(mysql_error());

        mysql_close($wankerlink);

        $wankerTempWerkstatt = $wankerZonenArray['tempWerkstatt'] / 10.0;
        $wankerTempLounge = $wankerZonenArray['tempLounge'] / 10.0;
        $wankerTimestamp = $wankerZonenArray['time'];
        $wankerAge = $wankerZonenArray['age'];

        $wankerTuerOffen = $wankerZonenArray['tuerOffen'] == 0 ? false : true;

        $answerArray['tuerOffen']     = intval($wankerTuerOffen);
        $answerArray['timestamp']     = intval($wankerTimestamp);
        $answerArray['age']     = intval($wankerAge);


	$data = Array(
		'api' => '0.13',
		'space' => 'Warpzone',
		'logo' => 'https://www.warpzone.ms/api/warpzone_logo.png',
		'url' => 'https://www.warpzone.ms',
		'feeds' => Array(
			'blog' => Array(
				'type' => 'rss',
				'url' => 'https://www.warpzone.ms/feed/',
			),
			'calendar' => Array(
				'type' => 'ical',
				'url' => 'https://www.google.com/calendar/ical/hc82sdjshuf1ru9f9eqcfq9bvs%40group.calendar.google.com/public/basic.ics',
			),
			'wiki' => Array(
				'type' => 'rss',
				'url' => 'https://www.warpzone.ms/wiki/feed.php',
			),
		),
		'location' => Array(
			'address' => 'Warpzone e.V., Am Hawerkamp 31, 48155 Münster, Germany',
			'lon' => 7.638216,
			'lat' => 51.943376,
		),
		'contact' => Array(
			'phone' => '+49 251 39500271',
			'twitter' => '@warpzone_ms',
			'email' => 'office@warpzone.ms',
			'irc' => 'irc://irc.freenode.net/#warpzone',
			'ml' => 'warpzone@warpzone.ms',
		),
		'issue_report_channels' => Array(
			'email',
		),
		'state' => Array(
			'open' => $wankerTuerOffen,
			'icon' => Array(
				'open' => 'https://www.warpzone.ms/api/warpzone_open.png',
				'closed' => 'https://www.warpzone.ms/api/warpzone_closed.png',
			),
		),
		'sensors' => Array(
			'temperature' => Array(
				Array(
					'value' => $wankerTempLounge,
					'unit' => '°C',
					'location' => 'Lounge',
				),
				Array(
					'value' => $wankerTempWerkstatt,
					'unit' => '°C',
					'location' => 'Werkstatt',
				),
			),
		),

/* API 0.8 / 0.9/ 0.11 compatibility */
		'open' => $wankerTuerOffen,
		'icon' => Array(
			'open' => 'https://www.warpzone.ms/api/warpzone_open.png',
			'closed' => 'https://www.warpzone.ms/api/warpzone_closed.png',
		),

/* Caching disabled, re-enable to allow caching by spaceapi.net
		'cache' => Array(
			'schedule' => 'm.02',
		),
*/
	);

        print(json_encode($data));
?>