<?php
if (!preg_match("/\/\/(www|forums|teams)\.supercheats\.com/",$_SERVER["HTTP_REFERER"])) { exit; }
require "../../php/connect.php";
require "../../php-new/sitefunctions.php";
require "../../php-new/gamepagefunctions.php";
$mysqli=connecti("supercheats");

$pagevars=getPlatforms($pagevars);

$id=preg_replace("/[^0-9]/","",$_POST["qid"]);
if($pagevars["platforms"][$_POST["platform"]]) {
	$lcplatform=$_POST["platform"];
	$pagevars["platform"]=$pagevars["platforms"][$_POST["platform"]];
	$query="SELECT * FROM action_replay_codes WHERE id='$id' and ((status='ACTIVE') or (status='RECOMMENDED'))";
        $submission=returnmysql($query,"single");
        if ($submission["id"]) {
                $query="SELECT * FROM products WHERE recid = '".addslashes($submission["gameid"])."'";
                $game=returnmysql($query,"single");
                $query="SELECT id,replyto,submittedby,comment,timestamp,abusecount FROM submission_comments WHERE platform='Action Replay Codes' and subid='".$submission["id"]."' ORDER BY id DESC";
                $rows=returnmysql($query);
                $pagevars["totalcomments"]=count($rows);
                if ($rows) {
                foreach ($rows as $row) {
                        if (count($pagevars["comments"])<=50){
                        $pagevars["comments"][$row["replyto"]][]=$row;
                        }
                }
                }
                $thumbs["up"]=0;
                $thumbs["down"]=0;
                $query="SELECT thumb FROM submission_thumbs WHERE type='$lcplatform' and subid='".$submission["id"]."'";
                $rows=returnmysql($query);
                foreach ($rows as $row) {
                $thumbs[$row["thumb"]]++;
                }
		if ($submission["title"]) {
                        $subtitle=urltext($submission["title"]); 
                } else {
                        $subtitle=urltext($submission["contents"]);
                }
                $submission["thisurl"]='/'.$lcplatform.'/'.lchyph($game["name"]).'/'.$submission["id"].'/ar-codes/'.$subtitle.'/';
		$submission["headtitle"]=$submission["title"].' Action Replay Code for  '.$game["name"];
        }

}

if ($submission) {
	$pagevars["thisgame"]=$game;
	$text.='
        <div class="scrollBlock" data-url="'.$submission["thisurl"].'" data-pagetitle="'.$submission["headtitle"].'">
	<h1>'.$submission["headtitle"].'</h1>';
	$text.=gameBreadcrumb($pagevars);

if ($submissionrow["submittedby"]) {
        $submittedby='<a href="/members/'.urlencode($submissionrow["submittedby"]).'" title="'.$submissionrow["submittedby"].' Bio">'.shorten($submissionrow["submittedby"]
,18).'</a> ';
} else { $submittedby="Guest"; }
if ($submissionrow["title"]) {
        echo '<p class="indi">
        <b>'.$submittedby.' posted: </b> </p>';
}
echo '<p><span class="fright"><i>'.date("M jS Y",$submissionrow["submittedon"]).', ID#'.$submissionrow["id"].'</i></span>
<strong>'.$submissionrow["title"].'</strong></p>';
echo nl2p(inarticle_textinsert(bbcparse($submissionrow["description"])));
        echo "<div class='arcode'>
                <div class='fleft arcodebar'>
                Region: <B>".$regions[$submissionrow["region"]]."</b>";
                if ($submissionrow["classification"]) {
                        echo " | Class: <b>".$classifications[$submissionrow["classification"]]."</b>";
                }
                echo "</div>";
                if ($submissionrow["code"]) {
                        echo "
                        <br clear=all>
                        <div id='sub".$submissionrow["id"]."' class=arcodearea>".bbcparse($submissionrow["code"])."</div><br />";
                } else { echo "<br clear=all />"; }
                 echo "
                </div>
                <div class=\"cboth_sm\">&nbsp;</div>
                ";
if ($submissionrow["edited"]) {
echo "<br /><em>Edited: ".date("M j Y",$submissionrow["edited"])."</em>";
}
if ((($uid) and ($uid==$submissionrow["submittedby"])) or ($userisadmin)) {
if ($pendingedit) {
echo "<span class='fright'>[<a class=hand onclick='showlightviewpage(\"/editsubmission.php?s=$subid&base=actionreplaycode\",800,600);'>View Pending Edit</a>]</span>
<div class=\"cboth_sm\">&nbsp;</div>";
} else {
echo "<span class='fright'>[<a class=hand onclick='showlightviewpage(\"/editsubmission.php?s=$subid&base=actionreplaycode\",800,600);'>Edit</a>]</span>
<div class=\"cboth_sm\">&nbsp;</div>";
}
}
echo '
<div class="blog-links" style="font-size:15px;line-height:24px; border-top:1px dotted  #888;">
';
        if ($bookmark) {
        echo '
        <span class="bookmarklink masterTooltip hand" title="This '.$stype.' is in your Cheat Book" id="addtocheatbook"
        onclick="location.href=\'https://www.supercheats.com/myaccount/cheatbook\';">Bookmarked</span> &nbsp;
        ';
        } else {
        echo '
        <span class="bookmarklink masterTooltip hand" title="Add this '.$stype.' to your Cheat Book. ';
        if (! $auth) { echo 'You need to be logged in to use this feature'; }
        echo '" id="addtocheatbook"
        onclick="addtocheatbook(\'addtocheatbook\',\'Action Replay Codes\',\''.$gameid.'\',\''.$submissionrow["id"].'\');">Bookmark <i class="fa fa-bookmark" aria-hidden="true"></i></span> &nbsp;
        ';
        }
        if ($totalcomments) {
        echo ' | &nbsp;
        <span class="commentlink masterTooltip hand" title="See comments" onclick="jQuery(\'html, body\').animate({ scrollTop: jQuery(\'#comment_area\').offset().top-200 }, 400);">'.$totalcomments.' <i class="fa fa-commenting" aria-hidden="true"></i></span>
        ';
        } else {
        echo ' | &nbsp;
        <span class="commentlink masterTooltip hand" title="Comment on this '.$stype.'" onclick="jQuery(\'html, body\').animate({ scrollTop:jQuery(\'#commentbox\').offset().top-200 }, 400);"></span>
        ';
        }
        echo '
        <soan class="fright">
        Rate this '.$stype.': &nbsp;
                <span class="thumbup hand masterTooltip" title="Give this '.$stype.' a Thumbs Up" onclick="dothumbvote(\'up\',\'actionreplaycode\',\''.$submissionrow["id"].'\');" id="thumbupactionreplaycode'.$submissionrow["id"].'">'.$thumbs["up"].' <i class="fa fa-thumbs-up" aria-hidden="true"></i></span>
&nbsp;
                <span class="thumbdown hand masterTooltip" title="Give this '.$stype.' a Thumbs Down" onclick="dothumbvote(\'down\',\'actionreplaycode\',\''.$submissionrow["id"].'\');" id="thumbdownactionreplaycode'.$submissionrow["id"].'">'.$thumbs["down"].' <i class="fa fa-thumbs-down" aria-hidden="true"></i></span> &nbsp;
                 | &nbsp; <span id="submissionreport'.$submissionrow["id"].'"><a href="#reportsubmission" class="lightview masterTooltip" title="Report a problem with this '.$stype.'">REPORT</a></span>
        </span>
                </div>
';
echo '
</div>
<div class="cboth_sm">&nbsp;</div>
';

$pagevars["commentplatform"]="ActionReplayCodes";
$pagevars["hidecomments"]=1;
$stype="Cheat";
$text.=pageComments($pagevars,$stype,$submission["id"]);
$text.='</div>';


}

$msg["d"]='<hr class="separator">'.$text;


echo json_encode($msg);

?>
