* -------------------------------------------------------------------- *
* Kurzbeschreibung : Geburtstagsgutschrift bestaetigen *
* -------------------------------------------------------------------- *
- * $Revision:: $ *
- * $Date:: $ *
- * $Tag:: 0.2.1-FINAL $ *
- * $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 *
$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(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') {
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
}
// 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);
+loadPageHeader();
// Load final template and output it
loadTemplate('birthday_confirm', FALSE, $content);
// Include footer
-loadIncludeOnce('inc/footer.php');
+loadPageFooter();
// [EOF]
?>