Ok so I'm gonna give up and see if anyone here will give me a hand with this before I throw my pc off a bridge.
Little bit of backstory, I am in the process of creating a database loosely based of the current Counter-strike pro scene. I am reviving old orgs, or orgs that have left CS but still exist, in place of organisation-less teams that don't have a logo on liquipedia.
The problem:
So my plan is to make some of the domestic leagues that exist, or did exist, and then have ESL Pro League/ESEA Leagues as continental competitions. At the moment this is going relatively ok, but I've ran into an issue when it comes to the german league "ESL Meisterschaft". The league structure in this one is a bit whacky, it starts off with an initial group stage, then a 2nd group stage where the top 3 from each group go into an upper group and the bottom 3 from each go into a lower group, after this there is a triple bracket championship playoff featuring the 6 teams from the upper group and the top 2 from the lower group. Now this is fine, as a standalone single division I can make this no problem, the problem occurs when trying to add division 2; now division 2 follows the same format except for the fact that there is no championship playoffs, whoever wins the upper group is the winner of division 2. Teams move between divisions as follows: the bottom 2 teams from the lower group in div 1 are automatically relegated and the top 2 from the upper group in div 2 are automatically promoted, then there is a relegation/promotion playoff where 5-6th in div 2 upper group face off against 1-2nd in div 2 lower group, winners face 3-4th div 2 upper group teams and then the winners of that face 3-4th div 1 lower group teams with the eventual winners of that last round being in division 1 next season.
The issue I am having is that I either get 1 of 2 outcomes when trying to verify the rules, firstly, I get an error saying 2 teams relegated and 0 teams promoted error, or the editor just crashes. The way I have the two group stages set up is after the first one teams qualify for a top or bottom playoff, then in stage 2 i use this qualification to give teams either a 0 or 1 seed and use the group rule use seeding as group index, particularly for div 1 i was then able to use the individual group rules and cup tie mapping to get the championship playoffs to play how i want. I've also tried creating a sub-league table for div 2 and taking the games from both group stages into account, then doing qualification rules based on finishing in the sub-league table but this throws up the 2 relegated 0 promoted error. I also wanted to try a sub-league table that then splits after the first stage, I am able to get a sub-league table with a split working but it keeps splitting before the first game of the season.
So right now I am kinda begging for help on getting the relegation/promotion to work because i am not sure what to do at this point, also if anyone can help with the sub-league table splitting after the first group stage and not before that would be great too. I've attached the current state of the editor file, which features a basic setup for div 1 so that I could feel confident in the relegation working and then figured once I'd fine tuned and figured out the promotion from div 2 I could effectively transpose that method onto div 1 for the relegation.
2 test 3 germ.fmf
