Renamed ifSqlHasZeroNums() to ifSqlHasZeroNumRows() and improved some queries.
[mailer.git] / inc / modules / guest / what-sponsor_reg.php
index 06319fc276076ef96e76e93b83875123c5fa5bc2..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 - 2011 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 *
@@ -37,7 +32,7 @@
 
 // Some security stuff...
 if (!defined('__SECURITY')) {
-       die();
+       exit();
 } // END - if
 
 // Add description as navigation point
@@ -58,17 +53,17 @@ if (isFormSent()) {
        // 1. Salutation / Surname / family name
        if (!isPostRequestElementSet('gender')) {
                // Surname is empty
-               $formErrors[] = '{--SPONSOR_NO_GENDER_SELECTED--}';
+               array_push($formErrors, '{--SPONSOR_NO_GENDER_SELECTED--}');
        } // END - if
 
        if (!isPostRequestElementSet('surname')) {
                // Surname is empty
-               $formErrors[] = '{--SPONSOR_SURNAME_EMPTY--}';
+               array_push($formErrors, '{--SPONSOR_SURNAME_EMPTY--}');
        } // END - if
 
        if (!isPostRequestElementSet('family')) {
                // Surname is empty
-               $formErrors[] = '{--SPONSOR_FAMILY_EMPTY--}';
+               array_push($formErrors, '{--SPONSOR_FAMILY_EMPTY--}');
        } // END - if
 
        // 2. Company name
@@ -76,128 +71,128 @@ if (isFormSent()) {
        if (((!isPostRequestElementSet('company')) && ((isPostRequestElementSet('tax_ident')) || (isPostRequestElementSet('position')))) || ((isPostRequestElementSet('company')) && (!isPostRequestElementSet('tax_ident')))) {
                if (!isPostRequestElementSet('company')) {
                        // Company name is empty
-                       $formErrors[] = '{--SPONSOR_COMPANY_EMPTY--}';
+                       array_push($formErrors, '{--SPONSOR_COMPANY_EMPTY--}');
                } elseif (!isPostRequestElementSet('tax_ident')) {
                        // Tax ident number name is empty
-                       $formErrors[] = '{--SPONSOR_TAX_IDENT_EMPTY--}';
+                       array_push($formErrors, '{--SPONSOR_TAX_IDENT_EMPTY--}');
                }
 
                if (!isPostRequestElementSet('position')) {
                        // Not fatal but not nice: position in company is empty
-                       $formErrors[] = '{--SPONSOR_POSITION_EMPTY--}';
+                       array_push($formErrors, '{--SPONSOR_POSITION_EMPTY--}');
                } // END - if
        } // END - if
 
        // 3. Street and number
        if (!isPostRequestElementSet('street_nr1')) {
                // Street name and house number are empty
-               $formErrors[] = '{--SPONSOR_STREET_NR1_EMPTY--}';
+               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_EMPTY_2_NOT--}';
+               array_push($formErrors, '{--SPONSOR_STREET_NR1_EMPTY_2_NOT--}');
        }
 
        // 4. Country code
        if (!isPostRequestElementSet('country')) {
                // Country code is empty
-               $formErrors[] = '{--kSPONSOR_COUNTRY_EMPTY--}';
+               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 (!isPostRequestElementSet('zip')) {
                // ZIP code is empty
-               $formErrors[] = '{--SPONSOR_ZIP_EMPTY--}';
+               array_push($formErrors, '{--SPONSOR_ZIP_EMPTY--}');
        } elseif (bigintval(postRequestElement('zip')) != postRequestElement('zip')) {
                // ZIP is invalid
-               $formErrors[] = '{--SPONSOR_ZIP_IS_INVALID--}';
+               array_push($formErrors, '{--SPONSOR_ZIP_IS_INVALID--}');
                setPostRequestElement('zip', '');
        }
 
        // 4. City
        if (!isPostRequestElementSet('city')) {
                // City is empty
-               $formErrors[] = '{--SPONSOR_CITY_EMPTY--}';
+               array_push($formErrors, '{--SPONSOR_CITY_EMPTY--}');
        } // END - if
 
        // 5. Phone number
        if (!isPostRequestElementSet('phone')) {
                // City is empty
-               $formErrors[] = '{--SPONSOR_PHONE_EMPTY--}';
+               array_push($formErrors, '{--SPONSOR_PHONE_EMPTY--}');
        } // END - if
 
        // 6. Homepage URL
        if (!isPostRequestElementSet('url')) {
                // Homepage URL is empty
-               $formErrors[] = '{--SPONSOR_URL_EMPTY--}';
+               array_push($formErrors, '{--SPONSOR_URL_EMPTY--}');
        } elseif (!isUrlValid(postRequestElement('url'))) {
                // Homepage URL is invalid
-               $formErrors[] = '{--SPONSOR_URL_IS_INVALID--}';
+               array_push($formErrors, '{--SPONSOR_URL_IS_INVALID--}');
                setPostRequestElement('url', '');
        }
 
        // 7. Light validation of email address
        if ((!isPostRequestElementSet('email')) || (postRequestElement('email') == '@')) {
                // Email is invalid/empty
-               $formErrors[] = '{--SPONSOR_EMAIL_IS_INVALID--}';
+               array_push($formErrors, '{--SPONSOR_EMAIL_IS_INVALID--}');
        } elseif (isSponsorRegisteredWithEmail(postRequestElement('email'))) {
                // Email already found in database!
-               $formErrors[] = '{--SPONSOR_EMAIL_IS_ALREADY_REGISTERED--}';
+               array_push($formErrors, '{--SPONSOR_EMAIL_IS_ALREADY_REGISTERED--}');
                setPostRequestElement('email', '');
        }
 
        // 8. Pay type selected?
        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 (!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 (!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 (((!isPostRequestElementSet('pass1')) || (!isPostRequestElementSet('pass2'))) || ((postRequestElement('pass1') != postRequestElement('pass2')) && (isPostRequestElementSet('pass1')) && (isPostRequestElementSet('pass2')))) {
-               if ((postRequestElement('pass1') != postRequestElement('pass2')) && (isPostRequestElementSet('pass1')) && (isPostRequestElementSet('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 (!isPostRequestElementSet('pass1')) {
+                       if (!isPostRequestElementSet('password1')) {
                                // Password 1 is empty
-                               $formErrors[] = '{--SPONSOR_PASSWORD1_EMPTY--}';
+                               array_push($formErrors, '{--SPONSOR_PASSWORD1_EMPTY--}');
                        }
 
-                       if (!isPostRequestElementSet('pass2')) {
+                       if (!isPostRequestElementSet('password2')) {
                                // Password 2 is empty
-                               $formErrors[] = '{--SPONSOR_PASSWORD2_EMPTY--}';
+                               array_push($formErrors, '{--SPONSOR_PASSWORD2_EMPTY--}');
                        }
                }
-       } elseif (strlen(postRequestElement('pass1')) < getPassLen()) {
+       } 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 (!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) unsetPostRequestElement('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,7 +200,7 @@ if ((isFormSent()) && (count($formErrors) == 0)) {
        );
 
        // Calulate points
-       $result = SQL_QUERY_ESC('SELECT
+       $result = sqlQueryEscaped('SELECT
        (`pay_rate` * `pay_min_count`) AS `points`,
        `pay_min_count`,
        `pay_currency`
@@ -215,10 +210,10 @@ WHERE
        `id`=%s
 LIMIT 1',
                array(postRequestElement('pay_type')), __FILE__, __LINE__);
-       list($points, $pay, $curr) = SQL_FETCHROW($result);
+       list($points, $pay, $curr) = sqlFetchRow($result);
 
        // Free memory
-       SQL_FREERESULT($result);
+       sqlFreeResult($result);
 
        // Add points to array
        postRequestElement('points_amount', $points);
@@ -233,25 +228,30 @@ LIMIT 1',
        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) {
@@ -259,7 +259,7 @@ 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]    = postRequestElement($entry);
@@ -274,8 +274,8 @@ ORDER BY
                        $OUT = '';
 
                        // Errors found?
-                       if (count($formErrors) > 0) {
-                               $OUT = displayMessage('{--SPONSOR_REGISTER_SOMETHING_MISSING--}', true);
+                       if (isFilledArray($formErrors)) {
+                               $OUT = returnMessage('{--SPONSOR_REGISTER_SOMETHING_MISSING--}');
                                $OUT .= '<ol>';
                                foreach ($formErrors as $error) {
                                        $OUT .= '<li>' . $error . '</li>';
@@ -286,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 ((isPostRequestElementSet('refid')) && (isValidUserId(postRequestElement('refid')))) {
-                               // Transfer referal id
+                       // 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
                displayMessage('{--SPONSOR_PAYMENT_LIST_EMPTY--}');
        }
 
        // Free memory
-       SQL_FREERESULT($result);
+       sqlFreeResult($result);
 }
 
 // [EOF]