Filters for configurable userid exclusion added:

[mailer.git] / birthday_confirm.php

diff --git a/birthday_confirm.php b/birthday_confirm.php
index 20e2f6eeab7065aea291d77ce3a555f5a724d2a6..607dd32c9e8c5e02e4311d10f8997f7c87e71dff 100644 (file)
--- a/birthday_confirm.php
+++ b/birthday_confirm.php
@@ -62,16 +62,22 @@ $chk = bigintval(getRequestElement('check'), FALSE);
 
 // Check if link is not clicked so far
 $result = SQL_QUERY_ESC("SELECT
-       b.`points`, d.`userid`, d.`gender`, d.`surname`, d.`family`, d.`status`, d.`ref_payout`
+       `b`.`points`,
+       `d`.`userid`,
+       `d`.`gender`,
+       `d`.`surname`,
+       `d`.`family`,
+       `d`.`status`,
+       `d`.`ref_payout`
 FROM
-       `{?_MYSQL_PREFIX?}_user_birthday` AS b
+       `{?_MYSQL_PREFIX?}_user_birthday` AS `b`
 INNER JOIN
-       `{?_MYSQL_PREFIX?}_user_data` AS d
+       `{?_MYSQL_PREFIX?}_user_data` AS `d`
 ON
-       b.`userid`=d.`userid`
+       `b`.`userid`=`d`.`userid`
 WHERE
-       b.`userid`=%s AND
-       b.`chk_value`='%s'
+       `b`.`userid`=%s AND
+       `b`.`chk_value`='%s'
 LIMIT 1",
        array(
                $userid,