Magellan Linux

Diff of /alx-src/branches/alx-web-060/monitor.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 2188 by niro, Mon May 9 16:31:38 2011 UTC revision 2189 by niro, Tue Jun 7 13:05:36 2011 UTC
# Line 1  Line 1 
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    ?>

Legend:
Removed from v.2188  
changed lines
  Added in v.2189