achievements
#9

Quote:
Originally Posted by XStormiest
View Post
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.
Thank you very much, but I have not understood completely, excuse me (I need coffre haha). If it's not too much trouble you could show me a picture on the db of what it would be like? I haven't understood much
Reply


Messages In This Thread
achievements - by Ertouq - 18.05.2020, 13:56
Re: achievements - by jasperschellekens - 18.05.2020, 14:00
Re: achievements - by Ertouq - 18.05.2020, 16:11
Re: achievements - by XStormiest - 18.05.2020, 16:56
Re: achievements - by Ertouq - 18.05.2020, 17:18
Re: achievements - by XStormiest - 18.05.2020, 17:31
Re: achievements - by Ertouq - 18.05.2020, 17:41
Re: achievements - by XStormiest - 18.05.2020, 17:58
Re: achievements - by Ertouq - 18.05.2020, 18:10
Re: achievements - by XStormiest - 18.05.2020, 18:50

Forum Jump:


Users browsing this thread: 1 Guest(s)