|
Latest News |
|---|
';
$news=@mysql_query("SELECT * FROM `news` ORDER BY `id` DESC LIMIT 10") or die (mysql_error());
$num=1;
while($latest=@mysql_fetch_array($news))
{
$main=$main . '| ' . $num .' | ' . $latest['subject']. ' | ';
$num++;
}
if($info['access'] >= 5)
{
$insert = '(Add News Item)';
}
else
{
$insert = ' ';
}
$main=$main . '| ' . $insert . ' |
|
|
Last week\'s winners |
|---|
';
$lastweek=@mysql_query("SELECT * FROM `rankings` ORDER BY `votes` DESC LIMIT 10") or die (mysql_error());
$num=1;
while(($top=@mysql_fetch_array($lastweek))&&($num<=10))
{
if($num==1)
{
$ext='st';
}
elseif($num==2)
{
$ext='nd';
}
elseif($num==3)
{
$ext='rd';
}
else
{
$ext='th';
}
$main=$main . '| ' . $num .' | ' . $top['name']. ' got ' . $num . $ext . ' place with ' . $top['votes'] . ' votes | ';
$num++;
}
$main=$main . '| |
|
|
Latest Offers |
|---|
';
$offers=@mysql_query("SELECT * FROM `offers` ORDER BY `id` DESC LIMIT 10") or die (mysql_error());
$num=1;
while($off=@mysql_fetch_array($offers))
{
$gam=@mysql_query("SELECT * FROM `games` WHERE `id`='$off[gameid]'") or die (mysql_error());
$game=@mysql_fetch_array($gam);
$main=$main . '| ' . $num .'. ' . $game['name']. '. Check Now! | ';
$num++;
}
for($i=$num; $i<=10; $i++)
{
$main = $main . '| | ';
}
$main=$main . '
| ';
if($info['access'] >= 2)
{
$insert = '(Add Offer)';
}
else
{
$insert = ' ';
}
$main = $main . '| ' . $insert . ' |
|
|
Latest Reviews |
|---|
';
$reviews = @mysql_query("SELECT * FROM `reviews` ORDER BY `id` DESC LIMIT 10") or die (mysql_error());
$num = 1;
while($rev = @mysql_fetch_array($reviews))
{
$gam = @mysql_query("SELECT * FROM `games` WHERE `id` = {$rev['gameid']}") or die (mysql_error());
$game = @mysql_fetch_array($gam);
$author = @mysql_query("SELECT * FROM `accounts` WHERE `id` = {$rev['authorid']}") or die (mysql_error());
$auth = @mysql_fetch_array($author);
$main = $main . '| ' . $num .'. ' . $game['name'] . ' by ' . $auth['user'] . ' | ';
$num++;
}
for($i=$num; $i<=10; $i++)
{
$main = $main . '| | ';
}
$main=$main . '
| ';
if($info['access'] >= 4)
{
$insert = '(Add Review)';
}
else
{
$insert = ' ';
}
$main = $main . '| ' . $insert . ' |
|
|
Latest Games |
|---|
';
$newgames=@mysql_query("SELECT * FROM `games` ORDER BY `id` DESC LIMIT 10") or die (mysql_error());
$num=1;
while($new=@mysql_fetch_array($newgames))
{
$main=$main . '| ' . $num .'. ' . $new['name']. ' | ';
$num++;
}
for($i=$num; $i<=10; $i++)
{
$main = $main . '| | ';
}
$main=$main . '
| | ';
if($info['access'] >= 2)
{
$insert = '| (Add Game) | ';
}
else
{
$insert = ' ';
}
$main = $main . '| ' . $insert . ' |
|
';
include('footer.php');
?>
|