--- alx-src/branches/alx-web-060/import.php	2011/06/07 13:06:18	2192
+++ alx-src/branches/alx-web-060/import.php	2011/06/07 13:07:35	2193
@@ -1,51 +1,52 @@
 <?
-	// INCLUDE UND TABELLEN-DEFINITIONEN
-	include('include/basesql.php');
-	$tabs = array('cfg_graphic', 'cfg_network', 'cfg_input', 'client_auth', 'cfg_autostart', 'cfg_comments', 'cfg_printers', 'cfg_sessions', 'cfg_modules', 'cfg_other_menuitems', 'cfg_screensaver');
-	$multi= array(    0,		 0,		0,		0,		0,		1, 		1,		1,		1,	       1,		0);
-	$data = array();
 
-	// GGF IMPORTIEREN
-	if($_POST['do_import'])
+// INCLUDE UND TABELLEN-DEFINITIONEN
+include('include/basesql.php');
+$tabs = array('cfg_graphic', 'cfg_network', 'cfg_input', 'client_auth', 'cfg_autostart', 'cfg_comments', 'cfg_printers', 'cfg_sessions', 'cfg_modules', 'cfg_other_menuitems', 'cfg_screensaver');
+$multi= array(    0,		 0,		0,		0,		0,		1, 		1,		1,		1,	       1,		0);
+$data = array();
+
+// GGF IMPORTIEREN
+if($_POST['do_import'])
+{
+	function add_data($data, $t)
 	{
-		function add_data($data, $t)
-		{
-			$data['serial']=$_POST['id'];
-			unset($data['id']);
-			sqladd($t, $data);
-		}
+		$data['serial']=$_POST['id'];
+		unset($data['id']);
+		sqladd($t, $data);
+	}
 
-		foreach($tabs as $k=>$t)
+	foreach($tabs as $k=>$t)
+	{
+		if($_POST['import_'.$t])
 		{
-			if($_POST['import_'.$t])
+			if($multi[$k])
 			{
-				if($multi[$k])
-				{
-					if(!$_POST['keep_'.$t])	mysql_query('DELETE FROM '.$t.' WHERE serial='.$_POST['id']);
-					sqlforeach('SELECT * FROM '.$t.' WHERE serial='.$_POST['id2'], 'add_data', $t);
-				}
-				else
-				{
-					$data = sqlfirst('SELECT * FROM '.$t.' WHERE serial='.$_POST['id2']);
-					$data['serial']=$_POST['id'];
-					mysql_query('UPDATE '.$t.' SET '.updatestr($data).' WHERE serial='.$_POST['id']);
-				}
+				if(!$_POST['keep_'.$t])	mysql_query('DELETE FROM '.$t.' WHERE serial='.$_POST['id']);
+				sqlforeach('SELECT * FROM '.$t.' WHERE serial='.$_POST['id2'], 'add_data', $t);
+			}
+			else
+			{
+				$data = sqlfirst('SELECT * FROM '.$t.' WHERE serial='.$_POST['id2']);
+				$data['serial']=$_POST['id'];
+				mysql_query('UPDATE '.$t.' SET '.updatestr($data).' WHERE serial='.$_POST['id']);
 			}
 		}
 	}
-	else
-	{
-		// ANZEIGEN
-		echo '<form action="import.php" method=post>';
-		echo '<input type=hidden name="do_import" value="1">';
-		echo '<input type=hidden name="id" value="'.$id.'">';
-	}
+}
+else
+{
+	// ANZEIGEN
+	echo '<form action="import.php" method=post>';
+	echo '<input type=hidden name="do_import" value="1">';
+	echo '<input type=hidden name="id" value="'.$id.'">';
+}
 
-	// ANZEIGEN => NON-MULTI TABELLEN
-	echo '<table><tr><td valign=top width=560>';
+// ANZEIGEN => NON-MULTI TABELLEN
+echo '<table><tr><td valign=top width=560>';
 
-	if(!$_POST['do_import'])
-	{
+if(!$_POST['do_import'])
+{
 	echo '<b>TARGET:</b><br>';
 	echo '#'.$id.': '.sqlfirst('SELECT hostname FROM cfg_network WHERE serial='.$id,'hostname');
 	echo '<br><br>';
@@ -73,51 +74,51 @@
 	echo '</table><br><br>';
 
 	echo '<input type=submit value="IMPORT">';
-	}
-	else	echo '<b>IMPORT PROCESSED!<br><br><a href="show.php?id='.$id.'" style="text-decoration:none;color:#000000">[EDIT]</a> <a href="index.php" style="text-decoration:none;color:#000000">[INDEX]</a></b>';
+}
+else echo '<b>IMPORT PROCESSED!<br><br><a href="show.php?id='.$id.'" style="text-decoration:none;color:#000000">[EDIT]</a> <a href="index.php" style="text-decoration:none;color:#000000">[INDEX]</a></b>';
 
-	// ANZEIGEN => NAVI
-	echo '</td><td valign=top>';
+// ANZEIGEN => NAVI
+echo '</td><td valign=top>';
 
-		// STATUS BESTIMMEN (ON/OFF)
-		$conn = sqlfirst('SELECT * FROM state_connected WHERE serial='.$id);
-		$state = 'Off';
-		if(count($conn)>0)
-		{
-			passthru("/usr/sbin/fping -c 1 -i 50 -q ".$conn['ip']." &> /dev/null && exit 0 || exit 1",$retval);
-			if($retval==0)	$state = 'On';
-		}
-
-		echo '<img src="pics/logo2.jpg"><br><br>';
-
-		$davor  = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id-1),'mac')!=null; if($davor) $disdavor=''; else $disdavor = 'disabled=1';
-		$danach = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id+1),'mac')!=null; if($danach) $disdanach=''; else $disdanach = 'disabled=1';
-
-		echo '<input type=button '.$disdavor.' value="<" style="width:30px" onclick="location.href=\'import.php?id='.($id-1).'\'">';
-		echo '<input type=button value="EDIT" style="width:90px;font-weight:bold" onclick="location.href=\'show.php?id='.$id.'\'">';
-		echo '<input type=button '.$disdanach.' value=">" style="width:30px" onclick="location.href=\'import.php?id='.($id+1).'\'">';
+// STATUS BESTIMMEN (ON/OFF)
+$conn = sqlfirst('SELECT * FROM state_connected WHERE serial='.$id);
+$state = 'Off';
+if(count($conn)>0)
+{
+	passthru("/usr/sbin/fping -c 1 -i 50 -q ".$conn['ip']." &> /dev/null && exit 0 || exit 1",$retval);
+	if($retval==0)	$state = 'On';
+}
+
+echo '<img src="pics/logo2.jpg"><br><br>';
+
+$davor  = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id-1),'mac')!=null; if($davor) $disdavor=''; else $disdavor = 'disabled=1';
+$danach = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id+1),'mac')!=null; if($danach) $disdanach=''; else $disdanach = 'disabled=1';
+
+echo '<input type=button '.$disdavor.' value="<" style="width:30px" onclick="location.href=\'import.php?id='.($id-1).'\'">';
+echo '<input type=button value="EDIT" style="width:90px;font-weight:bold" onclick="location.href=\'show.php?id='.$id.'\'">';
+echo '<input type=button '.$disdanach.' value=">" style="width:30px" onclick="location.href=\'import.php?id='.($id+1).'\'">';
+
+echo '<br><input type=button value="INDEX" style="width:150px; font-weight:bold" onclick="location.href=\'index.php\'"><br><br>';
+
+echo '<br><br>';
+echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff"><b>';
+echo '<u>Serial:</u>&nbsp;&nbsp;#'.$id.'<br>';
+echo '<u>Stand:</u>&nbsp;&nbsp;'.date('H:i:s').'<br>';
+echo '<u>Status:</u> <img src="pics/'.strtolower($state).'line.gif" align=top> '.$state.'line<br>';
+if($state=='On') echo '<u>IP:</u> '.$conn['ip'];
+
+echo '</b></div>';
+//echo '<br><br>';
+
+if($state=='On')
+{
+	echo '<input type=button value="REBOOT" style="width:150px" onclick="window.open(\'reboot.php?client='.$id.'&ip='.$conn['ip'].'&op=reboot\', \'ShutdownWin\', \'width=200,height=100\')"><br>';
+	echo '<input type=button value="SHUTDOWN" style="width:150px" onclick="window.open(\'reboot.php?client='.$id.'&ip='.$conn['ip'].'&op=halt\', \'ShutdownWin\', \'width=200,height=100\')"><br>';
+}
+else	echo '<input type=button value="WAKE ON LAN" style="width:150px" onclick="window.open(\'wake_on_lan.php?mac='.$data['client_serials']['mac'].'\', \'WakeWin\', \'width=200,height=100\')"><br>';
 
-		echo '<br><input type=button value="INDEX" style="width:150px; font-weight:bold" onclick="location.href=\'index.php\'"><br><br>';
-
-		echo '<br><br>';
-		echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff"><b>';
-		echo '<u>Serial:</u>&nbsp;&nbsp;#'.$id.'<br>';
-		echo '<u>Stand:</u>&nbsp;&nbsp;'.date('H:i:s').'<br>';
-		echo '<u>Status:</u> <img src="pics/'.strtolower($state).'line.gif" align=top> '.$state.'line<br>';
-		if($state=='On')	echo '<u>IP:</u> '.$conn['ip'];
-
-		echo '</b></div>';
-		//echo '<br><br>';
-
-		if($state=='On')
-		{
-			echo '<input type=button value="REBOOT" style="width:150px" onclick="window.open(\'reboot.php?client='.$id.'&ip='.$conn['ip'].'&op=reboot\', \'ShutdownWin\', \'width=200,height=100\')"><br>';
-			echo '<input type=button value="SHUTDOWN" style="width:150px" onclick="window.open(\'reboot.php?client='.$id.'&ip='.$conn['ip'].'&op=halt\', \'ShutdownWin\', \'width=200,height=100\')"><br>';
-		}
-		else
-			echo '<input type=button value="WAKE ON LAN" style="width:150px" onclick="window.open(\'wake_on_lan.php?mac='.$data['client_serials']['mac'].'\', \'WakeWin\', \'width=200,height=100\')"><br>';
+echo '</td></tr></table>';
 
-	echo '</td></tr></table>';
+if(!$_POST['do_import']) echo '</form>';
 
-	if(!$_POST['do_import']) echo '</form>';
 ?>