if ($tpage == 0) {
$spage = $tpage + 1;
} else {
$spage = $tpage;
}
$startfrom = ($page - 1) * $config[items_per_page];
$sql = "select * from pm where receiver='{$_SESSION['USERNAME']}' and inbox_track=2 order by pm_id desc limit {$startfrom}, {$config['items_per_page']}";
$rs = $conn->execute($sql);
while (!$rs->EOF) {
if ($rs->fields['inbox_track'] == 2) {
$pm_id[] = $rs->fields['pm_id'];
$body[] = $rs->fields['body'];
$sender[] = $rs->fields['sender'];
$date[] = $rs->fields['date'];
$seen[] = $rs->fields['seen'];
$subject[] = fx_replace('$sender_name', $rs->fields['subject'], $rs->fields['sender']);
}
$rs->movenext();
}
$start_num = $startfrom + 1;
$end_num = $startfrom + $rs->recordcount();
$page_link = "";
for ($k = 1; $k <= $tpage; $k++) {
$page_link .= "<a href='inbox.php?UID={$_SESSION['UID']}&page={$k}&type={$_REQUEST['type']}'>{$k}</a> ";
}
//END PAGING
STemplate::assign('pm_id', $pm_id);
STemplate::assign('subject', $subject);
STemplate::assign('body', $body);
STemplate::assign('sender', $sender);
STemplate::assign('date', $date);
<?php
session_start();
include "include/config.php";
include "include/function.php";
chk_member_login();
if ($_GET['s'] == "0") {
$conn->execute("update pm set\n seen = 1\n where pm_id = {$_GET['id']}\n ");
}
$sql = "select * from pm where pm_id={$_GET['id']}";
$rs = $conn->execute($sql);
STemplate::assign('subject', fx_replace('$sender_name', $rs->fields['subject'], $rs->fields['sender']));
STemplate::assign('body', $rs->fields['body']);
STemplate::assign('sender', $rs->fields['sender']);
STemplate::assign('date', $rs->fields['date']);
/* fetch user information */
$sql = "select UID from signup where username='******'sender'] . "'";
$rs_u = $conn->execute($sql);
STemplate::assign('userid', $rs_u->fields['UID']);
STemplate::assign('err', $err);
STemplate::assign('head_bottom', "msglinks.tpl");
STemplate::display('head1.tpl');
STemplate::display('msg.tpl');
STemplate::display('footer.tpl');
