X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_cats.php;h=7d6556fc90c3233c26bfd6c501f16ac893ffeb20;hb=d016e24dd4686f613a17733b96bc28fac936a4ac;hp=239af59c82d641762e1cb5e076f5875903007e2c;hpb=6c763653e88b9d10627e651ca59c7201d4b7d62b;p=mailer.git

diff --git a/inc/modules/admin/what-list_cats.php b/inc/modules/admin/what-list_cats.php
index 239af59c82..7d6556fc90 100644
--- a/inc/modules/admin/what-list_cats.php
+++ b/inc/modules/admin/what-list_cats.php
@@ -43,7 +43,7 @@ ADD_DESCR("admin", __FILE__);
 
 if (!empty($_GET['u_id'])) {
 	// Check if the user already exists
-	$result = SQL_QUERY_ESC("SELECT surname, family, email FROM `"._MYSQL_PREFIX."_user_data` WHERE userid=%s LIMIT 1",
+	$result = SQL_QUERY_ESC("SELECT surname, family, email FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
 	 array(bigintval($_GET['u_id'])), __FILE__, __LINE__);
 	if (SQL_NUMROWS($result) == 1) {
 		// Loads surname, family's name and the email address
@@ -51,25 +51,25 @@ if (!empty($_GET['u_id'])) {
 		SQL_FREERESULT($result);
 
 		// Prepare constants
-		define('__CATS_BASE'   , "<A href=\"".URL."/modules.php?module=admin&amp;u_id=");
+		define('__CATS_BASE'   , "<a href=\"{!URL!}/modules.php?module=admin&amp;u_id=");
 		define('__UID'         , bigintval($_GET['u_id']));
 		define('__MEMBER_LINKS', MEMBER_ACTION_LINKS(__UID));
-		define('__EMAIL'       , "<A href=\"".CREATE_EMAIL_LINK($email, "user_data")."\">".$sname." ".$fname."</A>");
+		define('__EMAIL'       , "<a href=\"".CREATE_EMAIL_LINK($email, "user_data")."\">".$sname." ".$fname."</a>");
 
 		// Ok, list categories of this user
-		$result_cats = SQL_QUERY("SELECT id, cat FROM "._MYSQL_PREFIX."_cats ORDER BY sort", __FILE__, __LINE__);
+		$result_cats = SQL_QUERY("SELECT id, cat FROM `{!_MYSQL_PREFIX!}_cats` ORDER BY `sort`", __FILE__, __LINE__);
 
 		if (SQL_NUMROWS($result_cats) > 0) {
 			// List categories
 			$cnt = "1"; $SW = 2; $OUT = "";
 			while (list($cid, $cat) = SQL_FETCHROW($result_cats)) {
 				// Check user's selection
-				$result_user = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_user_cats WHERE userid=%s AND cat_id=%s LIMIT 1",
+				$result_user = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_user_cats` WHERE userid=%s AND cat_id=%s LIMIT 1",
 				 array(bigintval($_GET['u_id']), bigintval($cid)), __FILE__, __LINE__);
 
 				// Set selection
-				$SELECTED = "<FONT color=\"red\">".NO."</FONT>";
-				if (SQL_NUMROWS($result_user) == 1) $SELECTED = "<FONT color=\"green\">".YES."</FONT>";
+				$SELECTED = "<font color=\"red\">{--NO--}</div>";
+				if (SQL_NUMROWS($result_user) == 1) $SELECTED = "<font color=\"green\">{--YES--}</div>";
 
 				// Prepare array for the row template
 				$content = array(
@@ -96,7 +96,7 @@ if (!empty($_GET['u_id'])) {
 		}
 	} else {
 		// User not found
-		LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_MEMBER_404_1.__UID.ADMIN_MEMBER_404_2);
+		LOAD_TEMPLATE("admin_settings_saved", false, sprintf(getMessage('ADMIN_MEMBER_404'), constant('__UID')));
 	}
 } else {
 	// Output selection form with all confirmed user accounts listed