X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-del_holiday.php;h=d968f7d6f8f38527cfa64853d59093ec51f5a402;hb=c1671a3b6c02326b471916a28f4177c453871f51;hp=7435c85ec3c830e3cd59a2a15c618eba1b209364;hpb=1ebf518b9552f71ee95de6f4b80e6de3a27716d1;p=mailer.git

diff --git a/inc/modules/admin/what-del_holiday.php b/inc/modules/admin/what-del_holiday.php
index 7435c85ec3..d968f7d6f8 100644
--- a/inc/modules/admin/what-del_holiday.php
+++ b/inc/modules/admin/what-del_holiday.php
@@ -1,6 +1,6 @@
 <?php
 /************************************************************************
- * MXChange v0.2.1                                    Start: 07/24/2004 *
+ * Mailer v0.2.1-FINAL                                Start: 07/24/2004 *
  * ================                             Last change: 08/09/2004 *
  *                                                                      *
  * -------------------------------------------------------------------- *
@@ -44,19 +44,19 @@ if ((!defined('__SECURITY')) || (!isAdmin())) {
 // Add description as navigation point
 addMenuDescription('admin', __FILE__);
 
-// Check for selected holidays
-$SUM = 0;
-if (isPostRequestElementSet('sel')) $SUM = countPostSelection();
-
 // Shall I delete selected holidays???
-if ($SUM > 0) {
+if (countPostSelection() > 0) {
 	// Delete multiple holiday requests (for list_holiday)
-	$cnt = 0;
+	$cnt = '0';
 	foreach (postRequestElement('sel') as $id => $sel) {
 		// Get the userid
-		$result = SQL_QUERY_ESC("SELECT userid, holiday_start, holiday_end
-FROM `{?_MYSQL_PREFIX?}_user_holidays`
-WHERE `id`=%s LIMIT 1", array(bigintval($id)), __FILE__, __LINE__);
+		$result = SQL_QUERY_ESC("SELECT
+	`userid`, `holiday_start`, `holiday_end`
+FROM
+	`{?_MYSQL_PREFIX?}_user_holidays`
+WHERE
+	`id`=%s
+LIMIT 1", array(bigintval($id)), __FILE__, __LINE__);
 		if (SQL_NUMROWS($result) == 1) {
 			// Load data and free memory
 			list($userid, $start, $end) = SQL_FETCHROW($result);
@@ -64,17 +64,24 @@ WHERE `id`=%s LIMIT 1", array(bigintval($id)), __FILE__, __LINE__);
 
 			// Update user's account
 			SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data`
-SET `holiday_active`='N', holiday_activated='0'
-WHERE `userid`=%s LIMIT 1", array(bigintval($userid)), __FILE__, __LINE__);
+SET
+	`holiday_active`='N',
+	`holiday_activated`=0
+WHERE
+	`userid`=%s
+LIMIT 1", array(bigintval($userid)), __FILE__, __LINE__);
 
 			// Remove holiday
-			SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_holidays`
-WHERE `id`=%s LIMIT 1", array(bigintval($id)), __FILE__, __LINE__);
+			SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM
+	`{?_MYSQL_PREFIX?}_user_holidays`
+WHERE
+	`id`=%s
+LIMIT 1", array(bigintval($id)), __FILE__, __LINE__);
 
 			// Prepare loaded data for the
 			$content = array(
-				'start' => generateDateTime($start, '3'),
-				'end'   => generateDateTime($end  , '3')
+				'start' => generateDateTime($start, 3),
+				'end'   => generateDateTime($end  , 3)
 			);
 
 			// Send email to user
@@ -126,5 +133,5 @@ LIMIT 1", array(bigintval(getRequestElement('userid'))), __FILE__, __LINE__);
 	loadTemplate('admin_settings_saved', false, getMessage('HOLIDAY_NO_DIRECT_CALL'));
 }
 
-//
+// [EOF]
 ?>