base_url dependent on devel status
error handler outputs errors for devel
git-svn-id: svn://presbrey.mit.edu/sql/mitsql@110
a142d4bd-2cfb-0310-9673-
cb33a7e74f58
empty($i_page) && $i_page=1;
empty($i_sortby) && $i_sortby='dSignup';
empty($i_sortorder) && $i_sortorder=0;
empty($i_page) && $i_page=1;
empty($i_sortby) && $i_sortby='dSignup';
empty($i_sortorder) && $i_sortorder=0;
+!isset($i_search) && $i_search='';
if ($i_sortorder>0) $sortSQL = 'ASC'; else $sortSQL = 'DESC';
$i_pagesize = mysql_escape_string($i_pagesize);
$i_page = mysql_escape_string($i_page);
if ($i_sortorder>0) $sortSQL = 'ASC'; else $sortSQL = 'DESC';
$i_pagesize = mysql_escape_string($i_pagesize);
$i_page = mysql_escape_string($i_page);
+$i_search = mysql_escape_string($i_search);
$i_sortby = mysql_escape_string($i_sortby);
$i_sortby = mysql_escape_string($i_sortby);
+$sql_search = empty($i_search)?'':" AND Username LIKE '%$i_search%' ";
+
$columns = array('','Username','Name','nBytes','nBytesHard','nBytesOver','dSignup');
$userCount = 0;
$columns = array('','Username','Name','nBytes','nBytesHard','nBytesOver','dSignup');
$userCount = 0;
-$sqlc = "SELECT COUNT(*) as c FROM User WHERE bEnabled=1";
+$sqlc = "SELECT COUNT(*) as c FROM User WHERE bEnabled=1 $sql_search";
$r = fetchRows(DBSelect($sqlc));
$r = array_shift($r);
count($r) && $userCount = array_shift($r);
$r = fetchRows(DBSelect($sqlc));
$r = array_shift($r);
count($r) && $userCount = array_shift($r);
-$sql = sprintf("SELECT User.UserId,Username,Name,dSignup,dLastCheck,nBytes,nBytesSoft,nBytesHard,
+$sql = "SELECT User.UserId,Username,Name,dSignup,dLastCheck,nBytes,nBytesSoft,nBytesHard,
IF(nBytes>nBytesHard,nBytes-nBytesHard,0) as nBytesOver
FROM User
NATURAL JOIN UserStat
NATURAL JOIN UserQuota
WHERE bEnabled=1
IF(nBytes>nBytesHard,nBytes-nBytesHard,0) as nBytesOver
FROM User
NATURAL JOIN UserStat
NATURAL JOIN UserQuota
WHERE bEnabled=1
- ORDER BY $i_sortby $sortSQL");
+ $sql_search
+ ORDER BY $i_sortby $sortSQL";
$sql .= ' LIMIT '.($i_page-1)*$i_pagesize.','.$i_pagesize;
$pageArray = range(1,ceil($userCount/$i_pagesize));
$sql .= ' LIMIT '.($i_page-1)*$i_pagesize.','.$i_pagesize;
$pageArray = range(1,ceil($userCount/$i_pagesize));
*/
echo ' | Page '.$i_page.' of '.$pageCount.' by '.$i_sortby;
*/
echo ' | Page '.$i_page.' of '.$pageCount.' by '.$i_sortby;
+?>
+<span></span>
+<form method=get id=search name=search>
+<input type=text name=search value="<?=$i_search?>" />
+<input type=submit value="Search" />
+<input type=button value="Clear" onClick="document.forms['search']['search'].value = ''; document.forms['search'].submit();" />
+</form>
+<?php
echo '<table cellspacing="0" cellpadding="0" class="usertable">';
echo '<thead>';
foreach($columns as $column) {
echo '<table cellspacing="0" cellpadding="0" class="usertable">';
echo '<thead>';
foreach($columns as $column) {
}
$error_bt = ErrorBacktrace(debug_backtrace());
$error_msg = $type . ':' . $error_msg . "\n" . $error_bt . "\n\n";
}
$error_bt = ErrorBacktrace(debug_backtrace());
$error_msg = $type . ':' . $error_msg . "\n" . $error_bt . "\n\n";
- if (DEVEL && 0) {
- echo nl2br($error_msg);
+ if (DEVEL) {
+ echo '<table width="100%" bgcolor="white"><tr><td><pre>'.$error_msg.'</pre></td></tr></table>';
} else {
$error_msg .= print_r(get_included_files(),1)."\n";
$error_msg .= print_r($errcontext,1);
} else {
$error_msg .= print_r(get_included_files(),1)."\n";
$error_msg .= print_r($errcontext,1);
define('VER', '1.2');
if (DEVEL) {
define('VERSION', VER.'-dev');
define('VER', '1.2');
if (DEVEL) {
define('VERSION', VER.'-dev');
+ defined('BASE_URL') || define('BASE_URL', '/~sql/dev/');
} else {
define('VERSION', VER);
} else {
define('VERSION', VER);
+ defined('BASE_URL') || define('BASE_URL', '/~sql/main/');
}
define('DELIMETER', '+');
defined('DBHOST') || define('DBHOST', 'sql.mit.edu');
}
define('DELIMETER', '+');
defined('DBHOST') || define('DBHOST', 'sql.mit.edu');
-defined('BASE_URL') || define('BASE_URL', '/~sql/main/');
defined('ADMINUSER') || define('ADMINUSER', 'root');
defined('ADMINPASS') || die('Please email sql@mit.edu');
defined('ADMINDB') || define('ADMINDB', 'mitsql');
defined('ADMINUSER') || define('ADMINUSER', 'root');
defined('ADMINPASS') || die('Please email sql@mit.edu');
defined('ADMINDB') || define('ADMINDB', 'mitsql');