Magellan Linux

Contents of /alx-src/tags/alx-web-0_7_0_20170802_2/show.php

Parent Directory Parent Directory | Revision Log Revision Log


Revision 9681 - (show annotations) (download)
Wed Aug 2 15:09:41 2017 UTC (6 years, 8 months ago) by niro
File size: 18373 byte(s)
tagged 'alx-web-0_7_0_20170802_2'
1 <?
2 // INCLUDE UND TABELLEN-DEFINITIONEN
3 include('include/basesql.php');
4 include('include/common-functions.php');
5
6 // INCLUDE CURRENT-PROBLEMS
7 include('include/current-problems.php');
8
9 $tabs = array('cfg_graphic', 'cfg_network', 'cfg_input', 'client_auth', 'cfg_fluxbox_autostart', 'client_serials', 'cfg_comments', 'cfg_printers', 'cfg_sessions_citrix', 'cfg_sessions_storefront', 'cfg_sessions_rdesktop', 'cfg_modules', 'cfg_fluxbox_menuitem', 'cfg_screensaver', 'client_version');
10 $multi= array( 0, 0, 0, 0, 1, 0, 1, 1, 1, 1, 1, 1, 1, 0, 0);
11 $data = array();
12
13 // get alx version info for
14 $alxinfo = sqlfirst('SELECT * FROM client_version WHERE serial='.$id);
15 $alxos = $alxinfo[os];
16 $alxutils = $alxinfo[utils];
17
18 // get gfxdriver
19 $gfxinfo = sqlfirst('SELECT * FROM cfg_graphic WHERE serial='.$id);
20
21 if($kill==1)
22 {
23 if($method=='DEACTIVATE') mysql_query('UPDATE client_serials SET enabled="0" WHERE serial='.$id);
24 else mysql_query('UPDATE client_serials SET enabled="1" WHERE serial='.$id);
25
26 echo '<body onload="window.setTimeout(\'window.close()\', 1750)">';
27 echo '<table width=100% height=100% style="border:solid black 1px; background-color:#d5e5ff"><tr><td valign=middle align=center>';
28
29 if($method=='DEACTIVATE') echo 'DEACTIVATED #'.$id;
30 else echo 'ACTIVATED #'.$id;
31
32 echo '</td></tr></table>';
33 return true;
34 }
35
36 // FELD-DEFINITIONEN (ARRAY=>DROPDOWN / HIDDEN / IGNORE / 1 / BOLD / PASSWORD / SHOW / SHOWTIME / MONITORID)
37 $drop = array();
38 $drop['cfg_graphic_module'] = sqlarr('SELECT value FROM values_graphic_module where enabled=1', '', 'value');
39 if($gfxinfo['module'] == 'intel')
40 {
41 $drop['cfg_graphic_hdmi'] = array('disable', 'enable');
42 }
43 else
44 {
45 $drop['cfg_graphic_hdmi'] = 'ignore';
46 }
47 $drop['resolution'] = sqlarr('SELECT value FROM values_graphic_resolution where enabled=1', '', 'value');
48 $drop['depth'] = sqlarr('SELECT value FROM values_graphic_depth where enabled=1', '', 'value');
49 //$drop['mouse'] = array('Auto', 'IMPS/2', 'PS/2');
50 //$drop['keyboard'] = array('PC105');
51 $drop['keymap'] = sqlarr('SELECT value FROM values_input_keymap where enabled=1', '', 'value');
52 $drop['cfg_network_module'] = sqlarr('SELECT value FROM values_network_module where enabled=1', '', 'value');
53 $drop['networking'] = array('dhcp', 'static');
54 $drop['port'] = sqlarr('SELECT value FROM values_printers_port where enabled=1', '', 'value');
55 //for ($i=0; $i<999; $i++) { $drop['cfg_printers_'.$i.'_ip'] = 'ignore'; }
56 $drop['share'] = 'ignore';
57 $drop['location'] = sqlarr('SELECT location FROM client_locations where enabled=1', '', 'location');
58 $drop['id'] = 'hidden';
59 $drop['flg_modified'] = '1';
60 $drop['serial'] = 'ignore';
61 $drop['monitorid'] = 'ignore';
62 $drop['refresh_rate'] = sqlarr('SELECT value FROM values_graphic_refresh_rate where enabled=1', '', 'value');
63 $drop['hostname'] = 'bold';
64 $drop['session'] = 'bold';
65 $drop['mtime'] = 'showtime';
66 $drop['mac'] = 'show';
67 $drop['client_serials_serial'] = 'show';
68 $drop['password'] = 'password';
69 //$drop['shell'] = 'password';
70 $drop['client_auth_user'] = 'password';
71 $drop['root'] = 'password';
72 $drop['vnc'] = 'password';
73 $drop['samba'] = 'password';
74 $drop['station'] = 'password';
75 $drop['txt'] = 'txt';
76 $drop['screensaver'] = sqlarr('SELECT value FROM values_screensaver_screensaver where enabled=1', '', 'value');
77 //$drop['iface'] = array('eth0', 'wlan0');
78 $drop['client_version_os'] = 'show';
79 $drop['client_version_utils'] = 'show';
80 $drop['hwdetected'] = 'ignore';
81
82 // ACHTUNG!!! wlan_-Felder heißen eigentlich wireless_
83 $drop['wireless_mode'] = sqlarr('SELECT value FROM values_network_wireless_mode where enabled=1', '', 'value');
84 $drop['wireless_auth_mode'] = sqlarr('SELECT value FROM values_network_wireless_auth_mode where enabled=1', '', 'value');
85 $drop['wireless_bitrate'] = sqlarr('SELECT value FROM values_network_wireless_bitrate where enabled=1', '', 'value');
86 $drop['wireless_key_length'] = sqlarr('SELECT value FROM values_network_wireless_key_length where enabled=1', '', 'value');
87 $drop['wireless_channel'] = sqlarr('SELECT value FROM values_network_wireless_channel where enabled=1', '', 'value');
88 $drop['wireless_frequency'] = sqlarr('SELECT value FROM values_network_wireless_frequency where enabled=1', '', 'value');
89 $drop['wireless_key'] = 'password';
90 $drop['wireless_key_ascii'] = 'password';
91
92 // get current citrix apps
93 $citrix_apps = sqlarr('SELECT session FROM values_citrix_session where enabled=1', '', 'session');
94 // add an empty value add the first position of the array as session-default
95 array_unshift($citrix_apps, "");
96 // hackish, fix me
97 for ($i=0; $i<999; $i++) { $drop['cfg_sessions_citrix_'.$i.'_session'] = $citrix_apps; }
98
99 // get current storefront apps
100 $storefront_apps = sqlarr('SELECT session FROM values_storefront_session where enabled=1', '', 'session');
101 // add an empty value add the first position of the array as session-default
102 array_unshift($storefront_apps, "");
103 // hackish, fix me
104 for ($i=0; $i<999; $i++) { $drop['cfg_sessions_storefront_'.$i.'_session'] = $storefront_apps; }
105
106 $drop['enabled'] = 'ignore';
107 $drop['filename'] = 'ignore';
108 $drop['autostart'] = array('0','1');
109
110 // GGF. NEUEN DATENSATZ EINFÜGEN
111 if(isset($_POST['do_add']))
112 {
113 list($bla,$what) = explode(' ',$_POST['do_add']);
114 if($what=='COMMENT') sqladd('cfg_comments', array('serial'=>$id));
115 else if($what=='PRINTER') sqladd('cfg_printers', array('serial'=>$id));
116 else if($what=='MODULE') sqladd('cfg_modules', array('serial'=>$id));
117 else if($what=='SESSION-CITRIX') sqladd('cfg_sessions_citrix', array('domain'=>$citrix_domain_name, 'serverlist'=>$citrix_serverlist, 'serial'=>$id));
118 else if($what=='SESSION-STOREFRONT') sqladd('cfg_sessions_storefront', array('domain'=>$storefront_domain_name, 'store'=>$storefront_store, 'serial'=>$id));
119 else if($what=='SESSION-RDP') sqladd('cfg_sessions_rdesktop', array('domain'=>$rdesktop_domain_name, 'server'=>$rdesktop_server, 'serial'=>$id));
120 else if($what=='MENUITEM') sqladd('cfg_fluxbox_menuitem', array('serial'=>$id));
121 else if($what=='AUTOSTART') sqladd('cfg_fluxbox_autostart', array('serial'=>$id));
122 }
123
124
125 // GGF. SPEICHERN
126 if($_POST['do_upl'])
127 {
128 function postarr($prefix)
129 {
130 $prefix.='_';
131 $prelen = strlen($prefix);
132
133 $arr = array();
134 foreach($_POST as $k=>$v)
135 {
136 if((substr($k,0,$prelen)==$prefix) && ($v!='KEEPPASS'))
137 $arr[substr($k,$prelen)] = stripslashes($v);
138 }
139
140 return $arr;
141 }
142
143 foreach($tabs as $k=>$t)
144 {
145 if(!$multi[$k]) mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t)).' WHERE serial='.$id);
146 else
147 {
148 $i=0;
149 while(isset($_POST[$t.'_'.$i.'_id']))
150 {
151 if($_POST[$t.'_'.$i.'_delete'])
152 mysql_query('DELETE FROM '.$t.' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);
153 else
154 mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t.'_'.$i)).' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);
155 $i++;
156 }
157 }
158 }
159
160 // reload site
161 header("location: show.php?id=".$id);
162 }
163
164 // EINLESEN DER DATEN AUS SQL-TABELLEN
165 foreach($tabs as $k=>$t)
166 {
167 if($multi[$k]) $data[$t] = sqlarr('SELECT * FROM '.$t.' WHERE serial='.$id);
168 else $data[$t] = sqlfirst('SELECT * FROM '.$t.' WHERE serial='.$id);
169 }
170
171 // ANZEIGEN - KLAPPFUNKTIONEN
172 $absnames = array();
173
174 function openabs($heading, $helpfile='')
175 {
176 global $absnames;
177 $absnames[] = $heading;
178
179 // <AufZuLink> <Bild/> <Heading/> </AufZuLink><BR/> <Absatz>
180
181 if( $_SESSION['openclose'][$heading] )
182 {
183 echo '<a href="JavaScript:openclose(\''.$heading.'\',1);"><img border="0" src="pics/minus.gif" title="CLOSE" id="sch_bild_'.$heading.'"> <b>['.$heading.']</b></a>';
184 if($helpfile!='') echo ' <a href="JavaScript:showhelp(\''.$helpfile.'\')" title="HELP">[?]</a>';
185 echo '<br><div id="sch_absatz_'.$heading.'" style="top:0px; visibility:visible">';
186 }
187 else
188 {
189 echo '<a href="JavaScript:openclose(\''.$heading.'\',1);"><img border="0" src="pics/plus.gif" title="OPEN" id="sch_bild_'.$heading.'"> <b>['.$heading.']</b></a>';
190 if($helpfile!='') echo ' <a href="JavaScript:showhelp(\''.$helpfile.'\')" title="HELP">[?]</a>';
191 echo '<br><div id="sch_absatz_'.$heading.'" style="position:absolute; top:0px; visibility:hidden">';
192 }
193 }
194
195 function closeabs()
196 {
197 // </Absatz> <BR/>
198 echo '</div><br>';
199 }
200
201 // ANZEIGEN
202
203 function parsearr($name, $arr, $del=false, $wireless=false)
204 {
205 global $drop;
206 global $id;
207 global $alxos;
208
209 $parts = explode('_',$name); $helpfile='help.php?page='.$parts[1];
210 openabs($name, $helpfile);
211 echo '<table class="keytab">';
212
213 foreach($arr as $k=>$v)
214 {
215 if( (substr($k,0,9)=='wireless_') xor $wireless ) Continue;
216
217 $d = $drop[$name.'_'.$k]; if($d==null) $d = $drop[$k];
218 $k = str_replace('wireless_', '', $k);
219 $k2 = $k;
220
221 # tell something about vesa
222 // if ($v == 'vesa') echo '<br><font color="#FF0000">Warning: "vesa" graphic module doesn\'t support any resolutions higher than 1024x786x16@60hz!</font><br>';
223
224 if(is_array($d))
225 {
226 echo '<tr><td class="key">'.$k2.'</td><td>= <select style="width:144px" name="'.$name.'_'.$k.'">';
227 foreach($d as $di) if($v==$di) echo '<option selected>'.$di; else echo '<option>'.$di;
228 echo '</select></td></tr>';
229 }
230 else if($d=='hidden') echo '<tr><td colspan=2><input type=hidden name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';
231 else if($d=='1') echo '<tr><td colspan=2><input type=hidden name="'.$name.'_'.$k.'" value="1"></td></tr>';
232 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>';
233 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>';
234 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>';
235 else if($d=='show') echo '<tr><td class="key">'.$k2.'</td><td>= <b>'.$v.'</b></td></tr>';
236 else if($d=='showtime') echo '<tr><td class="key">'.$k2.'</td><td>= <b>'.date('d.m.y - H:i:s', $v).'</b></td></tr>';
237 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>';
238 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>';
239 else if($d=='txt') echo '<tr><td colspan=2><textarea style="width:240px; background-color:#d5e5ff" rows=6 name="'.$name.'_'.$k.'">'.$v.'</textarea></td></tr>';
240 else if($d!='ignore') echo '<tr><td class="key">'.$k2.'</td><td>= <input style="width:144px" name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';
241 }
242
243 if($del) echo '<tr><td class="key">delete</td><td>=<input type=checkbox name="'.$name.'_delete" value="1"></td></tr>';
244 echo '</table>';
245 closeabs();
246
247 if($name=='cfg_network' && !$wireless) parsearr($name.'_wireless', $arr, $del, true);
248 }
249
250 function parsearrs($name, $arr)
251 {
252 foreach($arr as $k=>$a)
253 parsearr($name.'_'.$k, $a, true);
254 }
255
256 ?><head>
257 <title>ALX Config</title>
258 <style>
259 body,table { font-family:Tahoma; font-size:10pt }
260 a { color:#000000; text-decoration:none; }
261 .key { width:85px }
262 .keytab, input, textarea, select, option { font-size:8pt; font-family:Tahoma }
263 .but { font-size:10pt; font-family:Tahoma; height:23px }
264 </style>
265 <script type="text/javascript" src="js/jquery-1.2.6.min.js"></script>
266 <script language="JavaScript" src="openclose_ajax.js"></script>
267 <script language="JavaScript">
268
269 // opens an url and shows retval in a javascript-alert on current site
270 function urlopen(url,typ) {
271 var $url = url.split("?");
272 $.ajax({type:""+typ+"",url:$url[0],data:$url[1],cache:false,success:function(data){ alert(data); }});
273 }
274
275 function openclose(nummer, act)
276 {
277 var bild = document.images['sch_bild_'+nummer];
278 var absatz = document.all['sch_absatz_'+nummer].style;
279 var senden = false;
280
281 if(bild.title == 'OPEN')
282 {
283 if(act<=1)
284 {
285 absatz.visibility = 'visible';
286 absatz.position = '';
287 bild.title = 'CLOSE';
288 bild.src = 'pics/minus.gif';
289 senden = true;
290 act = 0;
291 }
292 }
293 else
294 {
295 if(act>=1)
296 {
297 absatz.visibility = 'hidden';
298 absatz.position = 'absolute';
299 bild.title = 'OPEN';
300 bild.src = 'pics/plus.gif';
301 senden = true;
302 act = 2;
303 }
304 }
305 if(senden) sendopenclose(nummer,act);
306 }
307
308 function showhelp(name)
309 { window.open(name, 'HelpWin', 'width=620,height=500,scrollbars=yes'); }
310
311 </script>
312 </head>
313
314 <body><?
315
316 echo '<form action="show.php" method="post" onreset="return confirm(\'UNDO CHANGES?\')">';
317 echo '<input type=hidden name="do_upl" value="1">';
318 echo '<input type=hidden name="id" value="'.$id.'">';
319
320 // ANZEIGEN => NON-MULTI TABELLEN
321 echo '<table><tr><td valign=top width="300">';
322
323 echo '<b style="font-size:6pt">';
324 echo '<a href="JavaScript:opencloseall(0);" title="OPEN ALL"><img src="pics/plus.gif" border="0"> OPEN...</a> ';
325 echo '<a href="JavaScript:opencloseall(2);" title="CLOSE ALL"><img src="pics/minus.gif" border="0"> CLOSE...</a> ALL';
326 echo '</b><br><br>';
327
328 foreach($tabs as $k=>$t) if(!$multi[$k]) parsearr($t, $data[$t]);
329
330 // ANZEIGEN => MULTI TABELLEN
331 echo '</td><td valign=top width="300">';
332
333 foreach($tabs as $k=>$t) if($multi[$k]) parsearrs($t, $data[$t]);
334
335 echo '<script language="JavaScript">';
336 echo 'function opencloseall(act) { ';
337
338 foreach($absnames as $absname)
339 echo 'openclose("'.$absname.'", act); ';
340
341 echo '}</script>';
342
343 // ANZEIGEN => NAVI
344 echo '</td><td valign=top>';
345
346 // STATUS BESTIMMEN (ON/OFF)
347 $conn = sqlfirst('SELECT * FROM state_connected WHERE serial='.$id);
348 $state = 'Off';
349 if(count($conn)>0)
350 {
351 if($retval==0)
352 {
353 $ping_retval = ping_host($conn['ip'],$mcore_port,$ping_timeout);
354 if($ping_retval==0)
355 {
356 $state = 'On';
357 }
358 }
359 }
360
361 echo '<img src="pics/logo2.jpg"><br><br>';
362
363 echo '<input class="but" type=submit value="SAVE" style="width:150px"><br><br>';
364
365 echo '<input class="but" type=submit name="do_add" value="ADD COMMENT" style="width:150px"><br>';
366 echo '<input class="but" type=submit name="do_add" value="ADD PRINTER" style="width:150px"><br>';
367 echo '<input class="but" type=submit name="do_add" value="ADD SESSION-CITRIX" style="width:150px"><br>';
368 echo '<input class="but" type=submit name="do_add" value="ADD SESSION-STOREFRONT" style="width:150px"><br>';
369 echo '<input class="but" type=submit name="do_add" value="ADD SESSION-RDP" style="width:150px"><br>';
370 echo '<input class="but" type=submit name="do_add" value="ADD MODULE" style="width:150px"><br>';
371 echo '<input class="but" type=submit name="do_add" value="ADD MENUITEM" style="width:150px"><br>';
372 echo '<input class="but" type=submit name="do_add" value="ADD AUTOSTART" style="width:150px"><br>';
373 echo '<br>';
374
375 $clientstatus = sqlfirst('SELECT * FROM client_serials WHERE serial='.$id);
376 if($clientstatus['enabled']>0) $KILLCAP='DEACTIVATE'; else $KILLCAP='ACTIVATE';
377 echo '<input class="but" type=button value="'.$KILLCAP.'" style="width:150px" onclick="if(confirm(\''.$KILLCAP.' CLIENT #'.$id.' ?\')) { window.open(\'show.php?id='.$id.'&kill=1&method='.$KILLCAP.'\', \'DeactWin\', \'width=200,height=100\'); location.href=\'index.php\'; }"><br>';
378 echo '<input class="but" type=button value="IMPORT FROM..." style="width:150px" onclick="location.href=\'import.php?id='.$id.'\'"><br>';
379 echo '<input class="but" type=reset value="UNDO CHANGES" style="width:150px"><br><br>';
380
381 $davor = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id-1),'mac')!=null; if($davor) $disdavor=''; else $disdavor = 'disabled=1';
382 $danach = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id+1),'mac')!=null; if($danach) $disdanach=''; else $disdanach = 'disabled=1';
383
384 echo '<input class="but" type=button '.$disdavor.' value="<" style="width:30px" onclick="location.href=\'show.php?id='.($id-1).'\'">';
385 echo '<input class="but" type=button value="REFRESH" style="width:90px" onclick="location.href=\'show.php?id='.$id.'\'">';
386 echo '<input class="but" type=button '.$disdanach.' value=">" style="width:30px" onclick="location.href=\'show.php?id='.($id+1).'\'">';
387 echo '<br><input class="but" type=button value="INDEX" style="width:150px; font-weight:bold" onclick="location.href=\'index.php\'"><br><br>';
388
389 echo '<br>';
390 echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff"><b>';
391 if($id<0) echo '<b>DEACTIVATED!</b><br><br>';
392 echo '<u>Serial:</u>&nbsp;&nbsp;#'.$id.'<br>';
393 echo '<u>Stand:</u>&nbsp;&nbsp;'.date('H:i:s').'<br>';
394 echo '<u>Status:</u> <img src="pics/'.strtolower($state).'line.gif" align=top> '.$state.'line<br>';
395 if($state=='On')
396 {
397 echo '<u>IP:</u> '.$conn['ip'].'<br>';
398 if($conn['netboot'] == 1) echo '<u>Boot:</u> Netboot (PXE)<br>';
399 else echo '<u>Boot:</u> Local Disk<br>';
400 echo '<br>';
401 echo '<u>OS:</u> '.$alxos.'<br>';
402 echo '<u>Utils:</u> '.$alxutils.'<br>';
403 }
404
405 echo '</b></div>';
406
407 if($state=='On')
408 {
409 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>';
410 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=shutdown\', \'ShutdownWin\', \'width=200,height=100\')"><br>';
411 echo '<br>';
412 echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff" align="center"><b>';
413 echo 'Remote Shadow:</b></div>';
414 echo '<input class="but" type=button value="VNC" style="width:75px" onclick="window.open(\'vncviewer.php?ip='.$conn['ip'].'\', \'VncViewer\', \'width=200,height=100\')">';
415 echo '<input class="but" type=button value="SSH" style="width:75px" onclick="window.open(\'mindterm.php?ip='.$conn['ip'].'\', \'MindTerm\', \'width=200,height=100\')">';
416 }
417 else
418 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>';
419
420 // print version info
421 $version = file_get_contents('./VERSION', FILE_USE_INCLUDE_PATH);
422 echo '<br><br><font size="1">v'.$version.'</font>';
423
424 echo '</td></tr></table>';
425 echo '</form>';
426 ?>