X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmysql-manager.php;h=e0e63f090e137b9d876348df8b7d32e85f903ef4;hb=4cc62618b7a59c6641b057c34047b2dd531c16ad;hp=910f6a551360e8c2d021bb3062e53d10177a66c6;hpb=15d03825972c38fbd95abad41f304c7494c5a70e;p=mailer.git

diff --git a/inc/mysql-manager.php b/inc/mysql-manager.php
index 910f6a5513..e0e63f090e 100644
--- a/inc/mysql-manager.php
+++ b/inc/mysql-manager.php
@@ -47,7 +47,7 @@ if (!defined('__SECURITY')) {
 function getTitleFromMenu ($mode, $what, $column = 'what', $ADD='') {
 	// Fix empty 'what'
 	if (empty($what)) {
-		$what = getConfig('index_home');
+		$what = getIndexHome();
 	} // END - if
 
 	// Default is not found
@@ -109,7 +109,7 @@ function addMenuDescription ($accessLevel, $FQFN, $return = false) {
 		if (isAdmin()) $ADD = '';
 
 		$dummy = substr($search, 0, -4);
-		$ADD .= " AND `action`='".getActionFromModuleWhat($accessLevel, $dummy)."'";
+		$ADD .= sprintf(" AND `action`='%s'", getActionFromModuleWhat($accessLevel, $dummy));
 	} elseif (($accessLevel == 'sponsor') || ($accessLevel == 'engine')) {
 		// Sponsor / engine menu
 		$type     = 'what';
@@ -732,7 +732,7 @@ function getActionFromModuleWhat ($module, $what) {
 		}
 	} elseif ((empty($what)) && ($module != 'admin')) {
 		// Use configured 'home'
-		$what = getConfig('index_home');
+		$what = getIndexHome();
 	} // END - if
 
 	if ($module == 'admin') {
@@ -1514,7 +1514,6 @@ LIMIT 1",
 
 	// Add reason and translate points
 	$data['text']   = $reason;
-	$data['points'] = translateComma($data['points']);
 
 	// Now a mail to the user and that's all...
 	$message = loadEmailTemplate('del-user', $data, $userid);
@@ -1546,7 +1545,7 @@ function getWhatFromModule ($modCheck) {
 			// Is ext-sql_patches installed and newer than 0.0.5?
 			if (isExtensionInstalledAndNewer('sql_patches', '0.0.5')) {
 				// Use it from config
-				$what = getConfig('index_home');
+				$what = getIndexHome();
 			} else {
 				// Use default 'welcome'
 				$what = 'welcome';
@@ -1830,7 +1829,7 @@ ORDER BY
 		// Fetch all entries
 		while ($row = SQL_FETCHARRAY($result)) {
 			// Get total points of this user
-			$row['points'] = countSumTotalData($row['refid'], 'user_points', 'points') - countSumTotalData($row['refid'], 'user_data', 'used_points');
+			$row['points'] = getTotalPoints($row['refid']);
 
 			// Get unconfirmed mails
 			$row['unconfirmed']  = countSumTotalData($row['refid'], 'user_links', 'id', 'userid', true);