X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fmodules%2Fmember%2Fwhat-stats.php;h=12390580eeecf40b8f5a739977af9ba78f2378db;hb=e5dffd4249c97200cbad02f3f4eaf5c373fdb89a;hp=eda45cfd227d8058ff4dcd9014284a5db6dd5ee0;hpb=20741b93fd58620af677a7f1039ffd16ea6ec689;p=mailer.git

diff --git a/inc/modules/member/what-stats.php b/inc/modules/member/what-stats.php
index eda45cfd22..12390580ee 100644
--- a/inc/modules/member/what-stats.php
+++ b/inc/modules/member/what-stats.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
+ * Copyright (c) 2009 - 2013 by Mailer Developer Team                   *
  * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -37,7 +37,7 @@
 
 // Some security stuff...
 if (!defined('__SECURITY')) {
-	die();
+	exit();
 } elseif (!isMember()) {
 	redirectToIndexMemberOnlyModule();
 }
@@ -49,8 +49,16 @@ addYouAreHereLink('member', __FILE__);
 $main_content = array();
 
 // Load waiting/pending orders
-$result = SQL_QUERY_ESC("SELECT
-	`id`,`cat_id`,`payment_id`,`subject`,`url`,`timestamp`,`target_send`,`data_type`,`zip`
+$result = sqlQueryEscaped("SELECT
+	`id`,
+	`cat_id`,
+	`payment_id`,
+	`subject`,
+	`url`,
+	`timestamp`,
+	`target_send`,
+	`data_type`,
+	`zip`
 FROM
 	`{?_MYSQL_PREFIX?}_pool`
 WHERE
@@ -61,70 +69,73 @@ ORDER BY
 	array(getMemberId()), __FILE__, __LINE__);
 
 // Are there mails left in pool?
-if (!SQL_HASZERONUMS($result)) {
+if (!ifSqlHasZeroNums($result)) {
 	// Load all orders
 	$OUT = '';
-	while ($content = SQL_FETCHARRAY($result)) {
+	while ($content = sqlFetchArray($result)) {
 		// Prepare content for output
 		$content['timestamp'] = generateDateTime($content['timestamp'], '2');
 
 		// Load template
-		$OUT .= loadTemplate('member_pool_row', true, $content);
+		$OUT .= loadTemplate('member_pool_row', TRUE, $content);
 	} // END - if
 
 	// Load main template
-	$main_content['pool'] = loadTemplate('member_pool_table', true, $OUT);
+	$main_content['pool'] = loadTemplate('member_pool_table', TRUE, $OUT);
 } else {
 	// No mails in pool!
-	$main_content['pool'] = displayMessage('{--MEMBER_NO_MAILS_IN_POOL--}', true);
+	$main_content['pool'] = displayMessage('{--MEMBER_NO_MAILS_IN_POOL--}', TRUE);
 }
 
 // Free result
-SQL_FREERESULT($result);
+sqlFreeResult($result);
 
 // Load sent orders
-$result = SQL_QUERY_ESC("SELECT
-	`id`,`cat_id`,`payment_id`,`subject`,`url`,`timestamp_ordered`,`max_rec`,`timestamp_send`,`clicks`
+$result = sqlQueryEscaped('SELECT
+	`id`,
+	`cat_id`,
+	`payment_id`,
+	`subject`,
+	`url`,
+	`timestamp_ordered`,
+	`max_rec`,
+	`timestamp_send`,
+	`clicks`
 FROM
 	`{?_MYSQL_PREFIX?}_user_stats`
 WHERE
 	`userid`=%s
 ORDER BY
-	`timestamp_ordered` DESC",
+	`timestamp_ordered` DESC',
 	array(getMemberId()), __FILE__, __LINE__);
 
-if (!SQL_HASZERONUMS($result)) {
+if (!ifSqlHasZeroNums($result)) {
 	// Mail orders are in pool so we can display them
 	$OUT = '';
-	while ($content = SQL_FETCHARRAY($result)) {
+	while ($content = sqlFetchArray($result)) {
 		// Prepare data for the template
 		$content['timestamp_ordered'] = generateDateTime($content['timestamp_ordered'], '2');
 		$content['timestamp_sent']    = generateDateTime($content['timestamp_send'], '2');
 
 		// Click rate
-		$content['click_rate'] = '0';
-
-		// Better protection against 'divison-by-zero'
-		if ($content['max_rec'] > 0) {
-			$content['click_rate'] = ($content['clicks'] / $content['max_rec'] * 100);
-		} // END - if
+		$content['click_rate'] = calculatePercentageRate($content['clicks'], $content['max_rec']);
 
 		// Load row template and switch colors
-		$OUT .= loadTemplate('member_stats_row', true, $content);
+		$OUT .= loadTemplate('member_stats_row', TRUE, $content);
 	} // END - while
 
 	// Load main template
-	$main_content['stats'] = loadTemplate('member_stats_table', true, $OUT);
+	$main_content['stats'] = loadTemplate('member_stats_table', TRUE, $OUT);
 } else {
 	// No mail orders fond
-	$main_content['stats'] = displayMessage('{--MEMBER_NO_MAILS_IN_STATS--}', true);
+	$main_content['stats'] = displayMessage('{--MEMBER_NO_MAILS_IN_STATS--}', TRUE);
 }
 
 // Free result
-SQL_FREERESULT($result);
+sqlFreeResult($result);
 
 // Load main template
-loadTemplate('member_stats_pool', false, $main_content);
+loadTemplate('member_stats_pool', FALSE, $main_content);
 
 // [EOF]
 ?>