[itsRahul]

Instead of making a new thread, I'll try here for another small issue.

I believe that when I deleted a lot of spambots and inactive users some time ago, the friends counters for some users (such as myself) became inaccurate. For example, my friends list said "19 friends" when my full friends page only contains 5 users. I set my `friendcount` to 5 through phpmyadmin and that fixed it, but I'm sure there are other users with this problem, so I want to simply wipe everyone's friendlist and reset the counters. However, I don't think this is the solution, because of the following.

After learning that `usertextfield` contains the buddy lists, I tried setting my buddy list to NULL, so that my friends list would become empty. After refreshing my forum profile page, it showed the same 5 users. I set my `friendcount`to 0, and this showed 0 friends and displayed no users. So I thought that fixed it, but I set my `friendcount` to 2 just to double-check, and it showed 2 of my old 5 friends. In `usertextfield` my buddylist is still set to NULL. How can I make sure that the list gets wiped and reset, before applying this to all users?