Changeset 37 for trunk/index.php

Timestamp:

Sep 10, 2020, 10:25:07 PM (4 years ago)

Author:

chronos

Message:

• Fixed: Update runner team if it was later changed.

File:

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

trunk/index.php

@@ -159 +159 @@
 
     $Runners = array();
-    $DbResult = $this->Database->query('SELECT Runner.Id, Runner.ChipNumber, '.
+    $DbResult = $this->Database->query('SELECT Runner.Id, Runner.ChipNumber, Runner.Team, '.
       '(SELECT RunnerStat.Distance FROM RunnerStat WHERE (RunnerStat.Runner = Runner.Id) ORDER BY RunnerStat.Distance DESC LIMIT 1) AS Distance '.
       'FROM Runner WHERE Year='.$Year);
@@ -203 +203 @@
                 'IsFamily' => 0,
               ));
-              $Teams[$Item['TeamId']] = array('Id' => $TeamId, 'Distance' => -1);
+              $Teams[$Item['TeamId']] = array('Id' => $TeamId, 'Distance' => -1, 'Team' => $Item['TeamId']);
               $NextTeamId++;
             } else
@@ -224 +224 @@
           $Runners[$Item['ChipNumber']] = array('Id' => $RunnerId, 'Distance' => -1);
           $NextRunnerId++;
-        } else
+        } else {
           $RunnerId = $Runners[$Item['ChipNumber']]['Id'];
+
+          // Update runner team if it was changed
+          if ($Item['TeamId'] != $Runners[$Item['ChipNumber']]['Team'] and array_key_exists($Item['TeamId'], $Teams))
+          {
+            $Runners[$Item['ChipNumber']]['Team'] = $Item['TeamId'];
+            $Queries[] = $this->Database->GetUpdate('Runner', 'Id='.$RunnerId, array('Team' => $Item['TeamId']));
+          }
+        }
 
         if ($Runners[$Item['ChipNumber']]['Distance'] < $Item['OverallDistance'])