Changeset 21 for trunk/index.php

Timestamp:

Sep 6, 2019, 9:36:21 PM (5 years ago)

Author:

chronos

Message:

• Added: Show link to team under runner name.

File:

• trunk/index.php (modified) (2 diffs)

trunk/index.php

@@ -375 +375 @@
     $Output .= '<div class="page-title">Family '.$DbRow['Name'].'</div>';
 
-
     $Where = 'Team='.$TeamId;
 
@@ -603 +602 @@
     if (!is_numeric($RunnerId)) die('Runner id needs to be numeric');
 
-    $DbResult = $this->Database->query('SELECT * FROM Runner WHERE Id='.$RunnerId);
+    $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);
     $DbRow = $DbResult->fetch_assoc();
     $Output .= '<div class="page-title">Runner '.$DbRow['Name'].'</div>';
-
+    if ($DbRow['TeamName'] != '')
+      $Output .= '<div class="section-title"><a href="'.$this->Link('/team/'.$DbRow['TeamId']).'">'.$DbRow['TeamName'].'</a></div>';
 
     $Where = 'RunnerStat.Runner='.$RunnerId;