Thomas Kohler

DNN Blog Module does not provide proper URL for images

thomas.kohler@enio.ch — Wed, 11 Feb 2009 09:22:00 GMT

Recently I discovered that certain RSS readers could not display my images
that I added to my blog posts.

After diving into this topic I discovered that the image source in DNN is mapped
to something like:

/Portals/0/images/%5BProvider%5D/%5BUser%5D/%5BYear%5D.....

so basically the http://domain part is missing which some RSS readers have problem with.

After some email traffic with Don from ITCrossing (http://www.itcrossing.com) he pointed out that this is not an error of the blog provider of the metaPost module (http://dnn.itcrossing.com/products/modules/metapost/) of them which I use to post my articles with Windows Live Writer to DNN but rather of the DNN blog module itself. He told me to check this site to find a possible solution:

http://www.subodh.com/Blog/EntryId/110/Fixing-the-DNN-Blog-and-Feedburner-issues.aspx

The proposed solution is to adapt some changes in the stored procedures of the DNN installation.
After diving into this I tried to change the stored procedure as mentioned in the blog entry above but it did not solve my problem fully. So I did have a closer look at it.

Firstly, I changed not to replace the Description field but the Entry field.
Secondly, I changed more than only the mentioned SP Blog_GetEntry. I changed the following SPs:

Blog_GetEntry
Blog_ListEntriesByPortalByMonth
Blog_ListEntriesByPortalByDay
Blog_ListAllEntriesByBlog
Blog_ListEntriesByBlog
Blog_ListEntriesByPortal

Download All Files download

The change is to replace some text of the blog entry and add the missing fields:

if you have the PortalID as a parameter in the SP use:

   1:  DECLARE @Prefix varchar(53)

   2:  select top 1 @Prefix='http://'+RTRIM( LTRIM(PA.HTTPAlias))

   3:  from

   4:      Blog_Blogs B,

   5:      Users U, UserPortals UP, PortalAlias PA

   6:  where B.PortalID=@PortalID and B.UserID= U.UserID and UP.UserID =U.UserID and PA.PortalID = UP.PortalID

   7:  order by PA.PortalAliasID asc

if you have the BlogID as a parameter in the SP use:

   1:  DECLARE @Prefix varchar(53)

   2:  select top 1 @Prefix='http://'+RTRIM( LTRIM(PA.HTTPAlias))

   3:  from

   4:      Blog_Blogs B,

   5:      Users U, UserPortals UP, PortalAlias PA

   6:      where B.BlogId=@BlogID and B.UserID= U.UserID and UP.UserID =U.UserID and PA.PortalID = UP.PortalID

   7:  order by PA.PortalAliasID asc

and then:

   1:  cast(

   2:  Replace(

   3:  REPLACE(cast(E.[Entry] as varchar(max)),'"/Portals/','"'+@Prefix+'/Portals/')

   4:  ,'"/Portals/','"'+@Prefix+'/Portals/')

   5:  as ntext) as [Entry],

!!!!! By changing the SPs be aware that on every update of the blog module your changes will be overwritten. Also be aware that all changes of the SPs you do by your own risk so please back up the SPs before you start changing them. !!!!

More ...

C4F Vista Peer-to-Peer Toolkit

thomas.kohler@enio.ch — Thu, 10 Apr 2008 14:34:28 GMT

This project was created to demonstrate the power and ease of creating fun, cool applications with Visual Studio 2008 Express Editions. The P2P controls are composed of both WinForm and WPF controls that you can use to create different types of P2P enabled applications. You can develop P2P applications like chat, streaming audio and streaming video applications with no lines of code.

http://www.codeplex.com/C4FP2P

More ...

C4F Developer Kit

thomas.kohler@enio.ch — Thu, 10 Apr 2008 14:33:12 GMT

C4F Developer Kit project was created to demonstrate the power and ease of creating fun, cool applications with the new Visual Studio 2008 Express Editions. The kit features include drag ‘n drop controls and components, SmartTags, Visual Basic and Visual C# source code for all tools and samples as well as complete QuickStarts and APIs documentation. For more information on this project, visit the C4F Developer Kit home page on the Visual Studio 2008 Express Web site. Addtionally, we've created the C4F Vista P2P Toolkit for adding peer-to-peer functionality to WinForm and WPF applications.

http://www.codeplex.com/C4FDevKit

More ...