Assembla home | Assembla project page
 

Changeset 180

Show
Ignore:
Timestamp:
09/10/07 07:44:31 (3 years ago)
Author:
moensch
Message:

Display game in detail view for tournament

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/com_mls_tournaments/mls_tournaments.html.php

    r178 r180  
    130130                                <td valign="top" class="sectiontableentry2"><?php echo $row->categoryname; ?></td> 
    131131                        </tr> 
     132                        <?php if($row->gamename) { ?> 
     133                                <tr> 
     134                                        <td class="sectiontableheader" valign="top"><?php echo $l->m("game"); ?>:</td> 
     135                                        <td valign="top" class="sectiontableentry2"><?php echo $row->gamename; ?></td> 
     136                                </tr> 
     137                        <?php } ?> 
    132138                        <?php if($row->league) { ?> 
    133139                        <tr>  

  • trunk/com_mls_tournaments/mls_tournaments.php

    r178 r180  
    187187                                        ."\n IF(t.type='C','".$l->m("clans")."','".$l->m("singleplayer")."') AS `typename`," 
    188188                                        ."\n IF(t.mode='S','".$l->m("single_elimination")."','".$l->m("double_elimination")."') AS `modename`," 
    189                                         ."\n l.description AS `leaguedescription`,l.url AS `leagueurl`" 
     189                                        ."\n l.description AS `leaguedescription`,l.url AS `leagueurl`," 
     190                                        ."\n g.name AS `gamename`" 
    190191                                        ."\n FROM `#__mls_tournaments` AS `t`" 
    191192                                        ."\n LEFT JOIN `#__mls_tournaments_categories` AS `c` ON c.id=t.categoryid" 
    …… 
    193194                                        ."\n LEFT JOIN `#__mls_tournaments_participants` AS `p` ON p.tournamentid=t.id" 
    194195                                        ."\n LEFT JOIN `#__mls_tournaments_leagues` AS `l` ON l.name=t.league" 
     196                                        ."\n LEFT JOIN `#__mls_tournaments_games` AS `g` ON g.id=t.gameid" 
    195197                                        ."\n WHERE t.id='".$tournamentid."' AND t.published='1'" 
    196198                                        ."\n GROUP BY t.id"