Magellan Linux

  • Back to homepage
    • /[alx-svn]/alx-src/trunk/alx-web/show.php

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

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

    revision 363 by niro, Mon Oct 10 22:48:24 2005 UTC revision 468 by niro, Thu Jun 5 21:57:24 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    
    65     // ACHTUNG!!! wlan_-Felder heißen eigentlich wireless_
    66   $drop['wireless_mode'] = array('', 'managed', 'ad-hoc', 'master', 'repeater', 'secondary', 'monitor', 'auto');   $drop['wireless_mode'] = array('', 'managed', 'ad-hoc', 'master', 'repeater', 'secondary', 'monitor', 'auto');
    67   $drop['wireless_auth_mode'] = array('', 'wep', 'wpa', 'off');   $drop['wireless_auth_mode'] = array('', 'wep', 'wpa', 'off');
    68   $drop['wireless_key_length'] = array('', '64', '128', '256');   $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');   $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',   $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');   '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 94  Line 102 
    102    
    103   foreach($tabs as $k=>$t)   foreach($tabs as $k=>$t)
    104   {   {
    105     echo "debug1: '".updatestr(postarr($t))."'";
    106   if(!$multi[$k]) mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t)).' WHERE serial='.$id);   if(!$multi[$k]) mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t)).' WHERE serial='.$id);
    107   else   else
    108   {   {
    # Line 103  Line 112 
    112   if($_POST[$t.'_'.$i.'_delete'])   if($_POST[$t.'_'.$i.'_delete'])
    113   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']);
    114   else   else
    115     echo "debug2: '".updatestr(postarr($t.'_'.$i))."'";
    116   mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t.'_'.$i)).' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);   mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t.'_'.$i)).' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);
    117   $i++;   $i++;
    118   }   }
    # Line 121  Line 131 
    131    
    132    
    133    
    134   // ANZEIGEN   // ANZEIGEN - KLAPPFUNKTIONEN
    135   function parsearr($name, $arr, $del=false)   $absnames = array();
    136    
    137     function openabs($heading, $helpfile='')
    138     {
    139     global $absnames;
    140     $absnames[] = $heading;
    141    
    142     // <AufZuLink> <Bild/> <Heading/> </AufZuLink><BR/> <Absatz>
    143    
    144     if( $_SESSION['openclose'][$heading] )
    145     {
    146     echo '<a href="JavaScript:openclose(\''.$heading.'\',1);"><img border="0" src="pics/minus.gif" title="CLOSE" id="sch_bild_'.$heading.'"> <b>['.$heading.']</b></a>';
    147     if($helpfile!='') echo ' <a href="JavaScript:showhelp(\''.$helpfile.'\')" title="HELP">[?]</a>';
    148     echo '<br><div id="sch_absatz_'.$heading.'" style="top:0px; visibility:visible">';
    149     }
    150     else
    151     {
    152     echo '<a href="JavaScript:openclose(\''.$heading.'\',1);"><img border="0" src="pics/plus.gif" title="OPEN" id="sch_bild_'.$heading.'"> <b>['.$heading.']</b></a>';
    153     if($helpfile!='') echo ' <a href="JavaScript:showhelp(\''.$helpfile.'\')" title="HELP">[?]</a>';
    154     echo '<br><div id="sch_absatz_'.$heading.'" style="position:absolute; top:0px; visibility:hidden">';
    155     }
    156     }
    157    
    158     function closeabs()
    159     {
    160     // </Absatz> <BR/>
    161    
    162     echo '</div><br>';
    163     }
    164    
    165    
    166     // ANZEIGEN
    167    
    168     function parsearr($name, $arr, $del=false, $wireless=false)
    169   {   {
    170   global $drop;   global $drop;
    171   global $id;   global $id;
    172    
    173   $parts = explode('_',$name); $helpfile='help.php?page='.$parts[1];   $parts = explode('_',$name); $helpfile='help.php?page='.$parts[1];
    174   echo '<tr><td colspan=2 style="cursor:hand" onclick="window.open(\''.$helpfile.'\', \'HelpWin\', \'width=620,height=500,scrollbars=no\')"><b>['.$name.'] <font color=#626a88><tt>(?)</tt></font></b></td></tr>';   openabs($name, $helpfile);
    175     echo '<table class="keytab">';
    176    
    177   foreach($arr as $k=>$v)   foreach($arr as $k=>$v)
    178   {   {
    179     //if( (substr($k,0,9)=='wireless_') xor $wireless ) Continue;
    180    
    181   $d = $drop[$name.'_'.$k]; if($d==null) $d = $drop[$k];   $d = $drop[$name.'_'.$k]; if($d==null) $d = $drop[$k];
    182     //$k = str_replace('wireless_', '', $k);
    183     $k2 = $k;
    184    
    185   if(is_array($d))   if(is_array($d))
    186   {   {
    187   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.'">';
    188   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;
    189   echo '</select></td></tr>';   echo '</select></td></tr>';
    190   }   }
    191   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>';
    192   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>';
    193   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>';
    194   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>';
    195   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>';
    196   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>';
    197   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>';
    198   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>';
    199   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>';
    200   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>';
    201   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>';
    202   }   }
    203    
    204   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>';
    205   echo '<tr height=30><td colspan=2></td></tr>';   echo '</table>';
    206     closeabs();
    207    
    208     //if($name=='cfg_network' && !$wireless) parsearr($name.'_wireless', $arr, $del, true);
    209   }   }
    210   function parsearrs($name, $arr)   function parsearrs($name, $arr)
    211   {   {
    # Line 162  Line 213 
    213   parsearr($name.'_'.$k, $a, true);   parsearr($name.'_'.$k, $a, true);
    214   }   }
    215    
    216   echo '<head><title>ALX Config - Client #'.$id.'</title></head>';   ?><head>
    217   echo '<body>';   <title>ALX Config</title>
    218     <style>
    219     body,table { font-family:Tahoma; font-size:10pt }
    220     a { color:#000000; text-decoration:none; }
    221     .key { width:85px }
    222     .keytab, input, textarea, select, option { font-size:8pt; font-family:Tahoma }
    223     .but { font-size:10pt; font-family:Tahoma; height:23px }
    224     </style>
    225     <script language="JavaScript" src="openclose_ajax.js"></script>
    226     <script language="JavaScript">
    227    
    228     function openclose(nummer, act)
    229     {
    230     var bild = document.images['sch_bild_'+nummer];
    231     var absatz = document.all['sch_absatz_'+nummer].style;
    232     var senden = false;
    233    
    234     if(bild.title == 'OPEN')
    235     {
    236     if(act<=1)
    237     {
    238     absatz.visibility = 'visible';
    239     absatz.position = '';
    240     bild.title = 'CLOSE';
    241     bild.src = 'pics/minus.gif';
    242     senden = true;
    243     act = 0;
    244     }
    245     }
    246     else
    247     {
    248     if(act>=1)
    249     {
    250     absatz.visibility = 'hidden';
    251     absatz.position = 'absolute';
    252     bild.title = 'OPEN';
    253     bild.src = 'pics/plus.gif';
    254     senden = true;
    255     act = 2;
    256     }
    257     }
    258    
    259     if(senden) sendopenclose(nummer,act);
    260     }
    261    
    262     function showhelp(name)
    263     { window.open(name, 'HelpWin', 'width=620,height=500,scrollbars=yes'); }
    264    
    265     </script>
    266     </head>
    267    
    268     <body><?
    269    
    270    
    271   //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">';
    272   echo '<form action="show.php" method=post onreset="return confirm(\'UNDO CHANGES?\')">';   echo '<form action="show.php" method=post onreset="return confirm(\'UNDO CHANGES?\')">';
    273   echo '<input type=hidden name="do_upl" value="1">';   echo '<input type=hidden name="do_upl" value="1">';
    274   echo '<input type=hidden name="id" value="'.$id.'">';   echo '<input type=hidden name="id" value="'.$id.'">';
    275    
    276   // ANZEIGEN => NON-MULTI TABELLEN   // ANZEIGEN => NON-MULTI TABELLEN
    277   echo '<table><tr><td valign=top width=280>';   echo '<table><tr><td valign=top width="300">';
    278    
    279     echo '<b style="font-size:6pt">';
    280     echo '<a href="JavaScript:opencloseall(0);" title="OPEN ALL"><img src="pics/plus.gif" border="0"> OPEN...</a> ';
    281     echo '<a href="JavaScript:opencloseall(2);" title="CLOSE ALL"><img src="pics/minus.gif" border="0"> CLOSE...</a> ALL';
    282     echo '</b><br><br>';
    283    
      echo '<table cellpadding=0 cellspacing=0>';  
    284   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>';  
    285    
    286   // ANZEIGEN => MULTI TABELLEN   // ANZEIGEN => MULTI TABELLEN
    287   echo '</td><td valign=top width=280>';   echo '</td><td valign=top width="300">';
    288    
      echo '<table cellpadding=0 cellspacing=0>';  
    289   foreach($tabs as $k=>$t) if($multi[$k]) parsearrs($t, $data[$t]);   foreach($tabs as $k=>$t) if($multi[$k]) parsearrs($t, $data[$t]);
    290   echo '</table>';  
    291     echo '<script language="JavaScript">';
    292     echo 'function opencloseall(act) { ';
    293    
    294     foreach($absnames as $absname)
    295     echo 'openclose("'.$absname.'", act); ';
    296    
    297     echo '}</script>';
    298    
    299   // ANZEIGEN => NAVI   // ANZEIGEN => NAVI
    300   echo '</td><td valign=top>';   echo '</td><td valign=top>';
    # Line 198  Line 311 
    311    
    312   echo '<img src="pics/logo2.jpg"><br><br>';   echo '<img src="pics/logo2.jpg"><br><br>';
    313    
    314   echo '<input type=submit value="SAVE" style="width:150px"><br><br>';   echo '<input class="but" type=submit value="SAVE" style="width:150px"><br><br>';
    315    
    316   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>';
    317   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>';
    318   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>';
    319   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>';
    320   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>';
    321    
    322    
    323   if($id>0) $KILLCAP='DEACTIVATE'; else $KILLCAP='ACTIVATE';   if($id>0) $KILLCAP='DEACTIVATE'; else $KILLCAP='ACTIVATE';
    324   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>';
    325   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>';
    326   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>';
    327    
    328   $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';
    329   $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';
    330    
    331   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).'\'">';
    332   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.'\'">';
    333   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).'\'">';
    334   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>';
    335    
    336   echo '<br><br>';   echo '<br><br>';
    337   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 226  Line 339 
    339   echo '<u>Serial:</u>&nbsp;&nbsp;#'.$id.'<br>';   echo '<u>Serial:</u>&nbsp;&nbsp;#'.$id.'<br>';
    340   echo '<u>Stand:</u>&nbsp;&nbsp;'.date('H:i:s').'<br>';   echo '<u>Stand:</u>&nbsp;&nbsp;'.date('H:i:s').'<br>';
    341   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>';
    342   if($state=='On') echo '<u>IP:</u> '.$conn['ip'];   if($state=='On')
    343     {
    344     echo '<u>IP:</u> '.$conn['ip'].'<br><br>';
    345     $pubkey = mysql_query('select public_key from ssh_auth_clients where serial='.$id.'');
    346     while ($row = mysql_fetch_row ($pubkey)) {
    347     # schreiben der .ssh/known_hosts file mit dem public rsa key des client,
    348     # um die "yes" abfrage zu vermeiden
    349     $hostfile = fopen ($home."/.ssh/known_hosts","w");
    350     fwrite($hostfile,$conn['ip']." ".$row[0],strlen($row[0])+strlen($conn['ip'])+1);
    351     fclose($hostfile);
    352    
    353     $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}"\'');
    354     $osver = explode(':',$osver);
    355     }
    356     if($osver[0] == '') $osver[0]='unkown';
    357     if($osver[1] == '') $osver[1]='unkown';
    358                     echo '<u>OS:</u> '.$osver[0].'<br>';
    359                     echo '<u>Utils:</u> '.$osver[1].'<br>';
    360     }
    361    
    362   echo '</b></div>';   echo '</b></div>';
    363   //echo '<br><br>';   //echo '<br><br>';
    364    
    365   if($state=='On')   if($state=='On')
    366   {   {
    367   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>';
    368   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>';
    369    
    370   echo '<br>';   echo '<br>';
    371                   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>';
    372                  echo 'Client Software Update:<br><br>';                  echo 'Client Update:</b></div>';
    373   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>';
    374   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>';
    375   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>';  
    376   }   }
    377   else   else
    378   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>';
    379    
    380   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>';  
    381    
    382   echo '</td></tr></table>';   echo '</td></tr></table>';
    383   echo '</form>';   echo '</form>';
    Legend:
    Removed from v.363  
    changed lines
      Added in v.468