Stats for Opencaching sites

Du suchst die richtigen GPS-Geräte, Geocaching-Software oder sonstiges Geocaching-Zubehör? Tausche Dich hier mit anderen Usern aus.

Moderator: mic@

Benutzeravatar
mic@
Vereinsmitglied
Vereinsmitglied
Beiträge: 6623
Registriert: 04.12.2009, 00:31

:bounce: :bounce: :bounce: :bounce: :bounce: :bounce:
It works now !!!
:bounce: :bounce: :bounce: :bounce: :bounce: :bounce:

Thank You for this very fast fix, Mic@
Benutzeravatar
mic@
Vereinsmitglied
Vereinsmitglied
Beiträge: 6623
Registriert: 04.12.2009, 00:31

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?!
Du hast keine ausreichende Berechtigung, um die Dateianhänge dieses Beitrags anzusehen.
Benutzeravatar
tomaszg
Nano
Nano
Beiträge: 32
Registriert: 28.01.2020, 03:18

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.
Benutzeravatar
mic@
Vereinsmitglied
Vereinsmitglied
Beiträge: 6623
Registriert: 04.12.2009, 00:31

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@
Benutzeravatar
tomaszg
Nano
Nano
Beiträge: 32
Registriert: 28.01.2020, 03:18

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 :/ )
Benutzeravatar
tomaszg
Nano
Nano
Beiträge: 32
Registriert: 28.01.2020, 03:18

Ugh, it now shows events happening in the future as found caches, it looks weird. Your "hidden month matrix" identifies you as time traveler.
Benutzeravatar
mic@
Vereinsmitglied
Vereinsmitglied
Beiträge: 6623
Registriert: 04.12.2009, 00:31

tomaszg hat geschrieben: 31.08.2023, 23:08 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)
Benutzeravatar
tomaszg
Nano
Nano
Beiträge: 32
Registriert: 28.01.2020, 03:18

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