regoarrarr

Okay I think it's fixed. Actually this new page layout makes things much cleaner on my end :-). I also have to thank my friend Mike Haboustak, for providing me the Parser code that is so much better than the crap I was using - it made changing things SO much easier. I mention his name of course, just so that when he does a Google Search on his name, this page will come up . Let me know if there are any bugs that I missed.

With the new format of the cache detail pages, the stats page is not accepting any new logs. This is just due to things being moved around. I'm working on it, and hope to have it fixed soon. I'm not sure how many (if any) logs might have been missed, so in a worst-case scenario, you may have to enter in missing logs for the past day or 2 (if you have any) on the Missing Logs page. I will post here on this thread when it is fixed. dan.

185 found, 10 hidden. But, one of those was a 13-stage multi, so should that count as 13?

185 found, 10 hidden. But, one of those was a 13-stage multi, so should that count as 13?

185 found, 10 hidden. But, one of those was a 13-stage multi, so should that count as 13?

No, no, no, not just as much fun. You must mean *almost* as much fun

No, no, no, not just as much fun. You must mean *almost* as much fun

416 from Madeira (Cincinnati) Ohio

If you've entered in the ID numbers on the Missing Logs page and they're still not updating, let me know the ID numbers via email and I"ll take a look at it.

Yeah you're right. I didn't really think about it. I was just kind of thinking of just getting the actual raw results. As mentioned in my earlier post, I realize that I'm not an expert SQL programmer of any means, so I appreciate you helping me out in seeing the error of my ways....

Now, I don't consider myself to be an SQL expert by any means, but I don't understand why the nearest caches query is so complex. Using the stats database, I ran the query: select id,title,lat,lon,69.16*acos(((sin(3.14*lat/180))*(sin(3.14*39.18/180)))+((cos(lat*3.14/180))*(cos(3.14*39.18/180))*cos((lon+84.34)*3.14/180)))*180/3.14 as val from caches order by val limit 5g which gave me: | id | title | lat | lon | val | +-------+------------------------------+-----------+------------+------------+ | 13051 | Above The Falls II | 39.1695 | -84.337633 | 0.73719160 | | 12639 | Target #1: Madeira | 39.182717 | -84.360717 | 1.12671885 | | 11711 | Joe "Garage"iola 2 | 39.201033 | -84.370483 | 2.18799560 | | 13173 | Save the Universe: Air | 39.21045 | -84.3098 | 2.65641235 | | 15749 | Stewart's Stash | 39.183117 | -84.393833 | 2.89479859 | +-------+------------------------------+-----------+------------+------------+ That query may seem complex, but that's just a bit of sining and cosining in there - I wouldn't think that it would cause too much strain on things. And using proper indices and such should make it even easier. But like I said, I'm not really a database expert - so if you tell me that's how you run it and that causes DB strain then I'll believe you. Anyway this topic is one that interests me so I thought I'd share my 2 cents.

Mario's Tower - World's most Difficult Geocache

Couple of ones I hit while out in Utah are right off I-80 east of Salt Lake City. http://www.geocaching.com/seek/cache_details.asp?ID=22490 is right off the highway. http://www.geocaching.com/seek/cache_details.asp?ID=3342 is a bit further off but not too far. I'm sure there are others near I-80 that I never got a chance to hit - try http://www.brillig.com/geocaching/salt_lake_city.shtml

Minutewar - www.minutewar.org Geodashing - www.geodashing.org

My multi-cache Mario's Tower was hidden on Aug. 16th, and DLiming and crew have been working on it pretty non-stop for a week and a half and haven't quite finished it yet.

Strangely enough, that movie was just on TBS this evening. Crazy, huh?

Strangely enough, that movie was just on TBS this evening. Crazy, huh?

Email me with the ID numbers and I'll take a look. dan at insidecorner dot com

Putting the ID number in the Missing Logs page should also work for missing hidden caches.

Mario's Tower has some of that

Fixed it Jeepster!

Yes - leprechauns is correct. All you need to do is put in the Cache ID number of the cache that has a missing log and it will re-load that page and (theoretically) pick up your log. As far as changing log types and deleting logs, my site has a bit of a limitation. If you delete a log it won't delete from my site. Similarly if you change a log type or log date it will still show the old one (though if you go through the Missing Logs page it will pick up the new one). I guess the next thing to do would be to, when I re-load a cache page to delete from my database those logs that don't show up on the cache page. But that's a job for later...

Guys I made an update to the stats page www.insidecorner.com/geocaching/stats/ There is now a Missing Logs page. If my site is missing a cache log for you, you caan go to that pageand put in the ID number. Then I will re-request the information from www.geocaching.com for that page, which should clear up most problems. Combined usernames will still need to be handled by me via email.

Madeira, Oh - suburb of Cincinnati

Well if you keep a thread up long enough, eventually I'll see it. The most southern cache was http://www.geocaching.com/seek/cache_details.asp?ID=24853 (now archived) Now it's http://www.geocaching.com/seek/cache_details.asp?ID=10393 (virtual) the most southern physical cache is at: http://www.geocaching.com/seek/cache_details.asp?ID=431 which is in New Zealand. The most northern cache is the one named above in this thread - As north as it gets. Thus ends your local stats update