#!/usr/bin/php -q
<?php
$config = array();

//-----------------------------------------------------------------------------
function readconfig_master() {
	global $config;
	$reader = new XMLReader(); 
	$reader->open("/etc/wprotect/wprotect.conf"); 
	while ($reader->read()) { 
		switch ($reader->nodeType)  { 
			case (XMLREADER::ELEMENT): 
				if ($reader->name == "config_mysql_host") { $reader->read(); $config['config_mysql_host'] = trim( $reader->value ); break; }
				if ($reader->name == "config_mysql_user") { $reader->read(); $config['config_mysql_user'] = trim( $reader->value ); break; }
				if ($reader->name == "config_mysql_password") { $reader->read(); $config['config_mysql_password'] = trim( $reader->value ); break; }
				if ($reader->name == "config_mysql_db") { $reader->read(); $config['config_mysql_db'] = trim( $reader->value ); break; }
		}
	}
}
//-----------------------------------------------------------------------------
//------------------------------------------------------------
function connect_mysql () {
    global $config;
	global $connbdd;
	$connbdd = mysqli_connect ($config['config_mysql_host'], $config['config_mysql_user'], $config['config_mysql_password'], $config['config_mysql_db']);
	mysqli_query($connbdd, "SET NAMES 'utf8'");
    if (!mysqli_query($connbdd, "SET NAMES 'utf8'")) {
        return FALSE;
	}
    return TRUE;
}
//-----------------------------------------------------------
function verif_mysql () {
    global $config;
	global $connbdd;
    $result = mysqli_query($connbdd, "SET NAMES 'utf8'");
    if (!$result) {
        $connbdd = mysqli_connect ($config['config_mysql_host'], $config['config_mysql_user'], $config['config_mysql_password'], $config['config_mysql_db']);
        $result = mysqli_query($connbdd, "SET NAMES 'utf8'");
        if (!$result) {
            return FALSE;
        }
        return TRUE;
    }
    return TRUE;

}
//------------------------------------------------------------
//-----------------------------------------------------------------------------------
function exec_mysql($query) {
	global $config;
	global $connbdd;
	if (isset($connbdd)) {
		$result = mysqli_query($connbdd, $query);
		if (!$result) {
			connect_mysql();
			$result2 = mysqli_query($connbdd, $query);
			if (!$result2) {
				return FALSE;
			}
			else {
				return $result2;
			}
		}
		else {
			return $result;
		}
	}
	else {
		connect_mysql();
		$result = mysqli_query($connbdd, $query);
		if (!$result) {
			return FALSE;
		}
		else {
			return $result;
		}
	}
}
//------------------------------------------------------------------------------------
readconfig_master();
$nb_connected = mysqli_num_rows(exec_mysql("SELECT mac FROM lan_discover WHERE active='1'"));
$nb_authorize = mysqli_num_rows(exec_mysql("SELECT mac FROM lan_discover WHERE active='1' AND authorize='1'"));

echo "graph_title Appareils connectes au reseau wifi\n";
echo "graph_vlabel Nb appareils\n";
echo "graph_category WIFI\n";
echo "graph_info Statistiques des appareils connectes au reseau wifi\n";
echo "connected.label Appareils connectes au WIFI\n";
echo "connected.type GAUGE\n";
echo "connected.draw AREA\n";
echo "connected.value $nb_connected\n";
echo "authorize.label Appareils autorises sur internet\n";
echo "authorize.type GAUGE\n";
echo "authorize.draw AREA\n";
echo "authorize.value $nb_authorize\n";
?>