Changeset 758

Timestamp:

Oct 26, 2015, 8:29:45 AM (9 years ago)

Author:

chronos

Message:

• Modified: Time ordering in sent notifications.

Location:

trunk

Files:

• Application/Version.php (modified) (1 diff)
• Modules/Notify/Notify.php (modified) (1 diff)

trunk/Application/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 757; // Subversion revision
+$Revision = 758; // Subversion revision
 $DatabaseRevision = 755; // SQL structure revision
-$ReleaseTime = strtotime('2015-10-25');
+$ReleaseTime = strtotime('2015-10-26');

trunk/Modules/Notify/Notify.php

@@ -55 +55 @@
             'LEFT JOIN `NetworkInterface` ON `NetworkInterface`.`Id` = `NetworkInterfaceUpDown`.`Interface` '.
             'LEFT JOIN `NetworkDevice` ON `NetworkDevice`.`Id` = `NetworkInterface`.`Device` '.
-            'WHERE (`Time` > "'.$User['LastTime'].'") AND (`Time` <= "'.TimeToMysqlDateTime($Time).'") AND (`NetworkDevice`.`PermanentOnline`=1)');
+            'WHERE (`Time` > "'.$User['LastTime'].'") AND (`Time` <= "'.TimeToMysqlDateTime($Time).'") '.
+            'AND (`NetworkDevice`.`PermanentOnline`=1) ORDER BY `NetworkInterfaceUpDown`.`Time` DESC');
           if($DbResult3->num_rows > 0) {
             $Output .= 'Category '.$Category['Name'].":\n";