1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
|
/** pm popup **/
if ($_REQUEST['action'] == 'popup') {
$lang->load('BOARD');
$result = $db->query("SELECT ".
"p.privatemessageid, p.subject, p.sendtime, p.iconid, p.attachments, ".
"i.iconpath, i.icontitle, ".
"u.userid, u.username ".
"FROM bb".$n."_privatemessagereceipts pmr ".
"LEFT JOIN bb".$n."_privatemessage p USING(privatemessageid) ".
"LEFT JOIN bb".$n."_icons i USING(iconid) ".
"LEFT JOIN bb".$n."_users u ON (p.senderid=u.userid) ".
"WHERE pmr.recipientid='$wbbuserdata[userid]' AND p.sendtime>'$wbbuserdata[lastvisit]' AND pmr.view=0 AND pmr.deletepm=0 ".
"ORDER BY p.sendtime DESC");
$pmscount = $db->num_rows($result);
$pmbit = '';
while ($row = $db->fetch_array($result)) {
if ($row['iconid']) $icon = makeimgtag($row['iconpath'], getlangvar($row['icontitle'], $lang), 0);
else $icon = " ";
$senddate = formatdate($wbbuserdata['dateformat'], $row['sendtime']);
$sendtime = formatdate($wbbuserdata['timeformat'], $row['sendtime']);
$row['subject'] = htmlconverter(textwrap($row['subject']));
if ($row['userid'] > 0) $row['username'] = htmlconverter($row['username']);
else $row['username'] = $lang->get('LANG_PMS_SENDER_SYSTEM', array('$master_board_name' => $master_board_name));
if ($row['attachments']) $LANG_PMS_ATTACHMENTS = $lang->get("LANG_BOARD_ATTACHMENTS", array('$attachments' => $row['attachments']));
eval("\$pmbit .= \"".$tpl->get("pmpopup_pmbit")."\";");
}
if ($pmscount == 1) $LANG_PMS_POPUP_MESSAGE = $lang->items['LANG_PMS_POPUP_MESSAGE'];
else $LANG_PMS_POPUP_MESSAGE = $lang->items['LANG_PMS_POPUP_MESSAGES'];
$lang->items['LANG_PMS_POPUP_NEWMESSAGE'] = $lang->get("LANG_PMS_POPUP_NEWMESSAGE", array('$pmscount' => $pmscount, '$LANG_PMS_POPUP_MESSAGE' => $LANG_PMS_POPUP_MESSAGE));
eval("\$tpl->output(\"".$tpl->get("pmpopup")."\");");
exit;
}
|
)