X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_user.php;h=0722b871e4affee3a8b048e2f5332912eeb5cd99;hp=ce195ae973ff08d557b53dd04fee99ba947dd562;hb=9afd6ec5878544a7982c50ed9c0dd7de37606d5b;hpb=c2e17d983fcbc0c3bd1dd37908d87c678f0367df

diff --git a/inc/modules/admin/what-list_user.php b/inc/modules/admin/what-list_user.php
index ce195ae973..0722b871e4 100644
--- a/inc/modules/admin/what-list_user.php
+++ b/inc/modules/admin/what-list_user.php
@@ -93,7 +93,7 @@ if (!isGetRequestElementSet('page'))   { setRequestGetElement('page'  , 1);
 $base = '[<a href="{?URL?}/modules.php?module=admin';
 
 if (isGetRequestElementSet('userid')) {
-	// Secure the user ID
+	// Secure the user id
 	$userid = bigintval(getRequestElement('userid'));
 
 	// Does the account exists?
@@ -172,7 +172,7 @@ LIMIT 1",
 		} // END - if
 
 		// Clickrate
-		$content['click_rate'] = 0;
+		$content['click_rate'] = '0';
 		if ($content['emails_received'] > 0) {
 			$content['click_rate'] = translateComma($content['mails_confirmed'] / $content['emails_received'] * 100);
 		} // END - if
@@ -185,8 +185,8 @@ LIMIT 1",
 		if (isExtensionActive('country')) {
 			// Then overwrite country information
 			$content['country'] = generateCountryInfo($content['country_code']);
-		} elseif ($content['country'] == 0) {
-			// Zero ID???
+		} elseif ($content['country'] == '0') {
+			// Zero id???
 			$content['country'] = '???';
 		}
 
@@ -247,7 +247,7 @@ LIMIT 1",
 	$result_master = SQL_QUERY($sql, __FILE__, __LINE__);
 
 	// Calculate page count (0.5 fixes a bug with page count)
-	if (getConfig('user_limit') == 0) {
+	if (getConfig('user_limit') == '0') {
 		setConfigEntry('user_limit', 100);
 		loadTemplate('admin_settings_saved', false, getMessage('EXTENSION_WARNING_USER_LIMIT'));
 	} // END - if
@@ -312,7 +312,7 @@ LIMIT 1",
 			$pointsTotal = countSumTotalData($content['userid'], 'user_points', 'points')  - countSumTotalData($content['userid'], 'user_data', 'used_points');
 
 			// Clickrate
-			$clickRate = 0;
+			$clickRate = '0';
 			if ($content['emails_received'] > 0) {
 				$clickRate = $content['mails_confirmed'] / $content['emails_received'] * 100;
 			} // END - if
@@ -328,7 +328,7 @@ LIMIT 1",
 			$content['locked']         = translateComma(countSumTotalData($content['userid'], 'user_points', 'locked_points'));
 			$content['lock_timestamp'] = generateDateTime($content['lock_timestamp'], 2);
 			$content['status']         = translateUserStatus($content['status']);
-			$content['refs']           = countSumTotalData($content['userid'], 'refsystem', 'counter');
+			$content['refs']           = countSumTotalData($content['userid'], 'user_refs', 'id', 'userid', true);
 
 			// If we have at least one referal, make it clickable to referal list
 			if ($content['refs'] > 0) $content['refs'] = $base . '&amp;what=list_refs&amp;userid=' . $content['userid'] . '">' . $content['refs'] . '</a>]';
@@ -342,7 +342,7 @@ LIMIT 1",
 				// Then overwrite country information
 				$content['country'] = generateCountryInfo($content['country_code']);
 			} elseif ($content['country'] == '') {
-				// Zero ID???
+				// Zero id???
 				$content['country'] = '???';
 			}