Changeset 17222

Timestamp:

Sep 6, 2001, 5:02:18 AM (24 years ago)

Author:

bird

Message:

Design notes.

Location:

tags/trunk/tools/database/www

Files:

• Odin32DB.phtml (modified) (10 diffs)
• Odin32DBHelpers.php3 (modified) (1 diff)

tags/trunk/tools/database/www/Odin32DB.phtml ¶

@@ -86 +86 @@
         $authordll = -1;
 }
+else if (isset($designnoterefcode))
+{   /* Author by refcode */
+    $sCategory      = "designnote";
+    $sCategoryName  = "Design Note";
+    if ($designnoterefcode != "")
+        $iRefcode = (int)$designnoterefcode;
+}
 else if (isset($dlls))
 {   /* All dlls */
-    $sCategory      = "dll";
-    $sCategoryName  = "Dlls";
+    $sCategory      = "dlls";
+    $sCategoryName  = "All Dlls";
+    $sDllType = 'A';
 }
 else if (isset($internal))
 {   /* All Internal Dlls */
-    $sCategory      = "dll";
+    $sCategory      = "dlls";
     $sCategoryName  = "Internal Dlls";
+    $sDllType = 'I';
 }
 else if (isset($support))
 {   /* All dlls */
-    $sCategory      = "dll";
+    $sCategory      = "dlls";
     $sCategoryName  = "Support Stuff";
+    $sDllType = 'S';
 }
 else if (isset($tools))
-{   /* All dlls */
-    $sCategory      = "dll";
+{   /* Tools */
+    $sCategory      = "dlls";
     $sCategoryName  = "Tools";
+    $sDllType = 'T';
 }
 else if (isset($apigroups))
@@ -115 +126 @@
     $sCategory      = "authors";
     $sCategoryName  = "Authors";
+}
+else if (isset($design))
+{   /* All authors */
+    $sCategory      = "designnotes";
+    $sCategoryName  = "Design Notes";
 } /* else: root page */
 
@@ -138 +154 @@
         $fNoData = 1;
         $sName = "!Invalid Refcode!";
+        Odin32DBSqlError($sql);
     }
     @mysql_free_result($result);
@@ -189 +206 @@
         {
             Odin32DBAuthorInfo($db, $iRefcode, $fDlls, $fFunctions, $fFiles, $fAPIGroups, $fSortByState, $authordll);
+            break;
+        }
+
+        case "designnote":
+        {
+            Odin32DBDesignNote($db, $iRefcode);
             break;
         }
@@ -209 +232 @@
             echo "<font size=3>".
                  "<ul>\n".
-                 "  <li><b>Module<\n>\n".
+                 "  <li><b>Modules\n".
                  "      <ul>\n".
                  "         <li><b><a href=\"Odin32DB.phtml?dlls=1\">Odin32 API DLLs</a></b>\n".
@@ -218 +241 @@
                  "  <li><b><a href=\"Odin32DB.phtml?apigroups=1\">API Groups</a></b>\n".
                  "  <li><b><a href=\"Odin32DB.phtml?authors=1\">Authors</a></b>\n".
-                 "  <li><i><a href=\"Odin32DB.phtml?searchapi=1\">Search API (not implemeted)</a></i>\n".
+                 "  <li><b><a href=\"Odin32DB.phtml?design=1\">Design Notes</a></b>\n".
+                 "  <!-- <li><i><a href=\"Odin32DB.phtml?searchapi=1\">Search API (not implemeted)</a></i> -->\n".
                  "</ul>\n";
                  "</font>\n";
@@ -239 +263 @@
                  "-Enjoy!<br>\n";
 
-            Odin32DBNaslov("All Dlls", "dlls", "");
+            Odin32DBNaslov($sCategoryName, $sCategory, "");
             $sql = "SELECT\n".
                    "    d.name              AS name,\n".
@@ -246 +270 @@
                    "FROM\n".
                    "    dll d\n".
-                   "    JOIN function f\n".
+                   "    LEFT OUTER JOIN function f\n".
+                   "    ON f.dll = d.refcode\n".
                    "WHERE\n".
-                   "    f.dll = d.refcode\n".
+                   "    d.type = '".$sDllType."'\n".
                    "GROUP BY d.refcode\n".
                    "ORDER BY d.name\n";
@@ -254 +279 @@
             {
                 if (mysql_num_rows($result) <= 0)
-                    echo "<i>No dlls!</i>\n";
+                    echo "<i>No data in this module category!<br>$sql</i>\n";
                 else
                 {
@@ -364 +389 @@
         }
 
+        case "designnotes":
+        {
+            /*
+             * List all design notes.
+             */
+            Odin32DBNavigationTop("","");
+            Odin32DBNaslov("Welcome to the Odin32 API Database", "welcome", "");
+            echo "This is the first Beta edition of the Odin32 API Database.<br>\n".
+                 "There might be dead or non-functioning links. Currently feedback is <i>NOT</i> needed.\n".
+                 "<p>\n".
+                 "Please note that the quality of the data avilable is quite poor\n".
+                 "for the time being. This will improve within some months.<br>\n".
+                 "-Enjoy!<br>\n";
+
+            Odin32DBNaslov($sCategoryName, $sCategory, "");
+            $sql = "SELECT\n".
+                   "    dn.refcode          AS refcode,\n".
+                   "    dn.name             AS name,\n".
+                   "    dn.seqnbr           AS seqnbr,\n".
+                   "    dn.level            AS level,\n".
+                   "    d.name              AS dllname,\n".
+                   "    f.name              AS filename\n".
+                   "FROM\n".
+                   "    designnote dn,\n".
+                   "    dll d,\n".
+                   "    file f\n".
+                   "WHERE   dn.dll = d.refcode\n".
+                   "    AND dn.file = f.refcode\n".
+                   "    AND dn.level <= 1\n".
+                   "ORDER BY d.name, dn.seqnbr, dn.seqnbrnote\n";
+            if ($result = mysql_query($sql, $db))
+            {
+                if (mysql_num_rows($result) <= 0)
+                    echo "<i>No Design Notes!</i>\n";
+                else
+                {
+                    echo "\n<font size=-1><ul><b>";
+                    $iLevel = 0;
+                    while ($aDesignNote = mysql_fetch_array($result))
+                    {
+                        if ($aDesignNote["level"] > $iLevel)
+                           print "    <ul>\n";
+                        else if ($aDesignNote["level"] < $iLevel)
+                           print "    </ul>\n";
+                        $iLevel = $aDesignNote["level"];
+
+                        if ($iLevel > 0)
+                           print "        <li><a href=\"Odin32DB.phtml?designnoterefcode=".$aDesignNote["refcode"].
+                                 "\">".$aDesignNote["name"]."</a>\n";
+                        else
+                           print "    <li><a href=\"Odin32DB.phtml?designnoterefcode=".$aDesignNote["refcode"].
+                                  "\">".$aDesignNote["seqnbr"].".0 ".$aDesignNote["name"]."</a> (".$aDesignNote["filename"].")\n";
+
+                    }
+                    echo "</ul></b></font>\n";
+                }
+            }
+            else
+                Odin32DBSqlError($sql);
+            Odin32DBNavigationBottom("","");
+            break;
+        }
+
         default:
             echo "!IPE!"; //FIXME

tags/trunk/tools/database/www/Odin32DBHelpers.php3 ¶

@@ -2218 +2218 @@
 
 
+/**
+ * Displays a design not.
+ * @returns     void
+ * @param       $db             Database handle.
+ * @param       $iRefcode       Author reference code.
+ * @author  knut st. osmundsen (kosmunds@csc.com)
+ * @remark
+ */
+function Odin32DBDesignNote($db, $iRefcode)
+{
+    /*
+     * Navigation - TOP
+     */
+    $sExpand    = "authorrefcode=".$iRefcode."&fDlls=1&fFiles=1&fFunctions=1&fAPIGroups=1&fAuthors=1&dll=".$iDllRefcode;
+    if ($fSortByState)  $sExpand = $sExpand."&fSortByState=".$fSortByState;
+    $sCollapse  = "authorrefcode=".$iRefcode;
+    Odin32DBNavigationTop($sExpand, $sCollapse);
+
+    /*
+     * Fetch (vital) data.
+     */
+    $sql = sprintf("SELECT\n".
+                   "    dn.name          AS name,\n".
+                   "    dn.note          AS note,\n".
+                   "    dn.refcode       AS refcode,\n".
+                   "    dn.dll           AS dllrefcode,\n".
+                   "    dn.file          AS filerefcode,\n".
+                   "    dn.seqnbrnote    AS seqnbnote,\n".
+                   "    dn.level         AS level,\n".
+                   "    dn.seqnbr        AS seqnbr,\n".
+                   "    dn.line          AS line,\n".
+                   "    d.name           AS dll,\n".
+                   "    f.name           AS file\n".
+                   "FROM\n".
+                   "    designnote dn,\n".
+                   "    dll d,\n".
+                   "    file f\n".
+                   "WHERE   dn.refcode = %d\n".
+                   "    AND dn.dll = d.refcode\n".
+                   "    AND dn.file = f.refcode\n".
+                   "ORDER BY dn.seqnbrnote\n",
+                   $iRefcode);
+    if (($result = mysql_query($sql, $db)) && mysql_num_rows($result) > 0 && ($array = mysql_fetch_array($result)))
+    {
+        /*
+         * General
+         */
+        /*Odin32DBNaslov("General", "general");
+        echo "\n<table width=100% border=3 cellpadding=0>\n";
+        Odin32DBInfoRow1("Title", $array, "name","","","","");
+        Odin32DBInfoRow1("Module", $array, "dll","","","","");
+        Odin32DBInfoRow1("File", $array, "file","","","","");
+        Odin32DBInfoRow1("Line", $array, "line","","","","");
+        Odin32DBInfoRow1("Seq#", $array, "seqnbr","","","","");
+        echo "</table>\n";
+        */
+
+        /*
+         * Sections.
+         */
+        $iLevel = 0;
+        $sSectionNbr = "";
+        do
+        {
+            /* make section number */
+            if ($array["level"] <= 0)
+                $sSection = $array["seqnbr"].".0";
+            else
+            {
+                while ($iLevel > 0 && $iLevel < $array["level"])
+                {
+                    echo "debug ".$iLevel." < ".$array["level"]."<br>\n";
+                    $sSection .= '.0';
+                    $iLevel = $iLevel + 1;
+                }
+
+                if ($iLevel == 0) $iLevel++;
+                while ($iLevel >= $array["level"])
+                {
+                    $sSection = substr($sSection, 0, strlen($sSection) - strlen(strrchr($sSection, '.')));
+                    $iLevel = $iLevel - 1;
+                }
+                $sSection = $sSection.".".$array["seqnbr"];
+            }
+            $iLevel = $array["level"];
+
+            /* print it */
+            $sName = $sSection." ".$array["name"];
+            Odin32DBNaslov($sName, $sName);
+            echo $array["note"]."\n";
+
+        } while ($array = mysql_fetch_array($result));
+
+    }
+    else
+    {
+        echo "<p> No data! Invalid refcode? </p>";
+        Odin32DBSqlError($sql);
+    }
+
+    /*
+     * Navigation - Bottom
+     */
+    Odin32DBNavigationBottom($sExpand, $sCollapse);
+}
+
+