tags/alx-web-0_7_0_20171218_1/monitor.php

<?
 include('include/basesql.php');

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