]> git.mxchange.org Git - mailer.git/blobdiff - inc/modules/admin/what-list_user.php
More usage of wrapper functions
[mailer.git] / inc / modules / admin / what-list_user.php
index 58bc853aa343bef54e59715280e4cb8f08023691..91f225c556313a4dc4f285f8dc757120764c8ff4 100644 (file)
@@ -75,7 +75,7 @@ if (isGetRequestParameterSet('userid')) {
 
        // Does the account exists?
        $result_user = SQL_QUERY_ESC("SELECT
-       `userid`, `country`, `email`, `birth_day`, `birth_month`, `birth_year`, `last_online`, `used_points`, `emails_sent`, `joined`, `last_update`, `last_profile_sent`, `notified`, `emails_received`, `mails_confirmed`".$MORE."
+       `userid`,`country`,`email`,`birth_day`,`birth_month`,`birth_year`,`last_online`,`used_points`,`emails_sent`,`joined`,`last_update`,`last_profile_sent`,`notified`,`emails_received`,`mails_confirmed`".$MORE."
 FROM
        `{?_MYSQL_PREFIX?}_user_data`
 WHERE
@@ -104,18 +104,18 @@ LIMIT 1",
                // Is this above zero?
                if ($stamp > 0) {
                        // Then use it
-                       $content['birthday'] = generateDateTime($stamp, '3');
+                       $content['birthday'] = generateDateTime($stamp, '2');
                } else {
                        // Zero or below so set zero!
-                       $content['birthday'] = generateDateTime(0, '3');
+                       $content['birthday'] = generateDateTime(0, '2');
                }
 
                // Prepare data for template
                $content['email_link']        = generateEmailLink($content['email'], 'user_data');
-               $content['last_online']       = generateDateTime($content['last_online'], '0');
-               $content['joined']            = generateDateTime($content['joined'], '0');
-               $content['last_update']       = generateDateTime($content['last_update'], '0');
-               $content['last_profile_sent'] = generateDateTime($content['last_profile_sent'], '0');
+               $content['last_online']       = generateDateTime($content['last_online'], '2');
+               $content['joined']            = generateDateTime($content['joined'], '2');
+               $content['last_update']       = generateDateTime($content['last_update'], '2');
+               $content['last_profile_sent'] = generateDateTime($content['last_profile_sent'], '2');
                $content['total_points']      = getTotalPoints($content['userid']);
                $content['locked_points']     = countSumTotalData($content['userid'], 'user_points', 'locked_points') + countSumTotalData($content['userid'], 'user_points', 'locked_order_points');
 
@@ -130,7 +130,7 @@ LIMIT 1",
 
                // Add more data
                $content['own_points']     = $data['points'];
-               $content['lock_timestamp'] = generateDateTime($content['lock_timestamp'], 2);
+               $content['lock_timestamp'] = generateDateTime($content['lock_timestamp'], '2');
 
                // Link to email_details if some are sent
                if ($content['emails_sent'] > 0) {
@@ -211,7 +211,7 @@ LIMIT 1",
        } // END - if
 
        // Generate master query string
-       $sql = sprintf("SELECT `userid`, `email`, `emails_sent`, `mails_confirmed`, `emails_received`" . $MORE . " FROM `{?_MYSQL_PREFIX?}_user_data`" . $whereStatement . " ORDER BY `%s` ASC",
+       $sql = sprintf("SELECT `userid`,`email`,`emails_sent`,`mails_confirmed`,`emails_received`" . $MORE . " FROM `{?_MYSQL_PREFIX?}_user_data`" . $whereStatement . " ORDER BY `%s` ASC",
                getRequestParameter('sortby')
        );
 
@@ -276,7 +276,7 @@ LIMIT 1",
 
                        // Transfer data to array
                        $content['email']          = '[<a href="' . generateEmailLink($content['email'], 'user_data') . '">' . $content['email'] . '</a>]';
-                       $content['lock_timestamp'] = generateDateTime($content['lock_timestamp'], 2);
+                       $content['lock_timestamp'] = generateDateTime($content['lock_timestamp'], '2');
                        $content['refs']           = countSumTotalData($content['userid'], 'user_refs', 'id', 'userid', true);
                        $content['own_points']     = countSumTotalData($content['userid'], 'user_points', 'points') + countSumTotalData($content['userid'], 'user_points', 'order_points');
                        $content['locked_points']  = countSumTotalData($content['userid'], 'user_points', 'locked_points') + countSumTotalData($content['userid'], 'user_points', 'locked_order_points');