Magellan Linux

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

Parent Directory Parent Directory | Revision Log Revision Log


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