Changeset 679 for trunk/Common

Timestamp:

Jul 26, 2014, 9:25:03 PM (10 years ago)

Author:

chronos

Message:

• Přidáno: U zařízení je možno nastavit ozančení použitého produktu.
• Upraveno: Umožněno přidávat rozhraní bez IP adresy. Potřeba pro registraci wifi rozhraní bez ip zapoojených v mostu pro měření signálu.

Location:

trunk/Common

Files:

• Global.php (modified) (1 diff)
• Setup/Updates.php (modified) (2 diffs)

trunk/Common/Global.php

@@ -365 +365 @@
   global $Database;
 
-  $DbResult = $Database->query('SELECT Id FROM Member WHERE (SELECT Member FROM NetworkDevice WHERE (SELECT Device FROM NetworkInterface WHERE LocalIP = "'.$IP.'") = NetworkDevice.Id) = Member.Id');
+  $DbResult = $Database->query('SELECT Id FROM Member WHERE '.
+  '(SELECT Member FROM NetworkDevice WHERE (SELECT Device FROM NetworkInterface '.
+  'WHERE LocalIP = "'.$IP.'") = NetworkDevice.Id) = Member.Id');
   if($DbResult->num_rows > 0)
   {

trunk/Common/Setup/Updates.php

@@ -879 +879 @@
 }
 
+function UpdateTo679($Manager)
+{
+  $Manager->Execute('ALTER TABLE `NetworkDevice` ADD `Product` INT NOT NULL AFTER `Id` ,
+ADD INDEX ( `Product` ) ;');
+}
+
 class Updates
 {
@@ -926 +932 @@
       674 => array('Revision' => 676, 'Function' => 'UpdateTo676'),
       676 => array('Revision' => 678, 'Function' => 'UpdateTo678'),
+      678 => array('Revision' => 679, 'Function' => 'UpdateTo679'),
     ));
   }