From 9b06a0b9b72fbdaf5bf638df82ae37c56a5654cb Mon Sep 17 00:00:00 2001 From: =?utf8?q?Roland=20H=C3=A4der?= Date: Fri, 5 Aug 2011 08:50:09 +0000 Subject: [PATCH] Typo in naming a database column fixed --- inc/extensions/ext-earning.php | 2 +- inc/libs/earning_functions.php | 2 +- inc/modules/member/what-earning.php | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) diff --git a/inc/extensions/ext-earning.php b/inc/extensions/ext-earning.php index 52f103d50b..8f4b944e79 100644 --- a/inc/extensions/ext-earning.php +++ b/inc/extensions/ext-earning.php @@ -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, diff --git a/inc/libs/earning_functions.php b/inc/libs/earning_functions.php index b0300dbcf0..5773ee4422 100644 --- a/inc/libs/earning_functions.php +++ b/inc/libs/earning_functions.php @@ -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 diff --git a/inc/modules/member/what-earning.php b/inc/modules/member/what-earning.php index 27c2a9a3ae..28af0bce9e 100644 --- a/inc/modules/member/what-earning.php +++ b/inc/modules/member/what-earning.php @@ -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 -- 2.30.2