if (isAdmin()) $whereStatement = '';
$result = SQL_QUERY("SELECT `id`, `url`, `alternate`, `counter`, `clicks` FROM `{?_MYSQL_PREFIX?}_refbanner`", __FILE__, __LINE__);
-if (SQL_NUMROWS($result) > 0) {
+if (!SQL_HASZERONUMS($result)) {
// List available ref banners
- $OUT = ''; $SW = 2;
+ $OUT = '';
while ($row = SQL_FETCHARRAY($result)) {
- $test = str_replace(getConfig('URL'), getConfig('PATH'), $row['url']); $size = '0';
+ $test = str_replace(getUrl(), getPath(), $row['url']); $size = '0';
if ($test == $row['url']) {
// Download banner (I hope you keep the banner on same server???)
$fp = sendGetRequest($row['url']); $bannerContent = '';
if ($size > 0) $row['alternate'] .= ' (' .translateComma(round($size / 102.4) / 10) . ' {--KBYTES--})';
// Add some more data
- $row['sw'] = $SW;
$row['userid'] = getMemberId();
// Add row
$OUT .= loadTemplate('member_reflinks_row', true, $row);
-
- // Switchcolors
- $SW = 3 - $SW;
} // END - while
// Load final template