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');