Admin user details extended, DEBUG_LOG() rewritten, random userid on refid=0 added

[mailer.git] / inc / modules / admin / what-list_user.php

diff --git a/inc/modules/admin/what-list_user.php b/inc/modules/admin/what-list_user.php
index ce84588bad234c8522f61b612152a6f4bf5621e7..9ecd2c4ee8776fa10390a95567128125e465a183 100644 (file)
--- a/inc/modules/admin/what-list_user.php
+++ b/inc/modules/admin/what-list_user.php
@@ -54,9 +54,19 @@ if (!empty($_GET['mode'])) {
 // Remember it
 define('__TITLE', $listHeader);
 
 // Remember it
 define('__TITLE', $listHeader);
 

-$MORE = ", userid"; $colspan = "4"; //                 27
+// Init variables
+$MORE = ", userid"; $colspan = "4";
+
+// Add nickname if extension is found&active

 if (EXT_IS_ACTIVE("nickname")) { $MORE = ", nickname"; }
 
 if (EXT_IS_ACTIVE("nickname")) { $MORE = ", nickname"; }
 

+// Add random confirmed if extension version matches
+if (GET_EXT_VERSION("user") >= "0.3.4") {
+       // Add it...
+       $MORE .= ", rand_confirmed";
+} // END - if
+
+// Init unset data (bad that we change $_GET here!)

 if (empty($_GET['letter'])) { $_GET['letter'] = _ALL2;    }
 if (empty($_GET['sortby'])) { $_GET['sortby'] = "userid"; }
 if (empty($_GET['page']))   { $_GET['page']   = "1";      }
 if (empty($_GET['letter'])) { $_GET['letter'] = _ALL2;    }
 if (empty($_GET['sortby'])) { $_GET['sortby'] = "userid"; }
 if (empty($_GET['page']))   { $_GET['page']   = "1";      }


@@ -68,57 +78,80 @@ if (!empty($_GET['u_id'])) {
        // Secure the user ID
        $uid = bigintval($_GET['u_id']);
 
        // Secure the user ID
        $uid = bigintval($_GET['u_id']);
 

-       // Does the account exists?        0      1        2         3       4     5      6       7         8          9          10           11           12         13     14         15           16          17            18           19           20           21        22        23             24              25         26
-       $result = SQL_QUERY_ESC("SELECT gender, surname, family, street_nr, zip, city, country, email, birth_day, birth_month, birth_year, max_mails, receive_mails, refid, status, REMOTE_ADDR, last_online, last_module, ref_clicks, total_logins, used_points, emails_sent, joined, last_update, last_profile_sent, notified, ref_payout".$MORE."
+       // Does the account exists?
+       $result_user = SQL_QUERY_ESC("SELECT gender, surname, family, street_nr, zip, city, country, email, birth_day, birth_month, birth_year, max_mails, receive_mails, refid, status, REMOTE_ADDR, last_online, last_module, ref_clicks, total_logins, used_points, emails_sent, joined, last_update, last_profile_sent, notified, ref_payout, emails_received, mails_confirmed".$MORE."

 FROM "._MYSQL_PREFIX."_user_data
 FROM "._MYSQL_PREFIX."_user_data

-WHERE userid=%s LIMIT 1",
-        array($uid), __FILE__, __LINE__);
-       if (SQL_NUMROWS($result) == 1) {
+WHERE userid=%s
+LIMIT 1",
+               array($uid), __FILE__, __LINE__);
+       if (SQL_NUMROWS($result_user) == 1) {

                // Account found!
                // Account found!

-               $DATA  = SQL_FETCHROW($result);
-               SQL_FREERESULT($result);
+               $DATA  = SQL_FETCHARRAY($result_user);

 
 

+               // Get count/sum of refs, selected categories, unconfirmed mails

                $REFS  = GET_TOTAL_DATA($uid, "refsystem", "counter");
                $CATS  = GET_TOTAL_DATA($uid, "user_cats", "id", "userid", true);
                $LINKS = GET_TOTAL_DATA($uid, "user_links", "id", "userid", true);
 
                $REFS  = GET_TOTAL_DATA($uid, "refsystem", "counter");
                $CATS  = GET_TOTAL_DATA($uid, "user_cats", "id", "userid", true);
                $LINKS = GET_TOTAL_DATA($uid, "user_links", "id", "userid", true);
 

+               // Add links to the numbers

                if ($LINKS > 0) $LINKS = $BASE."&amp;what=list_links&amp;u_id=".$uid."\">".$LINKS."</A>]";
                if ($LINKS > 0) $LINKS = $BASE."&amp;what=list_links&amp;u_id=".$uid."\">".$LINKS."</A>]";

-               if ($DATA[13] > 0) $DATA[13] = str_replace(("u_id=".$uid), ("u_id=".$DATA[13]), $BASE."&amp;what=list_user\">".$DATA[13]."</A>]");
-               if (empty($DATA[17])) $DATA[17] = "---";
+               if ($DATA['refid'] > 0) $DATA['refid'] = $BASE."&amp;what=list_user&amp;u_id=".$DATA['refid']."\">".$DATA['refid']."</A>]";
+               if (empty($DATA['last_module'])) $DATA['last_module'] = "---";

                if ($REFS > 0) $REFS = $BASE."&amp;what=list_refs&amp;u_id=".$uid."\">".$REFS."</A>]";
                if ($CATS > 0) $CATS = $BASE."&amp;what=list_cats&amp;u_id=".$uid."\">".$CATS."</A>]";
 
                // Prepare data for template
                if ($REFS > 0) $REFS = $BASE."&amp;what=list_refs&amp;u_id=".$uid."\">".$REFS."</A>]";
                if ($CATS > 0) $CATS = $BASE."&amp;what=list_cats&amp;u_id=".$uid."\">".$CATS."</A>]";
 
                // Prepare data for template

-               define('_BIRTHDAY', MAKE_DATETIME(mktime(0, 0, 0, $DATA[9], $DATA[8], $DATA[10]), "3"));
+               define('_BIRTHDAY', MAKE_DATETIME(mktime(0, 0, 0, $DATA['birth_month'], $DATA['birth_day'], $DATA['birth_year']), "3"));

                define('_REFS' , $REFS);
                define('_CATS' , $CATS);
                define('_LINKS', $LINKS);
                define('_REFS' , $REFS);
                define('_CATS' , $CATS);
                define('_LINKS', $LINKS);

-               define('_ADMIN_LINKS', MEMBER_ACTION_LINKS($uid, $DATA[14]));
-               $DATA[0]      = TRANSLATE_GENDER($DATA[0]);
-               $DATA[28]     = CREATE_EMAIL_LINK($DATA[7], "user_data");
-               $DATA[14]     = TRANSLATE_STATUS($DATA[14]);
-               $DATA[16]     = MAKE_DATETIME($DATA[16], "0");
-               $DATA[20]     = TRANSLATE_COMMA($DATA[20]);
-               if ($DATA[21] > 0) $DATA[21] = $BASE."&amp;what=email_details&amp;u_id=".$uid."\">".TRANSLATE_COMMA($DATA[21])."</A>]";
-               $DATA[22]     = MAKE_DATETIME($DATA[22], "0");
-               $DATA[23]     = MAKE_DATETIME($DATA[23], "0");
-               $DATA[24]     = MAKE_DATETIME($DATA[24], "0");
-               if ((empty($DATA[27])) || ($DATA[27] == $uid)) $DATA[27] = "---";
-               $DATA['total']  = TRANSLATE_COMMA(GET_TOTAL_DATA($uid, "user_points", "points"));
-               $DATA['locked'] = TRANSLATE_COMMA(GET_TOTAL_DATA($uid, "user_points", "locked_points"));
-
+               define('_ADMIN_LINKS', MEMBER_ACTION_LINKS($uid, $DATA['status']));
+               $DATA['gender']            = TRANSLATE_GENDER($DATA['gender']);
+               $DATA['email_link']        = CREATE_EMAIL_LINK($DATA['email'], "user_data");
+               $DATA['status']            = TRANSLATE_STATUS($DATA['status']);
+               $DATA['last_online']       = MAKE_DATETIME($DATA['last_online'], "0");
+               $DATA['used_points']       = TRANSLATE_COMMA($DATA['used_points']);
+               if ($DATA['emails_sent'] > 0) $DATA['emails_sent'] = $BASE."&amp;what=email_details&amp;u_id=".$uid."\">".TRANSLATE_COMMA($DATA['emails_sent'])."</A>]";
+               $DATA['joined']            = MAKE_DATETIME($DATA['joined'], "0");
+               $DATA['last_update']       = MAKE_DATETIME($DATA['last_update'], "0");
+               $DATA['last_profile_sent'] = MAKE_DATETIME($DATA['last_profile_sent'], "0");
+               $DATA['total']             = TRANSLATE_COMMA(GET_TOTAL_DATA($uid, "user_points", "points"));
+               $DATA['locked']            = TRANSLATE_COMMA(GET_TOTAL_DATA($uid, "user_points", "locked_points"));
+
+               // Nickname inclusion?

                if (EXT_IS_ACTIVE("nickname")) {
                if (EXT_IS_ACTIVE("nickname")) {

-                       if ((empty($DATA[27])) || ($DATA[27] == $uid)) $DATA[27] = "---";
+                       // Nickname not set or invalid? Then 
+                       if ((empty($DATA['nickname'])) || ($DATA['nickname'] == $uid)) $DATA['nickname'] = "---";

                } else {
                } else {

-                       $DATA[27] = EXT_NICKNAME_404;
+                       // Extension not found
+                       $DATA['nickname'] = EXT_NICKNAME_404;

                }
 
                }
 

-               // Template laden
+               // Is the user extension newer?
+               if (GET_EXT_VERSION("user") >= "0.3.4") {
+                       // Then "translate" the number
+                       $DATA['rand_confirmed'] = TRANSLATE_COMMA($DATA['rand_confirmed']);
+               } // END - if
+
+               // Clickrate
+               $DATA['click_rate'] = 0;
+               if ($DATA['emails_received'] > 0) {
+                       $DATA['click_rate'] = TRANSLATE_COMMA($DATA['mails_confirmed'] / $DATA['emails_received'] * 100);
+               } // END - if
+
+               // "Translate" more data
+               $DATA['mails_confirmed'] = TRANSLATE_COMMA($DATA['mails_confirmed']);
+               $DATA['emails_received'] = TRANSLATE_COMMA($DATA['emails_received']);
+
+               // Load user-details template

                LOAD_TEMPLATE("admin_user_details", false, $uid);
        } else {
                LOAD_TEMPLATE("admin_user_details", false, $uid);
        } else {

-               // Account does not exists!
+               // Account does not exist!

                LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_MEMBER_404_1.$uid.ADMIN_MEMBER_404_2);
        }
                LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_MEMBER_404_1.$uid.ADMIN_MEMBER_404_2);
        }

+
+       // Free the result
+       SQL_FREERESULT($result_user);

 } else {
        $whereStatement = "";
        if (($_GET['letter'] != _ALL2) && ($_GET['letter'] != _OTHERS) && (!empty($_GET['letter']))) {
 } else {
        $whereStatement = "";
        if (($_GET['letter'] != _ALL2) && ($_GET['letter'] != _OTHERS) && (!empty($_GET['letter']))) {