* $Author:: $ *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * Copyright (c) 2009, 2010 by Mailer Developer Team *
+ * Copyright (c) 2009 - 2011 by Mailer Developer Team *
* For more information visit: http://www.mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
// Translate some data
$content['timestamp'] = generateDateTime($content['timestamp'], 2);
$content['userid'] = getMemberId();
- $content['user_status'] = getMaskedMessage('MEMBER_MAIL_BONUS_CONFIRMED_UNKNOWN', $content['id']);
+ $content['user_status'] = '{%message,MEMBER_MAIL_BONUS_CONFIRMED_UNKNOWN=' . $content['id'] . '%}';
// Is ext-user installed?
if (isExtensionInstalled('user')) {
// Get timestamp from insert
- $content['user_status'] = getMaskedMessage('MEMBER_MAIL_BONUS_CONFIRMED_ON',
- generateDateTime(getTimestampFromUserStats('bonusid', $content['id']), 2)
- );
+ $content['user_status'] = '{%message,MEMBER_MAIL_BONUS_CONFIRMED_ON=' . generateDateTime(getEpocheTimeFromUserStats('bonusid', $content['id']), '2') . '%}';
} // END - if
// Display it depending on mail (data) type
- loadTemplate('member_mail_bonus_'.strtolower($content['data_type']), false, $content);
+ loadTemplate('member_mail_bonus_' . strtolower($content['data_type']), false, $content);
// Free result
SQL_FREERESULT($result_data);
} elseif (isGetRequestParameterSet('mailid')) {
// Display regular member mail by loading its full data
$result_data = SQL_QUERY_ESC("SELECT
- s.id, s.subject, p.text, s.timestamp_ordered AS `timestamp`, s.cat_id, pay.price AS points, p.sender, pay.time, p.data_type
+ s.id, s.subject, p.text, s.timestamp_ordered AS `timestamp`,
+ s.cat_id, pay.price AS `points`, p.sender, pay.time, p.data_type
FROM
`{?_MYSQL_PREFIX?}_user_stats` AS s
LEFT JOIN
$content = SQL_FETCHARRAY($result_data);
// Translate some data
- $content['timestamp'] = generateDateTime($content['timestamp'], 2);
+ $content['timestamp'] = generateDateTime($content['timestamp'], '2');
$content['userid'] = getMemberId();
- $content['user_status'] = getMaskedMessage('MEMBER_MAIL_NORMAL_CONFIRMED_UNKNOWN', $content['id']);
+ $content['user_status'] = '{%message,MEMBER_MAIL_NORMAL_CONFIRMED_UNKNOWN=' . $content['id'] . '%}';
// Is ext-user installed?
if (isExtensionInstalled('user')) {
// Get timestamp from insert
- $content['user_status'] = getMaskedMessage('MEMBER_MAIL_NORMAL_CONFIRMED_ON',
- generateDateTime(getTimestampFromUserStats('mailid', $content['id']), 2)
- );
+ $content['user_status'] = '{%message,MEMBER_MAIL_NORMAL_CONFIRMED_ON=' . generateDateTime(getEpocheTimeFromUserStats('mailid', $content['id']), '2') . '%}';
} // END - if
// Display it depending on mail (data) type
break;
case 'BONUS':
- $result_data = SQL_QUERY_ESC("SELECT subject, timestamp, cat_id, points, 0 FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1",
+ $result_data = SQL_QUERY_ESC("SELECT `subject`, `timestamp`, `cat_id`, `points`, 0 FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1",
array(bigintval($row['bonus_id'])), __FILE__, __LINE__);
$row['link_type'] = 'bonusid';
$data = $row['bonus_id'];
// Data found to this mail?
if ((SQL_NUMROWS($result_data) == 1) && (($row['link_type'] == 'mailid') || ($row['link_type'] == 'bonusid'))) {
- // Mail was found!
+ // Mail was found
list($subject, $timestamp, $cat, $pay, $sender) = SQL_FETCHROW($result_data);
// Subject line found?
}
} else {
// No mails left to confirm... :)
- loadTemplate('admin_settings_saved', false, '{--MEMBER_NO_MAILS_TO_CONFIRM--}');
+ displayMessage('{--MEMBER_NO_MAILS_TO_CONFIRM--}');
}
// [EOF]