Magellan Linux

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

Parent Directory Parent Directory | Revision Log Revision Log


Revision 355 - (hide annotations) (download)
Mon Oct 10 19:42:06 2005 UTC (18 years, 7 months ago) by niro
File size: 12994 byte(s)
cvs import: alx-web for alxconfig-ng
 - code clean up and
 - reorganized the whole structure

1 niro 355 <?
2     // INCLUDE UND TABELLEN-DEFINITIONEN
3     include('include/basesql.php');
4     $tabs = array('cfg_graphic', 'cfg_network', 'cfg_input', 'client_auth', 'cfg_autostart', 'client_serials', 'cfg_comments', 'cfg_printers', 'cfg_sessions', 'cfg_modules', 'cfg_other_menuitems', 'cfg_screensaver');
5     $multi= array( 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 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');
26     $drop['resolution'] = array('640x480', '800x600', '1024x768', '1280x1024', '1600x1200');
27     $drop['depth'] = array('24', '16', '8');
28     $drop['mouse'] = array('Auto', 'IMPS/2', 'PS/2');
29     $drop['cfg_network_module'] = array('3c59x', '8139too', '8139cp', 'e100', 'ne2k-pci', 'pcnet32', 'sis900', 'via-rhine', 'zd1211');
30     $drop['networking'] = array('dhcp', 'static');
31     $drop['port'] = array('lpt1', 'com1', 'com2', 'lpd', 'socket');
32     $drop['location'] = array('', 'BO', 'HAT', 'LIN');
33     $drop['id'] = 'hidden';
34     $drop['flg_modified'] = '1';
35     $drop['serial'] = 'ignore';
36     $drop['monitorid'] = 'monitorid';
37     $drop['hostname'] = 'bold';
38     $drop['session'] = 'bold';
39     $drop['cfg_autostart_session'] = 'filename';
40     $drop['mtime'] = 'showtime';
41     $drop['mac'] = 'show';
42     $drop['client_serials_serial'] = 'show';
43     $drop['password'] = 'password';
44     $drop['shell'] = 'password';
45     $drop['vnc'] = 'password';
46     $drop['samba'] = 'password';
47     $drop['station'] = 'password';
48     $drop['txt'] = 'txt';
49     $drop['screensaver'] = array('','blank', 'random', 'ant', 'ant3d', 'apollonian', 'ball', 'bat', 'blot', 'bomb', 'bouboule',
50     'bounce', 'braid', 'bubble', 'bug', 'clock', 'coral', 'crystal', 'daisy', 'dclock', 'decay', 'deco',
51     'demon', 'dilemma', 'discrete', 'dragon', 'drift', 'euler2d', 'eyes', 'fadeplot', 'fiberlamp', 'flag',
52     'flame', 'flow', 'forest', 'galaxy', 'goop', 'grav', 'helix', 'hop', 'hyper', 'ico', 'ifs', 'image',
53     'juggle', 'julia', 'kaleid', 'kumppa', 'laser', 'life', 'life1d', 'life3d', 'lightning', 'lisa', 'lissie',
54     'loop', 'lyapunov', 'mandelbrot', 'marquee', 'matrix', 'maze', 'mountain', 'munch', 'nose', 'pacman',
55     'penrose', 'petal', 'petri', 'polyominoes', 'puzzle', 'pyro', 'qix', 'roll', 'rotor', 'scooter', 'shape',
56     'sierpinski', 'slip', 'solitare', 'space', 'sphere', 'spiral', 'spline', 'star', 'starfish', 'strange',
57     'swarm', 'swirl', 't3d', 'tetris', 'thornbird', 'tik_tak', 'toneclock', 'triangle', 'tube', 'turtle',
58     'vines', 'voters', 'wator', 'wire', 'world', 'worm', 'xcl', 'xjack');
59     $drop['iface'] = array('eth0', 'wlan0');
60     $drop['wireless_mode'] = array('managed', 'ad-hoc', 'master', 'repeater', 'secondary', 'monitor', 'auto');
61     $drop['wireless_auth_mode'] = array('wep', 'wpa', 'off');
62     //$drop['wireless_key_length'] = array('64', '128', '256');
63    
64     // GGF. NEUEN DATENSATZ EINFÜGEN
65     if(isset($_POST['do_add']))
66     {
67     list($bla,$what) = explode(' ',$_POST['do_add']);
68     if($what=='COMMENT') sqladd('cfg_comments', array('serial'=>$id));
69     else if($what=='PRINTER') sqladd('cfg_printers', array('serial'=>$id));
70     else if($what=='MODULE') sqladd('cfg_modules', array('serial'=>$id));
71     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));
72     else if($what=='MENUITEM') sqladd('cfg_other_menuitems', array('serial'=>$id));
73     }
74    
75    
76     // GGF. SPEICHERN
77     if($_POST['do_upl'])
78     {
79     function postarr($prefix)
80     {
81     $prefix.='_';
82     $prelen = strlen($prefix);
83    
84     $arr = array();
85     foreach($_POST as $k=>$v)
86     if((substr($k,0,$prelen)==$prefix) && ($v!='KEEPPASS'))
87     $arr[substr($k,$prelen)] = stripslashes($v);
88    
89     return $arr;
90     }
91    
92     foreach($tabs as $k=>$t)
93     {
94     if(!$multi[$k]) mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t)).' WHERE serial='.$id);
95     else
96     {
97     $i=0;
98     while(isset($_POST[$t.'_'.$i.'_id']))
99     {
100     if($_POST[$t.'_'.$i.'_delete'])
101     mysql_query('DELETE FROM '.$t.' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);
102     else
103     mysql_query('UPDATE '.$t.' SET '.updatestr(postarr($t.'_'.$i)).' WHERE serial='.$id.' AND id='.$_POST[$t.'_'.$i.'_id']);
104     $i++;
105     }
106     }
107     }
108     }
109    
110    
111     // EINLESEN DER DATEN AUS SQL-TABELLEN
112     foreach($tabs as $k=>$t)
113     {
114     if($multi[$k]) $data[$t] = sqlarr('SELECT * FROM '.$t.' WHERE serial='.$id);
115     else $data[$t] = sqlfirst('SELECT * FROM '.$t.' WHERE serial='.$id);
116     }
117    
118    
119    
120    
121     // ANZEIGEN
122     function parsearr($name, $arr, $del=false)
123     {
124     global $drop;
125     global $id;
126    
127     $parts = explode('_',$name); $helpfile='help.php?page='.$parts[1];
128     echo '<tr><td colspan=2 style="cursor:hand" onclick="window.open(\''.$helpfile.'\', \'HelpWin\', \'width=600,height=500,scrollbars=no\')"><b>['.$name.'] <font color=#626a88><tt>(?)</tt></font></b></td></tr>';
129    
130     foreach($arr as $k=>$v)
131     {
132     $d = $drop[$name.'_'.$k]; if($d==null) $d = $drop[$k];
133    
134     if(is_array($d))
135     {
136     echo '<tr><td>'.$k.'</td><td>= <select style="width:144px" name="'.$name.'_'.$k.'">';
137     foreach($d as $di) if($v==$di) echo '<option selected>'.$di; else echo '<option>'.$di;
138     echo '</select></td></tr>';
139     }
140     else if($d=='hidden') echo '<tr><td colspan=2><input type=hidden name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';
141     else if($d=='1') echo '<tr><td colspan=2><input type=hidden name="'.$name.'_'.$k.'" value="1"></td></tr>';
142     else if($d=='monitorid') echo '<tr><td>'.$k.'</td><td>= <input type=button style="width:24px" onclick="window.open(\'monitor.php?id='.$id.'\', \'MonitorWin\', \'width=350,height=200\')" value="..."></td>';
143     else if($d=='bold') echo '<tr><td>'.$k.'</td><td>= <input style="width:144px;font-weight:bold" name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';
144     else if($d=='filename') echo '<tr><td>filename</td><td>= <input style="width:144px;font-weight:bold" name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';
145     else if($d=='show') echo '<tr><td>'.$k.'</td><td>= <b>'.$v.'</b></td></tr>';
146     else if($d=='showtime') echo '<tr><td>'.$k.'</td><td>= <b>'.date('d.m.y - H:i:s', $v).'</b></td></tr>';
147     else if($d=='password' && $v=='') echo '<tr><td>'.$k.'</td><td>= <input type=password style="width:144px" name="'.$name.'_'.$k.'" value=""></td></tr>';
148     else if($d=='password') echo '<tr><td>'.$k.'</td><td>= <input type=password style="width:144px" name="'.$name.'_'.$k.'" value="KEEPPASS"></td></tr>';
149     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>';
150     else if($d!='ignore') echo '<tr><td>'.$k.'</td><td>= <input style="width:144px" name="'.$name.'_'.$k.'" value="'.$v.'"></td></tr>';
151     }
152    
153     if($del) echo '<tr><td>delete</td><td>=<input type=checkbox name="'.$name.'_delete" value="1"></td></tr>';
154     echo '<tr height=30><td colspan=2></td></tr>';
155     }
156     function parsearrs($name, $arr)
157     {
158     foreach($arr as $k=>$a)
159     parsearr($name.'_'.$k, $a, true);
160     }
161    
162     echo '<head><title>ALX Config - Client #'.$id.'</title></head>';
163     echo '<body>';
164     //echo '<body style="background-image:URL(logo.jpg);background-repeat:no-repeat; background-position:0px 0px; margin-top:25px">';
165     echo '<form action="show.php" method=post onreset="return confirm(\'UNDO CHANGES?\')">';
166     echo '<input type=hidden name="do_upl" value="1">';
167     echo '<input type=hidden name="id" value="'.$id.'">';
168    
169     // ANZEIGEN => NON-MULTI TABELLEN
170     echo '<table><tr><td valign=top width=280>';
171    
172     echo '<table cellpadding=0 cellspacing=0>';
173     foreach($tabs as $k=>$t) if(!$multi[$k]) parsearr($t, $data[$t]);
174     echo '</table>';
175    
176     // ANZEIGEN => MULTI TABELLEN
177     echo '</td><td valign=top width=280>';
178    
179     echo '<table cellpadding=0 cellspacing=0>';
180     foreach($tabs as $k=>$t) if($multi[$k]) parsearrs($t, $data[$t]);
181     echo '</table>';
182    
183     // ANZEIGEN => NAVI
184     echo '</td><td valign=top>';
185    
186     // STATUS BESTIMMEN (ON/OFF)
187     $conn = sqlfirst('SELECT * FROM state_connected WHERE serial='.$id);
188     $state = 'Off';
189     if(count($conn)>0)
190     {
191     passthru("/usr/sbin/fping -c 1 -i 50 -q ".$conn['ip']." &> /dev/null && exit 0 || exit 1",$retval);
192     if($retval==0) $state = 'On';
193     }
194    
195    
196     echo '<img src="pics/logo2.jpg"><br><br>';
197    
198     echo '<input type=submit value="SAVE" style="width:150px"><br><br>';
199    
200     echo '<input type=submit name="do_add" value="SAVE+ADD COMMENT" style="width:150px"><br>';
201     echo '<input type=submit name="do_add" value="SAVE+ADD PRINTER" style="width:150px"><br>';
202     echo '<input type=submit name="do_add" value="SAVE+ADD SESSION" style="width:150px"><br>';
203     echo '<input type=submit name="do_add" value="SAVE+ADD MODULE" style="width:150px"><br>';
204     echo '<input type=submit name="do_add" value="SAVE+ADD MENUITEM" style="width:150px"><br><br>';
205    
206    
207     if($id>0) $KILLCAP='DEACTIVATE'; else $KILLCAP='ACTIVATE';
208     echo '<input 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>';
209     echo '<input type=button value="IMPORT FROM..." style="width:150px" onclick="location.href=\'import.php?id='.$id.'\'"><br>';
210     echo '<input type=reset value="UNDO CHANGES" style="width:150px"><br><br>';
211    
212     $davor = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id-1),'mac')!=null; if($davor) $disdavor=''; else $disdavor = 'disabled=1';
213     $danach = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id+1),'mac')!=null; if($danach) $disdanach=''; else $disdanach = 'disabled=1';
214    
215     echo '<input type=button '.$disdavor.' value="<" style="width:30px" onclick="location.href=\'show.php?id='.($id-1).'\'">';
216     echo '<input type=button value="REFRESH" style="width:90px" onclick="location.href=\'show.php?id='.$id.'\'">';
217     echo '<input type=button '.$disdanach.' value=">" style="width:30px" onclick="location.href=\'show.php?id='.($id+1).'\'">';
218     echo '<br><input type=button value="INDEX" style="width:150px; font-weight:bold" onclick="location.href=\'index.php\'"><br><br>';
219    
220     echo '<br><br>';
221     echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff"><b>';
222     if($id<0) echo '<b>DEACTIVATED!</b><br><br>';
223     echo '<u>Serial:</u>&nbsp;&nbsp;#'.$id.'<br>';
224     echo '<u>Stand:</u>&nbsp;&nbsp;'.date('H:i:s').'<br>';
225     echo '<u>Status:</u> <img src="pics/'.strtolower($state).'line.gif" align=top> '.$state.'line<br>';
226     if($state=='On') echo '<u>IP:</u> '.$conn['ip'];
227    
228     echo '</b></div>';
229     //echo '<br><br>';
230    
231     if($state=='On')
232     {
233     echo '<input 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>';
234     echo '<input 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>';
235    
236     echo '<br>';
237     echo '<div style="border:solid black 1px; padding:5px; background-color:#d5e5ff"><b>';
238     echo 'Client Software Update:<br><br>';
239     echo '<input 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>';
240     echo '<input 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>';
241     echo '<input 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>';
242     echo '</b></div>';
243     }
244     else
245     echo '<input 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>';
246    
247     echo '<br><a href="share/ChangeLog.html">ChangeLog</a>';
248     echo '<br><a href="share/FAQ.html">FAQs</a>';
249    
250     echo '</td></tr></table>';
251     echo '</form>';
252     ?>

Properties

Name Value
svn:executable *