Magellan Linux

Diff of /alx-src/branches/alx-web-070/index.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

alx-src/branches/alx-web-060/index.php revision 3348 by niro, Wed Feb 8 13:03:11 2012 UTC alx-src/branches/alx-web-070/index.php revision 8527 by niro, Mon Feb 8 10:03:43 2016 UTC
# Line 4  include('include/basesql.php'); Line 4  include('include/basesql.php');
4  include('include/common-functions.php');  include('include/common-functions.php');
5    
6  session_start();  session_start();
7  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');
8    $_SESSION['alx_sort_krit'] = $alx_sort_krit;
9    $_SESSION['alx_sort_onfirst'] = $alx_sort_onfirst;
10    $_SESSION['alx_sort_loc'] = $alx_sort_loc;
11    
12  $locations = sqlarr('SELECT location FROM client_locations', '', 'location');  $locations = sqlarr('SELECT location FROM client_locations where enabled="1"', '', 'location');
13  $locations[] = '';  $locations[] = '';
14    
15  if($_SESSION['alx_sort_krit']==null)  if($_SESSION['alx_sort_krit']==null)
# Line 27  if(isset($_GET['s_krit'])) Line 30  if(isset($_GET['s_krit']))
30  function check_online($dat, $bla)  function check_online($dat, $bla)
31  {  {
32   global $comps;   global $comps;
33   global $pingcmd;   global $mcore_port;
34     global $ping_timeout;
35   if(!isset($comps[$dat['serial']])) return false;   if(!isset($comps[$dat['serial']])) return false;
36    
37   //passthru("/bin/ping -I eth0 -c 1 -W 1 -q ".$dat['ip']." &> /dev/null && exit 0 || exit 1",$retval);   $retval = ping_host($dat['ip'],$mcore_port,$ping_timeout);
  passthru($pingcmd." ".$dat['ip']." &> /dev/null && exit 0 || exit 1",$retval);  
38   if($retval==0)   if($retval==0)
39   {   {
40   $comps[$dat['serial']]['online'] = true;   $comps[$dat['serial']]['online'] = true;
# Line 67  function checkif($b) Line 70  function checkif($b)
70   else return '';   else return '';
71  }  }
72    
73  $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");  $comps = sqlarr("select client_serials.serial, client_serials.enabled, client_serials.location, client_serials.mac, cfg_network.hostname, state_connected.mtime, state_connected.netboot 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");
74    
75  sqlforeach('SELECT serial, ip, hostname, mac FROM state_connected', 'check_online', null);  sqlforeach('SELECT state_connected.serial, state_connected.ip, cfg_network.hostname, state_connected.mac FROM state_connected left join cfg_network on cfg_network.serial=state_connected.serial', 'check_online', null);
76  usort($comps, 'sortcomp');  usort($comps, 'sortcomp');
77  echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"  echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
78      "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">';   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">';
79  echo '<head>';  echo '<head>';
80   echo '<title>ALX Config - Index</title>';   echo '<title>ALX Config - Index</title>';
81   echo '<script language="JavaScript">';   echo '<script language="JavaScript">';
# Line 85  echo '<script type="text/javascript" src Line 88  echo '<script type="text/javascript" src
88    
89  if($reload!='off') echo '<body onload="window.setTimeout(\'location.reload()\',60000)">';  if($reload!='off') echo '<body onload="window.setTimeout(\'location.reload()\',60000)">';
90    
 /*  
 echo '<img src="logo.jpg" align=middle>';  
 echo '<a href="index.php" style="padding-left:170px; color:#000000;text-decoration:none; font-weight:bold">[REFRESH]</a><br>';  
   
 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';  
 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>';  
 */  
   
91  echo '<form action="index.php" method="get" style="margin:0px">';  echo '<form action="index.php" method="get" style="margin:0px">';
92  echo '<table width=480><tr>';  echo '<table width=480><tr>';
93  echo '<td><img src="pics/logo.jpg"></td>';  echo '<td><img src="pics/logo.jpg"></td>';
# Line 113  echo '</form>'; Line 108  echo '</form>';
108    
109    
110  echo '<table border="1" id="mytab">';  echo '<table border="1" id="mytab">';
111  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>';  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>mac</th><th width=100>last connected</th>';
112  //always enable showversion atm  echo '<th colspan=2>version</th>';
113  $showversion = "on";  echo '<th width=100>boot</th>';
 if($showversion=='on') echo '<th colspan=2>version</th>';  
114  echo '<th width=150>up/down</th></tr></thead><tbody>';  echo '<th width=150>up/down</th></tr></thead><tbody>';
115    
116  foreach($comps as $c)  foreach($comps as $c)
117  {  {
118   if(!$_SESSION['alx_sort_loc'][$c['location']]) Continue;   if(!$_SESSION['alx_sort_loc'][$c['location']]) Continue;
119   if($c['serial']<0 && !$_SESSION['alx_sort_loc']['DEAD']) Continue;   if($c['enabled']==0 && !$_SESSION['alx_sort_loc']['DEAD']) Continue;
120    
121   if($c['online']) $pic='online';   if($c['online']) $pic='online';
122   else $pic='offline';   else $pic='offline';
123    
124   if($c['serial']<0)   if($c['enabled']==0)
125   {   {
126   echo '<tr style="text-decoration:line-through; color:#aaaaaa">';   echo '<tr style="text-decoration:line-through; color:#aaaaaa">';
127   $pic = 'deact';   $pic = 'deact';
# Line 135  foreach($comps as $c) Line 129  foreach($comps as $c)
129   else echo '<tr>';   else echo '<tr>';
130    
131   echo '<td><input type=button value="EDIT" onclick="location.href=\'show.php?id='.$c['serial'].'\'"></td>';   echo '<td><input type=button value="EDIT" onclick="location.href=\'show.php?id='.$c['serial'].'\'"></td>';
132   echo '<td>'.substr($c['location'],0,1).'</td>';   echo '<td>'.substr($c['location'],0,3).'</td>';
133   echo '<td><img src="pics/'.$pic.'.gif" alt="'.strtoupper($pic).'"></td>';   echo '<td><img src="pics/'.$pic.'.gif" alt="'.strtoupper($pic).'"></td>';
134   echo '<td width=40><b>#'.$c['serial'].'</b></td>';   echo '<td width=40><b>#'.$c['serial'].'</b></td>';
135   echo '<td><nobr>'.$c['hostname'].'</nobr></td>';   echo '<td><nobr>'.$c['hostname'].'</nobr></td>';
136    
137   echo '<td><nobr>'.$c['ip'].'</nobr></td>';   echo '<td><nobr>'.$c['ip'].'</nobr></td>';
138     echo '<td><nobr>'.$c['mac'].'</nobr></td>';
139   if($c['mtime']) { echo '<td><nobr>'.date('Y-m-d, H:i:s',$c['mtime']).'</nobr></td>'; }   if($c['mtime']) { echo '<td><nobr>'.date('Y-m-d, H:i:s',$c['mtime']).'</nobr></td>'; }
  //if($c['mtime']) { echo '<td><nobr>'.$c['mtime'].'</nobr></td>'; }  
140   else echo '<td></td>';   else echo '<td></td>';
141    
142   if($showversion=='on')   if($showversion=='on')
# Line 152  foreach($comps as $c) Line 146  foreach($comps as $c)
146   $alxver = $alxinfo[os];   $alxver = $alxinfo[os];
147   $alxutils = $alxinfo[utils];   $alxutils = $alxinfo[utils];
148    
149   if( $alxver == '')   if($alxver == '') $alxver='unknown';
150   {   if($alxutils == '') $alxutils='unknown';
  if($c['online'])  
  {  
  //$alxinfo = @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}"', $c['ip']);  
  //$alxinfo = explode(':',$alxinfo[1]);  
  //$alxver = $alxinfo[0];  
  //$alxutils = $alxinfo[1];  
  }  
  }  
  if($alxver == '') $alxver='unkown';  
  if($alxutils == '') $alxutils='unkown';  
151    
152         echo '<td>'.$alxver.'</td>';   echo '<td>'.$alxver.'</td>';
153         echo '<td>'.$alxutils.'</td>';   echo '<td>'.$alxutils.'</td>';
154   }   }
155    
156     //netboot state
157     if($c['netboot'] == 1) echo '<td>Netboot (PXE)</td>';
158     else echo '<td>Local Disk</td>';
159    
160   echo '<td>';   echo '<td>';
161   if($c['online'])   if($c['online'])
162   {   {
# Line 180  foreach($comps as $c) Line 168  foreach($comps as $c)
168   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\')">';   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\')">';
169   echo '</td>';   echo '</td>';
170    
171   echo '</tr>';   echo '</tr>';
172  }  }
173  echo '</tbody></table><br>';  echo '</tbody></table><br>';
174    

Legend:
Removed from v.3348  
changed lines
  Added in v.8527