Magellan Linux

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

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

alx-src/branches/alx-web-050/show.php revision 1608 by niro, Thu Dec 2 22:13:04 2010 UTC alx-src/branches/alx-web-060/show.php revision 4897 by niro, Tue May 28 13:55:52 2013 UTC
# Line 1  Line 1 
1  <?  <?
2   // INCLUDE UND TABELLEN-DEFINITIONEN  // INCLUDE UND TABELLEN-DEFINITIONEN
3   include('include/basesql.php');  include('include/basesql.php');
4   $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');  include('include/common-functions.php');
5   $multi= array(    0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 0, 0);  
6   $data = array();  // INCLUDE CURRENT-PROBLEMS
7    include('include/current-problems.php');
8    
9   // get alx version info for  $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');
10   $alxinfo = sqlfirst('SELECT * FROM client_version WHERE serial='.$id);  $multi= array(    0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 0, 0, 1);
11   $alxos = $alxinfo[os];  $data = array();
12   $alxutils = $alxinfo[utils];  
13    
14   if($kill==1)  // get alx version info for
15   {  $alxinfo = sqlfirst('SELECT * FROM client_version WHERE serial='.$id);
16   foreach($tabs as $t) mysql_query('UPDATE '.$t.' SET serial=-serial WHERE serial='.$id);  $alxos = $alxinfo[os];
17    $alxutils = $alxinfo[utils];
18   echo '<body onload="window.setTimeout(\'window.close()\', 1750)">';  
19   echo '<table width=100% height=100% style="border:solid black 1px; background-color:#d5e5ff"><tr><td valign=middle align=center>';  // get gfxdriver
20    $gfxinfo = sqlfirst('SELECT * FROM cfg_graphic WHERE serial='.$id);
21   if($id<0) echo 'ACTIVATED #'.abs($id);  
22   else echo 'DEACTIVATED #'.$id;  if($kill==1)
23    {
24   echo '</td></tr></table>';   foreach($tabs as $t) mysql_query('UPDATE '.$t.' SET serial=-serial WHERE serial='.$id);
25   return true;  
26   }   echo '<body onload="window.setTimeout(\'window.close()\', 1750)">';
27     echo '<table width=100% height=100% style="border:solid black 1px; background-color:#d5e5ff"><tr><td valign=middle align=center>';
28   // FELD-DEFINITIONEN  (ARRAY=>DROPDOWN / HIDDEN / IGNORE / 1 / BOLD / PASSWORD / SHOW / SHOWTIME / MONITORID)  
29   $drop = array();   if($id<0) echo 'ACTIVATED #'.abs($id);
30   if($alxos >= '0.5.3')   else echo 'DEACTIVATED #'.$id;
31   {  
32   $drop['cfg_graphic_module'] = array('vesa', 'ati', 'cirrus', 'i710', 'intel', 'nv', 'mga', 'r128', 'radeon', 's3', 's3virge', 'savage', 'sis', 'trident', 'tseng', 'via');   echo '</td></tr></table>';
33   }   return true;
34   else  }
35   {  
36   $drop['cfg_graphic_module'] = array('vesa', 'ati', 'cirrus', 'i810', 'i710', 'nv', 'mga', 'r128', 'radeon', 's3', 's3virge', 'savage', 'sis', 'trident', 'tseng', 'via');  // FELD-DEFINITIONEN  (ARRAY=>DROPDOWN / HIDDEN / IGNORE / 1 / BOLD / PASSWORD / SHOW / SHOWTIME / MONITORID)
37   }  $drop = array();
38   $drop['resolution'] = array('640x480', '800x600', '1024x768', '1280x960', '1280x1024', '1360x768', '1366x768', '1400x1050', '1440x900', '1600x1200', '1680x1050');  if($alxos >= '0.6.0')
39   $drop['depth'] = array('24', '16', '8');  {
40   $drop['mouse'] = array('Auto', 'IMPS/2', 'PS/2');   if($alxos >= '0.6.2')
41   $drop['cfg_network_module'] = array('3c59x', '8139too', '8139cp', 'e100', 'ne2k-pci', 'pcnet32', 'sis900', 'via-rhine', 'zd1211', 'b44', 'bnx2', 'dl2k', 'e1000', 'r8169', 'sk98lin', 'tg3', 'via-velocity');   {
42   $drop['networking'] = array('dhcp', 'static');   $drop['cfg_graphic_module'] = array('vesa', 'ati', 'cirrus', 'i710', 'intel', 'nv', 'mach64', 'mga', 'unichrome', 'radeon', 's3', 's3virge', 'savage', 'sis', 'trident', 'tseng', 'vmware');
43   $drop['port'] = array('lpt1', 'usb1', 'usb2', 'com1', 'com2', 'lpd', 'socket', 'ipp');   }
44   $drop['location'] = sqlarr('SELECT location FROM client_locations', '', 'location');   else
45   $drop['id'] = 'hidden';   {
46   $drop['flg_modified'] = '1';   $drop['cfg_graphic_module'] = array('vesa', 'ati', 'cirrus', 'i710', 'intel', 'nv', 'mach64', 'mga', 'openchrome', 'radeon', 's3', 's3virge', 'savage', 'sis', 'trident', 'tseng', 'vmware');
47   $drop['serial'] = 'ignore';   }
48   if($alxos>='0.5.3')   if($gfxinfo[module] == 'intel')
49   {   {
50   $drop['monitorid'] = 'ignore';   $drop['cfg_graphic_hdmi'] = array('disable', 'enable');
51   $drop['refresh_rate'] = array('','60','75','85','100');   }
52   }   else
53   else   {
54   {   $drop['cfg_graphic_hdmi'] = 'ignore';
55   $drop['monitorid'] = 'monitorid';   }
56   $drop['refresh_rate'] = 'ignore';  }
57   }  else if($alxos >= '0.5.3')
58   $drop['hostname'] = 'bold';  {
59   $drop['session'] = 'bold';   $drop['cfg_graphic_module'] = array('vesa', 'ati', 'cirrus', 'i710', 'intel', 'nv', 'mach64', 'mga', 'openchrome', 'radeon', 's3', 's3virge', 'savage', 'sis', 'trident', 'tseng');
60   $drop['cfg_autostart_session'] = 'filename';   $drop['cfg_graphic_hdmi'] = 'ignore';
61   $drop['mtime'] = 'showtime';  }
62   $drop['mac'] = 'show';  else
63   $drop['client_serials_serial'] = 'show';  {
64   $drop['password'] = 'password';   $drop['cfg_graphic_module'] = array('vesa', 'ati', 'cirrus', 'i810', 'i710', 'nv', 'mga', 'r128', 'radeon', 's3', 's3virge', 'savage', 'sis', 'trident', 'tseng', 'via');
65   $drop['shell'] = 'password';   $drop['cfg_graphic_hdmi'] = 'ignore';
66   $drop['vnc'] = 'password';  }
67   $drop['samba'] = 'password';  $drop['resolution'] = array('640x480', '800x600', '1024x768', '1280x960', '1280x1024', '1360x768', '1366x768', '1400x1050', '1440x900', '1600x1200', '1680x1050', '1280x720', '1920x1080');
68   $drop['station'] = 'password';  $drop['depth'] = array('24', '16', '8');
69   $drop['txt'] = 'txt';  $drop['mouse'] = array('Auto', 'IMPS/2', 'PS/2');
70   $drop['screensaver'] = array('','blank', 'random', 'ant', 'ant3d', 'apollonian', 'ball', 'bat', 'blot', 'bomb', 'bouboule',  $drop['keyboard'] = array('PC105');
71   'bounce', 'braid', 'bubble', 'bug', 'clock', 'coral', 'crystal', 'daisy', 'dclock', 'decay', 'deco',  if($alxos >= '0.6.0')
72   'demon', 'dilemma', 'discrete', 'dragon', 'drift', 'euler2d', 'eyes', 'fadeplot', 'fiberlamp', 'flag',  {
73   'flame', 'flow', 'forest', 'galaxy', 'goop', 'grav', 'helix', 'hop', 'hyper', 'ico', 'ifs', 'image',   $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', 'b43', 'b43legacy', 'hostap_pci', 'hostap_plx', 'ipw2100', 'ipw2200', 'iwl3945', 'usb8xxx', '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', 'wl1251', 'wl1271', 'zd1201', 'zd1211rw');
74   'juggle', 'julia', 'kaleid', 'kumppa', 'laser', 'life', 'life1d', 'life3d', 'lightning', 'lisa', 'lissie',  }
75   'loop', 'lyapunov', 'mandelbrot', 'marquee', 'matrix', 'maze', 'mountain', 'munch', 'nose', 'pacman',  else
76   'penrose', 'petal', 'petri', 'polyominoes', 'puzzle',  'pyro', 'qix', 'roll',  'rotor', 'scooter', 'shape',  {
77   'sierpinski', 'slip', 'solitare', 'space', 'sphere', 'spiral', 'spline', 'star', 'starfish', 'strange',   $drop['cfg_network_module'] = array('3c59x', '8139too', '8139cp', 'e100', 'ne2k-pci', 'pcnet32', 'sis900', 'via-rhine', 'zd1211', 'b44', 'bnx2', 'dl2k', 'e1000', 'forcedeth', 'r8169', 'sk98lin', 'tg3', 'via-velocity');
78   'swarm', 'swirl', 't3d', 'tetris', 'thornbird', 'tik_tak', 'toneclock', 'triangle', 'tube', 'turtle',  }
79   'vines', 'voters', 'wator', 'wire', 'world', 'worm', 'xcl', 'xjack');  $drop['networking'] = array('dhcp', 'static');
80   $drop['iface'] = array('eth0', 'wlan0');  // 0.6.0 does not support lpd, ipp and socket printing atm
81   $drop['client_version_os'] = 'show';  if($alxos>='0.6.0')
82   $drop['client_version_utils'] = 'show';  {
83     $drop['port'] = array('lpt1', 'usb1', 'usb2', 'com1', 'com2');
84   // ACHTUNG!!! wlan_-Felder heißen eigentlich wireless_   for ($i=0; $i<999; $i++) { $drop['cfg_printers_'.$i.'_ip'] = 'ignore'; }
85   $drop['wireless_mode'] = array('', 'managed', 'ad-hoc', 'master', 'repeater', 'secondary', 'monitor', 'auto');   $drop['share'] = 'ignore';
86   $drop['wireless_auth_mode'] = array('', 'wep', 'wpa', 'off');  }
87   $drop['wireless_key_length'] = array('', '64', '128', '256');  else
88   $drop['wireless_channel'] = array('', '1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14');  {
89   $drop['wireless_frequency'] = array('', '2.412G', '2.417G', '2.422G', '2.427G', '2.432G', '2.437G', '2.442G',   $drop['port'] = array('lpt1', 'usb1', 'usb2', 'com1', 'com2', 'lpd', 'socket', 'ipp');
90   '2.447G', '2.452G', '2.457G', '2.462G', '2.467G', '2.472G', '2.484G');  }
91   $drop['wireless_key'] = 'password';  $drop['location'] = sqlarr('SELECT location FROM client_locations', '', 'location');
92   $drop['wireless_key_ascii'] = 'password';  $drop['id'] = 'hidden';
93    $drop['flg_modified'] = '1';
94   // GGF. NEUEN DATENSATZ EINFÜGEN  $drop['serial'] = 'ignore';
95   if(isset($_POST['do_add']))  if($alxos>='0.5.3')
96   {  {
97   list($bla,$what) = explode(' ',$_POST['do_add']);   $drop['monitorid'] = 'ignore';
98   if($what=='COMMENT') sqladd('cfg_comments', array('serial'=>$id));   $drop['refresh_rate'] = array('','60','75','85','100');
99   else if($what=='PRINTER') sqladd('cfg_printers', array('serial'=>$id));  }
100   else if($what=='MODULE') sqladd('cfg_modules', array('serial'=>$id));  else
101   else if($what=='SESSION') sqladd('cfg_sessions', array('domain'=>'DOM_AKA_NT', 'browseradrs'=>'128.20.50.50;128.20.50.66;128.20.50.71;128.20.50.46;128.20.100.31;128.20.100.32', 'serial'=>$id));  {
102   else if($what=='MENUITEM') sqladd('cfg_other_menuitems', array('serial'=>$id));   $drop['monitorid'] = 'monitorid';
103   }   $drop['refresh_rate'] = 'ignore';
104    }
105    $drop['hostname'] = 'bold';
106   // GGF. SPEICHERN  $drop['session'] = 'bold';
107   if($_POST['do_upl'])  if($alxos>='0.6.0')
108   {  {
109   function postarr($prefix)   $drop['cfg_autostart_session'] = sqlarr('SELECT filename FROM cfg_sessions where serial='.$id, '', 'filename');
110   {   array_unshift($drop['cfg_autostart_session'], "");
111   $prefix.='_';  }
112   $prelen = strlen($prefix);  else
113    {
114   $arr = array();   $drop['cfg_autostart_session'] = 'filename';
115   foreach($_POST as $k=>$v)  }
116   if((substr($k,0,$prelen)==$prefix) && ($v!='KEEPPASS'))  $drop['mtime'] = 'showtime';
117   $arr[substr($k,$prelen)] = stripslashes($v);  $drop['mac'] = 'show';
118    $drop['client_serials_serial'] = 'show';
119   return $arr;  $drop['password'] = 'password';
120   }  $drop['shell'] = 'password';
121    $drop['vnc'] = 'password';
122   foreach($tabs as $k=>$t)  $drop['samba'] = 'password';
123   {  $drop['station'] = 'password';
124   if(!$multi[$k]) mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t)).' WHERE serial='.$id);  $drop['txt'] = 'txt';
125   else  $drop['screensaver'] = array('','blank', 'random', 'ant', 'ant3d', 'apollonian', 'ball', 'bat', 'blot', 'bomb', 'bouboule',
126   {   'bounce', 'braid', 'bubble', 'bug', 'clock', 'coral', 'crystal', 'daisy', 'dclock', 'decay', 'deco',
127   $i=0;   'demon', 'dilemma', 'discrete', 'dragon', 'drift', 'euler2d', 'eyes', 'fadeplot', 'fiberlamp', 'flag',
128   while(isset($_POST[$t.'_'.$i.'_id']))   'flame', 'flow', 'forest', 'galaxy', 'goop', 'grav', 'helix', 'hop', 'hyper', 'ico', 'ifs', 'image',
129   {   'juggle', 'julia', 'kaleid', 'kumppa', 'laser', 'life', 'life1d', 'life3d', 'lightning', 'lisa', 'lissie',
130   if($_POST[$t.'_'.$i.'_delete'])   'loop', 'lyapunov', 'mandelbrot', 'marquee', 'matrix', 'maze', 'mountain', 'munch', 'nose', 'pacman',
131   mysql_query('DELETE FROM '.$t.' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);   'penrose', 'petal', 'petri', 'polyominoes', 'puzzle',  'pyro', 'qix', 'roll',  'rotor', 'scooter', 'shape',
132   else   'sierpinski', 'slip', 'solitare', 'space', 'sphere', 'spiral', 'spline', 'star', 'starfish', 'strange',
133   mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t.'_'.$i)).' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);   'swarm', 'swirl', 't3d', 'tetris', 'thornbird', 'tik_tak', 'toneclock', 'triangle', 'tube', 'turtle',
134   $i++;   'vines', 'voters', 'wator', 'wire', 'world', 'worm', 'xcl', 'xjack');
135   }  $drop['iface'] = array('eth0', 'wlan0');
136   }  $drop['client_version_os'] = 'show';
137   }  $drop['client_version_utils'] = 'show';
138   }  
139    // ACHTUNG!!! wlan_-Felder heißen eigentlich wireless_
140    $drop['wireless_mode'] = array('', 'managed', 'ad-hoc', 'master', 'repeater', 'secondary', 'monitor', 'auto');
141   // EINLESEN DER DATEN AUS SQL-TABELLEN  $drop['wireless_auth_mode'] = array('', 'wep', 'wpa', 'wpa2', 'off');
142   foreach($tabs as $k=>$t)  $drop['wireless_key_length'] = array('', '64', '128', '256');
143   {  $drop['wireless_channel'] = array('', '1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14');
144   if($multi[$k]) $data[$t] = sqlarr('SELECT * FROM '.$t.' WHERE serial='.$id);  $drop['wireless_frequency'] = array('', '2.412G', '2.417G', '2.422G', '2.427G', '2.432G', '2.437G', '2.442G',
145   else $data[$t] = sqlfirst('SELECT * FROM '.$t.' WHERE serial='.$id);   '2.447G', '2.452G', '2.457G', '2.462G', '2.467G', '2.472G', '2.484G');
146   }  $drop['wireless_key'] = 'password';
147    $drop['wireless_key_ascii'] = 'password';
148   // ANZEIGEN - KLAPPFUNKTIONEN  
149   $absnames = array();  // plugin support
150    if($alxos>='0.6.0')
151   function openabs($heading, $helpfile='')  {
152   {   for ($i=0; $i<999; $i++) { $drop['cfg_plugins_'.$i.'_plugin'] = 'pluginconfig'; }
153   global $absnames;   for ($i=0; $i<999; $i++)
154   $absnames[] = $heading;   {
155     $drop['cfg_plugins_'.$i.'_plugin_array'] = sqlarr('SELECT plugin FROM avail_plugins', '', 'plugin');
156   // <AufZuLink> <Bild/> <Heading/> </AufZuLink><BR/> <Absatz>   array_unshift($drop['cfg_plugins_'.$i.'_plugin_array'], "");
157     }
158   if( $_SESSION['openclose'][$heading] )  }
159   {  else
160   echo '<a href="JavaScript:openclose(\''.$heading.'\',1);"><img border="0" src="pics/minus.gif" title="CLOSE" id="sch_bild_'.$heading.'"> <b>['.$heading.']</b></a>';  {
161   if($helpfile!='') echo ' <a href="JavaScript:showhelp(\''.$helpfile.'\')" title="HELP">[?]</a>';   for ($i=0; $i<999; $i++) { $drop['cfg_plugins_'.$i.'_id'] = 'ignore'; }
162   echo '<br><div id="sch_absatz_'.$heading.'" style="top:0px; visibility:visible">';   for ($i=0; $i<999; $i++) { $drop['cfg_plugins_'.$i.'_serial'] = 'ignore'; }
163   }   for ($i=0; $i<999; $i++) { $drop['cfg_plugins_'.$i.'_plugin'] = 'ignore'; }
164   else  }
165   {  
166   echo '<a href="JavaScript:openclose(\''.$heading.'\',1);"><img border="0" src="pics/plus.gif" title="OPEN" id="sch_bild_'.$heading.'"> <b>['.$heading.']</b></a>';  // get current citrix sessions
167   if($helpfile!='') echo ' <a href="JavaScript:showhelp(\''.$helpfile.'\')" title="HELP">[?]</a>';  if($alxos>='0.6.0')
168   echo '<br><div id="sch_absatz_'.$heading.'" style="position:absolute; top:0px; visibility:hidden">';  {
169   }   // split all citrix server into an array to get the first server from list
170   }   $citrix_query_browser = split(";", $citrix_browseradrs);
171     exec($wwwroot.'/pnabrowse-wrapper -A '.$citrix_query_browser[0], $returned_citrix_sessions, $retval);
172   function closeabs()   if ($retval == 0)
173   {   {
174   // </Absatz> <BR/>   $citrix_public_applications = str_replace("'", "", $returned_citrix_sessions);
175     // add an empty value add the first position of the array as session-default
176   echo '</div><br>';   array_unshift($citrix_public_applications, "");
177   }   for ($i=0; $i<999; $i++) { $drop['cfg_sessions_'.$i.'_session'] = $citrix_public_applications; }
178     }
179     else
180   // ANZEIGEN   {
181     if($retval = 126) echo "pnabrowser-wrapper has no execute permission! please run chmod +x on ".$wwwroot."/pnabrowser-wrapper.";
182   function parsearr($name, $arr, $del=false, $wireless=false)   else echo "pnabrowse-wrapper does not run successfully! retval->'".$retval."'<br>";
183   {   }
184   global $drop;  }
185   global $id;  
186   global $alxos;  // GGF. NEUEN DATENSATZ EINFÜGEN
187    if(isset($_POST['do_add']))
188   $parts = explode('_',$name); $helpfile='help.php?page='.$parts[1];  {
189   openabs($name, $helpfile);   list($bla,$what) = explode(' ',$_POST['do_add']);
190   echo '<table class="keytab">';   if($what=='COMMENT') sqladd('cfg_comments', array('serial'=>$id));
191     else if($what=='PRINTER') sqladd('cfg_printers', array('serial'=>$id));
192   foreach($arr as $k=>$v)   else if($what=='MODULE') sqladd('cfg_modules', array('serial'=>$id));
193   {   else if($what=='SESSION') sqladd('cfg_sessions', array('domain'=>$citrix_domain_name, 'browseradrs'=>$citrix_browseradrs, 'serial'=>$id));
194   if( (substr($k,0,9)=='wireless_') xor $wireless ) Continue;   else if($what=='MENUITEM') sqladd('cfg_other_menuitems', array('serial'=>$id));
195     else if($what=='PLUGIN') sqladd('cfg_plugins', array('serial'=>$id));
196   $d = $drop[$name.'_'.$k]; if($d==null) $d = $drop[$k];  }
197   $k = str_replace('wireless_', '', $k);  
198   $k2 = $k;  
199    // GGF. SPEICHERN
200   //replace i810 with intel on 0.5.3 or higher  if($_POST['do_upl'])
201   if($alxos >= '0.5.3' && $v == 'i810')  {
202   {   function postarr($prefix)
203   echo '<br><font color="#FF0000">Replaced "i810" with "intel" - Please press SAVE!</font><br>';   {
204   $v='intel';   $prefix.='_';
205   }   $prelen = strlen($prefix);
206    
207   if(is_array($d))   $arr = array();
208   {   foreach($_POST as $k=>$v)
209   echo '<tr><td class="key">'.$k2.'</td><td>= <select style="width:144px" name="'.$name.'_'.$k.'">';   if((substr($k,0,$prelen)==$prefix) && ($v!='KEEPPASS'))
210   foreach($d as $di) if($v==$di) echo '<option selected>'.$di; else echo '<option>'.$di;   $arr[substr($k,$prelen)] = stripslashes($v);
211   echo '</select></td></tr>';  
212   }   return $arr;
213   else if($d=='hidden') echo '<tr><td colspan=2><input type=hidden name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';   }
214   else if($d=='1') echo '<tr><td colspan=2><input type=hidden name="'.$name.'_'.$k.'" value="1"></td></tr>';  
215   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>';   foreach($tabs as $k=>$t)
216   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>';   {
217   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>';   if(!$multi[$k]) mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t)).' WHERE serial='.$id);
218   else if($d=='show') echo '<tr><td class="key">'.$k2.'</td><td>= <b>'.$v.'</b></td></tr>';   else
219   else if($d=='showtime') echo '<tr><td class="key">'.$k2.'</td><td>= <b>'.date('d.m.y - H:i:s', $v).'</b></td></tr>';   {
220   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>';   $i=0;
221   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>';   while(isset($_POST[$t.'_'.$i.'_id']))
222   else if($d=='txt') echo '<tr><td colspan=2><textarea style="width:240px; background-color:#d5e5ff" rows=4 name="'.$name.'_'.$k.'">'.$v.'</textarea></td></tr>';   {
223   else if($d!='ignore') echo '<tr><td class="key">'.$k2.'</td><td>= <input style="width:144px" name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';   if($_POST[$t.'_'.$i.'_delete'])
224   }   mysql_query('DELETE FROM '.$t.' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);
225     else
226   if($del) echo '<tr><td class="key">delete</td><td>=<input type=checkbox name="'.$name.'_delete" value="1"></td></tr>';   mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t.'_'.$i)).' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);
227   echo '</table>';   $i++;
228   closeabs();   }
229     }
230   if($name=='cfg_network' && !$wireless) parsearr($name.'_wireless', $arr, $del, true);   }
231   }  
232   function parsearrs($name, $arr)   // reload site
233   {   header("location: show.php?id=".$id);
234   foreach($arr as $k=>$a)  }
235   parsearr($name.'_'.$k, $a, true);  
236   }  // EINLESEN DER DATEN AUS SQL-TABELLEN
237    foreach($tabs as $k=>$t)
238   ?><head>  {
239   <title>ALX Config</title>   if($multi[$k]) $data[$t] = sqlarr('SELECT * FROM '.$t.' WHERE serial='.$id);
240   <style>   else $data[$t] = sqlfirst('SELECT * FROM '.$t.' WHERE serial='.$id);
241   body,table { font-family:Tahoma; font-size:10pt }  }
242   a { color:#000000; text-decoration:none; }  
243   .key { width:85px }  // ANZEIGEN - KLAPPFUNKTIONEN
244   .keytab, input, textarea, select, option { font-size:8pt; font-family:Tahoma }  $absnames = array();
245   .but { font-size:10pt; font-family:Tahoma; height:23px }  
246   </style>  function openabs($heading, $helpfile='')
247   <script language="JavaScript" src="openclose_ajax.js"></script>  {
248   <script language="JavaScript">   global $absnames;
249     $absnames[] = $heading;
250   function openclose(nummer, act)  
251   {   // <AufZuLink> <Bild/> <Heading/> </AufZuLink><BR/> <Absatz>
252   var bild = document.images['sch_bild_'+nummer];  
253   var absatz = document.all['sch_absatz_'+nummer].style;   if( $_SESSION['openclose'][$heading] )
254   var senden = false;   {
255     echo '<a href="JavaScript:openclose(\''.$heading.'\',1);"><img border="0" src="pics/minus.gif" title="CLOSE" id="sch_bild_'.$heading.'"> <b>['.$heading.']</b></a>';
256   if(bild.title == 'OPEN')   if($helpfile!='') echo ' <a href="JavaScript:showhelp(\''.$helpfile.'\')" title="HELP">[?]</a>';
257   {   echo '<br><div id="sch_absatz_'.$heading.'" style="top:0px; visibility:visible">';
258   if(act<=1)   }
259   {   else
260   absatz.visibility = 'visible';   {
261   absatz.position = '';   echo '<a href="JavaScript:openclose(\''.$heading.'\',1);"><img border="0" src="pics/plus.gif" title="OPEN" id="sch_bild_'.$heading.'"> <b>['.$heading.']</b></a>';
262   bild.title = 'CLOSE';   if($helpfile!='') echo ' <a href="JavaScript:showhelp(\''.$helpfile.'\')" title="HELP">[?]</a>';
263   bild.src = 'pics/minus.gif';   echo '<br><div id="sch_absatz_'.$heading.'" style="position:absolute; top:0px; visibility:hidden">';
264   senden = true;   }
265   act = 0;  }
266   }  
267   }  function closeabs()
268   else  {
269   {   // </Absatz> <BR/>
270   if(act>=1)  
271   {   echo '</div><br>';
272   absatz.visibility = 'hidden';  }
273   absatz.position = 'absolute';  
274   bild.title = 'OPEN';  
275   bild.src = 'pics/plus.gif';  // ANZEIGEN
276   senden = true;  
277   act = 2;  function parsearr($name, $arr, $del=false, $wireless=false)
278   }  {
279   }   global $drop;
280     global $id;
281   if(senden) sendopenclose(nummer,act);   global $alxos;
282   }  
283     $parts = explode('_',$name); $helpfile='help.php?page='.$parts[1];
284   function showhelp(name)   openabs($name, $helpfile);
285   { window.open(name, 'HelpWin', 'width=620,height=500,scrollbars=yes'); }   echo '<table class="keytab">';
286    
287   </script>   foreach($arr as $k=>$v)
288   </head>   {
289     if( (substr($k,0,9)=='wireless_') xor $wireless ) Continue;
290   <body><?  
291     $d = $drop[$name.'_'.$k]; if($d==null) $d = $drop[$k];
292     $k = str_replace('wireless_', '', $k);
293   //echo '<body style="background-image:URL(logo.jpg);background-repeat:no-repeat; background-position:0px 0px; margin-top:25px">';   $k2 = $k;
294   echo '<form action="show.php" method=post onreset="return confirm(\'UNDO CHANGES?\')">';  
295   echo '<input type=hidden name="do_upl" value="1">';   //replace some drivers on 0.5.3 or higher
296   echo '<input type=hidden name="id" value="'.$id.'">';   if($alxos >= '0.5.3')
297     {
298   // ANZEIGEN => NON-MULTI TABELLEN   if($v == 'i810')
299   echo '<table><tr><td valign=top width="300">';   {
300     echo '<br><font color="#FF0000">Replaced "i810" with "intel" - Please press SAVE!</font><br>';
301   echo '<b style="font-size:6pt">';   $v='intel';
302   echo '<a href="JavaScript:opencloseall(0);" title="OPEN ALL"><img src="pics/plus.gif" border="0"> OPEN...</a> ';   }
303   echo '<a href="JavaScript:opencloseall(2);" title="CLOSE ALL"><img src="pics/minus.gif" border="0"> CLOSE...</a> ALL';   if($v == 'r128')
304   echo '</b><br><br>';   {
305     echo '<br><font color="#FF0000">Replaced "r128" with "vesa" - Please press SAVE!</font><br>';
306   foreach($tabs as $k=>$t) if(!$multi[$k]) parsearr($t, $data[$t]);   $v='vesa';
307     }
308   // ANZEIGEN => MULTI TABELLEN  
309   echo '</td><td valign=top width="300">';   if($v == 'via')
310     {
311   foreach($tabs as $k=>$t) if($multi[$k]) parsearrs($t, $data[$t]);   echo '<br><font color="#FF0000">Replaced "via" with "openchrome" - Please press SAVE!</font><br>';
312     $v='openchrome';
313   echo '<script language="JavaScript">';   }
314   echo 'function opencloseall(act) { ';   }
315     if($alxos >= '0.6.2')
316   foreach($absnames as $absname)   {
317   echo 'openclose("'.$absname.'", act); ';   if($v == 'via')
318     {
319   echo '}</script>';   echo '<br><font color="#FF0000">Replaced "via" with "unichrome" - Please press SAVE!</font><br>';
320     $v='unichrome';
321   // ANZEIGEN => NAVI   }
322   echo '</td><td valign=top>';   if($v == 'openchrome')
323     {
324   // STATUS BESTIMMEN (ON/OFF)   echo '<br><font color="#FF0000">Replaced "openchrome" with "unichrome" - Please press SAVE!</font><br>';
325   $conn = sqlfirst('SELECT * FROM state_connected WHERE serial='.$id);   $v='unichrome';
326   $state = 'Off';   }
327   if(count($conn)>0)   }
328   {  
329  // passthru($pingcmd." ".$conn['ip']." &> /dev/null && exit 0 || exit 1",$retval);   # tell something about vesa
330   if($retval==0) $state = 'On';   if ($v == 'vesa') echo '<br><font color="#FF0000">Warning: "vesa" graphic module doesn\'t support any resolutions higher than 1024x786x16@60hz!</font><br>';
331   }  
332    
333     if(is_array($d))
334   echo '<img src="pics/logo2.jpg"><br><br>';   {
335     echo '<tr><td class="key">'.$k2.'</td><td>= <select style="width:144px" name="'.$name.'_'.$k.'">';
336   echo '<input class="but" type=submit value="SAVE" style="width:150px"><br><br>';   foreach($d as $di) if($v==$di) echo '<option selected>'.$di; else echo '<option>'.$di;
337     echo '</select></td></tr>';
338   echo '<input class="but" type=submit name="do_add" value="SAVE+ADD COMMENT" style="width:150px"><br>';   }
339   echo '<input class="but" type=submit name="do_add" value="SAVE+ADD PRINTER" style="width:150px"><br>';   else if($d=='hidden') echo '<tr><td colspan=2><input type=hidden name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';
340   echo '<input class="but" type=submit name="do_add" value="SAVE+ADD SESSION" style="width:150px"><br>';   else if($d=='1') echo '<tr><td colspan=2><input type=hidden name="'.$name.'_'.$k.'" value="1"></td></tr>';
341   echo '<input class="but" type=submit name="do_add" value="SAVE+ADD MODULE" style="width:150px"><br>';   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>';
342   echo '<input class="but" type=submit name="do_add" value="SAVE+ADD MENUITEM" style="width:150px"><br><br>';   else if($d=='pluginconfig')
343     {
344     $dplugin = $drop[$name.'_'.$k.'_array']; if($dplugin==null) $dplugin = $drop[$k];
345   if($id>0) $KILLCAP='DEACTIVATE'; else $KILLCAP='ACTIVATE';   if(is_array($dplugin))
346   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>';   {
347   echo '<input class="but" type=button value="IMPORT FROM..." style="width:150px" onclick="location.href=\'import.php?id='.$id.'\'"><br>';   echo '<tr><td class="key">'.$k2.'</td><td>= <select style="width:144px" name="'.$name.'_'.$k.'">';
348   echo '<input class="but" type=reset value="UNDO CHANGES" style="width:150px"><br><br>';   foreach($dplugin as $di) if($v==$di) echo '<option selected>'.$di; else echo '<option>'.$di;
349     echo '</select></td></tr>';
350   $davor  = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id-1),'mac')!=null; if($davor) $disdavor=''; else $disdavor = 'disabled=1';   }
351   $danach = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id+1),'mac')!=null; if($danach) $disdanach=''; else $disdanach = 'disabled=1';   // $v contains the pluginname, get the configure flag
352     $pflag = sqlfirst('SELECT configflag FROM avail_plugins WHERE plugin="'.$v.'"');
353   echo '<input class="but" type=button '.$disdavor.' value="<" style="width:30px" onclick="location.href=\'show.php?id='.($id-1).'\'">';   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>';
354   echo '<input class="but" type=button value="REFRESH" style="width:90px" onclick="location.href=\'show.php?id='.$id.'\'">';   }
355   echo '<input class="but" type=button '.$disdanach.' value=">" style="width:30px" onclick="location.href=\'show.php?id='.($id+1).'\'">';   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>';
356   echo '<br><input class="but" type=button value="INDEX" style="width:150px; font-weight:bold" onclick="location.href=\'index.php\'"><br><br>';   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>';
357     else if($d=='show') echo '<tr><td class="key">'.$k2.'</td><td>= <b>'.$v.'</b></td></tr>';
358   echo '<br><br>';   else if($d=='showtime') echo '<tr><td class="key">'.$k2.'</td><td>= <b>'.date('d.m.y - H:i:s', $v).'</b></td></tr>';
359   echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff"><b>';   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>';
360   if($id<0) echo '<b>DEACTIVATED!</b><br><br>';   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>';
361   echo '<u>Serial:</u>&nbsp;&nbsp;#'.$id.'<br>';   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>';
362   echo '<u>Stand:</u>&nbsp;&nbsp;'.date('H:i:s').'<br>';   else if($d!='ignore') echo '<tr><td class="key">'.$k2.'</td><td>= <input style="width:144px" name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';
363   echo '<u>Status:</u> <img src="pics/'.strtolower($state).'line.gif" align=top> '.$state.'line<br>';   }
364   if($state=='On')  
365   {   if($del) echo '<tr><td class="key">delete</td><td>=<input type=checkbox name="'.$name.'_delete" value="1"></td></tr>';
366   echo '<u>IP:</u> '.$conn['ip'].'<br><br>';   echo '</table>';
367   $pubkey = mysql_query('select public_key from ssh_auth_clients where serial='.$id.'');   closeabs();
368   while ($row = mysql_fetch_row ($pubkey)) {  
369   # schreiben der .ssh/known_hosts file mit dem public rsa key des client,   if($name=='cfg_network' && !$wireless) parsearr($name.'_wireless', $arr, $del, true);
370   # um die "yes" abfrage zu vermeiden  }
371   $hostfile = fopen ($home."/.ssh/known_hosts","w");  function parsearrs($name, $arr)
372   fwrite($hostfile,$conn['ip']." ".$row[0],strlen($row[0])+strlen($conn['ip'])+1);  {
373   fclose($hostfile);   foreach($arr as $k=>$a)
374     parsearr($name.'_'.$k, $a, true);
375   $osver = exec($sshcmd.' '.$conn['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}"\'');  }
376   $osver = explode(':',$osver);  
377   }  ?><head>
378   if($osver[0] == '') $osver[0]='unkown';  <title>ALX Config</title>
379   if($osver[1] == '') $osver[1]='unkown';  <style>
380                   echo '<u>OS:</u> '.$osver[0].'<br>';   body,table { font-family:Tahoma; font-size:10pt }
381                   echo '<u>Utils:</u> '.$osver[1].'<br>';   a { color:#000000; text-decoration:none; }
382     .key { width:85px }
383   if($osver[0] <> 'unkown')   .keytab, input, textarea, select, option { font-size:8pt; font-family:Tahoma }
384   {   .but { font-size:10pt; font-family:Tahoma; height:23px }
385   //write them to database  </style>
386   }  <script type="text/javascript" src="js/jquery-1.2.6.min.js"></script>
387   }  <script language="JavaScript" src="openclose_ajax.js"></script>
388    <script language="JavaScript">
389   echo '</b></div>';  
390   //echo '<br><br>';   // opens an url and shows retval in a javascript-alert on current site
391     function urlopen(url,typ) {
392   if($state=='On')   var $url = url.split("?");
393   {   $.ajax({type:""+typ+"",url:$url[0],data:$url[1],cache:false,success:function(data){ alert(data); }});
394   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>';   }
395   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>';   function plugin(name,id) { window.open('plugin.php?plugin='+name+'&id='+id, '', 'width=350,height=180'); }
396   echo '<br>';  
397                   echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff" align="center"><b>';  /* ignore this atm, not always working, sometime open does not work
398                  echo 'Remote Shadow:</b></div>';   function openclose(nummer, act)
399   echo '<input class="but" type=button value="VNC" style="width:150px" onclick="window.open(\'vncviewer.php?ip='.$conn['ip'].'\', \'VncViewer\', \'width=200,height=100\')"><br>';   {
400   echo '<br>';   var bild = document.images['sch_bild_'+nummer];
401                   echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff" align="center"><b>';   var absatz = document.all['sch_absatz_'+nummer].style;
402                  echo 'Client Update:</b></div>';   var senden = false;
403   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>';  
404   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>';   $("#sch_absatz_"+nummer).toggle(0, function(){
405   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\')"><br>';                                         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'});}
406   }   });
407   else   if(act<=1){ $("#sch_bild_"+nummer).attr({title:'CLOSE',src:'pics/minus.gif'}); }else{ $("#sch_bild_"+nummer).attr({title:'OPEN',src:'pics/plus.gif'}); };
408   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>';   }
409    */
410   echo '<br><center><a href="share/ChangeLog.html" target="_blank">[ChangeLog]</a> <a href="share/FAQ.html" target="_blank">[FAQs]</a></center>';   function openclose(nummer, act)
411     {
412   echo '</td></tr></table>';   var bild = document.images['sch_bild_'+nummer];
413   echo '</form>';   var absatz = document.all['sch_absatz_'+nummer].style;
414  ?>   var senden = false;
415    
416     if(bild.title == 'OPEN')
417     {
418     if(act<=1)
419     {
420     absatz.visibility = 'visible';
421     absatz.position = '';
422     bild.title = 'CLOSE';
423     bild.src = 'pics/minus.gif';
424     senden = true;
425     act = 0;
426     }
427     }
428     else
429     {
430     if(act>=1)
431     {
432     absatz.visibility = 'hidden';
433     absatz.position = 'absolute';
434     bild.title = 'OPEN';
435     bild.src = 'pics/plus.gif';
436     senden = true;
437     act = 2;
438     }
439     }
440    
441     if(senden) sendopenclose(nummer,act);
442     }
443    
444     function showhelp(name)
445     { window.open(name, 'HelpWin', 'width=620,height=500,scrollbars=yes'); }
446    
447    </script>
448    </head>
449    
450    <body><?
451    
452    echo '<form action="show.php" method="post" onreset="return confirm(\'UNDO CHANGES?\')">';
453    echo '<input type=hidden name="do_upl" value="1">';
454    echo '<input type=hidden name="id" value="'.$id.'">';
455    
456    // ANZEIGEN => NON-MULTI TABELLEN
457    echo '<table><tr><td valign=top width="300">';
458    
459     echo '<b style="font-size:6pt">';
460     echo '<a href="JavaScript:opencloseall(0);" title="OPEN ALL"><img src="pics/plus.gif" border="0"> OPEN...</a> ';
461     echo '<a href="JavaScript:opencloseall(2);" title="CLOSE ALL"><img src="pics/minus.gif" border="0"> CLOSE...</a> ALL';
462     echo '</b><br><br>';
463    
464     foreach($tabs as $k=>$t) if(!$multi[$k]) parsearr($t, $data[$t]);
465    
466    // ANZEIGEN => MULTI TABELLEN
467    echo '</td><td valign=top width="300">';
468    
469     foreach($tabs as $k=>$t) if($multi[$k]) parsearrs($t, $data[$t]);
470    
471     echo '<script language="JavaScript">';
472     echo 'function opencloseall(act) { ';
473    
474     foreach($absnames as $absname)
475     echo 'openclose("'.$absname.'", act); ';
476    
477     echo '}</script>';
478    
479    // ANZEIGEN => NAVI
480    echo '</td><td valign=top>';
481    
482     // STATUS BESTIMMEN (ON/OFF)
483     $conn = sqlfirst('SELECT * FROM state_connected WHERE serial='.$id);
484     $state = 'Off';
485     if(count($conn)>0)
486     {
487     if($retval==0) $state = 'On';
488     }
489    
490     echo '<img src="pics/logo2.jpg"><br><br>';
491    
492     echo '<input class="but" type=submit value="SAVE" style="width:150px"><br><br>';
493    
494     echo '<input class="but" type=submit name="do_add" value="SAVE+ADD COMMENT" style="width:150px"><br>';
495     echo '<input class="but" type=submit name="do_add" value="SAVE+ADD PRINTER" style="width:150px"><br>';
496     echo '<input class="but" type=submit name="do_add" value="SAVE+ADD SESSION" style="width:150px"><br>';
497     echo '<input class="but" type=submit name="do_add" value="SAVE+ADD MODULE" style="width:150px"><br>';
498     echo '<input class="but" type=submit name="do_add" value="SAVE+ADD MENUITEM" style="width:150px"><br>';
499     if($alxos >= '0.6.0')
500     {
501     echo '<input class="but" type=submit name="do_add" value="INSTALL PLUGIN" style="width:150px"><br>';
502     }
503     echo '<br>';
504    
505     if($id>0) $KILLCAP='DEACTIVATE'; else $KILLCAP='ACTIVATE';
506     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>';
507     echo '<input class="but" type=button value="IMPORT FROM..." style="width:150px" onclick="location.href=\'import.php?id='.$id.'\'"><br>';
508     echo '<input class="but" type=reset value="UNDO CHANGES" style="width:150px"><br><br>';
509    
510     $davor  = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id-1),'mac')!=null; if($davor) $disdavor=''; else $disdavor = 'disabled=1';
511     $danach = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id+1),'mac')!=null; if($danach) $disdanach=''; else $disdanach = 'disabled=1';
512    
513     echo '<input class="but" type=button '.$disdavor.' value="<" style="width:30px" onclick="location.href=\'show.php?id='.($id-1).'\'">';
514     echo '<input class="but" type=button value="REFRESH" style="width:90px" onclick="location.href=\'show.php?id='.$id.'\'">';
515     echo '<input class="but" type=button '.$disdanach.' value=">" style="width:30px" onclick="location.href=\'show.php?id='.($id+1).'\'">';
516     echo '<br><input class="but" type=button value="INDEX" style="width:150px; font-weight:bold" onclick="location.href=\'index.php\'"><br><br>';
517    
518     echo '<br>';
519     echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff"><b>';
520     if($id<0) echo '<b>DEACTIVATED!</b><br><br>';
521     echo '<u>Serial:</u>&nbsp;&nbsp;#'.$id.'<br>';
522     echo '<u>Stand:</u>&nbsp;&nbsp;'.date('H:i:s').'<br>';
523     echo '<u>Status:</u> <img src="pics/'.strtolower($state).'line.gif" align=top> '.$state.'line<br>';
524     if($state=='On')
525     {
526     echo '<u>IP:</u> '.$conn['ip'].'<br><br>';
527     if($alxos >= '0.6.0')
528     {
529     $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']);
530     }
531     else
532     {
533     $osver = @sshdo('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}"', $conn['ip']);
534     }
535     $osver = explode(':',$osver[1]);
536     if($osver[0] == '') $osver[0]='unknown';
537     if($osver[1] == '') $osver[1]='unknown';
538    
539     # update os string in database
540     if($alxos == '' && $osver[0] >= '0.5.3')
541     {
542     mysql_query('insert into client_version(serial,os,utils) values("'.$id.'","'.$osver[0].'","'.$osver[1].'")
543     on duplicate key update os="'.$osver[0].'", utils="'.$osver[1].'"');
544     # reload the site
545     echo '<script type="text/javascript">setTimeout(\'window.location.reload()\',0);</script>';
546     }
547    
548     echo '<u>OS:</u> '.$osver[0].'<br>';
549     echo '<u>Utils:</u> '.$osver[1].'<br>';
550    
551     if($osver[0] <> 'unknown')
552     {
553     //write them to database
554     }
555     }
556    
557     echo '</b></div>';
558    
559     if($state=='On')
560     {
561     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>';
562     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>';
563     echo '<br>';
564    
565     if($alxos >= '0.6.0')
566     {
567     echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff" align="center"><b>';
568     echo 'Hardware Detection:</b></div>';
569     echo '<input class="but" type=button value="LAN" style="width:50px" onclick="javascript:urlopen(\'include/hwinfo.php?ip='.$conn['ip'].'&cmd=lan\',\'POST\');">';
570     echo '<input class="but" type=button value="WLAN" style="width:50px" onclick="javascript:urlopen(\'include/hwinfo.php?ip='.$conn['ip'].'&cmd=wlan\',\'POST\');">';
571     echo '<input class="but" type=button value="VGA" style="width:50px" onclick="javascript:urlopen(\'include/hwinfo.php?ip='.$conn['ip'].'&cmd=vga\',\'POST\');">';
572     echo '<br>';
573     echo '<input class="but" type=button value="PRN" style="width:50px" onclick="javascript:urlopen(\'include/hwinfo.php?ip='.$conn['ip'].'&cmd=printer\',\'POST\');">';
574     echo '<input class="but" type=button value="HRDW" style="width:50px" onclick="javascript:urlopen(\'include/hwinfo.php?ip='.$conn['ip'].'&cmd=system\',\'POST\');">';
575     echo '<br><br>';
576     }
577    
578     echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff" align="center"><b>';
579     echo 'Remote Shadow:</b></div>';
580     echo '<input class="but" type=button value="VNC" style="width:75px" onclick="window.open(\'vncviewer.php?ip='.$conn['ip'].'\', \'VncViewer\', \'width=200,height=100\')">';
581     echo '<input class="but" type=button value="SSH" style="width:75px" onclick="window.open(\'mindterm.php?ip='.$conn['ip'].'\', \'MindTerm\', \'width=200,height=100\')">';
582     echo '<br><br>';
583     echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff" align="center"><b>';
584     echo 'Client Update:</b></div>';
585     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>';
586     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>';
587     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>';
588     }
589     else
590     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>';
591    
592     echo '<br><center><a href="share/ChangeLog.html" target="_blank">[ChangeLog]</a> <a href="share/FAQ.html" target="_blank">[FAQs]</a></center>';
593    
594    echo '</td></tr></table>';
595    echo '</form>';
596    ?>

Legend:
Removed from v.1608  
changed lines
  Added in v.4897