X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=mailid.php;h=a573a245ff2cb018b2cf62dd7b51a8a55e9cd8ab;hp=58b41d6b753ae75a14c756354e94259b67a4bc34;hb=205769111aba361c7aa76a6b9791bffed1372241;hpb=2ec9007220186d54f84846871ed1f7638c29baf7

diff --git a/mailid.php b/mailid.php
index 58b41d6b75..a573a245ff 100644
--- a/mailid.php
+++ b/mailid.php
@@ -17,7 +17,7 @@
  * Needs to be in all Files and every File needs "svn propset           *
  * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
- * Copyright (c) 2003 - 2008 by Roland Haeder                           *
+ * Copyright (c) 2003 - 2009 by Roland Haeder                           *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -45,40 +45,39 @@ $GLOBALS['startTime'] = microtime(true);
 // Tell everyone we are in this module
 $GLOBALS['module'] = 'mailid';
 $GLOBALS['output_mode'] = -1;
+$errorCode = '';
 
 // Load the required file(s)
 require('inc/config-global.php');
 
-if (!isInstalled()) {
-	// You have to install first!
-	redirectToUrl('install.php');
-} // END - if
+// Set content type
+setContentType('text/html');
 
 // Is the extension active?
 redirectOnUninstalledExtension('mailid');
 
 // Init
-$url_uid = 0;
+$url_userid = 0;
 $url_bid = 0;
 $url_mid = 0;
 
 // Secure all data
-if (REQUEST_ISSET_GET('uid'))     $url_uid = bigintval(REQUEST_GET('uid'));
-if (REQUEST_ISSET_GET('mailid'))  $url_mid = bigintval(REQUEST_GET('mailid'));
-if (REQUEST_ISSET_GET('bonusid')) $url_bid = bigintval(REQUEST_GET('bonusid'));
+if (isGetRequestElementSet('userid'))     $url_userid = bigintval(getRequestElement('userid'));
+if (isGetRequestElementSet('mailid'))  $url_mid = bigintval(getRequestElement('mailid'));
+if (isGetRequestElementSet('bonusid')) $url_bid = bigintval(getRequestElement('bonusid'));
 
 // 01        1        12            3    32           21    1                   22     10
-if (($url_uid) > 0 && (($url_mid > 0) || ($url_bid > 0)) && (getTotalFatalErrors() == 0)) {
+if (($url_userid) > 0 && (($url_mid > 0) || ($url_bid > 0)) && (getTotalFatalErrors() == 0)) {
 	// Maybe he wants to confirm an email?
 	if ($url_mid > 0) {
 		// Normal-Mails
-		$result = SQL_QUERY_ESC("SELECT link_type FROM `{!_MYSQL_PREFIX!}_user_links` WHERE stats_id=%s AND `userid`=%s LIMIT 1",
-		array($url_mid, $url_uid), __FILE__, __LINE__);
+		$result = SQL_QUERY_ESC("SELECT `link_type` FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `stats_id`=%s AND `userid`=%s LIMIT 1",
+			array($url_mid, $url_userid), __FILE__, __LINE__);
 		$type = 'mailid'; $urlId = $url_mid;
 	} elseif ($url_bid > 0) {
 		// Bonus-Mail
-		$result = SQL_QUERY_ESC("SELECT link_type FROM `{!_MYSQL_PREFIX!}_user_links` WHERE bonus_id=%s AND `userid`=%s LIMIT 1",
-		array($url_bid, $url_uid), __FILE__, __LINE__);
+		$result = SQL_QUERY_ESC("SELECT `link_type` FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `bonus_id`=%s AND `userid`=%s LIMIT 1",
+			array($url_bid, $url_userid), __FILE__, __LINE__);
 		$type = 'bonusid'; $urlId = $url_bid;
 	} else {
 		// Problem: No ID entered
@@ -97,7 +96,7 @@ if (($url_uid) > 0 && (($url_mid > 0) || ($url_bid > 0)) && (getTotalFatalErrors
 		{
 			case 'NORMAL':
 				// Is the stats ID valid?
-				$result = SQL_QUERY_ESC("SELECT pool_id, url, subject FROM `{!_MYSQL_PREFIX!}_user_stats` WHERE `id`=%s LIMIT 1",
+				$result = SQL_QUERY_ESC("SELECT pool_id, url, subject FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `id`=%s LIMIT 1",
 				array($url_mid), __FILE__, __LINE__);
 				break;
 
@@ -106,7 +105,7 @@ if (($url_uid) > 0 && (($url_mid > 0) || ($url_bid > 0)) && (getTotalFatalErrors
 				redirectOnUninstalledExtension('bonus');
 
 				// Bonus-Mails
-				$result = SQL_QUERY_ESC("SELECT id, url, subject FROM `{!_MYSQL_PREFIX!}_bonus` WHERE `id`=%s LIMIT 1",
+				$result = SQL_QUERY_ESC("SELECT id, url, subject FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1",
 				array($url_bid), __FILE__, __LINE__);
 				break;
 
@@ -122,17 +121,14 @@ if (($url_uid) > 0 && (($url_mid > 0) || ($url_bid > 0)) && (getTotalFatalErrors
 			// Free result
 			SQL_FREERESULT($result);
 
-			// Compile extra title
-			$title = COMPILE_CODE($title);
-
 			// Set it
 			setExtraTitle($title);
 
 			// Is the user's ID unlocked?
-			$result = SQL_QUERY_ESC("SELECT status, gender, surname, family FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
-			array($url_uid), __FILE__, __LINE__);
+			$result = SQL_QUERY_ESC("SELECT `status`, `gender`, `surname`,` family` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s LIMIT 1",
+				array($url_userid), __FILE__, __LINE__);
 			if (SQL_NUMROWS($result) == 1) {
-				list($status, $gender, $sname, $fname) = SQL_FETCHROW($result);
+				list($status, $gender, $surname, $family) = SQL_FETCHROW($result);
 				SQL_FREERESULT($result);
 				if ($status == 'CONFIRMED') {
 					// User has confirmed his account so we can procede...
@@ -140,22 +136,22 @@ if (($url_uid) > 0 && (($url_mid > 0) || ($url_bid > 0)) && (getTotalFatalErrors
 					switch ($ltype)
 					{
 						case 'NORMAL':
-							$result = SQL_QUERY_ESC("SELECT payment_id FROM `{!_MYSQL_PREFIX!}_user_stats` WHERE pool_id=%s LIMIT 1",
+							$result = SQL_QUERY_ESC("SELECT payment_id FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE pool_id=%s LIMIT 1",
 								array(bigintval($pool)), __FILE__, __LINE__);
 							if (SQL_NUMROWS($result) == 1) {
 								list($pay) = SQL_FETCHROW($result);
 								$time      = getPaymentPoints($pay, 'time');
 								$payment   = getPaymentPoints($pay, 'payment');
 								$isValid   = true;
-							}
+							} // END - if
 
 							// Free memory
 							SQL_FREERESULT($result);
 							break;
 
 						case 'BONUS':
-							$result = SQL_QUERY_ESC("SELECT points, time FROM `{!_MYSQL_PREFIX!}_bonus` WHERE `id`=%s LIMIT 1",
-							array($url_bid), __FILE__, __LINE__);
+							$result = SQL_QUERY_ESC("SELECT points, time FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1",
+								array($url_bid), __FILE__, __LINE__);
 							if (SQL_NUMROWS($result) == 1) {
 								list($points, $time) = SQL_FETCHROW($result);
 								$payment = '0.00000';
@@ -177,65 +173,71 @@ if (($url_uid) > 0 && (($url_mid > 0) || ($url_bid > 0)) && (getTotalFatalErrors
 					// Was that mail a valid one?
 					if ($isValid === true) {
 						// If time is zero seconds we have a sponsor mail. 1 Second shall be set to avoid problems
-						if (($time == '0') && ($payment > 0)) { $URL = constant('URL'); $time = '1'; }
+						if (($time == '0') && ($payment > 0)) { $URL = getConfig('URL'); $time = '1'; }
 						if (($time > 0) && (($payment > 0) || ($points > 0))) {
-							// He can confirm this mail!
 							// Export data into constants for the template
-							// @TODO Rewrite these constants
-							define('_UID_VALUE' , $url_uid);
-							define('_TYPE_VALUE', $type);
-							define('_DATA_VALUE', $urlId);
-							define('_URL_VALUE' , DEREFERER($URL));
+							$content = array(
+								'userid'  => $url_userid,
+								'type' => $type,
+								'data' => $urlId,
+								'url'  => generateDerefererUrl($URL)
+							);
 
 							// Load template
-							LOAD_TEMPLATE('mailid_frames');
+							loadTemplate('mailid_frames');
 						} else {
-							$msg = getCode('DATA_INVALID');
+							$errorCode = getCode('DATA_INVALID');
 						}
 					} else {
-						$msg = getCode('POSSIBLE_INVALID');
+						$errorCode = getCode('POSSIBLE_INVALID');
 					}
 				} else {
-					$msg = getCode('ACCOUNT_LOCKED');
+					$errorCode = getCode('ACCOUNT_LOCKED');
 				}
 			} else {
 				SQL_FREERESULT($result);
-				$msg = getCode('USER_404');
+				$errorCode = getCode('USER_404');
 			}
 		} else {
 			SQL_FREERESULT($result);
-			$msg = getCode('STATS_404');
+			$errorCode = getCode('STATS_404');
 		}
 	} else {
 		SQL_FREERESULT($result);
-		$msg = getCode('ALREADY_CONFIRMED');
+		$errorCode = getCode('ALREADY_CONFIRMED');
 	}
 } else {
 	// Nothing entered
-	$msg = getCode('ERROR_MAILID');
+	$errorCode = getCode('ERROR_MAILID');
 }
 
 // Error code is set?
-if (!empty($msg)) {
-	// @TODO Rewrite this to a filter
+if (!empty($errorCode)) {
+	// @TODO Rewrite this to a dynamic include or so
 	switch (getConfig('mailid_error_redirect')) {
 		case 'INDEX': // Redirect to index page
-			redirectToUrl('modules.php?module=index&msg='.$msg.'&ext=mailid');
+			redirectToUrl('modules.php?module=index&code=' . $errorCode . '&ext=mailid');
 			break;
 
 		case 'REJECT': // Redirect to rejection page
-			redirectToConfiguredUrl('reject_url');
+			if (isExtensionActive('other')) {
+				// Redirect to configured URL
+				redirectToConfiguredUrl('reject_url');
+			} else {
+				// Redirect to index
+				redirectToUrl('index.php');
+			}
 			break;
 
 		default:
-			DEBUG_LOG(__FILE__, __LINE__, sprintf("Unknown status %s detected in mailid_error_redirect.", getConfig('mailid_error_redirect')));
-			redirectToUrl('modules.php?module=index&msg=' . getCode('UNKNOWN_STATUS') . '&ext=mailid');
+			logDebugMessage(__FILE__, __LINE__, sprintf("Unknown status %s detected in mailid_error_redirect.", getConfig('mailid_error_redirect')));
+			redirectToUrl('modules.php?module=index&code=' . getCode('UNKNOWN_STATUS') . '&ext=mailid');
 			break;
-	}
-} else {
-	// Include footer
-	loadIncludeOnce('inc/footer.php');
-}
+	} // END - switch
+} // END - if
+
+// Include footer
+loadIncludeOnce('inc/footer.php');
 
 // [EOF]
 ?>