MasterACE14 Posted August 18, 2011 Share Posted August 18, 2011 This isn't a PHP problem, but more one of a design issue. Basically I wish to develop an 'Achievement' system, similar to what Steam, Windows Live and PSN have. My issue is in the design, I really aren't sure how to go about doing this(in php). Ok firstly, this is how my newly developed website works... - Main Site (where users both register and login - central account database) - Sub Sites (once logged in at the Main Site, their session allows them to access the sub sites with their accounts made in the sub site's database) So I'm not sure where to store the achievements? Should I store them in the central account database, or the individual sub site databases? At the end of the day, I'd like the users to be able to view all their achievements from all sub sites in their main site profile. Sorry in advance if the details seem vague. Appreciate your thoughts! Thanks, Ace Quote Link to comment Share on other sites More sharing options...
KevinM1 Posted August 18, 2011 Share Posted August 18, 2011 Achievements should be part of each main user account. The sub sites should update that info when a user earns an achievement. A table with columns for userID, game/sub siteID, and achievementID would probably suffice. Quote Link to comment Share on other sites More sharing options...
MasterACE14 Posted August 19, 2011 Author Share Posted August 19, 2011 ok, I shall do that. Thank you! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.