Coding standards
Security in ResourceSpace
Developer reference
- Project structure
- Database schema
- Fixed list fields
- Debugging ResourceSpace
- Writing your own plugins
- Context help links
- Custom fields ("user" defined)
- Query caching
- All user permissions
- Client side API calls
- Modals
- Sending user notifications
- Progressive Web App
- Managing (PHP) code dependencies
- Managing (JS) code dependencies
- OpenAPI documentation
- Automated Testing
Database
- Table: activity_log
- Table: annotation
- Table: annotation_node
- Table: api_log
- Table: collection
- Table: collection_keyword
- Table: collection_log
- Table: collection_resource
- Table: collection_savedsearch
- Table: comment
- Table: daily_stat
- Table: dash_tile
- Table: dynamic_tree_node
- Table: external_access_keys
- Table: filter
- Table: filter_rule
- Table: filter_rule_node
- Table: ip_lockout
- Table: job_queue
- Table: keyword
- Table: keyword_related
- Table: mail_log
- Table: message
- Table: node
- Table: node_keyword
- Table: plugins
- Table: preview_size
- Table: report
- Table: report_periodic_emails
- Table: report_periodic_emails_unsubscribe
- Table: request
- Table: research_request
- Table: resource
- Table: resource_alt_files
- Table: resource_custom_access
- Table: resource_dimensions
- Table: resource_keyword
- Table: resource_log
- Table: resource_node
- Table: resource_related
- Table: resource_type
- Table: resource_type_field
- Table: resource_type_field_resource_type
- Table: search_log
- Table: site_text
- Table: slideshow
- Table: sysvars
- Table: tab
- Table: user
- Table: user_collection
- Table: user_dash_tile
- Table: user_message
- Table: user_preferences
- Table: user_rating
- Table: user_report
- Table: user_userlist
- Table: usergroup
- Table: usergroup_collection
- Table: usergroup_dash_tile
User api session functions
Geolocation functions
update_country_coords()
Description
Fill missing resource geolocation from a resolved country coordinate pair.Parameters
| Column | Type | Default | Description |
|---|---|---|---|
| $refs | array | Resource IDs to update in bounded batches. | |
| $latlong | array | Latitude and longitude, or an empty array for an unknown country. |
Return
| void |
Location
include/geolocation_functions.php lines 57 to 69
Definition
function update_country_coords($refs, $latlong)
{
if (count($latlong) == 2) {
$chunks = array_chunk($refs, SYSTEM_DATABASE_IDS_CHUNK_SIZE);
foreach ($chunks as $chunk) {
ps_query(
"UPDATE resource SET geo_lat= ?, geo_long= ? WHERE ref IN (" . ps_param_insert(count($chunk)) . ")
AND (geo_lat IS NULL OR geo_long IS NULL)",
array_merge(['d', $latlong[0], 'd', $latlong[1]], ps_param_fill($chunk, 'i'))
);
}
}
}
This article was last updated 11th November 2026 19:05 Europe/London time based on the source file dated 11th November 2026 14:55 Europe/London time.