i added a new custom block for the arcade. works with ibProArcade 3.4
(you just need to translate the dutch language to english or any other)
this display ,
- Link to arcade
- Top 3 champions
- Newest game
- Random game
- Latest score
<?php
$this->ipsclass->DB->query("SELECT * FROM ibf_games_list WHERE active = 1 ORDER BY RAND() LIMIT 0, 1");
$random_game = $this->ipsclass->DB->fetch_row();
$this->ipsclass->DB->query("SELECT g.gtitle, g.gid, g.gname, s.gid, s.score, s.datescored, s.mid, m.mgroup, m.members_display_name, m.id FROM ibf_games_scores AS s LEFT JOIN ibf_games_list AS g ON (g.gid=s.gid) LEFT JOIN ibf_members AS m ON (m.id=s.mid) ORDER BY s.datescored DESC LIMIT 1");
$newest_score = $this->ipsclass->DB->fetch_row();
$i = 0;
$this->ipsclass->DB->query("SELECT s.*, m.members_display_name as name, m.mgroup, g.* from ibf_games_scores as s LEFT JOIN ibf_games_list as g ON (s.gid = g.gid) LEFT JOIN ibf_members as m ON (s.mid = m.id) WHERE g.active = 1 AND s.is_highscore = 1 ORDER BY s.datescored DESC LIMIT 0,1");
while( $champrow = $this->ipsclass->DB->fetch_row() )
{
$champrow['datescored'] = $this->ipsclass->get_date($champrow['datescored'],'ARCADE');
if( $champrow['datescored'] == date("m/d/Y") )
{
$champrow['datescored'] = $this->ipsclass->lang['today'];
}else{
$yesterday = date("m/d/Y", mktime(0, 0, 0, date("m") , date("d")-1, date("Y")));
}
if( $champrow['datescored'] == $yesterday )
{
$champrow['datescored'] = $this->ipsclass->lang['yesterday'];
}
}
$league = $this->ipsclass->DB->query("select l.userid, AVG(l.position) AS position , sum(l.points) as totalpoints, m.members_display_name as name , m.mgroup , arcade_time_spent, id from ibf_games_league as l left join ibf_members as m on (l.userid = m.id) group by l.userid order by totalpoints desc LIMIT 3");
while ($row = $this->ipsclass->DB->fetch_row($league) )
{
extract($row);
$rank++;
$Ctt++;
$name = "<b>".$row['name']."</b>";
$Champion['ArcadeChampion'.$Ctt] = '<a href="'.$this->ipsclass->base_url.'showuser='.$row['userid'].'">'.$name.'</a>';
}
$this->ipsclass->DB->query("SELECT gname,gid,gtitle FROM ibf_games_list WHERE active=1 ORDER BY gid DESC LIMIT 1");
$i=0;
while ($rows = $this->ipsclass->DB->fetch_row() )
{
$game = $rows['gid'];
$gtitle = $rows['gtitle'];
$glink = "<img src='arcade/images/{$rows[gname]}2.gif'> <a href='index.php?autocom=arcade&do=play&gameid={$game}'>{$gtitle}</a>";
}
echo "<center><b>[<a href='index.php?autocom=arcade'>Ga Naar Speelhal</a>]</b></center></tr>
<tr><td class='darkrow3' colspan='2'>Kampioen Speelhal</td></tr>
<tr>
<td class='row2'><b>1ste Plaats:</b> {$Champion['ArcadeChampion1']}<br></td>
</tr>
<tr>
<td class='row2'><b>2de Plaats:</b> {$Champion['ArcadeChampion2']}<br></td>
</tr>
<tr>
<td class='row2'><b>3de Plaats:</b> {$Champion['ArcadeChampion3']}<br></td>
</tr>
<tr>
<td class='darkrow3' colspan='2'>Nieuwe Game</td>
</tr>
<tr>
<td class='row2'>{$glink}</td>
</tr>
<tr>
<td class='darkrow3' colspan='2'>Willekeurige Game</td>
</tr>
<tr>
<td class='row2'>
<img src='arcade/images/{$random_game[gname]}2.gif' title='{$random_game[gtitle]}' alt='{$random_game[gtitle]}'> <a href='index.php?autocom=arcade&do=play&gameid={$random_game['gid']}'>{$random_game[gtitle]}</a>
<tr>
<td class='darkrow1' colspan='2'>Laatste Score</td>
</tr>
<tr>
<td class='row2'>
{$newest_score['members_display_name']} scored {$newest_score['score']} points playing <a href='index.php?autocom=arcade&do=play&gameid={$newest_score['gid']}'>{$newest_score['gtitle']}</a> <img src='arcade/images/{$newest_score[gname]}2.gif' title='{$newest_score[gtitle]}' alt='{$newest_score[gtitle]}'>
</td>
</tr>";
?>
1
