Renamed ifSqlHasZeroNums() to ifSqlHasZeroNumRows() and improved some queries.
[mailer.git] / inc / modules / guest / what-sponsor_reg.php
index ceb9c6638c2c6d8b1c51f8c531f529dc0b4f1a66..cb93271c33f44e364cf55f95666a1f69fd86c1fd 100644 (file)
@@ -1,7 +1,7 @@
 <?php
 /************************************************************************
- * MXChange v0.2.1                                    Start: 06/10/2005 *
- * ===============                              Last change: 05/18/2008 *
+ * Mailer v0.2.1-FINAL                                Start: 06/10/2005 *
+ * ===================                          Last change: 05/18/2008 *
  *                                                                      *
  * -------------------------------------------------------------------- *
  * File              : what-sponsor_reg.php                             *
  * -------------------------------------------------------------------- *
  * Kurzbeschreibung  : Anmeldeformular fuer Sponsoren                   *
  * -------------------------------------------------------------------- *
+ * Copyright (c) 2003 - 2009 by Roland Haeder                           *
+ * Copyright (c) 2009 - 2015 by Mailer Developer Team                   *
+ * For more information visit: http://mxchange.org                      *
  *                                                                      *
- * -------------------------------------------------------------------- *
- * Copyright (c) 2003 - 2008 by Roland Haeder                           *
- * For more information visit: http://www.mxchange.org                  *
- *                                                                      *
- * This program is free software. You can redistribute it and/or modify *
+ * This program is free software; you can redistribute it and/or modify *
  * it under the terms of the GNU General Public License as published by *
- * the Free Software Foundation; either version 2 of the License.       *
+ * the Free Software Foundation; either version 2 of the License, or    *
+ * (at your option) any later version.                                  *
  *                                                                      *
  * This program is distributed in the hope that it will be useful,      *
  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *
 
 // Some security stuff...
 if (!defined('__SECURITY')) {
-       $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4)."/security.php";
-       require($INC);
-} elseif ((!EXT_IS_ACTIVE("sponsor"))) {
-       addFatalMessage(getMessage('EXTENSION_PROBLEM_EXT_INACTIVE'), "sponsor");
-       return;
-}
+       exit();
+} // END - if
 
 // Add description as navigation point
-ADD_DESCR("guest", __FILE__);
+addYouAreHereLink('guest', __FILE__);
+
+if ((!isExtensionActive('sponsor'))) {
+       displayMessage('{%pipe,generateExtensionInactiveNotInstalledMessage=sponsor%}');
+       return;
+} // END - if
 
 // Create array for form errors (= missing data)
-$FORM_ERRORS = array();
+$formErrors = array();
 
-if (IS_FORM_SENT()) {
+if (isFormSent()) {
        //
        // Check submitted form data
        //
        // 1. Salutation / Surname / family name
-       if (!REQUEST_ISSET_POST(('gender'))) {
+       if (!isPostRequestElementSet('gender')) {
                // Surname is empty
-               $FORM_ERRORS[] = getMessage('SPONSOR_NO_GENDER_SELECTED');
-       }
+               array_push($formErrors, '{--SPONSOR_NO_GENDER_SELECTED--}');
+       } // END - if
 
-       if (!REQUEST_ISSET_POST(('surname'))) {
+       if (!isPostRequestElementSet('surname')) {
                // Surname is empty
-               $FORM_ERRORS[] = getMessage('SPONSOR_SURNAME_IS_EMPTY');
-       }
+               array_push($formErrors, '{--SPONSOR_SURNAME_EMPTY--}');
+       } // END - if
 
-       if (!REQUEST_ISSET_POST(('family'))) {
+       if (!isPostRequestElementSet('family')) {
                // Surname is empty
-               $FORM_ERRORS[] = getMessage('SPONSOR_FAMILY_IS_EMPTY');
-       }
+               array_push($formErrors, '{--SPONSOR_FAMILY_EMPTY--}');
+       } // END - if
 
        // 2. Company name
-       // 012     3                 32    23      4                   43    3      4                  4321    12      3                 32    2     3                   3210
-       if (((!REQUEST_ISSET_POST(('company'))) && ((REQUEST_ISSET_POST(('tax_ident'))) || (REQUEST_ISSET_POST(('position'))))) || ((REQUEST_ISSET_POST(('company'))) && (!REQUEST_ISSET_POST(('tax_ident'))))) {
-               if (!REQUEST_ISSET_POST(('company'))) {
+       // 012                          3         32    23                         4           43    3                         4          4321    12                         3         32    2                          3           3210
+       if (((!isPostRequestElementSet('company')) && ((isPostRequestElementSet('tax_ident')) || (isPostRequestElementSet('position')))) || ((isPostRequestElementSet('company')) && (!isPostRequestElementSet('tax_ident')))) {
+               if (!isPostRequestElementSet('company')) {
                        // Company name is empty
-                       $FORM_ERRORS[] = getMessage('SPONSOR_COMPANY_IS_EMPTY');
-               } elseif (!REQUEST_ISSET_POST(('tax_ident'))) {
+                       array_push($formErrors, '{--SPONSOR_COMPANY_EMPTY--}');
+               } elseif (!isPostRequestElementSet('tax_ident')) {
                        // Tax ident number name is empty
-                       $FORM_ERRORS[] = getMessage('SPONSOR_TAX_IDENT_IS_EMPTY');
+                       array_push($formErrors, '{--SPONSOR_TAX_IDENT_EMPTY--}');
                }
 
-               if (!REQUEST_ISSET_POST(('position'))) {
+               if (!isPostRequestElementSet('position')) {
                        // Not fatal but not nice: position in company is empty
-                       $FORM_ERRORS[] = getMessage('SPONSOR_POSITION_IS_EMPTY');
-               }
-       }
+                       array_push($formErrors, '{--SPONSOR_POSITION_EMPTY--}');
+               } // END - if
+       } // END - if
 
        // 3. Street and number
-       if (!REQUEST_ISSET_POST(('street_nr1'))) {
+       if (!isPostRequestElementSet('street_nr1')) {
                // Street name and house number are empty
-               $FORM_ERRORS[] = getMessage('SPONSOR_STREET_NR1_IS_EMPTY');
-       } elseif ((REQUEST_ISSET_POST(('street_nr2'))) && (!REQUEST_ISSET_POST(('street_nr1')))) {
+               array_push($formErrors, '{--SPONSOR_STREET_NR1_EMPTY--}');
+       } elseif ((isPostRequestElementSet('street_nr2')) && (!isPostRequestElementSet('street_nr1'))) {
                // 1st line for street is empty, but 2nd line not
-               $FORM_ERRORS[] = getMessage('SPONSOR_STREET_NR1_IS_EMPTY_2_NOT');
+               array_push($formErrors, '{--SPONSOR_STREET_NR1_EMPTY_2_NOT--}');
        }
 
        // 4. Country code
-       if (!REQUEST_ISSET_POST(('country'))) {
+       if (!isPostRequestElementSet('country')) {
                // Country code is empty
-               $FORM_ERRORS[] = getMessage('SPONSOR_COUNTRY_IS_EMPTY');
-       } elseif (strlen(REQUEST_POST('country')) != 2) {
+               array_push($formErrors, '{--kSPONSOR_COUNTRY_EMPTY--}');
+       } elseif (strlen(postRequestElement('country')) != 2) {
                // Country code is invalid
-               $FORM_ERRORS[] = getMessage('SPONSOR_COUNTRY_IS_INVALID');
+               array_push($formErrors, '{--SPONSOR_COUNTRY_IS_INVALID--}');
        }
 
        // 3. ZIP code
-       if (!REQUEST_ISSET_POST(('zip'))) {
+       if (!isPostRequestElementSet('zip')) {
                // ZIP code is empty
-               $FORM_ERRORS[] = getMessage('SPONSOR_ZIP_IS_EMPTY');
-       } elseif (bigintval(REQUEST_POST('zip')) != REQUEST_POST('zip')) {
+               array_push($formErrors, '{--SPONSOR_ZIP_EMPTY--}');
+       } elseif (bigintval(postRequestElement('zip')) != postRequestElement('zip')) {
                // ZIP is invalid
-               $FORM_ERRORS[] = getMessage('SPONSOR_ZIP_IS_INVALID');
-               REQUEST_SET_POST('zip', "");
+               array_push($formErrors, '{--SPONSOR_ZIP_IS_INVALID--}');
+               setPostRequestElement('zip', '');
        }
 
        // 4. City
-       if (!REQUEST_ISSET_POST(('city'))) {
+       if (!isPostRequestElementSet('city')) {
                // City is empty
-               $FORM_ERRORS[] = getMessage('SPONSOR_CITY_IS_EMPTY');
-       }
+               array_push($formErrors, '{--SPONSOR_CITY_EMPTY--}');
+       } // END - if
 
        // 5. Phone number
-       if (!REQUEST_ISSET_POST(('phone'))) {
+       if (!isPostRequestElementSet('phone')) {
                // City is empty
-               $FORM_ERRORS[] = getMessage('SPONSOR_PHONE_IS_EMPTY');
-       }
+               array_push($formErrors, '{--SPONSOR_PHONE_EMPTY--}');
+       } // END - if
 
        // 6. Homepage URL
-       if (!REQUEST_ISSET_POST(('url'))) {
+       if (!isPostRequestElementSet('url')) {
                // Homepage URL is empty
-               $FORM_ERRORS[] = getMessage('SPONSOR_URL_IS_EMPTY');
-       } elseif (!VALIDATE_URL(REQUEST_POST('url'))) {
+               array_push($formErrors, '{--SPONSOR_URL_EMPTY--}');
+       } elseif (!isUrlValid(postRequestElement('url'))) {
                // Homepage URL is invalid
-               $FORM_ERRORS[] = getMessage('SPONSOR_URL_IS_INVALID');
-               REQUEST_SET_POST('url', "");
+               array_push($formErrors, '{--SPONSOR_URL_IS_INVALID--}');
+               setPostRequestElement('url', '');
        }
 
        // 7. Light validation of email address
-       if ((!REQUEST_ISSET_POST(('email'))) || (REQUEST_POST('email') == "@")) {
+       if ((!isPostRequestElementSet('email')) || (postRequestElement('email') == '@')) {
                // Email is invalid/empty
-               $FORM_ERRORS[] = getMessage('SPONSOR_EMAIL_IS_INVALID');
-       } elseif (SPONSOR_FOUND_EMAIL_DB(REQUEST_POST('email'))) {
+               array_push($formErrors, '{--SPONSOR_EMAIL_IS_INVALID--}');
+       } elseif (isSponsorRegisteredWithEmail(postRequestElement('email'))) {
                // Email already found in database!
-               $FORM_ERRORS[] = getMessage('SPONSOR_EMAIL_IS_ALREADY_REGISTERED');
-               REQUEST_SET_POST('email', "");
+               array_push($formErrors, '{--SPONSOR_EMAIL_IS_ALREADY_REGISTERED--}');
+               setPostRequestElement('email', '');
        }
 
        // 8. Pay type selected?
-       if (!REQUEST_ISSET_POST(('pay_type'))) {
+       if (!isPostRequestElementSet('pay_type')) {
                // Not pay type selected
-               $FORM_ERRORS[] = getMessage('SPONSOR_NO_PAYTYPE_SELECTED');
-       }
+               array_push($formErrors, '{--SPONSOR_NO_PAYTYPE_SELECTED--}');
+       } // END - if
 
        // 9. Interval of mails
-       if (!REQUEST_ISSET_POST(('warning_interval'))) {
+       if (!isPostRequestElementSet('warning_interval')) {
                // No warning interval selected
-               $FORM_ERRORS[] = getMessage('SPONSOR_NO_WARNING_INTERVAL_SELECTED');
-       }
+               array_push($formErrors, '{--SPONSOR_NO_WARNING_INTERVAL_SELECTED--}');
+       } // END - if
 
        // 10. Mail notifications disabled/enabled
-       if (!REQUEST_ISSET_POST(('receive_warnings'))) {
+       if (!isPostRequestElementSet('receive_warnings')) {
                // Option not selected!
-               $FORM_ERRORS[] = getMessage('SPONSOR_NO_RECEIVE_WARNINGS_SELECTED');
-       }
+               array_push($formErrors, '{--SPONSOR_NO_RECEIVE_WARNINGS_SELECTED--}');
+       } // END - if
 
        // Did he enter his password twice?
-       if (((!REQUEST_ISSET_POST(('pass1'))) || (!REQUEST_ISSET_POST(('pass2')))) || ((REQUEST_POST('pass1') != REQUEST_POST('pass2')) && (REQUEST_ISSET_POST(('pass1'))) && (REQUEST_ISSET_POST(('pass2'))))) {
-               if ((REQUEST_POST('pass1') != REQUEST_POST('pass2')) && (REQUEST_ISSET_POST(('pass1'))) && (REQUEST_ISSET_POST(('pass2')))) {
+       if (((!isPostRequestElementSet('password1')) || (!isPostRequestElementSet('password2'))) || ((postRequestElement('password1') != postRequestElement('password2')) && (isPostRequestElementSet('password1')) && (isPostRequestElementSet('password2')))) {
+               if ((postRequestElement('password1') != postRequestElement('password2')) && (isPostRequestElementSet('password1')) && (isPostRequestElementSet('password2'))) {
                        // Passwords missmatch
-                       $FORM_ERRORS[] = getMessage('SPONSOR_PASSWORDS_MISMATCH');
+                       array_push($formErrors, '{--SPONSOR_PASSWORDS_MISMATCH--}');
                } else {
-                       if (!REQUEST_ISSET_POST(('pass1'))) {
+                       if (!isPostRequestElementSet('password1')) {
                                // Password 1 is empty
-                               $FORM_ERRORS[] = getMessage('SPONSOR_PASSWORD1_EMPTY');
+                               array_push($formErrors, '{--SPONSOR_PASSWORD1_EMPTY--}');
                        }
 
-                       if (!REQUEST_ISSET_POST(('pass2'))) {
+                       if (!isPostRequestElementSet('password2')) {
                                // Password 2 is empty
-                               $FORM_ERRORS[] = getMessage('SPONSOR_PASSWORD2_EMPTY');
+                               array_push($formErrors, '{--SPONSOR_PASSWORD2_EMPTY--}');
                        }
                }
-       } elseif (strlen(REQUEST_POST('pass1')) < getConfig('pass_len')) {
+       } elseif (strlen(postRequestElement('password1')) < getMinPasswordLength()) {
                // Password is to short!
-               $FORM_ERRORS[] = sprintf(getMessage('SPONSOR_PASSWORD_TOO_SHORT'), getConfig('pass_len'));
+               array_push($formErrors, '{--SPONSOR_PASSWORD_TOO_SHORT--}');
        }
 
        // Check if he has accepted the terms&conditions
-       if (!REQUEST_ISSET_POST(('terms'))) {
+       if (!isPostRequestElementSet('terms')) {
                // Homepage URL is empty
-               $FORM_ERRORS[] = getMessage('SPONSOR_TERMS_NOT_ACCEPTED');
-       }
-       
+               array_push($formErrors, '{--SPONSOR_TERMS_NOT_ACCEPTED--}');
+       } // END - if
+
        // If there is something wrong/missing stop registration
-       if (count($FORM_ERRORS) > 0) REQUEST_UNSET_POST('ok');
-}
+       if (isFilledArray($formErrors)) unsetPostRequestElement('ok');
+} // END - if
 
-if ((IS_FORM_SENT()) && (count($FORM_ERRORS) == 0)) {
+if ((isFormSent()) && (!isFilledArray($formErrors))) {
        // Generate message array
-       $MSGs = array(
-               'failed' => getMessage('SPONSOR_REGISTRATION_FAILED'),
-               'added'  => getMessage('SPONSOR_REGISTRATION_COMPLETED'),
+       $messageArray = 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(REQUEST_POST('pay_type')), __FILE__, __LINE__);
-       list($points, $pay, $curr) = SQL_FETCHROW($result);
+       $result = sqlQueryEscaped('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) = sqlFetchRow($result);
 
        // Free memory
-       SQL_FREERESULT($result);
+       sqlFreeResult($result);
 
        // Add points to array
-       REQUEST_POST('points_amount', $points);
-       REQUEST_POST('points_used'  , "0.00000");
-       REQUEST_POST('last_pay'     , $pay);
-       REQUEST_POST('last_curr'    , $curr);
+       postRequestElement('points_amount', $points);
+       postRequestElement('points_used'  , '0.00000');
+       postRequestElement('last_payment' , $pay);
+       postRequestElement('last_currency', $curr);
 
        // Register sponsor but never ever update here!
-       $STATUS = SPONSOR_HANDLE_SPONSOR(REQUEST_POST_ARRAY(), 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(REQUEST_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'    , REQUEST_POST('email'));
-                       define('__SURNAME'  , REQUEST_POST('surname'));
-                       define('__FAMILY'   , REQUEST_POST('family'));
-                       define('__GENDER'    , TRANSLATE_GENDER(REQUEST_POST('gender')));
-                       define('__TIMESTAMP', MAKE_DATETIME(time(), 0));
-                       define('__PASSWORD' , REQUEST_POST('pass1'));
-
-                       // Generate email and send it to the new sponsor
-                       $EMAIL_MSG = LOAD_EMAIL_TEMPLATE("sponsor_confirm", $hash);
-                       SEND_EMAIL(REQUEST_POST('email'), getMessage('SPONSOR_PLEASE_CONFIRM_SUBJ'), $EMAIL_MSG);
-
-                       // Send mail to admin
-                       SEND_ADMIN_NOTIFICATION(getMessage('ADMIN_NEW_SPONSOR'), "admin_sponsor_reg", $hash);
-
-                       // Output message: DONE
-                       $MSG = $MSGs['added'];
-               } else {
-                       // Sponsor account not found???
-                       $MSG = sprintf(getMessage('SPONSOR_EMAIL_404'), REQUEST_POST('email'));
-               }
-
-               // Free memory
-               SQL_FREERESULT($result);
-               break;
-
-       default:
-               DEBUG_LOG(__FILE__, __LINE__, sprintf("Unknown status %s detected.", $STATUS));
-               if (!IS_ADMIN()) {
-                       // Message for testing admin
-                       $MSG = sprintf(getMessage('ADMIN_SPONSOR_UNKNOWN_STATUS'), $STATUS);
-               } else {
-                       // Message for the guest
-                       $MSG = sprintf(getMessage('SPONSOR_UNKNOWN_STATUS'), $STATUS);
-               }
-               break;
-       }
+       $message = doProcessSponsorFormRequest($messageArray);
 
        // Display message
-       LOAD_TEMPLATE("admin_settings_saved", false, $MSG);
+       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 = sqlQuery('SELECT
+       `id`,
+       `pay_name`,
+       `pay_rate`,
+       `pay_currency`,
+       `pay_min_count`
+FROM
+       `{?_MYSQL_PREFIX?}_sponsor_paytypes`
+ORDER BY
+       `pay_name` ASC', __FILE__, __LINE__);
+
+       if (!ifSqlHasZeroNumRows($result)) {
                // Load all types...
-               // @TODO Swap this HTML code to templates
-               $OUT = "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"300\" class=\"left2 right2 top2\">\n";
-               $SW = 2;
-               while (list($id, $name, $rate, $curr, $min) = SQL_FETCHROW($result)) {
-                       $OUT .= "<tr>
-  <td class=\"bottom2 switch_sw".$SW."\" height=\"50\" style=\"padding-left: 2px; padding-right: 2px\">
-    <input type=\"radio\" name=\"pay_type\" class=\"guest_normal\" value=\"".bigintval($id)."\" />&nbsp;".$name."<br />
-    <div align=\"right\">(".$min." ".$curr." = ".TRANSLATE_COMMA($rate * $min)." {!POINTS!})</div>
-  </td>
-</tr>\n";
-                       $SW = 3 - $SW;
-               }
-               $OUT .= "</table>\n";
-               define('__PAYMENT_LIST', $OUT);
-               SQL_FREERESULT($result);
+               $OUT = '';
+               while ($content = sqlFetchArray($result)) {
+                       // Prepare content for output
+                       $content['res'] = translateComma($content['pay_rate'] * $content['pay_min_count']);
+
+                       // Load row template and switch color
+                       $OUT .= loadTemplate('guest_sponsor_payment_row', TRUE, $content);
+               } // END - while
+
+               // Remember the list in table
+               $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','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 (isFilledArray($formErrors)) {
                        // Some found... :-(
-                       define('__COMPANY'  , COMPILE_CODE(REQUEST_POST('company')));
-                       define('__POSITION' , COMPILE_CODE(REQUEST_POST('position')));
-                       define('__TAX_IDENT', COMPILE_CODE(REQUEST_POST('tax_ident')));
-                       define('__SURNAME'  , COMPILE_CODE(REQUEST_POST('surname')));
-                       define('__FAMILY'   , COMPILE_CODE(REQUEST_POST('family')));
-                       define('__STREET1'  , COMPILE_CODE(REQUEST_POST('street_nr1')));
-                       define('__STREET2'  , COMPILE_CODE(REQUEST_POST('street_nr2')));
-                       define('__COUNTRY'  , COMPILE_CODE(REQUEST_POST('country')));
-                       define('__ZIP'      , COMPILE_CODE(REQUEST_POST('zip')));
-                       define('__CITY'     , COMPILE_CODE(REQUEST_POST('city')));
-                       define('__PHONE'    , COMPILE_CODE(REQUEST_POST('phone')));
-                       define('__FAX'      , COMPILE_CODE(REQUEST_POST('fax')));
-                       define('__CELL'     , COMPILE_CODE(REQUEST_POST('cell')));
-                       define('__EMAIL'    , COMPILE_CODE(REQUEST_POST('email')));
-                       define('__URL'      , COMPILE_CODE(REQUEST_POST('url')));
-
-                       // Check for gender selection
-                       switch (REQUEST_POST('gender'))
-                       {
-                       case "M": // Male
-                               define('__GENDER_M'  , " selected=\"selected\"");
-                               define('__GENDER_F'  , "");
-                               define('__GENDER_C'  , "");
-                               break;
-
-                       case "F": // Female
-                               define('__GENDER_M'  , "");
-                               define('__GENDER_F'  , " selected=\"selected\"");
-                               define('__GENDER_C'  , "");
-                               break;
-
-                       case "C": // Company
-                               define('__GENDER_M'  , "");
-                               define('__GENDER_F'  , "");
-                               define('__GENDER_C'  , " selected=\"selected\"");
-                               break;
-                       }
+                       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
 
-                       // Check for receive_warnings
-                       switch (REQUEST_POST('receive_warnings'))
-                       {
-                       case "Y":
-                               define('__REC_Y'    , " selected=\"selected\"");
-                               define('__REC_N'    , "");
-                               break;
-
-                       case "N":
-                               define('__REC_Y'    , "");
-                               define('__REC_N'    , " selected=\"selected\"");
-                               break;
-                       }
+                       // Init receive selection
+                       $content['receive_warnings_y'] = '';
+                       $content['receive_warnings_n'] = '';
 
-                       // Errors found
-                       $OUT = "<P align=\"center\">
-  <strong><div class=\"guest_failed\">".SPONSOR_REGISTER_SOMETHING_MISSING.":</div></strong><br />
-</P>
-<ol>\n";
-                       foreach ($FORM_ERRORS as $error) {
-                               $OUT .= "<li>".$error."</li>\n";
+                       // Check for receive_warnings
+                       $content['receive_warnings_' . strtolower(postRequestElement('receive_warnings'))] = ' selected="selected"';
+                       $OUT = '';
+
+                       // Errors found?
+                       if (isFilledArray($formErrors)) {
+                               $OUT = returnMessage('{--SPONSOR_REGISTER_SOMETHING_MISSING--}');
+                               $OUT .= '<ol>';
+                               foreach ($formErrors as $error) {
+                                       $OUT .= '<li>' . $error . '</li>';
+                               } // END - foreach
+
+                               $OUT .= '</ol>';
                        } // END - if
 
-                       $OUT .= "</ol><br />\n";
-                       define('__SPONSOR_FORM_ERRORS', $OUT);
-                       define('__SPONSOR_REFID', REQUEST_POST('refid'));
-               } else {
-                       // None found, first call
-                       define('__COMPANY'  , "");
-                       define('__POSITION' , "");
-                       define('__TAX_IDENT', "");
-                       define('__GENDER_M'  , "");
-                       define('__GENDER_F'  , "");
-                       define('__GENDER_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', "");
-               }
+                       $content['form_errors'] = $OUT;
 
-               // Prepare referal things
-               if (!REQUEST_ISSET_GET(('refid'))) {
-                       // No referal link
-                       define('__SPONSOR_REFID', "0");
-               } else  {
-                       // Referal ID transmitted, we don't care here if it is right or not
-                       define('__SPONSOR_REFID', bigintval(REQUEST_GET('refid')));
-               }
+                       // @TODO Maybe a default referral id?
+                       $content['refid'] = NULL;
+
+                       // Is the referral id valid?
+                       if ((isPostRequestElementSet('refid')) && (isValidId(postRequestElement('refid')))) {
+                               // Transfer referral id
+                               $content['refid'] = bigintval(postRequestElement('refid'));
+                       } // END - if
+               } // END - if
 
                // Display registration form
-               LOAD_TEMPLATE("guest_sponsor_reg");
+               loadTemplate('guest_sponsor_reg', FALSE, $content);
        } else {
                // Nothing added so far
-               LOAD_TEMPLATE("admin_settings_saved", false, SPONSOR_PAYMENT_LIST_IS_EMPTY);
+               displayMessage('{--SPONSOR_PAYMENT_LIST_EMPTY--}');
        }
 
        // Free memory
-       SQL_FREERESULT($result);
+       sqlFreeResult($result);
 }
 
-//
+// [EOF]
 ?>