Changeset 409 for trunk/is/topologie-img2.php

Timestamp:

Oct 4, 2012, 9:01:28 AM (12 years ago)

Author:

chronos

Message:

• Upraveno: Přejmenovaná tabulka network_device a hosts_topology.

File:

• trunk/is/topologie-img2.php (modified) (2 diffs)

trunk/is/topologie-img2.php

@@ -9 +9 @@
 
 // === Vytvoř stromy a ulož výsledek do databáze ===============================
-$DbResult = $Database->query("SELECT MAX(pos), MAX(depth) FROM hosts_topology");
+$DbResult = $Database->query("SELECT MAX(Pos), MAX(Depth) FROM NetworkTopology");
 $item = $DbResult->fetch_array();
 $width = $item[0];
@@ -37 +37 @@
 
 //$DbResult = $Database->query("SELECT * FROM hosts, hosts_topology WHERE host = id AND used=1");
-$DbResult = $Database->query("SELECT tpl.*, tpl.host AS id, dev.name AS name, dev.online AS online, dtp.iconname AS iconname, 1 AS showonline
-  FROM hosts_topology tpl LEFT JOIN NetworkDevice dev ON dev.id = tpl.host LEFT JOIN NetworkDeviceType dtp ON dev.type = dtp.id");
+$DbResult = $Database->query("SELECT tpl.*, tpl.Host AS id, dev.Name AS name, dev.Online AS online, dtp.IconName AS iconname, 1 AS showonline
+  FROM NetworkTopology tpl LEFT JOIN NetworkDevice dev ON dev.id = tpl.host LEFT JOIN NetworkDeviceType dtp ON dev.type = dtp.id");
 while($item = $DbResult->fetch_array()) 
 {
   $id = $item['id'];
-  $vleft = $item['pos'];
-  $vtop = $item['depth'];
-  $vfirst = $item['first'];
-  $vlast = $item['last'];
+  $vleft = $item['Pos'];
+  $vtop = $item['Depth'];
+  $vfirst = $item['First'];
+  $vlast = $item['Last'];
   if(($vtop > 0) || ($item['name'] == $TopHostName)) 
   {