require "include/bittorrent.php";
  dbconn(false);
  loggedinorreturn();
  parked();
	$out = (int) $_GET['out'];
  if ($out)		// Sentbox
  {
	  stdhead( _("Sentbox"), false);
		print("
		
  	"._('Sentbox')."
   	\n");
	  
	  $res = do_mysql_query("SELECT 
	  											 messages.id, 
	  											 messages.receiver, 
	  											 users.username, 
	  											 messages.added, 
	  											 messages.unread, 
	  											 messages.msg_parsed, 
	  											 UNIX_TIMESTAMP(messages.added) as utadded 
	  											 FROM messages 
	  											 LEFT JOIN users ON users.id = messages.receiver 
	  											 WHERE sender=" . $CURUSER["id"] . " AND location IN ('out','both') ORDER BY messages.inverted_added") or die("barf!");
	  if (mysql_num_rows($res) == 0)
      stdmsg( _("Information"), _("Your Sentbox is empty!") );
	  else
	  while ($arr = mysql_fetch_assoc($res))
	  {
	    $receiver = "" . $arr["username"] . "";
	  	$elapsed = get_elapsed_time($arr["utadded"]);
  		print("
	    | 
	    "._('To')." ".$receiver." "._('at ').$arr["added"] . " ($elapsed "._('ago').") GMT\n");    
      if (get_user_class() >= UC_MODERATOR && $arr["unread"] == "yes")
	    	print("("._('Unread!').")");
	    
	    print("
	    \n 
	      |   \n");
	  }
  }
  else		// Inbox
  {
	  stdhead( _("Inbox"), false);
		print("
		
  	Inbox
   	\n");
  	$res = do_mysql_query("SELECT 
  												 m.id,
  												 m.sender,
  												 m.added,
  												 m.unread,
  												 m.msg_parsed,
  												 u.username,
  												 UNIX_TIMESTAMP(m.added) as utadded 
  												 FROM messages m
  												 LEFT JOIN users u ON u.id = m.sender 
  												 WHERE m.receiver=" . $CURUSER["id"] . " AND m.location IN ('in','both') ORDER BY m.inverted_added") or die("barf!");
	  if (mysql_num_rows($res) == 0)
      stdmsg(_("Information"), _("Your Inbox is empty!"));
	  else
    	while ($arr = mysql_fetch_assoc($res))
	    {
	      if (is_valid_id($arr["sender"]))
	        $sender = "" . ($arr["username"] ? $arr["username"]:"["._('Deleted')."]") . "";
	      else
	        $sender = "System";
	        
	    $elapsed = get_elapsed_time($arr["utadded"]);
	      print("
	      | 
	      From ".$sender." at\n" . $arr["added"] . " (".$elapsed." ago) GMT\n");
	      
	      if ($arr["unread"] == "yes")
	      {
	        print("("._('NEW!').")");
	        do_mysql_query("UPDATE messages SET unread='false' WHERE id=" . $arr["id"]) or die("arghh");
	      }
	      print("
	      \n 
	       | ".
	      ($arr["sender"] ? ""._('Reply')."" : ""._('Reply')."") .
	        " | "._('Delete')." | \n");
				
				/*
	      if (get_user_class() >= UC_MODERATOR)
	      {
	        print("Templates:   ".
	          ($arr["sender"] ? " FAQ" : " FAQ").
	          " | What  else?".
	          "  | \n");
	      }
        */
	      print(" 
  |   \n");
	    }
  }
	print(" |  
 ");
	printf( _('Do you need to %s find %s someone?').' ', "", '');
stdfoot();
?> |