/widgets/gamelist/gamelist.php

<?php

    class GameListWidget extends Widget
    {
        public function GameListWidget()
        {
            $this->addDefaultDependency("gamelist");
        }
        
        public function Render()
        {
            $user = Application::GetCurrentUser();

            $query = "SELECT games.label, U1.gameid, userpass.user FROM usergames as U1, usergames as U2, userpass, games WHERE 
                    U1.gameid = U2.gameid AND games.id = U1.gameid AND U1.userid = $user->ID AND U2.userid = userpass.id ORDER BY U1.gameid, U2.userid";


            $result = mysql_query($query) or die(mysql_error());
            $row = mysql_fetch_array($result);
            $gid = $row['gameid'];
            $label = $row['label'];
            $names = array($row['user']);
            ?>
            <div class="widget-gamelist ui-widget-content ui-widget ui-corner-all">
                <div class="ui-widget-header ui-corner-all">
                    Games
                </div>
                
                <?
            while( $row = mysql_fetch_array($result) )
            {
                if( $row['gameid'] != $gid )
                {
                ?>
                    <div class='game-div ui-corner-all'>
                        <div><?=$label?></div>
                        <div><? foreach( $names as $name ) echo "<div style='display:inline;margin-left:1em;'>".$name."</div>"; ?></div>
                        <a href='canvasgame.php?id=<?=$gid?>'> Game </a>
                    </div> 
                <? 
                    $label = $row['label'];
                    $gid = $row['gameid'];
                    $names = array();
                }
                array_push( $names, $row['user']);
            }
            if( count( $names ) > 0 )
            {
                ?>
                    <div class='game-div ui-corner-all'>
                        <div><?=$label?></div>
                        <div><? foreach( $names as $name ) echo "<div style='display:inline;margin-left:1em;'>".$name."</div>"; ?></div>
                        <a href='canvasgame.php?id=<?=$gid?>'> Game </a>
                    </div>        
                <?
            }
            ?></div><?
        }
    }
?>