Dan Mackey On ColdFusion Development

ColdFusion, Java, .NET, AJAX, DHTML development and general programming. Daniel is owner and Administrator of CFTagStore.com and works for an Application Development Company in Ireland called Digital Crew. His interests cover all areas of programming in multiple languages with a particular interest in Internet Technologies.

All Articles tagged : CFForumsExpress
2006-09-11 16:05:00.0

RSS Feed Counter

For a while now, I was interested in knowing how many actual subscribers I had to my blog. While my Blog stats showed me general stats, it did not show me a count of the RSS subscribers. Luckily, Peter had the same idea and wrote some handy code which I used as a basis for my tracking.

I added in a few extra fields so capture the user_agent and remote_host fields aswell as the last date the feed was consumed.

I reckoned Peters way was fairly clever and was simple to implement.

The basis is to use CFHEADER to send a message of Moved Permanently so the users agent would update their feed which infact tacked on a UID to identify them.

By checking to see if the UID was present on subsequent calls, I could update the other fields.

Below is a shot of the code and it is short and should make alot of sense.

I also have a field in the database which marks whether the subscriber is an aggregator or an RSS Reader. I am going to use this to place badges on my blog showing the number of individual subscribers like FeedBurner

If nothing else, this little excerise has thought me to look into the ON DUPLICATE KEY UPDATE directive in SQL and the ability to chain a number of updates together.

Add to your del.icio.us    DIGG This!    Technorati Cosmos Link    Post to Reddit    Add to your Furl    Add to Blinklist
Comments [1] - Leave a comment
2006-05-19 12:38:00.0

CFForumsExpress MSSQL and MYSQL

Just finished packaging up CFForumsExpress with MSSQL and MYSQL support with integrated Administration.

This is a pre-release version to help customers get up and running with MSSQL.

If you have purchased a copy and would like to use the pre-release version, please email me dan@digital-crew.com

 

Add to your del.icio.us    DIGG This!    Technorati Cosmos Link    Post to Reddit    Add to your Furl    Add to Blinklist
Comments [0] - Leave a comment