petlof / liveresults Goto Github PK

There is no favicon on the site today, the page would look more "finished" with one.

This would lead to another improvement -> possible to change the title for the page:
"LiveResults for Orientering" to become: "Live smålands kavlen", without getting the user confused.

Add a line in the results on qualification-heats to show how many that are through to final

in OE, if a runner is in a wrong category and then changed to the right (after readout) category, he is displayed two times: in the wrong and the changed category. Only visible at liveresultat.orie.... not in OE. Settings are set to export all records but problem occures in both modes.
Workflow?

Delete the split time when it is cleared in event software (eg. when loop-course control is passed second time in error), and IOF XML states SplitTime staus="Missing"

Add number of started and not finished runners into web part Latest updates.
It means how many runners are in forest.

Add possibility to edit multiday-setups in the admin-gui

If you are trying to track multiple runners it can be hard to find them in the class lists. In the club list you can easily see them but it only lists the start, finish and total time, so if you are interested in the intermediate time or position it isn't useful.

For tracking purposes it would be useful to add the ability to highlight runners or the club and store this throughout the competition

Same as in http://emmaclient.codeplex.com/workitem/20194, it is not possible to use Czech charset (ěščřžýáíé ...) in Club name field.

When creating local race (on local server) add possibility to import race data from web race.

On the adminpages the link to competition-index refers to wrong level in the hierarchy.

Due to new features in Chrome that warn about sites not under https liveresultat.orientering.se and all corresponding sites (including API) should be moved to HTTPS

If the computer that is running the upload uses a DateTime culture that have a date time format different from sweden, the starttimes will probably not be parsed correctly leading to problems uploading them (and also calculating radio-times).

Probably radio times will also be parsed incorrectly.

Due to abuse we need to password protect the admin-pages for a competition.
We'll do that by requiring a password while creating the competition, and then require login with that password for all upcoming edits of the same competition as well as upload to it from the emma-client.

In the fix for OLA 6.3.0, a new query was introduced in ReadRadioControls(). This query uses hardcoded IDs for eventId and eventRaceId which the pre-6.3.0 query don't. This will cause issues for competition having multiple competitions in the same schema (multi-day competitions etc).

The support for meos in emmaclient is broken and should be disabled/removed. The currently supported method is to use the builtin support in meos

The JSON parsing in the web/api.php is done manually, which might lead to non-parseable JSON being served by the API. I propose re-writing the API to utilise json_encode instead. I will do it myself and submit a PR, but it would be a bit of work so just checking there isn't a reason for the API being built this way.

Example:

if ($_GET['method'] == 'getcompetitions')
{
    $comps = Emma::GetCompetitions();
    $parsedComps = [];

    foreach ($comps as $comp) {
        $parsed = [
            'id' => $comp["tavid"],
            'name' => $comp["compName"],
            'organizer' => $comp["organizer"],
            'date' => date("Y-m-d",strtotime($comp['compDate'])),
            'timediff' => $comp["timediff"]
        ];

        if ($comp["multidaystage"] != "") {
            $parsed['multidaystage'] = $comp["multidaystage"];
            $parsed['multidayfirstday'] = $comp["multidayparent"];
        }

        $parsedComps[] = $parsed;
    }

    echo json_encode($parsedComps);
}

Would like to hear from you @petlof 😃

In commit 5bc0543 characters in the links for the Russian and Czech translations in follow_full.php was erroneously replaced with "?". The same happened in index.php but that was later fixed.

In finland there is a common case where teams get a penalty (in minutes) that is exported in the OS format.

When making a runner as "ej start" it is not sent to https://liveresultat.orientering.se/. Instead it looks like the runner had started as normal according to his start time.
Do you need more information?
How can I help implement/test this fix?

When an upload is starting after a previous run, patrols are always updated in the liveresults database even though nothing have changed in OLA

Handle that Krämer-software exports times with , as decimal separator on some regional settings.

Please add support for the no timing-flag per class in OLA. BR Oskar

The latest version of OLA (5.10.1) don't seem to be compatible with liveresults.

When trying to open a internal OLA db I get the following error alert:

It works fine when I downgrade to OLA 5.5 on the same competition.

If start time changes when a runner have existing radio times those times will not be recalculated to respect the new start time in the OLA-provider

How can we upload the start times of the runners before the event starts? We are using OE, and I couldn't find an input format to upload list of runners/start times. Thank you.

For us with too fast trigger finger... Please add a clear all data button on a competition when we happen to us the wrong Id when uploading... :-) BR Oskar

We need to start support IOF-XML 3.0

Hello,

I am trying to run caspar client on visual studio but I am not sure how to start the client since there is no documentation about it. Is there a short documentation or guide about how to use it?

There are a few links pointing to the project page on codeplex. All occurrences

They should be changed to the wiki pages instead due to the codeplex shutdown in December

Create window with all changes or possibility to show all changes in time. Actually there are only last 3 changes showed in upper part.

RestClient: Uri request:http://liveresultat.orientering.se//api.php?comp=12548&method=getclassresults&unformattedTimes=true&class=D40&includetotal=true

D/RestClient: request() responseCode:200
06-16 17:11:39.167 3339-3583/se.amli.liveresultsorienteering D/RestClient: request() responseCode:200
06-16 17:11:39.167 3339-3584/se.amli.liveresultsorienteering D/RestClient: request() response:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND runners.TavId = results.TavId AND runners.Class = 'D40' ORDER BY results.' at line 1
06-16 17:11:39.167 3339-3584/se.amli.liveresultsorienteering D/SelectClassActivity: getClassResults result:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND runners.TavId = results.TavId AND runners.Class = 'D40' ORDER BY results.' at line 1

• It would be nice to have a country field for each competition in getcompetitions to be able to sort competitions by country.
• It would also be very practical to have a function getclubs to get all clubs that compete in a competition (so you can then use getclubresults).

I have a fresh install of MySQL 8.0.29 and OLA 6.3.4. OLA-Server is configured to use MySQL as a database and I have registered one simple competition. When I try to start Liveresults Client 2022-04-22, I get the following error when I click on the OLA SOFT button, select MySQL-Server, and enter the information for it (running on localhost): "Authentication method caching_sha2_password not supported by any of the available plugins".

I have tried to reconfigure MySQL (my.ini) by changing authentication policy to: authentication_policy=mysql_native_password,, and running the following command ALTER USER "root"@"localhost" IDENTIFIED WITH mysql_native_password BY "password"; as suggested by googling.

But then I get a lot of "Objektreferanse er ikke satt til en objektforekomst" errors instead. Bottom line: I'm unable to use LiveResult Client to report live results from the newest versions of OLA and MySQL.

When results are changed the whole row is highlighted. it could be better to just highlight the changed cell

The adminpage should be translated

The NC –flag (not counted in results) is not in the OE-export –file, so this is of course not handled.

But I think Emma could handle this also by using ‘Place’ –column and ‘Classifier’ –column. When ‘Place’ –column is empty, but the leg is ok (‘Classifier’ is 0), this means that this runner/leg (whole team) should not be counted in results)?

It looks like the running times in the display does not account for summer/wintertime.
This is due to the fact that we only set the offset in hours and not the acutal timezone.
This will be fixed in the upcoming new admin-gui

For actual event show how many users are watching.

To support external-clients we should add support for CORS-requests to the API

Ordering of runners in the result-list should be done so runners without start time is ordered after those that have when both have the same amount of results.. See screenshot

Hi,
did you think about migrate or prepare EmmaClient for Linux/Unix based systems?

For my purpose it should be "only" nonvisual client - we will run it on Ubuntu with Racom system.

Thanks

Kenia

http://liveresultat.orientering.se/api.php?method=getcompetitions is now serving an invalid JSON because of a tab character inside " BEL_Ve Sprint Rocourt" competition. Tab characters and other special characters should be escaped on JSON when used inside strings https://www.freeformatter.com/json-escape.html.

I suppose that using json_encode to build the JSON as suggested in #43 should solve the problem. Otherwise you would have to manually escape this special chars before building the JSON.

Hi,
please make table in admincompetitions.php wider:
row 156
<table border="0" cellpadding="0" cellspacing="0" width="100%">
Thanks