* $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 *
// 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
$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
// 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 ((ifSqlHasZeroNums($result)) && ($points > 0) && (getBegPayMode() == 'NONE') && ((!isMember()) || (isAdmin()))) {
// Default is result from isAdmin(), mostly false
$isPayed = isAdmin();
* 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?
}
// Free memory
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
// Include header
loadIncludeOnce('inc/header.php');
} 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