0.2.1/inc/modules/admin/what-del_holiday.php

   1 <?php\r
   2 /************************************************************************\r
   3  * MXChange v0.2.1                                    Start: 07/24/2004 *\r
   4  * ================                             Last change: 08/09/2004 *\r
   5  *                                                                      *\r
   6  * -------------------------------------------------------------------- *\r
   7  * File              : what-del_holiday.php                             *\r
   8  * -------------------------------------------------------------------- *\r
   9  * Short description : Remove holiday requests                          *\r
  10  * -------------------------------------------------------------------- *\r
  11  * Kurzbeschreibung  : Urlaubsschaltungen entfernen                     *\r
  12  * -------------------------------------------------------------------- *\r
  13  *                                                                      *\r
  14  * -------------------------------------------------------------------- *\r
  15  * Copyright (c) 2003 - 2008 by Roland Haeder                           *\r
  16  * For more information visit: http://www.mxchange.org                  *\r
  17  *                                                                      *\r
  18  * This program is free software; you can redistribute it and/or modify *\r
  19  * it under the terms of the GNU General Public License as published by *\r
  20  * the Free Software Foundation; either version 2 of the License, or    *\r
  21  * (at your option) any later version.                                  *\r
  22  *                                                                      *\r
  23  * This program is distributed in the hope that it will be useful,      *\r
  24  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *\r
  25  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *\r
  26  * GNU General Public License for more details.                         *\r
  27  *                                                                      *\r
  28  * You should have received a copy of the GNU General Public License    *\r
  29  * along with this program; if not, write to the Free Software          *\r
  30  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *\r
  31  * MA  02110-1301  USA                                                  *\r
  32  ************************************************************************/\r
  33 \r
  34 // Some security stuff...\r
  35 if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!IS_ADMIN()))\r
  36 {\r
  37         $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4)."/security.php";\r
  38         require($INC);\r
  39 }\r
  40 // Add description as navigation point\r
  41 ADD_DESCR("admin", basename(__FILE__));\r
  42 \r
  43 // Check for selected holidays\r
  44 $SUM = 0;\r
  45 if (isset($_POST['sel'])) $SUM = SELECTION_COUNT($_POST['sel']);\r
  46 \r
  47 // Shall I delete selected holidays???\r
  48 if ($SUM > 0)\r
  49 {\r
  50         // Delete multiple holiday requests (for list_holiday)\r
  51         $cnt = 0;\r
  52         foreach ($_POST['sel'] as $id=>$sel)\r
  53         {\r
  54                 // Get the userid\r
  55                 $result = SQL_QUERY_ESC("SELECT userid, holiday_start, holiday_end\r
  56 FROM "._MYSQL_PREFIX."_user_holidays\r
  57 WHERE id=%d LIMIT 1", array(bigintval($id)), __FILE__, __LINE__);\r
  58                 if (SQL_NUMROWS($result) == 1)\r
  59                 {\r
  60                         // Load data and free memory\r
  61                         list($uid, $start, $end) = SQL_FETCHROW($result);\r
  62                         SQL_FREERESULT($result);\r
  63 \r
  64                         // Update user's account\r
  65                         $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data\r
  66 SET holiday_active='N', holiday_activated='0'\r
  67 WHERE userid=%d LIMIT 1", array(bigintval($uid)), __FILE__, __LINE__);\r
  68 \r
  69                         // Remove holiday\r
  70                         $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_holidays\r
  71 WHERE id=%d LIMIT 1", array(bigintval($id)), __FILE__, __LINE__);\r
  72 \r
  73                         // Prepare loaded data for the\r
  74                         $content = array(\r
  75                                 'start' => MAKE_DATETIME($start, "3"),\r
  76                                 'end'   => MAKE_DATETIME($end  , "3")\r
  77                         );\r
  78 \r
  79                         // Send email to user\r
  80                         $msg = LOAD_EMAIL_TEMPLATE("member_holiday_removed", $content, $uid);\r
  81                         SEND_EMAIL($uid, HOLIDAY_ADMIN_REMOVED_SUBJ, $msg);\r
  82                         $cnt++;\r
  83                 }\r
  84         }\r
  85         LOAD_TEMPLATE("admin_settings_saved", false, HOLIDAY_ADMIN_MULTI_DEL_1.$cnt.HOLIDAY_ADMIN_MULTI_DEL_2);\r
  86 }\r
  87  elseif (!empty($_GET['u_id']))\r
  88 {\r
  89         // Set default message\r
  90         $MSG = HOLIDAY_ADMIN_SINGLE_404;\r
  91 \r
  92         // Fetch data\r
  93         $result_load = SQL_QUERY_ESC("SELECT holiday_start AS start, holiday_end AS end\r
  94 FROM "._MYSQL_PREFIX."_user_holidays\r
  95 WHERE userid=%d LIMIT 1", array(bigintval($_GET['u_id'])), __FILE__, __LINE__);\r
  96         if (SQL_NUMROWS($result_load) == 1)\r
  97         {\r
  98                 // Load data\r
  99                 $content = SQL_FETCHARRAY($result_load);\r
 100 \r
 101                 // Free some memory\r
 102                 unset($content[0]);\r
 103                 unset($content[1]);\r
 104 \r
 105                 // Delete one holiday request (for task)\r
 106                 $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_holidays\r
 107 WHERE userid=%d LIMIT 1", array(bigintval($_GET['u_id'])), __FILE__, __LINE__);\r
 108 \r
 109                 // Send email to user\r
 110                 $msg = LOAD_EMAIL_TEMPLATE("member_holiday_removed", $content, $_GET['u_id']);\r
 111                 SEND_EMAIL($_GET['u_id'], HOLIDAY_ADMIN_REMOVED_SUBJ, $msg);\r
 112 \r
 113                 // Set message\r
 114                 $MSG = HOLIDAY_ADMIN_SINGLE_DELETED;\r
 115         }\r
 116 \r
 117         // Free memory\r
 118         SQL_FREERESULT($result_load);\r
 119 \r
 120         // Output message\r
 121         LOAD_TEMPLATE("admin_settings_saved", false, $MSG);\r
 122 }\r
 123  else\r
 124 {\r
 125         // Please call me over other scripts... ;)\r
 126         LOAD_TEMPLATE("admin_settings_saved", false, HOLIDAY_NO_DIRECT_CALL);\r
 127 }\r
 128 //\r
 129 ?>\r