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 "


"; ?>