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
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));
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
$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
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
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