Organization of the standings

Question

MySQL

Hello.

In the course of work on the game project, the task of creating a tournament grid became.
Here is a good example of what I need.


But the question arose, how can I store all this in the database?
Not a single sensible idea has yet come to mind. I count on your advice.

Answer 1

match table, where there are fields - id, id of players, match position (in level), match level (1/32, 1/16, ...), status (ongoing, is there a winner, ...)
the match ends, level++, position = position / 2.

Answer 2

I have an implementation of such a thing, you can write to habramail - I will gladly share the structure

Answer 3

The leaderboard is essentially a binary tree (and this is the so-called full binary tree), so you need to look for a representation of binary trees in relational databases.
I looked at the profile - you know PHP, which means a good place to start from:
phpclub.ru/faq/Tree?v=w5u

Answer 4

i would number all games and store 3 records: player1 id, player2 id, winner id
15 lines