> Forums > Active Social > Community Support > Set WhoCanEmail at Database Level
Last Post 01 Feb 2012 08:16 PM by Joseph. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Joseph
Customers
Joseph
Post Count:16

--
31 Jan 2012 04:23 PM
    • Active Social Version: 1.9.3
    • DotNetNuke Version: 5.6.2
    I read somewhere that in order to have the "Who can Email and Post" permissions to Everyone, that this needed to be done at the database level.

    I see the WhoCanPM column in the activesocial_User table. How do I change the table/column design so that it defaults to "2" instead of "1".
    Ben - DotNetNuke
    DotNetNuke Staff
    Ben - DotNetNuke
    Post Count:1645

    --
    01 Feb 2012 11:42 AM
    I am sorry, but we don't support direct database manipulation.

    Having said that, which setting exactly are you trying to update? There is the "Add Comments" setting and also the "Who Can Send You Messages" setting. I assume you want both of those to default to everyone.

    The second one is the easiest. On the Settings page of the control panel, in the Messaging section, there is a User Default Availability dropdown that you can set to Everyone. For existing users you may need to run a script to update them all, or just let them do it themselves.

    For the first one, comments, please see this topic: http://www.activemodules.com/active...t-working/

    It does default to Friends now though.
    Joseph
    Customers
    Joseph
    Post Count:16

    --
    01 Feb 2012 08:16 PM
    Ben,

    Thanks! We haven't gone live with the URL yet so I haven't messed around with the General Settings too much. It does look like what you mentioned work work.

    In the mean time I added a trigger to handle some of the key settings:


    CREATE TRIGGER UpdateWhoCanPMonActiveSocialUserInsert ON activesocial_User AFTER INSERT AS DECLARE @UserID int SELECT @UserID = (SELECT UserID FROM Inserted) UPDATE activesocial_User SET WhoCanPM = 2, WritePost = 2, ShareLink = 2, WriteNote = 0, AddComments = 2, GalleryView = 2, GalleryRatings = 2, GalleryComments = 2 WHERE UserID = @UserID

    I found it in this thread:  http://www.activemodules.com/active...ngs/#32328

    Joseph
    You are not authorized to post a reply.
    > Forums > Active Social > Community Support > Set WhoCanEmail at Database Level
    test
    Copyright 2012 by DotNetNuke Corporation / Terms of Use / Privacy