<?php
/**
 * Copyright 2016 Ludovic Pouzenc <ludovic@pouzenc.fr>
 * Copyright 2016 Nicolas Goaziou <mail@nicolasgoaziou.fr>
 * 
 * This file is part of CHD Gestion.
 * 
 * CHD Gestion is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 * 
 * CHD Gestion is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 * 
 * You should have received a copy of the GNU General Public License
 * along with CHD Gestion.  If not, see <http://www.gnu.org/licenses/>.
**/

include_once('inc/config.php');
$mysqli = new mysqli($db_config['host'], $db_config['username'], $db_config['password'], $db_config['database']);
if (mysqli_connect_errno()) {
	die(mysqli_connect_error());
}
unset($db_config);
$mysqli->set_charset("utf8") or die($mysqli->error);

$arg_ip6wanll=(array_key_exists('ip6wanll', $_GET) && preg_match('/^[a-f0-9:]+$/', $_GET['ip6wanll']))?$_GET['ip6wanll']:NULL;

if (!$arg_ip6wanll) {
	die("Wrong args");
}
$arg = $mysqli->real_escape_string($arg_ip6wanll);
$res = $mysqli->query("SELECT * FROM ipmgmt WHERE ip6='$arg'");
//var_dump($query);

if ( $res === FALSE ) {
	die("Wrong query");
}

$row = $res->fetch_assoc();
if ( ! is_array($row) ) {
	die("No result");
}
$row2 = $res->fetch_assoc();
if ( is_array($row2) ) {
	die("Non unique result");
}

$res = $mysqli->query("UPDATE ipmgmt SET ip6=NULL WHERE ip6='$arg' LIMIT 1");
$row["updated"] = $mysqli->affected_rows;

echo json_encode($row);