Rainouts: 402-697-7756


Home » Changelog

A dated log of changes made to the NSS website with the latest changes at the top.

  • To see what PHP and WordPress versions we’re using, click here
  • To view your WordPress profile page and logout link, click here

2023-09-03


Modified edit-player.php to show the player’s picture for confidence.

2023-08-19


  • ALTER TABLE `ness_teams` DROP `draft_order`;

2023-05-18


Manage Player

Super users can now edit a registration or a player.

Superseded

  • registration/update-registration.php

New

  • player/edit-registration.php

2023-05-13


Manage Player

New page which features player name autocomplete. A central page to get info about a player and, for super users, the ability to delete a registration.  Eventually super users will be able to edit a registration or a player.

Superseded

  • season/mailing-address.php
  • registration/delete-registration.php

New

  • player/manage-player.php
  • player/delete-registration.php
  • player/player-history.php
  • player/mailing-address.php

Updated

  • common/db-functions.php (for isRegistered)
  • season/cancel-games-v2.php (refactored out isRegistered)
  • registration/registration-handler-v2.php (started using common isRegistered to avoid clash)

2023-05-07


Standing Page

Only show player information if user is logged in.

Cancel Games

Removed alternate row coloring.


2023-05-04


Cancel Games Enhancement


2023-04-24


Introduced cancel-games-v2.php

The new version allows the user to cancel individual games.


2023-04-15


Register Late = Pool Player

  • Created registration-handler-v2.php to process pool_player="true" correctly.
  • Modified registration-form.php to hide “willing to manage” and “enter draft” options when registering a pool player.
  • Modified common/generic-functions.php to pass pool_player hidden variable along.

2023-04-10


Draft Upload Improvement

  • Fixed a bug in process-draft-order-v2.php that prevented reloading the same input file.
  • Cleaned up the output.

2023-04-08


Draft Upload Changes

In the past, for complete redrafts, the player director would provide a spreadsheet to pre-process with process-draft-order-matrix.php. The program would convert it to a simpler form for process-draft-order.php to use. The latter program works for either complete or supplemental drafts.

Dave Sanderson wrote Excel code to generate the simpler form directly from the spreadsheet, eliminating the pre-processing step.

  • Created process-draft-order-v2.php to handle the automatically generated file from Excel.
  • For each of the 3 uploads, I removed all 2023S entries in ness_drafts and did an update to ness_registrations to empty out team-id, draft_round, overall_pick for each manager in the draft. They all get assigned to a team and get pre-drafted as part of the upload process.

2023-03-23


Bug Fix

  • update-player.php did not initialize properly for the cell number (phone_eve). If the current player had a NULL cell number, the cell number for the previous row would be displayed. Within the loop, the $phone_eve value would carry over from the last iteration. Initializing to NULL within the loop fixed the problem.

2023-03-21


Update

  • Added draft_round values for returning players whose draft round was null or zero.
  • Changed the “still need login accounts” interval from “played within the last {n} years” from 3 to 2.

2023-03-02


Update

  • Added a “Logout” link to the home page.
  • Updated paypay-ipn.php to include a new name match.

2023-02-04


Update

  • Made email matching case insensitive.

2023-01-05


Update

  • Require user to be logged in to see the players.php page.

2023-01-02


Login to Register

New feature which requires a user to login before they can register.

  • Added registration/common.php, registration-status.php and registration-exception.php
  • Added delete-registration.php to remove registrations when people change their minds
  • Edited the “Register Now” page for 2023S
  • To prevent duplicate ness_players entries during registration, got rid of ness_players rows which didn’t have any associated ness_registrations
  • New log files have been introduced in /ness/wp-content/logs:
    • <season>_registration_exceptions.txt
    • <season>_delete_registration.txt

2022-08-03


Updates

  • Restored a “delete registration” function to update-registration.php
  • Fixed a warning in registration-report.php
  • Changed process-draft-order.php  to remove all draft picks for the specified season before inserting new ones.
  • In process-teams.php, issue warnings; but, don’t error out for manager name problems.

2022-06-27


Updated the Undrafted Players page

Since registration-handler.php copies over draft information from the previous summer, we don’t have to go get it with undrafted-players.php. This simplifies quite a bit of the logic and arg passing.

  • Fixed the UI so it works with pics on or off
  • Got rid of the seasonal references

2022-06-26


Find Subs Bug Fixes

  • Trimmed blanks out of first and last names to avoid image reference problems.

2022-06-21


Factored pay-now page out of register now page

This forces players to register before they pay. Several players did things out of order in 2022S.

  • changed registration-handler.php to point to pay-now after a successful registration

2022-04-30


Find Subs Bug Fixes

  • 2022S pool players weren’t appearing because query didn’t include season in WHERE clause
  • Pool players were showing up with times and fields even through they aren’t scheduled to play

2022-03-30


New 2022S Season Work

  • Created 2022 versions of all teams
  • Migrated all returning players to the 2022S version of their teams
  • Fixed the weather widget
  • Fixed a new bug where $season was getting nulled out by the order of the global variable section.

2022-01-21


Complete File and Database Restore

Tried to fix the “add event” button in the WordPress editor by updating our Appointway theme from 1.0.9 to 1.1.4. This caused many problem and made our website unusable. It appears that the latest version of Appointway is not compatible with WordPress 5.8.3. The solution was to roll everything back to the previous day.


2022-01-14


Added

  • Registration forms to support specific playing positions.
  • change-scores.php so board members could change a score.

2022-01-11


Updated

  • Registration forms to support specific playing positions.
  • Deactivated the WP Mail SMTP plug-in because it was keeping notification emails from going out.

2022-01-01


Updated

  • PHP from 7.1.1 to 7.4.10
  • WordPress to 5.8.2
  • Upgraded all plug-ins to the latest version

2021-08-17


Changed

  • Final changes to standings_v2.php to correct the GB value.
  • Recent changes were to implement all NSS tie-breaker factors.

2021-08-07


Changed

  • Several changes to have different versions of update registration function so conduct-draft.php will only update draft_round and overall_pick during complete redraft seasons.
  • games.php to use “sched_start” exclusively so fix an “add score” link regression bug.

2021-08-03


Changed

  • db-functions.php to exclude the “(pool)” team as a drop-down option.
  • find-subs.php to include pool players.

2021-07-27


Changed

  • games.php to set local timezone and to include an ending game time in the ICS event.

2021-06-30


Changed

  • registration_handler.php to copy draft values from last summer if we are not doing a complete redraft.

2021-04-14


Changed

  • To avoid glare, changed the start time for field 2 games between 4/19 and 5/12 from 18:15 to 19:30.

2021-04-13


Changed

  • games.php to only offer “Download Calendar File” option for teams playing in the current season. For some reason, users were getting to the games page from prior seasons, and superflous calendar files were getting generated.

2021-03-17


Changed

  • Changed games.php to have a “Download Calendar File” option

2021-02-15


Changed

  • Removed former board member from registration and payment notifications.
  • Changed process-schedule.php to handle new format that is tied very closely to the scheduling software.
  • Changed games.php so it is closer to generating a google calendar export.
  • Changed undrafted-players format per the NSS director of personnel.

2020-10-11


Changed

  • Added custom getLocalTime() function to generic-functions.php
  • Changed find-subs.php and games.php to use getLocalTime().
    • Managers will be able to find a sub right up until game time.
    • The “add” scores link will be visible only after the game has started. (Before, we were using UTC time zone and the “add” link appeared 5 hours before a game began.)

2020-10-10


Changed

  • Changed date.timezone = "America/New_York" to date.timezone = "America/Chicago" in php.ini.

NOTE: PHP system info can be displayed from this URL.


2020-10-09


Changed

  • The showCurrentGames shortcode function to show next week’s games starting on Saturday instead of Sunday.

2020-07-20


Changed

  • Added assistant manager names to standings page.

2020-07-01


Changed

  • Deactivated “W3 Total Cache” plugin.  I think it was causing the standings page to exclude the most recently reported games.
  • Also changed the Cache Control Tool interval from 4 hours to 1 hour.
  • Changed computeRegistrationSeason in generic-functions.php to disregard 2020F, since we’ll only have 1 season this year – 2020S.

2020-05-13


Changed

  • Added a new nickname to paypay-ipn.php.

2020-03-11


Added

  • A registration count to the main page sidebar.  Will remove it once registration is closed.

2020-03-08


Changed

  • Fixed several bugs in players.php
    • popup link was showing on the print view
    • draft players display was off by one
  • Refactored out some functions into assignment/common.php so new load-draft-order.php and conduct-draft.php could use them

2020-03-07


Changed

  • Disabled a php.ini file that iPage tech support had created to fix the outage.  Once that file was removed, full wp-admin functionality returned and the website had full function.
  • Turned off full, site-wide debugging by changing define(‘WP_DEBUG’) from true to false.

2020-03-05


Changed

  • Zach changed 2 things that helped us resume registration
    • iPage Control Panel > Domain Central >
      • Click on our domain
      • Click on the Pointers button
      • Removed the ness subdirectory
    • With myPhpAdmin, changed ness_options table, site_url column to include the /ness subdomain.  iPage tier 1 support had removed it.
  • Any attempt to use wp-admin still resulted in an “Internal Server Error”.

2020-03-02


Outage

  • We got the “white screen of death” somewhere between 1600-1700.  We were down for several days.

2020-02-28


Changed

  • Added additional CSS to remote the blog months sidebar from all posts
  • Changed the login link on the main page to:
    • appear only when the user is not logged in
    • go to the home page (not the dashboard) when logging in

2020-01-17


Changed

admin-functions.php to update-player.php to run as a regular PHP script, not a shortcode.


2020-01-11


Changed

player-popup.php now shows all contact information to manager or higher.  (It used to only show emergency contact info to manager or higher.)


2019-11-28


Changed

Converted undrafted-players.php to a shortcode function.


2019-11-26


Changed

Modified all the files which invoke player-popup.com to use the same common/popup.js include file:

  • assignment/assign-draft-players.php
  • assignment/complete-redraft.php
  • assignment/undrafted-players.php
  • season/players.php
  • season/standings.php

2019-11-24


Moved

As a wrap-up to the 2019-11-21 work, moved these files from /ness/wp-content/themes/ness to /ness/wp-content/themes/ness/attic:

  • functions.php 
  • ness-functions.php

Starting to move files in /ness/wp-content/themes/ness to a more specific directory.  The first of these is player-popup.php to ../common.  To test the new location, player.php was modified to call the new directory.  Several other calling .php files still need to be modified.


2019-11-22


Fixed

  • player-popup.php no longer relies on functions.php (It broke as a result of the changes on 11/21/2019).

2019-11-21


Modified

  • appointway/functions.php no longer includes ness/functions.php and ness/ness-functions.php.
  • FMSL code has been moved to separate files and folders.

2019-11-08


Changed

  • ness/functions.php line 671: With the WordPress version upgrade, a syntax error that used to be absorbed now became fatal.  It had to be fixed to get the FT Calendar interface repaired.
 				JOIN {$wpdb->prefix}teams ht ON ht.team_id=g.home_id 
 				JOIN {$wpdb->prefix}teams vt ON vt.team_id=g.visitor_id
 				WHERE (g.game_id = '{$game_id}')";
-    $game = $wpdb->get_row($wpdb->prepare($sql), ARRAY_A);
+    $game = $wpdb->get_row($sql, ARRAY_A);
     return $game;
 }

2019-11-07


Changed

  • from PHP version 5.3.29 to 7.1.1
  • from WordPress version 4.1.28 to 5.2.4
  • from FT Calendar from version 1.6.1 to 1.6.1.1

2019-04-23


Changed

  • The current games section of the home page now shows all the games on the schedule for the current week – played and unplayed.

2019-04-21


Add

  • A “Cancel Games” page (cancel-games.php) to allow NSS board members to mark ness_games rows as cancelled..

2019-04-18


Update

  • Restored the (‘printable’) ability to print a schedule without images.

2019-04-16


Numerous changes to accommodate 2019S startup

  • “Replacement” page enhanced to support double-headers.
  • load-teams enhanced to accommodate draft order and manager name.
  • load-schedule changed to accommodate slightly new format.
  • complete-redraft changed to reverse the draft order.

2019-03-16


Changed

  • Loaded data from 2017S draft into 2018S registrations for maximum number of hits during 2019S draft.
  • Changed “undrafted players” page to use 2018S instead of 2017S registrations.

2019-03-05


Fixed

  • The autofocus attribute was not letting some browsers focus in the “last name” field on the player-identity-form page.

2019-02-25


Changed

  • Updated the “Register Now” page with the correct registration fee amount.
  • Fixed bug in registration-handler.php – “mgr_ok” wasn’t being persisted.

2019-01-28


Added

  • undrafted-players to help managers on draft night

Changed

  • “Complete Redraft” to return undrafted sorted by (full) name.

2019-01-23


Menu Changes

  • Added “Complete Redraft” under “RESTRICTED” to conduct the entire draft through the web.
  • Removed the “Game Results” menu because that is now accessible on the home page.
  • Since we’re in a complete redraft year, restricted “Assign Players” to Admin role.

Code Changes

  • complete-redraft is now fully functional and ready for beta testing.
  • Added draft-related columns to update-registration.
  • Better headers in registration-report and update-registration by changing extra-style.css.

2019-01-19


Menu Changes

  • Removed the Help menu because that page was very much out of date.
  • Moved “Change Password” to be under the ADMIN menu.

2019-01-16


Changed update-registration.php

  • Made player’s name uneditable.

2019-01-15


Changed update-registration.php

  • Better logging (including the user making the change).
  • Provide success/failure feedback on each update.
  • Complete refactoring of all the code.

2019-01-13


Multiple changes to add “pay time” through the “Fix Registration” page.

  • Moved [regadmin] code from admin-functions.php to registration/update-registration.php.
  • Refactored specifyLogFile into common/generic-functions.php.
  • Moved logic from reg-save.php into registration/update-registration.php and then put it in the attic directory.
  • Removed “number pref” since that is now part of the player table.
  • Removed “season” since that is now part of the page header.
  • Change “Reg Admin” menu title to “Fix Registration”.

2019-01-05


Changed

  • Moved number_pref column from ness_registrations to ness_players table.

2018-12-30


Changed

  • player-popup withholds contact information unless the user is signed in and has at least manager privs.

2018-12-20


Changed registration form

  • Added tooltips.
  • Reworked the notes section.
  • Made emergency contacts required.
  • No longer accept 0/0 (Mon/Wed) game availability.
  • Added a check box to express interest in managing.
  • Added complete_redraft hidden field.

2018-12-10


Changed

  • Refactored several of the registration-related files as groundwork for Spring 2019 changes.

2018-11-25


Changed

  • nextgames and standings no longer supply season= value

2018-11-25


Numerous files changed as a result of “games” refactoring.

  1. Changed shortcode: nextgametable to currentgames
  2. Changed shortcode: gametable to games
file significant change
ness/ness-function.php Removed games functions
ness/paypal-ipn.php computeCurrentSeason => computeRegistrationSeason.
ness/common/db-functions.php Added getPlayingSeason for future use.
ness/common/generic_functions.php Renamed computeCurrentSeason to computeRegistrationSeason
Added userIs{Role}OrHigher functions.
ness/assignment/assign-draft-players.php computeCurrentSeason => computeRegistrationSeason
Moved createTeamOptions to db-functions.php
ness/assignment/load-draft-results.php computeCurrentSeason => computeRegistrationSeason
ness/assignment/missing-pics.php computeCurrentSeason => computeRegistrationSeason
Renamed createTeamOptions to createExtendedTeamOptions
ness/assignment/propose-returning-assignments.php computeCurrentSeason => computeRegistrationSeason
ness/registration/registration-report.php computeCurrentSeason => computeRegistrationSeason
ness/season/find-subs.php Started using isCoachOrHigher
ness/season/load-schedule.php computeCurrentSeason => computeRegistrationSeason
ness/season/load-teams.php computeCurrentSeason => computeRegistrationSeason
ness/season/standings.php Got rid of $wpdb->prefix references
computeCurrentSeason => computeRegistrationSeason
ness/season/games.php New shortcode functions.

2018-10-16


Changes

  • Added 1st round playoff games to the schedule.
  • Commented out section of nextgametable_cb in ness-functions.php so the teams that didn’t make the playoffs wouldn’t show up as BYE.

2018-09-29


Changes

  • Added field number to the find-subs page per manager requests.

2018-09-06


Changes

  • Had iPage restore the original .htaccess because we were getting 404 errors. Changes must have kicked in after 4 hours of caching. Problem is resolved.

2018-09-06


Changes

  • Started logging find-subs.php usage.
  • Add this line to .htaccess file to try and prevent dup log lines: RewriteCond %{REQUEST_FILENAME} !-l

2018-08-19


Changes

  • Find Replacement page now shows an image for each player (if one is present)

2018-08-15


Changes

  • Loaded 2018S draft info as 2018F replacement data.
  • Added new software to help managers easily find replacements according to the proposed rules.
  • Removed privs of former managers per NSS board.

2018-08-09


Changes

  • Created new teams, divisions and game schedule for 2018F.
  • Started changing shortcode season parameter on some pages to 2018F.

2018-07-19


Refactored

  • createSeasonOptions out of registration-report and into db-functions so I could use it in missing-pics.

2018-07-17


Updated

  • the database to remove trailing blanks from last names to avoid tripping up the registration handler.

2018-07-11


Replaced

  • the weather widget with one that points to AccuWeather data.

2018-07-09


Added

  • Three makeup games to the 2018S schedule

2018-06-29


Updated

  • All registration and payment notifications use PHP mail instead of WP mail. WP mail broke for some inexplicable reason and iPage couldn’t help fix it.
  • Revised all notifications to carry key information in the subject line: player name, processing result

2018-06-28


Updated

  • “Register Now” page to reflect 2018 Fall information.

2018-06-27


Removed

  • “Withheld” values from email field. (3 players affected.)

2018-06-21


Updated

  • the board meeting filename cues per NSS League Secretary
  • the board meeting file upload password

2018-05-31


Updated

  • the “Standings menu” to point the new [standings] code instead of [teamtable]. The new code supports any number of divisions, eliminates duplicate “division” code and reduces database access.

2018-05-21


Updated

  • [nextgametable] to remove the superfluous game time descriptors.

2018-05-17


Updated

  • themes/appointway/functions.php to register new standings shortcode which will replace teamtable shortcode which generates the team standings page.

2018-05-01


Fixed bug in [nextgametable]

  • fixed a date math problem.

2018-04-25


Updated

  • player-popup.php to have proper phone numbers labels.
  • Created “New Season Checklist”.

2018-04-23


Fixed bug in [nextgametable]

  • before: was calling get_scores_entry with and empty $team value. This was converted to an “L” prefix on the score, no matter who won. It was confusing.
  • after: set the default value of $team to 'all'. This suppresses the prefix in [nextgametable]; but still allows the prefix when you are looking at a specific team on the “games” page.

2018-04-10


Updated

  • switched some games on 4/23/19 schedule per George
  • main page sidebar
    • changed the order of the widgets.
    • converted weather from link to widget.

2018-04-09


Added

  • “nextgametable” to the home page sidebar.

Updated

  • the “printable roster” column headers to “Age”, “Home”, “Mobile” .

2018-04-07


Closed

  • the 2018S registration by removing the register-now button from the main page and making the on-line registration page private.

Updated

  • all returning players to the 2018S version of their team.
  • the missing-pics script to have a team filter.
  • the registration-report to get team options functions from db-functions.
  • the registration-form to have a smaller Suffix field.
  • the registration-form to display better errors when not invoked by the proper WordPress page.

2018-04-05


Updated

  • the assign players script to include a link to the players card (which has a photo).

2018-04-04


Added

  • a new script to determine what player pictures are missing.

2018-03-18


Updated

  • the nicknameMatches function to includes several more names.

2018-03-17


Added

  • payment method to the registration scoreboard.

2018-03-12


Created

  • the 2018 Summer game schedule.

Changed

  • the games page to use the 2018 Summer schedule.

2018-03-11


Added

  • a beta version of a page which assigns players from draft status to a specified team.

2018-03-10


Created

  • an “assignment” folder which will contain software the lead up to and execute the draft. For example: creating new teams and assigning players to those teams.
  • “2018S” versions of all 15 teams as a precursor to test:
    1. new schedule creation
    2. returning player assignment
    3. draft player assignment

2018-02-28


Changed

  • the 2018 “Planning/Summary Calendar” to include links for each date to the corresponding date in the “Detailed Calendar” table.

2018-02-26


Added

  • a “payment-complete” page and configured the NSS PayPal account to redirect to this page when a payment is complete.
  • a “Planning Calendar” menu option.

Changed

  • the 2018 “Planning Calendar” to include fall events.
  • “Games” menu to “Games Calendar” to contrast with “Planning Calendar”.

2018-02-25


Fixed

  • a bug in the registration-form where the number of games was showing 2 different values.

Changed

  • the “positions” hint in the registration-form.

2018-02-24


Added

  • a timestamp to the registration notification. There is sometimes an email delay, so the timestamp makes it easier to line things up.
  • another entry to the “Nicknames” array.

Changed

  • the registration form to include better hints for “game commitment”, “jersey number” and “playing positions”.

2018-02-20


Changed

  • the registration report so that when a different season is selected, the team option is reset to “All”; because, team ids change (even for the same team) every season.

2018-02-19


Changed

  • the registration report to account for teams operating under multiple team_ids.

2018-02-18


Added

  • a registration report which shows the alignment of registrations and IPN messages.

2018-02-16


Changed

  • the IPN handler to show SUCCESS/ERROR at the top of the email body instead of the bottom.

2018-02-15


Changed

  • the directions on the player-identity-handler to be more specific.
  • the return address for emails within PHP code from a personal address to a no-reply address

2018-02-14


Changed

  • registration fees per NSS board instructions.
  • the paper registration form to a newer version.
  • the player-identity-handler to make the need to click a little more clear.
  • got rid of all the fake registrations created during testing.

2018-02-07


Changed

  • the paper registration link to a new PDF on the “Register Now” page
  • the way a newly assigned player-id is retrieved in the registration handler.

2018-02-06


Added

  • WordPress post to put registration begin date on the calendar.

Changed

  • home page main image and feature headings.

2018-02-03


Overview

  • started moving obsolete files from /ness/wp-content/themes/ness to /ness/wp-content/themes/ness/attic.

2018-01-28


Changed

  • the “Register Now” page to reflect the latest 2018 information.
  • the registration handler to point back to the payment section of the “Register Now” page.

2018-01-26


Added

  • logic to fail hard if the hidden ‘season’ field isn’t provided to the registration handler.

Changed

  • the game commitment options to be automatically generated depending on the season (of the year) suffix.

2018-01-24


Changed

  • the registration form labels for the privacy fields to be more instructive.
  • the way player-id presence is detected.(bug fix)
  • the logic to report “returning player, but missing player-id” more clearly

2018-01-23


Added

Registration form validation:

  • mandatory fields supplied.
  • at least one phone number supplied.
  • liability release accepted.
  • form was signed.

Changed

  • the registration handler to detect and report missing hidden field.

2018-01-22


Overview

Cleaned up the registration notification process and started sending it to a few board members for review.

Added

  • number preference field to registration form and handler.
  • two more email notification addresses.

Changed

  • a generic function to be able to get rid values a player doesn’t want – like address 2 or an obsolete land-line number.
  • the email output to reflect more and clearer information.

2018-01-21


Summary

Modified code to email registration notifications. For now, I’m only sending them to a test mailbox.


2018-01-19


Summary

  • Added a common header and footer to most of the registration pages. (Still need to do that for the registration handler page.)
  • Added style elements to make the registration pages look more like the theme the rest of the site uses like buttons and margins.

2018-01-18


Changed

  • style.css to use the browser’s default behavior for links.
  • player-identity-form to have clearer instructions.
  • player-identity-handler to use default font.

 2018-01-17


Overview

Reworked the code to allow the current “Register Now” page in WordPress to front the entire registration process.  “Register Now” will be (rightly) modified every season to reflect the latest registration information.  The rest of the process is coded generically for any season.

Changed

  • Modified the “Register Now” page in WordPress to point to the new player-identity-form.php file.

Revision 376

  • First iteration of making player-identity-form a PHP file to be called from WP “Register Now” page.
  • Factored out a function I’ll need elsewhere.

Revision 374

  • Created function to specify the log file name.
  • Moved key registration function from db-functions to registration-handler.
  • Renamed regLog to logFile to be more consistent.

2018-01-16


 Added

  • this changelog page

Changed

  • the name of the “begin registration” page and shortlink to something more generic – “online registration” that doesn’t need to be changed every season.
  • the online registration page to “public” (so I could link to it from within WordPress)
  • the “Online Registration” link of the Register Now page to point to the new online registration process.
  • several menus around to group like things

 2018-01-15


SVN revision 367

Changed paths:
M /NSS-experiments/registration/registration-form.php

Reworked the legend groups.
Changed the order of the fields.
Limited “state” input to 2 columns.
Made some of the labels more user friendly.


2018-01-12


Database Cleanup

To prevent confusion during the new registration process, removed all the duplicate entries in the ness_players table. (See the SQL scripts in NSS-experiments/database/cleanup-duplicates.)

Before removing the duplicate, associated entries in the ness_registration table were modified from the duplicate player_id to the original player_id. This assured that all registrations for a player stayed in tact.

There were:

  • 17 duplicates entries where a person’s last name and birth date matched
  • 2 duplicates entries where the person matched, but one of the rows had a null birth date

This cleanup left alone the 45 or so people that legitimately share the same last name.


 2018-01-11


Added

  • the new registration process which consisted of all new files separated away from the rest of the code in new folders under /ness/wp-content/themes/ness:
    • registration
    • common
  • a new online registration page in WordPress to kick off the new registration process.  (This supersedes the HTML page (ness/wp-content/themes/ness/registration/player-identity-form.html) developed to model what the WordPress page needed to do.