X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fmodules%2Fadmin%2Fwhat-list_unconfirmed.php;h=729cbe8bd82f3da7cc3481b95b764fd96371d519;hb=f01652b7b8efac92d97889e312402c4a845c2f14;hp=7fe2287fa09dd131b08dead4f3d7df942b2a861a;hpb=541d2d03d7fac53d38b5d4236d1c35fb5f1f526b;p=mailer.git diff --git a/inc/modules/admin/what-list_unconfirmed.php b/inc/modules/admin/what-list_unconfirmed.php index 7fe2287fa0..729cbe8bd8 100644 --- a/inc/modules/admin/what-list_unconfirmed.php +++ b/inc/modules/admin/what-list_unconfirmed.php @@ -107,7 +107,7 @@ 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 ON l.userid=u.userid @@ -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), );