X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fmysql-manager.php;h=d42cd4ecdce94b2af26066db9c3c08e7d7989076;hb=0ed9eaa5aea8db1f690a983a39ff4b2074faf6c5;hp=2a36d6db07ef1d7d42b773638daffeba2e530199;hpb=e70440e1164db8bbeeccd90df305bfa0efb641e1;p=mailer.git

diff --git a/inc/mysql-manager.php b/inc/mysql-manager.php
index 2a36d6db07..d42cd4ecdc 100644
--- a/inc/mysql-manager.php
+++ b/inc/mysql-manager.php
@@ -907,8 +907,20 @@ function getPaymentPrice ($paymentsId) {
 	return getPaymentData($paymentsId, 'price');
 }
 
+// Get payment time
+function getPaymentTime ($paymentsId) {
+	// Return result
+	return getPaymentData($paymentsId, 'time');
+}
+
+// Get payment 'payment'
+function getPaymentPayment ($paymentsId) {
+	// Return result
+	return getPaymentData($paymentsId, 'payment');
+}
+
 // "Getter" for payment data (cached)
-function getPaymentData ($paymentsId, $lookFor = 'price') {
+function getPaymentData ($paymentsId, $lookFor) {
 	// Default value...
 	$data[$lookFor] = NULL;
 
@@ -986,8 +998,7 @@ function removeReceiver (&$receivers, $key, $userid, $poolId, $statsId = 0, $isB
 				// Update 'mails_sent' if ext-sql_patches is updated
 				if (isExtensionInstalledAndNewer('sql_patches', '0.7.4')) {
 					// Update the pool
-					SQL_QUERY_ESC('UPDATE `{?_MYSQL_PREFIX?}_pool` SET `mails_sent`=`mails_sent`+1 WHERE `id`=%s LIMIT 1',
-						array(bigintval($poolId)), __FUNCTION__, __LINE__);
+					updatePoolDataById($poolId, 'mails_sent', 1, '+');
 				} // END - if
 				$ret = 'done';
 			} else {