X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmails%2Fbirthday_mails.php;h=0d3e2ef4a2c3a20768587ef21c3bc02d91ab9f88;hb=c3ea029c279923888cebf39020fe152c4540fbe8;hp=d0faabfc5e919e0d4b1d3a5947eaf73ffe66e125;hpb=307a4e11763f0914e73dc756b219356e1c29ab25;p=mailer.git

diff --git a/inc/mails/birthday_mails.php b/inc/mails/birthday_mails.php
index d0faabfc5e..0d3e2ef4a2 100644
--- a/inc/mails/birthday_mails.php
+++ b/inc/mails/birthday_mails.php
@@ -62,7 +62,7 @@ if (($_CONFIG['birthday_active']) && (EXT_IS_ACTIVE("autopurge")) && ($_CONFIG['
 // Only confirmed members shall receive birthday mails...
 $result_birthday = SQL_QUERY_ESC("SELECT userid, email, birth_year
 FROM "._MYSQL_PREFIX."_user_data
-WHERE status='CONFIRMED' AND birth_day=%d AND birth_month=%d AND birthday_sent < ".(time() - (ONE_DAY*364)).$ADD."
+WHERE status='CONFIRMED' AND birth_day=%s AND birth_month=%s AND birthday_sent < ".(time() - (ONE_DAY*364)).$ADD."
 ORDER BY userid",
  array($DAY, $MONTH, $VALUE), __FILE__, __LINE__);
 
@@ -108,7 +108,7 @@ if (SQL_NUMROWS($result_birthday) > 0)
 		SEND_EMAIL($email, HAPPY_BIRTHDAY, $msg);
 
 		// Remember him that he has received a birthday mail
-		$result_bd = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET birthday_sent=UNIX_TIMESTAMP() WHERE userid=%d LIMIT 1",
+		$result_bd = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET birthday_sent=UNIX_TIMESTAMP() WHERE userid=%s LIMIT 1",
 		 array(bigintval($uid)), __FILE__, __LINE__);
 	}