From 316c18f9129451bd30484293cadc5e9e8c62f604 Mon Sep 17 00:00:00 2001 From: Philip Häusler Date: Sun, 5 Jan 2014 19:31:17 +0100 Subject: removed old user angeltypes --- includes/pages/admin_user_angeltypes.php | 100 ------------------------------- includes/sys_menu.php | 1 - 2 files changed, 101 deletions(-) delete mode 100644 includes/pages/admin_user_angeltypes.php (limited to 'includes') diff --git a/includes/pages/admin_user_angeltypes.php b/includes/pages/admin_user_angeltypes.php deleted file mode 100644 index 2b623d72..00000000 --- a/includes/pages/admin_user_angeltypes.php +++ /dev/null @@ -1,100 +0,0 @@ - 0) { - $angel_type_source = sql_select("SELECT `AngelTypes`.* FROM `AngelTypes` WHERE `AngelTypes`.`id`=" . sql_escape($_REQUEST['confirm_all']) . " LIMIT 1"); - if(count($angel_type_source) > 0) { - if(!isset($_REQUEST['confirmed'])) { - return page(array( - info("Möchtest Du wirklich alle Engel vom Typ " . $angel_type_source[0]['name'] . " freischalten?", true), - buttons(array( - button(page_link_to('admin_user_angeltypes'), "Abbrechen", 'cancel'), - button(page_link_to('admin_user_angeltypes') . '&confirm_all=' . $_REQUEST['confirm_all'] . '&confirmed', "Ok", 'ok') - )) - )); - } - sql_query("UPDATE `UserAngelTypes` SET `confirm_user_id`=" . sql_escape($_SESSION['uid']) . " WHERE `angeltype_id`=" . sql_escape($_REQUEST['confirm_all']) . " LIMIT 1"); - engelsystem_log("Confirmed all " . $angel_type_source[0]['name']); - success(_("Confirmed all.")); - } - else error(_("Entry not found.")); - redirect(page_link_to('admin_user_angeltypes')); - } - - if (isset ($_REQUEST['deny_all']) && test_request_int('deny_all') && sql_num_query("SELECT * FROM `UserAngelTypes` WHERE `angeltype_id`=" . sql_escape($_REQUEST['deny_all']) . " AND `confirm_user_id` IS NULL") > 0) { - $angel_type_source = sql_select("SELECT `AngelTypes`.* FROM `AngelTypes` WHERE `AngelTypes`.`id`=" . sql_escape($_REQUEST['deny_all'])); - if(count($angel_type_source) > 0) { - if(!isset($_REQUEST['confirmed'])) { - return page(array( - info("Möchtest Du wirklich alle Engel vom Typ " . $angel_type_source[0]['name'] . " ablehnen?", true), - buttons(array( - button(page_link_to('admin_user_angeltypes'), "Abbrechen", 'cancel'), - button(page_link_to('admin_user_angeltypes') . '&deny_all=' . $_REQUEST['deny_all'] . '&confirmed', "Ok", 'ok') - )) - )); - } - sql_query("DELETE FROM `UserAngelTypes` WHERE `confirm_user_id` IS NULL AND `angeltype_id`=" . sql_escape($_REQUEST['deny_all'])); - engelsystem_log("Denied all " . $angel_type_source[0]['name']); - success("Denied all."); - } - else error("Entry not found."); - redirect(page_link_to('admin_user_angeltypes')); - } - - if (isset ($_REQUEST['confirm']) && test_request_int('confirm') && sql_num_query("SELECT * FROM `UserAngelTypes` WHERE `id`=" . sql_escape($_REQUEST['confirm']) . " AND `confirm_user_id` IS NULL") > 0) { - $user_angel_type_source = sql_select("SELECT `UserAngelTypes`.*, `User`.`Nick`, `User`.`UID`, `AngelTypes`.`name` FROM `UserAngelTypes` JOIN `User` ON `User`.`UID`=`UserAngelTypes`.`user_id` JOIN `AngelTypes` ON `AngelTypes`.`id`=`UserAngelTypes`.`angeltype_id` WHERE `UserAngelTypes`.`id`=" . sql_escape($_REQUEST['confirm']) . " LIMIT 1"); - if(count($user_angel_type_source) > 0) { - sql_query("UPDATE `UserAngelTypes` SET `confirm_user_id`=" . sql_escape($_SESSION['uid']) . " WHERE `id`=" . sql_escape($_REQUEST['confirm']) . " LIMIT 1"); - engelsystem_log("Confirmed " . User_Nick_render($user_angel_type_source[0]) . " as " . $user_angel_type_source[0]['name']); - success("Confirmed."); - } - else error("Entry not found."); - redirect(page_link_to('admin_user_angeltypes')); - } - - if (isset ($_REQUEST['deny']) && test_request_int('deny') && sql_num_query("SELECT * FROM `UserAngelTypes` WHERE `id`=" . sql_escape($_REQUEST['deny']) . " AND `confirm_user_id` IS NULL") > 0) { - $user_angel_type_source = sql_select("SELECT `UserAngelTypes`.*, `User`.`Nick`, `User`.`UID`, `AngelTypes`.`name` FROM `UserAngelTypes` JOIN `User` ON `User`.`UID`=`UserAngelTypes`.`user_id` JOIN `AngelTypes` ON `AngelTypes`.`id`=`UserAngelTypes`.`angeltype_id` WHERE `UserAngelTypes`.`id`=" . sql_escape($_REQUEST['deny']) . " LIMIT 1"); - if(count($user_angel_type_source) > 0) { - sql_query("DELETE FROM `UserAngelTypes` WHERE `id`=" . sql_escape($_REQUEST['deny']) . " LIMIT 1"); - engelsystem_log("Denied " . User_Nick_render($user_angel_type_source[0]) . " as " . $user_angel_type_source[0]['name']); - success("Denied."); - } - else error("Entry not found."); - redirect(page_link_to('admin_user_angeltypes')); - } - - $angel_types_source = sql_select("SELECT * FROM `AngelTypes` WHERE `restricted`=1 ORDER BY `name`"); - $content = array(); - foreach($angel_types_source as $angel_type) { - $user_angel_types_source = sql_select("SELECT `UserAngelTypes`.`id`, `User`.`Nick`, `User`.`UID` FROM `UserAngelTypes` JOIN `User` ON `UserAngelTypes`.`user_id`=`User`.`UID` WHERE `UserAngelTypes`.`angeltype_id`=" . sql_escape($angel_type['id']) . " AND `UserAngelTypes`.`confirm_user_id` IS NULL ORDER BY `User`.`Nick`"); - if(count($user_angel_types_source)) { - $users = array (); - foreach ($user_angel_types_source as $user) { - $user['name'] = User_Nick_render($user); - $user['actions'] = img_button(page_link_to('admin_user_angeltypes') . '&confirm=' . $user['id'], 'tick', _("confirm")); - $user['actions'] .= '  '; - $user['actions'] .= img_button(page_link_to('admin_user_angeltypes') . '&deny=' . $user['id'], 'cross', _("deny")); - $users[] = $user; - } - $content[] = '

' . $angel_type['name'] . ' ' . img_button(page_link_to('admin_user_angeltypes') . '&confirm_all=' . $angel_type['id'], 'tick', '', _("confirm all")) . ' ' . img_button(page_link_to('admin_user_angeltypes') . '&deny_all=' . $angel_type['id'], 'cross', '', _("deny all")) . '

' . table(array ( - 'name' => "Nick", - 'actions' => "" - ), $users); - } - } - - return page(array ( - msg(), - join('', $content) - )); -} - -?> diff --git a/includes/sys_menu.php b/includes/sys_menu.php index ae39afeb..f7cefdfa 100644 --- a/includes/sys_menu.php +++ b/includes/sys_menu.php @@ -53,7 +53,6 @@ function make_navigation() { "admin_user" => admin_user_title(), "admin_free" => admin_free_title(), "admin_questions" => admin_questions_title(), - "admin_user_angeltypes" => admin_user_angeltypes_title(), "admin_shifts" => admin_shifts_title(), "admin_rooms" => admin_rooms_title(), "admin_groups" => admin_groups_title(), -- cgit v1.2.3-54-g00ecf