Installation improved, first login:

[mailer.git] / inc / modules / admin / what-del_holiday.php

diff --git a/inc/modules/admin/what-del_holiday.php b/inc/modules/admin/what-del_holiday.php
index 7435c85ec3c830e3cd59a2a15c618eba1b209364..ab80774af057e67f541758f86c2ebfd0a40a01ab 100644 (file)
--- a/inc/modules/admin/what-del_holiday.php
+++ b/inc/modules/admin/what-del_holiday.php
@@ -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]
 ?>