Changeset 3918 for trunk/tools/database

Timestamp:

Aug 2, 2000, 4:19:10 AM (25 years ago)

Author:

bird

Message:

Fixes. Changed database to Odin32.

Location:

trunk/tools/database/www

Files:

• Odin32DBConnect.php3 (modified) (1 diff)
• Odin32DBHelpers.php3 (modified) (3 diffs)
• Odin32GuidelineDocumentation.phtml (modified) (1 diff)

trunk/tools/database/www/Odin32DBConnect.php3

@@ -5 +5 @@
  */
 $db = mysql_connect("127.0.0.1", "root", "");
-$rc = mysql_select_db("odin32test", $db);
+$rc = mysql_select_db("odin32", $db);
 
 ?>

trunk/tools/database/www/Odin32DBHelpers.php3

@@ -1024 +1024 @@
                    "    f.equiv         AS equiv,\n".
                    "    f.time          AS time,\n".
+                   "    f.line          AS line,\n".
                    "    g.name          AS apigroupname,\n".
                    "    g.refcode       AS apigrouprefcode,\n".
@@ -1068 +1069 @@
             Odin32DBInfoRow1("API Group", $array, "apigroupname", "apigrouprefcode", "apigrouprefcode","","");
         Odin32DBInfoRow1("File", $array, "filename", "filerefcode", "filerefcode","not available","");
+        if ($array["line"] > 0)
+            Odin32DBInfoRow1("Line", $array, "line", "", "","","");
+        else
+            Odin32DBInfoRow1("Line", $array, "unavailable", "", "","not available","");
         if (isset($array["aliasrefcode"]))
             Odin32DBInfoRow2("Forwards", $array, "aliasdllname", "aliasdllrefcode", "dllrefcode","",".",
@@ -2103 +2108 @@
          */
         $sql = sprintf("SELECT\n".
-                       "    f.state,\n".
-                       "    COUNT(f.state)\n".
+                       "    state,\n".
+                       "    COUNT(state)\n".
                        "FROM\n".
                        "    function\n".
                        "WHERE\n".
-                       "    f.apigroup = %d\n".
-                       "GROUP BY f.state\n".
-                       "ORDER BY f.state",
+                       "    apigroup = %d\n".
+                       "GROUP BY state\n".
+                       "ORDER BY state",
                         $iRefcode);
         Odin32DBWriteStates($cFunctions, $sql, $db);

trunk/tools/database/www/Odin32GuidelineDocumentation.phtml

@@ -66 +66 @@
 CodeBeg();
 echo "
-/* \$Id: Odin32GuidelineDocumentation.phtml,v 1.2 2000-08-02 01:00:45 bird Exp $
+/* \$Id: Odin32GuidelineDocumentation.phtml,v 1.3 2000-08-02 02:19:10 bird Exp $
  *
  * <i>&lt;insert file description here&gt;</i>