Previous fix fixed, a lot constants rewritten (unfinished)

[mailer.git] / inc / modules / member / what-reflinks.php

diff --git a/inc/modules/member/what-reflinks.php b/inc/modules/member/what-reflinks.php
index f597c457fddfe9e16ae48cfe835bd4386b2c7cce..8b400c254c3efcd9c36ce6d99a1c1b59e1d7cdfa 100644 (file)
--- a/inc/modules/member/what-reflinks.php
+++ b/inc/modules/member/what-reflinks.php
@@ -43,13 +43,13 @@ 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",
+$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("<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 />
+<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")) {
@@ -59,20 +59,20 @@ if (EXT_IS_ACTIVE("nickname")) {
        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 {
                // Display link to nickname form
                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>");
+<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."</div><br /><br />");
-$whereStatement = " WHERE visible='Y'";
+$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) {
        // List available ref banners
@@ -119,7 +119,7 @@ if (SQL_NUMROWS($result) > 0) {
        LOAD_TEMPLATE("member_reflinks_table", false, $GLOBALS['userid']);
 } else {
        // No refbanner found!
-       LOAD_TEMPLATE("admin_settings_saved", false, MEMBER_NO_REFBANNER_FOUND);
+       LOAD_TEMPLATE("admin_settings_saved", false, getMessage('MEMBER_NO_REFBANNER_FOUND'));
 }
 
 // Free result