X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-newsletter.php;h=cfb079145b69bd84f5587688e9a43a6ec099db7e;hb=66b91ce490ab549425619c95fc12086e126d541b;hp=2d83f42f3a5785e50cbcfe8c23a7526b528fee76;hpb=b8aa17b98b99c27eafbdca0fa090bae63527da9a;p=mailer.git

diff --git a/inc/modules/member/what-newsletter.php b/inc/modules/member/what-newsletter.php
index 2d83f42f3a..cfb079145b 100644
--- a/inc/modules/member/what-newsletter.php
+++ b/inc/modules/member/what-newsletter.php
@@ -51,8 +51,8 @@ if (!defined('__SECURITY')) {
 ADD_DESCR('member', __FILE__);
 
 // Load status
-$result = SQL_QUERY_ESC("SELECT nl_receive, nl_until, nl_timespan FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
-array(getUserId()), __FILE__, __LINE__);
+$result = SQL_QUERY_ESC("SELECT `nl_receive`, `nl_until`, `nl_timespan` FROM `{!_MYSQL_PREFIX!}_user_data` WHERE `userid`=%s LIMIT 1",
+	array(getUserId()), __FILE__, __LINE__);
 list($status, $until, $span) = SQL_FETCHROW($result);
 SQL_FREERESULT($result);
 
@@ -62,7 +62,7 @@ define('__CHARGE_VALUE', translateComma(getConfig('nl_charge')));
 if ((isFormSent()) && ($status == 'Y') && ($span == '0')) {
 	// Save request
 	SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET nl_timespan='".(getConfig('one_day') * 30)."' WHERE userid=%s LIMIT 1",
-	array(getUserId()), __FILE__, __LINE__);
+		array(getUserId()), __FILE__, __LINE__);
 
 	// Load admin message
 	$admin_msg = LOAD_EMAIL_TEMPLATE('admin_newsletter_request', array(), getUserId());