Magellan Linux

Contents of /alx-src/trunk/alx-web/show.php

Parent Directory Parent Directory | Revision Log Revision Log


Revision 666 - (show annotations) (download)
Fri Mar 27 10:09:48 2009 UTC (15 years, 1 month ago) by niro
File size: 18293 byte(s)
-added more widescreen (19:10) vga resolutions
1 <?
2 // INCLUDE UND TABELLEN-DEFINITIONEN
3 include('include/basesql.php');
4 $tabs = array('cfg_graphic', 'cfg_network', 'cfg_interfaces', 'cfg_input', 'client_auth', 'cfg_autostart', 'client_serials', 'cfg_comments', 'cfg_printers', 'cfg_sessions', 'cfg_modules', 'cfg_other_menuitems', 'cfg_screensaver', 'cfg_theme');
5 $multi= array( 0, 0, 1, 0, 0, 0, 0, 1, 1, 1, 1, 1, 0, 0);
6 $data = array();
7
8 if($kill==1)
9 {
10 foreach($tabs as $t) mysql_query('UPDATE '.$t.' SET serial=-serial WHERE serial='.$id);
11
12 echo '<body onload="window.setTimeout(\'window.close()\', 1750)">';
13 echo '<table width=100% height=100% style="border:solid black 1px; background-color:#d5e5ff"><tr><td valign=middle align=center>';
14
15 if($id<0) echo 'ACTIVATED #'.abs($id);
16 else echo 'DEACTIVATED #'.$id;
17
18 echo '</td></tr></table>';
19 return true;
20 }
21
22
23 // FELD-DEFINITIONEN (ARRAY=>DROPDOWN / HIDDEN / IGNORE / 1 / BOLD / PASSWORD / SHOW / SHOWTIME / MONITORID)
24 $drop = array();
25 $drop['cfg_graphic_module'] = array('vesa', 'ati', 'cirrus', 'i810', 'i710', 'nv', 'mga', 'r128', 'radeon', 's3', 's3virge', 'sis', 'trident', 'tseng', 'via', 'vmware');
26 $drop['resolution'] = array('640x480', '800x600', '1024x768', '1280x960', '1280x1024', '1360x768', '1366x768', '1400x1050', '1600x1200', '1680x1050');
27 $drop['depth'] = array('24', '16', '8');
28 $drop['hz'] = array('auto','60','75','85','100');
29 $drop['mouse'] = array('Auto', 'IMPS/2', 'PS/2');
30 $drop['keyboard'] = array('kbd');
31 //$drop['cfg_network_module'] = array('auto','3c59x', '8139too', '8139cp', 'e100', 'ne2k-pci', 'pcnet32', 'sis900', 'via-rhine', 'zd1211');
32 $drop['module'] = array('auto','3c59x', '8139too', '8139cp', 'e100', 'ne2k-pci', 'pcnet32', 'sis900', 'via-rhine', 'zd1211', 'bnx2', 'dl2k', 'e1000', 'r8169', 'sk98lin', 'tg3', 'via-velocity');
33 $drop['networking'] = array('dhcp', 'static');
34 $drop['default_iface'] = sqlarr('SELECT iface FROM cfg_interfaces where serial='.$id, '', 'iface');
35 $drop['iface'] = 'show';
36 # only support parallel and seriell printing on tinyalx
37 //$drop['port'] = array('lpt1', 'com1', 'com2', 'lpd', 'socket', 'ipp');
38 $drop['port'] = array('lpt1', 'usb1', 'com1', 'com2');
39 $drop['location'] = sqlarr('SELECT location FROM client_locations', '', 'location');
40 $drop['id'] = 'hidden';
41 $drop['flg_modified'] = '1';
42 $drop['serial'] = 'ignore';
43 $drop['monitorid'] = 'monitorid';
44 $drop['hostname'] = 'bold';
45 $drop['session'] = 'bold';
46 $drop['displaymode'] = array('fullscreen', 'seamless', '1280x1024', '1024x768', '800x600');
47 $drop['cfg_autostart_session'] = array('');
48 $drop['cfg_autostart_session'] += sqlarr('SELECT filename FROM cfg_sessions where serial='.$id, 'array', 'filename');
49 $drop['mtime'] = 'showtime';
50 $drop['mac'] = 'show';
51 $drop['client_serials_serial'] = 'show';
52 $drop['password'] = 'password';
53 $drop['shell'] = 'password';
54 $drop['vnc'] = 'password';
55 $drop['samba'] = 'password';
56 $drop['station'] = 'password';
57 $drop['txt'] = 'txt';
58 $drop['screensaver'] = array('','blank', 'random', 'ant', 'ant3d', 'apollonian', 'ball', 'bat', 'blot', 'bomb', 'bouboule',
59 'bounce', 'braid', 'bubble', 'bug', 'clock', 'coral', 'crystal', 'daisy', 'dclock', 'decay', 'deco',
60 'demon', 'dilemma', 'discrete', 'dragon', 'drift', 'euler2d', 'eyes', 'fadeplot', 'fiberlamp', 'flag',
61 'flame', 'flow', 'forest', 'galaxy', 'goop', 'grav', 'helix', 'hop', 'hyper', 'ico', 'ifs', 'image',
62 'juggle', 'julia', 'kaleid', 'kumppa', 'laser', 'life', 'life1d', 'life3d', 'lightning', 'lisa', 'lissie',
63 'loop', 'lyapunov', 'mandelbrot', 'marquee', 'matrix', 'maze', 'mountain', 'munch', 'nose', 'pacman',
64 'penrose', 'petal', 'petri', 'polyominoes', 'puzzle', 'pyro', 'qix', 'roll', 'rotor', 'scooter', 'shape',
65 'sierpinski', 'slip', 'solitare', 'space', 'sphere', 'spiral', 'spline', 'star', 'starfish', 'strange',
66 'swarm', 'swirl', 't3d', 'tetris', 'thornbird', 'tik_tak', 'toneclock', 'triangle', 'tube', 'turtle',
67 'vines', 'voters', 'wator', 'wire', 'world', 'worm', 'xcl', 'xjack');
68 $drop['cfg_theme_theme'] = array('beOSbox','LemonSpace','PinguJessy','prime23-dark','prime23-light');
69
70
71 // ACHTUNG!!! wlan_-Felder heißen eigentlich wireless_
72 $drop['wireless_mode'] = array('', 'managed', 'ad-hoc', 'master', 'repeater', 'secondary', 'monitor', 'auto');
73 $drop['wireless_auth_mode'] = array('', 'wep', 'wpa', 'off');
74 $drop['wireless_key_length'] = array('', '64', '128', '256');
75 $drop['wireless_channel'] = array('', '1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14');
76 $drop['wireless_frequency'] = array('', '2.412G', '2.417G', '2.422G', '2.427G', '2.432G', '2.437G', '2.442G',
77 '2.447G', '2.452G', '2.457G', '2.462G', '2.467G', '2.472G', '2.484G');
78 $drop['wireless_key'] = 'password';
79 $drop['wireless_key_ascii'] = 'password';
80
81 // GGF. NEUEN DATENSATZ EINFÜGEN
82 if(isset($_POST['do_add']))
83 {
84 list($bla,$what) = explode(' ',$_POST['do_add']);
85 if($what=='COMMENT') sqladd('cfg_comments', array('serial'=>$id));
86 else if($what=='PRINTER') sqladd('cfg_printers', array('serial'=>$id));
87 else if($what=='MODULE') sqladd('cfg_modules', array('serial'=>$id));
88 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));
89 else if($what=='MENUITEM') sqladd('cfg_other_menuitems', array('serial'=>$id));
90 }
91
92
93 // GGF. SPEICHERN
94 if($_POST['do_upl'])
95 {
96 function postarr($prefix)
97 {
98 $prefix.='_';
99 $prelen = strlen($prefix);
100
101 $arr = array();
102 foreach($_POST as $k=>$v)
103 if((substr($k,0,$prelen)==$prefix) && ($v!='KEEPPASS'))
104 $arr[substr($k,$prelen)] = stripslashes($v);
105
106 return $arr;
107 }
108
109 foreach($tabs as $k=>$t)
110 {
111 if(!$multi[$k])
112 {
113 mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t)).' WHERE serial='.$id);
114 }
115 else
116 {
117 $i=0;
118 while(isset($_POST[$t.'_'.$i.'_id']))
119 {
120 if($_POST[$t.'_'.$i.'_delete'])
121 mysql_query('DELETE FROM '.$t.' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);
122 else
123 mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t.'_'.$i)).' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);
124 $i++;
125 }
126 }
127 }
128 }
129
130
131 // EINLESEN DER DATEN AUS SQL-TABELLEN
132 foreach($tabs as $k=>$t)
133 {
134 if($multi[$k]) $data[$t] = sqlarr('SELECT * FROM '.$t.' WHERE serial='.$id);
135 else $data[$t] = sqlfirst('SELECT * FROM '.$t.' WHERE serial='.$id);
136 }
137
138
139
140
141 // ANZEIGEN - KLAPPFUNKTIONEN
142 $absnames = array();
143
144 function openabs($heading, $helpfile='')
145 {
146 global $absnames;
147 $absnames[] = $heading;
148
149 // <AufZuLink> <Bild/> <Heading/> </AufZuLink><BR/> <Absatz>
150
151 if( $_SESSION['openclose'][$heading] )
152 {
153 echo '<a href="JavaScript:openclose(\''.$heading.'\',1);"><img border="0" src="pics/minus.gif" title="CLOSE" id="sch_bild_'.$heading.'"> <b>['.$heading.']</b></a>';
154 if($helpfile!='') echo ' <a href="JavaScript:showhelp(\''.$helpfile.'\')" title="HELP">[?]</a>';
155 echo '<br><div id="sch_absatz_'.$heading.'" style="top:0px; visibility:visible">';
156 }
157 else
158 {
159 echo '<a href="JavaScript:openclose(\''.$heading.'\',1);"><img border="0" src="pics/plus.gif" title="OPEN" id="sch_bild_'.$heading.'"> <b>['.$heading.']</b></a>';
160 if($helpfile!='') echo ' <a href="JavaScript:showhelp(\''.$helpfile.'\')" title="HELP">[?]</a>';
161 echo '<br><div id="sch_absatz_'.$heading.'" style="position:absolute; top:0px; visibility:hidden">';
162 }
163 }
164
165 function closeabs()
166 {
167 // </Absatz> <BR/>
168
169 echo '</div><br>';
170 }
171
172
173 // ANZEIGEN
174
175 function parsearr($name, $arr, $del=false, $wireless=false)
176 {
177 global $drop;
178 global $id;
179
180 $parts = explode('_',$name); $helpfile='help.php?page='.$parts[1];
181 openabs($name, $helpfile);
182 echo '<table class="keytab">';
183
184 foreach($arr as $k=>$v)
185 {
186 //if( (substr($k,0,9)=='wireless_') xor $wireless ) Continue;
187
188 $d = $drop[$name.'_'.$k]; if($d==null) $d = $drop[$k];
189 //$k = str_replace('wireless_', '', $k);
190 $k2 = $k;
191
192 if(is_array($d))
193 {
194 echo '<tr><td>'.$k2.'</td><td>= <select style="width:144px" name="'.$name.'_'.$k.'">';
195 foreach($d as $di) if($v==$di) echo '<option selected>'.$di; else echo '<option>'.$di;
196 echo '</select></td></tr>';
197 }
198 else if($d=='hidden') echo '<tr><td colspan=2><input type=hidden name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';
199 else if($d=='1') echo '<tr><td colspan=2><input type=hidden name="'.$name.'_'.$k.'" value="1"></td></tr>';
200 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>';
201 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>';
202 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>';
203 else if($d=='show') echo '<tr><td class="key">'.$k2.'</td><td>= <b>'.$v.'</b></td></tr>';
204 else if($d=='showtime') echo '<tr><td class="key">'.$k2.'</td><td>= <b>'.date('d.m.y - H:i:s', $v).'</b></td></tr>';
205 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>';
206 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>';
207 else if($d=='txt') echo '<tr><td colspan=2><textarea style="width:240px; background-color:#d5e5ff" rows=4 name="'.$name.'_'.$k.'">'.$v.'</textarea></td></tr>';
208 else if($d!='ignore') echo '<tr><td class="key">'.$k2.'</td><td>= <input style="width:144px" name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';
209 }
210
211 if($del) echo '<tr><td class="key">delete</td><td>=<input type=checkbox name="'.$name.'_delete" value="1"></td></tr>';
212 echo '</table>';
213 closeabs();
214
215 //if($name=='cfg_network' && !$wireless) parsearr($name.'_wireless', $arr, $del, true);
216 }
217 function parsearrs($name, $arr)
218 {
219 foreach($arr as $k=>$a)
220 parsearr($name.'_'.$k, $a, true);
221 }
222
223 ?><head>
224 <title>ALX Config</title>
225 <style>
226 body,table { font-family:Tahoma; font-size:10pt }
227 a { color:#000000; text-decoration:none; }
228 .key { width:85px }
229 .keytab, input, textarea, select, option { font-size:8pt; font-family:Tahoma }
230 .but { font-size:10pt; font-family:Tahoma; height:23px }
231 </style>
232 <script language="JavaScript" src="openclose_ajax.js"></script>
233 <script language="JavaScript">
234
235 function openclose(nummer, act)
236 {
237 var bild = document.images['sch_bild_'+nummer];
238 var absatz = document.all['sch_absatz_'+nummer].style;
239 var senden = false;
240
241 if(bild.title == 'OPEN')
242 {
243 if(act<=1)
244 {
245 absatz.visibility = 'visible';
246 absatz.position = '';
247 bild.title = 'CLOSE';
248 bild.src = 'pics/minus.gif';
249 senden = true;
250 act = 0;
251 }
252 }
253 else
254 {
255 if(act>=1)
256 {
257 absatz.visibility = 'hidden';
258 absatz.position = 'absolute';
259 bild.title = 'OPEN';
260 bild.src = 'pics/plus.gif';
261 senden = true;
262 act = 2;
263 }
264 }
265
266 if(senden) sendopenclose(nummer,act);
267 }
268
269 function showhelp(name)
270 { window.open(name, 'HelpWin', 'width=620,height=500,scrollbars=yes'); }
271
272 </script>
273 </head>
274
275 <body><?
276
277
278 //echo '<body style="background-image:URL(logo.jpg);background-repeat:no-repeat; background-position:0px 0px; margin-top:25px">';
279 echo '<form action="show.php" method=post onreset="return confirm(\'UNDO CHANGES?\')">';
280 echo '<input type=hidden name="do_upl" value="1">';
281 echo '<input type=hidden name="id" value="'.$id.'">';
282
283 // ANZEIGEN => NON-MULTI TABELLEN
284 echo '<table><tr><td valign=top width="300">';
285
286 echo '<b style="font-size:6pt">';
287 echo '<a href="JavaScript:opencloseall(0);" title="OPEN ALL"><img src="pics/plus.gif" border="0"> OPEN...</a> ';
288 echo '<a href="JavaScript:opencloseall(2);" title="CLOSE ALL"><img src="pics/minus.gif" border="0"> CLOSE...</a> ALL';
289 echo '</b><br><br>';
290
291 foreach($tabs as $k=>$t) if(!$multi[$k]) parsearr($t, $data[$t]);
292
293 // ANZEIGEN => MULTI TABELLEN
294 echo '</td><td valign=top width="300">';
295
296 foreach($tabs as $k=>$t) if($multi[$k]) parsearrs($t, $data[$t]);
297
298 echo '<script language="JavaScript">';
299 echo 'function opencloseall(act) { ';
300
301 foreach($absnames as $absname)
302 echo 'openclose("'.$absname.'", act); ';
303
304 echo '}</script>';
305
306 // ANZEIGEN => NAVI
307 echo '</td><td valign=top>';
308
309 // STATUS BESTIMMEN (ON/OFF)
310 $conn = sqlfirst('SELECT * FROM state_connected WHERE serial='.$id);
311 $state = 'Off';
312 if(count($conn)>0)
313 {
314 passthru("/usr/sbin/fping -c 1 -i 50 -q ".$conn['ip']." &> /dev/null && exit 0 || exit 1",$retval);
315 if($retval==0) $state = 'On';
316 }
317
318
319 echo '<img src="pics/logo2.jpg"><br><br>';
320
321 echo '<input class="but" type=submit value="SAVE" style="width:150px"><br><br>';
322
323 echo '<input class="but" type=submit name="do_add" value="SAVE+ADD COMMENT" style="width:150px"><br>';
324 echo '<input class="but" type=submit name="do_add" value="SAVE+ADD PRINTER" style="width:150px"><br>';
325 echo '<input class="but" type=submit name="do_add" value="SAVE+ADD SESSION" style="width:150px"><br>';
326 echo '<input class="but" type=submit name="do_add" value="SAVE+ADD MODULE" style="width:150px"><br>';
327 echo '<input class="but" type=submit name="do_add" value="SAVE+ADD MENUITEM" style="width:150px"><br><br>';
328
329
330 if($id>0) $KILLCAP='DEACTIVATE'; else $KILLCAP='ACTIVATE';
331 echo '<input class="but" type=button value="'.$KILLCAP.'" style="width:150px" onclick="if(confirm(\''.$KILLCAP.' CLIENT #'.abs($id).' ?\')) { window.open(\'show.php?id='.$id.'&kill=1\', \'DeactWin\', \'width=200,height=100\'); location.href=\'index.php\'; }"><br>';
332 echo '<input class="but" type=button value="IMPORT FROM..." style="width:150px" onclick="location.href=\'import.php?id='.$id.'\'"><br>';
333 echo '<input class="but" type=reset value="UNDO CHANGES" style="width:150px"><br><br>';
334
335 $davor = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id-1),'mac')!=null; if($davor) $disdavor=''; else $disdavor = 'disabled=1';
336 $danach = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id+1),'mac')!=null; if($danach) $disdanach=''; else $disdanach = 'disabled=1';
337
338 echo '<input class="but" type=button '.$disdavor.' value="<" style="width:30px" onclick="location.href=\'show.php?id='.($id-1).'\'">';
339 echo '<input class="but" type=button value="REFRESH" style="width:90px" onclick="location.href=\'show.php?id='.$id.'\'">';
340 echo '<input class="but" type=button '.$disdanach.' value=">" style="width:30px" onclick="location.href=\'show.php?id='.($id+1).'\'">';
341 echo '<br><input class="but" type=button value="INDEX" style="width:150px; font-weight:bold" onclick="location.href=\'index.php\'"><br><br>';
342
343 echo '<br><br>';
344 echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff"><b>';
345 if($id<0) echo '<b>DEACTIVATED!</b><br><br>';
346 echo '<u>Serial:</u>&nbsp;&nbsp;#'.$id.'<br>';
347 echo '<u>Stand:</u>&nbsp;&nbsp;'.date('H:i:s').'<br>';
348 echo '<u>Status:</u> <img src="pics/'.strtolower($state).'line.gif" align=top> '.$state.'line<br>';
349 if($state=='On')
350 {
351 echo '<u>IP:</u> '.$conn['ip'].'<br><br>';
352 $pubkey = mysql_query('select public_key from ssh_auth_clients where serial='.$id.'');
353 while ($row = mysql_fetch_row ($pubkey)) {
354 # schreiben der .ssh/known_hosts file mit dem public rsa key des client,
355 # um die "yes" abfrage zu vermeiden
356 $hostfile = fopen ($home."/.ssh/known_hosts","w");
357 fwrite($hostfile,$conn['ip']." ".$row[0],strlen($row[0])+strlen($conn['ip'])+1);
358 fclose($hostfile);
359
360 $osver = exec($sshcmd.' -l root '.$conn['ip'].' \'os_ver=$(<'.$mageversion.');cfg_ver=$(/sbin/magequery -n '.$alxconfig.'|cut -d" " -f5);pname=${cfg_ver%-*-*};cfg_ver=${cfg_ver/${pname}-};echo "${os_ver}:${cfg_ver}"\'');
361 $osver = explode(':',$osver);
362 }
363 if($osver[0] == '') $osver[0]='unkown';
364 if($osver[1] == '') $osver[1]='unkown';
365 echo '<u>OS:</u> '.$osver[0].'<br>';
366 echo '<u>Utils:</u> '.$osver[1].'<br>';
367 }
368
369 echo '</b></div>';
370 //echo '<br><br>';
371
372 if($state=='On')
373 {
374 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>';
375 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=halt\', \'ShutdownWin\', \'width=200,height=100\')"><br>';
376
377 echo '<br>';
378 echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff" align="center"><b>';
379 echo 'Client Update:</b></div>';
380 echo '<input class="but" type=button value="UPDATE MAGE DB" style="width:150px" onclick="if(confirm(\'UPDATE DB ON CLIENT #'.$id.' ?\')) window.open(\'mageupgrade.php?client='.$id.'&ip='.$conn['ip'].'&op=update\', \'ShutdownWin\', \'width=800,height=600\')"><br>';
381 echo '<input class="but" type=button value="CALC DEPS" style="width:150px" onclick="if(confirm(\'CALC DEPS FOR CLIENT #'.$id.' ?\')) window.open(\'mageupgrade.php?client='.$id.'&ip='.$conn['ip'].'&op=calc\', \'ShutdownWin\', \'width=800,height=600\')"><br>';
382 echo '<input class="but" type=button value="UPGRADE CLIENT" style="width:150px" onclick="if(confirm(\'UPGRADE ALL PACKAGES ON CLIENT #'.$id.' ?\')) window.open(\'mageupgrade.php?client='.$id.'&ip='.$conn['ip'].'&op=upgrade\', \'ShutdownWin\', \'width=800,height=600\')"><br>';
383 }
384 else
385 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>';
386
387 echo '<br><center><a href="share/ChangeLog.html" target="_blank">[ChangeLog]</a> <a href="share/FAQ.html" target="_blank">[FAQs]</a></center>';
388
389 echo '</td></tr></table>';
390 echo '</form>';
391 ?>

Properties

Name Value
svn:executable *