Edit File by line

[500] Fix | Delete

$value = maybe_serialize( $value );

[501] Fix | Delete

$this->db->escape_by_ref( $key );

[502] Fix | Delete

$this->db->escape_by_ref( $value );

[503] Fix | Delete

if( ! isset( $this->update_field_meta[ $this->update_field_meta_chunk ] ) || ! $this->update_field_meta[ $this->update_field_meta_chunk ] ) {

[504] Fix | Delete

$this->update_field_meta[ $this->update_field_meta_chunk ] = '';

[505] Fix | Delete

}

[506] Fix | Delete

$this->update_field_meta[ $this->update_field_meta_chunk ] .= " WHEN `parent_id` = '{$field_id}' AND `key` = '{$key}' THEN '{$value}'";

[507] Fix | Delete

[508] Fix | Delete

$counter++;

[509] Fix | Delete

if( 0 == $counter % 5000 ) $this->update_field_meta_chunk++;

[510] Fix | Delete

}

[511] Fix | Delete

public function run_update_field_meta_query()

[512] Fix | Delete

{

[513] Fix | Delete

if( empty( $this->update_field_meta ) ) return '';

[514] Fix | Delete

foreach( $this->update_field_meta as $update_field_meta ){

[515] Fix | Delete

[516] Fix | Delete

$sql = "UPDATE {$this->db->prefix}nf3_field_meta as field_meta

[517] Fix | Delete

SET `value` = CASE {$update_field_meta} ELSE `value` END";

[518] Fix | Delete

/**

[519] Fix | Delete

* If we have completed stage 1 of our db update process, then we want to update meta_value as well as value.

[520] Fix | Delete

[521] Fix | Delete

if ( $this->db_stage_1_complete ) {

[522] Fix | Delete

$sql .= ", `meta_value` = CASE {$update_field_meta} ELSE `meta_value` END, `meta_key` = CASE WHEN `parent_id` = '-999' THEN NULL ELSE `key` END";

[523] Fix | Delete

}

[524] Fix | Delete

[525] Fix | Delete

$this->db->query( $sql );

[526] Fix | Delete

return;

[527] Fix | Delete

}

[528] Fix | Delete

}

[529] Fix | Delete

}

[530] Fix | Delete