X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-holiday.php;h=ec4fae0ba8e477dad99b2e16f48f69f744eccb6e;hp=02816336897a01d5568e82c93048c02eb8d13920;hb=2df9f7a53f8b1dd5164f87824a324ccb3b6634cb;hpb=63f159414369b5ea19a8ca75d8cd8033c45d8341

diff --git a/inc/modules/member/what-holiday.php b/inc/modules/member/what-holiday.php
index 0281633689..ec4fae0ba8 100644
--- a/inc/modules/member/what-holiday.php
+++ b/inc/modules/member/what-holiday.php
@@ -119,7 +119,7 @@ if (isFormSent()) {
 		unsetPostRequestElement('ok');
 	} else {
 		// Everything went okay so let's store his request and send mails
-		SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_holidays` (`userid`,`holiday_start`,`holiday_end`,`comments`) VALUES ('%s','%s','%s','%s')",
+		SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_holidays` (`userid`, `holiday_start`, `holiday_end`, `comments`) VALUES ('%s','%s','%s','%s')",
 			array(getMemberId(), $START, $content['holiday_end'], postRequestElement('comments')), __FILE__, __LINE__);
 
 		// Activate holiday system
@@ -161,14 +161,15 @@ LIMIT 1",
 if (isPostRequestElementSet('stop')) {
 	// Okay, end the holiday here...
 	$result = SQL_QUERY_ESC("SELECT
-	`holiday_active`,`holiday_activated`
+	`holiday_active`,
+	`holiday_activated`
 FROM
 	`{?_MYSQL_PREFIX?}_user_data`
 WHERE
 	`userid`=%s
 LIMIT 1", array(getMemberId()), __FILE__, __LINE__);
 
-	// Do we have an entry?
+	// Is there an entry?
 	if (SQL_NUMROWS($result) == 1) {
 		// Merge arrays
 		$content = merge_array($content, SQL_FETCHARRAY($result));
@@ -176,7 +177,8 @@ LIMIT 1", array(getMemberId()), __FILE__, __LINE__);
 		if (($content['holiday_active'] == 'Y') && (($content['holiday_activated'] + getConfig('holiday_lock')) < time())) {
 			// Load data
 			$result2 = SQL_QUERY_ESC("SELECT
-	`holiday_start`,`holiday_end`
+	`holiday_start`,
+	`holiday_end`
 FROM
 	`{?_MYSQL_PREFIX?}_user_holidays`
 WHERE
@@ -191,7 +193,8 @@ LIMIT 1", array(getMemberId()), __FILE__, __LINE__);
 				$content['end']   = generateDateTime($content['holiday_end']  , 3);
 
 				// Deactivate it now
-				SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data`
+				SQL_QUERY_ESC("UPDATE
+	`{?_MYSQL_PREFIX?}_user_data`
 SET
 	`holiday_active`='N',
 	`holiday_activated`=0
@@ -237,7 +240,8 @@ LIMIT 1",
 if ((!isFormSent()) && (!isPostRequestElementSet('stop'))) {
 	// Check if user is in holiday...
 	$result = SQL_QUERY_ESC("SELECT
-	`holiday_active`,`holiday_activated`
+	`holiday_active`,
+	`holiday_activated`
 FROM
 	`{?_MYSQL_PREFIX?}_user_data`
 WHERE
@@ -253,7 +257,8 @@ LIMIT 1", array(getMemberId()), __FILE__, __LINE__);
 			case 'Y': // Display deactivation form
 				// Load starting and ending date
 				$result = SQL_QUERY_ESC("SELECT
-	`holiday_start`,`holiday_end`
+	`holiday_start`,
+	`holiday_end`
 FROM
 	`{?_MYSQL_PREFIX?}_user_holidays`
 WHERE