blitze\sitemaker\migrations\v20x\m12_add_hidden_forum_column

Complexity

Total Complexity

4

Size/Duplication

Total Lines	50
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes	1
Bugs	1	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	effectively_installed()	0	4	1
A	update_schema()	0	10	1
A	update_data()	0	6	1
A	update_blocks_settings()	0	8	1

<?php
/**
 *
 * @package sitemaker
 * @copyright (c) 2013 Daniel A. (blitze)
 * @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2
 *
 */

namespace blitze\sitemaker\migrations\v20x;

/**
 * Initial schema changes needed for Extension installation
 */
class m12_add_hidden_forum_column extends \phpbb\db\migration\migration
{

	/**
	 * Skip this migration if the hidden_forum column already exists
	 *
	 * @return bool True to skip this migration, false to run it
	 * @access public
	 */
	public function effectively_installed()
	{
		return $this->db_tools->sql_column_exists($this->table_prefix . 'forums', 'hidden_forum');
	}

	/**
	 * Update forums table schema
	 *
	 * @return array Array of table schema
	 * @access public
	 */
	public function update_schema()
	{
		return array(
			'add_columns'	=> array(
				$this->table_prefix . 'forums'	=> array(
					'hidden_forum'		=> array('BOOL', 0),
				),
			),
		);
	}

	/**
	 * @inheritdoc
	 */
	public function update_data()
	{
		return array(
			array('custom', array(array($this, 'set_hidden_forums'))),
		);
	}

	public function update_blocks_settings()
	{
		$data = array(
			'hidden_forum' => 1,
		);
		$sql = 'UPDATE ' . FORUMS_TABLE . ' SET ' . $this->db->sql_build_array('UPDATE', $data) . ' WHERE forum_id = ' . (int) $this->config['sitemaker_parent_forum_id'];
		$this->db->sql_query($sql);
	}
}