-body {
- margin: 1px;
- font: 12pt verdana, arial, helvetica, sans-serif;
- background-color: #bbb;
-}
-#body {
- position: relative;
- width: 640px;
- margin-left: auto;
- margin-right: auto;
- padding: 5px 2px 2px 2px;
-}
-#content0 {
- position: relative;
- padding: 5px 0 5px 0;
-}
-#sitename {
- font-size: 24pt;
- font-weight: bold;
-}
-#contact {
- position: absolute;
- right: 0;
- font-size: 10pt;
- margin-top: 20px;
-}
-#content1 {
- background-color: #aaa;
- border: 1px outset #aaa;
- padding: 3px;
- font-size: 9pt;
- text-align: right;
-}
-#content2 {
- padding: 10px;
- background-color: #aaa;
- border: 1px inset #999;
- font-size: 9pt;
- text-align: left;
- display: block;
- padding-bottom: auto;
-}
-#content3 {
- background-color: #aaa;
- padding: 3px;
- font-size: 7pt;
- text-align: right;
- border: 1px outset #999;
- font-style: italic;
-}
-a, a:link, a:visited, a:active {
- color: maroon;
- text-decoration: none;
-}
-a:hover {
- color: white;
- text-decoration: none;
- border-bottom: 1px dashed #aaa;
-}
-form {
+#content_wide form {
margin: 0;
display: inline;
}
-p {
- font-family: Verdana;
+#content_wide p {
font-size: 10pt;
text-indent: 25px;
}
-h2 {
+#content_wide h2 {
margin-top: 0;
}
-input {
- font-family: Verdana;
+#content_wide input {
font-size: 9pt;
border: 1px solid black;
}
-table,tr,td {
+#content_wide table,tr,td {
padding: 0;
}
td p {
border-left: 1px solid black;
}
div.msg {
- margin: 0px 20px 20px 20px;
+ padding: 0px 20px 0px 0px;
background-color: #ccc;
border: 1px solid black;
font-weight: bold;
}
div.err {
color: maroon;
- margin: 0px 20px 20px 20px;
+ padding: 0px 20px 0px 0px;
background-color: #ccc;
border: 1px dashed black;
font-variant: small-caps;
//checkQuotas();
+printMsgs(array('this is a test msg: test 0'));
+printMsgs(array('this is a test msg: test 1', 'this is a test msg: test 2'));
+
+printErrors(array('this is a test error: test 0'));
+printErrors(array('this is a test error: test 1', 'this is a test error: test 2'));
+
include 'tpl/foot.php';
?>
include 'head.php';
?>
-<h2>Contact/Help</h2>
+<h3>Contact/Help</h3>
<?php printErrors($err); ?>
include 'head.php';
?>
-<h2>Page Error</h2>
+<h3>Page Error</h3>
<p>
The page you were trying to view experienced an error while loading.
+ </div> <!-- end#content -->
+ </div> <!-- end#main -->
+ </div>
+ <!-- end#rap -->
+ <!-- footer -->
+ <div id="foot"> </div>
+ <!-- end#foot -->
+ <div id="clearer"> </div>
+ <!-- end#clearer -->
+ <div id="footer">
+ <p id="credit" style="text-align: right;">
+ <strong><em>sql.mit.edu v<?php echo VERSION; ?></em></strong>
+ </p>
+ </div>
+ <!-- end#footer -->
+ </div>
+ <!-- end#outer -->
</div>
-<?/*
-<div id="content3">The SIPB MySQL Service is part of the <a href="http://scripts.mit.edu">scripts.mit.edu project</a>.<?php //echo VERSION; ?></div>
-*/?>
-<div id="content3"><a alt="scripts.mit.edu" href="/">sql.mit.edu v<?php echo VERSION; ?></a></div>
-</div>
+<!-- end#farouter -->
</body>
</html>
}\r
\r
?>\r
-<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"\r
- "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r
-<html>\r
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r
+ "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r
+<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r
<head>\r
+ <meta http-equiv="content-type" content="text/html; charset=utf-8" />\r
<title>MIT SIPB MySQL Service for Athena</title>\r
- <link rel=stylesheet href="<?=$BASE_URL?>mitsql.css" type="text/css">\r
- <base href="<?=$BASE_URL?>">\r
+ <link rel="stylesheet" href="http://scripts.mit.edu/style.css" type="text/css" />\r
+ <link rel="stylesheet" href="<?=$BASE_URL?>mitsql.css" type="text/css" />\r
+ <base href="<?=$BASE_URL?>" />\r
</head>\r
-\r
<body>\r
-<div id="body">\r
-<div id="content0"><span id="sitename">MIT SIPB MySQL Service</span><span id="contact"><a href="do/contact">Contact/Help</a></span></div>\r
-<div id="content1"><?php isOnline() && include('menu.php'); ?> </div>\r
-<div id="content2">\r
+<div id="farouter">\r
+ <div id="outer">\r
+ <div id="rap">\r
+ <div id="masthead">\r
+ <h1 id="header"><a href="http://sql.mit.edu/">sql.mit.edu</a></h1>\r
+ <h2 id="tagline">MIT SIPB MySQL Service for Athena<br />\r
+ email: <? echo htmlentities('sql@mit.edu'); ?></h2>\r
+ </div>\r
+ <div id="hmenu">\r
+ <?php isOnline() && include('menu.php'); ?>\r
+ </div>\r
+ <div id="main">\r
+ <div id="content_wide">\r
<?php
include 'head.php';
?>
-<h2>About</h2>
+<h3>About</h3>
<p>
This service provides <a href="http://dev.mysql.com/doc">MySQL</a> databases to <a href="http://ca.mit.edu/">MIT certificate</a> holders.
The SIPB MySQL Service is part of the <a href="http://scripts.mit.edu/">scripts.mit.edu</a> project.
</p>
-<h2>Backups</h2>
+<h3>Backups</h3>
<p>
<strong>We strongly recommend you keep your own backups of your SQL schema and data.</strong> Your MySQL data is not stored in AFS.
</p>
<?/*
-<h2>Quotas</h2>
+<h3>Quotas</h3>
<p>
By default, new users can create up to <strong>5 databases</strong>, consuming a total of <strong>50 megabytes</strong> of SQL data.
</p>
*/?>
-<h2>Disclaimer</h2>
+<h3>Disclaimer</h3>
<p>
Although this service has been designed with reliability in mind, the SIPB MySQL service should not be used to host critical applications that cannot tolerate downtime.
$thisTxt = isSSL()?' using this Certificate':' using your MySQL Password';
?>
-<h2>Login</h2>
+<h3>Login</h3>
<?php printErrors($err); ?>
<?php if (!isSSL()): ?>
<form method=post action="<?=$URI?>">
-<h3>Please enter your MySQL login information:</h3>
+<p>Please enter your MySQL login information:</p>
<p>username: <input type="text" name="u" value="<?=isset($i_u)?$i_u:''?>"></p>
<p>password: <input type="password" name="p"></p>
<?php elseif (isSSL() && !empty($SSLCred)): ?>
<form method=post action="<?=$URI?>">
-<h3>You are identified as: <?=$SSLUsername?></h3>
+<p>You are identified as: <?=$SSLUsername?></p>
<p><?=$SSLName?></p>
<p><?=$SSLEmail?></p>
<?php elseif (isSSL() && !is_null($SSLCred)): ?>
-<h3><a href="do/signup">Sign up</a> to use this service.</h3>
+<p><a href="do/signup">Sign up</a> to use this service.</p>
<?php endif; ?>
}
?>
-<h2>Databases</h2>
+<h3>Databases</h3>
<form method="post" action="<?=$URI?>">
<?php printErrors($err1); ?>
<input type=submit value="add"></p>
</form>
-<h2>Manage Data</h2>
+<h3>Manage Data</h3>
<p>One interface we recommend for managing SQL data is <a href="https://scripts.mit.edu/~sql/phpMyAdmin/" target="_blank">phpMyAdmin</a>. Feel free to use it after you've created your databases.</p>
<?php
+ <div id="hnav">
+ <ul id="navlist">
<?php if (isLoggedIn()): ?>
<div style="float:left">
-<a href="do/main?refresh">Databases</a> |
-<a href="do/setup">Account</a> |
+<li><a href="do/main?refresh">Databases</a></li>
+<li><a href="do/setup">Account</a></li>
<?php if (isAdmin()) { ?>
-<a href="do/admin/main">Admin</a> |
+<li><a href="do/admin/main">Admin</a></li>
<?php } ?>
-<a href="do/logout">Logout</a>
-</div>
+<li><a href="do/logout">Logout</a></li>
+</div>
<?php
$loggedInText = $Login->getUsername();
if (isImpersonating()) {
- $loggedInText = '<a href="do/admin/main?impersonate">'.$loggedInText.'</a>';
+ $loggedInText = '<li><a href="do/admin/main?impersonate">'.$loggedInText.'</a></li>';
}
?>
-Logged in: <em><?=$loggedInText?>@<?=DBHOST?></em>
+<div style="text-align: right;">
+Logged in: <em><?=$loggedInText?>@<?=DBHOST?></em>
+</div>
<?php else: ?>
-<div style="float:left; position: relative;">
-<a href="do/signup">Sign up</a> |
-<a href="https://scripts.mit.edu/~sql/phpMyAdmin/" target="_blank">phpMyAdmin</a> |
-<a href="do/index">Home</a>
+<div style="float:left;">
+<li><a href="do/signup">Sign up</a></li>
+<li><a href="https://scripts.mit.edu/~sql/phpMyAdmin/" target="_blank">phpMyAdmin</a></li>
+<li><a href="do/index">Home</a></li>
</div>
-<div style="float: right;">
-Login via <a href="do/login?ssl=0">SQL Password</a> or <a href="do/login?ssl=1">MIT Certificate</a>
+<div style="text-align: right;">
+Login via <li><a href="do/login?ssl=0">SQL Password</a><li><a href="do/login?ssl=1">MIT Certificate</a></li>
</div>
-
<?php endif; ?>
+ </ul>
+ </div>
include 'head.php';
?>
-<h2>System Maintenance</h2>
+<h3>System Maintenance</h3>
<p>
The MySQL Service interface is temporarily offline while we perform system maintenance.
include 'head.php';
?>
-<h2>Change MySQL Password</h2>
+<h3>Change MySQL Password</h3>
Your MySQL password should be different from your Athena account password.<br>
<br>
$thisTxt = isSSL()?' with this Certificate':' via SQL';
?>
-<h2>Signup</h2>
+<h3>Signup</h3>
<?php printErrors($err); ?>
<?php if ($LoginSSL->canSignup()): ?>
-<h3>You are registering as: <?=$LoginSSL->getUsername()?></h3>
+<p>You are registering as: <?=$LoginSSL->getUsername()?></p>
<p><?=$LoginSSL->getName()?></p>
<p><?=$LoginSSL->getEmail()?></p>
<?php elseif ($LoginSSL->canLogin()): ?>
-<h3>This account is already signed up.</h3>
+<p>Your account [<?=$LoginSSL->getUsername()?>] is already signed up.</p>
<?php else: ?>