X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fguest%2Fwhat-sponsor_reg.php;h=ed4025993a1bd3e521630c88e09273fddd5d7f59;hp=35fdaeec1ecdf38055899796bcaf605f7a009f1c;hb=63f159414369b5ea19a8ca75d8cd8033c45d8341;hpb=64c8349613addc3da2242c5cd6b99d64e3fb5f8e diff --git a/inc/modules/guest/what-sponsor_reg.php b/inc/modules/guest/what-sponsor_reg.php index 35fdaeec1e..ed4025993a 100644 --- a/inc/modules/guest/what-sponsor_reg.php +++ b/inc/modules/guest/what-sponsor_reg.php @@ -1,7 +1,7 @@ 0) unsetPostRequestElement('ok'); -} + if (count($formErrors) > 0) unsetPostRequestElement('ok'); +} // END - if -if ((isFormSent()) && (count($FORM_ERRORS) == 0)) { +if ((isFormSent()) && (count($formErrors) == 0)) { // Generate message array $messageArray = array( - 'failed' => getMessage('SPONSOR_REGISTRATION_FAILED'), - 'added' => getMessage('SPONSOR_REGISTRATION_COMPLETED'), + 'failed' => '{--SPONSOR_REGISTRATION_FAILED--}', + 'added' => '{--SPONSOR_REGISTRATION_COMPLETED--}', ); // Calulate points - $result = SQL_QUERY_ESC("SELECT (`pay_rate` * `pay_min_count`) AS points, `pay_min_count` AS pay, `pay_currency` AS curr -FROM `{?_MYSQL_PREFIX?}_sponsor_paytypes` -WHERE `id`='%s' LIMIT 1", + $result = SQL_QUERY_ESC('SELECT + (`pay_rate` * `pay_min_count`) AS `points`, + `pay_min_count`, + `pay_currency` +FROM + `{?_MYSQL_PREFIX?}_sponsor_paytypes` +WHERE + `id`=%s +LIMIT 1', array(postRequestElement('pay_type')), __FILE__, __LINE__); list($points, $pay, $curr) = SQL_FETCHROW($result); @@ -218,147 +223,84 @@ WHERE `id`='%s' LIMIT 1", // Add points to array postRequestElement('points_amount', $points); postRequestElement('points_used' , '0.00000'); - postRequestElement('last_pay' , $pay); - postRequestElement('last_curr' , $curr); + postRequestElement('last_payment' , $pay); + postRequestElement('last_currency', $curr); // Register sponsor but never ever update here! - $STATUS = handlSponsorRequest(postRequestArray(), true, $messageArray, true); - - // Check the status of the registration process - switch ($STATUS) { - case 'added': // Sponsor successfully added with account status = UNCONFIRMED! - // Check for his ID number - $result = SQL_QUERY_ESC("SELECT `id`, `hash` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE `email`='%s' LIMIT 1", - array(postRequestElement('email')), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 1) { - // ID found so let's load it for the confirmation email - list($id, $hash) = SQL_FETCHROW($result); - - // Prepare data for the email template - $content['id'] = $id; - $content['hash'] = $hash; - $content['email'] = secureString(postRequestElement('email')); - $content['surname'] = secureString(postRequestElement('surname')); - $content['family'] = secureString(postRequestElement('family')); - $content['gender'] = translateGender(postRequestElement('gender')); - $content['timestamp'] = generateDateTime(time(), '0'); - $content['password'] = secureString(postRequestElement('pass1')); - - // Generate email and send it to the new sponsor - $message = loadEmailTemplate('sponsor_confirm', $hash); - sendEmail(postRequestElement('email'), getMessage('SPONSOR_PLEASE_CONFIRM_SUBJ'), $message); - - // Send mail to admin - sendAdminNotification(getMessage('ADMIN_NEW_SPONSOR'), 'admin_sponsor_reg', $hash); - - // Output message: DONE - $message = $messageArray['added']; - } else { - // Sponsor account not found??? - $message = sprintf(getMessage('SPONSOR_EMAIL_404'), postRequestElement('email')); - } - - // Free memory - SQL_FREERESULT($result); - break; - - default: - logDebugMessage(__FILE__, __LINE__, sprintf("Unknown status %s detected.", $STATUS)); - if (!isAdmin()) { - // Message for testing admin - $message = sprintf(getMessage('ADMIN_SPONSOR_UNKNOWN_STATUS'), $STATUS); - } else { - // Message for the guest - $message = sprintf(getMessage('SPONSOR_UNKNOWN_STATUS'), $STATUS); - } - break; - } + $message = doProcessSponsorFormRequest($messageArray); // Display message - loadTemplate('admin_settings_saved', false, $message); + displayMessage($message); } else { // Check for payment types - $result = SQL_QUERY("SELECT `id`, `pay_name`, `pay_rate`, `pay_currency`, `pay_min_count` -FROM `{?_MYSQL_PREFIX?}_sponsor_paytypes` -ORDER BY `pay_name`", __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) { + $result = SQL_QUERY('SELECT + `id`,`pay_name`,`pay_rate`,`pay_currency`,`pay_min_count` +FROM + `{?_MYSQL_PREFIX?}_sponsor_paytypes` +ORDER BY + `pay_name` ASC', __FILE__, __LINE__); + if (!SQL_HASZERONUMS($result)) { // Load all types... - // @TODO Swap this HTML code to templates - $OUT = "\n"; - $SW = 2; + $OUT = ''; while ($content = SQL_FETCHARRAY($result)) { // Prepare content for output - $content['sw'] = $SW; $content['res'] = translateComma($content['pay_rate'] * $content['pay_min_count']); // Load row template and switch color - $OUT .= loadTemplate('guest_sponsor_payment_row', false, $content); - $SW = 3 - $SW; - } - $OUT .= "
\n"; + $OUT .= loadTemplate('guest_sponsor_payment_row', true, $content); + } // END - while // Remember the list in table - $content['payment_list'] = $OUT; + $content['payment_list'] = loadTemplate('guest_sponsor_payment', true, $OUT); // Init a lot array elements - foreach (array('company','position','tax_ident','gender_m','gender_f','gender_c','surname','family','street_nr1','street_nr2','country','zip','city','phone','fix','cell','email','url','rec_y','rec_n','form_errors','refid') as $entry) { + foreach (array('company','position','tax_ident','gender_m','gender_f','gender_c','surname','family','street_nr1','street_nr2','country','zip','city','phone','fax','cell','email','url','receive_warnings_y','receive_warnings_n','form_errors','refid') as $entry) { $content[$entry] = ''; } // END - foreach // Check for invalid entries - if (count($FORM_ERRORS) > 0) { + if (count($formErrors) > 0) { // Some found... :-( - foreach (array('company','position','tax_ident','surname','family','street_nr1','street_nr2','country','zip','city','phone','fix','cell','email','url') as $entry) { - $content[$entry] = secureString(postRequestElement($entry)); + foreach (array('company','position','tax_ident','surname','family','street_nr1','street_nr2','country','zip','city','phone','fax','cell','email','url') as $entry) { + $content[$entry] = postRequestElement($entry); } // END - foreach - // Init gender - foreach (array('m', 'f', 'c') as $gender) { - $content['gender_' . $gender] = ''; - } // END - foreach - - // Check for gender selection - $content['gender_' . strtolower(postRequestElement('gender'))] = ' selected="selected"'; - // Init receive selection - $content['rec_y'] = ''; - $content['rec_n'] = ''; + $content['receive_warnings_y'] = ''; + $content['receive_warnings_n'] = ''; // Check for receive_warnings - $content['rec_' . strtolower(postRequestElement('receive_warnings'))] = ' selected="selected"'; + $content['receive_warnings_' . strtolower(postRequestElement('receive_warnings'))] = ' selected="selected"'; $OUT = ''; // Errors found? - if (count($FORM_ERRORS) > 0) { - $OUT = "
-
".getMessage('SPONSOR_REGISTER_SOMETHING_MISSING').":

-
-
    \n"; - foreach ($FORM_ERRORS as $error) { - $OUT .= "
  1. ".$error."
  2. \n"; + if (count($formErrors) > 0) { + $OUT = displayMessage('{--SPONSOR_REGISTER_SOMETHING_MISSING--}', true); + $OUT .= '
      '; + foreach ($formErrors as $error) { + $OUT .= '
    1. ' . $error . '
    2. '; } // END - foreach - $OUT .= "

    \n"; + $OUT .= '
'; } // END - if $content['form_errors'] = $OUT; - $content['refid'] = bigintval(postRequestElement('refid')); - } // END - if - // Prepare referal things - if (isGetRequestElementSet('refid')) { - // Referal ID transmitted, we don't care here if it is right or not - $content['refid'] = bigintval(getRequestElement('refid')); - } else { - // No referal link - $content['refid'] = '0'; - } + // @TODO Maybe a default referral id? + $content['refid'] = 0; + + // Is the referral id valid? + if ((isPostRequestElementSet('refid')) && (isValidUserId(postRequestElement('refid')))) { + // Transfer referral id + $content['refid'] = bigintval(postRequestElement('refid')); + } // END - if + } // END - if // Display registration form loadTemplate('guest_sponsor_reg', false, $content); } else { // Nothing added so far - loadTemplate('admin_settings_saved', false, getMessage('SPONSOR_PAYMENT_LIST_IS_EMPTY')); + displayMessage('{--SPONSOR_PAYMENT_LIST_EMPTY--}'); } // Free memory