X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fguest%2Fwhat-sponsor_infos.php;h=caa6b13ad2ac226a2fbd7d3c64fc4e6641d72bae;hb=c5e685ff1b1bd296243b9bfcd8921969fa09d53f;hp=39cf47fe7ea9c0158da1e5ddaee4a35bfccea267;hpb=b8ba3824d640da47d5f81485650b5885ba60867b;p=mailer.git

diff --git a/inc/modules/guest/what-sponsor_infos.php b/inc/modules/guest/what-sponsor_infos.php
index 39cf47fe7e..caa6b13ad2 100644
--- a/inc/modules/guest/what-sponsor_infos.php
+++ b/inc/modules/guest/what-sponsor_infos.php
@@ -35,11 +35,7 @@ if (!defined('__SECURITY')) {
 	$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4)."/security.php";
 	require($INC);
 } elseif ((!EXT_IS_ACTIVE("sponsor"))) {
-	if (IS_ADMIN()) {
-		ADD_FATAL(sprintf(EXTENSION_PROBLEM_NOT_INSTALLED, "sponsor"));
-	} else {
-		ADD_FATAL(EXTENSION_PROBLEM_EXT_INACTIVE, "sponsor");
-	}
+	addFatalMessage(getMessage('EXTENSION_PROBLEM_EXT_INACTIVE'), "sponsor");
 	return;
 }
 
@@ -51,9 +47,9 @@ unset($result_act);
 
 // Load all sponsor actions
 $result_act = SQL_QUERY("SELECT DISTINCT m.title, c.conv_rate, c.conv_name
-FROM "._MYSQL_PREFIX."_sponsor_menu AS m
-LEFT JOIN "._MYSQL_PREFIX."_sponsor_action_convert AS c ON m.what=c.ext_name
-LEFT JOIN "._MYSQL_PREFIX."_sponsor_registry AS r ON m.what=r.ext_name
+FROM `{!_MYSQL_PREFIX!}_sponsor_menu` AS m
+LEFT JOIN `{!_MYSQL_PREFIX!}_sponsor_action_convert` AS c ON m.what=c.ext_name
+LEFT JOIN `{!_MYSQL_PREFIX!}_sponsor_registry` AS r ON m.what=r.ext_name
 WHERE m.action='actions' AND r.is_active='Y'
 ORDER BY m.sort ASC", __FILE__, __LINE__);
 $num_act = SQL_NUMROWS($result_act);
@@ -76,7 +72,7 @@ if ($num_act > 0) {
 	} // END - while
 
 	// Check for pay types
-	$result_pay = SQL_QUERY("SELECT pay_name, pay_rate, pay_min_count, pay_currency FROM "._MYSQL_PREFIX."_sponsor_paytypes ORDER BY pay_name", __FILE__, __LINE__);
+	$result_pay = SQL_QUERY("SELECT pay_name, pay_rate, pay_min_count, pay_currency FROM `{!_MYSQL_PREFIX!}_sponsor_paytypes` ORDER BY pay_name", __FILE__, __LINE__);
 	if (SQL_NUMROWS($result_pay) > 0) {
 		// Load all pay types
 		$OUT_PAY = ""; $SW = 2;
@@ -97,18 +93,18 @@ if ($num_act > 0) {
 		}
 	} else {
 		// No pay types setuped so far!
-		$OUT_PAY = "<TR><TD colspan=\"2\">
+		$OUT_PAY = "<tr><td colspan=\"2\">
   ".LOAD_TEMPLATE("admin_settings_saved", true, SPONSOR_NO_ACTIONS_ACTIVATED)."
-</TD></TR>";
+</td></tr>";
 	}
 } else {
 	// No actions activated so far!
-	$OUT_ACT = "<TR><TD colspan=\"2\" class=\"bottom2\" style=\"padding-top: 10px; padding-bottom: 10px\">
+	$OUT_ACT = "<tr><td colspan=\"2\" class=\"bottom2\" style=\"padding-top: 10px; padding-bottom: 10px\">
   ".LOAD_TEMPLATE("admin_settings_saved", true, SPONSOR_NO_ACTIONS_ACTIVATED)."
-</TD></TR>";
-	$OUT_PAY = "<TR><TD colspan=\"2\" class=\"bottom2\" style=\"padding-top: 10px; padding-bottom: 10px\">
+</td></tr>";
+	$OUT_PAY = "<tr><td colspan=\"2\" class=\"bottom2\" style=\"padding-top: 10px; padding-bottom: 10px\">
   ".LOAD_TEMPLATE("admin_settings_saved", true, SPONSOR_NO_ACTIONS_ACTIVATED)."
-</TD></TR>";
+</td></tr>";
 }
 
 // Transfer rows to constans