<?

function addNetwork($addressNetwork, $nameNetwork, $interface, $routeur) {
	$link = mysql_connect($GLOBALS['hostDB'], $GLOBALS['userDB'], $GLOBALS['passwdDB']);
if (!$link) {
    $buffer = "Connexion [FAILED]: " . mysql_error() ;
	return $buffer;
}


$db_selected = @mysql_select_db($GLOBALS['nameDB'], $link);
    if (!$db_selected) {
       $buffer .= "Impossible de sélectionner la base de données :$nameDB"  . mysql_error();
    }



//Add switch
$sql = "INSERT INTO NETWORK VALUE('$addressNetwork', '$nameNetwork', '$interface', '$routeur');";

if (mysql_query($sql, $link)) {
   $buffer = 1;
} else {
   $buffer = "CREATE NETWORK $addressNetwork $nameNetwork : [FAILED] :" . mysql_error() ;
}

return $buffer;
}



function selectNetwork($filter) {
//connect DB
$link = mysql_connect($GLOBALS['hostDB'], $GLOBALS['userDB'], $GLOBALS['passwdDB']);
if (!$link) {
    $buffer = "Connexion [FAILED]: " . mysql_error() ;
	return $buffer;
}


$db_selected = @mysql_select_db($GLOBALS['nameDB'], $link);
    if (!$db_selected) {
       $buffer .= "Impossible de sélectionner la base de données :$nameDB"  . mysql_error();
    }

	
	if (empty($filter)) {
		$sql = "SELECT * FROM NETWORK";
	}else{
		$sql = "SELECT * FROM NETWORK WHERE $filter ;"  ;
	}


if ($result = mysql_query($sql, $link)) {
	//test if $return is_array
    return  $result ;

} else {
   $buffer = "SELECT NETWORK : [FAILED] :" . mysql_error() ;
    return $buffer ;   
}


}




function delNetwork($addressNetwork) {

$buffer = "";

//connect DB
$link = mysql_connect($GLOBALS['hostDB'], $GLOBALS['userDB'], $GLOBALS['passwdDB']);
if (!$link) {
    $buffer = "Connexion [FAILED]: " . mysql_error() ;
	return $buffer;
}


$db_selected = @mysql_select_db($GLOBALS['nameDB'], $link);
    if (!$db_selected) {
       $buffer .= "Impossible de sélectionner la base de données :$nameDB"  . mysql_error();
    }


//del switch from SERVICESWITCH
$sql = "DELETE FROM  NETWORK WHERE idNetwork='$addressNetwork'";
if (mysql_query($sql, $link)) {
   $buffer .= "DELETE NETWORK $hostname : [OK]<BR />";
} else {
   $buffer = "DELETE NETWORK $hostname : [FAILED] :" . mysql_error() ;
   return $buffer;
}


return $buffer;
}


?>