// INCLUDE UND TABELLEN-DEFINITIONEN
include('include/basesql.php');
include('include/common-functions.php');
// INCLUDE CURRENT-PROBLEMS
include('include/current-problems.php');
$tabs = array('cfg_graphic', 'cfg_network', 'cfg_input', 'client_auth', 'cfg_autostart', 'client_serials', 'cfg_comments', 'cfg_printers', 'cfg_sessions_citrix', 'cfg_sessions_storefront', 'cfg_modules', 'cfg_other_menuitems', 'cfg_screensaver', 'client_version');
$multi= array( 0, 0, 0, 0, 1, 0, 1, 1, 1, 1, 1, 1, 0, 0);
$data = array();
// get alx version info for
$alxinfo = sqlfirst('SELECT * FROM client_version WHERE serial='.$id);
$alxos = $alxinfo[os];
$alxutils = $alxinfo[utils];
// get gfxdriver
$gfxinfo = sqlfirst('SELECT * FROM cfg_graphic WHERE serial='.$id);
if($kill==1)
{
foreach($tabs as $t) mysql_query('UPDATE '.$t.' SET serial=-serial WHERE serial='.$id);
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'] = sqlarr('SELECT value FROM values_graphic_module where enabled=1', '', 'value');
if($gfxinfo[module] == 'intel')
{
$drop['cfg_graphic_hdmi'] = array('disable', 'enable');
}
else
{
$drop['cfg_graphic_hdmi'] = 'ignore';
}
$drop['resolution'] = sqlarr('SELECT value FROM values_graphic_resolution where enabled=1', '', 'value');
$drop['depth'] = sqlarr('SELECT value FROM values_graphic_depth where enabled=1', '', 'value');
//$drop['mouse'] = array('Auto', 'IMPS/2', 'PS/2');
//$drop['keyboard'] = array('PC105');
$drop['keymap'] = sqlarr('SELECT value FROM values_input_keymap where enabled=1', '', 'value');
$drop['cfg_network_module'] = sqlarr('SELECT value FROM values_network_module where enabled=1', '', 'value');
$drop['networking'] = array('dhcp', 'static');
$drop['port'] = sqlarr('SELECT value FROM values_printers_port where enabled=1', '', 'value');
//for ($i=0; $i<999; $i++) { $drop['cfg_printers_'.$i.'_ip'] = 'ignore'; }
$drop['share'] = 'ignore';
$drop['location'] = sqlarr('SELECT location FROM client_locations where enabled=1', '', 'location');
$drop['id'] = 'hidden';
$drop['flg_modified'] = '1';
$drop['serial'] = 'ignore';
$drop['monitorid'] = 'ignore';
$drop['refresh_rate'] = sqlarr('SELECT value FROM values_graphic_refresh_rate where enabled=1', '', 'value');
$drop['hostname'] = 'bold';
$drop['session'] = 'bold';
$drop['cfg_autostart_session'] = sqlarr('SELECT filename FROM cfg_sessions_citrix where serial='.$id, '', 'filename');
array_unshift($drop['cfg_autostart_session'], "");
$drop['mtime'] = 'showtime';
$drop['mac'] = 'show';
$drop['client_serials_serial'] = 'show';
//$drop['password'] = 'password';
//$drop['shell'] = 'password';
$drop['client_auth_user'] = 'password';
$drop['root'] = 'password';
$drop['vnc'] = 'password';
$drop['samba'] = 'password';
$drop['station'] = 'password';
$drop['txt'] = 'txt';
$drop['screensaver'] = sqlarr('SELECT value FROM values_screensaver_screensaver where enabled=1', '', 'value');
//$drop['iface'] = array('eth0', 'wlan0');
$drop['client_version_os'] = 'show';
$drop['client_version_utils'] = 'show';
$drop['hwdetected'] = 'ignore';
// 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', 'wpa2', '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';
// get current citrix apps
$citrix_apps = sqlarr('SELECT session FROM values_citrix_session where enabled=1', '', 'session');
// add an empty value add the first position of the array as session-default
array_unshift($citrix_apps, "");
// hackish, fix me
for ($i=0; $i<999; $i++) { $drop['cfg_sessions_citrix_'.$i.'_session'] = $citrix_apps; }
// get current storefront apps
$storefront_apps = sqlarr('SELECT session FROM values_storefront_session where enabled=1', '', 'session');
// add an empty value add the first position of the array as session-default
array_unshift($storefront_apps, "");
// hackish, fix me
for ($i=0; $i<999; $i++) { $drop['cfg_sessions_storefront_'.$i.'_session'] = $storefront_apps; }
// 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-CITRIX') sqladd('cfg_sessions_citrix', array('domain'=>$citrix_domain_name, 'browseradrs'=>$citrix_browseradrs, 'serial'=>$id));
else if($what=='SESSION-STOREFRONT') sqladd('cfg_sessions_storefront', array('domain'=>$storefront_domain_name, 'store'=>$storefront_store, 'serial'=>$id));
else if($what=='MENUITEM') sqladd('cfg_other_menuitems', array('serial'=>$id));
else if($what=='AUTOSTART') sqladd('cfg_autostart', 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++;
}
}
}
// reload site
header("location: show.php?id=".$id);
}
// 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;
//
if( $_SESSION['openclose'][$heading] )
{
echo ' ['.$heading.']';
if($helpfile!='') echo ' [?]';
echo '
';
}
else
{
echo '
['.$heading.']';
if($helpfile!='') echo '
[?]';
echo '
';
}
}
function closeabs()
{
//
echo '
';
}
// ANZEIGEN
function parsearr($name, $arr, $del=false, $wireless=false)
{
global $drop;
global $id;
global $alxos;
$parts = explode('_',$name); $helpfile='help.php?page='.$parts[1];
openabs($name, $helpfile);
echo '
';
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 '
';
?>