I am currently designing one education site.
For this we need to assign some badges to user based on their activity (like stackoverflow).
I was looking for a framework for this. Any one have any idea, how this can be done? Table design etc.
Issues which I could think of with this are :
- We may have large number of badges, so on each action of user we can not check all badges and check if any badge can be assigned
- On adding a new badge and criteria for this, I dont want to change the existing code to handle this (can we have some generic solution?)
- Which db should I choose (lets say if my framework in like, it raises the event when criteria for one badge satisfies and these rules are created in DB(like sql). or can I go for nosql db (like mongodb as my rest of the project is in mongodb )
My initial search gave me following things
- rule engine -> will result in very tedious task Database Architecture for "Badge" System & Arbitrary Criteria (MySQL/PHP)
- One project -> http://drupal.org/project/user_badges ( not able to understand it properly)
- people are saying your table structure should be like this and this ..and all .. Best way to store Badge criteria? Creating "Badges" for my site, best way to store user badges? Using PHP