<?php require_once 'config_local.php'; $client_ip = $_SERVER["REMOTE_ADDR"]; if ((strpos($client_ip, "192.168.") === 0) || (strpos($client_ip, "10.8.") === 0) || (strpos($client_ip, "2001:470:6f:9d5:") === 0)) { $local_net = True; } else { $local_net = False; } if (! $local_net) { header('HTTP/1.1 403 Forbidden'); echo "IP not in allowed range"; exit; } $stype = $_REQUEST['stype']; $sid = $_REQUEST['sid']; $param = $_REQUEST['param']; $value = $_REQUEST['value']; if (isset($_REQUEST['time'])) { $timestamp = "'".$_REQUEST['time']."'"; } else { $timestamp = 'NULL'; } $connection = new mysqli($mysql_host, $mysql_user, $mysql_pwd, $mysql_schema, $mysql_port); if ($connection->connect_errno) { header('HTTP/1.1 500 Internal Server Error'); exit; } $str = "CALL meteo.submit_value('".$stype."','".$sid."','".$param."',".$value.",".$timestamp.")"; if (!$connection->query($str)) { header('HTTP/1.1 500 Internal Server Error'); echo "$str\n"; echo "Call Failed\n"; exit; } else { $connection->commit(); echo "OK Logged"; }