[Firebug-cvs] firebug/web/postgres firebug.css,NONE,1.1 main.css,NONE,1.1 db_table_buttons.php,1.3,1.4 db_table_select.php,1.2,1.3

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

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

Modified Files:
	db_table_buttons.php db_table_select.php 
Added Files:
	firebug.css main.css 
Log Message:
Updated the stylesheets

Index: db_table_buttons.php
===================================================================
RCS file: /cvsroot/firebug/firebug/web/postgres/db_table_buttons.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** db_table_buttons.php	6 Jun 2005 19:23:19 -0000	1.3
--- db_table_buttons.php	7 Jun 2005 00:43:19 -0000	1.4
***************
*** 17,21 ****
  } else {
    $rows = pg_numrows($stat);
! 
    for ($i = 0; $i < $rows; $i++) {
      $data = pg_fetch_row($stat, $i);
--- 17,21 ----
  } else {
    $rows = pg_numrows($stat);
! /*
    for ($i = 0; $i < $rows; $i++) {
      $data = pg_fetch_row($stat, $i);
***************
*** 23,26 ****
--- 23,35 ----
      print ("<input type=submit name=tbl1 value=\"" . $data[0] . "\">");
    }
+ */
+   print ("<input type=hidden name=db1 value=\"$dbname\">");
+   print ("<input type=submit value=GO>");
+   print("<select name=tbl1>");
+   for ($i = 0; $i < $rows; $i++) {
+     $data = pg_fetch_row($stat, $i);
+     print ("<option value=$data[0]> $data[0] </option>");
+   }
+   print ("<\select>");
  }
  

--- NEW FILE: main.css ---
BODY, TD, P {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 12px;
    color: #000000;}
.black {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 11px;
    color: #000000;}
.grey {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 13px;
    color: #676767;}
.white {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 12px;
	font-weight: bold;
    color: #FFFFFF;}
	
a.white {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 12px;
	font-weight:bold;
    color: #FFFFFF;}
	
	
.orange {color: #FF6600;}

.titlered {color: #960707; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 18px; font-weight:bold;}
.titleorange {color: #CC6633; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 18px; font-weight:bold;}

.red {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 13px;
    color: #990000;}
	
.small {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; color: #000000; font-weight:normal;}

a.nav-main {
	font-size: 10px;
	color: #FFFFFF;
	font-weight:bold;
	text-decoration:none;
}
a.nav-main:hover {
	font-size: 10px;
	color: #FFF;
	font-weight:bold;
	text-decoration:none;
}
a.nav-sub {
	font-size: 10px;
	color: #FFFFFF;
	text-decoration:none;
}
a.nav-sub:hover {
	font-size: 10px;
	color: #CCCCCC;
	text-decoration:none;
}
	
A {
	font-family: Verdana, Arial, Helvetica, sans-serif;
    color: #0066CC;}
A:HOVER {
	color: #FF9900;
    text-decoration: underline;}
A:HOVER.white {
	color: #FFFFDD;
    text-decoration: underline;}
A:HOVER.black {
	color: #FF9900;
    text-decoration: underline;}
A:HOVER.orange {
	color: #993300;
    text-decoration: underline;}
A.small {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 10px;
    color: #0066CC;}
	

.topnav { font-size: 10px;}
.topnav_active {background-color:#FDCD85; color:#394D73; font-weight: bold; font-size: 10px;}
a.topnav{font-weight: bold; text-decoration:none; color:#394D73;}
a.topnav:hover{background-color:#FDCD85; color:#394D73; text-decoration:none;}
	
.header {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 15px;
    color: #000000;
	font-weight: bold;}
.headerwhite {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 15px;
    color: #FFFFFF;
	font-weight: bold;}


	
.wl	{font-family:verdana, Helvetica, Sans-Serif; 
     font-size: 12px; 
	 font-weight:bold; 
	 color:#666633;}
	 
.wlt			{font-family:verdana, Helvetica, Sans-Serif; font-size: 11px; color:#666633;}
.blueh			{font-family:verdana, Helvetica, Sans-Serif; font-size: 13px;font-weight:bold;color:#336699;}
.bluet			{font-family:verdana, Helvetica, Sans-Serif; font-size: 12px;color:#336699;}
.bluetsml		{font-family:verdana, Helvetica, Sans-Serif; font-size: 10px; color:#336699;}
.bluetout		{font-family:verdana, Helvetica, Sans-Serif; font-size: 10px;color:#336699;}
.boldsmall		{font-family:verdana, Helvetica, Sans-Serif; font-size: 10px;color:#000000; font-weight:bold}

.spacer1p {margin-top:1px;}
.spacer2p {margin-top:2px;}
.spacer4p {margin-top:4px;}
.spacer5p {margin-top:5px;}
.spacer7p {margin-top:7px;}
.spacer10p {margin-top:10px;}
.spacer12p {margin-top:12px;}
.spacer15p {margin-top:15px;}
.spacer20p {margin-top:20px;}
.spacer25p {margin-top:25px;}
.navbox {margin-top:2px;}









TR.NavRow TD {
	vertical-align: middle;
	border: 1px solid;
	border-color: #369 #003 #003;
	border-left: none;
	cursor: pointer;
}

.Nav {
	background-color: #384ccc;
	color: #fff;
	cursor: pointer;
}

.NavText, .NavHighlightText, .NavGroupText {
	font-family: verdana, arial, sans-serif;
	font-size: 10px;
	font-weight: bold;
	line-height: 14px;
	padding-left: 6px;
	text-decoration: none;
}

.Nav A:link, .Nav A:visited { color: #fff; Text-decoration: none;}


.NavHilite {
	background-color: #5A6B94;
	color: #fff;
	
}
.NavHilite A:link, .NavHilite A:visited {
	color: #fff;
}
TR TD.NavHilite A:link, TR TD.NavHilite A:visited {
	text-decoration: none;
}


TR.NavHiliteRow TD {
	vertical-align: middle;
	border: 1px solid;
	border-color: #000 #5A6B94 #000;
	border-left: none;
}
--- NEW FILE: firebug.css ---

table.header { 
   font-weight:bold;
   font-size:30pt;
}

table.code { 
   background-color:#ffff66;
   border:none;
   width:80%;
}

table.db_schema { 
   background-color:#ffff66;
   border-collapse:collapse;
   border-top:double;
   border-bottom:double;
   border-right:double;
   border-left:double;
   border-style:solid;
   align:center;
   /* 
   width:80%;
   font-size:75%;
   */
}

table.new { 
   width:50%;
}


tr.code { 
   /*background-color:#ffff66; */
}

tr.msg_header {  
   background-color:#ffcc00;
   text-align:center;
}

td.code { 
   padding:5px;
   width:100%;
}


h1 {
   background-color:#ffcc00;
   color:#ff3300;
   font-family:tahoma,helvetica,arial;
   font-size:150%;
}

h2 {
   background-color:#ffcc00;
   color:#ff3300;
   font-family:tahoma,helvetica,arial;
   font-size:100%;
}

h3 { 
  color:#0E37D0;
  font-family:Georgia;
  font-weight:bold;
  font-size:200%;
}

h4 {
  /*background-color:#072285;*/
  color:#5A7CFC;
  font-family:Courier New;
  font-style:normal;
  font-weight:bold;
  font-size:150%;
}

p.jazzy { 
  color:#1841D8;
  font-family:Comic Sans MS;
 }

p.nice { 
  color:#465BAA;
  font-family:Lucida Console;
}

pre.code { 
   background-color:#ffff66;
}

code.progname {
   font-weight:bold;
}


BODY {
color:black;
background-color:#FFFFF5;
}


SPAN.title {color:green}
SPAN.author {color:purple;}
SPAN.publication {color:green}
SPAN.fortran {
font-variant: small-caps;
}

span.invisible {
color:#FFFFF5;
}

P.abstract {color:blue;
            margin-left: 10%; 
            /* width: 80%; */
            margin-right: auto;
           /*  background-color: gray; */
}

/*
a:active { 
   color:red;
}

a:visited { 
   color:yellow; 
   background-color:blue;
}

a:link { 
   color:green;
}

a:hover {
   color:green; 
   font:bold;
}
*/



/*
IMG.inlinemath {
text-align: bottom
}
*/


/************************************************/

body {  
    margin:9px 9px 0 9px;
    padding:0;
    background-color:#ffffff;
}

#level0{  
   background-color:#ffcc00;
}

#level1 {  
    margin-left:143px;
    padding-left:9px;
    background-color:#FFFFFF;
}
#level2 {
    background:#FFF3AC;
   position:relative;
}

#level3 {
    margin-right:143px;
    padding-right:9px;
    background:#FFFFFF;
}
#main {
    background:#fff3ac;
}
#topBar {
    background:#ffffff;
}
#advBar {
    background:#fff3ac;
}

#tipDay {
    float:right;
    width:175px;
    background:#FFF3AC;
}

#lftBar {
    position:absolute;
    width:143px;
    top:9px;
    left:9px;
}

#rgtBar {
    position:absolute;
    width:143px;
    top:0;
    right:0;
}
Index: db_table_select.php
===================================================================
RCS file: /cvsroot/firebug/firebug/web/postgres/db_table_select.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** db_table_select.php	19 Aug 2004 21:59:57 -0000	1.2
--- db_table_select.php	7 Jun 2005 00:43:19 -0000	1.3
***************
*** 30,37 ****
  <?php
  
- //if (!isset($HTTP_SESSION_VARS["tblname"])) {
  if ($HTTP_POST_VARS["tbl1"]!=Null){
! $HTTP_SESSION_VARS["tblname"] = $HTTP_POST_VARS["tbl1"];
! $HTTP_SESSION_VARS["dbname"] = $HTTP_POST_VARS["db1"];	
  }
  
--- 30,36 ----
  <?php
  
  if ($HTTP_POST_VARS["tbl1"]!=Null){
!    $HTTP_SESSION_VARS["tblname"] = $HTTP_POST_VARS["tbl1"];
!    $HTTP_SESSION_VARS["dbname"] = $HTTP_POST_VARS["db1"];	
  }
  
***************
*** 54,72 ****
  <?php
  $dbh = connect_postgres($dbname);
! $statement = "SELECT a.attname FROM pg_attribute a,pg_class c where c.relname = '$tblname' and a.attrelid = c.oid and a.attnum > 0";
  $stat = @pg_exec($dbh,$statement);
  if (!$stat) {
    print "<strong>ERROR</strong>: Could not retrieve table header column names for<strong>".strtoupper($tblname)."</strong>.";
! } else {
  
  // Build the table header column names.  Make this into a function.
- 
    print("<tr>\n");
    $cols = pg_numrows($stat);
    for ($i=0 ; $i < $cols; $i++) {
!     print ("<td>");
      $header = pg_fetch_row($stat,$i);
      print $header[0];
!     print ("</td>");
    }
    print("</tr>\n");
--- 53,71 ----
  <?php
  $dbh = connect_postgres($dbname);
! $statement = "SELECT a.attname FROM pg_attribute a,pg_class c where c.relname ='$tblname' and a.attrelid = c.oid and a.attnum > 0";
  $stat = @pg_exec($dbh,$statement);
  if (!$stat) {
    print "<strong>ERROR</strong>: Could not retrieve table header column names for<strong>".strtoupper($tblname)."</strong>.";
! } 
! else {
  
  // Build the table header column names.  Make this into a function.
    print("<tr>\n");
    $cols = pg_numrows($stat);
    for ($i=0 ; $i < $cols; $i++) {
!     print ("<td><b><align=center><h2>");
      $header = pg_fetch_row($stat,$i);
      print $header[0];
!     print ("<//h2></b></td>");
    }
    print("</tr>\n");
***************
*** 82,86 ****
  function print_row($item2,$key) {
      
!   print ("<td>\n");
    echo "$item2\n";
    print ("</td>\n");
--- 81,85 ----
  function print_row($item2,$key) {
      
!   print ("<td><align=\"center\">\n");
    echo "$item2\n";
    print ("</td>\n");
***************
*** 101,104 ****
--- 100,105 ----
    }
   pg_close($dbh);
+ 
+ 
  }
  ?>