PHP 'blog' script

[Jord]

ok so i'm making a website, but im a little stuck. ive got my user system created and everything, but i want to have it so that once a user has signed up, they can edit their profile(i already have that part) but i also want it so they get their own individual blog that they can post to and then it appears on their profile (kinda like myspace, facebook etc)

does anyone have any ideas how i would go about doing this?

also - any ideas on how i'd aloow users to add eachother as friends ???

thank you :)

[Toon]

Have you looked at Ning? It's a ready made social network system you can request the source code to change how you wish?

Here's the one I used..

Graphic Design Network

[LeadMagnet]

For your first problem, give each user their own table when they create their user profiles which contains all the blog entries for that user. Pretty straightforward. If you managed to create the rest then you should have no difficulties. Have fields for time and date etc., all the standard stuff you'd see on a blog entry.

For the other problem, another table for each user will have a list of other user IDs that are on their friend's list and whether or not the other user has confirmed the friendship or not. For unconfirmed friends (e.g. John has added Mary as a friend but she hasn't accepted yet {and hasn't declined either}), compare the user's (John's) friends list with the target user's (Mary's) friends list. If both users exist on each other's tables, change the confirmed status to true on both users' tables.
If a user declines friendship, delete the entry from both tables completely.
So any time that list is checked, the confirmed friends will be listed off, and the unconfirmed ones will be ignored until they're confirmed.

Might sound confusing, but i'm sure you get the general idea.

*edit* yeah, or use free code. :)

[Jord]

I see now with the blog part, i'll be able to do that easily. But I dont quite get the friends part :/

[LeadMagnet]

Yeah, sorry, i know... i kinda changed my mind while typing it and didn't fix it, lol.

I'll try to simplify.
1 friends table for each user. Fields are: User ID (of the friends), confirmed status and possibly whether or not someone has added you as a friend.

By using User IDs, it should be easy to target a table belonging to another user and modify friend status as needed.
For every User ID on a person's friends list, just pull down the name and profile pic or whatever else belonging to that user.

Does that make more sense?

[Jord]

yeah, so it'd probs look something like this:

create table friends
'userid'
'confirmedstatus'

^^ but thats simplified obviously

[LeadMagnet]

Yeah, you'd want to have the user's id in all table names belonging to that user so that you can add on the label for easy targeting (e.g. friends_3275)

You might want to add extra information like whether this is a new friend's request, then they'd get a popup maybe asking them to confirm friendship if it's the first time logging in after being added.
Other things like time and date added might be useful too for sorting.