1 |
<? |
<? |
|
include('include/basesql.php'); |
|
2 |
|
|
3 |
$step = (integer)$step; |
include('include/basesql.php'); |
4 |
$mon = sqlfirst('SELECT * FROM list_monitors WHERE id='.sqlfirst('SELECT monitorid FROM cfg_graphic WHERE serial='.$id, 'monitorid')); |
|
5 |
if(count($mon)==0) $mon = array('id'=>0, 'vendor'=>'AutoDetect'); |
$step = (integer)$step; |
6 |
|
$mon = sqlfirst('SELECT * FROM list_monitors WHERE id='.sqlfirst('SELECT monitorid FROM cfg_graphic WHERE serial='.$id, 'monitorid')); |
7 |
|
if(count($mon)==0) $mon = array('id'=>0, 'vendor'=>'AutoDetect'); |
8 |
|
|
9 |
echo '<img src="pics/logo2.jpg" align=top> <u><b>Montior for #'.$id.'</b></u>'; |
echo '<img src="pics/logo2.jpg" align=top> <u><b>Montior for #'.$id.'</b></u>'; |
10 |
|
|
11 |
echo '<form action="monitor.php" method=get>'; |
echo '<form action="monitor.php" method=get>'; |
12 |
echo '<input type=hidden name="id" value="'.$id.'">'; |
echo '<input type=hidden name="id" value="'.$id.'">'; |
13 |
|
|
14 |
function drawmon($dat, $k) |
function drawmon($dat, $k) |
15 |
{ |
{ |
16 |
global $mon; |
global $mon; |
17 |
if($mon[$k]==$dat[$k]) echo '<option style="font-weight:bold" selected>'.$dat[$k]; |
if($mon[$k]==$dat[$k]) echo '<option style="font-weight:bold" selected>'.$dat[$k]; |
18 |
else echo '<option>'.$dat[$k]; |
else echo '<option>'.$dat[$k]; |
19 |
} |
} |
20 |
|
|
21 |
if($step==0) |
if($step==0) |
22 |
{ |
{ |
23 |
echo '<input type=hidden name="step" value="1">'; |
echo '<input type=hidden name="step" value="1">'; |
24 |
echo '<br><br><br>Select monitor vendor:<br>'; |
echo '<br><br><br>Select monitor vendor:<br>'; |
25 |
echo '<select name="vendor">'; |
echo '<select name="vendor">'; |
26 |
|
|
27 |
drawmon(array('vendor'=>'AutoDetect'), 'vendor'); |
drawmon(array('vendor'=>'AutoDetect'), 'vendor'); |
28 |
sqlforeach('SELECT DISTINCT vendor FROM list_monitors ORDER by vendor ASC', 'drawmon', 'vendor'); |
sqlforeach('SELECT DISTINCT vendor FROM list_monitors ORDER by vendor ASC', 'drawmon', 'vendor'); |
|
|
|
|
echo '</select>'; |
|
|
echo '<input type=submit value=">>">'; |
|
|
} |
|
|
else if($step==1) |
|
|
{ |
|
|
if($vendor=='AutoDetect') { $step=50; $sel=0; } |
|
|
else |
|
|
{ |
|
|
echo '<input type=hidden name="step" value="2">'; |
|
|
echo '<input type=hidden name="vendor" value="'.$vendor.'">'; |
|
|
|
|
|
echo '<b>Vendor:</b> '.$vendor.'<br><br><br>'; |
|
|
echo 'Select monitor model:<br>'; |
|
|
|
|
|
echo '<input type=button value="<<" onclick="location.href=\'monitor.php?id='.$id.'\'">'; |
|
|
echo '<select name="model">'; |
|
|
|
|
|
sqlforeach('SELECT DISTINCT model FROM list_monitors WHERE vendor=\''.redir($vendor).'\' ORDER BY model ASC', 'drawmon', 'model'); |
|
29 |
|
|
30 |
echo '</select>'; |
echo '</select>'; |
31 |
echo '<input type=submit value=">>">'; |
echo '<input type=submit value=">>">'; |
32 |
} |
} |
33 |
} |
else if($step==1) |
34 |
else if($step==2) |
{ |
35 |
{ |
if($vendor=='AutoDetect') { $step=50; $sel=0; } |
36 |
$matches = sqlarr('SELECT id, concat(\'Size: \',size,\' - HSync: \',hsync,\' - VRefresh: \',vrefresh) data FROM list_monitors WHERE vendor=\''.redir($vendor).'\' and model=\''.redir($model).'\''); |
else |
37 |
|
{ |
38 |
if(count($matches)==1) { $step=50; $sel=$matches[0]['id']; } |
echo '<input type=hidden name="step" value="2">'; |
39 |
else |
echo '<input type=hidden name="vendor" value="'.$vendor.'">'; |
40 |
{ |
|
41 |
echo '<input type=hidden name="step" value="50">'; |
echo '<b>Vendor:</b> '.$vendor.'<br><br><br>'; |
42 |
echo '<input type=hidden name="vendor" value="'.$vendor.'">'; |
echo 'Select monitor model:<br>'; |
43 |
echo '<input type=hidden name="model" value="'.$model.'">'; |
|
44 |
|
echo '<input type=button value="<<" onclick="location.href=\'monitor.php?id='.$id.'\'">'; |
45 |
echo '<b>Vendor:</b> '.$vendor.'<br>'; |
echo '<select name="model">'; |
46 |
echo '<b>Model:</b> '.$model.'<br><br>'; |
|
47 |
echo 'Select monitor:<br>'; |
sqlforeach('SELECT DISTINCT model FROM list_monitors WHERE vendor=\''.redir($vendor).'\' ORDER BY model ASC', 'drawmon', 'model'); |
|
|
|
|
echo '<input type=button value="<<" onclick="location.href=\'monitor.php?id='.$id.'&step=1&vendor='.urlencode($vendor).'\'">'; |
|
|
echo '<select name="sel">'; |
|
|
|
|
|
foreach($matches as $m) |
|
|
{ |
|
|
if($m['id']==$mon['id']) echo '<option value="'.$m['id'].'" style="font-weight:bold" selected>'.$m['data']; |
|
|
else echo '<option value="'.$m['id'].'">'.$m['data']; |
|
|
} |
|
|
|
|
|
echo '</select>'; |
|
|
echo '<input type=submit value=">>">'; |
|
|
} |
|
|
} |
|
|
|
|
|
if($step==50) |
|
|
{ |
|
|
mysql_query('UPDATE cfg_graphic SET monitorid='.$sel.' WHERE serial='.$id); |
|
|
echo '<script language=JavaScript>window.setTimeout(\'window.close()\', 1400);</script>'; |
|
|
echo '<big><b>MonitorID saved!</b></big>'; |
|
|
} |
|
48 |
|
|
|
echo '</form>'; |
|
|
?> |
|
49 |
|
echo '</select>'; |
50 |
|
echo '<input type=submit value=">>">'; |
51 |
|
} |
52 |
|
} |
53 |
|
else if($step==2) |
54 |
|
{ |
55 |
|
$matches = sqlarr('SELECT id, concat(\'Size: \',size,\' - HSync: \',hsync,\' - VRefresh: \',vrefresh) data FROM list_monitors WHERE vendor=\''.redir($vendor).'\' and model=\''.redir($model).'\''); |
56 |
|
|
57 |
|
if(count($matches)==1) { $step=50; $sel=$matches[0]['id']; } |
58 |
|
else |
59 |
|
{ |
60 |
|
echo '<input type=hidden name="step" value="50">'; |
61 |
|
echo '<input type=hidden name="vendor" value="'.$vendor.'">'; |
62 |
|
echo '<input type=hidden name="model" value="'.$model.'">'; |
63 |
|
|
64 |
|
echo '<b>Vendor:</b> '.$vendor.'<br>'; |
65 |
|
echo '<b>Model:</b> '.$model.'<br><br>'; |
66 |
|
echo 'Select monitor:<br>'; |
67 |
|
|
68 |
|
echo '<input type=button value="<<" onclick="location.href=\'monitor.php?id='.$id.'&step=1&vendor='.urlencode($vendor).'\'">'; |
69 |
|
echo '<select name="sel">'; |
70 |
|
|
71 |
|
foreach($matches as $m) |
72 |
|
{ |
73 |
|
if($m['id']==$mon['id']) echo '<option value="'.$m['id'].'" style="font-weight:bold" selected>'.$m['data']; |
74 |
|
else echo '<option value="'.$m['id'].'">'.$m['data']; |
75 |
|
} |
76 |
|
|
77 |
|
echo '</select>'; |
78 |
|
echo '<input type=submit value=">>">'; |
79 |
|
} |
80 |
|
} |
81 |
|
|
82 |
|
if($step==50) |
83 |
|
{ |
84 |
|
mysql_query('UPDATE cfg_graphic SET monitorid='.$sel.' WHERE serial='.$id); |
85 |
|
echo '<script language=JavaScript>window.setTimeout(\'window.close()\', 1400);</script>'; |
86 |
|
echo '<big><b>MonitorID saved!</b></big>'; |
87 |
|
} |
88 |
|
|
89 |
|
echo '</form>'; |
90 |
|
|
91 |
|
?> |