X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=birthday_confirm.php;h=c018d591d5cfb607f1477f993855f53153e5dd18;hp=d1284aec6bbb346b8446aec0c216e2d84ff0b359;hb=30c4ffdadae5e5a2a39528fa9d8de4803055f123;hpb=2ec9007220186d54f84846871ed1f7638c29baf7

diff --git a/birthday_confirm.php b/birthday_confirm.php
index d1284aec6b..c018d591d5 100644
--- a/birthday_confirm.php
+++ b/birthday_confirm.php
@@ -66,11 +66,16 @@ $chk = bigintval(REQUEST_GET('check'), false);
 
 // Check if link is not clicked so far
 $result = SQL_QUERY_ESC("SELECT b.points, 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
-WHERE b.userid=%s AND b.chk_value='%s' LIMIT 1",
-array($uid, $chk), __FILE__, __LINE__);
+FROM
+	`{!_MYSQL_PREFIX!}_user_birthday` AS b
+INNER JOIN
+	`{!_MYSQL_PREFIX!}_user_data` AS d
+ON
+	b.userid=d.userid
+WHERE
+	b.userid=%s AND b.chk_value='%s'
+LIMIT 1",
+	array($uid, $chk), __FILE__, __LINE__);
 //* DEBUG: */ echo "uid=".$uid.",chk=".$chk." (".strlen($chk).'/'.strlen(REQUEST_GET('check')).'/'.SQL_NUMROWS($result).")<br />\n";
 
 // Prepare content