X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fmodules%2Fadmin%2Fwhat-del_email.php;h=bcc1fcc5d2607d21e02db72233b71d60ee9fd25c;hb=ca7455674c0f02d34cbfc22a823393ba629a5160;hp=3401751e7de08c4293b6bb5051116882ad164a9d;hpb=55e6ddf528028536b88b1397ef8297655782de69;p=mailer.git

diff --git a/inc/modules/admin/what-del_email.php b/inc/modules/admin/what-del_email.php
index 3401751e7d..bcc1fcc5d2 100644
--- a/inc/modules/admin/what-del_email.php
+++ b/inc/modules/admin/what-del_email.php
@@ -35,7 +35,7 @@
  ************************************************************************/
 
 // Some security stuff...
-if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!IS_ADMIN())) {
+if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
 	$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
 	require($INC);
 }
@@ -45,7 +45,7 @@ ADD_DESCR("admin", basename(__FILE__));
 
 if (!empty($_GET['mid'])) {
 	// Load email data
-	$result = SQL_QUERY_ESC("SELECT id, sender, subject, url, timestamp, payment_id FROM "._MYSQL_PREFIX."_pool WHERE id=%d LIMIT 1",
+	$result = SQL_QUERY_ESC("SELECT id, sender, subject, url, timestamp, payment_id FROM "._MYSQL_PREFIX."_pool WHERE id=%s LIMIT 1",
 	 array(bigintval($_GET['mid'])), __FILE__, __LINE__);
 
 	// Delete mail only once
@@ -68,29 +68,31 @@ if (!empty($_GET['mid'])) {
 		LOAD_TEMPLATE("admin_del_email_normal");
 
 		// Transfer data to data array
-		$DATA = array($url, $subject);
+		$DATA = array('url' => $url, 'subject' => $subject);
 
 		// Load email template and send the email away
-		$msg_user = LOAD_EMAIL_TEMPLATE("order-deleted", "", $sender);
+		$msg_user = LOAD_EMAIL_TEMPLATE("order-deleted", array(), $sender);
 		SEND_EMAIL($sender, MEMBER_ORDER_DELETED, $msg_user);
 
 		// Delete mail from queue
-		//$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_pool WHERE id=%d LIMIT 1",
-		// array(bigintval($_GET['mid'])), __FILE__, __LINE__);
+		$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_pool WHERE id=%s LIMIT 1",
+		 array(bigintval($_GET['mid'])), __FILE__, __LINE__);
 
 		// Fetch right stats_id from pool
 		$result = SQL_QUERY_ESC("SELECT s.id FROM "._MYSQL_PREFIX."_user_stats AS s
 LEFT JOIN "._MYSQL_PREFIX."_pool AS p
 ON s.pool_id=p.id
-WHERE s.pool_id=%d LIMIT 1",
+WHERE s.pool_id=%s LIMIT 1",
  array(bigintval($_GET['mid'])), __FILE__, __LINE__);
 		if (SQL_NUMROWS($result) == 1) {
 			// Fetch stats id
 			list($stats_id) = SQL_FETCHROW($result);
+
+			// Free the result
 			SQL_FREERESULT($result);
 
 			// Get all user links
-			$result = SQL_QUERY_ESC("SELECT COUNT(id) AS 'cnt' FROM "._MYSQL_PREFIX."_user_links WHERE stats_id=%d",
+			$result = SQL_QUERY_ESC("SELECT COUNT(id) AS 'cnt' FROM "._MYSQL_PREFIX."_user_links WHERE stats_id=%s",
 				array(bigintval($stats_id)), __FILE__, __LINE__);
 
 			// Get unconfirmed links for calculation of total points
@@ -101,16 +103,45 @@ WHERE s.pool_id=%d LIMIT 1",
 
 			// Calc total points and pay them back
 			$totalPoints = $links * $price;
-			//* DEBUG: */ echo $stats_id.":".$totalPoints."/".$links."/".$price."<br />\n";
-			if ($totalPoints > 0) {
-				// Pay back points
-				//* DEBUG: */ echo "PAYBACK:".$sender."<br />\n";
-				ADD_POINTS_REFSYSTEM($sender, $totalPoints, true, "0", false,"direct");
+
+			// Shall we pay the points back to the user?
+			if ($_CONFIG['repay_deleted_mails'] != 'SHRED') {
+				//* DEBUG: */ echo $stats_id.":".$totalPoints."/".$links."/".$price."<br />\n";
+				if ($totalPoints > 0) {
+					// Shall we payback to user or jackpot?
+					if ($_CONFIG['repay_deleted_mails'] == "JACKPOT") {
+						// Set jackpot
+						$sender = 0;
+					}
+
+					// Pay back points
+					//* DEBUG: */ echo "PAYBACK:".$sender."<br />\n";
+					ADD_POINTS_REFSYSTEM($sender, $totalPoints, true, "0", false,"direct");
+
+					// Output message
+					if ($_CONFIG['repay_deleted_mails'] == 'REPAY') {
+						// Repayed
+						LOAD_TEMPLATE("admin_settings_saved", false, sprintf(ADMIN_POINTS_REPAYED,
+							number_format($totalPoints, 0, ",", ".")
+						));
+					} else {
+						// To jackpot
+						LOAD_TEMPLATE("admin_settings_saved", false, sprintf(ADMIN_POINTS_TO_JACKPOT,
+							number_format($totalPoints, 0, ",", ".")
+						));
+					}
+				} else {
+					// No points repayed!
+					LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_NO_POINTS_REPAYED);
+				}
+			} else {
+				// Points shredded!
+				LOAD_TEMPLATE("admin_settings_saved", false, sprintf(ADMIN_POINTS_SHREDDED, $totalPoints));
 			}
 
 			// Remove links from DB
-			//$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_links WHERE stats_id=%d",
-			// array(bigintval($stats_id)), __FILE__, __LINE__);
+			$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_links WHERE stats_id=%s",
+			 array(bigintval($stats_id)), __FILE__, __LINE__);
 
 			// Output link for manually removing stats entry
 			LOAD_TEMPLATE("admin_settings_saved", false, "<A href=\"".URL."/modules.php?module=admin&amp;what=del_email&amp;pid=".bigintval($_GET['mid'])."\">".ADMIN_REMOVE_STATS_ENTRY."</A>");
@@ -121,12 +152,12 @@ WHERE s.pool_id=%d LIMIT 1",
 	}
 } elseif (!empty($_GET['pid'])) {
 	// Remove stats entries
-	$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_stats WHERE pool_id=%d LIMIT 1",
+	$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_stats WHERE pool_id=%s LIMIT 1",
 	 array(bigintval($_GET['pid'])), __FILE__, __LINE__);
 	LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_USER_STATS_REMOVED);
 } elseif ((!empty($_GET['bid'])) && (EXT_IS_ACTIVE("bonus"))) {
 	// Load data from bonus mail
-	$result = SQL_QUERY_ESC("SELECT id, subject, url, timestamp FROM "._MYSQL_PREFIX."_bonus WHERE id=%d",
+	$result = SQL_QUERY_ESC("SELECT id, subject, url, timestamp FROM "._MYSQL_PREFIX."_bonus WHERE id=%s",
 	 array(bigintval($_GET['bid'])), __FILE__, __LINE__);
 
 	// Delete mail only once
@@ -136,9 +167,9 @@ WHERE s.pool_id=%d LIMIT 1",
 		SQL_FREERESULT($result);
 
 		// Delete bonus mail entirely from database
-		$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_bonus WHERE id=%d LIMIT 1",
+		$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_bonus WHERE id=%s LIMIT 1",
 		 array(bigintval($_GET['bid'])), __FILE__, __LINE__);
-		$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_links WHERE bonus_id=%d",
+		$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_links WHERE bonus_id=%s",
 		 array(bigintval($_GET['bid'])), __FILE__, __LINE__);
 
 		// Prepare data for the template