- $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;
- }