Sorry if this was asked, but is there anyway to apply this via SQL retroactively to certain usergroups (basically only active members)? As in, I know this works for future registrations, but what about existing members that I want to make my friend now?

is there one for vb 4.0??? please let me know

Works on 4.0.6, no pm is sent though however no DB error as some 3.x users posted above.

Are you sure it is adding friends? I tried adding it to 4.1.2 on my test site. When I added a new account it didn't seem to add my chosen account to friends, then when I tried to verify the account it got that same db error.

So... I guess it doesn't work with 4.1.x...

will this work with vB4 +?

This one is not working either for vB 4.1.4

Does this work with vb4?

Works great at 3.8...

An "issue", only adds to Friends list, not to contacts... can you add the option to add the user to "friends" and "contacts" too?

That's the reason there's not a + beside the Nick/Username. To addit have to go under Control Panel -> Buddy / Ignore Lists --> ADD TO CONTACT LIST...

Uninstalled...

After 1012 added friends my profile crashed and a SQL ERROR screen appears when ANY user try to see my profile...

This is the error:

PHP Code:

---

Invalid SQL:

                               SELECT user.*, (user.options & 512) AS invisible , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.filedata_thumb, customavatar.height AS avheight, customavatar.width AS avwidth, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb

                               FROM vBuserlist AS userlist
                               INNER JOIN vBuser AS user ON (user.userid = userlist.relationid)
                               LEFT JOIN vBavatar AS avatar ON (avatar.avatarid = user.avatarid)
                               LEFT JOIN vBcustomavatar AS customavatar ON (customavatar.userid = user.userid)

                               WHERE userlist.userid = 1
                                       AND userlist.type = 'buddy'
                                       AND userlist.friend = 'yes'

                               ORDER BY RAND()
                               LIMIT 0, 1.033;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1.033' at line 13
Error Number  : 1064 


---

It'd be so nice to see this updated to work once more than 1000 users have joined.