Diff of /alx-src/trunk/alx-web/index.php

Parent Directory | Revision Log | Patch

	revision 355 by niro, Mon Oct 10 19:42:06 2005 UTC	revision 425 by niro, Wed Jun 4 22:35:14 2008 UTC
#	Line 1	Line 1
1	<?	<?
2	include('include/basesql.php');	include('include/basesql.php');
3	session_start();	session_start();
4	session_register('alx_sort_krit'); session_register('alx_sort_onfirst'); session_register('alx_sort_loc');	session_register('alx_sort_krit'); session_register('alx_sort_onfirst'); session_register('alx_sort_loc');
5	if($_SESSION['alx_sort_krit']==null) { $_SESSION['alx_sort_krit'] = 'serial'; $_SESSION['alx_sort_onfirst'] = 1; $_SESSION['alx_sort_loc'] = array(''=>true, 'BO'=>true, 'LIN'=>true, 'HAT'=>true, 'DEAD'=>false); }
6	if(isset($_GET['s_krit'])) { $_SESSION['alx_sort_krit']=$_GET['s_krit']; $_SESSION['alx_sort_onfirst']=0+$_GET['s_on'];	$locations = sqlarr('SELECT location FROM client_locations', '', 'location');
7	$_SESSION['alx_sort_loc']['BO']=$_GET['s_bo']; $_SESSION['alx_sort_loc']['LIN']=$_GET['s_lin']; $_SESSION['alx_sort_loc']['HAT']=$_GET['s_hat']; $_SESSION['alx_sort_loc']['']=$_GET['s_unset']; $_SESSION['alx_sort_loc']['DEAD']=$_GET['s_dead'];  }	$locations[] = '';
8
9	function check_online($dat, $bla)	if($_SESSION['alx_sort_krit']==null)
10	{	{
11	global $comps;	$_SESSION['alx_sort_krit'] = 'serial';
12	if(!isset($comps[$dat['serial']])) return false;	$_SESSION['alx_sort_onfirst'] = 1;
13		$_SESSION['alx_sort_loc'] = array('DEAD'=>false);
14	//passthru("/bin/ping -I eth0 -c 1 -W 1 -q ".$dat['ip']." &> /dev/null && exit 0 || exit 1",$retval);	foreach($locations as $l) $_SESSION['alx_sort_loc'][$l]=true;
15	passthru("/usr/sbin/fping -c 1 -t 50 -q ".$dat['ip']." &> /dev/null && exit 0 || exit 1",$retval);	}
16	if($retval==0)	if(isset($_GET['s_krit']))
17	{	{
18	$comps[$dat['serial']]['online'] = true;	$_SESSION['alx_sort_krit']=$_GET['s_krit'];
19	$comps[$dat['serial']]['ip'] = $dat['ip'];	$_SESSION['alx_sort_onfirst']=0+$_GET['s_on'];
20	}	$_SESSION['alx_sort_loc']['DEAD']=$_GET['s_dead'];
21	else $comps[$dat['serial']]['ip'] = '<font color=#a00000>'.$dat['ip'].' <small>(no ping)</small></font>';	foreach($locations as $l) $_SESSION['alx_sort_loc'][$l]=$_GET['s_'.$l];
22		}
23	$comps[$dat['serial']]['hostname'] = $dat['hostname'];
24	$comps[$dat['serial']]['mac'] = $dat['mac'];	function check_online($dat, $bla)
25	}	{
26		global $comps;
27	function sortcomp($a,$b)	if(!isset($comps[$dat['serial']])) return false;
28	{
29	if($a['serial']<0 && $b['serial']>0) return -1;	//passthru("/bin/ping -I eth0 -c 1 -W 1 -q ".$dat['ip']." &> /dev/null && exit 0 || exit 1",$retval);
30	if($a['serial']>0 && $b['serial']<0) return 1;	passthru("/usr/sbin/fping -c 1 -t 50 -q ".$dat['ip']." &> /dev/null && exit 0 || exit 1",$retval);
31		if($retval==0)
32	if($_SESSION['alx_sort_onfirst'])	{
33	{	$comps[$dat['serial']]['online'] = true;
34	if($a['online'] && !$b['online']) return -1;	$comps[$dat['serial']]['ip'] = $dat['ip'];
35	if($b['online'] && !$a['online']) return 1;	}
36	}	else $comps[$dat['serial']]['ip'] = '<font color=#a00000>'.$dat['ip'].' <small>(no ping)</small></font>';
37	if($_SESSION['alx_sort_krit']=='hostname')
38	{	$comps[$dat['serial']]['hostname'] = $dat['hostname'];
39	if(strtoupper($a['hostname'])<strtoupper($b['hostname'])) return -1;	$comps[$dat['serial']]['mac'] = $dat['mac'];
40	else if(strtoupper($a['hostname'])>strtoupper($b['hostname'])) return 1;	}
41	}
42	return $a['serial']-$b['serial'];	function sortcomp($a,$b)
43	}	{
44		if($a['serial']<0 && $b['serial']>0) return -1;
45	function checkif($b)	if($a['serial']>0 && $b['serial']<0) return 1;
46	{ if($b) return ' checked'; else return ''; }
47		if($_SESSION['alx_sort_onfirst'])
48	$comps = sqlarr('SELECT s.serial, s.location, s.mac, n.hostname FROM cfg_network n,client_serials s WHERE n.serial=s.serial', 'serial');	{
49	sqlforeach('SELECT serial, ip, hostname, mac FROM state_connected', 'check_online', null);	if($a['online'] && !$b['online']) return -1;
50	usort($comps, 'sortcomp');	if($b['online'] && !$a['online']) return 1;
51		}
52	echo '<head><title>ALX Config - Index</title></head>';	if($_SESSION['alx_sort_krit']=='hostname')
53	echo '<body onload="window.setTimeout(\'location.reload()\',60000)">';	{
54		if(strtoupper($a['hostname'])<strtoupper($b['hostname'])) return -1;
55	/*	else if(strtoupper($a['hostname'])>strtoupper($b['hostname'])) return 1;
56	echo '<img src="logo.jpg" align=middle>';	}
57	echo '<a href="index.php" style="padding-left:170px; color:#000000;text-decoration:none; font-weight:bold">[REFRESH]</a><br>';	return $a['serial']-$b['serial'];
58		}
59	echo '<form action="index.php" method="get" style="margin-top:0px"><b>SORT BY</b> <input onclick="this.form.submit()" type="radio" name="s_krit" value="serial"'.checkif($_SESSION['alx_sort_krit']=='serial').'>serial <input onclick="this.form.submit()" type="radio" name="s_krit" value="hostname"'.checkif($_SESSION['alx_sort_krit']=='hostname').'>hostname';
60	echo '<input onclick="this.form.submit()" style="margin-left:125px" name="s_on" type="checkbox" value="1"'.checkif($_SESSION['alx_sort_onfirst']).'>online clients on top</form><br>';	function checkif($b)
61	*/	{ if($b) return ' checked'; else return ''; }
62
63	echo '<form action="index.php" method="get" style="margin:0px">';	$comps = sqlarr('SELECT s.serial, s.location, s.mac, n.hostname FROM cfg_network n,client_serials s WHERE n.serial=s.serial', 'serial');
64	echo '<table width=480><tr>';	sqlforeach('SELECT serial, ip, hostname, mac FROM state_connected', 'check_online', null);
65	echo '<td><img src="pics/logo.jpg"></td>';	usort($comps, 'sortcomp');
66	echo '<td align=right valign=top><a href="index.php" style="color:#000000;text-decoration:none; font-weight:bold">[REFRESH]</a></td>';
67	echo '</tr><tr>';	echo '<head>';
68	echo '<td valign=top><b>SORT BY</b> <input onclick="this.form.submit()" type="radio" name="s_krit" value="serial"'.checkif($_SESSION['alx_sort_krit']=='serial').'>serial <input onclick="this.form.submit()" type="radio" name="s_krit" value="hostname"'.checkif($_SESSION['alx_sort_krit']=='hostname').'>hostname<br>';	echo '<title>ALX Config - Index</title>';
69	echo '<input onclick="this.form.submit()" name="s_on" style="margin-left:72px" type="checkbox" value="1"'.checkif($_SESSION['alx_sort_onfirst']).'>online clients on top</td>';	echo '<script language="JavaScript">';
70	echo '<td align=right valign=top>';	echo 'function loc(name) { window.open(\'loc.php?location=\'+name, \'\', \'width=350,height=180\'); }';
71	echo '<input onclick="this.form.submit()" type="checkbox" name="s_unset" value="1"'.checkif($_SESSION['alx_sort_loc']['']).'>?';	echo '</script>';
72	echo '<input onclick="this.form.submit()" type="checkbox" name="s_bo" value="1"'.checkif($_SESSION['alx_sort_loc']['BO']).'>BO';	echo '</head>';
73	echo '<input onclick="this.form.submit()" type="checkbox" name="s_hat" value="1"'.checkif($_SESSION['alx_sort_loc']['HAT']).'>HAT';	echo '<body onload="window.setTimeout(\'location.reload()\',60000)">';
74	echo '<input onclick="this.form.submit()" type="checkbox" name="s_lin" value="1"'.checkif($_SESSION['alx_sort_loc']['LIN']).'>LIN';
75	echo '<br>';	/*
76	echo '<input onclick="this.form.submit()" type="checkbox" name="s_dead" value="1"'.checkif($_SESSION['alx_sort_loc']['DEAD']).'>DEACTIVATED';	echo '<img src="logo.jpg" align=middle>';
77	echo '</td>';	echo '<a href="index.php" style="padding-left:170px; color:#000000;text-decoration:none; font-weight:bold">[REFRESH]</a><br>';
78	echo '</tr></table><br>';
79	echo '</form>';	echo '<form action="index.php" method="get" style="margin-top:0px"><b>SORT BY</b> <input onclick="this.form.submit()" type="radio" name="s_krit" value="serial"'.checkif($_SESSION['alx_sort_krit']=='serial').'>serial <input onclick="this.form.submit()" type="radio" name="s_krit" value="hostname"'.checkif($_SESSION['alx_sort_krit']=='hostname').'>hostname';
80		echo '<input onclick="this.form.submit()" style="margin-left:125px" name="s_on" type="checkbox" value="1"'.checkif($_SESSION['alx_sort_onfirst']).'>online clients on top</form><br>';
81		*/
82	echo '<table border>';
83	echo '<tr style="font-weight:bold;background-color:#d5e5ff"><td>edit</td><td colspan=3>serial</td><td width=170>hostname</td><td width=100>ip</td><td>up/down</td></tr>';	echo '<form action="index.php" method="get" style="margin:0px">';
84		echo '<table width=480><tr>';
85	foreach($comps as $c)	echo '<td><img src="pics/logo.jpg"></td>';
86	{	echo '<td align=right valign=top><a href="index.php" style="color:#000000;text-decoration:none; font-weight:bold">[REFRESH]</a></td>';
87	if(!$_SESSION['alx_sort_loc'][$c['location']]) Continue;	echo '</tr><tr>';
88	if($c['serial']<0 && !$_SESSION['alx_sort_loc']['DEAD']) Continue;	echo '<td valign=top><b>SORT BY</b> <input onclick="this.form.submit()" type="radio" name="s_krit" value="serial"'.checkif($_SESSION['alx_sort_krit']=='serial').'>serial <input onclick="this.form.submit()" type="radio" name="s_krit" value="hostname"'.checkif($_SESSION['alx_sort_krit']=='hostname').'>hostname<br>';
89		echo '<input onclick="this.form.submit()" name="s_on" style="margin-left:72px" type="checkbox" value="1"'.checkif($_SESSION['alx_sort_onfirst']).'>online clients on top</td>';
90	if($c['online']) $pic='online'; else $pic='offline';	echo '<td align=right valign=top>';
91
92	if($c['serial']<0) { echo '<tr style="text-decoration:line-through; color:#aaaaaa">'; $pic = 'deact'; }	foreach($locations as $l)
93	else echo '<tr>';	echo '<input onclick="this.form.submit()" type="checkbox" name="s_'.$l.'" value="1"'.checkif($_SESSION['alx_sort_loc'][$l]).'><a href="JavaScript:loc(\''.$l.'\')" style="color:#000000">'.($l=='' ? '?' : $l).'</a>';
94
95	echo '<td><input type=button value="EDIT" onclick="location.href=\'show.php?id='.$c['serial'].'\'"></td>';	echo '<br/>';
96	echo '<td>'.substr($c['location'],0,1).'</td>';	echo '<input onclick="this.form.submit()" type="checkbox" name="s_dead" value="1"'.checkif($_SESSION['alx_sort_loc']['DEAD']).'>DEACTIVATED';
97	echo '<td><img src="pics/'.$pic.'.gif" alt="'.strtoupper($pic).'"></td>';	echo '</td>';
98	echo '<td width=40><b>#'.$c['serial'].'</b></td>';	echo '</tr></table><br>';
99	echo '<td><nobr>'.$c['hostname'].'</nobr></td>';	echo '</form>';
100
101	echo '<td><nobr>'.$c['ip'].'</nobr></td>';
102		echo '<table border>';
103	echo '<td>';	echo '<tr style="font-weight:bold;background-color:#d5e5ff"><td>edit</td><td colspan=3>serial</td><td width=170>hostname</td><td width=100>ip</td>';
104	if($c['online'])	if($showversion=='on') echo '<td colspan=2>version</td>';
105	{	echo '<td>up/down</td></tr>';
106	echo '<input type=button style="width:50%" value="RB" onclick="if(confirm(\'REBOOT CLIENT #'.$c['serial'].' ?\')) window.open(\'reboot.php?client='.$c['serial'].'&ip='.$c['ip'].'&op=reboot\', \'ShutdownWin\', \'width=200,height=100\')">';
107	echo '<input type=button style="width:50%" value="SD" onclick="if(confirm(\'SHUTDOWN CLIENT #'.$c['serial'].' ?\')) window.open(\'reboot.php?client='.$c['serial'].'&ip='.$c['ip'].'&op=halt\', \'ShutdownWin\', \'width=200,height=100\')">';	foreach($comps as $c)
108	}	{
109	else echo '<input type=button style="width:100%" value="WOL" onclick="if(confirm(\'WAKE CLIENT #'.$c['serial'].' ?\')) window.open(\'wake_on_lan.php?mac='.$c['mac'].'\', \'WakeWin\', \'width=200,height=100\')">';	if(!$_SESSION['alx_sort_loc'][$c['location']]) Continue;
110	echo '</td>';	if($c['serial']<0 && !$_SESSION['alx_sort_loc']['DEAD']) Continue;
111
112	echo '</tr>';	if($c['online']) $pic='online'; else $pic='offline';
113	}
114	echo '</table><br>';	if($c['serial']<0) { echo '<tr style="text-decoration:line-through; color:#aaaaaa">'; $pic = 'deact'; }
115		else echo '<tr>';
116
117		echo '<td><input type=button value="EDIT" onclick="location.href=\'show.php?id='.$c['serial'].'\'"></td>';
118		echo '<td>'.substr($c['location'],0,1).'</td>';
119		echo '<td><img src="pics/'.$pic.'.gif" alt="'.strtoupper($pic).'"></td>';
120		echo '<td width=40><b>#'.$c['serial'].'</b></td>';
121		echo '<td><nobr>'.$c['hostname'].'</nobr></td>';
122
123		echo '<td><nobr>'.$c['ip'].'</nobr></td>';
124
125		if($c['online'])
126		{
127		if($showversion=='on')
128		{
129		$pubkey = mysql_query('select public_key from ssh_auth_clients where serial='.$c['serial'].'');
130		while ($row = mysql_fetch_row ($pubkey)) {
131		$sshcmd = "/usr/bin/ssh";
132		$home = "/home/httpd";
133
134		# schreiben der .ssh/known_hosts file mit dem public rsa key des client,
135		# um die "yes" abfrage zu vermeiden
136		$hostfile = fopen ($home."/.ssh/known_hosts","w");
137		fwrite($hostfile,$c['ip']." ".$row[0],strlen($row[0])+strlen($c['ip'])+1);
138		fclose($hostfile);
139
140		$osver = exec($sshcmd.' -l root '.$c['ip'].' \'os_ver=$(</etc/mageversion);cfg_ver=$(/sbin/magequery -n alxconfig-ng-alx|cut -d" " -f5);pname=${cfg_ver%-*-*};cfg_ver=${cfg_ver/${pname}-};echo "${os_ver}:${cfg_ver}"\'');
141		$osver = explode(':',$osver);
142		}
143		if($osver[0] == '') $osver[0]='unkown';
144		if($osver[1] == '') $osver[1]='unkown';
145		echo '<td>'.$osver[0].'</td>';
146		echo '<td>'.$osver[1].'</td>';
147		}
148		}
149
150		echo '<td>';
151		if($c['online'])
152		{
153		echo '<input type=button style="width:50%" value="RB" onclick="if(confirm(\'REBOOT CLIENT #'.$c['serial'].' ?\')) window.open(\'reboot.php?client='.$c['serial'].'&ip='.$c['ip'].'&op=reboot\', \'ShutdownWin\', \'width=200,height=100\')">';
154		echo '<input type=button style="width:50%" value="SD" onclick="if(confirm(\'SHUTDOWN CLIENT #'.$c['serial'].' ?\')) window.open(\'reboot.php?client='.$c['serial'].'&ip='.$c['ip'].'&op=halt\', \'ShutdownWin\', \'width=200,height=100\')">';
155		}
156		else echo '<input type=button style="width:100%" value="WOL" onclick="if(confirm(\'WAKE CLIENT #'.$c['serial'].' ?\')) window.open(\'wake_on_lan.php?mac='.$c['mac'].'\', \'WakeWin\', \'width=200,height=100\')">';
157		echo '</td>';
158
159		echo '</tr>';
160		}
161		echo '</table><br>';
162	?>	?>

---

Colored Diff Long Colored Diff Full Colored Diff Unidiff Context Diff Side by Side

Legend: Removed from v.355   changed lines   Added in v.425