#!/usr/bin/php -q
<?php 
set_time_limit(30);
require 'phpagi.php';
$agi = new AGI();
$mysqli = mysqli_connect('parkingcity.nl', 'citypark', 'KoffieKopje12', 'citypark');
$setting = $mysqli->query("SELECT setting_value FROM citypark_setting WHERE setting_name = 'citypark_parking_space'");
$setting_count = $setting->fetch_object()->setting_value;
$parking = $mysqli->query("SELECT COUNT(id) AS aantal FROM parking WHERE start_date IS NOT NULL AND end_date IS NULL");
$parking_count = $parking->fetch_object()->aantal;
$free_space = $setting_count - $parking_count;
$agi->say_number($free_space);