X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mailid_top.php;h=dbd32df25c8099ee7a8df4d3981f743b6e01c80b;hb=3362362ce0e29315913fd679ea359ce27b8d3733;hp=b88616de73d9260a7cfacbda1ad7d02c96937989;hpb=e1cf98e08d4d92edf492396b82c67efa97a0ece8;p=mailer.git

diff --git a/mailid_top.php b/mailid_top.php
index b88616de73..dbd32df25c 100644
--- a/mailid_top.php
+++ b/mailid_top.php
@@ -84,12 +84,12 @@ if ((isValidUserId($userId)) && (($mailId > 0) || ($bonusId > 0)) && (!ifFatalEr
 
 	// Maybe he wants to confirm an email?
 	if ($mailId > 0) {
-		$result_main = SQL_QUERY_ESC("SELECT `id`, `link_type` FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `stats_id`=%s AND `userid`=%s LIMIT 1",
+		$result_main = SQL_QUERY_ESC("SELECT `id`,`link_type` FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `stats_id`=%s AND `userid`=%s LIMIT 1",
 			array($mailId, $userId), __FILE__, __LINE__);
 		$type = 'mailid';
 		$urlId = $mailId;
 	} elseif ($bonusId > 0) {
-		$result_main = SQL_QUERY_ESC("SELECT `id`, `link_type` FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `bonus_id`=%s AND `userid`=%s LIMIT 1",
+		$result_main = SQL_QUERY_ESC("SELECT `id`,`link_type` FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `bonus_id`=%s AND `userid`=%s LIMIT 1",
 			array($bonusId, $userId), __FILE__, __LINE__);
 		$type = 'bonusid';
 		$urlId = $bonusId;
@@ -105,12 +105,12 @@ if ((isValidUserId($userId)) && (($mailId > 0) || ($bonusId > 0)) && (!ifFatalEr
 		// @TODO Rewrite this to a filter
 		switch ($ltype) {
 			case 'NORMAL':
-				$result_mailid = SQL_QUERY_ESC("SELECT `pool_id`, `userid`, `id` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `id`=%s LIMIT 1",
+				$result_mailid = SQL_QUERY_ESC("SELECT `pool_id`,`userid`,`id` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `id`=%s LIMIT 1",
 					array($mailId), __FILE__, __LINE__);
 				break;
 
 			case 'BONUS':
-				$result_mailid = SQL_QUERY_ESC("SELECT `id`, `id`, `is_notify` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1",
+				$result_mailid = SQL_QUERY_ESC("SELECT `id`,`id`,`is_notify` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1",
 					array($bonusId), __FILE__, __LINE__);
 				break;
 
@@ -154,7 +154,7 @@ if ((isValidUserId($userId)) && (($mailId > 0) || ($bonusId > 0)) && (!ifFatalEr
 							break;
 
 						case 'BONUS':
-							$result = SQL_QUERY_ESC("SELECT `time`, `points` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1",
+							$result = SQL_QUERY_ESC("SELECT `time`,`points` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1",
 								array(bigintval($pool)), __FILE__, __LINE__);
 
 							// Entry found?
@@ -176,10 +176,10 @@ if ((isValidUserId($userId)) && (($mailId > 0) || ($bonusId > 0)) && (!ifFatalEr
 					if ($isValid === true) {
 						if (($time == '0') && ($payment > 0)) $time = 1;
 						if (($time > 0) && ($payment > 0)) {
-							$img_code = '0';
+							$realCode = '0';
 							if (!empty($code)) {
-								// Generate code
-								$img_code = generateRandomCode(getCodeLength(), $code, $userId, $urlId);
+								// Generate code (the user sees in the CAPTCHA)
+								$realCode = generateRandomCode(getCodeLength(), $code, $userId, $urlId);
 							} // END - if
 
 							// @TODO Rewrite this to a filter
@@ -227,7 +227,7 @@ if ((isValidUserId($userId)) && (($mailId > 0) || ($bonusId > 0)) && (!ifFatalEr
 									// @TODO Rewrite these blocks to filter
 									if (isExtensionInstalledAndNewer('user', '0.1.2')) {
 										// Update counter
-										SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET mails_confirmed=mails_confirmed + 1 WHERE `userid`=%s LIMIT 1",
+										SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `mails_confirmed`=`mails_confirmed`+1 WHERE `userid`=%s LIMIT 1",
 											array($userId), __FILE__, __LINE__);
 
 										// Update random confirmed as well?
@@ -239,10 +239,10 @@ if ((isValidUserId($userId)) && (($mailId > 0) || ($bonusId > 0)) && (!ifFatalEr
 									} // END - if
 
 									// Insert stats record
-									insertUserStatsRecord($userId, $type, $stats_data);
+									//insertUserStatsRecord($userId, $type, $stats_data);
 
 									// Right code entered?
-									if (bigintval(postRequestParameter('gfx_check')) == $img_code) {
+									if (bigintval(postRequestParameter('gfx_check')) == $realCode) {
 										// Set HTTP status to okay
 										setHttpStatus('200 OK');
 
@@ -298,10 +298,20 @@ if ((isValidUserId($userId)) && (($mailId > 0) || ($bonusId > 0)) && (!ifFatalEr
 										loadTemplate($template, false, $content);
 									} elseif (isValidUserId($sender)) {
 										// Wrong image code! So add points to sender's account
+										initReferalSystem();
 										addPointsThroughReferalSystem('mailid_payback', $sender, $payment);
 
+										// Add payment points
+										$content['points'] = $payment;
+
 										// Load template
 										loadTemplate('mailid_points_failed', false, $content);
+									} else {
+										// Add payment points (again)
+										$content['points'] = $payment;
+
+										// Load template
+										loadTemplate('mailid_points_failed2', false, $content);
 									}
 
 									// Remove link from table
@@ -310,7 +320,7 @@ if ((isValidUserId($userId)) && (($mailId > 0) || ($bonusId > 0)) && (!ifFatalEr
 									break;
 
 								case 'img':
-									generateImageOrCode($img_code);
+									generateImageOrCode($realCode);
 									break;
 
 								case 'confirm':
@@ -323,11 +333,11 @@ if ((isValidUserId($userId)) && (($mailId > 0) || ($bonusId > 0)) && (!ifFatalEr
 										$content['banner'] = loadTemplate('mailid_banner', true);
 										if (getCodeLength() > 0) {
 											// Generate Code
-											$content['image'] = generateCaptchaCode($code, $type, $urlId, $userId);
+											$content['image'] = generateCaptchaCode($realCode, $type, $urlId, $userId);
 											$templ = 'mailid_enter_code';
 										} else {
 											// Disabled code
-											$content['gfx'] = $img_code;
+											$content['gfx'] = $realCode;
 											$templ = 'mailid_confirm_buttom';
 										}