Code Coverage |
||||||||||
Classes and Traits |
Functions and Methods |
Lines |
||||||||
| Total | |
0.00% |
0 / 1 |
|
0.00% |
0 / 3 |
CRAP | |
0.00% |
0 / 33 |
| remove_outdated_media | |
0.00% |
0 / 1 |
|
0.00% |
0 / 3 |
42 | |
0.00% |
0 / 33 |
| depends_on | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 2 |
|||
| update_data | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 2 |
|||
| change_extension_group | |
0.00% |
0 / 1 |
20 | |
0.00% |
0 / 29 |
|||
| <?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_outdated_media extends \phpbb\db\migration\migration | |
| { | |
| // Following constants were deprecated in 3.2 | |
| // and moved from constants.php to compatibility_globals.php, | |
| // thus define them as class constants | |
| const ATTACHMENT_CATEGORY_WM = 2; | |
| const ATTACHMENT_CATEGORY_RM = 3; | |
| const ATTACHMENT_CATEGORY_QUICKTIME = 6; | |
| protected $cat_id = array( | |
| self::ATTACHMENT_CATEGORY_WM, | |
| self::ATTACHMENT_CATEGORY_RM, | |
| self::ATTACHMENT_CATEGORY_QUICKTIME, | |
| ); | |
| static public function depends_on() | |
| { | |
| return array( | |
| '\phpbb\db\migration\data\v320\dev', | |
| ); | |
| } | |
| public function update_data() | |
| { | |
| return array( | |
| array('custom', array(array($this, 'change_extension_group'))), | |
| ); | |
| } | |
| public function change_extension_group() | |
| { | |
| // select group ids of outdated media | |
| $sql = 'SELECT group_id | |
| FROM ' . EXTENSION_GROUPS_TABLE . ' | |
| WHERE ' . $this->db->sql_in_set('cat_id', $this->cat_id); | |
| $result = $this->db->sql_query($sql); | |
| $group_ids = array(); | |
| while ($group_id = (int) $this->db->sql_fetchfield('group_id')) | |
| { | |
| $group_ids[] = $group_id; | |
| } | |
| $this->db->sql_freeresult($result); | |
| // nothing to do, admin has removed all the outdated media extension groups | |
| if (empty($group_ids)) | |
| { | |
| return true; | |
| } | |
| // get the group id of downloadable files | |
| $sql = 'SELECT group_id | |
| FROM ' . EXTENSION_GROUPS_TABLE . " | |
| WHERE group_name = 'DOWNLOADABLE_FILES'"; | |
| $result = $this->db->sql_query($sql); | |
| $download_id = (int) $this->db->sql_fetchfield('group_id'); | |
| $this->db->sql_freeresult($result); | |
| if (empty($download_id)) | |
| { | |
| $sql = 'UPDATE ' . EXTENSIONS_TABLE . ' | |
| SET group_id = 0 | |
| WHERE ' . $this->db->sql_in_set('group_id', $group_ids); | |
| } | |
| else | |
| { | |
| // move outdated media extensions to downloadable files | |
| $sql = 'UPDATE ' . EXTENSIONS_TABLE . " | |
| SET group_id = $download_id" . ' | |
| WHERE ' . $this->db->sql_in_set('group_id', $group_ids); | |
| } | |
| $this->db->sql_query($sql); | |
| // delete the now empty, outdated media extension groups | |
| $sql = 'DELETE FROM ' . EXTENSION_GROUPS_TABLE . ' | |
| WHERE ' . $this->db->sql_in_set('group_id', $group_ids); | |
| $this->db->sql_query($sql); | |
| } | |
| } |