I am working on rebuilding the propietary website from a baseball club which is now builded with php/html and based on some own made MySql Tables.
www.redcaps.nl

In these tables there are Members of the club, Teams, Competion Games linked to the Team Roles (in which team a member belongs and is he player, Coach, or Trainer)

At the start of each season I rebuild this tables with querys I've made from within an Excel sheet and using PhpMyAdmin to fill this tables. During the season I add/update records when the competion scheme changes (also with PhpMyAdmin), not very handsome, but I never took the time to make forms or procedures for it.

I'd like to Change this all to the drupal way of doing this.
I saw there are modules for a sport club, but they are not very up to date (most of them are for drupal 6.x)

Question:
Can i use content-types and views to get this content in the site ?, Or do I have to make my own modules for handling this, or is there a good up to date sports club module (I didn't find one) for free ofcourse this is all volunteers work.

Comments

WorldFallz’s picture

It's been a while since I surveyed the sports club modules, but I think they're always a bit under maintained (none of them have a d7 version yet i don't think which is a bad sign) because you can pretty much do this with content types, views, and entityreference. I would probably consider using og for the 'teams', then build on from there.

EDIT:
looks like https://drupal.org/project/tourney might be useful for a piece of functionality also.

BertVivie’s picture

Hi WordlFallz,
What do you mean with :
I would probably consider using og for the 'teams', then build on from there.
Especialy with og ?

WorldFallz’s picture

Sorry... I'm not sure i understand what you're asking...

BertVivie’s picture

Question is what do you mean with the word og (sorry but english is not my native language I am Dutch)

WorldFallz’s picture

ahhh... ok... no apologies necessary. it easy to forget not everyone is familiar with drupalisms,lol. I meant: http://drupal.org/project/og. I would make each team a 'group'.