Typo in naming a database column fixed
authorRoland Häder <roland@mxchange.org>
Fri, 5 Aug 2011 08:50:09 +0000 (08:50 +0000)
committerRoland Häder <roland@mxchange.org>
Fri, 5 Aug 2011 08:50:09 +0000 (08:50 +0000)
inc/extensions/ext-earning.php
inc/libs/earning_functions.php
inc/modules/member/what-earning.php

index 52f103d..8f4b944 100644 (file)
@@ -76,7 +76,7 @@ UNIQUE `earning_group_name` (`earning_group`,`earning_provider`)",
 `earning_userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `earning_active` ENUM('Y','N') NOT NULL DEFAULT 'Y',
 `earning_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
-`earning_cancelled` TIMESTAMP NULL DEFAULT NULL,
+`earning_canceled` TIMESTAMP NULL DEFAULT NULL,
 `earning_daily_amount` SMALLINT(7) NOT NULL DEFAULT 0,
 `earning_current_amount` SMALLINT(7) NOT NULL DEFAULT 0,
 `earning_points` FLOAT(20,5) NOT NULL DEFAULT 0.00000,
index b0300db..5773ee4 100644 (file)
@@ -153,7 +153,7 @@ function updateMemberEarning ($earningId, $dailyAmount, $isActive = 'Y') {
        // Does the user cancel the earning?
        if ($isActive == 'N') {
                // Then update cancellation timestamp as well
-               $moreSql = ', `earning_cancelled`=NOW()';
+               $moreSql = ', `earning_canceled`=NOW()';
        } // END - if
 
        // Update database record
index 27c2a9a..28af0bc 100644 (file)
@@ -76,7 +76,7 @@ if (SQL_NUMROWS($result) > 0) {
                $result2 = SQL_QUERY_ESC('SELECT
        u.`earning_active`,
        UNIX_TIMESTAMP(u.`earning_added`) AS `earning_added`,
-       UNIX_TIMESTAMP(u.`earning_cancelled`) AS `earning_cancelled`,
+       UNIX_TIMESTAMP(u.`earning_canceled`) AS `earning_canceled`,
        u.`earning_daily_amount`,
        u.`earning_points`
 FROM