← All changes | includes/db.php +23 -1 1.2.2 → 2.3.0 View file →

		@@ -54,8 +54,9 @@
54	54	rfm_r VARCHAR(3),
55	55	rfm_f VARCHAR(3),
56	56	rfm_m VARCHAR(3),
57	57	ip VARCHAR(255),
	58	+ url_query_string longtext,
58	59	updated_at VARCHAR(11),
59	60	PRIMARY KEY ( id )
60	61	',
61	62	],
		@@ -74,8 +75,25 @@
74	75	applied_at VARCHAR(20),
75	76	PRIMARY KEY ( id )
76	77	',
77	78	],
	79	+ 'funnel_contact' => [
	80	+ 'name' => $wpdb->prefix . self::DATABASE_PREFIX . 'funnel_contact',
	81	+ 'query' => '
	82	+ id bigint(20) NOT NULL AUTO_INCREMENT,
	83	+ funnel_id bigint(20) NOT NULL,
	84	+ user_id bigint(20) NOT NULL,
	85	+ order_bump longtext DEFAULT NULL,
	86	+ upsell longtext DEFAULT NULL,
	87	+ downsell longtext DEFAULT NULL,
	88	+ optin longtext DEFAULT NULL,
	89	+ checkout longtext DEFAULT NULL,
	90	+ total_spent longtext DEFAULT NULL,
	91	+ updated_at VARCHAR(11),
	92	+ created_at VARCHAR(11),
	93	+ PRIMARY KEY ( id )
	94	+ ',
	95	+ ],
78	96	];
79	97
80	98	return apply_filters( 'sellkit_tables', $tables );
81	99	}
		@@ -197,9 +215,13 @@
197	215
198	216	// phpcs:ignore WordPress.DB.DirectDatabaseQuery
199	217	$result = $wpdb->insert( $wpdb->prefix . self::DATABASE_PREFIX . $table_name, $prepared_data, $format );
200	218
201		- return $result;
	219	+ if ( empty( $result ) || is_wp_error( $result ) ) {
	220	+ return false;
	221	+ }
	222	+
	223	+ return $wpdb->insert_id;
202	224	}
203	225
204	226	/**
205	227	* Gets database data.