Advertisement
Guest User

Untitled

a guest
Jul 29th, 2015
200
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.65 KB | None | 0 0
  1. nb mail unseen:
  2. SELECT COUNT(*) FROM messages WHERE id_recipient = $id_member AND seen = 0 AND deleted_recipient = 0;
  3. GET mail
  4. SELECT * FROM messages WHERE id_recipient = $id_member AND deleted_recipient = 0;
  5. GET mail sent
  6. SELECT * FROM messages WHERE id_sender = $id_member AND deleted_sender = 0;
  7. list del msg(ONLY received msg)
  8. SELECT * FROM messages WHERE id_recipient = $id_member AND deleted_recipient = 1;
  9. SET msg seen (WHEN recipient VIEW msg)
  10. UPDATE messages SET seen = 1 WHERE id_msg = $id;
  11. del msg recipient
  12. UPDATE messages SET deleted_recipient = 1 WHERE id_msg = $id;
  13. del msg sender
  14. UPDATE messages SET deleted_sender = 1 WHERE id_msg = $id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement