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")) {
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&what=nickname\">".PLEASE_CLICK_NICKNAME_FORM."</a>");
+<a class=\"tiny\" href=\"{!URL!}/modules.php?module=login&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
$SW = 2; $OUT = "";
while (list($id, $url, $alt, $count, $clks) = SQL_FETCHROW($result)) {
- $test = str_replace(URL, PATH, $url); $size = 0;
+ $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 = "";
+ $fp = GET_URL($url); $bannerContent = "";
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) {
- $file .= $f;
+ $bannerContent .= $f;
}
}
- $size = strlen($file);
+ $size = strlen($bannerContent);
} elseif (FILE_READABLE($test)) {
$size = filesize($test);
}
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