All pastes #266001 Raw Edit

Stinger

public php v1 · immutable
·published 2006-12-03 20:41 UTC
rendered paste body
  $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!") );	$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!"));