| <?php |
| require_once ("../includes/buildServer-common.php"); |
| require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/app.class.php"); require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/nav.class.php"); require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/menu.class.php"); $App = new App(); $Nav = new Nav(); $Menu = new Menu(); include($App->getProjectCommon()); |
| |
| require_once($_SERVER['DOCUMENT_ROOT'] . "/modeling/includes/scripts.php"); |
| $isEMFserver = (preg_match("/^emf(?:\.torolab\.ibm\.com)$/", $_SERVER["SERVER_NAME"])); |
| $isBuildServer = (preg_match("/^(emft|modeling|build)\.eclipse\.org$/", $_SERVER["SERVER_NAME"])) || $isEMFserver; |
| internalUseOnly(); |
| |
| include($_SERVER["DOCUMENT_ROOT"] . "/modeling/includes/db.php"); |
| |
| $query = "SHOW TABLES"; |
| |
| $tables = array(); |
| $pageTitle = "Modeling Project Database Schema"; |
| |
| ob_start(); |
| |
| print "<div id=\"midcolumn\">\n"; |
| |
| print "<h1>$pageTitle</h1>"; |
| print '<p>This database includes tables for <a href="http://wiki.eclipse.org/Search_CVS">Search CVS</a>,' . |
| '<a href="http://wiki.eclipse.org/Search_CVS%2C_Release_Notes%2C_Build_News">Release Notes & Build News</a>,' . |
| '<a href="http://www.eclipse.org/modeling/emf/downloads/stats.php">Download Stats</a>, and <a href="http://www.eclipse.org/modeling/team/">Meet The Modeling Team</a>.</p>'."\n"; |
| |
| $nav = ""; |
| $nav .= "<div class=\"sideitem\">\n"; |
| $nav .= "<h6>Tables</h6>\n"; |
| $result = wmysql_query($query); |
| if (!$result) |
| { |
| print "<p><ul><li><i>MySQL Error: ".mysql_error()."</i></li></ul></p>\n"; |
| } |
| else |
| { |
| $nav .= "<p><ul>\n"; |
| while($row = mysql_fetch_row($result)) |
| { |
| $tables[] = $row[0]; |
| $nav .= "<li><a href=\"#" . $row[0] . "\">" . ucfirst($row[0]) . "</a></li>\n"; |
| } |
| $nav .= "</ul></p>\n"; |
| } |
| |
| $nav .= "</div>\n"; |
| |
| $desc_cols = array("Field", "Type", "Null", "Key", "Default", "Extra"); |
| |
| foreach ($tables as $tablename) |
| { |
| $query = "DESCRIBE $tablename"; |
| print "<div class=\"homeitem3col\">\n"; |
| print "<h3><a name=\"$tablename\"></a>" . ucfirst($tablename) . " Table</h3>\n"; |
| $result = mysql_query($query); |
| if (!$result) |
| { |
| print "<p><ul><li><i>MySQL Error: ".mysql_error()."</i></li></ul></p>\n"; |
| } |
| else |
| { |
| print "<p><blockquote><table border=\"1\" cellspacing=\"0\" cellpadding=\"2\"><tr>\n"; |
| foreach ($desc_cols as $col) |
| { |
| print "<th>$col</th>\n"; |
| } |
| print "</tr>\n"; |
| while($row = mysql_fetch_assoc($result)) |
| { |
| print "<tr>\n"; |
| foreach ($desc_cols as $col) |
| { |
| print "<td>" . str_replace(",", ", ", $row[$col]) . "</td>\n"; |
| } |
| print "</tr>\n"; |
| } |
| print "</table></blockquote></p> \n"; |
| } |
| print "</div>"; |
| } |
| |
| print "</div>\n"; // midcolumn |
| |
| print "<div id=\"rightcolumn\">\n"; |
| |
| if (sizeof($tables) > 0 && $nav) |
| { |
| print $nav; |
| } |
| |
| print "<div class=\"sideitem\">\n"; |
| print "<h6>About</h6>\n"; |
| print "<p>Updated:<br/>" . date("Y-m-d H:i T") . "</p>\n"; |
| print "</div>\n"; |
| |
| print "</div>\n"; // rightcolumn |
| |
| print "</div>\n"; |
| |
| $html = ob_get_contents(); |
| ob_end_clean(); |
| |
| $pageKeywords = ""; |
| $pageAuthor = "Nick Boldt"; |
| |
| $App->AddExtraHtmlHeader('<link rel="stylesheet" type="text/css" href="/modeling/includes/downloads.css"/>' . "\n"); |
| $App->generatePage($theme, $Menu, $Nav, $pageAuthor, $pageKeywords, $pageTitle, $html); |
| ?> |