About ScoreKeeper

General Info

ScoreKeeper is a web-based system for updating and displaying results and rankings for biliard events. It was created in June 2010 by Hermund Årdalen and is constantly updated with new features.

The system is available free of charge. Send me an e-mail at webmaster@snooker.org if you'd like a copy.

Admin interface:

Help

For help with the administration interface see the help page.

Solutions

Version history

1.0.100 - 30.06.2010
- Initial

1.0.101 - 04.04.2013
- Added chat

1.0.102 - 03.06.2013
- Finalized money lists

1.0.103 - 05.06.2013
- British flags in World Games

1.0.104 - 11.06.2013
- Added Details URL box to Matches form

1.0.105 - 25.06.2013
- New Advance option: Continuous (first available)

1.0.106 - 02.07.2013
- Possible to add scheduled dates with day only

1.0.107 - 11.07.2013
- Added Round Info to Matches form

1.0.108 - 21.07.2013
- Changed order of column in Matches form

1.0.109 - 26.07.2013
- Moved bronze match below final and added num matches to Round info

1.0.110 - 01.08.2013
- Moving round info and advance boxes to the bottom after values are registered

1.0.111 - 03.08.2013
- Reintroduced event URLs in the right box

1.0.112 - 11.08.2013
- Displaying points and money for each round

1.0.113 - 14.08.2013
- Used distance in admin of matches (max values and javascript goodies)

1.0.114 - 17.08.2013
- Fixed sorting bugs in ranking lists and introduced version history

1.0.115 - 19.08.2013
- Lots of fixes to allow for easier upgrading of other sites

1.0.116 - 26.08.2013
- Introduced gobjMergeQualMatches, reintroduced bracket link from events and bugfixes

1.0.117 - 29.08.2013
- Displaying Asian Order of Merit in player pages

1.0.118 - 31.08.2013
- Get the new value in the event and player forms selected directly after submit

1.0.119 - 01.09.2013
- Set default season in an event form to current season.
- Rearranged elements in event form
- Added number of matches to results, live scores and upcoming
- Introduced AllRoundsAdded to reduce size of dropdown menu for rounds in the Matches form
- Matches form: Automatic fetch when an event is selected that uses only one round

1.0.120 - 03.09.2013
- Set match to completed (in handleMatches) when distance has been reached but unfinished box is checked

1.0.121 - 05.09.2013
- Added USE_FIRST_TO

1.0.122 - 08.09.2013
- Using AllRoundsAdded to reduce size of dropdown menu for rounds in the Advance box in the Matches form
- Added displayTrackingCode()
- Let an empty score count as zero if the other score is there
- Ignore scores if there's a walkover

1.0.123 - 09.09.2013
- Introduced gobjEventsWithFramesAsPoints, gobjEventsThatUseFrameDifference and gobjEventsUsingMainForTable

1.0.124 - 11.09.2013
- Introduced gobjMergeInDiary

1.0.125 - 13.09.2013
- Fixed link from event to matches when round 1 is not in use

1.0.126 - 14.09.2013
- Added ORDER_UPCOMING_BY_DATEONLY (when day comes before day and time)

1.0.127 - 15.09.2013
- Hide distance after first matches have finished
- Handle single and double quotes in roundinfo note
- Hide match rows when no event and round is selected

1.0.128 - 20.09.2013
- Highlight newcomers in provisional season-end money list
- Hide lots more on minimize
- The "Update rankings" box is automatically checked when a score is set to the distance or a walkover box is checked.

1.0.129 - 23.09.2013
- Fixed a bug in the updating of Live Scores.
- Only updating ranking lists affected by event (only update Order of Merit when event is PTC)

1.0.200 - 26.09.2013
- New Head2Head table replaces gobjHead2Heads
- getSeeding: Dropped gobjSeeding in favour of direct database lookup

1.0.201 - 28.09.2013
- Optimized updateValueNominations and now runs it only once

1.0.202 - 03.10.2013
- Limiting tweets to cases when match scores were changed
- Optimized getPlayerEventPoints to reduce time to generate the ranking lists in the presentation

1.0.203 - 07.10.2013
- Fixed a bug in getCutOffRestriction() that caused no points to be awarded in qualifying events

1.0.204 - 10.10.2013
- Changes time zone to CET after 27 Oct 2013
- New method: flush()

1.0.205 - 23.10.2013
- Better support for team events

1.0.206 - 10.11.2013
- Added "Players" and "Head 2 Head" to front menu
- Added player homepages
- Adjusted HTML and CSS on a number of pages in the presentation

1.0.207 - 30.11.2013
- Admin/Matches: Highlighting "init" link for overdue matches
- Admin/Matches: Design tweaks

1.0.208 - 01.12.2013
- Upcoming: Info when matches in a round are awaiting scheduling

1.0.209 - 12.12.2013
- Player: Display age

1.0.210 - 14.12.2013
- Display "Today"
- Drop modified date for matches that haven't started

1.0.211 - 15.12.2013
- Added page "Main Tour players"
- Introduced gobjDistanceExceptions

1.0.212 - 16.12.2013
- Added win percentage column to "Main Tour players"

1.0.213 - 01.01.2014
- Handling lookups for non-existent events
- Fixed age calculation (getAge)

1.0.214 - 02.01.2014
- Fixed bug in genLeagueTable (occurred when all matches just had the TBD player)

1.0.215 - 03.01.2014
- Used getAge() also in player profiles

1.0.216 - 12.01.2014
- Removed group events from Finals page
- gobjEventsThatUseDraws
- Added flags to round-robin tables
- Fixed fetchCurrentEvents() to exclude completed round-robin events

1.0.217 - 27.01.2014
- Added main events to event menus (genmenu())

1.0.218 - 22.02.2014
- Added gobjPlayerNames

1.0.219 - 25.02.2014
- Fixed sorting bug in match stats

1.0.220 - 26.02.2014
- Added gobjMainEvents and gobjEventSeedings

1.0.230 - 28.02.2014
- Major optimizations in a number of SQL queries in the presentation

1.0.240 - 01.03.2014
- Added genMatchData(), with gobjNumHead2Heads and general multi-dimensional gobjEventSeedings
- Dropped calls in fetchPlayer from ranking lists
- gobjEventWSIDs

1.0.241 - 02.03.2014
- Added getFinishedEvents()

1.0.242 - 15.03.2014
- Added customized searches (gobjCustomizedSearches)
- Added number of hits on searches

1.0.243 - 26.03.2014
- Added USE_WORLDSNOOKER

1.0.244 - 30.03.2014
- Replacing CURRENT_TIMEZONE with getTimeZone()

1.0.245 - 31.03.2014
- Fixed error in getCandidates() and improved performance

1.0.246 - 04.04.2014
- Added "[etq]" and "[atq]" to the qualified players in the prov end-of-season money list

1.0.247 - 06.04.2014
- Improved displayResults()
- Adjusting highlighting in ranking lists

1.0.248 - 02.05.2014
- Displaying sessions when match has started

1.0.300 - 03.05.2014
- Multi Admin

1.0.301 - 13.05.2014
- TEMPLATE_CUSTOMIZED
- Display last page when you request a page too far

1.0.302 - 17.05.2014
- More dimensions in gobjNewcomers
- Added average age to Main Tour players page

1.0.303 - 18.05.2014
- Bugfix etc while preparing for a new season

1.0.304 - 22.05.2014
- Season for teams

1.0.305 - 27.05.2014
- Fixed DateOnly

1.0.306 - 31.05.2014
- Various changes to the multi function

1.0.310 - 04.06.2014
- Rolldown menu on team members

1.0.311 - 07.06.2014
- Collapsable singles matches (admin and presentation)
- Bug fixes in use of Candidate table and more
- Defaults in Round Info
- Provisional end-of-season seedings and World Grand Prix rankings

1.0.312 - 09.06.2014
- Adjustments to collapsable team matches

1.0.313 - 11.06.2014
- gobjIncludeFlushed

1.0.314 - 19.06.2014
- Added table numbers and keyword replacement
- Bug fixes in various ranking lists

1.0.315 - 29.06.2014
- Fixed bug in calculation of gintNumUpdatedMatches

1.0.316 - 27.07.2014
- Context-based player suggestions in the Matches form

1.0.317 - 29.07.2014
- Constants for player statuses
- Initial work for Amateur Order of Merit

1.0.318 - 07.08.2014
- Support for handicaps

1.0.319 - 16.08.2014
- "About" page

1.0.320 - 09.09.2014
- Edited and launched page for historic seedings

1.0.321 - 24.09.2014
- Displaying group number in match lists

1.0.322 - 01.11.2014
- Admin log

1.0.323 - 09.11.2014
- Adjusting the minimized view for latter stages of events

1.0.324 - 11.11.2014
- Moved the admin log to separate page

1.0.325 - 20.11.2014
- Added Host and Active to admin log

1.0.330 - 22.11.2014
- Put in blocker for overwriting scores

1.0.331 - 18.12.2014
- Bulk insert of Scheduled date

1.0.332 - 23.12.2014
- Video links from matches

1.0.340 - 31.12.2014
- Optimized candidate calculation (updateMatchAdvancement)
- Prevent advancement to same round
- Display which rankings are being updated