unsetPostRequestParameter('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'], postRequestParameter('comments')), __FILE__, __LINE__);
// Activate holiday system
if (isPostRequestParameterSet('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
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
if ((!isFormSent()) && (!isPostRequestParameterSet('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
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