Changeset 9 for trunk/index.php

Timestamp:

Aug 5, 2018, 10:36:27 PM (6 years ago)

Author:

chronos

Message:

• Modified: Improved RSS export.

File:

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

trunk/index.php

@@ -282 +282 @@
 
     $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', '1 ORDER BY `Date` DESC LIMIT 30');
+      '(SELECT MeetSource.URL FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceURL, UNIX_TIMESTAMP(`Date`) AS `UnixTime`', '1 ORDER BY `Date` DESC LIMIT 30');
     while($MeetItem = $DbResult->fetch_assoc())
     {
@@ -288 +288 @@
       if ($MeetItem['Age'] != '') $Title .= ', '.$MeetItem['Age'].' let';
       if ($MeetItem['Weight'] != '') $Title .= ', '.$MeetItem['Height'].' cm';
-      $Description = $MeetItem['Message'];
+      if ($MeetItem['Location'] != '') $Title .= ', '.$MeetItem['Location'];
+      $Description = $MeetItem['Message']."<br/>\n";
       if ($MeetItem['Email'] != '') $Description .= '<br/>Email: '.$MeetItem['Email'];
       if ($MeetItem['Phone'] != '') $Description .= '<br/>Telefon: '.$MeetItem['Phone'];
+      if ($MeetItem['Age'] != '') $Description .= '<br/>Věk: '.$MeetItem['Age'].' let';
+      if ($MeetItem['Height'] != '') $Description .= '<br/>Výška: '.$MeetItem['Height'].' cm';
+      if ($MeetItem['Weight'] != '') $Description .= '<br/>Váha: '.$MeetItem['Weight'].' kg';
       $Description .= '<br/>Škola: <a href="'.$this->Link($MeetItem['SourceURL']).'">'.$MeetItem['SourceName'].'</a>';
       $RSS->Items[] = array(
         'Title' => $Title,
         'Description' => $Description,
-        'Time' => MysqlDateTimeToTime($MeetItem['Date']),
+        'Time' => $MeetItem['UnixTime'],
         'Link' => $this->Link('/seznamka/'),
       );
-      $Output .= '<tr>'.
-        '<td>'.HumanDate(MysqlDateToTime($MeetItem['Date'])).'</td>'.
-        '<td>'.$MeetItem['Name'].'</td>'.
-        '<td>'.$MeetItem['Height'].'</td>'.
-        '<td>'.$MeetItem['Age'].'</td>'.
-        '<td>'.$MeetItem['Weight'].'</td>'.
-        //'<td>'.$MeetItem['Email'].'</td>'.
-        //'<td>'.$MeetItem['Phone'].'</td>'.
-        '<td>'.$Gender[$MeetItem['Gender']].'</td>'.
-        '<td>'.$MeetItem['Message'].'</td>'.
-        '<td></td>';
       $Output .= '</tr>';
     }