Changeset 42 for trunk/index.php

Timestamp:

Sep 14, 2020, 1:41:50 PM (4 years ago)

Author:

chronos

Message:

• Fixed: Division by zero in speed calculation.
• Fixed: Wrong year loaded for runner without team.

File:

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

trunk/index.php

@@ -572 +572 @@
         else $Output .= '<td>&nbsp;</td>';
       $Output .= '<td>'.$Item['Length'].'</td>';
-      $Speed = $Item['Length'] / $Item['Duration'] * 3600;
+
       if (($Item['Duration'] > 0) and ($Item['Duration'] < $Item['Length'] * 3600 / $this->MinRunnerSpeed))
+      {
+        $Speed = $Item['Length'] / $Item['Duration'] * 3600;
         $Output .= '<td>'.$PrefixMultiplier->Add($Speed, '', 4, 'Decimal').'</td>';
-        else $Output .= '<td>&nbsp;</td>';
+      } else $Output .= '<td>&nbsp;</td>';
       $Output .= '</tr>';
     }
@@ -726 +728 @@
     if (!is_numeric($RunnerId)) die(T('Runner id needs to be numeric'));
 
-    $DbResult = $this->Database->query('SELECT Runner.Name, Team.Name AS TeamName, Team.Id AS TeamId, Team.Year FROM Runner LEFT JOIN Team ON Team.Id=Runner.Team WHERE Runner.Id='.$RunnerId);
+    $DbResult = $this->Database->query('SELECT Runner.Name, Team.Name AS TeamName, Team.Id AS TeamId, Runner.Year FROM Runner LEFT JOIN Team ON Team.Id=Runner.Team WHERE Runner.Id='.$RunnerId);
     $DbRow = $DbResult->fetch_assoc();
     $this->Title = T('Runner').' '.$DbRow['Name'].' - '.$this->Title;