* $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 *
if (isExtensionInstalled('user')) {
// Get timestamp from insert
$content['user_status'] = getMaskedMessage('MEMBER_MAIL_BONUS_CONFIRMED_ON',
- generateDateTime(getTimestampFromUserStats('bonusid', $content['id']), 2)
+ 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
if (isExtensionInstalled('user')) {
// Get timestamp from insert
$content['user_status'] = getMaskedMessage('MEMBER_MAIL_NORMAL_CONFIRMED_ON',
- generateDateTime(getTimestampFromUserStats('mailid', $content['id']), 2)
+ generateDateTime(getEpocheTimeFromUserStats('mailid', $content['id']), 2)
);
} // END - if
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]