Changeset 21 for trunk

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:

• SQL/Upgrade.txt (modified) (1 diff)
• index.php (modified) (2 diffs)
• style.css (modified) (3 diffs)

trunk/SQL/Upgrade.txt

@@ -14 +14 @@
 ALTER TABLE `Import`
   MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
+

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;

trunk/style.css

@@ -72 +72 @@
   font-weight: bold;
   text-align: center;
-  padding-bottom: 10px;
+  padding-bottom: 7px;
 }
 
@@ -79 +79 @@
   font-weight: normal;
   text-align: center;
+  padding-bottom: 7px;
 }
 
@@ -84 +85 @@
 {
   text-align: center;
-  padding-bottom: 10px;
+  padding-bottom: 7px;
 }