| | Rating | | ' . $rating[0] . '' . $rating[1] . ' |
| ';
break;
case 'review':
if($_GET['id'])
{
$id = clean($_GET['id']);
$reviews = mysql_query("SELECT * FROM `reviews` WHERE `id` = '$id'");
$review = mysql_fetch_array($reviews);
$games = mysql_query("SELECT * FROM `games` WHERE `id` = '{$review['gameid']}'");
$game = mysql_fetch_array($games);
$authors = mysql_query("SELECT * FROM `accounts` WHERE `id` = '{$review['authorid']}'");
$author = mysql_fetch_array($authors);
$main = $main . '
| Review for ' . $game['name'] . ' by ' . $author['user'] . ' |
|---|
';
if($review['gamerev'])
{
$main = $main . '| Gameplay |
|---|
| ' . $review['gamerev'] . ' | | ';
$overall += $review['gameplay'];
$count++;
}
if($review['storyrev'])
{
$main = $main . '| Storyline |
|---|
| ' . $review['storyrev'] . ' | | ';
$overall += $review['storyline'];
$count++;
}
if($review['graphrev'])
{
$main = $main . '| Graphics |
|---|
| ' . $review['graphrev'] . ' | | ';
$overall += $review['storyline'];
$count++;
}
if($review['diffrev'])
{
$main = $main . '| Difficulty |
|---|
| ' . $review['diffrev'] . ' | | ';
$overall += $review['compatibility'];
$count++;
}
if($review['origrev'])
{
$main = $main . '| Security |
|---|
| ' . $review['origrev'] . ' | | ';
$overall += $review['originality'];
$count++;
}
if($review['comprev'])
{
$main = $main . '| Compatibility |
|---|
| ' . $review['comprev'] . ' | | ';
$overall += $review['compatibility'];
$count++;
}
if($review['secrev'])
{
$main = $main . '| Security |
|---|
| ' . $review['secrev'] . ' | | ';
$overall += $review['security'];
$count++;
}
if($review['suprev'])
{
$main = $main . '| Support |
|---|
| ' . $review['suprev'] . ' | | ';
$overall += $review['support'];
$count++;
}
$overall = round($overall/$count);
$main = $main . '
| Scores |
|---|
| Gameplay: | ' . $review['gameplay'] . '/25 | Story: | ' . $review['storyline'] . '/20 |
| Graphics: | ' . $review['graphics'] . '/10 | Originality | ' . $review['originality'] . '/10 |
| Difficulty: | ' . $review['difficulty'] . '/10 | Support: | ' . $review['support'] . '/10 |
| Compatibility: | ' . $review['compatibility'] . '/5 | Overall | ' . $review['overall'] . '/10 |
|
|
';
}
break;
case 'offer':
$id = clean($_GET['id']);
if(!$id)
{
header('location: http://www.rpgtoplist.com/?email=' . $email);
}
else
{
$offers = mysql_query("SELECT * FROM `offers` WHERE `id` = '$id'");
$offer = mysql_fetch_array($offers);
$games = mysql_query("SELECT * FROM `games` WHERE `id` = '{$offer['gameid']}'");
$game = mysql_fetch_array($games);
if($offer['promo'])
{
$promo = '| Promo code: | ' . $offer['promo'] . ' |
| Offer for ' . $game['name'] . ' |
|---|
| Offered: | ' . $offer['subject'] . ' |
| Details: | ' . $offer['body'] . ' |
' . $promo . '
|
|
';
}
break;
case 'archive':
if(($_COOKIE['rpgtoplist'] || $_SESSION['rpgtoplist']) && $email)
{
$main = $main . '
| Newsletter archive |
|---|
';
if(!$_GET['newsletter'])
{
$main = $main . '| Subject | Date | | | ';
$newsletter = @mysql_query("SELECT * FROM `newsletters` order by `time` ASC") or die (mysql_error());
while($news = @mysql_fetch_array($newsletters))
{
$main = $main . ' | ' . $news['subject'] . ' | ' . $news['date'] . ' | View online | Resend email | ';
}
}
elseif($_GET['resend'] == 'Y')
{
$news = clean($_GET['news']);
$newsletter = @mysql_query("SELECT * FROM `newsletters` WHERE `id` = '$news'");
$news = @mysql_fetch_array($news);
require_once("Mail.php");
require_once("Mail/mime.php");
$message = new Mail_Mime("\n");
$from = 'RPG Top List ';
$to = $info['email'];
$subject = 'RPG Top List newsletter #' . $news['id'] . ': ' . $news['subject'];
$message -> setHTMLBody($news['body']);
$host = "mail.lotdhosting.com";
$username = "no-reply@rpgtoplist.com";
$password = "7890a3c";
$mailer= 'PHP/' . phpversion();
$headers = array ('From' => $from,
'To' => $to,
'Subject' => $subject,
'X-Mailer' => $mailer);
$body = $message->get();
$headers = $message ->headers($headers);
$smtp = Mail::factory('smtp',
array ('host' => $host,
'auth' => true,
'username' => $username,
'password' => $password));
$mail = $smtp->send($to, $headers, $body);
if (PEAR::isError($mail)) {
echo("" . $mail->getMessage() . " ");
}
$main = $main . '| The newsletter has been sent. Click here to go back. | ';
}
else
{
$newsletter = @mysql_query("SELECT * FROM `newsletters` WHERE `id` = '$news'");
$news = @mysql_fetch_array($news);
$main = $main . '| ' . $news['subject'] . ' |
| ' . $news['body'] . ' | ';
}
$main = $main . ' |
';
}
break;
case 'profile':
$id = clean($_GET['id']);
$users = mysql_query("SELECT * FROM `accounts` WHERE `id` = '$id'");
$user = mysql_fetch_array($users);
$name = explode(' ', $user['name']);
$main = $main . '
| ' . $user['user'] . ' |
|---|
| First name: | ' . $name[0] . ' |
| Last name: | ' . $name[1] . ' | ';
if($user['access'] == 2)
{
$main = $main . 'Company: | ' . $user['company'] . ' |
Owner of: | ';
$game = mysql_query("SELECT * FROM `games` WHERE `ownerid` = '{$user['id']}'");
while($games = mysql_fetch_array($game))
{
$main = $main . '' . $games['name'] . '
';
}
$main = $main . ' | ';
}
$main = $main . ' |
';
break;
case 'game':
if($_GET['id'])
{
$id = clean($_GET['id']);
$game = @mysql_query("SELECT * FROM `games` WHERE `id` = '$id'") or die(mysql_error());
$games = @mysql_fetch_array($game);
$rats = mysql_query("SELECT AVG(`rating`) FROM `comments` WHERE `gameid` = '$id'");
$revs = mysql_query("SELECT AVG(`overall`) FROM `reviews` WHERE `gameid` = '$id'");
$rat = round(mysql_result($rats, 0), 1);
$rev = round(mysql_result($revs, 0), 1);
$score = explode('.',$rev);
$rating = explode('.',$rat);
$date = date('m/d/y',$games['dateadded']);
$rank = mysql_query("SELECT COUNT(`id`)+1 FROM `games` WHERE `votes` > '{$games['votes']}'") or die(mysql_error());
$ranking = mysql_result($rank, 0);
$main = '
| ' . $games['name'] . ' - Created by ' . $games['owner'] . ' from ' . $games['company'] . ' Added - ' . $date . ' |
|---|
| Category: | ' . $games['category'] . ' | Status | ' . $games['status'] . ' |
| Interface: | ' . $games['interface'] . ' | Client: | ' . $games['client'] . ' |
| Plugin: | ' . $games['plugin'] . ' | Platform: | ' . $games['platform'] . ' |
| Cost: | ' . $games['cost'] . ' | Prizes: | ' . $games['prizes'] . ' |
| # Players: | ' . $games['players'] . ' | Votes: | ' . $games['votes'] . ' |
| Last Ranking: | ' . $games['lastrank'] . ' | Current Ranking: | ' . $ranking . ' |
|
| Description: ' . $games['description'] . ' |
|
|
|
| Overall Score |
|---|
| ' . $score[0] . '' . $score[1] . ' |
|
| Player Rating |
|---|
| ' . $rating[0] . '' . $rating[1] . ' |
|
|
| Screenshots |
|---|
';
/* $id = clean($_GET['id']);
$screen = opendir('/hsphere/local/home/lordsof/rpgtoplist.com/images/screenshots/' . $game['name']);
while($screenshot=readdir($screen))
{
$main = $main . ' | ';
}
$main = $main . ' ';
$name = explode('.', $file);
while($screenshot=readdir($screen))
{
$main = $main . '| ' . $name[0] . ' | ';
}
*/
$main = $main . '
|
|
| ' . $games['name'] . '\'s Offers |
|---|
';
$offers = @mysql_query("SELECT * FROM `offers` WHERE `gameid`='$id'");
$num = @mysql_num_rows($offers);
while($off = @mysql_fetch_array($offers))
{
$main = $main . '| ' . ucfirst($off['subject']) . ' offered! | ';
}
while($num <= 10)
{
$main = $main . '| | ';
$num++;
}
if($info['access']>=2 && $info['id'] == $games['ownerid'])
{
$add = '(Add Offer)';
}
else
{
$add = ' ';
}
$main = $main . '
| ' . $add . ' | |
| ' . $games['name'] . '\'s Reviews |
|---|
';
$id = clean($_GET['id']);
$reviews = @mysql_query("SELECT * FROM `reviews` WHERE `gameid` = '$id'") or die(mysql_error());
$num = @mysql_num_rows($reviews);
while($review = @mysql_fetch_array($reviews))
{
$sql = mysql_query("SELECT `user` FROM `accounts` WHERE `id` = '{$review['authorid']}'") or die(mysql_error());
$author = mysql_fetch_array($sql);
$main = $main . '| Review by ' . $author['user'] . ' | ';
}
while($num <= 10)
{
$main = $main . '| | ';
$num++;
}
if($info['access']>=4)
{
$add = '(Add Review)';
}
else
{
$add = ' ';
}
$main = $main . '| ' . $add . ' |
|
| ' . $games['name'] . '\'s Comments |
|---|
';
$id=clean($_GET['id']);
$comments = @mysql_query("SELECT * FROM `comments` WHERE `gameid`='$id'") or die(mysql_error());
$num = @mysql_num_rows($comments);
while($comment = @mysql_fetch_array($comments))
{
if($comment['authorid'])
{
$by = '' . $comment['author'] . '';
}
else
{
$by = $comment['author'];
}
$main = $main . '| Comment by ' . $by . ' ' . $comment['rating'] . ' / 10 | ';
}
while($num <= 10)
{
$main = $main . '| | ';
$num++;
}
$main = $main . '| (Add Comment) |
| |
|
';
}
elseif(!$_GET['cat'])
{
$_GET['cat'] = 'All';
}
elseif($_GET['cat'] == 'All')
{
$order = clean($_GET['order']);
if(!$_GET['order'])
{
$order = 'name';
}
if(!$_GET['dir'])
{
$dir = 'ASC';
}
elseif($_GET['dir']=='ASC')
{
$dir = 'DESC';
}
else
{
$dir = 'ASC';
}
$main = '| All Games |
|---|
| Name | Category | Date Added | Votes | Player Rating | Overall Score | Description | ';
$game = @mysql_query("SELECT * FROM `games` ORDER BY `$order` $dir") or die (mysql_error());
$i = 0;
while($games = @mysql_fetch_array($game))
{
if($color == '#7F7F7F')
{
$color = '#666666';
}
else
{
$color = '#7F7F7F';
}
$i++;
$ratings = mysql_query("SELECT AVG(`rating`) FROM `comments` WHERE `gameid` = '{$games['id']}'");
$rating = round(mysql_result($ratings, 0), 1);
if(!$rating)
{
$rating = 0;
}
$date = date("d/m/y",$games['dateadded']);
$main = $main . '| ' . $games['name'] . ' | ' . $games['category'] . ' | ' . $date . ' | ' . $games['votes'] . ' | ' . $rating . ' | ' . $games['score'] . ' | ' . $games['shortdesc'] . ' | ';
}
$main = $main . '
|
';
}
else
{
if(!$_GET['order'])
{
$order = 'name';
}
if(!$_GET['dir'])
{
$dir = 'ASC';
}
elseif($_GET['dir'] == 'ASC')
{
$dir = 'DESC';
}
else
{
$dir = 'ASC';
}
$main = '| ' . $_GET['cat'] . ' Games |
|---|
| Name | Date Added | Votes | Player Rating | Overall Score | Description |
';
$cat = clean($_GET['cat']);
if(!$order){$order = clean($_GET['order']);}
$game = @mysql_query("SELECT * FROM `games` WHERE `category`='$cat' ORDER BY `$order` $dir") or die (mysql_error());
$i = 0;
while($games = @mysql_fetch_array($game))
{
if($color == '#7F7F7F')
{
$color = '#666666';
}
else
{
$color = '#7F7F7F';
}
$i++;
$ratings = mysql_query("SELECT AVG(`rating`) FROM `comments` WHERE `gameid` = '{$games['id']}'");
$rating = round(mysql_result($ratings, 0), 1);
$revs = mysql_query("SELECT AVG(`overall`) FROM `reviews` WHERE `gameid` = '{$games['id']}'");
$rev = round(mysql_result($revs, 0), 1);
if(!$rating)
{
$rating = 0;
}
$date = date("d/m/y",$games[dateadded]);
$main = $main . '| ' . $games['name'] . ' | ' . $date . ' | ' . $games['votes'] . ' | ' . $rating . ' | ' . $rev . ' | ' . $games['shortdesc'] . ' |
';
}
$main = $main . '
';
}
break;
case 'news':
$article = @mysql_query("SELECT * FROM `news` WHERE `id`=$_GET[id]") or die(mysql_error());
$news = mysql_fetch_array($article);
$main = '| ' . $news['subject'] . ' | ' . $news['body'] .'
Click here to go back to the main page. |
';
break;
case 'screenshot':
header('Content-type: image/png');
$image = imagecreatefrompng('./images/screenshots/' . $_GET['game'] . '/' . $_GET['screen']);
$newimage = imagecreatetruecolor(45,60);
$size = getimagesize($image);
imagecopyresized($newimage,$image,0,0,0,0,60,45, $size[0],$size[1]);
imagepng($newimage);
imagedestroy($image);
imagedestroy($newimage);
/*if( ($_GET['game']) && ($_GET['id']) )
{
$ext = explode('.','$_GET[screenshot]');
switch ($ext[1])
{
case 'jpg':
case 'jpeg':
$img = @imagecreatefromjpeg("http://www.rpgtoplist.com/images/screenshots/$_GET[game]/$_GET[screenshot]");
break;
case 'png':
$img = @imagecreatefrompng("http://www.rpgtoplist.com/images/screenshots/$_GET[game]/$_GET[screenshot]");
break;
case 'gif':
$img = @imagecreatefromgif("http://www.rpgtoplist.com/$_GET[game]/$_GET[screenshot]");
break;
}
if($img)
{
$size = getimagesize($img);
$width = $size[0];
$height = $size[1];
$new_style="height:90px";
$new_width=70;
$tmp_img = imagecreatetruecolor($new_width, $new_height);
imagecopyresampled($tmp_img, $img, 0, 0, 0, 0, $new_width, $new_height, $width, $height);
imagedestroy($img);
$img = $tmp_img;
imagejpeg($img, null, 100);
}
}*/
break;
default:
header('location: http://www.rpgtoplist.com');
break;
}
include_once('footer.php');
?>