-<!-- INCLUDE install_header.html -->

-

-<!-- IF S_NOT_INSTALLED -->

-

- <h1>{TITLE}</h1>

-

- <p>{BODY}</p>

-

-<!-- ELSE -->

-

- <form id="install_convert" method="post" action="{U_ACTION}">

-

- <h1>{TITLE}</h1>

-

- <p>{BODY}</p>

-

- <!-- IF S_ERROR_BOX -->

- <div class="errorbox">

- <h3>{ERROR_TITLE}</h3>

- <p>{ERROR_MSG}</p>

- </div>

- <!-- ENDIF -->

-

- <!-- IF S_LIST -->

- <table class="table1">

- <caption>{L_AVAILABLE_CONVERTORS}</caption>

- <col class="col1" /><col class="col2" /><col class="col1" /><col class="col2" />

- <thead>

- <tr>

- <th>{L_SOFTWARE}</th>

- <th>{L_VERSION}</th>

- <th>{L_AUTHOR}</th>

- <th>{L_OPTIONS}</th>

- </tr>

- </thead>

- <tbody>

- <!-- IF .convertors -->

- <!-- BEGIN convertors -->

- <tr>

- <td>{convertors.SOFTWARE}</td>

- <td>{convertors.VERSION}</td>

- <td>{convertors.AUTHOR}</td>

- <td><a href="{convertors.U_CONVERT}">{L_CONVERT}</a></td>

- </tr>

- <!-- END convertors -->

- <!-- ELSE -->

- <tr>

- <td>{L_NO_CONVERTORS}</td>

- <td>-</td>

- <td>-</td>

- <td>-</td>

- </tr>

- <!-- ENDIF -->

- </tbody>

- </table>

- <!-- ENDIF -->

-

- <!-- IF S_CONTINUE -->

- </form>

-

- <fieldset class="submit-buttons">

- <form method="post" action="{U_NEW_ACTION}">

- <input class="button1" type="submit" name="submit_new" value="{L_NEW}" />

- </form>

- <br />

- <form method="post" action="{U_CONTINUE_ACTION}">

- <input class="button1" type="submit" name="submit_cont" value="{L_CONTINUE}" />

- </form>

- </fieldset>

-

- <form method="post" action="{U_ACTION}">

- <!-- ENDIF -->

-

- <!-- IF .checks -->

- <fieldset>

-

- <!-- BEGIN checks -->

- <!-- IF checks.S_LEGEND -->

- <!-- IF not checks.S_FIRST_ROW -->

- </fieldset>

-

- <fieldset>

- <!-- ENDIF -->

- <legend>{checks.LEGEND}</legend>

- <!-- IF checks.LEGEND_EXPLAIN --><p>{checks.LEGEND_EXPLAIN}</p><!-- ENDIF -->

- <!-- ELSE -->

-

- <dl>

- <dt><label>{checks.TITLE}{L_COLON}</label><!-- IF checks.S_EXPLAIN --><br /><span class="explain">{checks.TITLE_EXPLAIN}</span><!-- ENDIF --></dt>

- <dd>{checks.RESULT}</dd>

- </dl>

- <!-- ENDIF -->

- <!-- END checks -->

-

- </fieldset>

- <!-- ENDIF -->

-

- <!-- IF .options -->

- <fieldset>

-

- <!-- BEGIN options -->

- <!-- IF options.S_LEGEND -->

- <!-- IF not options.S_FIRST_ROW -->

- </fieldset>

-

- <fieldset>

- <!-- ENDIF -->

- <legend>{options.LEGEND}</legend>

- <!-- ELSE -->

-

- <dl>

- <dt><label for="{options.KEY}">{options.TITLE}{L_COLON}</label><!-- IF options.S_EXPLAIN --><br /><span class="explain">{options.TITLE_EXPLAIN}</span><!-- ENDIF --></dt>

- <dd>{options.CONTENT}</dd>

- </dl>

-

- <!-- ENDIF -->

- <!-- END options -->

-

- </fieldset>

- <!-- ENDIF -->

-

- <!-- IF L_SUBMIT -->

- <!-- IF L_MESSAGE --><p>{L_MESSAGE}</p><!-- ENDIF -->

-

- <fieldset class="submit-buttons">

- {S_HIDDEN}

- <!-- IF L_SUBMIT --><input class="button1<!-- IF S_REFRESH --> disabled<!-- ENDIF -->" type="submit" id="submit" <!-- IF S_REFRESH -->disabled="disabled" <!-- ELSE --> onclick="this.className = 'button1 disabled';" onsubmit="this.disabled = 'disabled';" <!-- ENDIF -->name="submit" value="{L_SUBMIT}" /><!-- ENDIF -->

- </fieldset>

- <!-- ENDIF -->

-

- </form>

-<!-- ENDIF -->

-

-<!-- INCLUDE install_footer.html -->

-<!-- INCLUDE install_header.html -->

-

-<div class="errorbox">

- <h3>{MESSAGE_TITLE}</h3>

- <p>{MESSAGE_TEXT}</p>

-</div>

-

-<!-- INCLUDE install_footer.html -->

- </div>

- </div><!-- /#main -->

- </div>

- </div><!-- /#acp -->

- </div>

-

- <div id="page-footer">

- <div class="copyright">

- Powered by <a href="https://www.phpbb.com/">phpBB</a>&reg; Forum Software &copy; phpBB Limited

- </div>

- </div>

-</div>

-

-<script type="text/javascript" src="{T_JQUERY_LINK}"></script>

-<!-- IF S_ALLOW_CDN --><script type="text/javascript">window.jQuery || document.write(unescape('%3Cscript src="{T_ASSETS_PATH}/javascript/jquery.min.js" type="text/javascript"%3E%3C/script%3E'));</script><!-- ENDIF -->

-<script type="text/javascript" src="{T_ASSETS_PATH}/javascript/core.js?assets_version={T_ASSETS_VERSION}"></script>

-<!-- INCLUDEJS admin.js -->

-{$SCRIPTS}

-

-</body>

-</html>

-<!DOCTYPE html>

-<html dir="{S_CONTENT_DIRECTION}" lang="{S_USER_LANG}">

-<head>

-<meta charset="utf-8">

-<meta name="viewport" content="width=device-width, initial-scale=1" />

-<!-- IF META -->{META}<!-- ENDIF -->

-<title>{PAGE_TITLE}</title>

-

-<link href="{T_TEMPLATE_PATH}/admin.css" rel="stylesheet" type="text/css" media="screen" />

-</head>

-

-<body class="{S_CONTENT_DIRECTION} nojs">

-<div id="wrap">

- <div id="page-header">

- <h1>{L_INSTALL_PANEL}</h1>

- <p id="skip"><a href="#acp">{L_SKIP}</a></p>

- <!-- IF S_LANG_SELECT -->

- <form method="post" action="#">

- <fieldset class="nobg">

- <label for="language">{L_SELECT_LANG}{L_COLON}</label>

- {S_LANG_SELECT}

- <input class="button1" type="submit" id="change_lang" name="change_lang" value="{L_CHANGE}" />

- </fieldset>

- </form>

- <!-- ENDIF -->

- </div>

-

- <div id="page-body">

- <div id="tabs">

- <ul>

- <!-- BEGIN t_block1 -->

- <li class="tab<!-- IF t_block1.S_SELECTED --> activetab<!-- ENDIF -->"><a href="{t_block1.U_TITLE}">{t_block1.L_TITLE}</a></li>

- <!-- END t_block1 -->

- </ul>

- </div>

-

- <div id="acp">

- <div id="content">

- <div id="menu">

- <div class="menu-block no-header">

- <ul>

- <!-- BEGIN l_block1 -->

- <li<!-- IF l_block1.S_SELECTED --> id="activemenu"<!-- ENDIF -->><a href="{l_block1.U_TITLE}"><span>{l_block1.L_TITLE}</span></a></li>

- <!-- END l_block1 -->

- <!-- BEGIN l_block2 -->

- <li<!-- IF l_block2.S_SELECTED --> id="activemenu"<!-- ENDIF -->><span<!-- IF l_block2.S_COMPLETE --> class="completed"<!-- ENDIF -->>{l_block2.L_TITLE}</span></li>

- <!-- END l_block2 -->

- </ul>

- </div>

- </div>

-

- <div id="main" class="install-body">

- <div class="main">

-<!-- INCLUDE install_header.html -->

-

-<form id="install_install" method="post" action="{U_ACTION}" onsubmit="submit.disabled = 'disabled';">

-

-<!-- IF TITLE --><h1>{TITLE}</h1><!-- ENDIF -->

-<!-- IF BODY --><p>{BODY}</p><!-- ENDIF -->

-

-<!-- IF .checks -->

- <fieldset>

-

- <!-- BEGIN checks -->

- <!-- IF checks.S_LEGEND -->

- <!-- IF not checks.S_FIRST_ROW -->

- </fieldset>

-

- <fieldset>

- <!-- ENDIF -->

- <legend>{checks.LEGEND}</legend>

- <!-- IF checks.LEGEND_EXPLAIN --><p>{checks.LEGEND_EXPLAIN}</p><!-- ENDIF -->

- <!-- ELSE -->

-

- <dl>

- <dt>{checks.TITLE}{L_COLON}<!-- IF checks.S_EXPLAIN --><br /><span class="explain">{checks.TITLE_EXPLAIN}</span><!-- ENDIF --></dt>

- <dd>{checks.RESULT}</dd>

- </dl>

- <!-- ENDIF -->

- <!-- END checks -->

-

- </fieldset>

-<!-- ENDIF -->

-

-<!-- IF .options -->

- <fieldset>

-

- <!-- BEGIN options -->

- <!-- IF options.S_LEGEND -->

- <!-- IF not options.S_FIRST_ROW -->

- </fieldset>

-

- <fieldset>

- <!-- ENDIF -->

- <legend>{options.LEGEND}</legend>

- <!-- ELSE -->

-

- <dl>

- <dt><label for="{options.KEY}">{options.TITLE}{L_COLON}</label><!-- IF options.S_EXPLAIN --><br /><span class="explain">{options.TITLE_EXPLAIN}</span><!-- ENDIF --></dt>

- <dd>{options.CONTENT}</dd>

- </dl>

-

- <!-- ENDIF -->

- <!-- END options -->

-

- </fieldset>

-<!-- ENDIF -->

-

-<!-- IF S_SHOW_DOWNLOAD -->

- <h1>{L_DL_CONFIG}</h1>

- <p>{L_DL_CONFIG_EXPLAIN}</p>

-

- <fieldset class="submit-buttons">

- <legend>{L_DL_CONFIG}</legend>

- {S_HIDDEN}

- <input class="button1" type="submit" id="dlconfig" name="dlconfig" value="{L_DL_DOWNLOAD}" />&nbsp;<input class="button1" type="submit" id="dldone" name="dldone" value="{L_DL_DONE}" />

- </fieldset>

-<!-- ENDIF -->

-

-<!-- IF L_SUBMIT -->

- <fieldset class="submit-buttons">

- <legend>{L_SUBMIT}</legend>

- {S_HIDDEN}

- <!-- IF L_SUBMIT --><input class="button1" type="submit" id="submit" onclick="this.className = 'button1 disabled';" name="submit" value="{L_SUBMIT}" /><!-- ENDIF -->

- </fieldset>

-<!-- ENDIF -->

-

-</form>

-

-<!-- INCLUDE install_footer.html -->

-<!-- INCLUDE install_header.html -->

-

- <h1>{TITLE}</h1>

- <p>{BODY}</p>

-

-<!-- INCLUDE install_footer.html -->

-<!-- INCLUDE install_header.html -->

-

-<script type="text/javascript">

-// <![CDATA[

- function popup(url, width, height, name)

- {

- if (!name)

- {

- name = '_popup';

- }

-

- window.open(url.replace(/&amp;/g, '&'), name, 'height=' + height + ',resizable=yes,scrollbars=yes, width=' + width);

- return false;

- }

-

- function diff_popup(url)

- {

- popup(url, 950, 600, '_diff');

- return false;

- }

-// ]]>

-</script>

-

-<!-- IF S_ERROR -->

- <div class="errorbox" style="margin-top: 0;">

- <h3>{L_NOTICE}</h3>

- <p>{ERROR_MSG}</p>

- </div>

-<!-- ENDIF -->

-

-<!-- IF S_IN_PROGRESS -->

-

- <div class="successbox" style="margin-top: 0;">

- <h3>{L_IN_PROGRESS}</h3>

- <p>{L_IN_PROGRESS_EXPLAIN}</p>

- </div>

-

-<!-- ELSEIF S_INTRO -->

-

- <!-- IF S_WARNING -->

- <div class="successbox" style="margin-top: 0;">

- <h3>{L_NOTICE}</h3>

- <p>{WARNING_MSG}</p>

- </div>

- <!-- ENDIF -->

-

- <div class="errorbox" style="margin-top: 0;">

- <h3>{L_NOTICE}</h3>

- <p>{L_BACKUP_NOTICE}</p>

- </div>

-

- <form id="install_update" method="post" action="{U_ACTION}">

-

- <h1>{L_UPDATE_INSTALLATION}</h1>

- <p>{L_UPDATE_INSTALLATION_EXPLAIN}</p>

-

- <fieldset class="submit-buttons">

- <input class="button1" type="submit" name="submit" value="{L_NEXT_STEP}" />

- </fieldset>

-

- </form>

-

-<!-- ELSEIF S_UPLOAD_SUCCESS -->

-

- <form id="install_update" method="post" action="{U_ACTION}">

-

- <h1>{L_UPDATE_SUCCESS}</h1>

- <p>{L_UPDATE_SUCCESS_EXPLAIN}</p>

-

- <fieldset class="submit-buttons">

- <input class="button1" type="submit" name="check_again" value="{L_CONTINUE_UPDATE}" />

- </fieldset>

-

- </form>

-

-<!-- ENDIF -->

-

-<!-- IF S_VERSION_CHECK -->

-

- <h1>{L_VERSION_CHECK}</h1>

-

- <p>{L_VERSION_CHECK_EXPLAIN}</p>

-

- <!-- IF S_UP_TO_DATE -->

- <div class="successbox">

- <p>{L_VERSION_UP_TO_DATE}</p>

- </div>

- <!-- ELSE -->

- <div class="errorbox">

- <p>{L_VERSION_NOT_UP_TO_DATE}</p>

- </div>

- <!-- ENDIF -->

-

- <fieldset>

- <legend></legend>

- <dl>

- <dt><label>{L_CURRENT_VERSION}</label></dt>

- <dd><strong>{CURRENT_VERSION}</strong></dd>

- </dl>

- <dl>

- <dt><label>{L_LATEST_VERSION}</label></dt>

- <dd><strong>{LATEST_VERSION}</strong></dd>

- </dl>

- <!-- IF PACKAGE_VERSION and not S_UP_TO_DATE -->

- <dl>

- <dt><label>{L_PACKAGE_UPDATES_TO}</label></dt>

- <dd><strong>{PACKAGE_VERSION}</strong></dd>

- </dl>

- <!-- ENDIF -->

- </fieldset>

-

- <form id="install_update" method="post" action="{U_ACTION}">

-

- <fieldset class="submit-buttons">

- <p>{L_CHECK_FILES_EXPLAIN}</p>

- <input class="button1" type="submit" name="submit" value="{L_CHECK_FILES}" />

- </fieldset>

-

- </form>

-

-<!-- ELSEIF S_DB_UPDATE -->

-

- <!-- IF not S_DB_UPDATE_FINISHED -->

-

- <h1>{L_PERFORM_DATABASE_UPDATE}</h1>

-

- <p>

- {L_PERFORM_DATABASE_UPDATE_EXPLAIN}<br />

- </p>

-

- <br /><br />

-

- <form id="install_dbupdate" method="post" action="{U_DB_UPDATE_ACTION}">

-

- <fieldset class="submit-buttons">

- <a href="{U_DB_UPDATE}" class="button1">{L_RUN_DATABASE_SCRIPT}</a>

-

- <!-- input class="button1" type="submit" name="db_update" value="{L_CHECK_UPDATE_DATABASE}" / -->

- </fieldset>

-

- </form>

-

- <!-- ELSE -->

-

- <div class="successbox">

- <h3>{L_UPDATE_SUCCESS}</h3>

- <p>{L_EVERYTHING_UP_TO_DATE}</p>

- </div>

-

- <!-- ENDIF -->

-

-<!-- ELSEIF S_FILE_CHECK -->

-

- <!-- IF S_ALL_UP_TO_DATE -->

-

- <h1>{L_UPDATE_FILE_SUCCESS}</h1>

- <p>{L_ALL_FILES_UP_TO_DATE}</p>

-

- <p>{L_UPDATE_DATABASE_EXPLAIN}</p>

-

- <form id="install_dbupdate" method="post" action="{U_DB_UPDATE_ACTION}">

-

- <fieldset class="submit-buttons">

- <input class="button1" type="submit" name="db_update" value="{L_UPDATE_DATABASE}" />

- </fieldset>

-

- </form>

-

- <!-- ELSE -->

- <h1>{L_COLLECTED_INFORMATION}</h1>

-

- <p>{L_COLLECTED_INFORMATION_EXPLAIN}</p>

-

- <!-- IF S_NO_UPDATE_FILES -->

- <div class="errorbox">

- <h3>{L_NO_UPDATE_FILES}</h3>

-

- <p>{L_NO_UPDATE_FILES_EXPLAIN}</p><br />

-

- <strong>{NO_UPDATE_FILES}</strong>

-

- </div>

- <!-- ENDIF -->

-

- <form id="install_update" method="post" action="{U_UPDATE_ACTION}">

-

- <!-- IF .deleted -->

- <h2>{L_FILES_DELETED}</h2>

- <div style="float: {S_CONTENT_FLOW_END};">&raquo; <a href="#" onclick="phpbb.toggleDisplay('deleted', 0); return false;">{L_TOGGLE_DISPLAY}</a></div>

- <p>{L_FILES_DELETED_EXPLAIN}</p>

-

- <fieldset id="deleted">

- <legend><img src="{T_IMAGE_PATH}icon_delete.gif" alt="{L_STATUS_DELETED}" /></legend>

- <!-- BEGIN deleted -->

- <dl>

- <dt style="width: 60%;"><strong><!-- IF deleted.DIR_PART -->{deleted.DIR_PART}<br /><!-- ENDIF -->{deleted.FILE_PART}</strong></dt>

- <dd style="margin-{S_CONTENT_FLOW_BEGIN}: 60%;">

- <!-- IF not deleted.S_BINARY -->[<a href="{deleted.U_SHOW_DIFF}" onclick="diff_popup(this.href); return false;">{deleted.L_SHOW_DIFF}</a>]<!-- ELSE -->{L_BINARY_FILE}<!-- ENDIF -->

- </dd>

- </dl>

- <!-- END deleted -->

- </fieldset>

-

- <!-- ENDIF -->

-

- <!-- IF .conflict -->

- <h2>{L_FILES_CONFLICT}</h2>

- <div style="float: {S_CONTENT_FLOW_END};">&raquo; <a href="#" onclick="phpbb.toggleDisplay('conflict', 0); return false;">{L_TOGGLE_DISPLAY}</a></div>

- <p>{L_FILES_CONFLICT_EXPLAIN}</p>

-

- <!-- BEGIN conflict -->

- <fieldset id="conflict">

- <legend><img src="{T_IMAGE_PATH}file_conflict.gif" alt="{L_STATUS_CONFLICT}" /></legend>

- <dl>

- <dt style="width: 60%;"><strong><!-- IF conflict.DIR_PART -->{conflict.DIR_PART}<br /><!-- ENDIF -->{conflict.FILE_PART}</strong>

- <!-- IF conflict.S_CUSTOM --><br /><span><em>{L_FILE_USED}{L_COLON} </em>{conflict.CUSTOM_ORIGINAL}</span><!-- ENDIF -->

- <!-- IF conflict.NUM_CONFLICTS --><br /><span>{L_NUM_CONFLICTS}{L_COLON} {conflict.NUM_CONFLICTS}</span><!-- ENDIF -->

- </dt>

- <dd style="margin-{S_CONTENT_FLOW_BEGIN}{L_COLON} 60%;">

- <!-- IF not conflict.S_BINARY -->[<a href="{conflict.U_SHOW_DIFF}">{L_DOWNLOAD_CONFLICTS}</a>]<br />{L_DOWNLOAD_CONFLICTS_EXPLAIN}

- <!-- ELSE -->{L_BINARY_FILE}<!-- ENDIF -->

- </dd>

- <!-- IF conflict.S_CUSTOM -->

- <dd style="margin-{S_CONTENT_FLOW_BEGIN}{L_COLON} 60%;"><label><input type="checkbox" name="no_update[]" value="{conflict.FILENAME}" class="radio" /> {L_DO_NOT_UPDATE}</label></dd>

- <!-- ENDIF -->

- </dl>

- <!-- IF conflict.S_BINARY -->

- <dl>

- <dt style="width: 60%"><label><input type="radio" class="radio" name="conflict[{conflict.FILENAME}]" value="1" checked="checked" /> {L_MERGE_NO_MERGE_NEW_OPTION}</label></dt>

- <dd style="margin-{S_CONTENT_FLOW_BEGIN}{L_COLON} 60%;">&nbsp;</dd>

- </dl>

- <!-- ELSE -->

- <dl>

- <dt style="width: 60%"><label><input type="radio" class="radio" name="conflict[{conflict.FILENAME}]" value="3" checked="checked" /> {L_MERGE_NEW_FILE_OPTION}</label></dt>

- <dd style="margin-{S_CONTENT_FLOW_BEGIN}{L_COLON} 60%;">[<a href="{conflict.U_VIEW_NEW_FILE}" onclick="diff_popup(this.href); return false;">{L_SHOW_DIFF_MODIFIED}</a>]</dd>

- </dl>

- <dl>

- <dt style="width: 60%"><label><input type="radio" class="radio" name="conflict[{conflict.FILENAME}]" value="4" /> {L_MERGE_MOD_FILE_OPTION}</label></dt>

- <dd style="margin-{S_CONTENT_FLOW_BEGIN}{L_COLON} 60%;">[<a href="{conflict.U_VIEW_MOD_FILE}" onclick="diff_popup(this.href); return false;">{L_SHOW_DIFF_MODIFIED}</a>]</dd>

- </dl>

- <dl>

- <dt style="width: 60%"><label><input type="radio" class="radio" name="conflict[{conflict.FILENAME}]" value="1" /> {L_MERGE_NO_MERGE_NEW_OPTION}</label></dt>

- <dd style="margin-{S_CONTENT_FLOW_BEGIN}{L_COLON} 60%;">[<a href="{conflict.U_VIEW_NO_MERGE_NEW}" onclick="diff_popup(this.href); return false;">{L_SHOW_DIFF_FINAL}</a>]</dd>

- </dl>

- <dl>

- <dt style="width: 60%"><label><input type="radio" class="radio" name="conflict[{conflict.FILENAME}]" value="2" /> {L_MERGE_NO_MERGE_MOD_OPTION}</label></dt>

- <dd style="margin-{S_CONTENT_FLOW_BEGIN}{L_COLON} 60%;">[<a href="{conflict.U_VIEW_NO_MERGE_MOD}" onclick="diff_popup(this.href); return false;">{L_SHOW_DIFF_FINAL}</a>]</dd>

- </dl>

- <!-- ENDIF -->

- </fieldset>

- <!-- END conflict -->

-

- <!-- ENDIF -->

-

- <!-- IF .new_conflict -->

- <h2>{L_FILES_NEW_CONFLICT}</h2>

- <div style="float: {S_CONTENT_FLOW_END};">&raquo; <a href="#" onclick="phpbb.toggleDisplay('new_conflict', 0); return false;">{L_TOGGLE_DISPLAY}</a></div>

- <p>{L_FILES_NEW_CONFLICT_EXPLAIN}</p>

-

- <fieldset id="new_conflict">

- <legend><img src="{T_IMAGE_PATH}file_new_conflict.gif" alt="{L_STATUS_NEW_CONFLICT}" /></legend>

- <!-- BEGIN new_conflict -->

- <dl>

- <dt style="width: 60%;"><strong><!-- IF new_conflict.DIR_PART -->{new_conflict.DIR_PART}<br /><!-- ENDIF -->{new_conflict.FILE_PART}</strong>

- <!-- IF new_conflict.S_CUSTOM --><br /><span><em>{L_FILE_USED}{L_COLON} </em>{new_conflict.CUSTOM_ORIGINAL}</span><!-- ENDIF -->

- </dt>

- <dd style="margin-{S_CONTENT_FLOW_BEGIN}{L_COLON} 60%;">

- <!-- IF not new_conflict.S_BINARY -->[<a href="{new_conflict.U_SHOW_DIFF}" onclick="diff_popup(this.href); return false;">{new_conflict.L_SHOW_DIFF}</a>]<!-- ELSE -->{L_BINARY_FILE}<!-- ENDIF -->

- </dd>

- <!-- IF new_conflict.S_CUSTOM -->

- <dd style="margin-{S_CONTENT_FLOW_BEGIN}{L_COLON} 60%;"><label><input type="checkbox" name="no_update[]" value="{new_conflict.FILENAME}" class="radio" /> {L_DO_NOT_UPDATE}</label></dd>

- <!-- ENDIF -->

- </dl>

- <!-- END new_conflict -->

- </fieldset>

-

- <!-- ENDIF -->

-

- <!-- IF .modified -->

- <h2>{L_FILES_MODIFIED}</h2>

- <div style="float: {S_CONTENT_FLOW_END};">&raquo; <a href="#" onclick="phpbb.toggleDisplay('modified', 0); return false;">{L_TOGGLE_DISPLAY}</a></div>

- <p>{L_FILES_MODIFIED_EXPLAIN}</p>

-

- <!-- BEGIN modified -->

- <fieldset id="modified">

- <legend><img src="{T_IMAGE_PATH}file_modified.gif" alt="{L_STATUS_MODIFIED}" /></legend>

- <dl>

- <dt style="width: 60%;"><strong><!-- IF modified.DIR_PART -->{modified.DIR_PART}<br /><!-- ENDIF -->{modified.FILE_PART}</strong>

- <!-- IF modified.S_CUSTOM --><br /><span><em>{L_FILE_USED}{L_COLON} </em>{modified.CUSTOM_ORIGINAL}</span><!-- ENDIF -->

- </dt>

- <dd style="margin-{S_CONTENT_FLOW_BEGIN}{L_COLON} 60%;">&nbsp;</dd>

- <!-- IF modified.S_CUSTOM -->

- <dd style="margin-{S_CONTENT_FLOW_BEGIN}{L_COLON} 60%;"><label><input type="checkbox" name="no_update[]" value="{modified.FILENAME}" class="radio" /> {L_DO_NOT_UPDATE}</label></dd>

- <!-- ENDIF -->

- </dl>

- <dl>

- <dt style="width: 60%"><label><input type="radio" class="radio" name="modified[{modified.FILENAME}]" value="0" checked="checked" /> {L_MERGE_MODIFICATIONS_OPTION}</label></dt>

- <dd style="margin-{S_CONTENT_FLOW_BEGIN}{L_COLON} 60%;"><!-- IF not modified.S_BINARY -->[<a href="{modified.U_SHOW_DIFF}" onclick="diff_popup(this.href); return false;">{modified.L_SHOW_DIFF}</a>]<!-- ELSE -->{L_BINARY_FILE}<!-- ENDIF --></dd>

- </dl>

- <dl>

- <dt style="width: 60%"><label><input type="radio" class="radio" name="modified[{modified.FILENAME}]" value="1" /> {L_MERGE_NO_MERGE_NEW_OPTION}</label></dt>

- <dd style="margin-{S_CONTENT_FLOW_BEGIN}{L_COLON} 60%;"><!-- IF not modified.S_BINARY -->[<a href="{modified.U_VIEW_NO_MERGE_NEW}" onclick="diff_popup(this.href); return false;">{L_SHOW_DIFF_FINAL}</a>]<!-- ELSE -->&nbsp;<!-- ENDIF --></dd>

- </dl>

- <dl>

- <dt style="width: 60%"><label><input type="radio" class="radio" name="modified[{modified.FILENAME}]" value="2" /> {L_MERGE_NO_MERGE_MOD_OPTION}</label></dt>

- <dd style="margin-{S_CONTENT_FLOW_BEGIN}{L_COLON} 60%;"><!-- IF not modified.S_BINARY -->[<a href="{modified.U_VIEW_NO_MERGE_MOD}" onclick="diff_popup(this.href); return false;">{L_SHOW_DIFF_FINAL}</a>]<!-- ELSE -->&nbsp;<!-- ENDIF --></dd>

- </dl>

- </fieldset>

- <!-- END modified -->

-

- <!-- ENDIF -->

-

- <!-- IF .new -->

- <h2>{L_FILES_NEW}</h2>

- <div style="float: {S_CONTENT_FLOW_END};">&raquo; <a href="#" onclick="phpbb.toggleDisplay('new_files', 0); return false;">{L_TOGGLE_DISPLAY}</a></div>

- <p>{L_FILES_NEW_EXPLAIN}</p>

-

- <fieldset id="new_files" style="display: none;">

- <legend><img src="{T_IMAGE_PATH}file_new.gif" alt="{L_STATUS_NEW}" /></legend>

- <!-- BEGIN new -->

- <dl>

- <dt style="width: 60%;"><strong><!-- IF new.DIR_PART -->{new.DIR_PART}<br /><!-- ENDIF -->{new.FILE_PART}</strong>

- <!-- IF new.S_CUSTOM --><br /><span><em>{L_FILE_USED}{L_COLON} </em>{new.CUSTOM_ORIGINAL}</span><!-- ENDIF -->

- </dt>

- <dd style="margin-{S_CONTENT_FLOW_BEGIN}{L_COLON} 60%;">

- <!-- IF not new.S_BINARY -->[<a href="{new.U_SHOW_DIFF}" onclick="diff_popup(this.href); return false;">{new.L_SHOW_DIFF}</a>]<!-- ELSE -->{L_BINARY_FILE}<!-- ENDIF -->

- </dd>

- <!-- IF new.S_CUSTOM -->

- <dd style="margin-{S_CONTENT_FLOW_BEGIN}{L_COLON} 60%;"><label><input type="checkbox" name="no_update[]" value="{new.FILENAME}" class="radio" /> {L_DO_NOT_UPDATE}</label></dd>

- <!-- ENDIF -->

- </dl>

- <!-- END new -->

- </fieldset>

-

- <!-- ENDIF -->

-

- <!-- IF .not_modified -->

- <h2>{L_FILES_NOT_MODIFIED}</h2>

- <div style="float: {S_CONTENT_FLOW_END};">&raquo; <a href="#" onclick="phpbb.toggleDisplay('not_modified', 0); return false;">{L_TOGGLE_DISPLAY}</a></div>

- <p>{L_FILES_NOT_MODIFIED_EXPLAIN}</p>

-

- <fieldset id="not_modified" style="display: none;">

- <legend><img src="{T_IMAGE_PATH}file_not_modified.gif" alt="{L_STATUS_NOT_MODIFIED}" /></legend>

- <!-- BEGIN not_modified -->

- <dl>

- <dt style="width: 60%;"><strong><!-- IF not_modified.DIR_PART -->{not_modified.DIR_PART}<br /><!-- ENDIF -->{not_modified.FILE_PART}</strong>

- <!-- IF not_modified.S_CUSTOM --><br /><span><em>{L_FILE_USED}{L_COLON} </em>{not_modified.CUSTOM_ORIGINAL}</span><!-- ENDIF -->

- </dt>

- <dd style="margin-{S_CONTENT_FLOW_BEGIN}{L_COLON} 60%;"><!-- IF not not_modified.S_BINARY -->[<a href="{not_modified.U_SHOW_DIFF}" onclick="diff_popup(this.href); return false;">{not_modified.L_SHOW_DIFF}</a>]<!-- ELSE -->{L_BINARY_FILE}<!-- ENDIF --></dd>

- <!-- IF not_modified.S_CUSTOM -->

- <dd style="margin-{S_CONTENT_FLOW_BEGIN}{L_COLON} 60%;"><label><input type="checkbox" name="no_update[]" value="{not_modified.FILENAME}" class="radio" /> {L_DO_NOT_UPDATE}</label></dd>

- <!-- ENDIF -->

- </dl>

- <!-- END not_modified -->

- </fieldset>

-

- <!-- ENDIF -->

-

- <!-- IF .up_to_date -->

- <h2>{L_FILES_UP_TO_DATE}</h2>

- <div style="float: {S_CONTENT_FLOW_END};">&raquo; <a href="#" onclick="phpbb.toggleDisplay('up_to_date', 0); return false;">{L_TOGGLE_DISPLAY}</a></div>

- <p>{L_FILES_UP_TO_DATE_EXPLAIN}</p>

-

- <fieldset id="up_to_date" style="display: none;">

- <legend><img src="{T_IMAGE_PATH}file_up_to_date.gif" alt="{L_STATUS_UP_TO_DATE}" /></legend>

- <!-- BEGIN up_to_date -->

- <dl>

- <dd class="full" style="text-align: {S_CONTENT_FLOW_BEGIN};"><strong>{up_to_date.FILENAME}</strong></dd>

- </dl>

- <!-- END up_to_date -->

- </fieldset>

-

- <!-- ENDIF -->

-

- <br />

-

- <fieldset class="quick">

- <input class="button1" type="submit" name="check_again" value="{L_CHECK_FILES_AGAIN}" />

- </fieldset>

-

- <br />

-

- <h1>{L_UPDATE_METHOD}</h1>

-

- <p>{L_UPDATE_METHOD_EXPLAIN}</p>

-

- <fieldset class="submit-buttons">

- <input class="button1" type="submit" name="ftp_upload" value="{L_FTP_UPDATE_METHOD}" />&nbsp; &nbsp;<input class="button1" type="submit" name="download" value="{L_DOWNLOAD_UPDATE_METHOD_BUTTON}" />

- </fieldset>

-

- </form>

-

- <!-- ENDIF -->

-

-<!-- ELSEIF S_DOWNLOAD_FILES -->

-

- <h1>{L_DOWNLOAD_UPDATE_METHOD}</h1>

-

- <p>{L_DOWNLOAD_UPDATE_METHOD_EXPLAIN}</p>

-

- <form id="install_update" method="post" action="{U_ACTION}">

-

- <fieldset>

- <legend>{L_SELECT_DOWNLOAD_FORMAT}</legend>

- <dl>

- <dt><label for="use_method">{L_DOWNLOAD_AS}{L_COLON}</label></dt>

- <dd>{RADIO_BUTTONS}</dd>

- </dl>

- </fieldset>

-

- <fieldset class="submit-buttons">

- {S_HIDDEN_FIELDS}

- <input type="submit" class="button2" value="{L_CONTINUE_UPDATE}" name="check_again" />&nbsp; &nbsp;<input type="submit" class="button1" value="{L_DOWNLOAD}" name="download" />

- </fieldset>

-

- </form>

-

- <br /><br />

-

- <p>{L_MAPPING_FILE_STRUCTURE}</p>

-

- <table class="table1">

- <col class="row1" /><col class="row2" /><col class="row1" />

- <thead>

- <tr>

- <th style="width: 49%">{L_ARCHIVE_FILE}</th>

- <th style="width: 2%">&nbsp;</th>

- <th style="width: 49%">{L_DESTINATION}</th>

- </tr>

- </thead>

- <tbody>

- <!-- BEGIN location -->

- <tr>

- <td>{location.SOURCE}</td>

- <td><strong>&raquo;</strong></td>

- <td>{location.DESTINATION}</td>

- </tr>

- <!-- END location -->

- </tbody>

- </table>

-

-<!-- ELSEIF S_FTP_UPLOAD -->

-

- <h1>{L_SELECT_FTP_SETTINGS}</h1>

-

- <form id="install_update" method="post" action="{U_ACTION}">

-

- <!-- IF S_CONNECTION_SUCCESS -->

- <div class="successbox">

- <p>{L_CONNECTION_SUCCESS}</p>

- </div>

- <!-- ELSEIF S_CONNECTION_FAILED -->

- <div class="successbox">

- <p>{L_TRY_DOWNLOAD_METHOD}</p>

-

- <fieldset class="quick">

- <input class="button1" type="submit" name="download" value="{L_TRY_DOWNLOAD_METHOD_BUTTON}" />

- </fieldset>

- </div>

-

- <div class="errorbox">

- <p>{L_CONNECTION_FAILED}<br />{ERROR_MSG}</p>

- </div>

- <!-- ENDIF -->

-

- <fieldset>

- <legend>{L_FTP_SETTINGS}</legend>

- <dl>

- <dt><label>{L_UPLOAD_METHOD}{L_COLON}</label></dt>

- <dd><strong>{UPLOAD_METHOD}</strong></dd>

- </dl>

- <!-- BEGIN data -->

- <dl>

- <dt><label for="{data.DATA}">{data.NAME}{L_COLON}</label><br /><span>{data.EXPLAIN}</span></dt>

- <dd><input type="<!-- IF data.DATA == 'password' -->password<!-- ELSE -->text<!-- ENDIF -->" id="{data.DATA}" name="{data.DATA}" value="{data.DEFAULT}" /></dd>

- </dl>

- <!-- END data -->

- </fieldset>

-

- <fieldset class="submit-buttons">

- {S_HIDDEN_FIELDS}

- <input class="button2" type="submit" name="check_again" value="{L_BACK}" />

- <input class="button1" type="submit" name="test_connection" value="{L_TEST_CONNECTION}" />

- <input class="button1" type="submit" name="submit" value="{L_UPDATE_FILES}" />

- </fieldset>

-

- </form>

-

-<!-- ENDIF -->

-

-<!-- INCLUDE install_footer.html -->

-<!DOCTYPE html>

-<html dir="{S_CONTENT_DIRECTION}" lang="{S_USER_LANG}">

-<head>

-<meta charset="utf-8">

-<meta name="viewport" content="width=device-width, initial-scale=1" />

-<!-- IF META -->{META}<!-- ENDIF -->

-<title>{PAGE_TITLE}</title>

-

-<link href="{T_TEMPLATE_PATH}/admin.css" rel="stylesheet" type="text/css" media="screen" />

-

-<script type="text/javascript">

-// <![CDATA[

-function resize_panel()

-{

- var block = document.getElementById('diff_content');

- var height;

-

- if (window.innerHeight)

- {

- height = window.innerHeight - 200;

- block.style.height = height + 'px';

- }

- else

- {

- //whatever IE needs to do this

- }

-}

-

-window.onresize = resize_panel;

-

-// ]]>

-</script>

-

-<style type="text/css">

-/* <![CDATA[ */

-

-#main, .rtl #main {

- font-size: 1em;

- line-height: 0.7em;

- margin: 0;

- padding: 0;

- width: 99%;

-}

-

-#diff_content {

- padding: 30px 10px 10px;

- overflow: hidden;

-}

-

-<!-- IF DIFF_MODE neq 'side_by_side' and DIFF_MODE neq 'raw' -->

-div#codepanel {

- width: 100%;

-}

-<!-- ELSE -->

-div#codepanel {

- background-color: #eee;

-}

-<!-- ENDIF -->

-

-<!-- IF DIFF_MODE neq 'unified' and DIFF_MODE neq 'side_by_side' -->

-div#diff_content pre {

- overflow: auto;

- height: 414px;

- width: 100% !important;

-}

-<!-- ENDIF -->

-

-<!-- IF not S_DIFF_NEW_FILE -->

-/**

-* Unified Diff

-*/

-.file {

- line-height: .7em;

- overflow: auto;

- height: 414px;

-}

-

-.diff {

- margin: 0;

-}

-

-.added {

- background-color: #dfd;

-}

-

-.removed {

- background-color: #fdd;

-}

-

-.info {

- color: #888;

-}

-

-.context {

- background-color: #eee;

-}

-

-/**

-* Inline Diff

-*/

-.ins {

- background-color: #dfd;

- text-decoration: underline;

-}

-

-.del {

- background-color: #fdd;

- text-decoration: line-through;

-}

-

-/**

-* Column Diff

-*/

-table.hrdiff {

- margin: 0 0 8px 5px;

- width: 100%;

- overflow: hidden;

- border-bottom: 1px solid #999;

- table-layout: fixed;

- background: transparent;

-}

-

-table.hrdiff th {

- text-align: left;

- width: 50%;

- color: #333;

- font-family: Verdana,Helvetica,sans-serif;

- font-size: 11px;

- border-bottom: 1px solid #999;

- border-right: 1px solid #999;

- background: #D9D9D9;

-}

-

-table.hrdiff thead th {

- font-weight: bold;

- font-size: 110%;

- padding: 2px;

-}

-

-table.hrdiff tr:first-child th {

- border-top: none;

-}

-

-table.hrdiff tbody th {

- font-size: 80%;

- border-top: 1px solid #999;

-}

-

-table.hrdiff tbody td {

- border-right: 1px solid #999;

-}

-

-table.hrdiff td pre {

- font-family: "Consolas", monospace;

- font-size: 1.1em;

- white-space: pre-wrap; /* css-3 */

- word-wrap: break-word; /* Internet Explorer 5.5+ */

-}

-

-table.hrdiff .unmodified {

- background: transparent;

-}

-

-table.hrdiff .added {

- background: #9f9;

-}

-

-table.hrdiff .added_empty {

- background: #cfc;

-}

-

-table.hrdiff .modified {

- background: #fd9;

-}

-

-table.hrdiff .removed {

- background: #f99;

-}

-

-table.hrdiff .removed_empty {

- background: #fcc;

-}

-

-table.hrdiff caption {

- caption-side: top;

- text-align: left;

- margin: 0 0 8px 5px;

- font-size: 90%;

- font-weight: bold;

- padding: 5px;

-}

-

-table.hrdiff caption span {

- height: 10px;

- width: 10px;

- line-height: 10px;

- letter-spacing: 10px;

- border: 1px solid #000;

- margin-left: 0.5em;

- vertical-align: baseline;

-}

-

-<!-- ENDIF -->

-

-/* ]]> */

-</style>

-

-</head>

-

-<!-- IF DIFF_MODE neq 'side_by_side' and DIFF_MODE neq 'raw' -->

-<body onload="resize_panel();">

-<!-- ELSE -->

-<body>

-<!-- ENDIF -->

-

-<div id="wrap">

- <div id="page-header">

-<!-- IF S_DIFF_NEW_FILE -->

-

- <h1>{L_VIEWING_FILE_CONTENTS}</h1>

-<!-- ELSE -->

- <h1>{L_VIEWING_FILE_DIFF}</h1>

-<!-- ENDIF -->

-<!-- IF not S_DIFF_NEW_FILE -->

- <p id="skip"><a href="#acp">{L_SKIP}</a></p>

- <form method="post" action="#">

- <fieldset class="quick">

- <label for="diff_mode">{L_SELECT_DIFF_MODE}{L_COLON}</label>

- <select name="diff_mode" id="diff_mode">{S_DIFF_MODE_OPTIONS}</select>

-

- <input class="button1" type="submit" id="submit" name="submit" value="{L_CHANGE}" />

- </fieldset>

- </form>

-<!-- ENDIF -->

-<!-- IF S_DIFF_CONFLICT_FILE -->

- <div style="float: {S_CONTENT_FLOW_BEGIN};"><strong>{L_NUM_CONFLICTS}{L_COLON} {NUM_CONFLICTS}</strong></div>

- <br style="clear: both;" />

-<!-- ENDIF -->

- </div>

-

- <div id="page-body">

- <div id="acp">

- <div id="codepanel">

- <div id="diff_content">

- <div id="main">

- {DIFF_CONTENT}

- </div>

- </div>

- </div>

- </div>

- </div>

-

-

-<!-- INCLUDE simple_footer.html -->

- $script_path = trim(dirname($script_name)) . '/' . $phpbb_root_path . 'install/index.' . $phpEx;

- $update_link = append_sid($phpbb_root_path . 'install/index.' . $phpEx, 'mode=update');

-<?php

-/**

-*

-* This file is part of the phpBB Forum Software package.

-*

-* @copyright (c) phpBB Limited <https://www.phpbb.com>

-* @license GNU General Public License, version 2 (GPL-2.0)

-*

-* For full copyright and license information, please see

-* the docs/CREDITS.txt file.

-*

-*/

-

-/**

-* @ignore

-*/

-if (!defined('IN_PHPBB'))

-{

- exit;

-}

-

-/**

-* Returns an array of available DBMS with some data, if a DBMS is specified it will only

-* return data for that DBMS and will load its extension if necessary.

-*/

-function get_available_dbms($dbms = false, $return_unavailable = false, $only_20x_options = false)

-{

- global $lang;

- $available_dbms = array(

- // Note: php 5.5 alpha 2 deprecated mysql.

- // Keep mysqli before mysql in this list.

- 'mysqli' => array(

- 'LABEL' => 'MySQL with MySQLi Extension',

- 'SCHEMA' => 'mysql_41',

- 'MODULE' => 'mysqli',

- 'DELIM' => ';',

- 'DRIVER' => 'phpbb\db\driver\mysqli',

- 'AVAILABLE' => true,

- '2.0.x' => true,

- ),

- 'mysql' => array(

- 'LABEL' => 'MySQL',

- 'SCHEMA' => 'mysql',

- 'MODULE' => 'mysql',

- 'DELIM' => ';',

- 'DRIVER' => 'phpbb\db\driver\mysql',

- 'AVAILABLE' => true,

- '2.0.x' => true,

- ),

- 'mssql' => array(

- 'LABEL' => 'MS SQL Server 2000+',

- 'SCHEMA' => 'mssql',

- 'MODULE' => 'mssql',

- 'DELIM' => 'GO',

- 'DRIVER' => 'phpbb\db\driver\mssql',

- 'AVAILABLE' => true,

- '2.0.x' => true,

- ),

- 'mssql_odbc'=> array(

- 'LABEL' => 'MS SQL Server [ ODBC ]',

- 'SCHEMA' => 'mssql',

- 'MODULE' => 'odbc',

- 'DELIM' => 'GO',

- 'DRIVER' => 'phpbb\db\driver\mssql_odbc',

- 'AVAILABLE' => true,

- '2.0.x' => true,

- ),

- 'mssqlnative' => array(

- 'LABEL' => 'MS SQL Server 2005+ [ Native ]',

- 'SCHEMA' => 'mssql',

- 'MODULE' => 'sqlsrv',

- 'DELIM' => 'GO',

- 'DRIVER' => 'phpbb\db\driver\mssqlnative',

- 'AVAILABLE' => true,

- '2.0.x' => false,

- ),

- 'oracle' => array(

- 'LABEL' => 'Oracle',

- 'SCHEMA' => 'oracle',

- 'MODULE' => 'oci8',

- 'DELIM' => '/',

- 'DRIVER' => 'phpbb\db\driver\oracle',

- 'AVAILABLE' => true,

- '2.0.x' => false,

- ),

- 'postgres' => array(

- 'LABEL' => 'PostgreSQL 8.3+',

- 'SCHEMA' => 'postgres',

- 'MODULE' => 'pgsql',

- 'DELIM' => ';',

- 'DRIVER' => 'phpbb\db\driver\postgres',

- 'AVAILABLE' => true,

- '2.0.x' => true,

- ),

- 'sqlite' => array(

- 'LABEL' => 'SQLite',

- 'SCHEMA' => 'sqlite',

- 'MODULE' => 'sqlite',

- 'DELIM' => ';',

- 'DRIVER' => 'phpbb\db\driver\sqlite',

- 'AVAILABLE' => true,

- '2.0.x' => false,

- ),

- 'sqlite3' => array(

- 'LABEL' => 'SQLite3',

- 'SCHEMA' => 'sqlite',

- 'MODULE' => 'sqlite3',

- 'DELIM' => ';',

- 'DRIVER' => 'phpbb\db\driver\sqlite3',

- 'AVAILABLE' => true,

- '2.0.x' => false,

- ),

- );

-

- if ($dbms)

- {

- if (isset($available_dbms[$dbms]))

- {

- $available_dbms = array($dbms => $available_dbms[$dbms]);

- }

- else

- {

- return array();

- }

- }

-

- // now perform some checks whether they are really available

- foreach ($available_dbms as $db_name => $db_ary)

- {

- if ($only_20x_options && !$db_ary['2.0.x'])

- {

- if ($return_unavailable)

- {

- $available_dbms[$db_name]['AVAILABLE'] = false;

- }

- else

- {

- unset($available_dbms[$db_name]);

- }

- continue;

- }

-

- $dll = $db_ary['MODULE'];

-

- if (!@extension_loaded($dll))

- {

- if ($return_unavailable)

- {

- $available_dbms[$db_name]['AVAILABLE'] = false;

- }

- else

- {

- unset($available_dbms[$db_name]);

- }

- continue;

- }

- $any_db_support = true;

- }

-

- if ($return_unavailable)

- {

- $available_dbms['ANY_DB_SUPPORT'] = $any_db_support;

- }

- return $available_dbms;

-}

-

-/**

-* Generate the drop down of available database options

-*/

-function dbms_select($default = '', $only_20x_options = false)

-{

- global $lang;

-

- $available_dbms = get_available_dbms(false, false, $only_20x_options);

- $dbms_options = '';

- foreach ($available_dbms as $dbms_name => $details)

- {

- $selected = ($dbms_name == $default) ? ' selected="selected"' : '';

- $dbms_options .= '<option value="' . $dbms_name . '"' . $selected .'>' . $lang['DLL_' . strtoupper($dbms_name)] . '</option>';

- }

- return $dbms_options;

-}

-

-/**

-* Used to test whether we are able to connect to the database the user has specified

-* and identify any problems (eg there are already tables with the names we want to use

-* @param array $dbms should be of the format of an element of the array returned by {@link get_available_dbms get_available_dbms()}

-* necessary extensions should be loaded already

-*/

-function connect_check_db($error_connect, &$error, $dbms_details, $table_prefix, $dbhost, $dbuser, $dbpasswd, $dbname, $dbport, $prefix_may_exist = false, $load_dbal = true, $unicode_check = true)

-{

- global $phpbb_root_path, $phpEx, $config, $lang, $phpbb_filesystem;

-

- $dbms = $dbms_details['DRIVER'];

-

- // Instantiate it and set return on error true

- $db = new $dbms();

- $db->sql_return_on_error(true);

-

- // Check that we actually have a database name before going any further.....

- if ($dbms_details['DRIVER'] != 'phpbb\db\driver\sqlite' && $dbms_details['DRIVER'] != 'phpbb\db\driver\sqlite3' && $dbms_details['DRIVER'] != 'phpbb\db\driver\oracle' && $dbname === '')

- {

- $error[] = $lang['INST_ERR_DB_NO_NAME'];

- return false;

- }

-

- // Make sure we don't have a daft user who thinks having the SQLite database in the forum directory is a good idea

- if (($dbms_details['DRIVER'] == 'phpbb\db\driver\sqlite' || $dbms_details['DRIVER'] == 'phpbb\db\driver\sqlite3') && stripos($phpbb_filesystem->realpath($dbhost), $phpbb_filesystem->realpath('../')) === 0)

- {

- $error[] = $lang['INST_ERR_DB_FORUM_PATH'];

- return false;

- }

-

- // Check the prefix length to ensure that index names are not too long and does not contain invalid characters

- switch ($dbms_details['DRIVER'])

- {

- case 'phpbb\db\driver\mysql':

- case 'phpbb\db\driver\mysqli':

- if (strspn($table_prefix, '-./\\') !== 0)

- {

- $error[] = $lang['INST_ERR_PREFIX_INVALID'];

- return false;

- }

-

- // no break;

-

- case 'phpbb\db\driver\postgres':

- $prefix_length = 36;

- break;

-

- case 'phpbb\db\driver\mssql':

- case 'phpbb\db\driver\mssql_odbc':

- case 'phpbb\db\driver\mssqlnative':

- $prefix_length = 90;

- break;

-

- case 'phpbb\db\driver\sqlite':

- case 'phpbb\db\driver\sqlite3':

- $prefix_length = 200;

- break;

-

- case 'phpbb\db\driver\oracle':

- $prefix_length = 6;

- break;

- }

-

- if (strlen($table_prefix) > $prefix_length)

- {

- $error[] = sprintf($lang['INST_ERR_PREFIX_TOO_LONG'], $prefix_length);

- return false;

- }

-

- // Try and connect ...

- if (is_array($db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false, true)))

- {

- $db_error = $db->sql_error();

- $error[] = $lang['INST_ERR_DB_CONNECT'] . '<br />' . (($db_error['message']) ? utf8_convert_message($db_error['message']) : $lang['INST_ERR_DB_NO_ERROR']);

- }

- else

- {

- // Likely matches for an existing phpBB installation

- if (!$prefix_may_exist)

- {

- $temp_prefix = strtolower($table_prefix);

- $table_ary = array($temp_prefix . 'attachments', $temp_prefix . 'config', $temp_prefix . 'sessions', $temp_prefix . 'topics', $temp_prefix . 'users');

-

- $db_tools_factory = new \phpbb\db\tools\factory();

- $db_tools = $db_tools_factory->get($db);

- $tables = $db_tools->sql_list_tables();

- $tables = array_map('strtolower', $tables);

- $table_intersect = array_intersect($tables, $table_ary);

-

- if (sizeof($table_intersect))

- {

- $error[] = $lang['INST_ERR_PREFIX'];

- }

- }

-

- // Make sure that the user has selected a sensible DBAL for the DBMS actually installed

- switch ($dbms_details['DRIVER'])

- {

- case 'phpbb\db\driver\mysqli':

- if (version_compare(mysqli_get_server_info($db->get_db_connect_id()), '4.1.3', '<'))

- {

- $error[] = $lang['INST_ERR_DB_NO_MYSQLI'];

- }

- break;

-

- case 'phpbb\db\driver\sqlite':

- if (version_compare(sqlite_libversion(), '2.8.2', '<'))

- {

- $error[] = $lang['INST_ERR_DB_NO_SQLITE'];

- }

- break;

-

- case 'phpbb\db\driver\sqlite3':

- $version = \SQLite3::version();

- if (version_compare($version['versionString'], '3.6.15', '<'))

- {

- $error[] = $lang['INST_ERR_DB_NO_SQLITE3'];

- }

- break;

-

- case 'phpbb\db\driver\oracle':

- if ($unicode_check)

- {

- $sql = "SELECT *

- FROM NLS_DATABASE_PARAMETERS

- WHERE PARAMETER = 'NLS_RDBMS_VERSION'

- OR PARAMETER = 'NLS_CHARACTERSET'";

- $result = $db->sql_query($sql);

-

- while ($row = $db->sql_fetchrow($result))

- {

- $stats[$row['parameter']] = $row['value'];

- }

- $db->sql_freeresult($result);

-

- if (version_compare($stats['NLS_RDBMS_VERSION'], '9.2', '<') && $stats['NLS_CHARACTERSET'] !== 'UTF8')

- {

- $error[] = $lang['INST_ERR_DB_NO_ORACLE'];

- }

- }

- break;

-

- case 'phpbb\db\driver\postgres':

- if ($unicode_check)

- {

- $sql = "SHOW server_encoding;";

- $result = $db->sql_query($sql);

- $row = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

- if ($row['server_encoding'] !== 'UNICODE' && $row['server_encoding'] !== 'UTF8')

- {

- $error[] = $lang['INST_ERR_DB_NO_POSTGRES'];

- }

- }

- break;

- }

-

- }

-

- if ($error_connect && (!isset($error) || !sizeof($error)))

- {

- return true;

- }

- return false;

-}

-

-/**

-* Removes "/* style" as well as "# style" comments from $input.

-*

-* @param string $input Input string

-*

-* @return string Input string with comments removed

-*/

-function phpbb_remove_comments($input)

-{

- // Remove /* */ comments (http://ostermiller.org/findcomment.html)

- $input = preg_replace('#/\*(.|[\r\n])*?\*/#', "\n", $input);

-

- // Remove # style comments

- $input = preg_replace('/\n{2,}/', "\n", preg_replace('/^#.*$/m', "\n", $input));

-

- return $input;

-}

-

-/**

-* split_sql_file will split an uploaded sql file into single sql statements.

-* Note: expects trim() to have already been run on $sql.

-*/

-function split_sql_file($sql, $delimiter)

-{

- $sql = str_replace("\r" , '', $sql);

- $data = preg_split('/' . preg_quote($delimiter, '/') . '$/m', $sql);

-

- $data = array_map('trim', $data);

-

- // The empty case

- $end_data = end($data);

-

- if (empty($end_data))

- {

- unset($data[key($data)]);

- }

-

- return $data;

-}

-

-/**

-* For replacing {L_*} strings with preg_replace_callback

-*/

-function adjust_language_keys_callback($matches)

-{

- if (!empty($matches[1]))

- {

- global $lang, $db;

-

- return (!empty($lang[$matches[1]])) ? $db->sql_escape($lang[$matches[1]]) : $db->sql_escape($matches[1]);

- }

-}

-

-/**

-* Creates the output to be stored in a phpBB config.php file

-*

-* @param array $data Array containing the database connection information

-* @param string $dbms The name of the DBAL class to use

-* @param bool $debug If the debug constants should be enabled by default or not

-* @param bool $debug_container If the container should be compiled on

-* every page load or not

-* @param bool $debug_test If the DEBUG_TEST constant should be added

-* NOTE: Only for use within the testing framework

-*

-* @return string The output to write to the file

-*/

-function phpbb_create_config_file_data($data, $dbms, $debug = false, $debug_container = false, $debug_test = false)

-{

- $config_data = "<?php\n";

- $config_data .= "// phpBB 3.1.x auto-generated configuration file\n// Do not change anything in this file!\n";

-

- $config_data_array = array(

- 'dbms' => $dbms,

- 'dbhost' => $data['dbhost'],

- 'dbport' => $data['dbport'],

- 'dbname' => $data['dbname'],

- 'dbuser' => $data['dbuser'],

- 'dbpasswd' => htmlspecialchars_decode($data['dbpasswd']),

- 'table_prefix' => $data['table_prefix'],

-

- 'phpbb_adm_relative_path' => 'adm/',

-

- 'acm_type' => 'phpbb\cache\driver\file',

- );

-

- foreach ($config_data_array as $key => $value)

- {

- $config_data .= "\${$key} = '" . str_replace("'", "\\'", str_replace('\\', '\\\\', $value)) . "';\n";

- }

-

- $config_data .= "\n@define('PHPBB_INSTALLED', true);\n";

- $config_data .= "// @define('PHPBB_DISPLAY_LOAD_TIME', true);\n";

-

- if ($debug_test)

- {

- $config_data .= "@define('PHPBB_ENVIRONMENT', 'test');\n";

- }

- else if ($debug)

- {

- $config_data .= "@define('PHPBB_ENVIRONMENT', 'development');\n";

- }

- else

- {

- $config_data .= "@define('PHPBB_ENVIRONMENT', 'production');\n";

- }

-

- if ($debug_container)

- {

- $config_data .= "@define('DEBUG_CONTAINER', true);\n";

- }

- else

- {

- $config_data .= "// @define('DEBUG_CONTAINER', true);\n";

- }

-

- if ($debug_test)

- {

- $config_data .= "@define('DEBUG_TEST', true);\n";

- $config_data .= "@define('DEBUG', true);\n"; // Mandatory for the functional tests, will be removed by PHPBB3-12623

- }

-

- return $config_data;

-}

-

-/**

-* Check whether a file should be ignored on update

-*

-* We ignore new files in some circumstances:

-* 1. The file is a language file, but the language is not installed

-* 2. The file is a style file, but the style is not installed

-* 3. The file is a style language file, but the language is not installed

-*

-* @param string $phpbb_root_path phpBB root path

-* @param string $file File including path from phpbb root

-* @return bool Should we ignore the new file or add it to the board?

-*/

-function phpbb_ignore_new_file_on_update($phpbb_root_path, $file)

-{

- $ignore_new_file = false;

-

- // We ignore new files in some circumstances:

- // 1. The file is a language file, but the language is not installed

- if (!$ignore_new_file && strpos($file, 'language/') === 0)

- {

- list($language_dir, $language_iso) = explode('/', $file);

- $ignore_new_file = !file_exists($phpbb_root_path . $language_dir . '/' . $language_iso);

- }

-

- // 2. The file is a style file, but the style is not installed

- if (!$ignore_new_file && strpos($file, 'styles/') === 0)

- {

- list($styles_dir, $style_name) = explode('/', $file);

- $ignore_new_file = !file_exists($phpbb_root_path . $styles_dir . '/' . $style_name);

- }

-

- // 3. The file is a style language file, but the language is not installed

- if (!$ignore_new_file && strpos($file, 'styles/') === 0)

- {

- $dirs = explode('/', $file);

- if (sizeof($dirs) >= 5)

- {

- list($styles_dir, $style_name, $template_component, $language_iso) = explode('/', $file);

- if ($template_component == 'theme' && $language_iso !== 'images')

- {

- $ignore_new_file = !file_exists($phpbb_root_path . 'language/' . $language_iso);

- }

- }

- }

-

- return $ignore_new_file;

-}

-

-/**

-* Check whether phpBB is installed.

-*

-* @param string $phpbb_root_path Path to the phpBB board root.

-* @param string $php_ext PHP file extension.

-*

-* @return bool Returns true if phpBB is installed.

-*/

-function phpbb_check_installation_exists($phpbb_root_path, $php_ext)

-{

- // Try opening config file

- if (file_exists($phpbb_root_path . 'config.' . $php_ext))

- {

- include($phpbb_root_path . 'config.' . $php_ext);

- }

-

- return defined('PHPBB_INSTALLED');

-}

-$startup_new_path = $phpbb_root_path . 'install/update/update/new/install_new/startup.' . $phpEx;

-$startup_path = (file_exists($startup_new_path)) ? $startup_new_path : $phpbb_root_path . 'install_new/startup.' . $phpEx;

-$language->add_lang(array('common', 'acp/common', 'acp/board', 'install_new', 'posting'));

-<?php

-/**

-*

-* This file is part of the phpBB Forum Software package.

-*

-* @copyright (c) phpBB Limited <https://www.phpbb.com>

-* @license GNU General Public License, version 2 (GPL-2.0)

-*

-* For full copyright and license information, please see

-* the docs/CREDITS.txt file.

-*

-*/

-

-$update_start_time = time();

-

-/**

-* @ignore

-*/

-define('IN_PHPBB', true);

-define('IN_INSTALL', true);

-$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './../';

-$phpEx = substr(strrchr(__FILE__, '.'), 1);

-

-function phpbb_end_update($cache, $config)

-{

- $cache->purge();

-

- $config->increment('assets_version', 1);

-

-?>

- </p>

- </div>

- </div>

- <span class="corners-bottom"><span></span></span>

- </div>

- </div>

- </div>

-

- <div id="page-footer">

- <div class="copyright">

- Powered by <a href="https://www.phpbb.com/">phpBB</a>&reg; Forum Software &copy; phpBB Limited

- </div>

- </div>

- </div>

-</body>

-</html>

-

-<?php

-

- garbage_collection();

- exit_handler();

-}

-

-require($phpbb_root_path . 'includes/startup.' . $phpEx);

-require($phpbb_root_path . 'phpbb/class_loader.' . $phpEx);

-

-$phpbb_class_loader = new \phpbb\class_loader('phpbb\\', "{$phpbb_root_path}phpbb/", $phpEx);

-$phpbb_class_loader->register();

-

-$phpbb_config_php_file = new \phpbb\config_php_file($phpbb_root_path, $phpEx);

-extract($phpbb_config_php_file->get_all());

-

-if (!defined('PHPBB_INSTALLED') || empty($dbms) || empty($acm_type))

-{

- die("Please read: <a href='../docs/INSTALL.html'>INSTALL.html</a> before attempting to update.");

-}

-

-// In case $phpbb_adm_relative_path is not set (in case of an update), use the default.

-$phpbb_adm_relative_path = (isset($phpbb_adm_relative_path)) ? $phpbb_adm_relative_path : 'adm/';

-$phpbb_admin_path = (defined('PHPBB_ADMIN_PATH')) ? PHPBB_ADMIN_PATH : $phpbb_root_path . $phpbb_adm_relative_path;

-

-// Include files

-require($phpbb_root_path . 'includes/functions.' . $phpEx);

-require($phpbb_root_path . 'includes/functions_content.' . $phpEx);

-

-require($phpbb_root_path . 'includes/constants.' . $phpEx);

-require($phpbb_root_path . 'includes/utf/utf_tools.' . $phpEx);

-

-// Set PHP error handler to ours

-set_error_handler(defined('PHPBB_MSG_HANDLER') ? PHPBB_MSG_HANDLER : 'msg_handler');

-

-// Set up container (must be done here because extensions table may not exist)

-$phpbb_container_builder = new \phpbb\di\container_builder($phpbb_root_path, $phpEx);

-$phpbb_container = $phpbb_container_builder

- ->with_config($phpbb_config_php_file)

- ->without_extensions()

- ->without_cache()

- ->get_container()

-;

-

-// set up caching

-/* @var $cache \phpbb\cache\service */

-$cache = $phpbb_container->get('cache');

-

-// Instantiate some basic classes

-/* @var $phpbb_dispatcher \phpbb\event\dispatcher */

-$phpbb_dispatcher = $phpbb_container->get('dispatcher');

-

-/* @var $request \phpbb\request\request_interface */

-$request = $phpbb_container->get('request');

-

-/* @var $user \phpbb\user */

-$user = $phpbb_container->get('user');

-

-/* @var $auth \phpbb\auth\auth */

-$auth = $phpbb_container->get('auth');

-

-/* @var $db \phpbb\db\driver\driver_interface */

-$db = $phpbb_container->get('dbal.conn');

-

-/* @var $phpbb_log \phpbb\log\log_interface */

-$phpbb_log = $phpbb_container->get('log');

-

-/** @var \phpbb\language\language $language */

-$language = $phpbb_container->get('language');

-

-// Grab global variables, re-cache if necessary

-/* @var $config \phpbb\config\config */

-$config = $phpbb_container->get('config');

-

-if (!isset($config['version_update_from']))

-{

- $config->set('version_update_from', $config['version']);

-}

-

-$orig_version = $config['version_update_from'];

-

-$user->add_lang(array('common', 'acp/common', 'install', 'migrator'));

-

-// Add own hook handler, if present. :o

-if (file_exists($phpbb_root_path . 'includes/hooks/index.' . $phpEx))

-{

- require($phpbb_root_path . 'includes/hooks/index.' . $phpEx);

- $phpbb_hook = new phpbb_hook(array('exit_handler', 'phpbb_user_session_handler', 'append_sid', array('template', 'display')));

-

- /* @var $phpbb_hook_finder \phpbb\hook\finder */

- $phpbb_hook_finder = $phpbb_container->get('hook_finder');

- foreach ($phpbb_hook_finder->find() as $hook)

- {

- @include($phpbb_root_path . 'includes/hooks/' . $hook . '.' . $phpEx);

- }

-}

-else

-{

- $phpbb_hook = false;

-}

-

-header('Content-type: text/html; charset=UTF-8');

-?>

-<!DOCTYPE html>

-<html dir="<?php echo $user->lang['DIRECTION']; ?>" lang="<?php echo $user->lang['USER_LANG']; ?>">

-<head>

-<meta charset="utf-8">

-

-<title><?php echo $user->lang['UPDATING_TO_LATEST_STABLE']; ?></title>

-

-<link href="<?php echo htmlspecialchars($phpbb_admin_path); ?>style/admin.css" rel="stylesheet" type="text/css" media="screen" />

-

-</head>

-

-<body>

- <div id="wrap">

- <div id="page-header">&nbsp;</div>

-

- <div id="page-body">

- <div id="acp">

- <div class="panel">

- <span class="corners-top"><span></span></span>

- <div id="content">

- <div id="main" class="install-body">

-

- <h1><?php echo $user->lang['UPDATING_TO_LATEST_STABLE']; ?></h1>

-

- <br />

-

- <p><?php echo $user->lang['DATABASE_TYPE']; ?> :: <strong><?php echo $db->get_sql_layer(); ?></strong><br />

- <?php echo $user->lang['PREVIOUS_VERSION']; ?> :: <strong><?php echo $config['version']; ?></strong><br />

-

-<?php

-

-define('IN_DB_UPDATE', true);

-

-/**

-* @todo mysql update?

-*/

-

-// End startup code

-

-/* @var $migrator \phpbb\db\migrator */

-$migrator = $phpbb_container->get('migrator');

-

-/** @var \phpbb\filesystem\filesystem_interface $phpbb_filesystem */

-$phpbb_filesystem = $phpbb_container->get('filesystem');

-$migrator->set_output_handler(new \phpbb\db\output_handler\log_wrapper_migrator_output_handler($language, new \phpbb\db\output_handler\html_migrator_output_handler($language), $phpbb_root_path . 'store/migrations_' . time() . '.log', $phpbb_filesystem));

-

-$migrator->create_migrations_table();

-

-/* @var $phpbb_extension_manager \phpbb\extension\manager */

-$phpbb_extension_manager = $phpbb_container->get('ext.manager');

-

-$migrations = $phpbb_extension_manager

- ->get_finder()

- ->core_path('phpbb/db/migration/data/')

- ->extension_directory('/migrations')

- ->get_classes();

-

-$migrator->set_migrations($migrations);

-

-// What is a safe limit of execution time? Half the max execution time should be safe.

-// No more than 15 seconds so the user isn't sitting and waiting for a very long time

-$phpbb_ini = new \bantu\IniGetWrapper\IniGetWrapper();

-$safe_time_limit = min(15, ($phpbb_ini->getNumeric('max_execution_time') / 2));

-

-// While we're going to try limit this to half the max execution time,

-// we want to try and take additional measures to prevent hitting the

-// max execution time (if, say, one migration step takes much longer

-// than the max execution time)

-@set_time_limit(0);

-

-while (!$migrator->finished())

-{

- try

- {

- $migrator->update();

- }

- catch (\phpbb\db\migration\exception $e)

- {

- echo $e->getLocalisedMessage($user);

-

- phpbb_end_update($cache, $config);

- }

-

- $state = array_merge(array(

- 'migration_schema_done' => false,

- 'migration_data_done' => false,

- ),

- $migrator->last_run_migration['state']

- );

-

- // Are we approaching the time limit? If so we want to pause the update and continue after refreshing

- if ((time() - $update_start_time) >= $safe_time_limit)

- {

- echo '<br />' . $user->lang['DATABASE_UPDATE_NOT_COMPLETED'] . '<br /><br />';

- echo '<a href="' . append_sid($phpbb_root_path . 'install/database_update.' . $phpEx, 'type=' . $request->variable('type', 0) . '&amp;language=' . $request->variable('language', 'en')) . '" class="button1">' . $user->lang['DATABASE_UPDATE_CONTINUE'] . '</a>';

-

- phpbb_end_update($cache, $config);

- }

-}

-

-if ($orig_version != $config['version'])

-{

- $phpbb_log->add('admin', $user->data['user_id'], $user->ip, 'LOG_UPDATE_DATABASE', false, array($orig_version, $config['version']));

-}

-

-echo $user->lang['DATABASE_UPDATE_COMPLETE'] . '<br />';

-

-if ($request->variable('type', 0))

-{

- echo $user->lang['INLINE_UPDATE_SUCCESSFUL'] . '<br /><br />';

- echo '<a href="' . append_sid($phpbb_root_path . 'install/index.' . $phpEx, 'mode=update&amp;sub=update_db&amp;language=' . $request->variable('language', 'en')) . '" class="button1">' . $user->lang['CONTINUE_UPDATE_NOW'] . '</a>';

-}

-else

-{

- echo '<div class="errorbox">' . $user->lang['UPDATE_FILES_NOTICE'] . '</div>';

- echo $user->lang['COMPLETE_LOGIN_TO_BOARD'];

-}

-

-$config->delete('version_update_from');

-

-phpbb_end_update($cache, $config);

-<?php

-/**

-*

-* This file is part of the phpBB Forum Software package.

-*

-* @copyright (c) phpBB Limited <https://www.phpbb.com>

-* @license GNU General Public License, version 2 (GPL-2.0)

-*

-* For full copyright and license information, please see

-* the docs/CREDITS.txt file.

-*

-*/

-

-/**#@+

-* @ignore

-*/

-define('IN_PHPBB', true);

-define('IN_INSTALL', true);

-define('PHPBB_ENVIRONMENT', 'production');

-/**#@-*/

-

-$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './../';

-$phpEx = substr(strrchr(__FILE__, '.'), 1);

-

-if (version_compare(PHP_VERSION, '5.4') < 0)

-{

- die('You are running an unsupported PHP version. Please upgrade to PHP 5.4 or higher before trying to install phpBB 3.2');

-}

-

-function phpbb_require_updated($path, $optional = false)

-{

- global $phpbb_root_path, $table_prefix;

-

- $new_path = $phpbb_root_path . 'install/update/new/' . $path;

- $old_path = $phpbb_root_path . $path;

-

- if (file_exists($new_path))

- {

- require($new_path);

- }

- else if (!$optional || file_exists($old_path))

- {

- require($old_path);

- }

-}

-

-function phpbb_include_updated($path, $optional = false)

-{

- global $phpbb_root_path;

-

- $new_path = $phpbb_root_path . 'install/update/new/' . $path;

- $old_path = $phpbb_root_path . $path;

-

- if (file_exists($new_path))

- {

- include($new_path);

- }

- else if (!$optional || file_exists($old_path))

- {

- include($old_path);

- }

-}

-

-phpbb_require_updated('includes/startup.' . $phpEx);

-

-// Try to override some limits - maybe it helps some...

-@set_time_limit(0);

-$mem_limit = @ini_get('memory_limit');

-if (!empty($mem_limit))

-{

- $unit = strtolower(substr($mem_limit, -1, 1));

- $mem_limit = (int) $mem_limit;

-

- if ($unit == 'k')

- {

- $mem_limit = floor($mem_limit / 1024);

- }

- else if ($unit == 'g')

- {

- $mem_limit *= 1024;

- }

- else if (is_numeric($unit))

- {

- $mem_limit = floor((int) ($mem_limit . $unit) / 1048576);

- }

- $mem_limit = max(128, $mem_limit) . 'M';

-}

-else

-{

- $mem_limit = '128M';

-}

-@ini_set('memory_limit', $mem_limit);

-

-// In case $phpbb_adm_relative_path is not set (in case of an update), use the default.

-$phpbb_adm_relative_path = (isset($phpbb_adm_relative_path)) ? $phpbb_adm_relative_path : 'adm/';

-$phpbb_admin_path = (defined('PHPBB_ADMIN_PATH')) ? PHPBB_ADMIN_PATH : $phpbb_root_path . $phpbb_adm_relative_path;

-

-// Include essential scripts

-phpbb_require_updated('phpbb/class_loader.' . $phpEx);

-

-phpbb_require_updated('includes/functions.' . $phpEx);

-

-phpbb_require_updated('includes/functions_content.' . $phpEx, true);

-

-phpbb_include_updated('includes/functions_admin.' . $phpEx);

-phpbb_include_updated('includes/utf/utf_tools.' . $phpEx);

-phpbb_require_updated('includes/functions_install.' . $phpEx);

-

-// Setup class loader first

-$phpbb_class_loader_new = new \phpbb\class_loader('phpbb\\', "{$phpbb_root_path}install/update/new/phpbb/", $phpEx);

-$phpbb_class_loader_new->register();

-$phpbb_class_loader = new \phpbb\class_loader('phpbb\\', "{$phpbb_root_path}phpbb/", $phpEx);

-$phpbb_class_loader->register();

-$phpbb_class_loader_ext = new \phpbb\class_loader('\\', "{$phpbb_root_path}ext/", $phpEx);

-$phpbb_class_loader_ext->register();

-

-// Set up container

-$phpbb_config_php_file = new \phpbb\config_php_file($phpbb_root_path, $phpEx);

-$phpbb_container_builder = new \phpbb\di\container_builder($phpbb_root_path, $phpEx);

-$phpbb_container_builder

- ->without_extensions()

- ->without_cache()

- ->without_compiled_container()

-;

-

-$other_config_path = $phpbb_root_path . 'install/update/new/config/';

-$config_path = file_exists($other_config_path . 'services.yml') ? $other_config_path : $phpbb_root_path . 'config/';

-$phpbb_container_builder->with_config_path($config_path);

-

-$phpbb_container_builder->with_custom_parameters(array(

- 'core.root_path' => $phpbb_root_path,

- 'core.adm_relative_path' => $phpbb_adm_relative_path,

- 'core.php_ext' => $phpEx,

- 'core.table_prefix' => '',

- 'cache.driver.class' => 'phpbb\cache\driver\file',

-));

-

-$phpbb_container = $phpbb_container_builder->get_container();

-$phpbb_container->register('dbal.conn.driver')->setSynthetic(true);

-$phpbb_container->register('template.twig.environment')->setSynthetic(true);

-$phpbb_container->register('language.loader')->setSynthetic(true);

-$phpbb_container->compile();

-

-$phpbb_class_loader->set_cache($phpbb_container->get('cache.driver'));

-$phpbb_class_loader_ext->set_cache($phpbb_container->get('cache.driver'));

-

-/* @var $phpbb_dispatcher \phpbb\event\dispatcher */

-$phpbb_dispatcher = $phpbb_container->get('dispatcher');

-

-/* @var $request \phpbb\request\request_interface */

-$request = $phpbb_container->get('request');

-

-// Try and load an appropriate language if required

-$language = basename($request->variable('language', ''));

-

-if ($request->header('Accept-Language') && !$language)

-{

- $accept_lang_ary = explode(',', strtolower($request->header('Accept-Language')));

- foreach ($accept_lang_ary as $accept_lang)

- {

- // Set correct format ... guess full xx_yy form

- $accept_lang = substr($accept_lang, 0, 2) . '_' . substr($accept_lang, 3, 2);

-

- if (file_exists($phpbb_root_path . 'language/' . $accept_lang) && is_dir($phpbb_root_path . 'language/' . $accept_lang))

- {

- $language = $accept_lang;

- break;

- }

- else

- {

- // No match on xx_yy so try xx

- $accept_lang = substr($accept_lang, 0, 2);

- if (file_exists($phpbb_root_path . 'language/' . $accept_lang) && is_dir($phpbb_root_path . 'language/' . $accept_lang))

- {

- $language = $accept_lang;

- break;

- }

- }

- }

-}

-

-// No appropriate language found ... so let's use the first one in the language

-// dir, this may or may not be English

-if (!$language)

-{

- $dir = @opendir($phpbb_root_path . 'language');

-

- if (!$dir)

- {

- die('Unable to access the language directory');

- exit;

- }

-

- while (($file = readdir($dir)) !== false)

- {

- $path = $phpbb_root_path . 'language/' . $file;

-

- if (!is_file($path) && !is_link($path) && file_exists($path . '/iso.txt'))

- {

- $language = $file;

- break;

- }

- }

- closedir($dir);

-}

-

-if (!file_exists($phpbb_root_path . 'language/' . $language) || !is_dir($phpbb_root_path . 'language/' . $language))

-{

- die('No language found!');

-}

-

-// And finally, load the relevant language files

-$load_lang_files = array('common', 'acp/common', 'acp/board', 'install', 'posting');

-$new_path = $phpbb_root_path . 'install/update/new/language/' . $language . '/';

-$old_path = $phpbb_root_path . 'language/' . $language . '/';

-

-// NOTE: we can not use "phpbb_include_updated" as the files uses vars which would be required

-// to be global while loading.

-foreach ($load_lang_files as $lang_file)

-{

- if (file_exists($new_path . $lang_file . '.' . $phpEx))

- {

- include($new_path . $lang_file . '.' . $phpEx);

- }

- else

- {

- include($old_path . $lang_file . '.' . $phpEx);

- }

-}

-

-// usually we would need every single constant here - and it would be consistent. For 3.0.x, use a dirty hack... :(

-

-// Define needed constants

-define('CHMOD_ALL', 7);

-define('CHMOD_READ', 4);

-define('CHMOD_WRITE', 2);

-define('CHMOD_EXECUTE', 1);

-

-$mode = $request->variable('mode', 'overview');

-$sub = $request->variable('sub', '');

-

-// Set PHP error handler to ours

-set_error_handler(defined('PHPBB_MSG_HANDLER') ? PHPBB_MSG_HANDLER : 'msg_handler');

-

-$lang_service = new \phpbb\language\language(new \phpbb\language\language_file_loader($phpbb_root_path, $phpEx));

-$lang_service->add_lang($load_lang_files);

-$lang_service->set_user_language($language);

-$user = new \phpbb\user($lang_service, '\phpbb\datetime');

-$auth = new \phpbb\auth\auth();

-

-// Add own hook handler, if present. :o

-if (file_exists($phpbb_root_path . 'includes/hooks/index.' . $phpEx))

-{

- require($phpbb_root_path . 'includes/hooks/index.' . $phpEx);

- $phpbb_hook = new phpbb_hook(array('exit_handler', 'phpbb_user_session_handler', 'append_sid', array('template', 'display')));

-

- /* @var $phpbb_hook_finder \phpbb\hook\finder */

- $phpbb_hook_finder = $phpbb_container->get('hook_finder');

- foreach ($phpbb_hook_finder->find() as $hook)

- {

- @include($phpbb_root_path . 'includes/hooks/' . $hook . '.' . $phpEx);

- }

-}

-else

-{

- $phpbb_hook = false;

-}

-

-// Set some standard variables we want to force

-$config = new \phpbb\config\config(array(

- 'load_tplcompile' => '1'

-));

-

-/* @var $symfony_request \phpbb\symfony_request */

-$symfony_request = $phpbb_container->get('symfony_request');

-

-/* @var $phpbb_filesystem \phpbb\filesystem\filesystem_interface */

-$phpbb_filesystem = $phpbb_container->get('filesystem');

-

-/* @var $phpbb_path_helper \phpbb\path_helper */

-$phpbb_path_helper = $phpbb_container->get('path_helper');

-$cache_path = $phpbb_root_path . 'cache/';

-

-$twig_environment = new \phpbb\template\twig\environment(

- $config,

- $phpbb_filesystem,

- $phpbb_path_helper,

- $phpbb_container,

- $cache_path,

- null,

- $phpbb_container->get('template.twig.loader')

-);

-

-$language_loader = new \phpbb\language\language_file_loader($phpbb_root_path, $phpEx);

-$phpbb_container->set('template.twig.environment', $twig_environment);

-$phpbb_container->set('language.loader', $language_loader);

-$twig_context = new \phpbb\template\context();

-$template = new \phpbb\template\twig\twig(

- $phpbb_path_helper,

- $config,

- $twig_context,

- $twig_environment,

- $cache_path,

- $user,

- array($phpbb_container->get('template.twig.extensions.phpbb'))

-);

-

-/** @var \phpbb\language\language $lang_service */

-$lang_service = $phpbb_container->get('language');

-$lang_service->add_lang($load_lang_files);

-$lang_service->set_user_language($language);

-

-$paths = array($phpbb_root_path . 'install/update/new/adm/style', $phpbb_admin_path . 'style');

-$paths = array_filter($paths, 'is_dir');

-$template->set_custom_style(array(

- array(

- 'name' => 'adm',

- 'ext_path' => 'adm/style/',

- ),

-), $paths);

-

-$path = array_shift($paths);

-

-$template->assign_var('T_ASSETS_PATH', $path . '/../../assets');

-$template->assign_var('T_TEMPLATE_PATH', $path);

-

-$install = new module();

-

-$install->create('install', "index.$phpEx", $mode, $sub);

-$install->load();

-

-// Generate the page

-$install->page_header();

-$install->generate_navigation();

-

-$template->set_filenames(array(

- 'body' => $install->get_tpl_name())

-);

-

-$install->page_footer();

-

-class module

-{

- var $id = 0;

- var $type = 'install';

- var $module_ary = array();

- var $filename;

- var $module_url = '';

- var $tpl_name = '';

- var $mode;

- var $sub;

-

- /**

- * Private methods, should not be overwritten

- */

- function create($module_type, $module_url, $selected_mod = false, $selected_submod = false)

- {

- global $db, $config, $phpEx, $phpbb_root_path;

-

- $module = array();

-

- // Grab module information using Bart's "neat-o-module" system (tm)

- $dir = @opendir('.');

-

- if (!$dir)

- {

- $this->error('Unable to access the installation directory', __LINE__, __FILE__);

- }

-

- $setmodules = 1;

- while (($file = readdir($dir)) !== false)

- {

- if (preg_match('#^install_(.*?)\.' . $phpEx . '$#', $file))

- {

- include($file);

- }

- }

- closedir($dir);

-

- unset($setmodules);

-

- if (!sizeof($module))

- {

- $this->error('No installation modules found', __LINE__, __FILE__);

- }

-

- // Order to use and count further if modules get assigned to the same position or not having an order

- $max_module_order = 1000;

-

- foreach ($module as $row)

- {

- // Module order not specified or module already assigned at this position?

- if (!isset($row['module_order']) || isset($this->module_ary[$row['module_order']]))

- {

- $row['module_order'] = $max_module_order;

- $max_module_order++;

- }

-

- $this->module_ary[$row['module_order']]['name'] = $row['module_title'];

- $this->module_ary[$row['module_order']]['filename'] = $row['module_filename'];

- $this->module_ary[$row['module_order']]['subs'] = $row['module_subs'];

- $this->module_ary[$row['module_order']]['stages'] = $row['module_stages'];

-

- if (strtolower($selected_mod) == strtolower($row['module_title']))

- {

- $this->id = (int) $row['module_order'];

- $this->filename = (string) $row['module_filename'];

- $this->module_url = (string) $module_url;

- $this->mode = (string) $selected_mod;

- // Check that the sub-mode specified is valid or set a default if not

- if (is_array($row['module_subs']))

- {

- $this->sub = strtolower((in_array(strtoupper($selected_submod), $row['module_subs'])) ? $selected_submod : $row['module_subs'][0]);

- }

- else if (is_array($row['module_stages']))

- {

- $this->sub = strtolower((in_array(strtoupper($selected_submod), $row['module_stages'])) ? $selected_submod : $row['module_stages'][0]);

- }

- else

- {

- $this->sub = '';

- }

- }

- } // END foreach

- } // END create

-

- /**

- * Load and run the relevant module if applicable

- */

- function load($mode = false, $run = true)

- {

- global $phpbb_root_path, $phpEx;

-

- if ($run)

- {

- if (!empty($mode))

- {

- $this->mode = $mode;

- }

-

- $module = $this->filename;

- if (!class_exists($module))

- {

- $this->error('Module "' . htmlspecialchars($module) . '" not accessible.', __LINE__, __FILE__);

- }

- $this->module = new $module($this);

-

- if (method_exists($this->module, 'main'))

- {

- $this->module->main($this->mode, $this->sub);

- }

- }

- }

-

- /**

- * Output the standard page header

- */

- function page_header()

- {

- if (defined('HEADER_INC'))

- {

- return;

- }

-

- define('HEADER_INC', true);

- global $template, $lang, $stage, $phpbb_admin_path, $path;

-

- $template->assign_vars(array(

- 'L_CHANGE' => $lang['CHANGE'],

- 'L_COLON' => $lang['COLON'],

- 'L_INSTALL_PANEL' => $lang['INSTALL_PANEL'],

- 'L_SELECT_LANG' => $lang['SELECT_LANG'],

- 'L_SKIP' => $lang['SKIP'],

- 'PAGE_TITLE' => $this->get_page_title(),

- 'T_IMAGE_PATH' => htmlspecialchars($phpbb_admin_path) . 'images/',

- 'T_JQUERY_LINK' => $path . '/../../assets/javascript/jquery.min.js',

-

- 'S_CONTENT_DIRECTION' => $lang['DIRECTION'],

- 'S_CONTENT_FLOW_BEGIN' => ($lang['DIRECTION'] == 'ltr') ? 'left' : 'right',

- 'S_CONTENT_FLOW_END' => ($lang['DIRECTION'] == 'ltr') ? 'right' : 'left',

- 'S_CONTENT_ENCODING' => 'UTF-8',

-

- 'S_USER_LANG' => $lang['USER_LANG'],

- )

- );

-

- header('Content-type: text/html; charset=UTF-8');

- header('Cache-Control: private, no-cache="set-cookie"');

- header('Expires: ' . gmdate('D, d M Y H:i:s', time()) . ' GMT');

-

- return;

- }

-

- /**

- * Output the standard page footer

- */

- function page_footer()

- {

- global $db, $template;

-

- $template->display('body');

-

- // Close our DB connection.

- if (!empty($db) && is_object($db))

- {

- $db->sql_close();

- }

-

- if (function_exists('exit_handler'))

- {

- exit_handler();

- }

- }

-

- /**

- * Returns desired template name

- */

- function get_tpl_name()

- {

- return $this->module->tpl_name . '.html';

- }

-

- /**

- * Returns the desired page title

- */

- function get_page_title()

- {

- global $lang;

-

- if (!isset($this->module->page_title))

- {

- return '';

- }

-

- return (isset($lang[$this->module->page_title])) ? $lang[$this->module->page_title] : $this->module->page_title;

- }

-

- /**

- * Generate an HTTP/1.1 header to redirect the user to another page

- * This is used during the installation when we do not have a database available to call the normal redirect function

- * @param string $page The page to redirect to relative to the installer root path

- */

- function redirect($page)

- {

- global $request;

-

- // HTTP_HOST is having the correct browser url in most cases...

- $server_name = strtolower(htmlspecialchars_decode($request->header('Host', $request->server('SERVER_NAME'))));

- $server_port = $request->server('SERVER_PORT', 0);

- $secure = $request->is_secure() ? 1 : 0;

-

- $script_name = htmlspecialchars_decode($request->server('PHP_SELF'));

- if (!$script_name)

- {

- $script_name = htmlspecialchars_decode($request->server('REQUEST_URI'));

- }

-

- // Replace backslashes and doubled slashes (could happen on some proxy setups)

- $script_name = str_replace(array('\\', '//'), '/', $script_name);

- $script_path = trim(dirname($script_name));

-

- $url = (($secure) ? 'https://' : 'http://') . $server_name;

-

- if ($server_port && (($secure && $server_port <> 443) || (!$secure && $server_port <> 80)))

- {

- // HTTP HOST can carry a port number...

- if (strpos($server_name, ':') === false)

- {

- $url .= ':' . $server_port;

- }

- }

-

- $url .= $script_path . '/' . $page;

- header('Location: ' . $url);

- exit;

- }

-

- /**

- * Generate the navigation tabs

- */

- function generate_navigation()

- {

- global $lang, $template, $phpEx, $language;

-

- if (is_array($this->module_ary))

- {

- @ksort($this->module_ary);

- foreach ($this->module_ary as $cat_ary)

- {

- $cat = $cat_ary['name'];

- $l_cat = (!empty($lang['CAT_' . $cat])) ? $lang['CAT_' . $cat] : preg_replace('#_#', ' ', $cat);

- $cat = strtolower($cat);

- $url = $this->module_url . "?mode=$cat&amp;language=$language";

-

- if ($this->mode == $cat)

- {

- $template->assign_block_vars('t_block1', array(

- 'L_TITLE' => $l_cat,

- 'S_SELECTED' => true,

- 'U_TITLE' => $url,

- ));

-

- if (is_array($this->module_ary[$this->id]['subs']))

- {

- $subs = $this->module_ary[$this->id]['subs'];

- foreach ($subs as $option)

- {

- $l_option = (!empty($lang['SUB_' . $option])) ? $lang['SUB_' . $option] : preg_replace('#_#', ' ', $option);

- $option = strtolower($option);

- $url = $this->module_url . '?mode=' . $this->mode . "&amp;sub=$option&amp;language=$language";

-

- $template->assign_block_vars('l_block1', array(

- 'L_TITLE' => $l_option,

- 'S_SELECTED' => ($this->sub == $option),

- 'U_TITLE' => $url,

- ));

- }

- }

-

- if (is_array($this->module_ary[$this->id]['stages']))

- {

- $subs = $this->module_ary[$this->id]['stages'];

- $matched = false;

- foreach ($subs as $option)

- {

- $l_option = (!empty($lang['STAGE_' . $option])) ? $lang['STAGE_' . $option] : preg_replace('#_#', ' ', $option);

- $option = strtolower($option);

- $matched = ($this->sub == $option) ? true : $matched;

-

- $template->assign_block_vars('l_block2', array(

- 'L_TITLE' => $l_option,

- 'S_SELECTED' => ($this->sub == $option),

- 'S_COMPLETE' => !$matched,

- ));

- }

- }

- }

- else

- {

- $template->assign_block_vars('t_block1', array(

- 'L_TITLE' => $l_cat,

- 'S_SELECTED' => false,

- 'U_TITLE' => $url,

- ));

- }

- }

- }

- }

-

- /**

- * Output an error message

- * If skip is true, return and continue execution, else exit

- */

- function error($error, $line, $file, $skip = false)

- {

- global $lang, $db, $template, $phpbb_admin_path;

-

- if ($skip)

- {

- $template->assign_block_vars('checks', array(

- 'S_LEGEND' => true,

- 'LEGEND' => $lang['INST_ERR'],

- ));

-

- $template->assign_block_vars('checks', array(

- 'TITLE' => basename($file) . ' [ ' . $line . ' ]',

- 'RESULT' => '<b style="color:red">' . $error . '</b>',

- ));

-

- return;

- }

-

- echo '<!DOCTYPE html>';

- echo '<html dir="ltr">';

- echo '<head>';

- echo '<meta charset="utf-8">';

- echo '<title>' . $lang['INST_ERR_FATAL'] . '</title>';

- echo '<link href="' . htmlspecialchars($phpbb_admin_path) . 'style/admin.css" rel="stylesheet" type="text/css" media="screen" />';

- echo '</head>';

- echo '<body id="errorpage">';

- echo '<div id="wrap">';

- echo ' <div id="page-header">';

- echo ' </div>';

- echo ' <div id="page-body">';

- echo ' <div id="acp">';

- echo ' <div class="panel">';

- echo ' <span class="corners-top"><span></span></span>';

- echo ' <div id="content">';

- echo ' <h1>' . $lang['INST_ERR_FATAL'] . '</h1>';

- echo ' <p>' . $lang['INST_ERR_FATAL'] . "</p>\n";

- echo ' <p>' . basename($file) . ' [ ' . $line . " ]</p>\n";

- echo ' <p><b>' . $error . "</b></p>\n";

- echo ' </div>';

- echo ' <span class="corners-bottom"><span></span></span>';

- echo ' </div>';

- echo ' </div>';

- echo ' </div>';

- echo ' <div id="page-footer">';

- echo ' Powered by <a href="https://www.phpbb.com/">phpBB</a>&reg; Forum Software &copy; phpBB Limited';

- echo ' </div>';

- echo '</div>';

- echo '</body>';

- echo '</html>';

-

- if (!empty($db) && is_object($db))

- {

- $db->sql_close();

- }

-

- exit_handler();

- }

-

- /**

- * Output an error message for a database related problem

- * If skip is true, return and continue execution, else exit

- */

- function db_error($error, $sql, $line, $file, $skip = false)

- {

- global $lang, $db, $template;

-

- if ($skip)

- {

- $template->assign_block_vars('checks', array(

- 'S_LEGEND' => true,

- 'LEGEND' => $lang['INST_ERR_FATAL'],

- ));

-

- $template->assign_block_vars('checks', array(

- 'TITLE' => basename($file) . ' [ ' . $line . ' ]',

- 'RESULT' => '<b style="color:red">' . $error . '</b><br />&#187; SQL:' . $sql,

- ));

-

- return;

- }

-

- $template->set_filenames(array(

- 'body' => 'install_error.html')

- );

- $this->page_header();

- $this->generate_navigation();

-

- $template->assign_vars(array(

- 'MESSAGE_TITLE' => $lang['INST_ERR_FATAL_DB'],

- 'MESSAGE_TEXT' => '<p>' . basename($file) . ' [ ' . $line . ' ]</p><p>SQL : ' . $sql . '</p><p><b>' . $error . '</b></p>',

- ));

-

- // Rollback if in transaction

- if ($db->get_transaction())

- {

- $db->sql_transaction('rollback');

- }

-

- $this->page_footer();

- }

-

- /**

- * Generate the relevant HTML for an input field and the associated label and explanatory text

- */

- function input_field($name, $type, $value = '', $options = '')

- {

- global $lang;

- $tpl_type = explode(':', $type);

- $tpl = '';

-

- switch ($tpl_type[0])

- {

- case 'text':

- case 'password':

- // HTML5 text-like input types

- case 'color':

- case 'date':

- case 'time':

- case 'datetime':

- case 'datetime-local':

- case 'email':

- case 'month':

- case 'number':

- case 'range':

- case 'search':

- case 'tel':

- case 'url':

- case 'week':

-

- $size = (int) $tpl_type[1];

- $maxlength = (int) $tpl_type[2];

- $autocomplete = (isset($options['autocomplete']) && $options['autocomplete'] == 'off') ? ' autocomplete="off"' : '';

-

- $tpl = '<input id="' . $name . '" type="' . $tpl_type[0] . '"' . (($size) ? ' size="' . $size . '"' : '') . ' maxlength="' . (($maxlength) ? $maxlength : 255) . '" name="' . $name . '"' . $autocomplete . ' value="' . $value . '" />';

- break;

-

- case 'textarea':

- $rows = (int) $tpl_type[1];

- $cols = (int) $tpl_type[2];

-

- $tpl = '<textarea id="' . $name . '" name="' . $name . '" rows="' . $rows . '" cols="' . $cols . '">' . $value . '</textarea>';

- break;

-

- case 'radio':

- $key_yes = ($value) ? ' checked="checked" id="' . $name . '"' : '';

- $key_no = (!$value) ? ' checked="checked" id="' . $name . '"' : '';

-

- $tpl_type_cond = explode('_', $tpl_type[1]);

- $type_no = ($tpl_type_cond[0] == 'disabled' || $tpl_type_cond[0] == 'enabled') ? false : true;

-

- $tpl_no = '<label><input type="radio" name="' . $name . '" value="0"' . $key_no . ' class="radio" /> ' . (($type_no) ? $lang['NO'] : $lang['DISABLED']) . '</label>';

- $tpl_yes = '<label><input type="radio" name="' . $name . '" value="1"' . $key_yes . ' class="radio" /> ' . (($type_no) ? $lang['YES'] : $lang['ENABLED']) . '</label>';

-

- $tpl = ($tpl_type_cond[0] == 'yes' || $tpl_type_cond[0] == 'enabled') ? $tpl_yes . '&nbsp;&nbsp;' . $tpl_no : $tpl_no . '&nbsp;&nbsp;' . $tpl_yes;

- break;

-

- case 'select':

- // @codingStandardsIgnoreStart

- eval('$s_options = ' . str_replace('{VALUE}', $value, $options) . ';');

- // @codingStandardsIgnoreEnd

- $tpl = '<select id="' . $name . '" name="' . $name . '">' . $s_options . '</select>';

- break;

-

- case 'custom':

- // @codingStandardsIgnoreStart

- eval('$tpl = ' . str_replace('{VALUE}', $value, $options) . ';');

- // @codingStandardsIgnoreEnd

- break;

-

- default:

- break;

- }

-

- return $tpl;

- }

-

- /**

- * Generate the drop down of available language packs

- */

- function inst_language_select($default = '')

- {

- global $phpbb_root_path, $phpEx;

-

- $dir = @opendir($phpbb_root_path . 'language');

-

- if (!$dir)

- {

- $this->error('Unable to access the language directory', __LINE__, __FILE__);

- }

-

- while ($file = readdir($dir))

- {

- $path = $phpbb_root_path . 'language/' . $file;

-

- if ($file == '.' || $file == '..' || is_link($path) || is_file($path) || $file == 'CVS')

- {

- continue;

- }

-

- if (file_exists($path . '/iso.txt'))

- {

- list($displayname, $localname) = @file($path . '/iso.txt');

- $lang[$localname] = $file;

- }

- }

- closedir($dir);

-

- @asort($lang);

- @reset($lang);

-

- $user_select = '';

- foreach ($lang as $displayname => $filename)

- {

- $selected = (strtolower($default) == strtolower($filename)) ? ' selected="selected"' : '';

- $user_select .= '<option value="' . $filename . '"' . $selected . '>' . ucwords($displayname) . '</option>';

- }

-

- return $user_select;

- }

-}

-<?php

-/**

-*

-* This file is part of the phpBB Forum Software package.

-*

-* @copyright (c) phpBB Limited <https://www.phpbb.com>

-* @license GNU General Public License, version 2 (GPL-2.0)

-*

-* For full copyright and license information, please see

-* the docs/CREDITS.txt file.

-*

-*/

-

-/**

-*/

-

-if (!defined('IN_INSTALL'))

-{

- // Someone has tried to access the file direct. This is not a good idea, so exit

- exit;

-}

-

-if (!empty($setmodules))

-{

- $module[] = array(

- 'module_type' => 'install',

- 'module_title' => 'CONVERT',

- 'module_filename' => substr(basename(__FILE__), 0, -strlen($phpEx)-1),

- 'module_order' => 20,

- 'module_subs' => '',

- 'module_stages' => array('INTRO', 'SETTINGS', 'IN_PROGRESS', 'FINAL'),

- 'module_reqs' => ''

- );

-}

-

-/**

-* Class holding all convertor-specific details.

-*/

-class convert

-{

- var $options = array();

-

- var $convertor_tag = '';

- var $src_dbms = '';

- var $src_dbhost = '';

- var $src_dbport = '';

- var $src_dbuser = '';

- var $src_dbpasswd = '';

- var $src_dbname = '';

- var $src_table_prefix = '';

-

- var $convertor_data = array();

- var $tables = array();

- var $config_schema = array();

- var $convertor = array();

- var $src_truncate_statement = 'DELETE FROM ';

- var $truncate_statement = 'DELETE FROM ';

-

- var $fulltext_search;

-

- // Batch size, can be adjusted by the conversion file

- // For big boards a value of 6000 seems to be optimal

- var $batch_size = 2000;

- // Number of rows to be inserted at once (extended insert) if supported

- // For installations having enough memory a value of 60 may be good.

- var $num_wait_rows = 20;

-

- // Mysqls internal recoding engine messing up with our (better) functions? We at least support more encodings than mysql so should use it in favor.

- var $mysql_convert = false;

-

- var $p_master;

-

- function convert(&$p_master)

- {

- $this->p_master = &$p_master;

- }

-}

-

-/**

-* Convert class for conversions

-*/

-class install_convert extends module

-{

- /** @var array */

- protected $lang;

-

- /** @var string */

- protected $language;

-

- /** @var \phpbb\template\template */

- protected $template;

-

- /** @var string */

- protected $phpbb_root_path;

-

- /** @var string */

- protected $php_ext;

-

- /** @var \phpbb\filesystem\filesystem_interface */

- protected $filesystem;

-

- /**

- * Variables used while converting, they are accessible from the global variable $convert

- */

- function install_convert(&$p_master)

- {

- $this->p_master = &$p_master;

- }

-

- function main($mode, $sub)

- {

- global $lang, $template, $phpbb_root_path, $phpEx, $cache, $config, $language, $table_prefix;

- global $convert, $request, $phpbb_container, $phpbb_config_php_file;

-

- $this->tpl_name = 'install_convert';

- $this->mode = $mode;

- $this->lang = $lang;

- $this->language = $language;

- $this->template = $template;

- $this->phpbb_root_path = $phpbb_root_path;

- $this->php_ext = $phpEx;

- $this->filesystem = new \phpbb\filesystem\filesystem();

-

- if (!$this->check_phpbb_installed())

- {

- return;

- }

-

- $convert = new convert($this->p_master);

-

- // Enable super globals to prevent issues with the new \phpbb\request\request object

- $request->enable_super_globals();

- // Create a normal container now

- $phpbb_container_builder = new \phpbb\di\container_builder($phpbb_root_path, $phpEx);

- $phpbb_container = $phpbb_container_builder->with_config($phpbb_config_php_file)->get_container();

-

- // Create cache

- /* @var $cache \phpbb\cache\service */

- $cache = $phpbb_container->get('cache');

-

- switch ($sub)

- {

- case 'intro':

- extract($phpbb_config_php_file->get_all());

-

- require($phpbb_root_path . 'includes/constants.' . $phpEx);

- require($phpbb_root_path . 'includes/functions_convert.' . $phpEx);

-

- $dbms = $phpbb_config_php_file->convert_30_dbms_to_31($dbms);

-

- $db = new $dbms();

- $db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false, true);

- unset($dbpasswd);

-

- // We need to fill the config to let internal functions correctly work

- $config = new \phpbb\config\db($db, new \phpbb\cache\driver\dummy, CONFIG_TABLE);

-

- // Detect if there is already a conversion in progress at this point and offer to resume

- // It's quite possible that the user will get disconnected during a large conversion so they need to be able to resume it

- $new_conversion = $request->variable('new_conv', 0);

-

- if ($new_conversion)

- {

- $config['convert_progress'] = '';

- $config['convert_db_server'] = '';

- $config['convert_db_user'] = '';

- $db->sql_query('DELETE FROM ' . CONFIG_TABLE . "

- WHERE config_name = 'convert_progress'

- OR config_name = 'convert_db_server'

- OR config_name = 'convert_db_user'"

- );

- }

-

- // Let's see if there is a conversion in the works...

- $options = array();

- if (!empty($config['convert_progress']) && !empty($config['convert_db_server']) && !empty($config['convert_db_user']) && !empty($config['convert_options']))

- {

- $options = unserialize($config['convert_progress']);

- $options = array_merge($options, unserialize($config['convert_db_server']), unserialize($config['convert_db_user']), unserialize($config['convert_options']));

- }

-

- // This information should have already been checked once, but do it again for safety

- if (!empty($options) && !empty($options['tag']) &&

- isset($options['dbms']) &&

- isset($options['dbhost']) &&

- isset($options['dbport']) &&

- isset($options['dbuser']) &&

- isset($options['dbpasswd']) &&

- isset($options['dbname']) &&

- isset($options['table_prefix']))

- {

- $this->page_title = $lang['CONTINUE_CONVERT'];

-

- $template->assign_vars(array(

- 'TITLE' => $lang['CONTINUE_CONVERT'],

- 'BODY' => $lang['CONTINUE_CONVERT_BODY'],

- 'L_NEW' => $lang['CONVERT_NEW_CONVERSION'],

- 'L_CONTINUE' => $lang['CONTINUE_OLD_CONVERSION'],

- 'S_CONTINUE' => true,

-

- 'U_NEW_ACTION' => $this->p_master->module_url . "?mode={$this->mode}&amp;sub=intro&amp;new_conv=1&amp;language=$language",

- 'U_CONTINUE_ACTION' => $this->p_master->module_url . "?mode={$this->mode}&amp;sub=in_progress&amp;tag={$options['tag']}{$options['step']}&amp;language=$language",

- ));

-

- return;

- }

-

- $this->list_convertors($sub);

-

- break;

-

- case 'settings':

- $this->get_convert_settings($sub);

- break;

-

- case 'in_progress':

- $this->convert_data($sub);

- break;

-

- case 'final':

- $this->page_title = $lang['CONVERT_COMPLETE'];

-

- $template->assign_vars(array(

- 'TITLE' => $lang['CONVERT_COMPLETE'],

- 'BODY' => $lang['CONVERT_COMPLETE_EXPLAIN'],

- ));

-

- // If we reached this step (conversion completed) we want to purge the cache and log the user out.

- // This is for making sure the session get not screwed due to the 3.0.x users table being completely new.

- $cache->purge();

-

- extract($phpbb_config_php_file->get_all());

-

- require($phpbb_root_path . 'includes/constants.' . $phpEx);

- require($phpbb_root_path . 'includes/functions_convert.' . $phpEx);

-

- $dbms = $phpbb_config_php_file->convert_30_dbms_to_31($dbms);

-

- $db = new $dbms();

- $db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false, true);

- unset($dbpasswd);

-

- $sql = 'SELECT config_value

- FROM ' . CONFIG_TABLE . '

- WHERE config_name = \'search_type\'';

- $result = $db->sql_query($sql);

-

- if ($db->sql_fetchfield('config_value') != 'fulltext_mysql')

- {

- $template->assign_vars(array(

- 'S_ERROR_BOX' => true,

- 'ERROR_TITLE' => $lang['SEARCH_INDEX_UNCONVERTED'],

- 'ERROR_MSG' => $lang['SEARCH_INDEX_UNCONVERTED_EXPLAIN'],

- ));

- }

-

- switch ($db->get_sql_layer())

- {

- case 'sqlite':

- case 'sqlite3':

- $db->sql_query('DELETE FROM ' . SESSIONS_KEYS_TABLE);

- $db->sql_query('DELETE FROM ' . SESSIONS_TABLE);

- break;

-

- default:

- $db->sql_query('TRUNCATE TABLE ' . SESSIONS_KEYS_TABLE);

- $db->sql_query('TRUNCATE TABLE ' . SESSIONS_TABLE);

- break;

- }

-

- break;

- }

- }

-

- /**

- * Check whether phpBB is installed.

- * Assigns error template vars if not installed.

- *

- * @return bool Returns true if phpBB is installed.

- */

- public function check_phpbb_installed()

- {

- if (phpbb_check_installation_exists($this->phpbb_root_path, $this->php_ext))

- {

- return true;

- }

-

- $this->page_title = 'BOARD_NOT_INSTALLED';

- $install_url = append_sid($this->phpbb_root_path . 'install/index.' . $this->php_ext, 'mode=install&amp;language=' . $this->language);

-

- $this->template->assign_vars(array(

- 'S_NOT_INSTALLED' => true,

- 'BODY' => sprintf($this->lang['BOARD_NOT_INSTALLED_EXPLAIN'], $install_url),

- ));

-

- return false;

- }

-

- /**

- * Generate a list of all available conversion modules

- */

- function list_convertors($sub)

- {

- global $lang, $language, $template, $phpbb_root_path, $phpEx;

-

- $this->page_title = $lang['SUB_INTRO'];

-

- $template->assign_vars(array(

- 'TITLE' => $lang['CONVERT_INTRO'],

- 'BODY' => $lang['CONVERT_INTRO_BODY'],

-

- 'L_AUTHOR' => $lang['AUTHOR'],

- 'L_AVAILABLE_CONVERTORS' => $lang['AVAILABLE_CONVERTORS'],

- 'L_CONVERT' => $lang['CONVERT'],

- 'L_NO_CONVERTORS' => $lang['NO_CONVERTORS'],

- 'L_OPTIONS' => $lang['CONVERT_OPTIONS'],

- 'L_SOFTWARE' => $lang['SOFTWARE'],

- 'L_VERSION' => $lang['VERSION'],

-

- 'S_LIST' => true,

- ));

-

- $convertors = $sort = array();

- $get_info = true;

-

- $handle = @opendir('./convertors/');

-

- if (!$handle)

- {

- $this->error('Unable to access the convertors directory', __LINE__, __FILE__);

- }

-

- while ($entry = readdir($handle))

- {

- if (preg_match('/^convert_([a-z0-9_]+).' . $phpEx . '$/i', $entry, $m))

- {

- include('./convertors/' . $entry);

- if (isset($convertor_data))

- {

- $sort[strtolower($convertor_data['forum_name'])] = sizeof($convertors);

-

- $convertors[] = array(

- 'tag' => $m[1],

- 'forum_name' => $convertor_data['forum_name'],

- 'version' => $convertor_data['version'],

- 'dbms' => $convertor_data['dbms'],

- 'dbhost' => $convertor_data['dbhost'],

- 'dbport' => $convertor_data['dbport'],

- 'dbuser' => $convertor_data['dbuser'],

- 'dbpasswd' => $convertor_data['dbpasswd'],

- 'dbname' => $convertor_data['dbname'],

- 'table_prefix' => $convertor_data['table_prefix'],

- 'author' => $convertor_data['author']

- );

- }

- unset($convertor_data);

- }

- }

- closedir($handle);

-

- @ksort($sort);

-

- foreach ($sort as $void => $index)

- {

- $template->assign_block_vars('convertors', array(

- 'AUTHOR' => $convertors[$index]['author'],

- 'SOFTWARE' => $convertors[$index]['forum_name'],

- 'VERSION' => $convertors[$index]['version'],

-

- 'U_CONVERT' => $this->p_master->module_url . "?mode={$this->mode}&amp;language=$language&amp;sub=settings&amp;tag=" . $convertors[$index]['tag'],

- ));

- }

- }

-

- /**

- */

- function get_convert_settings($sub)

- {

- global $lang, $language, $template, $db, $phpbb_root_path, $phpEx, $config, $cache, $phpbb_config_php_file;

-

- extract($phpbb_config_php_file->get_all());

-

- require($phpbb_root_path . 'includes/constants.' . $phpEx);

- require($phpbb_root_path . 'includes/functions_convert.' . $phpEx);

-

- $dbms = $phpbb_config_php_file->convert_30_dbms_to_31($dbms);

-

- $db = new $dbms();

- $db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false, true);

- unset($dbpasswd);

-

- $this->page_title = $lang['STAGE_SETTINGS'];

-

- // We need to fill the config to let internal functions correctly work

- $config = new \phpbb\config\db($db, new \phpbb\cache\driver\dummy, CONFIG_TABLE);

-

- $convertor_tag = $request->variable('tag', '');

-

- if (empty($convertor_tag))

- {

- $this->p_master->error($lang['NO_CONVERT_SPECIFIED'], __LINE__, __FILE__);

- }

- $get_info = true;

-

- // check security implications of direct inclusion

- $convertor_tag = basename($convertor_tag);

- if (!file_exists('./convertors/convert_' . $convertor_tag . '.' . $phpEx))

- {

- $this->p_master->error($lang['CONVERT_NOT_EXIST'], __LINE__, __FILE__);

- }

-

- include('./convertors/convert_' . $convertor_tag . '.' . $phpEx);

-

- // The test_file is a file that should be present in the location of the old board.

- if (!isset($test_file))

- {

- $this->p_master->error($lang['DEV_NO_TEST_FILE'], __LINE__, __FILE__);

- }

-

- $submit = (isset($_POST['submit'])) ? true : false;

-

- $src_dbms = $request->variable('src_dbms', $convertor_data['dbms']);

- $src_dbhost = $request->variable('src_dbhost', $convertor_data['dbhost']);

- $src_dbport = $request->variable('src_dbport', $convertor_data['dbport']);

- $src_dbuser = $request->variable('src_dbuser', $convertor_data['dbuser']);

- $src_dbpasswd = $request->variable('src_dbpasswd', $convertor_data['dbpasswd']);

- $src_dbname = $request->variable('src_dbname', $convertor_data['dbname']);

- $src_table_prefix = $request->variable('src_table_prefix', $convertor_data['table_prefix']);

- $forum_path = $request->variable('forum_path', $convertor_data['forum_path']);

- $refresh = $request->variable('refresh', 1);

-

- // Default URL of the old board

- // @todo Are we going to use this for attempting to convert URL references in posts, or should we remove it?

- // -> We should convert old urls to the new relative urls format

- // $src_url = $request->variable('src_url', 'Not in use at the moment');

-

- // strip trailing slash from old forum path

- $forum_path = (strlen($forum_path) && $forum_path[strlen($forum_path) - 1] == '/') ? substr($forum_path, 0, -1) : $forum_path;

-

- $error = array();

- if ($submit)

- {

- if (!@file_exists('./../' . $forum_path . '/' . $test_file))

- {

- $error[] = sprintf($lang['COULD_NOT_FIND_PATH'], $forum_path);

- }

-

- $connect_test = false;

- $available_dbms = get_available_dbms(false, true, true);

-

- if (!isset($available_dbms[$src_dbms]) || !$available_dbms[$src_dbms]['AVAILABLE'])

- {

- $error[] = $lang['INST_ERR_NO_DB'];

- $connect_test = false;

- }

- else

- {

- $connect_test = connect_check_db(true, $error, $available_dbms[$src_dbms], $src_table_prefix, $src_dbhost, $src_dbuser, htmlspecialchars_decode($src_dbpasswd), $src_dbname, $src_dbport, true, ($src_dbms == $dbms) ? false : true, false);

- }

-

- // The forum prefix of the old and the new forum can only be the same if two different databases are used.

- if ($src_table_prefix == $table_prefix && $src_dbms == $dbms && $src_dbhost == $dbhost && $src_dbport == $dbport && $src_dbname == $dbname)

- {

- $error[] = sprintf($lang['TABLE_PREFIX_SAME'], $src_table_prefix);

- }

-

- $src_dbms = $phpbb_config_php_file->convert_30_dbms_to_31($src_dbms);

-

- // Check table prefix

- if (!sizeof($error))

- {

- // initiate database connection to old db if old and new db differ

- global $src_db, $same_db;

- $src_db = $same_db = false;

-

- if ($src_dbms != $dbms || $src_dbhost != $dbhost || $src_dbport != $dbport || $src_dbname != $dbname || $src_dbuser != $dbuser)

- {

- $src_db = new $src_dbms();

- $src_db->sql_connect($src_dbhost, $src_dbuser, htmlspecialchars_decode($src_dbpasswd), $src_dbname, $src_dbport, false, true);

- $same_db = false;

- }

- else

- {

- $src_db = $db;

- $same_db = true;

- }

-

- $src_db->sql_return_on_error(true);

- $db->sql_return_on_error(true);

-

- // Try to select one row from the first table to see if the prefix is OK

- $result = $src_db->sql_query_limit('SELECT * FROM ' . $src_table_prefix . $tables[0], 1);

-

- if (!$result)

- {

- $prefixes = array();

-

- $db_tools_factory = new \phpbb\db\tools\factory();

- $db_tools = $db_tools_factory->get($src_db);

- $tables_existing = $db_tools->sql_list_tables();

- $tables_existing = array_map('strtolower', $tables_existing);

- foreach ($tables_existing as $table_name)

- {

- compare_table($tables, $table_name, $prefixes);

- }

- unset($tables_existing);

-

- foreach ($prefixes as $prefix => $count)

- {

- if ($count >= sizeof($tables))

- {

- $possible_prefix = $prefix;

- break;

- }

- }

-

- $msg = '';

- if (!empty($convertor_data['table_prefix']))

- {

- $msg .= sprintf($lang['DEFAULT_PREFIX_IS'], $convertor_data['forum_name'], $convertor_data['table_prefix']);

- }

-

- if (!empty($possible_prefix))

- {

- $msg .= '<br />';

- $msg .= ($possible_prefix == '*') ? $lang['BLANK_PREFIX_FOUND'] : sprintf($lang['PREFIX_FOUND'], $possible_prefix);

- $src_table_prefix = ($possible_prefix == '*') ? '' : $possible_prefix;

- }

-

- $error[] = $msg;

- }

- $src_db->sql_freeresult($result);

- $src_db->sql_return_on_error(false);

- }

-

- if (!sizeof($error))

- {

- // Save convertor Status

- $config->set('convert_progress', serialize(array(

- 'step' => '',

- 'table_prefix' => $src_table_prefix,

- 'tag' => $convertor_tag,

- )), false);

- $config->set('convert_db_server', serialize(array(

- 'dbms' => $src_dbms,

- 'dbhost' => $src_dbhost,

- 'dbport' => $src_dbport,

- 'dbname' => $src_dbname,

- )), false);

- $config->set('convert_db_user', serialize(array(

- 'dbuser' => $src_dbuser,

- 'dbpasswd' => $src_dbpasswd,

- )), false);

-

- // Save options

- $config->set('convert_options', serialize(array(

- 'forum_path' => './../' . $forum_path,

- 'refresh' => $refresh

- )), false);

-

- $template->assign_block_vars('checks', array(

- 'TITLE' => $lang['VERIFY_OPTIONS'],

- 'RESULT' => $lang['CONVERT_SETTINGS_VERIFIED'],

- ));

-

- $template->assign_vars(array(

- 'L_SUBMIT' => $lang['BEGIN_CONVERT'],

-// 'S_HIDDEN' => $s_hidden_fields,

- 'U_ACTION' => $this->p_master->module_url . "?mode={$this->mode}&amp;sub=in_progress&amp;tag=$convertor_tag&amp;language=$language",

- ));

-

- return;

- }

- else

- {

- $template->assign_block_vars('checks', array(

- 'TITLE' => $lang['VERIFY_OPTIONS'],

- 'RESULT' => '<b style="color:red">' . implode('<br />', $error) . '</b>',

- ));

- }

- } // end submit

-

- foreach ($this->convert_options as $config_key => $vars)

- {

- if (!is_array($vars) && strpos($config_key, 'legend') === false)

- {

- continue;

- }

-

- if (strpos($config_key, 'legend') !== false)

- {

- $template->assign_block_vars('options', array(

- 'S_LEGEND' => true,

- 'LEGEND' => $lang[$vars])

- );

-

- continue;

- }

-

- $options = isset($vars['options']) ? $vars['options'] : '';

-

- $template->assign_block_vars('options', array(

- 'KEY' => $config_key,

- 'TITLE' => $lang[$vars['lang']],

- 'S_EXPLAIN' => $vars['explain'],

- 'S_LEGEND' => false,

- 'TITLE_EXPLAIN' => ($vars['explain']) ? $lang[$vars['lang'] . '_EXPLAIN'] : '',

- 'CONTENT' => $this->p_master->input_field($config_key, $vars['type'], ${$config_key}, $options),

- )

- );

- }

-

- $template->assign_vars(array(

- 'TITLE' => $lang['STAGE_SETTINGS'],

- 'BODY' => $lang['CONV_OPTIONS_BODY'],

- 'L_SUBMIT' => $lang['BEGIN_CONVERT'],

- 'U_ACTION' => $this->p_master->module_url . "?mode={$this->mode}&amp;sub=settings&amp;tag=$convertor_tag&amp;language=$language",

- ));

- }

-

- /**

- * The function which does the actual work (or dispatches it to the relevant places)

- */

- function convert_data($sub)

- {

- global $template, $user, $phpbb_root_path, $phpEx, $db, $lang, $config, $cache, $auth;

- global $convert, $convert_row, $message_parser, $skip_rows, $language;

- global $request, $phpbb_config_php_file, $phpbb_dispatcher;

-

- extract($phpbb_config_php_file->get_all());

-

- require($phpbb_root_path . 'includes/constants.' . $phpEx);

- require($phpbb_root_path . 'includes/functions_convert.' . $phpEx);

-

- $dbms = $phpbb_config_php_file->convert_30_dbms_to_31($dbms);

-

- $db = new $dbms();

- $db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false, true);

- unset($dbpasswd);

-

- // We need to fill the config to let internal functions correctly work

- $config = new \phpbb\config\db($db, new \phpbb\cache\driver\dummy, CONFIG_TABLE);

-

- // Override a couple of config variables for the duration

- $config['max_quote_depth'] = 0;

-

- // @todo Need to confirm that max post length in source is <= max post length in destination or there may be interesting formatting issues

- $config['max_post_chars'] = $config['min_post_chars'] = 0;

-

- // Set up a user as well. We _should_ have enough of a database here at this point to do this

- // and it helps for any core code we call

- $user->session_begin();

- $user->page = $user->extract_current_page($phpbb_root_path);

-

- // This is a little bit of a fudge, but it allows the language entries to be available to the

- // core code without us loading them again

- $user->lang = &$lang;

-

- $this->page_title = $user->lang['STAGE_IN_PROGRESS'];

-

- $convert->options = array();

- if (isset($config['convert_progress']))

- {

- $convert->options = unserialize($config['convert_progress']);

- $convert->options = array_merge($convert->options, unserialize($config['convert_db_server']), unserialize($config['convert_db_user']), unserialize($config['convert_options']));

- }

-

- // This information should have already been checked once, but do it again for safety

- if (empty($convert->options) || empty($convert->options['tag']) ||

- !isset($convert->options['dbms']) ||

- !isset($convert->options['dbhost']) ||

- !isset($convert->options['dbport']) ||

- !isset($convert->options['dbuser']) ||

- !isset($convert->options['dbpasswd']) ||

- !isset($convert->options['dbname']) ||

- !isset($convert->options['table_prefix']))

- {

- $this->p_master->error($user->lang['NO_CONVERT_SPECIFIED'], __LINE__, __FILE__);

- }

-

- // Make some short variables accessible, for easier referencing

- $convert->convertor_tag = basename($convert->options['tag']);

- $convert->src_dbms = $convert->options['dbms'];

- $convert->src_dbhost = $convert->options['dbhost'];

- $convert->src_dbport = $convert->options['dbport'];

- $convert->src_dbuser = $convert->options['dbuser'];

- $convert->src_dbpasswd = $convert->options['dbpasswd'];

- $convert->src_dbname = $convert->options['dbname'];

- $convert->src_table_prefix = $convert->options['table_prefix'];

-

- // initiate database connection to old db if old and new db differ

- global $src_db, $same_db;

- $src_db = $same_db = null;

- if ($convert->src_dbms != $dbms || $convert->src_dbhost != $dbhost || $convert->src_dbport != $dbport || $convert->src_dbname != $dbname || $convert->src_dbuser != $dbuser)

- {

- $dbms = $convert->src_dbms;

- $src_db = new $dbms();

- $src_db->sql_connect($convert->src_dbhost, $convert->src_dbuser, htmlspecialchars_decode($convert->src_dbpasswd), $convert->src_dbname, $convert->src_dbport, false, true);

- $same_db = false;

- }

- else

- {

- $src_db = $db;

- $same_db = true;

- }

-

- $convert->mysql_convert = false;

- switch ($src_db->sql_layer)

- {

- case 'sqlite':

- case 'sqlite3':

- $convert->src_truncate_statement = 'DELETE FROM ';

- break;

-

- // Thanks MySQL, for silently converting...

- case 'mysql':

- case 'mysql4':

- if (version_compare($src_db->sql_server_info(true, false), '4.1.3', '>='))

- {

- $convert->mysql_convert = true;

- }

- $convert->src_truncate_statement = 'TRUNCATE TABLE ';

- break;

-

- case 'mysqli':

- $convert->mysql_convert = true;

- $convert->src_truncate_statement = 'TRUNCATE TABLE ';

- break;

-

- default:

- $convert->src_truncate_statement = 'TRUNCATE TABLE ';

- break;

- }

-

- if ($convert->mysql_convert && !$same_db)

- {

- $src_db->sql_query("SET NAMES 'binary'");

- }

-

- switch ($db->get_sql_layer())

- {

- case 'sqlite':

- case 'sqlite3':

- $convert->truncate_statement = 'DELETE FROM ';

- break;

-

- default:

- $convert->truncate_statement = 'TRUNCATE TABLE ';

- break;

- }

-

- $get_info = false;

-

- // check security implications of direct inclusion

- if (!file_exists('./convertors/convert_' . $convert->convertor_tag . '.' . $phpEx))

- {

- $this->p_master->error($user->lang['CONVERT_NOT_EXIST'], __LINE__, __FILE__);

- }

-

- if (file_exists('./convertors/functions_' . $convert->convertor_tag . '.' . $phpEx))

- {

- include('./convertors/functions_' . $convert->convertor_tag . '.' . $phpEx);

- }

-

- $get_info = true;

- include('./convertors/convert_' . $convert->convertor_tag . '.' . $phpEx);

-

- // Map some variables...

- $convert->convertor_data = $convertor_data;

- $convert->tables = $tables;

- $convert->config_schema = $config_schema;

-

- // Now include the real data

- $get_info = false;

- include('./convertors/convert_' . $convert->convertor_tag . '.' . $phpEx);

-

- $convert->convertor_data = $convertor_data;

- $convert->tables = $tables;

- $convert->config_schema = $config_schema;

- $convert->convertor = $convertor;

-

- // The test_file is a file that should be present in the location of the old board.

- if (!file_exists($convert->options['forum_path'] . '/' . $test_file))

- {

- $this->p_master->error(sprintf($user->lang['COULD_NOT_FIND_PATH'], $convert->options['forum_path']), __LINE__, __FILE__);

- }

-

- $search_type = $config['search_type'];

-

- // For conversions we are a bit less strict and set to a search backend we know exist...

- if (!class_exists($search_type))

- {

- $search_type = '\phpbb\search\fulltext_native';

- $config->set('search_type', $search_type);

- }

-

- if (!class_exists($search_type))

- {

- trigger_error('NO_SUCH_SEARCH_MODULE');

- }

-

- $error = false;

- $convert->fulltext_search = new $search_type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user, $phpbb_dispatcher);

-

- if ($error)

- {

- trigger_error($error);

- }

-

- include($phpbb_root_path . 'includes/message_parser.' . $phpEx);

- $message_parser = new parse_message();

-

- $jump = $request->variable('jump', 0);

- $final_jump = $request->variable('final_jump', 0);

- $sync_batch = $request->variable('sync_batch', -1);

- $last_statement = $request->variable('last', 0);

-

- // We are running sync...

- if ($sync_batch >= 0)

- {

- $this->sync_forums($sync_batch);

- return;

- }

-

- if ($jump)

- {

- $this->jump($jump, $last_statement);

- return;

- }

-

- if ($final_jump)

- {

- $this->final_jump($final_jump);

- return;

- }

-

- $current_table = $request->variable('current_table', 0);

- $old_current_table = min(-1, $current_table - 1);

- $skip_rows = $request->variable('skip_rows', 0);

-

- if (!$current_table && !$skip_rows)

- {

- if (!$request->variable('confirm', false))

- {

- // If avatars / ranks / smilies folders are specified make sure they are writable

- $bad_folders = array();

-

- $local_paths = array(

- 'avatar_path' => path($config['avatar_path']),

- 'avatar_gallery_path' => path($config['avatar_gallery_path']),

- 'icons_path' => path($config['icons_path']),

- 'ranks_path' => path($config['ranks_path']),

- 'smilies_path' => path($config['smilies_path'])

- );

-

- foreach ($local_paths as $folder => $local_path)

- {

- if (isset($convert->convertor[$folder]))

- {

- if (empty($convert->convertor['test_file']))

- {

- // test_file is mandantory at the moment so this should never be reached, but just in case...

- $this->p_master->error($user->lang['DEV_NO_TEST_FILE'], __LINE__, __FILE__);

- }

-

- if (!$local_path || !$this->filesystem->is_writable($phpbb_root_path . $local_path))

- {

- if (!$local_path)

- {

- $bad_folders[] = sprintf($user->lang['CONFIG_PHPBB_EMPTY'], $folder);

- }

- else

- {

- $bad_folders[] = $local_path;

- }

- }

- }

- }

-

- if (sizeof($bad_folders))

- {

- $msg = (sizeof($bad_folders) == 1) ? $user->lang['MAKE_FOLDER_WRITABLE'] : $user->lang['MAKE_FOLDERS_WRITABLE'];

- sort($bad_folders);

- $this->p_master->error(sprintf($msg, implode('<br />', $bad_folders)), __LINE__, __FILE__, true);

-

- $template->assign_vars(array(

- 'L_SUBMIT' => $user->lang['INSTALL_TEST'],

- 'U_ACTION' => $this->p_master->module_url . "?mode={$this->mode}&amp;sub=in_progress&amp;tag={$convert->convertor_tag}&amp;language=$language",

- ));

- return;

- }

-

- // Grab all the tables used in convertor

- $missing_tables = $tables_list = $aliases = array();

-

- foreach ($convert->convertor['schema'] as $schema)

- {

- // Skip those not used (because of addons/plugins not detected)

- if (!$schema['target'])

- {

- continue;

- }

-

- foreach ($schema as $key => $val)

- {

- // we're dealing with an array like:

- // array('forum_status', 'forums.forum_status', 'is_item_locked')

- if (is_int($key) && !empty($val[1]))

- {

- $temp_data = $val[1];

- if (!is_array($temp_data))

- {

- $temp_data = array($temp_data);

- }

-

- foreach ($temp_data as $val)

- {

- if (preg_match('/([a-z0-9_]+)\.([a-z0-9_]+)\)* ?A?S? ?([a-z0-9_]*?)\.?([a-z0-9_]*)$/i', $val, $m))

- {

- $table = $convert->src_table_prefix . $m[1];

- $tables_list[$table] = $table;

-

- if (!empty($m[3]))

- {

- $aliases[] = $convert->src_table_prefix . $m[3];

- }

- }

- }

- }

- // 'left_join' => 'topics LEFT JOIN vote_desc ON topics.topic_id = vote_desc.topic_id AND topics.topic_vote = 1'

- else if ($key == 'left_join')

- {

- // Convert the value if it wasn't an array already.

- if (!is_array($val))

- {

- $val = array($val);

- }

-

- for ($j = 0; $j < sizeof($val); ++$j)

- {

- if (preg_match('/LEFT JOIN ([a-z0-9_]+) AS ([a-z0-9_]+)/i', $val[$j], $m))

- {

- $table = $convert->src_table_prefix . $m[1];

- $tables_list[$table] = $table;

-

- if (!empty($m[2]))

- {

- $aliases[] = $convert->src_table_prefix . $m[2];

- }

- }

- }

- }

- }

- }

-

- // Remove aliased tables from $tables_list

- foreach ($aliases as $alias)

- {

- unset($tables_list[$alias]);

- }

-

- // Check if the tables that we need exist

- $src_db->sql_return_on_error(true);

- foreach ($tables_list as $table => $null)

- {

- $sql = 'SELECT 1 FROM ' . $table;

- $_result = $src_db->sql_query_limit($sql, 1);

-

- if (!$_result)

- {

- $missing_tables[] = $table;

- }

- $src_db->sql_freeresult($_result);

- }

- $src_db->sql_return_on_error(false);

-

- // Throw an error if some tables are missing

- // We used to do some guessing here, but since we have a suggestion of possible values earlier, I don't see it adding anything here to do it again

-

- if (sizeof($missing_tables) == sizeof($tables_list))

- {

- $this->p_master->error($user->lang['NO_TABLES_FOUND'] . ' ' . $user->lang['CHECK_TABLE_PREFIX'], __LINE__, __FILE__);

- }

- else if (sizeof($missing_tables))

- {

- $this->p_master->error(sprintf($user->lang['TABLES_MISSING'], implode($user->lang['COMMA_SEPARATOR'], $missing_tables)) . '<br /><br />' . $user->lang['CHECK_TABLE_PREFIX'], __LINE__, __FILE__);

- }

-

- $url = $this->save_convert_progress('&amp;confirm=1');

- $msg = $user->lang['PRE_CONVERT_COMPLETE'];

-

- if ($convert->convertor_data['author_notes'])

- {

- $msg .= '</p><p>' . sprintf($user->lang['AUTHOR_NOTES'], $convert->convertor_data['author_notes']);

- }

-

- $template->assign_vars(array(

- 'L_SUBMIT' => $user->lang['CONTINUE_CONVERT'],

- 'L_MESSAGE' => $msg,

- 'U_ACTION' => $url,

- ));

-

- return;

- } // if (!$request->variable('confirm', false)))

-

- $template->assign_block_vars('checks', array(

- 'S_LEGEND' => true,

- 'LEGEND' => $user->lang['STARTING_CONVERT'],

- ));

-

- // Convert the config table and load the settings of the old board

- if (!empty($convert->config_schema))

- {

- restore_config($convert->config_schema);

-

- // Override a couple of config variables for the duration

- $config['max_quote_depth'] = 0;

-

- // @todo Need to confirm that max post length in source is <= max post length in destination or there may be interesting formatting issues

- $config['max_post_chars'] = $config['min_post_chars'] = 0;

- }

-

- $template->assign_block_vars('checks', array(

- 'TITLE' => $user->lang['CONFIG_CONVERT'],

- 'RESULT' => $user->lang['DONE'],

- ));

-

- // Now process queries and execute functions that have to be executed prior to the conversion

- if (!empty($convert->convertor['execute_first']))

- {

- // @codingStandardsIgnoreStart

- eval($convert->convertor['execute_first']);

- // @codingStandardsIgnoreEnd

- }

-

- if (!empty($convert->convertor['query_first']))

- {

- if (!is_array($convert->convertor['query_first']))

- {

- $convert->convertor['query_first'] = array('target', array($convert->convertor['query_first']));

- }

- else if (!is_array($convert->convertor['query_first'][0]))

- {

- $convert->convertor['query_first'] = array(array($convert->convertor['query_first'][0], $convert->convertor['query_first'][1]));

- }

-

- foreach ($convert->convertor['query_first'] as $query_first)

- {

- if ($query_first[0] == 'src')

- {

- if ($convert->mysql_convert && $same_db)

- {

- $src_db->sql_query("SET NAMES 'binary'");

- }

-

- $src_db->sql_query($query_first[1]);

-

- if ($convert->mysql_convert && $same_db)

- {

- $src_db->sql_query("SET NAMES 'utf8'");

- }

- }

- else

- {

- $db->sql_query($query_first[1]);

- }

- }

- }

-

- $template->assign_block_vars('checks', array(

- 'TITLE' => $user->lang['PREPROCESS_STEP'],

- 'RESULT' => $user->lang['DONE'],

- ));

- } // if (!$current_table && !$skip_rows)

-

- $template->assign_block_vars('checks', array(

- 'S_LEGEND' => true,

- 'LEGEND' => $user->lang['FILLING_TABLES'],

- ));

-

- // This loop takes one target table and processes it

- while ($current_table < sizeof($convert->convertor['schema']))

- {

- $schema = $convert->convertor['schema'][$current_table];

-

- // The target table isn't set, this can be because a module (for example the attachement mod) is taking care of this.

- if (empty($schema['target']))

- {

- $current_table++;

- continue;

- }

-

- $template->assign_block_vars('checks', array(

- 'TITLE' => sprintf($user->lang['FILLING_TABLE'], $schema['target']),

- ));

-

- // This is only the case when we first start working on the tables.

- if (!$skip_rows)

- {

- // process execute_first and query_first for this table...

- if (!empty($schema['execute_first']))

- {

- // @codingStandardsIgnoreStart

- eval($schema['execute_first']);

- // @codingStandardsIgnoreEnd

- }

-

- if (!empty($schema['query_first']))

- {

- if (!is_array($schema['query_first']))

- {

- $schema['query_first'] = array('target', array($schema['query_first']));

- }

- else if (!is_array($schema['query_first'][0]))

- {

- $schema['query_first'] = array(array($schema['query_first'][0], $schema['query_first'][1]));

- }

-

- foreach ($schema['query_first'] as $query_first)

- {

- if ($query_first[0] == 'src')

- {

- if ($convert->mysql_convert && $same_db)

- {

- $src_db->sql_query("SET NAMES 'binary'");

- }

- $src_db->sql_query($query_first[1]);

- if ($convert->mysql_convert && $same_db)

- {

- $src_db->sql_query("SET NAMES 'utf8'");

- }

- }

- else

- {

- $db->sql_query($query_first[1]);

- }

- }

- }

-

- if (!empty($schema['autoincrement']))

- {

- switch ($db->get_sql_layer())

- {

- case 'postgres':

- $db->sql_query("SELECT SETVAL('" . $schema['target'] . "_seq',(select case when max(" . $schema['autoincrement'] . ")>0 then max(" . $schema['autoincrement'] . ")+1 else 1 end from " . $schema['target'] . '));');

- break;

-

- case 'oracle':

- $result = $db->sql_query('SELECT MAX(' . $schema['autoincrement'] . ') as max_id FROM ' . $schema['target']);

- $row = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

- $largest_id = (int) $row['max_id'];

-

- if ($largest_id)

- {

- $db->sql_query('DROP SEQUENCE ' . $schema['target'] . '_seq');

- $db->sql_query('CREATE SEQUENCE ' . $schema['target'] . '_seq START WITH ' . ($largest_id + 1));

- }

- break;

- }

- }

- }

-

- // Process execute_always for this table

- // This is for code which needs to be executed on every pass of this table if

- // it gets split because of time restrictions

- if (!empty($schema['execute_always']))

- {

- // @codingStandardsIgnoreStart

- eval($schema['execute_always']);

- // @codingStandardsIgnoreEnd

- }

-

- //

- // Set up some variables

- //

- // $waiting_rows holds rows for multirows insertion (MySQL only)

- // $src_tables holds unique tables with aliases to select from

- // $src_fields will quickly refer source fields (or aliases) corresponding to the current index

- // $select_fields holds the names of the fields to retrieve

- //

-

- $sql_data = array(

- 'source_fields' => array(),

- 'target_fields' => array(),

- 'source_tables' => array(),

- 'select_fields' => array(),

- );

-

- // This statement is building the keys for later insertion.

- $insert_query = $this->build_insert_query($schema, $sql_data, $current_table);

-

- // If no source table is affected, we skip the table

- if (empty($sql_data['source_tables']))

- {

- $skip_rows = 0;

- $current_table++;

- continue;

- }

-

- $distinct = (!empty($schema['distinct'])) ? 'DISTINCT ' : '';

-

- $sql = 'SELECT ' . $distinct . implode(', ', $sql_data['select_fields']) . " \nFROM " . implode(', ', $sql_data['source_tables']);

-

- // Where

- $sql .= (!empty($schema['where'])) ? "\nWHERE (" . $schema['where'] . ')' : '';

-

- // Group By

- if (!empty($schema['group_by']))

- {

- $schema['group_by'] = array($schema['group_by']);

- foreach ($sql_data['select_fields'] as $select)

- {

- $alias = strpos(strtolower($select), ' as ');

- $select = ($alias) ? substr($select, 0, $alias) : $select;

- if (!in_array($select, $schema['group_by']))

- {

- $schema['group_by'][] = $select;

- }

- }

- }

- $sql .= (!empty($schema['group_by'])) ? "\nGROUP BY " . implode(', ', $schema['group_by']) : '';

-

- // Having

- $sql .= (!empty($schema['having'])) ? "\nHAVING " . $schema['having'] : '';

-

- // Order By

- if (empty($schema['order_by']) && !empty($schema['primary']))

- {

- $schema['order_by'] = $schema['primary'];

- }

- $sql .= (!empty($schema['order_by'])) ? "\nORDER BY " . $schema['order_by'] : '';

-

- // Counting basically holds the amount of rows processed.

- $counting = -1;

- $batch_time = 0;

-

- while ($counting === -1 || ($counting >= $convert->batch_size && still_on_time()))

- {

- $old_current_table = $current_table;

-

- $rows = '';

- $waiting_rows = array();

-

- if (!empty($batch_time))

- {

- $mtime = explode(' ', microtime());

- $mtime = $mtime[0] + $mtime[1];

- $rows = ceil($counting/($mtime - $batch_time)) . " rows/s ($counting rows) | ";

- }

-

- $template->assign_block_vars('checks', array(

- 'TITLE' => "skip_rows = $skip_rows",

- 'RESULT' => $rows . ((defined('DEBUG') && function_exists('memory_get_usage')) ? ceil(memory_get_usage()/1024) . ' ' . $user->lang['KIB'] : ''),

- ));

-

- $mtime = explode(' ', microtime());

- $batch_time = $mtime[0] + $mtime[1];

-

- if ($convert->mysql_convert && $same_db)

- {

- $src_db->sql_query("SET NAMES 'binary'");

- }

-

- // Take skip rows into account and only fetch batch_size amount of rows

- $___result = $src_db->sql_query_limit($sql, $convert->batch_size, $skip_rows);

-

- if ($convert->mysql_convert && $same_db)

- {

- $src_db->sql_query("SET NAMES 'utf8'");

- }

-

- // This loop processes each row

- $counting = 0;

-

- $convert->row = $convert_row = array();

-

- if (!empty($schema['autoincrement']))

- {

- switch ($db->get_sql_layer())

- {

- case 'mssql':

- case 'mssql_odbc':

- case 'mssqlnative':

- $db->sql_query('SET IDENTITY_INSERT ' . $schema['target'] . ' ON');

- break;

- }

- }

-

- // Now handle the rows until time is over or no more rows to process...

- while ($counting === 0 || still_on_time())

- {

- $convert_row = $src_db->sql_fetchrow($___result);

-

- if (!$convert_row)

- {

- // move to the next batch or table

- break;

- }

-

- // With this we are able to always save the last state

- $convert->row = $convert_row;

-

- // Increment the counting variable, it stores the number of rows we have processed

- $counting++;

-

- $insert_values = array();

-

- $sql_flag = $this->process_row($schema, $sql_data, $insert_values);

-

- if ($sql_flag === true)

- {

- switch ($db->get_sql_layer())

- {

- // If MySQL, we'll wait to have num_wait_rows rows to submit at once

- case 'mysql':

- case 'mysql4':

- case 'mysqli':

- $waiting_rows[] = '(' . implode(', ', $insert_values) . ')';

-

- if (sizeof($waiting_rows) >= $convert->num_wait_rows)

- {

- $errored = false;

-

- $db->sql_return_on_error(true);

-

- if (!$db->sql_query($insert_query . implode(', ', $waiting_rows)))

- {

- $errored = true;

- }

- $db->sql_return_on_error(false);

-

- if ($errored)

- {

- $db->sql_return_on_error(true);

-

- // Because it errored out we will try to insert the rows one by one... most of the time this

- // is caused by duplicate entries - but we also do not want to miss one...

- foreach ($waiting_rows as $waiting_sql)

- {

- if (!$db->sql_query($insert_query . $waiting_sql))

- {

- $this->p_master->db_error($user->lang['DB_ERR_INSERT'], htmlspecialchars($insert_query . $waiting_sql) . '<br /><br />' . htmlspecialchars(print_r($db->_sql_error(), true)), __LINE__, __FILE__, true);

- }

- }

-

- $db->sql_return_on_error(false);

- }

-

- $waiting_rows = array();

- }

-

- break;

-

- default:

- $insert_sql = $insert_query . '(' . implode(', ', $insert_values) . ')';

-

- $db->sql_return_on_error(true);

-

- if (!$db->sql_query($insert_sql))

- {

- $this->p_master->db_error($user->lang['DB_ERR_INSERT'], htmlspecialchars($insert_sql) . '<br /><br />' . htmlspecialchars(print_r($db->_sql_error(), true)), __LINE__, __FILE__, true);

- }

- $db->sql_return_on_error(false);

-

- $waiting_rows = array();

-

- break;

- }

- }

-

- $skip_rows++;

- }

- $src_db->sql_freeresult($___result);

-

- // We might still have some rows waiting

- if (sizeof($waiting_rows))

- {

- $errored = false;

- $db->sql_return_on_error(true);

-

- if (!$db->sql_query($insert_query . implode(', ', $waiting_rows)))

- {

- $errored = true;

- }

- $db->sql_return_on_error(false);

-

- if ($errored)

- {

- $db->sql_return_on_error(true);

-

- // Because it errored out we will try to insert the rows one by one... most of the time this

- // is caused by duplicate entries - but we also do not want to miss one...

- foreach ($waiting_rows as $waiting_sql)

- {

- $db->sql_query($insert_query . $waiting_sql);

- $this->p_master->db_error($user->lang['DB_ERR_INSERT'], htmlspecialchars($insert_query . $waiting_sql) . '<br /><br />' . htmlspecialchars(print_r($db->_sql_error(), true)), __LINE__, __FILE__, true);

- }

-

- $db->sql_return_on_error(false);

- }

-

- $waiting_rows = array();

- }

-

- if (!empty($schema['autoincrement']))

- {

- switch ($db->get_sql_layer())

- {

- case 'mssql':

- case 'mssql_odbc':

- case 'mssqlnative':

- $db->sql_query('SET IDENTITY_INSERT ' . $schema['target'] . ' OFF');

- break;

-

- case 'postgres':

- $db->sql_query("SELECT SETVAL('" . $schema['target'] . "_seq',(select case when max(" . $schema['autoincrement'] . ")>0 then max(" . $schema['autoincrement'] . ")+1 else 1 end from " . $schema['target'] . '));');

- break;

-

- case 'oracle':

- $result = $db->sql_query('SELECT MAX(' . $schema['autoincrement'] . ') as max_id FROM ' . $schema['target']);

- $row = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

- $largest_id = (int) $row['max_id'];

-

- if ($largest_id)

- {

- $db->sql_query('DROP SEQUENCE ' . $schema['target'] . '_seq');

- $db->sql_query('CREATE SEQUENCE ' . $schema['target'] . '_seq START WITH ' . ($largest_id + 1));

- }

- break;

- }

- }

- }

-

- // When we reach this point, either the current table has been processed or we're running out of time.

- if (still_on_time() && $counting < $convert->batch_size/* && !defined('DEBUG')*/)

- {

- $skip_rows = 0;

- $current_table++;

- }

- else

- {/*

- if (still_on_time() && $counting < $convert->batch_size)

- {

- $skip_rows = 0;

- $current_table++;

- }*/

-

- // Looks like we ran out of time.

- $url = $this->save_convert_progress('&amp;current_table=' . $current_table . '&amp;skip_rows=' . $skip_rows);

-

- $current_table++;

-// $percentage = ($skip_rows == 0) ? 0 : floor(100 / ($total_rows / $skip_rows));

-

- $msg = sprintf($user->lang['STEP_PERCENT_COMPLETED'], $current_table, sizeof($convert->convertor['schema']));

-

- $template->assign_vars(array(

- 'L_MESSAGE' => $msg,

- 'L_SUBMIT' => $user->lang['CONTINUE_CONVERT'],

- 'U_ACTION' => $url,

- ));

-

- $this->meta_refresh($url);

- return;

- }

- }

-

- // Process execute_last then we'll be done

- $url = $this->save_convert_progress('&amp;jump=1');

-

- $template->assign_vars(array(

- 'L_SUBMIT' => $user->lang['FINAL_STEP'],

- 'U_ACTION' => $url,

- ));

-

- $this->meta_refresh($url);

- return;

- }

-

- /**

- * Sync function being executed at the middle, some functions need to be executed after a successful sync.

- */

- function sync_forums($sync_batch)

- {

- global $template, $user, $db, $phpbb_root_path, $phpEx, $config, $cache;

- global $convert;

-

- $template->assign_block_vars('checks', array(

- 'S_LEGEND' => true,

- 'LEGEND' => $user->lang['SYNC_TOPICS'],

- ));

-

- $batch_size = $convert->batch_size;

-

- $sql = 'SELECT MIN(topic_id) as min_value, MAX(topic_id) AS max_value

- FROM ' . TOPICS_TABLE;

- $result = $db->sql_query($sql);

- $row = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

- // Set values of minimum/maximum primary value for this table.

- $primary_min = $row['min_value'];

- $primary_max = $row['max_value'];

-

- if ($sync_batch == 0)

- {

- $sync_batch = (int) $primary_min;

- }

-

- if ($sync_batch == 0)

- {

- $sync_batch = 1;

- }

-

- // Fetch a batch of rows, process and insert them.

- while ($sync_batch <= $primary_max && still_on_time())

- {

- $end = ($sync_batch + $batch_size - 1);

-

- // Sync all topics in batch mode...

- sync('topic', 'range', 'topic_id BETWEEN ' . $sync_batch . ' AND ' . $end, true, true);

-

- $template->assign_block_vars('checks', array(

- 'TITLE' => sprintf($user->lang['SYNC_TOPIC_ID'], $sync_batch, ($sync_batch + $batch_size)) . ((defined('DEBUG') && function_exists('memory_get_usage')) ? ' [' . ceil(memory_get_usage()/1024) . ' ' . $user->lang['KIB'] . ']' : ''),

- 'RESULT' => $user->lang['DONE'],

- ));

-

- $sync_batch += $batch_size;

- }

-

- if ($sync_batch >= $primary_max)

- {

- $url = $this->save_convert_progress('&amp;final_jump=1');

-

- $template->assign_vars(array(

- 'L_SUBMIT' => $user->lang['CONTINUE_CONVERT'],

- 'U_ACTION' => $url,

- ));

-

- $this->meta_refresh($url);

- return;

- }

- else

- {

- $sync_batch--;

- }

-

- $url = $this->save_convert_progress('&amp;sync_batch=' . $sync_batch);

-

- $template->assign_vars(array(

- 'L_SUBMIT' => $user->lang['CONTINUE_CONVERT'],

- 'U_ACTION' => $url,

- ));

-

- $this->meta_refresh($url);

- return;

- }

-

- /**

- * Save the convertor status

- */

- function save_convert_progress($step)

- {

- global $config, $convert, $language;

-

- // Save convertor Status

- $config->set('convert_progress', serialize(array(

- 'step' => $step,

- 'table_prefix' => $convert->src_table_prefix,

- 'tag' => $convert->convertor_tag,

- )), false);

-

- $config->set('convert_db_server', serialize(array(

- 'dbms' => $convert->src_dbms,

- 'dbhost' => $convert->src_dbhost,

- 'dbport' => $convert->src_dbport,

- 'dbname' => $convert->src_dbname,

- )), false);

-

- $config->set('convert_db_user', serialize(array(

- 'dbuser' => $convert->src_dbuser,

- 'dbpasswd' => $convert->src_dbpasswd,

- )), false);

-

- return $this->p_master->module_url . "?mode={$this->mode}&amp;sub=in_progress&amp;tag={$convert->convertor_tag}$step&amp;language=$language";

- }

-

- /**

- * Finish conversion, the last function to be called.

- */

- function finish_conversion()

- {

- global $db, $phpbb_root_path, $phpEx, $convert, $config, $language, $user, $template;

- global $cache, $auth, $phpbb_container, $phpbb_log;

-

- $db->sql_query('DELETE FROM ' . CONFIG_TABLE . "

- WHERE config_name = 'convert_progress'

- OR config_name = 'convert_options'

- OR config_name = 'convert_db_server'

- OR config_name = 'convert_db_user'");

- $db->sql_query('DELETE FROM ' . SESSIONS_TABLE);

-

- @unlink($phpbb_root_path . 'cache/data_global.' . $phpEx);

- phpbb_cache_moderators($db, $cache, $auth);

-

- // And finally, add a note to the log

- $phpbb_log->add('admin', $user->data['user_id'], $user->ip, 'LOG_INSTALL_CONVERTED', false, array($convert->convertor_data['forum_name'], $config['version']));

-

- $url = $this->p_master->module_url . "?mode={$this->mode}&amp;sub=final&amp;language=$language";

-

- $template->assign_vars(array(

- 'L_SUBMIT' => $user->lang['FINAL_STEP'],

- 'U_ACTION' => $url,

- ));

-

- $this->meta_refresh($url);

- return;

- }

-

- /**

- * This function marks the steps after syncing

- */

- function final_jump($final_jump)

- {

- global $template, $user, $src_db, $same_db, $db, $phpbb_root_path, $phpEx, $config, $cache;

- global $convert;

-

- $template->assign_block_vars('checks', array(

- 'S_LEGEND' => true,

- 'LEGEND' => $user->lang['PROCESS_LAST'],

- ));

-

- if ($final_jump == 1)

- {

- $db->sql_return_on_error(true);

-

- update_topics_posted();

-

- $template->assign_block_vars('checks', array(

- 'TITLE' => $user->lang['UPDATE_TOPICS_POSTED'],

- 'RESULT' => $user->lang['DONE'],

- ));

-

- if ($db->get_sql_error_triggered())

- {

- $template->assign_vars(array(

- 'S_ERROR_BOX' => true,

- 'ERROR_TITLE' => $user->lang['UPDATE_TOPICS_POSTED'],

- 'ERROR_MSG' => $user->lang['UPDATE_TOPICS_POSTED_ERR'],

- ));

- }

- $db->sql_return_on_error(false);

-

- $this->finish_conversion();

- return;

- }

- }

-

- /**

- * This function marks the steps before syncing (jump=1)

- */

- function jump($jump, $last_statement)

- {

- global $template, $user, $src_db, $same_db, $db, $phpbb_root_path, $phpEx, $config, $cache;

- global $convert;

-

- $template->assign_block_vars('checks', array(

- 'S_LEGEND' => true,

- 'LEGEND' => $user->lang['PROCESS_LAST'],

- ));

-

- if ($jump == 1)

- {

- // Execute 'last' statements/queries

- if (!empty($convert->convertor['execute_last']))

- {

- if (!is_array($convert->convertor['execute_last']))

- {

- // @codingStandardsIgnoreStart

- eval($convert->convertor['execute_last']);

- // @codingStandardsIgnoreEnd

- }

- else

- {

- while ($last_statement < sizeof($convert->convertor['execute_last']))

- {

- // @codingStandardsIgnoreStart

- eval($convert->convertor['execute_last'][$last_statement]);

- // @codingStandardsIgnoreEnd

-

- $template->assign_block_vars('checks', array(

- 'TITLE' => $convert->convertor['execute_last'][$last_statement],

- 'RESULT' => $user->lang['DONE'],

- ));

-

- $last_statement++;

- $url = $this->save_convert_progress('&amp;jump=1&amp;last=' . $last_statement);

-

- $percentage = ($last_statement == 0) ? 0 : floor(100 / (sizeof($convert->convertor['execute_last']) / $last_statement));

- $msg = sprintf($user->lang['STEP_PERCENT_COMPLETED'], $last_statement, sizeof($convert->convertor['execute_last']), $percentage);

-

- $template->assign_vars(array(

- 'L_SUBMIT' => $user->lang['CONTINUE_LAST'],

- 'L_MESSAGE' => $msg,

- 'U_ACTION' => $url,

- ));

-

- $this->meta_refresh($url);

- return;

- }

- }

- }

-

- if (!empty($convert->convertor['query_last']))

- {

- if (!is_array($convert->convertor['query_last']))

- {

- $convert->convertor['query_last'] = array('target', array($convert->convertor['query_last']));

- }

- else if (!is_array($convert->convertor['query_last'][0]))

- {

- $convert->convertor['query_last'] = array(array($convert->convertor['query_last'][0], $convert->convertor['query_last'][1]));

- }

-

- foreach ($convert->convertor['query_last'] as $query_last)

- {

- if ($query_last[0] == 'src')

- {

- if ($convert->mysql_convert && $same_db)

- {

- $src_db->sql_query("SET NAMES 'binary'");

- }

-

- $src_db->sql_query($query_last[1]);

-

- if ($convert->mysql_convert && $same_db)

- {

- $src_db->sql_query("SET NAMES 'utf8'");

- }

- }

- else

- {

- $db->sql_query($query_last[1]);

- }

- }

- }

-

- // Sanity check

- $db->sql_return_on_error(false);

- $src_db->sql_return_on_error(false);

-

- fix_empty_primary_groups();

-

- $sql = 'SELECT MIN(user_regdate) AS board_startdate

- FROM ' . USERS_TABLE;

- $result = $db->sql_query($sql);

- $row = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

- if (!isset($config['board_startdate']) || ($row['board_startdate'] < $config['board_startdate'] && $row['board_startdate'] > 0))

- {

- $config->set('board_startdate', $row['board_startdate']);

- $db->sql_query('UPDATE ' . USERS_TABLE . ' SET user_regdate = ' . $row['board_startdate'] . ' WHERE user_id = ' . ANONYMOUS);

- }

-

- update_dynamic_config();

-

- $template->assign_block_vars('checks', array(

- 'TITLE' => $user->lang['CLEAN_VERIFY'],

- 'RESULT' => $user->lang['DONE'],

- ));

-

- $url = $this->save_convert_progress('&amp;jump=2');

-

- $template->assign_vars(array(

- 'L_SUBMIT' => $user->lang['CONTINUE_CONVERT'],

- 'U_ACTION' => $url,

- ));

-

- $this->meta_refresh($url);

- return;

- }

-

- if ($jump == 2)

- {

- $db->sql_query('UPDATE ' . USERS_TABLE . " SET user_permissions = ''");

-

- // TODO: sync() is likely going to bomb out on forums with a considerable amount of topics.

- // TODO: the sync function is able to handle FROM-TO values, we should use them here (batch processing)

- sync('forum', '', '', false, true);

- $cache->destroy('sql', FORUMS_TABLE);

-

- $template->assign_block_vars('checks', array(

- 'TITLE' => $user->lang['SYNC_FORUMS'],

- 'RESULT' => $user->lang['DONE'],

- ));

-

- // Continue with synchronizing the forums...

- $url = $this->save_convert_progress('&amp;sync_batch=0');

-

- $template->assign_vars(array(

- 'L_SUBMIT' => $user->lang['CONTINUE_CONVERT'],

- 'U_ACTION' => $url,

- ));

-

- $this->meta_refresh($url);

- return;

- }

- }

-

- function build_insert_query(&$schema, &$sql_data, $current_table)

- {

- global $db, $user;

- global $convert;

-

- // Can we use IGNORE with this DBMS?

- $sql_ignore = (strpos($db->get_sql_layer(), 'mysql') === 0 && !defined('DEBUG')) ? 'IGNORE ' : '';

- $insert_query = 'INSERT ' . $sql_ignore . 'INTO ' . $schema['target'] . ' (';

-

- $aliases = array();

-

- $sql_data = array(

- 'source_fields' => array(),

- 'target_fields' => array(),

- 'source_tables' => array(),

- 'select_fields' => array(),

- );

-

- foreach ($schema as $key => $val)

- {

- // Example: array('group_name', 'extension_groups.group_name', 'htmlspecialchars'),

- if (is_int($key))

- {

- if (!empty($val[0]))

- {

- // Target fields

- $sql_data['target_fields'][$val[0]] = $key;

- $insert_query .= $val[0] . ', ';

- }

-

- if (!is_array($val[1]))

- {

- $val[1] = array($val[1]);

- }

-

- foreach ($val[1] as $valkey => $value_1)

- {

- // This should cover about any case:

- //

- // table.field => SELECT table.field FROM table

- // table.field AS alias => SELECT table.field AS alias FROM table

- // table.field AS table2.alias => SELECT table2.field AS alias FROM table table2

- // table.field AS table2.field => SELECT table2.field FROM table table2

- //

- if (preg_match('/^([a-z0-9_]+)\.([a-z0-9_]+)( +AS +(([a-z0-9_]+?)\.)?([a-z0-9_]+))?$/i', $value_1, $m))

- {

- // There is 'AS ...' in the field names

- if (!empty($m[3]))

- {

- $value_1 = ($m[2] == $m[6]) ? $m[1] . '.' . $m[2] : $m[1] . '.' . $m[2] . ' AS ' . $m[6];

-

- // Table alias: store it then replace the source table with it

- if (!empty($m[5]) && $m[5] != $m[1])

- {

- $aliases[$m[5]] = $m[1];

- $value_1 = str_replace($m[1] . '.' . $m[2], $m[5] . '.' . $m[2], $value_1);

- }

- }

- else

- {

- // No table alias

- $sql_data['source_tables'][$m[1]] = (empty($convert->src_table_prefix)) ? $m[1] : $convert->src_table_prefix . $m[1] . ' ' . $m[1];

- }

-

- $sql_data['select_fields'][$value_1] = $value_1;

- $sql_data['source_fields'][$key][$valkey] = (!empty($m[6])) ? $m[6] : $m[2];

- }

- }

- }

- else if ($key == 'where' || $key == 'group_by' || $key == 'order_by' || $key == 'having')

- {

- if (@preg_match_all('/([a-z0-9_]+)\.([a-z0-9_]+)/i', $val, $m))

- {

- foreach ($m[1] as $value)

- {

- $sql_data['source_tables'][$value] = (empty($convert->src_table_prefix)) ? $value : $convert->src_table_prefix . $value . ' ' . $value;

- }

- }

- }

- }

-

- // Add the aliases to the list of tables

- foreach ($aliases as $alias => $table)

- {

- $sql_data['source_tables'][$alias] = $convert->src_table_prefix . $table . ' ' . $alias;

- }

-

- // 'left_join' => 'forums LEFT JOIN forum_prune ON forums.forum_id = forum_prune.forum_id',

- if (!empty($schema['left_join']))

- {

- if (!is_array($schema['left_join']))

- {

- $schema['left_join'] = array($schema['left_join']);

- }

-

- foreach ($schema['left_join'] as $left_join)

- {

- // This won't handle concatened LEFT JOINs

- if (!preg_match('/([a-z0-9_]+) LEFT JOIN ([a-z0-9_]+) A?S? ?([a-z0-9_]*?) ?(ON|USING)(.*)/i', $left_join, $m))

- {

- $this->p_master->error(sprintf($user->lang['NOT_UNDERSTAND'], 'LEFT JOIN', $left_join, $current_table, $schema['target']), __LINE__, __FILE__);

- }

-

- if (!empty($aliases[$m[2]]))

- {

- if (!empty($m[3]))

- {

- $this->p_master->error(sprintf($user->lang['NAMING_CONFLICT'], $m[2], $m[3], $schema['left_join']), __LINE__, __FILE__);

- }

-

- $m[2] = $aliases[$m[2]];

- $m[3] = $m[2];

- }

-

- $right_table = $convert->src_table_prefix . $m[2];

- if (!empty($m[3]))

- {

- unset($sql_data['source_tables'][$m[3]]);

- }

- else if ($m[2] != $m[1])

- {

- unset($sql_data['source_tables'][$m[2]]);

- }

-

- if (strpos($sql_data['source_tables'][$m[1]], "\nLEFT JOIN") !== false)

- {

- $sql_data['source_tables'][$m[1]] = '(' . $sql_data['source_tables'][$m[1]] . ")\nLEFT JOIN $right_table";

- }

- else

- {

- $sql_data['source_tables'][$m[1]] .= "\nLEFT JOIN $right_table";

- }

-

- if (!empty($m[3]))

- {

- unset($sql_data['source_tables'][$m[3]]);

- $sql_data['source_tables'][$m[1]] .= ' AS ' . $m[3];

- }

- else if (!empty($convert->src_table_prefix))

- {

- $sql_data['source_tables'][$m[1]] .= ' AS ' . $m[2];

- }

- $sql_data['source_tables'][$m[1]] .= ' ' . $m[4] . $m[5];

- }

- }

-

- // Remove ", " from the end of the insert query

- $insert_query = substr($insert_query, 0, -2) . ') VALUES ';

-

- return $insert_query;

- }

-

- /**

- * Function for processing the currently handled row

- */

- function process_row(&$schema, &$sql_data, &$insert_values)

- {

- global $template, $user, $phpbb_root_path, $phpEx, $db, $lang, $config, $cache;

- global $convert, $convert_row;

-

- $sql_flag = false;

-

- foreach ($schema as $key => $fields)

- {

- // We are only interested in the lines with:

- // array('comment', 'attachments_desc.comment', 'htmlspecialchars'),

- if (is_int($key))

- {

- if (!is_array($fields[1]))

- {

- $fields[1] = array($fields[1]);

- }

-

- $firstkey_set = false;

- $firstkey = 0;

-

- foreach ($fields[1] as $inner_key => $inner_value)

- {

- if (!$firstkey_set)

- {

- $firstkey = $inner_key;

- $firstkey_set = true;

- }

-

- $src_field = isset($sql_data['source_fields'][$key][$inner_key]) ? $sql_data['source_fields'][$key][$inner_key] : '';

-

- if (!empty($src_field))

- {

- $fields[1][$inner_key] = $convert->row[$src_field];

- }

- }

-

- if (!empty($fields[0]))

- {

- // We have a target field, if we haven't set $sql_flag yet it will be set to TRUE.

- // If a function has already set it to FALSE it won't change it.

- if ($sql_flag === false)

- {

- $sql_flag = true;

- }

-

- // No function assigned?

- if (empty($fields[2]))

- {

- $value = $fields[1][$firstkey];

- }

- else if (is_array($fields[2]) && !is_callable($fields[2]))

- {

- // Execute complex function/eval/typecast

- $value = $fields[1];

-

- foreach ($fields[2] as $type => $execution)

- {

- if (strpos($type, 'typecast') === 0)

- {

- if (!is_array($value))

- {

- $value = array($value);

- }

- $value = $value[0];

- settype($value, $execution);

- }

- else if (strpos($type, 'function') === 0)

- {

- if (!is_array($value))

- {

- $value = array($value);

- }

-

- $value = call_user_func_array($execution, $value);

- }

- else if (strpos($type, 'execute') === 0)

- {

- if (!is_array($value))

- {

- $value = array($value);

- }

-

- $execution = str_replace('{RESULT}', '$value', $execution);

- $execution = str_replace('{VALUE}', '$value', $execution);

- // @codingStandardsIgnoreStart

- eval($execution);

- // @codingStandardsIgnoreEnd

- }

- }

- }

- else

- {

- $value = call_user_func_array($fields[2], $fields[1]);

- }

-

- if (is_null($value))

- {

- $value = '';

- }

-

- $insert_values[] = $db->_sql_validate_value($value);

- }

- else if (!empty($fields[2]))

- {

- if (is_array($fields[2]))

- {

- // Execute complex function/eval/typecast

- $value = '';

-

- foreach ($fields[2] as $type => $execution)

- {

- if (strpos($type, 'typecast') === 0)

- {

- $value = settype($value, $execution);

- }

- else if (strpos($type, 'function') === 0)

- {

- if (!is_array($value))

- {

- $value = array($value);

- }

-

- $value = call_user_func_array($execution, $value);

- }

- else if (strpos($type, 'execute') === 0)

- {

- if (!is_array($value))

- {

- $value = array($value);

- }

-

- $execution = str_replace('{RESULT}', '$value', $execution);

- $execution = str_replace('{VALUE}', '$value', $execution);

- // @codingStandardsIgnoreStart

- eval($execution);

- // @codingStandardsIgnoreEnd

- }

- }

- }

- else

- {

- call_user_func_array($fields[2], $fields[1]);

- }

- }

- }

- }

-

- return $sql_flag;

- }

-

- /**

- * Own meta refresh function to be able to change the global time used

- */

- function meta_refresh($url)

- {

- global $convert, $template;

-

- if ($convert->options['refresh'])

- {

- // Because we should not rely on correct settings, we simply use the relative path here directly.

- $template->assign_vars(array(

- 'S_REFRESH' => true,

- 'META' => '<meta http-equiv="refresh" content="5; url=' . $url . '" />')

- );

- }

- }

-

- /**

- * The information below will be used to build the input fields presented to the user

- */

- var $convert_options = array(

- 'legend1' => 'SPECIFY_OPTIONS',

- 'src_dbms' => array('lang' => 'DBMS', 'type' => 'select', 'options' => 'dbms_select(\'{VALUE}\', true)', 'explain' => false),

- 'src_dbhost' => array('lang' => 'DB_HOST', 'type' => 'text:25:100', 'explain' => true),

- 'src_dbport' => array('lang' => 'DB_PORT', 'type' => 'text:25:100', 'explain' => true),

- 'src_dbname' => array('lang' => 'DB_NAME', 'type' => 'text:25:100', 'explain' => false),

- 'src_dbuser' => array('lang' => 'DB_USERNAME', 'type' => 'text:25:100', 'explain' => false),

- 'src_dbpasswd' => array('lang' => 'DB_PASSWORD', 'type' => 'password:25:100', 'explain' => false),

- 'src_table_prefix' => array('lang' => 'TABLE_PREFIX', 'type' => 'text:25:100', 'explain' => false),

- //'src_url' => array('lang' => 'FORUM_ADDRESS', 'type' => 'text:50:100', 'explain' => true),

- 'forum_path' => array('lang' => 'FORUM_PATH', 'type' => 'text:25:100', 'explain' => true),

- 'refresh' => array('lang' => 'REFRESH_PAGE', 'type' => 'radio:yes_no', 'explain' => true),

- );

-}

-<?php

-/**

-*

-* This file is part of the phpBB Forum Software package.

-*

-* @copyright (c) phpBB Limited <https://www.phpbb.com>

-* @license GNU General Public License, version 2 (GPL-2.0)

-*

-* For full copyright and license information, please see

-* the docs/CREDITS.txt file.

-*

-*/

-

-/**

-*/

-if (!defined('IN_INSTALL'))

-{

- // Someone has tried to access the file direct. This is not a good idea, so exit

- exit;

-}

-

-if (!empty($setmodules))

-{

- // If phpBB is already installed we do not include this module

- if (phpbb_check_installation_exists($phpbb_root_path, $phpEx) && !file_exists($phpbb_root_path . 'cache/install_lock'))

- {

- return;

- }

-

- $module[] = array(

- 'module_type' => 'install',

- 'module_title' => 'INSTALL',

- 'module_filename' => substr(basename(__FILE__), 0, -strlen($phpEx)-1),

- 'module_order' => 10,

- 'module_subs' => '',

- 'module_stages' => array('INTRO', 'REQUIREMENTS', 'DATABASE', 'ADMINISTRATOR', 'CONFIG_FILE', 'ADVANCED', 'CREATE_TABLE', 'FINAL'),

- 'module_reqs' => ''

- );

-}

-

-/**

-* Installation

-*/

-class install_install extends module

-{

- /**

- * @var \phpbb\filesystem\filesystem_interface

- */

- protected $filesystem;

-

- function install_install(&$p_master)

- {

- $this->p_master = &$p_master;

- $this->filesystem = new \phpbb\filesystem\filesystem();

- }

-

- function main($mode, $sub)

- {

- global $lang, $template, $language, $phpbb_root_path, $phpEx;

- global $phpbb_container, $cache, $phpbb_log, $request, $phpbb_config_php_file;

-

- switch ($sub)

- {

- case 'intro':

- $phpbb_container->get('cache.driver')->purge();

-

- $this->page_title = $lang['SUB_INTRO'];

-

- $template->assign_vars(array(

- 'TITLE' => $lang['INSTALL_INTRO'],

- 'BODY' => $lang['INSTALL_INTRO_BODY'],

- 'L_SUBMIT' => $lang['NEXT_STEP'],

- 'S_LANG_SELECT' => '<select id="language" name="language">' . $this->p_master->inst_language_select($language) . '</select>',

- 'U_ACTION' => $this->p_master->module_url . "?mode=$mode&amp;sub=requirements&amp;language=$language",

- ));

-

- break;

-

- case 'requirements':

- $this->check_server_requirements($mode, $sub);

-

- break;

-

- case 'database':

- $this->obtain_database_settings($mode, $sub);

-

- break;

-

- case 'administrator':

- $this->obtain_admin_settings($mode, $sub);

-

- break;

-

- case 'config_file':

- $this->create_config_file($mode, $sub);

-

- break;

-

- case 'advanced':

- $this->obtain_advanced_settings($mode, $sub);

-

- break;

-

- case 'create_table':

- $this->load_schema($mode, $sub);

- break;

-

- case 'final':

- // Enable super globals to prevent issues with the new \phpbb\request\request object

- $request->enable_super_globals();

-

- // Create a normal container now

- $phpbb_container_builder = new \phpbb\di\container_builder($phpbb_root_path, $phpEx);

- $phpbb_container = $phpbb_container_builder->with_config($phpbb_config_php_file)->get_container();

-

- // Sets the global variables

- /* @var $cache \phpbb\cache\service */

- $cache = $phpbb_container->get('cache');

-

- /* @var $phpbb_log \phpbb\log\log_interface */

- $phpbb_log = $phpbb_container->get('log');

-

- $this->build_search_index($mode, $sub);

- $this->add_modules($mode, $sub);

- $this->add_language($mode, $sub);

- $this->add_bots($mode, $sub);

- $this->email_admin($mode, $sub);

- $this->disable_avatars_if_unwritable();

- $this->populate_migrations($phpbb_container->get('ext.manager'), $phpbb_container->get('migrator'));

-

- // Remove the lock file

- @unlink($phpbb_root_path . 'cache/install_lock');

-

- break;

- }

-

- $this->tpl_name = 'install_install';

- }

-

- /**

- * Checks that the server we are installing on meets the requirements for running phpBB

- */

- function check_server_requirements($mode, $sub)

- {

- global $lang, $template, $phpbb_root_path, $phpEx, $language;

-

- $this->page_title = $lang['STAGE_REQUIREMENTS'];

-

- $template->assign_vars(array(

- 'TITLE' => $lang['REQUIREMENTS_TITLE'],

- 'BODY' => $lang['REQUIREMENTS_EXPLAIN'],

- ));

-

- $passed = array('php' => false, 'db' => false, 'files' => false, 'pcre' => false, 'imagesize' => false, 'json' => false,);

-

- // Test for basic PHP settings

- $template->assign_block_vars('checks', array(

- 'S_LEGEND' => true,

- 'LEGEND' => $lang['PHP_SETTINGS'],

- 'LEGEND_EXPLAIN' => $lang['PHP_SETTINGS_EXPLAIN'],

- ));

-

- // Test the minimum PHP version

- $php_version = PHP_VERSION;

-

- if (version_compare($php_version, '5.4') < 0)

- {

- $result = '<strong style="color:red">' . $lang['NO'] . '</strong>';

- }

- else

- {

- $passed['php'] = true;

-

- // We also give feedback on whether we're running in safe mode

- $result = '<strong style="color:green">' . $lang['YES'];

- if (@ini_get('safe_mode') == '1' || strtolower(@ini_get('safe_mode')) == 'on')

- {

- $result .= ', ' . $lang['PHP_SAFE_MODE'];

- }

- $result .= '</strong>';

- }

-

- $template->assign_block_vars('checks', array(

- 'TITLE' => $lang['PHP_VERSION_REQD'],

- 'RESULT' => $result,

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

- ));

-

- // Don't check for register_globals on 5.4+

- if (version_compare($php_version, '5.4.0-dev') < 0)

- {

- // Check for register_globals being enabled

- if (@ini_get('register_globals') == '1' || strtolower(@ini_get('register_globals')) == 'on')

- {

- $result = '<strong style="color:red">' . $lang['NO'] . '</strong>';

- }

- else

- {

- $result = '<strong style="color:green">' . $lang['YES'] . '</strong>';

- }

-

- $template->assign_block_vars('checks', array(

- 'TITLE' => $lang['PHP_REGISTER_GLOBALS'],

- 'TITLE_EXPLAIN' => $lang['PHP_REGISTER_GLOBALS_EXPLAIN'],

- 'RESULT' => $result,

-

- 'S_EXPLAIN' => true,

- 'S_LEGEND' => false,

- ));

- }

-

- // Check for url_fopen

- if (@ini_get('allow_url_fopen') == '1' || strtolower(@ini_get('allow_url_fopen')) == 'on')

- {

- $result = '<strong style="color:green">' . $lang['YES'] . '</strong>';

- }

- else

- {

- $result = '<strong style="color:red">' . $lang['NO'] . '</strong>';

- }

-

- $template->assign_block_vars('checks', array(

- 'TITLE' => $lang['PHP_URL_FOPEN_SUPPORT'],

- 'TITLE_EXPLAIN' => $lang['PHP_URL_FOPEN_SUPPORT_EXPLAIN'],

- 'RESULT' => $result,

-

- 'S_EXPLAIN' => true,

- 'S_LEGEND' => false,

- ));

-

- // Check for getimagesize

- if (@function_exists('getimagesize'))

- {

- $passed['imagesize'] = true;

- $result = '<strong style="color:green">' . $lang['YES'] . '</strong>';

- }

- else

- {

- $result = '<strong style="color:red">' . $lang['NO'] . '</strong>';

- }

-

- $template->assign_block_vars('checks', array(

- 'TITLE' => $lang['PHP_GETIMAGESIZE_SUPPORT'],

- 'TITLE_EXPLAIN' => $lang['PHP_GETIMAGESIZE_SUPPORT_EXPLAIN'],

- 'RESULT' => $result,

-

- 'S_EXPLAIN' => true,

- 'S_LEGEND' => false,

- ));

-

- // Check for PCRE UTF-8 support

- if (@preg_match('//u', ''))

- {

- $passed['pcre'] = true;

- $result = '<strong style="color:green">' . $lang['YES'] . '</strong>';

- }

- else

- {

- $result = '<strong style="color:red">' . $lang['NO'] . '</strong>';

- }

-

- $template->assign_block_vars('checks', array(

- 'TITLE' => $lang['PCRE_UTF_SUPPORT'],

- 'TITLE_EXPLAIN' => $lang['PCRE_UTF_SUPPORT_EXPLAIN'],

- 'RESULT' => $result,

-

- 'S_EXPLAIN' => true,

- 'S_LEGEND' => false,

- ));

-

- // Check for php json support

- if (@extension_loaded('json'))

- {

- $passed['json'] = true;

- $result = '<strong style="color:green">' . $lang['YES'] . '</strong>';

- }

- else

- {

- $result = '<strong style="color:red">' . $lang['NO'] . '</strong>';

- }

-

- $template->assign_block_vars('checks', array(

- 'TITLE' => $lang['PHP_JSON_SUPPORT'],

- 'TITLE_EXPLAIN' => $lang['PHP_JSON_SUPPORT_EXPLAIN'],

- 'RESULT' => $result,

-

- 'S_EXPLAIN' => true,

- 'S_LEGEND' => false,

- ));

-

- $passed['mbstring'] = true;

- if (@extension_loaded('mbstring'))

- {

- // Test for available database modules

- $template->assign_block_vars('checks', array(

- 'S_LEGEND' => true,

- 'LEGEND' => $lang['MBSTRING_CHECK'],

- 'LEGEND_EXPLAIN' => $lang['MBSTRING_CHECK_EXPLAIN'],

- ));

-

- $checks = array(

- array('func_overload', '&', MB_OVERLOAD_MAIL|MB_OVERLOAD_STRING),

- array('encoding_translation', '!=', 0),

- array('http_input', '!=', array('pass', '')),

- array('http_output', '!=', array('pass', ''))

- );

-

- foreach ($checks as $mb_checks)

- {

- $ini_val = @ini_get('mbstring.' . $mb_checks[0]);

- switch ($mb_checks[1])

- {

- case '&':

- if (intval($ini_val) & $mb_checks[2])

- {

- $result = '<strong style="color:red">' . $lang['NO'] . '</strong>';

- $passed['mbstring'] = false;

- }

- else

- {

- $result = '<strong style="color:green">' . $lang['YES'] . '</strong>';

- }

- break;

-

- case '!=':

- if (!is_array($mb_checks[2]) && $ini_val != $mb_checks[2] ||

- is_array($mb_checks[2]) && !in_array($ini_val, $mb_checks[2]))

- {

- $result = '<strong style="color:red">' . $lang['NO'] . '</strong>';

- $passed['mbstring'] = false;

- }

- else

- {

- $result = '<strong style="color:green">' . $lang['YES'] . '</strong>';

- }

- break;

- }

- $template->assign_block_vars('checks', array(

- 'TITLE' => $lang['MBSTRING_' . strtoupper($mb_checks[0])],

- 'TITLE_EXPLAIN' => $lang['MBSTRING_' . strtoupper($mb_checks[0]) . '_EXPLAIN'],

- 'RESULT' => $result,

-

- 'S_EXPLAIN' => true,

- 'S_LEGEND' => false,

- ));

- }

- }

-

- // Test for available database modules

- $template->assign_block_vars('checks', array(

- 'S_LEGEND' => true,

- 'LEGEND' => $lang['PHP_SUPPORTED_DB'],

- 'LEGEND_EXPLAIN' => $lang['PHP_SUPPORTED_DB_EXPLAIN'],

- ));

-

- $available_dbms = get_available_dbms(false, true);

- $passed['db'] = $available_dbms['ANY_DB_SUPPORT'];

- unset($available_dbms['ANY_DB_SUPPORT']);

-

- foreach ($available_dbms as $db_name => $db_ary)

- {

- if (!$db_ary['AVAILABLE'])

- {

- $template->assign_block_vars('checks', array(

- 'TITLE' => $lang['DLL_' . strtoupper($db_name)],

- 'RESULT' => '<span style="color:red">' . $lang['UNAVAILABLE'] . '</span>',

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

- ));

- }

- else

- {

- $template->assign_block_vars('checks', array(

- 'TITLE' => $lang['DLL_' . strtoupper($db_name)],

- 'RESULT' => '<strong style="color:green">' . $lang['AVAILABLE'] . '</strong>',

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

- ));

- }

- }

-

- // Test for other modules

- $template->assign_block_vars('checks', array(

- 'S_LEGEND' => true,

- 'LEGEND' => $lang['PHP_OPTIONAL_MODULE'],

- 'LEGEND_EXPLAIN' => $lang['PHP_OPTIONAL_MODULE_EXPLAIN'],

- ));

-

- foreach ($this->php_dlls_other as $dll)

- {

- if (!@extension_loaded($dll))

- {

- $template->assign_block_vars('checks', array(

- 'TITLE' => $lang['DLL_' . strtoupper($dll)],

- 'RESULT' => '<strong style="color:red">' . $lang['UNAVAILABLE'] . '</strong>',

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

- ));

- continue;

- }

-

- $template->assign_block_vars('checks', array(

- 'TITLE' => $lang['DLL_' . strtoupper($dll)],

- 'RESULT' => '<strong style="color:green">' . $lang['AVAILABLE'] . '</strong>',

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

- ));

- }

-

- // Can we find Imagemagick anywhere on the system?

- $exe = (DIRECTORY_SEPARATOR == '\\') ? '.exe' : '';

-

- $magic_home = getenv('MAGICK_HOME');

- $img_imagick = '';

- if (empty($magic_home))

- {

- $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/');

- $path_locations = str_replace('\\', '/', (explode(($exe) ? ';' : ':', getenv('PATH'))));

-

- $locations = array_merge($path_locations, $locations);

- foreach ($locations as $location)

- {

- // The path might not end properly, fudge it

- if (substr($location, -1, 1) !== '/')

- {

- $location .= '/';

- }

-

- if (@file_exists($location) && @is_readable($location . 'mogrify' . $exe) && @filesize($location . 'mogrify' . $exe) > 3000)

- {

- $img_imagick = str_replace('\\', '/', $location);

- continue;

- }

- }

- }

- else

- {

- $img_imagick = str_replace('\\', '/', $magic_home);

- }

-

- $template->assign_block_vars('checks', array(

- 'TITLE' => $lang['APP_MAGICK'],

- 'RESULT' => ($img_imagick) ? '<strong style="color:green">' . $lang['AVAILABLE'] . ', ' . $img_imagick . '</strong>' : '<strong style="color:blue">' . $lang['NO_LOCATION'] . '</strong>',

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

- ));

-

- // Check permissions on files/directories we need access to

- $template->assign_block_vars('checks', array(

- 'S_LEGEND' => true,

- 'LEGEND' => $lang['FILES_REQUIRED'],

- 'LEGEND_EXPLAIN' => $lang['FILES_REQUIRED_EXPLAIN'],

- ));

-

- $directories = array('cache/', 'files/', 'store/');

-

- umask(0);

-

- $passed['files'] = true;

- foreach ($directories as $dir)

- {

- $exists = $write = false;

-

- // Try to create the directory if it does not exist

- if (!file_exists($phpbb_root_path . $dir))

- {

- @mkdir($phpbb_root_path . $dir, 0777);

-

- try

- {

- $this->filesystem->phpbb_chmod($phpbb_root_path . $dir, CHMOD_READ | CHMOD_WRITE);

- }

- catch (\phpbb\filesystem\exception\filesystem_exception $e)

- {

- // Do nothing

- }

- }

-

- // Now really check

- if (file_exists($phpbb_root_path . $dir) && is_dir($phpbb_root_path . $dir))

- {

- try

- {

- $this->filesystem->phpbb_chmod($phpbb_root_path . $dir, CHMOD_READ | CHMOD_WRITE);

- }

- catch (\phpbb\filesystem\exception\filesystem_exception $e)

- {

- // Do nothing

- }

-

- $exists = true;

- }

-

- // Now check if it is writable by storing a simple file

- $fp = @fopen($phpbb_root_path . $dir . 'test_lock', 'wb');

- if ($fp !== false)

- {

- $write = true;

- }

- @fclose($fp);

-

- @unlink($phpbb_root_path . $dir . 'test_lock');

-

- $passed['files'] = ($exists && $write && $passed['files']) ? true : false;

-

- $exists = ($exists) ? '<strong style="color:green">' . $lang['FOUND'] . '</strong>' : '<strong style="color:red">' . $lang['NOT_FOUND'] . '</strong>';

- $write = ($write) ? ', <strong style="color:green">' . $lang['WRITABLE'] . '</strong>' : (($exists) ? ', <strong style="color:red">' . $lang['UNWRITABLE'] . '</strong>' : '');

-

- $template->assign_block_vars('checks', array(

- 'TITLE' => $dir,

- 'RESULT' => $exists . $write,

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

- ));

- }

-

- // Check permissions on files/directories it would be useful access to

- $template->assign_block_vars('checks', array(

- 'S_LEGEND' => true,

- 'LEGEND' => $lang['FILES_OPTIONAL'],

- 'LEGEND_EXPLAIN' => $lang['FILES_OPTIONAL_EXPLAIN'],

- ));

-

- $directories = array('config.' . $phpEx, 'images/avatars/upload/');

-

- foreach ($directories as $dir)

- {

- $write = $exists = true;

- if (file_exists($phpbb_root_path . $dir))

- {

- if (!$this->filesystem->is_writable($phpbb_root_path . $dir))

- {

- $write = false;

- }

- }

- else

- {

- $write = $exists = false;

- }

-

- $exists_str = ($exists) ? '<strong style="color:green">' . $lang['FOUND'] . '</strong>' : '<strong style="color:red">' . $lang['NOT_FOUND'] . '</strong>';

- $write_str = ($write) ? ', <strong style="color:green">' . $lang['WRITABLE'] . '</strong>' : (($exists) ? ', <strong style="color:red">' . $lang['UNWRITABLE'] . '</strong>' : '');

-

- $template->assign_block_vars('checks', array(

- 'TITLE' => $dir,

- 'RESULT' => $exists_str . $write_str,

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

- ));

- }

-

- // And finally where do we want to go next (well today is taken isn't it :P)

- $s_hidden_fields = ($img_imagick) ? '<input type="hidden" name="img_imagick" value="' . addslashes($img_imagick) . '" />' : '';

-

- $url = (!in_array(false, $passed)) ? $this->p_master->module_url . "?mode=$mode&amp;sub=database&amp;language=$language" : $this->p_master->module_url . "?mode=$mode&amp;sub=requirements&amp;language=$language ";

- $submit = (!in_array(false, $passed)) ? $lang['INSTALL_START'] : $lang['INSTALL_TEST'];

-

- $template->assign_vars(array(

- 'L_SUBMIT' => $submit,

- 'S_HIDDEN' => $s_hidden_fields,

- 'U_ACTION' => $url,

- ));

- }

-

- /**

- * Obtain the information required to connect to the database

- */

- function obtain_database_settings($mode, $sub)

- {

- global $lang, $template, $phpEx;

-

- $this->page_title = $lang['STAGE_DATABASE'];

-

- // Obtain any submitted data

- $data = $this->get_submitted_data();

-

- $connect_test = false;

- $error = array();

- $available_dbms = get_available_dbms(false, true);

-

- // Has the user opted to test the connection?

- if (isset($_POST['testdb']))

- {

- if (!isset($available_dbms[$data['dbms']]) || !$available_dbms[$data['dbms']]['AVAILABLE'])

- {

- $error[] = $lang['INST_ERR_NO_DB'];

- $connect_test = false;

- }

- else if (!preg_match(get_preg_expression('table_prefix'), $data['table_prefix']))

- {

- $error[] = $lang['INST_ERR_DB_INVALID_PREFIX'];

- $connect_test = false;

- }

- else

- {

- $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']);

- }

-

- $template->assign_block_vars('checks', array(

- 'S_LEGEND' => true,

- 'LEGEND' => $lang['DB_CONNECTION'],

- 'LEGEND_EXPLAIN' => false,

- ));

-

- if ($connect_test)

- {

- $template->assign_block_vars('checks', array(

- 'TITLE' => $lang['DB_TEST'],

- 'RESULT' => '<strong style="color:green">' . $lang['SUCCESSFUL_CONNECT'] . '</strong>',

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

- ));

- }

- else

- {

- $template->assign_block_vars('checks', array(

- 'TITLE' => $lang['DB_TEST'],

- 'RESULT' => '<strong style="color:red">' . implode('<br />', $error) . '</strong>',

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

- ));

- }

- }

-

- if (!$connect_test)

- {

- // Update the list of available DBMS modules to only contain those which can be used

- $available_dbms_temp = array();

- foreach ($available_dbms as $type => $dbms_ary)

- {

- if (!$dbms_ary['AVAILABLE'])

- {

- continue;

- }

-

- $available_dbms_temp[$type] = $dbms_ary;

- }

-

- $available_dbms = &$available_dbms_temp;

-

- // And now for the main part of this page

- $data['table_prefix'] = (!empty($data['table_prefix']) ? $data['table_prefix'] : 'phpbb_');

-

- foreach ($this->db_config_options as $config_key => $vars)

- {

- if (!is_array($vars) && strpos($config_key, 'legend') === false)

- {

- continue;

- }

-

- if (strpos($config_key, 'legend') !== false)

- {

- $template->assign_block_vars('options', array(

- 'S_LEGEND' => true,

- 'LEGEND' => $lang[$vars])

- );

-

- continue;

- }

-

- $options = isset($vars['options']) ? $vars['options'] : '';

-

- $template->assign_block_vars('options', array(

- 'KEY' => $config_key,

- 'TITLE' => $lang[$vars['lang']],

- 'S_EXPLAIN' => $vars['explain'],

- 'S_LEGEND' => false,

- 'TITLE_EXPLAIN' => ($vars['explain']) ? $lang[$vars['lang'] . '_EXPLAIN'] : '',

- 'CONTENT' => $this->p_master->input_field($config_key, $vars['type'], $data[$config_key], $options),

- )

- );

- }

- }

-

- // And finally where do we want to go next (well today is taken isn't it :P)

- $s_hidden_fields = ($data['img_imagick']) ? '<input type="hidden" name="img_imagick" value="' . addslashes($data['img_imagick']) . '" />' : '';

- $s_hidden_fields .= '<input type="hidden" name="language" value="' . $data['language'] . '" />';

- if ($connect_test)

- {

- foreach ($this->db_config_options as $config_key => $vars)

- {

- if (!is_array($vars))

- {

- continue;

- }

- $s_hidden_fields .= '<input type="hidden" name="' . $config_key . '" value="' . $data[$config_key] . '" />';

- }

- }

-

- $url = ($connect_test) ? $this->p_master->module_url . "?mode=$mode&amp;sub=administrator" : $this->p_master->module_url . "?mode=$mode&amp;sub=database";

- $s_hidden_fields .= ($connect_test) ? '' : '<input type="hidden" name="testdb" value="true" />';

-

- $submit = $lang['NEXT_STEP'];

-

- $template->assign_vars(array(

- 'L_SUBMIT' => $submit,

- 'S_HIDDEN' => $s_hidden_fields,

- 'U_ACTION' => $url,

- ));

- }

-

- /**

- * Obtain the administrator's name, password and email address

- */

- function obtain_admin_settings($mode, $sub)

- {

- global $lang, $template, $phpEx;

-

- $this->page_title = $lang['STAGE_ADMINISTRATOR'];

-

- // Obtain any submitted data

- $data = $this->get_submitted_data();

-

- if ($data['dbms'] == '')

- {

- // Someone's been silly and tried calling this page direct

- // So we send them back to the start to do it again properly

- $this->p_master->redirect("index.$phpEx?mode=install");

- }

-

- $s_hidden_fields = ($data['img_imagick']) ? '<input type="hidden" name="img_imagick" value="' . addslashes($data['img_imagick']) . '" />' : '';

- $passed = false;

-

- $data['default_lang'] = ($data['default_lang'] !== '') ? $data['default_lang'] : $data['language'];

-

- if (isset($_POST['check']))

- {

- $error = array();

-

- // Check the entered email address and password

- if ($data['admin_name'] == '' || $data['admin_pass1'] == '' || $data['admin_pass2'] == '' || $data['board_email'] == '')

- {

- $error[] = $lang['INST_ERR_MISSING_DATA'];

- }

-

- if ($data['admin_pass1'] != $data['admin_pass2'] && $data['admin_pass1'] != '')

- {

- $error[] = $lang['INST_ERR_PASSWORD_MISMATCH'];

- }

-

- // Test against the default username rules

- if ($data['admin_name'] != '' && utf8_strlen($data['admin_name']) < 3)

- {

- $error[] = $lang['INST_ERR_USER_TOO_SHORT'];

- }

-

- if ($data['admin_name'] != '' && utf8_strlen($data['admin_name']) > 20)

- {

- $error[] = $lang['INST_ERR_USER_TOO_LONG'];

- }

-

- // Test against the default password rules

- if ($data['admin_pass1'] != '' && utf8_strlen($data['admin_pass1']) < 6)

- {

- $error[] = $lang['INST_ERR_PASSWORD_TOO_SHORT'];

- }

-

- if ($data['admin_pass1'] != '' && utf8_strlen($data['admin_pass1']) > 30)

- {

- $error[] = $lang['INST_ERR_PASSWORD_TOO_LONG'];

- }

-

- if ($data['board_email'] != '' && !preg_match('/^' . get_preg_expression('email') . '$/i', $data['board_email']))

- {

- $error[] = $lang['INST_ERR_EMAIL_INVALID'];

- }

-

- $template->assign_block_vars('checks', array(

- 'S_LEGEND' => true,

- 'LEGEND' => $lang['STAGE_ADMINISTRATOR'],

- 'LEGEND_EXPLAIN' => false,

- ));

-

- if (!sizeof($error))

- {

- $passed = true;

- $template->assign_block_vars('checks', array(

- 'TITLE' => $lang['ADMIN_TEST'],

- 'RESULT' => '<strong style="color:green">' . $lang['TESTS_PASSED'] . '</strong>',

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

- ));

- }

- else

- {

- $template->assign_block_vars('checks', array(

- 'TITLE' => $lang['ADMIN_TEST'],

- 'RESULT' => '<strong style="color:red">' . implode('<br />', $error) . '</strong>',

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

- ));

- }

- }

-

- if (!$passed)

- {

- foreach ($this->admin_config_options as $config_key => $vars)

- {

- if (!is_array($vars) && strpos($config_key, 'legend') === false)

- {

- continue;

- }

-

- if (strpos($config_key, 'legend') !== false)

- {

- $template->assign_block_vars('options', array(

- 'S_LEGEND' => true,

- 'LEGEND' => $lang[$vars])

- );

-

- continue;

- }

-

- $options = isset($vars['options']) ? $vars['options'] : '';

-

- $template->assign_block_vars('options', array(

- 'KEY' => $config_key,

- 'TITLE' => $lang[$vars['lang']],

- 'S_EXPLAIN' => $vars['explain'],

- 'S_LEGEND' => false,

- 'TITLE_EXPLAIN' => ($vars['explain']) ? $lang[$vars['lang'] . '_EXPLAIN'] : '',

- 'CONTENT' => $this->p_master->input_field($config_key, $vars['type'], $data[$config_key], $options),

- )

- );

- }

- }

- else

- {

- foreach ($this->admin_config_options as $config_key => $vars)

- {

- if (!is_array($vars))

- {

- continue;

- }

- $s_hidden_fields .= '<input type="hidden" name="' . $config_key . '" value="' . $data[$config_key] . '" />';

- }

- }

-

- $s_hidden_fields .= ($data['img_imagick']) ? '<input type="hidden" name="img_imagick" value="' . addslashes($data['img_imagick']) . '" />' : '';

- $s_hidden_fields .= '<input type="hidden" name="language" value="' . $data['language'] . '" />';

-

- foreach ($this->db_config_options as $config_key => $vars)

- {

- if (!is_array($vars))

- {

- continue;

- }

- $s_hidden_fields .= '<input type="hidden" name="' . $config_key . '" value="' . $data[$config_key] . '" />';

- }

-

- $submit = $lang['NEXT_STEP'];

-

- $url = ($passed) ? $this->p_master->module_url . "?mode=$mode&amp;sub=config_file" : $this->p_master->module_url . "?mode=$mode&amp;sub=administrator";

- $s_hidden_fields .= ($passed) ? '' : '<input type="hidden" name="check" value="true" />';

-

- $template->assign_vars(array(

- 'L_SUBMIT' => $submit,

- 'S_HIDDEN' => $s_hidden_fields,

- 'U_ACTION' => $url,

- ));

- }

-

- /**

- * Writes the config file to disk, or if unable to do so offers alternative methods

- */

- function create_config_file($mode, $sub)

- {

- global $lang, $template, $phpbb_root_path, $phpEx;

-

- $this->page_title = $lang['STAGE_CONFIG_FILE'];

-

- // Obtain any submitted data

- $data = $this->get_submitted_data();

-

- if ($data['dbms'] == '')

- {

- // Someone's been silly and tried calling this page direct

- // So we send them back to the start to do it again properly

- $this->p_master->redirect("index.$phpEx?mode=install");

- }

-

- $s_hidden_fields = ($data['img_imagick']) ? '<input type="hidden" name="img_imagick" value="' . addslashes($data['img_imagick']) . '" />' : '';

- $s_hidden_fields .= '<input type="hidden" name="language" value="' . $data['language'] . '" />';

- $written = false;

-

- // Create a list of any PHP modules we wish to have loaded

- $available_dbms = get_available_dbms($data['dbms']);

-

- // Create a lock file to indicate that there is an install in progress

- $fp = @fopen($phpbb_root_path . 'cache/install_lock', 'wb');

- if ($fp === false)

- {

- // We were unable to create the lock file - abort

- $this->p_master->error($lang['UNABLE_WRITE_LOCK'], __LINE__, __FILE__);

- }

- @fclose($fp);

-

- @chmod($phpbb_root_path . 'cache/install_lock', 0777);

-

- // Time to convert the data provided into a config file

- $config_data = phpbb_create_config_file_data($data, $available_dbms[$data['dbms']]['DRIVER']);

-

- // Attempt to write out the config file directly. If it works, this is the easiest way to do it ...

- if ((file_exists($phpbb_root_path . 'config.' . $phpEx) && $this->filesystem->is_writable($phpbb_root_path . 'config.' . $phpEx)) || $this->filesystem->is_writable($phpbb_root_path))

- {

- // Assume it will work ... if nothing goes wrong below

- $written = true;

-

- if (!($fp = @fopen($phpbb_root_path . 'config.' . $phpEx, 'w')))

- {

- // Something went wrong ... so let's try another method

- $written = false;

- }

-

- if (!(@fwrite($fp, $config_data)))

- {

- // Something went wrong ... so let's try another method

- $written = false;

- }

-

- @fclose($fp);

-

- if ($written)

- {

- // We may revert back to chmod() if we see problems with users not able to change their config.php file directly

- try

- {

- $this->filesystem->phpbb_chmod($phpbb_root_path . 'config.' . $phpEx, CHMOD_READ);

- }

- catch (\phpbb\filesystem\exception\filesystem_exception $e)

- {

- // Do nothing

- }

- }

- }

-

- if (isset($_POST['dldone']))

- {

- // Do a basic check to make sure that the file has been uploaded

- // Note that all we check is that the file has _something_ in it

- // We don't compare the contents exactly - if they can't upload

- // a single file correctly, it's likely they will have other problems....

- if (filesize($phpbb_root_path . 'config.' . $phpEx) > 10)

- {

- $written = true;

- }

- }

-

- $config_options = array_merge($this->db_config_options, $this->admin_config_options);

-

- foreach ($config_options as $config_key => $vars)

- {

- if (!is_array($vars))

- {

- continue;

- }

- $s_hidden_fields .= '<input type="hidden" name="' . $config_key . '" value="' . $data[$config_key] . '" />';

- }

-

- if (!$written)

- {

- // OK, so it didn't work let's try the alternatives

-

- if (isset($_POST['dlconfig']))

- {

- // They want a copy of the file to download, so send the relevant headers and dump out the data

- header("Content-Type: text/x-delimtext; name=\"config.$phpEx\"");

- header("Content-disposition: attachment; filename=config.$phpEx");

- echo $config_data;

- exit;

- }

-

- // The option to download the config file is always available, so output it here

- $template->assign_vars(array(

- 'BODY' => $lang['CONFIG_FILE_UNABLE_WRITE'],

- 'L_DL_CONFIG' => $lang['DL_CONFIG'],

- 'L_DL_CONFIG_EXPLAIN' => $lang['DL_CONFIG_EXPLAIN'],

- 'L_DL_DONE' => $lang['DONE'],

- 'L_DL_DOWNLOAD' => $lang['DL_DOWNLOAD'],

- 'S_HIDDEN' => $s_hidden_fields,

- 'S_SHOW_DOWNLOAD' => true,

- 'U_ACTION' => $this->p_master->module_url . "?mode=$mode&amp;sub=config_file",

- ));

- return;

- }

- else

- {

- $template->assign_vars(array(

- 'BODY' => $lang['CONFIG_FILE_WRITTEN'],

- 'L_SUBMIT' => $lang['NEXT_STEP'],

- 'S_HIDDEN' => $s_hidden_fields,

- 'U_ACTION' => $this->p_master->module_url . "?mode=$mode&amp;sub=advanced",

- ));

- return;

- }

- }

-

- /**

- * Provide an opportunity to customise some advanced settings during the install

- * in case it is necessary for them to be set to access later

- */

- function obtain_advanced_settings($mode, $sub)

- {

- global $lang, $template, $phpEx, $request;

-

- $this->page_title = $lang['STAGE_ADVANCED'];

-

- // Obtain any submitted data

- $data = $this->get_submitted_data();

-

- if ($data['dbms'] == '')

- {

- // Someone's been silly and tried calling this page direct

- // So we send them back to the start to do it again properly

- $this->p_master->redirect("index.$phpEx?mode=install");

- }

-

- $s_hidden_fields = ($data['img_imagick']) ? '<input type="hidden" name="img_imagick" value="' . addslashes($data['img_imagick']) . '" />' : '';

- $s_hidden_fields .= '<input type="hidden" name="language" value="' . $data['language'] . '" />';

-

- // HTTP_HOST is having the correct browser url in most cases...

- $server_name = strtolower(htmlspecialchars_decode($request->header('Host', $request->server('SERVER_NAME'))));

-

- // HTTP HOST can carry a port number...

- if (strpos($server_name, ':') !== false)

- {

- $server_name = substr($server_name, 0, strpos($server_name, ':'));

- }

-

- $data['email_enable'] = ($data['email_enable'] !== '') ? $data['email_enable'] : true;

- $data['server_name'] = ($data['server_name'] !== '') ? $data['server_name'] : $server_name;

- $data['server_port'] = ($data['server_port'] !== '') ? $data['server_port'] : $request->server('SERVER_PORT', 0);

- $data['server_protocol'] = ($data['server_protocol'] !== '') ? $data['server_protocol'] : ($request->is_secure() ? 'https://' : 'http://');

- $data['cookie_secure'] = ($data['cookie_secure'] !== '') ? $data['cookie_secure'] : $request->is_secure();

-

- if ($data['script_path'] === '')

- {

- $name = htmlspecialchars_decode($request->server('PHP_SELF'));

- if (!$name)

- {

- $name = htmlspecialchars_decode($request->server('REQUEST_URI'));

- }

-

- // Replace backslashes and doubled slashes (could happen on some proxy setups)

- $name = str_replace(array('\\', '//'), '/', $name);

- $data['script_path'] = trim(dirname(dirname($name)));

- }

-

- foreach ($this->advanced_config_options as $config_key => $vars)

- {

- if (!is_array($vars) && strpos($config_key, 'legend') === false)

- {

- continue;

- }

-

- if (strpos($config_key, 'legend') !== false)

- {

- $template->assign_block_vars('options', array(

- 'S_LEGEND' => true,

- 'LEGEND' => $lang[$vars])

- );

-

- continue;

- }

-

- $options = isset($vars['options']) ? $vars['options'] : '';

-

- $template->assign_block_vars('options', array(

- 'KEY' => $config_key,

- 'TITLE' => $lang[$vars['lang']],

- 'S_EXPLAIN' => $vars['explain'],

- 'S_LEGEND' => false,

- 'TITLE_EXPLAIN' => ($vars['explain']) ? $lang[$vars['lang'] . '_EXPLAIN'] : '',

- 'CONTENT' => $this->p_master->input_field($config_key, $vars['type'], $data[$config_key], $options),

- )

- );

- }

-

- $config_options = array_merge($this->db_config_options, $this->admin_config_options);

- foreach ($config_options as $config_key => $vars)

- {

- if (!is_array($vars))

- {

- continue;

- }

- $s_hidden_fields .= '<input type="hidden" name="' . $config_key . '" value="' . $data[$config_key] . '" />';

- }

-

- $submit = $lang['NEXT_STEP'];

-

- $url = $this->p_master->module_url . "?mode=$mode&amp;sub=create_table";

-

- $template->assign_vars(array(

- 'BODY' => $lang['STAGE_ADVANCED_EXPLAIN'],

- 'L_SUBMIT' => $submit,

- 'S_HIDDEN' => $s_hidden_fields,

- 'U_ACTION' => $url,

- ));

- }

-

- /**

- * Load the contents of the schema into the database and then alter it based on what has been input during the installation

- */

- function load_schema($mode, $sub)

- {

- global $db, $lang, $template, $phpbb_root_path, $phpEx, $request;

-

- $this->page_title = $lang['STAGE_CREATE_TABLE'];

- $s_hidden_fields = '';

-

- // Obtain any submitted data

- $data = $this->get_submitted_data();

-

- if ($data['dbms'] == '')

- {

- // Someone's been silly and tried calling this page direct

- // So we send them back to the start to do it again properly

- $this->p_master->redirect("index.$phpEx?mode=install");

- }

-

- // HTTP_HOST is having the correct browser url in most cases...

- $server_name = strtolower(htmlspecialchars_decode($request->header('Host', $request->server('SERVER_NAME'))));

- $referer = strtolower($request->header('Referer'));

-

- // HTTP HOST can carry a port number...

- if (strpos($server_name, ':') !== false)

- {

- $server_name = substr($server_name, 0, strpos($server_name, ':'));

- }

-

- $cookie_domain = ($data['server_name'] != '') ? $data['server_name'] : $server_name;

-

- // Try to come up with the best solution for cookie domain...

- if (strpos($cookie_domain, 'www.') === 0)

- {

- $cookie_domain = str_replace('www.', '.', $cookie_domain);

- }

-

- // If we get here and the extension isn't loaded it should be safe to just go ahead and load it

- $available_dbms = get_available_dbms($data['dbms']);

-

- if (!isset($available_dbms[$data['dbms']]))

- {

- // Someone's been silly and tried providing a non-existant dbms

- $this->p_master->redirect("index.$phpEx?mode=install");

- }

-

- $dbms = $available_dbms[$data['dbms']]['DRIVER'];

-

- // Instantiate the database

- $db = new $dbms();

- $db->sql_connect($data['dbhost'], $data['dbuser'], htmlspecialchars_decode($data['dbpasswd']), $data['dbname'], $data['dbport'], false, false);

-

- // NOTE: trigger_error does not work here.

- $db->sql_return_on_error(true);

-

- // If mysql is chosen, we need to adjust the schema filename slightly to reflect the correct version. ;)

- if ($data['dbms'] == 'mysql')

- {

- if (version_compare($db->sql_server_info(true), '4.1.3', '>='))

- {

- $available_dbms[$data['dbms']]['SCHEMA'] .= '_41';

- }

- else

- {

- $available_dbms[$data['dbms']]['SCHEMA'] .= '_40';

- }

- }

-

- // Ok we have the db info go ahead and read in the relevant schema

- // and work on building the table

- $dbms_schema = 'schemas/' . $available_dbms[$data['dbms']]['SCHEMA'] . '_schema.sql';

-

- // How should we treat this schema?

- $delimiter = $available_dbms[$data['dbms']]['DELIM'];

-

- if (file_exists($dbms_schema))

- {

- $sql_query = @file_get_contents($dbms_schema);

- $sql_query = preg_replace('#phpbb_#i', $data['table_prefix'], $sql_query);

- $sql_query = phpbb_remove_comments($sql_query);

- $sql_query = split_sql_file($sql_query, $delimiter);

-

- foreach ($sql_query as $sql)

- {

- // Ignore errors when the functions or types already exist

- // to allow installing phpBB twice in the same database with

- // a different prefix

- $db->sql_query($sql);

- }

- unset($sql_query);

- }

-

- // Ok we have the db info go ahead and work on building the table

- if (file_exists('schemas/schema.json'))

- {

- $db_table_schema = @file_get_contents('schemas/schema.json');

- $db_table_schema = json_decode($db_table_schema, true);

- }

- else

- {

- global $phpbb_root_path, $phpEx, $table_prefix;

- $table_prefix = 'phpbb_';

-

- if (!defined('CONFIG_TABLE'))

- {

- // We need to include the constants file for the table constants

- // when we generate the schema from the migration files.

- include($phpbb_root_path . 'includes/constants.' . $phpEx);

- }

-

- $finder = new \phpbb\finder(new \phpbb\filesystem\filesystem(), $phpbb_root_path, null, $phpEx);

- $classes = $finder->core_path('phpbb/db/migration/data/')

- ->get_classes();

-

- $sqlite_db = new \phpbb\db\driver\sqlite();

- $factory = new \phpbb\db\tools\factory();

- $db_tools = $factory->get($sqlite_db, true);

- $schema_generator = new \phpbb\db\migration\schema_generator($classes, new \phpbb\config\config(array()), $sqlite_db, $db_tools, $phpbb_root_path, $phpEx, $table_prefix);

- $db_table_schema = $schema_generator->get_schema();

- }

-

- if (!defined('CONFIG_TABLE'))

- {

- // CONFIG_TABLE is required by sql_create_index() to check the

- // length of index names. However table_prefix is not defined

- // here yet, so we need to create the constant ourselves.

- define('CONFIG_TABLE', $data['table_prefix'] . 'config');

- }

-

- $factory = new \phpbb\db\tools\factory();

- $db_tools = $factory->get($db);

- foreach ($db_table_schema as $table_name => $table_data)

- {

- $db_tools->sql_create_table(

- $data['table_prefix'] . substr($table_name, 6),

- $table_data

- );

- }

-

- // Ok tables have been built, let's fill in the basic information

- $sql_query = file_get_contents('schemas/schema_data.sql');

-

- // Deal with any special comments and characters

- switch ($data['dbms'])

- {

- case 'mssql':

- case 'mssql_odbc':

- case 'mssqlnative':

- $sql_query = preg_replace('#\# MSSQL IDENTITY (phpbb_[a-z_]+) (ON|OFF) \##s', 'SET IDENTITY_INSERT \1 \2;', $sql_query);

- break;

-

- case 'postgres':

- $sql_query = preg_replace('#\# POSTGRES (BEGIN|COMMIT) \##s', '\1; ', $sql_query);

- break;

-

- case 'mysql':

- case 'mysqli':

- $sql_query = str_replace('\\', '\\\\', $sql_query);

- break;

- }

-

- // Change prefix

- $sql_query = preg_replace('# phpbb_([^\s]*) #i', ' ' . $data['table_prefix'] . '\1 ', $sql_query);

-

- // Change language strings...

- $sql_query = preg_replace_callback('#\{L_([A-Z0-9\-_]*)\}#s', 'adjust_language_keys_callback', $sql_query);

-

- $sql_query = phpbb_remove_comments($sql_query);

- $sql_query = split_sql_file($sql_query, ';');

-

- foreach ($sql_query as $sql)

- {

- //$sql = trim(str_replace('|', ';', $sql));

- if (!$db->sql_query($sql))

- {

- $error = $db->sql_error();

- $this->p_master->db_error($error['message'], $sql, __LINE__, __FILE__);

- }

- }

- unset($sql_query);

-

- $current_time = time();

-

- $user_ip = $request->server('REMOTE_ADDR') ? phpbb_ip_normalise($request->server('REMOTE_ADDR')) : '';

-

- if ($data['script_path'] !== '/')

- {

- // Adjust destination path (no trailing slash)

- if (substr($data['script_path'], -1) == '/')

- {

- $data['script_path'] = substr($data['script_path'], 0, -1);

- }

-

- $data['script_path'] = str_replace(array('../', './'), '', $data['script_path']);

-

- if ($data['script_path'][0] != '/')

- {

- $data['script_path'] = '/' . $data['script_path'];

- }

- }

-

- // Set default config and post data, this applies to all DB's

- $sql_ary = array(

- 'INSERT INTO ' . $data['table_prefix'] . "config (config_name, config_value)

- VALUES ('board_startdate', '$current_time')",

-

- 'INSERT INTO ' . $data['table_prefix'] . "config (config_name, config_value)

- VALUES ('default_lang', '" . $db->sql_escape($data['default_lang']) . "')",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['img_imagick']) . "'

- WHERE config_name = 'img_imagick'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['server_name']) . "'

- WHERE config_name = 'server_name'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['server_port']) . "'

- WHERE config_name = 'server_port'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['board_email']) . "'

- WHERE config_name = 'board_email'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['board_email']) . "'

- WHERE config_name = 'board_contact'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($cookie_domain) . "'

- WHERE config_name = 'cookie_domain'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($lang['default_dateformat']) . "'

- WHERE config_name = 'default_dateformat'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['email_enable']) . "'

- WHERE config_name = 'email_enable'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['smtp_delivery']) . "'

- WHERE config_name = 'smtp_delivery'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['smtp_host']) . "'

- WHERE config_name = 'smtp_host'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['smtp_auth']) . "'

- WHERE config_name = 'smtp_auth_method'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['smtp_user']) . "'

- WHERE config_name = 'smtp_username'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['smtp_pass']) . "'

- WHERE config_name = 'smtp_password'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['cookie_secure']) . "'

- WHERE config_name = 'cookie_secure'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['force_server_vars']) . "'

- WHERE config_name = 'force_server_vars'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['script_path']) . "'

- WHERE config_name = 'script_path'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['server_protocol']) . "'

- WHERE config_name = 'server_protocol'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['admin_name']) . "'

- WHERE config_name = 'newest_username'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . md5(mt_rand()) . "'

- WHERE config_name = 'avatar_salt'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . md5(mt_rand()) . "'

- WHERE config_name = 'plupload_salt'",

-

- 'UPDATE ' . $data['table_prefix'] . "users

- 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'])) . "'

- WHERE username = 'Admin'",

-

- 'UPDATE ' . $data['table_prefix'] . "moderator_cache

- SET username = '" . $db->sql_escape($data['admin_name']) . "'

- WHERE username = 'Admin'",

-

- 'UPDATE ' . $data['table_prefix'] . "forums

- SET forum_last_poster_name = '" . $db->sql_escape($data['admin_name']) . "'

- WHERE forum_last_poster_name = 'Admin'",

-

- 'UPDATE ' . $data['table_prefix'] . "topics

- SET topic_first_poster_name = '" . $db->sql_escape($data['admin_name']) . "', topic_last_poster_name = '" . $db->sql_escape($data['admin_name']) . "'

- WHERE topic_first_poster_name = 'Admin'

- OR topic_last_poster_name = 'Admin'",

-

- 'UPDATE ' . $data['table_prefix'] . "users

- SET user_regdate = $current_time",

-

- 'UPDATE ' . $data['table_prefix'] . "posts

- SET post_time = $current_time, poster_ip = '" . $db->sql_escape($user_ip) . "'",

-

- 'UPDATE ' . $data['table_prefix'] . "topics

- SET topic_time = $current_time, topic_last_post_time = $current_time",

-

- 'UPDATE ' . $data['table_prefix'] . "forums

- SET forum_last_post_time = $current_time",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($db->sql_server_info(true)) . "'

- WHERE config_name = 'dbms_version'",

- );

-

- if (@extension_loaded('gd'))

- {

- $sql_ary[] = 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = 'core.captcha.plugins.gd'

- WHERE config_name = 'captcha_plugin'";

-

- $sql_ary[] = 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '1'

- WHERE config_name = 'captcha_gd'";

- }

-

- $ref = substr($referer, strpos($referer, '://') + 3);

-

- if (!(stripos($ref, $server_name) === 0))

- {

- $sql_ary[] = 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '0'

- WHERE config_name = 'referer_validation'";

- }

-

- // We set a (semi-)unique cookie name to bypass login issues related to the cookie name.

- $cookie_name = 'phpbb3_';

- $rand_str = md5(mt_rand());

- $rand_str = str_replace('0', 'z', base_convert($rand_str, 16, 35));

- $rand_str = substr($rand_str, 0, 5);

- $cookie_name .= strtolower($rand_str);

-

- $sql_ary[] = 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($cookie_name) . "'

- WHERE config_name = 'cookie_name'";

-

- foreach ($sql_ary as $sql)

- {

- //$sql = trim(str_replace('|', ';', $sql));

-

- if (!$db->sql_query($sql))

- {

- $error = $db->sql_error();

- $this->p_master->db_error($error['message'], $sql, __LINE__, __FILE__);

- }

- }

-

- $submit = $lang['NEXT_STEP'];

-

- $url = $this->p_master->module_url . "?mode=$mode&amp;sub=final";

-

- $template->assign_vars(array(

- 'BODY' => $lang['STAGE_CREATE_TABLE_EXPLAIN'],

- 'L_SUBMIT' => $submit,

- 'S_HIDDEN' => build_hidden_fields($data),

- 'U_ACTION' => $url,

- ));

- }

-

- /**

- * Build the search index...

- */

- function build_search_index($mode, $sub)

- {

- global $db, $lang, $phpbb_root_path, $phpbb_dispatcher, $phpEx, $config, $auth, $user;

-

- // Obtain any submitted data

- $data = $this->get_submitted_data();

- $table_prefix = $data['table_prefix'];

-

- // If we get here and the extension isn't loaded it should be safe to just go ahead and load it

- $available_dbms = get_available_dbms($data['dbms']);

-

- if (!isset($available_dbms[$data['dbms']]))

- {

- // Someone's been silly and tried providing a non-existant dbms

- $this->p_master->redirect("index.$phpEx?mode=install");

- }

-

- $dbms = $available_dbms[$data['dbms']]['DRIVER'];

-

- // Instantiate the database

- $db = new $dbms();

- $db->sql_connect($data['dbhost'], $data['dbuser'], htmlspecialchars_decode($data['dbpasswd']), $data['dbname'], $data['dbport'], false, false);

-

- // NOTE: trigger_error does not work here.

- $db->sql_return_on_error(true);

-

- include_once($phpbb_root_path . 'includes/constants.' . $phpEx);

- include_once($phpbb_root_path . 'phpbb/search/fulltext_native.' . $phpEx);

-

- // We need to fill the config to let internal functions correctly work

- $config = new \phpbb\config\db($db, new \phpbb\cache\driver\dummy, CONFIG_TABLE);

-

- $error = false;

- $search = new \phpbb\search\fulltext_native($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user, $phpbb_dispatcher);

-

- $sql = 'SELECT post_id, post_subject, post_text, poster_id, forum_id

- FROM ' . POSTS_TABLE;

- $result = $db->sql_query($sql);

-

- while ($row = $db->sql_fetchrow($result))

- {

- $search->index('post', $row['post_id'], $row['post_text'], $row['post_subject'], $row['poster_id'], $row['forum_id']);

- }

- $db->sql_freeresult($result);

- }

-

- /**

- * Populate the module tables

- */

- function add_modules($mode, $sub)

- {

- global $db, $lang, $phpbb_root_path, $phpEx, $phpbb_extension_manager, $config, $phpbb_container;

-

- // modules require an extension manager

- if (empty($phpbb_extension_manager))

- {

- /* @var $phpbb_extension_manager \phpbb\extension\manager */

- $phpbb_extension_manager = $phpbb_container->get('ext.manager');

- }

-

- $_module = new \phpbb\module\module_manager(

- new \phpbb\cache\driver\dummy(),

- $db,

- $phpbb_extension_manager,

- MODULES_TABLE,

- $phpbb_root_path,

- $phpEx

- );

- $module_classes = array('acp', 'mcp', 'ucp');

-

- // Add categories

- foreach ($module_classes as $module_class)

- {

- $categories = array();

-

- // Set the module class

- $_module->module_class = $module_class;

-

- foreach ($this->module_categories[$module_class] as $cat_name => $subs)

- {

- $basename = '';

- // Check if this sub-category has a basename. If it has, use it.

- if (isset($this->module_categories_basenames[$cat_name]))

- {

- $basename = $this->module_categories_basenames[$cat_name];

- }

- $module_data = array(

- 'module_basename' => $basename,

- 'module_enabled' => 1,

- 'module_display' => 1,

- 'parent_id' => 0,

- 'module_class' => $module_class,

- 'module_langname' => $cat_name,

- 'module_mode' => '',

- 'module_auth' => '',

- );

-

- // Add category

- $_module->update_module_data($module_data);

-

- // Check for last sql error happened

- if ($db->get_sql_error_triggered())

- {

- $error = $db->sql_error($db->get_sql_error_sql());

- $this->p_master->db_error($error['message'], $db->get_sql_error_sql(), __LINE__, __FILE__);

- }

-

- $categories[$cat_name]['id'] = (int) $module_data['module_id'];

- $categories[$cat_name]['parent_id'] = 0;

-

- // Create sub-categories...

- if (is_array($subs))

- {

- foreach ($subs as $level2_name)

- {

- $basename = '';

- // Check if this sub-category has a basename. If it has, use it.

- if (isset($this->module_categories_basenames[$level2_name]))

- {

- $basename = $this->module_categories_basenames[$level2_name];

- }

- $module_data = array(

- 'module_basename' => $basename,

- 'module_enabled' => 1,

- 'module_display' => 1,

- 'parent_id' => (int) $categories[$cat_name]['id'],

- 'module_class' => $module_class,

- 'module_langname' => $level2_name,

- 'module_mode' => '',

- 'module_auth' => '',

- );

-

- $_module->update_module_data($module_data);

-

- // Check for last sql error happened

- if ($db->get_sql_error_triggered())

- {

- $error = $db->sql_error($db->get_sql_error_sql());

- $this->p_master->db_error($error['message'], $db->get_sql_error_sql(), __LINE__, __FILE__);

- }

-

- $categories[$level2_name]['id'] = (int) $module_data['module_id'];

- $categories[$level2_name]['parent_id'] = (int) $categories[$cat_name]['id'];

- }

- }

- }

-

- // Get the modules we want to add... returned sorted by name

- $module_info = $_module->get_module_infos($module_class);

-

- foreach ($module_info as $module_basename => $fileinfo)

- {

- foreach ($fileinfo['modes'] as $module_mode => $row)

- {

- foreach ($row['cat'] as $cat_name)

- {

- if (!isset($categories[$cat_name]))

- {

- continue;

- }

-

- $module_data = array(

- 'module_basename' => $module_basename,

- 'module_enabled' => 1,

- 'module_display' => (isset($row['display'])) ? (int) $row['display'] : 1,

- 'parent_id' => (int) $categories[$cat_name]['id'],

- 'module_class' => $module_class,

- 'module_langname' => $row['title'],

- 'module_mode' => $module_mode,

- 'module_auth' => $row['auth'],

- );

-

- $_module->update_module_data($module_data);

-

- // Check for last sql error happened

- if ($db->get_sql_error_triggered())

- {

- $error = $db->sql_error($db->get_sql_error_sql());

- $this->p_master->db_error($error['message'], $db->get_sql_error_sql(), __LINE__, __FILE__);

- }

- }

- }

- }

-

- // Move some of the modules around since the code above will put them in the wrong place

- if ($module_class == 'acp')

- {

- // Move main module 4 up...

- $sql = 'SELECT *

- FROM ' . MODULES_TABLE . "

- WHERE module_basename = 'acp_main'

- AND module_class = 'acp'

- AND module_mode = 'main'";

- $result = $db->sql_query($sql);

- $row = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

- $_module->move_module_by($row, 'acp', 'move_up', 4);

-

- // Move permissions intro screen module 4 up...

- $sql = 'SELECT *

- FROM ' . MODULES_TABLE . "

- WHERE module_basename = 'acp_permissions'

- AND module_class = 'acp'

- AND module_mode = 'intro'";

- $result = $db->sql_query($sql);

- $row = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

- $_module->move_module_by($row, 'acp', 'move_up', 4);

-

- // Move manage users screen module 5 up...

- $sql = 'SELECT *

- FROM ' . MODULES_TABLE . "

- WHERE module_basename = 'acp_users'

- AND module_class = 'acp'

- AND module_mode = 'overview'";

- $result = $db->sql_query($sql);

- $row = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

- $_module->move_module_by($row, 'acp', 'move_up', 5);

-

- // Move extension management module 1 up...

- $sql = 'SELECT *

- FROM ' . MODULES_TABLE . "

- WHERE module_langname = 'ACP_EXTENSION_MANAGEMENT'

- AND module_class = 'acp'

- AND module_mode = ''

- AND module_basename = ''";

- $result = $db->sql_query($sql);

- $row = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

- $_module->move_module_by($row, 'acp', 'move_up', 1);

- }

-

- if ($module_class == 'mcp')

- {

- // Move pm report details module 3 down...

- $sql = 'SELECT *

- FROM ' . MODULES_TABLE . "

- WHERE module_basename = 'mcp_pm_reports'

- AND module_class = 'mcp'

- AND module_mode = 'pm_report_details'";

- $result = $db->sql_query($sql);

- $row = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

- $_module->move_module_by($row, 'mcp', 'move_down', 3);

-

- // Move closed pm reports module 3 down...

- $sql = 'SELECT *

- FROM ' . MODULES_TABLE . "

- WHERE module_basename = 'mcp_pm_reports'

- AND module_class = 'mcp'

- AND module_mode = 'pm_reports_closed'";

- $result = $db->sql_query($sql);

- $row = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

- $_module->move_module_by($row, 'mcp', 'move_down', 3);

-

- // Move open pm reports module 3 down...

- $sql = 'SELECT *

- FROM ' . MODULES_TABLE . "

- WHERE module_basename = 'mcp_pm_reports'

- AND module_class = 'mcp'

- AND module_mode = 'pm_reports'";

- $result = $db->sql_query($sql);

- $row = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

- $_module->move_module_by($row, 'mcp', 'move_down', 3);

- }

-

- if ($module_class == 'ucp')

- {

- // Move attachment module 4 down...

- $sql = 'SELECT *

- FROM ' . MODULES_TABLE . "

- WHERE module_basename = 'ucp_attachments'

- AND module_class = 'ucp'

- AND module_mode = 'attachments'";

- $result = $db->sql_query($sql);

- $row = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

- $_module->move_module_by($row, 'ucp', 'move_down', 4);

-

- // Move notification options module 4 down...

- $sql = 'SELECT *

- FROM ' . MODULES_TABLE . "

- WHERE module_basename = 'ucp_notifications'

- AND module_class = 'ucp'

- AND module_mode = 'notification_options'";

- $result = $db->sql_query($sql);

- $row = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

- $_module->move_module_by($row, 'ucp', 'move_down', 4);

-

- // Move OAuth module 5 down...

- $sql = 'SELECT *

- FROM ' . MODULES_TABLE . "

- WHERE module_basename = 'ucp_auth_link'

- AND module_class = 'ucp'

- AND module_mode = 'auth_link'";

- $result = $db->sql_query($sql);

- $row = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

- $_module->move_module_by($row, 'ucp', 'move_down', 5);

- }

-

- // And now for the special ones

- // (these are modules which appear in multiple categories and thus get added manually to some for more control)

- if (isset($this->module_extras[$module_class]))

- {

- foreach ($this->module_extras[$module_class] as $cat_name => $mods)

- {

- $sql = 'SELECT module_id, left_id, right_id

- FROM ' . MODULES_TABLE . "

- WHERE module_langname = '" . $db->sql_escape($cat_name) . "'

- AND module_class = '" . $db->sql_escape($module_class) . "'";

- $result = $db->sql_query_limit($sql, 1);

- $row2 = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

- foreach ($mods as $mod_name)

- {

- $sql = 'SELECT *

- FROM ' . MODULES_TABLE . "

- WHERE module_langname = '" . $db->sql_escape($mod_name) . "'

- AND module_class = '" . $db->sql_escape($module_class) . "'

- AND module_basename <> ''";

- $result = $db->sql_query_limit($sql, 1);

- $row = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

- $module_data = array(

- 'module_basename' => $row['module_basename'],

- 'module_enabled' => (int) $row['module_enabled'],

- 'module_display' => (int) $row['module_display'],

- 'parent_id' => (int) $row2['module_id'],

- 'module_class' => $row['module_class'],

- 'module_langname' => $row['module_langname'],

- 'module_mode' => $row['module_mode'],

- 'module_auth' => $row['module_auth'],

- );

-

- $_module->update_module_data($module_data);

-

- // Check for last sql error happened

- if ($db->get_sql_error_triggered())

- {

- $error = $db->sql_error($db->get_sql_error_sql());

- $this->p_master->db_error($error['message'], $db->get_sql_error_sql(), __LINE__, __FILE__);

- }

- }

- }

- }

-

- $_module->remove_cache_file($module_class);

- }

- }

-

- /**

- * Populate the language tables

- */

- function add_language($mode, $sub)

- {

- global $db, $lang, $phpbb_root_path, $phpEx;

-

- $dir = @opendir($phpbb_root_path . 'language');

-

- if (!$dir)

- {

- $this->error('Unable to access the language directory', __LINE__, __FILE__);

- }

-

- $installed_languages = array();

- while (($file = readdir($dir)) !== false)

- {

- $path = $phpbb_root_path . 'language/' . $file;

-

- if ($file == '.' || $file == '..' || is_link($path) || is_file($path) || $file == 'CVS')

- {

- continue;

- }

-

- if (is_dir($path) && file_exists($path . '/iso.txt'))

- {

- $lang_file = file("$path/iso.txt");

-

- $lang_pack = array(

- 'lang_iso' => basename($path),

- 'lang_dir' => basename($path),

- 'lang_english_name' => trim(htmlspecialchars($lang_file[0])),

- 'lang_local_name' => trim(htmlspecialchars($lang_file[1], ENT_COMPAT, 'UTF-8')),

- 'lang_author' => trim(htmlspecialchars($lang_file[2], ENT_COMPAT, 'UTF-8')),

- );

-

- $db->sql_query('INSERT INTO ' . LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $lang_pack));

-

- $installed_languages[] = (int) $db->sql_nextid();

- if ($db->get_sql_error_triggered())

- {

- $error = $db->sql_error($db->get_sql_error_sql());

- $this->p_master->db_error($error['message'], $db->get_sql_error_sql(), __LINE__, __FILE__);

- }

- }

- }

- closedir($dir);

-

- $sql = 'SELECT *

- FROM ' . PROFILE_FIELDS_TABLE;

- $result = $db->sql_query($sql);

-

- $profile_fields = array();

- $insert_buffer = new \phpbb\db\sql_insert_buffer($db, PROFILE_LANG_TABLE);

- while ($row = $db->sql_fetchrow($result))

- {

- foreach ($installed_languages as $lang_id)

- {

- $insert_buffer->insert(array(

- 'field_id' => $row['field_id'],

- 'lang_id' => $lang_id,

- 'lang_name' => strtoupper(substr($row['field_name'], 6)),// Remove phpbb_ from field name

- 'lang_explain' => '',

- 'lang_default_value' => '',

- ));

- }

- }

- $db->sql_freeresult($result);

-

- $insert_buffer->flush();

- }

-

- /**

- * Add search robots to the database

- */

- function add_bots($mode, $sub)

- {

- global $db, $lang, $phpbb_root_path, $phpEx, $config;

-

- // Obtain any submitted data

- $data = $this->get_submitted_data();

-

- // We need to fill the config to let internal functions correctly work

- $config = new \phpbb\config\db($db, new \phpbb\cache\driver\dummy, CONFIG_TABLE);

-

- $sql = 'SELECT group_id

- FROM ' . GROUPS_TABLE . "

- WHERE group_name = 'BOTS'";

- $result = $db->sql_query($sql);

- $group_id = (int) $db->sql_fetchfield('group_id');

- $db->sql_freeresult($result);

-

- if (!$group_id)

- {

- // If we reach this point then something has gone very wrong

- $this->p_master->error($lang['NO_GROUP'], __LINE__, __FILE__);

- }

-

- if (!function_exists('user_add'))

- {

- include($phpbb_root_path . 'includes/functions_user.' . $phpEx);

- }

-

- foreach ($this->bot_list as $bot_name => $bot_ary)

- {

- $user_row = array(

- 'user_type' => USER_IGNORE,

- 'group_id' => $group_id,

- 'username' => $bot_name,

- 'user_regdate' => time(),

- 'user_password' => '',

- 'user_colour' => '9E8DA7',

- 'user_email' => '',

- 'user_lang' => $data['default_lang'],

- 'user_style' => 1,

- 'user_timezone' => 'UTC',

- 'user_dateformat' => $lang['default_dateformat'],

- 'user_allow_massemail' => 0,

- 'user_allow_pm' => 0,

- );

-

- $user_id = user_add($user_row);

-

- if (!$user_id)

- {

- // If we can't insert this user then continue to the next one to avoid inconsistent data

- $this->p_master->db_error('Unable to insert bot into users table', $db->get_sql_error_sql(), __LINE__, __FILE__, true);

- continue;

- }

-

- $sql = 'INSERT INTO ' . BOTS_TABLE . ' ' . $db->sql_build_array('INSERT', array(

- 'bot_active' => 1,

- 'bot_name' => (string) $bot_name,

- 'user_id' => (int) $user_id,

- 'bot_agent' => (string) $bot_ary[0],

- 'bot_ip' => (string) $bot_ary[1],

- ));

-

- $db->sql_query($sql);

- }

- }

-

- /**

- * Sends an email to the board administrator with their password and some useful links

- */

- function email_admin($mode, $sub)

- {

- global $auth, $config, $db, $lang, $template, $user, $phpbb_root_path, $phpbb_admin_path, $phpEx, $phpbb_log;

-

- $this->page_title = $lang['STAGE_FINAL'];

-

- // Obtain any submitted data

- $data = $this->get_submitted_data();

-

- // We need to fill the config to let internal functions correctly work

- $config = new \phpbb\config\db($db, new \phpbb\cache\driver\dummy, CONFIG_TABLE);

-

- $user->session_begin();

- $auth->login($data['admin_name'], $data['admin_pass1'], false, true, true);

-

- // OK, Now that we've reached this point we can be confident that everything

- // is installed and working......I hope :)

- // So it's time to send an email to the administrator confirming the details

- // they entered

-

- if ($config['email_enable'])

- {

- include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

-

- $messenger = new messenger(false);

-

- $messenger->template('installed', $data['language']);

-

- $messenger->to($data['board_email'], $data['admin_name']);

-

- $messenger->anti_abuse_headers($config, $user);

-

- $messenger->assign_vars(array(

- 'USERNAME' => htmlspecialchars_decode($data['admin_name']),

- 'PASSWORD' => htmlspecialchars_decode($data['admin_pass1']))

- );

-

- $messenger->send(NOTIFY_EMAIL);

- }

-

- // And finally, add a note to the log

- $phpbb_log->add('admin', $user->data['user_id'], $user->ip, 'LOG_INSTALL_INSTALLED', false, array($config['version']));

-

- $template->assign_vars(array(

- 'TITLE' => $lang['INSTALL_CONGRATS'],

- 'BODY' => sprintf($lang['INSTALL_CONGRATS_EXPLAIN'], $config['version'], append_sid($phpbb_root_path . 'install/index.' . $phpEx, 'mode=convert&amp;language=' . $data['language']), '../docs/README.html'),

- 'L_SUBMIT' => $lang['INSTALL_LOGIN'],

- 'U_ACTION' => append_sid($phpbb_admin_path . 'index.' . $phpEx, 'i=send_statistics&amp;mode=send_statistics'),

- ));

- }

-

- /**

- * Check if the avatar directory is writable and disable avatars

- * if it isn't writable.

- */

- function disable_avatars_if_unwritable()

- {

- global $config, $phpbb_root_path;

-

- if (!$this->filesystem->is_writable($phpbb_root_path . 'images/avatars/upload/'))

- {

- $config->set('allow_avatar', 0);

- $config->set('allow_avatar_upload', 0);

- }

- }

-

- /**

- * Populate migrations for the installation

- *

- * This "installs" all migrations from (root path)/phpbb/db/migrations/data.

- * "installs" means it adds all migrations to the migrations table, but does not

- * perform any of the actions in the migrations.

- *

- * @param \phpbb\extension\manager $extension_manager

- * @param \phpbb\db\migrator $migrator

- */

- function populate_migrations($extension_manager, $migrator)

- {

- $finder = $extension_manager->get_finder();

-

- $migrations = $finder

- ->core_path('phpbb/db/migration/data/')

- ->get_classes();

- $migrator->populate_migrations($migrations);

- }

-

- /**

- * Generate a list of available mail server authentication methods

- */

- function mail_auth_select($selected_method)

- {

- global $lang;

-

- $auth_methods = array('PLAIN', 'LOGIN', 'CRAM-MD5', 'DIGEST-MD5', 'POP-BEFORE-SMTP');

- $s_smtp_auth_options = '';

-

- foreach ($auth_methods as $method)

- {

- $s_smtp_auth_options .= '<option value="' . $method . '"' . (($selected_method == $method) ? ' selected="selected"' : '') . '>' . $lang['SMTP_' . str_replace('-', '_', $method)] . '</option>';

- }

-

- return $s_smtp_auth_options;

- }

-

- /**

- * Get submitted data

- */

- function get_submitted_data()

- {

- global $request;

-

- return array(

- 'language' => basename($request->variable('language', '')),

- 'dbms' => $request->variable('dbms', ''),

- 'dbhost' => $request->variable('dbhost', ''),

- 'dbport' => $request->variable('dbport', ''),

- 'dbuser' => $request->variable('dbuser', ''),

- 'dbpasswd' => $request->variable('dbpasswd', '', true),

- 'dbname' => $request->variable('dbname', ''),

- 'table_prefix' => $request->variable('table_prefix', ''),

- 'default_lang' => basename($request->variable('default_lang', '')),

- 'admin_name' => $request->variable('admin_name', '', true),

- 'admin_pass1' => $request->variable('admin_pass1', '', true),

- 'admin_pass2' => $request->variable('admin_pass2', '', true),

- 'board_email' => strtolower($request->variable('board_email', '')),

- 'img_imagick' => $request->variable('img_imagick', ''),

- 'ftp_path' => $request->variable('ftp_path', ''),

- 'ftp_user' => $request->variable('ftp_user', ''),

- 'ftp_pass' => $request->variable('ftp_pass', ''),

- 'email_enable' => $request->variable('email_enable', ''),

- 'smtp_delivery' => $request->variable('smtp_delivery', ''),

- 'smtp_host' => $request->variable('smtp_host', ''),

- 'smtp_auth' => $request->variable('smtp_auth', ''),

- 'smtp_user' => $request->variable('smtp_user', ''),

- 'smtp_pass' => $request->variable('smtp_pass', ''),

- 'cookie_secure' => $request->variable('cookie_secure', ''),

- 'force_server_vars' => $request->variable('force_server_vars', ''),

- 'server_protocol' => $request->variable('server_protocol', ''),

- 'server_name' => $request->variable('server_name', ''),

- 'server_port' => $request->variable('server_port', ''),

- 'script_path' => $request->variable('script_path', ''),

- );

- }

-

- /**

- * The information below will be used to build the input fields presented to the user

- */

- var $db_config_options = array(

- 'legend1' => 'DB_CONFIG',

- 'dbms' => array('lang' => 'DBMS', 'type' => 'select', 'options' => 'dbms_select(\'{VALUE}\')', 'explain' => false),

- 'dbhost' => array('lang' => 'DB_HOST', 'type' => 'text:25:100', 'explain' => true),

- 'dbport' => array('lang' => 'DB_PORT', 'type' => 'text:25:100', 'explain' => true),

- 'dbname' => array('lang' => 'DB_NAME', 'type' => 'text:25:100', 'explain' => false),

- 'dbuser' => array('lang' => 'DB_USERNAME', 'type' => 'text:25:100', 'explain' => false),

- 'dbpasswd' => array('lang' => 'DB_PASSWORD', 'type' => 'password:25:100', 'explain' => false),

- 'table_prefix' => array('lang' => 'TABLE_PREFIX', 'type' => 'text:25:100', 'explain' => true),

- );

- var $admin_config_options = array(

- 'legend1' => 'ADMIN_CONFIG',

- 'default_lang' => array('lang' => 'DEFAULT_LANG', 'type' => 'select', 'options' => '$this->module->inst_language_select(\'{VALUE}\')', 'explain' => false),

- 'admin_name' => array('lang' => 'ADMIN_USERNAME', 'type' => 'text:25:100', 'explain' => true),

- 'admin_pass1' => array('lang' => 'ADMIN_PASSWORD', 'type' => 'password:25:100', 'explain' => true),

- 'admin_pass2' => array('lang' => 'ADMIN_PASSWORD_CONFIRM', 'type' => 'password:25:100', 'explain' => false),

- 'board_email' => array('lang' => 'CONTACT_EMAIL', 'type' => 'email:25:100', 'explain' => false),

- );

- var $advanced_config_options = array(

- 'legend1' => 'ACP_EMAIL_SETTINGS',

- 'email_enable' => array('lang' => 'ENABLE_EMAIL', 'type' => 'radio:enabled_disabled', 'explain' => true),

- 'smtp_delivery' => array('lang' => 'USE_SMTP', 'type' => 'radio:yes_no', 'explain' => true),

- 'smtp_host' => array('lang' => 'SMTP_SERVER', 'type' => 'text:25:50', 'explain' => false),

- 'smtp_auth' => array('lang' => 'SMTP_AUTH_METHOD', 'type' => 'select', 'options' => '$this->module->mail_auth_select(\'{VALUE}\')', 'explain' => true),

- 'smtp_user' => array('lang' => 'SMTP_USERNAME', 'type' => 'text:25:255', 'explain' => true, 'options' => array('autocomplete' => 'off')),

- 'smtp_pass' => array('lang' => 'SMTP_PASSWORD', 'type' => 'password:25:255', 'explain' => true, 'options' => array('autocomplete' => 'off')),

-

- 'legend2' => 'SERVER_URL_SETTINGS',

- 'cookie_secure' => array('lang' => 'COOKIE_SECURE', 'type' => 'radio:enabled_disabled', 'explain' => true),

- 'force_server_vars' => array('lang' => 'FORCE_SERVER_VARS', 'type' => 'radio:yes_no', 'explain' => true),

- 'server_protocol' => array('lang' => 'SERVER_PROTOCOL', 'type' => 'text:10:10', 'explain' => true),

- 'server_name' => array('lang' => 'SERVER_NAME', 'type' => 'text:40:255', 'explain' => true),

- 'server_port' => array('lang' => 'SERVER_PORT', 'type' => 'text:5:5', 'explain' => true),

- 'script_path' => array('lang' => 'SCRIPT_PATH', 'type' => 'text::255', 'explain' => true),

- );

-

- /**

- * Specific PHP modules we may require for certain optional or extended features

- */

- var $php_dlls_other = array('zlib', 'ftp', 'gd', 'xml');

-

- /**

- * A list of the web-crawlers/bots we recognise by default

- *

- * Candidates but not included:

- * 'Accoona [Bot]' 'Accoona-AI-Agent/'

- * 'ASPseek [Crawler]' 'ASPseek/'

- * 'Boitho [Crawler]' 'boitho.com-dc/'

- * 'Bunnybot [Bot]' 'powered by www.buncat.de'

- * 'Cosmix [Bot]' 'cfetch/'

- * 'Crawler Search [Crawler]' '.Crawler-Search.de'

- * 'Findexa [Crawler]' 'Findexa Crawler ('

- * 'GBSpider [Spider]' 'GBSpider v'

- * 'genie [Bot]' 'genieBot ('

- * 'Hogsearch [Bot]' 'oegp v. 1.3.0'

- * 'Insuranco [Bot]' 'InsurancoBot'

- * 'IRLbot [Bot]' 'http://irl.cs.tamu.edu/crawler'

- * 'ISC Systems [Bot]' 'ISC Systems iRc Search'

- * 'Jyxobot [Bot]' 'Jyxobot/'

- * 'Kraehe [Metasuche]' '-DIE-KRAEHE- META-SEARCH-ENGINE/'

- * 'LinkWalker' 'LinkWalker'

- * 'MMSBot [Bot]' 'http://www.mmsweb.at/bot.html'

- * 'Naver [Bot]' 'nhnbot@naver.com)'

- * 'NetResearchServer' 'NetResearchServer/'

- * 'Nimble [Crawler]' 'NimbleCrawler'

- * 'Ocelli [Bot]' 'Ocelli/'

- * 'Onsearch [Bot]' 'onCHECK-Robot'

- * 'Orange [Spider]' 'OrangeSpider'

- * 'Sproose [Bot]' 'http://www.sproose.com/bot'

- * 'Susie [Sync]' '!Susie (http://www.sync2it.com/susie)'

- * 'Tbot [Bot]' 'Tbot/'

- * 'Thumbshots [Capture]' 'thumbshots-de-Bot'

- * 'Vagabondo [Crawler]' 'http://webagent.wise-guys.nl/'

- * 'Walhello [Bot]' 'appie 1.1 (www.walhello.com)'

- * 'WissenOnline [Bot]' 'WissenOnline-Bot'

- * 'WWWeasel [Bot]' 'WWWeasel Robot v'

- * 'Xaldon [Spider]' 'Xaldon WebSpider'

- */

- var $bot_list = array(

- 'AdsBot [Google]' => array('AdsBot-Google', ''),

- 'Alexa [Bot]' => array('ia_archiver', ''),

- 'Alta Vista [Bot]' => array('Scooter/', ''),

- 'Ask Jeeves [Bot]' => array('Ask Jeeves', ''),

- 'Baidu [Spider]' => array('Baiduspider', ''),

- 'Bing [Bot]' => array('bingbot/', ''),

- 'Exabot [Bot]' => array('Exabot', ''),

- 'FAST Enterprise [Crawler]' => array('FAST Enterprise Crawler', ''),

- 'FAST WebCrawler [Crawler]' => array('FAST-WebCrawler/', ''),

- 'Francis [Bot]' => array('http://www.neomo.de/', ''),

- 'Gigabot [Bot]' => array('Gigabot/', ''),

- 'Google Adsense [Bot]' => array('Mediapartners-Google', ''),

- 'Google Desktop' => array('Google Desktop', ''),

- 'Google Feedfetcher' => array('Feedfetcher-Google', ''),

- 'Google [Bot]' => array('Googlebot', ''),

- 'Heise IT-Markt [Crawler]' => array('heise-IT-Markt-Crawler', ''),

- 'Heritrix [Crawler]' => array('heritrix/1.', ''),

- 'IBM Research [Bot]' => array('ibm.com/cs/crawler', ''),

- 'ICCrawler - ICjobs' => array('ICCrawler - ICjobs', ''),

- 'ichiro [Crawler]' => array('ichiro/', ''),

- 'Majestic-12 [Bot]' => array('MJ12bot/', ''),

- 'Metager [Bot]' => array('MetagerBot/', ''),

- 'MSN NewsBlogs' => array('msnbot-NewsBlogs/', ''),

- 'MSN [Bot]' => array('msnbot/', ''),

- 'MSNbot Media' => array('msnbot-media/', ''),

- 'Nutch [Bot]' => array('http://lucene.apache.org/nutch/', ''),

- 'Online link [Validator]' => array('online link validator', ''),

- 'psbot [Picsearch]' => array('psbot/0', ''),

- 'Sensis [Crawler]' => array('Sensis Web Crawler', ''),

- 'SEO Crawler' => array('SEO search Crawler/', ''),

- 'Seoma [Crawler]' => array('Seoma [SEO Crawler]', ''),

- 'SEOSearch [Crawler]' => array('SEOsearch/', ''),

- 'Snappy [Bot]' => array('Snappy/1.1 ( http://www.urltrends.com/ )', ''),

- 'Steeler [Crawler]' => array('http://www.tkl.iis.u-tokyo.ac.jp/~crawler/', ''),

- 'Telekom [Bot]' => array('crawleradmin.t-info@telekom.de', ''),

- 'TurnitinBot [Bot]' => array('TurnitinBot/', ''),

- 'Voyager [Bot]' => array('voyager/', ''),

- 'W3 [Sitesearch]' => array('W3 SiteSearch Crawler', ''),

- 'W3C [Linkcheck]' => array('W3C-checklink/', ''),

- 'W3C [Validator]' => array('W3C_Validator', ''),

- 'YaCy [Bot]' => array('yacybot', ''),

- 'Yahoo MMCrawler [Bot]' => array('Yahoo-MMCrawler/', ''),

- 'Yahoo Slurp [Bot]' => array('Yahoo! DE Slurp', ''),

- 'Yahoo [Bot]' => array('Yahoo! Slurp', ''),

- 'YahooSeeker [Bot]' => array('YahooSeeker/', ''),

- );

-

- /**

- * Define the module structure so that we can populate the database without

- * needing to hard-code module_id values

- */

- var $module_categories = array(

- 'acp' => array(

- 'ACP_CAT_GENERAL' => array(

- 'ACP_QUICK_ACCESS',

- 'ACP_BOARD_CONFIGURATION',

- 'ACP_CLIENT_COMMUNICATION',

- 'ACP_SERVER_CONFIGURATION',

- ),

- 'ACP_CAT_FORUMS' => array(

- 'ACP_MANAGE_FORUMS',

- 'ACP_FORUM_BASED_PERMISSIONS',

- ),

- 'ACP_CAT_POSTING' => array(

- 'ACP_MESSAGES',

- 'ACP_ATTACHMENTS',

- ),

- 'ACP_CAT_USERGROUP' => array(

- 'ACP_CAT_USERS',

- 'ACP_GROUPS',

- 'ACP_USER_SECURITY',

- ),

- 'ACP_CAT_PERMISSIONS' => array(

- 'ACP_GLOBAL_PERMISSIONS',

- 'ACP_FORUM_BASED_PERMISSIONS',

- 'ACP_PERMISSION_ROLES',

- 'ACP_PERMISSION_MASKS',

- ),

- 'ACP_CAT_CUSTOMISE' => array(

- 'ACP_STYLE_MANAGEMENT',

- 'ACP_EXTENSION_MANAGEMENT',

- 'ACP_LANGUAGE',

- ),

- 'ACP_CAT_MAINTENANCE' => array(

- 'ACP_FORUM_LOGS',

- 'ACP_CAT_DATABASE',

- ),

- 'ACP_CAT_SYSTEM' => array(

- 'ACP_AUTOMATION',

- 'ACP_GENERAL_TASKS',

- 'ACP_MODULE_MANAGEMENT',

- ),

- 'ACP_CAT_DOT_MODS' => null,

- ),

- 'mcp' => array(

- 'MCP_MAIN' => null,

- 'MCP_QUEUE' => null,

- 'MCP_REPORTS' => null,

- 'MCP_NOTES' => null,

- 'MCP_WARN' => null,

- 'MCP_LOGS' => null,

- 'MCP_BAN' => null,

- ),

- 'ucp' => array(

- 'UCP_MAIN' => null,

- 'UCP_PROFILE' => null,

- 'UCP_PREFS' => null,

- 'UCP_PM' => null,

- 'UCP_USERGROUPS' => null,

- 'UCP_ZEBRA' => null,

- ),

- );

- var $module_categories_basenames = array(

- 'UCP_PM' => 'ucp_pm',

- );

-

- var $module_extras = array(

- 'acp' => array(

- 'ACP_QUICK_ACCESS' => array(

- 'ACP_MANAGE_USERS',

- 'ACP_GROUPS_MANAGE',

- 'ACP_MANAGE_FORUMS',

- 'ACP_MOD_LOGS',

- 'ACP_BOTS',

- 'ACP_PHP_INFO',

- ),

- 'ACP_FORUM_BASED_PERMISSIONS' => array(

- 'ACP_FORUM_PERMISSIONS',

- 'ACP_FORUM_PERMISSIONS_COPY',

- 'ACP_FORUM_MODERATORS',

- 'ACP_USERS_FORUM_PERMISSIONS',

- 'ACP_GROUPS_FORUM_PERMISSIONS',

- ),

- ),

- );

-}

-<?php

-/**

-*

-* This file is part of the phpBB Forum Software package.

-*

-* @copyright (c) phpBB Limited <https://www.phpbb.com>

-* @license GNU General Public License, version 2 (GPL-2.0)

-*

-* For full copyright and license information, please see

-* the docs/CREDITS.txt file.

-*

-*/

-

-/**

-*/

-