I've updated my previous post with the actual implementation after testing and tweaking. The stored procedure for paging through threads in a forum from newest to oldest is quite different than my original post. The paging through posts in a thread is more like my original idea because it pages from oldest to newest. The forums are coming along nicely now. Once I finish with the MS SQL implementation it will be only a little extra work to get the MySQL version working so I can show it off on this site. This site is using MySQL but on my development machine I switch back and forth between the the 2 data layers as needed.

I started work on the forums module today. Didn't get too much done but stubbed out the basic pieces of the puzzle as I envision them. I'm basing it on the functionality of the forums at http://www.gotmono.com. Its using yabb, (Yet Another Bulletin Board), a very nice implementation in perl.

This skin only took about 20 minutes to create. When I have time I'll do something more elaborate. For the moment I'm much more focused on functionality than making it pretty. I envision being able to create tools within the site that will allow creation of skins using the web browser. Other features need to be done first. I'd like to have the photo gallery and forums modules ready before I make a release, particularly the forums because then if people find bugs they can post to the forum instead of sending me an e-mail and I can avoid having to answer the same questions to multiple users.