Stats for Opencaching sites

[mic@]

It works now !!!


Thank You for this very fast fix, Mic@

[mic@]

Hi Tomasz,
while looking at the statistics of "nordlandkai"...
https://tomaszg.pl/cgi-bin/geo-form.pl? ... ap=Germany


...we discovered a very strange behaviour.

Sometimes his foundlog of 29-02-2020
https://www.opencaching.de/viewcache.ph ... log1306372

...is calculated correctly

good1.jpg

good2.jpg

and sometimes this date is missing !?!

bad.jpg

Could You please check what the reason of this varying error is?!

[tomaszg]

Terribly sorry for not replying immediately. I didn't get notification *again* and only looked here by chance. Please don't hesitate to ping me via private message, email or GC if I don't respond.

I was rather baffled by this report but finally tracked it down. Apparently for some logs time was not set (it was reported as 0:00). Moreover my code didn't take care of daylight saving time and as result some finds were randomly shifted in time +/- 1h. Now I believe it to be fixed, hope it is fine now.

I also have some finds on my own on OCde , so I will try to test my code with OCde database more regularly.

[mic@]

Good morning Tomasz,
the modified statistics looks good now, thanks for Your support.
What is still missing are events, locked caches and hidden caches.
I presume that You are not able to get locked or hidden caches through the OKAPI,
but events should work. Could You add them to this table too?
TIA, Mic@

[tomaszg]

Events are displayed now, it was trivial to do: only problem was that log type was not "found" but "attended". I see you attended a lot of events! Still, the number on my stats is much lower than on OCde website. Probably those are these locked caches. Like we discussed before, if OKAPI doesn't show them, I don't see them...

(Again, I didn't get any notification... Maybe my mail server is blocking them :/ )

[tomaszg]

Ugh, it now shows events happening in the future as found caches, it looks weird. Your "hidden month matrix" identifies you as time traveler.

[mic@]

Ugh, it now shows events happening in the future as found caches, it looks weird. Your "hidden month matrix" identifies you as time traveler.

Maybe You have problems with my recycled events (e.g. OC Talk, Berolina, newbie-event).
These listings got every time a new schedule, but old logs remain active.

Regarding the zero notification:
This is not Your fault, it´s our or better say Google makes it now more complicated than before.
This is the reply which the forum server gets:

Code: Alles auswählen

<firschke@gmail.com>: host gmail-smtp-in.l.google.com[66.102.1.26] said:
    550-5.7.26 This mail is unauthenticated, which poses a security risk to the
    550-5.7.26 sender and Gmail users, and has been blocked. The sender must
    550-5.7.26 authenticate with at least one of SPF or DKIM. For this message,
    550-5.7.26 DKIM checks did not pass and SPF check for [opencaching.de] did
    not 550-5.7.26 pass with ip: [188.68.63.102]. The sender should visit
    550-5.7.26  https://support.google.com/mail/answer/81126#authentication for
    550 5.7.26 instructions on setting up authentication.
    t12-20020a1c770c000000b00401cb2bdf5fsi2365157wmi.51 - gsmtp (in reply to
    end of DATA command)

[tomaszg]

Ah, I know the problem. Our mail server also rejects emails with incorrect or missing SPF entries.

[mic@]

Good evening Tomasz,
Your statistic is still wonderful. I will announce it again on our monthly OC talk (podcast), which will be held on this sunday (Feb 02, 8.30 pm berlin time).
But there is still a bug which maybe could be fixed by avoiding coord.eu ! For example:


While clicking on a cache link...

_screen1.jpg

...then Your statistic tool uses a link forwarder named coords.eu , but the listing is not shown:

_screen2.jpg

The problem is that the certicate for coords.eu is not valid,
because it was issued for *.ar1.andrix.eu, ar1.andrix.eu

So maybe it is better to just use the plain address, for example https://opencaching.de/OC1832E
Greetings from Berlin, Mic@

[tomaszg]

Hi, I will check the error, but it seems to work for me. I'm in Vienna right now (didn't find any OCDE cache yet...) and the domain seems to work fine. Apparently problem occurs only with https, but for me the browser connects via http and everything works. Maybe you have some add-on forcing https?

I was using this webpage coord.eu to handle easily all OC sites without too much trouble. I should probably rewrite it inside my code. At this moment I'm surprised it works at all, apparently there was some critical bug that I reported but it was never fixed: https://github.com/opencaching/oc_coord/pull/14

I'll have closer look when I return back home.

[mic@]

Hey Tomasz,
there seems to be a problem with german "umlaut" (ä,ö,ü) in username. Here is a screenshot of the problem:

_screen.jpg

[tomaszg]

Yeah, I got the email from him directly. Just returned home a couple of hours ago and didn't manage to answer or find the reason yet. It is simple but complicated...