X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmails%2Fbirthday_mails.php;h=be67b650fd7b89fc5d547f34d8899fb128031ab2;hp=0a69e1c09ed01ac7e256086bee540e18f3fe7885;hb=5bdeaf8b452206598b6c6cd4f941145b11a0eccc;hpb=cca98f57dff720b174d21d071cee8303462485d7

diff --git a/inc/mails/birthday_mails.php b/inc/mails/birthday_mails.php
index 0a69e1c09e..be67b650fd 100644
--- a/inc/mails/birthday_mails.php
+++ b/inc/mails/birthday_mails.php
@@ -57,7 +57,7 @@ if ((getConfig('birthday_active')) && (EXT_IS_ACTIVE("autopurge")) && (getConfig
 
 // Only confirmed members shall receive birthday mails...
 $result_birthday = SQL_QUERY_ESC("SELECT userid, email, birth_year
-FROM `{!MYSQL_PREFIX!}_user_data`
+FROM `{!_MYSQL_PREFIX!}_user_data`
 WHERE status='CONFIRMED' AND birth_day=%s AND birth_month=%s AND birthday_sent < (UNIX_TIMESTAMP() - ".(getConfig('one_day') * 364).")".$ADD."
 ORDER BY userid",
  array($DAY, $MONTH, $VALUE), __FILE__, __LINE__);
@@ -85,7 +85,7 @@ if (SQL_NUMROWS($result_birthday) > 0) {
 			}
 
 			// Insert row into database
-			SQL_QUERY_ESC("INSERT INTO `{!MYSQL_PREFIX!}_user_birthday` (userid, points, chk_value) VALUES ('%s','%s','%s' )",
+			SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_user_birthday` (userid, points, chk_value) VALUES ('%s','%s','%s' )",
 				array(bigintval($uid), getConfig('birthday_points'), $content['check']), __FILE__, __LINE__);
 
 			// Load email template with confirmation link
@@ -99,7 +99,7 @@ if (SQL_NUMROWS($result_birthday) > 0) {
 		SEND_EMAIL($uid, HAPPY_BIRTHDAY, $msg);
 
 		// Remember him that he has received a birthday mail
-		SQL_QUERY_ESC("UPDATE `{!MYSQL_PREFIX!}_user_data` SET birthday_sent=UNIX_TIMESTAMP() WHERE userid=%s LIMIT 1",
+		SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET birthday_sent=UNIX_TIMESTAMP() WHERE userid=%s LIMIT 1",
 			array(bigintval($uid)), __FILE__, __LINE__);
 	}