* $Author:: $ *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * Copyright (c) 2009 - 2011 by Mailer Developer Team *
- * For more information visit: http://www.mxchange.org *
+ * Copyright (c) 2009 - 2012 by Mailer Developer Team *
+ * For more information visit: http://mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
// Some security stuff...
if (!defined('__SECURITY')) {
- die();
+ exit();
} elseif (!isMember()) {
redirectToIndexMemberOnlyModule();
}
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
SQL_QUERY_ESC("UPDATE
`{?_MYSQL_PREFIX?}_user_data`
SET
- `holiday_active`='N', `holiday_activated`=UNIX_TIMESTAMP()
+ `holiday_active`='N',
+ `holiday_activated`=UNIX_TIMESTAMP()
WHERE
`userid`=%s
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));
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