X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-reflinks.php;h=4a88da8c96099c45b4ee9d5bee809ac65b96d2df;hb=c47144dd555bbab4acdf9085e4623900dedb0e7c;hp=ee7d7827091d700945758f5c61810510d126a8d7;hpb=d0c792100bf4b67acd1824860204929c1540f6fb;p=mailer.git

diff --git a/inc/modules/member/what-reflinks.php b/inc/modules/member/what-reflinks.php
index ee7d782709..4a88da8c96 100644
--- a/inc/modules/member/what-reflinks.php
+++ b/inc/modules/member/what-reflinks.php
@@ -43,59 +43,49 @@ if (!defined('__SECURITY')) {
 ADD_DESCR("member", __FILE__);
 
 // Load current referal clicks
-$result = SQL_QUERY_ESC("SELECT ref_clicks FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s LIMIT 1",
- array($GLOBALS['userid']), __FILE__, __LINE__);
-
+$result = SQL_QUERY_ESC("SELECT ref_clicks FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
+	array($GLOBALS['userid']), __FILE__, __LINE__);
 list($c) = SQL_FETCHROW($result);
 SQL_FREERESULT($result);
 
-OUTPUT_HTML("<FONT class=\"tiny\">".YOUR_PERSONAL_REFLINK.":<br />
-<STRONG><A href=\"".URL."/ref.php?refid=".$GLOBALS['userid']."\" target=\"_blank\">".URL."/ref.php?ref=".$GLOBALS['userid']."</A></STRONG><br />
+OUTPUT_HTML("<div class=\"tiny\">".YOUR_PERSONAL_REFLINK.":<br />
+<strong><a href=\"{!URL!}/ref.php?refid=".$GLOBALS['userid']."\" target=\"_blank\">{!URL!}/ref.php?ref=".$GLOBALS['userid']."</a></strong><br />
 <br />");
 
-if (EXT_IS_ACTIVE("nickname"))
-{
+if (EXT_IS_ACTIVE("nickname")) {
 	// Add nickname link when nickname is entered
 	$nick = NICKNAME_GET_NICK($GLOBALS['userid']);
 
-	if (!empty($nick))
-	{
+	if (!empty($nick)) {
 		// Display nickname link
 		OUTPUT_HTML(NICKNAME_YOUR_REFLINK.":<br />
-<STRONG><A href=\"".URL."/ref.php?ref=".$nick."\" target=\"_blank\">".URL."/ref.php?ref=".$nick."</A></STRONG><br />
+<strong><a href=\"{!URL!}/ref.php?ref=".$nick."\" target=\"_blank\">{!URL!}/ref.php?ref=".$nick."</a></strong><br />
 <br />");
-	}
-	 else
-	{
+	} else {
 		// Display link to nickname form
-		OUTPUT_HTML("<STRONG class=\"guest_note\">".NO_NICKNAME_SET."</STRONG><br />
-<A class=\"tiny\" href=\"".URL."/modules.php?module=login&amp;what=nickname\">".PLEASE_CLICK_NICKNAME_FORM."</A>");
+		OUTPUT_HTML("<div class=\"guest_note\">".NO_NICKNAME_SET."</strong><br />
+<a class=\"tiny\" href=\"{!URL!}/modules.php?module=login&amp;what=nickname\">".PLEASE_CLICK_NICKNAME_FORM."</a>");
 	}
 }
 
 // Clicks on your reflink
-OUTPUT_HTML(YOUR_REFCLICKS.": <STRONG>".$c."</STRONG> ".CLICKS."</FONT><br /><br />");
-$whereStatement = " WHERE visible='Y'";
+OUTPUT_HTML(YOUR_REFCLICKS.": <strong>".$c."</strong> ".CLICKS."</div><br /><br />");
+$whereStatement = " WHERE `visible`='Y'";
 if (IS_ADMIN()) $whereStatement = "";
-$result = SQL_QUERY("SELECT id, url, alternate, counter, clicks FROM "._MYSQL_PREFIX."_refbanner", __FILE__, __LINE__);
+$result = SQL_QUERY("SELECT id, url, alternate, counter, clicks FROM `{!_MYSQL_PREFIX!}_refbanner`", __FILE__, __LINE__);
 
-if (SQL_NUMROWS($result) > 0)
-{
+if (SQL_NUMROWS($result) > 0) {
 	// List available ref banners
 	$SW = 2; $OUT = "";
-	while (list($id, $url, $alt, $count, $clks) = SQL_FETCHROW($result))
-	{
-		$test = str_replace(URL, PATH, $url); $size = 0;
-		if ($test == $url)
-		{
+	while (list($id, $url, $alt, $count, $clks) = SQL_FETCHROW($result)) {
+		$test = str_replace(URL, constant('PATH'), $url); $size = 0;
+		if ($test == $url) {
 			// Download banner (I hope you keep the banner on same server???)
 			$fp = GET_URL($url); $file = "";
-			if ((!empty($fp)) && (is_array($fp)) && (count($fp) > 0))
-			{
+			if ((!empty($fp)) && (is_array($fp)) && (count($fp) > 0) {
 				// Loads only found banner, when there is a 404 error this foreach() command
 				// will cause an "Invalid argument supplied for foreach()" error
-				foreach ($fp as $f)
-				{
+				foreach ($fp as $f) {
 					$file .= $f;
 				}
 			}
@@ -127,6 +117,9 @@ if (SQL_NUMROWS($result) > 0)
 
 	// Load final template
 	LOAD_TEMPLATE("member_reflinks_table", false, $GLOBALS['userid']);
+} else {
+	// No refbanner found!
+	LOAD_TEMPLATE("admin_settings_saved", false, getMessage('MEMBER_NO_REFBANNER_FOUND'));
 }
 
 // Free result