marc1706\quickedit\migrations\v10x\beta1

Complexity

Total Complexity

9

Size/Duplication

Total Lines	67
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	effectively_installed()	0	4	1
A	depends_on()	0	4	1
A	update_data()	0	6	1
A	revert_data()	0	6	1
A	revert_forum_flags()	0	15	3
A	update_schema()	0	10	1
A	revert_schema()	0	10	1

<?php
/**
*
* @package Quickedit
* @copyright (c) 2015 - 2021 Marc Alexander ( www.m-a-styles.de )
* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2
*
*/

namespace marc1706\quickedit\migrations\v10x;

class beta1 extends \phpbb\db\migration\migration
{
	/** @var int quickedit forums flag */
	const QUICKEDIT_FLAG = 128;

	public function effectively_installed()
	{
		return isset($this->config['allow_quick_edit']);
	}

	public function update_schema()
	{
		return array(
			'change_columns'	=> array(
				$this->table_prefix . 'forums'			=> array(
					'forum_flags'		=> array('UINT', 32),
				),
			),
		);
	}

	public function revert_schema()
	{
		return array(
			'change_columns'	=> array(
				$this->table_prefix . 'forums'			=> array(
					'forum_flags'		=> array('TINT:4', 32),
				),
			),
		);
	}

	static public function depends_on()
	{
		return array('\phpbb\db\migration\data\v310\dev');
	}

	public function update_data()
	{
		return array(
			array('config.add', array('allow_quick_edit', 0)),
		);
	}

	public function revert_data()
	{
		return array(
			array('custom', array(array($this, 'revert_forum_flags'))),
		);
	}

	public function revert_forum_flags()
	{
		$sql = 'SELECT forum_id, forum_flags FROM ' . FORUMS_TABLE . '
				WHERE forum_flags >= ' . self::QUICKEDIT_FLAG;
		$result = $this->db->sql_query($sql);

		while ($row = $this->db->sql_fetchrow($result))
		{
			$sql = 'UPDATE ' . FORUMS_TABLE . '
					SET forum_flags = ' . (($row['forum_flags'] & self::QUICKEDIT_FLAG) ? $row['forum_flags'] - self::QUICKEDIT_FLAG : $row['forum_flags']) . '
					WHERE forum_id = ' . (int) $row['forum_id'];
			$this->db->sql_query($sql);
		}
		$this->db->sql_freeresult($result);
	}
}