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);
+$i_search = mysql_escape_string($i_search);
$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;
-$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);
-$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
- 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));
*/
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) {
define('VER', '1.2');
if (DEVEL) {
define('VERSION', VER.'-dev');
+ defined('BASE_URL') || define('BASE_URL', '/~sql/dev/');
} else {
define('VERSION', VER);
+ defined('BASE_URL') || define('BASE_URL', '/~sql/main/');
}
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');