<?
// connection to mysql
include 'library/config.php';
include 'library/opendb.php';

$sql_item       = "SELECT username, sum(games_played) as gp "
                . "FROM player_stats, vBulletin.vbb_user "
                . "WHERE vBulletin.vbb_user.userid = player_stats.userid "
                . "GROUP BY username "
                . "HAVING sum(games_played) > 100 "
                . "ORDER BY gp desc ";

$item_info = mysql_query($sql_item) or die(mysql_errno().' : '.mysql_error());

// creates a loop to assign variables with the value from the database
while($data = mysql_fetch_array($item_info))
{
        $username = $data['username'];

        // no clan tags please
        $uname_noclan = ereg_replace('^\[.*\]', "", $username);
        if(!strcmp($uname_noclan, "")){
                $uname_noclan = $username;
        }

        echo "$uname_noclan\t$data[gp]\n";
}
?>