X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_unconfirmed.php;h=86bf30742befc4f04b25fa159dbd4629d5acab05;hp=1c763694f52bbb4d87af433f5f46d851241c6ca9;hb=89c00e43d2ce1dd1afe11c2c8485307342805f97;hpb=43885129ac24cee5545a8a5ad51e90aa182fdf46
diff --git a/inc/modules/admin/what-list_unconfirmed.php b/inc/modules/admin/what-list_unconfirmed.php
index 1c763694f5..86bf30742b 100644
--- a/inc/modules/admin/what-list_unconfirmed.php
+++ b/inc/modules/admin/what-list_unconfirmed.php
@@ -32,7 +32,7 @@
************************************************************************/
// Some security stuff...
-if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!IS_ADMIN())) {
+if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
require($INC);
} elseif (!EXT_IS_ACTIVE("mailid")) {
@@ -41,7 +41,7 @@ if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!IS_ADMIN())) {
}
// 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;
@@ -96,7 +96,7 @@ if ($listed)
// Transfer data to constants for the template
if (($stats_id > 0) && ($ID == "-1")) $ID = $stats_id;
- if ($col == "bonus_id") $sender = "0";
+ if ($col == "bonus_id") $sender = 0;
define('__LIST_UNCON_SENDER' , $sender);
define('__LIST_UNCON_SUBJECT', COMPILE_CODE($subj));
define('__LIST_UNCON_TEXT' , COMPILE_CODE($text));
@@ -107,12 +107,12 @@ if ($listed)
// but it does only show unconfirmed mail links from existing user
// accounts. So if you have delete one you did not see those links
//
- $result = SQL_QUERY_ESC("SELECT DISTINCT l.userid, u.status, u.surname, u.family, u.sex, u.email
+ $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);
@@ -121,7 +121,7 @@ WHERE l.%s='%s' ORDER BY l.userid LIMIT %s",
// At least one link left to confirm
$OUT = LOAD_TEMPLATE("admin_list_unconfirmed_header", true);
$SW = 2;
- while(list($uid, $status, $sname, $fname, $sex, $email) = SQL_FETCHROW($result))
+ while(list($uid, $status, $sname, $fname, $gender, $email) = SQL_FETCHROW($result))
{
// Prepare data for the row template
$content = array(
@@ -130,7 +130,7 @@ WHERE l.%s='%s' ORDER BY l.userid LIMIT %s",
'uid' => $uid,
'link' => $LINK,
'id' => $ID,
- 'email' => "".TRANSLATE_SEX($sex)." ".$sname." ".$fname."",
+ 'email' => "".TRANSLATE_GENDER($gender)." ".$sname." ".$fname."",
'status' => TRANSLATE_STATUS($status),
);