OBBLM league structure question

[dsavillian]

OBBLM gurus,

I'm just starting with our OBBLM installation and I'm wondering how (if I can that is) achieve the following league/division structure.


Our league will have 4 divisions
There will be 3-4 teams in each division

Each team will play some games in their division, and then some cross division games.

I'd like to have the teams grouped by division so that I can see the standings relative to the division as well as the entire league.

I'm not quite sure if this is possible, but I might not understand the League/Division/Tournament setup.

I have our league set up as follows

League
- Div A
--- Season 1
- Div B
--- Season 1
- Div C
--- Season 1
- Div D
--- Season 1

as far as I can tell, if I enter a scheduled match between a team from Div A and Div B, I have to pick which division to assign it to.


Any ideas? I'm sure what I want to do is painfully simple once I see how to do it

Thanks!


edit:

I guess to be clearer, I'd like to have a divisional set up like the MLB, NFL or NHL. Games are played in and across divisions, but standings within the division take all games into account.

[pixelgeek]

We also have another issue where the League drop-down in the Create Team page for a Coach has no Leagues in it even though we have a league with divisions assigned to it

[dsavillian]

We ended up finding the conference module tucked away in the modules folder. Enabled it, created the SQL tables and bingo!

Seems to work really well so far

[nicholasmr]

This might help http://nicholasmr.dk/obblmwiki/index.ph ... e_in_OBBLM

Nicholas.

[pixelgeek]

This might help http://nicholasmr.dk/obblmwiki/index.ph ... e_in_OBBLM

Nicholas.

We read the wiki quite a few times.

The issue appears to be that the install code for the conferences module wasn't run. Once I manaully created the tables we were good to go.

[funnyfingers]

After enabling a module, I believe upgrade.php will handle any table creation needed.

[dsavillian]

After enabling a module, I believe upgrade.php will handle any table creation needed.

We ended up figuring it out by just creating the SQL tables manually

Handy that we are both programmers

[funnyfingers]

Just letting you know how to properly do it.

[mzukerman]

Hey all, we had the module added but I'm getting "Error Adding Conference". I have admin privileges and created the league first.

Any ides?

[DoubleSkulls]

Conferences are something I added.

The structure is League - Division - Tournament - Conference, so if you don't have a tournament then you may get an error.

[mzukerman]

Conferences are something I added.

The structure is League - Division - Tournament - Conference, so if you don't have a tournament then you may get an error.

After we enabled the Conference and LeagueTables modules by setting them to "true" in the settings_modules.php file, we ran the Upgrade.php script. We selected the upgrade from 9.0 to 9.1 even though we were already at 9.1 and it said that the SQL for the Modules completed successfully. However we checked the MYSQL DB and there is no table called conference.


Is there anything else we need to enable to signal to the Upgrade.php script to create the conference related tables?

[DoubleSkulls]

Ah, I think its not linked to upgrades, but you needed to update before the initial install.

You'll need to either run it by hand or reinstall I'm afraid (if you put the new install in a new DB you could copy any content over).

Code: Select all

	return array(
        # Table name => column definitions
        'conferences' => array(
            # Column name => column definition
				'conf_id'       => $CT_cols[T_NODE_TOURNAMENT].' NOT NULL PRIMARY KEY AUTO_INCREMENT',
				'f_tour_id'       => $CT_cols[T_NODE_TOURNAMENT].' NOT NULL ',
				'name'          => $CT_cols['name'],
				'type'          => 'TINYINT UNSIGNED',
				'date_created'  => 'DATETIME',
        ),
        'conference_teams' => array(
			'f_conf_id'       => $CT_cols[T_NODE_TOURNAMENT].' NOT NULL ',
	        'f_team_id'      => $CT_cols[T_OBJ_TEAM].' NOT NULL ',
			'PRIMARY KEY'  => '(f_conf_id,f_team_id)',
        ),
    );

[mzukerman]

We'll try it. Thanks!

[mzukerman]

It looks like it works. Thank you very much!

[siggyllama]

This was really useful, thanks for posting. (And a tip for anyone trying to create the database table: if you make the 'name' row type VARCHAR (a good idea), don't forget to specify a limit (64 should work).)

Is there any way, short of coding the PHP myself, of getting the conference standings, as in the League Tables plugin, to display on the Home page?