can be viewed by every one. privacy=1 => can be viewed by logged in users only privacy=0 => can not be viewed by anyone but the user. ******************************************* blog entries can be viewed by every one. all the entries can be viewed by all the logged in users. privacy=2 can be viewed by every one privacy=1 can be viewed only by user's friends list privacy=0 can not be viewed by anyone. ******************************************* user can send a message to another use to ask for their friendship, if the other user accepts the request, then the user will be added to other persons friend list. - a user's friends list is the list of the people who asked the user for him/her friendship. - firends is a table where the primary key is a user id and another field with the users friend list as a text representaion like that user-id1_user-id2_user-id3_ the list ends with "_" and it also serves as a separator of the firends user_id s. -there is another table for user's pending requests for friendship. once a user requests for someones friendship (meaning the act of adding someone to his/her friend list, a record will be added to this table. once the other user accepts or rejects that user's request, that entry will be deleted from the table. 1- john wants to add jim to his friends. 2- a record will be created in that table for jim with john's user id in another field. 3- when jim logs in next, he will see the request 4.1- jim accepts the request: the record will be deleted from pending table and john will be added to jims friends list 4.2- jim rejects the request: the record will be deleted from pending table. no further action is taken. ******************************************* there is a table for messages, this table has no primary key. messages received and read by the users will simply be deleted from the database. user_id, from, message, date_sent where user_id is the user id of the person who will receive the message. ****************************************** /blog/email/attachment/ /blog/email/image/ there is a table for emails, this table has no primary key. emails received and read by the users will simply be kept for 30 days. user_id, from, subject, message, picture_if_any, file_attachment_if_any, date_sent, is_read. where user_id is the user id of the person who will receive the message. a user can send a message to one person, all his friends list, or in any group his a part of if any. */ ?> Help

Submit News Terms of Use Legal Notices

My Email

Login failed.

You are not logged in.

You should log in to view the blog.

Empty my mail box

Inbox

Sent

Saved

Deleted

Address Book

Select all Save selected Delete selected