Fix for inserted codes while registering of extensions, many rewrites/cleanups:

[mailer.git] / birthday_confirm.php

diff --git a/birthday_confirm.php b/birthday_confirm.php
index 157a0358374aafd53e68b270b9271db46f01e4f5..91d5f911c3068a2539ec0360f4bed9375ccb7881 100644 (file)
--- a/birthday_confirm.php
+++ b/birthday_confirm.php
@@ -64,16 +64,16 @@ $chk = bigintval(getRequestParameter('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
 INNER JOIN
        `{?_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,