X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-edit_sponsor.php;h=64b052ff662f09f0f9c184c3c3c5cf8da517f7e7;hb=f8da178ba4b2f0ed9bfd303d6d32f62b0919a442;hp=747d4728a58412ea065d18dca6cf4059eae61488;hpb=a6301e2f3288f3501dd04ccac8ac06711e727850;p=mailer.git diff --git a/inc/modules/admin/what-edit_sponsor.php b/inc/modules/admin/what-edit_sponsor.php index 747d4728a5..64b052ff66 100644 --- a/inc/modules/admin/what-edit_sponsor.php +++ b/inc/modules/admin/what-edit_sponsor.php @@ -48,7 +48,7 @@ ADD_DESCR('admin', __FILE__); if ((REQUEST_ISSET_GET('id')) && (REQUEST_ISSET_GET(('mode')))) { // Check for selected sponsor $result = SQL_QUERY_ESC("SELECT company, position, gender, surname, family, street_nr1, street_nr2, zip, city, country, phone, fax, cell, email, url, tax_ident, receive_warnings, warning_interval FROM `{!_MYSQL_PREFIX!}_sponsor_data` WHERE `id`='%s' LIMIT 1", - array(bigintval(REQUEST_GET('id'))), __FILE__, __LINE__); + array(bigintval(REQUEST_GET('id'))), __FILE__, __LINE__); if (SQL_NUMROWS($result) == 1) { // Load sponsor details $DATA = SQL_FETCHARRAY($result); @@ -64,23 +64,23 @@ if ((REQUEST_ISSET_GET('id')) && (REQUEST_ISSET_GET(('mode')))) { // Personal data switch ($DATA['gender']) { - case "M": - define('__GENDER_M', ' selected="selected"'); - define('__GENDER_F', ''); - define('__GENDER_C', ''); - break; - - case "F": - define('__GENDER_M', ''); - define('__GENDER_F', ' selected="selected"'); - define('__GENDER_C', ''); - break; - - case "C": - define('__GENDER_M', ''); - define('__GENDER_F', ''); - define('__GENDER_C', ' selected="selected"'); - break; + case "M": + define('__GENDER_M', ' selected="selected"'); + define('__GENDER_F', ''); + define('__GENDER_C', ''); + break; + + case "F": + define('__GENDER_M', ''); + define('__GENDER_F', ' selected="selected"'); + define('__GENDER_C', ''); + break; + + case "C": + define('__GENDER_M', ''); + define('__GENDER_F', ''); + define('__GENDER_C', ' selected="selected"'); + break; } define('__SURNAME' , $DATA['surname']); define('__FAMILY' , $DATA['family']); @@ -108,83 +108,83 @@ if ((REQUEST_ISSET_GET('id')) && (REQUEST_ISSET_GET(('mode')))) { // Perform action on mode switch (REQUEST_GET('mode')) { - case "add_points": // Add points - if (strval(REQUEST_POST('points')) > 0) { - // Replace german decimal comma with computer's decimal dot - $POINTS = strval(convertCommaToDot(REQUEST_POST('points'))); + case "add_points": // Add points + if (strval(REQUEST_POST('points')) > 0) { + // Replace german decimal comma with computer's decimal dot + $POINTS = strval(convertCommaToDot(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", + // 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' , translateComma($POINTS)); - define('__REASON' , REQUEST_POST('reason')); - - // Send email - $msg = LOAD_EMAIL_TEMPLATE("sponsor_add_points", REQUEST_POST('reason'), true); - sendEmail(__EMAIL, ADMIN_SPONSOR_ADD_POINTS_SUBJ, $msg); - $message = ADMIN_SPONSOR_POINTS_ADDED; - } else { - // No points entered to add! - $message = 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(convertCommaToDot(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", + // Remember points /reason for the template + define('__POINTS' , translateComma($POINTS)); + define('__REASON' , REQUEST_POST('reason')); + + // Send email + $msg = LOAD_EMAIL_TEMPLATE("sponsor_add_points", REQUEST_POST('reason'), true); + sendEmail(__EMAIL, ADMIN_SPONSOR_ADD_POINTS_SUBJ, $msg); + $message = ADMIN_SPONSOR_POINTS_ADDED; + } else { + // No points entered to add! + $message = 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(convertCommaToDot(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' , translateComma($POINTS)); - define('__REASON' , REQUEST_POST('reason')); - - // Send email - $msg = LOAD_EMAIL_TEMPLATE("sponsor_sub_points", REQUEST_POST('reason'), true); - sendEmail(__EMAIL, ADMIN_SPONSOR_SUB_POINTS_SUBJ, $msg); - $message = ADMIN_SPONSOR_POINTS_SUBTRACTED; - } else { - // No points entered to add! - $message = 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; - convertSelectionsToTimestamp(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' , translateGender(REQUEST_POST('gender'))); - REQUEST_POST('warning_interval', createFancyTime(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); - sendEmail(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'))); - $message = sprintf(getMessage('ADMIN_SPONSOR_INVALID_MODE'), REQUEST_GET(('mode'))); - break; + // Remember points /reason for the template + define('__POINTS' , translateComma($POINTS)); + define('__REASON' , REQUEST_POST('reason')); + + // Send email + $msg = LOAD_EMAIL_TEMPLATE("sponsor_sub_points", REQUEST_POST('reason'), true); + sendEmail(__EMAIL, ADMIN_SPONSOR_SUB_POINTS_SUBJ, $msg); + $message = ADMIN_SPONSOR_POINTS_SUBTRACTED; + } else { + // No points entered to add! + $message = 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; + convertSelectionsToTimestamp(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' , translateGender(REQUEST_POST('gender'))); + REQUEST_POST('warning_interval', createFancyTime(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); + sendEmail(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'))); + $message = sprintf(getMessage('ADMIN_SPONSOR_INVALID_MODE'), REQUEST_GET(('mode'))); + break; } if (!empty($message)) {