X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-holiday.php;h=b233e861a4523a6cb18a55599600a0d3b7cd907d;hb=f42e417c1cd63d07563965c54bf10f6e1cd4248f;hp=11f17185ff880fc79bb6666a71077a1ecc989b1b;hpb=d1637dad0b2ca0e5fb411ee0843f01bfb4cc94e0;p=mailer.git diff --git a/inc/modules/member/what-holiday.php b/inc/modules/member/what-holiday.php index 11f17185ff..b233e861a4 100644 --- a/inc/modules/member/what-holiday.php +++ b/inc/modules/member/what-holiday.php @@ -17,7 +17,7 @@ * Needs to be in all Files and every File needs "svn propset * * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * - * Copyright (c) 2003 - 2008 by Roland Haeder * + * Copyright (c) 2003 - 2009 by Roland Haeder * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -38,26 +38,27 @@ // Some security stuff... if (!defined('__SECURITY')) { - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php'; - require($INC); -} elseif (!IS_MEMBER()) { - redirectToUrl('modules.php?module=index'); -} elseif ((!EXT_IS_ACTIVE('holiday')) && (!IS_ADMIN())) { - addFatalMessage(__FILE__, __LINE__, generateExtensionInactiveNotInstalledMessage('holiday')); - return; + die(); +} elseif (!isMember()) { + redirectToIndexMemberOnlyModule(); } +// Add description as navigation point +addMenuDescription('member', __FILE__); + +if ((!isExtensionActive('holiday')) && (!isAdmin())) { + loadTemplate('admin_settings_saved', false, generateExtensionInactiveNotInstalledMessage('holiday')); + return; +} // END - if + // Init content array $content = array(); -// Add description as navigation point -ADD_DESCR('member', __FILE__); - // Check for running mail orders in pool $result1 = SQL_QUERY_ESC("SELECT `timestamp` FROM - `{!_MYSQL_PREFIX!}_pool` + `{?_MYSQL_PREFIX?}_pool` WHERE `sender`=%s ORDER BY @@ -68,7 +69,7 @@ LIMIT 1", array(getUserId()), __FILE__, __LINE__); $result2 = SQL_QUERY_ESC("SELECT `timestamp_ordered` FROM - `{!_MYSQL_PREFIX!}_user_stats` + `{?_MYSQL_PREFIX?}_user_stats` WHERE `userid`=%s ORDER BY @@ -86,8 +87,8 @@ if ((SQL_NUMROWS($result1) == 1) || (SQL_NUMROWS($result2) == 1)) { if ((($content['timestamp'] + getConfig('holiday_lock')) > time()) || (($content['timestamp_ordered'] + getConfig('holiday_lock')) > time())) { // Mail order is to close away! - REQUEST_UNSET_POST('ok'); - REQUEST_UNSET_POST('stop'); + unsetPostRequestElement('ok'); + unsetPostRequestElement('stop'); if (($content['timestamp'] + getConfig('holiday_lock')) > time()) { // Mail found in pool @@ -98,7 +99,7 @@ if ((SQL_NUMROWS($result1) == 1) || (SQL_NUMROWS($result2) == 1)) { } // Display message and exit here - LOAD_TEMPLATE('admin_settings_saved', false, sprintf(getMessage('HOLIDAY_MEMBER_ORDER'), generateDateTime($stamp, '1'))); + loadTemplate('admin_settings_saved', false, sprintf(getMessage('HOLIDAY_MEMBER_ORDER'), generateDateTime($stamp, '1'))); return; } } // END - if @@ -109,22 +110,22 @@ SQL_FREERESULT($result2); if (isFormSent()) { // Check holiday request... - $START = mktime(0, 0, 0, REQUEST_POST('start_month'), REQUEST_POST('start_day'), REQUEST_POST('start_year')); - $content['holiday_end'] = mktime(0, 0, 0, REQUEST_POST('end_month') , REQUEST_POST('end_day') , REQUEST_POST('end_year') ); + $START = mktime(0, 0, 0, postRequestElement('start_month'), postRequestElement('start_day'), postRequestElement('start_year')); + $content['holiday_end'] = mktime(0, 0, 0, postRequestElement('end_month') , postRequestElement('end_day') , postRequestElement('end_year') ); // Test both values $TEST = $content['holiday_end'] - $START; - if (($TEST < 0) || ($TEST > (getConfig('one_day') * getConfig('holiday_max'))) || ($START < time()) || ($content['holiday_end'] < time())) { + if (($TEST < 0) || ($TEST > (getConfig('ONE_DAY') * getConfig('holiday_max'))) || ($START < time()) || ($content['holiday_end'] < time())) { // Time test failed - REQUEST_UNSET_POST('ok'); + 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')", - array(getUserId(), $START, $content['holiday_end'], REQUEST_POST('comments')), __FILE__, __LINE__); + SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_holidays` (`userid`, `holiday_start`, `holiday_end`, `comments`) VALUES ('%s','%s','%s','%s')", + array(getUserId(), $START, $content['holiday_end'], postRequestElement('comments')), __FILE__, __LINE__); // Activate holiday system SQL_QUERY_ESC("UPDATE - `{!_MYSQL_PREFIX!}_user_data` + `{?_MYSQL_PREFIX?}_user_data` SET `holiday_active`='N', `holiday_activated`=UNIX_TIMESTAMP() WHERE @@ -133,35 +134,36 @@ LIMIT 1", array(getUserId()), __FILE__, __LINE__); // Prepare constants - define('_START_DAY' , REQUEST_POST('start_day')); - define('_START_MONTH', $GLOBALS['month_descr'][REQUEST_POST('start_month')]); - define('_START_YEAR' , REQUEST_POST('start_year')); - define('_END_DAY' , REQUEST_POST('end_day')); - define('_END_MONTH' , $GLOBALS['month_descr'][REQUEST_POST('end_month')]); - define('_END_YEAR' , REQUEST_POST('end_year')); + $content['start_day'] = bigintval(postRequestElement('start_day')); + $content['start_month'] = $GLOBALS['month_descr'][postRequestElement('start_month')]; + $content['start_year'] = bigintval(postRequestElement('start_year')); + $content['end_day'] = bigintval(postRequestElement('end_day')); + $content['end_month'] = $GLOBALS['month_descr'][postRequestElement('end_month')]; + $content['end_year'] = bigintval(postRequestElement('end_year')); + $content['comments'] = secureString(postRequestElement('comments')); // Send mail to member - $message = LOAD_EMAIL_TEMPLATE('member_holiday_request', REQUEST_POST('comments'), getUserId()); + $message = loadEmailTemplate('member_holiday_request', $content, getUserId()); sendEmail(getUserId(), getMessage('HOLIDAY_MEMBER_SUBJECT'), $message); // Send mail to all admins - sendAdminNotification(getMessage('HOLIDAY_ADMIN_SUBJECT'), 'admin_holiday_request', REQUEST_POST('comments'), getUserId()); + sendAdminNotification(getMessage('HOLIDAY_ADMIN_SUBJECT'), 'admin_holiday_request', $content, getUserId()); // Create task createNewTask('{--HOLIDAY_ADMIN_SUBJECT--}', $message, 'HOLIDAY_REQUEST', getUserId()); // Display message - LOAD_TEMPLATE('admin_settings_saved', false, getMessage('HOLIDAY_IS_ACTIVATED_NOW')); + loadTemplate('admin_settings_saved', false, getMessage('HOLIDAY_IS_ACTIVATED_NOW')); } } // END - if // Holiday shall be ended now -if (REQUEST_ISSET_POST('stop')) { +if (isPostRequestElementSet('stop')) { // Okay, end the holiday here... $result = SQL_QUERY_ESC("SELECT `holiday_active`, `holiday_activated` FROM - `{!_MYSQL_PREFIX!}_user_data` + `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s LIMIT 1", array(getUserId()), __FILE__, __LINE__); @@ -173,7 +175,7 @@ LIMIT 1", array(getUserId()), __FILE__, __LINE__); $result = SQL_QUERY_ESC("SELECT `holiday_start`, `holiday_end` FROM - `{!_MYSQL_PREFIX!}_user_holidays` + `{?_MYSQL_PREFIX?}_user_holidays` WHERE `userid`=%s LIMIT 1", array(getUserId()), __FILE__, __LINE__); @@ -183,47 +185,49 @@ LIMIT 1", array(getUserId()), __FILE__, __LINE__); SQL_FREERESULT($result); // Prepare it for the template - define('__HOLIDAY_START', generateDateTime($content['holiday_start'], '3')); - define('__HOLIDAY_END' , generateDateTime($content['holiday_end'] , '3')); + $content['start'] = generateDateTime($content['holiday_start'], '3'); + $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 WHERE `userid`=%s -LIMIT 1", array(getUserId()), __FILE__, __LINE__); +LIMIT 1", + array(getUserId()), __FILE__, __LINE__); // Remove entry SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM - `{!_MYSQL_PREFIX!}_user_holidays` + `{?_MYSQL_PREFIX?}_user_holidays` WHERE `userid`=%s -LIMIT 1", array(getUserId()), __FILE__, __LINE__); +LIMIT 1", + array(getUserId()), __FILE__, __LINE__); // Send email to admin - sendAdminNotification(getMessage('HOLIDAY_ADMIN_DEAC_SUBJ'), 'admin_holiday_deactivated', array(), getUserId()); + sendAdminNotification(getMessage('HOLIDAY_ADMIN_DEAC_SUBJ'), 'admin_holiday_deactivated', $content, getUserId()); // Display message to user - LOAD_TEMPLATE('admin_settings_saved', false, getMessage('HOLIDAY_MEMBER_DEACTIVATED_NOW')); + loadTemplate('admin_settings_saved', false, getMessage('HOLIDAY_MEMBER_DEACTIVATED_NOW')); } else { // Display message to user - LOAD_TEMPLATE('admin_settings_saved', false, getMessage('HOLIDAY_MEMBER_CANNOT_DEACTIVATE')); + loadTemplate('admin_settings_saved', false, getMessage('HOLIDAY_MEMBER_CANNOT_DEACTIVATE')); } } elseif ($content['holiday_active'] == 'Y') { // To fast! - LOAD_TEMPLATE('admin_settings_saved', false, getMessage('HOLIDAY_MEMBER_LOCKED')); + loadTemplate('admin_settings_saved', false, getMessage('HOLIDAY_MEMBER_LOCKED')); } } // END - if // If something is wrong or link in menu is just clicked display form -if ((!isFormSent()) && (!REQUEST_ISSET_POST('stop'))) { +if ((!isFormSent()) && (!isPostRequestElementSet('stop'))) { // Check if user is in holiday... $result = SQL_QUERY_ESC("SELECT `holiday_active`, `holiday_activated` FROM - `{!_MYSQL_PREFIX!}_user_data` + `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s LIMIT 1", array(getUserId()), __FILE__, __LINE__); @@ -240,7 +244,7 @@ LIMIT 1", array(getUserId()), __FILE__, __LINE__); $result = SQL_QUERY_ESC("SELECT `holiday_start`, `holiday_end` FROM - `{!_MYSQL_PREFIX!}_user_holidays` + `{?_MYSQL_PREFIX?}_user_holidays` WHERE `userid`=%s LIMIT 1", array(getUserId()), __FILE__, __LINE__); @@ -250,19 +254,19 @@ LIMIT 1", array(getUserId()), __FILE__, __LINE__); SQL_FREERESULT($result); // Prepare it for the template - define('__HOLIDAY_START', generateDateTime($content['holiday_start'] , '3')); - define('__HOLIDAY_END' , generateDateTime($content['holiday_end'] , '3')); - define('__HOLIDAY_LOCK' , generateDateTime($content['holiday_activated'], '1')); + $content['start'] = generateDateTime($content['holiday_start'] , '3'); + $content['end'] = generateDateTime($content['holiday_end'] , '3'); + $content['lock'] = generateDateTime($content['holiday_activated'], '1'); // Load template - LOAD_TEMPLATE('member_holiday_deactivate'); + loadTemplate('member_holiday_deactivate', false, $content); } else { // Free memory SQL_FREERESULT($result); // Remove entry and reload URL SQL_QUERY_ESC("UPDATE - `{!_MYSQL_PREFIX!}_user_data` + `{?_MYSQL_PREFIX?}_user_data` SET `holiday_active`='N' WHERE @@ -275,30 +279,27 @@ LIMIT 1", array(getUserId()), __FILE__, __LINE__); case 'N': // Display activation form // Starting day - define('_START_DAY' , ADD_SELECTION('day' , date('d', (time() + getConfig('one_day'))), 'start')); - define('_START_MONTH', ADD_SELECTION('month', date('m', (time() + getConfig('one_day'))), 'start')); - define('_START_YEAR' , ADD_SELECTION('year' , date('Y', (time() + getConfig('one_day'))), 'start')); + $content['start_day'] = addSelectionBox('day' , date('d', (time() + getConfig('ONE_DAY'))), 'start'); + $content['start_month'] = addSelectionBox('month', date('m', (time() + getConfig('ONE_DAY'))), 'start'); + $content['start_year'] = addSelectionBox('year' , date('Y', (time() + getConfig('ONE_DAY'))), 'start'); // Calcualte ending date - $D = date('d', time() + getConfig('one_day') + (getConfig('one_day') * getConfig('holiday_max'))); - $M = date('m', time() + getConfig('one_day') + (getConfig('one_day') * getConfig('holiday_max'))); - $Y = date('Y', time() + getConfig('one_day') + (getConfig('one_day') * getConfig('holiday_max'))); + $D = date('d', time() + getConfig('ONE_DAY') + (getConfig('ONE_DAY') * getConfig('holiday_max'))); + $M = date('m', time() + getConfig('ONE_DAY') + (getConfig('ONE_DAY') * getConfig('holiday_max'))); + $Y = date('Y', time() + getConfig('ONE_DAY') + (getConfig('ONE_DAY') * getConfig('holiday_max'))); // Ending day - define('_END_DAY' , ADD_SELECTION('day' , $D, 'end')); - define('_END_MONTH', ADD_SELECTION('month', $M, 'end')); - define('_END_YEAR' , ADD_SELECTION('year' , $Y, 'end')); - - // Copy value from configuration - define('__HOLIDAY_MAX', getConfig('holiday_max')); + $content['end_day'] = addSelectionBox('day' , $D, 'end'); + $content['end_month'] = addSelectionBox('month', $M, 'end'); + $content['end_year'] = addSelectionBox('year' , $Y, 'end'); // Output form - LOAD_TEMPLATE('member_holiday_form'); + loadTemplate('member_holiday_form'); break; } } else { // To fast! - LOAD_TEMPLATE('admin_settings_saved', false, getMessage('HOLIDAY_MEMBER_LOCKED')); + loadTemplate('admin_settings_saved', false, getMessage('HOLIDAY_MEMBER_LOCKED')); } } // END - if