php and mysql codes for a bowling site

I have a bowling club site that i need custom php and mysql scripts This is the scenario: 1 - The club runs a game series (called leagues) that spans roughly 37 to 40 weeks per year (variable/flexible). 2 - The main game series starts and played every friday of the month (called "friday league" and exclusive to members only). 3 - within every friday league game, members can opt to form a separate league called (TWTL - short for tournament within the league and is not included in the overall game series of 37 to 40 weeks per year). 4 - They also have a game on every wednesday of the month called "wednesday league" and is included/calculated in the overall game series (spanning 37 to 40 weeks per year). 5 - occationally, the club runs a special leagu called "masters league" and "fun game". note: 1 - the php script should be flexible to cater unlimited member of registrations. 2- php registration and login form should be secure from common hacks. 3 - officers should have the ability to CRUD members, CRUD leagues, CRUD group teams, CRUD scores. 4 - mysql tables should generate game series, group team and individial standings. 5 - bowlers/members are categorized as "class A", "class B", "class C" so the mysql table should generate a roster, classification, stats/standings page. what i expect: 1 - I am not interested in website design/template and/or presentations (html/css). 2 - a simple website/pages showing how the codes is applied is fine with me. 3 - to save time, you can do a basic html/css (up to you) or if youre comfortable creating it as a plugin/widget for wordpress/joomla is up to you and ok for me. 4 - generaly, I am only interested on how the above description can be custom coded in php/mysql. kindly post a msg if the above desription is not clear. thanks and happy bidding. ## Deliverables * * *This broadcast message was sent to all bidders on Saturday May 21, 2011 3:46:44 AM: Hi guys, thanks for bidding. To clear out things, I will outline what i expect from a bowling site in different cases: first, as a member/bowler who wants to register: 1 - I go to site, register there and wait for confirmation/approval in my email. 2 - minutes after i register, I received a confirmation regarding my registration and wait for aproval. 3 - after a while, I receive again a mail from officer/site admin regarding the outcome of my registration whether i got approved or rejected with reason why i got rejected and a link to login if i got approved. 4- - if my registration/application was approved, i click the link where i can log in as registered member. second, as an officer in charge of member approval. 1 - when im not online, I should receive a notification via email and mobile (sms) that a new user has registered in the site and waiting for approval. 2- I then logs in to secure admin page, and see the lists of members waiting for approval. I should be able to approve or reject applicants. 3 - i check the front-end of the site and the member i approved should in the memberlists page that can be searched/sorted by either registration date, date approved, classification (class A, B or C), birthday, username, firstname, lastname etc. third, as an officer in charge of administering the game series. 1 - I should be able to create, read, update and delete "league categories". I should expect a form where: a - I can type a location address where the bowling game should be held. b - I can type lane number where the bowler will perform the current game (ex. lane no.1, 2 3, etc) c - I can choose a unique league name (ex. friday league, wednesday league etc) that can become a dropdown list once i created a group. 2 - after creating the league category, I should be able to create, read, update and delete "group teams" out of the total registered members. I should expect a form where: a - I can choose to type a unique group name( ex. fred's group or boys next door group etc). b - I can choose from the drop down list of all the league categories available and select it to associate it the corresponding group that i will be creating. c - members already associated in the group cannot be associated in other group i will be creating until all members are in within the group. d - a timestamped date on when the group/team was created. fourth, as a score keeper, I will be able to create, read, update and delete scores based on the group that was created. I should expect a page where: 1 - I can see a page where all the available league categories with corresponding groups and its members in a simple css formatted (table). 2 - I can only edit the scores field for each of the members inside the simple css formatted (table). 3 - the simple css formatted (table) columns/rows should have: a - league category (row header) b - group name (1st column) c - bowler/member name (2nd column) d - handicap (3rd column) (drop-down list from 1 - 300 only) e - game1 score column. (4th column and has a drop-down list from 1 - 300 only) f - game2 score column. (5th column and has a drop-down list from 1 - 300 only) g - game3 score column. (6th column and has a drop-down list from 1 - 300 only) h - game1 + handicap score (7thcolumn - automatically computed based on the handicap and games 1 score). i - game2 + handicap score (8th column - automatically computed based on the handicap and games 2 score). j - game3 + handicap score (9th column - automatically computed based on the handicap and games 3 score). k - total for games 1, 2 and 3 called game series (10th column - automatically computed based on the handicap and 3-games scores). l - averages for game1, 2 and 3. (11th column - automatically computed based on the 3-games scores). n - averages for game1, 2 and 3 plus handicap. (12th column - automatically computed based on the handicap and 3-games scores). 4 - so really only the handicap and 3-games (1, 2 3) needs CRUD operation for the score keepers task. fifth - as registered member, I should see a page where: 1 - i can see my statistics like: a - my individual scores for the current and past games. b - my group scores for the current and past leagues. c - my stats and rankings against other members. 2 - i can change basic setting in my profile page such as password, etc. 3 - an archive of past leagues that can be sorted by year or by league category for current and past events. - so this is more or less the very basic that i need. - i will take care of the presentation and formatting of the pages. - i just need the very basic page where the codes will take into action. - just concentrate on the php/mysql side of things. - it must be very well commented out so i can edit it as necessary without going back to bug you in future. i hope this clear things out. bidders who can show me a quick mockup of the above details will likely be considered to start asap. if for some reason you dont have a webhost to temporary host your mockup, tell me and i will provide you with details on how you can ftp the sample mockup. I am also a vworker so dont worry that i will stole your mockup because i dont want to ruin my reputation and compromise my account/job upportunities here in vworker for just this one-time project. once again, thanks and happy bidding.