// $_REQUEST[id] is the game ID $url = stripslashes($_GET["url"]); $gID = str_replace(".htm"," ",$_GET["id"]); //echo $url." - vs - ".$_REQUEST[id]; //die; $conn = @mysql_pconnect("127.0.0.1","2flash", "mqs232rt") or DIE(mysql_error()); @mysql_select_db("2fgdb", $conn); $game = null; $date = date ("Y-m-d"); if (isset($_REQUEST['id']) && is_numeric($_REQUEST['id'])) { $query = "select categories.catname, games.name from games, categories where games.category = categories.id and games.id = '$gID'"; $result = mysql_query($query, $conn); if (mysql_num_rows($result) > 0) { $game = mysql_result($result, 0, 'name') . " - "; } } /*/---- Count OutLink $chkquery = "SELECT gameid FROM outCount WHERE dateout = $date AND gameid = $gID"; if ($chkresult = mysql_query($chkquery)) { $totrow = mysql_num_rows($chkresult); if ($totrow > 0) { $sql = "UPDATE outCount SET out=out+1, url='$url' WHERE gameid = $gID AND date =$date"; $sqlresult = mysql_query($sql); } else { $query = "INSERT INTO outCount (gameid,dateout,out,url) VALUES ('".$gID."','".$date."','1','".$url."')';"; $result = mysql_query($query) or die("
Query unsuccessful." . mysql_error() . "
"); } }*/ ?>