X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=mailid_top.php;h=cf0ec430c2162794333a642b0241cdcb3bc7e759;hp=b477247c6df7431a4ece9534310432a8241d612b;hb=09f120bc3ab97a58ba6abbb519fbe124cebbbaed;hpb=cca98f57dff720b174d21d071cee8303462485d7

diff --git a/mailid_top.php b/mailid_top.php
index b477247c6d..cf0ec430c2 100644
--- a/mailid_top.php
+++ b/mailid_top.php
@@ -32,7 +32,7 @@
  ************************************************************************/
 
 // Load security stuff here (Oh, I hope this is not unsecure? Am I paranoia??? ;-) )
-require_once("inc/libs/security_functions.php");
+require("inc/libs/security_functions.php");
 
 // Init "action" and "what"
 global $what, $action;
@@ -62,15 +62,15 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
 	// 01        1        12            2    2            21    1                   22     10
 	if (($url_uid) > 0 && (($url_mid > 0) || ($url_bid > 0)) && (getTotalFatalErrors() == 0)) {
 		// No image? Then output header
-		if ($mode != "img") require_once(PATH."inc/header.php");
+		if ($mode != "img") LOAD_INC_ONCE("inc/header.php");
 
 		// Maybe he wants to confirm an email?
 		if ($url_mid > 0) {
-			$result = SQL_QUERY_ESC("SELECT id, link_type FROM `{!MYSQL_PREFIX!}_user_links` WHERE stats_id=%s AND userid=%s LIMIT 1",
+			$result = SQL_QUERY_ESC("SELECT id, link_type FROM `{!_MYSQL_PREFIX!}_user_links` WHERE stats_id=%s AND userid=%s LIMIT 1",
 			 array($url_mid, $url_uid), __FILE__, __LINE__);
 			$type = "mailid"; $DATA = $url_mid;
 		} elseif ($url_bid > 0) 	{
-			$result = SQL_QUERY_ESC("SELECT id, link_type FROM `{!MYSQL_PREFIX!}_user_links` WHERE bonus_id=%s AND userid=%s LIMIT 1",
+			$result = SQL_QUERY_ESC("SELECT id, link_type FROM `{!_MYSQL_PREFIX!}_user_links` WHERE bonus_id=%s AND userid=%s LIMIT 1",
 			 array($url_bid, $url_uid), __FILE__, __LINE__);
 			$type = "bonusid"; $DATA = $url_bid;
 		}
@@ -82,12 +82,12 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
 			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($url_mid), __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($url_bid), __FILE__, __LINE__);
 				break;
 			}
@@ -107,7 +107,7 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
 				if ($ltype == "BONUS") $sender = 0;
 
 				// Is the user's ID unlocked?
-				$result = SQL_QUERY_ESC("SELECT status, gender, surname, family, ref_payout FROM `{!MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
+				$result = SQL_QUERY_ESC("SELECT status, gender, surname, family, ref_payout FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
 					array($url_uid), __FILE__, __LINE__);
 				if (SQL_NUMROWS($result) == 1) {
 					// Load data
@@ -118,14 +118,14 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
 
 					if ($status == "CONFIRMED") {
 						// Update last activity
-						SQL_QUERY_ESC("UPDATE `{!MYSQL_PREFIX!}_user_data` SET last_online=UNIX_TIMESTAMP(), last_module='mailid_top' WHERE userid=%s LIMIT 1",
+						SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET last_online=UNIX_TIMESTAMP(), last_module='mailid_top' WHERE userid=%s LIMIT 1",
 							array($url_uid), __FILE__, __LINE__);
 
 						// User has confirmed his account so we can procede...
 						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__);
 
 							// Entry found?
@@ -141,7 +141,7 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
 							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?
@@ -173,7 +173,7 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
 									switch ($ltype)
 									{
 									case "NORMAL":
-										SQL_QUERY_ESC("UPDATE `{!MYSQL_PREFIX!}_user_stats` SET clicks=clicks + 1 WHERE id=%s LIMIT 1",
+										SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_stats` SET clicks=clicks + 1 WHERE id=%s LIMIT 1",
 											array($url_mid), __FILE__, __LINE__);
 
 										// Update mediadata as well
@@ -185,7 +185,7 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
 										break;
 
 									case "BONUS":
-										SQL_QUERY_ESC("UPDATE `{!MYSQL_PREFIX!}_bonus` SET clicks=clicks + 1 WHERE id=%s LIMIT 1",
+										SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_bonus` SET clicks=clicks + 1 WHERE id=%s LIMIT 1",
 											array($url_bid), __FILE__, __LINE__);
 
 										// Update mediadata as well
@@ -204,13 +204,13 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
 									// Only when user extension = v0.1.2: Update mails-confirmed counter
 									if (GET_EXT_VERSION("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($url_uid), __FILE__, __LINE__);
 
 										// Update random confirmed as well?
 										if (GET_EXT_VERSION("user") >= "0.3.4") {
 											// Update second counter
-											SQL_QUERY_ESC("UPDATE `{!MYSQL_PREFIX!}_user_data` SET rand_confirmed=rand_confirmed + 1 WHERE userid=%s LIMIT 1",
+											SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET rand_confirmed=rand_confirmed + 1 WHERE userid=%s LIMIT 1",
 												array($url_uid), __FILE__, __LINE__);
 										} // END - if
 									} // END - if
@@ -232,7 +232,7 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
 										} // END - if
 
 										// Count down ref_payout value
-										SQL_QUERY_ESC("UPDATE `{!MYSQL_PREFIX!}_user_data` SET ref_payout=ref_payout-1 WHERE userid=%s AND ref_payout > 0 LIMIT 1",
+										SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET ref_payout=ref_payout-1 WHERE userid=%s AND ref_payout > 0 LIMIT 1",
 											array($url_uid), __FILE__, __LINE__);
 
 										// Add points
@@ -276,7 +276,7 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
 									}
 
 									// Remove link from table
-									SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!MYSQL_PREFIX!}_user_links` WHERE id=%s LIMIT 1",
+									SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_user_links` WHERE id=%s LIMIT 1",
 										array(bigintval($lid)), __FILE__, __LINE__);
 									break;
 
@@ -348,7 +348,7 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
 		// Insert footer if no image
 		if ($mode != "img") {
 			// Write footer
-			require_once(PATH."inc/footer.php");
+			LOAD_INC_ONCE("inc/footer.php");
 		} // END - if
 	}
 } elseif ($mode != "img") {