[Firebug-cvs] firebug/web db_create.php,1.8,1.9 table_select.php,1.8,1.9

[<che...@us...>]

Update of /cvsroot/firebug/firebug/web
In directory sc8-pr-cvs1:/tmp/cvs-serv11609

Modified Files:
	db_create.php table_select.php 
Log Message:
add rss

Index: db_create.php
===================================================================
RCS file: /cvsroot/firebug/firebug/web/db_create.php,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** db_create.php	18 Jul 2003 20:06:20 -0000	1.8
--- db_create.php	30 Jul 2003 22:16:10 -0000	1.9
***************
*** 38,45 ****
  mysql_query($statement) or die("Error: ".mysql_error()." in creating location atable");
  
! $statement = "CREATE TABLE current (mote_id INTEGER, time TIMESTAMP, temp FLOAT, rel_hum FLOAT, baro_pres FLOAT, cnt INTEGER)";
  mysql_query($statement) or die("Error: ".mysql_error()." in creating current atable");
  
! $statement = "CREATE TABLE cumulative (mote_id INTEGER, time TIMESTAMP, temp FLOAT, rel_hum FLOAT, baro_pres FLOAT, cnt INTEGER)";
  mysql_query($statement) or die("Error: ".mysql_error()." in creating cumulative atable");
  
--- 38,45 ----
  mysql_query($statement) or die("Error: ".mysql_error()." in creating location atable");
  
! $statement = "CREATE TABLE current (mote_id INTEGER, time TIMESTAMP, temp FLOAT, rel_hum FLOAT, baro_pres FLOAT, cnt INTEGER, rss INTEGER)";
  mysql_query($statement) or die("Error: ".mysql_error()." in creating current atable");
  
! $statement = "CREATE TABLE cumulative (mote_id INTEGER, time TIMESTAMP, temp FLOAT, rel_hum FLOAT, baro_pres FLOAT, cnt INTEGER, rss INTEGER)";
  mysql_query($statement) or die("Error: ".mysql_error()." in creating cumulative atable");
  
***************
*** 53,57 ****
  for ($i = 2; $i <= $nummotes+1; $i++) {
  
!   $statement = "insert into current values ($i,NULL,NULL,NULL,NULL,NULL);";
    print "<br />";
    print $statement;
--- 53,57 ----
  for ($i = 2; $i <= $nummotes+1; $i++) {
  
!   $statement = "insert into current values ($i,NULL,NULL,NULL,NULL,NULL,NULL);";
    print "<br />";
    print $statement;

Index: table_select.php
===================================================================
RCS file: /cvsroot/firebug/firebug/web/table_select.php,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** table_select.php	30 Jul 2003 22:04:03 -0000	1.8
--- table_select.php	30 Jul 2003 22:16:10 -0000	1.9
***************
*** 54,58 ****
  <td>Rel. Hum.</td>
  <td>Baro. Pres.</td>
! <td>cnt </td>
  </tr>
  
--- 54,59 ----
  <td>Rel. Hum.</td>
  <td>Baro. Pres.</td>
! <td>Cnt </td>
! <td>Rss </td>
  </tr>
  
***************
*** 86,93 ****
--- 87,100 ----
  }
  
+ if ($rss == "") {
+    $rss = "%";
+ }
+ 
+ 
  $result = mysql_query("select * from $tblname
                         where mote_id like '$mote_id%'
                         and time like      '$time%'
                         and cnt like       '$cnt%'
+                        and rss like       '$rss%'
                         and temp like      '$temp%'
                         and rel_hum like      '$rel_hum%'
***************
*** 125,128 ****
--- 132,139 ----
        print ("<td>");
        print $row["cnt"];
+       print ("</td>");
+ 
+       print ("<td>");
+       print $row["rss"];
        print ("</td>");