From f42e417c1cd63d07563965c54bf10f6e1cd4248f Mon Sep 17 00:00:00 2001 From: =?utf8?q?Roland=20H=C3=A4der?= Date: Wed, 28 Oct 2009 20:01:05 +0000 Subject: [PATCH] SQL fix and double->single --- inc/modules/member/what-bonus.php | 20 ++++++++++---------- 1 file changed, 10 insertions(+), 10 deletions(-) diff --git a/inc/modules/member/what-bonus.php b/inc/modules/member/what-bonus.php index 256f418a8c..a1058a34f7 100644 --- a/inc/modules/member/what-bonus.php +++ b/inc/modules/member/what-bonus.php @@ -54,16 +54,16 @@ if ((!isExtensionActive('bonus')) && (!isAdmin())) { if (getExtensionVersion('bonus') >= '0.6.9') { // Add more bonus points here // @TODO Rewrite this to a filter - $USE = "(0"; - if (getConfig('bonus_click_yn') == 'Y') $USE .= " + turbo_bonus"; - if (getConfig('bonus_login_yn') == 'Y') $USE .= " + login_bonus"; - if (getConfig('bonus_order_yn') == 'Y') $USE .= " + bonus_order"; - if (getConfig('bonus_stats_yn') == 'Y') $USE .= " + bonus_stats"; - if (getConfig('bonus_ref_yn') == 'Y') $USE .= " + bonus_ref"; - $USE .= ")"; + $USE = '(0'; + if (getConfig('bonus_click_yn') == 'Y') $USE .= ' + `turbo_bonus`'; + if (getConfig('bonus_login_yn') == 'Y') $USE .= ' + `login_bonus`'; + if (getConfig('bonus_order_yn') == 'Y') $USE .= ' + `bonus_order`'; + if (getConfig('bonus_stats_yn') == 'Y') $USE .= ' + `bonus_stats`'; + if (getConfig('bonus_ref_yn') == 'Y') $USE .= ' + `bonus_ref`'; + $USE .= ')'; } else { // Old version ??? - $USE = "turbo_bonus"; + $USE = '`turbo_bonus`'; } // Autopurge installed? @@ -76,11 +76,11 @@ if (isExtensionActive('autopurge')) { // Let's check if there are some points left we can 'pay'... $result = SQL_QUERY_ESC("SELECT - `userid`, `".$USE."` AS points, `last_online` + `userid`, ".$USE." AS points, `last_online` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE - `".$USE."` > 0 AND `status`='CONFIRMED'".$lastOnline." + ".$USE." > 0 AND `status`='CONFIRMED'".$lastOnline." ORDER BY `points` DESC, last_online DESC, -- 2.39.2