Changeset 12835 for trunk/ippMonitor/raw

Timestamp:

Apr 16, 2007, 3:21:41 PM (19 years ago)

Author:

eugene

Message:

updating to current db table layout

Location:

trunk/ippMonitor/raw

Files:

• ipp.css (modified) (1 diff)
• ipp.php (modified) (4 diffs)
• ipp.science.dat (modified) (1 diff)

trunk/ippMonitor/raw/ipp.css

@@ -50 +50 @@
 }
 
+table.select { text-align: left; 
+             font-size: small; 
+             font-weight: normal; 
+             background: #0080c0; 
+             border: 1px solid #0080c0; 
+             padding: 0px; 
+}
+
+td.select  { 
+           text-align: left; 
+           font-size: normal;  
+           font-weight: bold;  
+           vertical-align: top;
+           color: #ffffff; 
+           background: #0080c0; 
+           background-color: #0080c0; 
+           border: 2px solid #0080c0; 
+           padding: 2px; 
+}
+
+th.select  { 
+           text-align: left; 
+           font-size: normal;  
+           font-weight: bold;  
+           vertical-align: top;
+           color: #000000; 
+           background: #d0d0ff; 
+           background-color: #d0d0ff; 
+           border: 0px solid #0080c0; 
+           padding: 2px; 
+}
+
 table.list { text-align: left; 
              font-size: small; 

trunk/ippMonitor/raw/ipp.php

@@ -28 +28 @@
     echo "</form>\n";
 
+    $db = dbconnect('ippadmin');
+
+    // make this a DB lookup
+    $sql = "SELECT projname FROM projects";
+
+    $qry = $db->query($sql);
+    if (DB::iserror($db)) {
+      echo "<b>error reading project list</b><br>\n";
+      menu_end();
+    }
+  
+    echo "<table class=select>\n";
+    echo "<tr class=select><th class=select> projects </th></tr>\n";
+    while ($qry->fetchInto($row)) {
+      echo "<tr class=select><td class=select> $row[0] </td></tr>\n";
+    }
+    echo "</table>\n";
+
     menu_end ();
 }
@@ -34 +52 @@
 
   // connect to the database
+  // these should be set on installation
   require_once('DB.php');
-  $db = DB::connect("mysql://ipp:ipp@alala/$database");
+  $password = "ipp";
+  $username = "ipp";
+  $hostname = "alala";
+  $db = DB::connect("mysql://$username:$password@$hostname/$database");
   if (DB::iserror($db)) {
     echo "<b>error accessing database</b><br>\n";
-    echo "<b>tried mysql://ipp:ipp@localhost/ipp</b><br>\n";
+    echo "<b>tried mysql://$username:$password@$hostname/$database</b><br>\n";
     menu_end();
   }
@@ -57 +79 @@
   $db = dbconnect('ippadmin');
 
-  // make this a DB lookup
+  // get the users from the DB
   $sql = "SELECT username FROM users WHERE username = '$username' AND password = '$password'";
 
@@ -227 +249 @@
     }
         
-    $this = $_SERVER[SCRIPT_NAME]; 
+    $thisname = $_SERVER[SCRIPT_NAME]; 
     $page = "$root/" . $base;
-    if ($page == $this) {
+    if ($page == $thisname) {
         $style = trim($line[1]);
     } else { 

trunk/ippMonitor/raw/ipp.science.dat

@@ -27 +27 @@
 
 menutop   | menutop      | plain   |                         | 
-menulink  | menuselect   | plain   | Guide Processed Exp          | 
+menutop   | menuselect   | plain   | Guide Processed Exp          | 
 menulink  | menuselect   | link    | Chip Processed Exp           | chipProcessedExp.php            
 menulink  | menuselect   | link    | Cam Processed Exp            | camProcessedExp.php            
 menutop   | menutop      | plain   |                         | 
-menulink  | menuselect   | link    | Guide Pending Exp            | guidePendingExp.php              
+menutop   | menuselect   | plain   | Guide Pending Exp            | guidePendingExp.php              
 menulink  | menuselect   | link    | Chip Pending Exp             | chipPendingExp.php              
 menulink  | menuselect   | link    | Cam Pending Exp              | camPendingExp.php