I've tried fumbling around with drupal for 4 weeks now and have been searching the forum, and maybe I'm missing something but I cannot figure out how to accomplish what I want to do.
Here's the scenario:
I want to make a database of all the sports teams in a highschool (past and present). I would like to have the different sports listed (football, track, wintertrack) for the different years (05, 06, 07) and inlcude who the coaches are, who the players are, and what position each student played. I have the heirarchal taxonomy for Season (Spring, Winter, Fall) -> and then sport type (X-Contry is only listed for fall). Things like photos, videos, I already have a handle on using views and taxonomy.
I would like to be able to go to a students page to view the positions he/she's played and on what team.
Also go to a team page and view the list of students and what position they played.
Here are the issues:
1. When adding a new team I can't figure out how to add a list of students and the postions they played in a way so that if I wanted to, I could also add a student from the past to the database and list the teams they were on and what position the played. People and Teams are node types but is there a way so that positions don't have to be node types?
2. People can be added to the database as node types but I want students to create an account and people able to attach themselves to the node that is themself.
Does this make sense?
Comments
If i understand you
If i understand you right:
what if teams and position were taxomony terms. then you create a team or player node and select a taxomony for that node.
So if you create a player node for 'John Smith', and asign him the taxomony terms 'Southend United for Boys' and 'Benfleet Rovers'. You could list these terms (or teams) on his user profile. Also within the teams nodes, you could list players, filted by taxomony > term == southend united for boys and benfleet rovers.
if i understand you right... ;-)
I hope that helps a bit.
Realworks Media Website Design
Realworks Media Website Design
Almost, but not quite
Thanks Fiasst,
I apprecuiate the response but one key element was the position John Smith Played on the team. My issue is assigning a player (node) to a team (node) AND at the same time their Position.
Example:
If i'm creating the Norwell Clippers Football Team
I want to add Joe Brown (nodereference?), but also list him as a Quarterback so that when I the view the team it will say
Joe Brown................Quarterback - 07
but also if I view Joe Brown it will show
Norwell Clippers - Football - 07 - Quarterback
use CCK and node reference
I think using CCK and the nodereference module might be easier and should be quite abit more flexible.
I'm with you biohabit but....
I've been trying to play with nodereference and currently have teams and players as seperate nodetypes. Here's what I've run into:
I'm not just referencing a player when linking it to a node, but that player also has a position. Same thing if referencing teams to a player page, I also need to reference the positon.
So should each "position" be a seperate nodetype?
I suppose I could create a nodetype "position", then Add New Position and have the Title be "Shortstop", then reference sport-type "Baseball" , and reference player "Joe Schmoe" as well as a year taxonomy.
Does this make sense to anyone? Would this be the way to go?
You have a number of pieces of information
You a have person/student, a team and a player.
Teams have players and players belong to a team
A team has a sports type.
A player is a student that played for a given team in a given year.
So what about making a player a content type that is
So the player content type basically forms a linkage between a student and a team in a given year.
At that point it is a matter of code (views may help here) that given a player, finds which teams they played on (as well as year and position). Going the other way, given a team and a year you can find the people and their postions.
Part of the key here is to have students and players be two different content types.
If you want people to be able to register I would start by making everyone a Drupal user, use node profile and that way they are attached when the account is created.
I am working on the same
I am working on the same type of thing - and I am a raw beginner. Browsing through the modules I found
OG Teampage
which looks like does a lot of what you and I are trying to do - but I so far don't have the understanding to implement it. Have you checked it out?
I have a couple months to learn what I'm doing, but this will be a major part of my site.
Learner ;)