- $CLICK = 1;
- $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_refbanner SET clicks=clicks+1 WHERE id=%d LIMIT 1", array(bigintval($_GET['banner'])), __FILE__, __LINE__);
- if (SQL_AFFECTEDROWS($link) == 1) {
- if (!empty($_GET['user'])) {
- LOAD_URL(URL."/ref.php?refid=".bigintval($_GET['user']));
- } else {
- LOAD_URL(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(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')));