- SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_refbanner` SET clicks=clicks+1 WHERE `id`=%s LIMIT 1", array(bigintval(getRequestElement('banner'))), __FILE__, __LINE__);
- if (SQL_AFFECTEDROWS() == 1) {
- if (isGetRequestElementSet('user')) {
- redirectToUrl('ref.php?refid=' . bigintval(getRequestElement('user')));
- } elseif (isGetRequestElementSet('reseller')) {
- redirectToUrl('shop_reseller.php?reseller=' . bigintval(getRequestElement('reseller')));
- }
+ SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_refbanner` SET `clicks`=`clicks`+1 WHERE `id`=%s LIMIT 1", array(bigintval(getRequestElement('banner'))), __FILE__, __LINE__);
+
+ // A line has been updated?
+ if ((!SQL_HASZEROAFFECTED()) && (isGetRequestElementSet('user'))) {
+ // Redirect to the user's referral link
+ redirectToUrl('ref.php?refid=' . bigintval(getRequestElement('user')));