X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=birthday_confirm.php;h=51c7c936295d4c320f133ece64f2b68a05c5b79a;hb=89d7185efed1ad8a862b30555b6ba6e0b668ed8d;hp=469104d454243cbbd4804577dd0b36451e998d28;hpb=596c8ab32594401ca84abfbfe35513ddfff31bec;p=mailer.git

diff --git a/birthday_confirm.php b/birthday_confirm.php
index 469104d454..51c7c93629 100644
--- 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,
@@ -117,12 +123,6 @@ $GLOBALS['__module'] = 'birthday_confirm';
 // Include header
 loadIncludeOnce('inc/header.php');
 
-// Load birthday header template (for your banners, e.g.?)
-$content['header'] =  loadTemplate('birthday_header', TRUE);
-
-// Load birthday footer template (for your banners, e.g.?)
-$content['footer'] =  loadTemplate('birthday_footer', TRUE);
-
 // Load final template and output it
 loadTemplate('birthday_confirm', FALSE, $content);