## REVISION 4
RewriteCond %{REQUEST_URI} ^.*/do/(.+)$
-RewriteRule ^do/(.+)$ $1.php [QSA]
+RewriteRule ^do/(.+)$ $1.php [L,QSA]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule .* do/index [R,L,QSA]
<?php
+/*
+ (c) 2005 Joe Presbrey
+*/
require_once('mitsql.cfg.php');
require_once('mitsql.lib.php');
<?php
+/*
+ (c) 2005 Joe Presbrey
+*/
$_NEW_DB['nBytes'] = 0;
$_NEW_DB['dCreated'] = 'NOW()';
<?php
+/*
+ (c) 2005 Joe Presbrey
+*/
require_once('mitsql.cfg.php');
require_once('mitsql.lib.php');
<?php
+/*
+ (c) 2005 Joe Presbrey
+*/
require_once('mitsql.cfg.php');
require_once('mitsql.lib.php');
<?php
+/*
+ (c) 2005 Joe Presbrey
+*/
require_once('joe.lib.php');
<?php
+/*
+ (c) 2005 Joe Presbrey
+*/
## FORMATTING FUNCTIONS
<?php
+/*
+ (c) 2005 Joe Presbrey
+*/
function ErrorHandler($errno, $errstr, $errfile, $errline, $errcontext) {
$error_halt = true;
<?php
/*
(c) 2005 Joe Presbrey
- joepresbrey@gmail.com
ATTN: This library was assembled and completed in its entirety independent of
any and all corporate projects and/or work environ.
<?php
+/*
+ (c) 2005 Joe Presbrey
+*/
require_once('mitsql.lib.php');
$uname = $User->getUsername();
$uname = str_replace('.','',$uname);
$dbname = $uname.DELIMETER.$i_newdb;
- if ($User->isOverQuota()) {
+ if ($User->isOverQuota() && !isAdmin()) {
$err1[] = 'You are over your quota. You may not add more databases.';
- } elseif (count($User->getDBList())>MAXDBS) {
+ } elseif (count($User->getDBList())>MAXDBS && !isAdmin()) {
$err1[] = 'You have too many databases. You may not add more databases.';
} elseif (empty($i_newdb)) {
$err1[] = 'Your database name may not be empty.';
<?php
+/*
+ (c) 2005 Joe Presbrey
+*/
require_once('mitsql.lib.php');
<?php
+/*
+ (c) 2005 Joe Presbrey
+*/
require_once('mitsql.cfg.php');
require_once('mitsql.lib.php');
<?php
+/*
+ (c) 2005 Joe Presbrey
+*/
require_once('mitsql.cfg.php');
require_once('mitsql.lib.php');
<?php
+/*
+ (c) 2005 Joe Presbrey
+*/
require_once('mitsql.cfg.php');
require_once('mitsql.lib.php');
<?php
+/*
+ (c) 2005 Joe Presbrey
+*/
require_once('mitsql.cfg.php');
require_once('mitsql.lib.php');
<?php
+/*
+ (c) 2005 Joe Presbrey
+*/
require_once('mitsql.cfg.php');
require_once('mitsql.lib.php');
<?php
+/*
+ (c) 2005 Joe Presbrey
+*/
require_once('mitsql.cfg.php');
require_once('mitsql.lib.php');
<?php
include 'head.php';
?>
-<?/*
-<h3>About</h3>
-*/?>
<p>
This service provides <a target="_blank" href="http://dev.mysql.com/doc">MySQL</a> databases to <a target="_blank" href="http://ca.mit.edu/">MIT certificate</a> holders.
-You must choose a MySQL password (which should be different from your Athena account password) when you <a href="do/signup">sign up</a>, and you can
+You must choose a MySQL password (which should be different from your Athena account password) when you <a href="do/signup">sign up</a>, and
then use this interface to create and drop databases. All subsequent SQL commands can be issued from any host, client, and/or script of your choice;
simply connect to the MySQL server at <b>sql.mit.edu</b> using your username and your new MySQL password.
You may find it convenient to run scripts using the <a target="_blank" href="http://scripts.mit.edu/web">web script service</a> or
All uses of this service must comply with the <a target="_blank" href="http://web.mit.edu/olh/Welcome/rules.html">MITnet rules of use</a>.
</p>
-<?/*
-<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.
-Although we use various technical means to try to ensure the availability of your data (including hardware-level redundancy and real-time replication), we can make no guarantees about the reliability of the service and access to your data.
-</p>
-
-<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.
-The system will periodically check your database sizes and suspend creation of new data (INSERT statements) if your total usage exceeds your allotted quota.
-</p>
-
-<p>
-This service is not designed to store gratuitous amounts of information in the BLOB or BINARY formats. Extra quota space will not be allotted to users for this type of data.
-Users should instead store these types of data in AFS and use SQL tables only to catalogue it.
-</p>
-
-<p>
-<strong>Always use this interface to create and drop databases.</strong>
-Although you can drop any of your databases outside this interface, doing so will not relinquish your rights to that database and will therefore still count against your quota.
-</p>
-
-<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.
-<? /* We may, of course, suspend or terminate your MySQL account at any time, for any or no reason. */ ?>
We perform no query logging, schema or data backups, or any other backups otherwise generally available. You are solely responsible for performing backups of your data.
We maintain general usage statistics of this service by the MIT community at large.
</p>