Pm system help

[stelthius]

your code you just posted just returns a blank page

 

 

<?php
  include("../include/session.php");
  include("../include/checkban.php");
//Are they logged in or not?
  if ($session->logged_in) {
    $query = "SELECT id FROM messages WHERE reciever='$user' AND unread='yes'";
    $num=mysql_num_rows($query);
    if ($num>0) {
      echo '<a href="inbox.php">You have '.$num.' new message(s)</a>'
    }
  } else {
    echo 'Please login to use the PM System.';
  }
?>

 

 

Once again sorry for this taking so long

[stelthius]

this is my inbox.php my full pm system works keep in mind it is just this small modification im trying to make that isnt working

 

 

 

 

<?
session_start();
$user = $_SESSION['username'];


include("../include/session.php");
include("../include/checkban.php");

//Are they logged in or not?
if ($session->logged_in){
//Get your private message count

?>


<p align="center"> </p>
<br>
<center>
<b><p><a href="inbox.php">Inbox</a> | <a href="compose.php">Compose</a> | <a href="sent.php">Sentbox</a>
<b><p> </p>
</b>
</center>
<br>
<?
//This stuff and the while loop will query, see if you have messages or not, and display them if you do
$query = "SELECT id, sender, subject, message FROM messages WHERE reciever='$user'";
$sqlinbox = mysql_query($query);

//Dispaly the error and the query so we can diagnose the problem if there is one
if(!$sqlinbox)
{
?>
<p><? print '$query: '.$query.mysql_error();?></p>
<?
}

//There are no rows found for the user that is logged in, so I guess that means they dont have any messages
//or maybe its all broken 
elseif (!mysql_num_rows($sqlinbox) )
{
?>
<center><p><b>You have no messages to display</b></p></center>
<?
}

//So if there is not an error, and they apparently do have messages we need to get their information and
//display it.
else
{
//Ok, Lets center this whole table Im going to make just because I like it like that
//Then we create a table 80% the total width with 3 columns The subject is 75% of the whole table,
//the sender is 120 pixels (should be plenty) and the select checkboxes only get 25 pixels
?>
<center>
<form name="send" method="post" action="delete.php">
<table width="80%">
<tr>
<td width="50px" valign="top"><p><b><u>Subject</u></b></p></td>
<td width="50px" valign="top"><p><b><u>Sender</u></b></p></td> 
<td width="30px" valign="top"><p><b><u>Select</u></b></p></td>
</tr>
<?
//Ok cool, now we stick it all into an array and we will dispaly it now
while($inbox = mysql_fetch_array($sqlinbox))
{
//These are the variables we have the id of the private message, we have the person who sent the message, we have the subject of the message, and yeah thats it
$pm_id = $inbox['id'];
$sender = $inbox['sender'];
$subject = $inbox['subject'];

//So lets show the subject and make that a link to the view message page, we will send the message id through the URL to that page so it can be displayed
//And also let the person wee who sent it to them, if you want you can make that some sort of a link to view more stuff about the user, but Im not doing that here, I did it for my game though, pretty much same as the viewmsg.php page but a different page, and with the senders id
//And finally the checkboxes that are all stuck into an array and if they are selected we stick the private message id into the array
//I will only let my users have a maximum of 50 messages, remeber that ok? Because that's the value I will use later for things
?>
<tr>
<td width="75%" valign="top"><p><a href="viewmsg.php?msg_id=<? echo $pm_id; ?>"><? echo $subject; ?></a></p></td>
<td width="120px" valign="top"><p><? echo $sender; ?></p></td>
<td width="25px" valign="top"><input name="pms[]" type="checkbox" value="<? echo $pm_id; ?>"></td>
</tr>
<?
//This ends the while loop
}
?>
<tr> 
<th align=right colspan="3"><input type="submit" name="Submit" value="Delete Selected"></td>
<td></td>
<td></td>
</tr>
</table>
<?
//So this ends the else to see if it is all ok and having messages or not
}

//This ends that first thing that checks if you are logged in or not
}
else
{
echo "<center>";
echo "[<a href=\"../main.php\">Home</a>]";
echo "[<a href=\"../main.php\">Login</a>]";
echo "[<a href=\"../register.php\">Register</a>]";
echo "<br>Please Login";
echo "</center>";
}
?>

[Yesideez]

It'll return a blank page if that one query shows the message on the page.

 

In one of the includes the code I posted above to check for a new message.

[Yesideez]

Try changing the line to this:

elseif (mysql_num_rows($sqlinbox)==0)

 

EDIT: Bad typo

[Yesideez]

OK right now your code works.

 

To find out if anyone has new messages you need to add this to your query:

AND unread='yes'

otherwise it'll show everyone as having new messages.

 

That's why I suggest having in one of the includes (maybe one that builds a status bar of sorts) the COUNT query I posted then it'll show whether a user has new mail on every page they visit.

[stelthius]

sorry to be a pain but it still doesnt work, im thinking about giving up on the idea to be honest its driving me insane now.

 

Rick