echo"

".$fulltitle."

Platform: ".showplatform($row_info['platform'])." Developer: ".$developer." Genre: ".$genre." Publisher: ".$publisher." "; //$row_info['bool_article']=0; if($row_info['bool_article']>0) { echo " Type: FaQ / Walkthrough Author: David Lawrence Last Modified: 12/12/2004  view more  User Rating: 8.2 "; } // review if($row_info['bool_cheat']>0) { $sql = "SELECT * FROM cheats_res WHERE shortname = '".$row_info["shortname"]."' AND platform = '".$platform_ref."' ORDER BY id DESC"; $res_like = mysql_query($sql); /* echo " ";*/ while($row_like=mysql_fetch_array($res_like)) { /* echo" "; } echo " ".$row_like["cheatname"] . " " . $row_like["type"]." "; */ $month = substr($row_like['dato'],5,2); $year = substr($row_like['dato'],0,4); $day = substr($row_like['dato'],8,2); $shortdate = $month."/".$day."/".$year; $result = mysql_query("SELECT SUM(rating) AS rating_total, COUNT(*) AS antal FROM cheat_rating WHERE cheatid='".$row_like['id']."'") or die(mysql_error()); $row_rate = mysql_fetch_array($result); if($row_rate['antal']==0) $snit = "No votes"; else { $snit = $row_rate[rating_total]/$row_rate[antal]; $snit = number_format($snit, 1); } echo " "; if($row_like['typeother']!="") { echo" "; } if($row_like['feature']!="") { echo" "; } echo " Type: ".$row_like['type']." ".$row_like['type']." type: ".$row_like['typeother']." Feature: ".$row_like['feature']." Last Modified: ".$shortdate."  view more  User Rating: ".$snit." "; } } // bool_cheat end if($anycontent==0) { echo "No cheats and reviews are available for this title"; } //show news related to this game //if($_SERVER["REMOTE_ADDR"]=="130.228.5.204" || $_SERVER["REMOTE_ADDR"]=="87.72.49.103") //{ $day = mktime(0, 0, 0, date("m"), date("d")-60, date("Y")); $sql = "SELECT * FROM nyheder WHERE ref_game = '".$sname."' AND timestamp>".$day." AND accept=1 ORDER BY id DESC"; $res = mysql_query($sql) or die(mysql_error()." ".$sql); if(mysql_num_rows($res)) { echo " "; while ($row = mysql_fetch_array($res)) { if($ii%2==0) $color = "EFEFEF"; else $color = "F4F4F4"; $ii++; $colorOn="9A9A9A"; echo" "; } echo "  ".$fulltitle." news ".$row["headline"]." ".$row["date"]." "; } //} // END show news // show games from same genre // $_SERVER["REMOTE_ADDR"]=="130.228.5.204" && if($genre!="N/A" && $genre!="") { // viewcheatlink($row_like["platform"],showtypesafe($row_like["type"]),$row_like["shortname"],$row_like["type_id"]). // find other games in same genre // if($genre!=") $sql = "SELECT * FROM cheatname WHERE genre='".addslashes($genre)."' AND platform='".$platform_ref."' AND id !=".$row_info["id"]." AND id>".($row_info["id"]-3000)." ORDER BY id DESC LIMIT 5"; $ii = 0; $res = mysql_query($sql) or die("DB error"); if(mysql_num_rows($res)) { echo " "; while($r = mysql_fetch_array($res)) { if($ii%2==0) $color = "EFEFEF"; else $color = "F4F4F4"; $ii++; $colorOn="9A9A9A"; echo" "; } echo "  You may also want other games in genre: ".$genre." ".$r["cheatname"]." "; } } // END show games from same genre echo " "; //Screenshot here include_once("includes/screens.php"); echo " "; // TABS TO THE RIGHT if($row_info['bool_article']>0) $parameter = ""; else $parameter = ""; echo " "; if($row_info['bool_screenshot']>0) $parameter = ""; else $parameter = ""; echo " "; echo "  ".$parameter."View Review   ".$parameter."View Screenshots  "; if($_SERVER["REMOTE_ADDR"]=="130.228.5.204") { //$sname = $shortname; include_once('includes/also_available_on.php'); } echo "

"; ?>