X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-chk_regs.php;h=234d0029c7fa506e0b16819f9873c748f6ea5afd;hb=22a33b87f9894a94efb71de7630f12129e34f83b;hp=e178a6d173a27ba98286e397f86aa40b5a78cf30;hpb=6032b7018b83778f1592383238f4e0d28f718622;p=mailer.git
diff --git a/inc/modules/admin/what-chk_regs.php b/inc/modules/admin/what-chk_regs.php
index e178a6d173..234d0029c7 100644
--- a/inc/modules/admin/what-chk_regs.php
+++ b/inc/modules/admin/what-chk_regs.php
@@ -32,8 +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);
}
@@ -42,24 +41,27 @@ if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!IS_ADMIN()))
ADD_DESCR ("admin", basename(__FILE__));
// Check for accounts
-$query = SQL_QUERY("SELECT userid, sex, surname, family, email, REMOTE_ADDR, refid, user_hash FROM "._MYSQL_PREFIX."_user_data WHERE status='UNCONFIRMED' ORDER BY userid", __FILE__, __LINE__);
+$result = SQL_QUERY("SELECT userid, gender, surname, family, email, REMOTE_ADDR, refid, user_hash
+FROM `"._MYSQL_PREFIX."_user_data`
+WHERE status='UNCONFIRMED'
+ORDER BY userid ASC", __FILE__, __LINE__);
-if (SQL_NUMROWS($query) > 0) {
+if (SQL_NUMROWS($result) > 0) {
// We have some (new?) registrations!
$SW = 2; $OUT = "";
- while (list($uid, $sex, $sname, $fname, $email, $IP, $ref, $hash) = SQL_FETCHROW($query)) {
+ while (list($uid, $gender, $sname, $fname, $email, $IP, $ref, $hash) = SQL_FETCHROW($result)) {
if ($ref > 0) $ref = ADMIN_USER_PROFILE_LINK($ref);
// Prepare array for the row template
$content = array(
- 'sw' => $SW,
- 'sex' => TRANSLATE_SEX($sex),
- 'sname' => $sname,
- 'fname' => $fname,
- 'email' => "".$email."",
- 'ip' => $IP,
- 'ref' => $ref,
- 'hash' => $hash,
- 'link' => ADMIN_USER_PROFILE_LINK($uid),
+ 'sw' => $SW,
+ 'gender' => TRANSLATE_GENDER($gender),
+ 'sname' => $sname,
+ 'fname' => $fname,
+ 'email' => "".$email."",
+ 'ip' => $IP,
+ 'ref' => $ref,
+ 'hash' => $hash,
+ 'link' => ADMIN_USER_PROFILE_LINK($uid),
);
// Load row template and switch color
@@ -67,8 +69,7 @@ if (SQL_NUMROWS($query) > 0) {
$SW = 3 - $SW;
}
- // Free memory
- SQL_FREERESULT($query);
+ // Remember rows
define('__REG_ROWS', $OUT);
// Load main template
@@ -78,5 +79,8 @@ if (SQL_NUMROWS($query) > 0) {
LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_ALL_CONFIRMED_EMAIL);
}
+// Free memory
+SQL_FREERESULT($result);
+
//
?>