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 $sql_search"; $r = fetchRows(DBSelect($sqlc)); $r = array_shift($r); count($r) && $userCount = array_shift($r); $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 $sql_search ORDER BY $i_sortby $sortSQL"; $sql .= ' LIMIT '.($i_page-1)*$i_pagesize.','.$i_pagesize; $pageArray = range(1,ceil($userCount/$i_pagesize)); $pageCount = count($pageArray); $users = fetchRows(DBSelect($sql),'UserId'); include 'tpl/head.php'; ?> ',$userCount,' users | '; if ($i_page > 1) $tPagePrev = ' Prev'; else $tPagePrev = 'First'; if ($i_page < $pageCount) $tPageNext = ' Next'; else $tPageNext = 'Last'; if (!empty($tPageNext) && empty($tPagePrev)) echo($tPageNext); elseif (empty($tPageNext) && !empty($tPagePrev)) echo($tPagePrev); else echo "$tPagePrev | $tPageNext"; /* echo ' | Skip to: '; foreach($pageArray as $availablePage) { echo ' '.$availablePage.''; } */ echo ' | Page '.$i_page.' of '.$pageCount.' by '.$i_sortby; ?>

'; echo ''; foreach($columns as $column) { if (!empty($column)) { $qsa = array('sortby'=>$column); if ($column==$i_sortby) $qsa['sortorder']=abs($i_sortorder-1); echo ''.$column.''; } else echo ''; } echo ''; foreach($users as $id=>$user) { echo '', $user['UserId'], '', '', $user['Username'], '', $user['Name'], '', sprintSize($user['nBytes']), '', sprintSize($user['nBytesHard']), '', sprintSize($user['nBytesOver']), '', $user['dSignup'], // '', // $user['dLastCheck'], ''; } echo ''; include 'tpl/foot.php'; ?>