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 424 by niro, Wed Jun 4 21:54:04 2008 UTC revision 495 by niro, Tue Jun 10 11:30:03 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)
    9   {   {
    10   foreach($tabs as $t) mysql_query('UPDATE '.$t.' SET serial=-serial WHERE serial='.$id);   foreach($tabs as $t) mysql_query('UPDATE '.$t.' SET serial=-serial WHERE serial='.$id);
    11    
    12   echo '<body onload="window.setTimeout(\'window.close()\', 1750)">';   echo '<body onload="window.setTimeout(\'window.close()\', 1750)">';
    13   echo '<table width=100% height=100% style="border:solid black 1px; background-color:#d5e5ff"><tr><td valign=middle align=center>';   echo '<table width=100% height=100% style="border:solid black 1px; background-color:#d5e5ff"><tr><td valign=middle align=center>';
    14    
    15   if($id<0) echo 'ACTIVATED #'.abs($id);   if($id<0) echo 'ACTIVATED #'.abs($id);
    16   else echo 'DEACTIVATED #'.$id;   else echo 'DEACTIVATED #'.$id;
    17    
    18   echo '</td></tr></table>';   echo '</td></tr></table>';
    19   return true;   return true;
    20   }   }
    21    
    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','1360x768', '1366x768', '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['networking'] = array('dhcp', 'static');   //$drop['cfg_network_module'] = array('auto','3c59x', '8139too', '8139cp', 'e100', 'ne2k-pci', 'pcnet32', 'sis900', 'via-rhine', 'zd1211');
    31   $drop['port'] = array('lpt1', 'com1', 'com2', 'lpd', 'socket', 'ipp');   $drop['module'] = array('auto','3c59x', '8139too', '8139cp', 'e100', 'ne2k-pci', 'pcnet32', 'sis900', 'via-rhine', 'zd1211');
    32   $drop['location'] = sqlarr('SELECT location FROM client_locations', '', 'location');   $drop['networking'] = array('dhcp', 'static');
    33   $drop['id'] = 'hidden';   $drop['default_iface'] = sqlarr('SELECT iface FROM cfg_interfaces where serial='.$id, '', 'iface');
    34   $drop['flg_modified'] = '1';   $drop['iface'] = 'show';
    35   $drop['serial'] = 'ignore';   # only support parallel and seriell printing on tinyalx
    36   $drop['monitorid'] = 'monitorid';   //$drop['port'] = array('lpt1', 'com1', 'com2', 'lpd', 'socket', 'ipp');
    37   $drop['hostname'] = 'bold';   $drop['port'] = array('lpt1', 'com1');
    38   $drop['session'] = 'bold';   $drop['location'] = sqlarr('SELECT location FROM client_locations', '', 'location');
    39   $drop['cfg_autostart_session'] = 'filename';   $drop['id'] = 'hidden';
    40   $drop['mtime'] = 'showtime';   $drop['flg_modified'] = '1';
    41   $drop['mac'] = 'show';   $drop['serial'] = 'ignore';
    42   $drop['client_serials_serial'] = 'show';   $drop['monitorid'] = 'monitorid';
    43   $drop['password'] = 'password';   $drop['hostname'] = 'bold';
    44   $drop['shell'] = 'password';   $drop['session'] = 'bold';
    45   $drop['vnc'] = 'password';   $drop['displaymode'] = array('fullscreen', 'seamless', '1280x1024', '1024x768', '800x600');
    46   $drop['samba'] = 'password';   $drop['cfg_autostart_session'] = array('');
    47   $drop['station'] = 'password';   $drop['cfg_autostart_session'] += sqlarr('SELECT filename FROM cfg_sessions where serial='.$id, 'array', 'filename');
    48   $drop['txt'] = 'txt';   $drop['mtime'] = 'showtime';
    49   $drop['screensaver'] = array('','blank', 'random', 'ant', 'ant3d', 'apollonian', 'ball', 'bat', 'blot', 'bomb', 'bouboule',   $drop['mac'] = 'show';
    50   'bounce', 'braid', 'bubble', 'bug', 'clock', 'coral', 'crystal', 'daisy', 'dclock', 'decay', 'deco',   $drop['client_serials_serial'] = 'show';
    51   'demon', 'dilemma', 'discrete', 'dragon', 'drift', 'euler2d', 'eyes', 'fadeplot', 'fiberlamp', 'flag',   $drop['password'] = 'password';
    52   'flame', 'flow', 'forest', 'galaxy', 'goop', 'grav', 'helix', 'hop', 'hyper', 'ico', 'ifs', 'image',   $drop['shell'] = 'password';
    53   'juggle', 'julia', 'kaleid', 'kumppa', 'laser', 'life', 'life1d', 'life3d', 'lightning', 'lisa', 'lissie',   $drop['vnc'] = 'password';
    54   'loop', 'lyapunov', 'mandelbrot', 'marquee', 'matrix', 'maze', 'mountain', 'munch', 'nose', 'pacman',   $drop['samba'] = 'password';
    55   'penrose', 'petal', 'petri', 'polyominoes', 'puzzle',  'pyro', 'qix', 'roll',  'rotor', 'scooter', 'shape',   $drop['station'] = 'password';
    56   'sierpinski', 'slip', 'solitare', 'space', 'sphere', 'spiral', 'spline', 'star', 'starfish', 'strange',   $drop['txt'] = 'txt';
    57   'swarm', 'swirl', 't3d', 'tetris', 'thornbird', 'tik_tak', 'toneclock', 'triangle', 'tube', 'turtle',   $drop['screensaver'] = array('','blank', 'random', 'ant', 'ant3d', 'apollonian', 'ball', 'bat', 'blot', 'bomb', 'bouboule',
    58   'vines', 'voters', 'wator', 'wire', 'world', 'worm', 'xcl', 'xjack');   'bounce', 'braid', 'bubble', 'bug', 'clock', 'coral', 'crystal', 'daisy', 'dclock', 'decay', 'deco',
    59   $drop['iface'] = array('eth0', 'wlan0');   'demon', 'dilemma', 'discrete', 'dragon', 'drift', 'euler2d', 'eyes', 'fadeplot', 'fiberlamp', 'flag',
    60     'flame', 'flow', 'forest', 'galaxy', 'goop', 'grav', 'helix', 'hop', 'hyper', 'ico', 'ifs', 'image',
    61     'juggle', 'julia', 'kaleid', 'kumppa', 'laser', 'life', 'life1d', 'life3d', 'lightning', 'lisa', 'lissie',
    62   // ACHTUNG!!! wlan_-Felder heißen eigentlich wireless_   'loop', 'lyapunov', 'mandelbrot', 'marquee', 'matrix', 'maze', 'mountain', 'munch', 'nose', 'pacman',
    63   $drop['wireless_mode'] = array('', 'managed', 'ad-hoc', 'master', 'repeater', 'secondary', 'monitor', 'auto');   'penrose', 'petal', 'petri', 'polyominoes', 'puzzle',  'pyro', 'qix', 'roll',  'rotor', 'scooter', 'shape',
    64   $drop['wireless_auth_mode'] = array('', 'wep', 'wpa', 'off');   'sierpinski', 'slip', 'solitare', 'space', 'sphere', 'spiral', 'spline', 'star', 'starfish', 'strange',
    65   $drop['wireless_key_length'] = array('', '64', '128', '256');   'swarm', 'swirl', 't3d', 'tetris', 'thornbird', 'tik_tak', 'toneclock', 'triangle', 'tube', 'turtle',
    66   $drop['wireless_channel'] = array('', '1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14');   'vines', 'voters', 'wator', 'wire', 'world', 'worm', 'xcl', 'xjack');
    67   $drop['wireless_frequency'] = array('', '2.412G', '2.417G', '2.422G', '2.427G', '2.432G', '2.437G', '2.442G',  
    68   '2.447G', '2.452G', '2.457G', '2.462G', '2.467G', '2.472G', '2.484G');  
    69   $drop['wireless_key'] = 'password';   // ACHTUNG!!! wlan_-Felder heißen eigentlich wireless_
    70   $drop['wireless_key_ascii'] = 'password';   $drop['wireless_mode'] = array('', 'managed', 'ad-hoc', 'master', 'repeater', 'secondary', 'monitor', 'auto');
    71     $drop['wireless_auth_mode'] = array('', 'wep', 'wpa', 'off');
    72   // GGF. NEUEN DATENSATZ EINFÜGEN   $drop['wireless_key_length'] = array('', '64', '128', '256');
    73   if(isset($_POST['do_add']))   $drop['wireless_channel'] = array('', '1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14');
    74   {   $drop['wireless_frequency'] = array('', '2.412G', '2.417G', '2.422G', '2.427G', '2.432G', '2.437G', '2.442G',
    75   list($bla,$what) = explode(' ',$_POST['do_add']);   '2.447G', '2.452G', '2.457G', '2.462G', '2.467G', '2.472G', '2.484G');
    76   if($what=='COMMENT') sqladd('cfg_comments', array('serial'=>$id));   $drop['wireless_key'] = 'password';
    77   else if($what=='PRINTER') sqladd('cfg_printers', array('serial'=>$id));   $drop['wireless_key_ascii'] = 'password';
    78   else if($what=='MODULE') sqladd('cfg_modules', array('serial'=>$id));  
    79   else if($what=='SESSION') sqladd('cfg_sessions', array('domain'=>'DOM_AKA_NT', 'browseradrs'=>'128.20.50.38;128.20.50.39;128.20.50.46;128.20.50.24;128..20.100.20', 'serial'=>$id));   // GGF. NEUEN DATENSATZ EINFÜGEN
    80   else if($what=='MENUITEM') sqladd('cfg_other_menuitems', array('serial'=>$id));   if(isset($_POST['do_add']))
    81   }   {
    82     list($bla,$what) = explode(' ',$_POST['do_add']);
    83     if($what=='COMMENT') sqladd('cfg_comments', array('serial'=>$id));
    84   // GGF. SPEICHERN   else if($what=='PRINTER') sqladd('cfg_printers', array('serial'=>$id));
    85   if($_POST['do_upl'])   else if($what=='MODULE') sqladd('cfg_modules', array('serial'=>$id));
    86   {   else if($what=='SESSION') sqladd('cfg_sessions', array('domain'=>'DOM_AKA_NT', 'browseradrs'=>'128.20.50.38;128.20.50.39;128.20.50.46;128.20.50.24;128..20.100.20', 'serial'=>$id));
    87   function postarr($prefix)   else if($what=='MENUITEM') sqladd('cfg_other_menuitems', array('serial'=>$id));
    88   {   }
    89   $prefix.='_';  
    90   $prelen = strlen($prefix);  
    91     // GGF. SPEICHERN
    92   $arr = array();   if($_POST['do_upl'])
    93   foreach($_POST as $k=>$v)   {
    94   if((substr($k,0,$prelen)==$prefix) && ($v!='KEEPPASS'))   function postarr($prefix)
    95   $arr[substr($k,$prelen)] = stripslashes($v);   {
    96     $prefix.='_';
    97   return $arr;   $prelen = strlen($prefix);
    98   }  
    99     $arr = array();
    100   foreach($tabs as $k=>$t)   foreach($_POST as $k=>$v)
    101   {   if((substr($k,0,$prelen)==$prefix) && ($v!='KEEPPASS'))
    102   if(!$multi[$k]) mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t)).' WHERE serial='.$id);   $arr[substr($k,$prelen)] = stripslashes($v);
    103   else  
    104   {   return $arr;
    105   $i=0;   }
    106   while(isset($_POST[$t.'_'.$i.'_id']))  
    107   {   foreach($tabs as $k=>$t)
    108   if($_POST[$t.'_'.$i.'_delete'])   {
    109   mysql_query('DELETE FROM '.$t.' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);   if(!$multi[$k])
    110   else   {
    111   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)).' WHERE serial='.$id);
    112   $i++;   }
    113   }   else
    114   }   {
    115   }   $i=0;
    116   }   while(isset($_POST[$t.'_'.$i.'_id']))
    117     {
    118     if($_POST[$t.'_'.$i.'_delete'])
    119   // EINLESEN DER DATEN AUS SQL-TABELLEN   mysql_query('DELETE FROM '.$t.' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);
    120   foreach($tabs as $k=>$t)   else
    121   {   mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t.'_'.$i)).' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);
    122   if($multi[$k]) $data[$t] = sqlarr('SELECT * FROM '.$t.' WHERE serial='.$id);   $i++;
    123   else $data[$t] = sqlfirst('SELECT * FROM '.$t.' WHERE serial='.$id);   }
    124   }   }
    125     }
    126     }
    127    
    128    
    129   // ANZEIGEN - KLAPPFUNKTIONEN   // EINLESEN DER DATEN AUS SQL-TABELLEN
    130   $absnames = array();   foreach($tabs as $k=>$t)
    131     {
    132   function openabs($heading, $helpfile='')   if($multi[$k]) $data[$t] = sqlarr('SELECT * FROM '.$t.' WHERE serial='.$id);
    133   {   else $data[$t] = sqlfirst('SELECT * FROM '.$t.' WHERE serial='.$id);
    134   global $absnames;   }
    135   $absnames[] = $heading;  
    136    
    137   // <AufZuLink> <Bild/> <Heading/> </AufZuLink><BR/> <Absatz>  
    138    
    139   if( $_SESSION['openclose'][$heading] )   // ANZEIGEN - KLAPPFUNKTIONEN
    140   {   $absnames = array();
    141   echo '<a href="JavaScript:openclose(\''.$heading.'\',1);"><img border="0" src="pics/minus.gif" title="CLOSE" id="sch_bild_'.$heading.'"> <b>['.$heading.']</b></a>';  
    142   if($helpfile!='') echo ' <a href="JavaScript:showhelp(\''.$helpfile.'\')" title="HELP">[?]</a>';   function openabs($heading, $helpfile='')
    143   echo '<br><div id="sch_absatz_'.$heading.'" style="top:0px; visibility:visible">';   {
    144   }   global $absnames;
    145   else   $absnames[] = $heading;
    146   {  
    147   echo '<a href="JavaScript:openclose(\''.$heading.'\',1);"><img border="0" src="pics/plus.gif" title="OPEN" id="sch_bild_'.$heading.'"> <b>['.$heading.']</b></a>';   // <AufZuLink> <Bild/> <Heading/> </AufZuLink><BR/> <Absatz>
    148   if($helpfile!='') echo ' <a href="JavaScript:showhelp(\''.$helpfile.'\')" title="HELP">[?]</a>';  
    149   echo '<br><div id="sch_absatz_'.$heading.'" style="position:absolute; top:0px; visibility:hidden">';   if( $_SESSION['openclose'][$heading] )
    150   }   {
    151   }   echo '<a href="JavaScript:openclose(\''.$heading.'\',1);"><img border="0" src="pics/minus.gif" title="CLOSE" id="sch_bild_'.$heading.'"> <b>['.$heading.']</b></a>';
    152     if($helpfile!='') echo ' <a href="JavaScript:showhelp(\''.$helpfile.'\')" title="HELP">[?]</a>';
    153   function closeabs()   echo '<br><div id="sch_absatz_'.$heading.'" style="top:0px; visibility:visible">';
    154   {   }
    155   // </Absatz> <BR/>   else
    156     {
    157   echo '</div><br>';   echo '<a href="JavaScript:openclose(\''.$heading.'\',1);"><img border="0" src="pics/plus.gif" title="OPEN" id="sch_bild_'.$heading.'"> <b>['.$heading.']</b></a>';
    158   }   if($helpfile!='') echo ' <a href="JavaScript:showhelp(\''.$helpfile.'\')" title="HELP">[?]</a>';
    159     echo '<br><div id="sch_absatz_'.$heading.'" style="position:absolute; top:0px; visibility:hidden">';
    160     }
    161   // ANZEIGEN   }
    162    
    163   function parsearr($name, $arr, $del=false, $wireless=false)   function closeabs()
    164   {   {
    165   global $drop;   // </Absatz> <BR/>
    166   global $id;  
    167     echo '</div><br>';
    168   $parts = explode('_',$name); $helpfile='help.php?page='.$parts[1];   }
    169   openabs($name, $helpfile);  
    170   echo '<table class="keytab">';  
    171     // ANZEIGEN
    172   foreach($arr as $k=>$v)  
    173   {   function parsearr($name, $arr, $del=false, $wireless=false)
    174   if( (substr($k,0,9)=='wireless_') xor $wireless ) Continue;   {
    175     global $drop;
    176   $d = $drop[$name.'_'.$k]; if($d==null) $d = $drop[$k];   global $id;
    177   $k = str_replace('wireless_', '', $k);  
    178   $k2 = $k;   $parts = explode('_',$name); $helpfile='help.php?page='.$parts[1];
    179     openabs($name, $helpfile);
    180   if(is_array($d))   echo '<table class="keytab">';
    181   {  
    182   echo '<tr><td>'.$k2.'</td><td>= <select style="width:144px" name="'.$name.'_'.$k.'">';   foreach($arr as $k=>$v)
    183   foreach($d as $di) if($v==$di) echo '<option selected>'.$di; else echo '<option>'.$di;   {
    184   echo '</select></td></tr>';   //if( (substr($k,0,9)=='wireless_') xor $wireless ) Continue;
    185   }  
    186   else if($d=='hidden') echo '<tr><td colspan=2><input type=hidden name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';   $d = $drop[$name.'_'.$k]; if($d==null) $d = $drop[$k];
    187   else if($d=='1') echo '<tr><td colspan=2><input type=hidden name="'.$name.'_'.$k.'" value="1"></td></tr>';   //$k = str_replace('wireless_', '', $k);
    188   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>';   $k2 = $k;
    189   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>';  
    190   else if($d=='filename') echo '<tr><td class="key">filename</td><td>= <input style="width:144px;font-weight:bold" name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';   if(is_array($d))
    191   else if($d=='show') echo '<tr><td class="key">'.$k2.'</td><td>= <b>'.$v.'</b></td></tr>';   {
    192   else if($d=='showtime') echo '<tr><td class="key">'.$k2.'</td><td>= <b>'.date('d.m.y - H:i:s', $v).'</b></td></tr>';   echo '<tr><td>'.$k2.'</td><td>= <select style="width:144px" name="'.$name.'_'.$k.'">';
    193   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>';   foreach($d as $di) if($v==$di) echo '<option selected>'.$di; else echo '<option>'.$di;
    194   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>';   echo '</select></td></tr>';
    195   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>';   }
    196   else if($d!='ignore') echo '<tr><td class="key">'.$k2.'</td><td>= <input style="width:144px" 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>';
    197   }   else if($d=='1') echo '<tr><td colspan=2><input type=hidden name="'.$name.'_'.$k.'" value="1"></td></tr>';
    198     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>';
    199   if($del) echo '<tr><td class="key">delete</td><td>=<input type=checkbox name="'.$name.'_delete" value="1"></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>';
    200   echo '</table>';   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>';
    201   closeabs();   else if($d=='show') echo '<tr><td class="key">'.$k2.'</td><td>= <b>'.$v.'</b></td></tr>';
    202     else if($d=='showtime') echo '<tr><td class="key">'.$k2.'</td><td>= <b>'.date('d.m.y - H:i:s', $v).'</b></td></tr>';
    203   if($name=='cfg_network' && !$wireless) parsearr($name.'_wireless', $arr, $del, true);   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>';
    204   }   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>';
    205   function parsearrs($name, $arr)   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>';
    206   {   else if($d!='ignore') echo '<tr><td class="key">'.$k2.'</td><td>= <input style="width:144px" name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';
    207   foreach($arr as $k=>$a)   }
    208   parsearr($name.'_'.$k, $a, true);  
    209   }   if($del) echo '<tr><td class="key">delete</td><td>=<input type=checkbox name="'.$name.'_delete" value="1"></td></tr>';
    210     echo '</table>';
    211   ?><head>   closeabs();
    212   <title>ALX Config</title>  
    213   <style>   //if($name=='cfg_network' && !$wireless) parsearr($name.'_wireless', $arr, $del, true);
    214   body,table { font-family:Tahoma; font-size:10pt }   }
    215   a { color:#000000; text-decoration:none; }   function parsearrs($name, $arr)
    216   .key { width:85px }   {
    217   .keytab, input, textarea, select, option { font-size:8pt; font-family:Tahoma }   foreach($arr as $k=>$a)
    218   .but { font-size:10pt; font-family:Tahoma; height:23px }   parsearr($name.'_'.$k, $a, true);
    219   </style>   }
    220   <script language="JavaScript" src="openclose_ajax.js"></script>  
    221   <script language="JavaScript">   ?><head>
    222     <title>ALX Config</title>
    223   function openclose(nummer, act)   <style>
    224   {   body,table { font-family:Tahoma; font-size:10pt }
    225   var bild = document.images['sch_bild_'+nummer];   a { color:#000000; text-decoration:none; }
    226   var absatz = document.all['sch_absatz_'+nummer].style;   .key { width:85px }
    227   var senden = false;   .keytab, input, textarea, select, option { font-size:8pt; font-family:Tahoma }
    228     .but { font-size:10pt; font-family:Tahoma; height:23px }
    229   if(bild.title == 'OPEN')   </style>
    230   {   <script language="JavaScript" src="openclose_ajax.js"></script>
    231   if(act<=1)   <script language="JavaScript">
    232   {  
    233   absatz.visibility = 'visible';   function openclose(nummer, act)
    234   absatz.position = '';   {
    235   bild.title = 'CLOSE';   var bild = document.images['sch_bild_'+nummer];
    236   bild.src = 'pics/minus.gif';   var absatz = document.all['sch_absatz_'+nummer].style;
    237   senden = true;   var senden = false;
    238   act = 0;  
    239   }   if(bild.title == 'OPEN')
    240   }   {
    241   else   if(act<=1)
    242   {   {
    243   if(act>=1)   absatz.visibility = 'visible';
    244   {   absatz.position = '';
    245   absatz.visibility = 'hidden';   bild.title = 'CLOSE';
    246   absatz.position = 'absolute';   bild.src = 'pics/minus.gif';
    247   bild.title = 'OPEN';   senden = true;
    248   bild.src = 'pics/plus.gif';   act = 0;
    249   senden = true;   }
    250   act = 2;   }
    251   }   else
    252   }   {
    253     if(act>=1)
    254   if(senden) sendopenclose(nummer,act);   {
    255   }   absatz.visibility = 'hidden';
    256     absatz.position = 'absolute';
    257   function showhelp(name)   bild.title = 'OPEN';
    258   { window.open(name, 'HelpWin', 'width=620,height=500,scrollbars=yes'); }   bild.src = 'pics/plus.gif';
    259     senden = true;
    260   </script>   act = 2;
    261   </head>   }
    262     }
    263   <body><?  
    264     if(senden) sendopenclose(nummer,act);
    265     }
    266   //echo '<body style="background-image:URL(logo.jpg);background-repeat:no-repeat; background-position:0px 0px; margin-top:25px">';  
    267   echo '<form action="show.php" method=post onreset="return confirm(\'UNDO CHANGES?\')">';   function showhelp(name)
    268   echo '<input type=hidden name="do_upl" value="1">';   { window.open(name, 'HelpWin', 'width=620,height=500,scrollbars=yes'); }
    269   echo '<input type=hidden name="id" value="'.$id.'">';  
    270     </script>
    271   // ANZEIGEN => NON-MULTI TABELLEN   </head>
    272   echo '<table><tr><td valign=top width="300">';  
    273     <body><?
    274   echo '<b style="font-size:6pt">';  
    275   echo '<a href="JavaScript:opencloseall(0);" title="OPEN ALL"><img src="pics/plus.gif" border="0"> OPEN...</a> ';  
    276   echo '<a href="JavaScript:opencloseall(2);" title="CLOSE ALL"><img src="pics/minus.gif" border="0"> CLOSE...</a> ALL';   //echo '<body style="background-image:URL(logo.jpg);background-repeat:no-repeat; background-position:0px 0px; margin-top:25px">';
    277   echo '</b><br><br>';   echo '<form action="show.php" method=post onreset="return confirm(\'UNDO CHANGES?\')">';
    278     echo '<input type=hidden name="do_upl" value="1">';
    279   foreach($tabs as $k=>$t) if(!$multi[$k]) parsearr($t, $data[$t]);   echo '<input type=hidden name="id" value="'.$id.'">';
    280    
    281   // ANZEIGEN => MULTI TABELLEN   // ANZEIGEN => NON-MULTI TABELLEN
    282   echo '</td><td valign=top width="300">';   echo '<table><tr><td valign=top width="300">';
    283    
    284   foreach($tabs as $k=>$t) if($multi[$k]) parsearrs($t, $data[$t]);   echo '<b style="font-size:6pt">';
    285     echo '<a href="JavaScript:opencloseall(0);" title="OPEN ALL"><img src="pics/plus.gif" border="0"> OPEN...</a> ';
    286   echo '<script language="JavaScript">';   echo '<a href="JavaScript:opencloseall(2);" title="CLOSE ALL"><img src="pics/minus.gif" border="0"> CLOSE...</a> ALL';
    287   echo 'function opencloseall(act) { ';   echo '</b><br><br>';
    288    
    289   foreach($absnames as $absname)   foreach($tabs as $k=>$t) if(!$multi[$k]) parsearr($t, $data[$t]);
    290   echo 'openclose("'.$absname.'", act); ';  
    291     // ANZEIGEN => MULTI TABELLEN
    292   echo '}</script>';   echo '</td><td valign=top width="300">';
    293    
    294   // ANZEIGEN => NAVI   foreach($tabs as $k=>$t) if($multi[$k]) parsearrs($t, $data[$t]);
    295   echo '</td><td valign=top>';  
    296     echo '<script language="JavaScript">';
    297   // STATUS BESTIMMEN (ON/OFF)   echo 'function opencloseall(act) { ';
    298   $conn = sqlfirst('SELECT * FROM state_connected WHERE serial='.$id);  
    299   $state = 'Off';   foreach($absnames as $absname)
    300   if(count($conn)>0)   echo 'openclose("'.$absname.'", act); ';
    301   {  
    302   passthru("/usr/sbin/fping -c 1 -i 50 -q ".$conn['ip']." &> /dev/null && exit 0 || exit 1",$retval);   echo '}</script>';
    303   if($retval==0) $state = 'On';  
    304   }   // ANZEIGEN => NAVI
    305     echo '</td><td valign=top>';
    306    
    307   echo '<img src="pics/logo2.jpg"><br><br>';   // STATUS BESTIMMEN (ON/OFF)
    308     $conn = sqlfirst('SELECT * FROM state_connected WHERE serial='.$id);
    309   echo '<input class="but" type=submit value="SAVE" style="width:150px"><br><br>';   $state = 'Off';
    310     if(count($conn)>0)
    311   echo '<input class="but" type=submit name="do_add" value="SAVE+ADD COMMENT" style="width:150px"><br>';   {
    312   echo '<input class="but" type=submit name="do_add" value="SAVE+ADD PRINTER" style="width:150px"><br>';   passthru("/usr/sbin/fping -c 1 -i 50 -q ".$conn['ip']." &> /dev/null && exit 0 || exit 1",$retval);
    313   echo '<input class="but" type=submit name="do_add" value="SAVE+ADD SESSION" style="width:150px"><br>';   if($retval==0) $state = 'On';
    314   echo '<input class="but" type=submit name="do_add" value="SAVE+ADD MODULE" style="width:150px"><br>';   }
    315   echo '<input class="but" type=submit name="do_add" value="SAVE+ADD MENUITEM" style="width:150px"><br><br>';  
    316    
    317     echo '<img src="pics/logo2.jpg"><br><br>';
    318   if($id>0) $KILLCAP='DEACTIVATE'; else $KILLCAP='ACTIVATE';  
    319   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=submit value="SAVE" style="width:150px"><br><br>';
    320   echo '<input class="but" type=button value="IMPORT FROM..." style="width:150px" onclick="location.href=\'import.php?id='.$id.'\'"><br>';  
    321   echo '<input class="but" type=reset value="UNDO CHANGES" style="width:150px"><br><br>';   echo '<input class="but" type=submit name="do_add" value="SAVE+ADD COMMENT" style="width:150px"><br>';
    322     echo '<input class="but" type=submit name="do_add" value="SAVE+ADD PRINTER" style="width:150px"><br>';
    323   $davor  = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id-1),'mac')!=null; if($davor) $disdavor=''; else $disdavor = 'disabled=1';   echo '<input class="but" type=submit name="do_add" value="SAVE+ADD SESSION" style="width:150px"><br>';
    324   $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=submit name="do_add" value="SAVE+ADD MODULE" style="width:150px"><br>';
    325     echo '<input class="but" type=submit name="do_add" value="SAVE+ADD MENUITEM" style="width:150px"><br><br>';
    326   echo '<input class="but" type=button '.$disdavor.' value="<" style="width:30px" onclick="location.href=\'show.php?id='.($id-1).'\'">';  
    327   echo '<input class="but" type=button value="REFRESH" style="width:90px" onclick="location.href=\'show.php?id='.$id.'\'">';  
    328   echo '<input class="but" type=button '.$disdanach.' value=">" style="width:30px" onclick="location.href=\'show.php?id='.($id+1).'\'">';   if($id>0) $KILLCAP='DEACTIVATE'; else $KILLCAP='ACTIVATE';
    329   echo '<br><input class="but" type=button value="INDEX" style="width:150px; font-weight:bold" onclick="location.href=\'index.php\'"><br><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>';
    330     echo '<input class="but" type=button value="IMPORT FROM..." style="width:150px" onclick="location.href=\'import.php?id='.$id.'\'"><br>';
    331   echo '<br><br>';   echo '<input class="but" type=reset value="UNDO CHANGES" style="width:150px"><br><br>';
    332   echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff"><b>';  
    333   if($id<0) echo '<b>DEACTIVATED!</b><br><br>';   $davor  = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id-1),'mac')!=null; if($davor) $disdavor=''; else $disdavor = 'disabled=1';
    334   echo '<u>Serial:</u>&nbsp;&nbsp;#'.$id.'<br>';   $danach = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id+1),'mac')!=null; if($danach) $disdanach=''; else $disdanach = 'disabled=1';
    335   echo '<u>Stand:</u>&nbsp;&nbsp;'.date('H:i:s').'<br>';  
    336   echo '<u>Status:</u> <img src="pics/'.strtolower($state).'line.gif" align=top> '.$state.'line<br>';   echo '<input class="but" type=button '.$disdavor.' value="<" style="width:30px" onclick="location.href=\'show.php?id='.($id-1).'\'">';
    337   if($state=='On')   echo '<input class="but" type=button value="REFRESH" style="width:90px" onclick="location.href=\'show.php?id='.$id.'\'">';
    338   {   echo '<input class="but" type=button '.$disdanach.' value=">" style="width:30px" onclick="location.href=\'show.php?id='.($id+1).'\'">';
    339   echo '<u>IP:</u> '.$conn['ip'].'<br><br>';   echo '<br><input class="but" type=button value="INDEX" style="width:150px; font-weight:bold" onclick="location.href=\'index.php\'"><br><br>';
    340    
    341     echo '<br><br>';
    342     echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff"><b>';
    343     if($id<0) echo '<b>DEACTIVATED!</b><br><br>';
    344     echo '<u>Serial:</u>&nbsp;&nbsp;#'.$id.'<br>';
    345     echo '<u>Stand:</u>&nbsp;&nbsp;'.date('H:i:s').'<br>';
    346     echo '<u>Status:</u> <img src="pics/'.strtolower($state).'line.gif" align=top> '.$state.'line<br>';
    347     if($state=='On')
    348     {
    349     echo '<u>IP:</u> '.$conn['ip'].'<br><br>';
    350   $pubkey = mysql_query('select public_key from ssh_auth_clients where serial='.$id.'');   $pubkey = mysql_query('select public_key from ssh_auth_clients where serial='.$id.'');
    351   while ($row = mysql_fetch_row ($pubkey)) {   while ($row = mysql_fetch_row ($pubkey)) {
    352   # schreiben der .ssh/known_hosts file mit dem public rsa key des client,   # schreiben der .ssh/known_hosts file mit dem public rsa key des client,
    # Line 345  Line 355 
    355   fwrite($hostfile,$conn['ip']." ".$row[0],strlen($row[0])+strlen($conn['ip'])+1);   fwrite($hostfile,$conn['ip']." ".$row[0],strlen($row[0])+strlen($conn['ip'])+1);
    356   fclose($hostfile);   fclose($hostfile);
    357    
    358   $osver = exec($sshcmd.' -l root '.$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}"\'');   $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}"\'');
    359   $osver = explode(':',$osver);   $osver = explode(':',$osver);
    360   }   }
    361   if($osver[0] == '') $osver[0]='unkown';   if($osver[0] == '') $osver[0]='unkown';
    362   if($osver[1] == '') $osver[1]='unkown';   if($osver[1] == '') $osver[1]='unkown';
    363                   echo '<u>OS:</u> '.$osver[0].'<br>';   echo '<u>OS:</u> '.$osver[0].'<br>';
    364                   echo '<u>Utils:</u> '.$osver[1].'<br>';   echo '<u>Utils:</u> '.$osver[1].'<br>';
    365   }   }
    366    
    367   echo '</b></div>';   echo '</b></div>';
    368   //echo '<br><br>';   //echo '<br><br>';
    369    
    370   if($state=='On')   if($state=='On')
    371   {   {
    372   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="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>';
    373   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 '<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>';
    374    
    375   echo '<br>';   echo '<br>';
    376                   echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff" align="center"><b>';   echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff" align="center"><b>';
    377                  echo 'Client Update:</b></div>';   echo 'Client Update:</b></div>';
    378   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="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>';
    379   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="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>';
    380   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 '<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>';                                      
    381   }   }
    382   else   else
    383   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>';   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>';
    384    
    385   echo '<br><center><a href="share/ChangeLog.html" target="_blank">[ChangeLog]</a> <a href="share/FAQ.html" target="_blank">[FAQs]</a></center>';   echo '<br><center><a href="share/ChangeLog.html" target="_blank">[ChangeLog]</a> <a href="share/FAQ.html" target="_blank">[FAQs]</a></center>';
    386    
    387   echo '</td></tr></table>';   echo '</td></tr></table>';
    388   echo '</form>';   echo '</form>';
    389  ?>  ?>
    Legend:
    Removed from v.424  
    changed lines
      Added in v.495