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();
?> |