X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-edit_sponsor.php;h=0603a9dea73d4ad691d67a53e0870fa4f447250a;hp=36f33eff6fc239976f8545849991a9c6c8ab70f0;hb=2379934be6a196a54f4155bb8e24c49b20736969;hpb=4c83f0cc7459cad9ec9c1c68963f5365155ee935 diff --git a/inc/modules/admin/what-edit_sponsor.php b/inc/modules/admin/what-edit_sponsor.php index 36f33eff6f..0603a9dea7 100644 --- a/inc/modules/admin/what-edit_sponsor.php +++ b/inc/modules/admin/what-edit_sponsor.php @@ -1,7 +1,7 @@ 0) { - // Replace german decimal comma with computer's decimal dot - $POINTS = strval(REVERT_COMMA(REQUEST_POST('points'))); - - // Add points to account - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_sponsor_data` SET points_amount=points_amount+%s WHERE id='%s' LIMIT 1", - array($POINTS, bigintval(REQUEST_GET('id'))), __FILE__, __LINE__); - - // Remember points /reason for the template - define('__POINTS' , TRANSLATE_COMMA($POINTS)); - define('__REASON' , REQUEST_POST('reason')); - - // Send email - $msg = LOAD_EMAIL_TEMPLATE("sponsor_add_points", REQUEST_POST('reason'), true); - SEND_EMAIL(__EMAIL, ADMIN_SPONSOR_ADD_POINTS, $msg); - $MSG = ADMIN_SPONSOR_POINTS_ADDED; - } else { - // No points entered to add! - $MSG = ADMIN_SPONSPOR_NO_POINTS_TO_ADD; - } - break; - - case "sub_points": // Subtract points - if (strval(REQUEST_POST('points')) > 0) { - // Replace german decimal comma with computer's decimal dot - $POINTS = strval(REVERT_COMMA(REQUEST_POST('points'))); - - // Add points to account - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_sponsor_data` SET points_used=points_used+%s WHERE id='%s' LIMIT 1", - array($POINTS, bigintval(REQUEST_GET('id'))), __FILE__, __LINE__); - - // Remember points /reason for the template - define('__POINTS' , TRANSLATE_COMMA($POINTS)); - define('__REASON' , REQUEST_POST('reason')); - - // Send email - $msg = LOAD_EMAIL_TEMPLATE("sponsor_sub_points", REQUEST_POST('reason'), true); - SEND_EMAIL(__EMAIL, ADMIN_SPONSOR_SUB_POINTS, $msg); - $MSG = ADMIN_SPONSOR_POINTS_SUBTRACTED; - } else { - // No points entered to add! - $MSG = ADMIN_SPONSPOR_NO_POINTS_TO_SUBTRACT; - } - break; - - case "edit": // Edit sponsor account - $PASS = true; - if ((REQUEST_POST('pass1') != REQUEST_POST('pass2')) || ((!REQUEST_ISSET_POST(('pass1'))) && (!REQUEST_ISSET_POST(('pass1'))))) { - // Remove passwords - REQUEST_UNSET_POST(('pass1')); - REQUEST_UNSET_POST(('pass2')); - $PASS = false; - } - - // Convert time selection - $DATA = array(); $id = "warning_interval_ye"; $skip = false; - CONVERT_SELECTIONS_TO_TIMESTAMP(REQUEST_POST_ARRAY(), $DATA, $id, $skip); - - // Save the sponsor - SPONSOR_HANDLE_SPONSOR(REQUEST_POST_ARRAY()); - - // Convert some data for the email template - REQUEST_POST('gender' , TRANSLATE_GENDER(REQUEST_POST('gender'))); - REQUEST_POST('warning_interval', CREATE_FANCY_TIME(REQUEST_POST('warning_interval'))); - - if (!$PASS) REQUEST_SET_POST('pass1', getMessage('SPONSOR_PASS_UNCHANGED')); - - // Load email template and send the mail away - $msg = LOAD_EMAIL_TEMPLATE("admin_sponsor_edit", REQUEST_POST_ARRAY(), false); - SEND_EMAIL(REQUEST_POST('email'), getMessage('ADMIN_SPONSOR_EDIT_SUBJECT'), $msg); - break; - - default: // Unknown mode - DEBUG_LOG(__FILE__, __LINE__, sprintf("Unknown mode %s detected.", REQUEST_GET('mode'))); - $MSG = sprintf(getMessage('ADMIN_SPONSOR_INVALID_MODE'), REQUEST_GET(('mode'))); - break; + switch (getRequestElement('mode')) { + case 'add_points': // Add points + if (bigintval(postRequestElement('points')) > 0) { + // Replace german decimal comma with computer's decimal dot + $points = bigintval(convertCommaToDot(postRequestElement('points'))); + + // Add points to account + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `points_amount`=`points_amount`+%s WHERE `id`=%s LIMIT 1", + array($points, bigintval(getRequestElement('id'))), __FILE__, __LINE__); + + // Remember points /reason for the template + $content['points'] = $points; + $content['reason'] = postRequestElement('reason'); + + // Send email + $message = loadEmailTemplate('sponsor_add_points', $content); + sendEmail($content['email'], '{--ADMIN_SPONSOR_ADD_POINTS_SUBJECT--}', $message); + $message = '{--ADMIN_SPONSOR_POINTS_ADDED--}'; + } else { + // No points entered to add! + $message = '{--ADMIN_SPONSOR_NO_POINTS_TO_ADD--}'; + } + break; + + case 'sub_points': // Subtract points + if (bigintval(postRequestElement('points')) > 0) { + // Replace german decimal comma with computer's decimal dot + $points = bigintval(convertCommaToDot(postRequestElement('points'))); + + // Add points to account + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `points_used`=`points_used`+%s WHERE `id`=%s LIMIT 1", + array($points, bigintval(getRequestElement('id'))), __FILE__, __LINE__); + + // Remember points /reason for the template + $content['points'] = $points; + $content['reason'] = postRequestElement('reason'); + + // Send email + $message = loadEmailTemplate('sponsor_sub_points', $content); + sendEmail($content['email'], '{--ADMIN_SPONSOR_SUB_POINTS_SUBJECT--}', $message); + $message = '{--ADMIN_SPONSOR_POINTS_SUBTRACTED--}'; + } else { + // No points entered to add! + $message = '{--ADMIN_SPONSOR_NO_POINTS_TO_SUBTRACT--}'; + } + break; + + case 'edit': // Edit sponsor account + $PASS = true; + if ((postRequestElement('pass1') != postRequestElement('pass2')) || ((!isPostRequestElementSet('pass1')) && (!isPostRequestElementSet('pass1')))) { + // Remove passwords + unsetPostRequestElement('pass1'); + unsetPostRequestElement('pass2'); + $PASS = false; + } // END - if + + // Convert time selection + $content = array(); $id = 'warning_interval_ye'; $skip = false; + convertSelectionsToEpocheTime(postRequestArray(), $content, $id, $skip); + + // Save the sponsor + handleSponsorRequest(postRequestArray()); + + // Convert some data for the email template + postRequestElement('gender' , '{%pipe,translateGender=' . postRequestElement('gender') . '%}'); + postRequestElement('warning_interval', '{%pipe,createFancyTime=' . postRequestElement('warning_interval') . '%}'); + + if ($PASS === false) setPostRequestElement('pass1', '{--SPONSOR_PASS_UNCHANGED--}'); + + // Load email template and send the mail away + $message = loadEmailTemplate('admin_sponsor_edit', postRequestArray(), false); + sendEmail(postRequestElement('email'), '{--ADMIN_SPONSOR_EDIT_SUBJECT--}', $message); + break; + + default: // Unknown mode + logDebugMessage(__FILE__, __LINE__, sprintf("Unknown mode %s detected.", getRequestElement('mode'))); + $message = '{%message,ADMIN_SPONSOR_INVALID_MODE=' . getRequestElement('mode') . '%}'; + break; } - if (!empty($MSG)) { + if (!empty($message)) { // Output message - LOAD_TEMPLATE("admin_settings_saved", false, $MSG); + displayMessage($message); } // END - if - } elseif (FILE_READABLE(sprintf("%stemplates/%s/html/admin/%s.tpl", constant('PATH'), GET_LANGUAGE(), $TPL))) { + } elseif (isFileReadable(sprintf("%stemplates/%s/html/admin/%s.tpl", getPath(), getLanguage(), $TPL))) { // Create mailto link - define('__SPONSOR_VALUE', "{!__SURNAME!} {!__FAMILY!}"); + $content['contact'] = '' . $content['surname'] . ' ' . $content['family'] . ''; // Load mode template - LOAD_TEMPLATE($TPL); + loadTemplate($TPL, false, $content); } else { - // Template not found! - LOAD_TEMPLATE("admin_settings_saved", false, sprintf(getMessage('ADMIN_SPONSOR_MODUS_TPL_404'), REQUEST_GET(('mode')))); + // Template not found + displayMessage('{%message,ADMIN_SPONSOR_MODUS_TPL_404', getRequestElement('mode') . '%}'); } } else { - // Sponsor not found! - LOAD_TEMPLATE("admin_settings_saved", false, sprintf(getMessage('ADMIN_SPONSOR_404'), bigintval(REQUEST_GET('id')))); + // Sponsor not found + displayMessage('{%message,ADMIN_SPONSOR_404=' . bigintval(getRequestElement('id')) . '%}'); } + + // Free result + SQL_FREERESULT($result_main); } else { // Not called by what-list_sponsor.php - LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_CALL_NOT_DIRECTLY')); + displayMessage('{--ADMIN_CALL_NOT_DIRECTLY--}'); } -// +// [EOF] ?>