* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
* *
* 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 *
* *
* 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 *
- $result_sponsor = SQL_QUERY_ESC("SELECT `gender`, `surname`, `family`, `email`, `status` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE `id`='%s' LIMIT 1",
+ $result_sponsor = SQL_QUERY_ESC("SELECT `gender`,`surname`,`family`,`email`,`status` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE `id`=%s LIMIT 1",
array(bigintval(getRequestElement('id'))), __FILE__, __LINE__);
if (SQL_NUMROWS($result_sponsor) == 1) {
// Get sponsor's current status and let only confirmed and locked status pass
array(bigintval(getRequestElement('id'))), __FILE__, __LINE__);
if (SQL_NUMROWS($result_sponsor) == 1) {
// Get sponsor's current status and let only confirmed and locked status pass
if (($content['status'] == 'CONFIRMED') || ($content['status'] == 'LOCKED')) {
// Transfer data to constants
if (($content['status'] == 'CONFIRMED') || ($content['status'] == 'LOCKED')) {
// Transfer data to constants
- $content['message'] = getMessage('SPONSOR_ACCOUNT_LOCKED');
- $subject = getMessage('SPONSOR_SUBJECT_LOCKED');
+ $content['message'] = '{--SPONSOR_ACCOUNT_LOCKED--}';
+ $subject = '{--SPONSOR_LOCKED_SUBJECT--}';
- $content['message'] = getMessage('SPONSOR_ACCOUNT_UNLOCKED');
- $subject = getMessage('SPONSOR_SUBJECT_UNLOCKED');
+ $content['message'] = '{--SPONSOR_ACCOUNT_UNLOCKED--}';
+ $subject = '{--SPONSOR_UNLOCKED_SUBJECT--}';
sendEmail($content['email'], $subject, $message);
// Update sponsor's account
sendEmail($content['email'], $subject, $message);
// Update sponsor's account
array($content['status'], bigintval(getRequestElement('id'))), __FILE__, __LINE__);
} elseif (isPostRequestElementSet('no')) {
// No don't lock / unlock now!
array($content['status'], bigintval(getRequestElement('id'))), __FILE__, __LINE__);
} elseif (isPostRequestElementSet('no')) {
// No don't lock / unlock now!
// Create header and text messages
if ($content['status'] == 'CONFIRMED') {
// Messages when sponsor's account is confirmed
// Create header and text messages
if ($content['status'] == 'CONFIRMED') {
// Messages when sponsor's account is confirmed
- $content['header_message'] = getMessage('SPONSOR_LOCK_SPONSOR_HEADER');
- $content['text_message'] = getMessage('SPONSOR_LOCK_SPONSOR_TEXT');
+ $content['header_message'] = '{--SPONSOR_LOCK_SPONSOR_HEADER--}';
+ $content['text_message'] = '{--SPONSOR_LOCK_SPONSOR_TEXT--}';
- $content['header_message'] = getMessage('SPONSOR_UNLOCK_SPONSOR_HEADER');
- $content['text_message'] = getMessage('SPONSOR_UNLOCK_SPONSOR_TEXT');
+ $content['header_message'] = '{--SPONSOR_UNLOCK_SPONSOR_HEADER--}';
+ $content['text_message'] = '{--SPONSOR_UNLOCK_SPONSOR_TEXT--}';