$whereStatement = " WHERE `visible`='Y'";
if (isAdmin()) $whereStatement = '';
-$result = SQL_QUERY('SELECT `id`, `url`, `alternate`, `counter`, `clicks` FROM `{?_MYSQL_PREFIX?}_refbanner` ORDER BY `id` ASC', __FILE__, __LINE__);
+$result = sqlQuery('SELECT `id`, `url`, `alternate`, `counter`, `clicks` FROM `{?_MYSQL_PREFIX?}_refbanner` ORDER BY `id` ASC', __FILE__, __LINE__);
-if (!SQL_HASZERONUMS($result)) {
+if (!ifSqlHasZeroNums($result)) {
// List available ref banners
$OUT = '';
- while ($row = SQL_FETCHARRAY($result)) {
+ while ($row = sqlFetchArray($result)) {
$test = str_replace(getUrl(), getPath(), $row['url']); $size = '0';
if ($test == $row['url']) {
// Download banner (I hope you keep the banner on same server???)
$content['refbanner_content'] = loadTemplate('member_list_reflinks', TRUE, $OUT);
} else {
// No refbanner found
- $content['refbanner_content'] = displayMessage('{--MEMBER_REFERRAL_BANNER_404--}', TRUE);
+ $content['refbanner_content'] = returnMessage('{--MEMBER_REFERRAL_BANNER_404--}');
}
// Free result
-SQL_FREERESULT($result);
+sqlFreeResult($result);
// Add extra content through filter
$content['extra_content'] = runFilterChain('member_reflink_extra_content');