- $CLICK = 1;
- $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_refbanner SET clicks=clicks+1 WHERE id=%s LIMIT 1", array(bigintval($_GET['banner'])), __FILE__, __LINE__);
- if (SQL_AFFECTEDROWS() == 1) {
- if (!empty($_GET['user'])) {
- LOAD_URL("ref.php?refid=".bigintval($_GET['user']));
- } else {
- LOAD_URL("shop_reseller.php?reseller=".bigintval($_GET['user']));
- }
+ SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_refbanner` SET `clicks`=`clicks`+1 WHERE `id`=%s LIMIT 1", array(bigintval(getRequestParameter('banner'))), __FILE__, __LINE__);
+
+ // A line has been updated?
+ if ((SQL_AFFECTEDROWS() == 1) && (isGetRequestParameterSet('user'))) {
+ // Redirect to the user's referal link
+ redirectToUrl('ref.php?refid=' . bigintval(getRequestParameter('user')));