| [ Index ] |
PHP Cross Reference of phpBB-3.1.12-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 if (!defined('IN_PHPBB')) 15 { 16 exit; 17 } 18 19 /** 20 * Helper functions for phpBB 2.0.x to phpBB 3.1.x conversion 21 */ 22 23 /** 24 * Set forum flags - only prune old polls by default 25 */ 26 function phpbb_forum_flags() 27 { 28 // Set forum flags 29 $forum_flags = 0; 30 31 // FORUM_FLAG_LINK_TRACK 32 $forum_flags += 0; 33 34 // FORUM_FLAG_PRUNE_POLL 35 $forum_flags += FORUM_FLAG_PRUNE_POLL; 36 37 // FORUM_FLAG_PRUNE_ANNOUNCE 38 $forum_flags += 0; 39 40 // FORUM_FLAG_PRUNE_STICKY 41 $forum_flags += 0; 42 43 // FORUM_FLAG_ACTIVE_TOPICS 44 $forum_flags += 0; 45 46 // FORUM_FLAG_POST_REVIEW 47 $forum_flags += FORUM_FLAG_POST_REVIEW; 48 49 return $forum_flags; 50 } 51 52 /** 53 * Insert/Convert forums 54 */ 55 function phpbb_insert_forums() 56 { 57 global $db, $src_db, $same_db, $convert, $user, $config; 58 59 $db->sql_query($convert->truncate_statement . FORUMS_TABLE); 60 61 // Determine the highest id used within the old forums table (we add the categories after the forum ids) 62 $sql = 'SELECT MAX(forum_id) AS max_forum_id 63 FROM ' . $convert->src_table_prefix . 'forums'; 64 $result = $src_db->sql_query($sql); 65 $max_forum_id = (int) $src_db->sql_fetchfield('max_forum_id'); 66 $src_db->sql_freeresult($result); 67 68 $max_forum_id++; 69 70 // pruning disabled globally? 71 $sql = "SELECT config_value 72 FROM {$convert->src_table_prefix}config 73 WHERE config_name = 'prune_enable'"; 74 $result = $src_db->sql_query($sql); 75 $prune_enabled = (int) $src_db->sql_fetchfield('config_value'); 76 $src_db->sql_freeresult($result); 77 78 // Insert categories 79 $sql = 'SELECT cat_id, cat_title 80 FROM ' . $convert->src_table_prefix . 'categories 81 ORDER BY cat_order'; 82 83 if ($convert->mysql_convert && $same_db) 84 { 85 $src_db->sql_query("SET NAMES 'binary'"); 86 } 87 88 $result = $src_db->sql_query($sql); 89 90 if ($convert->mysql_convert && $same_db) 91 { 92 $src_db->sql_query("SET NAMES 'utf8'"); 93 } 94 95 switch ($db->get_sql_layer()) 96 { 97 case 'mssql': 98 case 'mssql_odbc': 99 case 'mssqlnative': 100 $db->sql_query('SET IDENTITY_INSERT ' . FORUMS_TABLE . ' ON'); 101 break; 102 } 103 104 $cats_added = array(); 105 while ($row = $src_db->sql_fetchrow($result)) 106 { 107 $sql_ary = array( 108 'forum_id' => (int) $max_forum_id, 109 'forum_name' => ($row['cat_title']) ? htmlspecialchars(phpbb_set_default_encoding($row['cat_title']), ENT_COMPAT, 'UTF-8') : $user->lang['CATEGORY'], 110 'parent_id' => 0, 111 'forum_parents' => '', 112 'forum_desc' => '', 113 'forum_type' => FORUM_CAT, 114 'forum_status' => ITEM_UNLOCKED, 115 'forum_rules' => '', 116 ); 117 118 $sql = 'SELECT MAX(right_id) AS right_id 119 FROM ' . FORUMS_TABLE; 120 $_result = $db->sql_query($sql); 121 $cat_row = $db->sql_fetchrow($_result); 122 $db->sql_freeresult($_result); 123 124 $sql_ary['left_id'] = (int) ($cat_row['right_id'] + 1); 125 $sql_ary['right_id'] = (int) ($cat_row['right_id'] + 2); 126 127 $sql = 'INSERT INTO ' . FORUMS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary); 128 $db->sql_query($sql); 129 130 $cats_added[$row['cat_id']] = $max_forum_id; 131 $max_forum_id++; 132 } 133 $src_db->sql_freeresult($result); 134 135 // There may be installations having forums with non-existant category ids. 136 // We try to catch them and add them to an "unknown" category instead of leaving them out. 137 $sql = 'SELECT cat_id 138 FROM ' . $convert->src_table_prefix . 'forums 139 GROUP BY cat_id'; 140 $result = $src_db->sql_query($sql); 141 142 $unknown_cat_id = false; 143 while ($row = $src_db->sql_fetchrow($result)) 144 { 145 // Catch those categories not been added before 146 if (!isset($cats_added[$row['cat_id']])) 147 { 148 $unknown_cat_id = true; 149 } 150 } 151 $src_db->sql_freeresult($result); 152 153 // Is there at least one category not known? 154 if ($unknown_cat_id === true) 155 { 156 $unknown_cat_id = 'ghost'; 157 158 $sql_ary = array( 159 'forum_id' => (int) $max_forum_id, 160 'forum_name' => (string) $user->lang['CATEGORY'], 161 'parent_id' => 0, 162 'forum_parents' => '', 163 'forum_desc' => '', 164 'forum_type' => FORUM_CAT, 165 'forum_status' => ITEM_UNLOCKED, 166 'forum_rules' => '', 167 ); 168 169 $sql = 'SELECT MAX(right_id) AS right_id 170 FROM ' . FORUMS_TABLE; 171 $_result = $db->sql_query($sql); 172 $cat_row = $db->sql_fetchrow($_result); 173 $db->sql_freeresult($_result); 174 175 $sql_ary['left_id'] = (int) ($cat_row['right_id'] + 1); 176 $sql_ary['right_id'] = (int) ($cat_row['right_id'] + 2); 177 178 $sql = 'INSERT INTO ' . FORUMS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary); 179 $db->sql_query($sql); 180 181 $cats_added[$unknown_cat_id] = $max_forum_id; 182 $max_forum_id++; 183 } 184 185 // Now insert the forums 186 $sql = 'SELECT f.forum_id, f.forum_name, f.cat_id, f.forum_desc, f.forum_status, f.prune_enable, f.prune_next, fp.prune_days, fp.prune_freq FROM ' . $convert->src_table_prefix . 'forums f 187 LEFT JOIN ' . $convert->src_table_prefix . 'forum_prune fp ON f.forum_id = fp.forum_id 188 GROUP BY f.forum_id, f.forum_name, f.cat_id, f.forum_desc, f.forum_status, f.prune_enable, f.prune_next, f.forum_order, fp.prune_days, fp.prune_freq 189 ORDER BY f.cat_id, f.forum_order'; 190 191 if ($convert->mysql_convert && $same_db) 192 { 193 $src_db->sql_query("SET NAMES 'binary'"); 194 } 195 196 $result = $src_db->sql_query($sql); 197 198 if ($convert->mysql_convert && $same_db) 199 { 200 $src_db->sql_query("SET NAMES 'utf8'"); 201 } 202 203 while ($row = $src_db->sql_fetchrow($result)) 204 { 205 // Some might have forums here with an id not being "possible"... 206 // To be somewhat friendly we "change" the category id for those to a previously created ghost category 207 if (!isset($cats_added[$row['cat_id']]) && $unknown_cat_id !== false) 208 { 209 $row['cat_id'] = $unknown_cat_id; 210 } 211 212 if (!isset($cats_added[$row['cat_id']])) 213 { 214 continue; 215 } 216 217 // Define the new forums sql ary 218 $sql_ary = array( 219 'forum_id' => (int) $row['forum_id'], 220 'forum_name' => htmlspecialchars(phpbb_set_default_encoding($row['forum_name']), ENT_COMPAT, 'UTF-8'), 221 'parent_id' => (int) $cats_added[$row['cat_id']], 222 'forum_parents' => '', 223 'forum_desc' => htmlspecialchars(phpbb_set_default_encoding($row['forum_desc']), ENT_COMPAT, 'UTF-8'), 224 'forum_type' => FORUM_POST, 225 'forum_status' => is_item_locked($row['forum_status']), 226 'enable_prune' => ($prune_enabled) ? (int) $row['prune_enable'] : 0, 227 'prune_next' => (int) null_to_zero($row['prune_next']), 228 'prune_days' => (int) null_to_zero($row['prune_days']), 229 'prune_viewed' => 0, 230 'prune_freq' => (int) null_to_zero($row['prune_freq']), 231 232 'forum_flags' => phpbb_forum_flags(), 233 'forum_options' => 0, 234 235 // Default values 236 'forum_desc_bitfield' => '', 237 'forum_desc_options' => 7, 238 'forum_desc_uid' => '', 239 'forum_link' => '', 240 'forum_password' => '', 241 'forum_style' => 0, 242 'forum_image' => '', 243 'forum_rules' => '', 244 'forum_rules_link' => '', 245 'forum_rules_bitfield' => '', 246 'forum_rules_options' => 7, 247 'forum_rules_uid' => '', 248 'forum_topics_per_page' => 0, 249 'forum_posts_approved' => 0, 250 'forum_posts_unapproved' => 0, 251 'forum_posts_softdeleted' => 0, 252 'forum_topics_approved' => 0, 253 'forum_topics_unapproved' => 0, 254 'forum_topics_softdeleted' => 0, 255 'forum_last_post_id' => 0, 256 'forum_last_poster_id' => 0, 257 'forum_last_post_subject' => '', 258 'forum_last_post_time' => 0, 259 'forum_last_poster_name' => '', 260 'forum_last_poster_colour' => '', 261 'display_on_index' => 1, 262 'enable_indexing' => 1, 263 'enable_icons' => 0, 264 ); 265 266 // Now add the forums with proper left/right ids 267 $sql = 'SELECT left_id, right_id 268 FROM ' . FORUMS_TABLE . ' 269 WHERE forum_id = ' . $cats_added[$row['cat_id']]; 270 $_result = $db->sql_query($sql); 271 $cat_row = $db->sql_fetchrow($_result); 272 $db->sql_freeresult($_result); 273 274 $sql = 'UPDATE ' . FORUMS_TABLE . ' 275 SET left_id = left_id + 2, right_id = right_id + 2 276 WHERE left_id > ' . $cat_row['right_id']; 277 $db->sql_query($sql); 278 279 $sql = 'UPDATE ' . FORUMS_TABLE . ' 280 SET right_id = right_id + 2 281 WHERE ' . $cat_row['left_id'] . ' BETWEEN left_id AND right_id'; 282 $db->sql_query($sql); 283 284 $sql_ary['left_id'] = (int) $cat_row['right_id']; 285 $sql_ary['right_id'] = (int) ($cat_row['right_id'] + 1); 286 287 $sql = 'INSERT INTO ' . FORUMS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary); 288 $db->sql_query($sql); 289 } 290 $src_db->sql_freeresult($result); 291 292 switch ($db->get_sql_layer()) 293 { 294 case 'postgres': 295 $db->sql_query("SELECT SETVAL('" . FORUMS_TABLE . "_seq',(select case when max(forum_id)>0 then max(forum_id)+1 else 1 end from " . FORUMS_TABLE . '));'); 296 break; 297 298 case 'mssql': 299 case 'mssql_odbc': 300 case 'mssqlnative': 301 $db->sql_query('SET IDENTITY_INSERT ' . FORUMS_TABLE . ' OFF'); 302 break; 303 304 case 'oracle': 305 $result = $db->sql_query('SELECT MAX(forum_id) as max_id FROM ' . FORUMS_TABLE); 306 $row = $db->sql_fetchrow($result); 307 $db->sql_freeresult($result); 308 309 $largest_id = (int) $row['max_id']; 310 311 if ($largest_id) 312 { 313 $db->sql_query('DROP SEQUENCE ' . FORUMS_TABLE . '_seq'); 314 $db->sql_query('CREATE SEQUENCE ' . FORUMS_TABLE . '_seq START WITH ' . ($largest_id + 1)); 315 } 316 break; 317 } 318 } 319 320 /** 321 * Function for recoding text with the default language 322 * 323 * @param string $text text to recode to utf8 324 * @param bool $grab_user_lang if set to true the function tries to use $convert_row['user_lang'] (and falls back to $convert_row['poster_id']) instead of the boards default language 325 */ 326 function phpbb_set_encoding($text, $grab_user_lang = true) 327 { 328 global $lang_enc_array, $convert_row; 329 global $convert, $phpEx; 330 331 /*static $lang_enc_array = array( 332 'korean' => 'euc-kr', 333 'serbian' => 'windows-1250', 334 'polish' => 'iso-8859-2', 335 'kurdish' => 'windows-1254', 336 'slovak' => 'Windows-1250', 337 'russian' => 'windows-1251', 338 'estonian' => 'iso-8859-4', 339 'chinese_simplified' => 'gb2312', 340 'macedonian' => 'windows-1251', 341 'azerbaijani' => 'UTF-8', 342 'romanian' => 'iso-8859-2', 343 'romanian_diacritice' => 'iso-8859-2', 344 'lithuanian' => 'windows-1257', 345 'turkish' => 'iso-8859-9', 346 'ukrainian' => 'windows-1251', 347 'japanese' => 'shift_jis', 348 'hungarian' => 'ISO-8859-2', 349 'romanian_no_diacritics' => 'iso-8859-2', 350 'mongolian' => 'UTF-8', 351 'slovenian' => 'windows-1250', 352 'bosnian' => 'windows-1250', 353 'czech' => 'Windows-1250', 354 'farsi' => 'Windows-1256', 355 'croatian' => 'windows-1250', 356 'greek' => 'iso-8859-7', 357 'russian_tu' => 'windows-1251', 358 'sakha' => 'UTF-8', 359 'serbian_cyrillic' => 'windows-1251', 360 'bulgarian' => 'windows-1251', 361 'chinese_traditional_taiwan' => 'big5', 362 'chinese_traditional' => 'big5', 363 'arabic' => 'windows-1256', 364 'hebrew' => 'WINDOWS-1255', 365 'thai' => 'windows-874', 366 //'chinese_traditional_taiwan' => 'utf-8' // custom modified, we may have to do an include :-( 367 );*/ 368 369 if (empty($lang_enc_array)) 370 { 371 $lang_enc_array = array(); 372 } 373 374 $get_lang = trim(get_config_value('default_lang')); 375 376 // Do we need the users language encoding? 377 if ($grab_user_lang && !empty($convert_row)) 378 { 379 if (!empty($convert_row['user_lang'])) 380 { 381 $get_lang = trim($convert_row['user_lang']); 382 } 383 else if (!empty($convert_row['poster_id'])) 384 { 385 global $src_db, $same_db; 386 387 if ($convert->mysql_convert && $same_db) 388 { 389 $src_db->sql_query("SET NAMES 'binary'"); 390 } 391 392 $sql = 'SELECT user_lang 393 FROM ' . $convert->src_table_prefix . 'users 394 WHERE user_id = ' . (int) $convert_row['poster_id']; 395 $result = $src_db->sql_query($sql); 396 $get_lang = (string) $src_db->sql_fetchfield('user_lang'); 397 $src_db->sql_freeresult($result); 398 399 if ($convert->mysql_convert && $same_db) 400 { 401 $src_db->sql_query("SET NAMES 'utf8'"); 402 } 403 404 $get_lang = (!trim($get_lang)) ? trim(get_config_value('default_lang')) : trim($get_lang); 405 } 406 } 407 408 if (!isset($lang_enc_array[$get_lang])) 409 { 410 $filename = $convert->options['forum_path'] . '/language/lang_' . $get_lang . '/lang_main.' . $phpEx; 411 412 if (!file_exists($filename)) 413 { 414 $get_lang = trim(get_config_value('default_lang')); 415 } 416 417 if (!isset($lang_enc_array[$get_lang])) 418 { 419 include($convert->options['forum_path'] . '/language/lang_' . $get_lang . '/lang_main.' . $phpEx); 420 $lang_enc_array[$get_lang] = $lang['ENCODING']; 421 unset($lang); 422 } 423 } 424 425 $encoding = $lang_enc_array[$get_lang]; 426 427 return utf8_recode($text, $lang_enc_array[$get_lang]); 428 } 429 430 /** 431 * Same as phpbb_set_encoding, but forcing boards default language 432 */ 433 function phpbb_set_default_encoding($text) 434 { 435 return phpbb_set_encoding($text, false); 436 } 437 438 /** 439 * Convert Birthday from Birthday MOD to phpBB Format 440 */ 441 function phpbb_get_birthday($birthday = '') 442 { 443 if (defined('MOD_BIRTHDAY_TERRA')) 444 { 445 $birthday = (string) $birthday; 446 447 // stored as month, day, year 448 if (!$birthday) 449 { 450 return ' 0- 0- 0'; 451 } 452 453 // We use the original mod code to retrieve the birthday (not ideal) 454 preg_match('/(..)(..)(....)/', sprintf('%08d', $birthday), $birthday_parts); 455 456 $month = $birthday_parts[1]; 457 $day = $birthday_parts[2]; 458 $year = $birthday_parts[3]; 459 460 return sprintf('%2d-%2d-%4d', $day, $month, $year); 461 } 462 else 463 { 464 $birthday = (int) $birthday; 465 466 if (!$birthday || $birthday == 999999) 467 { 468 return ' 0- 0- 0'; 469 } 470 471 // The birthday mod from niels is using this code to transform to day/month/year 472 return sprintf('%2d-%2d-%4d', gmdate('j', $birthday * 86400 + 1), gmdate('n', $birthday * 86400 + 1), gmdate('Y', $birthday * 86400 + 1)); 473 } 474 } 475 476 /** 477 * Return correct user id value 478 * Everyone's id will be one higher to allow the guest/anonymous user to have a positive id as well 479 */ 480 function phpbb_user_id($user_id) 481 { 482 global $config; 483 484 // Increment user id if the old forum is having a user with the id 1 485 if (!isset($config['increment_user_id'])) 486 { 487 global $src_db, $same_db, $convert; 488 489 if ($convert->mysql_convert && $same_db) 490 { 491 $src_db->sql_query("SET NAMES 'binary'"); 492 } 493 494 // Now let us set a temporary config variable for user id incrementing 495 $sql = "SELECT user_id 496 FROM {$convert->src_table_prefix}users 497 WHERE user_id = 1"; 498 $result = $src_db->sql_query($sql); 499 $id = (int) $src_db->sql_fetchfield('user_id'); 500 $src_db->sql_freeresult($result); 501 502 // Try to get the maximum user id possible... 503 $sql = "SELECT MAX(user_id) AS max_user_id 504 FROM {$convert->src_table_prefix}users"; 505 $result = $src_db->sql_query($sql); 506 $max_id = (int) $src_db->sql_fetchfield('max_user_id'); 507 $src_db->sql_freeresult($result); 508 509 if ($convert->mysql_convert && $same_db) 510 { 511 $src_db->sql_query("SET NAMES 'utf8'"); 512 } 513 514 // If there is a user id 1, we need to increment user ids. :/ 515 if ($id === 1) 516 { 517 set_config('increment_user_id', ($max_id + 1), true); 518 $config['increment_user_id'] = $max_id + 1; 519 } 520 else 521 { 522 set_config('increment_user_id', 0, true); 523 $config['increment_user_id'] = 0; 524 } 525 } 526 527 // If the old user id is -1 in 2.0.x it is the anonymous user... 528 if ($user_id == -1) 529 { 530 return ANONYMOUS; 531 } 532 533 if (!empty($config['increment_user_id']) && $user_id == 1) 534 { 535 return $config['increment_user_id']; 536 } 537 538 // A user id of 0 can happen, for example within the ban table if no user is banned... 539 // Within the posts and topics table this can be "dangerous" but is the fault of the user 540 // having mods installed (a poster id of 0 is not possible in 2.0.x). 541 // Therefore, we return the user id "as is". 542 543 return (int) $user_id; 544 } 545 546 /** 547 * Return correct user id value 548 * Everyone's id will be one higher to allow the guest/anonymous user to have a positive id as well 549 */ 550 function phpbb_topic_replies_to_posts($num_replies) 551 { 552 return (int) $num_replies + 1; 553 } 554 555 /* Copy additional table fields from old forum to new forum if user wants this (for Mod compatibility for example) 556 function phpbb_copy_table_fields() 557 { 558 } 559 */ 560 561 /** 562 * Convert authentication 563 * user, group and forum table has to be filled in order to work 564 */ 565 function phpbb_convert_authentication($mode) 566 { 567 global $db, $src_db, $same_db, $convert, $user, $config, $cache; 568 569 if ($mode == 'start') 570 { 571 $db->sql_query($convert->truncate_statement . ACL_USERS_TABLE); 572 $db->sql_query($convert->truncate_statement . ACL_GROUPS_TABLE); 573 574 // What we will do is handling all 2.0.x admins as founder to replicate what is common in 2.0.x. 575 // After conversion the main admin need to make sure he is removing permissions and the founder status if wanted. 576 577 // Grab user ids of users with user_level of ADMIN 578 $sql = "SELECT user_id 579 FROM {$convert->src_table_prefix}users 580 WHERE user_level = 1 581 ORDER BY user_regdate ASC"; 582 $result = $src_db->sql_query($sql); 583 584 while ($row = $src_db->sql_fetchrow($result)) 585 { 586 $user_id = (int) phpbb_user_id($row['user_id']); 587 // Set founder admin... 588 $sql = 'UPDATE ' . USERS_TABLE . ' 589 SET user_type = ' . USER_FOUNDER . " 590 WHERE user_id = $user_id"; 591 $db->sql_query($sql); 592 } 593 $src_db->sql_freeresult($result); 594 595 $sql = 'SELECT group_id 596 FROM ' . GROUPS_TABLE . " 597 WHERE group_name = '" . $db->sql_escape('BOTS') . "'"; 598 $result = $db->sql_query($sql); 599 $bot_group_id = (int) $db->sql_fetchfield('group_id'); 600 $db->sql_freeresult($result); 601 } 602 603 // Grab forum auth information 604 $sql = "SELECT * 605 FROM {$convert->src_table_prefix}forums"; 606 $result = $src_db->sql_query($sql); 607 608 $forum_access = array(); 609 while ($row = $src_db->sql_fetchrow($result)) 610 { 611 $forum_access[$row['forum_id']] = $row; 612 } 613 $src_db->sql_freeresult($result); 614 615 if ($convert->mysql_convert && $same_db) 616 { 617 $src_db->sql_query("SET NAMES 'binary'"); 618 } 619 // Grab user auth information from 2.0.x board 620 $sql = "SELECT ug.user_id, aa.* 621 FROM {$convert->src_table_prefix}auth_access aa, {$convert->src_table_prefix}user_group ug, {$convert->src_table_prefix}groups g, {$convert->src_table_prefix}forums f 622 WHERE g.group_id = aa.group_id 623 AND g.group_single_user = 1 624 AND ug.group_id = g.group_id 625 AND f.forum_id = aa.forum_id"; 626 $result = $src_db->sql_query($sql); 627 628 $user_access = array(); 629 while ($row = $src_db->sql_fetchrow($result)) 630 { 631 $user_access[$row['forum_id']][] = $row; 632 } 633 $src_db->sql_freeresult($result); 634 635 // Grab group auth information 636 $sql = "SELECT g.group_id, aa.* 637 FROM {$convert->src_table_prefix}auth_access aa, {$convert->src_table_prefix}groups g 638 WHERE g.group_id = aa.group_id 639 AND g.group_single_user <> 1"; 640 $result = $src_db->sql_query($sql); 641 642 $group_access = array(); 643 while ($row = $src_db->sql_fetchrow($result)) 644 { 645 $group_access[$row['forum_id']][] = $row; 646 } 647 $src_db->sql_freeresult($result); 648 649 if ($convert->mysql_convert && $same_db) 650 { 651 $src_db->sql_query("SET NAMES 'utf8'"); 652 } 653 654 // Add Forum Access List 655 $auth_map = array( 656 'auth_view' => array('f_', 'f_list'), 657 'auth_read' => array('f_read', 'f_search'), 658 'auth_post' => array('f_post', 'f_bbcode', 'f_smilies', 'f_img', 'f_sigs', 'f_postcount', 'f_report', 'f_subscribe', 'f_print', 'f_email'), 659 'auth_reply' => 'f_reply', 660 'auth_edit' => 'f_edit', 661 'auth_delete' => 'f_delete', 662 'auth_pollcreate' => 'f_poll', 663 'auth_vote' => 'f_vote', 664 'auth_announce' => 'f_announce', 665 'auth_sticky' => 'f_sticky', 666 'auth_attachments' => array('f_attach', 'f_download'), 667 'auth_download' => 'f_download', 668 ); 669 670 // Define the ACL constants used in 2.0 to make the code slightly more readable 671 define('AUTH_ALL', 0); 672 define('AUTH_REG', 1); 673 define('AUTH_ACL', 2); 674 define('AUTH_MOD', 3); 675 define('AUTH_ADMIN', 5); 676 677 // A mapping of the simple permissions used by 2.0 678 $simple_auth_ary = array( 679 'public' => array( 680 'auth_view' => AUTH_ALL, 681 'auth_read' => AUTH_ALL, 682 'auth_post' => AUTH_ALL, 683 'auth_reply' => AUTH_ALL, 684 'auth_edit' => AUTH_REG, 685 'auth_delete' => AUTH_REG, 686 'auth_sticky' => AUTH_MOD, 687 'auth_announce' => AUTH_MOD, 688 'auth_vote' => AUTH_REG, 689 'auth_pollcreate' => AUTH_REG, 690 ), 691 'registered' => array( 692 'auth_view' => AUTH_ALL, 693 'auth_read' => AUTH_ALL, 694 'auth_post' => AUTH_REG, 695 'auth_reply' => AUTH_REG, 696 'auth_edit' => AUTH_REG, 697 'auth_delete' => AUTH_REG, 698 'auth_sticky' => AUTH_MOD, 699 'auth_announce' => AUTH_MOD, 700 'auth_vote' => AUTH_REG, 701 'auth_pollcreate' => AUTH_REG, 702 ), 703 'registered_hidden' => array( 704 'auth_view' => AUTH_REG, 705 'auth_read' => AUTH_REG, 706 'auth_post' => AUTH_REG, 707 'auth_reply' => AUTH_REG, 708 'auth_edit' => AUTH_REG, 709 'auth_delete' => AUTH_REG, 710 'auth_sticky' => AUTH_MOD, 711 'auth_announce' => AUTH_MOD, 712 'auth_vote' => AUTH_REG, 713 'auth_pollcreate' => AUTH_REG, 714 ), 715 'private' => array( 716 'auth_view' => AUTH_ALL, 717 'auth_read' => AUTH_ACL, 718 'auth_post' => AUTH_ACL, 719 'auth_reply' => AUTH_ACL, 720 'auth_edit' => AUTH_ACL, 721 'auth_delete' => AUTH_ACL, 722 'auth_sticky' => AUTH_ACL, 723 'auth_announce' => AUTH_MOD, 724 'auth_vote' => AUTH_ACL, 725 'auth_pollcreate' => AUTH_ACL, 726 ), 727 'private_hidden' => array( 728 'auth_view' => AUTH_ACL, 729 'auth_read' => AUTH_ACL, 730 'auth_post' => AUTH_ACL, 731 'auth_reply' => AUTH_ACL, 732 'auth_edit' => AUTH_ACL, 733 'auth_delete' => AUTH_ACL, 734 'auth_sticky' => AUTH_ACL, 735 'auth_announce' => AUTH_MOD, 736 'auth_vote' => AUTH_ACL, 737 'auth_pollcreate' => AUTH_ACL, 738 ), 739 'moderator' => array( 740 'auth_view' => AUTH_ALL, 741 'auth_read' => AUTH_MOD, 742 'auth_post' => AUTH_MOD, 743 'auth_reply' => AUTH_MOD, 744 'auth_edit' => AUTH_MOD, 745 'auth_delete' => AUTH_MOD, 746 'auth_sticky' => AUTH_MOD, 747 'auth_announce' => AUTH_MOD, 748 'auth_vote' => AUTH_MOD, 749 'auth_pollcreate' => AUTH_MOD, 750 ), 751 'moderator_hidden' => array( 752 'auth_view' => AUTH_MOD, 753 'auth_read' => AUTH_MOD, 754 'auth_post' => AUTH_MOD, 755 'auth_reply' => AUTH_MOD, 756 'auth_edit' => AUTH_MOD, 757 'auth_delete' => AUTH_MOD, 758 'auth_sticky' => AUTH_MOD, 759 'auth_announce' => AUTH_MOD, 760 'auth_vote' => AUTH_MOD, 761 'auth_pollcreate' => AUTH_MOD, 762 ), 763 ); 764 765 if ($mode == 'start') 766 { 767 user_group_auth('guests', 'SELECT user_id, {GUESTS} FROM ' . USERS_TABLE . ' WHERE user_id = ' . ANONYMOUS, false); 768 user_group_auth('registered', 'SELECT user_id, {REGISTERED} FROM ' . USERS_TABLE . ' WHERE user_id <> ' . ANONYMOUS . " AND group_id <> $bot_group_id", false); 769 770 // Selecting from old table 771 if (!empty($config['increment_user_id'])) 772 { 773 $auth_sql = 'SELECT user_id, {ADMINISTRATORS} FROM ' . $convert->src_table_prefix . 'users WHERE user_level = 1 AND user_id <> 1'; 774 user_group_auth('administrators', $auth_sql, true); 775 776 $auth_sql = 'SELECT ' . $config['increment_user_id'] . ' as user_id, {ADMINISTRATORS} FROM ' . $convert->src_table_prefix . 'users WHERE user_level = 1 AND user_id = 1'; 777 user_group_auth('administrators', $auth_sql, true); 778 } 779 else 780 { 781 $auth_sql = 'SELECT user_id, {ADMINISTRATORS} FROM ' . $convert->src_table_prefix . 'users WHERE user_level = 1'; 782 user_group_auth('administrators', $auth_sql, true); 783 } 784 785 if (!empty($config['increment_user_id'])) 786 { 787 $auth_sql = 'SELECT user_id, {GLOBAL_MODERATORS} FROM ' . $convert->src_table_prefix . 'users WHERE user_level = 1 AND user_id <> 1'; 788 user_group_auth('global_moderators', $auth_sql, true); 789 790 $auth_sql = 'SELECT ' . $config['increment_user_id'] . ' as user_id, {GLOBAL_MODERATORS} FROM ' . $convert->src_table_prefix . 'users WHERE user_level = 1 AND user_id = 1'; 791 user_group_auth('global_moderators', $auth_sql, true); 792 } 793 else 794 { 795 $auth_sql = 'SELECT user_id, {GLOBAL_MODERATORS} FROM ' . $convert->src_table_prefix . 'users WHERE user_level = 1'; 796 user_group_auth('global_moderators', $auth_sql, true); 797 } 798 } 799 else if ($mode == 'first') 800 { 801 // Go through all 2.0.x forums 802 foreach ($forum_access as $forum) 803 { 804 $new_forum_id = (int) $forum['forum_id']; 805 806 // Administrators have full access to all forums whatever happens 807 mass_auth('group_role', $new_forum_id, 'administrators', 'FORUM_FULL'); 808 809 $matched_type = ''; 810 foreach ($simple_auth_ary as $key => $auth_levels) 811 { 812 $matched = 1; 813 foreach ($auth_levels as $k => $level) 814 { 815 if ($forum[$k] != $auth_levels[$k]) 816 { 817 $matched = 0; 818 } 819 } 820 821 if ($matched) 822 { 823 $matched_type = $key; 824 break; 825 } 826 } 827 828 switch ($matched_type) 829 { 830 case 'public': 831 mass_auth('group_role', $new_forum_id, 'guests', 'FORUM_LIMITED'); 832 mass_auth('group_role', $new_forum_id, 'registered', 'FORUM_LIMITED_POLLS'); 833 mass_auth('group_role', $new_forum_id, 'bots', 'FORUM_BOT'); 834 break; 835 836 case 'registered': 837 mass_auth('group_role', $new_forum_id, 'guests', 'FORUM_READONLY'); 838 mass_auth('group_role', $new_forum_id, 'bots', 'FORUM_BOT'); 839 840 // no break; 841 842 case 'registered_hidden': 843 mass_auth('group_role', $new_forum_id, 'registered', 'FORUM_POLLS'); 844 break; 845 846 case 'private': 847 case 'private_hidden': 848 case 'moderator': 849 case 'moderator_hidden': 850 default: 851 // The permissions don't match a simple set, so we're going to have to map them directly 852 853 // No post approval for all, in 2.0.x this feature does not exist 854 mass_auth('group', $new_forum_id, 'guests', 'f_noapprove', ACL_YES); 855 mass_auth('group', $new_forum_id, 'registered', 'f_noapprove', ACL_YES); 856 857 // Go through authentication map 858 foreach ($auth_map as $old_auth_key => $new_acl) 859 { 860 // If old authentication key does not exist we continue 861 // This is helpful for mods adding additional authentication fields, we need to add them to the auth_map array 862 if (!isset($forum[$old_auth_key])) 863 { 864 continue; 865 } 866 867 // Now set the new ACL correctly 868 switch ($forum[$old_auth_key]) 869 { 870 // AUTH_ALL 871 case AUTH_ALL: 872 mass_auth('group', $new_forum_id, 'guests', $new_acl, ACL_YES); 873 mass_auth('group', $new_forum_id, 'bots', $new_acl, ACL_YES); 874 mass_auth('group', $new_forum_id, 'registered', $new_acl, ACL_YES); 875 break; 876 877 // AUTH_REG 878 case AUTH_REG: 879 mass_auth('group', $new_forum_id, 'registered', $new_acl, ACL_YES); 880 break; 881 882 // AUTH_ACL 883 case AUTH_ACL: 884 // Go through the old group access list for this forum 885 if (isset($group_access[$forum['forum_id']])) 886 { 887 foreach ($group_access[$forum['forum_id']] as $index => $access) 888 { 889 // We only check for ACL_YES equivalence entry 890 if (isset($access[$old_auth_key]) && $access[$old_auth_key] == 1) 891 { 892 mass_auth('group', $new_forum_id, (int) $access['group_id'], $new_acl, ACL_YES); 893 } 894 } 895 } 896 897 if (isset($user_access[$forum['forum_id']])) 898 { 899 foreach ($user_access[$forum['forum_id']] as $index => $access) 900 { 901 // We only check for ACL_YES equivalence entry 902 if (isset($access[$old_auth_key]) && $access[$old_auth_key] == 1) 903 { 904 mass_auth('user', $new_forum_id, (int) phpbb_user_id($access['user_id']), $new_acl, ACL_YES); 905 } 906 } 907 } 908 break; 909 910 // AUTH_MOD 911 case AUTH_MOD: 912 if (isset($group_access[$forum['forum_id']])) 913 { 914 foreach ($group_access[$forum['forum_id']] as $index => $access) 915 { 916 // We only check for ACL_YES equivalence entry 917 if (isset($access[$old_auth_key]) && $access[$old_auth_key] == 1) 918 { 919 mass_auth('group', $new_forum_id, (int) $access['group_id'], $new_acl, ACL_YES); 920 } 921 } 922 } 923 924 if (isset($user_access[$forum['forum_id']])) 925 { 926 foreach ($user_access[$forum['forum_id']] as $index => $access) 927 { 928 // We only check for ACL_YES equivalence entry 929 if (isset($access[$old_auth_key]) && $access[$old_auth_key] == 1) 930 { 931 mass_auth('user', $new_forum_id, (int) phpbb_user_id($access['user_id']), $new_acl, ACL_YES); 932 } 933 } 934 } 935 break; 936 } 937 } 938 break; 939 } 940 } 941 } 942 else if ($mode == 'second') 943 { 944 // Assign permission roles and other default permissions 945 946 // guests having u_download and u_search ability 947 $db->sql_query('INSERT INTO ' . ACL_GROUPS_TABLE . ' (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) SELECT ' . get_group_id('guests') . ', 0, auth_option_id, 0, 1 FROM ' . ACL_OPTIONS_TABLE . " WHERE auth_option IN ('u_', 'u_download', 'u_search')"); 948 949 // administrators/global mods having full user features 950 mass_auth('group_role', 0, 'administrators', 'USER_FULL'); 951 mass_auth('group_role', 0, 'global_moderators', 'USER_FULL'); 952 953 // By default all converted administrators are given full access 954 mass_auth('group_role', 0, 'administrators', 'ADMIN_FULL'); 955 956 // All registered users are assigned the standard user role 957 mass_auth('group_role', 0, 'registered', 'USER_STANDARD'); 958 mass_auth('group_role', 0, 'registered_coppa', 'USER_STANDARD'); 959 960 // Instead of administrators being global moderators we give the MOD_FULL role to global mods (admins already assigned to this group) 961 mass_auth('group_role', 0, 'global_moderators', 'MOD_FULL'); 962 963 // And now those who have had their avatar rights removed get assigned a more restrictive role 964 $sql = 'SELECT user_id FROM ' . $convert->src_table_prefix . 'users 965 WHERE user_allowavatar = 0 966 AND user_id > 0'; 967 $result = $src_db->sql_query($sql); 968 969 while ($row = $src_db->sql_fetchrow($result)) 970 { 971 mass_auth('user_role', 0, (int) phpbb_user_id($row['user_id']), 'USER_NOAVATAR'); 972 } 973 $src_db->sql_freeresult($result); 974 975 // And the same for those who have had their PM rights removed 976 $sql = 'SELECT user_id FROM ' . $convert->src_table_prefix . 'users 977 WHERE user_allow_pm = 0 978 AND user_id > 0'; 979 $result = $src_db->sql_query($sql); 980 981 while ($row = $src_db->sql_fetchrow($result)) 982 { 983 mass_auth('user_role', 0, (int) phpbb_user_id($row['user_id']), 'USER_NOPM'); 984 } 985 $src_db->sql_freeresult($result); 986 } 987 else if ($mode == 'third') 988 { 989 // And now the moderators 990 // We make sure that they have at least standard access to the forums they moderate in addition to the moderating permissions 991 992 $mod_post_map = array( 993 'auth_announce' => 'f_announce', 994 'auth_sticky' => 'f_sticky' 995 ); 996 997 foreach ($user_access as $forum_id => $access_map) 998 { 999 $forum_id = (int) $forum_id; 1000 1001 foreach ($access_map as $access) 1002 { 1003 if (isset($access['auth_mod']) && $access['auth_mod'] == 1) 1004 { 1005 mass_auth('user_role', $forum_id, (int) phpbb_user_id($access['user_id']), 'MOD_STANDARD'); 1006 mass_auth('user_role', $forum_id, (int) phpbb_user_id($access['user_id']), 'FORUM_STANDARD'); 1007 foreach ($mod_post_map as $old => $new) 1008 { 1009 if (isset($forum_access[$forum_id]) && isset($forum_access[$forum_id][$old]) && $forum_access[$forum_id][$old] == AUTH_MOD) 1010 { 1011 mass_auth('user', $forum_id, (int) phpbb_user_id($access['user_id']), $new, ACL_YES); 1012 } 1013 } 1014 } 1015 } 1016 } 1017 1018 foreach ($group_access as $forum_id => $access_map) 1019 { 1020 $forum_id = (int) $forum_id; 1021 1022 foreach ($access_map as $access) 1023 { 1024 if (isset($access['auth_mod']) && $access['auth_mod'] == 1) 1025 { 1026 mass_auth('group_role', $forum_id, (int) $access['group_id'], 'MOD_STANDARD'); 1027 mass_auth('group_role', $forum_id, (int) $access['group_id'], 'FORUM_STANDARD'); 1028 foreach ($mod_post_map as $old => $new) 1029 { 1030 if (isset($forum_access[$forum_id]) && isset($forum_access[$forum_id][$old]) && $forum_access[$forum_id][$old] == AUTH_MOD) 1031 { 1032 mass_auth('group', $forum_id, (int) $access['group_id'], $new, ACL_YES); 1033 } 1034 } 1035 } 1036 } 1037 } 1038 1039 // We grant everyone readonly access to the categories to ensure that the forums are visible 1040 $sql = 'SELECT forum_id, forum_name, parent_id, left_id, right_id 1041 FROM ' . FORUMS_TABLE . ' 1042 ORDER BY left_id ASC'; 1043 $result = $db->sql_query($sql); 1044 1045 $parent_forums = $forums = array(); 1046 while ($row = $db->sql_fetchrow($result)) 1047 { 1048 if ($row['parent_id'] == 0) 1049 { 1050 mass_auth('group_role', $row['forum_id'], 'administrators', 'FORUM_FULL'); 1051 mass_auth('group_role', $row['forum_id'], 'global_moderators', 'FORUM_FULL'); 1052 $parent_forums[] = $row; 1053 } 1054 else 1055 { 1056 $forums[] = $row; 1057 } 1058 } 1059 $db->sql_freeresult($result); 1060 1061 global $auth; 1062 1063 // Let us see which groups have access to these forums... 1064 foreach ($parent_forums as $row) 1065 { 1066 // Get the children 1067 $branch = $forum_ids = array(); 1068 1069 foreach ($forums as $key => $_row) 1070 { 1071 if ($_row['left_id'] > $row['left_id'] && $_row['left_id'] < $row['right_id']) 1072 { 1073 $branch[] = $_row; 1074 $forum_ids[] = $_row['forum_id']; 1075 continue; 1076 } 1077 } 1078 1079 if (sizeof($forum_ids)) 1080 { 1081 // Now make sure the user is able to read these forums 1082 $hold_ary = $auth->acl_group_raw_data(false, 'f_list', $forum_ids); 1083 1084 if (empty($hold_ary)) 1085 { 1086 continue; 1087 } 1088 1089 foreach ($hold_ary as $g_id => $f_id_ary) 1090 { 1091 $set_group = false; 1092 1093 foreach ($f_id_ary as $f_id => $auth_ary) 1094 { 1095 foreach ($auth_ary as $auth_option => $setting) 1096 { 1097 if ($setting == ACL_YES) 1098 { 1099 $set_group = true; 1100 break 2; 1101 } 1102 } 1103 } 1104 1105 if ($set_group) 1106 { 1107 mass_auth('group', $row['forum_id'], $g_id, 'f_list', ACL_YES); 1108 } 1109 } 1110 } 1111 } 1112 } 1113 } 1114 1115 /** 1116 * Set primary group. 1117 * Really simple and only based on user_level (remaining groups will be assigned later) 1118 */ 1119 function phpbb_set_primary_group($user_level) 1120 { 1121 global $convert_row; 1122 1123 if ($user_level == 1) 1124 { 1125 return get_group_id('administrators'); 1126 } 1127 /* else if ($user_level == 2) 1128 { 1129 return get_group_id('global_moderators'); 1130 } 1131 else if ($user_level == 0 && $convert_row['user_active'])*/ 1132 else if ($convert_row['user_active']) 1133 { 1134 return get_group_id('registered'); 1135 } 1136 1137 return 0; 1138 } 1139 1140 /** 1141 * Convert the group name, making sure to avoid conflicts with 3.0 special groups 1142 */ 1143 function phpbb_convert_group_name($group_name) 1144 { 1145 $default_groups = array( 1146 'GUESTS', 1147 'REGISTERED', 1148 'REGISTERED_COPPA', 1149 'GLOBAL_MODERATORS', 1150 'ADMINISTRATORS', 1151 'BOTS', 1152 ); 1153 1154 if (in_array(strtoupper($group_name), $default_groups)) 1155 { 1156 return 'phpBB2 - ' . $group_name; 1157 } 1158 1159 return phpbb_set_default_encoding($group_name); 1160 } 1161 1162 /** 1163 * Convert the group type constants 1164 */ 1165 function phpbb_convert_group_type($group_type) 1166 { 1167 switch ($group_type) 1168 { 1169 case 0: 1170 return GROUP_OPEN; 1171 break; 1172 1173 case 1: 1174 return GROUP_CLOSED; 1175 break; 1176 1177 case 2: 1178 return GROUP_HIDDEN; 1179 break; 1180 } 1181 1182 // Never return GROUP_SPECIAL here, because only phpBB3's default groups are allowed to have this type set. 1183 return GROUP_HIDDEN; 1184 } 1185 1186 /** 1187 * Convert the topic type constants 1188 */ 1189 function phpbb_convert_topic_type($topic_type) 1190 { 1191 switch ($topic_type) 1192 { 1193 case 0: 1194 return POST_NORMAL; 1195 break; 1196 1197 case 1: 1198 return POST_STICKY; 1199 break; 1200 1201 case 2: 1202 return POST_ANNOUNCE; 1203 break; 1204 1205 case 3: 1206 return POST_GLOBAL; 1207 break; 1208 } 1209 1210 return POST_NORMAL; 1211 } 1212 1213 function phpbb_replace_size($matches) 1214 { 1215 return '[size=' . min(200, ceil(100.0 * (((double) $matches[1])/12.0))) . ':' . $matches[2] . ']'; 1216 } 1217 1218 /** 1219 * Reparse the message stripping out the bbcode_uid values and adding new ones and setting the bitfield 1220 * @todo What do we want to do about HTML in messages - currently it gets converted to the entities, but there may be some objections to this 1221 */ 1222 function phpbb_prepare_message($message) 1223 { 1224 global $phpbb_root_path, $phpEx, $db, $convert, $user, $config, $cache, $convert_row, $message_parser; 1225 1226 if (!$message) 1227 { 1228 $convert->row['mp_bbcode_bitfield'] = $convert_row['mp_bbcode_bitfield'] = 0; 1229 return ''; 1230 } 1231 1232 // Decode phpBB 2.0.x Message 1233 if (isset($convert->row['old_bbcode_uid']) && $convert->row['old_bbcode_uid'] != '') 1234 { 1235 // Adjust size... 1236 if (strpos($message, '[size=') !== false) 1237 { 1238 $message = preg_replace_callback('/\[size=(\d*):(' . $convert->row['old_bbcode_uid'] . ')\]/', 'phpbb_replace_size', $message); 1239 } 1240 1241 $message = preg_replace('/\:(([a-z0-9]:)?)' . $convert->row['old_bbcode_uid'] . '/s', '', $message); 1242 } 1243 1244 if (strpos($message, '[quote=') !== false) 1245 { 1246 $message = preg_replace('/\[quote="(.*?)"\]/s', '[quote="\1"]', $message); 1247 $message = preg_replace('/\[quote=\\\"(.*?)\\\"\]/s', '[quote="\1"]', $message); 1248 1249 // let's hope that this solves more problems than it causes. Deal with escaped quotes. 1250 $message = str_replace('\"', '"', $message); 1251 $message = str_replace('\"', '"', $message); 1252 } 1253 1254 // Already the new user id ;) 1255 $user_id = $convert->row['poster_id']; 1256 1257 $message = str_replace('<br />', "\n", $message); 1258 $message = str_replace('<', '<', $message); 1259 $message = str_replace('>', '>', $message); 1260 1261 // make the post UTF-8 1262 $message = phpbb_set_encoding($message); 1263 1264 $message_parser->warn_msg = array(); // Reset the errors from the previous message 1265 $message_parser->bbcode_uid = make_uid($convert->row['post_time']); 1266 $message_parser->message = $message; 1267 unset($message); 1268 1269 // Make sure options are set. 1270 // $enable_html = (!isset($row['enable_html'])) ? false : $row['enable_html']; 1271 $enable_bbcode = (!isset($convert->row['enable_bbcode'])) ? true : $convert->row['enable_bbcode']; 1272 $enable_smilies = (!isset($convert->row['enable_smilies'])) ? true : $convert->row['enable_smilies']; 1273 $enable_magic_url = (!isset($convert->row['enable_magic_url'])) ? true : $convert->row['enable_magic_url']; 1274 1275 // parse($allow_bbcode, $allow_magic_url, $allow_smilies, $allow_img_bbcode = true, $allow_flash_bbcode = true, $allow_quote_bbcode = true, $allow_url_bbcode = true, $update_this_message = true, $mode = 'post') 1276 $message_parser->parse($enable_bbcode, $enable_magic_url, $enable_smilies); 1277 1278 if (sizeof($message_parser->warn_msg)) 1279 { 1280 $msg_id = isset($convert->row['post_id']) ? $convert->row['post_id'] : $convert->row['privmsgs_id']; 1281 $convert->p_master->error('<span style="color:red">' . $user->lang['POST_ID'] . ': ' . $msg_id . ' ' . $user->lang['CONV_ERROR_MESSAGE_PARSER'] . ': <br /><br />' . implode('<br />', $message_parser->warn_msg), __LINE__, __FILE__, true); 1282 } 1283 1284 $convert->row['mp_bbcode_bitfield'] = $convert_row['mp_bbcode_bitfield'] = $message_parser->bbcode_bitfield; 1285 1286 $message = $message_parser->message; 1287 unset($message_parser->message); 1288 1289 return $message; 1290 } 1291 1292 /** 1293 * Return the bitfield calculated by the previous function 1294 */ 1295 function get_bbcode_bitfield() 1296 { 1297 global $convert_row; 1298 1299 return $convert_row['mp_bbcode_bitfield']; 1300 } 1301 1302 /** 1303 * Determine the last user to edit a post 1304 * In practice we only tracked edits by the original poster in 2.0.x so this will only be set if they had edited their own post 1305 */ 1306 function phpbb_post_edit_user() 1307 { 1308 global $convert_row, $config; 1309 1310 if (isset($convert_row['post_edit_count'])) 1311 { 1312 return phpbb_user_id($convert_row['poster_id']); 1313 } 1314 1315 return 0; 1316 } 1317 1318 /** 1319 * Obtain the path to uploaded files on the 2.0.x forum 1320 * This is only used if the Attachment MOD was installed 1321 */ 1322 function phpbb_get_files_dir() 1323 { 1324 if (!defined('MOD_ATTACHMENT')) 1325 { 1326 return; 1327 } 1328 1329 global $src_db, $same_db, $convert, $user, $config, $cache; 1330 1331 if ($convert->mysql_convert && $same_db) 1332 { 1333 $src_db->sql_query("SET NAMES 'binary'"); 1334 } 1335 $sql = 'SELECT config_value AS upload_dir 1336 FROM ' . $convert->src_table_prefix . "attachments_config 1337 WHERE config_name = 'upload_dir'"; 1338 $result = $src_db->sql_query($sql); 1339 $upload_path = $src_db->sql_fetchfield('upload_dir'); 1340 $src_db->sql_freeresult($result); 1341 1342 $sql = 'SELECT config_value AS ftp_upload 1343 FROM ' . $convert->src_table_prefix . "attachments_config 1344 WHERE config_name = 'allow_ftp_upload'"; 1345 $result = $src_db->sql_query($sql); 1346 $ftp_upload = (int) $src_db->sql_fetchfield('ftp_upload'); 1347 $src_db->sql_freeresult($result); 1348 1349 if ($convert->mysql_convert && $same_db) 1350 { 1351 $src_db->sql_query("SET NAMES 'utf8'"); 1352 } 1353 1354 if ($ftp_upload) 1355 { 1356 $convert->p_master->error($user->lang['CONV_ERROR_ATTACH_FTP_DIR'], __LINE__, __FILE__); 1357 } 1358 1359 return $upload_path; 1360 } 1361 1362 /** 1363 * Copy thumbnails of uploaded images from the 2.0.x forum 1364 * This is only used if the Attachment MOD was installed 1365 */ 1366 function phpbb_copy_thumbnails() 1367 { 1368 global $db, $convert, $user, $config, $cache, $phpbb_root_path; 1369 1370 $src_path = $convert->options['forum_path'] . '/' . phpbb_get_files_dir() . '/thumbs/'; 1371 1372 if ($handle = @opendir($src_path)) 1373 { 1374 while ($entry = readdir($handle)) 1375 { 1376 if ($entry[0] == '.') 1377 { 1378 continue; 1379 } 1380 1381 if (is_dir($src_path . $entry)) 1382 { 1383 continue; 1384 } 1385 else 1386 { 1387 copy_file($src_path . $entry, $config['upload_path'] . '/' . preg_replace('/^t_/', 'thumb_', $entry)); 1388 @unlink($phpbb_root_path . $config['upload_path'] . '/thumbs/' . $entry); 1389 } 1390 } 1391 closedir($handle); 1392 } 1393 } 1394 1395 /** 1396 * Convert the attachment category constants 1397 * This is only used if the Attachment MOD was installed 1398 */ 1399 function phpbb_attachment_category($cat_id) 1400 { 1401 switch ($cat_id) 1402 { 1403 case 1: 1404 return ATTACHMENT_CATEGORY_IMAGE; 1405 break; 1406 1407 case 2: 1408 return ATTACHMENT_CATEGORY_WM; 1409 break; 1410 1411 case 3: 1412 return ATTACHMENT_CATEGORY_FLASH; 1413 break; 1414 } 1415 1416 return ATTACHMENT_CATEGORY_NONE; 1417 } 1418 1419 /** 1420 * Convert the attachment extension names 1421 * This is only used if the Attachment MOD was installed 1422 */ 1423 function phpbb_attachment_extension_group_name() 1424 { 1425 global $db, $phpbb_root_path, $phpEx; 1426 1427 // Update file extension group names to use language strings. 1428 $sql = 'SELECT lang_dir 1429 FROM ' . LANG_TABLE; 1430 $result = $db->sql_query($sql); 1431 1432 $extension_groups_updated = array(); 1433 while ($lang_dir = $db->sql_fetchfield('lang_dir')) 1434 { 1435 $lang_dir = basename($lang_dir); 1436 $lang_file = $phpbb_root_path . 'language/' . $lang_dir . '/acp/attachments.' . $phpEx; 1437 1438 if (!file_exists($lang_file)) 1439 { 1440 continue; 1441 } 1442 1443 $lang = array(); 1444 include($lang_file); 1445 1446 foreach ($lang as $lang_key => $lang_val) 1447 { 1448 if (isset($extension_groups_updated[$lang_key]) || strpos($lang_key, 'EXT_GROUP_') !== 0) 1449 { 1450 continue; 1451 } 1452 1453 $sql_ary = array( 1454 'group_name' => substr($lang_key, 10), // Strip off 'EXT_GROUP_' 1455 ); 1456 1457 $sql = 'UPDATE ' . EXTENSION_GROUPS_TABLE . ' 1458 SET ' . $db->sql_build_array('UPDATE', $sql_ary) . " 1459 WHERE group_name = '" . $db->sql_escape($lang_val) . "'"; 1460 $db->sql_query($sql); 1461 1462 $extension_groups_updated[$lang_key] = true; 1463 } 1464 } 1465 $db->sql_freeresult($result); 1466 } 1467 1468 /** 1469 * Obtain list of forums in which different attachment categories can be used 1470 */ 1471 function phpbb_attachment_forum_perms($forum_permissions) 1472 { 1473 if (empty($forum_permissions)) 1474 { 1475 return ''; 1476 } 1477 1478 // Decode forum permissions 1479 $forum_ids = array(); 1480 1481 $one_char_encoding = '#'; 1482 $two_char_encoding = '.'; 1483 1484 $auth_len = 1; 1485 for ($pos = 0; $pos < strlen($forum_permissions); $pos += $auth_len) 1486 { 1487 $forum_auth = substr($forum_permissions, $pos, 1); 1488 if ($forum_auth == $one_char_encoding) 1489 { 1490 $auth_len = 1; 1491 continue; 1492 } 1493 else if ($forum_auth == $two_char_encoding) 1494 { 1495 $auth_len = 2; 1496 $pos--; 1497 continue; 1498 } 1499 1500 $forum_auth = substr($forum_permissions, $pos, $auth_len); 1501 $forum_id = base64_unpack($forum_auth); 1502 1503 $forum_ids[] = (int) $forum_id; 1504 } 1505 1506 if (sizeof($forum_ids)) 1507 { 1508 return attachment_forum_perms($forum_ids); 1509 } 1510 1511 return ''; 1512 } 1513 1514 /** 1515 * Convert the avatar type constants 1516 */ 1517 function phpbb_avatar_type($type) 1518 { 1519 switch ($type) 1520 { 1521 case 1: 1522 return AVATAR_UPLOAD; 1523 break; 1524 1525 case 2: 1526 return AVATAR_REMOTE; 1527 break; 1528 1529 case 3: 1530 return AVATAR_GALLERY; 1531 break; 1532 } 1533 1534 return 0; 1535 } 1536 1537 1538 /** 1539 * Just undos the replacing of '<' and '>' 1540 */ 1541 function phpbb_smilie_html_decode($code) 1542 { 1543 $code = str_replace('<', '<', $code); 1544 return str_replace('>', '>', $code); 1545 } 1546 1547 /** 1548 * Transfer avatars, copying the image if it was uploaded 1549 */ 1550 function phpbb_import_avatar($user_avatar) 1551 { 1552 global $convert_row; 1553 1554 if (!$convert_row['user_avatar_type']) 1555 { 1556 return ''; 1557 } 1558 else if ($convert_row['user_avatar_type'] == 1) 1559 { 1560 // Uploaded avatar 1561 return import_avatar($user_avatar, false, $convert_row['user_id']); 1562 } 1563 else if ($convert_row['user_avatar_type'] == 2) 1564 { 1565 // Remote avatar 1566 return $user_avatar; 1567 } 1568 else if ($convert_row['user_avatar_type'] == 3) 1569 { 1570 // Gallery avatar 1571 return $user_avatar; 1572 } 1573 1574 return ''; 1575 } 1576 1577 1578 /** 1579 * Find out about the avatar's dimensions 1580 */ 1581 function phpbb_get_avatar_height($user_avatar) 1582 { 1583 global $convert_row; 1584 1585 if (empty($convert_row['user_avatar_type'])) 1586 { 1587 return 0; 1588 } 1589 return get_avatar_height($user_avatar, 'phpbb_avatar_type', $convert_row['user_avatar_type']); 1590 } 1591 1592 1593 /** 1594 * Find out about the avatar's dimensions 1595 */ 1596 function phpbb_get_avatar_width($user_avatar) 1597 { 1598 global $convert_row; 1599 1600 if (empty($convert_row['user_avatar_type'])) 1601 { 1602 return 0; 1603 } 1604 1605 return get_avatar_width($user_avatar, 'phpbb_avatar_type', $convert_row['user_avatar_type']); 1606 } 1607 1608 1609 /** 1610 * Calculate the correct to_address field for private messages 1611 */ 1612 function phpbb_privmsgs_to_userid($to_userid) 1613 { 1614 global $config; 1615 1616 return 'u_' . phpbb_user_id($to_userid); 1617 } 1618 1619 /** 1620 * Calculate whether a private message was unread using the bitfield 1621 */ 1622 function phpbb_unread_pm($pm_type) 1623 { 1624 return ($pm_type == 5) ? 1 : 0; 1625 } 1626 1627 /** 1628 * Calculate whether a private message was new using the bitfield 1629 */ 1630 function phpbb_new_pm($pm_type) 1631 { 1632 return ($pm_type == 1) ? 1 : 0; 1633 } 1634 1635 /** 1636 * Obtain the folder_id for the custom folder created to replace the savebox from 2.0.x (used to store saved private messages) 1637 */ 1638 function phpbb_get_savebox_id($user_id) 1639 { 1640 global $db; 1641 1642 $user_id = phpbb_user_id($user_id); 1643 1644 // Only one custom folder, check only one 1645 $sql = 'SELECT folder_id 1646 FROM ' . PRIVMSGS_FOLDER_TABLE . ' 1647 WHERE user_id = ' . $user_id; 1648 $result = $db->sql_query_limit($sql, 1); 1649 $folder_id = (int) $db->sql_fetchfield('folder_id'); 1650 $db->sql_freeresult($result); 1651 1652 return $folder_id; 1653 } 1654 1655 /** 1656 * Transfer attachment specific configuration options 1657 * These were not stored in the main config table on 2.0.x 1658 * This is only used if the Attachment MOD was installed 1659 */ 1660 function phpbb_import_attach_config() 1661 { 1662 global $db, $src_db, $same_db, $convert, $config; 1663 1664 if ($convert->mysql_convert && $same_db) 1665 { 1666 $src_db->sql_query("SET NAMES 'binary'"); 1667 } 1668 1669 $sql = 'SELECT * 1670 FROM ' . $convert->src_table_prefix . 'attachments_config'; 1671 $result = $src_db->sql_query($sql); 1672 1673 if ($convert->mysql_convert && $same_db) 1674 { 1675 $src_db->sql_query("SET NAMES 'utf8'"); 1676 } 1677 1678 $attach_config = array(); 1679 while ($row = $src_db->sql_fetchrow($result)) 1680 { 1681 $attach_config[$row['config_name']] = $row['config_value']; 1682 } 1683 $src_db->sql_freeresult($result); 1684 1685 set_config('allow_attachments', 1); 1686 1687 // old attachment mod? Must be very old if this entry do not exist... 1688 if (!empty($attach_config['display_order'])) 1689 { 1690 set_config('display_order', $attach_config['display_order']); 1691 } 1692 set_config('max_filesize', $attach_config['max_filesize']); 1693 set_config('max_filesize_pm', $attach_config['max_filesize_pm']); 1694 set_config('attachment_quota', $attach_config['attachment_quota']); 1695 set_config('max_attachments', $attach_config['max_attachments']); 1696 set_config('max_attachments_pm', $attach_config['max_attachments_pm']); 1697 set_config('allow_pm_attach', $attach_config['allow_pm_attach']); 1698 1699 set_config('img_display_inlined', $attach_config['img_display_inlined']); 1700 set_config('img_max_width', $attach_config['img_max_width']); 1701 set_config('img_max_height', $attach_config['img_max_height']); 1702 set_config('img_link_width', $attach_config['img_link_width']); 1703 set_config('img_link_height', $attach_config['img_link_height']); 1704 set_config('img_create_thumbnail', $attach_config['img_create_thumbnail']); 1705 set_config('img_max_thumb_width', 400); 1706 set_config('img_min_thumb_filesize', $attach_config['img_min_thumb_filesize']); 1707 set_config('img_imagick', $attach_config['img_imagick']); 1708 } 1709 1710 /** 1711 * Calculate the date a user became inactive 1712 */ 1713 function phpbb_inactive_time() 1714 { 1715 global $convert_row; 1716 1717 if ($convert_row['user_active']) 1718 { 1719 return 0; 1720 } 1721 1722 if ($convert_row['user_lastvisit']) 1723 { 1724 return $convert_row['user_lastvisit']; 1725 } 1726 1727 return $convert_row['user_regdate']; 1728 } 1729 1730 /** 1731 * Calculate the reason a user became inactive 1732 * We can't actually tell the difference between a manual deactivation and one for profile changes 1733 * from the data available to assume the latter 1734 */ 1735 function phpbb_inactive_reason() 1736 { 1737 global $convert_row; 1738 1739 if ($convert_row['user_active']) 1740 { 1741 return 0; 1742 } 1743 1744 if ($convert_row['user_lastvisit']) 1745 { 1746 return INACTIVE_PROFILE; 1747 } 1748 1749 return INACTIVE_REGISTER; 1750 } 1751 1752 /** 1753 * Adjust 2.0.x disallowed names to 3.0.x format 1754 */ 1755 function phpbb_disallowed_username($username) 1756 { 1757 // Replace * with % 1758 $username = phpbb_set_default_encoding(str_replace('*', '%', $username)); 1759 return utf8_htmlspecialchars($username); 1760 } 1761 1762 /** 1763 * Checks whether there are any usernames on the old board that would map to the same 1764 * username_clean on phpBB3. Prints out a list if any exist and exits. 1765 */ 1766 function phpbb_create_userconv_table() 1767 { 1768 global $db, $src_db, $convert, $table_prefix, $user, $lang; 1769 1770 $map_dbms = ''; 1771 switch ($db->get_sql_layer()) 1772 { 1773 case 'mysql': 1774 $map_dbms = 'mysql_40'; 1775 break; 1776 1777 case 'mysql4': 1778 if (version_compare($db->sql_server_info(true), '4.1.3', '>=')) 1779 { 1780 $map_dbms = 'mysql_41'; 1781 } 1782 else 1783 { 1784 $map_dbms = 'mysql_40'; 1785 } 1786 break; 1787 1788 case 'mysqli': 1789 $map_dbms = 'mysql_41'; 1790 break; 1791 1792 case 'mssql': 1793 case 'mssql_odbc': 1794 case 'mssqlnative': 1795 $map_dbms = 'mssql'; 1796 break; 1797 1798 default: 1799 $map_dbms = $db->get_sql_layer(); 1800 break; 1801 } 1802 1803 // create a temporary table in which we store the clean usernames 1804 $drop_sql = 'DROP TABLE ' . USERCONV_TABLE; 1805 switch ($map_dbms) 1806 { 1807 case 'mssql': 1808 $create_sql = 'CREATE TABLE [' . USERCONV_TABLE . '] ( 1809 [user_id] [int] NOT NULL , 1810 [username_clean] [varchar] (255) DEFAULT (\'\') NOT NULL 1811 )'; 1812 break; 1813 1814 case 'mysql_40': 1815 $create_sql = 'CREATE TABLE ' . USERCONV_TABLE . ' ( 1816 user_id mediumint(8) NOT NULL, 1817 username_clean blob NOT NULL 1818 )'; 1819 break; 1820 1821 case 'mysql_41': 1822 $create_sql = 'CREATE TABLE ' . USERCONV_TABLE . ' ( 1823 user_id mediumint(8) NOT NULL, 1824 username_clean varchar(255) DEFAULT \'\' NOT NULL 1825 ) CHARACTER SET `utf8` COLLATE `utf8_bin`'; 1826 break; 1827 1828 case 'oracle': 1829 $create_sql = 'CREATE TABLE ' . USERCONV_TABLE . ' ( 1830 user_id number(8) NOT NULL, 1831 username_clean varchar2(255) DEFAULT \'\' 1832 )'; 1833 break; 1834 1835 case 'postgres': 1836 $create_sql = 'CREATE TABLE ' . USERCONV_TABLE . ' ( 1837 user_id INT4 DEFAULT \'0\', 1838 username_clean varchar_ci DEFAULT \'\' NOT NULL 1839 )'; 1840 break; 1841 1842 case 'sqlite': 1843 case 'sqlite3': 1844 $create_sql = 'CREATE TABLE ' . USERCONV_TABLE . ' ( 1845 user_id INTEGER NOT NULL DEFAULT \'0\', 1846 username_clean varchar(255) NOT NULL DEFAULT \'\' 1847 )'; 1848 break; 1849 } 1850 1851 $db->sql_return_on_error(true); 1852 $db->sql_query($drop_sql); 1853 $db->sql_return_on_error(false); 1854 $db->sql_query($create_sql); 1855 } 1856 1857 function phpbb_check_username_collisions() 1858 { 1859 global $db, $src_db, $convert, $table_prefix, $user, $lang; 1860 1861 // now find the clean version of the usernames that collide 1862 $sql = 'SELECT username_clean 1863 FROM ' . USERCONV_TABLE .' 1864 GROUP BY username_clean 1865 HAVING COUNT(user_id) > 1'; 1866 $result = $db->sql_query($sql); 1867 1868 $colliding_names = array(); 1869 while ($row = $db->sql_fetchrow($result)) 1870 { 1871 $colliding_names[] = $row['username_clean']; 1872 } 1873 $db->sql_freeresult($result); 1874 1875 // there was at least one collision, the admin will have to solve it before conversion can continue 1876 if (sizeof($colliding_names)) 1877 { 1878 $sql = 'SELECT user_id, username_clean 1879 FROM ' . USERCONV_TABLE . ' 1880 WHERE ' . $db->sql_in_set('username_clean', $colliding_names); 1881 $result = $db->sql_query($sql); 1882 unset($colliding_names); 1883 1884 $colliding_user_ids = array(); 1885 while ($row = $db->sql_fetchrow($result)) 1886 { 1887 $colliding_user_ids[(int) $row['user_id']] = $row['username_clean']; 1888 } 1889 $db->sql_freeresult($result); 1890 1891 $sql = 'SELECT username, user_id, user_posts 1892 FROM ' . $convert->src_table_prefix . 'users 1893 WHERE ' . $src_db->sql_in_set('user_id', array_keys($colliding_user_ids)); 1894 $result = $src_db->sql_query($sql); 1895 1896 $colliding_users = array(); 1897 while ($row = $src_db->sql_fetchrow($result)) 1898 { 1899 $row['user_id'] = (int) $row['user_id']; 1900 if (isset($colliding_user_ids[$row['user_id']])) 1901 { 1902 $colliding_users[$colliding_user_ids[$row['user_id']]][] = $row; 1903 } 1904 } 1905 $src_db->sql_freeresult($result); 1906 unset($colliding_user_ids); 1907 1908 $list = ''; 1909 foreach ($colliding_users as $username_clean => $users) 1910 { 1911 $list .= sprintf($user->lang['COLLIDING_CLEAN_USERNAME'], $username_clean) . "<br />\n"; 1912 foreach ($users as $i => $row) 1913 { 1914 $list .= sprintf($user->lang['COLLIDING_USER'], $row['user_id'], phpbb_set_default_encoding($row['username']), $row['user_posts']) . "<br />\n"; 1915 } 1916 } 1917 1918 $lang['INST_ERR_FATAL'] = $user->lang['CONV_ERR_FATAL']; 1919 $convert->p_master->error('<span style="color:red">' . $user->lang['COLLIDING_USERNAMES_FOUND'] . '</span></b><br /><br />' . $list . '<b>', __LINE__, __FILE__); 1920 } 1921 1922 $drop_sql = 'DROP TABLE ' . USERCONV_TABLE; 1923 $db->sql_query($drop_sql); 1924 } 1925 1926 function phpbb_convert_timezone($timezone) 1927 { 1928 global $config, $db, $phpbb_root_path, $phpEx, $table_prefix; 1929 $timezone_migration = new \phpbb\db\migration\data\v310\timezone($config, $db, new \phpbb\db\tools($db), $phpbb_root_path, $phpEx, $table_prefix); 1930 return $timezone_migration->convert_phpbb30_timezone($timezone, 0); 1931 } 1932 1933 function phpbb_add_notification_options($user_notify_pm) 1934 { 1935 global $convert_row, $db; 1936 1937 $user_id = phpbb_user_id($convert_row['user_id']); 1938 if ($user_id == ANONYMOUS) 1939 { 1940 return; 1941 } 1942 1943 $rows = array(); 1944 1945 $rows[] = array( 1946 'item_type' => 'post', 1947 'item_id' => 0, 1948 'user_id' => (int) $user_id, 1949 'notify' => 1, 1950 'method' => 'email', 1951 ); 1952 $rows[] = array( 1953 'item_type' => 'topic', 1954 'item_id' => 0, 1955 'user_id' => (int) $user_id, 1956 'notify' => 1, 1957 'method' => 'email', 1958 ); 1959 if ($user_notify_pm) 1960 { 1961 $rows[] = array( 1962 'item_type' => 'pm', 1963 'item_id' => 0, 1964 'user_id' => (int) $user_id, 1965 'notify' => 1, 1966 'method' => 'email', 1967 ); 1968 } 1969 1970 $sql = $db->sql_multi_insert(USER_NOTIFICATIONS_TABLE, $rows); 1971 } 1972 1973 function phpbb_convert_password_hash($hash) 1974 { 1975 global $phpbb_container; 1976 1977 $manager = $phpbb_container->get('passwords.manager'); 1978 $hash = $manager->hash($hash, '$H$'); 1979 1980 return '$CP$' . $hash; 1981 }
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
| Generated: Thu Jan 11 00:25:41 2018 | Cross-referenced by PHPXref 0.7.1 |