From a74cbdf4f8838f216ebb1a201943575177ffe9a5 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Roland=20H=C3=A4der?= Date: Sun, 29 Aug 2010 17:46:38 +0000 Subject: [PATCH] Aliasing should be avoided, better we rename the column or/and use direct column names --- inc/modules/member/what-unconfirmed.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/inc/modules/member/what-unconfirmed.php b/inc/modules/member/what-unconfirmed.php index ffa88d7eac..88baece6e6 100644 --- a/inc/modules/member/what-unconfirmed.php +++ b/inc/modules/member/what-unconfirmed.php @@ -51,7 +51,7 @@ addMenuDescription('member', __FILE__); if ((isGetRequestParameterSet('bonusid')) && (isExtensionActive('bonus'))) { // Display bonus mail by loading it's full data $result_data = SQL_QUERY_ESC("SELECT - `id`, `subject`, `timestamp`, `cat_id` AS `category`, `points`, `text`, `is_notify`, `data_type`, `time`, `url` + `id`, `subject`, `timestamp`, `cat_id`, `points`, `text`, `is_notify`, `data_type`, `time`, `url` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE -- 2.39.5