Coding standards
Security in ResourceSpace
Developer reference
Database
- Table: activity_log
- Table: annotation
- Table: annotation_node
- 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_data
- 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
Action functions
Admin functions
Ajax functions
Annotation functions
API functions
Collections functions
- get_user_collections()
- get_collection()
- get_collection_resources()
- get_collection_resources_with_data()
- add_resource_to_collection()
- remove_resource_from_collection()
- collection_writeable()
- collection_readable()
- set_user_collection()
- create_collection()
- delete_collection()
- refresh_collection_frame()
- search_public_collections()
- do_collections_search()
- add_collection()
- remove_collection()
- index_collection()
- save_collection()
- get_max_theme_levels()
- get_theme_headers()
- themes_comparator()
- collections_comparator()
- collections_comparator_desc()
- get_themes()
- get_smart_theme_headers()
- get_smart_themes_nodes()
- email_collection()
- generate_collection_access_key()
- get_saved_searches()
- add_saved_search()
- remove_saved_search()
- add_smart_collection()
- get_search_title()
- add_saved_search_items()
- allow_multi_edit()
- get_theme_image()
- swap_collection_order()
- update_collection_order()
- get_collection_resource_comment()
- save_collection_resource_comment()
- relate_to_collection()
- get_mycollection_name()
- get_collection_comments()
- send_collection_feedback()
- copy_collection()
- collection_is_research_request()
- add_to_collection_link()
- change_collection_link()
- get_collection_external_access()
- delete_collection_access_key()
- collection_log()
- get_collection_log()
- get_collection_videocount()
- collection_max_access()
- collection_min_access()
- collection_set_public()
- collection_set_private()
- collection_set_themes()
- remove_all_resources_from_collection()
- get_home_page_promoted_collections()
- is_collection_approved()
- edit_collection_external_access()
- show_hide_collection()
- get_session_collections()
- update_collection_user()
- compile_collection_actions()
- makeFilenameUnique()
- new_featured_collection_form()
- get_last_resource_edit()
- GetThemesFromRequest()
- collection_download_get_archive_file()
- collection_download_use_original_filenames_when_downloading()
- collection_download_process_text_file()
- collection_download_log_resource_ready()
- update_zip_progress_file()
- collection_download_process_data_only_types()
- collection_download_process_summary_notes()
- collection_download_process_csv_metadata_file()
- collection_download_process_command_to_file()
- collection_download_process_collection_download_name()
- collection_download_process_archive_command()
- collection_download_clean_temp_files()
- collection_cleanup_inaccessible_resources()
- relate_all_collection()
- update_collection_type()
- get_user_selection_collection()
- delete_old_collections()
- save_themename()
- get_featured_collection_resources()
- get_featured_collection_categ_sub_fcs()
- generate_featured_collection_image_urls()
- update_collection_parent()
- get_featured_collections()
- featured_collections_permissions_filter_sql()
- featured_collection_check_access_control()
- order_featured_collections_by_hasresources()
- get_featured_collection_categories()
- is_featured_collection_category()
- is_featured_collection_category_by_children()
- validate_collection_parent()
- get_featured_collection_category_branch_by_leaf()
- process_posted_featured_collection_categories()
- get_featured_collection_ref_by_name()
- allow_collection_share()
- allow_featured_collection_share()
- filter_featured_collections_by_root()
- get_featured_collections_by_resources()
- can_delete_featured_collection()
- order_featured_collections()
- strip_prefix_chars()
- allow_upload_to_collection()
- get_all_featured_collections()
- compute_featured_collections_acess_control()
- compute_featured_collections_access_control()
- cleanup_anonymous_collections()
- can_share_upload_link()
- can_edit_upload_share()
- create_upload_link()
- generate_share_key()
- upload_share_active()
- upload_share_setup()
- external_upload_notify()
- purge_expired_shares()
- can_delete_collection()
- move_featured_collection_branch_path_root()
- send_collection_to_admin()
- collection_add_resources()
- collection_remove_resources()
- get_default_user_collection()
- can_reorder_featured_collections()
- reorder_collections()
- update_smart_collection()
- check_upload_terms()
- unrelate_all_collection()
- reorder_all_featured_collections_with_parent()
Comment functions
Config functions
- validate_field()
- render_select_option()
- render_bool_option()
- render_text_option()
- set_config_option()
- get_config_option()
- get_config_option_users()
- get_config_options()
- process_config_options()
- config_clean()
- config_html()
- config_add_html()
- config_text_input()
- config_add_text_input()
- config_file_input()
- config_colouroverride_input()
- config_add_file_input()
- config_single_select()
- config_add_single_select()
- config_boolean_select()
- config_add_boolean_select()
- config_checkbox_select()
- config_add_checkbox_select()
- config_add_colouroverride_input()
- config_add_single_ftype_select()
- config_single_ftype_select()
- config_generate_AutoSaveConfigOption_function()
- config_process_file_input()
- config_generate_html()
- config_merge_non_image_types()
- get_header_image()
- config_register_core_fieldvars()
- config_add_hidden_input()
- config_register_core_field_refs()
- checkValidExtension()
- override_rs_variables_by_eval()
- remove_config_option()
- update_resource_type_field_resource_types()
- get_resource_type_field_resource_types()
- create_resource_type()
- save_resource_type()
- rs_get_resource_type()
- save_resource_type_field()
- get_resource_type_field_columns()
- delete_config_option()
- set_maxNumberOfFiles()
- clear_restype_cache()
- is_valid_contact_sheet_preview_size()
- check_removed_ui_config()
CSV export functions
Dash functions
- create_dash_tile()
- update_dash_tile()
- delete_dash_tile()
- revoke_all_users_flag_cascade_delete()
- append_default_position()
- reorder_default_dash()
- update_default_dash_tile_order()
- get_tile()
- all_user_dash_tile_active()
- existing_tile()
- cleanup_dash_tiles()
- checkTileConfig()
- checkConfigCustomHomePanels()
- get_alluser_available_tiles()
- get_default_dash()
- deleteDefaultDashTile()
- updateDashTileOrder()
- get_managed_dash()
- add_usergroup_dash_tile()
- append_usergroup_position()
- reorder_usergroup_dash()
- update_usergroup_dash_tile_order()
- build_usergroup_dash()
- get_tile_user_groups()
- get_usergroup_available_tiles()
- get_usergroup_tile()
- add_user_dash_tile()
- get_user_tile()
- create_new_user_dash()
- update_user_dash_tile_order()
- delete_user_dash_tile()
- empty_user_dash()
- reorder_user_dash()
- append_user_position()
- get_user_available_tiles()
- get_user_dash()
- deleteDashTile()
- render_delete_dialog_JS()
- parse_dashtile_link()
- build_dash_tile_list()
- allow_tile_colour_change()
- render_dash_tile_colour_chooser()
- update_tile_preview_colour()
- get_tile_custom_style()
- delete_usergroup_dash_tile()
- allowPromotedResources()
- render_upgrade_available_tile()
- generate_dash_tile_toolbar()
- existing_dash_tile()
- dash_tile_featured_collection_get_resources()
- validate_tile_style()
- validate_build_url()
- tltype_srch_generate_js_for_background_and_count()
- get_dash_search_data()
- can_edit_tile()
Debug functions
Encryption functions
Facial recognition functions
File functions
- get_checksum()
- is_safe_basename()
- is_valid_rs_path()
- validate_temp_path()
- validate_resource_files()
- is_valid_upload_path()
- is_banned_extension()
- remove_empty_temp_directory()
- rrmdir()
- check_valid_file_extension()
- temp_local_download_remote_file()
- isPathWhitelisted()
- generateUserFilenameUID()
- safe_file_name()
General functions
- getval()
- getuid()
- escape_check()
- unescape()
- nicedate()
- redirect()
- trim_spaces()
- trim_array()
- tidylist()
- tidy_trim()
- average_length()
- get_stats_activity_types()
- get_stats_years()
- newlines()
- get_all_site_text()
- get_site_text()
- check_site_text_custom()
- save_site_text()
- string_similar()
- formatfilesize()
- filesize2bytes()
- get_mime_type()
- send_mail()
- send_mail_phpmailer()
- log_mail()
- rs_quoted_printable_encode()
- rs_quoted_printable_encode_subject()
- pager()
- send_statistics()
- remove_extension()
- verify_extension()
- get_allowed_extensions()
- get_allowed_extensions_by_type()
- getAbsolutePath()
- getFolderContents()
- mb_basename()
- strip_extension()
- is_process_lock()
- set_process_lock()
- clear_process_lock()
- filesize_unlimited()
- strip_leading_comma()
- convert()
- get_temp_dir()
- convert_path_to_url()
- escape_command_args()
- run_command()
- run_external()
- error_alert()
- xml_entities()
- get_xml_entity_at_index_0()
- sanitize_char()
- format_display_field()
- format_string_more_link()
- sortmulti()
- draw_performance_footer()
- sql_affected_rows()
- get_imagemagick_path()
- get_utility_path()
- get_executable_path()
- truncate_cache_arrays()
- txt2html()
- is_html()
- rs_setcookie()
- get_editable_states()
- validate_html()
- generateURL()
- tail()
- move_array_element()
- emptyiszero()
- array_column()
- get_slideshow_files_data()
- form_value_display()
- job_queue_add()
- job_queue_update()
- job_queue_delete()
- job_queue_get_jobs()
- job_queue_run_job()
- user_set_usergroup()
- generateSecureKey()
- IsModal()
- generateCSRFToken()
- isValidCSRFToken()
- generateFormToken()
- generateAjaxToken()
- enforcePostRequest()
- findDuplicates()
- is_resourcespace_upgrade_available()
- get_recent_users()
- check_script_last_ran()
- count_errors()
- search_array_by_keyvalue()
- bypass_permissions()
- set_sysvar()
- get_sysvar()
- hook()
- strip_tags_and_attributes()
- show_pagetime()
- get_debug_log_dir()
- debug()
- rcRmdir()
- daily_stat()
- pagename()
- text()
- get_section_list()
- resolve_user_agent()
- get_ip()
- ResolveKB()
- trim_filename()
- job_queue_get_job()
- job_queue_purge()
- get_inner_html_from_tag()
- array_flip_by_value_key()
- reshape_array_by_value_keys()
- permission_j()
- permission_negative_j()
- cleanup_files()
- is_int_loose()
- ip_matches()
- set_unique_filename()
- build_permission()
- validate_remote_code()
- get_system_status()
- allowed_type_mime()
- try_unlink()
- check_filestore_browseability()
- check_imagemagick_cli_version_found()
- check_numeric_cli_version_found()
- check_utility_cli_version_found_by_name()
- command_line_only()
- prefix_value()
- generate_csrf_js_object()
- strip_paragraph_tags()
- set_order_by_to_zero()
- try_getimagesize()
- execution_lockout_remove_resource_type_field_props()
- is_positive_int_loose()
- compute_dpi()
- compute_megapixel()
- is_jpeg_extension()
- get_total_approved_users()
- get_total_resources()
- getCertificateExpiry()
- validate_sort_value()
- js_call_CentralSpaceLoad()
- isValidCssColor()
- generateConsistentColour()
- hslToRgb()
Language functions
- ucfirstletter()
- lang_or_i18n_get_translated()
- i18n_get_translated()
- i18n_get_collection_name()
- i18n_get_indexable()
- i18n_get_translations()
- str_replace_formatted_placeholder()
- ucfirstletter_callback()
- normalize_keyword()
- remove_accents()
- seems_utf8()
- http_get_preferred_language()
- setLanguage()
- lang_load_site_text()
- i18n_get_all_translations()
- i18n_merge_translations()
- get_display_language()
Log functions
Login functions
Message functions
- system_notification()
- message_get()
- message_add()
- message_remove()
- message_seen()
- message_unseen()
- message_seen_all()
- message_purge()
- message_send_unread_emails()
- message_remove_related()
- message_user_remove()
- message_get_conversation()
- send_user_message()
- message_deleteselusrmsg()
- message_selectedseen()
- message_selectedunseen()
- message_getrefs()
- send_user_notification()
- get_user_message()
- send_integrity_failure_notices()
- build_specialsearch_list_urls()
Migration functions
Node functions
- set_node()
- delete_node()
- delete_nodes_for_resource_type_field()
- get_node()
- is_parent_node()
- get_tree_node_level()
- get_root_node_by_leaf()
- reorder_node()
- reorder_nodes()
- render_new_node_record()
- get_node_order_by()
- draw_tree_node_table()
- node_field_options_override()
- add_node_keyword()
- remove_node_keyword()
- remove_all_node_keyword_mappings()
- check_node_indexed()
- add_node_keyword_mappings()
- remove_node_keyword_mappings()
- add_resource_nodes()
- add_resource_nodes_multi()
- get_resource_nodes()
- delete_resource_nodes()
- delete_resource_nodes_multi()
- delete_all_resource_nodes()
- copy_resource_nodes()
- get_nodes_from_keywords()
- update_resource_node_hitcount()
- copy_resource_type_field_nodes()
- get_parent_nodes()
- get_nodes_count()
- extract_node_options()
- get_node_by_name()
- get_node_id()
- node_name_comparator()
- node_orderby_comparator()
- get_node_elements()
- get_node_tree()
- get_tree_strings()
- compute_node_branch_path()
- compute_nodes_by_parent()
- get_resource_nodes_batch()
- get_nodes_by_refs()
- process_node_search_syntax_to_names()
- delete_unused_non_fixed_list_nodes()
- remove_invalid_node_keyword_mappings()
- get_nodes_use_count()
- check_delete_nodes()
- remove_field_keywords()
- get_cattree_nodes_ordered()
- get_cattree_node_strings()
- cattree_node_creator()
- cattree_node_flatten()
- get_resources_nodes_by_rtf()
- get_node_strings()
- order_tree_nodes()
- add_sql_node_language()
- migrate_fixed_to_text()
- cleanup_invalid_nodes()
- get_all_parents_by_leaf()
- get_all_ancestors_for_node()
- delete_node_resources()
- remove_invalid_resource_node_mappings()
- update_node_active_state()
- toggle_active_state_for_nodes()
- toggle_category_tree_nodes_active_state()
- node_is_active()
- get_nodes()
PDF functions
Plugin functions
- activate_plugin()
- deactivate_plugin()
- purge_plugin_config()
- get_plugin_yaml()
- config_json_encode()
- config_encode()
- get_plugin_config()
- set_plugin_config()
- is_plugin_activated()
- handle_rsc_upload()
- display_rsc_upload()
- config_gen_setup_post()
- config_gen_setup_html()
- config_section_header()
- config_add_section_header()
- config_add_text_list_input()
- config_multi_select()
- config_add_multi_select()
- config_single_user_select()
- config_add_single_user_select()
- config_multi_user_select()
- config_add_multi_user_select()
- config_single_group_select()
- config_add_single_group_select()
- config_multi_group_select()
- config_add_multi_group_select()
- config_multi_ftype_select()
- config_add_multi_ftype_select()
- config_single_rtype_select()
- config_add_single_rtype_select()
- config_multi_rtype_select()
- config_add_multi_rtype_select()
- config_db_single_select()
- config_add_db_single_select()
- config_db_multi_select()
- config_add_db_multi_select()
- config_add_hidden()
- config_text_field()
- config_userselect_field()
- config_field_select()
- config_boolean_field()
- config_custom_select_multi()
- config_custom_select()
- get_plugin_css()
- plugin_activate_for_setup()
- include_plugin_config()
- register_plugin_language()
- get_plugin_path()
- register_plugin()
- config_multi_archive_select()
- config_add_multi_archive_select()
- plugin_encode_complex_configs()
- plugin_decode_complex_configs()
- get_active_plugins()
- register_group_access_plugins()
- RenderPlugin()
Render functions
- render_search_field()
- render_sort_order()
- render_dropdown_option()
- render_actions()
- render_user_group_multi_select()
- render_user_group_select()
- render_user_group_checkbox_select()
- render_text_question()
- render_split_text_question()
- render_dropdown_question()
- render_access_key_tr()
- is_field_displayed()
- display_multilingual_text_field()
- display_field()
- render_date_range_field()
- renderBreadcrumbs()
- renderCallToActionTile()
- renderSocialMediaShareLinksForUrl()
- renderLockButton()
- render_resource_image()
- calculate_image_display()
- render_share_options()
- render_field_selector_question()
- render_filter_bar_button()
- render_upload_here_button()
- render_trash()
- render_browse_bar()
- generate_browse_bar_item()
- render_help_link()
- render_question_div()
- render_custom_fields()
- render_selected_resources_counter()
- render_edit_selected_btn()
- render_clear_selected_btn()
- render_selected_collection_actions()
- render_user_collection_select()
- render_csrf_data_attributes()
- check_display_condition()
- has_browsebar()
- display_upload_options()
- display_field_data()
- render_resource_lock_link()
- EditNav()
- SaveAndClearButtons()
- UpdateResultOrder()
- display_size_option()
- show_upgrade_in_progress()
- render_audio_download_link()
- render_table()
- render_array_in_table_cells()
- render_new_featured_collection_cta()
- render_featured_collection_category_selector()
- render_featured_collections()
- render_featured_collection()
- DrawOption()
- render_featured_collections_category_permissions()
- render_top_page_error_style()
- render_workflow_state_question()
- render_share_password_question()
- pclick()
- pblur()
- render_question_form_helper()
- render_hidden_input()
- radio_get_layout()
- render_radio_buttons_question()
- render_message()
- render_antispam_question()
- render_fixed_text_question()
- render_fa_icon_selector()
- filterIcons()
- escape_quoted_data()
- display_related_resources()
- admin_resource_type_field_constraint()
- admin_resource_type_field_option()
- showHideResTypeSelector()
- render_resource_type_selector_question()
- add_download_column()
- escape()
- render_resource_view_image()
- is_another_tool_option_enabled()
- toggleMode()
- toggleAnnotationsOption()
- toggleImagePreviewZoomOption()
- render_resource_tools_size_download_options()
- render_fixedlist_as_pills()
- render_fixed_list_as_pills()
Reporting functions
- render_bar_graph()
- render_pie_graph()
- report_process_query_placeholders()
- report_has_thumbnail()
- report_has_date_by_id()
- report_has_date()
- get_translated_activity_type()
- unsubscribe_user_from_periodic_report()
- delete_periodic_report()
- send_periodic_report_emails()
- create_periodic_email()
- do_report()
- get_reports()
- get_report_name()
Request functions
- managed_collection_request()
- get_request()
- get_user_requests()
- save_request()
- get_requests()
- email_collection_request()
- email_resource_request()
- get_valid_custom_fields()
- gen_custom_fields_html_props()
- process_custom_fields_submission()
- can_use_owner_field()
- get_notification_users_by_owner_field()
- resource_request_visible()
Research functions
Slideshow functions
Theme permission functions
User functions
- validate_user()
- setup_user()
- get_users()
- get_users_with_permission()
- get_user_by_email()
- get_user_by_username()
- get_usergroups()
- get_usergroup()
- get_user()
- save_user()
- email_user_welcome()
- email_reset_link()
- auto_create_user_account()
- email_user_request()
- new_user()
- get_active_users()
- change_password()
- make_password()
- bulk_mail()
- get_user_log()
- resolve_userlist_groups()
- resolve_userlist_groups_smart()
- remove_groups_smart_from_userlist()
- check_password()
- resolve_users()
- check_access_key()
- check_access_key_collection()
- make_username()
- get_registration_selectable_usergroups()
- open_access_to_user()
- open_access_to_group()
- resolve_open_access()
- remove_access_to_user()
- user_email_exists()
- resolve_user_emails()
- create_password_reset_key()
- get_rs_session_id()
- get_notification_users()
- verify_antispam()
- check_share_password()
- get_users_from_permission_lookup()
- offset_user_local_timezone()
- checkPermission_anonymoususer()
- checkPermission_dashadmin()
- checkPermission_dashuser()
- checkPermission_dashmanage()
- checkPermission_dashcreate()
- checkperm()
- checkperm_user_edit()
- internal_share_access()
- save_usergroup()
- set_user_profile()
- delete_profile_image()
- get_profile_image()
- get_profile_text()
- get_languages_notify_users()
- get_upload_url()
- emulate_user()
- is_authenticated()
- get_approver_usergroups()
- get_usergroup_approvers()
- copy_usergroup_permissions()
- mark_email_as_invalid()
- check_email_invalid()
- get_users_by_permission()
- is_anonymous_user()
- get_users_by_preference()
- generate_temp_download_key()
- validate_temp_download_key()
- setup_command_line_user()
- user_limit_reached()
- can_set_admin_usergroup()
- update_user_access()
- checkPermission_manage_users()
- set_processing_message()
Video functions
Database functions
- sql_truncate_text_val()
- db_end_transaction()
- db_rollback_transaction()
- sql_query()
- sql_value()
- sql_array()
- sql_insert_id()
- get_query_cache_location()
- clear_query_cache()
- check_db_structs()
- CheckDBStruct()
- sql_limit()
- sql_is_null_or_eq_val()
- sql_null_or_val()
- sql_query_prepared()
- ps_query()
- fetch_assoc_stmt()
- copy_value()
- ps_value()
- ps_array()
- ps_param_insert()
- ps_param_fill()
- columns_in()
- sql_limit_with_total_count()
- sql_reorder_records()
- ps_fill_param_array()
- db_chunk_id_list()
- errorhandler()
- db_use_multiple_connection_modes()
- db_set_connection_mode()
- db_get_connection_mode()
- db_clear_connection_mode()
- sql_connect()
- db_begin_transaction()
Metadata functions
Resource functions
- get_resource_path()
- get_resource_data()
- put_resource_data()
- create_resource()
- update_hitcount()
- save_resource_data()
- set_resource_defaults()
- save_resource_data_multi()
- append_field_value()
- remove_keyword_mappings()
- remove_keyword_from_resource()
- add_keyword_mappings()
- add_keyword_to_resource()
- remove_all_keyword_mappings_for_field()
- update_field()
- ()
- email_resource()
- delete_resource()
- get_resource_type_field()
- get_resource_field_data()
- get_resource_field_data_batch()
- get_resource_types()
- get_resource_top_keywords()
- clear_resource_data()
- get_max_resource_ref()
- get_resource_ref_range()
- copy_resource()
- resource_log()
- get_resource_log()
- get_resource_type_name()
- get_resource_custom_access()
- get_resource_custom_access_users_usergroups()
- save_resource_custom_access()
- get_custom_access()
- get_themes_by_resource()
- update_resource_type()
- relate_to_array()
- get_exiftool_fields()
- createTempFile()
- stripMetadata()
- write_metadata()
- delete_exif_tmpfile()
- update_resource()
- import_resource()
- get_alternative_files()
- add_alternative_file()
- delete_alternative_file()
- get_alternative_file()
- save_alternative_file()
- user_rating_save()
- process_notify_user_contributed_submitted()
- notify_user_contributed_submitted()
- notify_user_contributed_unsubmitted()
- get_field()
- get_field_options_with_stats()
- save_field_options()
- get_resources_matching_keyword()
- get_keyword_from_option()
- add_field_option()
- get_resource_access()
- get_custom_access_user()
- edit_resource_external_access()
- resource_download_allowed()
- get_edit_access()
- filter_match()
- log_diff()
- get_metadata_templates()
- get_resource_collections()
- download_summary()
- check_use_watermark()
- autocomplete_blank_fields()
- get_resource_files()
- reindex_resource()
- get_page_count()
- update_disk_usage()
- update_disk_usage_cron()
- get_total_disk_usage()
- overquota()
- notify_user_resources_approved()
- get_original_imagesize()
- generate_resource_access_key()
- get_resource_external_access()
- delete_resource_access_key()
- resource_type_config_override()
- update_archive_status()
- delete_resources_in_collection()
- update_related_resource()
- can_share_resource()
- delete_resource_custom_access_usergroups()
- truncate_join_field_value()
- get_video_snapshots()
- resource_file_readonly()
- delete_resource_custom_user_access()
- get_video_info()
- copyAllDataToResource()
- copyResourceDataValues()
- copy_locked_data()
- copy_locked_fields()
- copyRelatedResources()
- process_edit_form()
- update_timestamp()
- get_extension()
- get_last_resource_edit_array()
- get_default_archive_state()
- save_original_file_as_alternative()
- replace_resource_file()
- get_resource_all_image_sizes()
- sanitize_date_field_input()
- download_link_generate_key()
- download_link_check_key()
- filter_check()
- update_resource_keyword_hitcount()
- copy_hitcount_to_live()
- get_image_sizes()
- get_preview_quality()
- get_related_resources()
- get_field_options()
- get_data_by_field()
- get_resources_by_resource_data_value()
- get_all_image_sizes()
- image_size_restricted_access()
- get_fields()
- get_hidden_indexed_fields()
- get_category_tree_fields()
- get_OR_fields()
- get_nopreview_icon()
- get_indexed_resource_type_fields()
- get_resource_type_fields()
- notify_resource_change()
- add_verbatim_keywords()
- metadata_field_edit_access()
- get_download_filename()
- get_resource_type_from_extension()
- canSeePreviewTools()
- checkPreviewToolsOptionUniqueness()
- alt_is_ffmpeg_alternative()
- create_resource_type_field()
- metadata_field_view_access()
- get_workflow_states()
- delete_resource_type_field()
- tab_names()
- get_resource_table_joins()
- update_resource_lock()
- get_resource_lock_message()
- get_resource_data_batch()
- get_external_shares()
- get_video_duration()
- relate_all_resources()
- allow_in_browser()
- update_node_hitcount_from_search()
- update_resource_field_column()
- get_all_resource_types()
- data_joins_field_value_translate_and_csv()
- process_resource_data_joins_values()
- canSeeAnnotationsFields()
- apply_resource_default()
- skip_scr_size_preview()
- related_resource_pull()
- get_resource_preview()
- check_resources()
- get_resources_to_validate()
- get_nopreview_html()
Search functions
- copy_filter()
- save_related_keywords()
- get_simple_search_fields()
- get_fields_for_search_display()
- get_filters()
- get_filter()
- get_filter_rules()
- get_filter_rule()
- save_filter()
- save_filter_rule()
- delete_filter()
- delete_filter_rule()
- get_grouped_related_keywords()
- update_search_from_request()
- get_search_default_restypes()
- get_selectedtypes()
- render_advanced_search_buttons()
- get_collections_resource_count()
- get_search_params()
- is_not_wildcard_only()
- search_title_node_processing()
- setup_search_chunks()
- log_keyword_usage()
- set_search_order_by()
- get_upload_here_selected_nodes()
- suggest_refinement()
- get_advanced_search_fields()
- get_advanced_search_collection_fields()
- search_form_to_search_query()
- refine_searchstring()
- compile_search_actions()
- search_filter()
- search_special()
- resolve_nodes_from_string()
- rebuild_specific_field_search_from_node()
- search_get_previews()
- resolve_soundex()
- get_default_search_states()
- get_filter_sql()
- split_keywords()
- cleanse_string()
- resolve_keyword()
- add_partial_index()
- highlightkeywords()
- str_highlight()
- sorthighlights()
- get_suggested_keywords()
- get_related_keywords()
Map functions
Job functions
Tab functions
Test functions
Table: keyword
A list of keywords used when indexing. With stemming enabled (the default) the stems are stored as well as the full keywords.
| Column | Type | Note |
|---|---|---|
| ref | int(11) | Auto incrementing index |
| keyword | varchar(100) | An individual word, used for indexing/searching. When stemming is enabled the word stems are also stored in this table as keywords. |
| soundex | varchar(50) | A Soundex representation of the keyword, used when suggesting searches after zero results - it can show keywords that sound similar and help correct typos. |
| hit_count | int(11) | How many times this keyword has been used within resource metadata. Used to sort keywords when suggesting alternatives to the user. |
Default contents are as follows.
| ref | keyword | soundex | hit_count |
|---|---|---|---|
| 1 | 2 | 0000 | 0 |
| 2 | my collection | M242 | 0 |
| 3 | joe smith | J253 | 0 |
| 4 | my | M000 | 0 |
| 5 | collection | C423 | 0 |
| 6 | joe | J000 | 1 |
| 7 | smith | S530 | 1 |
| 8 | woman | W550 | 1 |
| 9 | man | M500 | 15 |
| 10 | child | C430 | 1 |
| 11 | building | B435 | 1 |
| 12 | vehicle | V240 | 1 |
| 13 | animal | A554 | 3 |
| 14 | elderly | E436 | 1 |
| 15 | baby | B100 | 1 |
| 16 | boy | B000 | 1 |
| 17 | girl | G640 | 1 |
| 18 | exhibition | E213 | 1 |
| 19 | meeting | M352 | 1 |
| 20 | concert | C526 | 3 |
| 21 | festival | F231 | 1 |
| 22 | party | P630 | 1 |
| 23 | conference | C516 | 1 |
| 24 | photo | P300 | 8 |
| 25 | shoot | S300 | 1 |
| 26 | happy | H100 | 1 |
| 27 | sad | S300 | 1 |
| 28 | inspirational | I521 | 1 |
| 29 | eye | E000 | 3 |
| 30 | contact | C532 | 3 |
| 31 | thoughtful | T231 | 1 |
| 32 | family | F540 | 1 |
| 33 | group | G610 | 1 |
| 34 | product | P632 | 1 |
| 35 | employee | E514 | 1 |
| 36 | customer | C235 | 1 |
| 37 | test | T230 | 2 |
| 38 | eye contact | E253 | 2 |
| 39 | 2016 | 0000 | 2 |
| 40 | 2016-06 | 0000 | 2 |
| 41 | 2016-06-16 10:56 | 0000 | 2 |
| 42 | 17 | 0000 | 0 |
| 43 | 3 | 0000 | 0 |
| 44 | upload 20160616105637 | U143 | 0 |
| 45 | upload | U143 | 0 |
| 46 | 20160616105637 | 0000 | 0 |
| 47 | montala | M534 | 1 |
| 48 | support | S163 | 1 |
| 49 | 1 | 0000 | 1 |
| 50 | poster | P236 | 1 |
| 51 | png | P520 | 1 |
| 52 | 0 | ||
| 53 | fundraising | F536 | 1 |
| 54 | !last1000 | L230 | 0 |
| 55 | afghanistan | A125 | 14 |
| 56 | aland | A453 | 14 |
| 57 | island | I245 | 386 |
| 58 | albania | A415 | 14 |
| 59 | algeria | A426 | 14 |
| 60 | american | A562 | 14 |
| 61 | samoa | S500 | 28 |
| 62 | andorra | A536 | 14 |
| 63 | angola | A524 | 14 |
| 64 | anguilla | A524 | 14 |
| 65 | antarctica | A536 | 14 |
| 66 | antigua | A532 | 14 |
| 67 | barbuda | B613 | 14 |
| 68 | argentina | A625 | 14 |
| 69 | armenia | A655 | 14 |
| 70 | aruba | A610 | 14 |
| 71 | australia | A236 | 14 |
| 72 | austria | A236 | 14 |
| 73 | azerbaijan | A261 | 14 |
| 74 | bahama | B500 | 22 |
| 75 | bahrain | B650 | 14 |
| 76 | bangladesh | B524 | 14 |
| 77 | barbado | B613 | 22 |
| 78 | belaru | B460 | 22 |
| 79 | belgium | B425 | 14 |
| 80 | beliz | B420 | 22 |
| 81 | benin | B550 | 14 |
| 82 | bermuda | B653 | 14 |
| 83 | bhutan | B350 | 14 |
| 84 | bolivia | B410 | 14 |
| 85 | bosnia | B250 | 14 |
| 86 | herzegovina | H622 | 14 |
| 87 | botswana | B325 | 14 |
| 88 | bouvet | B130 | 14 |
| 89 | brazil | B624 | 14 |
| 90 | british | B632 | 28 |
| 91 | indian | I535 | 14 |
| 92 | ocean | O250 | 14 |
| 93 | territori | T636 | 66 |
| 94 | brunei | B650 | 14 |
| 95 | darussalam | D624 | 14 |
| 96 | bulgaria | B426 | 14 |
| 97 | burkina | B625 | 14 |
| 98 | faso | F200 | 14 |
| 99 | burundi | B653 | 14 |
| 100 | cambodia | C513 | 14 |
| 101 | cameroon | C565 | 14 |
| 102 | canada | C530 | 14 |
| 103 | cape | C100 | 14 |
| 104 | verd | V630 | 22 |
| 105 | cayman | C550 | 14 |
| 106 | central | C536 | 14 |
| 107 | african | A162 | 14 |
| 108 | republ | R114 | 286 |
| 109 | chad | C300 | 14 |
| 110 | chile | C400 | 14 |
| 111 | china | C500 | 28 |
| 112 | christma | C623 | 22 |
| 113 | coco | C200 | 22 |
| 114 | keel | K400 | 22 |
| 115 | colombia | C451 | 14 |
| 116 | comoro | C560 | 22 |
| 117 | congo | C520 | 28 |
| 118 | democrat | D526 | 66 |
| 119 | cook | C200 | 14 |
| 120 | costa | C230 | 14 |
| 121 | rica | R200 | 14 |
| 122 | côte | C300 | 14 |
| 123 | d | D000 | 14 |
| 124 | ivoir | I160 | 22 |
| 125 | croatia | C630 | 14 |
| 126 | cuba | C100 | 14 |
| 127 | cypru | C160 | 22 |
| 128 | czech | C200 | 14 |
| 129 | denmark | D562 | 14 |
| 130 | djibouti | D213 | 14 |
| 131 | dominica | D552 | 14 |
| 132 | dominican | D552 | 14 |
| 133 | ecuador | E236 | 14 |
| 134 | egypt | E213 | 14 |
| 135 | el | E400 | 14 |
| 136 | salvador | S413 | 14 |
| 137 | equatori | E236 | 22 |
| 138 | guinea | G500 | 56 |
| 139 | eritrea | E636 | 14 |
| 140 | estonia | E235 | 14 |
| 141 | ethiopia | E310 | 14 |
| 142 | falkland | F424 | 14 |
| 143 | malvina | M415 | 22 |
| 144 | faro | F600 | 22 |
| 145 | fiji | F200 | 14 |
| 146 | finland | F545 | 14 |
| 147 | franc | F652 | 22 |
| 148 | french | F652 | 42 |
| 149 | guiana | G500 | 14 |
| 150 | polynesia | P452 | 14 |
| 151 | southern | S365 | 14 |
| 152 | gabon | G150 | 14 |
| 153 | gambia | G510 | 14 |
| 154 | georgia | G620 | 28 |
| 155 | germani | G655 | 22 |
| 156 | ghana | G500 | 14 |
| 157 | gibraltar | G164 | 14 |
| 158 | greec | G620 | 22 |
| 159 | greenland | G654 | 14 |
| 160 | grenada | G653 | 14 |
| 161 | guadeloup | G341 | 22 |
| 162 | guam | G500 | 14 |
| 163 | guatemala | G354 | 14 |
| 164 | guernsei | G652 | 22 |
| 165 | bissau | B200 | 14 |
| 166 | guyana | G500 | 14 |
| 167 | haiti | H300 | 14 |
| 168 | heard | H630 | 14 |
| 169 | mcdonald | M235 | 14 |
| 170 | holi | H400 | 22 |
| 171 | see | S000 | 14 |
| 172 | vatican | V325 | 14 |
| 173 | citi | C300 | 22 |
| 174 | state | S330 | 80 |
| 175 | hondura | H536 | 22 |
| 176 | hong | H520 | 14 |
| 177 | kong | K520 | 14 |
| 178 | hungari | H526 | 22 |
| 179 | iceland | I245 | 14 |
| 180 | india | I530 | 14 |
| 181 | indonesia | I535 | 14 |
| 182 | iran | I650 | 14 |
| 183 | islam | I245 | 22 |
| 184 | iraq | I620 | 14 |
| 185 | ireland | I645 | 14 |
| 186 | isl | I240 | 22 |
| 187 | israel | I264 | 14 |
| 188 | itali | I340 | 22 |
| 189 | jamaica | J520 | 14 |
| 190 | japan | J150 | 14 |
| 191 | jersei | J620 | 22 |
| 192 | jordan | J635 | 14 |
| 193 | kazakhstan | K222 | 14 |
| 194 | kenya | K500 | 14 |
| 195 | kiribati | K613 | 14 |
| 196 | korea | K600 | 28 |
| 197 | peopl | P140 | 44 |
| 198 | s | S000 | 42 |
| 199 | kuwait | K300 | 14 |
| 200 | kyrgyzstan | K622 | 14 |
| 201 | lao | L000 | 14 |
| 202 | latvia | L310 | 14 |
| 203 | lebanon | L155 | 14 |
| 204 | lesotho | L230 | 14 |
| 205 | liberia | L160 | 14 |
| 206 | libyan | L150 | 14 |
| 207 | arab | A610 | 42 |
| 208 | jamahiriya | J560 | 14 |
| 209 | liechtenstein | L235 | 14 |
| 210 | lithuania | L350 | 14 |
| 211 | luxembourg | L251 | 14 |
| 212 | macao | M200 | 14 |
| 213 | macedonia | M235 | 14 |
| 214 | former | F656 | 14 |
| 215 | yugoslav | Y224 | 14 |
| 216 | madagascar | M322 | 14 |
| 217 | malawi | M400 | 14 |
| 218 | malaysia | M420 | 14 |
| 219 | maldiv | M431 | 22 |
| 220 | mali | M400 | 14 |
| 221 | malta | M430 | 14 |
| 222 | marshal | M624 | 22 |
| 223 | martiniqu | M635 | 22 |
| 224 | mauritania | M635 | 14 |
| 225 | mauritiu | M630 | 22 |
| 226 | mayott | M300 | 22 |
| 227 | mexico | M220 | 14 |
| 228 | micronesia | M265 | 14 |
| 229 | feder | F360 | 44 |
| 230 | moldova | M431 | 14 |
| 231 | monaco | M520 | 14 |
| 232 | mongolia | M524 | 14 |
| 233 | montenegro | M535 | 14 |
| 234 | montserrat | M532 | 14 |
| 235 | morocco | M620 | 14 |
| 236 | mozambiqu | M251 | 22 |
| 237 | myanmar | M560 | 14 |
| 238 | namibia | N510 | 14 |
| 239 | nauru | N600 | 14 |
| 240 | nepal | N140 | 14 |
| 241 | netherland | N364 | 44 |
| 242 | antil | A534 | 22 |
| 243 | new | N000 | 42 |
| 244 | caledonia | C435 | 14 |
| 245 | zealand | Z453 | 14 |
| 246 | nicaragua | N262 | 14 |
| 247 | niger | N260 | 14 |
| 248 | nigeria | N260 | 14 |
| 249 | niue | N000 | 14 |
| 250 | norfolk | N614 | 14 |
| 251 | northern | N636 | 14 |
| 252 | mariana | M650 | 14 |
| 253 | norwai | N600 | 22 |
| 254 | oman | O550 | 14 |
| 255 | pakistan | P223 | 14 |
| 256 | palau | P400 | 14 |
| 257 | palestinian | P423 | 14 |
| 258 | occupi | O210 | 22 |
| 259 | panama | P550 | 14 |
| 260 | papua | P100 | 14 |
| 261 | paraguai | P620 | 22 |
| 262 | peru | P600 | 14 |
| 263 | philippin | P415 | 22 |
| 264 | pitcairn | P326 | 14 |
| 265 | poland | P453 | 14 |
| 266 | portug | P632 | 22 |
| 267 | puerto | P630 | 14 |
| 268 | rico | R200 | 14 |
| 269 | qatar | Q360 | 14 |
| 270 | réunion | R550 | 14 |
| 271 | romania | R550 | 14 |
| 272 | russian | R250 | 14 |
| 273 | rwanda | R530 | 14 |
| 274 | saint | S530 | 98 |
| 275 | barthélemi | B634 | 22 |
| 276 | helena | H450 | 14 |
| 277 | kitt | K300 | 22 |
| 278 | nevi | N100 | 22 |
| 279 | lucia | L200 | 14 |
| 280 | martin | M635 | 14 |
| 281 | pierr | P600 | 22 |
| 282 | miquelon | M245 | 14 |
| 283 | vincent | V525 | 14 |
| 284 | grenadin | G653 | 22 |
| 285 | san | S500 | 14 |
| 286 | marino | M650 | 14 |
| 287 | sao | S000 | 14 |
| 288 | tome | T500 | 14 |
| 289 | princip | P652 | 22 |
| 290 | saudi | S300 | 14 |
| 291 | arabia | A610 | 14 |
| 292 | seneg | S520 | 22 |
| 293 | serbia | S610 | 14 |
| 294 | seychel | S240 | 22 |
| 295 | sierra | S600 | 14 |
| 296 | leon | L500 | 22 |
| 297 | singapor | S521 | 22 |
| 298 | slovakia | S412 | 14 |
| 299 | slovenia | S415 | 14 |
| 300 | solomon | S455 | 14 |
| 301 | somalia | S540 | 14 |
| 302 | south | S300 | 42 |
| 303 | africa | A162 | 14 |
| 304 | sandwich | S532 | 14 |
| 305 | spain | S150 | 14 |
| 306 | sri | S600 | 14 |
| 307 | lanka | L520 | 14 |
| 308 | sudan | S350 | 14 |
| 309 | surinam | S655 | 22 |
| 310 | svalbard | S141 | 14 |
| 311 | jan | J500 | 14 |
| 312 | mayen | M500 | 14 |
| 313 | swaziland | S245 | 14 |
| 314 | sweden | S350 | 14 |
| 315 | switzerland | S326 | 14 |
| 316 | syrian | S650 | 14 |
| 317 | taiwan | T500 | 14 |
| 318 | provinc | P615 | 22 |
| 319 | tajikistan | T222 | 14 |
| 320 | tanzania | T525 | 14 |
| 321 | unit | U530 | 110 |
| 322 | thailand | T453 | 14 |
| 323 | timor | T560 | 14 |
| 324 | lest | L230 | 22 |
| 325 | togo | T200 | 14 |
| 326 | tokelau | T240 | 14 |
| 327 | tonga | T520 | 14 |
| 328 | trinidad | T653 | 14 |
| 329 | tobago | T120 | 14 |
| 330 | tunisia | T520 | 14 |
| 331 | turkei | T620 | 22 |
| 332 | turkmenistan | T625 | 14 |
| 333 | turk | T620 | 22 |
| 334 | caico | C200 | 22 |
| 335 | tuvalu | T140 | 14 |
| 336 | uganda | U253 | 14 |
| 337 | ukrain | U265 | 22 |
| 338 | emir | E560 | 22 |
| 339 | kingdom | K523 | 14 |
| 340 | minor | M560 | 14 |
| 341 | outli | O340 | 22 |
| 342 | uruguai | U620 | 22 |
| 343 | uzbekistan | U212 | 14 |
| 344 | vanuatu | V530 | 14 |
| 345 | venezuela | V524 | 14 |
| 346 | bolivarian | B416 | 14 |
| 347 | viet | V300 | 14 |
| 348 | nam | N500 | 14 |
| 349 | virgin | V625 | 28 |
| 350 | u | U000 | 14 |
| 351 | walli | W400 | 22 |
| 352 | futuna | F350 | 14 |
| 353 | western | W236 | 14 |
| 354 | sahara | S600 | 14 |
| 355 | yemen | Y550 | 14 |
| 356 | zambia | Z510 | 14 |
| 357 | zimbabw | Z511 | 22 |
| 358 | digit | D230 | 2 |
| 359 | camera | C560 | 2 |
| 360 | scan | S500 | 4 |
| 361 | neg | N200 | 2 |
| 362 | islands | I245 | 15 |
| 363 | bahamas | B520 | 1 |
| 364 | barbados | B613 | 1 |
| 365 | belarus | B462 | 1 |
| 366 | belize | B420 | 1 |
| 367 | territory | T636 | 2 |
| 368 | verde | V630 | 1 |
| 369 | republic | R114 | 13 |
| 370 | christmas | C623 | 1 |
| 371 | cocos | C220 | 1 |
| 372 | keeling | K452 | 1 |
| 373 | comoros | C562 | 1 |
| 374 | democratic | D526 | 3 |
| 375 | ivoire | I160 | 1 |
| 376 | cyprus | C162 | 1 |
| 377 | equatorial | E236 | 1 |
| 378 | malvinas | M415 | 1 |
| 379 | faroe | F600 | 1 |
| 380 | france | F652 | 1 |
| 381 | territories | T636 | 1 |
| 382 | germany | G655 | 1 |
| 383 | greece | G620 | 1 |
| 384 | guadeloupe | G341 | 1 |
| 385 | guernsey | G652 | 1 |
| 386 | holy | H400 | 1 |
| 387 | city | C300 | 1 |
| 388 | honduras | H536 | 1 |
| 389 | hungary | H526 | 1 |
| 390 | islamic | I245 | 1 |
| 391 | isle | I240 | 1 |
| 392 | italy | I340 | 1 |
| 393 | jersey | J620 | 1 |
| 394 | people | P140 | 2 |
| 395 | maldives | M431 | 1 |
| 396 | marshall | M624 | 1 |
| 397 | martinique | M635 | 1 |
| 398 | mauritius | M632 | 1 |
| 399 | mayotte | M300 | 1 |
| 400 | federated | F363 | 1 |
| 401 | states | S332 | 3 |
| 402 | mozambique | M251 | 1 |
| 403 | netherlands | N364 | 2 |
| 404 | antilles | A534 | 1 |
| 405 | norway | N600 | 1 |
| 406 | occupied | O213 | 1 |
| 407 | paraguay | P620 | 1 |
| 408 | philippines | P415 | 1 |
| 409 | portugal | P632 | 1 |
| 410 | federation | F363 | 1 |
| 411 | barthélemy | B634 | 1 |
| 412 | kitts | K320 | 1 |
| 413 | nevis | N120 | 1 |
| 414 | pierre | P600 | 1 |
| 415 | grenadines | G653 | 1 |
| 416 | principe | P652 | 1 |
| 417 | senegal | S524 | 1 |
| 418 | seychelles | S242 | 1 |
| 419 | leone | L500 | 1 |
| 420 | singapore | S521 | 1 |
| 421 | suriname | S655 | 1 |
| 422 | province | P615 | 1 |
| 423 | united | U533 | 5 |
| 424 | leste | L230 | 1 |
| 425 | turkey | T620 | 1 |
| 426 | turks | T620 | 1 |
| 427 | caicos | C220 | 1 |
| 428 | ukraine | U265 | 1 |
| 429 | emirates | E563 | 1 |
| 430 | outlying | O345 | 1 |
| 431 | uruguay | U620 | 1 |
| 432 | wallis | W420 | 1 |
| 433 | zimbabwe | Z511 | 1 |
Please see the schema overview for context. This document was last updated on the 13th of December 2024 at 20:35 (Europe/London time).