<?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)); ?>