prefix . 'sota_magic_locations';
// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared
$sota_cache_table_safe = esc_sql( $sota_cache_table );
$sota_cached_entries = $wpdb->get_results( "SELECT cache_key, lat, lon, source, cached_at FROM {$sota_cache_table_safe} WHERE source NOT IN ('sota','pota') ORDER BY cache_key ASC" ); // phpcs:ignore PluginCheck.Security.DirectDB.UnescapedDBParameter -- table name sanitized via esc_sql()
// phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared
$sota_cache_count = count( $sota_cached_entries );
?>
When your contact map loads, the plugin looks up each callsign’s location via QRZ, Callook, or HamQTH and stores the result locally. Locations are cached permanently so the map reflects where each station was at the time of your activation, even if they’ve moved since. Summit and park coordinates are cached separately for 90 days and are not listed here.
✓ Changes on this page take effect immediately. No Save button needed. Deleting an entry or clearing all cached locations happens the moment you click.
Cached Callsign Locations
callsign location(s) cached.
0 ) : ?>
| Callsign |
Source |
Lat / Lon |
Cached |
|
'Callook', 'hamqth' => 'HamQTH', 'qrz' => 'QRZ' ];
foreach ( $sota_cached_entries as $sota_entry ) :
$sota_callsign = preg_replace( '/^(loc_|qrz_)/', '', $sota_entry->cache_key );
$sota_cached_date = $sota_entry->cached_at ? gmdate( 'Y-m-d', strtotime( $sota_entry->cached_at ) ) : '-';
?>
|
source ] ?? $sota_entry->source ); ?> |
lat, 4 ) ); ?>, lon, 4 ) ); ?> |
|
|
No entries match your filter.
No callsign locations are currently cached.
Clear All Cached Locations
⚠ Nuclear option: Wipes all cached callsign locations site-wide. The next time any contact map loads, every contact without a grid square or summit/park reference will trigger a fresh lookup. Only use this if you believe cached locations are incorrect.