Changeset 6 for trunk


Ignore:
Timestamp:
Sep 12, 2018, 1:55:09 AM (6 years ago)
Author:
chronos
Message:
  • Fixed: Wrong two dates subtraction.
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/index.php

    r5 r6  
    217217    $Output .= $Order['Output'];
    218218    $DbResult = $this->Database->query('SELECT *'.
    219       ', (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'.
     219      ', (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'.
    220220      ', (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'.
    221221      ', NULL AS Speed'.
Note: See TracChangeset for help on using the changeset viewer.