Code Coverage |
||||||||||
Classes and Traits |
Functions and Methods |
Lines |
||||||||
| Total | |
0.00% |
0 / 1 |
|
0.00% |
0 / 8 |
CRAP | |
0.00% |
0 / 80 |
| remove_profilefield_wlm | |
0.00% |
0 / 1 |
|
0.00% |
0 / 8 |
90 | |
0.00% |
0 / 80 |
| depends_on | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 2 |
|||
| update_schema | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 5 |
|||
| revert_schema | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 5 |
|||
| update_data | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 2 |
|||
| revert_data | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 2 |
|||
| delete_custom_profile_field_data | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 11 |
|||
| get_custom_profile_field_id | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 6 |
|||
| create_custom_field | |
0.00% |
0 / 1 |
6 | |
0.00% |
0 / 47 |
|||
| <?php | |
| /** | |
| * | |
| * This file is part of the phpBB Forum Software package. | |
| * | |
| * @copyright (c) phpBB Limited <https://www.phpbb.com> | |
| * @license GNU General Public License, version 2 (GPL-2.0) | |
| * | |
| * For full copyright and license information, please see | |
| * the docs/CREDITS.txt file. | |
| * | |
| */ | |
| namespace phpbb\db\migration\data\v320; | |
| class remove_profilefield_wlm extends \phpbb\db\migration\migration | |
| { | |
| static public function depends_on() | |
| { | |
| return array( | |
| '\phpbb\db\migration\data\v320\dev', | |
| ); | |
| } | |
| public function update_schema() | |
| { | |
| return array( | |
| 'drop_columns' => array( | |
| $this->table_prefix . 'profile_fields_data' => array( | |
| 'pf_phpbb_wlm', | |
| ), | |
| ), | |
| ); | |
| } | |
| public function revert_schema() | |
| { | |
| return array( | |
| 'add_columns' => array( | |
| $this->table_prefix . 'profile_fields_data' => array( | |
| 'pf_phpbb_wlm' => array('VCHAR', ''), | |
| ), | |
| ), | |
| ); | |
| } | |
| public function update_data() | |
| { | |
| return array( | |
| array('custom', array(array($this, 'delete_custom_profile_field_data'))), | |
| ); | |
| } | |
| public function revert_data() | |
| { | |
| return array( | |
| array('custom', array(array($this, 'create_custom_field'))), | |
| ); | |
| } | |
| public function delete_custom_profile_field_data() | |
| { | |
| $field_id = $this->get_custom_profile_field_id(); | |
| $sql = 'DELETE FROM ' . PROFILE_FIELDS_TABLE . ' | |
| WHERE field_id = ' . (int) $field_id; | |
| $this->db->sql_query($sql); | |
| $sql = 'DELETE FROM ' . PROFILE_LANG_TABLE . ' | |
| WHERE field_id = ' . (int) $field_id; | |
| $this->db->sql_query($sql); | |
| $sql = 'DELETE FROM ' . PROFILE_FIELDS_LANG_TABLE . ' | |
| WHERE field_id = ' . (int) $field_id; | |
| $this->db->sql_query($sql); | |
| } | |
| /** | |
| * Get custom profile field id | |
| * @return int custom profile filed id | |
| */ | |
| public function get_custom_profile_field_id() | |
| { | |
| $sql = 'SELECT field_id | |
| FROM ' . PROFILE_FIELDS_TABLE . " | |
| WHERE field_name = 'phpbb_wlm'"; | |
| $result = $this->db->sql_query($sql); | |
| $field_id = (int) $this->db->sql_fetchfield('field_id'); | |
| $this->db->sql_freeresult($result); | |
| return $field_id; | |
| } | |
| public function create_custom_field() | |
| { | |
| $sql = 'SELECT MAX(field_order) as max_field_order | |
| FROM ' . PROFILE_FIELDS_TABLE; | |
| $result = $this->db->sql_query($sql); | |
| $max_field_order = (int) $this->db->sql_fetchfield('max_field_order'); | |
| $this->db->sql_freeresult($result); | |
| $sql_ary = array( | |
| 'field_name' => 'phpbb_wlm', | |
| 'field_type' => 'profilefields.type.string', | |
| 'field_ident' => 'phpbb_wlm', | |
| 'field_length' => '40', | |
| 'field_minlen' => '5', | |
| 'field_maxlen' => '255', | |
| 'field_novalue' => '', | |
| 'field_default_value' => '', | |
| 'field_validation' => '.*', | |
| 'field_required' => 0, | |
| 'field_show_novalue' => 0, | |
| 'field_show_on_reg' => 0, | |
| 'field_show_on_pm' => 1, | |
| 'field_show_on_vt' => 1, | |
| 'field_show_on_ml' => 0, | |
| 'field_show_profile' => 1, | |
| 'field_hide' => 0, | |
| 'field_no_view' => 0, | |
| 'field_active' => 1, | |
| 'field_is_contact' => 1, | |
| 'field_contact_desc' => '', | |
| 'field_contact_url' => '', | |
| 'field_order' => $max_field_order + 1, | |
| ); | |
| $sql = 'INSERT INTO ' . PROFILE_FIELDS_TABLE . ' ' . $this->db->sql_build_array('INSERT', $sql_ary); | |
| $this->db->sql_query($sql); | |
| $field_id = (int) $this->db->sql_nextid(); | |
| $insert_buffer = new \phpbb\db\sql_insert_buffer($this->db, PROFILE_LANG_TABLE); | |
| $sql = 'SELECT lang_id | |
| FROM ' . LANG_TABLE; | |
| $result = $this->db->sql_query($sql); | |
| $lang_name = 'WLM'; | |
| while ($lang_id = (int) $this->db->sql_fetchfield('lang_id')) | |
| { | |
| $insert_buffer->insert(array( | |
| 'field_id' => (int) $field_id, | |
| 'lang_id' => (int) $lang_id, | |
| 'lang_name' => $lang_name, | |
| 'lang_explain' => '', | |
| 'lang_default_value' => '', | |
| )); | |
| } | |
| $this->db->sql_freeresult($result); | |
| $insert_buffer->flush(); | |
| } | |
| } |