Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 22 Sep 2013, 18:55
woodmj woodmj is offline
 
Join Date: Sep 2013
VB4.21 Friend Tables

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.
Reply With Quote
  #2  
Old 22 Sep 2013, 20:32
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
You mean who is your buddy or on your ignore list? That is in the userlist table.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #3  
Old 22 Sep 2013, 21:08
woodmj woodmj is offline
 
Join Date: Sep 2013
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 View Post
You mean who is your buddy or on your ignore list? That is in the userlist table.
Reply With Quote
  #4  
Old 23 Sep 2013, 00:42
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: 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.)
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #5  
Old 23 Sep 2013, 08:07
woodmj woodmj is offline
 
Join Date: Sep 2013
That's just what I was looking for Lynne, many thanks!


Originally Posted by Lynne View Post
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.)
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
vBFOAF - Friend of a Friend exporter for vBulletin 3 Cloud-Warrior vBulletin 3.0 Full Releases 9 29 Nov 2007 15:13
vBFOAF - Friend of a Friend RDF metadata exporter for vBulletin 3.5 Cloud-Warrior vBulletin 3.5 Add-ons 7 29 Nov 2007 15:12



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 08:51.

Layout Options | Width: Wide Color: