Continued a bit:

[mailer.git] / beg.php

diff --git a/beg.php b/beg.php
index bd6e262d5c9ae9d31cebf9a7123d0ecf46a52169..2d52ee717b264ad6df19a45f218e8f41cbd096d6 100644 (file)
--- a/beg.php
+++ b/beg.php
@@ -10,13 +10,8 @@
  * -------------------------------------------------------------------- *
  * Kurzbeschreibung  : Bettel-Link fuer Mitglieder                      *
  * -------------------------------------------------------------------- *
- * $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 - 2016 by Mailer Developer Team                   *
  * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -65,7 +60,7 @@ if (isGetRequestElementSet('userid')) {
 
        // Validate if it is not a number
        if ((isExtensionActive('nickname')) && (isNicknameUsed(getRequestElement('userid')))) {
-               // Maybe we have found a nickname?
+               // Maybe a nickname is provided?
                fetchUserData(getRequestElement('userid'), 'nickname');
        } elseif (isNicknameUsed(getRequestElement('userid'))) {
                // Nickname entered but nickname is not active
@@ -79,7 +74,7 @@ if (isGetRequestElementSet('userid')) {
        $status = 'failed';
 
        // Check if account was found
-       if ((isUserDataValid()) && (getUserData('status') == 'CONFIRMED')) {
+       if ((isValidUserData()) && (getUserData('status') == 'CONFIRMED')) {
                /*
                 * Multiply configured values with 100000 and divide with 100000 so we can also handle small values
                 * If we need more number behind the decimal dot then we just need to increase all these three
@@ -90,28 +85,26 @@ if (isGetRequestElementSet('userid')) {
                // Set nickname / userid for template
                $content['userid']        = getRequestElement('userid');
                $content['clicks']        = (getUserData('beg_clicks') + 1);
-               $content['header_banner'] = loadTemplate('beg_header_banner', TRUE);
-               $content['footer_banner'] = loadTemplate('beg_footer_banner', TRUE);
                $content['points']        = $points;
        } // END - if
 
        // User id valid and not webmaster's id?
-       if ((isValidUserId(getUserData('userid'))) && (getBegUserid() != getUserData('userid'))) {
+       if ((isValidId(getUserData('userid'))) && (getBegUserid() != getUserData('userid'))) {
                // Update counter
-               SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `beg_clicks`=`beg_clicks`+1 WHERE `userid`=%s LIMIT 1",
+               sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `beg_clicks`=`beg_clicks`+1 WHERE `userid`=%s LIMIT 1",
                        array(getUserData('userid')), __FILE__, __LINE__);
 
                // Check for last entry for userid w/o IP number                            12              33                               2    23              44            3                                          21     1                              1
-               $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_beg_ips` WHERE ((UNIX_TIMESTAMP() - `timeout`) >= {?beg_timeout?} OR ((UNIX_TIMESTAMP() - `timeout`) >= {?beg_userid_timeout?} AND `userid`=%s)) AND (`remote_ip`='%s' OR `sid`='%s') LIMIT 1",
+               $result = sqlQueryEscaped("SELECT `id` FROM `{?_MYSQL_PREFIX?}_beg_ips` WHERE ((UNIX_TIMESTAMP() - `timeout`) >= {?beg_timeout?} OR ((UNIX_TIMESTAMP() - `timeout`) >= {?beg_userid_timeout?} AND `userid`=%s)) AND (`remote_ip`='%s' OR `sid`='%s') LIMIT 1",
                        array(
                                getUserData('userid'),
-                               detectRemoteAddr(),
+                               determineRealRemoteAddress(),
                                session_id()
                        ), __FILE__, __LINE__);
 
                // Entry not found, points set and not logged in?
                //* DEBUG: */ logDebugMessage(__FILE__, __LINE__, 'SQL_HASZERONUMS()=' . intval(SQL_HASZERONUMS($result)) . ',isAdmin()=' . intval(isAdmin()) . ',points=' . $points . ',isMember()=' . intval(isMember()) . ',getBegPayMode()=' . getBegPayMode());
-               if ((SQL_HASZERONUMS($result)) && ($points > 0) && (getBegPayMode() == 'NONE') && ((!isMember()) || (isAdmin()))) {
+               if ((ifSqlHasZeroNumRows($result)) && ($points > 0) && (getBegPayMode() == 'NONE') && ((!isMember()) || (isAdmin()))) {
                        // Default is result from isAdmin(), mostly false
                        $isPayed = isAdmin();
 
@@ -122,15 +115,15 @@ if (isGetRequestElementSet('userid')) {
                                 * but only when there is no admin begging.
                                 * Admins shall be able to test it!
                                 */
-                               SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_beg_ips` (`userid`, `remote_ip`, `sid`, `timeout`) VALUES ('%s','%s','%s', UNIX_TIMESTAMP())",
+                               sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_beg_ips` (`userid`, `remote_ip`, `sid`, `timeout`) VALUES ('%s','%s','%s', UNIX_TIMESTAMP())",
                                        array(
                                                getUserData('userid'),
-                                               detectRemoteAddr(),
+                                               determineRealRemoteAddress(),
                                                session_id()
                                        ), __FILE__, __LINE__);
 
                                // Was is successfull?
-                               $isPayed = (!SQL_HASZEROAFFECTED());
+                               $isPayed = (!ifSqlHasZeroAffectedRows());
                        } // END - if
 
                        // Pay points?
@@ -161,10 +154,10 @@ if (isGetRequestElementSet('userid')) {
                }
 
                // Free memory
-               SQL_FREERESULT($result);
+               sqlFreeResult($result);
 
                // Include header
-               loadIncludeOnce('inc/header.php');
+               loadPageHeader();
 
                // Load final template
                loadTemplate('beg_link', FALSE, $content);
@@ -184,11 +177,11 @@ if (isGetRequestElementSet('userid')) {
                }
 
                // Include footer
-               loadIncludeOnce('inc/footer.php');
+               loadPageFooter();
        } elseif ((getUserData('status') != 'CONFIRMED') && (getUserData('status') != 'failed')) {
                // Maybe locked/unconfirmed account?
                $errorCode = generateErrorCodeFromUserStatus();
-       } elseif ((getUserData('userid') == '0') || (getUserData('status') == 'failed')) {
+       } elseif ((!isValidId(getUserData('userid'))) || (getUserData('status') == 'failed')) {
                // Inalid or locked account, so let's find out
                if (fetchUserData(getRequestElement('userid'), 'nickname')) {
                        // Locked account