echo "<p><label>Subject:</label><span>{$Subject}</span></p>";
echo "<p><label>Message:</label><span style='line-height:18px;'>{$Message}</span></p>";
$Subjectnew = str_replace(" ", "%", $Subject);
echo "<p style='padding-top:10px;height:50px;line-height:18px;display:none;'><a href=Athmessage.php?action=compose&to={$fullname}&subject=RE: {$Subjectnew}&Usertypefrom={$Usertypefrom}&newfrom={$UserTo} class='mailaction'>Forward Message</a></p>";
}
////////////////////////////Viewssent///////////////////////////////
////////////////////////////Biginning Inbox///////////////////////////////
if ($action == inbox || $action == '') {
$selquery = "select * from " . TBL_MAIL . " where UserTo='{$username}' and status!='delete' and visible = 'ACTIVE' order by mail_id DESC";
$db->query($selquery);
$db->next_record();
$totalPages = $db->num_rows();
#Code for paging
$page->set_page_data('', $db->num_rows(), 20, 5, true, false, true);
$page->set_qry_string($selquery);
$selquery = $page->get_limit_query($selquery);
//return the query with limits
$db->query($selquery);
$db->next_record();
if ($db->num_rows() == '0') {
if ($_REQUEST['msg'] == '') {
echo '<div class="thankyoumessage">Your Inbox is Empty!</div>';
}
} else {
#echo "<h3 class='black'>Inbox</h3>";
echo "<table cellpadding=2 cellspacing=1 width='100%' align='center'>";
echo '<tr>
<td align="left" class="normalblack_12" width="10%"><strong>Date</strong></td>
<td align="left" class="normalblack_12" width="45%"><strong>Subject</strong></td>
<td align="left" class="normalblack_12" width="30%"><strong>From User</strong></td>
<td class="normalblack_12" width="15%" align="center" style="text-align:center;"><strong>Send to Trash</strong></td>';
} else {
$query = "Select * from " . TBL_HS_AAU_TEAM_NAME . " where " . $srchCond;
}
$db->query($query);
$db->next_record();
$totalPages = $db->num_rows();
if ($totalPages > 0) {
?>
<tr> <td align="left" style="padding-left:7px;"colspan="10"><input type="checkbox" id="check_all" name="check_all" value="" onclick="javascript:checkAll();"> <b>Check All</b> <input type="button" name="delete" value="Delete Selected" onclick="return submitDeleteAll();"></td></tr>
<?php
}
#Code for paging
$page->set_page_data('', $db->num_rows(), 100, 5, true, false, true);
$page->set_qry_string($queryString);
$query = $page->get_limit_query($query);
//return the query with limits
//echo $query;
//echo $queryString;
$db->query($query);
$db->next_record();
if ($db->num_rows() > 0) {
#check for record availability
echo '<tr><td align="center" class="normalblack_12" width="4%"> </td>
<td align="left" class="normalblack_12" width="8%"> <strong>S.No.</strong></td>
<td align="left" class="normalblack_12" width="25%"> <strong>HS AAU Team Name</strong></td>
';
echo '<td class="normalblack_12" width="5%" align="center"><strong>Edit</strong></td>';
echo '<td class="normalblack_12" width="7%" align="center"><strong>Delete</strong></td>';
$count++;
}
#show pagination
echo '<tr><td align="right" class="normalblack_12x" colspan="5">';
echo '</td></tr>';
}
echo '</form></table></span>';
?>
</div>
<div style="background: none repeat scroll 0 0 #FFFFFF;
border: 1px solid #DBDBDB;
min-height: 120px;
margin-top:11px;
width: 567px;float:right">
<form name="frmUsers_need" action="" method="post" onsubmit="">
<span class="gernal">Coach's Needs</span> <br /><br />
<?php
if ($_REQUEST['page'] == '') {
$pageno = '0';
} else {
$pageno = $_REQUEST['page'];
}
if ($_SESSION['mode'] == 'college') {
?>
<a href="#" onclick="window.open('collegeneed.php','windowname1', 'width=665, height=650'); return false;">Add Needs</a>
<?php
}
?>
