← All changes | includes/db.php +24 -1 1.1.4 → 2.7.0 View file →

		@@ -53,8 +53,10 @@
53	53	viewed_category longtext,
54	54	rfm_r VARCHAR(3),
55	55	rfm_f VARCHAR(3),
56	56	rfm_m VARCHAR(3),
	57	+ ip VARCHAR(255),
	58	+ url_query_string longtext,
57	59	updated_at VARCHAR(11),
58	60	PRIMARY KEY ( id )
59	61	',
60	62	],
		@@ -73,8 +75,25 @@
73	75	applied_at VARCHAR(20),
74	76	PRIMARY KEY ( id )
75	77	',
76	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	+ ],
77	96	];
78	97
79	98	return apply_filters( 'sellkit_tables', $tables );
80	99	}
		@@ -196,9 +215,13 @@
196	215
197	216	// phpcs:ignore WordPress.DB.DirectDatabaseQuery
198	217	$result = $wpdb->insert( $wpdb->prefix . self::DATABASE_PREFIX . $table_name, $prepared_data, $format );
199	218
200		- return $result;
	219	+ if ( empty( $result ) || is_wp_error( $result ) ) {
	220	+ return false;
	221	+ }
	222	+
	223	+ return $wpdb->insert_id;
201	224	}
202	225
203	226	/**
204	227	* Gets database data.