X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fguest%2Fwhat-stats.php;h=6e6c88e2843d980d32a995f99b4ee29a2f933df6;hb=1551e5820800685c80c19871a376986c0ad6f0f6;hp=2ef513ca78cab39f7975ced9dd88a2e9d02a50f5;hpb=fc162164725588cf75969f707faead9c9cd8e68b;p=mailer.git

diff --git a/inc/modules/guest/what-stats.php b/inc/modules/guest/what-stats.php
index 2ef513ca78..6e6c88e284 100644
--- a/inc/modules/guest/what-stats.php
+++ b/inc/modules/guest/what-stats.php
@@ -140,7 +140,7 @@ switch (getConfig('guest_stats')) {
 		// Generate monthly stats
 		$SW = 2; $r2 = ' right'; $l = 'll'; $r = 'lr'; $OUT = '';
 		foreach ($months as $month => $cnt) {
-			if ($SW == 2) $OUT .= "<tr>\n";
+			if ($SW == 2) $OUT .= '<tr>';
 
 			// Prepare data for template
 			$data = array(
@@ -158,28 +158,26 @@ switch (getConfig('guest_stats')) {
 				$r2 = '';
 				$l = 'rl'; $r = 'rr';
 			} else {
-				$OUT .= "</tr>\n";
+				$OUT .= '</tr>';
 				$r2 = ' right';
 				$l = 'll'; $r = 'lr';
 			}
 			$SW = 3 - $SW;
-		}
+		} // END - foreach
 		$content['month_rows'] = $OUT;
 
 		// Generate category stats
-		$OUT = ''; $SW = 2;
+		$OUT = '';
 		foreach ($cat_cnt as $id => $cnt) {
 			// Prepare data for the template
 			$data = array(
-				'sw'  => $SW,
 				'cat' => $cats[$id],
 				'cnt' => $cnt,
 			);
 
 			// Load row template and switch colors
 			$OUT .= loadTemplate('guest_stats_cats_row', true, $data);
-			$SW = 3 - $SW;
-		}
+		} // END - foreach
 		$content['cats_rows'] = $OUT;
 
 		// Load final template
@@ -192,37 +190,29 @@ switch (getConfig('guest_stats')) {
 		if (isAdmin()) $AND = '';
 
 		// Query for guest and member menus
-		$guest_t10 = SQL_QUERY("SELECT `counter`, `title` FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE `counter` > 0".$AND." ORDER BY `counter` DESC LIMIT 0,10", __FILE__, __LINE__);
-		$mem_t10   = SQL_QUERY("SELECT `counter`, `title` FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE `counter` > 0".$AND." ORDER BY `counter` DESC LIMIT 0,10", __FILE__, __LINE__);
+		$guest_t10 = SQL_QUERY('SELECT `counter`, `title` FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE `counter` > 0' . $AND . ' ORDER BY `counter` DESC LIMIT 0,10', __FILE__, __LINE__);
+		$mem_t10   = SQL_QUERY('SELECT `counter`, `title` FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE `counter` > 0' . $AND . ' ORDER BY `counter` DESC LIMIT 0,10', __FILE__, __LINE__);
 		$OUT = ''; 
 
-		if (SQL_NUMROWS($guest_t10) > 0) {
+		if (!SQL_HASZERONUMS($guest_t10)) {
 			// Guest clicks
 			$OUT .= loadTemplate('guest_stats_header', true, '{--GUEST_TOP_GUEST_STATS--}');
-			$SW = 2;
 			while ($content = SQL_FETCHARRAY($guest_t10)) {
-				$content['sw'] = $SW;
-
 				// Load row template
 				$OUT .= loadTemplate('guest_stats_row', true, $content);
-				$SW = 3 - $SW;
 			} // END - while
 		} // END - if
 
-		if (SQL_NUMROWS($mem_t10) > 0) {
+		if (!SQL_HASZERONUMS($mem_t10)) {
 			// Member clicks
 			$OUT .= loadTemplate('guest_stats_header', true, '{--GUEST_TOP_MEMBER_STATS--}');
-			$SW = 2;
 			while ($content = SQL_FETCHARRAY($mem_t10)) {
-				$content['sw'] = $SW;
-
 				// Load row template
 				$OUT .= loadTemplate('guest_stats_row', true, $content);
-				$SW = 3 - $SW;
 			} // END - while
 		} // END - if
 
-		if ((SQL_NUMROWS($guest_t10) > 0) || (SQL_NUMROWS($mem_t10) > 0)) {
+		if ((!SQL_HASZERONUMS($guest_t10)) || (!SQL_HASZERONUMS($mem_t10))) {
 			// Prepare content
 			$content = array(
 				'rows'   => $OUT,