← All changes | includes/class-wpdirectorykit-activator.php +296 -113 1.3.0 → 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 = 4.5;
	29	+ public static $db_version = 5.3;
30	30
31	31	/**
32	32	* Short Description. (use period)
33	33	*
		@@ -51,8 +51,10 @@
51	51
52	52	/* disable elmentor experement feature */
53	53	update_option( 'elementor_experiment-landing-pages', 'inactive' );
54	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');
55	57	}
56	58
57	59	public static function plugins_loaded(){
58	60	if ( get_site_option( 'wdk_db_version' ) === false ||
		@@ -267,10 +269,9 @@
267	269	/* version 1.2.0 db install */
268	270	if ( get_site_option( 'wdk_db_version' ) < '1.3' ) {
269	271
270	272	$table_name = $wpdb->prefix . 'wdk_categories';
271		- $sql = "ALTER TABLE `$table_name` CHANGE `parent_id` `parent_id` INT(11) NULL DEFAULT '0'; ";
272		- $wpdb->query($sql);
	273	+ $wpdb->query($wpdb->prepare("ALTER TABLE `{$table_name}` CHANGE `parent_id` `parent_id` INT(11) NULL DEFAULT %d;", 0));
273	274
274	275	self::$db_version = 1.3;
275	276	/* udpate option with db version */
276	277	}
		@@ -278,14 +279,18 @@
278	279	/* version 1.2.0 db install */
279	280	if ( get_site_option( 'wdk_db_version' ) < '1.4' ) {
280	281
281	282	$table_name = $wpdb->prefix . 'wdk_listings';
282		- $sql = "ALTER TABLE `$table_name` ADD `is_approved` INT(1) NULL DEFAULT NULL AFTER `is_activated`; ";
283		- $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	+
284	292
285		- $sql = "UPDATE `$table_name` SET `is_approved` = '1'";
286		- $wpdb->query($sql);
287		-
288	293	self::$db_version = 1.4;
289	294	/* udpate option with db version */
290	295	}
291	296
		@@ -291,10 +296,12 @@
291	296
292	297	if ( get_site_option( 'wdk_db_version' ) < '1.5' ) {
293	298
294	299	$table_name = $wpdb->prefix . 'wdk_listings';
295		- $sql = "ALTER TABLE `$table_name` ADD `date_package_expire` DATETIME NULL AFTER `hubspot_id`, ADD `package_id` INT NULL AFTER `date_package_expire`; ";
296		- $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	+
297	304
298	305	self::$db_version = 1.5;
299	306	/* udpate option with db version */
300	307	}
		@@ -301,10 +308,11 @@
301	308
302	309	if ( get_site_option( 'wdk_db_version' ) < '1.6' ) {
303	310
304	311	$table_name = $wpdb->prefix . 'wdk_categories';
305		- $sql = "ALTER TABLE `$table_name` ADD `marker_image_id` int(11) DEFAULT NULL";
306		- $wpdb->query($sql);
	312	+ $wpdb->query($wpdb->prepare(
	313	+ "ALTER TABLE `{$table_name}` ADD `marker_image_id` int(11) DEFAULT NULL"));
	314	+
307	315
308	316	self::$db_version = 1.6;
309	317	/* udpate option with db version */
310	318	}
		@@ -311,10 +319,12 @@
311	319
312	320	if ( get_site_option( 'wdk_db_version' ) < '1.7' ) {
313	321
314	322	$table_name = $wpdb->prefix . 'wdk_listings';
315		- $sql = "ALTER TABLE `$table_name` ADD `listing_images_path` VARCHAR(200) DEFAULT ''";
316		- $wpdb->query($sql);
	323	+ $wpdb->query($wpdb->prepare(
	324	+ "ALTER TABLE `{$table_name}` ADD `listing_images_path` VARCHAR(200) DEFAULT ''"
	325	+ ));
	326	+
317	327
318	328	// TODO: this column content should be generated based on listing_images or old client may have issues after update
319	329
320	330	self::$db_version = 1.7;
		@@ -323,10 +333,12 @@
323	333
324	334	if ( get_site_option( 'wdk_db_version' ) < '1.8' ) {
325	335
326	336	$table_name = $wpdb->prefix . 'wdk_listings';
327		- $sql = "ALTER TABLE `$table_name` ADD `subscription_id` INT NULL; ";
328		- $wpdb->query($sql);
	337	+ $wpdb->query($wpdb->prepare(
	338	+ "ALTER TABLE `{$table_name}` ADD `subscription_id` INT NULL;"
	339	+ ));
	340	+
329	341
330	342	self::$db_version = 1.8;
331	343	/* udpate option with db version */
332	344	}
		@@ -333,10 +345,12 @@
333	345
334	346	if ( get_site_option( 'wdk_db_version' ) < '1.9' ) {
335	347
336	348	$table_name = $wpdb->prefix . 'wdk_fields';
337		- $sql = "ALTER TABLE `$table_name` ADD `is_price_format` tinyint(1) DEFAULT NULL; ";
338		- $wpdb->query($sql);
	349	+ $wpdb->query($wpdb->prepare(
	350	+ "ALTER TABLE `{$table_name}` ADD `is_price_format` tinyint(1) DEFAULT NULL;"
	351	+ ));
	352	+
339	353
340	354	self::$db_version = 1.9;
341	355	/* udpate option with db version */
342	356	}
		@@ -343,10 +357,12 @@
343	357
344	358	if ( get_site_option( 'wdk_db_version' ) < '2.0' ) {
345	359
346	360	$table_name = $wpdb->prefix . 'wdk_resultitem';
347		- $sql = "ALTER TABLE `$table_name` ADD `is_multiline_enabled` tinyint(1) DEFAULT NULL; ";
348		- $wpdb->query($sql);
	361	+ $wpdb->query($wpdb->prepare(
	362	+ "ALTER TABLE `{$table_name}` ADD `is_multiline_enabled` tinyint(1) DEFAULT NULL;"
	363	+ ));
	364	+
349	365
350	366	self::$db_version = 2.0;
351	367	/* udpate option with db version */
352	368	}
		@@ -353,25 +369,27 @@
353	369
354	370	if ( get_site_option( 'wdk_db_version' ) < '2.1' ) {
355	371
356	372	$table_name = $wpdb->prefix . 'wdk_listings';
357		- $sql = "ALTER TABLE `$table_name` ADD `user_id_editor` INT DEFAULT NULL;";
358		- $wpdb->query($sql);
	373	+ $wpdb->query($wpdb->prepare(
	374	+ "ALTER TABLE `{$table_name}` ADD `user_id_editor` INT DEFAULT NULL;"
	375	+ ));
359	376
360	377	$table_user_name = $wpdb->prefix . 'wdk_listings_users';
361	378
362	379	/* copy agents to new column */
363		- $sql = "UPDATE
364		- `$table_name` table_listings ,
365		- `$table_user_name` table_users
366		- SET
367		- table_listings.user_id_editor = table_users.user_id
368		- WHERE
369		- table_listings.post_id = table_users.post_id;";
370		- $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	+ ));
371	387
372		- $sql = "TRUNCATE TABLE `$table_user_name`";
373		- $wpdb->query($sql);
	388	+ $wpdb->query($wpdb->prepare(
	389	+ "TRUNCATE TABLE `{$table_name}`"
	390	+ ));
	391	+
374	392
375	393	self::$db_version = 2.1;
376	394	/* udpate option with db version */
377	395	}
		@@ -378,35 +396,42 @@
378	396
379	397	if ( get_site_option( 'wdk_db_version' ) < '2.2' ) {
380	398
381	399	$table_name = $wpdb->prefix . 'wdk_locations';
382		- $sql = "ALTER TABLE `$table_name` ADD `level_0_id` INT DEFAULT NULL;";
383		- $wpdb->query($sql);
	400	+ $wpdb->query($wpdb->prepare(
	401	+ "ALTER TABLE `{$table_name}` ADD `level_0_id` INT DEFAULT NULL;"
	402	+ ));
384	403
385	404	$table_name = $wpdb->prefix . 'wdk_categories';
386		- $sql = "ALTER TABLE `$table_name` ADD `level_0_id` INT DEFAULT NULL;";
387		- $wpdb->query($sql);
	405	+ $wpdb->query($wpdb->prepare(
	406	+ "ALTER TABLE `{$table_name}` ADD `level_0_id` INT DEFAULT NULL;"
	407	+ ));
388	408
389		-
390	409	$table_name = $wpdb->prefix . 'wdk_listings_locations';
391		- $sql = "CREATE TABLE IF NOT EXISTS `$table_name` (
	410	+ $sql = $wpdb->prepare(
	411	+ "CREATE TABLE IF NOT EXISTS `{$table_name}` (
392	412	`idlistings_locations` int(11) NOT NULL AUTO_INCREMENT,
393	413	`location_id` int DEFAULT NULL,
394	414	`post_id` int DEFAULT NULL,
395		- PRIMARY KEY (idlistings_locations)
396		- ) $charset_collate;";
	415	+ PRIMARY KEY (idlistings_locations)
	416	+ ) $charset_collate;"
	417	+ );
397	418	dbDelta( $sql );
398	419
399	420	$table_name = $wpdb->prefix . 'wdk_listings_categories';
400		- $sql = "CREATE TABLE IF NOT EXISTS `$table_name` (
	421	+ $sql = $wpdb->prepare(
	422	+ "CREATE TABLE IF NOT EXISTS `{$table_name}` (
401	423	`idlistings_categories` int(11) NOT NULL AUTO_INCREMENT,
402	424	`category_id` int DEFAULT NULL,
403	425	`post_id` int DEFAULT NULL,
404		- PRIMARY KEY (idlistings_categories)
405		- ) $charset_collate;";
	426	+ PRIMARY KEY (idlistings_categories)
	427	+ ) $charset_collate;"
	428	+ );
406	429	dbDelta( $sql );
407	430
	431	+
408	432
	433	+
409	434	self::$db_version = 2.2;
410	435	/* udpate option with db version */
411	436	}
412	437
		@@ -412,10 +437,12 @@
412	437
413	438	if ( get_site_option( 'wdk_db_version' ) < '2.3' ) {
414	439
415	440	$table_name = $wpdb->prefix . 'wdk_listings';
416		- $sql = "ALTER TABLE `$table_name` ADD `listing_plans_documents` text DEFAULT '';";
417		- $wpdb->query($sql);
	441	+ $wpdb->query($wpdb->prepare(
	442	+ "ALTER TABLE `{$table_name}` ADD `listing_plans_documents` text DEFAULT '';"
	443	+ ));
	444	+
418	445
419	446	self::$db_version = 2.3;
420	447	/* udpate option with db version */
421	448	}
		@@ -422,10 +449,12 @@
422	449
423	450	if ( get_site_option( 'wdk_db_version' ) < '2.4' ) {
424	451
425	452	$table_name = $wpdb->prefix . 'wdk_resultitem';
426		- $sql = "ALTER TABLE `$table_name` ADD `is_label_disable` INT(1) NULL DEFAULT NULL";
427		- $wpdb->query($sql);
	453	+ $wpdb->query($wpdb->prepare(
	454	+ "ALTER TABLE `{$table_name}` ADD `is_label_disable` INT(1) NULL DEFAULT NULL"
	455	+ ));
	456	+
428	457
429	458	self::$db_version = 2.4;
430	459	/* udpate option with db version */
431	460	}
		@@ -432,14 +461,16 @@
432	461
433	462	if ( get_site_option( 'wdk_db_version' ) < '2.5' ) {
434	463
435	464	$table_name = $wpdb->prefix . 'wdk_listings';
436		- $sql = "ALTER TABLE `$table_name` ADD `categories_list` VARCHAR(128) DEFAULT ''";
437		- $wpdb->query($sql);
	465	+ $wpdb->query($wpdb->prepare(
	466	+ "ALTER TABLE `{$table_name}` ADD `categories_list` VARCHAR(128) DEFAULT ''"
	467	+ ));
438	468
439		- $table_name = $wpdb->prefix . 'wdk_listings';
440		- $sql = "ALTER TABLE `$table_name` ADD `locations_list` VARCHAR(128) DEFAULT ''";
441		- $wpdb->query($sql);
	469	+ $wpdb->query($wpdb->prepare(
	470	+ "ALTER TABLE `{$table_name}` ADD `locations_list` VARCHAR(128) DEFAULT ''"
	471	+ ));
	472	+
442	473
443	474
444	475	self::$db_version = 2.5;
445	476	/* udpate option with db version */
		@@ -447,11 +478,14 @@
447	478
448	479	if ( get_site_option( 'wdk_db_version' ) < '2.6' ) {
449	480
450	481	$table_name = $wpdb->prefix . 'wdk_fields';
	482	+ $wpdb->query($wpdb->prepare(
	483	+ "UPDATE `{$table_name}` SET `is_visible_frontend` = %d",
	484	+ 1
	485	+ ));
451	486
452		- $sql = "UPDATE `$table_name` SET `is_visible_frontend` = '1'";
453		- $wpdb->query($sql);
	487	+
454	488
455	489	self::$db_version = 2.6;
456	490	/* udpate option with db version */
457	491	}
		@@ -457,10 +491,12 @@
457	491	}
458	492
459	493	if ( get_site_option( 'wdk_db_version' ) < '2.7' ) {
460	494	$table_name = $wpdb->prefix . 'wdk_listings';
461		- $sql = "ALTER TABLE `$table_name` ADD `listing_images_path_medium` VARCHAR(250) DEFAULT ''";
462		- $wpdb->query($sql);
	495	+ $wpdb->query($wpdb->prepare(
	496	+ "ALTER TABLE `{$table_name}` ADD `listing_images_path_medium` VARCHAR(250) DEFAULT ''"
	497	+ ));
	498	+
463	499
464	500	self::$db_version = 2.7;
465	501	/* udpate option with db version */
466	502	}
		@@ -469,9 +505,9 @@
469	505	// Main table for visited pages
470	506
471	507	$table_name = $wpdb->prefix . 'wdk_dependfields';
472	508
473		- $sql = "CREATE TABLE IF NOT EXISTS $table_name (
	509	+ $sql = $sql = "CREATE TABLE IF NOT EXISTS `{$table_name}` (
474	510	`iddependfields` int(11) NOT NULL AUTO_INCREMENT,
475	511	`main_field` varchar(60) DEFAULT '',
476	512	`field_id` int(11) DEFAULT NULL,
477	513	`hidden_fields_list` varchar(256) DEFAULT '',
		@@ -487,9 +523,17 @@
487	523
488	524	if ( get_site_option( 'wdk_db_version' ) < '2.9' ) {
489	525	// Main table for visited pages
490	526	global $wpdb;
491		- $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	+
492	536	self::$db_version = 2.9;
493	537	/* udpate option with db version */
494	538	}
495	539
		@@ -496,10 +540,13 @@
496	540	if ( get_site_option( 'wdk_db_version' ) < '3.0' ) {
497	541
498	542	$table_name = $wpdb->prefix . 'wdk_fields';
499	543
500		- $sql = "UPDATE `$table_name` SET `is_visible_dashboard` = '1'";
501		- $wpdb->query($sql);
	544	+ $wpdb->query($wpdb->prepare(
	545	+ "UPDATE `{$table_name}` SET is_visible_dashboard = %d",
	546	+ 1
	547	+ ));
	548	+
502	549
503	550	self::$db_version = 3.0;
504	551	/* udpate option with db version */
505	552	}
		@@ -506,21 +553,28 @@
506	553
507	554	if ( get_site_option( 'wdk_db_version' ) < '3.1' ) {
508	555
509	556	$table_name = $wpdb->prefix . 'wdk_locations';
510		- $sql = "ALTER TABLE `$table_name` ADD `icon_path` VARCHAR(100) DEFAULT ''";
511		- $wpdb->query($sql);
512		- $sql = "ALTER TABLE `$table_name` ADD `image_path` VARCHAR(100) DEFAULT ''";
513		- $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	+ ));
514	563
515	564	$table_name = $wpdb->prefix . 'wdk_categories';
516		- $sql = "ALTER TABLE `$table_name` ADD `icon_path` VARCHAR(100) DEFAULT ''";
517		- $wpdb->query($sql);
518		- $sql = "ALTER TABLE `$table_name` ADD `image_path` VARCHAR(100) DEFAULT ''";
519		- $wpdb->query($sql);
520		- $sql = "ALTER TABLE `$table_name` ADD `marker_image_path` VARCHAR(100) DEFAULT ''";
521		- $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	+ ));
522	574
	575	+
	576	+
523	577	// TODO: this column content should be generated based on listing_images or old client may have issues after update
524	578
525	579	self::$db_version = 3.1;
526	580	/* udpate option with db version */
		@@ -530,9 +584,9 @@
530	584	// Main table for visited pages
531	585
532	586	$table_name = $wpdb->prefix . 'wdk_token';
533	587
534		- $sql = "CREATE TABLE IF NOT EXISTS $table_name (
	588	+ $sql = "CREATE TABLE IF NOT EXISTS `{$table_name}` (
535	589	`idtoken` int(11) NOT NULL AUTO_INCREMENT,
536	590	`token` varchar(60) UNIQUE DEFAULT '',
537	591	`user_id` int(11) DEFAULT NULL,
538	592	`user_email` varchar(256) DEFAULT '',
		@@ -558,18 +612,21 @@
558	612	if ( get_site_option( 'wdk_db_version' ) < '3.4' ) {
559	613	// Main table for visited pages
560	614
561	615	$table_name = $wpdb->prefix . 'wdk_locations';
562		- $sql = "ALTER TABLE `$table_name` ADD `related_svg_map` varchar(64) DEFAULT NULL;";
563		- $wpdb->query($sql);
	616	+ $wpdb->query($wpdb->prepare(
	617	+ "ALTER TABLE `{$table_name}` ADD `related_svg_map` varchar(64) DEFAULT NULL;"
	618	+ ));
564	619
565	620	$table_name = $wpdb->prefix . 'wdk_locations';
566		- $sql = "ALTER TABLE `$table_name` ADD `related_svg_map_location` varchar(128) DEFAULT NULL;";
567		- $wpdb->query($sql);
	621	+ $wpdb->query($wpdb->prepare(
	622	+ "ALTER TABLE `{$table_name}` ADD `related_svg_map_location` varchar(128) DEFAULT NULL;"
	623	+ ));
568	624
569	625	$table_name = $wpdb->prefix . 'wdk_fields';
570		- $sql = "ALTER TABLE `$table_name` CHANGE `values_list` `values_list` TEXT NULL DEFAULT NULL;";
571		- $wpdb->query($sql);
	626	+ $wpdb->query($wpdb->prepare(
	627	+ "ALTER TABLE `{$table_name}` CHANGE `values_list` `values_list` TEXT NULL DEFAULT NULL;"
	628	+ ));
572	629
573	630	self::$db_version = 3.4;
574	631	/* udpate option with db version */
575	632	}
		@@ -577,26 +634,31 @@
577	634	if ( get_site_option( 'wdk_db_version' ) < '3.5' ) {
578	635	// Main table for visited pages
579	636
580	637	$table_name = $wpdb->prefix . 'wdk_categories';
581		- $sql = "ALTER TABLE `$table_name` ADD `category_color` varchar(32) DEFAULT NULL;";
582		- $wpdb->query($sql);
	638	+ $wpdb->query($wpdb->prepare(
	639	+ "ALTER TABLE `{$table_name}` ADD `category_color` varchar(32) DEFAULT NULL;"
	640	+ ));
583	641
584	642	$table_name = $wpdb->prefix . 'wdk_fields';
585		- $sql = "ALTER TABLE `$table_name` ADD `validation` varchar(64) DEFAULT NULL;";
586		- $wpdb->query($sql);
	643	+ $wpdb->query($wpdb->prepare(
	644	+ "ALTER TABLE `{$table_name}` ADD `validation` varchar(64) DEFAULT NULL;"
	645	+ ));
587	646
588	647	$table_name = $wpdb->prefix . 'wdk_fields';
589		- $sql = "ALTER TABLE `$table_name` ADD `min_length` INT(3) DEFAULT NULL;";
590		- $wpdb->query($sql);
	648	+ $wpdb->query($wpdb->prepare(
	649	+ "ALTER TABLE `{$table_name}` ADD `min_length` INT(3) DEFAULT NULL;"
	650	+ ));
591	651
592	652	$table_name = $wpdb->prefix . 'wdk_listings';
593		- $sql = "ALTER TABLE `$table_name` CHANGE `listing_images_path` `listing_images_path` TEXT DEFAULT '';";
594		- $wpdb->query($sql);
	653	+ $wpdb->query($wpdb->prepare(
	654	+ "ALTER TABLE `{$table_name}` CHANGE `listing_images_path` `listing_images_path` TEXT DEFAULT '';"
	655	+ ));
595	656
596	657	$table_name = $wpdb->prefix . 'wdk_listings';
597		- $sql = "ALTER TABLE `$table_name` CHANGE `listing_images_path_medium` `listing_images_path_medium` TEXT DEFAULT '';";
598		- $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	+ ));
599	661
600	662	self::$db_version = 3.5;
601	663	/* udpate option with db version */
602	664	}
		@@ -604,18 +666,21 @@
604	666	if ( get_site_option( 'wdk_db_version' ) < '3.6' ) {
605	667
606	668	$table_name = $wpdb->prefix . 'wdk_fields';
607	669
608		- $sql = "UPDATE `$table_name` SET `is_visible_dashboard` = '1'";
609		- $wpdb->query($sql);
	670	+ $wpdb->query($wpdb->prepare(
	671	+ "UPDATE `{$table_name}` SET `is_visible_dashboard` = '1'"
	672	+ ));
610	673
611	674	$table_name = $wpdb->prefix . 'wdk_listings';
612		- $sql = "ALTER TABLE `$table_name` CHANGE `locations_list` `locations_list` TEXT DEFAULT '';";
613		- $wpdb->query($sql);
	675	+ $wpdb->query($wpdb->prepare(
	676	+ "ALTER TABLE `{$table_name}` CHANGE `locations_list` `locations_list` TEXT DEFAULT '';"
	677	+ ));
614	678
615	679	$table_name = $wpdb->prefix . 'wdk_listings';
616		- $sql = "ALTER TABLE `$table_name` CHANGE `categories_list` `categories_list` TEXT DEFAULT '';";
617		- $wpdb->query($sql);
	680	+ $wpdb->query($wpdb->prepare(
	681	+ "ALTER TABLE `{$table_name}` CHANGE `categories_list` `categories_list` TEXT DEFAULT '';"
	682	+ ));
618	683
619	684	self::$db_version = 3.6;
620	685	/* udpate option with db version */
621	686	}
		@@ -623,10 +688,11 @@
623	688	if ( get_site_option( 'wdk_db_version' ) < '3.7' ) {
624	689
625	690	$table_name = $wpdb->prefix . 'wdk_fields';
626	691
627		- $sql = "ALTER TABLE `$table_name` ADD `placeholder` varchar(128) DEFAULT NULL;";
628		- $wpdb->query($sql);
	692	+ $wpdb->query($wpdb->prepare(
	693	+ "ALTER TABLE `{$table_name}` ADD `placeholder` varchar(128) DEFAULT NULL;"
	694	+ ));
629	695
630	696	self::$db_version = 3.7;
631	697	/* udpate option with db version */
632	698	}
		@@ -633,10 +699,11 @@
633	699
634	700	if ( get_site_option( 'wdk_db_version' ) < '3.8' ) {
635	701
636	702	$table_name = $wpdb->prefix . 'wdk_messages';
637		- $sql = "ALTER TABLE `$table_name` ADD `is_notified` tinyint(1) DEFAULT NULL; ";
638		- $wpdb->query($sql);
	703	+ $wpdb->query($wpdb->prepare(
	704	+ "ALTER TABLE `{$table_name}` ADD `is_notified` tinyint(1) DEFAULT NULL; "
	705	+ ));
639	706
640	707	self::$db_version = 3.8;
641	708	/* udpate option with db version */
642	709	}
		@@ -644,9 +711,9 @@
644	711	if ( get_site_option( 'wdk_db_version' ) < '3.9' ) {
645	712
646	713	$table_name = $wpdb->prefix . 'wdk_users';
647	714
648		- $sql = "CREATE TABLE IF NOT EXISTS `$table_name` (
	715	+ $sql = "CREATE TABLE IF NOT EXISTS `{$table_name}` (
649	716	`idusers` int(11) NOT NULL AUTO_INCREMENT,
650	717	`cacheduser_user_id` int(11) DEFAULT NULL,
651	718	`cacheduser_profile_url` text DEFAULT NULL,
652	719	`cacheduser_display_name` text DEFAULT NULL,
		@@ -682,18 +749,19 @@
682	749
683	750	if ( get_site_option( 'wdk_db_version' ) < '4.0' ) {
684	751
685	752	$table_name = $wpdb->prefix . 'wdk_listings';
686		- $sql = "ALTER TABLE `$table_name` ADD `listing_related_ids` VARCHAR(512) DEFAULT ''";
687		- $wpdb->query($sql);
	753	+ $wpdb->query($wpdb->prepare(
	754	+ "ALTER TABLE `{$table_name}` ADD `listing_related_ids` VARCHAR(512) DEFAULT ''"
	755	+ ));
688	756
689		- $table_name = $wpdb->prefix . 'wdk_listings';
690		- $sql = "ALTER TABLE `$table_name` ADD `sublisting_order` INT(11) DEFAULT NULL";
691		- $wpdb->query($sql);
	757	+ $wpdb->query($wpdb->prepare(
	758	+ "ALTER TABLE `{$table_name}` ADD `sublisting_order` INT(11) DEFAULT NULL"
	759	+ ));
692	760
693		- $table_name = $wpdb->prefix . 'wdk_listings';
694		- $sql = "ALTER TABLE `$table_name` ADD `listing_parent_post_id` INT(11) DEFAULT NULL";
695		- $wpdb->query($sql);
	761	+ $wpdb->query($wpdb->prepare(
	762	+ "ALTER TABLE `{$table_name}` ADD `listing_parent_post_id` INT(11) DEFAULT NULL"
	763	+ ));
696	764
697	765	/* disable elmentor experement feature */
698	766	update_option( 'elementor_experiment-landing-pages', 'inactive' );
699	767	update_option( 'elementor_experiment-e_dom_optimization', 'inactive');
		@@ -704,10 +772,11 @@
704	772
705	773	if ( get_site_option( 'wdk_db_version' ) < '4.1' ) {
706	774
707	775	$table_name = $wpdb->prefix . 'wdk_dependfields';
708		- $sql = "ALTER TABLE `$table_name` CHANGE `hidden_fields_list` `hidden_fields_list` TEXT NULL DEFAULT NULL;";
709		- $wpdb->query($sql);
	776	+ $wpdb->query($wpdb->prepare(
	777	+ "ALTER TABLE `{$table_name}` CHANGE `hidden_fields_list` `hidden_fields_list` TEXT NULL DEFAULT NULL;"
	778	+ ));
710	779
711	780	self::$db_version = 4.1;
712	781	/* udpate option with db version */
713	782	}
		@@ -720,9 +789,10 @@
720	789
721	790	if ( get_site_option( 'wdk_db_version' ) < '4.3' ) {
722	791	$table_name = $wpdb->prefix . 'wdk_editlog';
723	792
724		- $sql = "CREATE TABLE IF NOT EXISTS `$table_name` (
	793	+ $sql = $wpdb->prepare(
	794	+ "CREATE TABLE IF NOT EXISTS `{$table_name}` (
725	795	`ideditlog` int(11) NOT NULL AUTO_INCREMENT,
726	796	`post_id` int(11) DEFAULT NULL,
727	797	`user_id` int(11) DEFAULT NULL,
728	798	`date` datetime DEFAULT NULL,
		@@ -728,9 +798,10 @@
728	798	`date` datetime DEFAULT NULL,
729	799	`ip` text DEFAULT NULL,
730	800	`comment` text DEFAULT NULL,
731	801	PRIMARY KEY (ideditlog)
732		- ) $charset_collate;";
	802	+ ) $charset_collate;"
	803	+ );
733	804
734	805	dbDelta( $sql );
735	806	self::$db_version = 4.3;
736	807	/* udpate option with db version */
		@@ -754,14 +825,126 @@
754	825	update_option( 'wdk_is_post_content_enable', '1');
755	826	update_option( 'wdk_is_alt_agent_enabled', '1');
756	827
757	828	$table_name = $wpdb->prefix . 'wdk_users';
758		- $sql = "ALTER TABLE `$table_name` ADD `cacheduser_agency_name` text DEFAULT ''";
759		- $wpdb->query($sql);
	829	+ $wpdb->query($wpdb->prepare(
	830	+ "ALTER TABLE `{$table_name}` ADD `cacheduser_agency_name` text DEFAULT ''"
	831	+ ));
760	832
761	833	self::$db_version = 4.5;
762	834	/* udpate option with db version */
763	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	+ }
764	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	+
765	948	update_option( 'wdk_db_version', self::$db_version );
766	949	}
767		-}
	950	+}