<?php
    $server = "localhost";
    $username = "22279_fpsuser";
    $pass = "fpsuserpass";
    $databse = "22279_fps";

    $target_x = $_REQUEST['t_x'];
    $target_y = $_REQUEST['t_y'];
    $target_z = $_REQUEST['t_z'];
    $player_id = $_REQUEST['p_id'];

    $connection = mysqli_connect($server, $username, $pass, $databse);

    if($connection) {
        echo "Connection Made <br>";
    } else {
        echo "".mysqli_error($connection)."<br>";
    }

    echo "Herrow World <br>";

    $query = "INSERT INTO `22279_fps`.`LogShot` (`id`, `target_x`, `target_y`, `target_z`, `timestamp`, `player_id`) VALUES (NULL, '$target_x', '$target_y', '$target_z', CURRENT_TIMESTAMP, '$player_id');";

    $result = mysqli_query($connection, $query);

    if($result) {
        echo "Entry added";
    } else {
        echo "".mysqli_error($connection)."<br>";
    }