← All changes | includes/class-wpdirectorykit-activator.php +405 -99 1.1.8 → 1.5.9 View file →

		@@ -25,9 +25,9 @@
25	25	exit; // Exit if accessed directly.
26	26	}
27	27	class Wpdirectorykit_Activator {
28	28
29		- public static $db_version = 3.8;
	29	+ public static $db_version = 5.3;
30	30
31	31	/**
32	32	* Short Description. (use period)
33	33	*
		@@ -48,8 +48,13 @@
48	48	// By default set London position
49	49	add_option($prefix.'default_lat', 51.505);
50	50	add_option($prefix.'default_lng', -0.09);
51	51
	52	+ /* disable elmentor experement feature */
	53	+ update_option( 'elementor_experiment-landing-pages', 'inactive' );
	54	+ update_option( 'elementor_experiment-e_dom_optimization', 'inactive');
	55	+ update_option( 'elementor_experiment-e_element_cache', 'inactive');
	56	+ update_option( 'elementor_element_cache_ttl', 'disable');
52	57	}
53	58
54	59	public static function plugins_loaded(){
55	60	if ( get_site_option( 'wdk_db_version' ) === false ||
		@@ -55,9 +60,8 @@
55	60	if ( get_site_option( 'wdk_db_version' ) === false ||
56	61	get_site_option( 'wdk_db_version' ) < self::$db_version ) {
57	62	self::install();
58	63	}
59		-
60	64	}
61	65
62	66	// https://codex.wordpress.org/Creating_Tables_with_Plugins
63	67	public static function install() {
		@@ -265,10 +269,9 @@
265	269	/* version 1.2.0 db install */
266	270	if ( get_site_option( 'wdk_db_version' ) < '1.3' ) {
267	271
268	272	$table_name = $wpdb->prefix . 'wdk_categories';
269		- $sql = "ALTER TABLE `$table_name` CHANGE `parent_id` `parent_id` INT(11) NULL DEFAULT '0'; ";
270		- $wpdb->query($sql);
	273	+ $wpdb->query($wpdb->prepare("ALTER TABLE `{$table_name}` CHANGE `parent_id` `parent_id` INT(11) NULL DEFAULT %d;", 0));
271	274
272	275	self::$db_version = 1.3;
273	276	/* udpate option with db version */
274	277	}
		@@ -276,14 +279,18 @@
276	279	/* version 1.2.0 db install */
277	280	if ( get_site_option( 'wdk_db_version' ) < '1.4' ) {
278	281
279	282	$table_name = $wpdb->prefix . 'wdk_listings';
280		- $sql = "ALTER TABLE `$table_name` ADD `is_approved` INT(1) NULL DEFAULT NULL AFTER `is_activated`; ";
281		- $wpdb->query($sql);
	283	+ $wpdb->query($wpdb->prepare(
	284	+ "ALTER TABLE `{$table_name}` ADD `is_approved` INT(1) NULL DEFAULT NULL AFTER `is_activated`;"
	285	+ ));
	286	+
	287	+ $wpdb->query($wpdb->prepare(
	288	+ "UPDATE `{$table_name}` SET `is_approved` = %d",
	289	+ 1
	290	+ ));
	291	+
282	292
283		- $sql = "UPDATE `$table_name` SET `is_approved` = '1'";
284		- $wpdb->query($sql);
285		-
286	293	self::$db_version = 1.4;
287	294	/* udpate option with db version */
288	295	}
289	296
		@@ -289,10 +296,12 @@
289	296
290	297	if ( get_site_option( 'wdk_db_version' ) < '1.5' ) {
291	298
292	299	$table_name = $wpdb->prefix . 'wdk_listings';
293		- $sql = "ALTER TABLE `$table_name` ADD `date_package_expire` DATETIME NULL AFTER `hubspot_id`, ADD `package_id` INT NULL AFTER `date_package_expire`; ";
294		- $wpdb->query($sql);
	300	+ $wpdb->query($wpdb->prepare(
	301	+ "ALTER TABLE `{$table_name}` ADD `date_package_expire` DATETIME NULL AFTER `hubspot_id`, ADD `package_id` INT NULL AFTER `date_package_expire`;"
	302	+ ));
	303	+
295	304
296	305	self::$db_version = 1.5;
297	306	/* udpate option with db version */
298	307	}
		@@ -299,10 +308,11 @@
299	308
300	309	if ( get_site_option( 'wdk_db_version' ) < '1.6' ) {
301	310
302	311	$table_name = $wpdb->prefix . 'wdk_categories';
303		- $sql = "ALTER TABLE `$table_name` ADD `marker_image_id` int(11) DEFAULT NULL";
304		- $wpdb->query($sql);
	312	+ $wpdb->query($wpdb->prepare(
	313	+ "ALTER TABLE `{$table_name}` ADD `marker_image_id` int(11) DEFAULT NULL"));
	314	+
305	315
306	316	self::$db_version = 1.6;
307	317	/* udpate option with db version */
308	318	}
		@@ -309,10 +319,12 @@
309	319
310	320	if ( get_site_option( 'wdk_db_version' ) < '1.7' ) {
311	321
312	322	$table_name = $wpdb->prefix . 'wdk_listings';
313		- $sql = "ALTER TABLE `$table_name` ADD `listing_images_path` VARCHAR(200) DEFAULT ''";
314		- $wpdb->query($sql);
	323	+ $wpdb->query($wpdb->prepare(
	324	+ "ALTER TABLE `{$table_name}` ADD `listing_images_path` VARCHAR(200) DEFAULT ''"
	325	+ ));
	326	+
315	327
316	328	// TODO: this column content should be generated based on listing_images or old client may have issues after update
317	329
318	330	self::$db_version = 1.7;
		@@ -321,10 +333,12 @@
321	333
322	334	if ( get_site_option( 'wdk_db_version' ) < '1.8' ) {
323	335
324	336	$table_name = $wpdb->prefix . 'wdk_listings';
325		- $sql = "ALTER TABLE `$table_name` ADD `subscription_id` INT NULL; ";
326		- $wpdb->query($sql);
	337	+ $wpdb->query($wpdb->prepare(
	338	+ "ALTER TABLE `{$table_name}` ADD `subscription_id` INT NULL;"
	339	+ ));
	340	+
327	341
328	342	self::$db_version = 1.8;
329	343	/* udpate option with db version */
330	344	}
		@@ -331,10 +345,12 @@
331	345
332	346	if ( get_site_option( 'wdk_db_version' ) < '1.9' ) {
333	347
334	348	$table_name = $wpdb->prefix . 'wdk_fields';
335		- $sql = "ALTER TABLE `$table_name` ADD `is_price_format` tinyint(1) DEFAULT NULL; ";
336		- $wpdb->query($sql);
	349	+ $wpdb->query($wpdb->prepare(
	350	+ "ALTER TABLE `{$table_name}` ADD `is_price_format` tinyint(1) DEFAULT NULL;"
	351	+ ));
	352	+
337	353
338	354	self::$db_version = 1.9;
339	355	/* udpate option with db version */
340	356	}
		@@ -341,10 +357,12 @@
341	357
342	358	if ( get_site_option( 'wdk_db_version' ) < '2.0' ) {
343	359
344	360	$table_name = $wpdb->prefix . 'wdk_resultitem';
345		- $sql = "ALTER TABLE `$table_name` ADD `is_multiline_enabled` tinyint(1) DEFAULT NULL; ";
346		- $wpdb->query($sql);
	361	+ $wpdb->query($wpdb->prepare(
	362	+ "ALTER TABLE `{$table_name}` ADD `is_multiline_enabled` tinyint(1) DEFAULT NULL;"
	363	+ ));
	364	+
347	365
348	366	self::$db_version = 2.0;
349	367	/* udpate option with db version */
350	368	}
		@@ -351,25 +369,27 @@
351	369
352	370	if ( get_site_option( 'wdk_db_version' ) < '2.1' ) {
353	371
354	372	$table_name = $wpdb->prefix . 'wdk_listings';
355		- $sql = "ALTER TABLE `$table_name` ADD `user_id_editor` INT DEFAULT NULL;";
356		- $wpdb->query($sql);
	373	+ $wpdb->query($wpdb->prepare(
	374	+ "ALTER TABLE `{$table_name}` ADD `user_id_editor` INT DEFAULT NULL;"
	375	+ ));
357	376
358	377	$table_user_name = $wpdb->prefix . 'wdk_listings_users';
359	378
360	379	/* copy agents to new column */
361		- $sql = "UPDATE
362		- `$table_name` table_listings ,
363		- `$table_user_name` table_users
364		- SET
365		- table_listings.user_id_editor = table_users.user_id
366		- WHERE
367		- table_listings.post_id = table_users.post_id;";
368		- $wpdb->query($sql);
	380	+ $wpdb->query($wpdb->prepare(
	381	+ "UPDATE %1\$s table_listings, %2\$s table_users
	382	+ SET table_listings.user_id_editor = table_users.user_id
	383	+ WHERE table_listings.post_id = table_users.post_id;",
	384	+ $table_name,
	385	+ $table_user_name
	386	+ ));
369	387
370		- $sql = "TRUNCATE TABLE `$table_user_name`";
371		- $wpdb->query($sql);
	388	+ $wpdb->query($wpdb->prepare(
	389	+ "TRUNCATE TABLE `{$table_name}`"
	390	+ ));
	391	+
372	392
373	393	self::$db_version = 2.1;
374	394	/* udpate option with db version */
375	395	}
		@@ -376,35 +396,42 @@
376	396
377	397	if ( get_site_option( 'wdk_db_version' ) < '2.2' ) {
378	398
379	399	$table_name = $wpdb->prefix . 'wdk_locations';
380		- $sql = "ALTER TABLE `$table_name` ADD `level_0_id` INT DEFAULT NULL;";
381		- $wpdb->query($sql);
	400	+ $wpdb->query($wpdb->prepare(
	401	+ "ALTER TABLE `{$table_name}` ADD `level_0_id` INT DEFAULT NULL;"
	402	+ ));
382	403
383	404	$table_name = $wpdb->prefix . 'wdk_categories';
384		- $sql = "ALTER TABLE `$table_name` ADD `level_0_id` INT DEFAULT NULL;";
385		- $wpdb->query($sql);
	405	+ $wpdb->query($wpdb->prepare(
	406	+ "ALTER TABLE `{$table_name}` ADD `level_0_id` INT DEFAULT NULL;"
	407	+ ));
386	408
387		-
388	409	$table_name = $wpdb->prefix . 'wdk_listings_locations';
389		- $sql = "CREATE TABLE IF NOT EXISTS `$table_name` (
	410	+ $sql = $wpdb->prepare(
	411	+ "CREATE TABLE IF NOT EXISTS `{$table_name}` (
390	412	`idlistings_locations` int(11) NOT NULL AUTO_INCREMENT,
391	413	`location_id` int DEFAULT NULL,
392	414	`post_id` int DEFAULT NULL,
393		- PRIMARY KEY (idlistings_locations)
394		- ) $charset_collate;";
	415	+ PRIMARY KEY (idlistings_locations)
	416	+ ) $charset_collate;"
	417	+ );
395	418	dbDelta( $sql );
396	419
397	420	$table_name = $wpdb->prefix . 'wdk_listings_categories';
398		- $sql = "CREATE TABLE IF NOT EXISTS `$table_name` (
	421	+ $sql = $wpdb->prepare(
	422	+ "CREATE TABLE IF NOT EXISTS `{$table_name}` (
399	423	`idlistings_categories` int(11) NOT NULL AUTO_INCREMENT,
400	424	`category_id` int DEFAULT NULL,
401	425	`post_id` int DEFAULT NULL,
402		- PRIMARY KEY (idlistings_categories)
403		- ) $charset_collate;";
	426	+ PRIMARY KEY (idlistings_categories)
	427	+ ) $charset_collate;"
	428	+ );
404	429	dbDelta( $sql );
405	430
	431	+
406	432
	433	+
407	434	self::$db_version = 2.2;
408	435	/* udpate option with db version */
409	436	}
410	437
		@@ -410,10 +437,12 @@
410	437
411	438	if ( get_site_option( 'wdk_db_version' ) < '2.3' ) {
412	439
413	440	$table_name = $wpdb->prefix . 'wdk_listings';
414		- $sql = "ALTER TABLE `$table_name` ADD `listing_plans_documents` text DEFAULT '';";
415		- $wpdb->query($sql);
	441	+ $wpdb->query($wpdb->prepare(
	442	+ "ALTER TABLE `{$table_name}` ADD `listing_plans_documents` text DEFAULT '';"
	443	+ ));
	444	+
416	445
417	446	self::$db_version = 2.3;
418	447	/* udpate option with db version */
419	448	}
		@@ -420,10 +449,12 @@
420	449
421	450	if ( get_site_option( 'wdk_db_version' ) < '2.4' ) {
422	451
423	452	$table_name = $wpdb->prefix . 'wdk_resultitem';
424		- $sql = "ALTER TABLE `$table_name` ADD `is_label_disable` INT(1) NULL DEFAULT NULL";
425		- $wpdb->query($sql);
	453	+ $wpdb->query($wpdb->prepare(
	454	+ "ALTER TABLE `{$table_name}` ADD `is_label_disable` INT(1) NULL DEFAULT NULL"
	455	+ ));
	456	+
426	457
427	458	self::$db_version = 2.4;
428	459	/* udpate option with db version */
429	460	}
		@@ -430,14 +461,16 @@
430	461
431	462	if ( get_site_option( 'wdk_db_version' ) < '2.5' ) {
432	463
433	464	$table_name = $wpdb->prefix . 'wdk_listings';
434		- $sql = "ALTER TABLE `$table_name` ADD `categories_list` VARCHAR(128) DEFAULT ''";
435		- $wpdb->query($sql);
	465	+ $wpdb->query($wpdb->prepare(
	466	+ "ALTER TABLE `{$table_name}` ADD `categories_list` VARCHAR(128) DEFAULT ''"
	467	+ ));
436	468
437		- $table_name = $wpdb->prefix . 'wdk_listings';
438		- $sql = "ALTER TABLE `$table_name` ADD `locations_list` VARCHAR(128) DEFAULT ''";
439		- $wpdb->query($sql);
	469	+ $wpdb->query($wpdb->prepare(
	470	+ "ALTER TABLE `{$table_name}` ADD `locations_list` VARCHAR(128) DEFAULT ''"
	471	+ ));
	472	+
440	473
441	474
442	475	self::$db_version = 2.5;
443	476	/* udpate option with db version */
		@@ -445,11 +478,14 @@
445	478
446	479	if ( get_site_option( 'wdk_db_version' ) < '2.6' ) {
447	480
448	481	$table_name = $wpdb->prefix . 'wdk_fields';
	482	+ $wpdb->query($wpdb->prepare(
	483	+ "UPDATE `{$table_name}` SET `is_visible_frontend` = %d",
	484	+ 1
	485	+ ));
449	486
450		- $sql = "UPDATE `$table_name` SET `is_visible_frontend` = '1'";
451		- $wpdb->query($sql);
	487	+
452	488
453	489	self::$db_version = 2.6;
454	490	/* udpate option with db version */
455	491	}
		@@ -455,10 +491,12 @@
455	491	}
456	492
457	493	if ( get_site_option( 'wdk_db_version' ) < '2.7' ) {
458	494	$table_name = $wpdb->prefix . 'wdk_listings';
459		- $sql = "ALTER TABLE `$table_name` ADD `listing_images_path_medium` VARCHAR(250) DEFAULT ''";
460		- $wpdb->query($sql);
	495	+ $wpdb->query($wpdb->prepare(
	496	+ "ALTER TABLE `{$table_name}` ADD `listing_images_path_medium` VARCHAR(250) DEFAULT ''"
	497	+ ));
	498	+
461	499
462	500	self::$db_version = 2.7;
463	501	/* udpate option with db version */
464	502	}
		@@ -467,9 +505,9 @@
467	505	// Main table for visited pages
468	506
469	507	$table_name = $wpdb->prefix . 'wdk_dependfields';
470	508
471		- $sql = "CREATE TABLE IF NOT EXISTS $table_name (
	509	+ $sql = $sql = "CREATE TABLE IF NOT EXISTS `{$table_name}` (
472	510	`iddependfields` int(11) NOT NULL AUTO_INCREMENT,
473	511	`main_field` varchar(60) DEFAULT '',
474	512	`field_id` int(11) DEFAULT NULL,
475	513	`hidden_fields_list` varchar(256) DEFAULT '',
		@@ -485,9 +523,17 @@
485	523
486	524	if ( get_site_option( 'wdk_db_version' ) < '2.9' ) {
487	525	// Main table for visited pages
488	526	global $wpdb;
489		- $wpdb->query('UPDATE '.$wpdb->prefix . 'wdk_fields SET is_price_format = 1 WHERE (idfield=6 OR idfield=7) AND field_type="NUMBER"');
	527	+ $table_name = $wpdb->prefix . 'wdk_fields';
	528	+ $wpdb->query($wpdb->prepare(
	529	+ "UPDATE `{$table_name}` SET is_price_format = %d WHERE (idfield=%d OR idfield=%d) AND field_type=%s",
	530	+ 1,
	531	+ 6,
	532	+ 7,
	533	+ 'NUMBER'
	534	+ ));
	535	+
490	536	self::$db_version = 2.9;
491	537	/* udpate option with db version */
492	538	}
493	539
		@@ -494,10 +540,13 @@
494	540	if ( get_site_option( 'wdk_db_version' ) < '3.0' ) {
495	541
496	542	$table_name = $wpdb->prefix . 'wdk_fields';
497	543
498		- $sql = "UPDATE `$table_name` SET `is_visible_dashboard` = '1'";
499		- $wpdb->query($sql);
	544	+ $wpdb->query($wpdb->prepare(
	545	+ "UPDATE `{$table_name}` SET is_visible_dashboard = %d",
	546	+ 1
	547	+ ));
	548	+
500	549
501	550	self::$db_version = 3.0;
502	551	/* udpate option with db version */
503	552	}
		@@ -504,21 +553,28 @@
504	553
505	554	if ( get_site_option( 'wdk_db_version' ) < '3.1' ) {
506	555
507	556	$table_name = $wpdb->prefix . 'wdk_locations';
508		- $sql = "ALTER TABLE `$table_name` ADD `icon_path` VARCHAR(100) DEFAULT ''";
509		- $wpdb->query($sql);
510		- $sql = "ALTER TABLE `$table_name` ADD `image_path` VARCHAR(100) DEFAULT ''";
511		- $wpdb->query($sql);
	557	+ $wpdb->query($wpdb->prepare(
	558	+ "ALTER TABLE `{$table_name}` ADD `icon_path` VARCHAR(100) DEFAULT ''"
	559	+ ));
	560	+ $wpdb->query($wpdb->prepare(
	561	+ "ALTER TABLE `{$table_name}` ADD `image_path` VARCHAR(100) DEFAULT ''"
	562	+ ));
512	563
513	564	$table_name = $wpdb->prefix . 'wdk_categories';
514		- $sql = "ALTER TABLE `$table_name` ADD `icon_path` VARCHAR(100) DEFAULT ''";
515		- $wpdb->query($sql);
516		- $sql = "ALTER TABLE `$table_name` ADD `image_path` VARCHAR(100) DEFAULT ''";
517		- $wpdb->query($sql);
518		- $sql = "ALTER TABLE `$table_name` ADD `marker_image_path` VARCHAR(100) DEFAULT ''";
519		- $wpdb->query($sql);
	565	+ $wpdb->query($wpdb->prepare(
	566	+ "ALTER TABLE `{$table_name}` ADD `icon_path` VARCHAR(100) DEFAULT ''"
	567	+ ));
	568	+ $wpdb->query($wpdb->prepare(
	569	+ "ALTER TABLE `{$table_name}` ADD `image_path` VARCHAR(100) DEFAULT ''"
	570	+ ));
	571	+ $wpdb->query($wpdb->prepare(
	572	+ "ALTER TABLE `{$table_name}` ADD `marker_image_path` VARCHAR(100) DEFAULT ''"
	573	+ ));
520	574
	575	+
	576	+
521	577	// TODO: this column content should be generated based on listing_images or old client may have issues after update
522	578
523	579	self::$db_version = 3.1;
524	580	/* udpate option with db version */
		@@ -528,9 +584,9 @@
528	584	// Main table for visited pages
529	585
530	586	$table_name = $wpdb->prefix . 'wdk_token';
531	587
532		- $sql = "CREATE TABLE IF NOT EXISTS $table_name (
	588	+ $sql = "CREATE TABLE IF NOT EXISTS `{$table_name}` (
533	589	`idtoken` int(11) NOT NULL AUTO_INCREMENT,
534	590	`token` varchar(60) UNIQUE DEFAULT '',
535	591	`user_id` int(11) DEFAULT NULL,
536	592	`user_email` varchar(256) DEFAULT '',
		@@ -556,18 +612,21 @@
556	612	if ( get_site_option( 'wdk_db_version' ) < '3.4' ) {
557	613	// Main table for visited pages
558	614
559	615	$table_name = $wpdb->prefix . 'wdk_locations';
560		- $sql = "ALTER TABLE `$table_name` ADD `related_svg_map` varchar(64) DEFAULT NULL;";
561		- $wpdb->query($sql);
	616	+ $wpdb->query($wpdb->prepare(
	617	+ "ALTER TABLE `{$table_name}` ADD `related_svg_map` varchar(64) DEFAULT NULL;"
	618	+ ));
562	619
563	620	$table_name = $wpdb->prefix . 'wdk_locations';
564		- $sql = "ALTER TABLE `$table_name` ADD `related_svg_map_location` varchar(128) DEFAULT NULL;";
565		- $wpdb->query($sql);
	621	+ $wpdb->query($wpdb->prepare(
	622	+ "ALTER TABLE `{$table_name}` ADD `related_svg_map_location` varchar(128) DEFAULT NULL;"
	623	+ ));
566	624
567	625	$table_name = $wpdb->prefix . 'wdk_fields';
568		- $sql = "ALTER TABLE `$table_name` CHANGE `values_list` `values_list` TEXT NULL DEFAULT NULL;";
569		- $wpdb->query($sql);
	626	+ $wpdb->query($wpdb->prepare(
	627	+ "ALTER TABLE `{$table_name}` CHANGE `values_list` `values_list` TEXT NULL DEFAULT NULL;"
	628	+ ));
570	629
571	630	self::$db_version = 3.4;
572	631	/* udpate option with db version */
573	632	}
		@@ -575,26 +634,31 @@
575	634	if ( get_site_option( 'wdk_db_version' ) < '3.5' ) {
576	635	// Main table for visited pages
577	636
578	637	$table_name = $wpdb->prefix . 'wdk_categories';
579		- $sql = "ALTER TABLE `$table_name` ADD `category_color` varchar(32) DEFAULT NULL;";
580		- $wpdb->query($sql);
	638	+ $wpdb->query($wpdb->prepare(
	639	+ "ALTER TABLE `{$table_name}` ADD `category_color` varchar(32) DEFAULT NULL;"
	640	+ ));
581	641
582	642	$table_name = $wpdb->prefix . 'wdk_fields';
583		- $sql = "ALTER TABLE `$table_name` ADD `validation` varchar(64) DEFAULT NULL;";
584		- $wpdb->query($sql);
	643	+ $wpdb->query($wpdb->prepare(
	644	+ "ALTER TABLE `{$table_name}` ADD `validation` varchar(64) DEFAULT NULL;"
	645	+ ));
585	646
586	647	$table_name = $wpdb->prefix . 'wdk_fields';
587		- $sql = "ALTER TABLE `$table_name` ADD `min_length` INT(3) DEFAULT NULL;";
588		- $wpdb->query($sql);
	648	+ $wpdb->query($wpdb->prepare(
	649	+ "ALTER TABLE `{$table_name}` ADD `min_length` INT(3) DEFAULT NULL;"
	650	+ ));
589	651
590	652	$table_name = $wpdb->prefix . 'wdk_listings';
591		- $sql = "ALTER TABLE `$table_name` CHANGE `listing_images_path` `listing_images_path` TEXT DEFAULT '';";
592		- $wpdb->query($sql);
	653	+ $wpdb->query($wpdb->prepare(
	654	+ "ALTER TABLE `{$table_name}` CHANGE `listing_images_path` `listing_images_path` TEXT DEFAULT '';"
	655	+ ));
593	656
594	657	$table_name = $wpdb->prefix . 'wdk_listings';
595		- $sql = "ALTER TABLE `$table_name` CHANGE `listing_images_path_medium` `listing_images_path_medium` TEXT DEFAULT '';";
596		- $wpdb->query($sql);
	658	+ $wpdb->query($wpdb->prepare(
	659	+ "ALTER TABLE `{$table_name}` CHANGE `listing_images_path_medium` `listing_images_path_medium` TEXT DEFAULT '';"
	660	+ ));
597	661
598	662	self::$db_version = 3.5;
599	663	/* udpate option with db version */
600	664	}
		@@ -602,18 +666,21 @@
602	666	if ( get_site_option( 'wdk_db_version' ) < '3.6' ) {
603	667
604	668	$table_name = $wpdb->prefix . 'wdk_fields';
605	669
606		- $sql = "UPDATE `$table_name` SET `is_visible_dashboard` = '1'";
607		- $wpdb->query($sql);
	670	+ $wpdb->query($wpdb->prepare(
	671	+ "UPDATE `{$table_name}` SET `is_visible_dashboard` = '1'"
	672	+ ));
608	673
609	674	$table_name = $wpdb->prefix . 'wdk_listings';
610		- $sql = "ALTER TABLE `$table_name` CHANGE `locations_list` `locations_list` TEXT DEFAULT '';";
611		- $wpdb->query($sql);
	675	+ $wpdb->query($wpdb->prepare(
	676	+ "ALTER TABLE `{$table_name}` CHANGE `locations_list` `locations_list` TEXT DEFAULT '';"
	677	+ ));
612	678
613	679	$table_name = $wpdb->prefix . 'wdk_listings';
614		- $sql = "ALTER TABLE `$table_name` CHANGE `categories_list` `categories_list` TEXT DEFAULT '';";
615		- $wpdb->query($sql);
	680	+ $wpdb->query($wpdb->prepare(
	681	+ "ALTER TABLE `{$table_name}` CHANGE `categories_list` `categories_list` TEXT DEFAULT '';"
	682	+ ));
616	683
617	684	self::$db_version = 3.6;
618	685	/* udpate option with db version */
619	686	}
		@@ -621,10 +688,11 @@
621	688	if ( get_site_option( 'wdk_db_version' ) < '3.7' ) {
622	689
623	690	$table_name = $wpdb->prefix . 'wdk_fields';
624	691
625		- $sql = "ALTER TABLE `$table_name` ADD `placeholder` varchar(128) DEFAULT NULL;";
626		- $wpdb->query($sql);
	692	+ $wpdb->query($wpdb->prepare(
	693	+ "ALTER TABLE `{$table_name}` ADD `placeholder` varchar(128) DEFAULT NULL;"
	694	+ ));
627	695
628	696	self::$db_version = 3.7;
629	697	/* udpate option with db version */
630	698	}
		@@ -631,14 +699,252 @@
631	699
632	700	if ( get_site_option( 'wdk_db_version' ) < '3.8' ) {
633	701
634	702	$table_name = $wpdb->prefix . 'wdk_messages';
635		- $sql = "ALTER TABLE `$table_name` ADD `is_notified` tinyint(1) DEFAULT NULL; ";
636		- $wpdb->query($sql);
	703	+ $wpdb->query($wpdb->prepare(
	704	+ "ALTER TABLE `{$table_name}` ADD `is_notified` tinyint(1) DEFAULT NULL; "
	705	+ ));
637	706
638	707	self::$db_version = 3.8;
639	708	/* udpate option with db version */
640	709	}
641	710
	711	+ if ( get_site_option( 'wdk_db_version' ) < '3.9' ) {
	712	+
	713	+ $table_name = $wpdb->prefix . 'wdk_users';
	714	+
	715	+ $sql = "CREATE TABLE IF NOT EXISTS `{$table_name}` (
	716	+ `idusers` int(11) NOT NULL AUTO_INCREMENT,
	717	+ `cacheduser_user_id` int(11) DEFAULT NULL,
	718	+ `cacheduser_profile_url` text DEFAULT NULL,
	719	+ `cacheduser_display_name` text DEFAULT NULL,
	720	+ `cacheduser_email` text DEFAULT NULL,
	721	+ `cacheduser_avatar_url` text DEFAULT NULL,
	722	+ `cacheduser_wdk_address` text DEFAULT NULL,
	723	+ `cacheduser_wdk_phone` text DEFAULT NULL,
	724	+ `cacheduser_wdk_city` text DEFAULT NULL,
	725	+ `cacheduser_wdk_company_name` text DEFAULT NULL,
	726	+ `cacheduser_wdk_facebook` text DEFAULT NULL,
	727	+ `cacheduser_wdk_youtube` text DEFAULT NULL,
	728	+ `cacheduser_wdk_linkedin` text DEFAULT NULL,
	729	+ `cacheduser_wdk_twitter` text DEFAULT NULL,
	730	+ `cacheduser_wdk_instagram` text DEFAULT NULL,
	731	+ `cacheduser_wdk_whatsapp` text DEFAULT NULL,
	732	+ `cacheduser_wdk_viber` text DEFAULT NULL,
	733	+ `cacheduser_wdk_iban` text DEFAULT NULL,
	734	+ `cacheduser_wdk_position_title` text DEFAULT NULL,
	735	+ `cacheduser_wdk_telegram` text DEFAULT NULL,
	736	+ `cacheduser_roles` text DEFAULT NULL,
	737	+ `cacheduser_description` text DEFAULT NULL,
	738	+ `cacheduser_user_url` text DEFAULT NULL,
	739	+ `cacheduser_json_data` text DEFAULT NULL,
	740	+ `cacheduser_date_updated` datetime DEFAULT NULL,
	741	+ PRIMARY KEY (idusers)
	742	+ ) $charset_collate;";
	743	+
	744	+ dbDelta( $sql );
	745	+
	746	+ self::$db_version = 3.9;
	747	+ /* udpate option with db version */
	748	+ }
	749	+
	750	+ if ( get_site_option( 'wdk_db_version' ) < '4.0' ) {
	751	+
	752	+ $table_name = $wpdb->prefix . 'wdk_listings';
	753	+ $wpdb->query($wpdb->prepare(
	754	+ "ALTER TABLE `{$table_name}` ADD `listing_related_ids` VARCHAR(512) DEFAULT ''"
	755	+ ));
	756	+
	757	+ $wpdb->query($wpdb->prepare(
	758	+ "ALTER TABLE `{$table_name}` ADD `sublisting_order` INT(11) DEFAULT NULL"
	759	+ ));
	760	+
	761	+ $wpdb->query($wpdb->prepare(
	762	+ "ALTER TABLE `{$table_name}` ADD `listing_parent_post_id` INT(11) DEFAULT NULL"
	763	+ ));
	764	+
	765	+ /* disable elmentor experement feature */
	766	+ update_option( 'elementor_experiment-landing-pages', 'inactive' );
	767	+ update_option( 'elementor_experiment-e_dom_optimization', 'inactive');
	768	+
	769	+ self::$db_version = 4.0;
	770	+ /* udpate option with db version */
	771	+ }
	772	+
	773	+ if ( get_site_option( 'wdk_db_version' ) < '4.1' ) {
	774	+
	775	+ $table_name = $wpdb->prefix . 'wdk_dependfields';
	776	+ $wpdb->query($wpdb->prepare(
	777	+ "ALTER TABLE `{$table_name}` CHANGE `hidden_fields_list` `hidden_fields_list` TEXT NULL DEFAULT NULL;"
	778	+ ));
	779	+
	780	+ self::$db_version = 4.1;
	781	+ /* udpate option with db version */
	782	+ }
	783	+
	784	+ if ( get_site_option( 'wdk_db_version' ) < '4.2' ) {
	785	+
	786	+ self::$db_version = 4.2;
	787	+ /* udpate option with db version */
	788	+ }
	789	+
	790	+ if ( get_site_option( 'wdk_db_version' ) < '4.3' ) {
	791	+ $table_name = $wpdb->prefix . 'wdk_editlog';
	792	+
	793	+ $sql = $wpdb->prepare(
	794	+ "CREATE TABLE IF NOT EXISTS `{$table_name}` (
	795	+ `ideditlog` int(11) NOT NULL AUTO_INCREMENT,
	796	+ `post_id` int(11) DEFAULT NULL,
	797	+ `user_id` int(11) DEFAULT NULL,
	798	+ `date` datetime DEFAULT NULL,
	799	+ `ip` text DEFAULT NULL,
	800	+ `comment` text DEFAULT NULL,
	801	+ PRIMARY KEY (ideditlog)
	802	+ ) $charset_collate;"
	803	+ );
	804	+
	805	+ dbDelta( $sql );
	806	+ self::$db_version = 4.3;
	807	+ /* udpate option with db version */
	808	+ }
	809	+
	810	+ if ( get_site_option( 'wdk_db_version' ) < '4.4' ) {
	811	+
	812	+ /* disable elmentor experement feature */
	813	+ update_option( 'elementor_experiment-e_font_icon_svg', 'inactive');
	814	+
	815	+ self::$db_version = 4.4;
	816	+ /* udpate option with db version */
	817	+ }
	818	+
	819	+ if ( get_site_option( 'wdk_db_version' ) < '4.5' ) {
	820	+
	821	+ /* disable elmentor experement feature */
	822	+ update_option( 'wdk_is_featured_enabled', '1');
	823	+ update_option( 'wdk_is_rank_enabled', '1');
	824	+ update_option( 'wdk_is_user_editor_enabled', '1');
	825	+ update_option( 'wdk_is_post_content_enable', '1');
	826	+ update_option( 'wdk_is_alt_agent_enabled', '1');
	827	+
	828	+ $table_name = $wpdb->prefix . 'wdk_users';
	829	+ $wpdb->query($wpdb->prepare(
	830	+ "ALTER TABLE `{$table_name}` ADD `cacheduser_agency_name` text DEFAULT ''"
	831	+ ));
	832	+
	833	+ self::$db_version = 4.5;
	834	+ /* udpate option with db version */
	835	+ }
	836	+
	837	+ if ( get_site_option( 'wdk_db_version' ) < '4.6' ) {
	838	+
	839	+ $table_name = $wpdb->prefix . 'wdk_fields';
	840	+ $wpdb->query($wpdb->prepare(
	841	+ "ALTER TABLE `{$table_name}` ADD `empty_value` text DEFAULT ''"
	842	+ ));
	843	+
	844	+ self::$db_version = 4.6;
	845	+ /* udpate option with db version */
	846	+ }
	847	+
	848	+ if ( get_site_option( 'wdk_db_version' ) < '4.7' ) {
	849	+
	850	+ $table_name = $wpdb->prefix . 'wdk_fields';
	851	+ $wpdb->query($wpdb->prepare(
	852	+ "ALTER TABLE `{$table_name}` ADD `date_format` text DEFAULT ''"
	853	+ ));
	854	+
	855	+ self::$db_version = 4.7;
	856	+ /* udpate option with db version */
	857	+ }
	858	+
	859	+ if ( get_site_option( 'wdk_db_version' ) < '4.8' ) {
	860	+
	861	+ $table_name = $wpdb->prefix . 'wdk_categories';
	862	+ $wpdb->query($wpdb->prepare(
	863	+ "ALTER TABLE `{$table_name}` ADD `titles_for_search` text DEFAULT '';"
	864	+ ));
	865	+
	866	+ $table_name = $wpdb->prefix . 'wdk_locations';
	867	+ $wpdb->query($wpdb->prepare(
	868	+ "ALTER TABLE `{$table_name}` ADD `titles_for_search` text DEFAULT '';"
	869	+ ));
	870	+
	871	+ self::$db_version = 4.8;
	872	+ /* udpate option with db version */
	873	+ }
	874	+
	875	+ if ( get_site_option( 'wdk_db_version' ) < '4.9' ) {
	876	+
	877	+ $table_name = $wpdb->prefix . 'wdk_users';
	878	+ $wpdb->query($wpdb->prepare(
	879	+ "ALTER TABLE `{$table_name}` ADD `cacheduser_user_login` text DEFAULT ''"
	880	+ ));
	881	+
	882	+ $wpdb->query($wpdb->prepare(
	883	+ "ALTER TABLE `{$table_name}` ADD `cacheduser_wdk_slug` text DEFAULT ''"
	884	+ ));
	885	+
	886	+ self::$db_version = 4.9;
	887	+ /* udpate option with db version */
	888	+ }
	889	+
	890	+
	891	+ if ( get_site_option( 'wdk_db_version' ) < '5.0' ) {
	892	+
	893	+ $table_name = $wpdb->prefix . 'wdk_fields';
	894	+ $wpdb->query($wpdb->prepare(
	895	+ "ALTER TABLE `{$table_name}` ADD `autosuggestion` varchar(64) DEFAULT NULL;"
	896	+ ));
	897	+
	898	+ self::$db_version = 5.0;
	899	+ /* udpate option with db version */
	900	+ }
	901	+
	902	+ if ( get_site_option( 'wdk_db_version' ) < '5.1' ) {
	903	+
	904	+ $table_name = $wpdb->prefix . 'wdk_resultitem';
	905	+ $wpdb->query($wpdb->prepare(
	906	+ "ALTER TABLE `{$table_name}` ADD `is_show_agent_details` INT(1) NULL DEFAULT NULL"
	907	+ ));
	908	+
	909	+ $table_name = $wpdb->prefix . 'wdk_listings';
	910	+ $wpdb->query($wpdb->prepare(
	911	+ "ALTER TABLE `{$table_name}` ADD `user_id_editor_display_name` VARCHAR(128) DEFAULT ''"
	912	+ ));
	913	+
	914	+ $wpdb->query($wpdb->prepare(
	915	+ "ALTER TABLE `{$table_name}` ADD `user_id_editor_user_login` VARCHAR(128) DEFAULT ''"
	916	+ ));
	917	+
	918	+ $wpdb->query($wpdb->prepare(
	919	+ "ALTER TABLE `{$table_name}` ADD `user_id_editor_wdk_slug` VARCHAR(128) DEFAULT ''"
	920	+ ));
	921	+
	922	+ $wpdb->query($wpdb->prepare(
	923	+ "ALTER TABLE `{$table_name}` ADD `user_id_editor_avatar` VARCHAR(256) DEFAULT ''"
	924	+ ));
	925	+
	926	+ self::$db_version = 5.1;
	927	+ /* udpate option with db version */
	928	+ }
	929	+
	930	+ if ( get_site_option( 'wdk_db_version' ) < '5.2' ) {
	931	+
	932	+ $table_name = $wpdb->prefix . 'wdk_listings';
	933	+ $wpdb->query($wpdb->prepare(
	934	+ "ALTER TABLE `{$table_name}` ADD `counter_results_views` INT(111) DEFAULT 0"
	935	+ ));
	936	+
	937	+ self::$db_version = 5.2;
	938	+ /* udpate option with db version */
	939	+ }
	940	+
	941	+ if ( get_site_option( 'wdk_db_version' ) < '5.3' ) {
	942	+ update_option( 'wdk_enable_filter_zero_decimal', '1');
	943	+
	944	+ self::$db_version = 5.3;
	945	+ /* udpate option with db version */
	946	+ }
	947	+
642	948	update_option( 'wdk_db_version', self::$db_version );
643	949	}
644		-}
	950	+}