Changeset 6

Timestamp:

Sep 12, 2018, 1:55:09 AM (6 years ago)

Author:

chronos

Message:

• Fixed: Wrong two dates subtraction.

File:

• trunk/index.php (modified) (1 diff)

trunk/index.php

@@ -217 +217 @@
     $Output .= $Order['Output'];
     $DbResult = $this->Database->query('SELECT *'.
-      ', (SELECT RunnerStat.Time - B.Time FROM RunnerStat AS B WHERE (B.Time < RunnerStat.Time) AND (B.Runner = RunnerStat.Runner) ORDER BY B.Time DESC LIMIT 1) AS Duration'.
+      ', (SELECT TIME_TO_SEC(TIMEDIFF(RunnerStat.Time, B.Time)) FROM RunnerStat AS B WHERE (B.Time < RunnerStat.Time) AND (B.Runner = RunnerStat.Runner) ORDER BY B.Time DESC LIMIT 1) AS Duration'.
       ', (SELECT RunnerStat.Distance - B.Distance FROM RunnerStat AS B WHERE (B.Time < RunnerStat.Time) AND (B.Runner = RunnerStat.Runner) ORDER BY B.Time DESC LIMIT 1) AS Length'.
       ', NULL AS Speed'.