X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fsponsor_functions.php;h=983a46b9685115caef2efbedd2e14211a494e18c;hp=ee59586f50d798230b1e80d1961af8d6f1b4672d;hb=0715fa7aa8e5e70bcf1d957fb09ae655c3896c4e;hpb=33989fa4a558317899c3e68cb51e1be552c4ce8e diff --git a/inc/libs/sponsor_functions.php b/inc/libs/sponsor_functions.php index ee59586f50..983a46b968 100644 --- a/inc/libs/sponsor_functions.php +++ b/inc/libs/sponsor_functions.php @@ -162,14 +162,14 @@ function handlSponsorRequest (&$postData, $update=false, $messageArray=array(), } // Implode all data into strings - $KEYS = implode("`, `" , $DATA['keys']); - $valueS = str_repeat("%s', '", count($DATA['values']) - 1); + $keyArray = implode("`, `" , $DATA['keys']); + $valueArray = str_repeat("%s', '", count($DATA['values']) - 1); // Generate string - $sql = "INSERT INTO `{?_MYSQL_PREFIX?}_sponsor_data` (`".$KEYS."`) VALUES ('".$valueS."%s')"; + $sql = "INSERT INTO `{?_MYSQL_PREFIX?}_sponsor_data` (`" . $keyArray . "`) VALUES ('" . $valueArray . "%s')"; // Generate message - $message = getMessageFromIndexedArray(getMessage('ADMIN_SPONSOR_ADDED'), "added", $messageArray); + $message = getMessageFromIndexedArray(getMessage('ADMIN_SPONSOR_ADDED'), 'added', $messageArray); $ret = 'added'; } elseif (($update === true) && (isAdmin())) { // Add all data as hidden data @@ -439,8 +439,7 @@ function saveSponsorData ($postData, $content) { $DATA[] = getSession('sponsorpass'); // Saving data was completed... ufff... - switch (getWhat()) - { + switch (getWhat()) { case 'account': // Change account data if ($EMAIL === true) { $message = getMessage('SPONSOR_ACCOUNT_EMAIL_CHANGED'); @@ -469,9 +468,11 @@ function saveSponsorData ($postData, $content) { $message = getMaskedMessage('SPONSOR_UNKNOWN_WHAT', getWhat()); $templ = ''; $subj = ''; break; - } + } // END - switch + // Has an entry updated? if (SQL_AFFECTEDROWS() == 1) { + // Template and subject are set? if (!empty($templ) && !empty($subj)) { // Run SQL command and check for success $result = SQL_QUERY_ESC($sql, $DATA, __FUNCTION__, __LINE__); @@ -479,7 +480,7 @@ function saveSponsorData ($postData, $content) { // Add all data to content $content['new_data'] = $postData; - // Change some data + // Translate some data if (isset($content['gender'])) $content['gender'] = translateGender($content['gender']); if (isset($content['new_data']['gender'])) $content['new_data']['gender'] = translateGender($content['new_data']['gender']); if (isset($content['receive_warnings'])) $content['new_data']['receive'] = translateYesNo($content['new_data']['receive_warnings']);