Changeset 216 for trunk

Timestamp:

May 11, 2009, 10:00:42 PM (16 years ago)

Author:

george

Message:

• Upraveno: Nezobrazovat nepoužitá zařízení v mapě sítě.

Location:

trunk

Files:

• map/index.php (modified) (2 diffs)
• sql/updates/215.sql (added)

trunk/map/index.php

@@ -67 +67 @@
         $Device1 = $DbResult2->fetch_assoc();
         $Device2 = $DbResult3->fetch_assoc();
-        $Output .= 'new GPolyline([new GLatLng('.$Device1['PositionLatitude'].', '.$Device1['PositionLongitude'].'),new GLatLng('.$Device2['PositionLatitude'].', '.$Device2['PositionLongitude'].')], "#4F4FBF", 3, 0.8), ';
+        if(($Device1['Used'] == 1) and ($Device2['Used'] == 1))
+          $Output .= 'new GPolyline([new GLatLng('.$Device1['PositionLatitude'].', '.$Device1['PositionLongitude'].'),new GLatLng('.$Device2['PositionLatitude'].', '.$Device2['PositionLongitude'].')], "#4F4FBF", 3, 0.8), ';
       }
     }
@@ -98 +99 @@
                     NetworkDevices = [';
 
-    $DbResult = $this->Database->query('SELECT * FROM NetworkDevice');
+    $DbResult = $this->Database->query('SELECT * FROM NetworkDevice WHERE Used=1');
     while($Device = $DbResult->fetch_assoc())
     {