X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=birthday_confirm.php;h=a54278b22aa227dd12c9475d599e08edadd66128;hp=607dd32c9e8c5e02e4311d10f8997f7c87e71dff;hb=ef93474b89c9e51dd97f4eb79b260630f05216f2;hpb=4f7df133f736da124e6f7bd02008b9093f736451

diff --git a/birthday_confirm.php b/birthday_confirm.php
index 607dd32c9e..a54278b22a 100644
--- a/birthday_confirm.php
+++ b/birthday_confirm.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
+ * Copyright (c) 2009 - 2013 by Mailer Developer Team                   *
  * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -61,7 +61,7 @@ $userid = bigintval(getRequestElement('userid'));
 $chk = bigintval(getRequestElement('check'), FALSE);
 
 // Check if link is not clicked so far
-$result = SQL_QUERY_ESC("SELECT
+$result = sqlQueryEscaped("SELECT
 	`b`.`points`,
 	`d`.`userid`,
 	`d`.`gender`,
@@ -83,15 +83,15 @@ LIMIT 1",
 		$userid,
 		$chk
 	), __FILE__, __LINE__);
-//* DEBUG: */ debugOutput("userid=".$userid.",chk=".$chk." (".strlen($chk).'/'.strlen(getRequestElement('check')).'/'.SQL_NUMROWS($result) . ')');
+//* DEBUG: */ debugOutput("userid=".$userid.",chk=".$chk." (".strlen($chk).'/'.strlen(getRequestElement('check')).'/'.sqlNumRows($result) . ')');
 
 // Prepare content
 $content = array();
 
 // Is an entry there?
-if (SQL_NUMROWS($result) == 1) {
+if (sqlNumRows($result) == 1) {
 	// Ok, congratulation again! Here's your gift from us...
-	$data = SQL_FETCHARRAY($result, FALSE);
+	$data = sqlFetchArray($result, FALSE);
 
 	// Is the account confirmed?
 	if ($data['status'] == 'CONFIRMED') {
@@ -100,7 +100,7 @@ if (SQL_NUMROWS($result) == 1) {
 		addPointsThroughReferralSystem('birthday_confirm', $userid, $data['points']);
 
 		// Remove entry from table
-		SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_birthday` WHERE `userid`=%s AND `chk_value`='%s' LIMIT 1",
+		sqlQueryEscaped("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_birthday` WHERE `userid`=%s AND `chk_value`='%s' LIMIT 1",
 			array($userid, $chk), __FILE__, __LINE__);
 
 		// Load message from template
@@ -115,20 +115,14 @@ if (SQL_NUMROWS($result) == 1) {
 }
 
 // Free memory
-SQL_FREERESULT($result);
+sqlFreeResult($result);
 
-// Set this because we have no module in URI
+// Set this because there is no module in URI
 $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);