English (United States) English (United Kingdom)
Friday, March 12, 2010

Smart-Thinker DNN Forums

Forum Guidelines

Please ensure you follow the bug-raising guidelines (e.g. post the full error from your Event Viewer) if you are raising a support call. To request a feature in a module, please use Feature Requests (unless you want to discuss it here in more detail first). If you have an urgent feature that you would like to see in the product then you should consider a Sponsored Enhancement

First Time User? Make sure you have read the Module Config Guide in the documents folder of each module. Also check out this handy Module Deployment Guide (written by a Smart-Thinker customer!)

Configuration issues and no time to read the Forums/Documentation? See our DotNetNuke Premium Support Service. We need your opinion! Please read our proposed new CrowdSourcing development method and let us know if you would be interested and if it might work.

 
 
  Forums  DotNetNuke  Smart-Thinker W...  Post notifications by default and auto insert post on new user
Previous Previous
 
Next Next
New Post 6/9/2008 12:04 PM
Informative
  Ivan
64 posts
3rd Level Poster




Post notifications by default and auto insert post on new user  (United States)
Modified By Rodney Joyce  on 10/5/2008 7:02:28 PM)

There are a couple of enhancements needed here when the wall is working in a profile mode
 - make the wall owner (profile owner) be subscribed to the post notifications by default (right now he needs to go to his public profile and check the box - not intuitive). I understand that this may be hard…as the "wall" is not aware that a particular user exists. Maybe an auto-trigger the first time someone views a particular user profile. The other option is trigger at registration?
 - have a setting to disable  people to subscribe to post notifications on other peoples wall…..spaying is not cool:)

Thanks.

Ivan

 
New Post 6/9/2008 5:45 PM
  Rodney Joyce
3227 posts
www.DNNDir.com
1st Level Poster




Re: Post notifications by default  (Australia)
Modified By Rodney Joyce  on 6/9/2008 6:47:45 PM)

 Ivan wrote

There are a couple of enhancements needed here when the wall is working in a profile mode
 - make the wall owner (profile owner) be subscribed to the post notifications by default (right now he needs to go to his public profile and check the box - not intuitive). I understand that this may be hard…as the "wall" is not aware that a particular user exists. Maybe an auto-trigger the first time someone views a particular user profile. The other option is trigger at registration?
 - have a setting to disable  people to subscribe to post notifications on other peoples wall…..spaying is not cool:)

 

1) You would be amazed at how long I spent on this trying to find a good, clean solution. Basically it would be great if it could check what type of Wall it is do a query for that type (ie. UserProfile Wall is easy - Group would check GroupOwner etc). The problem is that due to various reasons I stroed the ModuleID in the first version of the Wall - even though they are on the same page there is no direct link to the module it is one the page with - ideally you need to attach a Wall module to a particular module on that page so you would be able to look up the Wall module which belongs to Group/Event/User and update the notification record for a user. I also looked at it from the other module's point of view - I know when a Group or Event is created, so I wanted to insert a record into the Wall module then for the Owner, but the same problem exists - it is too losely coupled. For the UserProfile module it may be a little easier as it is treated slightly differently below the scenes - all UserProfile walls (ie. UP type) could be updated for the related ID (ie. your wall) but I don't have access to the CreateUser event in the core, so a trigger may be an option. The other option is possible to check it On Load. If a record has not been created yet for the Owner than insert one, but I was worried about performance and scaleability. This may be the simplest solution yet and I will have a think about this again.

 

2) My reasoning for this was that you can use the Members/Owner/All setting to control who can see the Wall. My logic was therefore - IF they can see the Wall, they might as well be able to subscribe to Notifications? They can just as easily bookmark the page and check everyday with the same end result?


Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

Smart-Thinker DotNetNuke Development Blog
 
New Post 6/9/2008 6:09 PM
  Rodney Joyce
3227 posts
www.DNNDir.com
1st Level Poster




Re: Post notifications by default  (Australia)

For anyone reading this, this thread contains a SQL script to achieve this for now.


Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

Smart-Thinker DotNetNuke Development Blog
 
New Post 6/13/2008 9:37 PM
  Ivan
64 posts
3rd Level Poster




Re: Post notifications by default  (Bulgaria)

1) I can see how it is hard to create the default notification. We decided to use a db trigger on new user registration.

2) We will be implementing a profile privacy functionality using a css tabs module. On the public profile page all modules (working of userid in the string) will sit in tabs and each user can configer privacy options for these tabs (see by all, registered users or friends only). Allowing users to subscribe to notifications will by pass this....no biggie though...we can touch the code.

 

 
New Post 6/13/2008 10:32 PM
  Rodney Joyce
3227 posts
www.DNNDir.com
1st Level Poster




Re: Post notifications by default  (Australia)

1) Can you share it with the class if possible Ivan? I may use this in PokerDIY in the meantime and you'll save me 30 minutes ;)

2)  I could wrap this in a setting - we can discuss it when I get round to the next version of the Wall module.


Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

Smart-Thinker DotNetNuke Development Blog
 
New Post 6/19/2008 2:50 AM
  Ivan
64 posts
3rd Level Poster




Re: Post notifications by default  (Bulgaria)

see below. our portal is 0

IF OBJECT_ID('trig_AddREIMUser','TR') IS NOT NULL

                DROP TRIGGER trig_AddREIMUser

GO

 

CREATE TRIGGER trig_AddREIMUser

 

ON Users

 

FOR INSERT

 

AS

 

DECLARE @UserID int

 

SELECT @UserID =(SELECT UserID FROM Inserted)

 

INSERT INTO SmartThinker_WallSubscription ([PortalID],[ModuleID],[RelatedID],[UserID],[Notify]) VALUES (0,648,@UserId,@UserId,1)

 

go 

 
New Post 6/30/2008 4:31 AM
  Rodney Joyce
3227 posts
www.DNNDir.com
1st Level Poster




Re: Post notifications by default  (Australia)

Thanks for that - note that I have updated the other SQL post to include updates for Group Members and Event Guests... I may write trigger to do the same as this sometime and will share it here.


Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

Smart-Thinker DotNetNuke Development Blog
 
New Post 10/5/2008 5:37 PM
  Rodney Joyce
3227 posts
www.DNNDir.com
1st Level Poster




Re: Post notifications by default  (Australia)
Modified By Rodney Joyce  on 10/5/2008 6:38:41 PM)

I wanted to auto-insert a Wall Post for new users (like a Welcome, bla bla message - see this new user for an example) so I added this trigger (I may make this into a feature at some point):

 

--Creates a wall post for that user when a new user is inserted
IF OBJECT_ID('trig_AddNewUserWallMessage','TR') IS NOT NULL DROP TRIGGER trig_AddNewUserWallMessage
GO
 
CREATE TRIGGER trig_AddNewUserWallMessage ON Users
FOR INSERT
AS
DECLARE @UserID int
SELECT @UserID =(SELECT UserID FROM Inserted)
INSERT INTO SmartThinker_WallPost (PortalID,ModuleID,ParentPostID,RelatedID,Subject,PostText,CreatedDate,ChangedDate,CreatedByUserID,ChangedByUserID,WallType)
--Portal 6, ModuleID 1970
VALUES (6,1970,-1,@UserId,'','<p>Hi, I''m an admin and I''m here to help! You can...</p> <ul> <li><a href="http://www.pokerdiy.com/edit-pokerdiy-profile.aspx">Edit your profile</a></li> <li><a href="http://www.pokerdiy.com/find-poker-leagues.aspx">Find a poker league</a> to join</li> <li><a href="http://www.pokerdiy.com/tell-a-friend.aspx">Tell some friends</a> about PokerDIY</li> <li><a href="http://www.pokerdiy.com/faq.aspx">Read the FAQs</a></li> </ul> <p>Still lost? <a href="http://www.pokerdiy.com/poker-forums.aspx">Introduce yourself on the forums</a> or <a href="http://www.pokerdiy.com/poker-player-profile/id/1.aspx">drop me a line on my wall</a>...</p>',GetDate(),GetDate(),1,1,2)
GO

 

Replace the ModuleID, PortalID and appropriate fields to match your site of course.


Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

Smart-Thinker DotNetNuke Development Blog
 
New Post 10/30/2008 6:34 AM
  Steve J.
60 posts
3rd Level Poster


Re: Post notifications by default  (United States)

As far as the trigger goes to personal wall subscriptions, do you do it for the module on their personal profile page or on their public profile page?  If you do it on their personal profile page will it send a message if they post a message one to their own Wall setup with "logged in" user?

Thanks,
Steve

 
New Post 11/2/2008 3:23 AM
  Rodney Joyce
3227 posts
www.DNNDir.com
1st Level Poster




Re: Post notifications by default  (Australia)

[QUOTE]Steve J. wrote

...do you do it for the module on their personal profile page or on their public profile page?  If you do it on their personal profile page will it send a message if they post a message one to their own Wall setup with "logged in" user?

/QUOTE]

I do it on the public profile page (the passed-in one). Yes, if you did it on the logged in one it would notify the person who posted on it, which would be the logged in user.


Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

Smart-Thinker DotNetNuke Development Blog
 
New Post 3/14/2009 8:02 AM
  MarkSensei
118 posts
3rd Level Poster


Re: Post notifications by default  (Japan)

dumb question, but to use this trigger, where should it be included?

Thanks

Mark

 
New Post 5/6/2009 2:50 AM
  jesper
178 posts
3rd Level Poster




Re: Post notifications by default  (Denmark)
Modified By jesper  on 5/6/2009 3:54:27 AM)

Hi Mark, did you figure this out already? 
It's in Host->SQL

I want to emphasize that you should not fiddle with SQL without some knowledge about what you are doing and never do anything without a complete site backup first. You will cry if you don't ;-)

Sry for this late reply but all the pinned topics (like this topic) doesn't show up on the aggregated list, and I mostly only look at the aggregated list.

 
New Post 6/9/2009 5:25 AM
  Duc Le
7 posts
5th Level Poster


Re: Post notifications by default  (Vietnam)

Hi guys, thanks for the solution.

When I execute these scripts, I get this error:

System.Data.SqlClient.SqlException: Incorrect syntax near 'GO'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

Even very simple queries, such as:

GO

GO

give the same error.

This error occurs in both SQL Server 2005 & 2008. Any ideas?

Thanks,

Duc

 
New Post 6/19/2009 4:36 AM
  Duc Le
7 posts
5th Level Poster


Re: Post notifications by default  (Vietnam)

I've designed a set of triggers to default post notification in the group wall to true when a user joins a group. The solution is described in this article. Feedback is greatly appreciated!

Thanks,

Duc

 
Previous Previous
 
Next Next
  Forums  DotNetNuke  Smart-Thinker W...  Post notifications by default and auto insert post on new user
Top Threads Minimize
In the past 1 week, we have 3 new thread(s) and 4 new post(s)
The most popular thread has been Re: Event Module Installation Error on DNN 5.1
The most active thread has been Event Control is currently unavailable
In the past 1 week, we have 3 new thread(s) and 4 new post(s)
The most popular thread has been Re: Event Module Installation Error on DNN 5.1
The most active thread has been Event Control is currently unavailable
Print  

Smart-Thinker is powered by DotNetNuke - please support us and DotNetNuke - DotNetNuke Powered!
Smart-Thinker is powered by DotNetNuke - please support us and DotNetNuke - DotNetNuke Powered!
© 2008 Smart-Thinker