$DB->query("SELECT g.gid, g.gtitle, g.gname, g.gcat, g.gcost, g.gwords, cat.password FROM ibf_games_list AS g, ibf_games_cats AS cat WHERE g.active=1 AND g.gcat=cat.c_id AND trim(password)='' ORDER BY RAND() LIMIT 1");
$random_game = $DB->fetch_row();

$DB->query("SELECT s.*, g.gtitle, g.decpoints, g.gid, c.password FROM ibf_games_scores AS s, ibf_games_list AS g, ibf_games_cats AS c WHERE s.gid=g.gid AND g.gcat=c.c_id AND trim(password)='' ORDER BY datescored DESC LIMIT 0, 1");
$newest_score = $DB->fetch_row();

$latestinfo = $ibforums->lang['newest_score'];

$i = 0;
$DB->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,1");
while( $champrow = $DB->fetch_row() )
{
$champrow['champ_date'] = $std->get_date($champrow['champ_date'],'ARCADE');
if( $champrow['champ_date'] == date("m/d/Y") )
{
$champrow['champ_date'] = $ibforums->lang['today'];
}
else
{
$yesterday = date("m/d/Y", mktime(0, 0, 0, date("m") , date("d")-1, date("Y")));
if( $champrow['champ_date'] == $yesterday )
{
$champrow['champ_date'] = $ibforums->lang['yesterday'];
}
}
}

$league = $DB->query("SELECT l.mid, l.gid, AVG(l.position) AS position, SUM(l.points) as points,
m.name
FROM ibf_games_league AS l
LEFT JOIN ibf_members AS m ON (l.mid=m.id)
".$extquery."
GROUP by mid
ORDER BY points DESC LIMIT 3");
while ($row = $DB->fetch_row($league) ) {
extract($row);
$rank++;
$Ctt++;
$name = $row['name'];
if ($ibforums->member['id'] == $mid) {
$name = "<b>".$name."</b>";
}
$Champion['ArcadeChampion'.$Ctt] = '<a href="'.$ibforums->base_url.'showuser='.$mid.'">'.$name.'</a>';

}

//latest games
$DB->query("SELECT g.gid, g.gtitle, g.gname, g.gcat, cat.password FROM ibf_games_list AS g, ibf_games_cats AS cat WHERE g.active=1 AND g.gcat=cat.c_id AND trim(password)='' ORDER BY g.added DESC LIMIT 1");
$i=0;
while ($row = $DB->fetch_row() ) {
$game = $row[gid];
$gtitle = $row[gtitle];
$glink = "<img src=' Forum/arcade/images/{$row[gname]}2.gif''> <a href='Forum/index.php?act=Arcade&do=play&gameid={$game}'>{$gtitle}</a>";
}
$data = "<div class='tableborder'>
<div class='row2'>
<table class='postdetails' style='font-size: 9px;' width='100%'>
<tr><td>
<center><b>[<a href='Forum/index.php?act=Arcade'>Aller dans l'arcade</a>]</b></center></td></tr>
<tr><td class='darkrow1' colspan='2'>Champions de l'arcade</td></tr>
<tr>
<td class='row4'><b>Premier:</b> {$Champion['ArcadeChampion1']}<br></td>
</tr>
<tr>
<td class='row4'><b>Second:</b> {$Champion['ArcadeChampion2']}<br></td>
</tr>
<tr>
<td class='row4'><b>Troisième:</b> {$Champion['ArcadeChampion3']}<br></td>
</tr>
<tr>
<td class='darkrow1' colspan='2'>Dernier jeu</td>
</tr>
<tr>
<td class='row4'>{$glink}</td>
</tr>
<tr>
<td class='darkrow1' colspan='2'>Jeu au hasard</td>
</tr>
<tr>
<td class='row4'>
<img src='Forum/arcade/images/{$random_game[gname]}2.gif' title='{$random_game[gtitle]}' alt='{$random_game[gtitle]}'> <a href='Forum/index.php?act=Arcade&do=play&gameid={$random_game['gid']}'>{$random_game[gtitle]}</a>
<tr>
<td class='darkrow1' colspan='2'>Dernier Score</td>
</tr>
<tr>
<td class='row4'>{$newest_score['name']} a fait {$newest_score['score']} au jeu <a href='Forum/index.php?act=Arcade&do=play&gameid={$newest_score['gid']}'>{$newest_score['gtitle']}</a></td>
</tr></table></div>";