This query got broken on rewrite phase

diff --git a/inc/libs/register_functions.php b/inc/libs/register_functions.php
index 35a790ae7f84c3fe1cc8144847923c22b49dbc3c..7dddc8fb29687fafbc6483cb886e8b0a736d40a2 100644 (file)
--- a/inc/libs/register_functions.php
+++ b/inc/libs/register_functions.php
@@ -255,17 +255,13 @@ function isRegistrationDataComplete () {
 
 // Do the registration
 function doRegistration () {
-       // Prepapre month and day of birth
-       if (strlen(postRequestElement('day'))   == 1) setPostRequestElement('day'  , '0' . postRequestElement('day'));
-       if (strlen(postRequestElement('month')) == 1) setPostRequestElement('month', '0' . postRequestElement('month'));
-
        // Generate hash which will be inserted into confirmation mail
        $hash = generateHash(sha1(
                // Get total confirmed, ...
                getTotalConfirmedUser() . getEncryptSeparator() .
                // ... unconfirmed ...
                getTotalUnconfirmedUser() . getEncryptSeparator() .
-               // ... and locked users!
+               // ... and locked users
                getTotalLockedUser() . getEncryptSeparator() .
                postRequestElement('month') . '-' .
                postRequestElement('day') . '-' .
@@ -285,10 +281,10 @@ function doRegistration () {
        // Add design when extension ext-theme is v0.0.8 or greater
        // @TODO Rewrite these all to a single filter
        $GLOBALS['register_sql_columns'] = '';
-       $GLOBALS['register_sql_data'] = '';
+       $GLOBALS['register_sql_data']    = '';
        if (isExtensionInstalledAndNewer('theme', '0.0.8')) {
                // Okay, add design here
-               $GLOBALS['register_sql_columns'] .= ',`curr_theme`';
+               $GLOBALS['register_sql_columns'] .= ', `curr_theme`';
                $GLOBALS['register_sql_data']    .= ", '{%%pipe,getCurrentTheme%%}'";
        } // END - if
 
@@ -296,13 +292,13 @@ function doRegistration () {
        //
        // First comes first: begging rallye
        if ((isExtensionInstalledAndNewer('beg', '0.2.7')) && (!isBegNewMemberNotifyEnabled())) {
-               $GLOBALS['register_sql_columns'] .= ',`beg_rallye_enable_notify`,`beg_rallye_disable_notify`';
+               $GLOBALS['register_sql_columns'] .= ', `beg_rallye_enable_notify`, `beg_rallye_disable_notify`';
                $GLOBALS['register_sql_data']    .= ', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()';
        } // END - if
 
        // Second: active rallye
        if ((isExtensionActive('bonus')) && (!isBonusNewMemberNotifyEnabled())) {
-               $GLOBALS['register_sql_columns'] .= ',`bonus_rallye_enable_notify`,`bonus_rallye_disable_notify`';
+               $GLOBALS['register_sql_columns'] .= ', `bonus_rallye_enable_notify`, `bonus_rallye_disable_notify`';
                $GLOBALS['register_sql_data']    .= ', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()';
        } // END - if
 
@@ -340,10 +336,10 @@ function doRegistration () {
        `ref_payout`
        ".$GLOBALS['register_sql_columns']."
 ) VALUES (
-       '%s'
-       '%s'
-       '%s'
-       '%s'
+       '%s',
+       '%s',
+       '%s',
+       '%s',
        '%s',
        %s,
        '%s',