Code Coverage
 
Classes and Traits
Functions and Methods
Lines
Total
0.00% covered (danger)
0.00%
0 / 1
0.00% covered (danger)
0.00%
0 / 8
CRAP
0.00% covered (danger)
0.00%
0 / 67
remove_profilefield_wlm
0.00% covered (danger)
0.00%
0 / 1
0.00% covered (danger)
0.00%
0 / 8
90.00
0.00% covered (danger)
0.00%
0 / 67
 depends_on
0.00% covered (danger)
0.00%
0 / 1
2.00
0.00% covered (danger)
0.00%
0 / 1
 update_schema
0.00% covered (danger)
0.00%
0 / 1
2.00
0.00% covered (danger)
0.00%
0 / 2
 revert_schema
0.00% covered (danger)
0.00%
0 / 1
2.00
0.00% covered (danger)
0.00%
0 / 2
 update_data
0.00% covered (danger)
0.00%
0 / 1
2.00
0.00% covered (danger)
0.00%
0 / 1
 revert_data
0.00% covered (danger)
0.00%
0 / 1
2.00
0.00% covered (danger)
0.00%
0 / 1
 delete_custom_profile_field_data
0.00% covered (danger)
0.00%
0 / 1
2.00
0.00% covered (danger)
0.00%
0 / 11
 get_custom_profile_field_id
0.00% covered (danger)
0.00%
0 / 1
2.00
0.00% covered (danger)
0.00%
0 / 5
 create_custom_field
0.00% covered (danger)
0.00%
0 / 1
6.00
0.00% covered (danger)
0.00%
0 / 44
<?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();
    }
}