- $STATUS = SPONSOR_HANDLE_SPONSOR($_POST, true, $MSGs, 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($_POST['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
- define('__ID' , $id);
- define('__HASH' , $hash);
- define('__EMAIL' , $_POST['email']);
- define('__SURNAME' , $_POST['surname']);
- define('__FAMILY' , $_POST['family']);
- define('__SALUT' , TRANSLATE_SEX($_POST['salut']));
- define('__TIMESTAMP', MAKE_DATETIME(time(), 0));
- define('__PASSWORD' , $_POST['pass1']);
-
- // Generate email and send it to the new sponsor
- $EMAIL_MSG = LOAD_EMAIL_TEMPLATE("sponsor_confirm", $hash);
- SEND_EMAIL($_POST['email'], SPONSOR_PLEASE_CONFIRM_SUBJ, $EMAIL_MSG);
-
- // Send mail to admin
- SEND_ADMIN_NOTIFICATION(ADMIN_NEW_SPONSOR, "admin_sponsor_reg", $hash);
-
- // Output message: DONE
- $MSG = $MSGs['added'];
- }
- else
- {
- // Sponsor account not found???
- $MSG = SPONSOR_EMAIL_404_1.$_POST['email'].SPONSOR_EMAIL_404_2;
- }
-
- // Free memory
- SQL_FREERESULT($result);
- break;
-
- default:
- if (!IS_ADMIN())
- {
- // Message for testing admin
- $MSG = ADMIN_SPONSOR_UNKOWN_STATUS_1.$STATUS.ADMIN_SPONSOR_UNKOWN_STATUS_2;
- }
- else
- {
- // Message for the guest
- $MSG = SPONSOR_UNKOWN_STATUS_1.$STATUS.SPONSOR_UNKOWN_STATUS_2;
- }
- break;
- }