← All changes | application/models/Listingfield_m.php +23 -0 1.2.9 → 1.5.9 View file →

		@@ -122,8 +122,13 @@
122	122	{
123	123	$sql = "ALTER TABLE `{$table}`
124	124	ADD `$column_name` TEXT NULL DEFAULT NULL;";
125	125	}
	126	+ else if($field_data['field_type'] == 'FILEUPLOAD')
	127	+ {
	128	+ $sql = "ALTER TABLE `{$table}`
	129	+ ADD `$column_name` TEXT NULL DEFAULT NULL;";
	130	+ }
126	131	else if($field_data['field_type'] == 'TEXTAREA_WYSIWYG')
127	132	{
128	133	$sql = "ALTER TABLE `{$table}`
129	134	ADD `$column_name` TEXT NULL DEFAULT NULL;";
		@@ -147,9 +152,27 @@
147	152	return false;
148	153	}
149	154
150	155	if(!isset($existing_fields[$column_name]))
	156	+ // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
151	157	$query_result = $wpdb->query( $sql );
	158	+
	159	+ }
	160	+
	161	+ // Create table column for new added or edited fields
	162	+ public function delete_table_column($field_data, $field_id)
	163	+ {
	164	+ global $wpdb;
	165	+
	166	+ $table = $wpdb->prefix . 'wdk_listings_fields';
	167	+ $column_name = 'field_'.$field_id.'_'.wmvc_show_data('field_type',$field_data);
	168	+
	169	+ $query_result = $wpdb->query(
	170	+ $wpdb->prepare(
	171	+ "ALTER TABLE `{$table}` DROP %s;",
	172	+ $column_name
	173	+ )
	174	+ );
152	175	}
153	176
154	177	}
155	178	?>