wpfunnels / includes / wpf-update-functions.php

wpf-update-functions.php in WPFunnels – Funnel Builder for WooCommerce with Checkout & One Click Upsell 3.12.3, at includes/wpf-update-functions.php

109 lines 2.9 KB

Raw Download Zip

1	<?php
2	/**
3	* WPFunnels Update
4	*
5	* Functions for updating data, used by the background updater.
6	*
7	*/
8
9
10
11	defined( 'ABSPATH' ) \|\| exit;
12
13	/**
14	* Create stat table
15	*
16	*/
17	function wpf_create_350_stat_table() {
18	global $wpdb;
19	$wpdb->hide_errors();
20	$charset_collate = $wpdb->get_charset_collate();
21	$table_name = $wpdb->prefix . 'wpfnl_stats';
22
23	$sql = "CREATE TABLE IF NOT EXISTS $table_name (
24	id mediumint(9) NOT NULL AUTO_INCREMENT,
25	order_id bigint(20) unsigned NOT NULL,
26	funnel_id bigint(20) unsigned NOT NULL,
27	parent_id bigint(20) unsigned NOT NULL,
28	customer_id bigint(20) unsigned NOT NULL,
29	total_sales double DEFAULT 0 NOT NULL,
30	orderbump_sales double DEFAULT 0 NOT NULL,
31	upsell_sales double DEFAULT 0 NOT NULL,
32	downsell_sales double DEFAULT 0 NOT NULL,
33	gateway double DEFAULT 0 NOT NULL,
34	status varchar(20) NOT NULL,
35	paid_date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
36	date_created datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
37	date_created_gmt datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
38	PRIMARY KEY (id)
39	) $charset_collate;";
40
41	require_once ABSPATH . 'wp-admin/includes/upgrade.php';
42	dbDelta( $sql );
43	}
44
45
46	/**
47	* Create optin entries table
48	*
49	* @return void
50	* @since 3.2.0
51	*/
52	function wpf_create_350_optin_entries_table() {
53	global $wpdb;
54	$wpdb->hide_errors();
55	$charset_collate = $wpdb->get_charset_collate();
56	$table_name = $wpdb->prefix . 'wpfnl_optin_entries';
57
58	$sql = "CREATE TABLE IF NOT EXISTS $table_name (
59	id mediumint(9) NOT NULL AUTO_INCREMENT,
60	funnel_id bigint(20) unsigned NOT NULL,
61	step_id bigint(20) unsigned NOT NULL,
62	user_id bigint(20) unsigned NOT NULL,
63	email varchar(100) NOT NULL,
64	hash varchar(100) NOT NULL,
65	data LONGTEXT NULL DEFAULT NULL,
66	date_created datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
67	PRIMARY KEY (id)
68	) $charset_collate;";
69
70	require_once ABSPATH . 'wp-admin/includes/upgrade.php';
71	dbDelta( $sql );
72	}
73
74
75	/**
76	* Update DB version to 3.2.0
77	*
78	*/
79	function wpf_update_350_db_version() {
80	update_option('wpfunnels_db_version', '3.2.0');
81	}
82
83
84	/**
85	* Create checkout visits table for native checkout conversion rate tracking.
86	*
87	* @since 3.11.0
88	*/
89	function wpf_create_3110_checkout_visits_table() {
90	global $wpdb;
91	$wpdb->hide_errors();
92	$charset_collate = $wpdb->get_charset_collate();
93	$table_name = $wpdb->prefix . 'wpfnl_checkout_visits';
94
95	$sql = "CREATE TABLE IF NOT EXISTS $table_name (
96	id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
97	type varchar(10) NOT NULL DEFAULT 'store',
98	funnel_id bigint(20) unsigned NOT NULL DEFAULT 0,
99	session_hash varchar(32) NOT NULL,
100	visit_date date NOT NULL,
101	date_created datetime NOT NULL,
102	PRIMARY KEY (id),
103	UNIQUE KEY unique_visit (session_hash, type, funnel_id, visit_date)
104	) $charset_collate;";
105
106	require_once ABSPATH . 'wp-admin/includes/upgrade.php';
107	dbDelta( $sql );
108	}
109