[Please participate] Most Played Games, cut off by time, for example last 30 days

[basketmen]

Hi guys, i think the current Most Played Games, is not good and very rarely updated by other games, almost static, its should be more dynamic

its should be cut off by time, for example make it Most Played Games in the last 30 days



in arcade.php i see this lines

// Begin Most Popular Games
$DB->query("SELECT g.gid, g.gtitle, g.gname, g.gcat, cat.password, g.gcount, cat.active FROM ibf_games_list AS g, ibf_games_cats AS cat WHERE g.active=1 AND cat.active=1 AND g.gcat=cat.c_id AND trim(password)='' ORDER BY g.gcount DESC LIMIT ".$this->arcade->settings['games_popular']);
$firstpop = true;
while($popgline = $DB->fetch_row()) {
if($firstpop) {
$firstpop = false;
} else {
$pop_games .= "<br />\n";
}
$pop_games .= " <a href='".$ibforums->base_url."act=Arcade&amp;do=play&amp;gameid={$popgline['gid']}'>{$popgline['gtitle']}</a> <a href='".$ibforums->base_url."act=Arcade&amp;do=play&amp;gameid={$popgline['gid']}'><img src='arcade/images/{$popgline[gname]}2.gif' border='0' alt='".$ibforums->lang[times_played].$popgline['gcount']."x' width='20' height='20' /></a>";
}
//Most End Popular Games




the count database, currently is in games_list table >> field gcount
its stored total game played



please participate here to make it