<?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";    
    }