BOTSC Website Management Routines
Display Data from the Database
101 - Registration Receipts
102 - Member / Email Lists
103 - Photo Lists
104 - Team Lists by Division
105 - Send Team List to Convenors
106 - Team Lists for Team Photos
107 - Division Teams Summary
108 - Team Uniforms Size Summary
109 - Spare Board
110 - Team Names, Colors and Convenors
111 - Team Grade and Age Summary
112 - By the Numbers
Updating The Database
200 - Delete Member Profiles
201 - View or Update Member Profiles
202 - New Club Applicants
203 - Waiting List Changes
204 - Make Back Up Copies of Selected Tables
205 - Make Changes to the
teams
Table
206 - Make Changes to the
season
Table
207 - Make Changes to the
executive
Table
208 - Make Changes to the
sponsors
Table
210 - Make Changes to the
recognition
Table
211 - Make Changes to the
misc_photos
Table
Prepare for Registration and the Draft
301 - Roll the Data in the
members
Table
303 - Status of Returning Players
304 - Players Eligible for Registration
305 - Returning Players Not Registered
306 - Registered Players Not Paid
306r - Review / Edit Comments and Notes
307 - List of Players by Grade for the Draft
308 - Photo List of Players for the Draft
309 - Prepare List of Players for the Draft
310 - Do The Draft (but run
309
first)
311 - Draft Results
312 - View the Draft Remotely
Send Email to Club Members
401 - Send Bulk Emails to Club Members
402 - Send Emails using Custom SQL
Registration
501 - Player Resignation
502 - Send Registration Invite to Wait List
503 - Select, Crop and Upload Member Photos
Other
Edit Banquet Attendance List
Edit International Games Team Lists
Upload Photos from Members
Attendance • Schedules • Results
601 - Update Grade and Attendance by Team
601s - Send 601 to team Convenors
602 - Make Changes to Grade by Division
605 - Games Schedule
607 - Standings
Events • Message Board • Minutes
701 - Upcoming Events
702 - Message Board
703 - Make changes to Event Attendance Lists
704 - Notewworthy Moments
705 - Select, Crop and Upload an Event Image
707 - Upload Executive Meeting Minutes
708 - Make Changes to the
minutes
table
709 - Make Changes to the
holidays
table
Referee Reports
901 - Complete and Submit Referee Reports
902 - Edit List of Referees
903 - Make Changes to Card Conduct List
904 - Add Action Taken to Cards Issued
905 - Graph of Cards Issued
906 - Cards Issued
Web Portal
000 - easyhosting Portal