2020-07-27 01:48:59 -05:00
< ? php
2020-07-27 02:57:19 -05:00
//include("smf_api.php");
include ( " SSI.php " );
global $smcFunc , $user_info , $db_prefix , $db_name ;
// SELECT * FROM `smf_personal_messages` AS `pms`, `smf_members` AS `senders`, `smf_pm_recipients` AS `recipients` WHERE `pms`.`id_member_from` = `senders`.`id_member` AND `pms`.`id_pm` = `recipients`.`id_pm` AND (`recipients`.`id_member` = 1 OR `pms`.`id_member_from` = 1);
2020-07-27 01:48:59 -05:00
$request = $smcFunc [ 'db_query' ]( '' , '
2020-07-27 02:57:19 -05:00
SELECT `pms` . `id_pm` , `pms` . `subject` , `pms` . `body` , `pms` . `msgtime` ,
`senders` . `member_name` AS `sender_username` ,
2020-07-27 01:48:59 -05:00
`senders` . `real_name` AS `sender_display_name` ,
`recipient_members` . `member_name` AS `recipient_username` ,
`recipient_members` . `real_name` AS `recipient_display_name`
2020-07-27 02:57:19 -05:00
FROM { db_prefix } personal_messages AS `pms` ,
{ db_prefix } members AS `senders` ,
{ db_prefix } members AS `recipient_members` ,
{ db_prefix } pm_recipients AS `recipients`
2020-07-27 01:48:59 -05:00
WHERE `pms` . `id_member_from` = `senders` . `id_member`
AND `recipient_members` . `id_member` = `recipients` . `id_member`
AND `pms` . `id_pm` = `recipients` . `id_pm`
AND ( `recipients` . `id_member` = { int : id_member } OR `pms` . `id_member_from` = { int : id_member }) ' ,
array (
2020-07-27 02:57:19 -05:00
'id_member' => $user_info [ 'id' ],
2020-07-27 01:48:59 -05:00
)
);
function format_name ( $result , $type ) {
2020-07-27 02:57:19 -05:00
$username = $result [ " ${ type } _username " ];
$display_name = $result [ " ${ type } _display_name " ];
2020-07-27 01:48:59 -05:00
$name = $display_name ;
if ( $display_name != $username ) {
$name = " $name ( $username ) " ;
}
return $name ;
}
echo " <html>
< head >
2020-07-27 02:57:19 -05:00
< title > Personal Messages sent to / from $ { user_info [ 'name' ]} </ title >
2020-07-27 01:48:59 -05:00
< style type = 'text/css' >
. label { font - weight : bold }
2020-07-27 02:57:19 -05:00
h2 { font - size : 17 px }
article { border - top : 1 px solid black ; }
section { margin - top : 15 px ; margin - bottom : 15 px ; }
2020-07-27 01:48:59 -05:00
</ style >
</ head >
2020-07-27 02:57:19 -05:00
< body >
< h1 > Personal Messages sent to / from $ { user_info [ 'name' ]} </ h1 > " ;
2020-07-27 01:48:59 -05:00
2020-07-27 02:57:19 -05:00
while ( $row = $smcFunc [ 'db_fetch_assoc' ]( $request )) {
2020-07-27 01:48:59 -05:00
$to = format_name ( $row , " recipient " );
$from = format_name ( $row , " sender " );
2020-07-27 02:57:19 -05:00
$date = strftime ( " %c " , $row [ 'msgtime' ]);
2020-07-27 01:48:59 -05:00
$body = parse_bbc ( $row [ 'body' ], true , " pm " . $row [ 'id_pm' ]);
echo " <article>
< header >
2020-07-27 02:57:19 -05:00
< h2 >< a href = '#${row[' id_pm ']}' id = '${row[' id_pm ']}' > $ { row [ 'subject' ]} </ a ></ h2 >
2020-07-27 01:48:59 -05:00
< div >< span class = 'label' > From :</ span > $from </ div >
2020-07-27 02:57:19 -05:00
< div >< span class = 'label' > To :</ span > $to </ div >
< div >< span class = 'label' > Date :</ span > $date </ div >
2020-07-27 01:48:59 -05:00
</ header >
< section > $body </ section >
</ article > " ;
2020-07-27 02:57:19 -05:00
flush ();
2020-07-27 01:48:59 -05:00
}
2020-07-27 02:57:19 -05:00
$smcFunc [ 'db_free_result' ]( $request );
2020-07-27 01:48:59 -05:00
echo " </body></html> " ;
