nielsoncp

Hi Matty! It was a bit of a challenge to do the db this year, so I'm going to hold off on adding anything new until the March update I think. So for the next eightish weeks, no. Check in after that!

I haven't tried those ones specifically, but if Darth made adjustments to the Canadian Championship it probably will take out the CONCACAF championships. It's a little tough to make databases work together - hence the reason I create a master database and base everything else off of that one. So you can try and report back if it worked.

Thanks for the heads up Rob. I think I fixed it - let me know if there are still issues.

It’s time for this year’s version of the Concacaf and US databases! Because of some conversion issues this is an entirely new database that has a few key differences from the last few years, but I’m excited about this new version. US Database The top 7 levels of the us database are now split into an East and West division, with each team playing twice in division. The 8th and 9th levels have 4 divisions, and the 10th level has 8 divisions. For the top seven divisions it's split into an opening and closing season (February-May and July-October (or December in the MLS Championship.)) In June and July there are a series of tournaments, including the US Open Cup and 19 regional cups happening in June, and league level cups happening in July (The Leagues Cup between MLS championship and the Liga MX, the MLS cup for teams in MLS 1-3, the USL cup for teams in the USL leagues, and the Amateur cup for lowest level teams.) Most leagues have two promotion and relegation spots, and have between 12 and 16 teams per division. In Divisions 2-7 the winners of the stages win automatic promotion to the next league - if the same team wins both stages the next two teams in the overall table have a two game playoff. There is also a championship between the East and West overall table winners, and the top division has a 16 team playoff to determine a champion and continental cup competition slots. I also reduced the amount of money available to the us teams, so hopefully that addresses some concerns from previous years. There should be less fixture congestion than previous years (teams play between 25 and 60 games depending on how far you go in competitions.) A few notes: As you may remember, this database used to be based off of Michael Danger’s US 2030 project. This years I pulled out those teams - I figured they weren’t needed since a lot of those cities have (or will have) lower league teams, so I raised all of those up a few tiers. Most of the current USL expansion teams are present, along with the independent MLS next pro teams - so all of the usl championship teams are now in the second tier instead of the fifth. I also added the MLS expansion franchise in San Diego and kept Part of why it took so long to put out this db is that I needed to wait for extinct teams to be made playable. I kept our dearly departed San Diego Loyal and Rio Grande Valley FC. I also brought back some of the extinct teams that were in the original Raysox database (like the San Antonio Scorpions, New York Cosmos, and Atlanta Silverbacks) to round out the league. I added 10-15 players (including at least one goal keeper) to each team in levels 2-7, so you should have a decent starting group to choose from. Finally, this year’s known lower level CTD issue is as follows: In every database I’ve made there is a ctd date that impacts some lower levels. It’s a bug in the game that I can’t fix unfortunately, but you can add to the big thread found here: (Will be inserted when I'm home and have reliable internet). If we get enough critical mass they may address it. The bug this year impacts the 8th level and below and happens on the 4th Wednesday in May. If you quit your job, sim past the day, and then retake the role you will be able to play for another year. I also have it set to default start with level 7, so most people should avoid this bug. Concacaf Club Competitions I remade the CONCACAF competitions to mimic the new CONCACAF format. There are still four cups (Champions, Gold, Silver, and Bronze), but like the new format US, Mexican, and Canadian teams are immediately sent to the round of 16. The qualifiers from Latin America (20 teams, with the top 3 for most competitions except for Belize (which gets 2) and the Caribbean (42 teams, with the top 2 from the 10 best nations and the solo competition winner for the other 22) will be entered into a group stage, and the top four teams from each group will qualify for the corresponding competition. The group stages happen in the summer and knockouts happen in the fall. (This is a change for the 24.3 version) There are no coefficient points in order to maintain this structure, but each nation has at least one slot (minus Saint Pierre, because you only have three teams and are off the coast of Canada and you messed up a previous version of this db, so I and sending you into exile!) Canada (and other nations) In previous versions of this database I made a Canadian pyramid. Because of some of the vagaries of the game (including the way the Canadian Championship is coded) I decided to forego building one this year and instead modified the roster rules and money in the advanced rules for the Canadian Premier League. It’s a closed shop, but you should be able to build a more competitive team than you would otherwise for the international club cups. Similarly I changed the Mexican money and schedule to help keep them competitive. Finally, to provide a new way to do a journeyman save, I made database files for 39 of the other nations in CONCACAF. All nations have at least one slot in the Concacaf Club competitions, so you can start out at a Sint Maarten or a Belizian or a Jamaican side and work your way up the ranks. I made all of the rules in the basic mode, so some of the special rules for each division (especially the opening and closing structures of the Latin American and Haitian/Dominican leagues) are not present. It should replicate roster rules, schedule structure, and transfer windows of each nation, so it should give you a starting point for each competition. I’ve also attached a quick start so you can easily add all of the Concacaf competitions quickly. Logo and Kit Pack Like last year I made a logo pack for all of the lower league us teams, along with logos for all of the leagues and competitions added here (updated for 24.4): https://drive.google.com/file/d/1P8lXj21olEcrQRyqsO-1Wc5KTwao_t_F/view?usp=drive_link. There are now two kit packs this year - as another user on the Sort it Out SI forum (DonJohn) helped me build the kits for the lower two levels and then did the other eight levels. My version (including team lists, templates and sponsors if you want to make your own with kitbasher) can be found here: https://drive.google.com/file/d/1-HhDPp20olDFQkoZT4AiSnxWZPZ-BzIe/view while DonJohn's can be found here: https://www.mediafire.com/file/cexphgjqb6imzbg/Test+Kit+Megapack.zip/file 24.3 Updates I made a few adjustments for the 24.3 version that are listed below: - I properly activated the reserves (levels 1-4) and U19 (levels 1-7) leagues. - I added kits and stadiums for each US based team, so teams won't randomly build new stadiums after season 1. - I made some tweaks to the later stages of the July tournaments - they now run into Wednesdays in August, providing a bit more space and hopefully reducing fixture congestion a bit. - I brought the CONCACAF cup knockouts into the fall, so teams that qualify will get to play in the tournament the year after (instead of waiting two years.) - I adjusted some things to make sure the correct teams qualify for the Central American group and the Champions League knockouts. - I renamed awards that had the same name, and thus were not showing up in game. These and a few other minor cosmetic changes were made throughout the DB. I have a few bigger picture adjustments I may want to do in the future (including adding a spring super cup amongst the winners in concacaf and a formal opening/closing structure for the US database), but these are all the upgrades I'm planning for this spring. Gotta spend some time playing and not editing now. Happy Concacafing all! 24.4 Updates (4/11) The big one this time - levels 1-7 now have formal opening and closing stages. The winner of the stages win automatic promotion - if the same team wins both stages then 2nd and 3rd in the overall table have a playoff to determine who goes up. Relegation is based off of the overall table. I gave each team a modest starting budget, added managers to most teams, and added players to teams in levels 2-7, so you should have some players at an appropriate level for the league when you play a team lower down the pyramid. You will still want to check the add players box though. I made levels 1-7 playable by default because of the lower league bug. I added a lot of local media to the US database - you should have 10-15 outlets at your news conferences going forward. I registered the appropriate clubs from the US, Canada, and Mexico for the Continental Cups. I tried to add a CONCACAF Cup Winners Cup in the spring, but I couldn't get the game to set it up. So, we will call it good for this year and try again in FM 25. Club Competitions - CEUD.fmf CEUD Activated Nations.zip Mexico - CEUD.fmf Canada - CEUD.fmf Club Competitions - CEUD.fmf CEUD Quick Start - 24.3.fmf CONCACAF Club Competitions - CEUD.fmf USA - CEUD.fmf

Yeah, there are certain teams that get hardcoded because of the MLS rules - usually it's the most recent expansion teams (last year it was Inter Miami, Austin, Charlotte, and Nashville, which was a trip.) You can duplicate the team (so it has all the same characteristics) and transfer all of the contracts to the new team, then make the original St. Louis SC extinct.

(Cross-posted from the bug forum) The thing that makes it particularly confounding is that this set up does have the competitions present (use the quickstart to force load the Canadian league.) I went through and aligned the Canadian league with the other two, and it somehow broke the competition structure. Again, any help will be appreciated. Ctest.fmf Canada - CEUD - Advanced 2.fmf Concacaf Continental Competitions - CEUD ADV v2.fmf USA - Test1.fmf

The thing that makes it particularly confounding is that this set up does have the competitions present (use the quickstart to force load the Canadian league.) I went through and aligned the Canadian league with the other two, and it somehow broke the competition structure. Again, any help will be appreciated. Canada - CEUD - Advanced 2.fmf Concacaf Continental Competitions - CEUD ADV v2.fmf USA - Test1.fmf Ctest.fmf

Hi everyone. I'm trying to get the FM24 version of my expanded universe to work, but the CONCACAF competitions aren't showing up. I've tried the troubleshooting things that worked last year (MLS as inactive competition, 24 teams in the US, setting the qualification rules in modded nations) to no avail. I thought I would share it and see if anyone sees anything I am missing that could explain why they aren't showing up in game. (The thing that makes it particularly frustrating is that before the last update to the editor the continental competitions were showing up fine, so hopefully this is a user error thing I'm just missing. Thanks all!) Canada - CEUD - Advanced 2.fmf ConContComp - CEUD no group reserveremoved.fmf USA - Test1adjust2.fmf

Hi everyone. I have a problem and I'm trying to figure out if I made a mistake or if there's a bug. In my CONCACAF champions league I'm experimenting with multiple group stages before the main group. It should be set that the top team from the eight groups move to the main stage, but right now the first eight teams in the first three groups (the three in group A, three in group B, and two in group C) are moving on. That's ... not how that is supposed to work. I'm attaching the file, but below are a couple screen caps - the first is the qualification rules for the second round (where the issue is appearing) and the second is the teams setting for the main group stage. Thanks brain trust - I want to see if I screwed this up before I post it in the bug thread. Qualification in Fate Actions Teams in Group Stage Concacaf Continental Competitions - CEUD ADV v2.fmf

And when I verified in Advanced Mode (didn't make any other changes) it loaded fine. Canada - CEUD - Advanced.fmf

I am having a similar issue for my Canada DB. I just tried to load it in game and was told that I only had 15 teams, when 16 are verified in the db. It does use the defunct Edmonton CPL team, so that may be the issue. I'm attaching it for your reference and testing. Canada - CEUD.fmf

Do not, under any condition, use the US (or really CONCACAF as a whole.) I know it's probably not on your radar, but don't.

I'll second this - I tried the same things as Sangue Blu (I transported forward a db file I used last year that worked in FM 23) and when I tried to add the leagues to the cups the extinct teams were missing. It also lists a lower # of teams in the league rule sections than I assigned in the db portion. I'm attaching the db file so you can take a look - specifically you can look at the USL1 East and Western Conferences to see what I'm talking about. USA - Test1.fmf

Not that I am aware of.

Unfortunately it looks like both of the bugs you mentioned are hardcoded. I have a workaround for the CCL issue (it's in this thread: https://community.sigames.com/bugtracker/football-manager-2023-bugs-tracker/913_pre-game-and-in-game-editor/custom-usa-database-causes-nacl-to-disappear-r14514/ ), but the CTD one is a game bug that afflicts custom databases. If you quit the job and sim forward a day you can rejoin and play for another year - details are in this thread:

The short version is, I don't know, We only tested it with US leagues. It does seem to afflict other custom databases, so I think it may be a buyer beware situation. However, if you do find a date you can't sim past, quit and take the job again after the next pause. I found the US database CTDs at 9 am on the 4th monday in August (incredibly specific, I know.) There may be one in the Canadian database that I'm not aware of yet.

Hmmmm. Inter Miami is one of five MLS teams that are hardcoded, and so I need to make them manually each year. My guess is that the players didn't transfer over to their new teams in 23.4 - I may have to look deeper into it.

I'll narrow it down further - the CTD happens at 9 am on the fourth monday in my database.

As a quick note, the US files are now updated with the Messi transfer happening in July 2023.

I hit the bug on the 4th Monday in August both years. Made it out of tier 3 after that, so I don't know if it stops after that.

Ok, for now, this is the last one I'm planning to release for FM 23 - although we'll see if I find another intriguing problem to sort in the editor. I redid the CONCACAF competitions. The problem with the CONCACAF leagues (for anyone who has played) is that the gap in talent between the top and bottom (or even mid tier) teams in North America is pretty massive, so a lot of the teams outside of Canada/Mexico/The US are being blown out by the 5th or 6th year in. The new competition tree looks something like this: The shorter (and much less complex version) is that to ameliorate this I added a fourth cup (the Bronze cup) that the teams lower in the group stage of the Gold and Silver cups get dumped into, and the lower teams in the Champions League group stage face off against the 2nd place teams in the Gold and Silver cup group stages. In theory this creates winnable competition for teams from smaller leagues, so they can get the champions league money and also have a route to a cup win. There were two other tweaks that are notable and one fun thing: 1) I added a coefficient, so theoretically nations can climb and fall - so it's possible to do a build a nation and get more slots. 2) There is also now a super cup between the winners of the four competitions in July. 3) I created a rotating set of host nations and stadiums, so the finals won't be at the home stadium of the larger teams anymore. The file is below CONCACAF Continental Competitions - 4 Cups and Drop Downs.fmf

I think you would need to make the changes in advanced mode - there isn't a way to do it in Basic. Are you familiar with/have you used advanced mode before?

It probably will - I don't think the bug was addressed in the 23.5 update, and there hasn't been any mention of a fix in the forums. I did find, though, that the problem happens on the 4th Monday in August - so if you are doing a lower level save and want to use the db, quit the job on the 4th Sunday and reappoint yourself on the following Tuesday, and you're good to go for a year. Also, once you're in the 2nd tier it no longer impacts gameplay,