Changeset 18 for trunk/index.php

Timestamp:

Sep 6, 2019, 9:00:35 AM (5 years ago)

Author:

chronos

Message:

• Fixed: Update name of unnamed teams which were added during runner insertion.

File:

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

trunk/index.php

@@ -93 +93 @@
   function QueryRunners($Category, $Page = 0, $TeamId = null, $Query = null, $StartNumber = null, $Count = null)
   {
-      $URL = 'http://leaderboard.teribear.cz/Home/GetRunners?category='.$Category;
+      $URL = 'https://registrace.teribear.cz/Leaderboard/Home/GetRunners?category='.$Category;
       if ($Page != 0) $URL .= '&page='.$Page;
       if ($TeamId != null) $URL .= '&teamId='.$TeamId;
@@ -159 +159 @@
 
     $Teams = array();
-    $DbResult = $this->Database->query('SELECT Team.Id, Team.WebId, '.
+    $DbResult = $this->Database->query('SELECT Team.Id, Team.WebId, Team.Name, '.
       '(SELECT TeamStat.Distance FROM TeamStat WHERE (TeamStat.Team = Team.Id) ORDER BY TeamStat.Distance DESC LIMIT 1) AS Distance '.
       'FROM Team WHERE Year='.$Year);
@@ -240 +240 @@
           $TeamId = $Teams[$Item['GroupId']]['Id'];
 
+        // Update missing team names
+        if ($Teams['Name'] == "")
+        {
+          $Queries[] = $this->Database->GetUpdate('Team', 'Id='.$Team['Id'], array('Name' => $Item['Name']));
+          $Teams['Name'] = $Item['Name'];
+          echo($Team['Name'].' ');
+        }
+
         if ($Teams[$Item['GroupId']]['Distance'] < $Item['OverallDistance'])
         $Queries[] = $this->Database->GetInsert('TeamStat', array(