X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fmodules%2Fadmin%2Fwhat-list_unconfirmed.php;h=85b939cc8002858e8b06d1beca0480636987533f;hb=56156f6c4392510cdbe0eb4f2ccefc23b43e2672;hp=5b7b11dcfee94a70e61683b51d8673250e41d999;hpb=7f104f6fe558bb56b4205241435a2357c2feece1;p=mailer.git
diff --git a/inc/modules/admin/what-list_unconfirmed.php b/inc/modules/admin/what-list_unconfirmed.php
index 5b7b11dcfe..85b939cc80 100644
--- a/inc/modules/admin/what-list_unconfirmed.php
+++ b/inc/modules/admin/what-list_unconfirmed.php
@@ -36,12 +36,12 @@ if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
require($INC);
} elseif (!EXT_IS_ACTIVE("mailid")) {
- ADD_FATAL(sprintf(EXTENSION_PROBLEM_NOT_INSTALLED, "mailid"));
+ addFatalMessage(sprintf(EXTENSION_PROBLEM_NOT_INSTALLED, "mailid"));
return;
}
// Add description as navigation point
-ADD_DESCR("admin", basename(__FILE__));
+ADD_DESCR("admin", __FILE__);
// Don't load the admin_list_unconfirmed template by default
$listed = false;
@@ -109,10 +109,10 @@ if ($listed)
//
$result = SQL_QUERY_ESC("SELECT DISTINCT l.userid, u.status, u.surname, u.family, u.gender, u.email
FROM "._MYSQL_PREFIX."_user_links AS l
-LEFT JOIN "._MYSQL_PREFIX."_user_data AS u
+LEFT JOIN `"._MYSQL_PREFIX."_user_data` AS u
ON l.userid=u.userid
WHERE l.%s='%s' ORDER BY l.userid LIMIT %s",
- array($col, $ID, bigintval($max)),__FILE__, __LINE__);
+ array($col, $ID, bigintval($max)),__FILE__, __LINE__);
$unconfirmed = SQL_NUMROWS($result);
define('__LIST_UNCO_UNCONFIRMED', $unconfirmed);
@@ -130,7 +130,7 @@ WHERE l.%s='%s' ORDER BY l.userid LIMIT %s",
'uid' => $uid,
'link' => $LINK,
'id' => $ID,
- 'email' => "".TRANSLATE_GENDER($gender)." ".$sname." ".$fname."",
+ 'email' => "".TRANSLATE_GENDER($gender)." ".$sname." ".$fname."",
'status' => TRANSLATE_STATUS($status),
);