As an idea, how about decoupling the events of the business logic that you care about, from how you consider them as points, badges, levels for the user? So you can sell walnuts in one place, such as the Ball Buzz badge to buy coffee for three consecutive Mondays during the football season.
Conceptually think about sending a message to all potentially interesting transactions and interactions with this reward module, which encapsulates (and hides from accountants) this fun functionality.
After further consideration of SO, there was already a substantial discussion of the subject. Of particular note are the “Best Way to Store Icon Criteria”, covering event notification and “Database Architecture for the Icon system with the overall architecture .
The relative merits of relational versus nosql / Mongodb for such a function, as well as the breakdown of business logic into stored procedures, were discussed.
It seems to me that there are many inventive wheels. Does anyone know the OSS framework or the Github projects arising in this area? Also, any useful articles or articles on the subject of badges specifically and gamification in general?
Walter k
source share