X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-chk_regs.php;h=b563cfe848ab1875892ecf59c025a3d5c8a4a5b2;hb=9e604ce404fe7d2d8dafc259a5fb8cd826aec5e6;hp=bbdf02305a70f6c1df30a29aaac9143af406353e;hpb=5dfaf0ed80b30f53574a8866858d3e7cf05ce325;p=mailer.git
diff --git a/inc/modules/admin/what-chk_regs.php b/inc/modules/admin/what-chk_regs.php
index bbdf02305a..b563cfe848 100644
--- a/inc/modules/admin/what-chk_regs.php
+++ b/inc/modules/admin/what-chk_regs.php
@@ -10,7 +10,12 @@
* -------------------------------------------------------------------- *
* Kurzbeschreibung : Neue Anmeldungen pruefen *
* -------------------------------------------------------------------- *
- * *
+ * $Revision:: $ *
+ * $Date:: $ *
+ * $Tag:: 0.2.1-FINAL $ *
+ * $Author:: $ *
+ * Needs to be in all Files and every File needs "svn propset *
+ * svn:keywords Date Revision" (autoprobset!) at least!!!!!! *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2008 by Roland Haeder *
* For more information visit: http://www.mxchange.org *
@@ -32,37 +37,43 @@
************************************************************************/
// Some security stuff...
-if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!IS_ADMIN()))
-{
- $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
+if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
+ $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php';
require($INC);
}
// Add description as navigation point
-ADD_DESCR ("admin", basename(__FILE__));
+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__);
-OPEN_TABLE("100%", "admin_content admin_content_align", "");
-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))
- {
- if ($ref > 0) $ref = ADMIN_USER_PROFILE_LINK($ref);
+ $OUT = ''; $SW = 2;
+ while ($content = SQL_FETCHARRAY($result)) {
+ // Add link to refid
+ if ($content['refid'] > 0) $content['refid'] = generateUserProfileLink($content['refid']);
+
// Prepare array for the row template
+ // @TODO Rewritings: sname->surname,fname->family,ip->REMOTE_ADDR,ref->refid,hash->user_hash in 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' => translateGender($content['gender']),
+ 'sname' => $content['surname'],
+ 'fname' => $content['family'],
+ 'email' => "".$content['email']."",
+ 'ip' => $content['REMOTE_ADDR'],
+ 'ref' => $content['refid'],
+ 'hash' => $content['user_hash'],
+ 'link' => generateUserProfileLink($content['userid']),
);
// Load row template and switch color
@@ -70,18 +81,19 @@ if (SQL_NUMROWS($query) > 0)
$SW = 3 - $SW;
}
- // Free memory
- SQL_FREERESULT($query);
+ // Remember rows
+ // @TODO Rewrite this constant
define('__REG_ROWS', $OUT);
// Load main template
LOAD_TEMPLATE("admin_reg");
-}
- else
-{
+} else {
// No registrations left - or all has confirmed their email address... :-)
- LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_ALL_CONFIRMED_EMAIL);
+ LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_ALL_CONFIRMED_EMAIL'));
}
-CLOSE_TABLE();
+
+// Free memory
+SQL_FREERESULT($result);
+
//
?>