X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmysql-manager.php;h=13b29b526495e831423a17e37a21d864ed2ad7ec;hp=a9733b4ec1489db3e08ea1f4dbba5cdd434320e9;hb=e3934352dffa6eb9da59a137ae1a9414e5b4d80b;hpb=f11431f9a9e4eef095057af4e3f0c2a3971488da

diff --git a/inc/mysql-manager.php b/inc/mysql-manager.php
index a9733b4ec1..13b29b5264 100644
--- a/inc/mysql-manager.php
+++ b/inc/mysql-manager.php
@@ -279,7 +279,7 @@ ORDER BY
 						}
 					} else {
 						// Not found - open
-						$OUT .= '<em style="cursor:help" class="notice" title="{%message,ADMIN_MENU_WHAT_404_TITLE=' . $content['sub_what'] . '%}">';
+						$OUT .= '<div style="cursor:help" class="bad" title="{%message,ADMIN_MENU_WHAT_404_TITLE=' . $content['sub_what'] . '%}">';
 					}
 
 					// Menu title
@@ -294,7 +294,7 @@ ORDER BY
 						} // END - if
 					} else {
 						// Not found - close
-						$OUT .= '</em>';
+						$OUT .= '</div>';
 					}
 
 					// Cunt it up
@@ -340,16 +340,16 @@ ORDER BY
 
 			//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'main_cnt=' . $main_cnt . ',getWhat()=' . getWhat());
 			if (SQL_NUMROWS($result_main) > $main_cnt) {
-				// Add seperator
-				$GLOBALS['rows'] .= loadTemplate('menu_seperator', true, $mode);
+				// Add separator
+				$GLOBALS['rows'] .= loadTemplate('menu_separator', true, $mode);
 
 				// Should we display adverts in this menu?
 				if ((isExtensionInstalledAndNewer('menu', '0.0.1')) && (getConfig($mode . '_menu_advert_enabled') == 'Y') && ($action != 'admin')) {
 					// Display advert template
 					$GLOBALS['rows'] .= loadTemplate('menu_' . $mode . '_advert_' . $action, true);
 
-					// Add seperator again
-					$GLOBALS['rows'] .= loadTemplate('menu_seperator', true, $mode);
+					// Add separator again
+					$GLOBALS['rows'] .= loadTemplate('menu_separator', true, $mode);
 				} // END - if
 			} // END - if
 		} // END - while
@@ -359,8 +359,8 @@ ORDER BY
 
 		// Should we display adverts in this menu?
 		if ((isExtensionInstalledAndNewer('menu', '0.0.1')) && (getConfig($mode . '_menu_advert_enabled') == 'Y')) {
-			// Add seperator again
-			$GLOBALS['rows'] .= loadTemplate('menu_seperator', true, $mode);
+			// Add separator again
+			$GLOBALS['rows'] .= loadTemplate('menu_separator', true, $mode);
 
 			// Display advert template
 			$GLOBALS['rows'] .= loadTemplate('menu_' . $mode . '_advert_end', true);
@@ -959,14 +959,14 @@ function countSumTotalData ($search, $tableName, $lookFor = 'id', $whereStatemen
 		// Count or sum whole table?
 		if ($countRows === true) {
 			// Count whole table
-			$result = SQL_QUERY_ESC("SELECT COUNT(`%s`) AS `res` FROM `{?_MYSQL_PREFIX?}_%s`".$add,
+			$result = SQL_QUERY_ESC("SELECT COUNT(`%s`) AS `res` FROM `{?_MYSQL_PREFIX?}_%s`" . $add . ' LIMIT 1',
 				array(
 					$lookFor,
 					$tableName
 				), __FUNCTION__, __LINE__);
 		} else {
 			// Sum whole table
-			$result = SQL_QUERY_ESC("SELECT SUM(`%s`) AS `res` FROM `{?_MYSQL_PREFIX?}_%s`".$add,
+			$result = SQL_QUERY_ESC("SELECT SUM(`%s`) AS `res` FROM `{?_MYSQL_PREFIX?}_%s`" . $add . ' LIMIT 1',
 				array(
 					$lookFor,
 					$tableName
@@ -975,7 +975,7 @@ function countSumTotalData ($search, $tableName, $lookFor = 'id', $whereStatemen
 	} elseif (($countRows === true) || ($lookFor == 'userid')) {
 		// Count rows
 		//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'COUNT!');
-		$result = SQL_QUERY_ESC("SELECT COUNT(`%s`) AS `res` FROM `{?_MYSQL_PREFIX?}_%s` WHERE `%s`%s'%s'".$add,
+		$result = SQL_QUERY_ESC("SELECT COUNT(`%s`) AS `res` FROM `{?_MYSQL_PREFIX?}_%s` WHERE `%s`%s'%s'" . $add . ' LIMIT 1',
 			array(
 				$lookFor,
 				$tableName,
@@ -986,7 +986,7 @@ function countSumTotalData ($search, $tableName, $lookFor = 'id', $whereStatemen
 	} else {
 		// Add all rows
 		//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'SUM!');
-		$result = SQL_QUERY_ESC("SELECT SUM(`%s`) AS `res` FROM `{?_MYSQL_PREFIX?}_%s` WHERE `%s`%s'%s'".$add,
+		$result = SQL_QUERY_ESC("SELECT SUM(`%s`) AS `res` FROM `{?_MYSQL_PREFIX?}_%s` WHERE `%s`%s'%s'" . $add . ' LIMIT 1',
 			array(
 				$lookFor,
 				$tableName,
@@ -1292,9 +1292,9 @@ function generateOptionList ($table, $id, $name, $default = '', $special = '', $
 		}
 	} else {
 		// Data from database
-		$SPEC = ', `' . $id . '`';
+		$SPEC = ',`' . $id . '`';
 		if (!empty($special)) {
-			$SPEC = ', `' . $special . '` AS `special`';
+			$SPEC = ',`' . $special . '` AS `special`';
 		} // END - if
 
 		// Query the database
@@ -1513,7 +1513,7 @@ function generateCategoryOptionsList ($mode) {
 		} // END - foreach
 	} else {
 		// No cateogries are defined yet
-		$OUT = '<option class="notice">{--MEMBER_NO_CATEGORIES--}</option>';
+		$OUT = '<option class="bad">{--MEMBER_NO_CATEGORIES--}</option>';
 	}
 
 	// Return HTML code