Remove All Members Friends
 

I was told to run this query on VBulletin.com:
update userlist set friend='' where userid='3';
update user set friendcount='';

Since I had over 3000 member I wished to remove just my friends and remove me from my friends profiles. However this query messed up and now it shows NO one has any friends, but when I go in to accept new friends, there are ALL of my friends shown there.


So my question is there a query to reset everything to make it so no one has ANY friends at all?

Can you link to your thread on vB.com, because I'm having a bit of trouble understanding exactly what it is you want to do.

Do you want to remove everyone's friends? O.o

No I wish to remove MY friends only. I have over 3,000 friends and when I try to accept a new friend invite (you know how it loads ALL of your friends when you go to accept a new friend request?) it freezes my browser.

So I wish to remove my friends and to remove me from my friends.


http://www.vbulletin.com/forum/proje...?issueid=28370