2026-10-21 09:46:40
Jeg skal nok have lidt mere end det. Jeg spurgte lidt videre:
Jeg spørger: If you get access to the source code can you then extract statistics from the runs?
Yes, but the run data most likely isn’t in the source code itself. In a PHP site like this, the code (attendance.php, events.php and so on) is just the logic. The actual runs, dates, hares, attendance and locations are almost certainly stored in a database, probably MySQL. So what I’d really need is one of these:
A database export (best option). A .sql dump from phpMyAdmin or the web host’s control panel. With that I can rebuild the tables and calculate anything from the full history. The source code plus the database. The code shows me how the tables connect, such as what each column means and how attendance links to members. Exports from the site. CSV or Excel files, if the admin pages offer them. The public pages. The site already shows past runs and statistics, so I could read those pages and collect the data. That only covers what’s publicly visible, and it should be done with the site owner’s OK.
With the data in hand I could, for example:
Count runs per year, season and weekday, and track attendance over time Rank the most active runners, hares and milestones (50th, 100th run and so on) Show first and last runs per member, and how many members stay or drop off Map popular start locations and routes Build charts or a dashboard you can share with the club