← All changes | includes/class-chart-builder-activator.php +307 -257 trunk → 3.8.1 View file →

		@@ -1,257 +1,307 @@
1		-<?php
2		-global $ays_chart_db_version;
3		-$ays_chart_db_version = '20.0.0';
4		-
5		-/**
6		- * Fired during plugin activation
7		- *
8		- * @link https://ays-pro.com/
9		- * @since 1.0.0
10		- *
11		- * @package Chart_Builder
12		- * @subpackage Chart_Builder/includes
13		- */
14		-
15		-/**
16		- * Fired during plugin activation.
17		- *
18		- * This class defines all code necessary to run during the plugin's activation.
19		- *
20		- * @since 1.0.0
21		- * @package Chart_Builder
22		- * @subpackage Chart_Builder/includes
23		- * @author Chart Builder Team <[email protected]>
24		- */
25		-class Chart_Builder_Activator {
26		-
27		- /**
28		- * Short Description. (use period)
29		- *
30		- * Long Description.
31		- *
32		- * @since 1.0.0
33		- */
34		- public static function activate() {
35		-
36		- global $wpdb;
37		- global $ays_chart_db_version;
38		- require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
39		-
40		- $installed_ver = get_option( "ays_chart_db_version" );
41		- $charts_table = $wpdb->prefix . CHART_BUILDER_DB_PREFIX . 'charts';
42		- $charts_meta_table = $wpdb->prefix . CHART_BUILDER_DB_PREFIX . 'charts_meta';
43		- $settings_table = $wpdb->prefix . CHART_BUILDER_DB_PREFIX . 'settings';
44		- $charset_collate = $wpdb->get_charset_collate();
45		-
46		- if( $installed_ver != $ays_chart_db_version ) {
47		-
48		- $sql = "CREATE TABLE `".$charts_table."` (
49		- `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
50		- `author_id` INT(16) UNSIGNED NOT NULL DEFAULT '0',
51		- `title` TEXT NOT NULL,
52		- `description` TEXT NOT NULL DEFAULT '',
53		- `type` VARCHAR(256) NOT NULL DEFAULT '',
54		- `source_chart_type` VARCHAR(256) NOT NULL DEFAULT '',
55		- `source_type` VARCHAR(256) NOT NULL DEFAULT '',
56		- `source` LONGTEXT NOT NULL DEFAULT '',
57		- `date_created` DATETIME NOT NULL DEFAULT '1000-01-01 00:00:00',
58		- `date_modified` DATETIME NOT NULL DEFAULT '1000-01-01 00:00:00',
59		- `status` VARCHAR(256) NOT NULL DEFAULT 'published',
60		- `trash_status` VARCHAR(256) NOT NULL DEFAULT '',
61		- `ordering` INT(16) NOT NULL,
62		- `options` TEXT NOT NULL DEFAULT '',
63		- PRIMARY KEY (`id`)
64		- )$charset_collate;";
65		-
66		- $sql_schema = "SELECT * FROM INFORMATION_SCHEMA.TABLES
67		- WHERE table_schema = '".DB_NAME."' AND table_name = '".$charts_table."' ";
68		- $results = $wpdb->get_results($sql_schema);
69		-
70		- if( empty( $results ) ){
71		- $wpdb->query( $sql );
72		- }else{
73		- dbDelta( $sql );
74		- }
75		-
76		-
77		- $sql = "CREATE TABLE `".$charts_meta_table."` (
78		- `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
79		- `chart_id` INT(11) UNSIGNED NOT NULL,
80		- `meta_key` TEXT NOT NULL DEFAULT '',
81		- `meta_value` TEXT NOT NULL DEFAULT '',
82		- `note` TEXT NOT NULL DEFAULT '',
83		- `options` TEXT NOT NULL DEFAULT '',
84		- PRIMARY KEY (`id`)
85		- )$charset_collate;";
86		-
87		- $sql_schema = "SELECT * FROM INFORMATION_SCHEMA.TABLES
88		- WHERE table_schema = '".DB_NAME."' AND table_name = '".$charts_meta_table."' ";
89		- $results = $wpdb->get_results($sql_schema);
90		-
91		- if(empty($results)){
92		- $wpdb->query( $sql );
93		- }else{
94		- dbDelta( $sql );
95		- }
96		-
97		-
98		- $sql = "CREATE TABLE `".$settings_table."` (
99		- `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
100		- `meta_key` TEXT NOT NULL DEFAULT '',
101		- `meta_value` TEXT NOT NULL DEFAULT '',
102		- `note` TEXT NOT NULL DEFAULT '',
103		- `options` TEXT NOT NULL DEFAULT '',
104		- PRIMARY KEY (`id`)
105		- )$charset_collate;";
106		-
107		- $sql_schema = "SELECT * FROM INFORMATION_SCHEMA.TABLES
108		- WHERE table_schema = '".DB_NAME."' AND table_name = '".$settings_table."' ";
109		- $results = $wpdb->get_results($sql_schema);
110		-
111		- if(empty($results)){
112		- $wpdb->query( $sql );
113		- }else{
114		- dbDelta( $sql );
115		- }
116		-
117		- update_option( 'ays_chart_db_version', $ays_chart_db_version );
118		-
119		- }
120		-
121		- $metas = array(
122		- "user_roles",
123		- "google",
124		- "options"
125		- );
126		-
127		- foreach($metas as $meta_key){
128		- $meta_val = "";
129		- if($meta_key == "user_roles"){
130		- $meta_val = json_encode(array('administrator'));
131		- }
132		- $sql = "SELECT COUNT(*) FROM `".$settings_table."` WHERE `meta_key` = '". esc_sql( $meta_key ) ."'";
133		- $result = $wpdb->get_var($sql);
134		- if(intval($result) == 0){
135		- $result = $wpdb->insert(
136		- $settings_table,
137		- array(
138		- 'meta_key' => $meta_key,
139		- 'meta_value' => $meta_val,
140		- 'note' => "",
141		- 'options' => ""
142		- ),
143		- array( '%s', '%s', '%s', '%s' )
144		- );
145		- }
146		- }
147		-
148		- self::create_default_chart();
149		- }
150		-
151		- public static function db_update_check() {
152		- global $ays_chart_db_version;
153		- if ( get_site_option( 'ays_chart_db_version' ) != $ays_chart_db_version ) {
154		- self::activate();
155		- }
156		- }
157		-
158		- public static function create_default_chart() {
159		- global $wpdb;
160		- global $ays_chart_db_version;
161		-
162		- $charts_table = $wpdb->prefix . CHART_BUILDER_DB_PREFIX . 'charts';
163		- $charts_meta_table = $wpdb->prefix . CHART_BUILDER_DB_PREFIX . 'charts_meta';
164		- $settings_table = $wpdb->prefix . CHART_BUILDER_DB_PREFIX . 'settings';
165		-
166		- $chart_count = $wpdb->get_var("SELECT COUNT(*) FROM " . $charts_table);
167		- $chart_meta_count = $wpdb->get_var("SELECT COUNT(*) FROM " . $charts_meta_table);
168		- if ($chart_count == 0 && $chart_meta_count == 0) {
169		- $default_chart_source = array(
170		- "1" => ["Administrator","11"],
171		- "2" => ["Author","2"],
172		- "3" => ["Editor","5"],
173		- "4" => ["Guest","2"],
174		- "5" => ["Subscriber","7"]
175		- );
176		-
177		- $default_chart_options = array(
178		- //
179		- );
180		-
181		- $default_chart = array(
182		- 'title' => 'Default chart',
183		- 'description' => '',
184		- 'type' => 'google_charts',
185		- 'source_chart_type' => 'pie_chart',
186		- 'source_type' => 'manual',
187		- 'source' => json_encode($default_chart_source),
188		- 'date_created' => current_time('mysql'),
189		- 'date_modified' => current_time('mysql'),
190		- 'status' => 'published',
191		- 'trash_status' => '',
192		- 'ordering' => '0',
193		- 'options' => json_encode($default_chart_options),
194		- 'author_id' => get_current_user_id()
195		- );
196		-
197		- $wpdb->insert($charts_table, $default_chart);
198		- $chart_id = $wpdb->insert_id;
199		-
200		- $default_chart_meta = array(
201		- array(
202		- 'chart_id' => $chart_id,
203		- 'meta_key' => 'width',
204		- 'meta_value' => '100',
205		- 'note' => '',
206		- 'option' => ''
207		- ),
208		- array(
209		- 'chart_id' => $chart_id,
210		- 'meta_key' => 'height',
211		- 'meta_value' => '400',
212		- 'note' => '',
213		- 'option' => ''
214		- ),
215		- array(
216		- 'chart_id' => $chart_id,
217		- 'meta_key' => 'width',
218		- 'meta_value' => '100',
219		- 'note' => '',
220		- 'option' => ''
221		- ),
222		- array(
223		- 'chart_id' => $chart_id,
224		- 'meta_key' => 'title_color',
225		- 'meta_value' => '#000000',
226		- 'note' => '',
227		- 'option' => ''
228		- ),
229		- array(
230		- 'chart_id' => $chart_id,
231		- 'meta_key' => 'font_size',
232		- 'meta_value' => '14',
233		- 'note' => '',
234		- 'option' => ''
235		- ),
236		- array(
237		- 'chart_id' => $chart_id,
238		- 'meta_key' => 'tooltip_trigger',
239		- 'meta_value' => 'hover',
240		- 'note' => '',
241		- 'option' => ''
242		- ),
243		- array(
244		- 'chart_id' => $chart_id,
245		- 'meta_key' => 'show_color_code',
246		- 'meta_value' => 'off',
247		- 'note' => '',
248		- 'option' => ''
249		- )
250		- );
251		-
252		- foreach ($default_chart_meta as $key => $value) {
253		- $wpdb->insert($charts_meta_table, $value);
254		- }
255		- }
256		- }
257		-}
	1	+<?php
	2	+global $ays_chart_db_version;
	3	+$ays_chart_db_version = '1.0.3';
	4	+
	5	+/**
	6	+ * Fired during plugin activation
	7	+ *
	8	+ * @link https://ays-pro.com/
	9	+ * @since 1.0.0
	10	+ *
	11	+ * @package Chart_Builder
	12	+ * @subpackage Chart_Builder/includes
	13	+ */
	14	+
	15	+/**
	16	+ * Fired during plugin activation.
	17	+ *
	18	+ * This class defines all code necessary to run during the plugin's activation.
	19	+ *
	20	+ * @since 1.0.0
	21	+ * @package Chart_Builder
	22	+ * @subpackage Chart_Builder/includes
	23	+ * @author Chart Builder Team <[email protected]>
	24	+ */
	25	+class Chart_Builder_Activator {
	26	+
	27	+ /**
	28	+ * Short Description. (use period)
	29	+ *
	30	+ * Long Description.
	31	+ *
	32	+ * @since 1.0.0
	33	+ */
	34	+ public static function activate() {
	35	+
	36	+ global $wpdb;
	37	+ global $ays_chart_db_version;
	38	+ require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
	39	+
	40	+ $installed_ver = get_option( "ays_chart_db_version" );
	41	+ $charts_table = $wpdb->prefix . CHART_BUILDER_DB_PREFIX . 'charts';
	42	+ $charts_meta_table = $wpdb->prefix . CHART_BUILDER_DB_PREFIX . 'charts_meta';
	43	+ $settings_table = $wpdb->prefix . CHART_BUILDER_DB_PREFIX . 'settings';
	44	+ $charset_collate = $wpdb->get_charset_collate();
	45	+
	46	+ if( $installed_ver != $ays_chart_db_version ) {
	47	+
	48	+ $sql = "CREATE TABLE `".$charts_table."` (
	49	+ `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	50	+ `author_id` INT(16) UNSIGNED NOT NULL DEFAULT '0',
	51	+ `title` TEXT NOT NULL,
	52	+ `description` TEXT NOT NULL DEFAULT '',
	53	+ `type` VARCHAR(256) NOT NULL DEFAULT '',
	54	+ `source_chart_type` VARCHAR(256) NOT NULL DEFAULT '',
	55	+ `source_type` VARCHAR(256) NOT NULL DEFAULT '',
	56	+ `source` LONGTEXT NOT NULL DEFAULT '',
	57	+ `date_created` DATETIME NOT NULL DEFAULT '1000-01-01 00:00:00',
	58	+ `date_modified` DATETIME NOT NULL DEFAULT '1000-01-01 00:00:00',
	59	+ `status` VARCHAR(256) NOT NULL DEFAULT 'published',
	60	+ `trash_status` VARCHAR(256) NOT NULL DEFAULT '',
	61	+ `custom_post_id` INT(16) UNSIGNED DEFAULT NULL,
	62	+ `ordering` INT(16) NOT NULL,
	63	+ `quiz_query` VARCHAR(256) DEFAULT '',
	64	+ `quiz_id` INT(16) UNSIGNED DEFAULT '0',
	65	+ `options` TEXT NOT NULL DEFAULT '',
	66	+ PRIMARY KEY (`id`)
	67	+ )$charset_collate;";
	68	+
	69	+ $results = $wpdb->get_results( // phpcs:ignore
	70	+ $wpdb->prepare(
	71	+ "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = %s AND table_name = %s",
	72	+ DB_NAME,
	73	+ $charts_table
	74	+ )
	75	+ );
	76	+ if( empty( $results ) ){
	77	+ // phpcs:ignore
	78	+ $wpdb->query( $sql );
	79	+ }else{
	80	+ dbDelta( $sql );
	81	+ }
	82	+
	83	+
	84	+ $sql = "CREATE TABLE `".$charts_meta_table."` (
	85	+ `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	86	+ `chart_id` INT(11) UNSIGNED NOT NULL,
	87	+ `meta_key` TEXT NOT NULL DEFAULT '',
	88	+ `meta_value` TEXT NOT NULL DEFAULT '',
	89	+ `note` TEXT NOT NULL DEFAULT '',
	90	+ `options` TEXT NOT NULL DEFAULT '',
	91	+ PRIMARY KEY (`id`)
	92	+ )$charset_collate;";
	93	+ $results = $wpdb->get_results(// phpcs:ignore
	94	+ $wpdb->prepare(
	95	+ "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = %s AND table_name = %s",
	96	+ DB_NAME,
	97	+ $charts_meta_table
	98	+ )
	99	+ );
	100	+
	101	+
	102	+ if(empty($results)){
	103	+ // phpcs:ignore
	104	+ $wpdb->query( $sql );
	105	+ }else{
	106	+ dbDelta( $sql );
	107	+ }
	108	+
	109	+
	110	+ $sql = "CREATE TABLE `".$settings_table."` (
	111	+ `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	112	+ `meta_key` TEXT NOT NULL DEFAULT '',
	113	+ `meta_value` TEXT NOT NULL DEFAULT '',
	114	+ `note` TEXT NOT NULL DEFAULT '',
	115	+ `options` TEXT NOT NULL DEFAULT '',
	116	+ PRIMARY KEY (`id`)
	117	+ )$charset_collate;";
	118	+
	119	+ $results = $wpdb->get_results(// phpcs:ignore
	120	+ $wpdb->prepare(
	121	+ "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = %s AND table_name = %s",
	122	+ DB_NAME,
	123	+ $settings_table
	124	+ )
	125	+ );
	126	+
	127	+ if(empty($results)){
	128	+ // phpcs:ignore
	129	+ $wpdb->query( $sql );
	130	+ }else{
	131	+ dbDelta( $sql );
	132	+ }
	133	+
	134	+ update_option( 'ays_chart_db_version', $ays_chart_db_version );
	135	+
	136	+ }
	137	+
	138	+ $metas = array(
	139	+ "user_roles",
	140	+ "google",
	141	+ "options"
	142	+ );
	143	+
	144	+ foreach($metas as $meta_key){
	145	+ $meta_val = "";
	146	+ if($meta_key == "user_roles"){
	147	+ $meta_val = json_encode(array('administrator'));
	148	+ }
	149	+
	150	+ $result = $wpdb->get_var(// phpcs:ignore
	151	+ $wpdb->prepare(
	152	+ "SELECT COUNT(*)
	153	+ FROM {$settings_table}
	154	+ WHERE meta_key = %s",
	155	+ $meta_key
	156	+ )
	157	+ );
	158	+ if(intval($result) == 0){
	159	+ $result = $wpdb->insert(// phpcs:ignore
	160	+ $settings_table,
	161	+ array(
	162	+ 'meta_key' => $meta_key,// phpcs:ignore
	163	+ 'meta_value' => $meta_val,// phpcs:ignore
	164	+ 'note' => "",
	165	+ 'options' => ""
	166	+ ),
	167	+ array( '%s', '%s', '%s', '%s' )
	168	+ );
	169	+ }
	170	+ }
	171	+
	172	+ self::create_default_chart();
	173	+ }
	174	+
	175	+ public static function db_update_check() {
	176	+ global $ays_chart_db_version;
	177	+ if ( get_site_option( 'ays_chart_db_version' ) != $ays_chart_db_version ) {
	178	+ self::activate();
	179	+ }
	180	+ }
	181	+
	182	+ public static function create_default_chart() {
	183	+ global $wpdb;
	184	+ global $ays_chart_db_version;
	185	+
	186	+ $charts_table = $wpdb->prefix . CHART_BUILDER_DB_PREFIX . 'charts';
	187	+ $charts_meta_table = $wpdb->prefix . CHART_BUILDER_DB_PREFIX . 'charts_meta';
	188	+ $settings_table = $wpdb->prefix . CHART_BUILDER_DB_PREFIX . 'settings';
	189	+
	190	+ $chart_count = $wpdb->get_var("SELECT COUNT(*) FROM " . $charts_table);
	191	+ $chart_meta_count = $wpdb->get_var("SELECT COUNT(*) FROM " . $charts_meta_table);
	192	+ if ($chart_count == 0 && $chart_meta_count == 0) {
	193	+ $default_chart_source = array(
	194	+ "0" => ["User roles", "Visits"],
	195	+ "1" => ["Administrator","11"],
	196	+ "2" => ["Author","2"],
	197	+ "3" => ["Editor","5"],
	198	+ "4" => ["Guest","2"],
	199	+ "5" => ["Subscriber","7"]
	200	+ );
	201	+
	202	+ $default_chart_options = array(
	203	+ //
	204	+ );
	205	+
	206	+ $default_chart = array(
	207	+ 'title' => 'Default chart',
	208	+ 'description' => '',
	209	+ 'type' => 'google-charts',
	210	+ 'source_chart_type' => 'pie_chart',
	211	+ 'source_type' => 'manual',
	212	+ 'source' => json_encode($default_chart_source),
	213	+ 'date_created' => current_time('mysql'),
	214	+ 'date_modified' => current_time('mysql'),
	215	+ 'status' => 'published',
	216	+ 'trash_status' => '',
	217	+ 'ordering' => '0',
	218	+ 'options' => json_encode($default_chart_options),
	219	+ 'author_id' => get_current_user_id()
	220	+ );
	221	+
	222	+ $wpdb->insert($charts_table, $default_chart);
	223	+
	224	+ $chart_id = $wpdb->insert_id;
	225	+
	226	+ $post_type_args = array(
	227	+ 'chart_id' => $chart_id,
	228	+ 'author_id' => get_current_user_id(),
	229	+ 'chart_title' => 'Default chart',
	230	+ );
	231	+
	232	+ $custom_post_id = Chart_Builder_Custom_Post_Type::ays_chart_add_custom_post($post_type_args);
	233	+
	234	+ $default_chart_meta = array(
	235	+ array(
	236	+ 'chart_id' => $chart_id,
	237	+ 'meta_key' => 'width',// phpcs:ignore
	238	+ 'meta_value' => '100',// phpcs:ignore
	239	+ 'note' => '',
	240	+ 'options' => ''
	241	+ ),
	242	+ array(
	243	+ 'chart_id' => $chart_id,
	244	+ 'meta_key' => 'height',// phpcs:ignore
	245	+ 'meta_value' => '400',// phpcs:ignore
	246	+ 'note' => '',
	247	+ 'options' => ''
	248	+ ),
	249	+ array(
	250	+ 'chart_id' => $chart_id,
	251	+ 'meta_key' => 'title_color',// phpcs:ignore
	252	+ 'meta_value' => '#000000',// phpcs:ignore
	253	+ 'note' => '',
	254	+ 'options' => ''
	255	+ ),
	256	+ array(
	257	+ 'chart_id' => $chart_id,
	258	+ 'meta_key' => 'font_size',// phpcs:ignore
	259	+ 'meta_value' => '14',// phpcs:ignore
	260	+ 'note' => '',
	261	+ 'options' => ''
	262	+ ),
	263	+ array(
	264	+ 'chart_id' => $chart_id,
	265	+ 'meta_key' => 'tooltip_trigger',// phpcs:ignore
	266	+ 'meta_value' => 'hover',// phpcs:ignore
	267	+ 'note' => '',
	268	+ 'options' => ''
	269	+ ),
	270	+ array(
	271	+ 'chart_id' => $chart_id,
	272	+ 'meta_key' => 'show_color_code',// phpcs:ignore
	273	+ 'meta_value' => 'off',// phpcs:ignore
	274	+ 'note' => '',
	275	+ 'options' => ''
	276	+ )
	277	+ );
	278	+
	279	+ foreach ($default_chart_meta as $key => $value) {
	280	+ $wpdb->insert($charts_meta_table, $value);
	281	+ }
	282	+
	283	+ $default_chart['type'] = 'chart-js';
	284	+ $wpdb->insert($charts_table, $default_chart);
	285	+
	286	+ $chart_js_id = $wpdb->insert_id;
	287	+
	288	+ $post_type_args = array(
	289	+ 'chart_id' => $chart_js_id,
	290	+ 'author_id' => get_current_user_id(),
	291	+ 'chart_title' => 'Default chart',
	292	+ );
	293	+
	294	+ $custom_post_id = Chart_Builder_Custom_Post_Type::ays_chart_add_custom_post($post_type_args);
	295	+ } else {
	296	+ $wpdb->update(// phpcs:ignore
	297	+ $charts_table,
	298	+ array(
	299	+ 'type' => 'google-charts',
	300	+ ),
	301	+ array(
	302	+ 'type' => 'google_charts',
	303	+ )
	304	+ );
	305	+ }
	306	+ }
	307	+}