Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...I will pay you $500 if you give me this or better than this but same format!I will pay you $500 if you give me this or better than this but same format!
Previous
 
Next
New Post
10/5/2007 2:40 PM
 

bump

 
New Post
2/7/2008 1:34 AM
 

We did something very similar to this last year on a community forum we started using AF.

AF rocks, by the way!!

The members who migrated from an older forum style complained about the way AF organized things. We silently disagreed with these members, but obliged them anyway. After going to the trouble of making the appropriate SQL view of AF threads, we used a Reports module to display the live threads in this older style. The AF threads are displayed in the Reports module so the subject is a hyperlink to AF so the user could add replies inside AF. After a very short time, the users became more comfortable with AF and they no longer use the older style. We left the older forum style running, just in case others want that style.

SELECT     TOP (100)
                      PERCENT '<div><a  href="http://www.yoursite.com/Forums/tabid/65/postid/' + CAST(CASE WHEN dbo.NTForums_Posts.ParentPostID = 0 THEN dbo.NTForums_Posts.PostID
                       ELSE dbo.NTForums_Posts.ParentPostID END AS varchar(8))
                      + '/view/topic/Default.aspx"  title="view Post">' + CASE WHEN dbo.NTForums_Posts.ParentPostID <> 0 THEN '&nbsp;&nbsp;&nbsp;' + dbo.NTForums_Posts.Subject
                       ELSE '<br>' + dbo.NTForums_Posts.Subject + '</a></div>' END AS Subject,
                      CASE WHEN dbo.NTForums_Posts.UserID = - 1 THEN CASE WHEN dbo.NTForums_Posts.ParentPostID = 0 THEN '<br>' + dbo.NTForums_Posts.UserName
                       ELSE dbo.NTForums_Posts.UserName END ELSE '<div><a href="http://www.yoursite.com/Forums/tabid/65/view/profile/uid/' + CAST(dbo.NTForums_Posts.UserID
                       AS varchar(8))
                      + '/Default.aspx" title="view Profile">' + CASE WHEN dbo.NTForums_Posts.ParentPostID = 0 THEN '<br>' + dbo.NTForums_Posts.UserName ELSE dbo.NTForums_Posts.UserName
                       END + '(' + CAST(dbo.NTForums_UserDetails.Posts AS varchar(8)) + ')</a></div>' END AS [Posted By],
                      CASE WHEN dbo.NTForums_Posts.ParentPostID = 0 THEN '<br>' + CAST(dbo.NTForums_Posts.DateAdded AS varchar(20))
                      ELSE CAST(dbo.NTForums_Posts.DateAdded AS varchar(20)) END AS [Date Posted]
FROM         dbo.NTForums_UserDetails RIGHT OUTER JOIN
                      dbo.NTForums_Posts ON dbo.NTForums_UserDetails.UserID = dbo.NTForums_Posts.UserID
WHERE     (dbo.NTForums_Posts.ForumID = 6) AND (dbo.NTForums_Posts.Deleted = 0)
GROUP BY dbo.NTForums_UserDetails.Posts, dbo.NTForums_Posts.DateAdded, dbo.NTForums_Posts.PostID, dbo.NTForums_Posts.ParentPostID,
                      dbo.NTForums_Posts.Subject, dbo.NTForums_Posts.UserName, dbo.NTForums_Posts.UserID
ORDER BY CASE WHEN dbo.NTForums_Posts.ParentPostID = 0 THEN dbo.NTForums_Posts.PostID ELSE dbo.NTForums_Posts.ParentPostID END DESC,
                      dbo.NTForums_Posts.DateAdded

So users could add "New Posts" we used a Links module viewable by registered users allowing us to track how many clicks and point it to the AF fourm TabID and ForumID like this: http://www.yoursite.com/Forums/tabid/[TabidForAF]/view/post/forumid/[AFForumID]/Default.aspx.

Hope I not am too late to help. I just saw your post.

Good luck!!


 
New Post
2/11/2008 8:29 PM
 

I have modified AF, a lot, but still would like to have the threaded view. Can I see where you have implemented the above style? Thanks for your time.

 
New Post
2/13/2008 2:10 AM
 

Live forum implementation has some sensitive content, so please contact me offline to discuss.


 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...I will pay you $500 if you give me this or better than this but same format!I will pay you $500 if you give me this or better than this but same format!


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out