[Firebug-cvs] firebug/web/gmaps db_render_xml.php,1.2,1.3

[Karthik D. <da...@us...>]

Update of /cvsroot/firebug/firebug/web/gmaps
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24193

Modified Files:
	db_render_xml.php 
Log Message:

we have labels now.


Index: db_render_xml.php
===================================================================
RCS file: /cvsroot/firebug/firebug/web/gmaps/db_render_xml.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** db_render_xml.php	8 Jun 2005 22:29:42 -0000	1.2
--- db_render_xml.php	8 Jun 2005 22:40:48 -0000	1.3
***************
*** 42,45 ****
--- 42,51 ----
    }
  
+   $cols = pg_numrows($stat);
+   for($i=0; $i < $cols; $i++) {
+     $header=pg_fetch_row($stat, $i);
+     $labels[$i]=$header[0];
+   }
+ 
    $statement = "SELECT * FROM $tblname";
    $stat = @pg_exec($dbh,$statement);
***************
*** 79,84 ****
  
       foreach ($row as $key => $value) {
!        print "$key"; //$value\n";
!        switch($key) {
           case "latitudedegree":
  	   $latdeg=$value;
--- 85,90 ----
  
       foreach ($row as $key => $value) {
!        //       print "$key"; //$value\n";
!        switch($labels[$key]) {
           case "latitudedegree":
  	   $latdeg=$value;
***************
*** 90,94 ****
  	   $longdeg=$value;
  	   break;
!          case "longitudeminutes":
  	   $longmin=$value;
  	   break;
--- 96,100 ----
  	   $longdeg=$value;
  	   break;
!          case "longitudeminute":
  	   $longmin=$value;
  	   break;
***************
*** 101,107 ****
       $long = $longdeg + ($longmin/60.0);
  
!      //print "$lat,$long";     
  
!      print("<point lat=\"$lat\" lng=-\"$long\"/>\n");//, $lat, $long);// or perr("db_render_xml", "1");
       printf("<icon image=\"%s\" class=\"local\"/>\n", $imgs[0]);
       print("<info>") or perr("db_render_xml","4");
--- 107,113 ----
       $long = $longdeg + ($longmin/60.0);
  
!      print "$lat,$long";     
  
!      print("<point lat=\"$lat\" lng=\"-$long\"/>\n");//, $lat, $long);// or perr("db_render_xml", "1");
       printf("<icon image=\"%s\" class=\"local\"/>\n", $imgs[0]);
       print("<info>") or perr("db_render_xml","4");