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(getUserId()), __FILE__, __LINE__);
-list($c) = SQL_FETCHROW($result);
+$result = SQL_QUERY_ESC("SELECT `ref_clicks` FROM `{!_MYSQL_PREFIX!}_user_data` WHERE `userid`=%s LIMIT 1",
+ array(getUserId()), __FILE__, __LINE__);
+$content = SQL_FETCHARRAY($result);
SQL_FREERESULT($result);
OUTPUT_HTML("<div class=\"tiny\">{--YOUR_PERSONAL_REFLINK--}:<br />
}
// Clicks on your reflink
-OUTPUT_HTML("{--YOUR_REFCLICKS--}: <strong>".$c."</strong> {--CLICKS--}</div><br /><br />");
+OUTPUT_HTML("{--YOUR_REFCLICKS--}: <strong>".$content['ref_clicks']."</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) {
// List available ref banners
// will cause an "Invalid argument supplied for foreach()" error
foreach ($fp as $f) {
$bannerContent .= $f;
- }
- }
+ } // END - foreach
+ } // END - if
$size = strlen($bannerContent);
} elseif (isFileReadable($test)) {
$size = filesize($test);
}
- if ($size > 0) $content['alternate'] .= " (".translateComma(round($size/102.4)/10)." {--KBYTES--})";
+ if ($size > 0) $content['alternate'] .= ' (' .translateComma(round($size / 102.4) / 10) . ' {--KBYTES--})';
- // Load banner data
- // @TODO Rewritings: alt->alternate,cnt->counter,cks->clicks,uid->userid in template
- $content = array(
- 'sw' => $SW,
- 'url' => $content['url'],
- 'alt' => $content['alternate'],
- 'cnt' => $content['counter'],
- 'cks' => $content['clicks'],
- 'uid' => getUserId(),
- 'id' => $content['id'],
- );
+ // Add some more data
+ $content['sw'] = $SW;
+ $content['userid'] = getUserId();
// Add row
- $OUT .= LOAD_TEMPLATE("member_reflinks_row", true, $content);
+ $OUT .= LOAD_TEMPLATE('member_reflinks_row', true, $content);
// Switchcolors
$SW = 3 - $SW;
- }
+ } // END - while
define('__REFLINKS_ROWS', $OUT);
// Load final template
- LOAD_TEMPLATE("member_reflinks_table", false, getUserId());
+ LOAD_TEMPLATE('member_reflinks_table', false, getUserId());
} else {
// No refbanner found!
LOAD_TEMPLATE('admin_settings_saved', false, getMessage('MEMBER_NO_REFBANNER_FOUND'));
// Free result
SQL_FREERESULT($result);
-//
+// [EOF]
?>