Changeset 31 for trunk/index.php

Timestamp:

Dec 30, 2018, 7:37:55 PM (5 years ago)

Author:

chronos

Message:

• Modified: Store date of meet items including time. For items without specified time, just use current time (time of import).

File:

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

trunk/index.php

@@ -267 +267 @@
     $Output .= $PageList['Output'];
     $TableColumns = array(
-      array('Name' => 'Date', 'Title' => 'Datum'),
+      array('Name' => 'Time', 'Title' => 'Čas'),
       array('Name' => 'Name', 'Title' => 'Jméno'),
       array('Name' => 'Height', 'Title' => 'Výška'),
@@ -278 +278 @@
       array('Name' => '', 'Title' => 'Detail'),
     );
-    $Order = GetOrderTableHeader($TableColumns, 'Date', 1);
+    $Order = GetOrderTableHeader($TableColumns, 'Time', 1);
     $Output .= '<table class="WideTable">';
     $Output .= $Order['Output'];
@@ -286 +286 @@
     {
       $Output .= '<tr>'.
-        '<td>'.HumanDate(MysqlDateToTime($MeetItem['Date'])).'</td>'.
+        '<td>'.HumanDate(MysqlDateToTime($MeetItem['Time'])).'</td>'.
         '<td>'.$MeetItem['Name'].'</td>'.
         '<td>'.$MeetItem['Height'].'</td>'.
@@ -332 +332 @@
         else $Link = '';
       $Output .= '<table class="ItemTable">'.
-        '<tr><th>Datum</th><td>'.HumanDate(MysqlDateToTime($MeetItem['Date'])).'</td></tr>'.
+        '<tr><th>Čas</th><td>'.HumanDate(MysqlDateToTime($MeetItem['Time'])).'</td></tr>'.
         '<tr><th>Pohlaví</th><td>'.$Gender[$MeetItem['Gender']].'</td></tr>'.
         '<tr><th>Jméno</th><td>'.$MeetItem['Name'].'</td></tr>'.
@@ -360 +360 @@
 
     $DbResult = $this->Database->select('MeetItem', '*, (SELECT MeetSource.Name FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceName, '.
-      '(SELECT MeetSource.URL FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceURL, UNIX_TIMESTAMP(`Date`) AS `UnixTime`', '1 ORDER BY `Date` DESC LIMIT 30');
+      '(SELECT MeetSource.URL FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceURL, UNIX_TIMESTAMP(`Time`) AS `UnixTime`', '1 ORDER BY `Time` DESC LIMIT 30');
     while($MeetItem = $DbResult->fetch_assoc())
     {