1 / 12

Future Legends of Poker

Future Legends of Poker. New League Score Sheet Functionality. Manager Logs Into Front End. Manager Logs Into Front End.

leal
Download Presentation

Future Legends of Poker

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Future Legends of Poker New League Score Sheet Functionality

  2. Manager Logs Into Front End

  3. Manager Logs Into Front End Manager is then presented with the existing Manager Menu. This menu currently contains one item for creating newsletters and mass email through the front end. There will be a new menu item added here called New Score Sheet.

  4. League Manager Starts a New Score Sheet at the Beginning of the Night Season and Venue are dropdown boxes pre-populated from new tables called cb_venue using Name column and cb_season using SeasonNo column. Submit button pressed after all games are completed and scored. Re-authentication is required. League Manager logs into the website and selects New Score Sheet from the Manager’s Menu (already programmed into the site). This page is then locked and can only be exited by the Manager pressing the Submit button at the bottom.

  5. Players Arrive and Sign Up for Game 1 A dropdown box is provided for Player which has been pre-populated from cb_user table using the Name column. Pos value changes from blank to 0 when the Player name is no longer blank.

  6. Game 1 in ProgressGame 2 Players Signing Up As Game 1 is played players are eliminated and they enter their final table positions from the game (1-11) using the Pos dropdown. These players, as well as anybody who has arrived in time can sign up for Game 2 using the Player dropdown as before. When there are enough players for Game 2 that new game begins playing while Game 1 continues until completion.

  7. Game 1 Complete, Game 2 Proceeding and Players Signing up for Game 3 As before players are eliminated from Game 2 and they enter their final table positions from that game and sign up for Game 3 while Game 2 continues until completion.

  8. All Games CompleteSubmit Score Sheet At the end of the evening after all games are completed and all final scores have been entered the Manager clicks the Submit button to calculate points and store the result in the CB profile.

  9. All Games CompleteSubmit Score Sheet Before beginning the calculating process the user is required to re-authenticate to avoid unwanted/accidental closure of the sheet.

  10. Score Calculation and Storing Points are calculated using a player’s final Position. Refer to the following table:

  11. Score Calculation and Storing Once calculated each players score for each game must be stored as an individual record in a table. There will need to be 2 new tables to hold all these scores: cb_SheetHeadercb_SheetDetail - UniqueID - UniqueID - Venue - SheetHeaderID (Foreign Key from cb_SheetHeader/UniqueID) - GameDate - GameNo (1, 2 or 3) - Season - PlayerID (from cb_user/cb_PlayerID) - Position (0-11 from Score Sheet) - Points (calculated using table on previous page) - TOCPoints (calculated using table on previous page) The scores are the aggregated ( SUM() )for each player for the Season (from Score Sheet) and stored in each players CB Profile. Custom CB fields already exist and are currently being used by CB to display League Scores, TOC Points, Season Championship Standing and Championship Chip Stacks. These fields must be retained and populated by the new process.

  12. Score Calculation and Storing Table positions are also counted and stored in custom CB fields: cb_1st = How many times a player made 1st place during the season cb_2nd = How many times a player made 2nd place during the season cb_3rd = How many times a player made 3rd place during the season cb_4th = How many times a player made 4th place during the season cb_5th = How many times a player made 5th place during the season cb_6th = How many times a player made 6th place during the season cb_7th = How many times a player made 7th place during the season cb_8th = How many times a player made 8th place during the season cb_9th = How many times a player made 9th place during the season cb_10th = How many times a player made 10th place during the season cb_11th = How many times a player made 11th place during the season cb_totalfinaltables = SUM() of all the above values except cb_11th

More Related