Changeset 21 for trunk


Ignore:
Timestamp:
Sep 6, 2019, 9:36:21 PM (5 years ago)
Author:
chronos
Message:
  • Added: Show link to team under runner name.
Location:
trunk
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • trunk/SQL/Upgrade.txt

    r15 r21  
    1414ALTER TABLE `Import`
    1515  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
     16
  • trunk/index.php

    r20 r21  
    375375    $Output .= '<div class="page-title">Family '.$DbRow['Name'].'</div>';
    376376
    377 
    378377    $Where = 'Team='.$TeamId;
    379378
     
    603602    if (!is_numeric($RunnerId)) die('Runner id needs to be numeric');
    604603
    605     $DbResult = $this->Database->query('SELECT * FROM Runner WHERE Id='.$RunnerId);
     604    $DbResult = $this->Database->query('SELECT Runner.Name, Team.Name AS TeamName, Team.Id AS TeamId FROM Runner LEFT JOIN Team ON Team.Id=Runner.Team WHERE Runner.Id='.$RunnerId);
    606605    $DbRow = $DbResult->fetch_assoc();
    607606    $Output .= '<div class="page-title">Runner '.$DbRow['Name'].'</div>';
    608 
     607    if ($DbRow['TeamName'] != '')
     608      $Output .= '<div class="section-title"><a href="'.$this->Link('/team/'.$DbRow['TeamId']).'">'.$DbRow['TeamName'].'</a></div>';
    609609
    610610    $Where = 'RunnerStat.Runner='.$RunnerId;
  • trunk/style.css

    r15 r21  
    7272  font-weight: bold;
    7373  text-align: center;
    74   padding-bottom: 10px;
     74  padding-bottom: 7px;
    7575}
    7676
     
    7979  font-weight: normal;
    8080  text-align: center;
     81  padding-bottom: 7px;
    8182}
    8283
     
    8485{
    8586  text-align: center;
    86   padding-bottom: 10px;
     87  padding-bottom: 7px;
    8788}
Note: See TracChangeset for help on using the changeset viewer.