$whereStatement = " WHERE `visible`='Y'";
if (isAdmin()) $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` ORDER BY `id` ASC', __FILE__, __LINE__);
if (!SQL_HASZERONUMS($result)) {
// List available ref banners
$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 = '';
+ $fp = sendGetRequest($row['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
$row['userid'] = getMemberId();
// Add row
- $OUT .= loadTemplate('member_reflinks_row', true, $row);
+ $OUT .= loadTemplate('member_list_reflinks_row', true, $row);
} // END - while
// Load final template
- $content['refbanner_content'] = loadTemplate('member_reflinks_table', true, $OUT);
+ $content['refbanner_content'] = loadTemplate('member_list_reflinks', true, $OUT);
} else {
// No refbanner found
- $content['refbanner_content'] = loadTemplate('admin_settings_saved', true, '{--MEMBER_NO_REFBANNER_FOUND--}');
+ $content['refbanner_content'] = displayMessage('{--MEMBER_REFERAL_BANNER_404--}', true);
}
// Free result