I have an idea for a friends list based off a user's account info.
'guid' is the character id number
'account' is the player's account number
'friend' is the player he is friends with
'online' 1 = online; 0= offline
Here's what the layout is like:
Friends List
`character_social` (`guid`, `friend`, `flags`, `note`) VALUES (6, 2, 1, 'Character 1');
`character_social` (`guid`, `friend`, `flags`, `note`) VALUES (2, 6, 1, 'Character 2');
So Character 1 is friends with Character 2 and vice versa.
Character Profiles
`characters` (`guid`, `account`, `name`, `online`) VALUES (6, 7, 'Character 1', 0);
`characters` (`guid`, `account`, `name`, `online`) VALUES (2, 6, 'Character 2', 0);
What i'm trying to do is display the currently logged in user's friends on a page.
So when Character 1 logs in it reads his friends list to find their 'guid' number and then looks to see if the friend is online by checking that friends 'online' field for a 1, if found it displays that characters 'name'.
I have no idea how to do this. Any help would be greatly appreciated.
Thank you.