<?

//set local variables
$dbhost = "localhost"; //Database Host
$dbuser = "gamerfm_ingame"; //Database User
$dbpass = "none"; //Database Password
$dbname = "gamerfm_ingame"; //Database Name

//connect
$db = mysql_pconnect($dbhost,$dbuser,$dbpass);
mysql_select_db("$dbname",$db);

?>
<?php
if (empty($_GET['name']) || empty($_GET['steamid']) || empty($_GET['game']) || empty($_GET['server']))
    exit("GET variables not set");
$name = $_GET["name"];
$steamid = $_GET["steamid"];
$game = $_GET["game"];
$server = $_GET["server"];
$rating = $_GET["rating"];
$message = $_GET["message"];
?>
<?php
if ($game== "tf"){
$fullgame = "Team Fortress 2";
} elseif ($game == "css"){
$fullgame = "Counter Strike Source";
} elseif ($game == "dod"){
$fullgame = "Day of Defat Source";
} elseif ($game == "gmod"){
$fullgame = "Garrys Mod";
} elseif ($game == "zps"){
$fullgame = "Zombie Panic Source";
} else {
$fullgame = $game;
}

$query_exists = "SELECT * FROM c_listeners WHERE steamid = '$steamid'";
$steam_exist = mysql_query($query_exists) or die(mysql_error());
$row_steam_exist = mysql_fetch_assoc($steam_exist);

if ($row_steam_exist['steamid']) {
    $query = "UPDATE c_listeners SET name = '$name', steamid = '$steamid', game = '$game', server = '$server', rating = '$rating', request = '$message' WHERE steamid = '$steamid'";
}
else {
    $query = "INSERT INTO c_listeners (name, steamid, game, server, rating, request) VALUES ('$name', '$steamid', '$game', '$server', '$rating', '$message')";
}

mysql_query($query) or die(mysql_error());
?>