* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
* Copyright (c) 2009 - 2011 by Mailer Developer Team *
- * For more information visit: http://www.mxchange.org *
+ * 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 *
} // END - if
//
-function handleSponsorRequest ($postData, $update=false, $messageArray=array(), $RET_STATUS=false) {
+function handleSponsorRequest ($postData, $update=false, $messageArray = array(), $RET_STATUS=false) {
// Init a lot variables
$SAVE = true;
$UPDATE = false;
// Remove last ", " from SQL string
$sql = substr($sql, 0, -2)." WHERE `id`=%s LIMIT 1";
- $DATA['values'][] = bigintval(getRequestParameter('id'));
+ $DATA['values'][] = bigintval(getRequestElement('id'));
// Generate message
$message = getMessageFromIndexedArray('{--ADMIN_SPONSOR_UPDATED--}', 'updated', $messageArray);
// Generate hash code
$DATA['keys'][] = 'hash';
// @TODO Rewrite this to API function
- $DATA['values'][] = md5(session_id() . getEncryptSeperator() . $postData['email'] . getEncryptSeperator() . detectRemoteAddr() . getEncryptSeperator() . detectUserAgent() . getEncryptSeperator() . time());
+ $DATA['values'][] = md5(session_id() . getEncryptSeparator() . $postData['email'] . getEncryptSeparator() . detectRemoteAddr() . getEncryptSeparator() . detectUserAgent() . getEncryptSeparator() . time());
$DATA['keys'][] = 'remote_addr';
$DATA['values'][] = detectRemoteAddr();
}
unset($DATA['values'][$key]);
// Implode all data into strings
- $keyArray = implode('`, `' , $DATA['keys']);
+ $keyArray = implode('`,`' , $DATA['keys']);
$valueArray = str_repeat("%s', '", count($DATA['values']) - 1);
// Generate string
}
// Translate the account status
-function sponsorTranslateUserStatus ($status) {
+function translateSponsorStatus ($status) {
// Construct constant name
$constantName = sprintf("ACCOUNT_STATUS_%s", $status);
// Load main menu entries
$result_main = SQL_QUERY("SELECT
- `action` AS `main_action`, `title` AS `main_title`
+ `action` AS `main_action`,
+ `title` AS `main_title`
FROM
`{?_MYSQL_PREFIX?}_sponsor_menu`
WHERE
while ($content = SQL_FETCHARRAY($result_main)) {
// Load sub menus
$result_sub = SQL_QUERY_ESC("SELECT
- `what` AS `sub_what`, `title` AS `sub_title`
+ `what` AS `sub_what`,
+ `title` AS `sub_title`
FROM
`{?_MYSQL_PREFIX?}_sponsor_menu`
WHERE
$EMAIL = true;
// Okay, has changed then add status with UNCONFIRMED and new hash code
- $sql .= " `status`='EMAIL', `hash`='%s',";
+ $sql .= " `status`='EMAIL',`hash`='%s',";
// Generate hash code
// @TODO Rewrite this to API function
- $HASH = md5(session_id() . getEncryptSeperator() . $postData['email'] . getEncryptSeperator() . detectRemoteAddr() . getEncryptSeperator() . detectUserAgent() . getEncryptSeperator() . time());
+ $HASH = md5(session_id() . getEncryptSeparator() . $postData['email'] . getEncryptSeparator() . detectRemoteAddr() . getEncryptSeparator() . detectUserAgent() . getEncryptSeparator() . time());
$DATA[] = $HASH;
} // END - if
} // END - if
$sql = substr($sql, 0, -1);
// Add last_change
- $sql .= ', `last_change`=NOW()';
+ $sql .= ',`last_change`=NOW()';
// Add SQL tail data
$sql .= " WHERE `id`=%s AND `password`='%s' LIMIT 1";
FROM
`{?_MYSQL_PREFIX?}_sponsor_data`
WHERE
- `email`='%s'" . $locked."
+ '%s' REGEXP `email`
+ " . $locked . "
LIMIT 1",
array($email), __FUNCTION__, __LINE__);
if (SQL_NUMROWS($result) == 1) {
switch ($status) {
case 'added': // Sponsor successfully added with account status = UNCONFIRMED!
// Check for his id number
- $result = SQL_QUERY_ESC("SELECT `id`, `hash` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE `email`='%s' LIMIT 1",
- array(postRequestParameter('email')), __FUNCTION__, __LINE__);
+ $result = SQL_QUERY_ESC("SELECT `id`,`hash` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE '%s' REGEXP `email` LIMIT 1",
+ array(postRequestElement('email')), __FUNCTION__, __LINE__);
if (SQL_NUMROWS($result) == 1) {
// id found so let's load it for the confirmation email
list($id, $hash) = SQL_FETCHROW($result);
// Prepare data for the email template
$content['id'] = $id;
$content['hash'] = $hash;
- $content['email'] = postRequestParameter('email');
- $content['surname'] = postRequestParameter('surname');
- $content['family'] = postRequestParameter('family');
+ $content['email'] = postRequestElement('email');
+ $content['surname'] = postRequestElement('surname');
+ $content['family'] = postRequestElement('family');
$content['timestamp'] = generateDateTime(time(), 0);
- $content['password'] = postRequestParameter('pass1');
+ $content['password'] = postRequestElement('pass1');
// Generate email and send it to the new sponsor
$message = loadEmailTemplate('sponsor_confirm', $content, $id);
- sendEmail(postRequestParameter('email'), '{--SPONSOR_PLEASE_CONFIRM_SUBJECT--}', $message);
+ sendEmail(postRequestElement('email'), '{--SPONSOR_PLEASE_CONFIRM_SUBJECT--}', $message);
// Send mail to admin
sendAdminNotification('{--ADMIN_NEW_SPONSOR--}', 'admin_sponsor_reg', $content);
$message = $messageArray['added'];
} else {
// Sponsor account not found???
- $message = '{%message,SPONSOR_EMAIL_404=' . postRequestParameter('email') . '%}';
+ $message = '{%message,SPONSOR_EMAIL_404=' . postRequestElement('email') . '%}';
}
// Free memory
if (isset($GLOBALS['sponsor_data'][getCurrentSponsorId()]['last_failure'])) {
// Backup the raw one and zero it
$GLOBALS['sponsor_data'][getCurrentSponsorId()]['last_failure_raw'] = $GLOBALS['sponsor_data'][getCurrentSponsorId()]['last_failure'];
- $GLOBALS['sponsor_data'][getCurrentSponsorId()]['last_failure'] = null;
+ $GLOBALS['sponsor_data'][getCurrentSponsorId()]['last_failure'] = NULL;
// Is it not zero?
if (!is_null($GLOBALS['sponsor_data'][getCurrentSponsorId()]['last_failure_raw'])) {