Rewrite of GetOldest() February 14, 2017 01:56PM |
Admin Registered: 8 years ago Posts: 800 |
SELECT * FROM geocaches ORDER BY hidden, cacheId LIMIT xIn other words, for those who don't speak SQL. It fetches limit geocaches ordered by the hidden date, and then the cache-id.
SELECT MAX (hidden) FROM geocaches ORDER BY hidden LIMIT x
SELECT * FROM geocaches WHERE hidden <= maxHidden ORDER BY hidden(no limit).
Re: Rewrite of GetOldest() February 14, 2017 02:31PM |
Registered: 8 years ago Posts: 60 |
Re: Rewrite of GetOldest() February 14, 2017 03:15PM |
Registered: 8 years ago Posts: 650 |
Re: Rewrite of GetOldest() February 14, 2017 03:52PM |
Admin Registered: 8 years ago Posts: 800 |
Re: Rewrite of GetOldest() February 14, 2017 04:22PM |
Admin Registered: 8 years ago Posts: 800 |
Re: Rewrite of GetOldest() February 14, 2017 06:26PM |
Registered: 8 years ago Posts: 650 |
Re: Rewrite of GetOldest() February 14, 2017 08:48PM |
Admin Registered: 8 years ago Posts: 800 |
Re: Rewrite of GetOldest() February 14, 2017 09:04PM |
Registered: 8 years ago Posts: 650 |
Re: Rewrite of GetOldest() February 14, 2017 10:02PM |
Admin Registered: 8 years ago Posts: 800 |
finds = GetFinds() foundGccodes = [] foreach(finds as find) { if foundGccodes[find.gccode] == nil { foundGccodes[find.gccode] = find } } states = conf.states // all 50 of them statesCompleted = 0 foreach(states as state) { params = {limit: 1, excludeDisabled: true, excludeArchived: true, country = 'US', region: state} oldest = GetOldest(params) foreach(oldest as old) { if(isset(foundGccodes[old])) { statesCompleted++ } } } if(statesCompleted >= 10) { ok = true } else { ok = false }
Re: Rewrite of GetOldest() February 15, 2017 12:40AM |
Registered: 8 years ago Posts: 650 |
Re: Rewrite of GetOldest() February 15, 2017 09:33AM |
Admin Registered: 8 years ago Posts: 800 |
Re: Rewrite of GetOldest() February 14, 2017 09:13PM |
Registered: 8 years ago Posts: 650 |
Re: Rewrite of GetOldest() February 14, 2017 09:50PM |
Admin Registered: 8 years ago Posts: 800 |
Re: Rewrite of GetOldest() February 15, 2017 12:03AM |
Registered: 8 years ago Posts: 650 |
Re: Rewrite of GetOldest() February 15, 2017 09:46AM |
Admin Registered: 8 years ago Posts: 800 |
Re: Rewrite of GetOldest() February 15, 2017 03:21PM |
Registered: 8 years ago Posts: 650 |
Re: Rewrite of GetOldest() February 15, 2017 10:59PM |
Admin Registered: 8 years ago Posts: 800 |
Re: Rewrite of GetOldest() February 16, 2017 12:03PM |
Registered: 8 years ago Posts: 650 |
Re: Rewrite of GetOldest() February 16, 2017 12:55PM |
Admin Registered: 8 years ago Posts: 800 |
Re: Rewrite of GetOldest() February 18, 2017 05:36PM |
Admin Registered: 8 years ago Posts: 800 |