Best strategy to implement stackoverflow style badges system in asp.net mvc
I was wondering what would be the best strategy to implement a badges system using asp.net mvc. The one that stackoverflow has is pretty interesting. What do you suggest?
I guess I need to clarify the question a bit. The problem would be the different criteria for earning every badges. How do make that logic extensible?
I'd do it purely in T-SQL, and set up a SQL job that runs periodically (Jeff did it using C#, and has a goofy system where it runs the process based on a page request).
Basicly, in your SQL Job, scan your member tables and calculate if anyone is qualified for a badge, if so, update the badge table(s).
Then in the front end, do a query to retrieve new badges for a member on each request.
链接地址: http://www.djcxy.com/p/41950.html