[TigerC10]

MrBig, you can query the database yourself. If you've set your permissions properly (in the config.php file, look for $config['SpecialUsers']['canrunqueries'] and make sure your userID is allowed), then in the AdminCP at the bottom under the "Maintenance" section, go to "Execute Database Query".

It goes without saying that you should make a database back up before doing this, just in case something goes wrong. This code is untested, but should work. Be 100% sure that you get a database backup before trying this.

Reset your friend count

UPDATE vb_user SET friendcount="0" WHERE userid="1"

Delete all friends from your list

DELETE FROM vb_userlist WHERE userid="1" AND type="buddy" AND friend="yes"

---------------------------------------------------------------------------

Reduce friend counts from everyone else that lists you as a friend

UPDATE vb_user LEFT JOIN vb_userlist ON vb_user.userid = vb_userlist.userid SET vb_user.friendcount = vb_user.friendcount-1 WHERE vb_userlist.relationid="1"

Delete yourself from everyone else's friend lists

DELETE FROM vb_userlist WHERE relationid="1" AND type="buddy" and friend="yes"

Of course, replace "vb_" with your table prefix, or delete it if you don't have a table prefix. And replace the 1 with your userid, assuming you're not userid 1 (don't forget to change the "relationid" variables away from 1). The first two and the last two must be done together as pairs, but you do not have to do all 4 of them. If you just want to clear YOUR friend list, and still let other people list you as a friend, just do the first two.


Then go to your trusty Maintenance section, and open the "Update Counters" page, and "Fix Broken Profiles" (this is just in case - it shouldn't have an effect, I don't think it even resets the friend counts properly).




@King Kovifor - Maybe adding in a friend establisher/resetter feature would be good. I know some people complained when it didn't retroactively make friendships for existing users. And here you see MrBig wants to be able to start fresh on his friend list. You need to update the .xml file because of the e-mail activation bug anyway - might as well just throw in some shiny new features. Using the code I just provided above (assuming it's fully correct - the only query I worry about is the left join one... which I guess is the important one) it shouldn't be too difficult to implement a friendlist resetter, and going backwards to make a friendlist establisher shouldn't be too difficult.