6. Admin Dash Panel 1

[A] Details: Change the order of group pairings, players, or group.

Link to Admin Panel 1 which allow changes to the Order Of: Pairings / Player / GROUPS.

Golf Schedule Setup – 4 Step Process

🔹 Step 1 : Clear Existing Playlist
Delete all previous player pairings and playlist to begin a fresh round. This step must be repeated for each new event.Set up the event details, including date, time, and shotgun start settings. Finalize the full schedule setup under Admin Setup before players are assigned.

🔹 Step 1.1 [B]Details: Schedule & Shotgun Settings
Set up the event details, including date, time, and shotgun start settings. Finalize the full schedule setup under Admin Setup before players are assigned.

🔹 Step 2:
START PLAY/RESET ROUND ( Rebuild Groups/Pairings):

Clear Playlist Table from last round and player sign-up reloaded to Playlist.
Random Process started using reloaded playlist.
Groups/Pairings created and all players are paired into a group. Groups and Players can be changed (see step 3).
Redirect at completion of step 2, you will be redirected to ADD Player's page all players are paired into a group. Groups and Players can be changed (see step 3).

🔹Walk-on(optional):
Access the full list of members:

Add players to the playlist
Select multiple players at once
Remove players from the playlist as needed

🔹 Step 4:Unlock/Lock
Toggle buttons to unlock the scoring page to begin recording each player strokes for the scheduled 18 hole round. When the "RED/Lock" is green, the score keeper is allow to advance to recording process.

File Handling (Importing / Exporting )* **The administrator uses the GSKV3 templates provided to import data needed to create player reports and stats(See figure above).

• Download All Player Scores* **Export final scores for all players at the end of the round.*

• Upload Player Handicaps** *Import handicaps using the GSKV3 Excel template.*

• Download Player Group Assignments ** *Get a list of players and their assigned groups.*

• Download PDF Pairings for Golf Course** *Generate a printable PDF of group pairings for course staff.*

• Upload Schedule from Excel** *Import a full event schedule using the GSKV3 format.*

• Upload Player Stats History** *Import historical player stats from a GSKV3 Excel template. Contact GSKV3 for the file.

Admin Additional Controls

END ROUND (Admin Reset & Reload)
Used after correcting any scorekeeper's card. Clears all End Round data and reloads the latest scores for every group.
Deleting Groups
Link to select a group to clear its entire scorecard. Scores must be re-entered manually.
Review Pairings
Link to preview current pairings for all groups. Admin may repeat Step 2 (pairing setup) if needed.
Golf Contacts
Link to view saved contact information for the assigned golf course.
Tee Box (Admin)
Link to manage all groups: view pairings, remove players, edit scores, and review scorecards or the leader board.
[C] Details: Edit Member
Link to add new members, new organizations, business logos, activate/deactivate members, update player information such as name, contact, or handicap.
Shotgun Setup
Set holes and start time for shotgun play.
PLAYLIST
View players signed up to play.
Remove Playlist
Remove all players from all groups.
Link to Remove Schedule
Open manual scheduling to remove or add new schedules.

ADMIN DASH PANEL-2

Swap Groups
Switch all players between two group numbers.
Move Player
Move an individual player to a different group.
Add Walk-on Player
Add a guest or new player to any group.
Delete Player
Remove a player from the current playlist and group.
Delete Playlist
Clear all players from the playlist without deleting sign-ups.
View Groups
View all players grouped by current group number.

Manage Player SignUp

This page allows administrators to manage the player sign-up list for the currently active event. The active event is determined by the most recent schedule created for your organization.

The event details shown at the top of the page (Course, Date, Green Fee, and Tee Time) come directly from the finalized schedule. If the displayed event is incorrect, return to Admin Scheduling and select or finalize the correct schedule.

Event Information Panel

The Event Information section displays read-only details for the active event: Course name, event date, green fee, and start time. These values confirm that players are being added to the correct event.

Dashboard Navigation

The dashboard buttons provide quick access to additional administrative tools. DASH PANEL 1 returns you to the main pairing and setup area. DASH PANEL 2 locks the signup list and prevents further changes once signup's are finalized.

Add a Guest or New Player

If a player does not already exist in your organization, use the Edit Member button to add a new player or guest. Newly created players will automatically become available in the signup list.

If the signup list was accidentally deleted, the system maintains a temporary backup. Clicking Restore Last Known Playlist will overwrite the current signup list with the most recent backup (stored for up to five days). Use this feature with caution.

Adding Players to the Playlist

The player selection area displays all active players associated with your organization. You may select one or multiple players at the same time.

Use the search box to quickly filter players by typing part of their name. The list updates instantly as you type.

After selecting players, click Add Selected Players to add them to the current event’s playlist. Duplicate signup are automatically prevented.

Removing Players

Signed-up players appear in the lower section of the page. To remove a single player, click the name with the “✖” icon and confirm the action.

To completely clear the signup list for this event, use the Remove All Players button. A confirmation prompt will appear before deletion.

Important Notes

All changes on this page apply only to the currently active schedule. Player signup's are tracked by Client ID, Schedule ID, and Player ID to ensure data integrity across multiple organizations.

Once signup's are locked, no further additions or removals can be made unless the event is unlocked by an administrator.

Scorecard Approval

This section is available only to users with Admin or Super Admin access. It allows you to review, approve, and manage player-submitted scorecards before they become final.

Scorecards listed in the Pending Approval section have been submitted by players and include a required witness name. These scorecards are considered provisional until reviewed and approved by an administrator.

Each pending scorecard displays the player name, date played, course, tee selection, front nine total, back nine total, and overall gross score. This information is provided to help verify accuracy before approval.

If a scorecard appears incorrect, administrators may edit the score using the dedicated edit page before approval. Editing is only permitted while the scorecard is pending and has not yet been approved.

Approving a scorecard finalizes the entry. Approval removes the witness restriction, locks the scorecard from player access, and prevents further edits or deletions by the player. Approved scorecards are considered official and should only be changed by authorized administrative action.

Administrators may remove a scorecard prior to approval if it was submitted in error. Removal is handled as a soft delete, preserving the record for audit purposes while preventing it from appearing in player or admin listings.

Only scorecards submitted through the official player scorecard entry page are eligible for approval. Scorecards entered through administrative tools or imports may follow separate validation rules.

If a scorecard requires correction after approval, contact a Super Admin to determine whether an administrative override is necessary.

All scorecard actions are logged and associated with the current client and player for auditing and reporting purposes.

4.1 Record/Correcting Score Card (Admin)

"The Admin's Record form is typically used after all scores have been entered and the 'End Round' button has been clicked. It allows reviewing and updating group scores hole-by-hole, using the current course, round, and schedule. Player validation, par values, and hole navigation are handled automatically."

Before recording scores: Admin can hind any player on score card by clicking red "Remove" button.

1. Record / Correcting Scores:
Select a group to correct scores. Each group includes multiple players assigned to this round.

2. Hole Number Display / Selector On hole navigation buttons or labels:
Current hole being scored. Use Next/Previous to switch holes.

3. Stroke Input Field Applied to each player's strokes input box:
Enter strokes taken by this player on the current hole. All scores default to zero. Click + to enter hole's "PAR" number. After "PAR" number is entered, use + or - to Increase/decrease strokes by 1.

4. Mark Score / Save Score Button : Save scores for all players in the selected group for the current hole.

5. After all players and groups have been updated, you must return to Admin Panel 1 and select "Master End Round". This will make all updated group scores available for excel download' stats for history, and post scores.

5. Setting Up A Golf Schedule Manually

(Step 1) Setup Schedules

This page controls event scheduling, tee times, rules, and round setup for your golf organization. Only administrators can access these tools.

Important Rules

Only ONE schedule can be active in the Setup table at any time. Saving a new schedule deletes ALL scores from the previous round. Excel uploads are stored separately and can be reused with Optional Auto Fill.

Option 1 – Upload Schedules from Excel (Recommended)

Optional Auto Fill

Save Schedule

Tip: Excel uploads are not automatically active — you must select and save one.

Option 2 – Manual Schedule Setup

-- New --

First Tee Time

Save Schedule

Shotgun time will override tee times when editing the active schedule.

Editing an Active Schedule

You must save a schedule before it can be edited. Use the Edit Active Schedule button to adjust:

Tee times Shotgun hole assignments Rules and notes Event date

Removing Schedules

Remove (Single) deletes only the active Setup schedule. Clear Schedule deletes ALL uploaded Excel schedules. Clearing schedules cannot be undone.

(Step 2) Admin Dash Panel 1

After saving the schedule, click Admin Dash Panel 1. Once all players have signed up to play or you manually enter all players (Add Player in walk-on section), Click START PLAY to run random picks to group players.

Important : Only one schedule is active. To setup mulitple schedule, repeat filling out the form for each new schedule, and save. Remember to re-select the active schedule for player sign-up. If players signup for the wrong schedule, select the preferred active schedule from the dropdown (DO NOT CLICK REMOVE). Then goto Admin Dash Panel 1 inside the "Walk-On" box, click restore last known signup list. Now , all players are re-assigned to correct active schedule.

TIP: if your group of players remain the same for each event, use "restore last known signup list" as a single key stroke to load players.

Admin / Player View

Admin must switch to Player View to sign up or enter scores. You must log back in as Admin to return to this page. If linked player access is missing, player features may be unavailable.

Need help? Always upload schedules first when possible — it reduces errors and keeps events consistent.

5.1 Upload An Excel SpreadSheet Golf Schedule

The GSKV3 gives you the ability to upload many prepared schedules from an excel worksheet.

GSKV3 should have provided a Golf Schedule template in your management package. Fill out a complete event schedule for 2-weeks or 52-weeks. Once you've uploaded your spread sheet, select any of the preloaded schedules and then click “Finalize” (See step-by-step figure). Do not make any modification to the red shaded areas in the templates. The red shaded areas are your organizational codes and if altered, your data will not be retrievable by normal operating processes. Contact us for additional help via your text message at our support number 8329382347(Include Player ID. Your Golf Organization and phone number on file must match.) .

5.2 Active Golf Schedule

Before any tournament start, a schedule must be activated (appears inside the active schedule box) in order create random groups. The schedules are Uploaded or manually entered (see section 5.1). Only the active highlighted schedule can be edited (rules, tee times, rounds information, option shotgun time and optional shotgun holes). This section is not visible until at least one schedule has been finalized. The update for the optional shotgun entries are posted on the pairings page, and can only be review after the pairings process has been completed.

5.2.1 Editing The Active Schedule Event

This page allows Admin and Super Admin to manage scheduled golf events for your organization.

🔹 Upload or Select a Schedule

Upload schedules using the official GSKV Excel template (recommended).
Only one schedule can be active at a time.
The active schedule is highlighted and shown at the top of this page.

🔹 Step 2: Edit Event Details

Event Date – Change the event date if needed.
Shotgun Start Time – Sets a shotgun start for all groups.
Tee Times – Enter a starting tee time and interval to auto-populate times.
Round ID / Round Name – Used for scoring, stats, and reports.

⚠️ Note: Entering a Shotgun Start will override individual tee times.

🔹 Step 3: Rules & Policies

View / Edit Policy – Organization-wide rules.
View / Edit Round Rules – Rules specific to this event.
Only admin can edit rules. Changes are saved immediately.

🔹 Step 4: Shotgun Hole Assignments

Assign starting holes for each group (Gp1–Gp18).
These determine where each group begins during a shotgun start.
Click Update Hole Assignments to save.

🔹 Removing a Schedule

Select the schedule you want to remove.
Click Remove and confirm.
This permanently removes the schedule from the active setup.

✔ Changes only affect the currently active schedule. ✔ Always confirm updates before leaving the page.

5.2.2 Shotgun start-time and Group starting holes

🔹 Edit Event Details

Event Date – Change the event date if needed.
Shotgun Start Time – Sets a shotgun start for all groups.
Tee Times – Enter a starting tee time and interval to auto-populate times.
Round ID / Round Name – Used for scoring, stats, and reports.

⚠️ Note: Entering a Shotgun Start will override individual tee times.

🔹 Rules & Policies

View / Edit Policy – Organization-wide rules.
View / Edit Round Rules – Rules specific to this event.
Only admin can edit rules. Changes are saved immediately.

🔹 Shotgun Hole Assignments

Assign starting holes for each group (Gp1–Gp18).
These determine where each group begins during a shotgun start.
Click Update Hole Assignments to save.

🔹 Removing a Schedule

Select the schedule you want to remove.
Click Remove and confirm.
This permanently removes the schedule from the active setup.

✔ Changes only affect the currently active schedule. ✔ Always confirm updates before leaving the page.

File Handling (Importing / Exporting )* **The administrator uses the GSKV3 templates provided to import data needed to create player reports and stats(See figure above).

• Download All Player Scores* **Export final scores for all players at the end of the round.*

• Upload Player Handicaps** *Import handicaps using the GSKV3 Excel template.*

• Download Player Group Assignments ** *Get a list of players and their assigned groups.*

• Download PDF Pairings for Golf Course** *Generate a printable PDF of group pairings for course staff.*

• Upload Schedule from Excel** *Import a full event schedule using the GSKV3 format.*

• Upload Player Stats History** *Import historical player stats from a GSKV3 Excel template. Contact GSKV3 for the file.

Quick Play Schedule

Purpose:
This page allows Admin users to:

Create or Reset an Event Schedule
Select Players
Assign Players to Groups (1–21)
Lock / Unlock Group Entry
Start Tournament Play
Set Tee Times

1️⃣ Access Control

You must be logged in as Admin, Super Admin, or Player.
If access is denied, re-login properly.
Admin switching to player mode uses linked player logic automatically.

2️⃣ Reset Schedule (⚠️ Permanent Action)

Clicking Reset Schedule will permanently delete:

All player assignments
All group pairings
All event scores
Advance signup list
The current active schedule

NOTE: The Reset Schedule action CANNOT be undone. Use Reset when:

You need to completely rebuild the tournament
You selected the wrong course
You want to reorganize all players

3️⃣ Event Schedule Setup

Complete the following fields:

Event Date (required)
Golf Course

If the course does not exist, click Add Golf Course

Match Name (Auto Generated) The system automatically generates a match name using:
Your Organization Code
The Event Date

Example: LPGC01032026

This value is hidden and cannot be edited.

Round Number (optional)

Example:

Tee Time

Click button "Complete Setup" before entering Tee Time. Clicking "Manage Tee Times" will allow you to set the official starting tee timee and interval (minutes).

✔ Only ONE active schedule is allowed at a time. ✔ Match Name is auto-generated from your organization code and date. If a schedule already exists, the system will warn you.

4️⃣ Player Selection & Group Assignment

Steps:

Select one or more players from the list

All players signed up for the event are highlighted. Click on each player highlighted and assign to a group number by clicking "Add Player". You must Click "Clear Selection" to assign next group. Repeat process for each player/group assignment. After each player/group selection, click "Add Player" and then "Clear Selection" to avold duplicate entries. No players highlighted, click to select a player. For multiple selection, hold shift or ctrl keys and click each player for a group as noted above.

Select a Group number (1–21)
Click Add Player

System Rules:

Maximum 21 groups
Maximum 5 players per group
Maximum 105 players total
System prevents overfilling a group
Total players per group is displayed
Total assigned players is displayed

Players can be modified by:

Clicking ❌ to remove
Drag & Drop between groups

Changes are not saved until you click Complete Setup.

5️⃣ Advance Signup Integration

Players who signed up in Advance Signup:

Are highlighted in the dropdown
Marked as “★ Signed Up”

Important:

Signed-up players are NOT automatically assigned
You must still select group and click Add

The summary panel shows:

Total Signed Up
Total Assigned
Total Unassigned

If unassigned players exist, a warning will display.

6️⃣ Re-Running This Page

If players already exist in the schedule: Without Reset:

New selections are appended
Duplicate players may occur if re-selected

With Reset:

Everything is cleared
Schedule rebuilt from scratch

Best Practice:

Add ONLY new players when updating
Use Reset when rebuilding all groups

7️⃣ Lock / Unlock Groups

Unlock allows players to mark scores and monitor live leader board.
Lock prevents access to marking scores

Use Lock when:

Tournament is ready to begin
No further player changes are allowed

Note: After marking scores for first hole, do not add any players to the group. Create a new group for player.

8️⃣ Start Play

Click START PLAY to proceed to the Tee Box. Before starting:

Ensure Complete Setup was clicked
Ensure groups are correct
Ensure no unassigned players remain

You may return later to add walk-on players via:

Admin Panel 2
Walk-on Add Player

Note: After marking scores for first hole, do not add any players to the group. Create a new group for player.

9️⃣ Course Mismatch Warning

If you see a Course Mismatch Banner:

The selected course does not match the schedule
Re-select the correct course OR
Reset the schedule

🔟 System Limits Summary

1 Active Schedule at a time
21 Maximum Groups
5 Players Per Group
105 Players Maximum

Admin Best Practices

✔ Always verify course before assigning players
✔ Always click Complete Setup before leaving page
✔ Reset only when fully rebuilding
✔ Unlock groups before starting tournament
✔ Check unassigned players before play

You are now ready to manage your event.

Post Members and Next Available ID's

1. Player ID Generation: Finds the highest numeric player ID for this client and organization prefix, then suggests the next available ID for a new player.

2. Guest ID Generation : "Extracts the organization code from a sample player ID and suggests the next available guest ID (g1–g9). Ensures no duplicate guests are assigned."

3. Display Registered Guests : "Lists all registered guest players (g1–g9) for the current organization in a drop down for review or selection."

4. Display Registered Members : "Lists all registered members and member id's for the current organization in a drop down for review or selection." This feature tracks all issued id's for your organization preventing duplicate entries.

Edit/Add/Activate Members

This panel allows authorized administrators to add new members, edit existing player information, activate or deactivate login access, and remove players from active participation while preserving historical data.

Action Selection

Insert New Player

Creates a brand-new player record
Requires a unique Player ID
Password is hashed and stored securely
Player is active immediately

Update All Player Info

Updates all editable player fields
Requires an existing Player ID
Does not change activation status

Delete Player

Removes player from active use
Historical stats are preserved
Select player from drop down (do not type Player ID)

Activate Player ID (Admin Managers Only)

Re-enables login access
Supports multi-select

De-activate Player ID (Admin Managers Only)

Disables login access
Player remains in historical data

Player ID

Format: client-orgcode####
Example: 5742-lpgc1023

This field is NOT used for Activate, Deactivate, or Delete actions.

Player Selection Drop down

Used only for Activate, De-activate, and Delete
Hold CTRL (Windows) or Command (Mac) to select multiple players

Player Name

Required format:
Last, First
Example: Dow, John

Password

Required for new players
Leave blank when updating unless resetting credentials
Passwords are stored securely

Client Information

Client ID – 4-digit GSKV3 organization number
Client Name – Organization display name

Changing Client ID affects data isolation.

Role

Player – Standard member access
Admin – Administrative dashboard access

Player Attributes

Field	Description
Alias	Nickname or display name
HC	Handicap value
FLT	Flight or grouping assignment
Shirt	Shirt size (optional)
Address / City	Mailing information
Home Phone / Cell	Contact numbers
Email	Default value may be used if unavailable

Notes

Admin-only notes
Not visible to players
Useful for internal tracking

Submission Checklist

Correct action selected
Required fields completed
Correct players selected for bulk actions

All changes take effect immediately upon submission.

Security

All actions are logged
Unauthorized actions are blocked
Activation changes affect login access instantly

New Join Us Request

Displays and manages 'Join Us' form submissions for the logged-in client. Allows admin super-user review and deletion." Delete each request after review and processing.

Activate New Accounts and Admin Users

Key Features:

✅ Upload Organization's excel worksheet which includes Client Name (Organization Name), Client_id ( Business code), Player ID (special id code), Player's Name and other member's information.
✅ Select one existing logo (previewed visually as radio options).
⬆️ Optional: Upload a new logo file.
🧍 Input client ID, name, and main player ID.
🗒️ Enter Admin and Admin Super Users with optional special access codes.
✔️ Mark client and players as active by default.
📤 Submits data to config/submit_client.php.

GSKV3 Admin Managers Only – Detailed User Guide

This administrative area is reserved exclusively for GSKV3 Master Administrators and Super Admin Users. It provides advanced system controls that directly affect organizations, licenses, members, and platform-wide configuration.

Upon entering this section, the system verifies your permission level. Users without master admin rights will see an access-denied warning and will be prevented from viewing or executing any administrative functions. This security measure ensures that only authorized personnel can modify critical system data.

Authorized master administrators are granted access to a full suite of management tools. These tools allow you to upload official organization Excel spreadsheets supplied by GSKV3, which may include licensed members, organizational details, and activation data. Uploaded files are validated and processed before being applied to the database.

The File Test function allows administrators to safely test upload or processing files in an isolated manner. This is intended to verify file structure, naming conventions, and data integrity prior to executing changes that affect live organizations or members.

The Licensed Members and Organizations viewer displays all registered clients and players across the system. Administrators can select an organization or member from the drop down lists to review identifying information, license status, and association details.

To maintain consistent licensing, the system automatically determines the next available License ID for the selected organization. This prevents duplicate IDs and enforces GSKV3 naming standards when adding new members.

Branding and identity management tools allow administrators to assign or change an organization’s logo. Logos may be selected from existing approved images or uploaded as new files. Selected logos are displayed throughout the application wherever organization identity is shown.

The New License / Activate section is used to create new licensed users, assign roles such as player, admin, or super admin, set initial passwords, and control active or inactive status. These settings directly determine a user’s access level and visibility within the system.

Guest and member lookup tools provide visibility into all registered users, including guests. Administrators can search, review, and verify player IDs, roles, activation status, and organizational affiliation to assist with support, audits, or troubleshooting.

Activation and deactivation controls allow master administrators to immediately enable or disable access for any user. Changes take effect system-wide and should be used carefully to avoid disrupting active organizations or events.

This section is intended for experienced administrators only. Changes made here may impact multiple organizations and users simultaneously. If you are unsure about an action, do not proceed without guidance from the system administrator.

For assistance, licensing questions, or permission changes, contact the primary system administrator listed on this page.

🏦 Auto Bank Builder – Purpose & Instructions

🎯 Purpose

The Auto Bank Builder eliminates manual calculations and setup for golf event finances. With one click, it automatically builds or updates the Bank record for the current event, ensuring every active player’s entry fee is accurately allocated across all pots, fees, and pay outs.

This tool ensures:

All players are charged the same standard entry fee
Pots are funded correctly and consistently
Vault balances carry forward between events
Skins and pay outs run without missing or mismatched bank data

⚙️ How Auto Bank Works

The Auto Bank Builder counts active players from the Playlist table for the current schedule and applies a standard $20 per-player entry fee.

💰 Auto Formula

Event Purse = Number of Active Players × $20

Pot Type	Amount per Player ($)
Gross Skins Pot	4
Net Skins Pot	4
Low Gross Pot	1
Low Net Pot	1
Greenie Pot	2
Birdie Pot	4
Eagle Pot	0
Rabbit Pot	0 (Optional)
Player Fee	4
Total per Player	20

📋 What Happens When You Click “Load Auto Bank”

The system checks for an existing Bank record for this schedule.
If none exists, a new Bank record is created automatically.
If one exists, it is updated with current round and player data.
The Vault balance from the previous event is added.
Bank Balance is calculated as:
Vault + Event Purse − Total Pay outs
The results appear in the Bank Breakdown table below.

🔁 Alternate Banking Options

Auto Bank (with Rabbit) – Includes the Rabbit Pot at $6 per player and recalculates automatically.
Manual Bank – Allows full manual entry or editing of all pot values.

▶️ Required Workflow

Load Auto Bank
Click Run Skins
Click Payouts

Skins and pay outs require the Bank to be loaded first.

📊 Example Calculation

Players	20
Entry Fee per Player	$20
Total Event Purse	$400
Player Fees (20 × $4)	−$80
Net Event Purse	$320
Vault from Last Event	$120
Bank Balance After Load	$520

📄 Download Your Prepared Excel Worksheets

This section contains Excel worksheets prepared specifically for your organization. These files are provided by GSKV3 and are available for download at any time.

These files are support worksheets that help your organization with offline event scheduling, member uploads, and managing organizational statistics.

File Name – The original worksheet name.
Size – File size in kilobytes.
Uploaded – Date and time the worksheet was posted.
Download – Click to save the file to your computer or device.

👉 Click Download next to any file to open or save the worksheet.

Note: Only files assigned to your organization are shown here. If you do not see a worksheet you expect, please contact your league administrator.

New Course / Manage Courses Guide

This page allows you to add, edit, clone, or import golf courses into the system. Each new course must be assigned to a Client (organization) in order for player handicaps, net scoring, skins, and statistics calculations to function. Use the forms below to manage course information, including par and handicap values for each hole.

CourseID:
Select an existing course by typing the first letter of the course name to filter the drop down list of preset courses. Selecting Custom will allow you to enter a new course name.

Tee Color:
Select an existing tee color or type a new one. This allows multiple tee setups for the same course to be distinguished.

Client ID:
Each course is associated with a client. The default value is your current client session, but it can be edited if needed.

Rating & Slope:
Enter the official course rating and slope for the selected tee.

Contact Info:
Optional fields for a contact name, phone number, and email address.

Holes:
Enter par and handicap (HC) values for each hole from 1 through 18.

Add / Update:
Click Add Course to insert a new course, or Update Course to save changes to an existing course.

Clone From:
Pre fill the form using an existing course and tee setup. Change the CourseID and/or Tee Color, then click Add Course to create a new copy.

CSV Import:
Upload a CSV file to import multiple courses and tee setups at once. Minimum required columns are CourseID and Tee Color. Optional columns include rating, slope, contact name, phone, email, par1–par18, hc1–hc18, and client_id.

Edit / Delete:
Use the buttons in the Existing Courses list to modify or remove courses.

Make sure all required fields are completed. After adding or updating a course, the Existing Courses list will refresh automatically.

⛳ GroupScores & Archive Manager – Admin Help

🔐 Admin Access

These tools are restricted to Admin and Super Admin users only.
All actions are logged to the master log per client.

📁 GroupScore Manager

Use this section to manage group scorecards during the round that were previously submitted(END ROUND).

🧹 Clear Entire Archive

Deletes all "End Round" scores for the selected scheduled event (soft delete, files are not deleted from database).

⚠ Scores must be re-entered and saved again using the "Master End Round" button. worksheets

👥 Delete Group

Removes all players and hole data for a selected group (soft delete, files are not deleted from database).
Use this if a group was entered incorrectly.

🚫 Delete Player (GroupScores)

Removes all archived hole scores for a single player within a group (soft delete, files are not deleted from database).
Other players are not affected.

✏️ Edit / Remove Hole Score

Update – Change an existing hole score
Remove – Soft-delete a hole (sets value to NULL)

ℹ A value of 0 is not valid in golf. Removed holes display as –.

Required selections:
• Player
• Hole (1–18)
• Date

📊 Live Hole-by-Hole Grid

Updates automatically after every change.
Only active (non-deleted) scores are displayed.

✏️ Master END ALL ROUNDS

After Updating or Editing groups and scores, you must re-submit by clicking "MASTER END ALL ROUNDS". This reloads all data to archive for player stats.

⚠ IMPORTANT: After reset of the scheduled event, update and Edit of groups and scores are not possible.

🗑️ Delete Player Scores (Archive Search)

This tool allows admin to locate and delete individual archived scorecards.

🔍 Search Filters

Use one or more filters to locate records:

Player Name or Player ID
Course ID
Date

❌ Delete Scorecard

Deletes the selected scorecard record (soft delete, files are not deleted from database).

⚠ You will be prompted with a confirmation message. This action cannot be undone.

⛳ ADMIN HELP – Scheduled Events Page

This page displays all scheduled golf events for your organization and controls player sign-ups. Admin may also switch into player view when they need to play or record scores.

ADMIN LOGIN BANNER

When logged in as an administrator, a banner appears at the top of the page. This confirms that you are in Admin View.

Admin cannot sign up for events while in Admin View.
Admin must switch to their linked player account to play or keep score.

Click the green “Switch to Player View” button to temporarily log in as your linked player.

NOTE: After switching to player view, you must log out and log back in as admin to regain admin access.

SIGN-UP BUTTON

If a player is not signed up, the green golf-ball sign-up button will appear.
If already signed up, the button is disabled and shown as inactive.
If no active schedule exists, sign-up is unavailable.

Admin accounts ending in adm1 are restricted from signing up and must switch to player view.

FINALIZED SCHEDULED EVENTS

This section shows finalized events from the Setup table.

ID – Event identifier
Course – Course name
Date – Event date
Tee – Tee time or shotgun time
Rules – Click to expand event rules

UPCOMING & PAST EVENTS

This section lists all uploaded schedule events for reference. These entries may include upcoming or historical events.

Click Rules to expand event details.
These events may not be active for sign-up.

IMPORTANT NOTES:

Admin View is read-only for player participation.
Switch to Player View to play, sign up, or enter scores.
Always confirm which account (admin vs player) you are logged into.

⛳ ADMIN – Player Stats Page

The Admin Player Stats page allows administrators to view detailed golf statistics for all players in your organization. You can see single-player stats, multi-player summaries, handicaps, scoring breakdowns, and winnings.

Access

Only users with the roles admin or admsuper can access this page. Attempting to access without proper permissions will display an Access Denied message.

Filter Form

Select one, multiple, or all players. Hold Ctrl/Cmd for multi-select.
Choose a specific course or leave blank for all courses.
Click Load to refresh stats.
Click Print / PDF to print or save as PDF.

Single-Player Stats

Best Gross Round 🥇
Worst Round (Net) 📉
Current Handicap 🎯 (Player name shown here)
Personal Best by Course ⭐
Round Details 📋 (Holes 1-18)
Scoring Summary 📊
Winnings 💰

Multi-Player Stats

Shows total rounds, courses, gross/net, handicap, best/worst per player.

Notes & Tips

Select correct CourseID for per-course stats.
Deleted rounds (is_deleted=1) are ignored.
Handicap calculation uses last 8 rounds or PlayerInfo.HC table.

⛳ ADMIN – Setting FLT Ranges & FLT Groups

1️⃣ Flight Ranges

Each flight (A, B, C) is assigned a handicap range. Admin can adjust the ranges using the inputs above.

A: Lower handicaps (best players)
B: Middle handicaps
C: Higher handicaps

⚠️ Warning: If the ranges overlap (for example, A max ≥ B min), a warning message will appear. Adjust the ranges to eliminate overlaps.

2️⃣ Assign Flights

Check the current ranges displayed above the table.
Modify the min/max values if necessary to correct overlaps.
Click Save Ranges. All players will automatically update to the correct flight based on their handicap.

3️⃣ Flight Table

The table shows:

Player ID: Unique ID of each player
Name: Player’s full name
Handicap: Current handicap
Flight: Flight assigned based on ranges

4️⃣ Common Issues

If no players appear, ensure that the playlist has been created in Admin Dash Panel 1, Step 2.
Solo players: The system will always try to avoid single-player groups in later grouping steps.
Always check warnings for overlapping ranges before assigning flights.

5️⃣ Tips

Use the flight assignment table to quickly verify that all players are in the correct flight.
Ranges are client-specific, so each organization can have different flight thresholds.
After adjusting ranges, rerun the flight assignment to apply changes.

ℹ️ Optional- After Setting FLT Range, Build FLT Groups

This screen automatically builds fair golf groups by combining handicap-based flights with balanced group assignment. The goal is competitive, playable groups — without manual math.

🏌️ Flights (A, B, C)

Flights are assigned strictly by handicap range:

Flight A: Lowest handicaps
Flight B: Mid-range handicaps
Flight C: Highest handicaps

You may change the handicap ranges at any time. Flight assignments update automatically.

⚙️ Grouping Rules (Always Enforced)

No group will ever contain only one player
Players are spread to avoid stacking the same flight
Lower handicaps are placed first for balance
Final display is always ordered by group number

🚫 If There Are No Flight A Players

When no Flight A players exist:

At least one Flight B player is placed in every group
Flight C players are distributed evenly afterward

This prevents weak or overloaded groups.

🆚 Auto vs Manual Group Selection

Auto: System assigns the best available group
Manual: You may force a player into a specific group

Manual selection overrides balance rules — use sparingly.

🔁 When Should I Rerun Grouping?

After players are added or removed
After handicap updates
After flight ranges change

Rerunning grouping is safe and will always re balance fairly.

Purpose of the Master Reset

This guide explains how the Master Reset and Restore from Backup features work, and how to use them safely.

⛳ Master Reset & Restore User Guide

🔐 This page is protected by an admin lock. Unauthorized users are redirected automatically.

What Happens During a Master Reset

Automatic Backup (Step 1A)
- The current Playlist is copied into Playlist_bkup
- Each backup is time stamped (backup_at)
- The admin ID is stored (backup_by)
Clear Active Tables (Step 2)
- Deletes all scores from GroupScores
- Deletes the active Playlist for the selected schedule
Rebuild Playlist (Step 3)
- Reads player signup's from advance_signup
- Randomizes players
- Assigns groups automatically (4 players per group)
Auto Assign HC & Flight (Step 4)
- Pulls handicap values from PlayerInfo
- Assigns FLT A / B / C automatically
Disaster Recovery Tables are Auto Backed up on every Reset (Step 1B)
- GSKV3 License
- Bank & Skins
- Player Stats
- PlayList
- Player Information
- Master Backup Log
- Golf Course Info (Assigned Client Courses)

Restore from Backup (Last Known Good)

If something goes wrong, you can instantly revert the playlist using the Restore From Backup button.

Deletes the current Playlist
Restores rows from Playlist_bkup
Does NOT affect historical stats
Skips generated columns automatically

✅ One-click restore. No fear. No guessing.

What This Tool Does NOT Touch

Player master records
License records
Course definitions
Historical stats (unless explicitly reset elsewhere)

⚠ WARNING

Once a Master Reset is confirmed:

All scores for the event are permanently deleted
Groups are randomized again
This action cannot be undone without using Restore

Common Questions

Why do I see a blank screen after reset?

This page uses a POST → redirect → message display pattern. If redirected too early, messages may not render until reload.

Is the backup automatic?

Yes. Every reset automatically creates a backup before any deletes occur.

How far back can I restore?

The restore button restores the most recent backup for the selected schedule.

Quick Summary

Playlist	Backed up, deleted, rebuilt
Scores	Deleted
Groups	Randomized
Flights	Auto-assigned
All Tables	Disaster Recovery
Security	Admin-only

✔ Use carefully — this is the most powerful event-level reset in the system.

Purpose of the Disaster Recovery

🧯 Disaster Recovery – Backup & Restore Help

🔐 Access Control

This page is restricted to Super Administrators only. All actions are logged and audited. Unauthorized access is blocked.

📦 What This Tool Does

This tool protects your organization against accidental data loss by creating a complete snapshot of critical league data.

Licenses & organization configuration
Player profiles & handicaps
Player scoring history
Skins & winnings results
Course setup and par data

Each backup is tagged with a timestamp and administrator ID for full trace ability.

🧪 Backup Preview (Dry Run)

Before a backup is committed, the system displays a row count preview. This allows you to verify the scope of data being captured.

No data is changed during preview
Counts reflect the current live database state
If numbers look incorrect, do not proceed

✅ Create Backup

When you initiate a backup:

All related tables are copied inside a single database transaction
A master backup log entry is created
If any table fails, all changes are rolled back
Successful backups are marked as “last known good”

✔ This guarantees consistency across all tables.

🔁 Restore Last Known Good Backup

This action restores the most recent successful backup. It should only be used when:

Scores were accidentally deleted
Incorrect imports were performed
Data corruption is detected

⚠ WARNING: Restore operations overwrite live data. This action cannot be undone.

📜 Backup History & Audit Log

Every backup and restore is recorded with:

Date & time
Administrator ID
Status (Committed / Rolled Back)
Error summary (if applicable)

This ensures full accountability and compliance.

🕒 Backup Retention

Older backups may be automatically expired based on system policy. Always verify that a valid backup exists before performing destructive actions.

🆘 Best Practices

Run a backup before major imports or resets
Verify preview counts carefully
Never restore during active score entry
Limit restore access to one administrator

This system is designed for safety, trace ability, and recovery.
When in doubt — back it up first.

Audit Viewer

What Is the Admin Audit Log?

The Admin Audit Log records all significant administrative and system actions performed within the application.

This tool is designed for administrators and super administrators to monitor system activity.

Tracked actions include:

User logins
Player creation
Player updates
Record deletions
League configuration changes
Security-related events

Understanding the Columns

ID – Unique log record ID.
Client – Organization or client identifier.
User – Player or user who performed the action.
Role – User role at the time of the action.
Action – Type of action performed (Login, Create, Update, Delete).
Entity – System object affected (example: player #45).
Details – Description of the change or activity.
IP – User IP address when action occurred.
Date – Timestamp of the activity.

Using the Filter Tools

You can narrow results using the filter fields:

Search – Searches within details and action labels.
User – Filter by specific player/user ID.
Action – Filter by action key (example: login, create, update, delete).
From / To – Filter by date range.

Filters can be combined. Example: Filter by user AND date range.

Super Admin vs Admin Access

Super Admin – Can view logs across all clients.
Standard Admin – Restricted to their own client logs only.

Printing the Log

Click the Print button to generate a printer-friendly version of the results.

Only the currently filtered results will print.

Security & Compliance

All admin activity is permanently logged.
Logs cannot be edited through the interface.
Logs provide trace ability for accountability and security audits.
IP tracking helps detect unauthorized access attempts.

Best Practices

Review logs regularly.
Investigate unexpected login locations.
Monitor repeated failed login attempts.
Print logs monthly for record retention (if required).

Quick Start Guide

Event Scheduling Quick Start Guide

Step-1. Create or Load Schedules

Create a new schedule directly in the system.
Repeat manual schedule setup for each event you want to create.
All created schedules are listed and selectable from optional auto fill drop down.
Load existing schedules from your saved files.

Step-1.1 Upload Multiple Schedules (Optional).

Upload spreadsheet files (.xlsx, .csv) with tournament schedules for upto 12 months.
Ensure columns match the system requirements (e.g., Event Name, Date, Time).

Step - 2. Complete the form

Pre-loaded schedules from step-1 can be reloaded into the form. This will fill in the date, course, match number(hidden), tee time, green fee and rules from previous events.
Date - fill in the date of the event.
Add Golf Course - If you golf course doen't appear in the drop down list, you must assign a course to your organization or insert data for that golf course (follow instruction list on Add Golf Course page).
Round - Enter a sequence number for each event scheduled. It's a good pratice to use the format :

Org- Code Event Date Round Name

lpgc 2026-02-16 lpgc-2026021601R1

Tee Times - Only the start tournament time for group 1 is required, all other groups will be assigned tee-times in intervals of default 10 mins. Use to made changes to the active schule.Use Back button to return to page.
Fees and Rules - This data will be recalled whenever you select a pre-loaded schedule. If changes are required, Goto . Use Back button to return to page.

Step-3. Save Schedule

Click to load a new schedule.
Removes last event schedule from active and displays new schedule in active box at top of page,
Resets Setup table and inserts new schedule.
Doesn't delete signup list, playlist or scores from last event.
Schedule Setup is now complete. Goto and click "START PLAY".

Notes:

Clear Schedule for a New Tournament;

When starting a new tournament, you must reset events by clicking "Clear Schedule".

Clear Schedule removes:

This will delect all uploaded schedules for your golf organization. If you uploaded 12 months of scheduled events, all will be removed from the database. Clearing the schedule can not be restored.

Clicking START PLAY on Admin dash panel 1;

Edit Players and Groups (Optional);

Swap Groups
Manually Create New Groups
Add Walk-on Players
Run Random Player/Groups (START PLAY)

Note: START PLAY will reset your player/group combinations.

Unlock Tee Box

After you completed the schedule setup, unlock the tee-box for the players to enter logic that allow last minute player changes.

Automatic Match Naming(hidden)

Match names are automatically generated using your organization code and event date.

Round naming is your choice, but we advise you to use a standard format such as :

Org- Code	Event Date	Round Name
lpgc	2026-02-16	lpgc-2026021601R1
boh	2026-03-01	boh-2026R3

Example: Your Club Organization's Org-Code with the date and the letter R (round) with a sequence number at the end(lpgc-2026021601R. This format ensures no round number is duplicated.

Tips

The System will auto-backup Player Signup list, Playlist, Bank, schedule_Uploads. Dates are posted to indicate last known backup.
Entering Admin Panel 2 or START PLAY locks player signup.
To unlock player signup, goto Admin Dash Panel 1 and click unlock signup.
Double-check uploaded spreadsheet formatting.
Use the generated match names in communications to avoid confusion.

Database Maintenance

Admin Super User Help Guide

Access Requirements

Only users with the role admsuper may access this page.
Unauthorized users will see Access denied.
This dashboard performs high-level database operations.

1. Database Backup

The Create Full Database Backup button performs a complete MySQL database export.

The system uses mysqldump to generate a full SQL backup file.

What Happens:

A backup file is created in the /backups/ directory.
Filename format: gskv3_backup_YYYY-MM-DD_HH-MM-SS.sql
The backup includes all tables and data.

Best Practice:

Run backups before major updates or maintenance.
Download and store backups securely.
Periodically clean old backup files from the server.

⚠ Backup files may contain sensitive data. Store securely.

2. Log Maintenance

The Remove Logs Older Than 1 Year button cleans the admin_audit_log table.

What Happens:

Deletes records older than 12 months.
Improves performance.
Reduces database size.

Only logs older than 1 year are deleted. Recent logs remain untouched.

When to Use:

When database size grows significantly.
During scheduled maintenance.

3. Optimize Tables

The Optimize admin_audit_log Table button runs:

OPTIMIZE TABLE admin_audit_log

Purpose:

Reclaims unused storage space.
Defragments the table.
Improves query performance.

✔ Safe to run periodically after large log deletions.

4. Client Filter (Super Admin Only)

The Filter by Client dropdown:

Displays logs grouped by client_id.
Sorts clients by total log count (highest first).
Helps identify high-activity clients.

5. Sorting Database Statistics

The Sort By dropdown allows you to sort tables by:

Size (Largest) – Largest tables first (default).
Row Count – Highest row count first.
Table Name – Alphabetical order.

6. Database Statistics Panel

Total Database Size

Displays combined size of all tables (Data + Index).

Largest Table

Shows the table consuming the most space.
Highlighted in the table list.

Database Health Indicator

Healthy – Under 50 MB
Moderate Growth – 50–200 MB
Large Database – Over 200 MB

The health indicator provides a quick visual database growth assessment.

7. Admin Navigation Buttons

ADMIN DASH PANEL 1 – Returns to main admin dashboard.
Home Icon – Returns to site home.
Tips/Manual Icon – Opens reference documentation.

Maintenance Recommendations

Run database backups weekly (minimum).
Clean logs quarterly or bi-annually.
Monitor database size monthly.
Investigate unusually large tables.
Optimize tables after major data deletions.

⚠ Important: All actions on this page directly affect the production database. Only experienced administrators should perform maintenance.

🔐 Secure Authentication

GSKV uses secure authentication protocols to verify every user before access is granted. This ensures that only authorized players, administrators, and master users can enter the system.

What Happens During Login

User enters Client ID
User enters Player ID / Username
User enters Password
Credentials are securely validated against the database
Passwords are encrypted (never stored in plain text)
If valid → Secure session is created
If invalid → Access is denied

Security Safeguards

Encrypted password storage
Credential verification before dashboard access
Protection against unauthorized entry
Optional lockout after repeated failed attempts

Visual Flow Diagram

GSKV authentication ensures a secure starting point before any tournament, scheduling, or scoring activity begins.

🔄 Session Validation

After successful login, GSKV maintains a secure session to validate user identity as you navigate through dashboards, reports, and scheduling tools.

How Sessions Work

A secure session is created upon login
The session stores:
- Client ID
- Player ID
- User Role
Every protected page verifies the active session
If session is missing or expired → User is redirected to login

Session Protection

Prevents direct URL bypass
Protects Admin and Master tools
Reduces risk of unauthorized access
Logout immediately destroys session

Visual Flow Diagram

[ Page Request ]
        ↓
Check Session
        ↓
 ┌───────────────┐
 │ Session Valid?│
 └──────┬────────┘
        │
   YES  │  NO
        │
Display │ Redirect to
Page    │ Login Screen

Session validation ensures your GSKV experience remains secure while allowing seamless navigation across tools and reports.

🎯 Role-Based Redirection

GSKV automatically adjusts dashboard access based on your assigned role. This ensures each user sees only the tools appropriate to their level of responsibility.

User Roles

🟩 Master (admsuper) – Full system & license control
🟨 Admin – Tournament management & operational tools
⚪ Player – Score entry, schedules, statistics

How Role Assignment Works

System checks PlayerInfo.role
System verifies gskv2_license table (Master override)
User role is finalized
Dashboard modules activate based on role
Restricted sections appear faded (disabled)

Visual Flow Diagram

Login Success
      ↓
Check Role Tables
      ↓
Assign Role
      ↓
 ┌──────────────────────┐
 │ Master | Admin | Player │
 └──────────┬───────────┘
            ↓
Load Role-Specific Dashboard
            ↓
Enable Allowed Features Only

Role-based redirection protects system integrity while keeping the interface clean, focused, and aligned with your responsibilities within GSKV.

FAQ / Troubleshooting

Q: I forgot my password.
A: Use the password reset link or contact your admin to reset it (text 832.938. 2347. Include Player ID and Golf Organization).

Q: I can't see my group.
A: Make sure you're signed up for the current event and assigned to a group.

↑ Back to Top

GSKV3 Golf Management Admin Manual

System Overview

Core Components

1. Organization & Access Control

2. Course Management

3. Event Scheduling

4. Player Management

5. Sign-Up & Group Assignment

6. Score Entry

7. Scoring & Statistics

8. Logging & Auditing

9. Data Integrity & Safety

Typical Workflow

6. Admin Dash Panel 1

[A] Details: Change the order of group pairings, players, or group.

Golf Schedule Setup – 4 Step Process

File Handling (Importing / Exporting )* **The administrator uses the GSKV3 templates provided to import data needed to create player reports and stats(See figure above).

Admin Additional Controls

ADMIN DASH PANEL-2

Manage Player SignUp

Event Information Panel

Dashboard Navigation

Add a Guest or New Player

Adding Players to the Playlist

Removing Players

Important Notes

Scorecard Approval

4.1 Record/Correcting Score Card (Admin)

5. Setting Up A Golf Schedule Manually

(Step 1) Setup Schedules

Important Rules

Option 1 – Upload Schedules from Excel (Recommended)

Option 2 – Manual Schedule Setup

Editing an Active Schedule

Removing Schedules

(Step 2) Admin Dash Panel 1

Admin / Player View

5.1 Upload An Excel SpreadSheet Golf Schedule

5.2 Active Golf Schedule

5.2.1 Editing The Active Schedule Event

🔹 Upload or Select a Schedule

🔹 Step 2: Edit Event Details

🔹 Step 3: Rules & Policies

🔹 Step 4: Shotgun Hole Assignments

🔹 Removing a Schedule

5.2.2 Shotgun start-time and Group starting holes

🔹 Edit Event Details

🔹 Rules & Policies

🔹 Shotgun Hole Assignments

🔹 Removing a Schedule

File Handling (Importing / Exporting )* **The administrator uses the GSKV3 templates provided to import data needed to create player reports and stats(See figure above).

Quick Play Schedule

1️⃣ Access Control

2️⃣ Reset Schedule (⚠️ Permanent Action)

3️⃣ Event Schedule Setup

4️⃣ Player Selection & Group Assignment

5️⃣ Advance Signup Integration

6️⃣ Re-Running This Page

7️⃣ Lock / Unlock Groups

8️⃣ Start Play

9️⃣ Course Mismatch Warning

🔟 System Limits Summary

Admin Best Practices

You are now ready to manage your event.

Post Members and Next Available ID's

Edit/Add/Activate Members

Action Selection

Insert New Player

Update All Player Info

Delete Player

Activate Player ID (Admin Managers Only)

De-activate Player ID (Admin Managers Only)

Player ID

Player Selection Drop down

Player Name

Password

Client Information

Role

Player Attributes

Notes