Member ref-link page swapped out to templates (#68)

[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 ab27f4813bcb71b7da77a10dc4d63d2b961999e4..d46a98c78744b257026d50c2617e789d2e92d2d8 100644 (file)
--- a/inc/modules/admin/what-del_holiday.php
+++ b/inc/modules/admin/what-del_holiday.php
@@ -54,9 +54,13 @@ if ($SUM > 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,12 +68,19 @@ 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(
@@ -126,5 +137,5 @@ LIMIT 1", array(bigintval(getRequestElement('userid'))), __FILE__, __LINE__);
        loadTemplate('admin_settings_saved', false, getMessage('HOLIDAY_NO_DIRECT_CALL'));
 }
 
-//
+// [EOF]
 ?>