Some cleanups/improvements

[mailer.git] / birthday_confirm.php

diff --git a/birthday_confirm.php b/birthday_confirm.php
index 219a15f5cfd8e36fca19ce4645958e42f569ef18..a54278b22aa227dd12c9475d599e08edadd66128 100644 (file)
--- a/birthday_confirm.php
+++ b/birthday_confirm.php
@@ -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,7 +115,7 @@ if (SQL_NUMROWS($result) == 1) {
 }
 
 // Free memory
-SQL_FREERESULT($result);
+sqlFreeResult($result);
 
 // Set this because there is no module in URI
 $GLOBALS['__module'] = 'birthday_confirm';