friend system?

[eluser]MMCCQQ[/eluser]
[quote author="thepyromaniac" date="1192808169"]I have a simple system for this. Have a FriendRequests table and a Friends table. Have userA and userB in both, userA does the requesting, userB is requested.

CREATE TABLE `FriendRequests` (
`requestID` bigint(20) NOT NULL auto_increment,
`userA` int(11) NOT NULL default '0',
`userB` int(11) NOT NULL default '0',
`viewed` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`requestID`)
);

CREATE TABLE `Friends` (
`friendshipID` bigint(20) NOT NULL auto_increment,
`userA` int(11) NOT NULL default '0',
`userB` int(11) NOT NULL default '0',
`friend_type` int(3) NOT NULL default '0',
`friends_since` int(11) NOT NULL default '0',
PRIMARY KEY (`friendshipID`)
);

This way you can easily show the incoming user requests:

SELECT * FROM FriendRequests WHERE userB = $userID

outgoing user requests

SELECT * FROM FriendRequests WHERE userA = $userID

and friendships

SELECT * FROM Friends WHERE (userA = $userID AND userB = $friendID) or (userB = $userID AND userA = $friendID)

.

The benefit of this is that you have functioniality like MySpace and other sites. If one user deletes the friendship, it is deleted. This echos reality a little more than the two-record system where someone can be friends with somebody who no longer likes them!

I have a friends module which I was going to release, but it has a little too much custom code in it for now, so will finish my project then package it.[/quote]

how to get friends list???