Magellan Linux

  • Back to homepage
    • /[alx-svn]/alx-src/branches/alx-web-050/showtest.php

    Annotation of /alx-src/branches/alx-web-050/showtest.php

    Parent Directory Parent Directory | Revision Log Revision Log

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

    Properties

    Name Value
    svn:executable *