Magellan Linux

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

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

revision 355 by niro, Mon Oct 10 19:42:06 2005 UTC revision 470 by niro, Thu Jun 5 22:04:21 2008 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');   $tabs = array('cfg_graphic', 'cfg_network', 'cfg_interfaces', 'cfg_input', 'client_auth', 'cfg_autostart', 'client_serials', 'cfg_comments', 'cfg_printers', 'cfg_sessions', 'cfg_modules', 'cfg_other_menuitems', 'cfg_screensaver');
5   $multi= array(    0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 0);   $multi= array(    0, 0,  1,   0, 0, 0, 0,   1,   1,   1,   1, 1,   0);
6   $data = array();   $data = array();
7    
8   if($kill==1)   if($kill==1)
# Line 22  Line 22 
22    
23   // FELD-DEFINITIONEN  (ARRAY=>DROPDOWN / HIDDEN / IGNORE / 1 / BOLD / PASSWORD / SHOW / SHOWTIME / MONITORID)   // FELD-DEFINITIONEN  (ARRAY=>DROPDOWN / HIDDEN / IGNORE / 1 / BOLD / PASSWORD / SHOW / SHOWTIME / MONITORID)
24   $drop = array();   $drop = array();
25   $drop['cfg_graphic_module'] = array('vesa', 'ati', 'cirrus', 'i810', 'i710', 'nv', 'mga', 'r128', 'radeon', 's3', 's3virge', 'sis', 'trident', 'tseng', 'via');   $drop['cfg_graphic_module'] = array('vesa', 'ati', 'cirrus', 'i810', 'i710', 'nv', 'mga', 'r128', 'radeon', 's3', 's3virge', 'sis', 'trident', 'tseng', 'via', 'vmware');
26   $drop['resolution'] = array('640x480', '800x600', '1024x768', '1280x1024', '1600x1200');   $drop['resolution'] = array('640x480', '800x600', '1024x768', '1280x1024','1360x768', '1366x768', '1600x1200');
27   $drop['depth'] = array('24', '16', '8');   $drop['depth'] = array('24', '16', '8');
28   $drop['mouse'] = array('Auto', 'IMPS/2', 'PS/2');   $drop['mouse'] = array('Auto', 'IMPS/2', 'PS/2');
29   $drop['cfg_network_module'] = array('3c59x', '8139too', '8139cp', 'e100', 'ne2k-pci', 'pcnet32', 'sis900', 'via-rhine', 'zd1211');   $drop['keyboard'] = array('kbd');
30     $drop['cfg_network_module'] = array('auto','3c59x', '8139too', '8139cp', 'e100', 'ne2k-pci', 'pcnet32', 'sis900', 'via-rhine', 'zd1211');
31   $drop['networking'] = array('dhcp', 'static');   $drop['networking'] = array('dhcp', 'static');
32   $drop['port'] = array('lpt1', 'com1', 'com2', 'lpd', 'socket');   $drop['default_iface'] = sqlarr('SELECT iface FROM cfg_interfaces where serial='.$id, '', 'iface');
33   $drop['location'] = array('', 'BO', 'HAT', 'LIN');   $drop['iface'] = 'show';
34     $drop['port'] = array('lpt1', 'com1', 'com2', 'lpd', 'socket', 'ipp');
35     $drop['location'] = sqlarr('SELECT location FROM client_locations', '', 'location');
36   $drop['id'] = 'hidden';   $drop['id'] = 'hidden';
37   $drop['flg_modified'] = '1';   $drop['flg_modified'] = '1';
38   $drop['serial'] = 'ignore';   $drop['serial'] = 'ignore';
39   $drop['monitorid'] = 'monitorid';   $drop['monitorid'] = 'monitorid';
40   $drop['hostname'] = 'bold';   $drop['hostname'] = 'bold';
41   $drop['session'] = 'bold';   $drop['session'] = 'bold';
42     $drop['displaymode'] = array('fullscreen', 'seamless', '1280x1024', '1024x768', '800x600');
43   $drop['cfg_autostart_session'] = 'filename';   $drop['cfg_autostart_session'] = 'filename';
44   $drop['mtime'] = 'showtime';   $drop['mtime'] = 'showtime';
45   $drop['mac'] = 'show';   $drop['mac'] = 'show';
# Line 56  Line 60 
60   'sierpinski', 'slip', 'solitare', 'space', 'sphere', 'spiral', 'spline', 'star', 'starfish', 'strange',   'sierpinski', 'slip', 'solitare', 'space', 'sphere', 'spiral', 'spline', 'star', 'starfish', 'strange',
61   'swarm', 'swirl', 't3d', 'tetris', 'thornbird', 'tik_tak', 'toneclock', 'triangle', 'tube', 'turtle',   'swarm', 'swirl', 't3d', 'tetris', 'thornbird', 'tik_tak', 'toneclock', 'triangle', 'tube', 'turtle',
62   'vines', 'voters', 'wator', 'wire', 'world', 'worm', 'xcl', 'xjack');   'vines', 'voters', 'wator', 'wire', 'world', 'worm', 'xcl', 'xjack');
63   $drop['iface'] = array('eth0', 'wlan0');  
64   $drop['wireless_mode'] = array('managed', 'ad-hoc', 'master', 'repeater', 'secondary', 'monitor', 'auto');  
65   $drop['wireless_auth_mode'] = array('wep', 'wpa', 'off');   // ACHTUNG!!! wlan_-Felder heißen eigentlich wireless_
66   //$drop['wireless_key_length'] = array('64', '128', '256');   $drop['wireless_mode'] = array('', 'managed', 'ad-hoc', 'master', 'repeater', 'secondary', 'monitor', 'auto');
67     $drop['wireless_auth_mode'] = array('', 'wep', 'wpa', 'off');
68     $drop['wireless_key_length'] = array('', '64', '128', '256');
69     $drop['wireless_channel'] = array('', '1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14');
70     $drop['wireless_frequency'] = array('', '2.412G', '2.417G', '2.422G', '2.427G', '2.432G', '2.437G', '2.442G',
71     '2.447G', '2.452G', '2.457G', '2.462G', '2.467G', '2.472G', '2.484G');
72     $drop['wireless_key'] = 'password';
73     $drop['wireless_key_ascii'] = 'password';
74    
75   // GGF. NEUEN DATENSATZ EINFÜGEN   // GGF. NEUEN DATENSATZ EINFÜGEN
76   if(isset($_POST['do_add']))   if(isset($_POST['do_add']))
# Line 91  Line 102 
102    
103   foreach($tabs as $k=>$t)   foreach($tabs as $k=>$t)
104   {   {
105   if(!$multi[$k]) mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t)).' WHERE serial='.$id);   if(!$multi[$k])
106     {
107     if(updatestr(postarr($t))='') $myupdatestr='NULL' else $myupdatestr=updatestr(postarr($t));
108     echo "debug1: '".$myupdatestr."'<br>";
109     //mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t)).' WHERE serial='.$id);
110     mysql_query('UPDATE '.$t.' SET '.$myupdatestr.' WHERE serial='.$id);
111     }
112   else   else
113   {   {
114   $i=0;   $i=0;
# Line 100  Line 117 
117   if($_POST[$t.'_'.$i.'_delete'])   if($_POST[$t.'_'.$i.'_delete'])
118   mysql_query('DELETE FROM '.$t.' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);   mysql_query('DELETE FROM '.$t.' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);
119   else   else
120   mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t.'_'.$i)).' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);   if(updatestr(postarr($t.'_'.$i)))='') $myupdatestr='NULL' else $myupdatestr=updatestr(postarr($t.'_'.$i)));
121     echo "debug2: '".$myupdatestr."'<br>";
122     //mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t.'_'.$i)).' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);
123     mysql_query('UPDATE '.$t.' SET '.$myupdatestr.' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);
124   $i++;   $i++;
125   }   }
126   }   }
# Line 118  Line 138 
138    
139    
140    
141   // ANZEIGEN   // ANZEIGEN - KLAPPFUNKTIONEN
142   function parsearr($name, $arr, $del=false)   $absnames = array();
143    
144     function openabs($heading, $helpfile='')
145     {
146     global $absnames;
147     $absnames[] = $heading;
148    
149     // <AufZuLink> <Bild/> <Heading/> </AufZuLink><BR/> <Absatz>
150    
151     if( $_SESSION['openclose'][$heading] )
152     {
153     echo '<a href="JavaScript:openclose(\''.$heading.'\',1);"><img border="0" src="pics/minus.gif" title="CLOSE" id="sch_bild_'.$heading.'"> <b>['.$heading.']</b></a>';
154     if($helpfile!='') echo ' <a href="JavaScript:showhelp(\''.$helpfile.'\')" title="HELP">[?]</a>';
155     echo '<br><div id="sch_absatz_'.$heading.'" style="top:0px; visibility:visible">';
156     }
157     else
158     {
159     echo '<a href="JavaScript:openclose(\''.$heading.'\',1);"><img border="0" src="pics/plus.gif" title="OPEN" id="sch_bild_'.$heading.'"> <b>['.$heading.']</b></a>';
160     if($helpfile!='') echo ' <a href="JavaScript:showhelp(\''.$helpfile.'\')" title="HELP">[?]</a>';
161     echo '<br><div id="sch_absatz_'.$heading.'" style="position:absolute; top:0px; visibility:hidden">';
162     }
163     }
164    
165     function closeabs()
166     {
167     // </Absatz> <BR/>
168    
169     echo '</div><br>';
170     }
171    
172    
173     // ANZEIGEN
174    
175     function parsearr($name, $arr, $del=false, $wireless=false)
176   {   {
177   global $drop;   global $drop;
178   global $id;   global $id;
179    
180   $parts = explode('_',$name); $helpfile='help.php?page='.$parts[1];   $parts = explode('_',$name); $helpfile='help.php?page='.$parts[1];
181   echo '<tr><td colspan=2 style="cursor:hand" onclick="window.open(\''.$helpfile.'\', \'HelpWin\', \'width=600,height=500,scrollbars=no\')"><b>['.$name.'] <font color=#626a88><tt>(?)</tt></font></b></td></tr>';   openabs($name, $helpfile);
182     echo '<table class="keytab">';
183    
184   foreach($arr as $k=>$v)   foreach($arr as $k=>$v)
185   {   {
186     //if( (substr($k,0,9)=='wireless_') xor $wireless ) Continue;
187    
188   $d = $drop[$name.'_'.$k]; if($d==null) $d = $drop[$k];   $d = $drop[$name.'_'.$k]; if($d==null) $d = $drop[$k];
189     //$k = str_replace('wireless_', '', $k);
190     $k2 = $k;
191    
192   if(is_array($d))   if(is_array($d))
193   {   {
194   echo '<tr><td>'.$k.'</td><td>= <select style="width:144px" name="'.$name.'_'.$k.'">';   echo '<tr><td>'.$k2.'</td><td>= <select style="width:144px" name="'.$name.'_'.$k.'">';
195   foreach($d as $di) if($v==$di) echo '<option selected>'.$di; else echo '<option>'.$di;   foreach($d as $di) if($v==$di) echo '<option selected>'.$di; else echo '<option>'.$di;
196   echo '</select></td></tr>';   echo '</select></td></tr>';
197   }   }
198   else if($d=='hidden') echo '<tr><td colspan=2><input type=hidden name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';   else if($d=='hidden') echo '<tr><td colspan=2><input type=hidden name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';
199   else if($d=='1') echo '<tr><td colspan=2><input type=hidden name="'.$name.'_'.$k.'" value="1"></td></tr>';   else if($d=='1') echo '<tr><td colspan=2><input type=hidden name="'.$name.'_'.$k.'" value="1"></td></tr>';
200   else if($d=='monitorid') echo '<tr><td>'.$k.'</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=='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>';
201   else if($d=='bold') echo '<tr><td>'.$k.'</td><td>= <input style="width:144px;font-weight:bold" name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';   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>';
202   else if($d=='filename') echo '<tr><td>filename</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>';
203   else if($d=='show') echo '<tr><td>'.$k.'</td><td>= <b>'.$v.'</b></td></tr>';   else if($d=='show') echo '<tr><td class="key">'.$k2.'</td><td>= <b>'.$v.'</b></td></tr>';
204   else if($d=='showtime') echo '<tr><td>'.$k.'</td><td>= <b>'.date('d.m.y - H:i:s', $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>';
205   else if($d=='password' && $v=='') echo '<tr><td>'.$k.'</td><td>= <input type=password style="width:144px" name="'.$name.'_'.$k.'" value=""></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>';
206   else if($d=='password') echo '<tr><td>'.$k.'</td><td>= <input type=password style="width:144px" name="'.$name.'_'.$k.'" value="KEEPPASS"></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>';
207   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=='txt') echo '<tr><td colspan=2><textarea style="width:240px; background-color:#d5e5ff" rows=4 name="'.$name.'_'.$k.'">'.$v.'</textarea></td></tr>';
208   else if($d!='ignore') echo '<tr><td>'.$k.'</td><td>= <input style="width:144px" name="'.$name.'_'.$k.'" value="'.$v.'"></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>';
209   }   }
210    
211   if($del) echo '<tr><td>delete</td><td>=<input type=checkbox name="'.$name.'_delete" value="1"></td></tr>';   if($del) echo '<tr><td class="key">delete</td><td>=<input type=checkbox name="'.$name.'_delete" value="1"></td></tr>';
212   echo '<tr height=30><td colspan=2></td></tr>';   echo '</table>';
213     closeabs();
214    
215     //if($name=='cfg_network' && !$wireless) parsearr($name.'_wireless', $arr, $del, true);
216   }   }
217   function parsearrs($name, $arr)   function parsearrs($name, $arr)
218   {   {
# Line 159  Line 220 
220   parsearr($name.'_'.$k, $a, true);   parsearr($name.'_'.$k, $a, true);
221   }   }
222    
223   echo '<head><title>ALX Config - Client #'.$id.'</title></head>';   ?><head>
224   echo '<body>';   <title>ALX Config</title>
225     <style>
226     body,table { font-family:Tahoma; font-size:10pt }
227     a { color:#000000; text-decoration:none; }
228     .key { width:85px }
229     .keytab, input, textarea, select, option { font-size:8pt; font-family:Tahoma }
230     .but { font-size:10pt; font-family:Tahoma; height:23px }
231     </style>
232     <script language="JavaScript" src="openclose_ajax.js"></script>
233     <script language="JavaScript">
234    
235     function openclose(nummer, act)
236     {
237     var bild = document.images['sch_bild_'+nummer];
238     var absatz = document.all['sch_absatz_'+nummer].style;
239     var senden = false;
240    
241     if(bild.title == 'OPEN')
242     {
243     if(act<=1)
244     {
245     absatz.visibility = 'visible';
246     absatz.position = '';
247     bild.title = 'CLOSE';
248     bild.src = 'pics/minus.gif';
249     senden = true;
250     act = 0;
251     }
252     }
253     else
254     {
255     if(act>=1)
256     {
257     absatz.visibility = 'hidden';
258     absatz.position = 'absolute';
259     bild.title = 'OPEN';
260     bild.src = 'pics/plus.gif';
261     senden = true;
262     act = 2;
263     }
264     }
265    
266     if(senden) sendopenclose(nummer,act);
267     }
268    
269     function showhelp(name)
270     { window.open(name, 'HelpWin', 'width=620,height=500,scrollbars=yes'); }
271    
272     </script>
273     </head>
274    
275     <body><?
276    
277    
278   //echo '<body style="background-image:URL(logo.jpg);background-repeat:no-repeat; background-position:0px 0px; margin-top:25px">';   //echo '<body style="background-image:URL(logo.jpg);background-repeat:no-repeat; background-position:0px 0px; margin-top:25px">';
279   echo '<form action="show.php" method=post onreset="return confirm(\'UNDO CHANGES?\')">';   echo '<form action="show.php" method=post onreset="return confirm(\'UNDO CHANGES?\')">';
280   echo '<input type=hidden name="do_upl" value="1">';   echo '<input type=hidden name="do_upl" value="1">';
281   echo '<input type=hidden name="id" value="'.$id.'">';   echo '<input type=hidden name="id" value="'.$id.'">';
282    
283   // ANZEIGEN => NON-MULTI TABELLEN   // ANZEIGEN => NON-MULTI TABELLEN
284   echo '<table><tr><td valign=top width=280>';   echo '<table><tr><td valign=top width="300">';
285    
286     echo '<b style="font-size:6pt">';
287     echo '<a href="JavaScript:opencloseall(0);" title="OPEN ALL"><img src="pics/plus.gif" border="0"> OPEN...</a> ';
288     echo '<a href="JavaScript:opencloseall(2);" title="CLOSE ALL"><img src="pics/minus.gif" border="0"> CLOSE...</a> ALL';
289     echo '</b><br><br>';
290    
  echo '<table cellpadding=0 cellspacing=0>';  
291   foreach($tabs as $k=>$t) if(!$multi[$k]) parsearr($t, $data[$t]);   foreach($tabs as $k=>$t) if(!$multi[$k]) parsearr($t, $data[$t]);
  echo '</table>';  
292    
293   // ANZEIGEN => MULTI TABELLEN   // ANZEIGEN => MULTI TABELLEN
294   echo '</td><td valign=top width=280>';   echo '</td><td valign=top width="300">';
295    
  echo '<table cellpadding=0 cellspacing=0>';  
296   foreach($tabs as $k=>$t) if($multi[$k]) parsearrs($t, $data[$t]);   foreach($tabs as $k=>$t) if($multi[$k]) parsearrs($t, $data[$t]);
297   echo '</table>';  
298     echo '<script language="JavaScript">';
299     echo 'function opencloseall(act) { ';
300    
301     foreach($absnames as $absname)
302     echo 'openclose("'.$absname.'", act); ';
303    
304     echo '}</script>';
305    
306   // ANZEIGEN => NAVI   // ANZEIGEN => NAVI
307   echo '</td><td valign=top>';   echo '</td><td valign=top>';
# Line 195  Line 318 
318    
319   echo '<img src="pics/logo2.jpg"><br><br>';   echo '<img src="pics/logo2.jpg"><br><br>';
320    
321   echo '<input type=submit value="SAVE" style="width:150px"><br><br>';   echo '<input class="but" type=submit value="SAVE" style="width:150px"><br><br>';
322    
323   echo '<input type=submit name="do_add" value="SAVE+ADD COMMENT" style="width:150px"><br>';   echo '<input class="but" type=submit name="do_add" value="SAVE+ADD COMMENT" style="width:150px"><br>';
324   echo '<input type=submit name="do_add" value="SAVE+ADD PRINTER" style="width:150px"><br>';   echo '<input class="but" type=submit name="do_add" value="SAVE+ADD PRINTER" style="width:150px"><br>';
325   echo '<input 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 SESSION" style="width:150px"><br>';
326   echo '<input 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 MODULE" style="width:150px"><br>';
327   echo '<input type=submit name="do_add" value="SAVE+ADD MENUITEM" style="width:150px"><br><br>';   echo '<input class="but" type=submit name="do_add" value="SAVE+ADD MENUITEM" style="width:150px"><br><br>';
328    
329    
330   if($id>0) $KILLCAP='DEACTIVATE'; else $KILLCAP='ACTIVATE';   if($id>0) $KILLCAP='DEACTIVATE'; else $KILLCAP='ACTIVATE';
331   echo '<input 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="'.$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>';
332   echo '<input type=button value="IMPORT FROM..." style="width:150px" onclick="location.href=\'import.php?id='.$id.'\'"><br>';   echo '<input class="but" type=button value="IMPORT FROM..." style="width:150px" onclick="location.href=\'import.php?id='.$id.'\'"><br>';
333   echo '<input type=reset value="UNDO CHANGES" style="width:150px"><br><br>';   echo '<input class="but" type=reset value="UNDO CHANGES" style="width:150px"><br><br>';
334    
335   $davor  = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id-1),'mac')!=null; if($davor) $disdavor=''; else $disdavor = 'disabled=1';   $davor  = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id-1),'mac')!=null; if($davor) $disdavor=''; else $disdavor = 'disabled=1';
336   $danach = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id+1),'mac')!=null; if($danach) $disdanach=''; else $disdanach = 'disabled=1';   $danach = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id+1),'mac')!=null; if($danach) $disdanach=''; else $disdanach = 'disabled=1';
337    
338   echo '<input type=button '.$disdavor.' value="<" style="width:30px" onclick="location.href=\'show.php?id='.($id-1).'\'">';   echo '<input class="but" type=button '.$disdavor.' value="<" style="width:30px" onclick="location.href=\'show.php?id='.($id-1).'\'">';
339   echo '<input type=button value="REFRESH" style="width:90px" onclick="location.href=\'show.php?id='.$id.'\'">';   echo '<input class="but" type=button value="REFRESH" style="width:90px" onclick="location.href=\'show.php?id='.$id.'\'">';
340   echo '<input type=button '.$disdanach.' value=">" style="width:30px" onclick="location.href=\'show.php?id='.($id+1).'\'">';   echo '<input class="but" type=button '.$disdanach.' value=">" style="width:30px" onclick="location.href=\'show.php?id='.($id+1).'\'">';
341   echo '<br><input type=button value="INDEX" style="width:150px; font-weight:bold" onclick="location.href=\'index.php\'"><br><br>';   echo '<br><input class="but" type=button value="INDEX" style="width:150px; font-weight:bold" onclick="location.href=\'index.php\'"><br><br>';
342    
343   echo '<br><br>';   echo '<br><br>';
344   echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff"><b>';   echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff"><b>';
# Line 223  Line 346 
346   echo '<u>Serial:</u>&nbsp;&nbsp;#'.$id.'<br>';   echo '<u>Serial:</u>&nbsp;&nbsp;#'.$id.'<br>';
347   echo '<u>Stand:</u>&nbsp;&nbsp;'.date('H:i:s').'<br>';   echo '<u>Stand:</u>&nbsp;&nbsp;'.date('H:i:s').'<br>';
348   echo '<u>Status:</u> <img src="pics/'.strtolower($state).'line.gif" align=top> '.$state.'line<br>';   echo '<u>Status:</u> <img src="pics/'.strtolower($state).'line.gif" align=top> '.$state.'line<br>';
349   if($state=='On') echo '<u>IP:</u> '.$conn['ip'];   if($state=='On')
350     {
351     echo '<u>IP:</u> '.$conn['ip'].'<br><br>';
352     $pubkey = mysql_query('select public_key from ssh_auth_clients where serial='.$id.'');
353     while ($row = mysql_fetch_row ($pubkey)) {
354     # schreiben der .ssh/known_hosts file mit dem public rsa key des client,
355     # um die "yes" abfrage zu vermeiden
356     $hostfile = fopen ($home."/.ssh/known_hosts","w");
357     fwrite($hostfile,$conn['ip']." ".$row[0],strlen($row[0])+strlen($conn['ip'])+1);
358     fclose($hostfile);
359    
360     $osver = exec($sshcmd.' -l root '.$conn['ip'].' \'os_ver=$(<'.$mageversion.');cfg_ver=$(/sbin/magequery -n '.$alxconfig.'|cut -d" " -f5);pname=${cfg_ver%-*-*};cfg_ver=${cfg_ver/${pname}-};echo "${os_ver}:${cfg_ver}"\'');
361     $osver = explode(':',$osver);
362     }
363     if($osver[0] == '') $osver[0]='unkown';
364     if($osver[1] == '') $osver[1]='unkown';
365                     echo '<u>OS:</u> '.$osver[0].'<br>';
366                     echo '<u>Utils:</u> '.$osver[1].'<br>';
367     }
368    
369   echo '</b></div>';   echo '</b></div>';
370   //echo '<br><br>';   //echo '<br><br>';
371    
372   if($state=='On')   if($state=='On')
373   {   {
374   echo '<input 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="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>';
375   echo '<input 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 '<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>';
376    
377   echo '<br>';   echo '<br>';
378                   echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff"><b>';                   echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff" align="center"><b>';
379                  echo 'Client Software Update:<br><br>';                  echo 'Client Update:</b></div>';
380   echo '<input 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="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>';
381   echo '<input 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="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>';
382   echo '<input 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>';   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>';                                      
                 echo '</b></div>';  
383   }   }
384   else   else
385   echo '<input 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>';   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>';
386    
387   echo '<br><a href="share/ChangeLog.html">ChangeLog</a>';   echo '<br><center><a href="share/ChangeLog.html" target="_blank">[ChangeLog]</a> <a href="share/FAQ.html" target="_blank">[FAQs]</a></center>';
  echo '<br><a href="share/FAQ.html">FAQs</a>';  
388    
389   echo '</td></tr></table>';   echo '</td></tr></table>';
390   echo '</form>';   echo '</form>';

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