Code Coverage |
||||||||||
Classes and Traits |
Functions and Methods |
Lines |
||||||||
| Total | |
0.00% |
0 / 1 |
|
0.00% |
0 / 2 |
CRAP | |
0.00% |
0 / 327 |
| acp_language | |
0.00% |
0 / 1 |
|
0.00% |
0 / 2 |
2162 | |
0.00% |
0 / 323 |
| main | |
0.00% |
0 / 1 |
1980 | |
0.00% |
0 / 306 |
|||
| compare_language_files | |
0.00% |
0 / 1 |
6 | |
0.00% |
0 / 17 |
|||
| <?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; | |
| } | |
| class acp_language | |
| { | |
| var $u_action; | |
| var $main_files; | |
| var $language_header = ''; | |
| var $lang_header = ''; | |
| var $language_file = ''; | |
| var $language_directory = ''; | |
| function main($id, $mode) | |
| { | |
| global $config, $db, $user, $template, $phpbb_log, $phpbb_container; | |
| global $phpbb_root_path, $phpEx, $request, $phpbb_dispatcher; | |
| if (!function_exists('validate_language_iso_name')) | |
| { | |
| include($phpbb_root_path . 'includes/functions_user.' . $phpEx); | |
| } | |
| // Check and set some common vars | |
| $action = (isset($_POST['update_details'])) ? 'update_details' : ''; | |
| $action = (isset($_POST['remove_store'])) ? 'details' : $action; | |
| $submit = (empty($action) && !isset($_POST['update']) && !isset($_POST['test_connection'])) ? false : true; | |
| $action = (empty($action)) ? $request->variable('action', '') : $action; | |
| $form_name = 'acp_lang'; | |
| add_form_key('acp_lang'); | |
| $lang_id = $request->variable('id', 0); | |
| $selected_lang_file = $request->variable('language_file', '|common.' . $phpEx); | |
| list($this->language_directory, $this->language_file) = explode('|', $selected_lang_file); | |
| $this->language_directory = basename($this->language_directory); | |
| $this->language_file = basename($this->language_file); | |
| $user->add_lang('acp/language'); | |
| $this->tpl_name = 'acp_language'; | |
| $this->page_title = 'ACP_LANGUAGE_PACKS'; | |
| switch ($action) | |
| { | |
| case 'update_details': | |
| if (!$submit || !check_form_key($form_name)) | |
| { | |
| trigger_error($user->lang['FORM_INVALID']. adm_back_link($this->u_action), E_USER_WARNING); | |
| } | |
| if (!$lang_id) | |
| { | |
| trigger_error($user->lang['NO_LANG_ID'] . adm_back_link($this->u_action), E_USER_WARNING); | |
| } | |
| $sql = 'SELECT * | |
| FROM ' . LANG_TABLE . " | |
| WHERE lang_id = $lang_id"; | |
| $result = $db->sql_query($sql); | |
| $row = $db->sql_fetchrow($result); | |
| $db->sql_freeresult($result); | |
| $sql_ary = array( | |
| 'lang_english_name' => $request->variable('lang_english_name', $row['lang_english_name']), | |
| 'lang_local_name' => $request->variable('lang_local_name', $row['lang_local_name'], true), | |
| 'lang_author' => $request->variable('lang_author', $row['lang_author'], true), | |
| ); | |
| $db->sql_query('UPDATE ' . LANG_TABLE . ' | |
| SET ' . $db->sql_build_array('UPDATE', $sql_ary) . ' | |
| WHERE lang_id = ' . $lang_id); | |
| $phpbb_log->add('admin', $user->data['user_id'], $user->ip, 'LOG_LANGUAGE_PACK_UPDATED', false, array($sql_ary['lang_english_name'])); | |
| trigger_error($user->lang['LANGUAGE_DETAILS_UPDATED'] . adm_back_link($this->u_action)); | |
| break; | |
| case 'details': | |
| if (!$lang_id) | |
| { | |
| trigger_error($user->lang['NO_LANG_ID'] . adm_back_link($this->u_action), E_USER_WARNING); | |
| } | |
| $this->page_title = 'LANGUAGE_PACK_DETAILS'; | |
| $sql = 'SELECT * | |
| FROM ' . LANG_TABLE . ' | |
| WHERE lang_id = ' . $lang_id; | |
| $result = $db->sql_query($sql); | |
| $lang_entries = $db->sql_fetchrow($result); | |
| $db->sql_freeresult($result); | |
| if (!$lang_entries) | |
| { | |
| trigger_error($user->lang['LANGUAGE_PACK_NOT_EXIST'] . adm_back_link($this->u_action), E_USER_WARNING); | |
| } | |
| $lang_iso = $lang_entries['lang_iso']; | |
| $template->assign_vars(array( | |
| 'S_DETAILS' => true, | |
| 'U_ACTION' => $this->u_action . "&action=details&id=$lang_id", | |
| 'U_BACK' => $this->u_action, | |
| 'LANG_LOCAL_NAME' => $lang_entries['lang_local_name'], | |
| 'LANG_ENGLISH_NAME' => $lang_entries['lang_english_name'], | |
| 'LANG_ISO' => $lang_iso, | |
| 'LANG_AUTHOR' => $lang_entries['lang_author'], | |
| 'L_MISSING_FILES' => $user->lang('THOSE_MISSING_LANG_FILES', $lang_entries['lang_local_name']), | |
| 'L_MISSING_VARS_EXPLAIN' => $user->lang('THOSE_MISSING_LANG_VARIABLES', $lang_entries['lang_local_name']), | |
| )); | |
| // If current lang is different from the default lang, then highlight missing files and variables | |
| if ($lang_iso != $config['default_lang']) | |
| { | |
| try | |
| { | |
| $iterator = new \RecursiveIteratorIterator( | |
| new \phpbb\recursive_dot_prefix_filter_iterator( | |
| new \RecursiveDirectoryIterator( | |
| $phpbb_root_path . 'language/' . $config['default_lang'] . '/', | |
| \FilesystemIterator::SKIP_DOTS | |
| ) | |
| ), | |
| \RecursiveIteratorIterator::LEAVES_ONLY | |
| ); | |
| } | |
| catch (\Exception $e) | |
| { | |
| return array(); | |
| } | |
| foreach ($iterator as $file_info) | |
| { | |
| /** @var \RecursiveDirectoryIterator $file_info */ | |
| $relative_path = $iterator->getInnerIterator()->getSubPathname(); | |
| $relative_path = str_replace(DIRECTORY_SEPARATOR, '/', $relative_path); | |
| if (file_exists($phpbb_root_path . 'language/' . $lang_iso . '/' . $relative_path)) | |
| { | |
| if (substr($relative_path, 0 - strlen($phpEx)) === $phpEx) | |
| { | |
| $missing_vars = $this->compare_language_files($config['default_lang'], $lang_iso, $relative_path); | |
| if (!empty($missing_vars)) | |
| { | |
| $template->assign_block_vars('missing_varfile', array( | |
| 'FILE_NAME' => $relative_path, | |
| )); | |
| foreach ($missing_vars as $var) | |
| { | |
| $template->assign_block_vars('missing_varfile.variable', array( | |
| 'VAR_NAME' => $var, | |
| )); | |
| } | |
| } | |
| } | |
| } | |
| else | |
| { | |
| $template->assign_block_vars('missing_files', array( | |
| 'FILE_NAME' => $relative_path, | |
| )); | |
| } | |
| } | |
| } | |
| return; | |
| break; | |
| case 'delete': | |
| if (!$lang_id) | |
| { | |
| trigger_error($user->lang['NO_LANG_ID'] . adm_back_link($this->u_action), E_USER_WARNING); | |
| } | |
| $sql = 'SELECT * | |
| FROM ' . LANG_TABLE . ' | |
| WHERE lang_id = ' . $lang_id; | |
| $result = $db->sql_query($sql); | |
| $row = $db->sql_fetchrow($result); | |
| $db->sql_freeresult($result); | |
| if ($row['lang_iso'] == $config['default_lang']) | |
| { | |
| trigger_error($user->lang['NO_REMOVE_DEFAULT_LANG'] . adm_back_link($this->u_action), E_USER_WARNING); | |
| } | |
| if (confirm_box(true)) | |
| { | |
| $db->sql_query('DELETE FROM ' . LANG_TABLE . ' WHERE lang_id = ' . $lang_id); | |
| $sql = 'UPDATE ' . USERS_TABLE . " | |
| SET user_lang = '" . $db->sql_escape($config['default_lang']) . "' | |
| WHERE user_lang = '" . $db->sql_escape($row['lang_iso']) . "'"; | |
| $db->sql_query($sql); | |
| // We also need to remove the translated entries for custom profile fields - we want clean tables, don't we? | |
| $sql = 'DELETE FROM ' . PROFILE_LANG_TABLE . ' WHERE lang_id = ' . $lang_id; | |
| $db->sql_query($sql); | |
| $sql = 'DELETE FROM ' . PROFILE_FIELDS_LANG_TABLE . ' WHERE lang_id = ' . $lang_id; | |
| $db->sql_query($sql); | |
| $phpbb_log->add('admin', $user->data['user_id'], $user->ip, 'LOG_LANGUAGE_PACK_DELETED', false, array($row['lang_english_name'])); | |
| $delete_message = sprintf($user->lang['LANGUAGE_PACK_DELETED'], $row['lang_english_name']); | |
| $lang_iso = $row['lang_iso']; | |
| /** | |
| * Run code after language deleted | |
| * | |
| * @event core.acp_language_after_delete | |
| * @var string lang_iso Language ISO code | |
| * @var string delete_message Delete message appear to user | |
| * @since 3.2.2-RC1 | |
| */ | |
| $vars = array('lang_iso', 'delete_message'); | |
| extract($phpbb_dispatcher->trigger_event('core.acp_language_after_delete', compact($vars))); | |
| trigger_error($delete_message . adm_back_link($this->u_action)); | |
| } | |
| else | |
| { | |
| $s_hidden_fields = array( | |
| 'i' => $id, | |
| 'mode' => $mode, | |
| 'action' => $action, | |
| 'id' => $lang_id, | |
| ); | |
| confirm_box(false, $user->lang('DELETE_LANGUAGE_CONFIRM', $row['lang_english_name']), build_hidden_fields($s_hidden_fields)); | |
| } | |
| break; | |
| case 'install': | |
| if (!check_link_hash($request->variable('hash', ''), 'acp_language')) | |
| { | |
| trigger_error($user->lang['FORM_INVALID'] . adm_back_link($this->u_action), E_USER_WARNING); | |
| } | |
| $lang_iso = $request->variable('iso', ''); | |
| $lang_iso = basename($lang_iso); | |
| if (!$lang_iso || !file_exists("{$phpbb_root_path}language/$lang_iso/iso.txt")) | |
| { | |
| trigger_error($user->lang['LANGUAGE_PACK_NOT_EXIST'] . adm_back_link($this->u_action), E_USER_WARNING); | |
| } | |
| $file = file("{$phpbb_root_path}language/$lang_iso/iso.txt"); | |
| $lang_pack = array( | |
| 'iso' => $lang_iso, | |
| 'name' => trim(htmlspecialchars($file[0])), | |
| 'local_name'=> trim(htmlspecialchars($file[1], ENT_COMPAT, 'UTF-8')), | |
| 'author' => trim(htmlspecialchars($file[2], ENT_COMPAT, 'UTF-8')) | |
| ); | |
| unset($file); | |
| $sql = 'SELECT lang_iso | |
| FROM ' . LANG_TABLE . " | |
| WHERE lang_iso = '" . $db->sql_escape($lang_iso) . "'"; | |
| $result = $db->sql_query($sql); | |
| $row = $db->sql_fetchrow($result); | |
| $db->sql_freeresult($result); | |
| if ($row) | |
| { | |
| trigger_error($user->lang['LANGUAGE_PACK_ALREADY_INSTALLED'] . adm_back_link($this->u_action), E_USER_WARNING); | |
| } | |
| if (!$lang_pack['name'] || !$lang_pack['local_name']) | |
| { | |
| trigger_error($user->lang['INVALID_LANGUAGE_PACK'] . adm_back_link($this->u_action), E_USER_WARNING); | |
| } | |
| // Add language pack | |
| $sql_ary = array( | |
| 'lang_iso' => $lang_pack['iso'], | |
| 'lang_dir' => $lang_pack['iso'], | |
| 'lang_english_name' => $lang_pack['name'], | |
| 'lang_local_name' => $lang_pack['local_name'], | |
| 'lang_author' => $lang_pack['author'] | |
| ); | |
| $db->sql_query('INSERT INTO ' . LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary)); | |
| $lang_id = $db->sql_nextid(); | |
| // Now let's copy the default language entries for custom profile fields for this new language - makes admin's life easier. | |
| $sql = 'SELECT lang_id | |
| FROM ' . LANG_TABLE . " | |
| WHERE lang_iso = '" . $db->sql_escape($config['default_lang']) . "'"; | |
| $result = $db->sql_query($sql); | |
| $default_lang_id = (int) $db->sql_fetchfield('lang_id'); | |
| $db->sql_freeresult($result); | |
| // We want to notify the admin that custom profile fields need to be updated for the new language. | |
| $notify_cpf_update = false; | |
| // From the mysql documentation: | |
| // Prior to MySQL 4.0.14, the target table of the INSERT statement cannot appear in the FROM clause of the SELECT part of the query. This limitation is lifted in 4.0.14. | |
| // Due to this we stay on the safe side if we do the insertion "the manual way" | |
| $sql = 'SELECT field_id, lang_name, lang_explain, lang_default_value | |
| FROM ' . PROFILE_LANG_TABLE . ' | |
| WHERE lang_id = ' . $default_lang_id; | |
| $result = $db->sql_query($sql); | |
| while ($row = $db->sql_fetchrow($result)) | |
| { | |
| $row['lang_id'] = $lang_id; | |
| $db->sql_query('INSERT INTO ' . PROFILE_LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $row)); | |
| $notify_cpf_update = true; | |
| } | |
| $db->sql_freeresult($result); | |
| $sql = 'SELECT field_id, option_id, field_type, lang_value | |
| FROM ' . PROFILE_FIELDS_LANG_TABLE . ' | |
| WHERE lang_id = ' . $default_lang_id; | |
| $result = $db->sql_query($sql); | |
| while ($row = $db->sql_fetchrow($result)) | |
| { | |
| $row['lang_id'] = $lang_id; | |
| $db->sql_query('INSERT INTO ' . PROFILE_FIELDS_LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $row)); | |
| $notify_cpf_update = true; | |
| } | |
| $db->sql_freeresult($result); | |
| $phpbb_log->add('admin', $user->data['user_id'], $user->ip, 'LOG_LANGUAGE_PACK_INSTALLED', false, array($lang_pack['name'])); | |
| $message = sprintf($user->lang['LANGUAGE_PACK_INSTALLED'], $lang_pack['name']); | |
| $message .= ($notify_cpf_update) ? '<br /><br />' . $user->lang['LANGUAGE_PACK_CPF_UPDATE'] : ''; | |
| trigger_error($message . adm_back_link($this->u_action)); | |
| break; | |
| } | |
| $sql = 'SELECT user_lang, COUNT(user_lang) AS lang_count | |
| FROM ' . USERS_TABLE . ' | |
| GROUP BY user_lang'; | |
| $result = $db->sql_query($sql); | |
| $lang_count = array(); | |
| while ($row = $db->sql_fetchrow($result)) | |
| { | |
| $lang_count[$row['user_lang']] = $row['lang_count']; | |
| } | |
| $db->sql_freeresult($result); | |
| $sql = 'SELECT * | |
| FROM ' . LANG_TABLE . ' | |
| ORDER BY lang_english_name'; | |
| $result = $db->sql_query($sql); | |
| $installed = array(); | |
| while ($row = $db->sql_fetchrow($result)) | |
| { | |
| $installed[] = $row['lang_iso']; | |
| $tagstyle = ($row['lang_iso'] == $config['default_lang']) ? '*' : ''; | |
| $template->assign_block_vars('lang', array( | |
| 'U_DETAILS' => $this->u_action . "&action=details&id={$row['lang_id']}", | |
| 'U_DOWNLOAD' => $this->u_action . "&action=download&id={$row['lang_id']}", | |
| 'U_DELETE' => $this->u_action . "&action=delete&id={$row['lang_id']}", | |
| 'ENGLISH_NAME' => $row['lang_english_name'], | |
| 'TAG' => $tagstyle, | |
| 'LOCAL_NAME' => $row['lang_local_name'], | |
| 'ISO' => $row['lang_iso'], | |
| 'USED_BY' => (isset($lang_count[$row['lang_iso']])) ? $lang_count[$row['lang_iso']] : 0, | |
| )); | |
| } | |
| $db->sql_freeresult($result); | |
| $new_ary = $iso = array(); | |
| /** @var \phpbb\language\language_file_helper $language_helper */ | |
| $language_helper = $phpbb_container->get('language.helper.language_file'); | |
| $iso = $language_helper->get_available_languages(); | |
| foreach ($iso as $lang_array) | |
| { | |
| $lang_iso = $lang_array['iso']; | |
| if (!in_array($lang_iso, $installed)) | |
| { | |
| $new_ary[$lang_iso] = $lang_array; | |
| } | |
| } | |
| unset($installed); | |
| if (count($new_ary)) | |
| { | |
| foreach ($new_ary as $iso => $lang_ary) | |
| { | |
| $template->assign_block_vars('notinst', array( | |
| 'ISO' => htmlspecialchars($lang_ary['iso']), | |
| 'LOCAL_NAME' => htmlspecialchars($lang_ary['local_name'], ENT_COMPAT, 'UTF-8'), | |
| 'NAME' => htmlspecialchars($lang_ary['name'], ENT_COMPAT, 'UTF-8'), | |
| 'U_INSTALL' => $this->u_action . '&action=install&iso=' . urlencode($lang_ary['iso']) . '&hash=' . generate_link_hash('acp_language')) | |
| ); | |
| } | |
| } | |
| unset($new_ary); | |
| } | |
| /** | |
| * Compare two language files | |
| */ | |
| function compare_language_files($source_lang, $dest_lang, $file) | |
| { | |
| global $phpbb_root_path; | |
| $source_file = $phpbb_root_path . 'language/' . $source_lang . '/' . $file; | |
| $dest_file = $phpbb_root_path . 'language/' . $dest_lang . '/' . $file; | |
| if (!file_exists($dest_file)) | |
| { | |
| return array(); | |
| } | |
| $lang = array(); | |
| include($source_file); | |
| $lang_entry_src = $lang; | |
| $lang = array(); | |
| include($dest_file); | |
| $lang_entry_dst = $lang; | |
| unset($lang); | |
| return array_diff(array_keys($lang_entry_src), array_keys($lang_entry_dst)); | |
| } | |
| } |