PDA

View Full Version : VB4.21 Friend Tables

woodmj
09-22-2013, 05:55 PM
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
09-22-2013, 07:32 PM
You mean who is your buddy or on your ignore list? That is in the userlist table.
woodmj
09-22-2013, 08:08 PM
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.


You mean who is your buddy or on your ignore list? That is in the userlist table.
Lynne
09-22-2013, 11:42 PM
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
09-23-2013, 07:07 AM
That's just what I was looking for Lynne, many thanks! :)


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.)