<?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$|^localhost$/", $_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); | |
?> |