To sort posts numerically we need to get their number This is everything up to the "_", converted to an int

How many people have verified this pin?

Note: This function is for administrators to view the state of the map as a whole, and is not intended for user-use

Records than an IP has marked a camera, tracks frequency so we can detect anyone abusing the map and marking cameras everywhere.

Returns distance in meters between two GPS coordinates This implementation of the Haversine formula gratefully taken from Stack Overflow: https://stac

Returns whether an IP address is close enough to a latitude longitude that it's feasible their location is correct.

Returns if a mark should be blocked because the IP Address was abusive

Adds an account to the database, and locks the file so we cannot add multiple accounts at the same time and corrupt the database

If there are no pins close by then add a new one, otherwise verify the existing pin at that location

This is the only regularly called external method. It backs up pins each hour and rotates backups when appropriate.

Triggers a removal of all old pins Should be run periodically to purge outdated data

For now we ignore the radius. Later we can use it as an upper bound and ignore pins that are too far away for the user to care For now we'll just retu

Returns a Points object or nil if user doesn't exist

Return timestamps from every verification

Removes any verifications by debug accounts. This is useful for situations where we *must* test on production servers, such as getting Apple testers t

Removes older verifications, so that forgotten pins will slowly fade away Basically we check if the timestamp is older than an arbitrary number of day

Remove all records old enough that they don't matter. What "matters" is defined by some constants, but it's around "IP records for the last five minut

Attempts to remove any verifications by a particular user returns true if any verifications removed, false otherwise

Searches for pins near the desired location, asks them to unverify the given username. Stops after one success. Returns true if unverification complet

A new user wants to verify this pin! See if they already have. If new verification then add them and return true. If already verified then do nothing

Returns (latitude, longitude) if address is valid Returns (nil, nil) if we can't resolve it

Hides usernames so we can check if a user has verified a particular pin We use SHA2 here for performance. It's already an O(n) operation to check if t

Creates a new blank score database if none exists

Set up empty databases if they don't exist yet