Changeset 6678 for trunk/tools/database/www/Odin32DBHelpers.php3
- Timestamp:
- Sep 7, 2001, 12:33:10 PM (24 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/tools/database/www/Odin32DBHelpers.php3
r6677 r6678 113 113 114 114 /** 115 * Compute completion percentage for a module.115 * Compute completion percentage for a dll. 116 116 * @returns Completion percentage. Range 0-100. 117 117 * On error -1 or -2 is returned. 118 * @param $i Module Modulereference code.119 * @param $db 120 * @sketch Get total number of function in the module.121 * Get number of completed functions in the module.118 * @param $iDll Dll reference code. 119 * @param $db Database connection variable. 120 * @sketch Get total number of function in the dll. 121 * Get number of completed functions in the dll. 122 122 * return complete*100 / total 123 123 * @status Completely implemented … … 125 125 * @remark 126 126 */ 127 function Odin32DBComputeCompletion($i Module, $db)128 { 129 /* 130 * Count the total number of functions in the module.127 function Odin32DBComputeCompletion($iDll, $db) 128 { 129 /* 130 * Count the total number of functions in the DLL. 131 131 */ 132 132 $sql = sprintf("SELECT SUM(s.weight)/COUNT(f.state) … … 136 136 WHERE 137 137 f.state = s.refcode 138 AND module= %d",139 $i Module);138 AND dll = %d", 139 $iDll); 140 140 if (($result = mysql_query($sql, $db)) && mysql_num_rows($result) < 1) 141 141 { … … 165 165 166 166 /** 167 * Draws a completion bar for a module (or all modules.).168 * @param $i Module Modulereference code.167 * Draws a completion bar for a dll (or all dlls). 168 * @param $iDll Dll reference code. 169 169 * If < 0 then for the entire project. 170 * @param $i ModName Modulename.170 * @param $iDllName Dll name. 171 171 * @param $db Database connection variable. 172 172 * @sketch Call Odin32DBCompletionBar2 with an appropriate condition. … … 174 174 * @author knut st. osmundsen (knut.stange.osmundsen@mynd.no) 175 175 */ 176 function Odin32DBCompletionBar Module($iModule, $sModName, $db)177 { 178 if ($i Module< 0)179 return Odin32DBcompletionBar2("", $s ModName, $db);180 return Odin32DBcompletionBar2(" module = ".$iModule." AND f.type IN ('A', 'I')", $sModName, $db);176 function Odin32DBCompletionBarDll($iDll, $sDllName, $db) 177 { 178 if ($iDll < 0) 179 return Odin32DBcompletionBar2("", $sDllName, $db); 180 return Odin32DBcompletionBar2("dll = ".$iDll, $sDllName, $db); 181 181 } 182 182 … … 221 221 { 222 222 /* 223 * Count the total number of functions for the author.223 * Count the total number of functions in the DLL. 224 224 */ 225 225 $sql = "SELECT COUNT(*) FROM fnauthor fa JOIN function f\n". 226 "WHERE fa.function = f.refcode AND fa.author = ".$iAuthor ." AND f.type IN ('A', 'I')";226 "WHERE fa.function = f.refcode AND fa.author = ".$iAuthor; 227 227 if (($result = mysql_query($sql, $db)) && mysql_num_rows($result) < 1) 228 228 { … … 260 260 " fa.author = ".$iAuthor." AND\n". 261 261 " fa.function = f.refcode AND\n". 262 " f.state = s.refcode AND\n". 263 " f.type IN ('A', 'I')\n". 262 " f.state = s.refcode\n". 264 263 "GROUP BY s.refcode\n". 265 264 "ORDER BY state\n"; … … 296 295 /** 297 296 * Draws a completion bar. 298 * @param $ sCondition Where conditions.299 * @param $sName Name...300 * @param $db 301 * @sketch Get total number of function in the selection.297 * @param $iDll Dll reference code. 298 * If < 0 then for the entire project. 299 * @param $db Database connection variable. 300 * @sketch Get total number of function in the dll. 302 301 * Get the number of function per status. (+state color) 303 302 * Draw bar. … … 308 307 { 309 308 /* 310 * Count the total number of functions in selection.309 * Count the total number of functions in the DLL. 311 310 */ 312 311 $sql = "SELECT COUNT(*) FROM function f"; … … 392 391 { 393 392 /* 394 * Select the states. 395 */ 396 $sql = "SELECT name, 397 color 398 FROM state 399 ORDER BY refcode"; 393 * Count the total number of functions in the DLL. 394 */ 395 $sql = "SELECT 396 name, 397 color 398 FROM 399 state 400 ORDER BY refcode"; 400 401 if (($result = mysql_query($sql, $db)) && mysql_num_rows($result) < 1) 401 402 { … … 667 668 /** 668 669 * Writes the a function listing base sqlstatement with these columns (ordered): 669 * 0. Modulerefcode670 * 1. Modulename670 * 0. dll refcode 671 * 1. dll name 671 672 * 2. number of functions 672 673 * … … 676 677 * @author knut st. osmundsen (knut.stange.osmundsen@mynd.no) 677 678 */ 678 function Odin32DBWrite Modules($sql, $db)679 function Odin32DBWriteDlls($sql, $db) 679 680 { 680 681 if ($result2 = mysql_query($sql, $db)) … … 684 685 echo "\n<table width=100% border=0 cellpadding=0>\n". 685 686 "<tr>\n". 686 " <td width=75%><font size=-1><b> Modules</b></font></td>\n".687 " <td width=75%><font size=-1><b>Dlls</b></font></td>\n". 687 688 " <td align=right><font size=-1><b>Functions</b></font></td>\n". 688 689 "</tr>\n"; 689 690 while ($aFunction = mysql_fetch_array($result2)) 690 691 printf("<tr>". 691 "<td><font size=-1><a href=\"Odin32DB.phtml? modrefcode=%s\">%s</a></font></td>".692 "<td><font size=-1><a href=\"Odin32DB.phtml?dllrefcode=%s\">%s</a></font></td>". 692 693 "<td align=right><font size=-1>%s</font></td>". 693 694 "</tr>\n", … … 761 762 /** 762 763 * Writes the a function listing base sqlstatement with these columns (ordered): 763 * 0. modulerefcode764 * 1. modulename764 * 0. dll refcode 765 * 1. dll name 765 766 * 2. function refcode 766 767 * 3. function name … … 774 775 * @author knut st. osmundsen (knut.stange.osmundsen@mynd.no) 775 776 */ 776 function Odin32DBWriteFunctionsWith Modules($sql, $db, $sURLArgs)777 function Odin32DBWriteFunctionsWithDlls($sql, $db, $sURLArgs) 777 778 { 778 779 if ($result2 = mysql_query($sql, $db)) … … 782 783 echo "\n<table width=100% border=0 cellpadding=0>\n". 783 784 "<tr>\n". 784 " <td width=30%><font size=-1><b> ModuleName</b></font></td>\n".785 " <td width=30%><font size=-1><b>Dll Name</b></font></td>\n". 785 786 " <td width=45%><font size=-1><b>Function Name</b></font></td>\n". 786 787 " <td><font size=-1><b>State</b></font></td>\n". … … 788 789 while ($aFunction = mysql_fetch_row($result2)) 789 790 printf("<tr>". 790 "<td><font size=-1><a href=\"Odin32DB.phtml? modrefcode=%s\">%s</a></font></td>".791 "<td><font size=-1><a href=\"Odin32DB.phtml?dllrefcode=%s\">%s</a></font></td>". 791 792 "<td><font size=-1><a href=\"Odin32DB.phtml?functionrefcode=%s\">%s</a></font></td>". 792 793 "<td><font size=-1 color=%s>%s</font></td>". … … 808 809 809 810 echo "<p>Click <a href=\"Odin32DB.phtml#functions?".$sURLArgs."\">here</a> to view functions sorted ". 810 ($fSortByState ? "alphabetical by module" : "by state"). ".<br>";811 ($fSortByState ? "alphabetical by dll" : "by state"). ".<br>"; 811 812 } 812 813 else … … 952 953 953 954 echo "<a href=\"Odin32DB.phtml\">Root</a>\n". 954 " - <a href=\"Odin32DB.phtml? modules=1\">Moduless</a>\n".955 " - <a href=\"Odin32DB.phtml?dlls=1\">Dlls</a>\n". 955 956 " - <a href=\"Odin32DB.phtml?authors=1\">Authors</a>\n". 956 957 " - <a href=\"Odin32DB.phtml?apigroups=1\">API Groups</a>\n"; … … 985 986 echo 986 987 "<a href=\"Odin32DB.phtml\">Root</a>\n". 987 " - <a href=\"Odin32DB.phtml? moduless=1\">Modules</a>\n".988 " - <a href=\"Odin32DB.phtml?dlls=1\">Dlls</a>\n". 988 989 " - <a href=\"Odin32DB.phtml?authors=1\">Authors</a>\n". 989 990 " - <a href=\"Odin32DB.phtml?apigroups=1\">API Groups</a>\n"; … … 1028 1029 " a.name AS aliasname,\n". 1029 1030 " a.refcode AS aliasrefcode,\n". 1030 " ad.name AS alias nmodname,\n".1031 " ad.refcode AS alias modrefcode,\n".1032 " d.name AS modname,\n".1033 " d.refcode AS modrefcode,\n".1031 " ad.name AS aliasdllname,\n". 1032 " ad.refcode AS aliasdllrefcode,\n". 1033 " d.name AS dllname,\n". 1034 " d.refcode AS dllrefcode,\n". 1034 1035 " i.name AS filename,\n". 1035 1036 " i.refcode AS filerefcode,\n". … … 1039 1040 " function f\n". 1040 1041 " LEFT OUTER JOIN function a ON f.aliasfn = a.refcode\n". 1041 " LEFT OUTER JOIN module ad ON a.module= ad.refcode\n".1042 " LEFT OUTER JOIN dll ad ON a.dll = ad.refcode\n". 1042 1043 " LEFT OUTER JOIN apigroup g ON f.apigroup = g.refcode\n". 1043 " LEFT JOIN module d ON f.module= d.refcode\n".1044 " LEFT JOIN dll d ON f.dll = d.refcode\n". 1044 1045 " LEFT JOIN state s ON f.state = s.refcode\n". 1045 1046 " LEFT OUTER JOIN file i ON f.file = i.refcode\n". … … 1063 1064 Odin32DBInfoRow1("Type", $array, "type", "", "","invalid",""); 1064 1065 Odin32DBInfoRow1("State", $array, "state", "", "","invalid",""); 1065 Odin32DBInfoRow1(" Module", $array, "modname", "modrefcode", "modrefcode","","");1066 Odin32DBInfoRow1("Dll", $array, "dllname", "dllrefcode", "dllrefcode","",""); 1066 1067 Odin32DBInfoRow1("Ordinal", $array, "ordinal","","","not available",""); 1067 1068 if (isset($array["apigroupname"])) 1068 1069 Odin32DBInfoRow1("API Group", $array, "apigroupname", "apigrouprefcode", "apigrouprefcode","",""); 1069 1070 Odin32DBInfoRow1("File", $array, "filename", "filerefcode", "filerefcode", "not available", 1070 " (<a href=\"cvs.phtml#".$array["line"]."?sFile=./src/".$array[" modname"]."/".$array["filename"].",v&sRevision=\">cvs</a>)");1071 " (<a href=\"cvs.phtml#".$array["line"]."?sFile=./src/".$array["dllname"]."/".$array["filename"].",v&sRevision=\">cvs</a>)"); 1071 1072 if ($array["line"] > 0) 1072 1073 Odin32DBInfoRow1("Line", $array, "line", "", "","",""); … … 1074 1075 Odin32DBInfoRow1("Line", $array, "unavailable", "", "","not available",""); 1075 1076 if (isset($array["aliasrefcode"])) 1076 Odin32DBInfoRow2("Forwards", $array, "alias modname", "aliasmodrefcode", "modrefcode","",".",1077 Odin32DBInfoRow2("Forwards", $array, "aliasdllname", "aliasdllrefcode", "dllrefcode","",".", 1077 1078 "aliasname", "aliasrefcode", "functionrefcode"); 1078 1079 else 1079 1080 { 1080 1081 $sql = sprintf("SELECT\n". 1081 " m.name AS modname,\n".1082 " m.refcode AS modrefcode,\n".1082 " d.name AS dllname,\n". 1083 " d.refcode AS dllrefcode,\n". 1083 1084 " f.name AS fnname,\n". 1084 1085 " f.refcode AS fnrefcode\n". 1085 1086 "FROM\n". 1086 1087 " function f,\n". 1087 " module m\n".1088 " dll d\n". 1088 1089 "WHERE\n". 1089 1090 " f.aliasfn = %d AND\n". 1090 " f. module = m.refcode\n".1091 "ORDER BY m.name, f.name\n",1091 " f.dll = d.refcode\n". 1092 "ORDER BY d.name, f.name\n", 1092 1093 $iRefcode); 1093 1094 if (($result2 = mysql_query($sql, $db))) … … 1101 1102 if ($f) $sValue = $sValue."<br>"; 1102 1103 else $f = 1; 1103 $sValue = $sValue."<a href=\"Odin32DB.phtml? modrefcode=".1104 $aAlias[" modrefcode"]."\">".$aAlias["modname"]."</a>.".1104 $sValue = $sValue."<a href=\"Odin32DB.phtml?dllrefcode=". 1105 $aAlias["dllrefcode"]."\">".$aAlias["dllname"]."</a>.". 1105 1106 "<a href=\"Odin32DB.phtml?functionrefcode=". 1106 1107 $aAlias["fnrefcode"]."\">".$aAlias["fnname"]."</a>"; … … 1244 1245 1245 1246 /** 1246 * Writes standard moduleinfo.1247 * Writes standard dll info. 1247 1248 * 1248 1249 * @returns void 1249 1250 * @param $db Database handle. 1250 * @param $iRefcode Modulereference code.1251 * @param $iRefcode Dll reference code. 1251 1252 * @param $fFunctions Flags which tells wether to list all functions or not. 1252 1253 * @param $fFiles Flags which tells wether to list all files or not. … … 1259 1260 * @remark 1260 1261 */ 1261 function Odin32DB ModuleInfo($db, $iRefcode, $fFunctions, $fFiles, $fAPIGroups, $fAuthors, $fSortByState)1262 { 1263 $sURLArgs = " modrefcode=".$iRefcode.1262 function Odin32DBDllInfo($db, $iRefcode, $fFunctions, $fFiles, $fAPIGroups, $fAuthors, $fSortByState) 1263 { 1264 $sURLArgs = "dllrefcode=".$iRefcode. 1264 1265 ($fFunctions ? "&fFunctions=1" : ""). 1265 1266 ($fFiles ? "&fFiles=1" : ""). … … 1271 1272 * Navigation - TOP 1272 1273 */ 1273 $sExpand = " modrefcode=".$iRefcode."&fFiles=1&fFunctions=1&fAPIGroups=1&fAuthors=1";1274 $sExpand = "dllrefcode=".$iRefcode."&fFiles=1&fFunctions=1&fAPIGroups=1&fAuthors=1"; 1274 1275 if ($fSortByState) $sExpand = $sExpand."&fSortByState=".$fSortByState; 1275 $sCollapse = " modrefcode=".$iRefcode;1276 $sCollapse = "dllrefcode=".$iRefcode; 1276 1277 Odin32DBNavigationTop($sExpand, $sCollapse); 1277 1278 … … 1280 1281 */ 1281 1282 $sql = sprintf("SELECT\n". 1282 " m.name AS name,\n".1283 " m.description AS description,\n".1283 " d.name AS name,\n". 1284 " d.description AS description,\n". 1284 1285 " c.description AS type\n". 1285 1286 "FROM\n". 1286 " moduled,\n".1287 " dll d,\n". 1287 1288 " code c\n". 1288 1289 "WHERE\n". 1289 1290 " c.codegroup = 'DTYP' AND\n". 1290 " m.type = c.code AND\n".1291 " m.refcode = %d",1291 " d.type = c.code AND\n". 1292 " d.refcode = %d", 1292 1293 $iRefcode); 1293 1294 if (($result = mysql_query($sql, $db)) && mysql_num_rows($result) > 0 && ($array = mysql_fetch_array($result))) … … 1306 1307 " function\n". 1307 1308 "WHERE\n". 1308 " module= %d",1309 " dll = %d", 1309 1310 $iRefcode); 1310 1311 $cFunctions = 0; … … 1320 1321 " file\n". 1321 1322 "WHERE\n". 1322 " module= %d",1323 " dll = %d", 1323 1324 $iRefcode); 1324 1325 $cFiles = 0; … … 1334 1335 " apigroup\n". 1335 1336 "WHERE\n". 1336 " module= %d",1337 " dll = %d", 1337 1338 $iRefcode); 1338 1339 $cAPIGroups = 0; … … 1350 1351 */ 1351 1352 Odin32DBNaslov("Completion", "completion"); 1352 Odin32DBCompletionBar Module($iRefcode, "", $db);1353 Odin32DBCompletionBarDll($iRefcode, "", $db); 1353 1354 1354 1355 /* … … 1361 1362 " function\n". 1362 1363 "WHERE\n". 1363 " module= %d\n".1364 " dll = %d\n". 1364 1365 "GROUP BY state\n". 1365 1366 "ORDER BY state", … … 1382 1383 " LEFT JOIN state s ON f.state = s.refcode\n". 1383 1384 "WHERE\n". 1384 " f. module= %d\n",1385 " f.dll = %d\n", 1385 1386 $iRefcode); 1386 1387 if ($fSortByState) … … 1409 1410 " LEFT OUTER JOIN function fn ON fn.file = f.refcode\n". 1410 1411 "WHERE\n". 1411 " f. module= %d\n".1412 " f.dll = %d\n". 1412 1413 "GROUP BY f.refcode\n". 1413 1414 "ORDER BY f.name\n", … … 1436 1437 " JOIN function f\n". 1437 1438 "WHERE\n". 1438 " g. module= %d AND\n".1439 " f. module= %d AND\n".1439 " g.dll = %d AND\n". 1440 " f.dll = %d AND\n". 1440 1441 " f.apigroup = g.refcode\n". 1441 1442 "GROUP BY f.apigroup\n". … … 1466 1467 " JOIN author a\n". 1467 1468 "WHERE\n". 1468 " f. module= %d AND\n".1469 " f.dll = %d AND\n". 1469 1470 " fa.function = f.refcode AND\n". 1470 1471 " fa.author = a.refcode\n". … … 1534 1535 " f.revision AS revision,\n". 1535 1536 " f.description AS description,\n". 1536 " f. module AS modrefcode,\n".1537 " m.name AS modname\n".1537 " f.dll AS dllrefcode,\n". 1538 " d.name AS dllname\n". 1538 1539 "FROM\n". 1539 1540 " file f,\n". 1540 " module m,\n".1541 " dll d,\n". 1541 1542 " author a\n". 1542 1543 "WHERE\n". 1543 1544 " f.refcode = %d AND\n". 1544 " f. module = m.refcode AND\n".1545 " f.dll = d.refcode AND\n". 1545 1546 " f.lastauthor= a.refcode", 1546 1547 $iRefcode); … … 1553 1554 echo "\n<table width=100% border=3 cellpadding=0>\n"; 1554 1555 Odin32DBInfoRow1("Name", $array, "name","","","", 1555 " (<a href=\"cvs.phtml?sFile=./src/".$array[" modname"]."/".$array["name"].",v&sRevision=\">cvs</a>)");1556 " (<a href=\"cvs.phtml?sFile=./src/".$array["dllname"]."/".$array["name"].",v&sRevision=\">cvs</a>)"); 1556 1557 Odin32DBInfoRow1("Revision", $array, "revision","","","",""); 1557 1558 Odin32DBInfoRow1("Changed", $array, "lastdatetime","","","",""); 1558 1559 Odin32DBInfoRow1("Last Author", $array, "lastauthorname","lastauthorrefcode","authorrefcode","",""); 1559 Odin32DBInfoRow1(" Module", $array, "modname","modrefcode","modrefcode","","");1560 Odin32DBInfoRow1("Dll", $array, "dllname","dllrefcode","dllrefcode","",""); 1560 1561 $sql = sprintf("SELECT\n". 1561 1562 " COUNT(*) as functions\n". … … 1721 1722 * @param $db Database handle. 1722 1723 * @param $iRefcode Author reference code. 1723 * @param $f Modules Flags which tells wether to list all modules or not.1724 * @param $fDlls Flags which tells wether to list all dlls or not. 1724 1725 * @param $fFunctions Flags which tells wether to list all functions or not. 1725 1726 * @param $fFiles Flags which tells wether to list all files or not. … … 1727 1728 * @param $fSortByState Flags which tells wether to sort functions by 1728 1729 * state and function name or just by function name. 1729 * @param $i ModRefcode Module refcode. All modulesif < 0.1730 * @param $iDllRefcode Dll refcode. All Dll if < 0. 1730 1731 * (not implemented yet) 1731 1732 * @sketch … … 1733 1734 * @remark 1734 1735 */ 1735 function Odin32DBAuthorInfo($db, $iRefcode, $f Modules, $fFunctions, $fFiles, $fAPIGroups, $fSortByState, $iModRefcode)1736 function Odin32DBAuthorInfo($db, $iRefcode, $fDlls, $fFunctions, $fFiles, $fAPIGroups, $fSortByState, $iDllRefcode) 1736 1737 { 1737 1738 $sURLArgs = "authorrefcode=".$iRefcode. 1738 ($f Modules ? "&fModules=1" : "").1739 ($fDlls ? "&fDlls=1" : ""). 1739 1740 ($fFunctions ? "&fFunctions=1" : ""). 1740 1741 ($fFiles ? "&fFiles=1" : ""). … … 1745 1746 * Navigation - TOP 1746 1747 */ 1747 $sExpand = "authorrefcode=".$iRefcode."&f Modules=1&fFiles=1&fFunctions=1&fAPIGroups=1&fAuthors=1&mod=".$iModRefcode;1748 $sExpand = "authorrefcode=".$iRefcode."&fDlls=1&fFiles=1&fFunctions=1&fAPIGroups=1&fAuthors=1&dll=".$iDllRefcode; 1748 1749 if ($fSortByState) $sExpand = $sExpand."&fSortByState=".$fSortByState; 1749 1750 $sCollapse = "authorrefcode=".$iRefcode; … … 1795 1796 } 1796 1797 $sql = sprintf("SELECT\n". 1797 " COUNT(f. module) as functions1798 " COUNT(f.dll) as functions 1798 1799 \n". 1799 1800 "FROM\n". … … 1803 1804 " fa.author = %d AND". 1804 1805 " f.refcode = fa.function\n". 1805 "GROUP BY f. module",1806 "GROUP BY f.dll", 1806 1807 $iRefcode); 1807 $c Modules = 0;1808 if (($result2 = mysql_query($sql, $db)) && ($c Modules = mysql_num_rows($result2)) > 0)1809 Odin32DBInfoRow1NoArray("# Moduless", $cModules, "","","","");1808 $cDlls = 0; 1809 if (($result2 = mysql_query($sql, $db)) && ($cDlls = mysql_num_rows($result2)) > 0) 1810 Odin32DBInfoRow1NoArray("# Dlls", $cDlls, "","","",""); 1810 1811 $sql = sprintf("SELECT\n". 1811 " COUNT(f. module) as functions1812 " COUNT(f.dll) as functions 1812 1813 \n". 1813 1814 "FROM\n". … … 1824 1825 Odin32DBInfoRow1NoArray("# Files", $cFiles, "","","",""); 1825 1826 $sql = sprintf("SELECT\n". 1826 " COUNT(f. module) as functions1827 " COUNT(f.dll) as functions 1827 1828 \n". 1828 1829 "FROM\n". … … 1866 1867 1867 1868 /* 1868 * Modules1869 */ 1870 Odin32DBNaslov(" Modules", "Modules");1871 if ($f Modules)1869 * Dlls 1870 */ 1871 Odin32DBNaslov("Dlls", "dlls"); 1872 if ($fDlls) 1872 1873 { 1873 1874 $sql = sprintf("SELECT\n". 1874 " m.refcode,\n".1875 " m.name,\n".1875 " d.refcode,\n". 1876 " d.name,\n". 1876 1877 " COUNT(f.refcode)\n". 1877 1878 "FROM\n". 1878 1879 " fnauthor fa,\n". 1879 " module m,\n".1880 " dll d,\n". 1880 1881 " function f\n". 1881 1882 "WHERE\n". 1882 1883 " fa.author = %d AND\n". 1883 1884 " fa.function = f.refcode AND\n". 1884 " f. module = m.refcode\n".1885 "GROUP BY m.refcode\n".1886 "ORDER BY m.name\n",1885 " f.dll = d.refcode\n". 1886 "GROUP BY d.refcode\n". 1887 "ORDER BY d.name\n", 1887 1888 $iRefcode); 1888 Odin32DBWrite Modules($sql, $db, $sURLArgs);1889 Odin32DBWriteDlls($sql, $db, $sURLArgs); 1889 1890 } 1890 1891 else 1891 echo "Click <a href=\"Odin32DB.phtml# modules?".$sURLArgs."&fModules=1".1892 echo "Click <a href=\"Odin32DB.phtml#dlls?".$sURLArgs."&fDlls=1". 1892 1893 "\">here</a> to see all files.\n"; 1893 1894 … … 1902 1903 " f.refcode,\n". 1903 1904 " f.name,\n". 1904 " m.refcode,\n".1905 " m.name,\n".1905 " d.refcode,\n". 1906 " d.name,\n". 1906 1907 " s.color,\n". 1907 1908 " s.name\n". … … 1909 1910 " fnauthor fa\n". 1910 1911 " JOIN function f\n". 1911 " JOIN module m\n".1912 " JOIN dll d\n". 1912 1913 " LEFT JOIN state s ON f.state = s.refcode\n". 1913 1914 "WHERE\n". 1914 1915 " fa.author = %d AND\n". 1915 1916 " fa.function = f.refcode AND \n". 1916 " f. module = m.refcode\n",1917 " f.dll = d.refcode\n", 1917 1918 $iRefcode); 1918 1919 if ($fSortByState) … … 1920 1921 else 1921 1922 $sql = $sql."ORDER BY d.name, f.name"; 1922 Odin32DBWriteFunctionsWith Modules($sql, $db, $sURLArgs);1923 Odin32DBWriteFunctionsWithDlls($sql, $db, $sURLArgs); 1923 1924 } 1924 1925 else … … 2037 2038 " g.refcode AS refcode,\n". 2038 2039 " g.description AS description,\n". 2039 " m.name AS modname,\n".2040 " m.refcode AS modrefcode\n".2040 " d.name AS dllname,\n". 2041 " d.refcode AS dllrefcode\n". 2041 2042 "FROM\n". 2042 2043 " apigroup g\n". 2043 " JOIN module m\n".2044 " JOIN dll d\n". 2044 2045 "WHERE\n". 2045 2046 " g.refcode = %d AND". 2046 " g. module = m.refcode\n",2047 " g.dll = d.refcode\n", 2047 2048 $iRefcode); 2048 2049 if (($result = mysql_query($sql, $db)) && mysql_num_rows($result) > 0 && ($array = mysql_fetch_array($result))) … … 2054 2055 echo "\n<table width=100% border=3 cellpadding=0>\n"; 2055 2056 Odin32DBInfoRow1("Name", $array, "name","","","",""); 2056 Odin32DBInfoRow1(" Module", $array, "modname","modrefcode","modrefcode","bad configuration","");2057 Odin32DBInfoRow1("Dll", $array, "dllname","dllrefcode","dllrefcode","bad configuration",""); 2057 2058 if (isset($array["description"])) 2058 2059 Odin32DBInfoRow1("Description", $array, "description","","","",""); … … 2084 2085 2085 2086 $sql = sprintf("SELECT\n". 2086 " COUNT(f. module) as functions\n".2087 " COUNT(f.dll) as functions\n". 2087 2088 "FROM\n". 2088 2089 " fnauthor fa,\n". … … 2230 2231 * Navigation - TOP 2231 2232 */ 2232 $sExpand = "authorrefcode=".$iRefcode."&f Modules=1&fFiles=1&fFunctions=1&fAPIGroups=1&fAuthors=1&module=".$iModRefcode;2233 $sExpand = "authorrefcode=".$iRefcode."&fDlls=1&fFiles=1&fFunctions=1&fAPIGroups=1&fAuthors=1&dll=".$iDllRefcode; 2233 2234 if ($fSortByState) $sExpand = $sExpand."&fSortByState=".$fSortByState; 2234 2235 $sCollapse = "authorrefcode=".$iRefcode; … … 2242 2243 " dn.note AS note,\n". 2243 2244 " dn.refcode AS refcode,\n". 2244 " dn. module AS modrefcode,\n".2245 " dn.dll AS dllrefcode,\n". 2245 2246 " dn.file AS filerefcode,\n". 2246 2247 " dn.seqnbrnote AS seqnbnote,\n". … … 2248 2249 " dn.seqnbr AS seqnbr,\n". 2249 2250 " dn.line AS line,\n". 2250 " m.name AS modname,\n".2251 " d.name AS dll,\n". 2251 2252 " f.name AS file\n". 2252 2253 "FROM\n". 2253 2254 " designnote dn,\n". 2254 " module m,\n".2255 " dll d,\n". 2255 2256 " file f\n". 2256 2257 "WHERE dn.refcode = %d\n". 2257 " AND dn. module = m.refcode\n".2258 " AND dn.dll = d.refcode\n". 2258 2259 " AND dn.file = f.refcode\n". 2259 2260 "ORDER BY dn.seqnbrnote\n", … … 2267 2268 echo "\n<table width=100% border=3 cellpadding=0>\n"; 2268 2269 Odin32DBInfoRow1("Title", $array, "name","","","",""); 2269 Odin32DBInfoRow1("Module", $array, " modname","","","","");2270 Odin32DBInfoRow1("Module", $array, "dll","","","",""); 2270 2271 Odin32DBInfoRow1("File", $array, "file","","","",""); 2271 2272 Odin32DBInfoRow1("Line", $array, "line","","","","");
Note:
See TracChangeset
for help on using the changeset viewer.