| [ 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 /** 15 */ 16 if (!defined('IN_INSTALL')) 17 { 18 // Someone has tried to access the file direct. This is not a good idea, so exit 19 exit; 20 } 21 22 if (!empty($setmodules)) 23 { 24 // If phpBB is already installed we do not include this module 25 if (phpbb_check_installation_exists($phpbb_root_path, $phpEx) && !file_exists($phpbb_root_path . 'cache/install_lock')) 26 { 27 return; 28 } 29 30 $module[] = array( 31 'module_type' => 'install', 32 'module_title' => 'INSTALL', 33 'module_filename' => substr(basename(__FILE__), 0, -strlen($phpEx)-1), 34 'module_order' => 10, 35 'module_subs' => '', 36 'module_stages' => array('INTRO', 'REQUIREMENTS', 'DATABASE', 'ADMINISTRATOR', 'CONFIG_FILE', 'ADVANCED', 'CREATE_TABLE', 'FINAL'), 37 'module_reqs' => '' 38 ); 39 } 40 41 /** 42 * Installation 43 */ 44 class install_install extends module 45 { 46 function install_install(&$p_master) 47 { 48 $this->p_master = &$p_master; 49 } 50 51 function main($mode, $sub) 52 { 53 global $lang, $template, $language, $phpbb_root_path, $phpEx; 54 global $phpbb_container, $cache, $phpbb_log, $request, $phpbb_config_php_file; 55 56 switch ($sub) 57 { 58 case 'intro': 59 $phpbb_container->get('cache.driver')->purge(); 60 61 $this->page_title = $lang['SUB_INTRO']; 62 63 $template->assign_vars(array( 64 'TITLE' => $lang['INSTALL_INTRO'], 65 'BODY' => $lang['INSTALL_INTRO_BODY'], 66 'L_SUBMIT' => $lang['NEXT_STEP'], 67 'S_LANG_SELECT' => '<select id="language" name="language">' . $this->p_master->inst_language_select($language) . '</select>', 68 'U_ACTION' => $this->p_master->module_url . "?mode=$mode&sub=requirements&language=$language", 69 )); 70 71 break; 72 73 case 'requirements': 74 $this->check_server_requirements($mode, $sub); 75 76 break; 77 78 case 'database': 79 $this->obtain_database_settings($mode, $sub); 80 81 break; 82 83 case 'administrator': 84 $this->obtain_admin_settings($mode, $sub); 85 86 break; 87 88 case 'config_file': 89 $this->create_config_file($mode, $sub); 90 91 break; 92 93 case 'advanced': 94 $this->obtain_advanced_settings($mode, $sub); 95 96 break; 97 98 case 'create_table': 99 $this->load_schema($mode, $sub); 100 break; 101 102 case 'final': 103 // Enable super globals to prevent issues with the new \phpbb\request\request object 104 $request->enable_super_globals(); 105 106 // Create a normal container now 107 $phpbb_container_builder = new \phpbb\di\container_builder($phpbb_config_php_file, $phpbb_root_path, $phpEx); 108 $phpbb_container = $phpbb_container_builder->get_container(); 109 110 // Sets the global variables 111 $cache = $phpbb_container->get('cache'); 112 $phpbb_log = $phpbb_container->get('log'); 113 114 $this->build_search_index($mode, $sub); 115 $this->add_modules($mode, $sub); 116 $this->add_language($mode, $sub); 117 $this->add_bots($mode, $sub); 118 $this->email_admin($mode, $sub); 119 $this->disable_avatars_if_unwritable(); 120 $this->populate_migrations($phpbb_container->get('ext.manager'), $phpbb_container->get('migrator')); 121 122 // Remove the lock file 123 @unlink($phpbb_root_path . 'cache/install_lock'); 124 125 break; 126 } 127 128 $this->tpl_name = 'install_install'; 129 } 130 131 /** 132 * Checks that the server we are installing on meets the requirements for running phpBB 133 */ 134 function check_server_requirements($mode, $sub) 135 { 136 global $lang, $template, $phpbb_root_path, $phpEx, $language; 137 138 $this->page_title = $lang['STAGE_REQUIREMENTS']; 139 140 $template->assign_vars(array( 141 'TITLE' => $lang['REQUIREMENTS_TITLE'], 142 'BODY' => $lang['REQUIREMENTS_EXPLAIN'], 143 )); 144 145 $passed = array('php' => false, 'db' => false, 'files' => false, 'pcre' => false, 'imagesize' => false, 'json' => false,); 146 147 // Test for basic PHP settings 148 $template->assign_block_vars('checks', array( 149 'S_LEGEND' => true, 150 'LEGEND' => $lang['PHP_SETTINGS'], 151 'LEGEND_EXPLAIN' => $lang['PHP_SETTINGS_EXPLAIN'], 152 )); 153 154 // Test the minimum and maximum version of PHP 155 $php_version = PHP_VERSION; 156 157 if ((version_compare($php_version, '5.3.3') < 0) || (version_compare($php_version, '7.0.0-dev', '>='))) 158 { 159 $result = '<strong style="color:red">' . $lang['NO'] . '</strong>'; 160 } 161 else 162 { 163 $passed['php'] = true; 164 165 // We also give feedback on whether we're running in safe mode 166 $result = '<strong style="color:green">' . $lang['YES']; 167 if (@ini_get('safe_mode') == '1' || strtolower(@ini_get('safe_mode')) == 'on') 168 { 169 $result .= ', ' . $lang['PHP_SAFE_MODE']; 170 } 171 $result .= '</strong>'; 172 } 173 174 $template->assign_block_vars('checks', array( 175 'TITLE' => $lang['PHP_VERSION_REQD'], 176 'RESULT' => $result, 177 178 'S_EXPLAIN' => false, 179 'S_LEGEND' => false, 180 )); 181 182 // Don't check for register_globals on 5.4+ 183 if (version_compare($php_version, '5.4.0-dev') < 0) 184 { 185 // Check for register_globals being enabled 186 if (@ini_get('register_globals') == '1' || strtolower(@ini_get('register_globals')) == 'on') 187 { 188 $result = '<strong style="color:red">' . $lang['NO'] . '</strong>'; 189 } 190 else 191 { 192 $result = '<strong style="color:green">' . $lang['YES'] . '</strong>'; 193 } 194 195 $template->assign_block_vars('checks', array( 196 'TITLE' => $lang['PHP_REGISTER_GLOBALS'], 197 'TITLE_EXPLAIN' => $lang['PHP_REGISTER_GLOBALS_EXPLAIN'], 198 'RESULT' => $result, 199 200 'S_EXPLAIN' => true, 201 'S_LEGEND' => false, 202 )); 203 } 204 205 // Check for url_fopen 206 if (@ini_get('allow_url_fopen') == '1' || strtolower(@ini_get('allow_url_fopen')) == 'on') 207 { 208 $result = '<strong style="color:green">' . $lang['YES'] . '</strong>'; 209 } 210 else 211 { 212 $result = '<strong style="color:red">' . $lang['NO'] . '</strong>'; 213 } 214 215 $template->assign_block_vars('checks', array( 216 'TITLE' => $lang['PHP_URL_FOPEN_SUPPORT'], 217 'TITLE_EXPLAIN' => $lang['PHP_URL_FOPEN_SUPPORT_EXPLAIN'], 218 'RESULT' => $result, 219 220 'S_EXPLAIN' => true, 221 'S_LEGEND' => false, 222 )); 223 224 // Check for getimagesize 225 if (@function_exists('getimagesize')) 226 { 227 $passed['imagesize'] = true; 228 $result = '<strong style="color:green">' . $lang['YES'] . '</strong>'; 229 } 230 else 231 { 232 $result = '<strong style="color:red">' . $lang['NO'] . '</strong>'; 233 } 234 235 $template->assign_block_vars('checks', array( 236 'TITLE' => $lang['PHP_GETIMAGESIZE_SUPPORT'], 237 'TITLE_EXPLAIN' => $lang['PHP_GETIMAGESIZE_SUPPORT_EXPLAIN'], 238 'RESULT' => $result, 239 240 'S_EXPLAIN' => true, 241 'S_LEGEND' => false, 242 )); 243 244 // Check for PCRE UTF-8 support 245 if (@preg_match('//u', '')) 246 { 247 $passed['pcre'] = true; 248 $result = '<strong style="color:green">' . $lang['YES'] . '</strong>'; 249 } 250 else 251 { 252 $result = '<strong style="color:red">' . $lang['NO'] . '</strong>'; 253 } 254 255 $template->assign_block_vars('checks', array( 256 'TITLE' => $lang['PCRE_UTF_SUPPORT'], 257 'TITLE_EXPLAIN' => $lang['PCRE_UTF_SUPPORT_EXPLAIN'], 258 'RESULT' => $result, 259 260 'S_EXPLAIN' => true, 261 'S_LEGEND' => false, 262 )); 263 264 // Check for php json support 265 if (@extension_loaded('json')) 266 { 267 $passed['json'] = true; 268 $result = '<strong style="color:green">' . $lang['YES'] . '</strong>'; 269 } 270 else 271 { 272 $result = '<strong style="color:red">' . $lang['NO'] . '</strong>'; 273 } 274 275 $template->assign_block_vars('checks', array( 276 'TITLE' => $lang['PHP_JSON_SUPPORT'], 277 'TITLE_EXPLAIN' => $lang['PHP_JSON_SUPPORT_EXPLAIN'], 278 'RESULT' => $result, 279 280 'S_EXPLAIN' => true, 281 'S_LEGEND' => false, 282 )); 283 284 $passed['mbstring'] = true; 285 if (@extension_loaded('mbstring')) 286 { 287 // Test for available database modules 288 $template->assign_block_vars('checks', array( 289 'S_LEGEND' => true, 290 'LEGEND' => $lang['MBSTRING_CHECK'], 291 'LEGEND_EXPLAIN' => $lang['MBSTRING_CHECK_EXPLAIN'], 292 )); 293 294 $checks = array( 295 array('func_overload', '&', MB_OVERLOAD_MAIL|MB_OVERLOAD_STRING), 296 array('encoding_translation', '!=', 0), 297 array('http_input', '!=', array('pass', '')), 298 array('http_output', '!=', array('pass', '')) 299 ); 300 301 foreach ($checks as $mb_checks) 302 { 303 $ini_val = @ini_get('mbstring.' . $mb_checks[0]); 304 switch ($mb_checks[1]) 305 { 306 case '&': 307 if (intval($ini_val) & $mb_checks[2]) 308 { 309 $result = '<strong style="color:red">' . $lang['NO'] . '</strong>'; 310 $passed['mbstring'] = false; 311 } 312 else 313 { 314 $result = '<strong style="color:green">' . $lang['YES'] . '</strong>'; 315 } 316 break; 317 318 case '!=': 319 if (!is_array($mb_checks[2]) && $ini_val != $mb_checks[2] || 320 is_array($mb_checks[2]) && !in_array($ini_val, $mb_checks[2])) 321 { 322 $result = '<strong style="color:red">' . $lang['NO'] . '</strong>'; 323 $passed['mbstring'] = false; 324 } 325 else 326 { 327 $result = '<strong style="color:green">' . $lang['YES'] . '</strong>'; 328 } 329 break; 330 } 331 $template->assign_block_vars('checks', array( 332 'TITLE' => $lang['MBSTRING_' . strtoupper($mb_checks[0])], 333 'TITLE_EXPLAIN' => $lang['MBSTRING_' . strtoupper($mb_checks[0]) . '_EXPLAIN'], 334 'RESULT' => $result, 335 336 'S_EXPLAIN' => true, 337 'S_LEGEND' => false, 338 )); 339 } 340 } 341 342 // Test for available database modules 343 $template->assign_block_vars('checks', array( 344 'S_LEGEND' => true, 345 'LEGEND' => $lang['PHP_SUPPORTED_DB'], 346 'LEGEND_EXPLAIN' => $lang['PHP_SUPPORTED_DB_EXPLAIN'], 347 )); 348 349 $available_dbms = get_available_dbms(false, true); 350 $passed['db'] = $available_dbms['ANY_DB_SUPPORT']; 351 unset($available_dbms['ANY_DB_SUPPORT']); 352 353 foreach ($available_dbms as $db_name => $db_ary) 354 { 355 if (!$db_ary['AVAILABLE']) 356 { 357 $template->assign_block_vars('checks', array( 358 'TITLE' => $lang['DLL_' . strtoupper($db_name)], 359 'RESULT' => '<span style="color:red">' . $lang['UNAVAILABLE'] . '</span>', 360 361 'S_EXPLAIN' => false, 362 'S_LEGEND' => false, 363 )); 364 } 365 else 366 { 367 $template->assign_block_vars('checks', array( 368 'TITLE' => $lang['DLL_' . strtoupper($db_name)], 369 'RESULT' => '<strong style="color:green">' . $lang['AVAILABLE'] . '</strong>', 370 371 'S_EXPLAIN' => false, 372 'S_LEGEND' => false, 373 )); 374 } 375 } 376 377 // Test for other modules 378 $template->assign_block_vars('checks', array( 379 'S_LEGEND' => true, 380 'LEGEND' => $lang['PHP_OPTIONAL_MODULE'], 381 'LEGEND_EXPLAIN' => $lang['PHP_OPTIONAL_MODULE_EXPLAIN'], 382 )); 383 384 foreach ($this->php_dlls_other as $dll) 385 { 386 if (!@extension_loaded($dll)) 387 { 388 $template->assign_block_vars('checks', array( 389 'TITLE' => $lang['DLL_' . strtoupper($dll)], 390 'RESULT' => '<strong style="color:red">' . $lang['UNAVAILABLE'] . '</strong>', 391 392 'S_EXPLAIN' => false, 393 'S_LEGEND' => false, 394 )); 395 continue; 396 } 397 398 $template->assign_block_vars('checks', array( 399 'TITLE' => $lang['DLL_' . strtoupper($dll)], 400 'RESULT' => '<strong style="color:green">' . $lang['AVAILABLE'] . '</strong>', 401 402 'S_EXPLAIN' => false, 403 'S_LEGEND' => false, 404 )); 405 } 406 407 // Can we find ImageMagick anywhere on the system? 408 $exe = (DIRECTORY_SEPARATOR == '\\') ? '.exe' : ''; 409 410 $magic_home = getenv('MAGICK_HOME'); 411 $img_imagick = ''; 412 if (empty($magic_home)) 413 { 414 $locations = array('C:/WINDOWS/', 'C:/WINNT/', 'C:/WINDOWS/SYSTEM/', 'C:/WINNT/SYSTEM/', 'C:/WINDOWS/SYSTEM32/', 'C:/WINNT/SYSTEM32/', '/usr/bin/', '/usr/sbin/', '/usr/local/bin/', '/usr/local/sbin/', '/opt/', '/usr/imagemagick/', '/usr/bin/imagemagick/'); 415 $path_locations = str_replace('\\', '/', (explode(($exe) ? ';' : ':', getenv('PATH')))); 416 417 $locations = array_merge($path_locations, $locations); 418 foreach ($locations as $location) 419 { 420 // The path might not end properly, fudge it 421 if (substr($location, -1, 1) !== '/') 422 { 423 $location .= '/'; 424 } 425 426 if (@file_exists($location) && @is_readable($location . 'mogrify' . $exe) && @filesize($location . 'mogrify' . $exe) > 3000) 427 { 428 $img_imagick = str_replace('\\', '/', $location); 429 continue; 430 } 431 } 432 } 433 else 434 { 435 $img_imagick = str_replace('\\', '/', $magic_home); 436 } 437 438 $template->assign_block_vars('checks', array( 439 'TITLE' => $lang['APP_MAGICK'], 440 'RESULT' => ($img_imagick) ? '<strong style="color:green">' . $lang['AVAILABLE'] . ', ' . $img_imagick . '</strong>' : '<strong style="color:blue">' . $lang['NO_LOCATION'] . '</strong>', 441 442 'S_EXPLAIN' => false, 443 'S_LEGEND' => false, 444 )); 445 446 // Check permissions on files/directories we need access to 447 $template->assign_block_vars('checks', array( 448 'S_LEGEND' => true, 449 'LEGEND' => $lang['FILES_REQUIRED'], 450 'LEGEND_EXPLAIN' => $lang['FILES_REQUIRED_EXPLAIN'], 451 )); 452 453 $directories = array('cache/', 'files/', 'store/'); 454 455 umask(0); 456 457 $passed['files'] = true; 458 foreach ($directories as $dir) 459 { 460 $exists = $write = false; 461 462 // Try to create the directory if it does not exist 463 if (!file_exists($phpbb_root_path . $dir)) 464 { 465 @mkdir($phpbb_root_path . $dir, 0777); 466 phpbb_chmod($phpbb_root_path . $dir, CHMOD_READ | CHMOD_WRITE); 467 } 468 469 // Now really check 470 if (file_exists($phpbb_root_path . $dir) && is_dir($phpbb_root_path . $dir)) 471 { 472 phpbb_chmod($phpbb_root_path . $dir, CHMOD_READ | CHMOD_WRITE); 473 $exists = true; 474 } 475 476 // Now check if it is writable by storing a simple file 477 $fp = @fopen($phpbb_root_path . $dir . 'test_lock', 'wb'); 478 if ($fp !== false) 479 { 480 $write = true; 481 } 482 @fclose($fp); 483 484 @unlink($phpbb_root_path . $dir . 'test_lock'); 485 486 $passed['files'] = ($exists && $write && $passed['files']) ? true : false; 487 488 $exists = ($exists) ? '<strong style="color:green">' . $lang['FOUND'] . '</strong>' : '<strong style="color:red">' . $lang['NOT_FOUND'] . '</strong>'; 489 $write = ($write) ? ', <strong style="color:green">' . $lang['WRITABLE'] . '</strong>' : (($exists) ? ', <strong style="color:red">' . $lang['UNWRITABLE'] . '</strong>' : ''); 490 491 $template->assign_block_vars('checks', array( 492 'TITLE' => $dir, 493 'RESULT' => $exists . $write, 494 495 'S_EXPLAIN' => false, 496 'S_LEGEND' => false, 497 )); 498 } 499 500 // Check permissions on files/directories it would be useful access to 501 $template->assign_block_vars('checks', array( 502 'S_LEGEND' => true, 503 'LEGEND' => $lang['FILES_OPTIONAL'], 504 'LEGEND_EXPLAIN' => $lang['FILES_OPTIONAL_EXPLAIN'], 505 )); 506 507 $directories = array('config.' . $phpEx, 'images/avatars/upload/'); 508 509 foreach ($directories as $dir) 510 { 511 $write = $exists = true; 512 if (file_exists($phpbb_root_path . $dir)) 513 { 514 if (!phpbb_is_writable($phpbb_root_path . $dir)) 515 { 516 $write = false; 517 } 518 } 519 else 520 { 521 $write = $exists = false; 522 } 523 524 $exists_str = ($exists) ? '<strong style="color:green">' . $lang['FOUND'] . '</strong>' : '<strong style="color:red">' . $lang['NOT_FOUND'] . '</strong>'; 525 $write_str = ($write) ? ', <strong style="color:green">' . $lang['WRITABLE'] . '</strong>' : (($exists) ? ', <strong style="color:red">' . $lang['UNWRITABLE'] . '</strong>' : ''); 526 527 $template->assign_block_vars('checks', array( 528 'TITLE' => $dir, 529 'RESULT' => $exists_str . $write_str, 530 531 'S_EXPLAIN' => false, 532 'S_LEGEND' => false, 533 )); 534 } 535 536 // And finally where do we want to go next (well today is taken isn't it :P) 537 $s_hidden_fields = ($img_imagick) ? '<input type="hidden" name="img_imagick" value="' . addslashes($img_imagick) . '" />' : ''; 538 539 $url = (!in_array(false, $passed)) ? $this->p_master->module_url . "?mode=$mode&sub=database&language=$language" : $this->p_master->module_url . "?mode=$mode&sub=requirements&language=$language "; 540 $submit = (!in_array(false, $passed)) ? $lang['INSTALL_START'] : $lang['INSTALL_TEST']; 541 542 $template->assign_vars(array( 543 'L_SUBMIT' => $submit, 544 'S_HIDDEN' => $s_hidden_fields, 545 'U_ACTION' => $url, 546 )); 547 } 548 549 /** 550 * Obtain the information required to connect to the database 551 */ 552 function obtain_database_settings($mode, $sub) 553 { 554 global $lang, $template, $phpEx; 555 556 $this->page_title = $lang['STAGE_DATABASE']; 557 558 // Obtain any submitted data 559 $data = $this->get_submitted_data(); 560 561 $connect_test = false; 562 $error = array(); 563 $available_dbms = get_available_dbms(false, true); 564 565 // Has the user opted to test the connection? 566 if (isset($_POST['testdb'])) 567 { 568 if (!isset($available_dbms[$data['dbms']]) || !$available_dbms[$data['dbms']]['AVAILABLE']) 569 { 570 $error[] = $lang['INST_ERR_NO_DB']; 571 $connect_test = false; 572 } 573 else if (!preg_match(get_preg_expression('table_prefix'), $data['table_prefix'])) 574 { 575 $error[] = $lang['INST_ERR_DB_INVALID_PREFIX']; 576 $connect_test = false; 577 } 578 else 579 { 580 $connect_test = connect_check_db(true, $error, $available_dbms[$data['dbms']], $data['table_prefix'], $data['dbhost'], $data['dbuser'], htmlspecialchars_decode($data['dbpasswd']), $data['dbname'], $data['dbport']); 581 } 582 583 $template->assign_block_vars('checks', array( 584 'S_LEGEND' => true, 585 'LEGEND' => $lang['DB_CONNECTION'], 586 'LEGEND_EXPLAIN' => false, 587 )); 588 589 if ($connect_test) 590 { 591 $template->assign_block_vars('checks', array( 592 'TITLE' => $lang['DB_TEST'], 593 'RESULT' => '<strong style="color:green">' . $lang['SUCCESSFUL_CONNECT'] . '</strong>', 594 595 'S_EXPLAIN' => false, 596 'S_LEGEND' => false, 597 )); 598 } 599 else 600 { 601 $template->assign_block_vars('checks', array( 602 'TITLE' => $lang['DB_TEST'], 603 'RESULT' => '<strong style="color:red">' . implode('<br />', $error) . '</strong>', 604 605 'S_EXPLAIN' => false, 606 'S_LEGEND' => false, 607 )); 608 } 609 } 610 611 if (!$connect_test) 612 { 613 // Update the list of available DBMS modules to only contain those which can be used 614 $available_dbms_temp = array(); 615 foreach ($available_dbms as $type => $dbms_ary) 616 { 617 if (!$dbms_ary['AVAILABLE']) 618 { 619 continue; 620 } 621 622 $available_dbms_temp[$type] = $dbms_ary; 623 } 624 625 $available_dbms = &$available_dbms_temp; 626 627 // And now for the main part of this page 628 $data['table_prefix'] = (!empty($data['table_prefix']) ? $data['table_prefix'] : 'phpbb_'); 629 630 foreach ($this->db_config_options as $config_key => $vars) 631 { 632 if (!is_array($vars) && strpos($config_key, 'legend') === false) 633 { 634 continue; 635 } 636 637 if (strpos($config_key, 'legend') !== false) 638 { 639 $template->assign_block_vars('options', array( 640 'S_LEGEND' => true, 641 'LEGEND' => $lang[$vars]) 642 ); 643 644 continue; 645 } 646 647 $options = isset($vars['options']) ? $vars['options'] : ''; 648 649 $template->assign_block_vars('options', array( 650 'KEY' => $config_key, 651 'TITLE' => $lang[$vars['lang']], 652 'S_EXPLAIN' => $vars['explain'], 653 'S_LEGEND' => false, 654 'TITLE_EXPLAIN' => ($vars['explain']) ? $lang[$vars['lang'] . '_EXPLAIN'] : '', 655 'CONTENT' => $this->p_master->input_field($config_key, $vars['type'], $data[$config_key], $options), 656 ) 657 ); 658 } 659 } 660 661 // And finally where do we want to go next (well today is taken isn't it :P) 662 $s_hidden_fields = ($data['img_imagick']) ? '<input type="hidden" name="img_imagick" value="' . addslashes($data['img_imagick']) . '" />' : ''; 663 $s_hidden_fields .= '<input type="hidden" name="language" value="' . $data['language'] . '" />'; 664 if ($connect_test) 665 { 666 foreach ($this->db_config_options as $config_key => $vars) 667 { 668 if (!is_array($vars)) 669 { 670 continue; 671 } 672 $s_hidden_fields .= '<input type="hidden" name="' . $config_key . '" value="' . $data[$config_key] . '" />'; 673 } 674 } 675 676 $url = ($connect_test) ? $this->p_master->module_url . "?mode=$mode&sub=administrator" : $this->p_master->module_url . "?mode=$mode&sub=database"; 677 $s_hidden_fields .= ($connect_test) ? '' : '<input type="hidden" name="testdb" value="true" />'; 678 679 $submit = $lang['NEXT_STEP']; 680 681 $template->assign_vars(array( 682 'L_SUBMIT' => $submit, 683 'S_HIDDEN' => $s_hidden_fields, 684 'U_ACTION' => $url, 685 )); 686 } 687 688 /** 689 * Obtain the administrator's name, password and email address 690 */ 691 function obtain_admin_settings($mode, $sub) 692 { 693 global $lang, $template, $phpEx; 694 695 $this->page_title = $lang['STAGE_ADMINISTRATOR']; 696 697 // Obtain any submitted data 698 $data = $this->get_submitted_data(); 699 700 if ($data['dbms'] == '') 701 { 702 // Someone's been silly and tried calling this page direct 703 // So we send them back to the start to do it again properly 704 $this->p_master->redirect("index.$phpEx?mode=install"); 705 } 706 707 $s_hidden_fields = ($data['img_imagick']) ? '<input type="hidden" name="img_imagick" value="' . addslashes($data['img_imagick']) . '" />' : ''; 708 $passed = false; 709 710 $data['default_lang'] = ($data['default_lang'] !== '') ? $data['default_lang'] : $data['language']; 711 712 if (isset($_POST['check'])) 713 { 714 $error = array(); 715 716 // Check the entered email address and password 717 if ($data['admin_name'] == '' || $data['admin_pass1'] == '' || $data['admin_pass2'] == '' || $data['board_email'] == '') 718 { 719 $error[] = $lang['INST_ERR_MISSING_DATA']; 720 } 721 722 if ($data['admin_pass1'] != $data['admin_pass2'] && $data['admin_pass1'] != '') 723 { 724 $error[] = $lang['INST_ERR_PASSWORD_MISMATCH']; 725 } 726 727 // Test against the default username rules 728 if ($data['admin_name'] != '' && utf8_strlen($data['admin_name']) < 3) 729 { 730 $error[] = $lang['INST_ERR_USER_TOO_SHORT']; 731 } 732 733 if ($data['admin_name'] != '' && utf8_strlen($data['admin_name']) > 20) 734 { 735 $error[] = $lang['INST_ERR_USER_TOO_LONG']; 736 } 737 738 // Test against the default password rules 739 if ($data['admin_pass1'] != '' && utf8_strlen($data['admin_pass1']) < 6) 740 { 741 $error[] = $lang['INST_ERR_PASSWORD_TOO_SHORT']; 742 } 743 744 if ($data['admin_pass1'] != '' && utf8_strlen($data['admin_pass1']) > 30) 745 { 746 $error[] = $lang['INST_ERR_PASSWORD_TOO_LONG']; 747 } 748 749 if ($data['board_email'] != '' && !preg_match('/^' . get_preg_expression('email') . '$/i', $data['board_email'])) 750 { 751 $error[] = $lang['INST_ERR_EMAIL_INVALID']; 752 } 753 754 $template->assign_block_vars('checks', array( 755 'S_LEGEND' => true, 756 'LEGEND' => $lang['STAGE_ADMINISTRATOR'], 757 'LEGEND_EXPLAIN' => false, 758 )); 759 760 if (!sizeof($error)) 761 { 762 $passed = true; 763 $template->assign_block_vars('checks', array( 764 'TITLE' => $lang['ADMIN_TEST'], 765 'RESULT' => '<strong style="color:green">' . $lang['TESTS_PASSED'] . '</strong>', 766 767 'S_EXPLAIN' => false, 768 'S_LEGEND' => false, 769 )); 770 } 771 else 772 { 773 $template->assign_block_vars('checks', array( 774 'TITLE' => $lang['ADMIN_TEST'], 775 'RESULT' => '<strong style="color:red">' . implode('<br />', $error) . '</strong>', 776 777 'S_EXPLAIN' => false, 778 'S_LEGEND' => false, 779 )); 780 } 781 } 782 783 if (!$passed) 784 { 785 foreach ($this->admin_config_options as $config_key => $vars) 786 { 787 if (!is_array($vars) && strpos($config_key, 'legend') === false) 788 { 789 continue; 790 } 791 792 if (strpos($config_key, 'legend') !== false) 793 { 794 $template->assign_block_vars('options', array( 795 'S_LEGEND' => true, 796 'LEGEND' => $lang[$vars]) 797 ); 798 799 continue; 800 } 801 802 $options = isset($vars['options']) ? $vars['options'] : ''; 803 804 $template->assign_block_vars('options', array( 805 'KEY' => $config_key, 806 'TITLE' => $lang[$vars['lang']], 807 'S_EXPLAIN' => $vars['explain'], 808 'S_LEGEND' => false, 809 'TITLE_EXPLAIN' => ($vars['explain']) ? $lang[$vars['lang'] . '_EXPLAIN'] : '', 810 'CONTENT' => $this->p_master->input_field($config_key, $vars['type'], $data[$config_key], $options), 811 ) 812 ); 813 } 814 } 815 else 816 { 817 foreach ($this->admin_config_options as $config_key => $vars) 818 { 819 if (!is_array($vars)) 820 { 821 continue; 822 } 823 $s_hidden_fields .= '<input type="hidden" name="' . $config_key . '" value="' . $data[$config_key] . '" />'; 824 } 825 } 826 827 $s_hidden_fields .= ($data['img_imagick']) ? '<input type="hidden" name="img_imagick" value="' . addslashes($data['img_imagick']) . '" />' : ''; 828 $s_hidden_fields .= '<input type="hidden" name="language" value="' . $data['language'] . '" />'; 829 830 foreach ($this->db_config_options as $config_key => $vars) 831 { 832 if (!is_array($vars)) 833 { 834 continue; 835 } 836 $s_hidden_fields .= '<input type="hidden" name="' . $config_key . '" value="' . $data[$config_key] . '" />'; 837 } 838 839 $submit = $lang['NEXT_STEP']; 840 841 $url = ($passed) ? $this->p_master->module_url . "?mode=$mode&sub=config_file" : $this->p_master->module_url . "?mode=$mode&sub=administrator"; 842 $s_hidden_fields .= ($passed) ? '' : '<input type="hidden" name="check" value="true" />'; 843 844 $template->assign_vars(array( 845 'L_SUBMIT' => $submit, 846 'S_HIDDEN' => $s_hidden_fields, 847 'U_ACTION' => $url, 848 )); 849 } 850 851 /** 852 * Writes the config file to disk, or if unable to do so offers alternative methods 853 */ 854 function create_config_file($mode, $sub) 855 { 856 global $lang, $template, $phpbb_root_path, $phpEx; 857 858 $this->page_title = $lang['STAGE_CONFIG_FILE']; 859 860 // Obtain any submitted data 861 $data = $this->get_submitted_data(); 862 863 if ($data['dbms'] == '') 864 { 865 // Someone's been silly and tried calling this page direct 866 // So we send them back to the start to do it again properly 867 $this->p_master->redirect("index.$phpEx?mode=install"); 868 } 869 870 $s_hidden_fields = ($data['img_imagick']) ? '<input type="hidden" name="img_imagick" value="' . addslashes($data['img_imagick']) . '" />' : ''; 871 $s_hidden_fields .= '<input type="hidden" name="language" value="' . $data['language'] . '" />'; 872 $written = false; 873 874 // Create a list of any PHP modules we wish to have loaded 875 $available_dbms = get_available_dbms($data['dbms']); 876 877 // Create a lock file to indicate that there is an install in progress 878 $fp = @fopen($phpbb_root_path . 'cache/install_lock', 'wb'); 879 if ($fp === false) 880 { 881 // We were unable to create the lock file - abort 882 $this->p_master->error($lang['UNABLE_WRITE_LOCK'], __LINE__, __FILE__); 883 } 884 @fclose($fp); 885 886 @chmod($phpbb_root_path . 'cache/install_lock', 0777); 887 888 // Time to convert the data provided into a config file 889 $config_data = phpbb_create_config_file_data($data, $available_dbms[$data['dbms']]['DRIVER']); 890 891 // Attempt to write out the config file directly. If it works, this is the easiest way to do it ... 892 if ((file_exists($phpbb_root_path . 'config.' . $phpEx) && phpbb_is_writable($phpbb_root_path . 'config.' . $phpEx)) || phpbb_is_writable($phpbb_root_path)) 893 { 894 // Assume it will work ... if nothing goes wrong below 895 $written = true; 896 897 if (!($fp = @fopen($phpbb_root_path . 'config.' . $phpEx, 'w'))) 898 { 899 // Something went wrong ... so let's try another method 900 $written = false; 901 } 902 903 if (!(@fwrite($fp, $config_data))) 904 { 905 // Something went wrong ... so let's try another method 906 $written = false; 907 } 908 909 @fclose($fp); 910 911 if ($written) 912 { 913 // We may revert back to chmod() if we see problems with users not able to change their config.php file directly 914 phpbb_chmod($phpbb_root_path . 'config.' . $phpEx, CHMOD_READ); 915 } 916 } 917 918 if (isset($_POST['dldone'])) 919 { 920 // Do a basic check to make sure that the file has been uploaded 921 // Note that all we check is that the file has _something_ in it 922 // We don't compare the contents exactly - if they can't upload 923 // a single file correctly, it's likely they will have other problems.... 924 if (filesize($phpbb_root_path . 'config.' . $phpEx) > 10) 925 { 926 $written = true; 927 } 928 } 929 930 $config_options = array_merge($this->db_config_options, $this->admin_config_options); 931 932 foreach ($config_options as $config_key => $vars) 933 { 934 if (!is_array($vars)) 935 { 936 continue; 937 } 938 $s_hidden_fields .= '<input type="hidden" name="' . $config_key . '" value="' . $data[$config_key] . '" />'; 939 } 940 941 if (!$written) 942 { 943 // OK, so it didn't work let's try the alternatives 944 945 if (isset($_POST['dlconfig'])) 946 { 947 // They want a copy of the file to download, so send the relevant headers and dump out the data 948 header("Content-Type: text/x-delimtext; name=\"config.$phpEx\""); 949 header("Content-disposition: attachment; filename=config.$phpEx"); 950 echo $config_data; 951 exit; 952 } 953 954 // The option to download the config file is always available, so output it here 955 $template->assign_vars(array( 956 'BODY' => $lang['CONFIG_FILE_UNABLE_WRITE'], 957 'L_DL_CONFIG' => $lang['DL_CONFIG'], 958 'L_DL_CONFIG_EXPLAIN' => $lang['DL_CONFIG_EXPLAIN'], 959 'L_DL_DONE' => $lang['DONE'], 960 'L_DL_DOWNLOAD' => $lang['DL_DOWNLOAD'], 961 'S_HIDDEN' => $s_hidden_fields, 962 'S_SHOW_DOWNLOAD' => true, 963 'U_ACTION' => $this->p_master->module_url . "?mode=$mode&sub=config_file", 964 )); 965 return; 966 } 967 else 968 { 969 $template->assign_vars(array( 970 'BODY' => $lang['CONFIG_FILE_WRITTEN'], 971 'L_SUBMIT' => $lang['NEXT_STEP'], 972 'S_HIDDEN' => $s_hidden_fields, 973 'U_ACTION' => $this->p_master->module_url . "?mode=$mode&sub=advanced", 974 )); 975 return; 976 } 977 } 978 979 /** 980 * Provide an opportunity to customise some advanced settings during the install 981 * in case it is necessary for them to be set to access later 982 */ 983 function obtain_advanced_settings($mode, $sub) 984 { 985 global $lang, $template, $phpEx, $request; 986 987 $this->page_title = $lang['STAGE_ADVANCED']; 988 989 // Obtain any submitted data 990 $data = $this->get_submitted_data(); 991 992 if ($data['dbms'] == '') 993 { 994 // Someone's been silly and tried calling this page direct 995 // So we send them back to the start to do it again properly 996 $this->p_master->redirect("index.$phpEx?mode=install"); 997 } 998 999 $s_hidden_fields = ($data['img_imagick']) ? '<input type="hidden" name="img_imagick" value="' . addslashes($data['img_imagick']) . '" />' : ''; 1000 $s_hidden_fields .= '<input type="hidden" name="language" value="' . $data['language'] . '" />'; 1001 1002 // HTTP_HOST is having the correct browser url in most cases... 1003 $server_name = strtolower(htmlspecialchars_decode($request->header('Host', $request->server('SERVER_NAME')))); 1004 1005 // HTTP HOST can carry a port number... 1006 if (strpos($server_name, ':') !== false) 1007 { 1008 $server_name = substr($server_name, 0, strpos($server_name, ':')); 1009 } 1010 1011 $data['email_enable'] = ($data['email_enable'] !== '') ? $data['email_enable'] : true; 1012 $data['server_name'] = ($data['server_name'] !== '') ? $data['server_name'] : $server_name; 1013 $data['server_port'] = ($data['server_port'] !== '') ? $data['server_port'] : $request->server('SERVER_PORT', 0); 1014 $data['server_protocol'] = ($data['server_protocol'] !== '') ? $data['server_protocol'] : ($request->is_secure() ? 'https://' : 'http://'); 1015 $data['cookie_secure'] = ($data['cookie_secure'] !== '') ? $data['cookie_secure'] : $request->is_secure(); 1016 1017 if ($data['script_path'] === '') 1018 { 1019 $name = htmlspecialchars_decode($request->server('PHP_SELF')); 1020 if (!$name) 1021 { 1022 $name = htmlspecialchars_decode($request->server('REQUEST_URI')); 1023 } 1024 1025 // Replace backslashes and doubled slashes (could happen on some proxy setups) 1026 $name = str_replace(array('\\', '//'), '/', $name); 1027 $data['script_path'] = trim(dirname(dirname($name))); 1028 } 1029 1030 foreach ($this->advanced_config_options as $config_key => $vars) 1031 { 1032 if (!is_array($vars) && strpos($config_key, 'legend') === false) 1033 { 1034 continue; 1035 } 1036 1037 if (strpos($config_key, 'legend') !== false) 1038 { 1039 $template->assign_block_vars('options', array( 1040 'S_LEGEND' => true, 1041 'LEGEND' => $lang[$vars]) 1042 ); 1043 1044 continue; 1045 } 1046 1047 $options = isset($vars['options']) ? $vars['options'] : ''; 1048 1049 $template->assign_block_vars('options', array( 1050 'KEY' => $config_key, 1051 'TITLE' => $lang[$vars['lang']], 1052 'S_EXPLAIN' => $vars['explain'], 1053 'S_LEGEND' => false, 1054 'TITLE_EXPLAIN' => ($vars['explain']) ? $lang[$vars['lang'] . '_EXPLAIN'] : '', 1055 'CONTENT' => $this->p_master->input_field($config_key, $vars['type'], $data[$config_key], $options), 1056 ) 1057 ); 1058 } 1059 1060 $config_options = array_merge($this->db_config_options, $this->admin_config_options); 1061 foreach ($config_options as $config_key => $vars) 1062 { 1063 if (!is_array($vars)) 1064 { 1065 continue; 1066 } 1067 $s_hidden_fields .= '<input type="hidden" name="' . $config_key . '" value="' . $data[$config_key] . '" />'; 1068 } 1069 1070 $submit = $lang['NEXT_STEP']; 1071 1072 $url = $this->p_master->module_url . "?mode=$mode&sub=create_table"; 1073 1074 $template->assign_vars(array( 1075 'BODY' => $lang['STAGE_ADVANCED_EXPLAIN'], 1076 'L_SUBMIT' => $submit, 1077 'S_HIDDEN' => $s_hidden_fields, 1078 'U_ACTION' => $url, 1079 )); 1080 } 1081 1082 /** 1083 * Load the contents of the schema into the database and then alter it based on what has been input during the installation 1084 */ 1085 function load_schema($mode, $sub) 1086 { 1087 global $db, $lang, $template, $phpbb_root_path, $phpEx, $request; 1088 1089 $this->page_title = $lang['STAGE_CREATE_TABLE']; 1090 $s_hidden_fields = ''; 1091 1092 // Obtain any submitted data 1093 $data = $this->get_submitted_data(); 1094 1095 if ($data['dbms'] == '') 1096 { 1097 // Someone's been silly and tried calling this page direct 1098 // So we send them back to the start to do it again properly 1099 $this->p_master->redirect("index.$phpEx?mode=install"); 1100 } 1101 1102 // HTTP_HOST is having the correct browser url in most cases... 1103 $server_name = strtolower(htmlspecialchars_decode($request->header('Host', $request->server('SERVER_NAME')))); 1104 $referer = strtolower($request->header('Referer')); 1105 1106 // HTTP HOST can carry a port number... 1107 if (strpos($server_name, ':') !== false) 1108 { 1109 $server_name = substr($server_name, 0, strpos($server_name, ':')); 1110 } 1111 1112 $cookie_domain = ($data['server_name'] != '') ? $data['server_name'] : $server_name; 1113 1114 // Try to come up with the best solution for cookie domain... 1115 if (strpos($cookie_domain, 'www.') === 0) 1116 { 1117 $cookie_domain = str_replace('www.', '.', $cookie_domain); 1118 } 1119 1120 // If we get here and the extension isn't loaded it should be safe to just go ahead and load it 1121 $available_dbms = get_available_dbms($data['dbms']); 1122 1123 if (!isset($available_dbms[$data['dbms']])) 1124 { 1125 // Someone's been silly and tried providing a non-existant dbms 1126 $this->p_master->redirect("index.$phpEx?mode=install"); 1127 } 1128 1129 $dbms = $available_dbms[$data['dbms']]['DRIVER']; 1130 1131 // Instantiate the database 1132 $db = new $dbms(); 1133 $db->sql_connect($data['dbhost'], $data['dbuser'], htmlspecialchars_decode($data['dbpasswd']), $data['dbname'], $data['dbport'], false, false); 1134 1135 // NOTE: trigger_error does not work here. 1136 $db->sql_return_on_error(true); 1137 1138 // If mysql is chosen, we need to adjust the schema filename slightly to reflect the correct version. ;) 1139 if ($data['dbms'] == 'mysql') 1140 { 1141 if (version_compare($db->sql_server_info(true), '4.1.3', '>=')) 1142 { 1143 $available_dbms[$data['dbms']]['SCHEMA'] .= '_41'; 1144 } 1145 else 1146 { 1147 $available_dbms[$data['dbms']]['SCHEMA'] .= '_40'; 1148 } 1149 } 1150 1151 // Ok we have the db info go ahead and read in the relevant schema 1152 // and work on building the table 1153 $dbms_schema = 'schemas/' . $available_dbms[$data['dbms']]['SCHEMA'] . '_schema.sql'; 1154 1155 // How should we treat this schema? 1156 $delimiter = $available_dbms[$data['dbms']]['DELIM']; 1157 1158 if (file_exists($dbms_schema)) 1159 { 1160 $sql_query = @file_get_contents($dbms_schema); 1161 $sql_query = preg_replace('#phpbb_#i', $data['table_prefix'], $sql_query); 1162 $sql_query = phpbb_remove_comments($sql_query); 1163 $sql_query = split_sql_file($sql_query, $delimiter); 1164 1165 foreach ($sql_query as $sql) 1166 { 1167 // Ignore errors when the functions or types already exist 1168 // to allow installing phpBB twice in the same database with 1169 // a different prefix 1170 $db->sql_query($sql); 1171 } 1172 unset($sql_query); 1173 } 1174 1175 // Ok we have the db info go ahead and work on building the table 1176 if (file_exists('schemas/schema.json')) 1177 { 1178 $db_table_schema = @file_get_contents('schemas/schema.json'); 1179 $db_table_schema = json_decode($db_table_schema, true); 1180 } 1181 else 1182 { 1183 global $phpbb_root_path, $phpEx, $table_prefix; 1184 $table_prefix = 'phpbb_'; 1185 1186 if (!defined('CONFIG_TABLE')) 1187 { 1188 // We need to include the constants file for the table constants 1189 // when we generate the schema from the migration files. 1190 include($phpbb_root_path . 'includes/constants.' . $phpEx); 1191 } 1192 1193 $finder = new \phpbb\finder(new \phpbb\filesystem(), $phpbb_root_path, null, $phpEx); 1194 $classes = $finder->core_path('phpbb/db/migration/data/') 1195 ->get_classes(); 1196 1197 $sqlite_db = new \phpbb\db\driver\sqlite(); 1198 $schema_generator = new \phpbb\db\migration\schema_generator($classes, new \phpbb\config\config(array()), $sqlite_db, new \phpbb\db\tools($sqlite_db, true), $phpbb_root_path, $phpEx, $table_prefix); 1199 $db_table_schema = $schema_generator->get_schema(); 1200 } 1201 1202 if (!defined('CONFIG_TABLE')) 1203 { 1204 // CONFIG_TABLE is required by sql_create_index() to check the 1205 // length of index names. However table_prefix is not defined 1206 // here yet, so we need to create the constant ourselves. 1207 define('CONFIG_TABLE', $data['table_prefix'] . 'config'); 1208 } 1209 1210 $db_tools = new \phpbb\db\tools($db); 1211 foreach ($db_table_schema as $table_name => $table_data) 1212 { 1213 $db_tools->sql_create_table( 1214 $data['table_prefix'] . substr($table_name, 6), 1215 $table_data 1216 ); 1217 } 1218 1219 // Ok tables have been built, let's fill in the basic information 1220 $sql_query = file_get_contents('schemas/schema_data.sql'); 1221 1222 // Deal with any special comments and characters 1223 switch ($data['dbms']) 1224 { 1225 case 'mssql': 1226 case 'mssql_odbc': 1227 case 'mssqlnative': 1228 $sql_query = preg_replace('#\# MSSQL IDENTITY (phpbb_[a-z_]+) (ON|OFF) \##s', 'SET IDENTITY_INSERT \1 \2;', $sql_query); 1229 break; 1230 1231 case 'postgres': 1232 $sql_query = preg_replace('#\# POSTGRES (BEGIN|COMMIT) \##s', '\1; ', $sql_query); 1233 break; 1234 1235 case 'mysql': 1236 case 'mysqli': 1237 $sql_query = str_replace('\\', '\\\\', $sql_query); 1238 break; 1239 } 1240 1241 // Change prefix 1242 $sql_query = preg_replace('# phpbb_([^\s]*) #i', ' ' . $data['table_prefix'] . '\1 ', $sql_query); 1243 1244 // Change language strings... 1245 $sql_query = preg_replace_callback('#\{L_([A-Z0-9\-_]*)\}#s', 'adjust_language_keys_callback', $sql_query); 1246 1247 $sql_query = phpbb_remove_comments($sql_query); 1248 $sql_query = split_sql_file($sql_query, ';'); 1249 1250 foreach ($sql_query as $sql) 1251 { 1252 //$sql = trim(str_replace('|', ';', $sql)); 1253 if (!$db->sql_query($sql)) 1254 { 1255 $error = $db->sql_error(); 1256 $this->p_master->db_error($error['message'], $sql, __LINE__, __FILE__); 1257 } 1258 } 1259 unset($sql_query); 1260 1261 $current_time = time(); 1262 1263 $user_ip = $request->server('REMOTE_ADDR') ? phpbb_ip_normalise($request->server('REMOTE_ADDR')) : ''; 1264 1265 if ($data['script_path'] !== '/') 1266 { 1267 // Adjust destination path (no trailing slash) 1268 if (substr($data['script_path'], -1) == '/') 1269 { 1270 $data['script_path'] = substr($data['script_path'], 0, -1); 1271 } 1272 1273 $data['script_path'] = str_replace(array('../', './'), '', $data['script_path']); 1274 1275 if ($data['script_path'][0] != '/') 1276 { 1277 $data['script_path'] = '/' . $data['script_path']; 1278 } 1279 } 1280 1281 // Set default config and post data, this applies to all DB's 1282 $sql_ary = array( 1283 'INSERT INTO ' . $data['table_prefix'] . "config (config_name, config_value) 1284 VALUES ('board_startdate', '$current_time')", 1285 1286 'INSERT INTO ' . $data['table_prefix'] . "config (config_name, config_value) 1287 VALUES ('default_lang', '" . $db->sql_escape($data['default_lang']) . "')", 1288 1289 'UPDATE ' . $data['table_prefix'] . "config 1290 SET config_value = '" . $db->sql_escape($data['img_imagick']) . "' 1291 WHERE config_name = 'img_imagick'", 1292 1293 'UPDATE ' . $data['table_prefix'] . "config 1294 SET config_value = '" . $db->sql_escape($data['server_name']) . "' 1295 WHERE config_name = 'server_name'", 1296 1297 'UPDATE ' . $data['table_prefix'] . "config 1298 SET config_value = '" . $db->sql_escape($data['server_port']) . "' 1299 WHERE config_name = 'server_port'", 1300 1301 'UPDATE ' . $data['table_prefix'] . "config 1302 SET config_value = '" . $db->sql_escape($data['board_email']) . "' 1303 WHERE config_name = 'board_email'", 1304 1305 'UPDATE ' . $data['table_prefix'] . "config 1306 SET config_value = '" . $db->sql_escape($data['board_email']) . "' 1307 WHERE config_name = 'board_contact'", 1308 1309 'UPDATE ' . $data['table_prefix'] . "config 1310 SET config_value = '" . $db->sql_escape($cookie_domain) . "' 1311 WHERE config_name = 'cookie_domain'", 1312 1313 'UPDATE ' . $data['table_prefix'] . "config 1314 SET config_value = '" . $db->sql_escape($lang['default_dateformat']) . "' 1315 WHERE config_name = 'default_dateformat'", 1316 1317 'UPDATE ' . $data['table_prefix'] . "config 1318 SET config_value = '" . $db->sql_escape($data['email_enable']) . "' 1319 WHERE config_name = 'email_enable'", 1320 1321 'UPDATE ' . $data['table_prefix'] . "config 1322 SET config_value = '" . $db->sql_escape($data['smtp_delivery']) . "' 1323 WHERE config_name = 'smtp_delivery'", 1324 1325 'UPDATE ' . $data['table_prefix'] . "config 1326 SET config_value = '" . $db->sql_escape($data['smtp_host']) . "' 1327 WHERE config_name = 'smtp_host'", 1328 1329 'UPDATE ' . $data['table_prefix'] . "config 1330 SET config_value = '" . $db->sql_escape($data['smtp_auth']) . "' 1331 WHERE config_name = 'smtp_auth_method'", 1332 1333 'UPDATE ' . $data['table_prefix'] . "config 1334 SET config_value = '" . $db->sql_escape($data['smtp_user']) . "' 1335 WHERE config_name = 'smtp_username'", 1336 1337 'UPDATE ' . $data['table_prefix'] . "config 1338 SET config_value = '" . $db->sql_escape($data['smtp_pass']) . "' 1339 WHERE config_name = 'smtp_password'", 1340 1341 'UPDATE ' . $data['table_prefix'] . "config 1342 SET config_value = '" . $db->sql_escape($data['cookie_secure']) . "' 1343 WHERE config_name = 'cookie_secure'", 1344 1345 'UPDATE ' . $data['table_prefix'] . "config 1346 SET config_value = '" . $db->sql_escape($data['force_server_vars']) . "' 1347 WHERE config_name = 'force_server_vars'", 1348 1349 'UPDATE ' . $data['table_prefix'] . "config 1350 SET config_value = '" . $db->sql_escape($data['script_path']) . "' 1351 WHERE config_name = 'script_path'", 1352 1353 'UPDATE ' . $data['table_prefix'] . "config 1354 SET config_value = '" . $db->sql_escape($data['server_protocol']) . "' 1355 WHERE config_name = 'server_protocol'", 1356 1357 'UPDATE ' . $data['table_prefix'] . "config 1358 SET config_value = '" . $db->sql_escape($data['admin_name']) . "' 1359 WHERE config_name = 'newest_username'", 1360 1361 'UPDATE ' . $data['table_prefix'] . "config 1362 SET config_value = '" . md5(mt_rand()) . "' 1363 WHERE config_name = 'avatar_salt'", 1364 1365 'UPDATE ' . $data['table_prefix'] . "config 1366 SET config_value = '" . md5(mt_rand()) . "' 1367 WHERE config_name = 'plupload_salt'", 1368 1369 'UPDATE ' . $data['table_prefix'] . "users 1370 SET username = '" . $db->sql_escape($data['admin_name']) . "', user_password='" . $db->sql_escape(md5($data['admin_pass1'])) . "', user_ip = '" . $db->sql_escape($user_ip) . "', user_lang = '" . $db->sql_escape($data['default_lang']) . "', user_email='" . $db->sql_escape($data['board_email']) . "', user_dateformat='" . $db->sql_escape($lang['default_dateformat']) . "', user_email_hash = " . $db->sql_escape(phpbb_email_hash($data['board_email'])) . ", username_clean = '" . $db->sql_escape(utf8_clean_string($data['admin_name'])) . "' 1371 WHERE username = 'Admin'", 1372 1373 'UPDATE ' . $data['table_prefix'] . "moderator_cache 1374 SET username = '" . $db->sql_escape($data['admin_name']) . "' 1375 WHERE username = 'Admin'", 1376 1377 'UPDATE ' . $data['table_prefix'] . "forums 1378 SET forum_last_poster_name = '" . $db->sql_escape($data['admin_name']) . "' 1379 WHERE forum_last_poster_name = 'Admin'", 1380 1381 'UPDATE ' . $data['table_prefix'] . "topics 1382 SET topic_first_poster_name = '" . $db->sql_escape($data['admin_name']) . "', topic_last_poster_name = '" . $db->sql_escape($data['admin_name']) . "' 1383 WHERE topic_first_poster_name = 'Admin' 1384 OR topic_last_poster_name = 'Admin'", 1385 1386 'UPDATE ' . $data['table_prefix'] . "users 1387 SET user_regdate = $current_time", 1388 1389 'UPDATE ' . $data['table_prefix'] . "posts 1390 SET post_time = $current_time, poster_ip = '" . $db->sql_escape($user_ip) . "'", 1391 1392 'UPDATE ' . $data['table_prefix'] . "topics 1393 SET topic_time = $current_time, topic_last_post_time = $current_time", 1394 1395 'UPDATE ' . $data['table_prefix'] . "forums 1396 SET forum_last_post_time = $current_time", 1397 1398 'UPDATE ' . $data['table_prefix'] . "config 1399 SET config_value = '" . $db->sql_escape($db->sql_server_info(true)) . "' 1400 WHERE config_name = 'dbms_version'", 1401 ); 1402 1403 if (@extension_loaded('gd')) 1404 { 1405 $sql_ary[] = 'UPDATE ' . $data['table_prefix'] . "config 1406 SET config_value = 'core.captcha.plugins.gd' 1407 WHERE config_name = 'captcha_plugin'"; 1408 1409 $sql_ary[] = 'UPDATE ' . $data['table_prefix'] . "config 1410 SET config_value = '1' 1411 WHERE config_name = 'captcha_gd'"; 1412 } 1413 1414 $ref = substr($referer, strpos($referer, '://') + 3); 1415 1416 if (!(stripos($ref, $server_name) === 0)) 1417 { 1418 $sql_ary[] = 'UPDATE ' . $data['table_prefix'] . "config 1419 SET config_value = '0' 1420 WHERE config_name = 'referer_validation'"; 1421 } 1422 1423 // We set a (semi-)unique cookie name to bypass login issues related to the cookie name. 1424 $cookie_name = 'phpbb3_'; 1425 $rand_str = md5(mt_rand()); 1426 $rand_str = str_replace('0', 'z', base_convert($rand_str, 16, 35)); 1427 $rand_str = substr($rand_str, 0, 5); 1428 $cookie_name .= strtolower($rand_str); 1429 1430 $sql_ary[] = 'UPDATE ' . $data['table_prefix'] . "config 1431 SET config_value = '" . $db->sql_escape($cookie_name) . "' 1432 WHERE config_name = 'cookie_name'"; 1433 1434 foreach ($sql_ary as $sql) 1435 { 1436 //$sql = trim(str_replace('|', ';', $sql)); 1437 1438 if (!$db->sql_query($sql)) 1439 { 1440 $error = $db->sql_error(); 1441 $this->p_master->db_error($error['message'], $sql, __LINE__, __FILE__); 1442 } 1443 } 1444 1445 $submit = $lang['NEXT_STEP']; 1446 1447 $url = $this->p_master->module_url . "?mode=$mode&sub=final"; 1448 1449 $template->assign_vars(array( 1450 'BODY' => $lang['STAGE_CREATE_TABLE_EXPLAIN'], 1451 'L_SUBMIT' => $submit, 1452 'S_HIDDEN' => build_hidden_fields($data), 1453 'U_ACTION' => $url, 1454 )); 1455 } 1456 1457 /** 1458 * Build the search index... 1459 */ 1460 function build_search_index($mode, $sub) 1461 { 1462 global $db, $lang, $phpbb_root_path, $phpbb_dispatcher, $phpEx, $config, $auth, $user; 1463 1464 // Obtain any submitted data 1465 $data = $this->get_submitted_data(); 1466 $table_prefix = $data['table_prefix']; 1467 1468 // If we get here and the extension isn't loaded it should be safe to just go ahead and load it 1469 $available_dbms = get_available_dbms($data['dbms']); 1470 1471 if (!isset($available_dbms[$data['dbms']])) 1472 { 1473 // Someone's been silly and tried providing a non-existant dbms 1474 $this->p_master->redirect("index.$phpEx?mode=install"); 1475 } 1476 1477 $dbms = $available_dbms[$data['dbms']]['DRIVER']; 1478 1479 // Instantiate the database 1480 $db = new $dbms(); 1481 $db->sql_connect($data['dbhost'], $data['dbuser'], htmlspecialchars_decode($data['dbpasswd']), $data['dbname'], $data['dbport'], false, false); 1482 1483 // NOTE: trigger_error does not work here. 1484 $db->sql_return_on_error(true); 1485 1486 include_once($phpbb_root_path . 'includes/constants.' . $phpEx); 1487 include_once($phpbb_root_path . 'phpbb/search/fulltext_native.' . $phpEx); 1488 1489 // We need to fill the config to let internal functions correctly work 1490 $config = new \phpbb\config\db($db, new \phpbb\cache\driver\null, CONFIG_TABLE); 1491 set_config(null, null, null, $config); 1492 set_config_count(null, null, null, $config); 1493 1494 $error = false; 1495 $search = new \phpbb\search\fulltext_native($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user, $phpbb_dispatcher); 1496 1497 $sql = 'SELECT post_id, post_subject, post_text, poster_id, forum_id 1498 FROM ' . POSTS_TABLE; 1499 $result = $db->sql_query($sql); 1500 1501 while ($row = $db->sql_fetchrow($result)) 1502 { 1503 $search->index('post', $row['post_id'], $row['post_text'], $row['post_subject'], $row['poster_id'], $row['forum_id']); 1504 } 1505 $db->sql_freeresult($result); 1506 } 1507 1508 /** 1509 * Populate the module tables 1510 */ 1511 function add_modules($mode, $sub) 1512 { 1513 global $db, $lang, $phpbb_root_path, $phpEx, $phpbb_extension_manager, $config, $phpbb_container; 1514 1515 // modules require an extension manager 1516 if (empty($phpbb_extension_manager)) 1517 { 1518 $phpbb_extension_manager = $phpbb_container->get('ext.manager'); 1519 } 1520 1521 include_once($phpbb_root_path . 'includes/acp/acp_modules.' . $phpEx); 1522 1523 $_module = new acp_modules(); 1524 $module_classes = array('acp', 'mcp', 'ucp'); 1525 1526 // Add categories 1527 foreach ($module_classes as $module_class) 1528 { 1529 $categories = array(); 1530 1531 // Set the module class 1532 $_module->module_class = $module_class; 1533 1534 foreach ($this->module_categories[$module_class] as $cat_name => $subs) 1535 { 1536 $basename = ''; 1537 // Check if this sub-category has a basename. If it has, use it. 1538 if (isset($this->module_categories_basenames[$cat_name])) 1539 { 1540 $basename = $this->module_categories_basenames[$cat_name]; 1541 } 1542 $module_data = array( 1543 'module_basename' => $basename, 1544 'module_enabled' => 1, 1545 'module_display' => 1, 1546 'parent_id' => 0, 1547 'module_class' => $module_class, 1548 'module_langname' => $cat_name, 1549 'module_mode' => '', 1550 'module_auth' => '', 1551 ); 1552 1553 // Add category 1554 $_module->update_module_data($module_data, true); 1555 1556 // Check for last sql error happened 1557 if ($db->get_sql_error_triggered()) 1558 { 1559 $error = $db->sql_error($db->get_sql_error_sql()); 1560 $this->p_master->db_error($error['message'], $db->get_sql_error_sql(), __LINE__, __FILE__); 1561 } 1562 1563 $categories[$cat_name]['id'] = (int) $module_data['module_id']; 1564 $categories[$cat_name]['parent_id'] = 0; 1565 1566 // Create sub-categories... 1567 if (is_array($subs)) 1568 { 1569 foreach ($subs as $level2_name) 1570 { 1571 $basename = ''; 1572 // Check if this sub-category has a basename. If it has, use it. 1573 if (isset($this->module_categories_basenames[$level2_name])) 1574 { 1575 $basename = $this->module_categories_basenames[$level2_name]; 1576 } 1577 $module_data = array( 1578 'module_basename' => $basename, 1579 'module_enabled' => 1, 1580 'module_display' => 1, 1581 'parent_id' => (int) $categories[$cat_name]['id'], 1582 'module_class' => $module_class, 1583 'module_langname' => $level2_name, 1584 'module_mode' => '', 1585 'module_auth' => '', 1586 ); 1587 1588 $_module->update_module_data($module_data, true); 1589 1590 // Check for last sql error happened 1591 if ($db->get_sql_error_triggered()) 1592 { 1593 $error = $db->sql_error($db->get_sql_error_sql()); 1594 $this->p_master->db_error($error['message'], $db->get_sql_error_sql(), __LINE__, __FILE__); 1595 } 1596 1597 $categories[$level2_name]['id'] = (int) $module_data['module_id']; 1598 $categories[$level2_name]['parent_id'] = (int) $categories[$cat_name]['id']; 1599 } 1600 } 1601 } 1602 1603 // Get the modules we want to add... returned sorted by name 1604 $module_info = $_module->get_module_infos('', $module_class); 1605 1606 foreach ($module_info as $module_basename => $fileinfo) 1607 { 1608 foreach ($fileinfo['modes'] as $module_mode => $row) 1609 { 1610 foreach ($row['cat'] as $cat_name) 1611 { 1612 if (!isset($categories[$cat_name])) 1613 { 1614 continue; 1615 } 1616 1617 $module_data = array( 1618 'module_basename' => $module_basename, 1619 'module_enabled' => 1, 1620 'module_display' => (isset($row['display'])) ? (int) $row['display'] : 1, 1621 'parent_id' => (int) $categories[$cat_name]['id'], 1622 'module_class' => $module_class, 1623 'module_langname' => $row['title'], 1624 'module_mode' => $module_mode, 1625 'module_auth' => $row['auth'], 1626 ); 1627 1628 $_module->update_module_data($module_data, true); 1629 1630 // Check for last sql error happened 1631 if ($db->get_sql_error_triggered()) 1632 { 1633 $error = $db->sql_error($db->get_sql_error_sql()); 1634 $this->p_master->db_error($error['message'], $db->get_sql_error_sql(), __LINE__, __FILE__); 1635 } 1636 } 1637 } 1638 } 1639 1640 // Move some of the modules around since the code above will put them in the wrong place 1641 if ($module_class == 'acp') 1642 { 1643 // Move main module 4 up... 1644 $sql = 'SELECT * 1645 FROM ' . MODULES_TABLE . " 1646 WHERE module_basename = 'acp_main' 1647 AND module_class = 'acp' 1648 AND module_mode = 'main'"; 1649 $result = $db->sql_query($sql); 1650 $row = $db->sql_fetchrow($result); 1651 $db->sql_freeresult($result); 1652 1653 $_module->move_module_by($row, 'move_up', 4); 1654 1655 // Move permissions intro screen module 4 up... 1656 $sql = 'SELECT * 1657 FROM ' . MODULES_TABLE . " 1658 WHERE module_basename = 'acp_permissions' 1659 AND module_class = 'acp' 1660 AND module_mode = 'intro'"; 1661 $result = $db->sql_query($sql); 1662 $row = $db->sql_fetchrow($result); 1663 $db->sql_freeresult($result); 1664 1665 $_module->move_module_by($row, 'move_up', 4); 1666 1667 // Move manage users screen module 5 up... 1668 $sql = 'SELECT * 1669 FROM ' . MODULES_TABLE . " 1670 WHERE module_basename = 'acp_users' 1671 AND module_class = 'acp' 1672 AND module_mode = 'overview'"; 1673 $result = $db->sql_query($sql); 1674 $row = $db->sql_fetchrow($result); 1675 $db->sql_freeresult($result); 1676 1677 $_module->move_module_by($row, 'move_up', 5); 1678 1679 // Move extension management module 1 up... 1680 $sql = 'SELECT * 1681 FROM ' . MODULES_TABLE . " 1682 WHERE module_langname = 'ACP_EXTENSION_MANAGEMENT' 1683 AND module_class = 'acp' 1684 AND module_mode = '' 1685 AND module_basename = ''"; 1686 $result = $db->sql_query($sql); 1687 $row = $db->sql_fetchrow($result); 1688 $db->sql_freeresult($result); 1689 1690 $_module->move_module_by($row, 'move_up', 1); 1691 } 1692 1693 if ($module_class == 'mcp') 1694 { 1695 // Move pm report details module 3 down... 1696 $sql = 'SELECT * 1697 FROM ' . MODULES_TABLE . " 1698 WHERE module_basename = 'mcp_pm_reports' 1699 AND module_class = 'mcp' 1700 AND module_mode = 'pm_report_details'"; 1701 $result = $db->sql_query($sql); 1702 $row = $db->sql_fetchrow($result); 1703 $db->sql_freeresult($result); 1704 1705 $_module->move_module_by($row, 'move_down', 3); 1706 1707 // Move closed pm reports module 3 down... 1708 $sql = 'SELECT * 1709 FROM ' . MODULES_TABLE . " 1710 WHERE module_basename = 'mcp_pm_reports' 1711 AND module_class = 'mcp' 1712 AND module_mode = 'pm_reports_closed'"; 1713 $result = $db->sql_query($sql); 1714 $row = $db->sql_fetchrow($result); 1715 $db->sql_freeresult($result); 1716 1717 $_module->move_module_by($row, 'move_down', 3); 1718 1719 // Move open pm reports module 3 down... 1720 $sql = 'SELECT * 1721 FROM ' . MODULES_TABLE . " 1722 WHERE module_basename = 'mcp_pm_reports' 1723 AND module_class = 'mcp' 1724 AND module_mode = 'pm_reports'"; 1725 $result = $db->sql_query($sql); 1726 $row = $db->sql_fetchrow($result); 1727 $db->sql_freeresult($result); 1728 1729 $_module->move_module_by($row, 'move_down', 3); 1730 } 1731 1732 if ($module_class == 'ucp') 1733 { 1734 // Move attachment module 4 down... 1735 $sql = 'SELECT * 1736 FROM ' . MODULES_TABLE . " 1737 WHERE module_basename = 'ucp_attachments' 1738 AND module_class = 'ucp' 1739 AND module_mode = 'attachments'"; 1740 $result = $db->sql_query($sql); 1741 $row = $db->sql_fetchrow($result); 1742 $db->sql_freeresult($result); 1743 1744 $_module->move_module_by($row, 'move_down', 4); 1745 1746 // Move notification options module 4 down... 1747 $sql = 'SELECT * 1748 FROM ' . MODULES_TABLE . " 1749 WHERE module_basename = 'ucp_notifications' 1750 AND module_class = 'ucp' 1751 AND module_mode = 'notification_options'"; 1752 $result = $db->sql_query($sql); 1753 $row = $db->sql_fetchrow($result); 1754 $db->sql_freeresult($result); 1755 1756 $_module->move_module_by($row, 'move_down', 4); 1757 1758 // Move OAuth module 5 down... 1759 $sql = 'SELECT * 1760 FROM ' . MODULES_TABLE . " 1761 WHERE module_basename = 'ucp_auth_link' 1762 AND module_class = 'ucp' 1763 AND module_mode = 'auth_link'"; 1764 $result = $db->sql_query($sql); 1765 $row = $db->sql_fetchrow($result); 1766 $db->sql_freeresult($result); 1767 1768 $_module->move_module_by($row, 'move_down', 5); 1769 } 1770 1771 // And now for the special ones 1772 // (these are modules which appear in multiple categories and thus get added manually to some for more control) 1773 if (isset($this->module_extras[$module_class])) 1774 { 1775 foreach ($this->module_extras[$module_class] as $cat_name => $mods) 1776 { 1777 $sql = 'SELECT module_id, left_id, right_id 1778 FROM ' . MODULES_TABLE . " 1779 WHERE module_langname = '" . $db->sql_escape($cat_name) . "' 1780 AND module_class = '" . $db->sql_escape($module_class) . "'"; 1781 $result = $db->sql_query_limit($sql, 1); 1782 $row2 = $db->sql_fetchrow($result); 1783 $db->sql_freeresult($result); 1784 1785 foreach ($mods as $mod_name) 1786 { 1787 $sql = 'SELECT * 1788 FROM ' . MODULES_TABLE . " 1789 WHERE module_langname = '" . $db->sql_escape($mod_name) . "' 1790 AND module_class = '" . $db->sql_escape($module_class) . "' 1791 AND module_basename <> ''"; 1792 $result = $db->sql_query_limit($sql, 1); 1793 $row = $db->sql_fetchrow($result); 1794 $db->sql_freeresult($result); 1795 1796 $module_data = array( 1797 'module_basename' => $row['module_basename'], 1798 'module_enabled' => (int) $row['module_enabled'], 1799 'module_display' => (int) $row['module_display'], 1800 'parent_id' => (int) $row2['module_id'], 1801 'module_class' => $row['module_class'], 1802 'module_langname' => $row['module_langname'], 1803 'module_mode' => $row['module_mode'], 1804 'module_auth' => $row['module_auth'], 1805 ); 1806 1807 $_module->update_module_data($module_data, true); 1808 1809 // Check for last sql error happened 1810 if ($db->get_sql_error_triggered()) 1811 { 1812 $error = $db->sql_error($db->get_sql_error_sql()); 1813 $this->p_master->db_error($error['message'], $db->get_sql_error_sql(), __LINE__, __FILE__); 1814 } 1815 } 1816 } 1817 } 1818 1819 $_module->remove_cache_file(); 1820 } 1821 } 1822 1823 /** 1824 * Populate the language tables 1825 */ 1826 function add_language($mode, $sub) 1827 { 1828 global $db, $lang, $phpbb_root_path, $phpEx; 1829 1830 $dir = @opendir($phpbb_root_path . 'language'); 1831 1832 if (!$dir) 1833 { 1834 $this->error('Unable to access the language directory', __LINE__, __FILE__); 1835 } 1836 1837 $installed_languages = array(); 1838 while (($file = readdir($dir)) !== false) 1839 { 1840 $path = $phpbb_root_path . 'language/' . $file; 1841 1842 if ($file == '.' || $file == '..' || is_link($path) || is_file($path) || $file == 'CVS') 1843 { 1844 continue; 1845 } 1846 1847 if (is_dir($path) && file_exists($path . '/iso.txt')) 1848 { 1849 $lang_file = file("$path/iso.txt"); 1850 1851 $lang_pack = array( 1852 'lang_iso' => basename($path), 1853 'lang_dir' => basename($path), 1854 'lang_english_name' => trim(htmlspecialchars($lang_file[0])), 1855 'lang_local_name' => trim(htmlspecialchars($lang_file[1], ENT_COMPAT, 'UTF-8')), 1856 'lang_author' => trim(htmlspecialchars($lang_file[2], ENT_COMPAT, 'UTF-8')), 1857 ); 1858 1859 $db->sql_query('INSERT INTO ' . LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $lang_pack)); 1860 1861 $installed_languages[] = (int) $db->sql_nextid(); 1862 if ($db->get_sql_error_triggered()) 1863 { 1864 $error = $db->sql_error($db->get_sql_error_sql()); 1865 $this->p_master->db_error($error['message'], $db->get_sql_error_sql(), __LINE__, __FILE__); 1866 } 1867 } 1868 } 1869 closedir($dir); 1870 1871 $sql = 'SELECT * 1872 FROM ' . PROFILE_FIELDS_TABLE; 1873 $result = $db->sql_query($sql); 1874 1875 $profile_fields = array(); 1876 $insert_buffer = new \phpbb\db\sql_insert_buffer($db, PROFILE_LANG_TABLE); 1877 while ($row = $db->sql_fetchrow($result)) 1878 { 1879 foreach ($installed_languages as $lang_id) 1880 { 1881 $insert_buffer->insert(array( 1882 'field_id' => $row['field_id'], 1883 'lang_id' => $lang_id, 1884 'lang_name' => strtoupper(substr($row['field_name'], 6)),// Remove phpbb_ from field name 1885 'lang_explain' => '', 1886 'lang_default_value' => '', 1887 )); 1888 } 1889 } 1890 $db->sql_freeresult($result); 1891 1892 $insert_buffer->flush(); 1893 } 1894 1895 /** 1896 * Add search robots to the database 1897 */ 1898 function add_bots($mode, $sub) 1899 { 1900 global $db, $lang, $phpbb_root_path, $phpEx, $config; 1901 1902 // Obtain any submitted data 1903 $data = $this->get_submitted_data(); 1904 1905 // We need to fill the config to let internal functions correctly work 1906 $config = new \phpbb\config\db($db, new \phpbb\cache\driver\null, CONFIG_TABLE); 1907 set_config(null, null, null, $config); 1908 set_config_count(null, null, null, $config); 1909 1910 $sql = 'SELECT group_id 1911 FROM ' . GROUPS_TABLE . " 1912 WHERE group_name = 'BOTS'"; 1913 $result = $db->sql_query($sql); 1914 $group_id = (int) $db->sql_fetchfield('group_id'); 1915 $db->sql_freeresult($result); 1916 1917 if (!$group_id) 1918 { 1919 // If we reach this point then something has gone very wrong 1920 $this->p_master->error($lang['NO_GROUP'], __LINE__, __FILE__); 1921 } 1922 1923 if (!function_exists('user_add')) 1924 { 1925 include($phpbb_root_path . 'includes/functions_user.' . $phpEx); 1926 } 1927 1928 foreach ($this->bot_list as $bot_name => $bot_ary) 1929 { 1930 $user_row = array( 1931 'user_type' => USER_IGNORE, 1932 'group_id' => $group_id, 1933 'username' => $bot_name, 1934 'user_regdate' => time(), 1935 'user_password' => '', 1936 'user_colour' => '9E8DA7', 1937 'user_email' => '', 1938 'user_lang' => $data['default_lang'], 1939 'user_style' => 1, 1940 'user_timezone' => 'UTC', 1941 'user_dateformat' => $lang['default_dateformat'], 1942 'user_allow_massemail' => 0, 1943 'user_allow_pm' => 0, 1944 ); 1945 1946 $user_id = user_add($user_row); 1947 1948 if (!$user_id) 1949 { 1950 // If we can't insert this user then continue to the next one to avoid inconsistent data 1951 $this->p_master->db_error('Unable to insert bot into users table', $db->get_sql_error_sql(), __LINE__, __FILE__, true); 1952 continue; 1953 } 1954 1955 $sql = 'INSERT INTO ' . BOTS_TABLE . ' ' . $db->sql_build_array('INSERT', array( 1956 'bot_active' => 1, 1957 'bot_name' => (string) $bot_name, 1958 'user_id' => (int) $user_id, 1959 'bot_agent' => (string) $bot_ary[0], 1960 'bot_ip' => (string) $bot_ary[1], 1961 )); 1962 1963 $db->sql_query($sql); 1964 } 1965 } 1966 1967 /** 1968 * Sends an email to the board administrator with their password and some useful links 1969 */ 1970 function email_admin($mode, $sub) 1971 { 1972 global $auth, $config, $db, $lang, $template, $user, $phpbb_root_path, $phpbb_admin_path, $phpEx; 1973 1974 $this->page_title = $lang['STAGE_FINAL']; 1975 1976 // Obtain any submitted data 1977 $data = $this->get_submitted_data(); 1978 1979 // We need to fill the config to let internal functions correctly work 1980 $config = new \phpbb\config\db($db, new \phpbb\cache\driver\null, CONFIG_TABLE); 1981 set_config(null, null, null, $config); 1982 set_config_count(null, null, null, $config); 1983 1984 $user->session_begin(); 1985 $auth->login($data['admin_name'], $data['admin_pass1'], false, true, true); 1986 1987 // OK, Now that we've reached this point we can be confident that everything 1988 // is installed and working......I hope :) 1989 // So it's time to send an email to the administrator confirming the details 1990 // they entered 1991 1992 if ($config['email_enable']) 1993 { 1994 include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx); 1995 1996 $messenger = new messenger(false); 1997 1998 $messenger->template('installed', $data['language']); 1999 2000 $messenger->to($data['board_email'], $data['admin_name']); 2001 2002 $messenger->anti_abuse_headers($config, $user); 2003 2004 $messenger->assign_vars(array( 2005 'USERNAME' => htmlspecialchars_decode($data['admin_name']), 2006 'PASSWORD' => htmlspecialchars_decode($data['admin_pass1'])) 2007 ); 2008 2009 $messenger->send(NOTIFY_EMAIL); 2010 } 2011 2012 // And finally, add a note to the log 2013 add_log('admin', 'LOG_INSTALL_INSTALLED', $config['version']); 2014 2015 $template->assign_vars(array( 2016 'TITLE' => $lang['INSTALL_CONGRATS'], 2017 'BODY' => sprintf($lang['INSTALL_CONGRATS_EXPLAIN'], $config['version'], append_sid($phpbb_root_path . 'install/index.' . $phpEx, 'mode=convert&language=' . $data['language']), '../docs/README.html'), 2018 'L_SUBMIT' => $lang['INSTALL_LOGIN'], 2019 'U_ACTION' => append_sid($phpbb_admin_path . 'index.' . $phpEx, 'i=send_statistics&mode=send_statistics'), 2020 )); 2021 } 2022 2023 /** 2024 * Check if the avatar directory is writable and disable avatars 2025 * if it isn't writable. 2026 */ 2027 function disable_avatars_if_unwritable() 2028 { 2029 global $phpbb_root_path; 2030 2031 if (!phpbb_is_writable($phpbb_root_path . 'images/avatars/upload/')) 2032 { 2033 set_config('allow_avatar', 0); 2034 set_config('allow_avatar_upload', 0); 2035 } 2036 } 2037 2038 /** 2039 * Populate migrations for the installation 2040 * 2041 * This "installs" all migrations from (root path)/phpbb/db/migrations/data. 2042 * "installs" means it adds all migrations to the migrations table, but does not 2043 * perform any of the actions in the migrations. 2044 * 2045 * @param \phpbb\extension\manager $extension_manager 2046 * @param \phpbb\db\migrator $migrator 2047 */ 2048 function populate_migrations($extension_manager, $migrator) 2049 { 2050 $finder = $extension_manager->get_finder(); 2051 2052 $migrations = $finder 2053 ->core_path('phpbb/db/migration/data/') 2054 ->get_classes(); 2055 $migrator->populate_migrations($migrations); 2056 } 2057 2058 /** 2059 * Generate a list of available mail server authentication methods 2060 */ 2061 function mail_auth_select($selected_method) 2062 { 2063 global $lang; 2064 2065 $auth_methods = array('PLAIN', 'LOGIN', 'CRAM-MD5', 'DIGEST-MD5', 'POP-BEFORE-SMTP'); 2066 $s_smtp_auth_options = ''; 2067 2068 foreach ($auth_methods as $method) 2069 { 2070 $s_smtp_auth_options .= '<option value="' . $method . '"' . (($selected_method == $method) ? ' selected="selected"' : '') . '>' . $lang['SMTP_' . str_replace('-', '_', $method)] . '</option>'; 2071 } 2072 2073 return $s_smtp_auth_options; 2074 } 2075 2076 /** 2077 * Get submitted data 2078 */ 2079 function get_submitted_data() 2080 { 2081 return array( 2082 'language' => basename(request_var('language', '')), 2083 'dbms' => request_var('dbms', ''), 2084 'dbhost' => request_var('dbhost', '', true), 2085 'dbport' => request_var('dbport', ''), 2086 'dbuser' => request_var('dbuser', ''), 2087 'dbpasswd' => request_var('dbpasswd', '', true), 2088 'dbname' => request_var('dbname', ''), 2089 'table_prefix' => request_var('table_prefix', ''), 2090 'default_lang' => basename(request_var('default_lang', '')), 2091 'admin_name' => utf8_normalize_nfc(request_var('admin_name', '', true)), 2092 'admin_pass1' => request_var('admin_pass1', '', true), 2093 'admin_pass2' => request_var('admin_pass2', '', true), 2094 'board_email' => strtolower(request_var('board_email', '')), 2095 'img_imagick' => request_var('img_imagick', ''), 2096 'ftp_path' => request_var('ftp_path', ''), 2097 'ftp_user' => request_var('ftp_user', ''), 2098 'ftp_pass' => request_var('ftp_pass', ''), 2099 'email_enable' => request_var('email_enable', ''), 2100 'smtp_delivery' => request_var('smtp_delivery', ''), 2101 'smtp_host' => request_var('smtp_host', ''), 2102 'smtp_auth' => request_var('smtp_auth', ''), 2103 'smtp_user' => request_var('smtp_user', ''), 2104 'smtp_pass' => request_var('smtp_pass', ''), 2105 'cookie_secure' => request_var('cookie_secure', ''), 2106 'force_server_vars' => request_var('force_server_vars', ''), 2107 'server_protocol' => request_var('server_protocol', ''), 2108 'server_name' => request_var('server_name', ''), 2109 'server_port' => request_var('server_port', ''), 2110 'script_path' => request_var('script_path', ''), 2111 ); 2112 } 2113 2114 /** 2115 * The information below will be used to build the input fields presented to the user 2116 */ 2117 var $db_config_options = array( 2118 'legend1' => 'DB_CONFIG', 2119 'dbms' => array('lang' => 'DBMS', 'type' => 'select', 'options' => 'dbms_select(\'{VALUE}\')', 'explain' => false), 2120 'dbhost' => array('lang' => 'DB_HOST', 'type' => 'text:25:100', 'explain' => true), 2121 'dbport' => array('lang' => 'DB_PORT', 'type' => 'text:25:100', 'explain' => true), 2122 'dbname' => array('lang' => 'DB_NAME', 'type' => 'text:25:100', 'explain' => false), 2123 'dbuser' => array('lang' => 'DB_USERNAME', 'type' => 'text:25:100', 'explain' => false), 2124 'dbpasswd' => array('lang' => 'DB_PASSWORD', 'type' => 'password:25:100', 'explain' => false), 2125 'table_prefix' => array('lang' => 'TABLE_PREFIX', 'type' => 'text:25:100', 'explain' => true), 2126 ); 2127 var $admin_config_options = array( 2128 'legend1' => 'ADMIN_CONFIG', 2129 'default_lang' => array('lang' => 'DEFAULT_LANG', 'type' => 'select', 'options' => '$this->module->inst_language_select(\'{VALUE}\')', 'explain' => false), 2130 'admin_name' => array('lang' => 'ADMIN_USERNAME', 'type' => 'text:25:100', 'explain' => true), 2131 'admin_pass1' => array('lang' => 'ADMIN_PASSWORD', 'type' => 'password:25:100', 'explain' => true), 2132 'admin_pass2' => array('lang' => 'ADMIN_PASSWORD_CONFIRM', 'type' => 'password:25:100', 'explain' => false), 2133 'board_email' => array('lang' => 'CONTACT_EMAIL', 'type' => 'email:25:100', 'explain' => false), 2134 ); 2135 var $advanced_config_options = array( 2136 'legend1' => 'ACP_EMAIL_SETTINGS', 2137 'email_enable' => array('lang' => 'ENABLE_EMAIL', 'type' => 'radio:enabled_disabled', 'explain' => true), 2138 'smtp_delivery' => array('lang' => 'USE_SMTP', 'type' => 'radio:yes_no', 'explain' => true), 2139 'smtp_host' => array('lang' => 'SMTP_SERVER', 'type' => 'text:25:50', 'explain' => false), 2140 'smtp_auth' => array('lang' => 'SMTP_AUTH_METHOD', 'type' => 'select', 'options' => '$this->module->mail_auth_select(\'{VALUE}\')', 'explain' => true), 2141 'smtp_user' => array('lang' => 'SMTP_USERNAME', 'type' => 'text:25:255', 'explain' => true, 'options' => array('autocomplete' => 'off')), 2142 'smtp_pass' => array('lang' => 'SMTP_PASSWORD', 'type' => 'password:25:255', 'explain' => true, 'options' => array('autocomplete' => 'off')), 2143 2144 'legend2' => 'SERVER_URL_SETTINGS', 2145 'cookie_secure' => array('lang' => 'COOKIE_SECURE', 'type' => 'radio:enabled_disabled', 'explain' => true), 2146 'force_server_vars' => array('lang' => 'FORCE_SERVER_VARS', 'type' => 'radio:yes_no', 'explain' => true), 2147 'server_protocol' => array('lang' => 'SERVER_PROTOCOL', 'type' => 'text:10:10', 'explain' => true), 2148 'server_name' => array('lang' => 'SERVER_NAME', 'type' => 'text:40:255', 'explain' => true), 2149 'server_port' => array('lang' => 'SERVER_PORT', 'type' => 'text:5:5', 'explain' => true), 2150 'script_path' => array('lang' => 'SCRIPT_PATH', 'type' => 'text::255', 'explain' => true), 2151 ); 2152 2153 /** 2154 * Specific PHP modules we may require for certain optional or extended features 2155 */ 2156 var $php_dlls_other = array('zlib', 'ftp', 'gd', 'xml'); 2157 2158 /** 2159 * A list of the web-crawlers/bots we recognise by default 2160 * 2161 * Candidates but not included: 2162 * 'Accoona [Bot]' 'Accoona-AI-Agent/' 2163 * 'ASPseek [Crawler]' 'ASPseek/' 2164 * 'Boitho [Crawler]' 'boitho.com-dc/' 2165 * 'Bunnybot [Bot]' 'powered by www.buncat.de' 2166 * 'Cosmix [Bot]' 'cfetch/' 2167 * 'Crawler Search [Crawler]' '.Crawler-Search.de' 2168 * 'Findexa [Crawler]' 'Findexa Crawler (' 2169 * 'GBSpider [Spider]' 'GBSpider v' 2170 * 'genie [Bot]' 'genieBot (' 2171 * 'Hogsearch [Bot]' 'oegp v. 1.3.0' 2172 * 'Insuranco [Bot]' 'InsurancoBot' 2173 * 'IRLbot [Bot]' 'http://irl.cs.tamu.edu/crawler' 2174 * 'ISC Systems [Bot]' 'ISC Systems iRc Search' 2175 * 'Jyxobot [Bot]' 'Jyxobot/' 2176 * 'Kraehe [Metasuche]' '-DIE-KRAEHE- META-SEARCH-ENGINE/' 2177 * 'LinkWalker' 'LinkWalker' 2178 * 'MMSBot [Bot]' 'http://www.mmsweb.at/bot.html' 2179 * 'Naver [Bot]' 'nhnbot@naver.com)' 2180 * 'NetResearchServer' 'NetResearchServer/' 2181 * 'Nimble [Crawler]' 'NimbleCrawler' 2182 * 'Ocelli [Bot]' 'Ocelli/' 2183 * 'Onsearch [Bot]' 'onCHECK-Robot' 2184 * 'Orange [Spider]' 'OrangeSpider' 2185 * 'Sproose [Bot]' 'http://www.sproose.com/bot' 2186 * 'Susie [Sync]' '!Susie (http://www.sync2it.com/susie)' 2187 * 'Tbot [Bot]' 'Tbot/' 2188 * 'Thumbshots [Capture]' 'thumbshots-de-Bot' 2189 * 'Vagabondo [Crawler]' 'http://webagent.wise-guys.nl/' 2190 * 'Walhello [Bot]' 'appie 1.1 (www.walhello.com)' 2191 * 'WissenOnline [Bot]' 'WissenOnline-Bot' 2192 * 'WWWeasel [Bot]' 'WWWeasel Robot v' 2193 * 'Xaldon [Spider]' 'Xaldon WebSpider' 2194 */ 2195 var $bot_list = array( 2196 'AdsBot [Google]' => array('AdsBot-Google', ''), 2197 'Alexa [Bot]' => array('ia_archiver', ''), 2198 'Alta Vista [Bot]' => array('Scooter/', ''), 2199 'Ask Jeeves [Bot]' => array('Ask Jeeves', ''), 2200 'Baidu [Spider]' => array('Baiduspider', ''), 2201 'Bing [Bot]' => array('bingbot/', ''), 2202 'Exabot [Bot]' => array('Exabot', ''), 2203 'FAST Enterprise [Crawler]' => array('FAST Enterprise Crawler', ''), 2204 'FAST WebCrawler [Crawler]' => array('FAST-WebCrawler/', ''), 2205 'Francis [Bot]' => array('http://www.neomo.de/', ''), 2206 'Gigabot [Bot]' => array('Gigabot/', ''), 2207 'Google Adsense [Bot]' => array('Mediapartners-Google', ''), 2208 'Google Desktop' => array('Google Desktop', ''), 2209 'Google Feedfetcher' => array('Feedfetcher-Google', ''), 2210 'Google [Bot]' => array('Googlebot', ''), 2211 'Heise IT-Markt [Crawler]' => array('heise-IT-Markt-Crawler', ''), 2212 'Heritrix [Crawler]' => array('heritrix/1.', ''), 2213 'IBM Research [Bot]' => array('ibm.com/cs/crawler', ''), 2214 'ICCrawler - ICjobs' => array('ICCrawler - ICjobs', ''), 2215 'ichiro [Crawler]' => array('ichiro/', ''), 2216 'Majestic-12 [Bot]' => array('MJ12bot/', ''), 2217 'Metager [Bot]' => array('MetagerBot/', ''), 2218 'MSN NewsBlogs' => array('msnbot-NewsBlogs/', ''), 2219 'MSN [Bot]' => array('msnbot/', ''), 2220 'MSNbot Media' => array('msnbot-media/', ''), 2221 'Nutch [Bot]' => array('http://lucene.apache.org/nutch/', ''), 2222 'Online link [Validator]' => array('online link validator', ''), 2223 'psbot [Picsearch]' => array('psbot/0', ''), 2224 'Sensis [Crawler]' => array('Sensis Web Crawler', ''), 2225 'SEO Crawler' => array('SEO search Crawler/', ''), 2226 'Seoma [Crawler]' => array('Seoma [SEO Crawler]', ''), 2227 'SEOSearch [Crawler]' => array('SEOsearch/', ''), 2228 'Snappy [Bot]' => array('Snappy/1.1 ( http://www.urltrends.com/ )', ''), 2229 'Steeler [Crawler]' => array('http://www.tkl.iis.u-tokyo.ac.jp/~crawler/', ''), 2230 'Telekom [Bot]' => array('crawleradmin.t-info@telekom.de', ''), 2231 'TurnitinBot [Bot]' => array('TurnitinBot/', ''), 2232 'Voyager [Bot]' => array('voyager/', ''), 2233 'W3 [Sitesearch]' => array('W3 SiteSearch Crawler', ''), 2234 'W3C [Linkcheck]' => array('W3C-checklink/', ''), 2235 'W3C [Validator]' => array('W3C_Validator', ''), 2236 'YaCy [Bot]' => array('yacybot', ''), 2237 'Yahoo MMCrawler [Bot]' => array('Yahoo-MMCrawler/', ''), 2238 'Yahoo Slurp [Bot]' => array('Yahoo! DE Slurp', ''), 2239 'Yahoo [Bot]' => array('Yahoo! Slurp', ''), 2240 'YahooSeeker [Bot]' => array('YahooSeeker/', ''), 2241 ); 2242 2243 /** 2244 * Define the module structure so that we can populate the database without 2245 * needing to hard-code module_id values 2246 */ 2247 var $module_categories = array( 2248 'acp' => array( 2249 'ACP_CAT_GENERAL' => array( 2250 'ACP_QUICK_ACCESS', 2251 'ACP_BOARD_CONFIGURATION', 2252 'ACP_CLIENT_COMMUNICATION', 2253 'ACP_SERVER_CONFIGURATION', 2254 ), 2255 'ACP_CAT_FORUMS' => array( 2256 'ACP_MANAGE_FORUMS', 2257 'ACP_FORUM_BASED_PERMISSIONS', 2258 ), 2259 'ACP_CAT_POSTING' => array( 2260 'ACP_MESSAGES', 2261 'ACP_ATTACHMENTS', 2262 ), 2263 'ACP_CAT_USERGROUP' => array( 2264 'ACP_CAT_USERS', 2265 'ACP_GROUPS', 2266 'ACP_USER_SECURITY', 2267 ), 2268 'ACP_CAT_PERMISSIONS' => array( 2269 'ACP_GLOBAL_PERMISSIONS', 2270 'ACP_FORUM_BASED_PERMISSIONS', 2271 'ACP_PERMISSION_ROLES', 2272 'ACP_PERMISSION_MASKS', 2273 ), 2274 'ACP_CAT_CUSTOMISE' => array( 2275 'ACP_STYLE_MANAGEMENT', 2276 'ACP_EXTENSION_MANAGEMENT', 2277 'ACP_LANGUAGE', 2278 ), 2279 'ACP_CAT_MAINTENANCE' => array( 2280 'ACP_FORUM_LOGS', 2281 'ACP_CAT_DATABASE', 2282 ), 2283 'ACP_CAT_SYSTEM' => array( 2284 'ACP_AUTOMATION', 2285 'ACP_GENERAL_TASKS', 2286 'ACP_MODULE_MANAGEMENT', 2287 ), 2288 'ACP_CAT_DOT_MODS' => null, 2289 ), 2290 'mcp' => array( 2291 'MCP_MAIN' => null, 2292 'MCP_QUEUE' => null, 2293 'MCP_REPORTS' => null, 2294 'MCP_NOTES' => null, 2295 'MCP_WARN' => null, 2296 'MCP_LOGS' => null, 2297 'MCP_BAN' => null, 2298 ), 2299 'ucp' => array( 2300 'UCP_MAIN' => null, 2301 'UCP_PROFILE' => null, 2302 'UCP_PREFS' => null, 2303 'UCP_PM' => null, 2304 'UCP_USERGROUPS' => null, 2305 'UCP_ZEBRA' => null, 2306 ), 2307 ); 2308 var $module_categories_basenames = array( 2309 'UCP_PM' => 'ucp_pm', 2310 ); 2311 2312 var $module_extras = array( 2313 'acp' => array( 2314 'ACP_QUICK_ACCESS' => array( 2315 'ACP_MANAGE_USERS', 2316 'ACP_GROUPS_MANAGE', 2317 'ACP_MANAGE_FORUMS', 2318 'ACP_MOD_LOGS', 2319 'ACP_BOTS', 2320 'ACP_PHP_INFO', 2321 ), 2322 'ACP_FORUM_BASED_PERMISSIONS' => array( 2323 'ACP_FORUM_PERMISSIONS', 2324 'ACP_FORUM_PERMISSIONS_COPY', 2325 'ACP_FORUM_MODERATORS', 2326 'ACP_USERS_FORUM_PERMISSIONS', 2327 'ACP_GROUPS_FORUM_PERMISSIONS', 2328 ), 2329 ), 2330 ); 2331 }
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 |