Okapi: Eigene Koordinaten fehlen

Hier geht es um die Programmierung von Opencaching.de - User mit Erfahrungen im Bereich PHP, MySQL, HTML, JavaScript, CSS werden hier ständig gesucht
Antworten
Bananeweizen
Nano
Nano
Beiträge: 97
Registriert: 18.02.2013, 13:18

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
Benutzeravatar
bohrsty
Administrator
Administrator
Beiträge: 1367
Registriert: 30.03.2012, 22:54

[quote="Bananeweizen"]
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
[/quote]

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":

Code: Alles auswählen

  # 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)

Bild
Boguś z Polska

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 ([url=http://code.google.com/p/opencaching-api/source/detail?r=947]rev. 947[/url]). 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.
Benutzeravatar
bohrsty
Administrator
Administrator
Beiträge: 1367
Registriert: 30.03.2012, 22:54

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/OpencachingDeutschla ... inates.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)

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

[quote="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.[/quote]

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)
Boguś z Polska

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
Du hast keine ausreichende Berechtigung, um die Dateianhänge dieses Beitrags anzusehen.
Zuletzt geändert von Boguś z Polska am 31.01.2014, 00:12, insgesamt 1-mal geändert.
Boguś z Polska

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 [url=http://opencaching.pl/okapi/services/caches/formatters/gpx.html#arg_location_source]docs here[/url] and see [url=http://code.google.com/p/opencaching-pl/source/diff?spec=svn5639&old=5539&r=5639&format=unidiff&path=%2Ftrunk%2Flib%2Fsearch.zip.inc.php]this change[/url].

Moreover, new method [url=http://opencaching.pl/okapi/services/caches/save_personal_notes.html]save_personal_notes[/url] has been introduced.

You should merge latest changes (at least up to [url=http://code.google.com/p/opencaching-api/source/detail?r=973]revision 973[/url]) to oc.de.

I case of questions - just ask :)
AlfredSK

[quote="Boguś z Polska"]
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.[/quote]
Hello,
there is a menu at the top too. :-) User's menu = Mein Profil (.../myhome.php) and Map = Karte (.../map2.php)

Happy caching!
Benutzeravatar
ra_sch
Micro
Micro
Beiträge: 273
Registriert: 07.10.2012, 21:06

[quote="Boguś z Polska"]
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 [url=http://opencaching.pl/okapi/services/caches/formatters/gpx.html#arg_location_source]docs here[/url] and see [url=http://code.google.com/p/opencaching-pl/source/diff?spec=svn5639&old=5539&r=5639&format=unidiff&path=%2Ftrunk%2Flib%2Fsearch.zip.inc.php]this change[/url].

Moreover, new method [url=http://opencaching.pl/okapi/services/caches/save_personal_notes.html]save_personal_notes[/url] has been introduced.

You should merge latest changes (at least up to [url=http://code.google.com/p/opencaching-api/source/detail?r=973]revision 973[/url]) to oc.de.

I case of questions - just ask :)
[/quote]
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
Boguś z Polska

I'm not sure how to understand your post. OKAPI GPX formatter, as well as geocache method return user coordinates, but for [url=http://opencaching.pl/okapi/services/caches/geocache.html]geocache[/url] method, this is attached as user-coords alternate waypoint: [url=http://opencaching.pl/okapi/services/caches/geocache.html#ret_alt_wpts]see docs[/url].
Benutzeravatar
ra_sch
Micro
Micro
Beiträge: 273
Registriert: 07.10.2012, 21:06

[quote="Boguś z Polska"]
I'm not sure how to understand your post. OKAPI GPX formatter, as well as geocache method return user coordinates, but for [url=http://opencaching.pl/okapi/services/caches/geocache.html]geocache[/url] method, this is attached as user-coords alternate waypoint: [url=http://opencaching.pl/okapi/services/caches/geocache.html#ret_alt_wpts]see docs[/url].
[/quote]
Thanks for pointing me there! That's perfekt for us (as soon as oc.de upgrades to this OKAPI version...)
Boguś z Polska

I'm glad to hear this :)
Antworten