<?php
	$servername = "localhost";
	$username = "root";
	$password = "";
	$dbname = "addon_info";

	$conn = new mysqli($servername, $username, $password, $dbname);

	$ipport 		= mysqli_real_escape_string( $conn, test_input($_POST["ipport"]) );
	$map 			= mysqli_real_escape_string( $conn, test_input($_POST["map"]) );
	$hostname 		= mysqli_real_escape_string( $conn, test_input($_POST["hostname"]) );
	$gamemode 		= mysqli_real_escape_string( $conn, test_input($_POST["gamemode"]) );
	$addon 			= mysqli_real_escape_string( $conn, test_input($_POST["addon"]) );
	$addonversion	= mysqli_real_escape_string( $conn, test_input($_POST["addonversion"]) );
	$realip			= mysqli_real_escape_string( $conn, test_input($_SERVER['REMOTE_ADDR']) );

	if(isset($_POST["addoninfo"])){
		$addoninfo		= mysqli_real_escape_string( $conn, test_input($_POST["addoninfo"]) );
	}
	else{
		$addoninfo = "N/A";
	}

	// Check connection
	if ($conn->connect_error) {
		die("Connection failed: " . $conn->connect_error);
	}

	$sql = "SELECT * FROM serverinfo WHERE ipport='" . $ipport . "'";
	$result = $conn->query($sql);

	if ($result->num_rows > 0) {
		$sql = "UPDATE serverinfo SET map='$map', hostname='$hostname', gamemode='$gamemode', checkin=NOW(), addon='$addon', addonversion='$addonversion', realip='$realip', addoninfo='$addoninfo'
				WHERE ipport='$ipport'";
		$conn->query($sql);
		echo("UPDATE");
	}
	else {
		$sql = "INSERT INTO serverinfo ( ipport, realip, map, hostname, gamemode, checkin, addon, addonversion, addoninfo )
				VALUES ( '$ipport', '$realip', '$map', '$hostname', '$gamemode', NOW(), '$addon', '$addonversion', '$addoninfo' )";
		$conn->query($sql);
		echo("NEW");
	}
	$conn->close();



	function test_input($data) {
		$data = trim($data);
		$data = stripslashes($data);
		$data = htmlspecialchars($data);
	return $data;
}
?>