+ array('poster_id', 'attachments.user_id_1 AS poster_id', 'phpbb_user_id'),

+ array('attach_comment', 'attachments_desc.comment', array('function1' => 'phpbb_set_encoding', 'function2' => 'utf8_htmlspecialchars')),

+ array('poster_id', 'attachments.user_id_1 AS poster_id', 'phpbb_user_id'),

+ array('attach_comment', 'attachments_desc.comment', array('function1' => 'phpbb_set_encoding', 'function2' => 'utf8_htmlspecialchars')),

+ array('group_name', 'extension_groups.group_name', array('function1' => 'phpbb_set_encoding', 'function2' => 'utf8_htmlspecialchars')),

+ array('disallow_username', 'disallow.disallow_username', 'phpbb_set_encoding'),

+ array('rank_title', 'ranks.rank_title', array('function1' => 'phpbb_set_encoding', 'function2' => 'utf8_htmlspecialchars')),

+ array('topic_poster', 'topics.topic_poster AS poster_id', 'phpbb_user_id'),

+ array('topic_title', 'topics.topic_title', 'phpbb_set_encoding'),

+ array('poll_title', 'vote_desc.vote_text', array('function1' => 'null_to_str', 'function2' => 'phpbb_set_encoding', 'function3' => 'utf8_htmlspecialchars')),

+ array('topic_poster', 'topics.topic_poster AS poster_id', 'phpbb_user_id'),

+ array('topic_title', 'topics.topic_title', 'phpbb_set_encoding'),

+ array('poll_title', 'vote_desc.vote_text', array('function1' => 'null_to_str', 'function2' => 'phpbb_set_encoding', 'function3' => 'utf8_htmlspecialchars')),

+ array('code', 'smilies.code', 'phpbb_set_encoding'),

+ array('emotion', 'smilies.emoticon', 'phpbb_set_encoding'),

+ array('', 'topics.topic_poster AS poster_id', ''),

+ array('poll_option_text', 'vote_results.vote_option_text', array('function1' => 'phpbb_set_encoding', 'function2' => 'utf8_htmlspecialchars')),

+ 'left_join' => 'vote_desc LEFT JOIN topics ON topics.topic_id = vote_desc.topic_id',

+ array('word', 'words.word', 'phpbb_set_encoding'),

+ array('replacement', 'words.replacement', 'phpbb_set_encoding'),

+ array('post_username', 'posts.post_username', 'phpbb_set_encoding'),

+ array('post_subject', 'posts_text.post_subject', 'phpbb_set_encoding'),

+ array('message_subject', 'privmsgs.privmsgs_subject', array('function1' => 'phpbb_set_encoding', 'function2' => 'utf8_htmlspecialchars')),

+ array('group_name', 'groups.group_name', 'phpbb_convert_group_name'), // phpbb_set_encoding called in phpbb_convert_group_name

+ array('group_desc', 'groups.group_description', 'phpbb_set_encoding'),

+ array('username', 'users.username', 'phpbb_set_default_encoding'), // recode to utf8 with default lang

+ array('username_clean', 'users.username', array('function1' => 'phpbb_set_default_encoding', 'function2' => 'utf8_clean_string')),

+ array('', 'users.user_lang', ''),

+ array('user_interests', 'users.user_interests', array('function1' => 'phpbb_set_encoding', 'function2' => 'utf8_htmlspecialchars')),

+ array('user_occ', 'users.user_occ', array('function1' => 'phpbb_set_encoding', 'function2' => 'utf8_htmlspecialchars')),

+ array('user_from', 'users.user_from', array('function1' => 'phpbb_set_encoding', 'function2' => 'utf8_htmlspecialchars')),

+ 'forum_name' => ($row['cat_title']) ? htmlspecialchars(phpbb_set_encoding($row['cat_title'], false), ENT_COMPAT, 'UTF-8') : $user->lang['CATEGORY'],

+ 'forum_name' => htmlspecialchars(phpbb_set_encoding($row['forum_name'], false), ENT_COMPAT, 'UTF-8'),

+ 'forum_desc' => htmlspecialchars(phpbb_set_encoding($row['forum_desc'], false), ENT_COMPAT, 'UTF-8'),

+/**

+* Function for recoding text with the default language

+*

+* @param string $text text to recode to utf8

+* @param bool $grab_user_lang if set to true the function tries to use $convert_row['user_lang'] (and falls back to $convert_row['poster_id']) instead of the boards default language

+*/

+function phpbb_set_encoding($text, $grab_user_lang = true)

+ global $lang_enc_array, $convert_row;

+ global $convert, $phpEx;

+ /*static $lang_enc_array = array(

+ 'korean' => 'euc-kr',

+ 'serbian' => 'windows-1250',

+ 'polish' => 'iso-8859-2',

+ 'kurdish' => 'windows-1254',

+ 'slovak' => 'Windows-1250',

+ 'russian' => 'windows-1251',

+ 'estonian' => 'iso-8859-4',

+ 'chinese_simplified' => 'gb2312',

+ 'macedonian' => 'windows-1251',

+ 'azerbaijani' => 'UTF-8',

+ 'romanian' => 'iso-8859-2',

+ 'romanian_diacritice' => 'iso-8859-2',

+ 'lithuanian' => 'windows-1257',

+ 'turkish' => 'iso-8859-9',

+ 'ukrainian' => 'windows-1251',

+ 'japanese' => 'shift_jis',

+ 'hungarian' => 'ISO-8859-2',

+ 'romanian_no_diacritics' => 'iso-8859-2',

+ 'mongolian' => 'UTF-8',

+ 'slovenian' => 'windows-1250',

+ 'bosnian' => 'windows-1250',

+ 'czech' => 'Windows-1250',

+ 'farsi' => 'Windows-1256',

+ 'croatian' => 'windows-1250',

+ 'greek' => 'iso-8859-7',

+ 'russian_tu' => 'windows-1251',

+ 'sakha' => 'UTF-8',

+ 'serbian_cyrillic' => 'windows-1251',

+ 'bulgarian' => 'windows-1251',

+ 'chinese_traditional_taiwan' => 'big5',

+ 'chinese_traditional' => 'big5',

+ 'arabic' => 'windows-1256',

+ 'hebrew' => 'WINDOWS-1255',

+ 'thai' => 'windows-874',

+ //'chinese_traditional_taiwan' => 'utf-8' // custom modified, we may have to do an include :-(

+ );*/

+ if (empty($lang_enc_array))

+ $lang_enc_array = array();

+ }

+

+ $get_lang = trim(get_config_value('default_lang'));

+ // Do we need the users language encoding?

+ if ($grab_user_lang && !empty($convert_row))

+ {

+ if (!empty($convert_row['user_lang']))

+ {

+ $get_lang = trim($convert_row['user_lang']);

+ }

+ else if (!empty($convert_row['poster_id']))

+ {

+ global $db;

+

+ $sql = 'SELECT user_lang

+ FROM ' . $convert->src_table_prefix . 'users

+ WHERE user_id = ' . (int) $convert_row['poster_id'];

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

+ $get_lang = (string) $db->sql_fetchfield('user_lang');

+ $db->sql_freeresult($result);

+

+ $get_lang = (!trim($get_lang)) ? trim(get_config_value('default_lang')) : trim($get_lang);

+ }

+ if (!isset($lang_enc_array[$get_lang]))

+ {

+ $filename = $convert->convertor_status['forum_path'] . '/language/lang_' . $get_lang . '/lang_main.' . $phpEx;

+

+ if (!file_exists($filename))

+ {

+ $get_lang = trim(get_config_value('default_lang'));

+ }

+

+ if (!isset($lang_enc_array[$get_lang]))

+ {

+ include($convert->convertor_status['forum_path'] . '/language/lang_' . $get_lang . '/lang_main.' . $phpEx);

+ $lang_enc_array[$get_lang] = $lang['ENCODING'];

+ unset($lang);

+ }

+ }

+

+ $encoding = $lang_enc_array[$get_lang];

+

+ return utf8_recode($text, $lang_enc_array[$get_lang]);

+/**

+* Same as phpbb_set_encoding, but forcing boards default language

+*/

+function phpbb_set_default_encoding($text)

+{

+ return phpbb_set_encoding($text, false);

+}

+ return phpbb_set_encoding($group_name, false);

+ $message = phpbb_set_encoding($message);