Hmm,it could show some things like the Arcade Champions or the newest games....I will give it a shot,but someone who knows php better than me should try that, too.
EDIT
Sorry,now I realised that there were topics for this issue....
Posted 17 November 2006 - 12:47 PM
Posted 29 December 2006 - 11:50 AM
<tr><th width="50%" nowrap="nowrap">Game Name</th><th width="30%" nowrap="nowrap">Champ</th><th width="20%" nowrap="nowrap">New Score</th></tr>
<?
$champer = mysql_query("SELECT c.*, g.gcat, cat.password FROM ibf_games_champs AS c, ibf_games_list AS g, ibf_games_cats AS cat WHERE c.champ_gid=g.gid AND g.gcat=cat.c_id AND trim(password)='' ORDER BY champ_date DESC LIMIT 0,10");
while($goats=mysql_fetch_array($champer))
{
$the_game_id=$goats["champ_gid"];
$game_title=$goats["champ_gtitle"];
$game_name=$goats["champ_name"];
$game_score = $this->ipsclass->do_number_format($goats["champ_score"]);
$content .= "<tr><td class='row1' colspan='1'><a href=".$this->ipsclass->base_url."act=Arcade&do=play&gameid=".$the_game_id."> <b>$game_title</b></a></td><td class='row1' colspan='1'> <b>$game_name</b></td> <td class='row1' colspan='1'> <b>$game_score</b></td></tr>";
}
echo $content;
?>Posted 31 December 2006 - 08:24 AM
ShootMePls, on Dec 29 2006, 06:50 PM, said:
<tr><th width="50%" nowrap="nowrap">Game Name</th><th width="30%" nowrap="nowrap">Champ</th><th width="20%" nowrap="nowrap">New Score</th></tr>
<?
$champer = mysql_query("SELECT c.*, g.gcat, cat.password FROM ibf_games_champs AS c, ibf_games_list AS g, ibf_games_cats AS cat WHERE c.champ_gid=g.gid AND g.gcat=cat.c_id AND trim(password)='' ORDER BY champ_date DESC LIMIT 0,10");
while($goats=mysql_fetch_array($champer))
{
$the_game_id=$goats["champ_gid"];
$game_title=$goats["champ_gtitle"];
$game_name=$goats["champ_name"];
$game_score = $this->ipsclass->do_number_format($goats["champ_score"]);
$content .= "<tr><td class='row1' colspan='1'><a href=".$this->ipsclass->base_url."act=Arcade&do=play&gameid=".$the_game_id."> <b>$game_title</b></a></td><td class='row1' colspan='1'> <b>$game_name</b></td> <td class='row1' colspan='1'> <b>$game_score</b></td></tr>";
}
echo $content;
?>Posted 10 May 2007 - 01:36 AM
<?
$homey = $this->ipsclass->DB->query("SELECT gname,gtitle,gid,object,gcount FROM ibf_games_list WHERE active=1 ORDER BY RAND() LIMIT 1");
while($mouse=mysql_fetch_array($homey))
{
$randomgameid=$mouse["gid"];
$randomgamename=$mouse["gname"];
$randomgametitle=$mouse["gtitle"];
$randomgameobject=$mouse["object"];
$randomgamecount=$mouse["gcount"];
$content .= "<center><a href='/index.php?autocom=arcade&code=play&g=$randomgameid'><img src='/arcade/images/{$randomgamename}1.gif'></img><br /><b><span style='color:red'>Play $randomgametitle</span></b></a><hr><b><u>Times Played: </b>$randomgamecount</u><hr><b><u>Description</u></b><br />$randomgameobject</center>";
}
echo $content;
?>
Posted 12 December 2007 - 07:22 AM
$content .= "<center><a href='index.php?autocom=arcade&code=play&g=$randomgameid'><img src='arcade/images/{$randomgamename}1.gif'></img><br /><b><span style='color:red'>Play $randomgametitle</span></b></a><hr><b><u>Times Played:Posted 28 August 2008 - 08:43 PM
ShootMePls, on Dec 29 2006, 08:50 PM, said:
<tr><th width="50%" nowrap="nowrap">Game Name</th><th width="30%" nowrap="nowrap">Champ</th><th width="20%" nowrap="nowrap">New Score</th></tr>
<?
$champer = mysql_query("SELECT c.*, g.gcat, cat.password FROM ibf_games_champs AS c, ibf_games_list AS g, ibf_games_cats AS cat WHERE c.champ_gid=g.gid AND g.gcat=cat.c_id AND trim(password)='' ORDER BY champ_date DESC LIMIT 0,10");
while($goats=mysql_fetch_array($champer))
{
$the_game_id=$goats["champ_gid"];
$game_title=$goats["champ_gtitle"];
$game_name=$goats["champ_name"];
$game_score = $this->ipsclass->do_number_format($goats["champ_score"]);
$content .= "<tr><td class='row1' colspan='1'><a href=".$this->ipsclass->base_url."act=Arcade&do=play&gameid=".$the_game_id."> <b>$game_title</b></a></td><td class='row1' colspan='1'> <b>$game_name</b></td> <td class='row1' colspan='1'> <b>$game_score</b></td></tr>";
}
echo $content;
?>
0 members, 1 guests, 0 anonymous users