+addYouAreHereLink('member', __FILE__);
+
+// Essential extension ext-mailid must be active
+if (!isExtensionActive('mailid')) {
+ displayMessage('{%pipe,generateExtensionInactiveNotInstalledMessage=mailid%}');
+ return;
+} // END - if
+
+// Shall we display a mail?
+if ((isGetRequestElementSet('bonusid')) && (isExtensionActive('bonus'))) {
+ // Display bonus mail by loading it's full data
+ $result_data = sqlQueryEscaped('SELECT
+ `id`,
+ `subject`,
+ `timestamp`,
+ `cat_id`,
+ `points`,
+ `text`,
+ `is_notify`,
+ `data_type`,
+ `time`,
+ `url`
+FROM
+ `{?_MYSQL_PREFIX?}_bonus`
+WHERE
+ `id`=%s
+LIMIT 1',
+ array(bigintval(getRequestElement('bonusid'))), __FILE__, __LINE__);
+
+ // Load data
+ $content = sqlFetchArray($result_data);
+
+ // Translate some data
+ $content['timestamp'] = generateDateTime($content['timestamp'], '2');
+ $content['userid'] = getMemberId();
+ $content['user_mail_status'] = '{%message,MEMBER_MAIL_BONUS_CONFIRMED_UNKNOWN=' . $content['id'] . '%}';
+
+ // Is ext-user active?
+ if (isExtensionActive('user')) {
+ // Default is never confirmed
+ $content['user_mail_status'] = '{%message,MEMBER_MAIL_BONUS_NEVER_CONFIRMED=' . $content['id'] . '%}';
+
+ // Get the timestamp from the mail
+ $confirmedStamp = getEpocheTimeFromUserStats('bonusid', $content['id']);
+
+ // Have confirmed it?
+ if ($confirmedStamp > 0) {
+ // Get timestamp from insert
+ $content['user_mail_status'] = '{%message,MEMBER_MAIL_BONUS_CONFIRMED_ON=' . generateDateTime($confirmedStamp, '2') . '%}';
+ } // END - if
+ } // END - if
+
+ // Display it depending on mail (data) type
+ loadTemplate('member_mail_bonus_' . strtolower($content['data_type']), FALSE, $content);
+
+ // Free result
+ sqlFreeResult($result_data);
+} elseif (isGetRequestElementSet('mailid')) {
+ // Display regular member mail by loading its full data
+ $result_data = sqlQueryEscaped("SELECT
+ `id` AS `stats_id`,
+ `pool_id`,
+ `subject`,
+ `timestamp_ordered`,
+ `cat_id`,
+FROM
+ `{?_MYSQL_PREFIX?}_user_stats` AS `s`
+WHERE
+ `id`=%s
+LIMIT 1",
+ array(bigintval(getRequestElement('mailid'))), __FILE__, __LINE__);
+
+ // Load data
+ $content = sqlFetchArray($result_data);
+ $content = merge_array($content, getPoolDataFromId($content['pool_id']));
+
+ // Translate some data
+ $content['timestamp_ordered'] = generateDateTime($content['timestamp_ordered'], '2');
+ // @TODO This call cannot be saved as EL code cannot be "framed" in other EL code
+ $content['userid'] = getMemberId();
+ $content['user_mail_status'] = '{%message,MEMBER_MAIL_NORMAL_CONFIRMED_UNKNOWN=' . $content['id'] . '%}';
+
+ // Is ext-user active?
+ if (isExtensionActive('user')) {
+ // Default is never confirmed
+ $content['user_mail_status'] = '{%message,MEMBER_MAIL_NORMAL_NEVER_CONFIRMED=' . $content['id'] . '%}';
+
+ // Get the timestamp from the mail
+ $confirmedStamp = getEpocheTimeFromUserStats('mailid', $content['id']);
+
+ // Have confirmed it?
+ if ($confirmedStamp > 0) {
+ // Get timestamp from insert
+ $content['user_mail_status'] = '{%message,MEMBER_MAIL_NORMAL_CONFIRMED_ON=' . generateDateTime($confirmedStamp, '2') . '%}';
+ } // END - if
+ } // END - if
+
+ // Display it depending on mail (data) type
+ loadTemplate('member_mail_normal_' . strtolower($content['data_type']), FALSE, $content);
+
+ // Free result
+ sqlFreeResult($result_data);
+}