hasPriv("admin"))
util_show_error_page_and_exit("Insufficient privileges.");
// we want to delete a user
if(isset($aClean['sAction']) && $aClean['sAction'] == "delete" &&
is_numeric($aClean['iUserId']))
{
$oUser = new User($aClean['iUserId']);
$oUser->delete();
}
// search form
echo html_frame_start("Users Management","400","",0);
$aClean['sSearch'] = isset($aClean['sSearch']) ? $aClean['sSearch'] : '';
$sLimit100 = $sLimit200 = $sLimit500 = '';
if ( isset($aClean['iLimit']) )
{
switch ($aClean['iLimit'])
{
case '100':
$sLimit100 = 'selected';
break;
case '200':
$sLimit200 = 'selected';
break;
case '500':
$sLimit500 = 'selected';
break;
}
}
$sOrder1 = $sOrder2 = $sOrder3 = '';
if ( isset($aClean['sOrderBy']) )
{
switch ($aClean['sOrderBy'])
{
case 'email':
$sOrder1 = 'selected';
break;
case 'realname':
$sOrder2 = 'selected';
break;
case 'created':
$sOrder3 = 'selected';
break;
}
}
?>
\n\n";
echo "\n";
echo " | Real name | \n";
echo " E-mail | \n";
echo " Creation date | \n";
echo " Last connected | \n";
echo " Roles | \n";
echo " Action | \n";
echo "
\n\n";
if(is_numeric($aClean['iLimit']) && in_array($aClean['sOrderBy'],array("email","realname","created")))
{
$sSearch = $aClean['sSearch'];
$sQuery = "SELECT * FROM user_list
WHERE realname LIKE '%?%' OR email LIKE '%?%'
ORDER BY ?
LIMIT ?";
$hResult = query_parameters($sQuery, $sSearch, $sSearch, $aClean['sOrderBy'],
$aClean['iLimit']);
$i=0;
while($hResult && $oRow = query_fetch_object($hResult))
{
$oUser = new User($oRow->userid);
$sAreYouSure = "Are you sure that you want to delete user ".addslashes($oUser->sRealname)." ?";
echo "\n";
echo " | ".$oUser->sRealname." | \n";
echo " ".$oUser->sEmail." | \n";
echo " ".$oUser->sDateCreated." | \n";
echo " ".$oUser->sStamp." | \n";
echo " ";
if($oUser->hasPriv("admin")) echo "A";
if($oUser->isMaintainer()) echo "M";
echo " | \n";
echo " [userid."&sSearch=".$sSearch."&iLimit=".$aClean['iLimit']."&sOrderBy=".$aClean['sOrderBy']."\">edit] [userid."&sSearch=".$sSearch."&iLimit=".$aClean['iLimit']."&sOrderBy=".$aClean['sOrderBy']."&sSubmit=true\">delete] | \n";
echo "
\n\n";
}
}
echo "";
echo html_frame_end();
}
apidb_footer();
?>