| [ Index ] |
PHP Cross Reference of phpBB-3.3.14-deutsch |
[Summary view] [Print] [Text view]
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 static public 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 }
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
| Generated: Mon Nov 25 19:05:08 2024 | Cross-referenced by PHPXref 0.7.1 |