Best strategy for implementing stackoverflow style system icons in asp.net mvc

Question

I was wondering what would be the best strategy for implementing an icon system using asp.net mvc. One that has stackoverflow is pretty interesting. What do you suggest?

I think I need to clarify the question a bit. The problem would be in the different criteria for getting each badge. How to make this logic extensible?

Answer 1

I would do it exclusively in T-SQL and set up an SQL job that runs periodically (Jeff did this with C # and has a dumb system where it starts the process based on the page request).

Basically, in your SQL job, scan your member tables and count if someone is qualified for the icon, if so, update the icon table (s).

Then, in the interface, run a query to get new member icons for each query.