From bbada27ee9e797c7f6ce997152bc1efb8c8f125d Mon Sep 17 00:00:00 2001 From: Joas Schilling Date: Sun, 2 Feb 2014 21:45:59 +0100 Subject: [ticket/12115] Also port user interests to profile fields PHPBB3-12115 --- phpBB/phpbb/db/migration/data/v310/profilefield_occupation.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'phpBB/phpbb/db/migration/data') diff --git a/phpBB/phpbb/db/migration/data/v310/profilefield_occupation.php b/phpBB/phpbb/db/migration/data/v310/profilefield_occupation.php index 09c71127f9..ee276fa0f9 100644 --- a/phpBB/phpbb/db/migration/data/v310/profilefield_occupation.php +++ b/phpBB/phpbb/db/migration/data/v310/profilefield_occupation.php @@ -19,7 +19,7 @@ class profilefield_occupation extends \phpbb\db\migration\migration static public function depends_on() { return array( - '\phpbb\db\migration\data\v310\profilefield_types', + '\phpbb\db\migration\data\v310\profilefield_interests', ); } @@ -83,7 +83,7 @@ class profilefield_occupation extends \phpbb\db\migration\migration $result = $this->db->sql_query($sql); while ($lang_id = (int) $this->db->sql_fetchfield('lang_id')) { - $insert_buffer->add(array( + $insert_buffer->insert(array( 'field_id' => $field_id, 'lang_id' => $lang_id, 'lang_name' => 'OCCUPATION', @@ -120,7 +120,7 @@ class profilefield_occupation extends \phpbb\db\migration\migration 'pf_phpbb_occupation' => $row['user_occ'], ); - $sql = 'UPDATE ' . $this->fields_data_table . ' + $sql = 'UPDATE ' . $this->table_prefix . 'profile_fields_data SET ' . $this->db->sql_build_array('UPDATE', $cp_data) . ' WHERE user_id = ' . (int) $row['user_id']; $this->db->sql_query($sql); -- cgit v1.2.1