18.05.2020, 18:10
Quote:
Well, every time you create a new achievement, you create it for the player, or the player name or character name or whatever you want to use. You need to create a table that has 2 foreign keys. One foreign key that comes from your account table. A second key from the table that handles achievements with data like name, progress, etc. (This one you have to create as well)
Then you create a third table that has 2 foreign keys, like accID (or whatever you want to use), achvID So this table will probably be named 'player_achievements' and will have as column names the next variables: p_achvid | pID (whatever you won't use here, like: charID, accountID, playerName, accountable, etc) | achvID Where pID, achvid is a foreign key, and p_achvid is the primary key in this table. |