[widget] BE1.6.x - SQL - Most Viewed

Topics: ASP.NET 2.0, Controls
Jun 25, 2011 at 5:49 AM
Edited Jun 25, 2011 at 5:49 AM

I found some few articles regarding this funtionallity in BlogEngine.NET but I'd really like to make my own. So as you can see from that screen shot, I have the widget on the left and sql query from the right. I used SQL Server anyway so if you guys still use XML, this is not for your BE. Well you can still read though to get some ideas.

Am using BE 1.6.1 - this could be compatible with 1.6 or lower version or higher? correct me if I'm wrong.

 

How things works?

Well I added a new table called "be_PostViews" and 2 new Stored Procedure to Update/Insert records and get the TOP 5 most viewed posts. Then I have a new Widget called "MostViewed".

 

Read more here:

http://jaysonragasa.net/post/2011/06/25/BlogEngineNET-WIDGET-Most-Viewed-Post.aspx