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 1610 by niro, Thu Dec 2 23:02:19 2010 UTC alx-src/branches/alx-web-070/show.php revision 8512 by niro, Mon Feb 8 09:19:00 2016 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    $tabs = array('cfg_graphic', 'cfg_network', 'cfg_input', 'client_auth', 'cfg_autostart', 'client_serials', 'cfg_comments', 'cfg_printers', 'cfg_sessions_citrix', 'cfg_sessions_storefront', 'cfg_sessions_rdesktop', 'cfg_modules', 'cfg_other_menuitems', 'cfg_screensaver', 'client_version');
10    $multi= array( 0, 0, 0, 0, 1, 0, 1, 1, 1, 1, 1, 1, 1, 0, 0);
11    $data = array();
12    
13    // get alx version info for
14    $alxinfo = sqlfirst('SELECT * FROM client_version WHERE serial='.$id);
15    $alxos = $alxinfo[os];
16    $alxutils = $alxinfo[utils];
17    
18    // get gfxdriver
19    $gfxinfo = sqlfirst('SELECT * FROM cfg_graphic WHERE serial='.$id);
20    
21    if($kill==1)
22    {
23     if($method=='DEACTIVATE') mysql_query('UPDATE client_serials SET enabled="0" WHERE serial='.$id);
24     else mysql_query('UPDATE client_serials SET enabled="1" WHERE serial='.$id);
25    
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    
29   // get alx version info for   if($method=='DEACTIVATE') echo 'DEACTIVATED #'.$id;
30   $alxinfo = sqlfirst('SELECT * FROM client_version WHERE serial='.$id);   else echo 'ACTIVATED #'.$id;
  $alxos = $alxinfo[os];  
  $alxutils = $alxinfo[utils];  
31    
32   if($kill==1)   echo '</td></tr></table>';
33   {   return true;
34   foreach($tabs as $t) mysql_query('UPDATE '.$t.' SET serial=-serial WHERE serial='.$id);  }
35    
36   echo '<body onload="window.setTimeout(\'window.close()\', 1750)">';  // FELD-DEFINITIONEN  (ARRAY=>DROPDOWN / HIDDEN / IGNORE / 1 / BOLD / PASSWORD / SHOW / SHOWTIME / MONITORID)
37   echo '<table width=100% height=100% style="border:solid black 1px; background-color:#d5e5ff"><tr><td valign=middle align=center>';  $drop = array();
38    $drop['cfg_graphic_module'] = sqlarr('SELECT value FROM values_graphic_module where enabled=1', '', 'value');
39    if($gfxinfo[module] == 'intel')
40    {
41     $drop['cfg_graphic_hdmi'] = array('disable', 'enable');
42    }
43    else
44    {
45     $drop['cfg_graphic_hdmi'] = 'ignore';
46    }
47    $drop['resolution'] = sqlarr('SELECT value FROM values_graphic_resolution where enabled=1', '', 'value');
48    $drop['depth'] = sqlarr('SELECT value FROM values_graphic_depth where enabled=1', '', 'value');
49    //$drop['mouse'] = array('Auto', 'IMPS/2', 'PS/2');
50    //$drop['keyboard'] = array('PC105');
51    $drop['keymap'] = sqlarr('SELECT value FROM values_input_keymap where enabled=1', '', 'value');
52    $drop['cfg_network_module'] = sqlarr('SELECT value FROM values_network_module where enabled=1', '', 'value');
53    $drop['networking'] = array('dhcp', 'static');
54    $drop['port'] = sqlarr('SELECT value FROM values_printers_port where enabled=1', '', 'value');
55    //for ($i=0; $i<999; $i++) { $drop['cfg_printers_'.$i.'_ip'] = 'ignore'; }
56    $drop['share'] = 'ignore';
57    $drop['location'] = sqlarr('SELECT location FROM client_locations where enabled=1', '', 'location');
58    $drop['id'] = 'hidden';
59    $drop['flg_modified'] = '1';
60    $drop['serial'] = 'ignore';
61    $drop['monitorid'] = 'ignore';
62    $drop['refresh_rate'] = sqlarr('SELECT value FROM values_graphic_refresh_rate where enabled=1', '', 'value');
63    $drop['hostname'] = 'bold';
64    $drop['session'] = 'bold';
65    $drop['cfg_autostart_session'] = sqlarr('SELECT filename FROM cfg_sessions_citrix where serial='.$id, '', 'filename');
66    array_unshift($drop['cfg_autostart_session'], "");
67    $drop['mtime'] = 'showtime';
68    $drop['mac'] = 'show';
69    $drop['client_serials_serial'] = 'show';
70    $drop['password'] = 'password';
71    //$drop['shell'] = 'password';
72    $drop['client_auth_user'] = 'password';
73    $drop['root'] = 'password';
74    $drop['vnc'] = 'password';
75    $drop['samba'] = 'password';
76    $drop['station'] = 'password';
77    $drop['txt'] = 'txt';
78    $drop['screensaver'] = sqlarr('SELECT value FROM values_screensaver_screensaver where enabled=1', '', 'value');
79    //$drop['iface'] = array('eth0', 'wlan0');
80    $drop['client_version_os'] = 'show';
81    $drop['client_version_utils'] = 'show';
82    $drop['hwdetected'] = 'ignore';
83    
84    // ACHTUNG!!! wlan_-Felder heißen eigentlich wireless_
85    $drop['wireless_mode'] = array('', 'managed', 'ad-hoc', 'master', 'repeater', 'secondary', 'monitor', 'auto');
86    $drop['wireless_auth_mode'] = array('', 'wep', 'wpa', 'wpa2', 'off');
87    $drop['wireless_key_length'] = array('', '64', '128', '256');
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',
90     '2.447G', '2.452G', '2.457G', '2.462G', '2.467G', '2.472G', '2.484G');
91    $drop['wireless_key'] = 'password';
92    $drop['wireless_key_ascii'] = 'password';
93    
94    // get current citrix apps
95    $citrix_apps = sqlarr('SELECT session FROM values_citrix_session where enabled=1', '', 'session');
96    // add an empty value add the first position of the array as session-default
97    array_unshift($citrix_apps, "");
98    // hackish, fix me
99    for ($i=0; $i<999; $i++) { $drop['cfg_sessions_citrix_'.$i.'_session'] = $citrix_apps; }
100    
101    // get current storefront apps
102    $storefront_apps = sqlarr('SELECT session FROM values_storefront_session where enabled=1', '', 'session');
103    // add an empty value add the first position of the array as session-default
104    array_unshift($storefront_apps, "");
105    // hackish, fix me
106    for ($i=0; $i<999; $i++) { $drop['cfg_sessions_storefront_'.$i.'_session'] = $storefront_apps; }
107    
108    $drop['enabled'] = 'ignore';
109    $drop['filename'] = 'ignore';
110    $drop['autostart'] = array('0','1');
111    
112    // GGF. NEUEN DATENSATZ EINFÃœGEN
113    if(isset($_POST['do_add']))
114    {
115     list($bla,$what) = explode(' ',$_POST['do_add']);
116     if($what=='COMMENT') sqladd('cfg_comments', array('serial'=>$id));
117     else if($what=='PRINTER') sqladd('cfg_printers', array('serial'=>$id));
118     else if($what=='MODULE') sqladd('cfg_modules', array('serial'=>$id));
119     else if($what=='SESSION-CITRIX') sqladd('cfg_sessions_citrix', array('domain'=>$citrix_domain_name, 'serverlist'=>$citrix_serverlist, 'serial'=>$id));
120     else if($what=='SESSION-STOREFRONT') sqladd('cfg_sessions_storefront', array('domain'=>$storefront_domain_name, 'store'=>$storefront_store, 'serial'=>$id));
121     else if($what=='SESSION-RDP') sqladd('cfg_sessions_rdesktop', array('domain'=>$rdesktop_domain_name, 'server'=>$rdesktop_server, 'serial'=>$id));
122     else if($what=='MENUITEM') sqladd('cfg_other_menuitems', array('serial'=>$id));
123     else if($what=='AUTOSTART') sqladd('cfg_autostart', array('serial'=>$id));
124    }
125    
126    
127    // GGF. SPEICHERN
128    if($_POST['do_upl'])
129    {
130     function postarr($prefix)
131     {
132     $prefix.='_';
133     $prelen = strlen($prefix);
134    
135   if($id<0) echo 'ACTIVATED #'.abs($id);   $arr = array();
136   else echo 'DEACTIVATED #'.$id;   foreach($_POST as $k=>$v)
137     {
138     if((substr($k,0,$prelen)==$prefix) && ($v!='KEEPPASS'))
139     $arr[substr($k,$prelen)] = stripslashes($v);
140     }
141    
142   echo '</td></tr></table>';   return $arr;
  return true;  
143   }   }
144    
145   // FELD-DEFINITIONEN  (ARRAY=>DROPDOWN / HIDDEN / IGNORE / 1 / BOLD / PASSWORD / SHOW / SHOWTIME / MONITORID)   foreach($tabs as $k=>$t)
  $drop = array();  
  if($alxos >= '0.5.3')  
  {  
  $drop['cfg_graphic_module'] = array('vesa', 'ati', 'cirrus', 'i710', 'intel', 'nv', 'mga', 'r128', 'radeon', 's3', 's3virge', 'savage', 'sis', 'trident', 'tseng', 'via');  
  }  
  else  
146   {   {
147   $drop['cfg_graphic_module'] = array('vesa', 'ati', 'cirrus', 'i810', 'i710', 'nv', 'mga', 'r128', 'radeon', 's3', 's3virge', 'savage', 'sis', 'trident', 'tseng', 'via');   if(!$multi[$k]) mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t)).' WHERE serial='.$id);
148     else
149     {
150     $i=0;
151     while(isset($_POST[$t.'_'.$i.'_id']))
152     {
153     if($_POST[$t.'_'.$i.'_delete'])
154     mysql_query('DELETE FROM '.$t.' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);
155     else
156     mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t.'_'.$i)).' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);
157     $i++;
158     }
159     }
160   }   }
161   $drop['resolution'] = array('640x480', '800x600', '1024x768', '1280x960', '1280x1024', '1360x768', '1366x768', '1400x1050', '1440x900', '1600x1200', '1680x1050');  
162   $drop['depth'] = array('24', '16', '8');   // reload site
163   $drop['mouse'] = array('Auto', 'IMPS/2', 'PS/2');   header("location: show.php?id=".$id);
164   $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');  }
165   $drop['networking'] = array('dhcp', 'static');  
166   $drop['port'] = array('lpt1', 'usb1', 'usb2', 'com1', 'com2', 'lpd', 'socket', 'ipp');  // EINLESEN DER DATEN AUS SQL-TABELLEN
167   $drop['location'] = sqlarr('SELECT location FROM client_locations', '', 'location');  foreach($tabs as $k=>$t)
168   $drop['id'] = 'hidden';  {
169   $drop['flg_modified'] = '1';   if($multi[$k]) $data[$t] = sqlarr('SELECT * FROM '.$t.' WHERE serial='.$id);
170   $drop['serial'] = 'ignore';   else $data[$t] = sqlfirst('SELECT * FROM '.$t.' WHERE serial='.$id);
171   if($alxos>='0.5.3')  }
172   {  
173   $drop['monitorid'] = 'ignore';  // ANZEIGEN - KLAPPFUNKTIONEN
174   $drop['refresh_rate'] = array('','60','75','85','100');  $absnames = array();
175    
176    function openabs($heading, $helpfile='')
177    {
178     global $absnames;
179     $absnames[] = $heading;
180    
181     // <AufZuLink> <Bild/> <Heading/> </AufZuLink><BR/> <Absatz>
182    
183     if( $_SESSION['openclose'][$heading] )
184     {
185     echo '<a href="JavaScript:openclose(\''.$heading.'\',1);"><img border="0" src="pics/minus.gif" title="CLOSE" id="sch_bild_'.$heading.'"> <b>['.$heading.']</b></a>';
186     if($helpfile!='') echo ' <a href="JavaScript:showhelp(\''.$helpfile.'\')" title="HELP">[?]</a>';
187     echo '<br><div id="sch_absatz_'.$heading.'" style="top:0px; visibility:visible">';
188   }   }
189   else   else
190   {   {
191   $drop['monitorid'] = 'monitorid';   echo '<a href="JavaScript:openclose(\''.$heading.'\',1);"><img border="0" src="pics/plus.gif" title="OPEN" id="sch_bild_'.$heading.'"> <b>['.$heading.']</b></a>';
192   $drop['refresh_rate'] = 'ignore';   if($helpfile!='') echo ' <a href="JavaScript:showhelp(\''.$helpfile.'\')" title="HELP">[?]</a>';
193     echo '<br><div id="sch_absatz_'.$heading.'" style="position:absolute; top:0px; visibility:hidden">';
194   }   }
195   $drop['hostname'] = 'bold';  }
  $drop['session'] = 'bold';  
  $drop['cfg_autostart_session'] = 'filename';  
  $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', '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';  
196    
197   // GGF. NEUEN DATENSATZ EINFÜGEN  function closeabs()
198   if(isset($_POST['do_add']))  {
199   {   // </Absatz> <BR/>
200   list($bla,$what) = explode(' ',$_POST['do_add']);   echo '</div><br>';
201   if($what=='COMMENT') sqladd('cfg_comments', array('serial'=>$id));  }
202   else if($what=='PRINTER') sqladd('cfg_printers', array('serial'=>$id));  
203   else if($what=='MODULE') sqladd('cfg_modules', array('serial'=>$id));  // ANZEIGEN
  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));  
  else if($what=='MENUITEM') sqladd('cfg_other_menuitems', array('serial'=>$id));  
  }  
204    
205    function parsearr($name, $arr, $del=false, $wireless=false)
206    {
207     global $drop;
208     global $id;
209     global $alxos;
210    
211   // GGF. SPEICHERN   $parts = explode('_',$name); $helpfile='help.php?page='.$parts[1];
212   if($_POST['do_upl'])   openabs($name, $helpfile);
213     echo '<table class="keytab">';
214    
215     foreach($arr as $k=>$v)
216   {   {
217   function postarr($prefix)   if( (substr($k,0,9)=='wireless_') xor $wireless ) Continue;
  {  
  $prefix.='_';  
  $prelen = strlen($prefix);  
218    
219   $arr = array();   $d = $drop[$name.'_'.$k]; if($d==null) $d = $drop[$k];
220   foreach($_POST as $k=>$v)   $k = str_replace('wireless_', '', $k);
221   if((substr($k,0,$prelen)==$prefix) && ($v!='KEEPPASS'))   $k2 = $k;
  $arr[substr($k,$prelen)] = stripslashes($v);  
222    
223   return $arr;   # tell something about vesa
224   }   if ($v == 'vesa') echo '<br><font color="#FF0000">Warning: "vesa" graphic module doesn\'t support any resolutions higher than 1024x786x16@60hz!</font><br>';
225    
226   foreach($tabs as $k=>$t)   if(is_array($d))
227   {   {
228   if(!$multi[$k]) mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t)).' WHERE serial='.$id);   echo '<tr><td class="key">'.$k2.'</td><td>= <select style="width:144px" name="'.$name.'_'.$k.'">';
229   else   foreach($d as $di) if($v==$di) echo '<option selected>'.$di; else echo '<option>'.$di;
230   {   echo '</select></td></tr>';
  $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++;  
  }  
  }  
231   }   }
232   }   else if($d=='hidden') echo '<tr><td colspan=2><input type=hidden name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';
233     else if($d=='1') echo '<tr><td colspan=2><input type=hidden name="'.$name.'_'.$k.'" value="1"></td></tr>';
234     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>';
235     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>';
236     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>';
237     else if($d=='show') echo '<tr><td class="key">'.$k2.'</td><td>= <b>'.$v.'</b></td></tr>';
238     else if($d=='showtime') echo '<tr><td class="key">'.$k2.'</td><td>= <b>'.date('d.m.y - H:i:s', $v).'</b></td></tr>';
239     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>';
240     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>';
241     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>';
242     else if($d!='ignore') echo '<tr><td class="key">'.$k2.'</td><td>= <input style="width:144px" name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';
243     }
244    
245     if($del) echo '<tr><td class="key">delete</td><td>=<input type=checkbox name="'.$name.'_delete" value="1"></td></tr>';
246     echo '</table>';
247     closeabs();
248    
249     if($name=='cfg_network' && !$wireless) parsearr($name.'_wireless', $arr, $del, true);
250    }
251    
252    function parsearrs($name, $arr)
253    {
254     foreach($arr as $k=>$a)
255     parsearr($name.'_'.$k, $a, true);
256    }
257    
258    ?><head>
259    <title>ALX Config</title>
260    <style>
261     body,table { font-family:Tahoma; font-size:10pt }
262     a { color:#000000; text-decoration:none; }
263     .key { width:85px }
264     .keytab, input, textarea, select, option { font-size:8pt; font-family:Tahoma }
265     .but { font-size:10pt; font-family:Tahoma; height:23px }
266    </style>
267    <script type="text/javascript" src="js/jquery-1.2.6.min.js"></script>
268    <script language="JavaScript" src="openclose_ajax.js"></script>
269    <script language="JavaScript">
270    
271     // opens an url and shows retval in a javascript-alert on current site
272     function urlopen(url,typ) {
273     var $url = url.split("?");
274     $.ajax({type:""+typ+"",url:$url[0],data:$url[1],cache:false,success:function(data){ alert(data); }});
275     }
276    
277     function openclose(nummer, act)
278     {
279     var bild = document.images['sch_bild_'+nummer];
280     var absatz = document.all['sch_absatz_'+nummer].style;
281     var senden = false;
282    
283   // EINLESEN DER DATEN AUS SQL-TABELLEN   if(bild.title == 'OPEN')
  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] )  
284   {   {
285   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(act<=1)
286   if($helpfile!='') echo ' <a href="JavaScript:showhelp(\''.$helpfile.'\')" title="HELP">[?]</a>';   {
287   echo '<br><div id="sch_absatz_'.$heading.'" style="top:0px; visibility:visible">';   absatz.visibility = 'visible';
288     absatz.position = '';
289     bild.title = 'CLOSE';
290     bild.src = 'pics/minus.gif';
291     senden = true;
292     act = 0;
293     }
294   }   }
295   else   else
296   {   {
297   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(act>=1)
298   if($helpfile!='') echo ' <a href="JavaScript:showhelp(\''.$helpfile.'\')" title="HELP">[?]</a>';   {
299   echo '<br><div id="sch_absatz_'.$heading.'" style="position:absolute; top:0px; visibility:hidden">';   absatz.visibility = 'hidden';
300     absatz.position = 'absolute';
301     bild.title = 'OPEN';
302     bild.src = 'pics/plus.gif';
303     senden = true;
304     act = 2;
305     }
306   }   }
307     if(senden) sendopenclose(nummer,act);
308   }   }
   
  function closeabs()  
  {  
  // </Absatz> <BR/>  
   
  echo '</div><br>';  
  }  
   
309    
310   // ANZEIGEN   function showhelp(name)
311     { window.open(name, 'HelpWin', 'width=620,height=500,scrollbars=yes'); }
  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">';  
312    
313   foreach($arr as $k=>$v)  </script>
314   {  </head>
  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;  
315    
316   //replace i810 with intel on 0.5.3 or higher  <body><?
  if($alxos >= '0.5.3' && $v == 'i810')  
  {  
  echo '<br><font color="#FF0000">Replaced "i810" with "intel" - Please press SAVE!</font><br>';  
  $v='intel';  
  }  
317    
318   if(is_array($d))  echo '<form action="show.php" method="post" onreset="return confirm(\'UNDO CHANGES?\')">';
319   {  echo '<input type=hidden name="do_upl" value="1">';
320   echo '<tr><td class="key">'.$k2.'</td><td>= <select style="width:144px" name="'.$name.'_'.$k.'">';  echo '<input type=hidden name="id" value="'.$id.'">';
  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=='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=4 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>';  
  }  
321    
322   if($del) echo '<tr><td class="key">delete</td><td>=<input type=checkbox name="'.$name.'_delete" value="1"></td></tr>';  // ANZEIGEN => NON-MULTI TABELLEN
323   echo '</table>';  echo '<table><tr><td valign=top width="300">';
  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);  
  }  
324    
325   ?><head>   echo '<b style="font-size:6pt">';
326   <title>ALX Config</title>   echo '<a href="JavaScript:opencloseall(0);" title="OPEN ALL"><img src="pics/plus.gif" border="0"> OPEN...</a> ';
327   <style>   echo '<a href="JavaScript:opencloseall(2);" title="CLOSE ALL"><img src="pics/minus.gif" border="0"> CLOSE...</a> ALL';
328   body,table { font-family:Tahoma; font-size:10pt }   echo '</b><br><br>';
  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 language="JavaScript" src="openclose_ajax.js"></script>  
  <script language="JavaScript">  
   
  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 '<body style="background-image:URL(logo.jpg);background-repeat:no-repeat; background-position:0px 0px; margin-top:25px">';  
  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)  
  {  
 // passthru($pingcmd." ".$conn['ip']." &> /dev/null && exit 0 || exit 1",$retval);  
  if($retval==0) $state = 'On';  
  }  
329    
330     foreach($tabs as $k=>$t) if(!$multi[$k]) parsearr($t, $data[$t]);
331    
332   echo '<img src="pics/logo2.jpg"><br><br>';  // ANZEIGEN => MULTI TABELLEN
333    echo '</td><td valign=top width="300">';
334    
335   echo '<input class="but" type=submit value="SAVE" style="width:150px"><br><br>';   foreach($tabs as $k=>$t) if($multi[$k]) parsearrs($t, $data[$t]);
336    
337   echo '<input class="but" type=submit name="do_add" value="SAVE+ADD COMMENT" style="width:150px"><br>';   echo '<script language="JavaScript">';
338   echo '<input class="but" type=submit name="do_add" value="SAVE+ADD PRINTER" style="width:150px"><br>';   echo 'function opencloseall(act) { ';
  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><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><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>';  
  $pubkey = mysql_query('select public_key from ssh_auth_clients where serial='.$id.'');  
  while ($row = mysql_fetch_row ($pubkey)) {  
  # schreiben der .ssh/known_hosts file mit dem public rsa key des client,  
  # um die "yes" abfrage zu vermeiden  
  $hostfile = fopen ($home."/.ssh/known_hosts","w");  
  fwrite($hostfile,$conn['ip']." ".$row[0],strlen($row[0])+strlen($conn['ip'])+1);  
  fclose($hostfile);  
339    
340   $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}"\'');   foreach($absnames as $absname)
341   $osver = explode(':',$osver);   echo 'openclose("'.$absname.'", act); ';
342   }  
343   if($osver[0] == '') $osver[0]='unkown';   echo '}</script>';
  if($osver[1] == '') $osver[1]='unkown';  
                  echo '<u>OS:</u> '.$osver[0].'<br>';  
                  echo '<u>Utils:</u> '.$osver[1].'<br>';  
344    
345   if($osver[0] <> 'unkown')  // ANZEIGEN => NAVI
346    echo '</td><td valign=top>';
347    
348     // STATUS BESTIMMEN (ON/OFF)
349     $conn = sqlfirst('SELECT * FROM state_connected WHERE serial='.$id);
350     $state = 'Off';
351     if(count($conn)>0)
352     {
353     if($retval==0)
354     {
355     // first try mcore, then get ssh
356     $ping_retval = ping_host($conn['ip'],$mcore_port,$ping_timeout);
357     if($ping_retval==1) $ping_retval = ping_host($dat['ip'],$ssh_port,$ping_timeout);
358     if($ping_retval==0)
359   {   {
360   //write them to database   $state = 'On';
361   }   }
362   }   }
363     }
364    
365   echo '</b></div>';   echo '<img src="pics/logo2.jpg"><br><br>';
  //echo '<br><br>';  
366    
367   if($state=='On')   echo '<input class="but" type=submit value="SAVE" style="width:150px"><br><br>';
  {  
  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 'Remote Shadow:</b></div>';  
  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>';  
  echo '<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\')"><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>';  
368    
369   echo '<br><center><a href="share/ChangeLog.html" target="_blank">[ChangeLog]</a> <a href="share/FAQ.html" target="_blank">[FAQs]</a></center>';   echo '<input class="but" type=submit name="do_add" value="ADD COMMENT" style="width:150px"><br>';
370     echo '<input class="but" type=submit name="do_add" value="ADD PRINTER" style="width:150px"><br>';
371     echo '<input class="but" type=submit name="do_add" value="ADD SESSION-CITRIX" style="width:150px"><br>';
372     echo '<input class="but" type=submit name="do_add" value="ADD SESSION-STOREFRONT" style="width:150px"><br>';
373     echo '<input class="but" type=submit name="do_add" value="ADD SESSION-RDP" style="width:150px"><br>';
374     echo '<input class="but" type=submit name="do_add" value="ADD MODULE" style="width:150px"><br>';
375     echo '<input class="but" type=submit name="do_add" value="ADD MENUITEM" style="width:150px"><br>';
376     echo '<input class="but" type=submit name="do_add" value="ADD AUTOSTART" style="width:150px"><br>';
377     echo '<br>';
378    
379     $clientstatus = sqlfirst('SELECT * FROM client_serials WHERE serial='.$id);
380     if($clientstatus['enabled']>0) $KILLCAP='DEACTIVATE'; else $KILLCAP='ACTIVATE';
381     echo '<input class="but" type=button value="'.$KILLCAP.'" style="width:150px" onclick="if(confirm(\''.$KILLCAP.' CLIENT #'.$id.' ?\')) { window.open(\'show.php?id='.$id.'&kill=1&method='.$KILLCAP.'\', \'DeactWin\', \'width=200,height=100\'); location.href=\'index.php\'; }"><br>';
382     echo '<input class="but" type=button value="IMPORT FROM..." style="width:150px" onclick="location.href=\'import.php?id='.$id.'\'"><br>';
383     echo '<input class="but" type=reset value="UNDO CHANGES" style="width:150px"><br><br>';
384    
385     $davor  = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id-1),'mac')!=null; if($davor) $disdavor=''; else $disdavor = 'disabled=1';
386     $danach = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id+1),'mac')!=null; if($danach) $disdanach=''; else $disdanach = 'disabled=1';
387    
388     echo '<input class="but" type=button '.$disdavor.' value="<" style="width:30px" onclick="location.href=\'show.php?id='.($id-1).'\'">';
389     echo '<input class="but" type=button value="REFRESH" style="width:90px" onclick="location.href=\'show.php?id='.$id.'\'">';
390     echo '<input class="but" type=button '.$disdanach.' value=">" style="width:30px" onclick="location.href=\'show.php?id='.($id+1).'\'">';
391     echo '<br><input class="but" type=button value="INDEX" style="width:150px; font-weight:bold" onclick="location.href=\'index.php\'"><br><br>';
392    
393     echo '<br>';
394     echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff"><b>';
395     if($id<0) echo '<b>DEACTIVATED!</b><br><br>';
396     echo '<u>Serial:</u>&nbsp;&nbsp;#'.$id.'<br>';
397     echo '<u>Stand:</u>&nbsp;&nbsp;'.date('H:i:s').'<br>';
398     echo '<u>Status:</u> <img src="pics/'.strtolower($state).'line.gif" align=top> '.$state.'line<br>';
399     if($state=='On')
400     {
401     echo '<u>IP:</u> '.$conn['ip'].'<br>';
402     if($conn['netboot'] == 1) echo '<u>Boot:</u> Netboot (PXE)<br>';
403     else echo '<u>Boot:</u> Local Disk<br>';
404     echo '<br>';
405     echo '<u>OS:</u> '.$alxos.'<br>';
406     echo '<u>Utils:</u> '.$alxutils.'<br>';
407     }
408    
409     echo '</b></div>';
410    
411     if($state=='On')
412     {
413     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>';
414     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=shutdown\', \'ShutdownWin\', \'width=200,height=100\')"><br>';
415     echo '<br>';
416     echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff" align="center"><b>';
417     echo 'Remote Shadow:</b></div>';
418     echo '<input class="but" type=button value="VNC" style="width:75px" onclick="window.open(\'vncviewer.php?ip='.$conn['ip'].'\', \'VncViewer\', \'width=200,height=100\')">';
419     echo '<input class="but" type=button value="SSH" style="width:75px" onclick="window.open(\'mindterm.php?ip='.$conn['ip'].'\', \'MindTerm\', \'width=200,height=100\')">';
420     }
421     else
422     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>';
423    
424   echo '</td></tr></table>';  echo '</td></tr></table>';
425   echo '</form>';  echo '</form>';
426  ?>  ?>

Legend:
Removed from v.1610  
changed lines
  Added in v.8512