I am wondering if there is a way to set the user to be notified of posts as a default setting so they can later choose not to recieve emals rather than the other way around.

Also I am curious about one thing. On my community each user has a personal account page and a public profile page. I have the wall the public page but I want the user to see their wall and be able to use it from their account page aswell to make the users experience more aggrogated. When I use the DNN "add an existing module" tool to add the wall from the profile page, it shows up, but it does not display any content nor allow for posting by the user (there is a profile module instance on the account page set to logged in user) so the user ID is being passed in.

Any thoughs?

Mark

Ok, here is the script I ran on PokerDIY to update all existing users to Notify if they have not already changed their preferences (add in ObjectQualifier/change ModuleIDs/PortalID etc.):

 *EDIT* Fixed Not Exists query - 30th June, 2008

--get a list of all users on the site (exclude superusers and non-auth)
INSERT INTO SmartThinker_WallSubscription ([PortalID],[ModuleID],[RelatedID],[UserID],[Notify])
SELECT 6, 1970, U.UserID, U.UserID, 1
FROM Users U
INNER JOIN UserPortals UP ON UP.UserID = U.UserID
WHERE IsSuperUser = 0 AND Authorised = 1 AND UP.PortalID = 6
--Ignore all user that have already set their pref
and not Exists(select SubscriptionID from SmartThinker_WallSubscription W where PortalID = 6 and moduleID = 1970 and RelatedID = U.UserID and UserID = U.UserID)

Rodney Joyce wrote I just posted on someone's wall on PokerDIY and I thought of another feature for the next version:   If you post on someone's wall for the first time then it defaults Notification to on (if it is not your first post it assumes that you have decided already).

Just a follow up on this - I thought about this in more detail and it's going to be a significant performance hit to achieve this, so I have postponed it - I can go into more techincal detail if anyone wants, but this is not as simple as it seems.

I have also done a SQL script for updating all active Group members and all Event Guests. You will need to change your moduleID's PortalIDs and insert the correct objQualifier. Ru nat own risk...

--update all active group members to be notified when there is a new post
insert into SmartThinker_WallSubscription (PortalID, ModuleID, RelatedID, UserID, Notify)
select 6, 1963, GroupID, GU.UserID, 1
from SmartThinker_GroupUser GU
--make sure this user exists
inner join users U on U.UserID = GU.UserID
inner join UserPortals UP on UP.UserID = GU.UserID
where not Exists(select SubscriptionID from SmartThinker_WallSubscription W where PortalID = 6 and moduleID = 1963 and RelatedID = GroupID and GU.UserID = W.UserID)
and Up.portalID = 6 and Up.Authorised = 1
and ApprovalStatusID = 1

--update all event guests to be notified when there is a new post
insert into SmartThinker_WallSubscription (PortalID, ModuleID, RelatedID, UserID, Notify)
select 6, 1971, eventID, EU.UserID, 1
from SmartThinker_EventUser EU
--make sure this user exists
inner join users U on U.UserID = EU.UserID
inner join UserPortals UP on UP.UserID = EU.UserID
where not Exists(select SubscriptionID from SmartThinker_WallSubscription W where PortalID = 6 and moduleID = 1971 and RelatedID = eventID and EU.UserID = W.UserID)
and Up.portalID = 6 and Up.Authorised = 1