rendered paste body<?PHP
/* ====================
Seditio - Website engine
Copyright Neocrome
http://www.neocrome.net
[BEGIN_SED]
File=arcade.php
Version=120
Updated=2007-feb-20
Type=Core
Author=Neocrome
Description=Arcade
[END_SED]
==================== */
if (!defined('SED_CODE')) { die('Wrong URL.'); }
$y = sed_import('y','P','TXT');
$id = sed_import('id','G','INT');
$s = sed_import('s','G','ALP',13);
$w = sed_import('w','G','ALP',4);
$d = sed_import('d','G','INT');
$f = sed_import('f','G','TXT');
list($usr['auth_read'], $usr['auth_write'], $usr['isadmin']) = sed_auth('users', 'a');
sed_block($usr['auth_read']);
$cat_res = "";
$cat_sessionstart = "";
$cat_permrequest = "";
$cat_burn = "";
$cat_play = "";
$cat_highscore = '';
$cat_else = '';
if ( isset($_GET['cat']) ) {
$tempcat = $_GET['cat'];
$sql="SELECT * FROM `arcade_categories` WHERE catname = '$tempcat'";
$result=mysql_query($sql) or die(mysql_error());
$catcheck = mysql_num_rows($result);
if ($catcheck > 0) {
$cat = $tempcat;
}
else {
$cat = "random";
}
}
else {
$cat = "random";
}
$cat_res = "";
$sql="SELECT * FROM `arcade_categories` ORDER BY `displayorder`";
$result=mysql_query($sql);
$catnum = mysql_num_rows($result);
for($i = 0; $i < $catnum; $i++) {
$row = mysql_fetch_array($result);
$catname = $row["catname"];
$cat_res .= "
<td style='vertical-align:bottom;' onclick='window.location.href=\"$VAR[0]/arcade.php?cat=$catname\";'>
";
if($cat == $catname){
$cat_res .= "";
}
else
{
$cat_res .= "";
}
$cat_res .= "";
if($cat == $catname){
$cat_res .= "";
}
else
{
$cat_res .= "";
}
$cat_res .= "
<a href='http://www.dramadome.com/arcade.php?cat=$catname'><b>$catname</b></a>
</div> ::
</td>
";
}
if ($_GET['do'] == 'newscore')
{
//echo" Error";
//echo "&validate=1µone=$microone&result=OK";
$score = base64_decode($_GET["check"]);
$pee = mysql_query("SELECT gameid FROM arcade_games where `shortname` = '".base64_decode($_GET['game'])."'");
$s2game = mysql_result($pee, 0);
$username = $VAR[4];
$sql = "INSERT INTO `arcade_highscores` (gamename, username, score) VALUES ('$s2game', '$username', '$score')";
$result=mysql_query($sql) or die(mysql_error());
header("Location: ".$VAR[0]."/arcade.php?highscore=".$s2game);
exit;
}
if ($_REQUEST['sessdo'] == 'sessionstart')
{
$sgame = $_REQUEST['gamename'];
$cat_sessionstart .= "&connStatus=1&initbar=$gamerand&gametime=" . TIMENOW . "&lastid=$lastid&result=OK";
$cat_sessionstart .= "<META HTTP-EQUIV=Refresh CONTENT=\"0; URL=\"arcade.php?game=$sgame\">";
}
if ($_REQUEST['sessdo'] == 'permrequest')
{
$cat_permrequest .= " Error";
$cat_permrequest .= "&validate=1µone=$microone&result=OK";
$score = $_REQUEST["score"];
$s2game = $_SESSION['sgameid'];
$username = $VAR[4];
$sql = "INSERT INTO `arcade_highscores` (gamename, username, score) VALUES ('$s2game', '$username', '$score')";
$result=mysql_query($sql) or die(mysql_error());
exit;
}
//done
if ($_REQUEST['sessdo'] == 'burn')
{
$gamename = $_SESSION['sgameid'];
$sql="SELECT * FROM `arcade_games` WHERE `gameid` = '$gamename' LIMIT 1";
$result=mysql_query($sql);
$row = mysql_fetch_array($result);
$shortname = $row["shortname"];
$title = $row["title"];
$gameid = $row["gameid"];
$stdimage = $row["stdimage"];
$description = $row["description"];
$thiscat = $row["categoryid"];
$timesplayed = $row["timesplayed"];
$namecheck = $VAR[4];
$isreverse = $row["isreverse"];
$cat_burn .= "
<table border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td colspan='2' style='vertical-align:top;padding-left:8px;padding-top:8px;' width='100%'>
<table border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td align='left' valign='top' width='10' height='30' background='images/contentbox_01.gif'>
</td>
<td style='vertical-align:middle;' align='left' background='images/contentbox_02.gif' width='100%' height='30'>
<b>$title HIGHT SCORES</b>
</td>
<td align='left' valign='top' width='10' height='30' background='images/contentbox_03.gif'>
</td>
</tr>
<tr>
<td align='left' valign='top' background='images/contentbox_04.gif' width='10' height='100%'>
</td>
<td align='left' valign='top' bgcolor='#1f3a4f'>
<table border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td rowspan='2' align='left' valign='top' width='10%'>
<a href='http://www.dramadome.com/arcade.php?play=$gameid'><img src='$VAR[0]/arcade/images/$stdimage' border='2' /></a>
</td>
<td align='left' valign='top' width='90%'>
<a href='http://www.dramadome.com/arcade.php?play=$gameid'>$title</a>
</tr>
<tr>
<td align='left' valign='top' width='90%'>
$description
<br>
<br>
Times played: $timesplayed
</td>
</tr>
</table>
</td>
<td align='left' valign='top' background='images/contentbox_05.gif' width='10' height='100%'>
</td>
</tr>
<tr>
<td align='left' valign='top' width='10' height='30'>
<img border='0' src='images/contentbox_06.gif' width='10' height='30'></td>
<td background='images/contentbox_07.gif'>
</td>
<td align='left' valign='top' width='10' height='30'>
<img border='0' src='images/contentbox_08.gif' width='10' height='30'></td>
</tr>
</table>
</td>
</tr>
<tr>
<td style='vertical-align:top;padding-left:8px;padding-top:8px;' align='left' width='50%'>
<table border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td align='left' valign='top' width='10' height='30' background='images/contentbox_01.gif'>
</td>
<td style='vertical-align:middle;' align='left' background='images/contentbox_02.gif' width='100%' height='30'>
<b>Overall High Scores</b>
</td>
<td align='left' valign='top' width='10' height='30' background='images/contentbox_03.gif'>
</td>
</tr>
<tr>
<td align='left' valign='top' background='images/contentbox_04.gif' width='10' height='100%'>
</td>
<td align='left' valign='top' bgcolor='#1f3a4f'>
<table class='border2' width='100%' border='0' align='center'>
<tr>
<td width='20'><b>#</b></td>
<td width='120'><b>Member</b></td>
<td width='110'><b>Score</b></td>
</tr>
";
if($isrverse == 1){
$sql="SELECT * FROM `arcade_highscores` WHERE `gamename` = '$gameid' ORDER BY `score` LIMIT 20";
}
else{
$sql="SELECT * FROM `arcade_highscores` WHERE `gamename` = '$gameid' ORDER BY `score` DESC LIMIT 20";
}
$result=mysql_query($sql);
for($i = 0; $i < 20; $i++) {
$row = mysql_fetch_array($result);
$username = $row["username"];
$score = $row["score"];
$rank = $i + 1;
$cat_burn .= "
<tr>
<td>
$rank
</td>
<td>
";
if ($username == $namecheck){
$cat_burn .= "
<b>
";
}
$cat_burn .= "
<a href='$http://www.dramadome.com/$username'>$username</a>
";
if ($username == $namecheck){
$cat_burn .= "
</b>
";
}
$cat_burn .= "
</td>
<td>
$score
</td>
</tr>
";
}
$cat_burn .= "
</table>
</td>
<td align='left' valign='top' background='images/contentbox_05.gif' width='20' height='100%'>
</td>
</tr>
<tr>
<td align='left' valign='top' width='10' height='30'>
<img border='0' src='images/contentbox_06.gif' width='10' height='30'></td>
<td background='images/contentbox_07.gif'>
</td>
<td align='left' valign='top' width='10' height='30'>
<img border='0' src='images/contentbox_08.gif' width='10' height='30'></td>
</tr>
</table>
</td>
<td style='vertical-align:top;padding-top:8px;' align='left' width='50%'>
<table border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td align='left' valign='top' width='10' height='30' background='images/contentbox_01.gif'>
</td>
<td style='vertical-align:middle;' align='left' background='images/contentbox_02.gif' width='100%' height='30'>
<b>Your High Scores</b>
</td>
<td align='left' valign='top' width='10' height='30' background='images/contentbox_03.gif'>
</td>
</tr>
<tr>
<td align='left' valign='top' background='images/contentbox_04.gif' width='10' height='100%'>
</td>
<td align='left' valign='top' bgcolor='#1f3a4f'>
<table class='border2' width='100%' border='0' align='center'>
</tr>
<tr>
<td width='33%'>
<b>#</b>
</td>
<td width='66%'>
<b>Score</b>
</td>
</tr>
";
if($isreverse == 1){
$sql="SELECT * FROM `arcade_highscores` WHERE `gamename` = '$gameid' AND `username` = '$usr[name]' ORDER BY `score` LIMIT 20";
}
else{
$sql="SELECT * FROM `arcade_highscores` WHERE `gamename` = '$gameid' AND `username` = '$usr[name]' ORDER BY `score` DESC LIMIT 20";
}
$result=mysql_query($sql);
$rescheck = mysql_num_rows($result);
for($i = 0; $i < 20; $i++) {
$row = mysql_fetch_array($result);
$score = $row["score"];
$rank = $i + 1;
$cat_burn .= "
<tr>
<td>
$rank
</td>
<td>
$score
</td>
</tr>
";
}
$cat_burn .= "
</table>
</td>
<td align='left' valign='top' background='images/contentbox_05.gif' width='10' height='100%'>
</td>
</tr>
<tr>
<td align='left' valign='top' width='10' height='30'>
<img border='0' src='images/contentbox_06.gif' width='10' height='30'></td>
<td background='images/contentbox_07.gif'>
</td>
<td align='left' valign='top' width='10' height='30'>
<img border='0' src='images/contentbox_08.gif' width='10' height='30'></td>
</tr>
</table>
</td>
</tr>
</table>
";
}
//done
else if (isset($_GET['play'])){
$thisgameid = $_GET['play'];
$_SESSION['sgameid'] = $thisgameid;
$sql="SELECT * FROM `arcade_games` WHERE `gameid` = '$thisgameid' LIMIT 1";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$shortname = $row["shortname"];
$title = $row["title"];
$gameid = $row["gameid"];
$stdimage = $row["stdimage"];
$description = $row["description"];
$thiscat = $row["categoryid"];
$timesplayed = $row["timesplayed"];
$file = $row["file"];
$width = $row["width"];
$height = $row["height"];
$gamename = $row["shortname"];
$isreverse = $row["isreverse"];
$timesnew = $timesplayed + 1;
$sqlplay="UPDATE `arcade_games` SET `timesplayed` = '$timesnew' WHERE `gameid` = '$thisgameid' LIMIT 1";
$resultplay=mysql_query($sqlplay);
$acta = mysql_query("SELECT * FROM `user_info` WHERE `user` = '$usr[name]'");
$actb = mysql_fetch_array($acta);
$actpa = $actb["total"];
$actpb = $actpa + 1;
//$actsql = mysql_query("UPDATE `user_info` SET `total` = '$actpb' WHERE `user` = '$usr[name]' LIMIT 1");
if($isreverse == 1){
$sql="SELECT * FROM `arcade_highscores` WHERE `gamename` = '$gameid' ORDER BY `score` LIMIT 1";
}
else{
$sql="SELECT * FROM `arcade_highscores` WHERE `gamename` = '$gameid' ORDER BY `score` DESC LIMIT 1";
}
$result=mysql_query($sql);
$champnum = mysql_num_rows($result);
if($champnum == 1){
$row = mysql_fetch_array($result);
$champname = $row["username"];
$champscore = $row["score"];
}
else {
$champname = "None";
$champscore = 0;
}
$cat_play .= "
<table border='0' cellpadding='0' cellspacing='0' width='760'>
<tr>
<td style='vertical-align:top;padding-left:8px;padding-top:8px;' width='70%'>
<table border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td align='left' valign='top' width='10' height='30' background='images/contentbox_01.gif'>
</td>
<td style='vertical-align:middle;' align='left' background='images/contentbox_02.gif' width='100%' height='30'>
<b>$title</b>
</td>
<td align='left' valign='top' width='10' height='30' background='images/contentbox_03.gif'>
</td>
</tr>
<tr>
<td align='left' valign='top' background='images/contentbox_04.gif' width='10' height='100%'>
</td>
<td align='left' valign='top' bgcolor='#1f3a4f'>
<object classid='clsid:D27CDB6E-AE6D-11cf-96B8-444553540000' codebase='http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,14,0' width='$width' height='$height'>
<param name='movie' value='http://dramadome.com/arcade/swf/$file'>
<param name='quality' value='high'>
<embed src='http://dramadome.com/arcade/swf/$file' quality='high' width='$width' height='$height' quality='high' pluginspage='http://www.macromedia.com/go/getflashplayer' type='application/x-shockwave-flash'></embed>
</object>
</td>
<td align='left' valign='top' background='images/contentbox_05.gif' width='10' height='100%'>
</td>
</tr>
<tr>
<td align='left' valign='top' width='10' height='30'>
<img border='0' src='images/contentbox_06.gif' width='10' height='30'></td>
<td background='images/contentbox_07.gif'>
</td>
<td align='left' valign='top' width='10' height='30'>
<img border='0' src='images/contentbox_08.gif' width='10' height='30'></td>
</tr>
</table>
</td>
<td align='left' style='vertical-align:top;padding-left:8px;padding-top:8px;'>
<table border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td align='left' valign='top' width='10' height='30' background='images/contentbox_01.gif'>
</td>
<td style='vertical-align:middle;' align='left' background='images/contentbox_02.gif' width='100%' height='30'>
<b>$title</b>
</td>
<td align='left' valign='top' width='10' height='30' background='images/contentbox_03.gif'>
</td>
</tr>
<tr>
<td align='left' valign='top' background='images/contentbox_04.gif' width='10' height='100%'>
</td>
<td align='left' valign='top' bgcolor='#1f3a4f'>
Champion: <b>$champname</b> <img src='http://dramadome.com/arcade/images/trophy.gif' border='0' align='middle' width='10' />
<br>
<br>
Score to Beat: <b>$champscore</b>
<br>
<br>
<a href='arcade.php?'>Play More Games</a>
<br>
<a href='http://dramadome.com/arcade.php?highscore=$gameid'>[View High Scores]</a>
</td>
<td align='left' valign='top' background='images/contentbox_05.gif' width='10' height='100%'>
</td>
</tr>
<tr>
<td align='left' valign='top' width='10' height='30'>
<img border='0' src='images/contentbox_06.gif' width='10' height='30'></td>
<td background='images/contentbox_07.gif'>
</td>
<td align='left' valign='top' width='10' height='30'>
<img border='0' src='images/contentbox_08.gif' width='10' height='30'></td>
</tr>
</table>
</td>
</tr>
</table>
";
}
//done
else if (isset($_GET['highscore'])){
$hsgameid = $_GET['highscore'];
$sql="SELECT * FROM `arcade_games` WHERE `gameid` = '$hsgameid' LIMIT 1";
$result=mysql_query($sql);
$row = mysql_fetch_array($result);
$shortname = $row["shortname"];
$title = $row["title"];
$gameid = $row["gameid"];
$stdimage = $row["stdimage"];
$description = $row["description"];
$thiscat = $row["categoryid"];
$timesplayed = $row["timesplayed"];
$isreverse = $row["isreverse"];
$cat_highscore .= "
<table border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td colspan='2' style='vertical-align:top;padding-left:8px;padding-top:8px;' width='100%'>
<table border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td align='left' valign='top' width='10' height='30' background='images/contentbox_01.gif'>
</td>
<td style='vertical-align:middle;' align='left' background='images/contentbox_02.gif' width='100%' height='30'>
<b>$title HIGHT SCORES</b>
</td>
<td align='left' valign='top' width='10' height='30' background='images/contentbox_03.gif'>
</td>
</tr>
<tr>
<td align='left' valign='top' background='images/contentbox_04.gif' width='10' height='100%'>
</td>
<td align='left' valign='top' bgcolor='#1f3a4f'>
<table border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td rowspan='2' align='left' valign='top' width='10%'>
<a href='$VAR[0]/arcade.php?play=$hsgameid'><img src='http://dramadome.com/arcade/images/$stdimage' border='2' /></a>
</td>
<td align='left' valign='top' width='90%'>
<a href='hrrp://dramadome.com/arcade.php?play=$gameid'>$title</a>
</tr>
<tr>
<td align='left' valign='top' width='90%'>
$description
<br>
<br>
Times played: $timesplayed
</td>
</tr>
</table>
</td>
<td align='left' valign='top' background='images/contentbox_05.gif' width='10' height='100%'>
</td>
</tr>
<tr>
<td align='left' valign='top' width='10' height='30'>
<img border='0' src='images/contentbox_06.gif' width='10' height='30'></td>
<td background='images/contentbox_07.gif'>
</td>
<td align='left' valign='top' width='10' height='30'>
<img border='0' src='images/contentbox_08.gif' width='10' height='30'></td>
</tr>
</table>
</td>
</tr>
<tr>
<td style='vertical-align:top;padding-left:8px;padding-top:8px;' align='left' width='50%'>
<table border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td align='left' valign='top' width='10' height='30' background='images/contentbox_01.gif'>
</td>
<td style='vertical-align:middle;' align='left' background='images/contentbox_02.gif' width='100%' height='30'>
<b>Overall High Scores</b>
</td>
<td align='left' valign='top' width='10' height='30' background='images/contentbox_03.gif'>
</td>
</tr>
<tr>
<td align='left' valign='top' background='images/contentbox_04.gif' width='10' height='100%'>
</td>
<td align='left' valign='top' bgcolor='#1f3a4f'>
<table class='border2' width='100%' border='0' align='center'>
<tr>
<td width='20'><b>#</b></td>
<td width='120'><b>Member</b></td>
<td width='110'><b>Score</b></td>
</tr>
";
$namecheck = $VAR[4];
if($isrverse == 1){
$sql="SELECT * FROM `arcade_highscores` WHERE `gamename` = '$gameid' ORDER BY `score` LIMIT 20";
}
else{
$sql="SELECT * FROM `arcade_highscores` WHERE `gamename` = '$gameid' ORDER BY `score` DESC LIMIT 20";
}
$result=mysql_query($sql);
for($i = 0; $i < 20; $i++) {
$row = mysql_fetch_array($result);
$username = $row["username"];
$score = $row["score"];
$rank = $i + 1;
$cat_highscore .= "
<tr>
<td>$rank.</td>
<td>
";
if ($username == $namecheck){
$cat_highscore .= "
<b>
";
}
echo "
<a href='http://dramadome.com/$username'>$username</a>
";
if ($username == $namecheck){
$cat_highscore .= "
</b>
";
}
$cat_highscore .= "
</td>
<td>$score</td>
</tr>
";
}
$cat_highscore .= "
</table>
</td>
<td align='left' valign='top' background='images/contentbox_05.gif' width='10' height='100%'>
</td>
</tr>
<tr>
<td align='left' valign='top' width='10' height='30'>
<img border='0' src='images/contentbox_06.gif' width='10' height='30'></td>
<td background='images/contentbox_07.gif'>
</td>
<td align='left' valign='top' width='10' height='30'>
<img border='0' src='images/contentbox_08.gif' width='10' height='30'></td>
</tr>
</table>
</td>
<td style='vertical-align:top;padding-top:8px;' align='left' width='50%'>
<table border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td align='left' valign='top' width='10' height='30' background='images/contentbox_01.gif'>
</td>
<td style='vertical-align:middle;' align='left' background='images/contentbox_02.gif' width='100%' height='30'>
<b>Your High Scores</b>
</td>
<td align='left' valign='top' width='10' height='30' background='images/contentbox_03.gif'>
</td>
</tr>
<tr>
<td align='left' valign='top' background='images/contentbox_04.gif' width='10' height='100%'>
</td>
<td align='left' valign='top' bgcolor='#1f3a4f'>
<table class='border2' width='100%' border='0' align='center'>
</tr>
<tr>
<td width='33%'>
<b>#</b>
</td>
<td width='66%'>
<b>Score</b>
</td>
</tr>
";
if($isreverse == 1){
$sql="SELECT * FROM `arcade_highscores` WHERE `gamename` = '$gameid' AND `username` = '$usr[name]' ORDER BY `score` LIMIT 20";
}
else{
$sql="SELECT * FROM `arcade_highscores` WHERE `gamename` = '$gameid' AND `username` = '$usr[name]' ORDER BY `score` DESC LIMIT 20";
}
$result=mysql_query($sql);
$rescheck = mysql_num_rows($result);
for($i = 0; $i < 20; $i++) {
$row = mysql_fetch_array($result);
$score = $row["score"];
$rank = $i + 1;
$cat_highscore .= "
<tr>
<td>$rank.</td>
<td>$score</td>
</tr>
";
}
$cat_highscore .= "
</table>
</td>
<td align='left' valign='top' background='images/contentbox_05.gif' width='10' height='100%'>
</td>
</tr>
<tr>
<td align='left' valign='top' width='10' height='30'>
<img border='0' src='images/contentbox_06.gif' width='10' height='30'></td>
<td background='images/contentbox_07.gif'>
</td>
<td align='left' valign='top' width='10' height='30'>
<img border='0' src='images/contentbox_08.gif' width='10' height='30'></td>
</tr>
</table>
</td>
</tr>
</table>
";
}
//done
else {
$cat_else .= "
<table border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td colspan='2' style='vertical-align:top;padding-left:8px;padding-top:8px;' width='100%'>
<table border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td align='left' valign='top' width='10' height='30' background='images/contentbox_01.gif'>
</td>
<td style='vertical-align:middle;' align='left' background='images/contentbox_02.gif' width='100%' height='30'>
<b>WELCOME TO OUR GAME SPOT.</b>
</td>
<td align='left' valign='top' width='10' height='30' background='images/contentbox_03.gif'>
</td>
</tr>
<tr>
<td align='left' valign='top' background='images/contentbox_04.gif' width='10' height='100%'>
</td>
<td align='left' valign='top' bgcolor='#1f3a4f'>
<table class='border2' style='width:100%;'>
<tr>
<td style='width:10%;'>
</td>
<td style='width:20%;'>
<b>Game</b>
</td>
<td style='width:10%;'>
<b>Category</b>
</td>
<td style='width:30%;'>
<b>Champion</b>
</td>
<td style='width:30%;'>
<b>Your Best</b>
</td>
</tr>
</table>
";
if($cat == 'random'){
$sql1="SELECT * FROM `arcade_games` ORDER BY `title`";
}
else{
$sql="SELECT * FROM `arcade_categories` WHERE `catname` = '$cat' LIMIT 1";
$result=mysql_query($sql);
$row = mysql_fetch_array($result);
$maincat = $row["catid"];
$sql1="SELECT * FROM `arcade_games` WHERE `categoryid` = '$maincat' ORDER BY `shortname`";
}
$result1=mysql_query($sql1);
$gamenum = mysql_num_rows($result1);
for($i = 0; $i < $gamenum; $i++) {
$row = mysql_fetch_array($result1);
$shortname = $row["shortname"];
$title = $row["title"];
$gameid = $row["gameid"];
$stdimage = $row["stdimage"];
$description = $row["description"];
$thiscat = $row["categoryid"];
$isreverse = $row["isreverse"];
$sql2="SELECT * FROM `arcade_categories` WHERE `catid` = '$thiscat' LIMIT 1";
$result2=mysql_query($sql2);
$row = mysql_fetch_array($result2);
$tempcat = $row["catname"];
if($isreverse == 1){
$sql3="SELECT * FROM `arcade_highscores` WHERE `gamename` = '$gameid' ORDER BY `score` LIMIT 1";
}
else{
$sql3="SELECT * FROM `arcade_highscores` WHERE `gamename` = '$gameid' ORDER BY `score` DESC LIMIT 1";
}
$result3=mysql_query($sql3);
$champnum = mysql_num_rows($result3);
if($champnum == 1){
$row = mysql_fetch_array($result3);
$champname = $row["username"];
$champscore = $row["score"];
}
else {
$champname = "None";
$champscore = 0;
}
$user = $VAR[4];
$sql4="SELECT * FROM `arcade_highscores` WHERE `gamename` = '$gameid' AND `username` = '$user' ORDER BY `score` DESC LIMIT 1";
$result4=mysql_query($sql4);
$row4 = mysql_fetch_array($result4);
$scorenum = mysql_num_rows($result4);
if($scorenum == 1){
$yourscore = $row4["score"];
}
else {
$yourscore = "None";
}
$cat_else .= "
<table style='width:100%;'>
<tr>
<td style='width:10%;'>
<a href='http://dramadome.com/arcade.php?play=$gameid'><img src='$VAR[0]/arcade/images/$stdimage' border='2'></a>
</td>
<td style='width:20%;'>
<a href='http://dramadome.com/arcade.php?play=$gameid'>$title</a>
<br>
$description
</td>
<td style='width:10%;'>
<b>$tempcat</b>
<br />
(<a href='http://dramadome.com/arcade.php?cat=$tempcat'>More</a>)
</td>
<td style='width:30%;' class='color'>
$champname high score:
<br />
<b>$champscore</b>
</td>
<td style='width:30%;'>
Your high score:
<br />
<b>$yourscore</b>
<br />
[<a href='http://dramadome.com/arcade.php?highscore=$gameid'>High Scores</a>]
</td>
</tr>
</table>
";
}
$cat_else .= "
</td>
<td align='left' valign='top' background='images/contentbox_05.gif' width='10' height='100%'>
</td>
</tr>
<tr>
<td align='left' valign='top' width='10' height='30'>
<img border='0' src='images/contentbox_06.gif' width='10' height='30'></td>
<td background='images/contentbox_07.gif'>
</td>
<td align='left' valign='top' width='10' height='30'>
<img border='0' src='images/contentbox_08.gif' width='10' height='30'></td>
</tr>
</table>
</td>
</tr>
</table>
";
}
require("system/header.php");
$mskin = sed_skinfile(array('arcade', 'fun'));
$t = new XTemplate($mskin);
$t->assign(array(
"ARCADE_CATS" => $cat_res,
"ARCADE_SESSIONSTART" => $cat_sessionstart,
"ARCADE_PERMREQUEST" => $cat_permrequest,
"ARCADE_BURN" => $cat_burn,
"ARCADE_PLAY" => $cat_play,
"ARCADE_HIGHSCORE" => $cat_highscore,
"ARCADE_ELSE" => $cat_else
));
$t->parse("MAIN");
$t->out("MAIN");
require("system/footer.php");
?>