X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-html_mail.php;h=07e592301c1f345e0dfb032aa14c8b2960a90dd7;hp=0e19e054a65b8fbda7d1381a52cad448a13970e6;hb=d1637dad0b2ca0e5fb411ee0843f01bfb4cc94e0;hpb=3afdce4fe00b4af570122ce7b8158ced44aec7d3

diff --git a/inc/modules/member/what-html_mail.php b/inc/modules/member/what-html_mail.php
index 0e19e054a6..07e592301c 100644
--- a/inc/modules/member/what-html_mail.php
+++ b/inc/modules/member/what-html_mail.php
@@ -43,7 +43,7 @@ if (!defined('__SECURITY')) {
 } elseif (!IS_MEMBER()) {
 	redirectToUrl('modules.php?module=index');
 } elseif ((!EXT_IS_ACTIVE('html_mail')) && (!IS_ADMIN())) {
-	addFatalMessage(__FILE__, __LINE__, sprintf(getMessage('EXTENSION_PROBLEM_EXT_INACTIVE'), 'html_mail'));
+	addFatalMessage(__FILE__, __LINE__, generateExtensionInactiveNotInstalledMessage('html_mail'));
 	return;
 }
 
@@ -53,25 +53,32 @@ ADD_DESCR('member', __FILE__);
 // Class was found and loaded
 if (isFormSent()) {
 	// Save settings
-	SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET `html`='%s' WHERE userid=%s LIMIT 1",
-	array(REQUEST_POST('html'), getUserId()), __FILE__, __LINE__);
+	SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET `html`='%s' WHERE `userid`=%s LIMIT 1",
+		array(REQUEST_POST('html'), getUserId()), __FILE__, __LINE__);
 	LOAD_TEMPLATE('admin_settings_saved', false, getMessage('MEMBER_SETTINGS_SAVED'));
 } else {
 	// Load template for changing settings
-	$result = SQL_QUERY_ESC("SELECT html FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
-	array(getUserId()), __FILE__, __LINE__);
-	list($mode) = SQL_FETCHROW($result);
+	$result = SQL_QUERY_ESC("SELECT `html` FROM `{!_MYSQL_PREFIX!}_user_data` WHERE `userid`=%s LIMIT 1",
+		array(getUserId()), __FILE__, __LINE__);
+
+	// Get the mode
+	$content = SQL_FETCHARRAY($result);
+
+	// Free result
 	SQL_FREERESULT($result);
 
-	if ($mode == 'Y') {
-		define('HTML_Y', ' checked="checked"');
-		define('HTML_N', '');
+	// Prepare it
+	if ($content['html'] == 'Y') {
+		$content['html_y'] = ' checked="checked"';
+		$content['html_n'] = '');
 	} else {
-		define('HTML_N', ' checked="checked"');
-		define('HTML_Y', '');
+		$content['html_n'] = ' checked="checked"';
+		$content['html_y'] = '';
 	}
-	LOAD_TEMPLATE("member_html_mail_settings");
+
+	// Load main template
+	LOAD_TEMPLATE('member_html_mail_settings');
 }
 
-//
+// [EOF]
 ?>