if($unumrows > 0){
echo ("$urgit |
");
while($urg = mysql_fetch_array($urges)){
$ID = $urg['ID'];
$fr_name = $urg['fr_name'];
$subject = $urg['subject'];
$message = $urg['message'];
$mdtnum = $urg['dtnum'];
$chunk_dtnum = chunk_split($mdtnum, 2, ':');
$chunk_arr = explode(":", $chunk_dtnum);
$input = nl2br($message);
echo("$chunk_arr[2]/$chunk_arr[3]/$chunk_arr[0]$chunk_arr[1]---------- " .
"$fr_name—$subject - " .
"$input" .
" |
");
}
}
?>
New Messages
|
if($num_rows < 1){
echo("You have no new messages. |
");
}else{
while($row = mysql_fetch_array($listem)){
$ID = $row['ID'];
$MID = $row['MID'];
if($MID == 0){
$messnum = 1;
}else{
$cntmess = @mysql_query("SELECT ID FROM messages WHERE MID='$MID'");
if($cntmess){
$count = mysql_num_rows($cntmess);
$messnum = $count + 1;
}
}
$fr_name = $row['fr_name'];
$subject = $row['subject'];
$mdtnum = $row['dtnum'];
$chunk_dtnum = chunk_split($mdtnum, 2, ':');
$chunk_arr = explode(":", $chunk_dtnum);
echo("$chunk_arr[2]/$chunk_arr[3]/$chunk_arr[0]$chunk_arr[1] " .
"$fr_name - $subject - ($messnum) |
");
}
}
?>
Read Messages
|
$listemb = @mysql_query("SELECT ID,MID,fr_name,subject,dtnum FROM messages WHERE usrn='$usrn' AND status='read' AND MID='0' ORDER BY ID DESC");
if (!$listemb) {
echo("Problem retrieving Original Messages. Error: ". mysql_error()." |
");
}
$countlist = mysql_num_rows($listemb);
if($countlist > 0){
while($row = mysql_fetch_array($listemb)){
$ID = $row['ID'];
$MID = $row['MID'];
$fr_name = $row['fr_name'];
$subject = $row['subject'];
$mdtnum = $row['dtnum'];
$chunk_dtnum = chunk_split($mdtnum, 2, ':');
$chunk_arr = explode(":", $chunk_dtnum);
echo("Original Message - $chunk_arr[2]/$chunk_arr[3]/$chunk_arr[0]$chunk_arr[1]---------- " .
"$fr_name - $subject " .
"  |
");
$cntmess = @mysql_query("SELECT ID FROM messages WHERE MID='$ID'");
if(!$cntmess){
echo("Problem retrieving Thread Messages. Error: ". mysql_error()." |
");
}else{
$num_rowsb = mysql_num_rows($cntmess);
$messcount = $num_rowsb + 1;
echo("$messcount Messages in Thread |
");
}//inelse
}//inwhile
}else{
$listemc = @mysql_query("SELECT ID,MID,fr_name,subject,dtnum FROM messages WHERE usrn='$usrn' AND status='read' ORDER BY ID DESC");
if(!$listemc){
echo("Problem retrieving Read Messages. Error: ". mysql_error()." |
");
}
$ccount = mysql_num_rows($listemc);
if($ccount < 1){
echo("You have no read messages. |
");
}else{
while($rowc = mysql_fetch_array($listemc)){
$IDc = $rowc['ID'];
$MIDc = $rowc['MID'];
$fr_namec = $rowc['fr_name'];
$subjectc = $rowc['subject'];
$mdtnumc = $rowc['dtnum'];
$chunk_dtnumc = chunk_split($mdtnumc, 2, ':');
$chunk_arrc = explode(":", $chunk_dtnumc);
echo("Original Message - $chunk_arrc[2]/$chunk_arrc[3]/$chunk_arrc[0]$chunk_arrc[1]---------- " .
"$fr_namec - $subjectc " .
"  |
");
$cntmess = @mysql_query("SELECT ID FROM messages WHERE MID='$MIDc'");
if(!$cntmess){
echo("Problem counting Thread Messages. Error: ". mysql_error()." |
");
}else{
$num_rowsb = mysql_num_rows($cntmess);
$messcount = $num_rowsb + 1;
echo("$messcount Messages in Thread |
");
}
}
}
}
?>
|