GeocacherCounts [Scope=Filter|Database|All] [Days=0] [Action=OK|Total]
This command emulates the GUI option "Geocaching.com access=>Update Geocacher find and hide counts".
Scope - Optional, defaults to "Filter". Corresponds to the "in" radio buttons on the dialog (hopefully the corresponding values are obvious)
Days - Optional, defaults to "0". Corresponds to the "Only update if..." section on the dialog
Action - Optional, default to "OK". Corresponds to the "OK" or "Total" button on the dialog. Use "OK" to actually process the dialog and fetch the updates. Use "Total" when you only want to know the total and not actually run the update yet. Note: As this is a macro, the action won't actually halt the macro with the totals dialog. Instead the action will merely add a record to the "History" table. So if you actually wanted to fetch the total in your macro to display or make some other decision then you would follow that line of code with something like:
$Total = Sqlite("sql","select h2 from History order by hdate desc limit 1","") |
By sorting on descending date we get the most current entry in the database first (the one we just added). The "Limit 1" then makes sure we fetch just the first record. This table has an index on hDate so this query will be fully optimized (that is, *very* quick even if there are many records in this table)