I’ve been keeping loads of player stats for loads of people.

• For each competition table removed 33 columns – has saved 24% from the overall table size.

Created new import function to provide additional sources of data

• Created new temp table – temp_precheck
• Created new index to differ between the two sources
• Created new function to collate to data

• New delete function added to data cleanse function
• Added to admin left menu

• Clubs by league table updated with prem finishes, EFL Champ, League One, League Two and National League finishes for 2023/24 added
• Cron stop function added
• Updated cron tasks to new address
• Added new columns to all player tables – weight, twitter, instagram, wage, pob
• Added new columns to player edit screen – need to upload player edit screen and jquery function to live

• 2023/24 – Premier League appearances added – 500 players updated
• 2023/24 – EFL Championship appearances added – 623 players updated
• 2023/24 – League One appearances added – 622 players updated
• 2023/24 – League Two appearances added – 646 players updated
• 2023/24 – National League appearances added – 656 players updated
• 2023/24 – FA Cup appearances added – 2145 players updated

• New fields, footed, weight, height, place of birth added to player profile pages.

Created a new function which allows the admin to view the detail on the competition tables and the player tables. So some data tidying up can be done.

• Created new temp tables temp_datacleanse & temp_datacleansetbl – both added to live site
• Checked players who have the most appearances
  • Fixed incorrect high appearance on EFL Championship 2022 – table replaced on live
  • Found Champions league tables 2009, 2010, 2011, 2012 & 2013 – every line is duplicated – fixed
• Created data cleanse for player tables
  • Discovered a number of players who have ridiculous high achievement score, owing presumably to errors created when achievement was brought up to new coding – created function to clear any over 399 and mark to update. 13 players adjusted.
  • Fixed an achievement include error on league two – where one year was sent line #682 but was considered an array
  • Fixed error in player name which had space at beginning
  • Fixed an error where player was 9 years old
  • Fixed 1 rogue player over 45 years old
  • All player tables checked
• Checked all the import functions with the new code, various code fixes for the offline version – allowing for National League player stats for 2022/23 to be finally added.

• Major update – Whole active player set run through automated process has taken 25 days to complete to bring all players on to the new template. 30k+ player pages updated and/or created.
• PFA Awards now fixed following code changes
• Young player of the year and player of the year for 2022 now added.
• Ballon D Or fixed following code changes
• Ballon D Or 1st to 3rd added for 2022.
• Extra c foreign character added to SEO friendly name.
• Cup finished for admin area fixed
• All FA Cup beaten teams and scores added for 2022/23
• All League Cup beaten teams and scored added for 2022/23
• Final appearances import changes fixed
• FA Cup final appearances for 2022/23 added
• League Cup final appearances for 2022/23 added
• Champions League final appearances for 2022/23 added
• Fix to Conference achievement include for apostrophe in club name
• Fix to League Cup achievement include for incorrect club winning name

Some fixes to career history as the first run throughs take place.

• Removed ‘EFL ‘ from league right hand side on create-player page to prevent formatting error when there is too much text. Fix now live.
• Fixed slash in club name in career history – fix now live.
• Reduced margin underneath career history badges – fix now live.
• Fixed an error on create player page – for when matched with a player who has since been archived – Fix now now
• Club edit changed to allow for club id to be pushed
• Changes to search to improve speed and security – now live
• Added full index to keywords field in search – now live
• Fixed an error on FA Cup achievement include for fa cup not played winner array
• Fixed an error on Europe League include for achievement text where an apostrophe needed slashing out.
• Same error fixed on Champs League winners and runners up.
• Fixed an error where SEO friendly name needed slashing out in create page.
• Countries cleared off all players
• Club and nations rebuilt

Major changes to latin1 charset to ensure special characters are successfully displayed.

• All club names corrected into special characters
• Changes to all player tables full name and alt name
• Changes to create player page to create an SEO friendly filename
• New field in all players table which has SEO friendly name in – this will then be added to search keywords and meta keywords
• As a result of the above major and critical changes all players on non-archived player tables (30k) marked to update – warning will slow site down while it processes.

Revamp of the career history section and move away from stats only and introduce a more conventional CV style.

• New temp table – temp_careerclubbyclub
• Major changes to the player-timeline achievement include
• New temp table – temp_careergrouptext
• New temp table – temp_chcomptotals
• Temp_careertimeline table adjusted
• short_name added to clubs table – need to update admin area to edit this
• Added Ballon D’Or to career history – ballon-dor include updated to record
• Player of the months added to career history
• PFA Young player and PFA full player of the year added to career history
• Resolved a beaten by null error in achievement-includes/league-cup
• Create player page – massive changes to introduce new career history
• Fixed and error on search-term includes for archived players
• New smaller no badge img created – uploaded
• Archive player and non-archive player testing completed
• Change to archive player player include
• Cron page updated with new archive player link
• Fixed missing image in footer23
• Various CSS style fixes
• Update to JS to fix season select
• Fixes to search terms
• Added an additional achievement run through page – now 4 per player