diff options
author | Philip Häusler <msquare@notrademark.de> | 2012-12-10 10:02:33 +0100 |
---|---|---|
committer | Philip Häusler <msquare@notrademark.de> | 2012-12-10 10:02:33 +0100 |
commit | 5660d36ef96845f6c6fbbe2be11cc1c851292cf1 (patch) | |
tree | ffce0095fb7aa6e79c17408df40e32773e7b17cc | |
parent | 079279a1d086e377b7c411292b1b2b6b9623ca18 (diff) |
#83 sort angeltypes to be confirmed
-rw-r--r-- | includes/pages/admin_user_angeltypes.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/includes/pages/admin_user_angeltypes.php b/includes/pages/admin_user_angeltypes.php index 4e431793..7923850b 100644 --- a/includes/pages/admin_user_angeltypes.php +++ b/includes/pages/admin_user_angeltypes.php @@ -19,7 +19,7 @@ function admin_user_angeltypes() { redirect(page_link_to('admin_user_angeltypes')); } - $users_source = sql_select("SELECT `UserAngelTypes`.`id`, `AngelTypes`.`name`, `User`.`Nick` FROM `UserAngelTypes` JOIN `AngelTypes` ON `UserAngelTypes`.`angeltype_id`=`AngelTypes`.`id` JOIN `User` ON `UserAngelTypes`.`user_id`=`User`.`UID` WHERE `AngelTypes`.`restricted`=1 AND `UserAngelTypes`.`confirm_user_id` IS NULL"); + $users_source = sql_select("SELECT `UserAngelTypes`.`id`, `AngelTypes`.`name`, `User`.`Nick` FROM `UserAngelTypes` JOIN `AngelTypes` ON `UserAngelTypes`.`angeltype_id`=`AngelTypes`.`id` JOIN `User` ON `UserAngelTypes`.`user_id`=`User`.`UID` WHERE `AngelTypes`.`restricted`=1 AND `UserAngelTypes`.`confirm_user_id` IS NULL ORDER BY `AngelTypes`.`name`"); $users = array (); foreach ($users_source as $user) { $user['actions'] = '<a href="' . page_link_to('admin_user_angeltypes') . '&confirm=' . $user['id'] . '">confirm</a>'; |