$sql = 'SELECT *

FROM ' . LANG_TABLE . "

WHERE lang_id = $lang_id";

$sql_ary = array(

'lang_english_name' => request_var('lang_english_name', $row['lang_english_name']),

'lang_author' => utf8_normalize_nfc(request_var('lang_author', $row['lang_author'], true)),

);

WHERE lang_id = ' . $lang_id);

add_log('admin', 'LOG_LANGUAGE_PACK_UPDATED', $sql_ary['lang_english_name']);

$sql = 'SELECT *

FROM ' . LANG_TABLE . "

WHERE lang_id = $lang_id";

if (!$row)

{

$sql = 'SELECT lang_iso

FROM ' . LANG_TABLE . "

WHERE lang_id = $lang_id";

$file = request_var('file', '');

$dir = request_var('dir', '');

$sql = 'SELECT *

FROM ' . LANG_TABLE . '

WHERE lang_id = ' . $lang_id;

$lang_iso = $lang_entries['lang_iso'];

$missing_vars = $missing_files = array();

$sql = 'SELECT *

FROM ' . LANG_TABLE . '

WHERE lang_id = ' . $lang_id;

if ($row['lang_iso'] == phpbb::$config['default_lang'])

{

trigger_error(phpbb::$user->lang['NO_REMOVE_DEFAULT_LANG'] . adm_back_link($this->u_action), E_USER_WARNING);

}

$sql = 'UPDATE ' . USERS_TABLE . "

// 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;

$sql = 'DELETE FROM ' . PROFILE_FIELDS_LANG_TABLE . ' WHERE lang_id = ' . $lang_id;

phpbb::$acm->destroy_sql(STYLES_IMAGESET_DATA_TABLE);

$sql = 'SELECT lang_iso

FROM ' . LANG_TABLE . "

if ($row)

{

'lang_author' => $lang_pack['author']

);

$valid_localized = array(

'icon_back_top', 'icon_contact_aim', 'icon_contact_email', 'icon_contact_icq', 'icon_contact_jabber', 'icon_contact_msnm', 'icon_contact_pm', 'icon_contact_yahoo', 'icon_contact_www', 'icon_post_delete', 'icon_post_edit', 'icon_post_info', 'icon_post_quote', 'icon_post_report', 'icon_user_online', 'icon_user_offline', 'icon_user_profile', 'icon_user_search', 'icon_user_warn', 'button_pm_forward', 'button_pm_new', 'button_pm_reply', 'button_topic_locked', 'button_topic_new', 'button_topic_reply',

$sql = 'SELECT *

FROM ' . STYLES_IMAGESET_TABLE;

{

if (@file_exists(PHPBB_ROOT_PATH . "styles/{$imageset_row['imageset_path']}/imageset/{$lang_pack['iso']}/imageset.cfg"))

{

}

}

}

if (sizeof($sql_ary))

{

phpbb::$acm->destroy_sql(STYLES_IMAGESET_DATA_TABLE);

}

// 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 . "

// 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.

$sql = 'SELECT field_id, lang_name, lang_explain, lang_default_value

FROM ' . PROFILE_LANG_TABLE . '

WHERE lang_id = ' . $default_lang_id;

{

$row['lang_id'] = $lang_id;

}

$sql = 'SELECT field_id, option_id, field_type, lang_value

FROM ' . PROFILE_FIELDS_LANG_TABLE . '

WHERE lang_id = ' . $default_lang_id;

{

$row['lang_id'] = $lang_id;

}

add_log('admin', 'LOG_LANGUAGE_PACK_INSTALLED', $lang_pack['name']);

$sql = 'SELECT *

FROM ' . LANG_TABLE . '

WHERE lang_id = ' . $lang_id;

$use_method = request_var('use_method', '');

$methods = array('.tar');

$sql = 'SELECT user_lang, COUNT(user_lang) AS lang_count

FROM ' . USERS_TABLE . '

GROUP BY user_lang';

$lang_count = array();

{

$lang_count[$row['user_lang']] = $row['lang_count'];

}

$sql = 'SELECT *

FROM ' . LANG_TABLE . '

ORDER BY lang_english_name';

$installed = array();

{

$installed[] = $row['lang_iso'];

$tagstyle = ($row['lang_iso'] == phpbb::$config['default_lang']) ? '*' : '';

'USED_BY' => (isset($lang_count[$row['lang_iso']])) ? $lang_count[$row['lang_iso']] : 0,

));

}

$new_ary = $iso = array();

$dp = @opendir(PHPBB_ROOT_PATH . 'language');