Renamed ifSqlHasZeroNums() to ifSqlHasZeroNumRows() and improved some queries.
[mailer.git] / inc / modules / guest / what-sponsor_reg.php
index 17dd29b14850b779e6fc734f9886c68090a99990..cb93271c33f44e364cf55f95666a1f69fd86c1fd 100644 (file)
  * -------------------------------------------------------------------- *
  * Kurzbeschreibung  : Anmeldeformular fuer Sponsoren                   *
  * -------------------------------------------------------------------- *
- * $Revision::                                                        $ *
- * $Date::                                                            $ *
- * $Tag:: 0.2.1-FINAL                                                 $ *
- * $Author::                                                          $ *
- * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009, 2010 by Mailer Developer Team                    *
- * For more information visit: http://www.mxchange.org                  *
+ * Copyright (c) 2009 - 2015 by Mailer Developer Team                   *
+ * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * 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 *
 
 // Some security stuff...
 if (!defined('__SECURITY')) {
-       die();
+       exit();
 } // END - if
 
 // Add description as navigation point
-addMenuDescription('guest', __FILE__);
+addYouAreHereLink('guest', __FILE__);
 
 if ((!isExtensionActive('sponsor'))) {
-       loadTemplate('admin_settings_saved', false, generateExtensionInactiveNotInstalledMessage('sponsor'));
+       displayMessage('{%pipe,generateExtensionInactiveNotInstalledMessage=sponsor%}');
        return;
 } // END - if
 
@@ -56,148 +51,148 @@ if (isFormSent()) {
        // Check submitted form data
        //
        // 1. Salutation / Surname / family name
-       if (!isPostRequestParameterSet('gender')) {
+       if (!isPostRequestElementSet('gender')) {
                // Surname is empty
-               $formErrors[] = '{--SPONSOR_NO_GENDER_SELECTED--}';
+               array_push($formErrors, '{--SPONSOR_NO_GENDER_SELECTED--}');
        } // END - if
 
-       if (!isPostRequestParameterSet('surname')) {
+       if (!isPostRequestElementSet('surname')) {
                // Surname is empty
-               $formErrors[] = '{--SPONSOR_SURNAME_IS_EMPTY--}';
+               array_push($formErrors, '{--SPONSOR_SURNAME_EMPTY--}');
        } // END - if
 
-       if (!isPostRequestParameterSet('family')) {
+       if (!isPostRequestElementSet('family')) {
                // Surname is empty
-               $formErrors[] = '{--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 (((!isPostRequestParameterSet('company')) && ((isPostRequestParameterSet('tax_ident')) || (isPostRequestParameterSet('position')))) || ((isPostRequestParameterSet('company')) && (!isPostRequestParameterSet('tax_ident')))) {
-               if (!isPostRequestParameterSet('company')) {
+       if (((!isPostRequestElementSet('company')) && ((isPostRequestElementSet('tax_ident')) || (isPostRequestElementSet('position')))) || ((isPostRequestElementSet('company')) && (!isPostRequestElementSet('tax_ident')))) {
+               if (!isPostRequestElementSet('company')) {
                        // Company name is empty
-                       $formErrors[] = '{--SPONSOR_COMPANY_IS_EMPTY--}';
-               } elseif (!isPostRequestParameterSet('tax_ident')) {
+                       array_push($formErrors, '{--SPONSOR_COMPANY_EMPTY--}');
+               } elseif (!isPostRequestElementSet('tax_ident')) {
                        // Tax ident number name is empty
-                       $formErrors[] = '{--SPONSOR_TAX_IDENT_IS_EMPTY--}';
+                       array_push($formErrors, '{--SPONSOR_TAX_IDENT_EMPTY--}');
                }
 
-               if (!isPostRequestParameterSet('position')) {
+               if (!isPostRequestElementSet('position')) {
                        // Not fatal but not nice: position in company is empty
-                       $formErrors[] = '{--SPONSOR_POSITION_IS_EMPTY--}';
+                       array_push($formErrors, '{--SPONSOR_POSITION_EMPTY--}');
                } // END - if
        } // END - if
 
        // 3. Street and number
-       if (!isPostRequestParameterSet('street_nr1')) {
+       if (!isPostRequestElementSet('street_nr1')) {
                // Street name and house number are empty
-               $formErrors[] = '{--SPONSOR_STREET_NR1_IS_EMPTY--}';
-       } elseif ((isPostRequestParameterSet('street_nr2')) && (!isPostRequestParameterSet('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
-               $formErrors[] = '{--SPONSOR_STREET_NR1_IS_EMPTY_2_NOT--}';
+               array_push($formErrors, '{--SPONSOR_STREET_NR1_EMPTY_2_NOT--}');
        }
 
        // 4. Country code
-       if (!isPostRequestParameterSet('country')) {
+       if (!isPostRequestElementSet('country')) {
                // Country code is empty
-               $formErrors[] = '{--kSPONSOR_COUNTRY_IS_EMPTY--}';
-       } elseif (strlen(postRequestParameter('country')) != 2) {
+               array_push($formErrors, '{--kSPONSOR_COUNTRY_EMPTY--}');
+       } elseif (strlen(postRequestElement('country')) != 2) {
                // Country code is invalid
-               $formErrors[] = '{--SPONSOR_COUNTRY_IS_INVALID--}';
+               array_push($formErrors, '{--SPONSOR_COUNTRY_IS_INVALID--}');
        }
 
        // 3. ZIP code
-       if (!isPostRequestParameterSet('zip')) {
+       if (!isPostRequestElementSet('zip')) {
                // ZIP code is empty
-               $formErrors[] = '{--SPONSOR_ZIP_IS_EMPTY--}';
-       } elseif (bigintval(postRequestParameter('zip')) != postRequestParameter('zip')) {
+               array_push($formErrors, '{--SPONSOR_ZIP_EMPTY--}');
+       } elseif (bigintval(postRequestElement('zip')) != postRequestElement('zip')) {
                // ZIP is invalid
-               $formErrors[] = '{--SPONSOR_ZIP_IS_INVALID--}';
-               setPostRequestParameter('zip', '');
+               array_push($formErrors, '{--SPONSOR_ZIP_IS_INVALID--}');
+               setPostRequestElement('zip', '');
        }
 
        // 4. City
-       if (!isPostRequestParameterSet('city')) {
+       if (!isPostRequestElementSet('city')) {
                // City is empty
-               $formErrors[] = '{--SPONSOR_CITY_IS_EMPTY--}';
+               array_push($formErrors, '{--SPONSOR_CITY_EMPTY--}');
        } // END - if
 
        // 5. Phone number
-       if (!isPostRequestParameterSet('phone')) {
+       if (!isPostRequestElementSet('phone')) {
                // City is empty
-               $formErrors[] = '{--SPONSOR_PHONE_IS_EMPTY--}';
+               array_push($formErrors, '{--SPONSOR_PHONE_EMPTY--}');
        } // END - if
 
        // 6. Homepage URL
-       if (!isPostRequestParameterSet('url')) {
+       if (!isPostRequestElementSet('url')) {
                // Homepage URL is empty
-               $formErrors[] = '{--SPONSOR_URL_IS_EMPTY--}';
-       } elseif (!isUrlValid(postRequestParameter('url'))) {
+               array_push($formErrors, '{--SPONSOR_URL_EMPTY--}');
+       } elseif (!isUrlValid(postRequestElement('url'))) {
                // Homepage URL is invalid
-               $formErrors[] = '{--SPONSOR_URL_IS_INVALID--}';
-               setPostRequestParameter('url', '');
+               array_push($formErrors, '{--SPONSOR_URL_IS_INVALID--}');
+               setPostRequestElement('url', '');
        }
 
        // 7. Light validation of email address
-       if ((!isPostRequestParameterSet('email')) || (postRequestParameter('email') == '@')) {
+       if ((!isPostRequestElementSet('email')) || (postRequestElement('email') == '@')) {
                // Email is invalid/empty
-               $formErrors[] = '{--SPONSOR_EMAIL_IS_INVALID--}';
-       } elseif (isSponsorRegisteredWithEmail(postRequestParameter('email'))) {
+               array_push($formErrors, '{--SPONSOR_EMAIL_IS_INVALID--}');
+       } elseif (isSponsorRegisteredWithEmail(postRequestElement('email'))) {
                // Email already found in database!
-               $formErrors[] = '{--SPONSOR_EMAIL_IS_ALREADY_REGISTERED--}';
-               setPostRequestParameter('email', '');
+               array_push($formErrors, '{--SPONSOR_EMAIL_IS_ALREADY_REGISTERED--}');
+               setPostRequestElement('email', '');
        }
 
        // 8. Pay type selected?
-       if (!isPostRequestParameterSet('pay_type')) {
+       if (!isPostRequestElementSet('pay_type')) {
                // Not pay type selected
-               $formErrors[] = '{--SPONSOR_NO_PAYTYPE_SELECTED--}';
+               array_push($formErrors, '{--SPONSOR_NO_PAYTYPE_SELECTED--}');
        } // END - if
 
        // 9. Interval of mails
-       if (!isPostRequestParameterSet('warning_interval')) {
+       if (!isPostRequestElementSet('warning_interval')) {
                // No warning interval selected
-               $formErrors[] = '{--SPONSOR_NO_WARNING_INTERVAL_SELECTED--}';
+               array_push($formErrors, '{--SPONSOR_NO_WARNING_INTERVAL_SELECTED--}');
        } // END - if
 
        // 10. Mail notifications disabled/enabled
-       if (!isPostRequestParameterSet('receive_warnings')) {
+       if (!isPostRequestElementSet('receive_warnings')) {
                // Option not selected!
-               $formErrors[] = '{--SPONSOR_NO_RECEIVE_WARNINGS_SELECTED--}';
+               array_push($formErrors, '{--SPONSOR_NO_RECEIVE_WARNINGS_SELECTED--}');
        } // END - if
 
        // Did he enter his password twice?
-       if (((!isPostRequestParameterSet('pass1')) || (!isPostRequestParameterSet('pass2'))) || ((postRequestParameter('pass1') != postRequestParameter('pass2')) && (isPostRequestParameterSet('pass1')) && (isPostRequestParameterSet('pass2')))) {
-               if ((postRequestParameter('pass1') != postRequestParameter('pass2')) && (isPostRequestParameterSet('pass1')) && (isPostRequestParameterSet('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
-                       $formErrors[] = '{--SPONSOR_PASSWORDS_MISMATCH--}';
+                       array_push($formErrors, '{--SPONSOR_PASSWORDS_MISMATCH--}');
                } else {
-                       if (!isPostRequestParameterSet('pass1')) {
+                       if (!isPostRequestElementSet('password1')) {
                                // Password 1 is empty
-                               $formErrors[] = '{--SPONSOR_PASSWORD1_EMPTY--}';
+                               array_push($formErrors, '{--SPONSOR_PASSWORD1_EMPTY--}');
                        }
 
-                       if (!isPostRequestParameterSet('pass2')) {
+                       if (!isPostRequestElementSet('password2')) {
                                // Password 2 is empty
-                               $formErrors[] = '{--SPONSOR_PASSWORD2_EMPTY--}';
+                               array_push($formErrors, '{--SPONSOR_PASSWORD2_EMPTY--}');
                        }
                }
-       } elseif (strlen(postRequestParameter('pass1')) < getConfig('pass_len')) {
+       } elseif (strlen(postRequestElement('password1')) < getMinPasswordLength()) {
                // Password is to short!
-               $formErrors[] = '{--SPONSOR_PASSWORD_TOO_SHORT--}';
+               array_push($formErrors, '{--SPONSOR_PASSWORD_TOO_SHORT--}');
        }
 
        // Check if he has accepted the terms&conditions
-       if (!isPostRequestParameterSet('terms')) {
+       if (!isPostRequestElementSet('terms')) {
                // Homepage URL is empty
-               $formErrors[] = '{--SPONSOR_TERMS_NOT_ACCEPTED--}';
+               array_push($formErrors, '{--SPONSOR_TERMS_NOT_ACCEPTED--}');
        } // END - if
 
        // If there is something wrong/missing stop registration
-       if (count($formErrors) > 0) unsetPostRequestParameter('ok');
+       if (isFilledArray($formErrors)) unsetPostRequestElement('ok');
 } // END - if
 
-if ((isFormSent()) && (count($formErrors) == 0)) {
+if ((isFormSent()) && (!isFilledArray($formErrors))) {
        // Generate message array
        $messageArray = array(
                'failed' => '{--SPONSOR_REGISTRATION_FAILED--}',
@@ -205,51 +200,58 @@ if ((isFormSent()) && (count($formErrors) == 0)) {
        );
 
        // Calulate points
-       $result = SQL_QUERY_ESC("SELECT
-       (`pay_rate` * `pay_min_count`) AS points, `pay_min_count` AS pay, `pay_currency` AS curr
+       $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(postRequestParameter('pay_type')), __FILE__, __LINE__);
-       list($points, $pay, $curr) = SQL_FETCHROW($result);
+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
-       postRequestParameter('points_amount', $points);
-       postRequestParameter('points_used'  , '0.00000');
-       postRequestParameter('last_payment' , $pay);
-       postRequestParameter('last_currency', $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!
        $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`
+       $result = sqlQuery('SELECT
+       `id`,
+       `pay_name`,
+       `pay_rate`,
+       `pay_currency`,
+       `pay_min_count`
 FROM
        `{?_MYSQL_PREFIX?}_sponsor_paytypes`
-ORDER BY 
+ORDER BY
        `pay_name` ASC', __FILE__, __LINE__);
-       if (!SQL_HASZERONUMS($result)) {
+
+       if (!ifSqlHasZeroNumRows($result)) {
                // Load all types...
                $OUT = '';
-               while ($content = SQL_FETCHARRAY($result)) {
+               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);
+                       $OUT .= loadTemplate('guest_sponsor_payment_row', TRUE, $content);
                } // END - while
 
                // Remember the list in table
-               $content['payment_list'] = loadTemplate('guest_sponsor_payment', true, $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','fax','cell','email','url','receive_warnings_y','receive_warnings_n','form_errors','refid') as $entry) {
@@ -257,31 +259,23 @@ ORDER BY
                } // END - foreach
 
                // Check for invalid entries
-               if (count($formErrors) > 0) {
+               if (isFilledArray($formErrors)) {
                        // Some found... :-(
                        foreach (array('company','position','tax_ident','surname','family','street_nr1','street_nr2','country','zip','city','phone','fax','cell','email','url') as $entry) {
-                               $content[$entry]    = secureString(postRequestParameter($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(postRequestParameter('gender'))] = ' selected="selected"';
-
                        // Init receive selection
                        $content['receive_warnings_y'] = '';
                        $content['receive_warnings_n'] = '';
 
                        // Check for receive_warnings
-                       $content['receive_warnings_' . strtolower(postRequestParameter('receive_warnings'))] = ' selected="selected"';
+                       $content['receive_warnings_' . strtolower(postRequestElement('receive_warnings'))] = ' selected="selected"';
                        $OUT = '';
 
                        // Errors found?
-                       if (count($formErrors) > 0) {
-                               $OUT = loadTemplate('admin_settings_saved', true, '{--SPONSOR_REGISTER_SOMETHING_MISSING--}');
+                       if (isFilledArray($formErrors)) {
+                               $OUT = returnMessage('{--SPONSOR_REGISTER_SOMETHING_MISSING--}');
                                $OUT .= '<ol>';
                                foreach ($formErrors as $error) {
                                        $OUT .= '<li>' . $error . '</li>';
@@ -292,25 +286,25 @@ ORDER BY
 
                        $content['form_errors'] = $OUT;
 
-                       // @TODO Maybe a default referal id?
-                       $content['refid']       = 0;
+                       // @TODO Maybe a default referral id?
+                       $content['refid'] = NULL;
 
-                       // Is the referal id valid?
-                       if ((isPostRequestParameterSet('refid')) && (isValidUserId(postRequestParameter('refid')))) {
-                               // Transfer referal id
-                               $content['refid']       = bigintval(postRequestParameter('refid'));
+                       // 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
-               loadTemplate('guest_sponsor_reg', false, $content);
+               loadTemplate('guest_sponsor_reg', FALSE, $content);
        } else {
                // Nothing added so far
-               loadTemplate('admin_settings_saved', false, '{--SPONSOR_PAYMENT_LIST_IS_EMPTY--}');
+               displayMessage('{--SPONSOR_PAYMENT_LIST_EMPTY--}');
        }
 
        // Free memory
-       SQL_FREERESULT($result);
+       sqlFreeResult($result);
 }
 
 // [EOF]