if (!empty($_GET['id'])) {
// Check for selected sponsor
- $result = SQL_QUERY_ESC("SELECT salut, 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
- list($salut, $sname, $fname, $email, $status) = SQL_FETCHROW($result);
+ list($gender, $sname, $fname, $email, $status) = SQL_FETCHROW($result);
SQL_FREERESULT($result);
if (($status == "CONFIRMED") || ($status == "LOCKED")) {
// Transfer data to constants
- define('__SALUT' , TRANSLATE_SEX($salut));
+ define('__GENDER' , TRANSLATE_GENDER($gender));
define('__SURNAME', $sname);
define('__FAMILY' , $fname);
define('__ID' , bigintval($_GET['id']));
}
// Create email link
- define('__EMAIL_LINK', "<A href=\"mailto:".$email."\">".__SALUT." ".__SURNAME." ".__FAMILY."</A>");
+ define('__EMAIL_LINK', "<A href=\"mailto:".$email."\">".__GENDER." ".__SURNAME." ".__FAMILY."</A>");
// Display form
LOAD_TEMPLATE("admin_lock_sponsor");