← All changes | includes/core/update/updater-functions.php +55 -0 1.2.1 → 2.7.0 View file →

		@@ -32,7 +32,62 @@
32	32	global $wpdb;
33	33
34	34	$prefix = $wpdb->prefix . Database::DATABASE_PREFIX;
35	35
	36	+ if ( ! function_exists( 'check_column' ) ) {
	37	+ require_once ABSPATH . 'wp-admin/install-helper.php';
	38	+ }
	39	+
	40	+ if ( ! empty( check_column( "{$prefix}contact_segmentation", 'ip', 'varchar(255)' ) ) ) {
	41	+ return;
	42	+ }
	43	+
36	44	$wpdb->query("ALTER TABLE {$prefix}contact_segmentation ADD ip VARCHAR (255) NULL DEFAULT NULL"); // phpcs:ignore
	45	+ }
	46	+
	47	+ /**
	48	+ * Add url query string to contact segmentation column.
	49	+ *
	50	+ * @since 1.2.3
	51	+ */
	52	+ public function add_url_query_string_column_to_contact_segmentation() {
	53	+ global $wpdb;
	54	+
	55	+ $prefix = $wpdb->prefix . Database::DATABASE_PREFIX;
	56	+
	57	+ if ( ! function_exists( 'check_column' ) ) {
	58	+ require_once ABSPATH . '/wp-admin/install-helper.php';
	59	+ }
	60	+
	61	+ if ( ! empty( check_column( "{$prefix}contact_segmentation", 'url_query_string', 'longtext' ) ) ) {
	62	+ return;
	63	+ }
	64	+
	65	+ $wpdb->query("ALTER TABLE {$prefix}contact_segmentation ADD url_query_string longtext NULL DEFAULT NULL"); // phpcs:ignore
	66	+ }
	67	+
	68	+ /**
	69	+ * Adds funnel contact table.
	70	+ *
	71	+ * @since 1.5.0
	72	+ */
	73	+ public function add_funnel_contact_table() {
	74	+ global $wpdb;
	75	+
	76	+ $is_testcase_site = strpos( site_url(), 'artbees.team' ); // It should be removed.
	77	+
	78	+ if (
	79	+ in_array( 'funnel_contact', $wpdb->tables, true ) &&
	80	+ ! $is_testcase_site // It should be removed.
	81	+ ) {
	82	+ return;
	83	+ }
	84	+
	85	+ // phpcs:disable
	86	+ if ( $is_testcase_site ) {
	87	+ $wpdb->query( "DROP TABLE IF EXISTS $wpdb->prefix" . Database::DATABASE_PREFIX . "funnel_contact" ); // It should be removed.
	88	+ }
	89	+ // phpcs:enable
	90	+
	91	+ Database::create_new_table( 'funnel_contact' );
37	92	}
38	93	}