X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=birthday_confirm.php;h=a54278b22aa227dd12c9475d599e08edadd66128;hp=f95f1f144b2fd9dfad305ae48e0dc2f730d6e30d;hb=a00ad7dd8c36a5322e28f38d8d641efb90c00c92;hpb=c3b4eaf29946349ff058691db2dcb615a5379bb2

diff --git a/birthday_confirm.php b/birthday_confirm.php
index f95f1f144b..a54278b22a 100644
--- a/birthday_confirm.php
+++ b/birthday_confirm.php
@@ -16,8 +16,8 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
- * For more information visit: http://www.mxchange.org                  *
+ * 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 *
  * it under the terms of the GNU General Public License as published by *
@@ -39,11 +39,11 @@
 require('inc/libs/security_functions.php');
 
 // Init start time
-$GLOBALS['startTime'] = microtime(true);
+$GLOBALS['__start_time'] = microtime(TRUE);
 
 // Set module
-$GLOBALS['module'] = 'birthday_confirm';
-$GLOBALS['output_mode'] = -1;
+$GLOBALS['__module']      = 'birthday_confirm';
+$GLOBALS['__output_mode'] = '0';
 
 // Load the required file(s)
 require('inc/config-global.php');
@@ -55,54 +55,59 @@ setContentType('text/html');
 redirectOnUninstalledExtension('birthday');
 
 // Script is installed so let's check for his confirmation link...
-$userid = bigintval(getRequestParameter('userid'));
+$userid = bigintval(getRequestElement('userid'));
 
 // Only allow numbers here...
-$chk = bigintval(getRequestParameter('check'), false);
+$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`
+$result = sqlQueryEscaped("SELECT
+	`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,
 		$chk
 	), __FILE__, __LINE__);
-//* DEBUG: */ debugOutput("userid=".$userid.",chk=".$chk." (".strlen($chk).'/'.strlen(getRequestParameter('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') {
 		// Add points to account
-		// @TODO Try to rewrite the following unset()
-		unset($GLOBALS['ref_level']);
-		addPointsThroughReferalSystem('birthday_confirm', $userid, $data['points'], false, 0, strtolower(getConfig('birthday_mode')));
+		initReferralSystem();
+		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
-		$content['message'] = loadTemplate('birthday_msg', true, $data);
+		$content['message'] = loadTemplate('birthday_msg', TRUE, $data);
 	} else {
 		// Unconfirmed / locked accounts cannot get points
-		$content['message'] = getMaskedMessage('MEMBER_BIRTHDAY_CANNOT_STATUS', translateUserStatus($data['status']));
+		$content['message'] = '{%message,MEMBER_BIRTHDAY_CANNOT_STATUS=' . $data['status'] . '%}';
 	}
 } else {
 	// Cannot load data!
@@ -110,22 +115,16 @@ if (SQL_NUMROWS($result) == 1) {
 }
 
 // Free memory
-SQL_FREERESULT($result);
+sqlFreeResult($result);
 
-// Set this because we have no module in URI
-$GLOBALS['module'] = 'birthday_confirm';
+// 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);
+loadTemplate('birthday_confirm', FALSE, $content);
 
 // Include footer
 loadIncludeOnce('inc/footer.php');