Commit graph

22 commits

Author SHA1 Message Date
Federico Dossena dd1ce2cb88 Fixed vulnerability in json.php caused my missing Content-Type header 2024-04-27 15:12:32 +02:00
sstidl e5f54fbd78
Release 5.3.0 (#587)
* Update README.md

Added simple manual instructions

* Link to docker documentation

* Add basic docker compose example

* add descriptive alt-text to GIF

* Fix some typos and formatting

* Updated Docker to use php8.2-apache as the upstream image.

* Clean up apt lists after installation in Dockerfile

* Update Dockerfile

Co-authored-by: Quentame <polletquentin74@me.com>

* fix typo

* doc: sqlite db persistance explained

* Create docker-publish.yml

* Update docker-publish.yml

* Update docker-publish.yml

* fix action

* switch docker image location

* without image signing

* remove signing

* switch units to Mbit/s

* move examples to folder

* fix ipinfo parsing

* fix regression on getIpinfo

* removed trailing whitespaces

* integrate ios favicon

closes #400

* set single-server-full as index

---------

Co-authored-by: Les W <30345058+leswaters@users.noreply.github.com>
Co-authored-by: bt90 <btom1990@googlemail.com>
Co-authored-by: An | Anton Röhm <18481195+AnTheMaker@users.noreply.github.com>
Co-authored-by: 0kyn <0kyn.dev@gmail.com>
Co-authored-by: Marc Zampetti <zampettim@users.noreply.github.com>
Co-authored-by: Peter Dave Hello <hsu@peterdavehello.org>
Co-authored-by: Quentame <polletquentin74@me.com>
Co-authored-by: Stefan STIDL <stefan.stidl@ffg.at>
2023-11-26 12:46:27 +01:00
Tracy-B 5956e07a7a
Microsoft SQL Server support and Sanity Check page (#569)
* Create telemetry_mssql.sql

SQL to create the speedtest_users table on Microsoft SQL server.

This SQL is based on the original templates, and continues to uses nvarchar for all fields as the templates do – even though some of the fields should be int.

* Added support for Microsoft SQL Server

* New sanitycheck.php page plus required updates to telemetry_db.php

Created a sanity check page to verify that the required PHP extensions are installed, and that it is possible to connect to the database.

* Update README.md - MS SQL support

Added mention of Microsoft SQL Server as a supported DB engine.

* Added missing <tr> to sanitycheck.php
2023-07-31 08:10:56 +02:00
Jeff Bierschbach afa84968c7
Save correct IP address to database (#457) 2022-01-08 12:16:05 +00:00
dosse91 a85f2c086f Fixed minor vulnerability in stats.php 2022-01-03 16:30:39 +01:00
dosse91 eca7f06e21 Fixed character encoding in mysql db template 2021-06-13 19:01:13 +02:00
dosse91 3937b940e8 Results can now be fetched in json format instead of just an image (results/json.php 2021-04-21 16:20:12 +02:00
dosse91 8be8aba5ed Fixed typo in results/index.php 2021-04-13 10:27:36 +02:00
Perflyst 011f8843fc
Add timestamp (#383)
* Add timestamp in result image

* Remove format on timestamp
2020-12-17 16:00:44 +00:00
Bernd Stellwag fb7575b67b
Refactor results/ PHP code (#369)
* put code to insert and query data from database into separate file

* simplify obfuscation salt file handling

* use new DB interaction functions in telemetry.php

* use new DB interaction functions in stats.php

and fix indentation levels

* format telemetry settings file

* use new function for interacting with DB in index.php

* move drawing of the image into function and try to comment each section with what it does

* reorder lines for parts of the image to align with the order they appear on the image

* bugfix: display obfuscated and deobfuscated id in stats if id obfuscation is enabled

* improve error handling

* add missing PHPDocs to functions

* imageftbbox returns an array on success and false on failure so to check if the font is usable, check if we got an array

* fix dsn for postgres

* fix limit sql statement for postgresql

* remove obsolete require statement

* use require instead of require_once since the settings file might need to be loaded multiple times

because it just contains plain variables which will just get loaded into the current scope

* move require statements to the top of the file

* make sure files are readable before requiring them

* add constant to refer to the telemetry settings file and check if it is readable before loading it

* return null if no speedtest result was found for the given id and show according message to the user instead of just exiting

* use existing constant instead of string for telemetry settings file name

* uniformly use single quotes instead of double quotes as most code places already used single quotes

* somehow some tabs sneaked in, replace them to uniformly use spaces

* mysql now uses pdo, too, reflect that in the requirements documentation

* pass username and password as constructor parameters instead of via DSN
2020-10-20 07:43:48 +02:00
Kristan Webb 9efae7c27c
Add Port option for MySql (#330) 2020-06-11 15:34:29 +02:00
dosse91 0c7ef8e979 Fixed query error in newer versions of sqlite and postgre 2019-10-01 06:46:22 +02:00
dosse91 1b059e6cc6 Improved redact_ip_addresses 2019-09-29 08:41:26 +02:00
dosse91 a50fcfe566 IP addresses can now be redacted automatically from telemetry 2019-09-28 08:22:14 +02:00
dosse91 bd7ec37350 Renamed to LibreSpeed 2019-09-25 08:23:53 +02:00
dosse91 9f4851dc8b Redesigned sharable image 2019-09-24 13:58:31 +02:00
dosse91 c3e576ddba Major project restructuring and unification with mpot branch 2019-06-30 07:03:06 +02:00
adolfintel 7b1d8995e1 Implemented ID obfuscation in telemetry.php and results/index.php 2019-01-30 10:16:28 +01:00
adolfintel 1c80530805 Fixed a typo in results/index.php 2019-01-10 06:38:23 +01:00
Mark Felder 52e91f9054 Fix results image for jitter (#158)
Postgres and SQLite were referencing the wrong variable causing the jitter field to always be empty.
2018-09-17 21:06:55 +02:00
adolfintel de3527791f results/index.php should be better at finding the fonts now. I hope 2018-08-08 20:55:17 +02:00
adolfintel 5446e98933 Added test result sharing; Added stats page; Improved project structure; Minor bug fixes 2018-08-06 18:15:52 +02:00