Magellan Linux

Contents of /alx-src/branches/alx-web-070/show.php

Parent Directory Parent Directory | Revision Log Revision Log


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