Magellan Linux

  • Back to homepage
    • /[alx-svn]/alx-src/branches/alx-web-050/index.php

    Contents of /alx-src/branches/alx-web-050/index.php

    Parent Directory Parent Directory | Revision Log Revision Log

    Revision 1725 - (show annotations) (download)
    Wed Mar 16 11:04:35 2011 UTC (13 years, 1 month ago) by niro
    File size: 8603 byte(s) 
    -fixed broken array fetch
    1 <?
    2 include('include/basesql.php');
    3 session_start();
    4 session_register('alx_sort_krit'); session_register('alx_sort_onfirst'); session_register('alx_sort_loc');
    5
    6 $locations = sqlarr('SELECT location FROM client_locations', '', 'location');
    7 $locations[] = '';
    8
    9 if($_SESSION['alx_sort_krit']==null)
    10 {
    11 $_SESSION['alx_sort_krit'] = 'serial';
    12 $_SESSION['alx_sort_onfirst'] = 1;
    13 $_SESSION['alx_sort_loc'] = array('DEAD'=>false);
    14 foreach($locations as $l) $_SESSION['alx_sort_loc'][$l]=true;
    15 }
    16 if(isset($_GET['s_krit']))
    17 {
    18 $_SESSION['alx_sort_krit']=$_GET['s_krit'];
    19 $_SESSION['alx_sort_onfirst']=0+$_GET['s_on'];
    20 $_SESSION['alx_sort_loc']['DEAD']=$_GET['s_dead'];
    21 foreach($locations as $l) $_SESSION['alx_sort_loc'][$l]=$_GET['s_'.$l];
    22 }
    23
    24 function check_online($dat, $bla)
    25 {
    26 global $comps;
    27 global $pingcmd;
    28 if(!isset($comps[$dat['serial']])) return false;
    29
    30 //passthru("/bin/ping -I eth0 -c 1 -W 1 -q ".$dat['ip']." &> /dev/null && exit 0 || exit 1",$retval);
    31 passthru($pingcmd." ".$dat['ip']." &> /dev/null && exit 0 || exit 1",$retval);
    32 if($retval==0)
    33 {
    34 $comps[$dat['serial']]['online'] = true;
    35 $comps[$dat['serial']]['ip'] = $dat['ip'];
    36 }
    37 else $comps[$dat['serial']]['ip'] = '<font color=#a00000>'.$dat['ip'].' <small>(no ping)</small></font>';
    38
    39 $comps[$dat['serial']]['hostname'] = $dat['hostname'];
    40 $comps[$dat['serial']]['mac'] = $dat['mac'];
    41 }
    42
    43 function sortcomp($a,$b)
    44 {
    45 if($a['serial']<0 && $b['serial']>0) return -1;
    46 if($a['serial']>0 && $b['serial']<0) return 1;
    47
    48 if($_SESSION['alx_sort_onfirst'])
    49 {
    50 if($a['online'] && !$b['online']) return -1;
    51 if($b['online'] && !$a['online']) return 1;
    52 }
    53 if($_SESSION['alx_sort_krit']=='hostname')
    54 {
    55 if(strtoupper($a['hostname'])<strtoupper($b['hostname'])) return -1;
    56 else if(strtoupper($a['hostname'])>strtoupper($b['hostname'])) return 1;
    57 }
    58 return $a['serial']-$b['serial'];
    59 }
    60
    61 function checkif($b)
    62 { if($b) return ' checked'; else return ''; }
    63
    64 $comps = sqlarr("select client_serials.serial, client_serials.location, client_serials.mac, cfg_network.hostname, state_connected.mtime from client_serials left join cfg_network on client_serials.serial=cfg_network.serial left join state_connected on client_serials.serial=state_connected.serial", "serial");
    65
    66 sqlforeach('SELECT serial, ip, hostname, mac FROM state_connected', 'check_online', null);
    67 usort($comps, 'sortcomp');
    68 echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
    69 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">';
    70 echo '<head>';
    71 echo '<title>ALX Config - Index</title>';
    72 echo '<script language="JavaScript">';
    73 echo 'function loc(name) { window.open(\'loc.php?location=\'+name, \'\', \'width=350,height=180\'); }';
    74 echo '</script>';
    75 echo '</head>';
    76 echo '<script type="text/javascript" src="js/jquery-1.2.6.min.js"></script>';
    77 echo '<script type="text/javascript" src="js/jquery.tablesorter.js"></script>';
    78 //echo '<link rel="stylesheet" type="text/css" media="screen" href="js/style.css" />';
    79
    80 if($reload!='off') echo '<body onload="window.setTimeout(\'location.reload()\',60000)">';
    81
    82 /*
    83 echo '<img src="logo.jpg" align=middle>';
    84 echo '<a href="index.php" style="padding-left:170px; color:#000000;text-decoration:none; font-weight:bold">[REFRESH]</a><br>';
    85
    86 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';
    87 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>';
    88 */
    89
    90 echo '<form action="index.php" method="get" style="margin:0px">';
    91 echo '<table width=480><tr>';
    92 echo '<td><img src="pics/logo.jpg"></td>';
    93 echo '<td align=right valign=top><a href="index.php" style="color:#000000;text-decoration:none; font-weight:bold">[REFRESH]</a></td>';
    94 echo '</tr><tr>';
    95 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>';
    96 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>';
    97 echo '<td align=right valign=top>';
    98
    99 foreach($locations as $l)
    100 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>';
    101
    102 echo '<br/>';
    103 echo '<input onclick="this.form.submit()" type="checkbox" name="s_dead" value="1"'.checkif($_SESSION['alx_sort_loc']['DEAD']).'>DEACTIVATED';
    104 echo '</td>';
    105 echo '</tr></table><br>';
    106 echo '</form>';
    107
    108
    109 echo '<table border="1" id="mytab">';
    110 echo '<thead><tr style="font-weight:bold;background-color:#d5e5ff"><th>edit</th><th colspan=3>serial</th><th width=170>hostname</th><th width=100>ip</th><th width=100>last connected</th>';
    111 if($showversion=='on') echo '<th colspan=2>version</th>';
    112 echo '<th width=150>up/down</th></tr></thead><tbody>';
    113
    114 foreach($comps as $c)
    115 {
    116 if(!$_SESSION['alx_sort_loc'][$c['location']]) Continue;
    117 if($c['serial']<0 && !$_SESSION['alx_sort_loc']['DEAD']) Continue;
    118
    119 if($c['online']) $pic='online'; else $pic='offline';
    120
    121 if($c['serial']<0) { echo '<tr style="text-decoration:line-through; color:#aaaaaa">'; $pic = 'deact'; }
    122 else echo '<tr>';
    123
    124 echo '<td><input type=button value="EDIT" onclick="location.href=\'show.php?id='.$c['serial'].'\'"></td>';
    125 echo '<td>'.substr($c['location'],0,1).'</td>';
    126 echo '<td><img src="pics/'.$pic.'.gif" alt="'.strtoupper($pic).'"></td>';
    127 echo '<td width=40><b>#'.$c['serial'].'</b></td>';
    128 echo '<td><nobr>'.$c['hostname'].'</nobr></td>';
    129
    130 echo '<td><nobr>'.$c['ip'].'</nobr></td>';
    131 if($c['mtime']) { echo '<td><nobr>'.date('Y-m-d, H:i:s',$c['mtime']).'</nobr></td>'; }
    132 //if($c['mtime']) { echo '<td><nobr>'.$c['mtime'].'</nobr></td>'; }
    133 else echo '<td></td>';
    134
    135 if($c['online'])
    136 {
    137 if($showversion=='on')
    138 {
    139 $pubkey = mysql_query('select public_key from ssh_auth_clients where serial='.$c['serial'].'');
    140 while ($row = mysql_fetch_row ($pubkey)) {
    141
    142 # schreiben der .ssh/known_hosts file mit dem public rsa key des client,
    143 # um die "yes" abfrage zu vermeiden
    144 $hostfile = fopen ($home."/.ssh/known_hosts","w");
    145 fwrite($hostfile,$c['ip']." ".$row[0],strlen($row[0])+strlen($c['ip'])+1);
    146 fclose($hostfile);
    147
    148 $osver = exec($sshcmd.' '.$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}"\'');
    149 $osver = explode(':',$osver);
    150 }
    151 if($osver[0] == '') $osver[0]='unkown';
    152 if($osver[1] == '') $osver[1]='unkown';
    153 echo '<td>'.$osver[0].'</td>';
    154 echo '<td>'.$osver[1].'</td>';
    155 }
    156 }
    157
    158 echo '<td>';
    159 if($c['online'])
    160 {
    161 echo '<input type=button style="width:24%" 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\')">';
    162 echo '<input type=button style="width:24%" 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\')">';
    163 echo '<input type=button style="width:24%" value="VNC" onclick="window.open(\'vncviewer.php?ip='.$c['ip'].'\', \'VncViewer\', \'width=200,height=100\')">';
    164 echo '<input type=button style="width:24%" value="SSH" onclick="window.open(\'mindterm.php?ip='.$c['ip'].'\', \'MindTerm\', \'width=200,height=100\')">';
    165 }
    166 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\')">';
    167 echo '</td>';
    168
    169 echo '</tr>';
    170 }
    171 echo '</tbody></table><br>';
    172
    173 echo '';
    174
    175 ?>
    176 <script type="text/javascript">
    177 $(document).ready(function(){ $("#mytab").tablesorter({ headers: { 0:{sorter: false}, 1:{sorter: false}, 5:{sorter: false}} } ); });
    178 </script>

    Properties

    Name Value
    svn:executable *