VB4.21 Friend Tables

[woodmj]

Hi, I was just wondering if anybody could point me in the right direction of which tables VB4.21 would write Friends data to and how they join? Many thanks in advance.

[Lynne]

You mean who is your buddy or on your ignore list? That is in the userlist table.

[woodmj]

Hi Lynne, Thanks for that. I was looking over the tables and also noticed usertextfield.buddylist which seems to be a char concat of userids and so wondered if that was linked in someway? and also whether there might be any other tables involved? Looking to import some data so wanted to fully understand any tables/relationships involved before I did it. Appreciate any advice you can give.

Originally Posted by Lynne

You mean who is your buddy or on your ignore list? That is in the userlist table.

[Lynne]

The items in usertextfield.buddylist are the userlist.relationid (the userids) that are buddies for that user (usertextfield.userid). userlist.type will say buddy and then userlist.friend will say either yes (they are friends) or pending (user hasn't answered the request) or no (they are just buddies). usertextfield.ignorelist is for where the user is on your ignore list and userlist.type will say ignore for that relationship.

(I think that is written correctly.)

[woodmj]

That's just what I was looking for Lynne, many thanks!

Originally Posted by Lynne

The items in usertextfield.buddylist are the userlist.relationid (the userids) that are buddies for that user (usertextfield.userid). userlist.type will say buddy and then userlist.friend will say either yes (they are friends) or pending (user hasn't answered the request) or no (they are just buddies). usertextfield.ignorelist is for where the user is on your ignore list and userlist.type will say ignore for that relationship.

(I think that is written correctly.)