| @@ -126,8 +126,9 @@ | ||
| 126 | 126 | wp_clear_scheduled_hook( 'propertyhive_process_email_log' ); |
| 127 | 127 | wp_clear_scheduled_hook( 'propertyhive_auto_email_match' ); |
| 128 | 128 | wp_clear_scheduled_hook( 'propertyhive_check_licenses' ); |
| 129 | 129 | wp_clear_scheduled_hook( 'propertyhive_update_address_concatenated' ); |
| 130 | + wp_clear_scheduled_hook( 'propertyhive_cleanup_search_analytics' ); | |
| 130 | 131 | } |
| 131 | 132 | |
| 132 | 133 | /** |
| 133 | 134 | * Get list of DB update callbacks. |
| @@ -151,8 +152,9 @@ | ||
| 151 | 152 | add_action('property_run_update_actions', $update_callback); |
| 152 | 153 | } |
| 153 | 154 | } |
| 154 | 155 | } |
| 156 | + // phpcs:ignore WordPress.NamingConventions.PrefixAllGlobals.NonPrefixedHooknameFound -- Existing public Property Hive extension hook property_run_update_actions; changing the established name would detach installed callbacks. | |
| 155 | 157 | do_action('property_run_update_actions'); |
| 156 | 158 | } |
| 157 | 159 | |
| 158 | 160 | /** |
| @@ -165,8 +167,9 @@ | ||
| 165 | 167 | wp_clear_scheduled_hook( 'propertyhive_process_email_log' ); |
| 166 | 168 | wp_clear_scheduled_hook( 'propertyhive_auto_email_match' ); |
| 167 | 169 | wp_clear_scheduled_hook( 'propertyhive_check_licenses' ); |
| 168 | 170 | wp_clear_scheduled_hook( 'propertyhive_update_address_concatenated' ); |
| 171 | + wp_clear_scheduled_hook( 'propertyhive_cleanup_search_analytics' ); | |
| 169 | 172 | |
| 170 | 173 | // Schedule for midnight as it's likely traffic will be quieter at that time |
| 171 | 174 | wp_schedule_event( strtotime( 'tomorrow' ) - ( (int)get_option( 'gmt_offset' ) * HOUR_IN_SECONDS ), 'daily', 'propertyhive_update_currency_exchange_rates' ); |
| 172 | 175 | |
| @@ -196,8 +199,10 @@ | ||
| 196 | 199 | // 1am so it doesn't run at exactly the same time as the exchange rate cron |
| 197 | 200 | wp_schedule_event( strtotime( 'tomorrow +1hours' ) - ( (int)get_option( 'gmt_offset' ) * HOUR_IN_SECONDS ), 'daily', 'propertyhive_check_licenses' ); |
| 198 | 201 | |
| 199 | 202 | wp_schedule_event( strtotime( 'tomorrow +3hours' ) - ( (int)get_option( 'gmt_offset' ) * HOUR_IN_SECONDS ), 'daily', 'propertyhive_update_address_concatenated' ); |
| 203 | + | |
| 204 | + wp_schedule_event( time() + HOUR_IN_SECONDS, 'daily', 'propertyhive_cleanup_search_analytics' ); | |
| 200 | 205 | } |
| 201 | 206 | |
| 202 | 207 | public function custom_cron_recurrence( $schedules ) |
| 203 | 208 | { |
| @@ -643,15 +648,19 @@ | ||
| 643 | 648 | add_option( 'propertyhive_install_timestamp', time(), '', 'no' ); |
| 644 | 649 | add_option( 'propertyhive_review_prompt_due_timestamp', strtotime('+30 days'), '', 'no' ); |
| 645 | 650 | |
| 646 | 651 | add_option( 'propertyhive_enquiry_auto_responder_email_subject', __( 'Thank you for your enquiry', 'propertyhive' ), '', 'no' ); |
| 647 | - add_option( 'propertyhive_enquiry_auto_responder_email_body', sprintf( __( "Thank you for your recent property enquiry about [property_address_hyperlinked]. A member of our team will be in touch shortly. | |
| 652 | + add_option( 'propertyhive_enquiry_auto_responder_email_body', sprintf( | |
| 653 | + /* translators: %s: blog name shown in the email sign-off */ | |
| 654 | + __( "Thank you for your recent property enquiry about [property_address_hyperlinked]. A member of our team will be in touch shortly. | |
| 648 | 655 | |
| 649 | 656 | Kind regards, |
| 650 | 657 | |
| 651 | 658 | %s |
| 652 | 659 | |
| 653 | -[similar_properties]", 'propertyhive' ), get_bloginfo('name') ), '', 'no' ); | |
| 660 | +[similar_properties]", 'propertyhive' ), | |
| 661 | + get_bloginfo('name') | |
| 662 | + ), '', 'no' ); | |
| 654 | 663 | |
| 655 | 664 | add_option( 'propertyhive_property_match_default_email_subject', __( 'We found [property_count] that might be of interest to you', 'propertyhive' ), '', 'no' ); |
| 656 | 665 | add_option( 'propertyhive_property_match_default_email_body', __( "Hi [contact_dear], |
| 657 | 666 | |
| @@ -787,8 +796,16 @@ | ||
| 787 | 796 | $tables .= " |
| 788 | 797 | CREATE TABLE {$wpdb->prefix}ph_address_keyword_polygon ( |
| 789 | 798 | address_keyword varchar(255) NOT NULL, |
| 790 | 799 | polygon_coordinates longtext NOT NULL |
| 800 | + ) $collate;"; | |
| 801 | + | |
| 802 | + $tables .= " | |
| 803 | + CREATE TABLE {$wpdb->prefix}ph_search_log ( | |
| 804 | + id bigint(20) unsigned NOT NULL AUTO_INCREMENT, | |
| 805 | + searched_at datetime NOT NULL, | |
| 806 | + PRIMARY KEY (id), | |
| 807 | + KEY searched_at (searched_at) | |
| 791 | 808 | ) $collate;"; |
| 792 | 809 | |
| 793 | 810 | dbDelta( $tables ); |
| 794 | 811 | } |
