if (!empty($_GET['id'])) {
// Check for selected sponsor
- $result = SQL_QUERY_ESC("SELECT gender, surname, family, email, status FROM "._MYSQL_PREFIX."_sponsor_data WHERE id='%s' LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT gender, surname, family, email, status FROM `{!_MYSQL_PREFIX!}_sponsor_data` WHERE id='%s' LIMIT 1",
array(bigintval($_GET['id'])), __FILE__, __LINE__);
if (SQL_NUMROWS($result) == 1) {
// Get sponsor's current status and let only confirmed and locked status pass
// Create messages
if ($status == "CONFIRMED") {
// Message when sponsor's account got lock
- define('__EMAIL_MSG', SPONSOR_ACCOUNT_LOCKED);
- $subject = SPONSOR_SUBJECT_LOCKED;
+ define('__EMAIL_MSG', getMessage('SPONSOR_ACCOUNT_LOCKED'));
+ $subject = getMessage('SPONSOR_SUBJECT_LOCKED');
$status = "LOCKED";
} else {
// Message when sponsor's account got unlock
- define('__EMAIL_MSG', SPONSOR_ACCOUNT_UNLOCKED);
- $subject = SPONSOR_SUBJECT_UNLOCKED;
+ define('__EMAIL_MSG', getMessage('SPONSOR_ACCOUNT_UNLOCKED'));
+ $subject = getMessage('SPONSOR_SUBJECT_UNLOCKED');
$status = "CONFIRMED";
}
SEND_EMAIL($email, $subject, $msg);
// Update sponsor's account
- SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_sponsor_data SET status='".$status."' WHERE id='%s' LIMIT 1",
+ SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_sponsor_data` SET `status`='".$status."' WHERE id='%s' LIMIT 1",
array(bigintval($_GET['id'])), __FILE__, __LINE__);
} elseif (!empty($_POST['no'])) {
// No don't lock / unlock now!
// Create header and text messages
if ($status == "CONFIRMED") {
// Messages when sponsor's account is confirmed
- define('__HEADER_MESSAGE', SPONSOR_LOCK_SPONSOR_HEADER);
- define('__TEXT_MESSAGE' , SPONSOR_LOCK_SPONSOR_TEXT);
+ define('__HEADER_MESSAGE', getMessage('SPONSOR_LOCK_SPONSOR_HEADER'));
+ define('__TEXT_MESSAGE' , getMessage('SPONSOR_LOCK_SPONSOR_TEXT'));
} else {
// Messages when sponsor's account is locked
- define('__HEADER_MESSAGE', SPONSOR_UNLOCK_SPONSOR_HEADER);
- define('__TEXT_MESSAGE' , SPONSOR_UNLOCK_SPONSOR_TEXT);
+ define('__HEADER_MESSAGE', getMessage('SPONSOR_UNLOCK_SPONSOR_HEADER'));
+ define('__TEXT_MESSAGE' , getMessage('SPONSOR_UNLOCK_SPONSOR_TEXT'));
}
// Create email link
- define('__EMAIL_LINK', "<a href=\"mailto:".$email."\">".__GENDER." ".__SURNAME." ".__FAMILY."</a>");
+ define('__EMAIL_LINK', "<a href=\"mailto:".$email."\">{!__GENDER!} {!__SURNAME!} {!__FAMILY!}</a>");
// Display form
LOAD_TEMPLATE("admin_lock_sponsor");
}
} else {
// Cannot change status on unconfirmed or pending accounts!
- $MSG = ADMIN_SPONSPOR_CANNOT_LOCK_PENDING_UNCINFIRMED_ACCOUNTS;
+ $MSG = getMessage('ADMIN_SPONSPOR_CANNOT_LOCK_PENDING_UNCINFIRMED_ACCOUNTS');
}
} else {
// Sponsor not found!
- $MSG = ADMIN_SPONSOR_404_1.bigintval($_GET['id']).ADMIN_SPONSOR_404_2;
+ $MSG = sprintf(getMessage('ADMIN_SPONSOR_404'), bigintval($_GET['id']));
}
} else {
// Not called by what-list_sponsor.php
- $MSG = ADMIN_CALL_NOT_DIRECTLY;
+ $MSG = getMessage('ADMIN_CALL_NOT_DIRECTLY');
}
if (!empty($MSG)) {
// Output message
LOAD_TEMPLATE("admin_settings_saved", false, $MSG);
}
+
//
?>