Joomla 1.5 Plugin/module
I need an installable native 1.5 Plugin/Extensions/Module that will duplicate the db functionality of these sites:
http://www.wevavolleyball.org
http://www.ovr.org
I will create the Joomla site that will use the plugin I want the developer to create.
Because only the frontend of the DB is visible on those sites, the developer will need to design and create the the pages that cannot be seen. For the most part those pages are the data input and display for the admins that will input the club, team, tournament, referee, contact and facility info. I am available for help on the design and what data is needed.
I am creating a similar site to http://www.wevavolleyball.org and http://www.ovr.org, and need to duplicate the functionality of the pages below. The links are from both sites, so they are not identical in functionality to each other, but close enough for the developer to understand what I am looking for.
Club signup page:
http://www.wevavolleyball.org/J-Club-F.asp
Club update page for club admins (Only their club info, not others), teams, tryouts, and tournaments:
http://www.wevavolleyball.org/J-Club-U.asp
Displayed club info:
http://www.wevavolleyball.org/J-Club-D.asp?Id=2
http://www.wevavolleyball.org/A-Club-D.asp?id=1
http://www.ovr.org/dir/club.php?club_id=534
Clubs displayed as list:
http://www.wevavolleyball.org/J-Club-O.asp
http://www.wevavolleyball.org/J-Club-B.asp
http://www.wevavolleyball.org/A-Club-O.asp
Club Search:
http://www.ovr.org/dir/club.php
Club Tryouts:
http://www.wevavolleyball.org/J-Try-O.asp
Team Page:
http://www.ovr.org/dir/team.php?id=2299
Team Seeding Page (The ranking and seeding is currently generated using a spreadsheet, which I will provide):
http://www.ovr.org/juniors/seeding.php
http://www.ovr.org/juniors/seeding.php?div=GAll
Referees Page (Permission Controlled Updating):
http://www.wevavolleyball.org/O-Refs-O.asp
Tournament Schedule (tournament name should be a link):
http://www.wevavolleyball.org/J-Tour-O.asp
http://www.wevavolleyball.org/A-Tour-O.asp
http://www.ovr.org/juniors/tournaments.php
Tournament info page:
http://www.ovr.org/juniors/jt_info.php?id=20090132
Completed Tournaments (tournament name should be a link):
http://www.wevavolleyball.org/J-Tour-C.asp
http://www.wevavolleyball.org/A-Result-O.asp
Tournament Results Search:
http://www.ovr.org/juniors/results.php
http://www.ovr.org/juniors/results.php?origin=*&date=*&site=*&td=*&division=*
Tournament Directors/Organizers page to add/edit tournaments and info:
http://www.wevavolleyball.org/J-Tour-D.asp
http://www.wevavolleyball.org/A-Tour-D.asp
Tournament Site Page:
http://www.ovr.org/sites/sites.php
http://www.ovr.org/sites/sites.php?id=AdenaHS
Team Standings:
http://www.ovr.org/adults/mstandings.php
http://www.ovr.org/adults/wstandings.php
Admin Staff:
http://www.wevavolleyball.org/G-Admin-O.asp
Search module for Boys/Girls/Adult Club search (top of page):
http://www.wevavolleyball.org/index.asp
Player/Team Connections:
http://www.ovr.org/connections/players.php
http://www.ovr.org/connections/teams.php
Season Archiving:
http://www.ovr.org/archives/2008/index.php
We need to be able separate playing seasons from each other. The teams are setup as age groups, and each year, the clubs needs to be able to create all new teams, even though the teams may have the same name, the team in 2009 is different from the team in 2010. At start of the new season, we need to be able to start over with new teams, tournaments, seeding and ranking for that new season.
I think the easiest way to do separate seasons is to have an admin option that lets the admin (me) start a new season by changing a season variable setting to the next season. All teams and tournaments created after this would be created for the new season. Clubs should be able to start with all of the same team names and players as the previous season, but until they update, they would not be able to associate with an Event in the new season because the SEASON_CODE variable won’t match. This would also make it so that we can have an option on the site to see previous season’s results.
Obviously, the views showing data for the season needs to filter via the SEASON_CODE variable set by the admin. To view a previous season’s info, the user would choose a season from a dropdown, and the table would show whichever season is chosen by the user, instead of the variable set by the admin.
I did a quick write up of the data fields so that I could show relationships and the data that is needed. I am not a DB admin, so do not rely on this for creating the database. I am certain that there will be more tables and data fields than I have listed.
CLUB
TEAM
FACILITY
CONTACTS
EVENT
CLUB
CLUB_CODE
CLUB_NAME
CLUB_REP
CLUB_WEBSITE
CONTACT_CODE
FACILITY_CODE
TEAM
TEAM_CODE
TEAM_NAME
TEAM_TYPE
CLUB_CODE
CONTACT_CODE
FACILITY
FACILITY_CODE
FACILITY_NAME
FACILITY_ADDRESS
FACILITY_PHONE
FACILITY_WEBSITE
CONTACT_CODE
CONTACT
CONTACT_CODE
CONTACT_NAME
CONTACT_PHONE
CONTACT_EMAIL
CONTACT_REGISTRATION_NUMBER
CONTACT_REGISTRATION_YEAR
CONTACT_BACKGROUND
CONTACT_CERTIFICATIONS
CONTACT_ROLE
EVENT
EVENT_CODE
EVENT_NAME
EVENT_DIVISION
EVENT_DATE
EVENT_HOST
EVENT_DIRECTOR
EVENT_FEE
EVENT_INFORMATION
CONTACT_CODE
FACILITY_CODE
POOL
POOL_CODE
POOL_DIVISIONS
POOL_COURTS
POOL_TEAMS
TEAM_CODE
EVENT_CODE
RESULTS
RESULTS_PLACE
RESULTS_POINTS
RESULTS_FINISH
TEAM_CODE
EVENT_CODE


