* $Date:: $ *
* $Tag:: 0.2.1-FINAL $ *
* $Author:: $ *
- * Needs to be in all Files and every File needs "svn propset *
- * svn:keywords Date Revision" (autoprobset!) at least!!!!!! *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
* Copyright (c) 2009, 2010 by Mailer Developer Team *
if (isGetRequestParameterSet('id')) {
// Check for selected sponsor
- $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(getRequestParameter('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') {
// Message when sponsor's account got lock
$content['message'] = '{--SPONSOR_ACCOUNT_LOCKED--}';
- $subject = '{--SPONSOR_SUBJECT_LOCKED--}';
+ $subject = '{--SPONSOR_LOCKED_SUBJECT--}';
$content['status'] = 'LOCKED';
} else {
// Message when sponsor's account got unlock
$content['message'] = '{--SPONSOR_ACCOUNT_UNLOCKED--}';
- $subject = '{--SPONSOR_SUBJECT_UNLOCKED--}';
+ $subject = '{--SPONSOR_UNLOCKED_SUBJECT--}';
$content['status'] = 'CONFIRMED';
}
sendEmail($content['email'], $subject, $message);
// Update sponsor's account
- SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `status`='%s' WHERE `id`='%s' LIMIT 1",
+ SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `status`='%s' WHERE `id`=%s LIMIT 1",
array($content['status'], bigintval(getRequestParameter('id'))), __FILE__, __LINE__);
} elseif (isPostRequestParameterSet('no')) {
// No don't lock / unlock now!
}
} else {
// Cannot change status on unconfirmed or pending accounts!
- $message = '{--ADMIN_SPONSPOR_CANNOT_LOCK_PENDING_UNCINFIRMED_ACCOUNTS--}';
+ $message = '{--ADMIN_SPONSOR_CANNOT_LOCK_PENDING_UNCINFIRMED_ACCOUNTS--}';
}
} else {
// Sponsor not found!