femi / ditto Goto Github PK

Requests to view albums, blogs and profiles etc. should be vetoed beforehand to ensure that the user has permission to view the item.

Update routes from .htaccess to index.php, check SessionId before serving

Occasionally I'm having trouble using the ../../filename notation. The same php or js function could be called from a different directory because of custom routings. I think it'd be good to have some sort of root variable to solve this issue.

Comments, dislikes and messages have special foreign key relationships that are not easily modelled using MySQL.

A comment must have one and only one of the following fields as not null:

• photoId
• albumId
• blogId

A dislike must have one and only one of the following fields as not null:

• commentId
• blogId
• photoId
• albumId

A message must have one and only one of the following fields as not null:

• circleId
• receiverId

As a user, I want to quickly navigate to a blog as quickly as possible. A dynamic search box would do just the trick.

SELECT * FROM blogs WHERE content LIKE %keyword%
SELECT * FROM blogs WHERE blogs.userId = users.userId

As a user, I want to be able to easily look through my friends of friends, so I can quickly connect with mutual friends,

As a user, I want to be able to create/edit/delete photo albums, and the photos therein. I would like a thumbnail of all the photos in the album.

As a user, I want to be able to assign access rights to my album to a particular friend circle.

Photo data generated by users needs to be stored somewhere, any ideas on the best way to go about this?

As a user I want to be able to register to ditto with my email address, password, age, sex etc.

INSERT INTO users (fName, lName, dob, city, mobileNumber, email, hashedPassword, maritalStatus, sex, description) VALUES (...)

As a user, I want to be able to comment and view other people's comments on a blog post.

1. As a user, I want to be able to modify my personal details
2. As a user, I want to be able to delete my account (optional)
3. As a user, I want to be able to modify or delete my profile picture

As a user, I want to be able to quickly look up other users using the site who may not be in my friend circles.

As a user, I want to easily create and view blog posts.

To implement @G3zz's custom apache routing we need to move index.php file to the /public and change the affected relative paths in corresponding php files.

As a user, I want to be able to view a single photo so that it (moreorless) fills the size of my screen.

You can only comment on your own posts when your privacy is set to Everyone, it will not work otherwise.

Upon successful sign up, a profile picture album (DB entry + physical directory creatino) and friend circle (DB entry) should be created.

As a user I want to be able to delete a blog that I no longer want people to see.

As a user, I am sometimes unsure of who should be my friend, so I would like an algorithm to make me aware of people that I might want to be friends with.

As a user when I log in and navigate away from the page, I want my login session to be maintained so when I navigate back to the page I am still logged in.

As a user I want to be able to login to ditto with my e-mail address and password.

SELECT email, hashedPassword FROM users WHERE email = request.email, hashedPassword = hash(request.password)

right now when you delete a friend - friend is still present in any circle you added them into

Users will be able to manage settings, for example, privacy settings

Find other users to friend via a collaborative filtering recommendation
method. Friend other users through an invite-and-accept method.

1. As a user, I want to be able to set the privacy of my profile to public or private.

1. As a user, I want to be able to type a name into a search box, and the result should be filtered according to the friend circles I have chosen to search through.

As a user, I want to be able to propagate my opinions on everything on the site. Furthermore, I want to be able to edit what I think, for when I change my mind.