Autor Thema: Okapi: Eigene Koordinaten fehlen  (Gelesen 3013 mal)

Offline Bananeweizen

  • Nano
  • **
  • Beiträge: 97
Okapi: Eigene Koordinaten fehlen
« am: 25. Januar 2014, 21:23:39 »
Ich habe jetzt mal das Feature für die persönliche Notiz und die eigenen Koordinaten bei einem Cache genutzt. Im GPX sind beide zu finden, bei einer Okapi-Anfrage nur die persönliche Notiz. Habe ich was übersehen? Ist das ein Fehler nur bei Opencaching.de oder wird diese Funktion tatsächlich so vom Okapi nicht unterstützt?

Ciao, Michael

Offline bohrsty

  • Administrator
  • Normal
  • *****
  • Beiträge: 1359
  • Teamleiter Technik
Re: Okapi: Eigene Koordinaten fehlen
« Antwort #1 am: 25. Januar 2014, 21:56:05 »
Ich habe jetzt mal das Feature für die persönliche Notiz und die eigenen Koordinaten bei einem Cache genutzt. Im GPX sind beide zu finden, bei einer Okapi-Anfrage nur die persönliche Notiz. Habe ich was übersehen? Ist das ein Fehler nur bei Opencaching.de oder wird diese Funktion tatsächlich so vom Okapi nicht unterstützt?

Ciao, Michael

nach meinem verstaendnis des okapi-services "geocaches", der das feld "my_notes" ausliest, werden die koordinaten nicht ausgelesen... evtl. existiert das feature in oc.pl nicht, denn der kommentar im quellcode aeussert verwunderung ueber die speicherung der "notizen" in der tabelle "coordinates":

  # OCDE uses coordinates table (with type == 2) to store notes (this is somewhat weird).

                                $rs = Db::query("
                                        select cache_id, null as date, group_concat(description) as `desc`
                                        from coordinates
                                        where
                                                type = 2 -- personal note
                                                and cache_id in ('".implode("','", array_map('mysql_real_escape_string', array_keys($cacheid2wptcode)))."')
                                                and user_id = '".mysql_real_escape_string($request->token->user_id)."'
                                        group by cache_id
                                ");

vielleicht macht ja jemand interessiertes mal einen featurerequest beim okapi-team auf...  8)
gruss Nils (bohrsty)


Offline Bananeweizen

  • Nano
  • **
  • Beiträge: 97

Offline Boguś z Polska

  • Aktive User
  • *
  • Beiträge: 6
Re: Okapi: Eigene Koordinaten fehlen
« Antwort #3 am: 28. Januar 2014, 22:43:20 »
Hi everybody!

I'm OKAPI developer, and I'd like to explain, that coordinates in personal cache notes have never been supported in oc.de. They are supported in oc.pl since two weeks (rev. 947). Right now I'm trying to implement them for OC.de, but I need database dump for that. I've asked mic@, and hope he'll reply soon.

Michael, your private notes and coords are safe from OKAPI developers, unless you reveal your oc.de password.

Offline bohrsty

  • Administrator
  • Normal
  • *****
  • Beiträge: 1359
  • Teamleiter Technik
Re: Okapi: Eigene Koordinaten fehlen
« Antwort #4 am: 28. Januar 2014, 23:29:13 »
as i mentioned in my post above (german, i know ;) ), the whole "personal note" and "coordinates in personal notes" thing in oc.de is stored in the coordinates table (the comment in the okapi-code shows that somebody of you wondered about ;) )... as you can see in https://github.com/OpencachingDeutschland/oc-server3/blob/master/htdocs/doc/sql/tables/coordinates.sql the coordinates are stored in the latitude and longitude field... these can be 0 (=zero) if no coordinates given or a legal coordinate in decimal format)...

hope that helps a bit until you get a up to date dump...

regards Nils
gruss Nils (bohrsty)


Offline mic@

  • Vereinsmitglied
  • Large
  • *
  • Beiträge: 6321
  • oc-only Verstecker
Re: Okapi: Eigene Koordinaten fehlen
« Antwort #5 am: 28. Januar 2014, 23:42:53 »
Zitat von: Boguś z Polska
Right now I'm trying to implement them for OC.de, but I need database dump for that. I've asked mic@, and hope he'll reply soon.

Access has been granted.
Have fun with it, Mic@

PS: Are You a oc.pl developer too? If so, have You ever thought of reuniting Your code with ours?
Because it´s always good to join forces  8)

Offline Boguś z Polska

  • Aktive User
  • *
  • Beiträge: 6
Re: Okapi: Eigene Koordinaten fehlen
« Antwort #6 am: 30. Januar 2014, 23:57:58 »
I'm also oc.pl contributor, small changes, bugfixes etc. Not a big developer ;)

I've been looking around at oc.de page, and there are several differences between oc.pl and oc.de. I like very much your clean web design. It's much better and modern compared to oc.pl. Also, PHP code (in parts where I've been digging) is better in oc.de. But, there is one important thing missing in oc.de: I haven't found user's menu, which holds lot of  useful options. Moreover, I think you are missing the map, something which is very crucial for our users.

Greetings
« Letzte Änderung: 31. Januar 2014, 00:12:27 von Boguś z Polska »

Offline Boguś z Polska

  • Aktive User
  • *
  • Beiträge: 6
Re: Okapi: Eigene Koordinaten fehlen
« Antwort #7 am: 31. Januar 2014, 00:10:07 »
And another news (sorry for two posts in a row).

OKAPI has been updated to return user coordinates in GPX and Garmin (ZIP) files. No other changes need to be performed, but read docs here and see this change.

Moreover, new method save_personal_notes has been introduced.

You should merge latest changes (at least up to revision 973) to oc.de.

I case of questions - just ask :)

Offline AlfredSK

  • Micro
  • ***
  • Beiträge: 165
Re: Okapi: Eigene Koordinaten fehlen
« Antwort #8 am: 31. Januar 2014, 00:50:45 »
I haven't found user's menu, which holds lot of  useful options. Moreover, I think you are missing the map, something which is very crucial for our users.
Hello,
there is a menu at the top too. :-) User's menu = Mein Profil (.../myhome.php) and Map = Karte (.../map2.php)

Happy caching!

Offline ra_sch

  • Micro
  • ***
  • Beiträge: 273
Re: Okapi: Eigene Koordinaten fehlen
« Antwort #9 am: 02. Februar 2014, 13:09:20 »
And another news (sorry for two posts in a row).

OKAPI has been updated to return user coordinates in GPX and Garmin (ZIP) files. No other changes need to be performed, but read docs here and see this change.

Moreover, new method save_personal_notes has been introduced.

You should merge latest changes (at least up to revision 973) to oc.de.

I case of questions - just ask :)
Thanks for the info! Unfortunately this doesn't help too much, as we don't use the GPX, but the XML formatter (as this allows for a more fine-grained control of the data we get). Hopefully the can move into the normal 'caches' method as well.

ra_sch

Offline Boguś z Polska

  • Aktive User
  • *
  • Beiträge: 6
Re: Okapi: Eigene Koordinaten fehlen
« Antwort #10 am: 04. Februar 2014, 23:15:32 »
I'm not sure how to understand your post. OKAPI GPX formatter, as well as geocache method return user coordinates, but for geocache method, this is attached as user-coords alternate waypoint: see docs.

Offline ra_sch

  • Micro
  • ***
  • Beiträge: 273
Re: Okapi: Eigene Koordinaten fehlen
« Antwort #11 am: 05. Februar 2014, 07:23:22 »
I'm not sure how to understand your post. OKAPI GPX formatter, as well as geocache method return user coordinates, but for geocache method, this is attached as user-coords alternate waypoint: see docs.
Thanks for pointing me there! That's perfekt for us (as soon as oc.de upgrades to this OKAPI version...)

Offline Boguś z Polska

  • Aktive User
  • *
  • Beiträge: 6
Re: Okapi: Eigene Koordinaten fehlen
« Antwort #12 am: 06. Februar 2014, 22:23:44 »
I'm glad to hear this :)