} 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 AS `category`, 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
} // END - if
// Display it depending on mail (data) type
- loadTemplate('member_mail_normal_'.strtolower($content['data_type']), false, $content);
+ loadTemplate('member_mail_normal_' . strtolower($content['data_type']), false, $content);
// Free result
SQL_FREERESULT($result_data);
}
// Mails left for confirmation?
-if (SQL_NUMROWS($result) > 0) {
+if (!SQL_HASZERONUMS($result)) {
// Please confirm these mails!
- $sum = '0'; $OUT = ''; $SW = 2;
+ $sum = '0'; $OUT = '';
// Init content
$content = array();
// Prepare data for template
$content = array(
- 'sw' => $SW,
- 'userid' => getMemberId(),
'data' => bigintval($DATA),
'type' => $type,
'subject' => $subject,
} else {
// Prepare data for template
$content = array(
- 'sw' => $SW,
'data' => $DATA,
'probl' => $PROBLEM,
);
// Free result
SQL_FREERESULT($result_data);
-
- // Switch color
- $SW = 3 - $SW;
} // END - while
// Free memory