Changeset 659 for trunk/Modules/NetworkConfigRouterOS/NetworkConfigRouterOS.php

Timestamp:

May 29, 2014, 11:59:39 PM (11 years ago)

Author:

chronos

Message:

• Opraveno: Zobrazení hodnoty času trvání změn stavu rozhraní.
• Upraveno: Vzdálenou IP klienta nezjišťovat z proxy adres. Tyto adresy se dají falšovat a tedy nejsou spolehlivé.

File:

• trunk/Modules/NetworkConfigRouterOS/NetworkConfigRouterOS.php (modified) (1 diff)

trunk/Modules/NetworkConfigRouterOS/NetworkConfigRouterOS.php

@@ -34 +34 @@
         'Interface' => array('Type' => 'TNetworkInterface', 'Caption' => 'Rozhraní', 'Default' => '', 'ReadOnly' => true),
         'State' => array('Type' => 'Boolean', 'Caption' => 'Stav', 'Default' => '', 'ReadOnly' => true),
-        'Duration' => array('Type' => 'Time', 'Caption' => 'Trvání', 'Default' => '', 'ReadOnly' => true,
-          'SQL' => 'TIMEDIFF(`Time`,'.
+        'Duration' => array('Type' => 'TimeDiff', 'Caption' => 'Trvání', 'Default' => '', 'ReadOnly' => true,
+          'SQL' => 'TIMESTAMPDIFF(SECOND, `Time`, '.
             '(SELECT `Time` FROM `NetworkInterfaceUpDown` AS `TA` WHERE (`TA`.`Time` > `TX`.`Time`) '.
                         'AND (`TA`.`Interface`=`TX`.`Interface`) ORDER BY `TA`.`Time` LIMIT 1))'),