Berger tables kombination

[ebchost]

I try to make Soccer manager, and i have problem to make fixtures by the automaticly rules of Berger tables as shown in table in botom of this post

 

I have 10 clubs in the N number of Ligue in table man_timovi

------------------------

| id | name | ligue |

------------------------

| 1 | Club1 | 1 |

| 2 | Club2 | 1 |

| 3 | Club3 | 1 |

|....

|10 | Club10 | 1 |

| 11 | Club11 | 2 |

| 12 | Club12 | 2 |

| 13 | Club13 | 2 |

|....

|20 | Club.20 | 2 |

|...

----------------------

 

By the Berger rules, first, second.... round is like this:

-------------------------------------------

| Round  | Ligue | GAME |

--------------------------------------------

Round 1 |  Ligue 1 | ID1 vs ID10

Round 1 |  Ligue 1 | ID2 vs ID9

Round 1 |  Ligue 1 | ID3 vs ID8

Round 1 |  Ligue 1 | ID4 vs ID7

Round 1 |  Ligue 1 | ID5 vs ID6

Round 1 |  Ligue 2 | ID11 vs ID20

Round 1 |  Ligue 2 | ID12 vs ID19

Round 1 |  Ligue 2 | ID13 vs ID18

Round 1 |  Ligue 2 | ID14 vs ID17

Round 1 |  Ligue 2 | ID15 vs ID16

.... etc (depends on the number of leagues, each league is played for 18 rounds)

------------------------------------------------------------------------------------------------------

 

 

How to make code, with Berger table combiantion  ruls?

 

Manual, game by game is no good, What if wee have more then 1000 ligue in manager?

 

Thanks

 

BERGER TABLES FOR 10 CLUBS in halfseson

--------------------------------------

R| G1 | G2 | G3 | G4 | G5

-------------------------------------

1 | 1-10 | 2-9 | 3-8 | 4-7 | 5-6

2 | 10-6 | 7-5 | 8-4 | 9-3 | 1-2

3 | 2-10 | 3-1 | 4-9 | 5-8 | 6-7

4 | 10-7 | 8-6 | 9-5 | 1-4 | 2-3

5 | 3-10 | 4-2 | 5-1 | 6-9 | 7-8

6 | 10-8 | 9-7 | 1-6 | 2-5 | 3-4

7 | 4-10 | 5-3 | 6-2 | 7-1 | 8-9

8 | 10-9 | 1-8 | 2-7 | 3-6 | 4-5

9 | 5-10 | 6-4 | 7-3 | 8-2 | 9-1

-------------------------------------

 

R is Round, G1,G2, G3, G4, G5 is number of the game