ALX Config

--- alx-src/branches/alx-web-050/showtest.php 2010/12/02 22:15:08 1609 +++ alx-src/branches/alx-web-050/showtest.php 2010/12/02 23:02:19 1610 @@ -1,352 +1,352 @@ -'; - echo '

'; - - if($id<0) echo 'ACTIVATED #'.abs($id); - else echo 'DEACTIVATED #'.$id; - - echo '

'; - return true; - } - - - // FELD-DEFINITIONEN (ARRAY=>DROPDOWN / HIDDEN / IGNORE / 1 / BOLD / PASSWORD / SHOW / SHOWTIME / MONITORID) - $drop = array(); - $drop['cfg_graphic_module'] = array('vesa', 'ati', 'cirrus', 'i810', 'i710', 'nv', 'mga', 'r128', 'radeon', 's3', 's3virge', 'sis', 'trident', 'tseng', 'via'); - $drop['resolution'] = array('640x480', '800x600', '1024x768', '1280x1024', '1600x1200'); - $drop['depth'] = array('24', '16', '8'); - $drop['mouse'] = array('Auto', 'IMPS/2', 'PS/2'); - $drop['cfg_network_module'] = array('3c59x', '8139too', '8139cp', 'e100', 'ne2k-pci', 'pcnet32', 'sis900', 'via-rhine', 'zd1211'); - $drop['networking'] = array('dhcp', 'static'); - $drop['port'] = array('lpt1', 'com1', 'com2', 'lpd', 'socket', 'ipp'); - $drop['location'] = sqlarr('SELECT location FROM client_locations', '', 'location'); - $drop['id'] = 'hidden'; - $drop['flg_modified'] = '1'; - $drop['serial'] = 'ignore'; - $drop['monitorid'] = 'monitorid'; - $drop['hostname'] = 'bold'; - $drop['session'] = 'bold'; - $drop['cfg_autostart_session'] = 'filename'; - $drop['mtime'] = 'showtime'; - $drop['mac'] = 'show'; - $drop['client_serials_serial'] = 'show'; - $drop['password'] = 'password'; - $drop['shell'] = 'password'; - $drop['vnc'] = 'password'; - $drop['samba'] = 'password'; - $drop['station'] = 'password'; - $drop['txt'] = 'txt'; - $drop['screensaver'] = array('','blank', 'random', 'ant', 'ant3d', 'apollonian', 'ball', 'bat', 'blot', 'bomb', 'bouboule', - 'bounce', 'braid', 'bubble', 'bug', 'clock', 'coral', 'crystal', 'daisy', 'dclock', 'decay', 'deco', - 'demon', 'dilemma', 'discrete', 'dragon', 'drift', 'euler2d', 'eyes', 'fadeplot', 'fiberlamp', 'flag', - 'flame', 'flow', 'forest', 'galaxy', 'goop', 'grav', 'helix', 'hop', 'hyper', 'ico', 'ifs', 'image', - 'juggle', 'julia', 'kaleid', 'kumppa', 'laser', 'life', 'life1d', 'life3d', 'lightning', 'lisa', 'lissie', - 'loop', 'lyapunov', 'mandelbrot', 'marquee', 'matrix', 'maze', 'mountain', 'munch', 'nose', 'pacman', - 'penrose', 'petal', 'petri', 'polyominoes', 'puzzle', 'pyro', 'qix', 'roll', 'rotor', 'scooter', 'shape', - 'sierpinski', 'slip', 'solitare', 'space', 'sphere', 'spiral', 'spline', 'star', 'starfish', 'strange', - 'swarm', 'swirl', 't3d', 'tetris', 'thornbird', 'tik_tak', 'toneclock', 'triangle', 'tube', 'turtle', - 'vines', 'voters', 'wator', 'wire', 'world', 'worm', 'xcl', 'xjack'); - $drop['iface'] = array('eth0', 'wlan0'); - - - // ACHTUNG!!! wlan_-Felder heißen eigentlich wireless_ - $drop['wireless_mode'] = array('', 'managed', 'ad-hoc', 'master', 'repeater', 'secondary', 'monitor', 'auto'); - $drop['wireless_auth_mode'] = array('', 'wep', 'wpa', 'off'); - $drop['wireless_key_length'] = array('', '64', '128', '256'); - $drop['wireless_channel'] = array('', '1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14'); - $drop['wireless_frequency'] = array('', '2.412G', '2.417G', '2.422G', '2.427G', '2.432G', '2.437G', '2.442G', - '2.447G', '2.452G', '2.457G', '2.462G', '2.467G', '2.472G', '2.484G'); - $drop['wireless_key'] = 'password'; - $drop['wireless_key_ascii'] = 'password'; - - // GGF. NEUEN DATENSATZ EINFÜGEN - if(isset($_POST['do_add'])) - { - list($bla,$what) = explode(' ',$_POST['do_add']); - if($what=='COMMENT') sqladd('cfg_comments', array('serial'=>$id)); - else if($what=='PRINTER') sqladd('cfg_printers', array('serial'=>$id)); - else if($what=='MODULE') sqladd('cfg_modules', array('serial'=>$id)); - 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)); - else if($what=='MENUITEM') sqladd('cfg_other_menuitems', array('serial'=>$id)); - } - - - // GGF. SPEICHERN - if($_POST['do_upl']) - { - function postarr($prefix) - { - $prefix.='_'; - $prelen = strlen($prefix); - - $arr = array(); - foreach($_POST as $k=>$v) - if((substr($k,0,$prelen)==$prefix) && ($v!='KEEPPASS')) - $arr[substr($k,$prelen)] = stripslashes($v); - - return $arr; - } - - foreach($tabs as $k=>$t) - { - if(!$multi[$k]) mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t)).' WHERE serial='.$id); - else - { - $i=0; - while(isset($_POST[$t.'_'.$i.'_id'])) - { - if($_POST[$t.'_'.$i.'_delete']) - mysql_query('DELETE FROM '.$t.' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']); - else - mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t.'_'.$i)).' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']); - $i++; - } - } - } - } - - - // EINLESEN DER DATEN AUS SQL-TABELLEN - foreach($tabs as $k=>$t) - { - if($multi[$k]) $data[$t] = sqlarr('SELECT * FROM '.$t.' WHERE serial='.$id); - else $data[$t] = sqlfirst('SELECT * FROM '.$t.' WHERE serial='.$id); - } - - - - - // ANZEIGEN - KLAPPFUNKTIONEN - $absnames = array(); - - function openabs($heading, $helpfile='') - { - global $absnames; - $absnames[] = $heading; - - //
- - echo '

['.$heading.']'; - if($helpfile!='') echo ' [?]'; - echo '

'; - } - - function closeabs() - { - //
- - echo '

'; - } - - - // ANZEIGEN - - function parsearr($name, $arr, $del=false, $wireless=false) - { - global $drop; - global $id; - - $parts = explode('_',$name); $helpfile='help.php?page='.$parts[1]; - openabs($name, $helpfile); - echo ''; - - foreach($arr as $k=>$v) - { - if( (substr($k,0,9)=='wireless_') xor $wireless ) Continue; - - $d = $drop[$name.'_'.$k]; if($d==null) $d = $drop[$k]; - $k = str_replace('wireless_', '', $k); - $k2 = $k; - - if(is_array($d)) - { - echo ''; - } - else if($d=='hidden') echo ''; - else if($d=='1') echo ''; - else if($d=='monitorid') echo ''; - else if($d=='bold') echo ''; - else if($d=='filename') echo ''; - else if($d=='show') echo ''; - else if($d=='showtime') echo ''; - else if($d=='password' && $v=='') echo ''; - else if($d=='password') echo ''; - else if($d=='txt') echo ''; - else if($d!='ignore') echo ''; - } - - if($del) echo ''; - echo '

'.$k2.'	=


'.$k2.'	=
'.$k2.'	=
filename	=
'.$k2.'	= '.$v.'
'.$k2.'	= '.date('d.m.y - H:i:s', $v).'
'.$k2.'	=
'.$k2.'	=
'.$v.'
'.$k2.'	=
delete	=

'; - closeabs(); - - if($name=='cfg_network' && !$wireless) parsearr($name.'_wireless', $arr, $del, true); - } - function parsearrs($name, $arr) - { - foreach($arr as $k=>$a) - parsearr($name.'_'.$k, $a, true); - } - - ?> - ALX Config - - - - - - '; - echo '

'; - echo ''; - echo ''; - - // ANZEIGEN => NON-MULTI TABELLEN - echo '

'; - - echo ''; - echo ' OPEN... '; - echo ' CLOSE... ALL'; - echo '

'; - - foreach($tabs as $k=>$t) if(!$multi[$k]) parsearr($t, $data[$t]); - - // ANZEIGEN => MULTI TABELLEN - echo '

'; - - foreach($tabs as $k=>$t) if($multi[$k]) parsearrs($t, $data[$t]); - - echo ''; - - // ANZEIGEN => NAVI - echo '

'; - - // STATUS BESTIMMEN (ON/OFF) - $conn = sqlfirst('SELECT * FROM state_connected WHERE serial='.$id); - $state = 'Off'; - if(count($conn)>0) - { - passthru("/usr/sbin/fping -c 1 -i 50 -q ".$conn['ip']." &> /dev/null && exit 0 || exit 1",$retval); - if($retval==0) $state = 'On'; - } - - - echo '

'; - - echo '

'; - - echo '
'; - echo '
'; - echo '
'; - echo '
'; - echo '

'; - - - if($id>0) $KILLCAP='DEACTIVATE'; else $KILLCAP='ACTIVATE'; - echo '
'; - echo '
'; - echo '

'; - - $davor = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id-1),'mac')!=null; if($davor) $disdavor=''; else $disdavor = 'disabled=1'; - $danach = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id+1),'mac')!=null; if($danach) $disdanach=''; else $disdanach = 'disabled=1'; - - echo ''; - echo ''; - echo ''; - echo '

'; - - echo '

'; - echo '

'; - if($id<0) echo 'DEACTIVATED!

'; - echo 'Serial: #'.$id.'
'; - echo 'Stand: '.date('H:i:s').'
'; - echo 'Status: '.$state.'line
'; - if($state=='On') echo 'IP: '.$conn['ip']; - - echo '

'; - //echo '

'; - - if($state=='On') - { - echo '
'; - echo '
'; - - echo '
'; - echo '

'; - echo 'Client Update:

'; - echo '
'; - echo '
'; - echo '
'; - } - else - echo '
'; - - echo '
[ChangeLog] [FAQs]'; - - echo '

'; - echo '

'; -?> +'; + echo '

'; + + if($id<0) echo 'ACTIVATED #'.abs($id); + else echo 'DEACTIVATED #'.$id; + + echo '

'; + return true; + } + + + // FELD-DEFINITIONEN (ARRAY=>DROPDOWN / HIDDEN / IGNORE / 1 / BOLD / PASSWORD / SHOW / SHOWTIME / MONITORID) + $drop = array(); + $drop['cfg_graphic_module'] = array('vesa', 'ati', 'cirrus', 'i810', 'i710', 'nv', 'mga', 'r128', 'radeon', 's3', 's3virge', 'sis', 'trident', 'tseng', 'via'); + $drop['resolution'] = array('640x480', '800x600', '1024x768', '1280x1024', '1600x1200'); + $drop['depth'] = array('24', '16', '8'); + $drop['mouse'] = array('Auto', 'IMPS/2', 'PS/2'); + $drop['cfg_network_module'] = array('3c59x', '8139too', '8139cp', 'e100', 'ne2k-pci', 'pcnet32', 'sis900', 'via-rhine', 'zd1211'); + $drop['networking'] = array('dhcp', 'static'); + $drop['port'] = array('lpt1', 'com1', 'com2', 'lpd', 'socket', 'ipp'); + $drop['location'] = sqlarr('SELECT location FROM client_locations', '', 'location'); + $drop['id'] = 'hidden'; + $drop['flg_modified'] = '1'; + $drop['serial'] = 'ignore'; + $drop['monitorid'] = 'monitorid'; + $drop['hostname'] = 'bold'; + $drop['session'] = 'bold'; + $drop['cfg_autostart_session'] = 'filename'; + $drop['mtime'] = 'showtime'; + $drop['mac'] = 'show'; + $drop['client_serials_serial'] = 'show'; + $drop['password'] = 'password'; + $drop['shell'] = 'password'; + $drop['vnc'] = 'password'; + $drop['samba'] = 'password'; + $drop['station'] = 'password'; + $drop['txt'] = 'txt'; + $drop['screensaver'] = array('','blank', 'random', 'ant', 'ant3d', 'apollonian', 'ball', 'bat', 'blot', 'bomb', 'bouboule', + 'bounce', 'braid', 'bubble', 'bug', 'clock', 'coral', 'crystal', 'daisy', 'dclock', 'decay', 'deco', + 'demon', 'dilemma', 'discrete', 'dragon', 'drift', 'euler2d', 'eyes', 'fadeplot', 'fiberlamp', 'flag', + 'flame', 'flow', 'forest', 'galaxy', 'goop', 'grav', 'helix', 'hop', 'hyper', 'ico', 'ifs', 'image', + 'juggle', 'julia', 'kaleid', 'kumppa', 'laser', 'life', 'life1d', 'life3d', 'lightning', 'lisa', 'lissie', + 'loop', 'lyapunov', 'mandelbrot', 'marquee', 'matrix', 'maze', 'mountain', 'munch', 'nose', 'pacman', + 'penrose', 'petal', 'petri', 'polyominoes', 'puzzle', 'pyro', 'qix', 'roll', 'rotor', 'scooter', 'shape', + 'sierpinski', 'slip', 'solitare', 'space', 'sphere', 'spiral', 'spline', 'star', 'starfish', 'strange', + 'swarm', 'swirl', 't3d', 'tetris', 'thornbird', 'tik_tak', 'toneclock', 'triangle', 'tube', 'turtle', + 'vines', 'voters', 'wator', 'wire', 'world', 'worm', 'xcl', 'xjack'); + $drop['iface'] = array('eth0', 'wlan0'); + + + // ACHTUNG!!! wlan_-Felder heißen eigentlich wireless_ + $drop['wireless_mode'] = array('', 'managed', 'ad-hoc', 'master', 'repeater', 'secondary', 'monitor', 'auto'); + $drop['wireless_auth_mode'] = array('', 'wep', 'wpa', 'off'); + $drop['wireless_key_length'] = array('', '64', '128', '256'); + $drop['wireless_channel'] = array('', '1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14'); + $drop['wireless_frequency'] = array('', '2.412G', '2.417G', '2.422G', '2.427G', '2.432G', '2.437G', '2.442G', + '2.447G', '2.452G', '2.457G', '2.462G', '2.467G', '2.472G', '2.484G'); + $drop['wireless_key'] = 'password'; + $drop['wireless_key_ascii'] = 'password'; + + // GGF. NEUEN DATENSATZ EINFÜGEN + if(isset($_POST['do_add'])) + { + list($bla,$what) = explode(' ',$_POST['do_add']); + if($what=='COMMENT') sqladd('cfg_comments', array('serial'=>$id)); + else if($what=='PRINTER') sqladd('cfg_printers', array('serial'=>$id)); + else if($what=='MODULE') sqladd('cfg_modules', array('serial'=>$id)); + 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)); + else if($what=='MENUITEM') sqladd('cfg_other_menuitems', array('serial'=>$id)); + } + + + // GGF. SPEICHERN + if($_POST['do_upl']) + { + function postarr($prefix) + { + $prefix.='_'; + $prelen = strlen($prefix); + + $arr = array(); + foreach($_POST as $k=>$v) + if((substr($k,0,$prelen)==$prefix) && ($v!='KEEPPASS')) + $arr[substr($k,$prelen)] = stripslashes($v); + + return $arr; + } + + foreach($tabs as $k=>$t) + { + if(!$multi[$k]) mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t)).' WHERE serial='.$id); + else + { + $i=0; + while(isset($_POST[$t.'_'.$i.'_id'])) + { + if($_POST[$t.'_'.$i.'_delete']) + mysql_query('DELETE FROM '.$t.' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']); + else + mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t.'_'.$i)).' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']); + $i++; + } + } + } + } + + + // EINLESEN DER DATEN AUS SQL-TABELLEN + foreach($tabs as $k=>$t) + { + if($multi[$k]) $data[$t] = sqlarr('SELECT * FROM '.$t.' WHERE serial='.$id); + else $data[$t] = sqlfirst('SELECT * FROM '.$t.' WHERE serial='.$id); + } + + + + + // ANZEIGEN - KLAPPFUNKTIONEN + $absnames = array(); + + function openabs($heading, $helpfile='') + { + global $absnames; + $absnames[] = $heading; + + //
+ + echo '

['.$heading.']'; + if($helpfile!='') echo ' [?]'; + echo '

'; + } + + function closeabs() + { + //
+ + echo '

'; + } + + + // ANZEIGEN + + function parsearr($name, $arr, $del=false, $wireless=false) + { + global $drop; + global $id; + + $parts = explode('_',$name); $helpfile='help.php?page='.$parts[1]; + openabs($name, $helpfile); + echo ''; + + foreach($arr as $k=>$v) + { + if( (substr($k,0,9)=='wireless_') xor $wireless ) Continue; + + $d = $drop[$name.'_'.$k]; if($d==null) $d = $drop[$k]; + $k = str_replace('wireless_', '', $k); + $k2 = $k; + + if(is_array($d)) + { + echo ''; + } + else if($d=='hidden') echo ''; + else if($d=='1') echo ''; + else if($d=='monitorid') echo ''; + else if($d=='bold') echo ''; + else if($d=='filename') echo ''; + else if($d=='show') echo ''; + else if($d=='showtime') echo ''; + else if($d=='password' && $v=='') echo ''; + else if($d=='password') echo ''; + else if($d=='txt') echo ''; + else if($d!='ignore') echo ''; + } + + if($del) echo ''; + echo '

'.$k2.'	=


'.$k2.'	=
'.$k2.'	=
filename	=
'.$k2.'	= '.$v.'
'.$k2.'	= '.date('d.m.y - H:i:s', $v).'
'.$k2.'	=
'.$k2.'	=
'.$v.'
'.$k2.'	=
delete	=

'; + closeabs(); + + if($name=='cfg_network' && !$wireless) parsearr($name.'_wireless', $arr, $del, true); + } + function parsearrs($name, $arr) + { + foreach($arr as $k=>$a) + parsearr($name.'_'.$k, $a, true); + } + + ?> + ALX Config + + + + + + '; + echo '

'; + echo ''; + echo ''; + + // ANZEIGEN => NON-MULTI TABELLEN + echo '

'; + + echo ''; + echo ' OPEN... '; + echo ' CLOSE... ALL'; + echo '

'; + + foreach($tabs as $k=>$t) if(!$multi[$k]) parsearr($t, $data[$t]); + + // ANZEIGEN => MULTI TABELLEN + echo '

'; + + foreach($tabs as $k=>$t) if($multi[$k]) parsearrs($t, $data[$t]); + + echo ''; + + // ANZEIGEN => NAVI + echo '

'; + + // STATUS BESTIMMEN (ON/OFF) + $conn = sqlfirst('SELECT * FROM state_connected WHERE serial='.$id); + $state = 'Off'; + if(count($conn)>0) + { + passthru("/usr/sbin/fping -c 1 -i 50 -q ".$conn['ip']." &> /dev/null && exit 0 || exit 1",$retval); + if($retval==0) $state = 'On'; + } + + + echo '

'; + + echo '

'; + + echo '
'; + echo '
'; + echo '
'; + echo '
'; + echo '

'; + + + if($id>0) $KILLCAP='DEACTIVATE'; else $KILLCAP='ACTIVATE'; + echo '
'; + echo '
'; + echo '

'; + + $davor = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id-1),'mac')!=null; if($davor) $disdavor=''; else $disdavor = 'disabled=1'; + $danach = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id+1),'mac')!=null; if($danach) $disdanach=''; else $disdanach = 'disabled=1'; + + echo ''; + echo ''; + echo ''; + echo '

'; + + echo '

'; + echo '

'; + if($id<0) echo 'DEACTIVATED!

'; + echo 'Serial: #'.$id.'
'; + echo 'Stand: '.date('H:i:s').'
'; + echo 'Status: '.$state.'line
'; + if($state=='On') echo 'IP: '.$conn['ip']; + + echo '

'; + //echo '

'; + + if($state=='On') + { + echo '
'; + echo '
'; + + echo '
'; + echo '

'; + echo 'Client Update:

'; + echo '
'; + echo '
'; + echo '
'; + } + else + echo '
'; + + echo '
[ChangeLog] [FAQs]'; + + echo '

'; + echo '

'; +?>