<?php
//Andmed//
$servername = "sql308.byetcluster.com";
$username = "17710919_1";
$password = "778S5q2P[)";
$dbname = "b7_17710919_m123";


  // kontrolli signatuuri
  $secret = '40587f10a7592343b9562ce182f95a24'; // sisesta teenuse secret kood '' märkide vahele
  if(empty($secret) || !check_signature($_GET, $secret)) {
    header("HTTP/1.0 404 Not Found");
    die("Viga: Vigane signatuur");
  }

  $message = $_GET['message'];
  // tee midagi sõnumi sisuga

// Loo ühendus
$conn = new mysqli($servername, $username, $password, $dbname);
// Kontrolli ühendust
if ($conn->connect_error) {
    die("Ühendus katkes: " . $conn->connect_error);
}

$sql = "UPDATE mybb_users SET additionalgroups='23' WHERE username=".$message."";

if ($conn->query($sql) === TRUE) {
   $reply = "Täname! Sinu annetus jõudis kohale"; //Vastus mille saab sõnumi saatja
    // saada vastus kasutajale
    echo($reply);
} else {
    echo "Viga: " . $conn->error;
}

$conn->close();

  function check_signature($params_array, $secret) {
    ksort($params_array);

    $str = '';
    foreach ($params_array as $k=>$v) {
      if($k != 'sig') {
        $str .= "$k=$v";
      }
    }
    $str .= $secret;
    $signature = md5($str);

    return ($params_array['sig'] == $signature);
  }
?>