0) unset($HTTP_POST_VARS['ok']);
}
if ((isset($HTTP_POST_VARS['ok'])) && (count($FORM_ERRORS) == 0))
{
// Generate message array
$MSGs = array(
'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", array($HTTP_POST_VARS['pay_type']), __FILE__, __LINE__);
list($points, $pay, $curr) = SQL_FETCHROW($result);
// Free memory
SQL_FREERESULT($result);
// Add points to array
$HTTP_POST_VARS['points_amount'] = $points;
$HTTP_POST_VARS['points_used'] = "0.00000";
$HTTP_POST_VARS['last_pay'] = $pay;
$HTTP_POST_VARS['last_curr'] = $curr;
// Register sponsor but never ever update here!
$STATUS = SPONSOR_HANDLE_SPONSOR($HTTP_POST_VARS, 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($HTTP_POST_VARS['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' , $HTTP_POST_VARS['email']);
define('__SURNAME' , $HTTP_POST_VARS['surname']);
define('__FAMILY' , $HTTP_POST_VARS['family']);
define('__SALUT' , TRANSLATE_SEX($HTTP_POST_VARS['salut']));
define('__TIMESTAMP', MAKE_DATETIME(time(), 0));
define('__PASSWORD' , $HTTP_POST_VARS['pass1']);
// Generate email and send it to the new sponsor
$EMAIL_MSG = LOAD_EMAIL_TEMPLATE("sponsor_confirm", $hash);
SEND_EMAIL($HTTP_POST_VARS['email'], SPONSOR_PLEASE_CONFIRM_SUBJ, $EMAIL_MSG);
// Send mail to admin
if (GET_EXT_VERSION("admins") >= "0.4.1")
{
// Use new system
SEND_ADMIN_EMAILS_PRO(ADMIN_NEW_SPONSOR, "admin_sponsor_reg", $hash);
}
else
{
// Send over old system
$msg_admin = LOAD_EMAIL_TEMPLATE("admin_sponsor_reg", $hash);
SEND_ADMIN_EMAILS (ADMIN_NEW_SPONSOR, $msg_admin);
}
// Output message: DONE
$MSG = $MSGs['added'];
}
else
{
// Sponsor account not found???
$MSG = SPONSOR_EMAIL_404_1.$HTTP_POST_VARS['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;
}
// Display message
LOAD_TEMPLATE("admin_settings_saved", false, $MSG);
}
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)
{
// Load all types...
$OUT = "\n";
define('__PAYMENT_LIST', $OUT);
SQL_FREERESULT($result);
// Check for invalid entries
if (count($FORM_ERRORS) > 0)
{
// Some found... :-(
define('__COMPANY' , COMPILE_CODE($HTTP_POST_VARS['company']));
define('__POSITION' , COMPILE_CODE($HTTP_POST_VARS['position']));
define('__TAX_IDENT', COMPILE_CODE($HTTP_POST_VARS['tax_ident']));
define('__SURNAME' , COMPILE_CODE($HTTP_POST_VARS['surname']));
define('__FAMILY' , COMPILE_CODE($HTTP_POST_VARS['family']));
define('__STREET1' , COMPILE_CODE($HTTP_POST_VARS['street_nr1']));
define('__STREET2' , COMPILE_CODE($HTTP_POST_VARS['street_nr2']));
define('__COUNTRY' , COMPILE_CODE($HTTP_POST_VARS['country']));
define('__ZIP' , COMPILE_CODE($HTTP_POST_VARS['zip']));
define('__CITY' , COMPILE_CODE($HTTP_POST_VARS['city']));
define('__PHONE' , COMPILE_CODE($HTTP_POST_VARS['phone']));
define('__FAX' , COMPILE_CODE($HTTP_POST_VARS['fax']));
define('__CELL' , COMPILE_CODE($HTTP_POST_VARS['cell']));
define('__EMAIL' , COMPILE_CODE($HTTP_POST_VARS['email']));
define('__URL' , COMPILE_CODE($HTTP_POST_VARS['url']));
// Check for salutation selection
switch ($HTTP_POST_VARS['salut'])
{
case "M": // Male
define('__SALUT_M' , " selected");
define('__SALUT_F' , "");
define('__SALUT_C' , "");
break;
case "F": // Female
define('__SALUT_M' , "");
define('__SALUT_F' , " selected");
define('__SALUT_C' , "");
break;
case "C": // Company
define('__SALUT_M' , "");
define('__SALUT_F' , "");
define('__SALUT_C' , " selected");
break;
}
// Check for receive_warnings
switch ($HTTP_POST_VARS['receive_warnings'])
{
case "Y":
define('__REC_Y' , " selected");
define('__REC_N' , "");
break;
case "N":
define('__REC_Y' , "");
define('__REC_N' , " selected");
break;
}
// Errors found
$OUT = "
".SPONSOR_REGISTER_SOMETHING_MISSING.":
\n";
foreach ($FORM_ERRORS as $error)
{
$OUT .= "- ".$error."
\n";
}
$OUT .= "
\n";
define('__SPONSOR_FORM_ERRORS', $OUT);
define('__SPONSOR_REFID', $HTTP_POST_VARS['refid']);
}
else
{
// None found, first call
define('__COMPANY' , "");
define('__POSITION' , "");
define('__TAX_IDENT', "");
define('__SALUT_M' , "");
define('__SALUT_F' , "");
define('__SALUT_C' , "");
define('__SURNAME' , "");
define('__FAMILY' , "");
define('__STREET1' , "");
define('__STREET2' , "");
define('__COUNTRY' , "");
define('__ZIP' , "");
define('__CITY' , "");
define('__PHONE' , "");
define('__FAX' , "");
define('__CELL' , "");
define('__EMAIL' , "");
define('__URL' , "");
define('__REC_Y' , "");
define('__REC_N' , "");
// No errors found so far
define('__SPONSOR_FORM_ERRORS', "");
}
// Prepare referral things
if (!isset($HTTP_GET_VARS['refid']))
{
// No referral link
define('__SPONSOR_REFID', "0");
}
else
{
// Referral ID transmitted, we don't care here if it is right or not
define('__SPONSOR_REFID', $HTTP_GET_VARS['refid']);
}
// Display registration form
LOAD_TEMPLATE("guest_sponsor_reg");
}
else
{
// Nothing added so far
LOAD_TEMPLATE("admin_settings_saved", false, SPONSOR_PAYMENT_LIST_IS_EMPTY);
}
// Free memory
SQL_FREERESULT($result);
}
//
?>