".$first . $prev . $nav . $next . $last."
"; echo "".$first . $prev . " Showing page $pageNum of $maxPage pages " . $next . $last."
| {$data['CommentTitle']} by {$data['UserName']} on $date. | \n
| {$data['CommentBody']} | \n
';
}
if((($currentrating >= 0.50)or($currentrating == 0.50)) && ($currentrating <= .99)){
$star = '
';
}
if((($currentrating >= 1.00)or($currentrating == 1.50)) && ($currentrating <= 1.49)){
$star = '
';
}
if((($currentrating >= 1.50)or($currentrating == 1.50)) && ($currentrating <= 1.99)){
$star = '
';
}
if((($currentrating >= 2.00)or($currentrating == 2.00)) && ($currentrating <= 2.49)){
$star = '
';
}
if((($currentrating >= 2.50)or($currentrating == 2.50)) && ($currentrating <= 2.99)){
$star = '
';
}
if((($currentrating >= 3.00)or($currentrating == 3.00)) && ($currentrating <= 3.49)){
$star = '
';
}
if((($currentrating >= 3.50)or($currentrating == 3.50)) && ($currentrating <= 3.99)){
$star = '
';
}
if((($currentrating >= 4.00)or($currentrating == 4.00)) && ($currentrating <= 4.49)){
$star = '
';
}
if((($currentrating >= 4.50)or($currentrating == 4.50)) && ($currentrating <= 4.99)){
$star = '
';
}
if($currentrating == 5.0){
$star = '
';
}
$fields = array(RgameCurrentRating => $star,
RgameRateGame.":" => $fields);
$form = FormGenerator(RgameLegendRating, $formname, "index.php?id=play&gid=$gameid", $fields, "updaterate", RgameInputRateNow);
return $form;
}
}
/**
* Function to edit existing game in the database
*
*/
function EditGame()
{
if (isset($_POST['delete']))
{
$deletegame = $_POST['deletegame'];
foreach ($deletegame as $key => $value)
{
//Get the swf file and image file names
$data = $this->RSqlArray("SELECT * FROM rgames_flash WHERE GameId = '".$key."'");
$filedirectory = "./../rgames/";
$swffile = $data['GameFile'];
$imagefile = $data['GameScreen'];
//Delete swf
$delete1 = unlink($filedirectory."swf/".$swffile);
if ($delete1)
{
//Delete image
$delete2 = unlink($filedirectory."game_icons/".$imagefile);
if ($delete2)
{
$delete3 = true;
}
else
{
DisplayMessage(RgameDeleteGameIconFailure.": $imagefile", 0, 0);
$delete3 = false;
}
}
else
{
DisplayMessage(RgameDeleteGameFileFailure.": $swffile", 0, 0);
$delete3 - false;
}
if ($delete3)
{
//remove from db
$sql2 = mysql_query("DELETE FROM rgames_flash WHERE GameId = '".$key."'");
if ($sql2)
{
DisplayMessage(RgameDeleteGameSuccess.": $value", 0, 1, "index.php?id=efg");
}
else
{
DisplayMessage(RgameDeleteGameFailure.": $value", 0, 0);
}
}
}
}
elseif (isset($_POST['update']))
{
$gamename = $_POST['gamename'];
$gamedesc = $_POST['gamedesc'];
$gamecat = $_POST['gamecat'];
$gamefile = $_POST['gamefile'];
$gameicon = $_POST['gameicon'];
$gameorder = $_POST['gameorder'];
$gameon = $_POST['gameon'];
$totalplayed = $_POST['totalplayed'];
$gamewidth = $_POST['gamewidth'];
$gameheight = $_POST['gameheight'];
$gameid = $_GET['gameid'];
$check1 = $this->CheckField($gamename, RgameFieldGameName);
$check2 = $this->CheckField($gamedesc, RgameFieldGameDesc);
$check3 = $this->CheckField($gamecat, RgameFieldGameCat);
$check4 = $this->CheckField($gamefile, RgameFieldGameUploadSWF);
$check5 = $this->CheckField($gameicon, RgameFieldGameUploadAvatar);
$gameon = $this->CheckField($gameon, RgameFieldGameOn, 1);
$data = $this->RSqlArray("SELECT * FROM rgames_flash WHERE GameId = '".$gameid."'");
if (empty($gamewidth))
{
$gamewidth = 500;
}
if (empty($gameheight))
{
$gameheight = 400;
}
if (empty($totalplayed))
{
$totalplayed = 0;
}
if ($check1 && $check2 && $check3 && $check4 && $check5)
{
$sql = $this->RQuery("UPDATE rgames_flash SET GameCat = '".$gamecat."',
GameName = '".$gamename."',
GameDesc = '".$gamedesc."',
GameFile = '".$gamefile."',
GameHeight = '".$gameheight."',
GameWidth = '".$gamewidth."',
GameScreen = '".$gameicon."',
GameOrder = '".$gameorder."',
GameAlive = '".$gameon."',
GameTotalPlayed = '".$totalplayed."'
WHERE GameId = '".$gameid."'");
if ($sql)
{
DisplayMessage(RgameUpdateGameSuccess, 0, 1, "index.php?id=efg");
}
else
{
DisplayMessage(RgameUpdateGameFailure, 0, 0);
}
}
else
{
DisplayMessage(RgameFillFields, 0, 0);
}
}
elseif (isset($_GET['fgid']))
{
$gameid = $_GET['fgid'];
$data = $this->RSqlArray("SELECT * FROM rgames_flash WHERE GameId = '".$gameid."' LIMIT 1");
$gamefilelocation = "./../rgames/swf/".$data['GameFile'];
if ($data['GameAlive'] == 1)
{
$gameon = " checked";
}
else
{
$gameon = '';
}
$formname = "EditGame";
$fields = array("*".RgameFieldGameName => FieldMaker($formname, 1, "gamename", $data['GameName']),
"*".RgameFieldGameDesc => FieldMaker($formname, 3, "gamedesc", $data['GameDesc']),
"*".RgameFieldGameCat => $this->GameCatGenerator($data['GameCatId']),
"*".RgameFieldGameUploadSWF => GenerateDirectories("./../rgames/swf/", "gamefile", $data['GameFile']),
RgameFieldGameWidth => FieldMaker($formname, 1, "gamewidth", $data['GameWidth'], 5),
RgameFieldGameHeight => FieldMaker($formname, 1, "gameheight", $data['GameHeight'], 5),
"*".RgameFieldGameUploadAvatar => GenerateDirectories("./../rgames/game_icons/", "gameicon", $data['GameScreen']),
RgameFieldGameOrder => FieldMaker($formname, 1, 'gameorder', $data['GameOrder'], 5),
RgameFieldGameOn => FieldMaker($formname, 4, 'gameon', $data['GameAlive']),
RgameFieldGameTotalPlayed => FieldMaker($formname, 1, 'totalplayed', $data['GameTotalPlayed'], 5)
);
echo FormGenerator(RgameInputEditGame.": ".$data['GameName'], $formname, "index.php?id=efg&gameid={$data['GameId']}", $fields, "update", RgameInputEditGame);
}
else
{
if (isset($_GET['catid']))
{
//Fetch games by category
$sql = mysql_query("SELECT * FROM rgames_flash WHERE GameCat = '".$_GET['catid']."'");
echo "
";
}
else
{
$sql = mysql_query("SELECT * FROM rgames_cats");
echo "
";
}
}
}
/**
* Function to add a flash game
*
*/
function AddGame()
{
if (isset($_POST['submit']))
{
$gamename = $_POST['gamename'];
$gamedesc = $_POST['gamedesc'];
$gamecat = $_POST['gamecat'];
$gamefile = $_POST['gamefile'];
$gameicon = $_POST['gameicon'];
$gameorder = $_POST['gameorder'];
$gameon = $_POST['gameon'];
$totalplayed = $_POST['totalplayed'];
$gamewidth = $_POST['gamewidth'];
$gameheight = $_POST['gameheight'];
$check1 = $this->CheckField($gamename, RgameFieldGameName);
$check2 = $this->CheckField($gamedesc, RgameFieldGameDesc);
$check3 = $this->CheckField($gamecat, RgameFieldGameCat);
$check4 = $this->CheckField($gamefile, RgameFieldGameUploadSWF);
$check5 = $this->CheckField($gameicon, RgameFieldGameUploadAvatar);
$gameon = $this->CheckField($gameon, RgameFieldGameOn, 1);
if (empty($gamewidth))
{
$gamewidth = 500;
}
if (empty($gameheight))
{
$gameheight = 400;
}
if (empty($totalplayed))
{
$totalplayed = 0;
}
if ($check1 && $check2 && $check3 && $check4 && $check5)
{
//Insert the records
$sql = $this->RQuery("INSERT INTO rgames_flash(GameCat,
GameName,
GameDesc,
GameFile,
GameHeight,
GameWidth,
GameScreen,
GameOrder,
GameAlive,
GameTotalPlayed)
VALUES ('".$gamecat."',
'".$gamename."',
'".$gamedesc."',
'".$gamefile."',
'".$gameheight."',
'".$gamewidth."',
'".$gameicon."',
'".$gameorder."',
'".$gameon."',
'".$totalplayed."')
");
if ($sql)
{
DisplayMessage(RgameAddGameSuccess, 0, 1, "index.php?id=efg");
}
else
{
DisplayMessage(RgameAddGameFailure, 0, 0);
}
}
}
else
{
$formname = "AddGame";
$fields = array("*".RgameFieldGameName => FieldMaker($formname, 1, "gamename"),
"*".RgameFieldGameDesc => FieldMaker($formname, 3, "gamedesc"),
"*".RgameFieldGameCat => $this->GameCatGenerator(),
"*".RgameFieldGameUploadSWF => GenerateDirectories("./../rgames/swf/", "gamefile"),
RgameFieldGameWidth => FieldMaker($formname, 1, "gamewidth", '', 5),
RgameFieldGameHeight => FieldMaker($formname, 1, "gameheight", '', 5),
"*".RgameFieldGameUploadAvatar => GenerateDirectories("./../rgames/game_icons/", "gameicon"),
RgameFieldGameOrder => FieldMaker($formname, 1, 'gameorder', "", 5),
RgameFieldGameOn => FieldMaker($formname, 4, 'gameon'),
RgameFieldGameTotalPlayed => FieldMaker($formname, 1, 'totalplayed', '', 5)
);
echo FormGenerator(RgameInputAddGame, $formname, "index.php?id=afg", $fields, "submit", RgameInputAddGame);
}
}
/**
* Function to reorder game categories
*
*/
function ReorderGameCats()
{
if (isset($_POST['submit']))
{
$neworder = $_POST['neworder'];
foreach ($neworder as $key => $value)
{
//Get category name
$data = $this->RSqlArray("SELECT * FROM rgames_cats WHERE GameCatId = '".$key."'");
$catname = $data['GameCatName'];
$sql2 = $this->RQuery("UPDATE rgames_cats SET GameCatOrder = '".$value."'
WHERE GameCatId = '".$key."'");
if ($sql2)
{
DisplayMessage(RgameCategoryOrderSuccess." $catname", 0, 1, "index.php?id=egc");
}
else
{
DisplayMessage(RgameCategoryOrderFailutre." $catname", 0, 0);
}
}
}
else
{
$sql = $this->RQuery("SELECT * FROM rgames_cats ORDER BY GameCatOrder");
echo "
";
}
}
/**
* Function to edit game categories
*
*/
function EditGameCats()
{
if (isset($_POST['delete']))
{
$deletegcat = $_POST['deletegcat'];
foreach ($deletegcat as $key => $value)
{
$sql2 = $this->RQuery("DELETE FROM rgames_cats WHERE GameCatId = '".$key."'");
if ($sql2)
{
DisplayMessage(RgameCategoryDeleteSuccess.": $value", 0, 1, "index.php?id=egc");
}
else
{
DisplayMessage(RgameCategoryDeleteFailure.": $value", 0, 0);
}
}
}
elseif (isset($_POST['update']))
{
$catname = $_POST['catname'];
$catdesc = $_POST['catdesc'];
$caticon = $_FILES['caticon'];
$catorder = $_POST['catorder'];
$gamecatid = $_GET['gcid'];
//Check fields
$check1 = $this->CheckField($catname, RgameFieldCatName);
$check2 = $this->CheckField($catdesc, RgameFieldCatDesc);
if (empty($catorder))
{
$catorder = 1;
}
if (is_numeric($catorder))
{
$check3 = TRUE;
}
else
{
DisplayMessage(RgameBadFieldNotNumber, 0, 0);
$check3 = FALSE;
}
if ($check1 && $check2 && $check3)
{
if (empty($caticon))
{
$caticon = "noavatar.gif";
}
//Do SQL Query
$sql = $this->RQuery("UPDATE rgames_cats SET GameCatName = '".$catname."',
GameCatDescription = '".$catdesc."',
GameCatIcon = '".$caticon."',
GameCatOrder = '".$catorder."'
WHERE GameCatId = '".$gamecatid."' LIMIT 1");
if ($sql)
{
DisplayMessage(RgameCategoryUpdateSuccess.": $catname", 1, 1, "index.php?id=egc");
}
else
{
DisplayMessage(RgameCategoryUpdateFailure.": $catname", 0, 0);
}
}
else
{
DisplayMessage(RgameFillFields, 0, 0);
}
}
elseif (isset($_GET['gcid']))
{
$data = $this->RSqlArray("SELECT * FROM rgames_cats WHERE GameCatId = '".$_GET['gcid']."' LIMIT 1");
$formname = "EditCategory";
$fields = array("*".RgameFieldCatName.":" => FieldMaker($formname, 1, "catname", $data['GameCatName']),
"*".RgameFieldCatDesc.":" => FieldMaker($formname, 3, "catdesc", $data['GameCatDescription']),
"*".RgameFieldCatOrder.":" => FieldMaker($formname, 1, "catorder", $data['GameCatOrder']),
RgameFieldCatIcon.":" => GenerateDirectories("./../icons/", "caticon", $data['GameCatIcon']));
echo FormGenerator(RgameFieldEditGameCatNumber, $formname, "index.php?id=egc&gcid={$data['GameCatId']}", $fields, "update", RgameInputUpdateGameCat);
}
else
{
$sql = $this->RQuery("SELECT * FROM rgames_cats ORDER BY GameCatOrder");
echo "
";
}
}
/**
* Function to create a new category
*
*/
function AddGameCat()
{
if (isset($_POST['submit']))
{
$catname = $_POST['catname'];
$catdesc = $_POST['catdesc'];
$caticon = $_POST['caticon'];
$catorder = $_POST['catorder'];
//Check fields
$check1 = $this->CheckField($catname, RgameFieldCatName);
$check2 = $this->CheckField($catdesc, RgameFieldCatDesc);
if (empty($catorder))
{
$catorder = 1;
}
if (is_numeric($catorder))
{
$check3 = TRUE;
}
else
{
DisplayMessage(RgameBadFieldNotNumber, 0, 0);
$check3 = FALSE;
}
if ($check1 && $check2 && $check3)
{
if (empty($caticon))
{
$caticon = "noavatar.gif";
}
//Do SQL Query
$sql = $this->RQuery("INSERT INTO rgames_cats (GameCatName,
GameCatDescription,
GameCatIcon,
GameCatOrder)
VALUES ('".$catname."',
'".$catdesc."',
'".$caticon."',
'".$catorder."')");
if ($sql)
{
DisplayMessage(RgameCategoryCreateSuccess.": $catname", 1, 1, "index.php?id=egc");
}
else
{
DisplayMessage(RgameCategoryCreateFailure.": $catname", 0, 1);
}
}
else
{
DisplayMessage(RgameFillFields, 0, 0);
}
}
else
{
$formname = "NewCategory";
$fields = array("*".RgameFieldCatName.":" => FieldMaker($formname, 1, "catname"),
"*".RgameFieldCatDesc.":" => FieldMaker($formname, 3, "catdesc"),
RgameFieldCatOrder.":" => FieldMaker($formname, 1, "catorder", "", 5),
RgameFieldCatIcon.":" => GenerateDirectories("./../icons/", "caticon"));
echo FormGenerator(RgameFieldCreateGameCatNumber, $formname, "index.php?id=cgc", $fields, "submit", RgameInputCreateGameCat);
}
}
/**
* Function to edit an existing user group
*
*/
function EditGroups()
{
if (isset($_POST['delete']))
{
$deletegroup = $_POST['deletegroup'];
foreach ($deletegroup as $key => $value)
{
$delete = $this->RQuery("DELETE FROM rgames_groups WHERE GroupId = '".$key."'");
if ($delete)
{
$group .= "$value$group
", 0, 1, "index.php?id=eg"); } else if (isset($_GET['gid'])) { //Edit user $data = $this->RSqlArray("SELECT * FROM rgames_groups WHERE GroupId = '".$_GET['gid']."' LIMIT 1"); $formname = "EditGroup"; $fields = array("*".RgameFieldGroupName.":" => FieldMaker($formname, 1, "groupname", $data['GroupName']), RgameFieldGroupPermissionPlayGames.":" => FieldMaker($formname, 4, "playgames", $data['PlayGames']), RgameFieldGroupPermissionAdmin.":" => FieldMaker($formname, 4, "accessadmin", $data['AccessAdmin']), RgameFieldGroupPermissionManageGroups.":" => FieldMaker($formname, 4, "managegroups", $data['ManageGroups']), RgameFieldGroupPermissionManageUsers.":" => FieldMaker($formname, 4, "manageusers", $data['ManageUsers']), RgameFieldGroupPermissionManageGames.":" => FieldMaker($formname, 4, "managegames", $data['ManageGames']), RgameFieldGroupPermissionManageCats.":" => FieldMaker($formname, 4, "managecats", $data['ManageCats']), RgameFieldGroupPermissionManageTemplates.":" => FieldMaker($formname, 4, "managetemplates", $data['ManageTemplates'])); echo FormGenerator(RgameFieldEditGroup, $formname, "index.php?id=eg&v={$data['GroupId']}", $fields, "UpdateGroup", RgameInputUpdateGroups); } else if (isset($_POST['UpdateGroup'])) { $groupname = $_POST['groupname']; $accessadmin = $_POST['accessadmin']; $managegroups = $_POST['managegroups']; $manageusers = $_POST['manageusers']; $managegames = $_POST['managegames']; $managecats = $_POST['managecats']; $managetemplates = $_POST['managetemplates']; $playgames = $_POST['playgames']; $check1 = $this->CheckField($groupname, RgameFieldGroupName); $accessadmin = $this->CheckField($accessadmin, "", 1); $managegroups = $this->CheckField($managegroups, "", 1); $manageusers = $this->CheckField($manageusers, "", 1); $managegames = $this->CheckField($managegames, "", 1); $managecats = $this->CheckField($managecats, "", 1); $managetemplates = $this->CheckField($managetemplates, "", 1); $playgames = $this->CheckField($playgames, "", 1); if ($check1) { //If everything went well, add thegroup $sql = $this->RQuery("UPDATE rgames_groups SET GroupName = '".$groupname."', PlayGames = '".$playgames."', AccessAdmin = '".$accessadmin."', ManageGroups = '".$managegroups."', ManageUsers = '".$manageusers."', ManageCats = '".$managecats."', ManageTemplates = '".$managetemplates."', ManageGames = '".$managegames."' WHERE GroupId = '".$_GET['v']."'"); if ($sql) { echo DisplayMessage(RgameGroupUpdateSuccess.": ".$groupname."".RgameEditUsersGuide."
"; } } /** * Function to create a new user * */ function AddUser() { if (isset($_POST['createusers'])) { $username = $_POST['username']; $password = $_POST['Password']; $usergroup = $_POST['usergroup']; $check1 = $this->CheckField($username, RgameFieldUsername, 3, "rgames_users", "UserName"); //Check for password field $check2 = $this->CheckField($password, RgameFieldPassword); //Check for password field $check3 = $this->CheckField($usergroup, RgameFieldUsergroup); if ($check1 && $check2 && $check3) { $available = $this->RNumRows("SELECT * FROM rgames_users WHERE UserName = '".$username."'"); //First check incase the username exists if ($available) { DisplayMessage(RgameUserNameExists.": $username", 0, 0); } else { $password = $this->Encryptor($password); //If everything went well, add the users $sql = $this->RQuery("INSERT INTO rgames_users (UserGroup, UserName, PassWord) VALUES ('".$usergroup."', '".$username."', '".$password."')"); if ($sql) { echo DisplayMessage(RgameUserCreateSuccess.": ".$username."$deleteditems
", 0, 1, "index.php?id=efg", $dir); } } else { $sql = $this->RQuery("SELECT * FROM rgames_flashcomments WHERE GameId = '".$gid."'"); echo " "; } } /** * Function to display the search box * */ function GameSearch() { $this->Connection(); $temp = new TEMPLATES(); $all = $_POST['all']; $any = $_POST['any']; $none = $_POST['none']; if((!$all) || ($all == "")) { $all = ""; } else { $all = "+(".$all.")"; } if((!$any) || ($any == "")) { $any = ""; } if((!$none) || ($none == "")) { $none = ""; } else { $none = "-(".$none.")"; } $skin = $this->RSqlArray("SELECT * FROM rgames_templates WHERE TempId = '4'"); $sql = mysql_query("SELECT *, MATCH(GameName, GameDesc) AGAINST ('$all $none $any' IN BOOLEAN MODE) AS score FROM rgames_flash WHERE MATCH(GameName, GameDesc) AGAINST ('$all $none $any' IN BOOLEAN MODE)"); echo " "; } } ?>