To get this to happen, must the user register via active social or is it linked through core dnn registration? I have set this feature up in the control panel and members are not being autofriended or autogrouped.

You must use the Active Social signup and login controls in order for these features to work properly.

I beleive you will have to use the AS registration for this to happen.

ughh...ok, thanks. That doesn't always work because I know there are a few of us who are registering in other ways because of payment requirements, etc.

I am using Dynamic registration and adding users to a pre-defined group and auto-friending using the SQL completion event.  It's working well for me.

Hi Ricky, would it be possible to share your completion event SQL?

Cheers
Ben

Hey Ben,

This is how I am accomplishing my auto-friend & auto-groups using Dynamic Registration:

To add a user to a group on registration I created an SQL completion event with the following SQL Statement:

INSERT into activesocial_Groups_Members (GroupId,UserId,MemberStatus,DateCreated,DateApproved)VALUES('Your Group ID','$(UserID)','1',GetDate(),GetDate())

You can look in activesocial_Groups to find out what the GroupId is...


For Auto-Friend there is an additional step.  To automatically add a friend on registration, I created 2 SQL completion events with the following SQL statements:

1st Event

INSERT INTO activesocial_Friends  (FriendId, UserId,PortalId,IsApproved,IsRejected)VALUES ('Friend ID','$(UserID)','$(PortalID)','True','False')

2nd Event

INSERT INTO activesocial_Friends  (FriendId, UserId,PortalId,IsApproved,IsRejected)VALUES ('$(UserID)','Friend ID','$(PortalID)','True','False')


If you only use 1 event for auto-friend, then it's like you've added someone but haven't been confirmed by the other person, so use the 2 events as I have described.  You could additionally use an email completion event to inform the new user that they have a new friend.  I didn't create the email event, but it would be easy to do.  Hope this helps.

Thanks Ricky, this helps me out until I can move back to the Active Social Registration process.

Cheers

Thanks!

>
INSERT into activesocial_Groups_Members (GroupId,UserId,MemberStatus,DateCreated,DateApproved)VALUES('Your Group ID','$(UserID)','1',GetDate(),GetDate())

INSERT into activesocial_Groups_Members (GroupId,UserId,MemberStatus,DateCreated,DateApproved)VALUES('5','$(UserID)','1',GetDate(),GetDate())

Something like this?

Does this look correct? Anyone please

1st Event
INSERT INTO activesocial_Friends (FriendId, UserId,PortalId,IsApproved,IsRejected)VALUES ('1656','$(UserID)','$(PortalID)','True','False')

2nd Event
INSERT INTO activesocial_Friends (FriendId, UserId,PortalId,IsApproved,IsRejected)VALUES ('$(UserID)','1656','$(PortalID)','True','False')

I was also wondering whether there is a way to add a predefined friend to all old members via sql script? Also, has anyone worked out any solution to integrate Dynamic Registration with AS when it comes to the profile picture? Is there is/are such thing/s, can anyone please share it? Thanks a lot.

That looks correct Frozen..

Posted By R1ckJon3z on 30 May 2010 07:48 PM
That looks correct Frozen..

Thank you!