Code Coverage |
||||||||||
Lines |
Functions and Methods |
Classes and Traits |
||||||||
| Total | |
0.00% |
0 / 277 |
|
0.00% |
0 / 13 |
CRAP | |
0.00% |
0 / 1 |
| dev | |
0.00% |
0 / 277 |
|
0.00% |
0 / 13 |
756 | |
0.00% |
0 / 1 |
| effectively_installed | |
0.00% |
0 / 1 |
|
0.00% |
0 / 1 |
2 | |||
| depends_on | |
0.00% |
0 / 7 |
|
0.00% |
0 / 1 |
2 | |||
| update_schema | |
0.00% |
0 / 26 |
|
0.00% |
0 / 1 |
2 | |||
| revert_schema | |
0.00% |
0 / 21 |
|
0.00% |
0 / 1 |
2 | |||
| update_data | |
0.00% |
0 / 101 |
|
0.00% |
0 / 1 |
2 | |||
| move_customise_modules | |
0.00% |
0 / 14 |
|
0.00% |
0 / 1 |
6 | |||
| update_ucp_pm_basename | |
0.00% |
0 / 9 |
|
0.00% |
0 / 1 |
6 | |||
| update_ucp_profile_auth | |
0.00% |
0 / 3 |
|
0.00% |
0 / 1 |
2 | |||
| rename_styles_module | |
0.00% |
0 / 3 |
|
0.00% |
0 / 1 |
2 | |||
| rename_module_basenames | |
0.00% |
0 / 16 |
|
0.00% |
0 / 1 |
42 | |||
| add_group_teampage | |
0.00% |
0 / 8 |
|
0.00% |
0 / 1 |
2 | |||
| update_group_legend | |
0.00% |
0 / 12 |
|
0.00% |
0 / 1 |
6 | |||
| localise_global_announcements | |
0.00% |
0 / 56 |
|
0.00% |
0 / 1 |
56 | |||
| 1 | <?php |
| 2 | /** |
| 3 | * |
| 4 | * This file is part of the phpBB Forum Software package. |
| 5 | * |
| 6 | * @copyright (c) phpBB Limited <https://www.phpbb.com> |
| 7 | * @license GNU General Public License, version 2 (GPL-2.0) |
| 8 | * |
| 9 | * For full copyright and license information, please see |
| 10 | * the docs/CREDITS.txt file. |
| 11 | * |
| 12 | */ |
| 13 | |
| 14 | namespace phpbb\db\migration\data\v310; |
| 15 | |
| 16 | class dev extends \phpbb\db\migration\container_aware_migration |
| 17 | { |
| 18 | public function effectively_installed() |
| 19 | { |
| 20 | return version_compare($this->config['version'], '3.1.0-dev', '>='); |
| 21 | } |
| 22 | |
| 23 | public static function depends_on() |
| 24 | { |
| 25 | return array( |
| 26 | '\phpbb\db\migration\data\v310\extensions', |
| 27 | '\phpbb\db\migration\data\v310\style_update_p2', |
| 28 | '\phpbb\db\migration\data\v310\timezone_p2', |
| 29 | '\phpbb\db\migration\data\v310\reported_posts_display', |
| 30 | '\phpbb\db\migration\data\v310\migrations_table', |
| 31 | ); |
| 32 | } |
| 33 | |
| 34 | public function update_schema() |
| 35 | { |
| 36 | return array( |
| 37 | 'add_columns' => array( |
| 38 | $this->table_prefix . 'groups' => array( |
| 39 | 'group_teampage' => array('UINT', 0, 'after' => 'group_legend'), |
| 40 | ), |
| 41 | $this->table_prefix . 'profile_fields' => array( |
| 42 | 'field_show_on_pm' => array('BOOL', 0), |
| 43 | ), |
| 44 | $this->table_prefix . 'styles' => array( |
| 45 | 'style_path' => array('VCHAR:100', ''), |
| 46 | 'bbcode_bitfield' => array('VCHAR:255', 'kNg='), |
| 47 | 'style_parent_id' => array('UINT:4', 0), |
| 48 | 'style_parent_tree' => array('TEXT', ''), |
| 49 | ), |
| 50 | $this->table_prefix . 'reports' => array( |
| 51 | 'reported_post_text' => array('MTEXT_UNI', ''), |
| 52 | 'reported_post_uid' => array('VCHAR:8', ''), |
| 53 | 'reported_post_bitfield' => array('VCHAR:255', ''), |
| 54 | ), |
| 55 | ), |
| 56 | 'change_columns' => array( |
| 57 | $this->table_prefix . 'groups' => array( |
| 58 | 'group_legend' => array('UINT', 0), |
| 59 | ), |
| 60 | ), |
| 61 | ); |
| 62 | } |
| 63 | |
| 64 | public function revert_schema() |
| 65 | { |
| 66 | return array( |
| 67 | 'drop_columns' => array( |
| 68 | $this->table_prefix . 'groups' => array( |
| 69 | 'group_teampage', |
| 70 | ), |
| 71 | $this->table_prefix . 'profile_fields' => array( |
| 72 | 'field_show_on_pm', |
| 73 | ), |
| 74 | $this->table_prefix . 'styles' => array( |
| 75 | 'style_path', |
| 76 | 'bbcode_bitfield', |
| 77 | 'style_parent_id', |
| 78 | 'style_parent_tree', |
| 79 | ), |
| 80 | $this->table_prefix . 'reports' => array( |
| 81 | 'reported_post_text', |
| 82 | 'reported_post_uid', |
| 83 | 'reported_post_bitfield', |
| 84 | ), |
| 85 | ), |
| 86 | ); |
| 87 | } |
| 88 | |
| 89 | public function update_data() |
| 90 | { |
| 91 | return array( |
| 92 | array('if', array( |
| 93 | (strpos('phpbb_search_', $this->config['search_type']) !== 0), |
| 94 | array('config.update', array('search_type', 'phpbb_search_' . $this->config['search_type'])), |
| 95 | )), |
| 96 | |
| 97 | array('config.add', array('fulltext_postgres_ts_name', 'simple')), |
| 98 | array('config.add', array('fulltext_postgres_min_word_len', 4)), |
| 99 | array('config.add', array('fulltext_postgres_max_word_len', 254)), |
| 100 | array('config.add', array('fulltext_sphinx_stopwords', 0)), |
| 101 | array('config.add', array('fulltext_sphinx_indexer_mem_limit', 512)), |
| 102 | |
| 103 | array('config.add', array('load_jquery_cdn', 0)), |
| 104 | array('config.add', array('load_jquery_url', '//ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js')), |
| 105 | |
| 106 | array('config.add', array('use_system_cron', 0)), |
| 107 | |
| 108 | array('config.add', array('legend_sort_groupname', 0)), |
| 109 | array('config.add', array('teampage_forums', 1)), |
| 110 | array('config.add', array('teampage_memberships', 1)), |
| 111 | |
| 112 | array('config.add', array('load_cpf_pm', 0)), |
| 113 | |
| 114 | array('config.add', array('display_last_subject', 1)), |
| 115 | |
| 116 | array('config.add', array('assets_version', 1)), |
| 117 | |
| 118 | array('config.add', array('site_home_url', '')), |
| 119 | array('config.add', array('site_home_text', '')), |
| 120 | |
| 121 | array('permission.add', array('u_chgprofileinfo', true, 'u_sig')), |
| 122 | |
| 123 | array('module.add', array( |
| 124 | 'acp', |
| 125 | 'ACP_GROUPS', |
| 126 | array( |
| 127 | 'module_basename' => 'acp_groups', |
| 128 | 'module_langname' => 'ACP_GROUPS_POSITION', |
| 129 | 'module_mode' => 'position', |
| 130 | 'module_auth' => 'acl_a_group', |
| 131 | ), |
| 132 | )), |
| 133 | array('module.add', array( |
| 134 | 'acp', |
| 135 | 'ACP_ATTACHMENTS', |
| 136 | array( |
| 137 | 'module_basename' => 'acp_attachments', |
| 138 | 'module_langname' => 'ACP_MANAGE_ATTACHMENTS', |
| 139 | 'module_mode' => 'manage', |
| 140 | 'module_auth' => 'acl_a_attach', |
| 141 | ), |
| 142 | )), |
| 143 | array('module.add', array( |
| 144 | 'acp', |
| 145 | 'ACP_STYLE_MANAGEMENT', |
| 146 | array( |
| 147 | 'module_basename' => 'acp_styles', |
| 148 | 'module_langname' => 'ACP_STYLES_INSTALL', |
| 149 | 'module_mode' => 'install', |
| 150 | 'module_auth' => 'acl_a_styles', |
| 151 | ), |
| 152 | )), |
| 153 | array('module.add', array( |
| 154 | 'acp', |
| 155 | 'ACP_STYLE_MANAGEMENT', |
| 156 | array( |
| 157 | 'module_basename' => 'acp_styles', |
| 158 | 'module_langname' => 'ACP_STYLES_CACHE', |
| 159 | 'module_mode' => 'cache', |
| 160 | 'module_auth' => 'acl_a_styles', |
| 161 | ), |
| 162 | )), |
| 163 | array('module.add', array( |
| 164 | 'ucp', |
| 165 | 'UCP_PROFILE', |
| 166 | array( |
| 167 | 'module_basename' => 'ucp_profile', |
| 168 | 'module_langname' => 'UCP_PROFILE_AUTOLOGIN_KEYS', |
| 169 | 'module_mode' => 'autologin_keys', |
| 170 | ), |
| 171 | )), |
| 172 | // Module will be renamed later |
| 173 | array('module.add', array( |
| 174 | 'acp', |
| 175 | 'ACP_CAT_STYLES', |
| 176 | 'ACP_LANGUAGE' |
| 177 | )), |
| 178 | |
| 179 | array('module.remove', array( |
| 180 | 'acp', |
| 181 | false, |
| 182 | 'ACP_TEMPLATES', |
| 183 | )), |
| 184 | array('module.remove', array( |
| 185 | 'acp', |
| 186 | false, |
| 187 | 'ACP_THEMES', |
| 188 | )), |
| 189 | array('module.remove', array( |
| 190 | 'acp', |
| 191 | false, |
| 192 | 'ACP_IMAGESETS', |
| 193 | )), |
| 194 | |
| 195 | array('custom', array(array($this, 'rename_module_basenames'))), |
| 196 | array('custom', array(array($this, 'rename_styles_module'))), |
| 197 | array('custom', array(array($this, 'add_group_teampage'))), |
| 198 | array('custom', array(array($this, 'update_group_legend'))), |
| 199 | array('custom', array(array($this, 'localise_global_announcements'))), |
| 200 | array('custom', array(array($this, 'update_ucp_pm_basename'))), |
| 201 | array('custom', array(array($this, 'update_ucp_profile_auth'))), |
| 202 | array('custom', array(array($this, 'move_customise_modules'))), |
| 203 | |
| 204 | array('config.update', array('version', '3.1.0-dev')), |
| 205 | ); |
| 206 | } |
| 207 | |
| 208 | public function move_customise_modules() |
| 209 | { |
| 210 | // Move language management to new location in the Customise tab |
| 211 | // First get language module id |
| 212 | $sql = 'SELECT module_id FROM ' . MODULES_TABLE . " |
| 213 | WHERE module_basename = 'acp_language'"; |
| 214 | $result = $this->db->sql_query($sql); |
| 215 | $language_module_id = $this->db->sql_fetchfield('module_id'); |
| 216 | $this->db->sql_freeresult($result); |
| 217 | // Next get language management module id of the one just created |
| 218 | $sql = 'SELECT module_id FROM ' . MODULES_TABLE . " |
| 219 | WHERE module_langname = 'ACP_LANGUAGE'"; |
| 220 | $result = $this->db->sql_query($sql); |
| 221 | $language_management_module_id = $this->db->sql_fetchfield('module_id'); |
| 222 | $this->db->sql_freeresult($result); |
| 223 | |
| 224 | // acp_modules calls adm_back_link, which is undefined at this point |
| 225 | if (!function_exists('adm_back_link')) |
| 226 | { |
| 227 | include($this->phpbb_root_path . 'includes/functions_acp.' . $this->php_ext); |
| 228 | } |
| 229 | $module_manager = $this->container->get('module.manager'); |
| 230 | $module_manager->move_module($language_module_id, $language_management_module_id, 'acp'); |
| 231 | } |
| 232 | |
| 233 | public function update_ucp_pm_basename() |
| 234 | { |
| 235 | $sql = 'SELECT module_id, module_basename |
| 236 | FROM ' . MODULES_TABLE . " |
| 237 | WHERE module_basename <> 'ucp_pm' AND |
| 238 | module_langname='UCP_PM'"; |
| 239 | $result = $this->db->sql_query_limit($sql, 1); |
| 240 | |
| 241 | if ($row = $this->db->sql_fetchrow($result)) |
| 242 | { |
| 243 | // This update is still not applied. Applying it |
| 244 | |
| 245 | $sql = 'UPDATE ' . MODULES_TABLE . " |
| 246 | SET module_basename = 'ucp_pm' |
| 247 | WHERE module_id = " . (int) $row['module_id']; |
| 248 | |
| 249 | $this->sql_query($sql); |
| 250 | } |
| 251 | $this->db->sql_freeresult($result); |
| 252 | } |
| 253 | |
| 254 | public function update_ucp_profile_auth() |
| 255 | { |
| 256 | // Update the auth setting for the module |
| 257 | $sql = 'UPDATE ' . MODULES_TABLE . " |
| 258 | SET module_auth = 'acl_u_chgprofileinfo' |
| 259 | WHERE module_class = 'ucp' |
| 260 | AND module_basename = 'ucp_profile' |
| 261 | AND module_mode = 'profile_info'"; |
| 262 | $this->sql_query($sql); |
| 263 | } |
| 264 | |
| 265 | public function rename_styles_module() |
| 266 | { |
| 267 | // Rename styles module to Customise |
| 268 | $sql = 'UPDATE ' . MODULES_TABLE . " |
| 269 | SET module_langname = 'ACP_CAT_CUSTOMISE' |
| 270 | WHERE module_langname = 'ACP_CAT_STYLES'"; |
| 271 | $this->sql_query($sql); |
| 272 | } |
| 273 | |
| 274 | public function rename_module_basenames() |
| 275 | { |
| 276 | // rename all module basenames to full classname |
| 277 | $sql = 'SELECT module_id, module_basename, module_class |
| 278 | FROM ' . MODULES_TABLE; |
| 279 | $result = $this->db->sql_query($sql); |
| 280 | |
| 281 | while ($row = $this->db->sql_fetchrow($result)) |
| 282 | { |
| 283 | $module_id = (int) $row['module_id']; |
| 284 | unset($row['module_id']); |
| 285 | |
| 286 | if (!empty($row['module_basename']) && !empty($row['module_class'])) |
| 287 | { |
| 288 | // all the class names start with class name or with phpbb_ for auto loading |
| 289 | if (strpos($row['module_basename'], $row['module_class'] . '_') !== 0 && |
| 290 | strpos($row['module_basename'], 'phpbb_') !== 0) |
| 291 | { |
| 292 | $row['module_basename'] = $row['module_class'] . '_' . $row['module_basename']; |
| 293 | |
| 294 | $sql_update = $this->db->sql_build_array('UPDATE', $row); |
| 295 | |
| 296 | $sql = 'UPDATE ' . MODULES_TABLE . ' |
| 297 | SET ' . $sql_update . ' |
| 298 | WHERE module_id = ' . $module_id; |
| 299 | $this->sql_query($sql); |
| 300 | } |
| 301 | } |
| 302 | } |
| 303 | |
| 304 | $this->db->sql_freeresult($result); |
| 305 | } |
| 306 | |
| 307 | public function add_group_teampage() |
| 308 | { |
| 309 | $sql = 'UPDATE ' . GROUPS_TABLE . ' |
| 310 | SET group_teampage = 1 |
| 311 | WHERE group_type = ' . GROUP_SPECIAL . " |
| 312 | AND group_name = 'ADMINISTRATORS'"; |
| 313 | $this->sql_query($sql); |
| 314 | |
| 315 | $sql = 'UPDATE ' . GROUPS_TABLE . ' |
| 316 | SET group_teampage = 2 |
| 317 | WHERE group_type = ' . GROUP_SPECIAL . " |
| 318 | AND group_name = 'GLOBAL_MODERATORS'"; |
| 319 | $this->sql_query($sql); |
| 320 | } |
| 321 | |
| 322 | public function update_group_legend() |
| 323 | { |
| 324 | $sql = 'SELECT group_id |
| 325 | FROM ' . GROUPS_TABLE . ' |
| 326 | WHERE group_legend = 1 |
| 327 | ORDER BY group_name ASC'; |
| 328 | $result = $this->db->sql_query($sql); |
| 329 | |
| 330 | $next_legend = 1; |
| 331 | while ($row = $this->db->sql_fetchrow($result)) |
| 332 | { |
| 333 | $sql = 'UPDATE ' . GROUPS_TABLE . ' |
| 334 | SET group_legend = ' . $next_legend . ' |
| 335 | WHERE group_id = ' . (int) $row['group_id']; |
| 336 | $this->sql_query($sql); |
| 337 | |
| 338 | $next_legend++; |
| 339 | } |
| 340 | $this->db->sql_freeresult($result); |
| 341 | } |
| 342 | |
| 343 | public function localise_global_announcements() |
| 344 | { |
| 345 | // Localise Global Announcements |
| 346 | $sql = 'SELECT topic_id, topic_approved, (topic_replies + 1) AS topic_posts, topic_last_post_id, topic_last_post_subject, topic_last_post_time, topic_last_poster_id, topic_last_poster_name, topic_last_poster_colour |
| 347 | FROM ' . TOPICS_TABLE . ' |
| 348 | WHERE forum_id = 0 |
| 349 | AND topic_type = ' . POST_GLOBAL; |
| 350 | $result = $this->db->sql_query($sql); |
| 351 | |
| 352 | $global_announcements = $update_lastpost_data = array(); |
| 353 | $update_lastpost_data['forum_last_post_time'] = 0; |
| 354 | $update_forum_data = array( |
| 355 | 'forum_posts' => 0, |
| 356 | 'forum_topics' => 0, |
| 357 | 'forum_topics_real' => 0, |
| 358 | ); |
| 359 | |
| 360 | while ($row = $this->db->sql_fetchrow($result)) |
| 361 | { |
| 362 | $global_announcements[] = (int) $row['topic_id']; |
| 363 | |
| 364 | $update_forum_data['forum_posts'] += (int) $row['topic_posts']; |
| 365 | $update_forum_data['forum_topics_real']++; |
| 366 | if ($row['topic_approved']) |
| 367 | { |
| 368 | $update_forum_data['forum_topics']++; |
| 369 | } |
| 370 | |
| 371 | if ($update_lastpost_data['forum_last_post_time'] < $row['topic_last_post_time']) |
| 372 | { |
| 373 | $update_lastpost_data = array( |
| 374 | 'forum_last_post_id' => (int) $row['topic_last_post_id'], |
| 375 | 'forum_last_post_subject' => $row['topic_last_post_subject'], |
| 376 | 'forum_last_post_time' => (int) $row['topic_last_post_time'], |
| 377 | 'forum_last_poster_id' => (int) $row['topic_last_poster_id'], |
| 378 | 'forum_last_poster_name' => $row['topic_last_poster_name'], |
| 379 | 'forum_last_poster_colour' => $row['topic_last_poster_colour'], |
| 380 | ); |
| 381 | } |
| 382 | } |
| 383 | $this->db->sql_freeresult($result); |
| 384 | |
| 385 | if (!empty($global_announcements)) |
| 386 | { |
| 387 | // Update the post/topic-count for the forum and the last-post if needed |
| 388 | $sql = 'SELECT forum_id |
| 389 | FROM ' . FORUMS_TABLE . ' |
| 390 | WHERE forum_type = ' . FORUM_POST; |
| 391 | $result = $this->db->sql_query_limit($sql, 1); |
| 392 | $ga_forum_id = $this->db->sql_fetchfield('forum_id'); |
| 393 | $this->db->sql_freeresult($result); |
| 394 | |
| 395 | $sql = 'SELECT forum_last_post_time |
| 396 | FROM ' . FORUMS_TABLE . ' |
| 397 | WHERE forum_id = ' . $ga_forum_id; |
| 398 | $result = $this->db->sql_query($sql); |
| 399 | $lastpost = (int) $this->db->sql_fetchfield('forum_last_post_time'); |
| 400 | $this->db->sql_freeresult($result); |
| 401 | |
| 402 | $sql_update = 'forum_posts = forum_posts + ' . $update_forum_data['forum_posts'] . ', '; |
| 403 | $sql_update .= 'forum_topics_real = forum_topics_real + ' . $update_forum_data['forum_topics_real'] . ', '; |
| 404 | $sql_update .= 'forum_topics = forum_topics + ' . $update_forum_data['forum_topics']; |
| 405 | if ($lastpost < $update_lastpost_data['forum_last_post_time']) |
| 406 | { |
| 407 | $sql_update .= ', ' . $this->db->sql_build_array('UPDATE', $update_lastpost_data); |
| 408 | } |
| 409 | |
| 410 | $sql = 'UPDATE ' . FORUMS_TABLE . ' |
| 411 | SET ' . $sql_update . ' |
| 412 | WHERE forum_id = ' . $ga_forum_id; |
| 413 | $this->sql_query($sql); |
| 414 | |
| 415 | // Update some forum_ids |
| 416 | $table_ary = array(TOPICS_TABLE, POSTS_TABLE, LOG_TABLE, DRAFTS_TABLE, TOPICS_TRACK_TABLE); |
| 417 | foreach ($table_ary as $table) |
| 418 | { |
| 419 | $sql = "UPDATE $table |
| 420 | SET forum_id = $ga_forum_id |
| 421 | WHERE " . $this->db->sql_in_set('topic_id', $global_announcements); |
| 422 | $this->sql_query($sql); |
| 423 | } |
| 424 | unset($table_ary); |
| 425 | } |
| 426 | } |
| 427 | } |