X-Git-Url: https://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=web%2Fusermgmt.php;h=95a9c76cfe1f3b3c7cf09f58197eb2e7357d8d4a;hb=328de26963e512cc34c999baf67f449020a62bfd;hp=ec9a83e455d2e3d149848649acf3c6279043de43;hpb=64be81589ed42dea811d61287b6aa84fce01cb8a;p=brisk.git diff --git a/web/usermgmt.php b/web/usermgmt.php index ec9a83e..95a9c76 100644 --- a/web/usermgmt.php +++ b/web/usermgmt.php @@ -225,7 +225,8 @@ SELECT usr.*, guar.login AS guar_login FROM %susers AS usr JOIN %susers AS guar ON guar.code = usr.guar_code WHERE ( (usr.type & (CAST (X'%x' as integer))) = (CAST (X'%x' as integer)) ) - AND usr.disa_reas = %d;", + AND usr.disa_reas = %d + ORDER BY usr.lintm;", $G_dbpfx, $G_dbpfx, USER_FLAG_TY_DISABLE, USER_FLAG_TY_DISABLE, USER_DIS_REA_NU_ADDED); @@ -342,7 +343,8 @@ SELECT usr.*, guar.login AS guar_login FROM %susers AS usr JOIN %susers AS guar ON guar.code = usr.guar_code WHERE ( (usr.type & (CAST (X'%x' as integer))) = (CAST (X'%x' as integer)) ) - AND usr.disa_reas = %d;", + AND usr.disa_reas = %d + ORDER BY usr.lintm;", $G_dbpfx, $G_dbpfx, USER_FLAG_TY_DISABLE, USER_FLAG_TY_DISABLE, USER_DIS_REA_NU_MAILED); @@ -473,7 +475,8 @@ SELECT usr.*, guar.login AS guar_login FROM %susers AS usr JOIN %susers AS guar ON guar.code = usr.guar_code WHERE ( (usr.type & (CAST (X'%x' as integer))) = (CAST (X'%x' as integer)) ) - AND usr.disa_reas = %d;", + AND usr.disa_reas = %d + ORDER BY usr.lintm;", $G_dbpfx, $G_dbpfx, USER_FLAG_TY_ALL, USER_FLAG_TY_DISABLE, USER_DIS_REA_NU_TOBECHK);