php and mysql codes for a bowling site

Cancelled

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.

Skills: Anything Goes, Engineering, Software Architecture, Software Testing

See more: mysql bowling league, php mysql bowling script, script mysql bowling, wordpress post a job, where can i do a presentation online, what to take if you want to be engineering, what do i need to go into game design, what can you do with php and mysql, what can i do with php and mysql, what can i do for a job, website front page template design profile, website design template for message, vworker site, vworker registration, vworker job online, vworker end, user rankings, the select group, thanks for your registration, thanks for registration, statistics rankings, statistics archive, statistics architecture, software for wordpress design, simple mobile number change

About the Employer:
( 4 reviews ) Qatar

Project ID: #3327567

9 freelancers are bidding on average $98 for this job

grupociberia

See private message.

$212.5 USD in 21 days
(95 Reviews)
5.9
indsoftexpertvw

See private message.

$76.5 USD in 21 days
(32 Reviews)
4.9
vipinkumarsl

See private message.

$127.5 USD in 21 days
(8 Reviews)
4.1
byte2osoftw

See private message.

$50 USD in 21 days
(3 Reviews)
0.6
dmwsoftware

See private message.

$80.75 USD in 21 days
(5 Reviews)
0.3
alienwebsoft

See private message.

$170 USD in 21 days
(0 Reviews)
0.0
fariha1

See private message.

$84.15 USD in 21 days
(0 Reviews)
0.2
pahulvw

See private message.

$68 USD in 21 days
(0 Reviews)
0.0
anasalzghoul

See private message.

$17 USD in 21 days
(1 Review)
0.0