function ExportMessages()
{
global $db_prefix, $ID_MEMBER, $scripturl, $user_info;
// Find all Messages to export...
// AND FIND_IN_SET('-1', pmr.labels)
$request = db_query("
SELECT pm.ID_PM, pm.ID_MEMBER_FROM, mem_to.RealName, pm.msgtime, pm.subject, pm.body, pmr.labels, mem_to.messageLabels
FROM ({$db_prefix}personal_messages AS pm, {$db_prefix}pm_recipients AS pmr)
LEFT JOIN {$db_prefix}members AS mem_to ON (mem_to.ID_MEMBER = pmr.ID_MEMBER)
WHERE pmr.ID_PM = pm.ID_PM
AND pmr.ID_MEMBER = $ID_MEMBER
AND pmr.deleted = 0
ORDER BY pmr.ID_PM ASC", __FILE__, __LINE__);
// Load the ID_PMs and ID_MEMBERs and initialize recipients.
$pms = array();
$recipients = array();
$pmessages = array();
while ($row = mysql_fetch_assoc($request))
{
if (!isset($recipients[$row['ID_PM']]))
{
// We need this to get the recipients.
$pms[] = $row['ID_PM'];
// This is the main stuff though.
$pmessages[$row['ID_PM']] = array(
'id' => $row['ID_PM'],
'from' => array(
'id' => $row['ID_MEMBER_FROM'],
'name' => $row['RealName'],
),
'recipients' => array(
'to' => array(),
'bbc' => array(),
),
'labels' => explode(',', $row['labels']),
'sent' => $row['msgtime'],
'subject' => $row['subject'],
'body' => $row['body'],
);
}
// Stop Repeating ourselves.
if(isset($templables))
$templables = explode(',', $row['messageLabels']);
}
mysql_free_result($request);
if (!empty($pms))
{
// Get recipients (don't include bcc-recipients for your inbox, you're not supposed to know :P).
$request = db_query("
SELECT pmr.ID_PM, mem_to.ID_MEMBER AS ID_MEMBER_TO, mem_to.realName AS toName, pmr.bcc, pmr.labels, pmr.is_read
FROM {$db_prefix}pm_recipients AS pmr
LEFT JOIN {$db_prefix}members AS mem_to ON (mem_to.ID_MEMBER = pmr.ID_MEMBER)
WHERE pmr.ID_PM IN (" . implode(', ', $pms) . ")", __FILE__, __LINE__);
$context['message_labels'] = array();
$context['message_replied'] = array();
while ($row = mysql_fetch_assoc($request))
{
if (empty($row['bcc']))
$pmessages[$row['ID_PM']]['recipients'][empty($row['bcc']) ? 'to' : 'bcc'][] = array (
'id' => $row['ID_MEMBER_TO'],
'name' => $row['toName'],
);
}
mysql_free_result($request);
}
echo 'pmessages
', print_r($pmessages), '
';
}