branches/alx-web-070/show.php

<?
// INCLUDE UND TABELLEN-DEFINITIONEN
include('include/basesql.php');
include('include/common-functions.php');

// INCLUDE CURRENT-PROBLEMS
include('include/current-problems.php');

$tabs = array('cfg_graphic', 'cfg_network', 'cfg_input', 'client_auth', 'cfg_autostart', 'client_serials', 'cfg_comments', 'cfg_printers', 'cfg_sessions', 'cfg_modules', 'cfg_other_menuitems', 'cfg_screensaver', 'client_version', 'cfg_plugins');
$multi= array(	0,		 0,		0,		0,		0,		0,		1,		1,		1,		1,		1,		0,	0,	1);
$data = array();


// get alx version info for 
$alxinfo = sqlfirst('SELECT * FROM client_version WHERE serial='.$id);
$alxos = $alxinfo[os];
$alxutils = $alxinfo[utils];

// get gfxdriver
$gfxinfo = sqlfirst('SELECT * FROM cfg_graphic WHERE serial='.$id);

if($kill==1)
{
	foreach($tabs as $t)	mysql_query('UPDATE '.$t.' SET serial=-serial WHERE serial='.$id);

	echo '<body onload="window.setTimeout(\'window.close()\', 1750)">';
	echo '<table width=100% height=100% style="border:solid black 1px; background-color:#d5e5ff"><tr><td valign=middle align=center>';

	if($id<0)	echo 'ACTIVATED #'.abs($id);
	else		echo 'DEACTIVATED #'.$id;

	echo '</td></tr></table>';
	return true;
}

// FELD-DEFINITIONEN  (ARRAY=>DROPDOWN / HIDDEN / IGNORE / 1 / BOLD / PASSWORD / SHOW / SHOWTIME / MONITORID)
$drop = array();
$drop['cfg_graphic_module'] = array('vesa', 'ati', 'cirrus', 'i710', 'intel', 'nv', 'nouveau', 'mach64', 'mga', 'unichrome', 'radeon', 's3', 's3virge', 'savage', 'sis', 'trident', 'tseng', 'vmware');
if($gfxinfo[module] == 'intel')
{
	$drop['cfg_graphic_hdmi'] = array('disable', 'enable');
}
else
{
	$drop['cfg_graphic_hdmi'] = 'ignore';
}
$drop['resolution'] = array('640x480', '800x600', '1024x768', '1280x960', '1280x1024', '1360x768', '1366x768', '1400x1050', '1440x900', '1600x1200', '1680x1050', '1280x720', '1920x1080');
$drop['depth'] = array('24', '16', '8');
$drop['mouse'] = array('Auto', 'IMPS/2', 'PS/2');
$drop['keyboard'] = array('PC105');
$drop['cfg_network_module'] = array('3c509', '3c59x', '8139cp', '8139too', '8390', 'amd8111e', 'atl1c', 'atl1e', 'atl1', 'atl2', 'b44', 'bnx2', 'cnic', 'e100', 'e1000', 'e1000e', 'forcedeth', 'igb', 'ipg', 'jme', 'natsemi', 'ne2k-pci', 'ns83820', 'pcnet32', 'qla3xxx', 'r8169', 'sis190', 'sis900', 'skge', 'sky2', 'tg3', 'typhoon', 'via-rhine', 'via-velocity', 'adm8211', 'airo', 'at76c50x-usb', 'ar9170usb', 'ath5k', 'ath9k', 'atmel', 'atmel_pci', 'b43', 'b43legacy', 'hostap_pci', 'hostap_plx', 'ipw2100', 'ipw2200', 'iwl3945', 'iwl4965', 'iwldvm', 'iwlwifi', 'libertas_tf', 'libertas_tf_usb', 'mwl8k', 'orinoco', 'orinoco_nortel', 'orinoco_plx', 'orinoco_tmd', 'orinoco_usb', 'p54pci', 'p54usb', 'prism54', 'rndis_wlan', 'rt2400pci', 'rt2500pci', 'rt2500usb', 'rt2800pci', 'rt2800usb', 'rt61pci', 'rt73usb', 'rtl8180', 'rtl8187', 'usb8xxx', 'wl1251', 'wl1271', 'zd1201', 'zd1211rw');
$drop['networking'] = array('dhcp', 'static');
$drop['port'] = array('lpt1', 'usb1', 'usb2', 'com1', 'com2');
for ($i=0; $i<999; $i++) { $drop['cfg_printers_'.$i.'_ip'] = 'ignore'; }
$drop['share'] = 'ignore';
$drop['location'] = sqlarr('SELECT location FROM client_locations', '', 'location');
$drop['id'] = 'hidden';
$drop['flg_modified'] = '1';
$drop['serial'] = 'ignore';
$drop['monitorid'] = 'ignore';
$drop['refresh_rate'] = array('','60','75','85','100');
$drop['hostname'] = 'bold';
$drop['session'] = 'bold';
$drop['cfg_autostart_session'] = sqlarr('SELECT filename FROM cfg_sessions where serial='.$id, '', 'filename');
array_unshift($drop['cfg_autostart_session'], "");
$drop['mtime'] = 'showtime';
$drop['mac'] = 'show';
$drop['client_serials_serial'] = 'show';
$drop['password'] = 'password';
$drop['shell'] = 'password';
$drop['vnc'] = 'password';
$drop['samba'] = 'password';
$drop['station'] = 'password';
$drop['txt'] = 'txt';
$drop['screensaver'] = array('','blank', 'random', 'ant', 'ant3d', 'apollonian', 'ball', 'bat', 'blot', 'bomb', 'bouboule',
		'bounce', 'braid', 'bubble', 'bug', 'clock', 'coral', 'crystal', 'daisy', 'dclock', 'decay', 'deco',
		'demon', 'dilemma', 'discrete', 'dragon', 'drift', 'euler2d', 'eyes', 'fadeplot', 'fiberlamp', 'flag',
		'flame', 'flow', 'forest', 'galaxy', 'goop', 'grav', 'helix', 'hop', 'hyper', 'ico', 'ifs', 'image',
		'juggle', 'julia', 'kaleid', 'kumppa', 'laser', 'life', 'life1d', 'life3d', 'lightning', 'lisa', 'lissie',
		'loop', 'lyapunov', 'mandelbrot', 'marquee', 'matrix', 'maze', 'mountain', 'munch', 'nose', 'pacman',
		'penrose', 'petal', 'petri', 'polyominoes', 'puzzle',  'pyro', 'qix', 'roll',  'rotor', 'scooter', 'shape',
		'sierpinski', 'slip', 'solitare', 'space', 'sphere', 'spiral', 'spline', 'star', 'starfish', 'strange',
		'swarm', 'swirl', 't3d', 'tetris', 'thornbird', 'tik_tak', 'toneclock', 'triangle', 'tube', 'turtle',
		'vines', 'voters', 'wator', 'wire', 'world', 'worm', 'xcl', 'xjack');
$drop['iface'] = array('eth0', 'wlan0');
$drop['client_version_os'] = 'show';
$drop['client_version_utils'] = 'show';

// ACHTUNG!!! wlan_-Felder heißen eigentlich wireless_
$drop['wireless_mode'] = array('', 'managed', 'ad-hoc', 'master', 'repeater', 'secondary', 'monitor', 'auto');
$drop['wireless_auth_mode'] = array('', 'wep', 'wpa', 'wpa2', 'off');
$drop['wireless_key_length'] = array('', '64', '128', '256');
$drop['wireless_channel'] = array('', '1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14');
$drop['wireless_frequency'] = array('', '2.412G', '2.417G', '2.422G', '2.427G', '2.432G', '2.437G', '2.442G',
		'2.447G', '2.452G', '2.457G', '2.462G', '2.467G', '2.472G', '2.484G');
$drop['wireless_key'] = 'password';
$drop['wireless_key_ascii'] = 'password';

// plugin support
for ($i=0; $i<999; $i++) { $drop['cfg_plugins_'.$i.'_plugin'] = 'pluginconfig'; }
for ($i=0; $i<999; $i++)
{
	$drop['cfg_plugins_'.$i.'_plugin_array'] = sqlarr('SELECT plugin FROM avail_plugins', '', 'plugin');
	array_unshift($drop['cfg_plugins_'.$i.'_plugin_array'], "");
}

// get current citrix sessions
// split all citrix server into an array to get the first server from list
$citrix_query_browser = split(";", $citrix_browseradrs);
exec($wwwroot.'/pnabrowse-wrapper -A '.$citrix_query_browser[0], $returned_citrix_sessions, $retval);
if ($retval == 0)
{
	$citrix_public_applications = str_replace("'", "", $returned_citrix_sessions);
	// add an empty value add the first position of the array as session-default
	array_unshift($citrix_public_applications, "");
	for ($i=0; $i<999; $i++) { $drop['cfg_sessions_'.$i.'_session'] = $citrix_public_applications; }
}

// GGF. NEUEN DATENSATZ EINFÜGEN
if(isset($_POST['do_add']))
{
	list($bla,$what) = explode(' ',$_POST['do_add']);
	if($what=='COMMENT')		sqladd('cfg_comments', array('serial'=>$id));
	else if($what=='PRINTER')	sqladd('cfg_printers', array('serial'=>$id));
	else if($what=='MODULE')	sqladd('cfg_modules', array('serial'=>$id));
	else if($what=='SESSION')	sqladd('cfg_sessions', array('domain'=>$citrix_domain_name, 'browseradrs'=>$citrix_browseradrs, 'serial'=>$id));
	else if($what=='MENUITEM')	sqladd('cfg_other_menuitems', array('serial'=>$id));
	else if($what=='PLUGIN')	sqladd('cfg_plugins', array('serial'=>$id));
}


// GGF. SPEICHERN
if($_POST['do_upl'])
{
	function postarr($prefix)
	{
		$prefix.='_';
		$prelen = strlen($prefix);

		$arr = array();
		foreach($_POST as $k=>$v)
			if((substr($k,0,$prelen)==$prefix) && ($v!='KEEPPASS'))
				$arr[substr($k,$prelen)] = stripslashes($v);

		return $arr;
	}

	foreach($tabs as $k=>$t)
	{
		if(!$multi[$k])	mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t)).' WHERE serial='.$id);
		else
		{
			$i=0;
			while(isset($_POST[$t.'_'.$i.'_id']))
			{
				if($_POST[$t.'_'.$i.'_delete'])
					mysql_query('DELETE FROM '.$t.' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);
				else
					mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t.'_'.$i)).' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);
				$i++;
			}
		}
	}

	// reload site
	header("location: show.php?id=".$id);
}

// EINLESEN DER DATEN AUS SQL-TABELLEN
foreach($tabs as $k=>$t)
{
	if($multi[$k])	$data[$t] = sqlarr('SELECT * FROM '.$t.' WHERE serial='.$id);
	else		$data[$t] = sqlfirst('SELECT * FROM '.$t.' WHERE serial='.$id);
}

// ANZEIGEN - KLAPPFUNKTIONEN
$absnames = array();

function openabs($heading, $helpfile='')
{
	global $absnames;
	$absnames[] = $heading;
	
	// <AufZuLink> <Bild/> <Heading/> </AufZuLink><BR/> <Absatz>
	
	if( $_SESSION['openclose'][$heading] )
	{
		echo '<a href="JavaScript:openclose(\''.$heading.'\',1);"><img border="0" src="pics/minus.gif" title="CLOSE" id="sch_bild_'.$heading.'"> <b>['.$heading.']</b></a>';
		if($helpfile!='')	echo ' <a href="JavaScript:showhelp(\''.$helpfile.'\')" title="HELP">[?]</a>';
		echo '<br><div id="sch_absatz_'.$heading.'" style="top:0px; visibility:visible">';			
	}
	else
	{
		echo '<a href="JavaScript:openclose(\''.$heading.'\',1);"><img border="0" src="pics/plus.gif" title="OPEN" id="sch_bild_'.$heading.'"> <b>['.$heading.']</b></a>';
		if($helpfile!='')	echo ' <a href="JavaScript:showhelp(\''.$helpfile.'\')" title="HELP">[?]</a>';
		echo '<br><div id="sch_absatz_'.$heading.'" style="position:absolute; top:0px; visibility:hidden">';
	}
}

function closeabs()
{
	// </Absatz> <BR/>
	
	echo '</div><br>';
}


// ANZEIGEN	

function parsearr($name, $arr, $del=false, $wireless=false)
{
	global $drop;
	global $id;
	global $alxos;

	$parts = explode('_',$name); $helpfile='help.php?page='.$parts[1];
	openabs($name, $helpfile);
	echo '<table class="keytab">';

	foreach($arr as $k=>$v)
	{
		if( (substr($k,0,9)=='wireless_') xor $wireless )	Continue;
		
		$d = $drop[$name.'_'.$k]; if($d==null) $d = $drop[$k];
		$k = str_replace('wireless_', '', $k);
		$k2 = $k;

		# tell something about vesa
		if ($v == 'vesa') echo '<br><font color="#FF0000">Warning: "vesa" graphic module doesn\'t support any resolutions higher than 1024x786x16@60hz!</font><br>';

		if(is_array($d))
		{
			echo '<tr><td class="key">'.$k2.'</td><td>= <select style="width:144px" name="'.$name.'_'.$k.'">';
			foreach($d as $di) if($v==$di) echo '<option selected>'.$di; else echo '<option>'.$di;
			echo '</select></td></tr>';
		}
		else if($d=='hidden') 			echo '<tr><td colspan=2><input type=hidden name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';
		else if($d=='1')			echo '<tr><td colspan=2><input type=hidden name="'.$name.'_'.$k.'" value="1"></td></tr>';
		else if($d=='monitorid')		echo '<tr><td class="key">'.$k2.'</td><td>= <input type=button style="width:24px" onclick="window.open(\'monitor.php?id='.$id.'\', \'MonitorWin\', \'width=350,height=200\')" value="..."></td>';
		else if($d=='pluginconfig')
		{
			$dplugin = $drop[$name.'_'.$k.'_array']; if($dplugin==null) $dplugin = $drop[$k];
			if(is_array($dplugin))
			{
				echo '<tr><td class="key">'.$k2.'</td><td>= <select style="width:144px" name="'.$name.'_'.$k.'">';
				foreach($dplugin as $di) if($v==$di) echo '<option selected>'.$di; else echo '<option>'.$di;
				echo '</select></td></tr>';
			}
			// $v contains the pluginname, get the configure flag
			$pflag = sqlfirst('SELECT configflag FROM avail_plugins WHERE plugin="'.$v.'"');
			if ($pflag[configflag]==1) echo '<tr><td class="key">configure</td><td>= <input type=button style="width:24px" onclick="window.open(\'plugin.php?id='.$id.'&plugin='.$v.'\', \'PluginWin\', \'width=500,height=400\')" value="..."></td>';
		}
		else if($d=='bold')			echo '<tr><td class="key">'.$k2.'</td><td>= <input style="width:144px;font-weight:bold" name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';
		else if($d=='filename')			echo '<tr><td class="key">filename</td><td>= <input style="width:144px;font-weight:bold" name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';
		else if($d=='show')			echo '<tr><td class="key">'.$k2.'</td><td>= <b>'.$v.'</b></td></tr>';
		else if($d=='showtime')			echo '<tr><td class="key">'.$k2.'</td><td>= <b>'.date('d.m.y - H:i:s', $v).'</b></td></tr>';
		else if($d=='password' && $v=='')	echo '<tr><td class="key">'.$k2.'</td><td>= <input type=password style="width:144px" name="'.$name.'_'.$k.'" value=""></td></tr>';
		else if($d=='password')			echo '<tr><td class="key">'.$k2.'</td><td>= <input type=password style="width:144px" name="'.$name.'_'.$k.'" value="KEEPPASS"></td></tr>';
		else if($d=='txt') 			echo '<tr><td colspan=2><textarea style="width:240px; background-color:#d5e5ff" rows=6 name="'.$name.'_'.$k.'">'.$v.'</textarea></td></tr>';
		else if($d!='ignore')			echo '<tr><td class="key">'.$k2.'</td><td>= <input style="width:144px" name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';
	}

	if($del)	echo '<tr><td class="key">delete</td><td>=<input type=checkbox name="'.$name.'_delete" value="1"></td></tr>';
	echo '</table>';
	closeabs();

	if($name=='cfg_network' && !$wireless)	parsearr($name.'_wireless', $arr, $del, true);
}

function parsearrs($name, $arr)
{
	foreach($arr as $k=>$a)
		parsearr($name.'_'.$k, $a, true);
}

?><head>
<title>ALX Config</title>
<style>
	body,table { font-family:Tahoma; font-size:10pt }
	a { color:#000000; text-decoration:none; }
	.key { width:85px }
	.keytab, input, textarea, select, option { font-size:8pt; font-family:Tahoma }
	.but { font-size:10pt; font-family:Tahoma; height:23px }
</style>
<script type="text/javascript" src="js/jquery-1.2.6.min.js"></script>
<script language="JavaScript" src="openclose_ajax.js"></script>
<script language="JavaScript">

	// opens an url and shows retval in a javascript-alert on current site
	function urlopen(url,typ) {
		var $url = url.split("?");
		$.ajax({type:""+typ+"",url:$url[0],data:$url[1],cache:false,success:function(data){ alert(data); }});
	}
	function plugin(name,id) { window.open('plugin.php?plugin='+name+'&id='+id, '', 'width=350,height=180'); }

/* ignore this atm, not always working, sometime open does not work
	function openclose(nummer, act)
	{			
		var bild = document.images['sch_bild_'+nummer];
		var absatz = document.all['sch_absatz_'+nummer].style;
		var senden = false;

		$("#sch_absatz_"+nummer).toggle(0, function(){
			if($(this).css("display")=="none"){$("#sch_bild_"+nummer).attr({title:'OPEN',src:'pics/plus.gif'});}else{$("#sch_bild_"+nummer).attr({title:'CLOSE',src:'pics/minus.gif'});}
		});
		if(act<=1){ $("#sch_bild_"+nummer).attr({title:'CLOSE',src:'pics/minus.gif'}); }else{ $("#sch_bild_"+nummer).attr({title:'OPEN',src:'pics/plus.gif'}); };
	}
*/
	function openclose(nummer, act)
	{			
		var bild = document.images['sch_bild_'+nummer];
		var absatz = document.all['sch_absatz_'+nummer].style;
		var senden = false;
		
		if(bild.title == 'OPEN')
		{
			if(act<=1)
			{
				absatz.visibility = 'visible';
				absatz.position = '';
				bild.title = 'CLOSE';
				bild.src = 'pics/minus.gif';
				senden = true;
				act = 0;
			}
		}
		else
		{
			if(act>=1)
			{
				absatz.visibility = 'hidden';
				absatz.position = 'absolute';
				bild.title = 'OPEN';
				bild.src = 'pics/plus.gif';
				senden = true;
				act = 2;
			}
		}
		
		if(senden)	sendopenclose(nummer,act);
	}

	function showhelp(name)
	{ window.open(name, 'HelpWin', 'width=620,height=500,scrollbars=yes'); }

</script>
</head>

<body><?

echo '<form action="show.php" method="post" onreset="return confirm(\'UNDO CHANGES?\')">';
echo '<input type=hidden name="do_upl" value="1">';
echo '<input type=hidden name="id" value="'.$id.'">';

// ANZEIGEN => NON-MULTI TABELLEN
echo '<table><tr><td valign=top width="300">';

	echo '<b style="font-size:6pt">';
	echo '<a href="JavaScript:opencloseall(0);" title="OPEN ALL"><img src="pics/plus.gif" border="0"> OPEN...</a> ';
	echo '<a href="JavaScript:opencloseall(2);" title="CLOSE ALL"><img src="pics/minus.gif" border="0"> CLOSE...</a> ALL';
	echo '</b><br><br>';

	foreach($tabs as $k=>$t)	if(!$multi[$k])		parsearr($t, $data[$t]);

// ANZEIGEN => MULTI TABELLEN
echo '</td><td valign=top width="300">';

	foreach($tabs as $k=>$t)	if($multi[$k])		parsearrs($t, $data[$t]);

	echo '<script language="JavaScript">';
	echo 'function opencloseall(act) { ';

	foreach($absnames as $absname)
		echo 'openclose("'.$absname.'", act); ';

	echo '}</script>';

// 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)
	{
		if($retval==0)	$state = 'On';
	}

	echo '<img src="pics/logo2.jpg"><br><br>';

	echo '<input class="but" type=submit value="SAVE" style="width:150px"><br><br>';

	echo '<input class="but" type=submit name="do_add" value="SAVE+ADD COMMENT" style="width:150px"><br>';
	echo '<input class="but" type=submit name="do_add" value="SAVE+ADD PRINTER" style="width:150px"><br>';
	echo '<input class="but" type=submit name="do_add" value="SAVE+ADD SESSION" style="width:150px"><br>';
	echo '<input class="but" type=submit name="do_add" value="SAVE+ADD MODULE" style="width:150px"><br>';
	echo '<input class="but" type=submit name="do_add" value="SAVE+ADD MENUITEM" style="width:150px"><br>';
	if($alxos >= '0.6.0')
	{
		echo '<input class="but" type=submit name="do_add" value="INSTALL PLUGIN" style="width:150px"><br>';
	}
	echo '<br>';

	if($id>0) $KILLCAP='DEACTIVATE'; else $KILLCAP='ACTIVATE';
	echo '<input class="but" type=button value="'.$KILLCAP.'" style="width:150px" onclick="if(confirm(\''.$KILLCAP.' CLIENT #'.abs($id).' ?\')) { window.open(\'show.php?id='.$id.'&kill=1\', \'DeactWin\', \'width=200,height=100\'); location.href=\'index.php\'; }"><br>';
	echo '<input class="but" type=button value="IMPORT FROM..." style="width:150px" onclick="location.href=\'import.php?id='.$id.'\'"><br>';
	echo '<input class="but" type=reset value="UNDO CHANGES" style="width:150px"><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 class="but" type=button '.$disdavor.' value="<" style="width:30px" onclick="location.href=\'show.php?id='.($id-1).'\'">';
	echo '<input class="but" type=button value="REFRESH" style="width:90px" onclick="location.href=\'show.php?id='.$id.'\'">';
	echo '<input class="but" type=button '.$disdanach.' value=">" style="width:30px" onclick="location.href=\'show.php?id='.($id+1).'\'">';
	echo '<br><input class="but" type=button value="INDEX" style="width:150px; font-weight:bold" onclick="location.href=\'index.php\'"><br><br>';

	echo '<br>';
	echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff"><b>';
	if($id<0)	echo '<b>DEACTIVATED!</b><br><br>';
	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'].'<br><br>';
		$osver = @sshdo('os_ver=$(</etc/mageversion);cfg_ver=$(/sbin/magequery -n alxconfig-ng | cut -d" " -f5);pname=${cfg_ver%-*-*};cfg_ver=${cfg_ver/${pname}-};echo "${os_ver}:${cfg_ver}"', $conn['ip']);
		$osver = explode(':',$osver[1]);
		if($osver[0] == '') $osver[0]='unknown';
		if($osver[1] == '') $osver[1]='unknown';

		# update os string in database
		if($alxos == '')
		{
			mysql_query('insert into client_version(serial,os,utils) values("'.$id.'","'.$osver[0].'","'.$osver[1].'")
							on duplicate key update os="'.$osver[0].'", utils="'.$osver[1].'"');
			# reload the site
			echo '<script type="text/javascript">setTimeout(\'window.location.reload()\',0);</script>';
		}

		echo '<u>OS:</u> '.$osver[0].'<br>';
		echo '<u>Utils:</u> '.$osver[1].'<br>';

		if($osver[0] <> 'unknown')
		{
			//write them to database
		}
	}

	echo '</b></div>';

	if($state=='On')
	{
		echo '<input class="but" type=button value="REBOOT" style="width:150px" onclick="if(confirm(\'REBOOT CLIENT #'.$id.' ?\')) window.open(\'reboot.php?client='.$id.'&ip='.$conn['ip'].'&op=reboot\', \'ShutdownWin\', \'width=200,height=100\')"><br>';
		echo '<input class="but" type=button value="SHUTDOWN" style="width:150px" onclick="if(confirm(\'SHUTDOWN CLIENT #'.$id.' ?\')) window.open(\'reboot.php?client='.$id.'&ip='.$conn['ip'].'&op=halt\', \'ShutdownWin\', \'width=200,height=100\')"><br>';
		echo '<br>';
		echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff" align="center"><b>';
		echo 'Hardware Detection:</b></div>';
		echo '<input class="but" type=button value="LAN" style="width:50px" onclick="javascript:urlopen(\'include/hwinfo.php?ip='.$conn['ip'].'&cmd=lan\',\'POST\');">';
		echo '<input class="but" type=button value="WLAN" style="width:50px" onclick="javascript:urlopen(\'include/hwinfo.php?ip='.$conn['ip'].'&cmd=wlan\',\'POST\');">';
		echo '<input class="but" type=button value="VGA" style="width:50px" onclick="javascript:urlopen(\'include/hwinfo.php?ip='.$conn['ip'].'&cmd=vga\',\'POST\');">';
		echo '<br>';
		echo '<input class="but" type=button value="PRN" style="width:50px" onclick="javascript:urlopen(\'include/hwinfo.php?ip='.$conn['ip'].'&cmd=printer\',\'POST\');">';
		echo '<input class="but" type=button value="HRDW" style="width:50px" onclick="javascript:urlopen(\'include/hwinfo.php?ip='.$conn['ip'].'&cmd=system\',\'POST\');">';
		echo '<input class="but" type=button value="FS" style="width:50px" onclick="javascript:urlopen(\'include/hwinfo.php?ip='.$conn['ip'].'&cmd=rootfs\',\'POST\');">';
		echo '<br><br>';
		echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff" align="center"><b>';
		echo 'Remote Shadow:</b></div>';
		echo '<input class="but" type=button value="VNC" style="width:75px" onclick="window.open(\'vncviewer.php?ip='.$conn['ip'].'\', \'VncViewer\', \'width=200,height=100\')">';
		echo '<input class="but" type=button value="SSH" style="width:75px" onclick="window.open(\'mindterm.php?ip='.$conn['ip'].'\', \'MindTerm\', \'width=200,height=100\')">';
		echo '<br><br>';
		echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff" align="center"><b>';
		echo 'Client Update:</b></div>';
		echo '<input class="but" type=button value="UPDATE MAGE DB" style="width:150px" onclick="if(confirm(\'UPDATE DB ON CLIENT #'.$id.' ?\')) window.open(\'mageupgrade.php?client='.$id.'&ip='.$conn['ip'].'&op=update\', \'ShutdownWin\', \'width=800,height=600\')"><br>';
		echo '<input class="but" type=button value="CALC DEPS" style="width:150px" onclick="if(confirm(\'CALC DEPS FOR CLIENT #'.$id.' ?\')) window.open(\'mageupgrade.php?client='.$id.'&ip='.$conn['ip'].'&op=calc\', \'ShutdownWin\', \'width=800,height=600\')"><br>';
		echo '<input class="but" type=button value="UPGRADE CLIENT" style="width:150px" onclick="if(confirm(\'UPGRADE ALL PACKAGES ON CLIENT #'.$id.' ?\')) window.open(\'mageupgrade.php?client='.$id.'&ip='.$conn['ip'].'&op=upgrade\', \'ShutdownWin\', \'width=800,height=600\');setTimeout(\'window.location.reload()\',0);"><br>'; 
	}
	else
		echo '<input class="but" type=button value="WAKE ON LAN" style="width:150px" onclick="if(confirm(\'WAKE CLIENT #'.$id.' ?\')) window.open(\'wake_on_lan.php?mac='.$data['client_serials']['mac'].'\', \'WakeWin\', \'width=200,height=100\')"><br>';

	echo '<br><center><a href="share/ChangeLog.html" target="_blank">[ChangeLog]</a> <a href="share/FAQ.html" target="_blank">[FAQs]</a></center>';

echo '</td></tr></table>';
echo '</form>';
?>