Changeset 3918 for trunk/tools/database/www/Odin32DBHelpers.php3

Timestamp:

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

Author:

bird

Message:

Fixes. Changed database to Odin32.

File:

• trunk/tools/database/www/Odin32DBHelpers.php3 (modified) (3 diffs)

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);