<?php

function getUserIP()
{
    $client  = @$_SERVER['HTTP_CLIENT_IP'];
    $forward = @$_SERVER['HTTP_X_FORWARDED_FOR'];
    $remote  = $_SERVER['REMOTE_ADDR'];

    if(filter_var($client, FILTER_VALIDATE_IP))
    {
        $ip = $client;
    }
    elseif(filter_var($forward, FILTER_VALIDATE_IP))
    {
        $ip = $forward;
    }
    else
    {
        $ip = $remote;
    }

    return $ip;
}

$steamid = $_GET['id'];
echo $steamid;
$servername = "sql5.freemysqlhosting.net";
$username = "sql5130856";
$password = "sJMZ7T1s37";
$dbname = "sql5130856";
$ip = getUserIP();

$db_handle = mysql_connect($servername, $username, $password);
$db_found = mysql_select_db($dbname, $db_handle);

if($db_found){
$sql = "INSERT INTO track (ip, agent)
VALUES ('$ip' ,'$steamid')";
$result = mysql_query($sql);
mysql_close($db_handle);

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT * FROM redirects WHERE id LIKE '$steamid'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "Connection Stable, Going to: " . $row["url"]. "\n";
		$url = $row["url"];
		header('Location: