Initial import for API part.

1 files changed, 53 insertions, 0 deletions

diff --git a/api/mig_wan6ll.php b/api/mig_wan6ll.php
new file mode 100644
index 0000000..173f7fe
--- /dev/null
+++ b/api/mig_wan6ll.php
@@ -0,0 +1,53 @@
+<?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']);
+unset($db_config);
+$mysqli->query("SET NAMES 'utf8'");
+
+$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);
+