PageRenderTime 67ms CodeModel.GetById 25ms RepoModel.GetById 1ms app.codeStats 0ms

/administrator/components/com_kunenaimporter/models/export_phpbb3.php

https://github.com/johker-wst/com_kunenaimporter
PHP | 2006 lines | 1321 code | 109 blank | 576 comment | 58 complexity | 27264a4da1e93ba32f4f4d96d7f4c533 MD5 | raw file
    

  1. <?php
    2. 

  2. /**
    3. 

  3.  * Kunena Importer component
    4. 

  4.  * @package Kunena.com_kunenaimporter
    5. 

  5.  *
    6. 

  6.  * @copyright (C) 2008 - 2012 Kunena Team. All rights reserved.
    7. 

  7.  * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
    8. 

  8.  * @link http://www.kunena.org
    9. 

  9.  **/
    10. 

  10. defined ( '_JEXEC' ) or die ();
    11. 

  11. 

  12. // Import Joomla! libraries
    13. 

  13. jimport ( 'joomla.application.component.model' );
    14. 

  14. jimport ( 'joomla.application.application' );
    15. 

  15. 

  16. require_once (JPATH_COMPONENT . '/models/export.php');
    17. 

  17. 

  18. /**
    19. 

  19.  * phpBB3 Exporter Class
    20. 

  20.  *
    21. 

  21.  * Exports almost all data from phpBB3.
    22. 

  22.  * @todo Configuration import needs some work
    23. 

  23.  * @todo Forum ACL not exported (except for moderators)
    24. 

  24.  * @todo URL avatars not exported
    25. 

  25.  * @todo Ranks not exported
    26. 

  26.  * @todo Private messages not exported
    27. 

  27.  * @todo Some emoticons may be missing (images/db are not exported)
    28. 

  28.  */
    29. 

  29. class KunenaimporterModelExport_phpBB3 extends KunenaimporterModelExport {
    30. 

  30. 	/**
    31. 

  31. 	 * Extension name
    32. 

  32. 	 * @var string
    33. 

  33. 	 */
    34. 

  34. 	public $extname = 'phpbb3';
    35. 

  35. 	/**
    36. 

  36. 	 * Display name
    37. 

  37. 	 * @var string
    38. 

  38. 	 */
    39. 

  39. 	public $exttitle = 'phpBB3';
    40. 

  40. 	/**
    41. 

  41. 	 * External application
    42. 

  42. 	 * @var bool
    43. 

  43. 	 */
    44. 

  44. 	public $external = true;
    45. 

  45. 	/**
    46. 

  46. 	 * Minimum required version
    47. 

  47. 	 * @var string or null
    48. 

  48. 	 */
    49. 

  49. 	protected $versionmin = '3.0.8';
    50. 

  50. 	/**
    51. 

  51. 	 * Maximum accepted version
    52. 

  52. 	 * @var string or null
    53. 

  53. 	 */
    54. 

  54. 	protected $versionmax = '3.0.999';
    55. 

  55. 

  56. 	protected $rokbridge = null;
    57. 

  57. 	protected $dbconfig = null;
    58. 

  58. 

  59. 	/**
    60. 

  60. 	 * Get forum path from importer configuration
    61. 

  61. 	 *
    62. 

  62. 	 * @return bool
    63. 

  63. 	 */
    64. 

  64. 	public function getPath($absolute = false) {
    65. 

  65. 		// Load rokBridge configuration (if exists)
    66. 

  66. 		if ($this->rokbridge === null && version_compare(JVERSION, '1.6', '<')) {
    67. 

  67. 			$this->rokbridge = JComponentHelper::getParams( 'com_rokbridge' );
    68. 

  68. 		}
    69. 

  69. 		$path = $this->rokbridge ? $this->rokbridge->get('phpbb3_path') : '';
    70. 

  70. 		if (!$this->params->get('path') && $path) {
    71. 

  71. 			// Get phpBB3 path from rokBridge
    72. 

  72. 			$this->relpath = $path;
    73. 

  73. 			$this->basepath = JPATH_ROOT."/{$this->relpath}";
    74. 

  74. 			return $absolute ? $this->basepath : $this->relpath;
    75. 

  75. 		}
    76. 

  76. 		return parent::getPath($absolute);
    77. 

  77. 	}
    78. 

  78. 

  79. 	/**
    80. 

  80. 	 * Detect if component and config.php exists
    81. 

  81. 	 *
    82. 

  82. 	 * @return bool
    83. 

  83. 	 */
    84. 

  84. 	public function detectComponent($path=null) {
    85. 

  85. 		if ($path === null) $path = $this->basepath;
    86. 

  86. 		// Make sure that configuration file exist, but check also something else
    87. 

  87. 		if (!JFile::exists("{$path}/config.php")
    88. 

  88. 			|| !JFile::exists("{$path}/adm/swatch.php")
    89. 

  89. 			|| !JFile::exists("{$path}/viewtopic.php")) {
    90. 

  90. 			return false;
    91. 

  91. 		}
    92. 

  92. 		return true;
    93. 

  93. 	}
    94. 

  94. 

  95. 	/**
    96. 

  96. 	 * Get database object
    97. 

  97. 	 */
    98. 

  98. 	public function getDatabase() {
    99. 

  99. 		$config = $this->getDBConfig();
    100. 

  100. 		$database = null;
    101. 

  101. 		if ($config) {
    102. 

  102. 			$app = JFactory::getApplication ();
    103. 

  103. 			$option ['driver'] = $app->getCfg ( 'dbtype' );
    104. 

  104. 			$option ['host'] = $config['dbhost'];
    105. 

  105. 			$option ['user'] = $config['dbuser'];
    106. 

  106. 			$option ['password'] = $config['dbpasswd'];
    107. 

  107. 			$option ['database'] = $config['dbname'];
    108. 

  108. 			$option ['prefix'] = $config['table_prefix'];
    109. 

  109. 			$database = JDatabase::getInstance ( $option );
    110. 

  110. 		}
    111. 

  111. 		return $database;
    112. 

  112. 	}
    113. 

  113. 

  114. 	/**
    115. 

  115. 	 * Get database settings
    116. 

  116. 	 */
    117. 

  117. 	protected function &getDBConfig() {
    118. 

  118. 		if (!$this->dbconfig) {
    119. 

  119. 			require "{$this->basepath}/config.php";
    120. 

  120. 			$this->dbconfig = get_defined_vars();
    121. 

  121. 		}
    122. 

  122. 		return $this->dbconfig;
    123. 

  123. 	}
    124. 

  124. 

  125. 	public function initialize() {
    126. 

  126. 		global $phpbb_root_path, $phpEx;
    127. 

  127. 

  128. 		if(!defined('IN_PHPBB')) {
    129. 

  129. 			define('IN_PHPBB', true);
    130. 

  130. 		}
    131. 

  131. 

  132. 		if(!defined('STRIP')) {
    133. 

  133. 			define('STRIP', (get_magic_quotes_gpc()) ? true : false);
    134. 

  134. 		}
    135. 

  135. 

  136. 		$phpbb_root_path = $this->basepath.'/';
    137. 

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

  138. 	}
    139. 

  139. 

  140. 	public function &getConfig() {
    141. 

  141. 		if (empty($this->config)) {
    142. 

  142. 			// Check if database settings are correct
    143. 

  143. 			$query = "SELECT config_name, config_value AS value FROM #__config";
    144. 

  144. 			$this->ext_database->setQuery ( $query );
    145. 

  145. 			$this->config = $this->ext_database->loadObjectList ('config_name');
    146. 

  146. 		}
    147. 

  147. 		return $this->config;
    148. 

  148. 	}
    149. 

  149. 

  150. 

  151. 	/**
    152. 

  152. 	 * Full detection
    153. 

  153. 	 *
    154. 

  154. 	 * Make sure that everything is OK for full import.
    155. 

  155. 	 * Use $this->addMessage($html) to add status messages.
    156. 

  156. 	 * If you return false, remember also to fill $this->error
    157. 

  157. 	 *
    158. 

  158. 	 * @return bool
    159. 

  159. 	 */
    160. 

  160. 	public function detect() {
    161. 

  161. 		// Initialize detection (also calls $this->detectComponent())
    162. 

  162. 		if (!parent::detect()) return false;
    163. 

  163. 

  164. 		// Check RokBridge
    165. 

  165. 		if ($this->rokbridge && $this->rokbridge->get('phpbb3_path')) {
    166. 

  166. 			$this->addMessage ( '<div>RokBridge: <b style="color:green">detected</b></div>' );
    167. 

  167. 		}
    168. 

  168. 

  169. 		// Check authentication method
    170. 

  170. 		$query = "SELECT config_value FROM #__config WHERE config_name='auth_method'";
    171. 

  171. 		$this->ext_database->setQuery ( $query );
    172. 

  172. 		$auth_method = $this->ext_database->loadResult () or die ( "<br />Invalid query:<br />$query<br />" . $this->ext_database->errorMsg () );
    173. 

  173. 		$this->addMessage ( '<div>phpBB authentication method: <b style="color:green">' . $auth_method . '</b></div>' );
    174. 

  174. 

  175. 		// Find out which field is used as username
    176. 

  176. 		$fields = $this->ext_database->getTableFields('#__users');
    177. 

  177. 		$this->login_field = isset($fields['#__users']['login_name']);
    178. 

  178. 		return true;
    179. 

  179. 	}
    180. 

  180. 

  181. 	/**
    182. 

  182. 	 * Get component version
    183. 

  183. 	 */
    184. 

  184. 	public function getVersion() {
    185. 

  185. 		$query = "SELECT config_value FROM #__config WHERE config_name='version'";
    186. 

  186. 		$this->ext_database->setQuery ( $query );
    187. 

  187. 		$version = $this->ext_database->loadResult ();
    188. 

  188. 		// phpBB2 version
    189. 

  189. 		if ($version [0] == '.')
    190. 

  190. 			$version = '2' . $version;
    191. 

  191. 		return $version;
    192. 

  192. 	}
    193. 

  193. 

  194. 	/**
    195. 

  195. 	 * Remove htmlentities, addslashes etc
    196. 

  196. 	 *
    197. 

  197. 	 * @param string $s String
    198. 

  198. 	 */
    199. 

  199. 	protected function parseText(&$s) {
    200. 

  200. 		$s = html_entity_decode ( $s );
    201. 

  201. 	}
    202. 

  202. 

  203. 	/**
    204. 

  204. 	 * Convert BBCode to Kunena BBCode
    205. 

  205. 	 *
    206. 

  206. 	 * @param string $s String
    207. 

  207. 	 */
    208. 

  208. 	protected function parseBBCode(&$s) {
    209. 

  209. 		$s = html_entity_decode ( $s );
    210. 

  210. 

  211. 		// [b]: bold font
    212. 

  212. 		$s = preg_replace ( '/\[b(:.*?)\]/', '[b]', $s );
    213. 

  213. 		$s = preg_replace ( '/\[\/b(:.*?)\]/', '[/b]', $s );
    214. 

  214. 

  215. 		// [i]: italic font
    216. 

  216. 		$s = preg_replace ( '/\[i(:.*?)\]/', '[i]', $s );
    217. 

  217. 		$s = preg_replace ( '/\[\/i(:.*?)\]/', '[/i]', $s );
    218. 

  218. 

  219. 		// [u]: underlined font
    220. 

  220. 		$s = preg_replace ( '/\[u(:.*?)\]/', '[u]', $s );
    221. 

  221. 		$s = preg_replace ( '/\[\/u(:.*?)\]/', '[/u]', $s );
    222. 

  222. 

  223. 		// [quote], [quote=*]: (named) quotes
    224. 

  224. 		$s = preg_replace ( '/\[quote(:.*?)\]/', '[quote]', $s );
    225. 

  225. 		$s = preg_replace ( '/\[quote=["\']?([^"\']+?)["\']?(\s*):([^:]+?)\]/', '[quote="\\1"]', $s );
    226. 

  226. 		$s = preg_replace ( '/\[\/quote(:.*?)\]/', '[/quote]', $s );
    227. 

  227. 		
    228. 

  228. 		// [img]: images
    229. 

  229. 		$s = preg_replace ( '/\[img(:.*?)\]/', '[img]', $s );
    230. 

  230. 		$s = preg_replace ( '/[\/img(:.*?)\]/', '[/img]', $s );
    231. 

  231. 		
    232. 

  232. 		// [color=*]: font color
    233. 

  233. 		$s = preg_replace ( '/\[color=(.+?):([^:]+?)\]/', '[color=\\1]', $s );
    234. 

  234. 		$s = preg_replace ( '/\[\/color(:.*?)\]/', '[/color]', $s );
    235. 

  235. 		
    236. 

  236. 		/*
    237. 

  237. 		 * [size=*]: font size
    238. 

  238. 		 * Sizes range from 1 <= size <= 200. Map them to 1-6 using the
    239. 

  239. 		 * following map:
    240. 

  240. 		 *
    241. 

  241. 		 * 		phpbb		kunena
    242. 

  242. 		 *     1-39			1
    243. 

  243. 		 *     40-79		2
    244. 

  244. 		 *     80-119		3
    245. 

  245. 		 *     120-159		4
    246. 

  246. 		 *     160-179		5
    247. 

  247. 		 *     180-200		6
    248. 

  248. 		 */
    249. 

  249. 		$s = preg_replace ( '/\[size=[123]?[0-9](:.*?)\]/', '[size=1]', $s );
    250. 

  250. 		$s = preg_replace ( '/\[size=[4567][0-9](:.*?)\]/', '[size=2]', $s );
    251. 

  251. 		$s = preg_replace ( '/\[size=(8|9|10|11)[0-9](:.*?)\]/', '[size=3]', $s );
    252. 

  252. 		$s = preg_replace ( '/\[size=(12|13|14|15)[0-9](:.*?)\]/', '[size=4]', $s );
    253. 

  253. 		$s = preg_replace ( '/\[size=(16|17)[0-9](:.*?)\]/', '[size=5]', $s );
    254. 

  254. 		$s = preg_replace ( '/\[size=(((18|19)[0-9])|200)(:.*?)\]/', '[size=6]', $s );
    255. 

  255. 		$s = preg_replace ( '/\[\/size(:.*?)\]/', '[/size]', $s );
    256. 

  256. 

  257. 		// [code], [code=*]: raw code with and without syntax highlighting
    258. 

  258. 		$s = preg_replace ( '/\[code(:.*?)\]/', '[code]', $s );
    259. 

  259. 		$s = preg_replace ( '/\[code=([a-z]+):([^:]+?)\]/', '[code type="\\1"]', $s );
    260. 

  260. 		$s = preg_replace ( '/\[\/code(:.*?)\]/', '[/code]', $s );
    261. 

  261. 

  262. 		// [list], [list=*], [*], [/*]: lists (ordered, unordered), list elements
    263. 

  263. 		// default list
    264. 

  264. 		$s = preg_replace ( '/\[list(:.*?)\]/', '[list]', $s );
    265. 

  265. 		// roman
    266. 

  266. 		$s = preg_replace ( '/\[list=([iI])(:.*?)\]/', '[list=\\1]', $s );
    267. 

  267. 		// numeric
    268. 

  268. 		$s = preg_replace ( '/\[list=([0-9]+)(:.*?)\]/', '[list=1]', $s );
    269. 

  269. 		// lower alpha
    270. 

  270. 		$s = preg_replace ( '/\[list=([a-z])(:.*?)\]/', '[list=a]', $s );
    271. 

  271. 		// upper alpha
    272. 

  272. 		$s = preg_replace ( '/\[list=([A-Z])(:.*?)\]/', '[list=A]', $s );
    273. 

  273. 		// misc
    274. 

  274. 		$s = preg_replace ( '/\[list=(disc|circle|square)(:.*?)\]/', '[list=\\1]', $s );
    275. 

  275. 

  276. 		$s = preg_replace ( '/\[\/list:u(:.*?)\]/', '[/list]', $s );
    277. 

  277. 		$s = preg_replace ( '/\[\/list:o(:.*?)\]/', '[/list]', $s );
    278. 

  278. 

  279. 		// TODO [*] does not need to be closed (no [/*])
    280. 

  280. 		$s = preg_replace ( '/\[\*(:.*?)\]/', '[li]', $s );
    281. 

  281. 		$s = preg_replace ( '/\[\/\*(:.*?)\]/', '[/li]', $s );
    282. 

  282. 

  283. 		// smileys
    284. 

  284. 		$s = preg_replace ( '/<!-- s(.*?) --\>\<img src=\"{SMILIES_PATH}.*?\/\>\<!-- s.*? --\>/', ' \\1 ', $s );
    285. 

  285. 

  286. 		// misc
    287. 

  287. 		$s = preg_replace ( '/\<!-- e(.*?) --\>/', '', $s );
    288. 

  288. 		$s = preg_replace ( '/\<!-- w(.*?) --\>/', '', $s );
    289. 

  289. 		$s = preg_replace ( '/\<!-- m(.*?) --\>/', '', $s );
    290. 

  290. 		$s = preg_replace ( '/\<!-- l(.*?) --\>/', '', $s ); // local url
    291. 

  291. 		$s = preg_replace ( '/\<!-- ia(.*?) --\>/', '', $s ); // inline attachment
    292. 

  292. 

  293. 		// [email], [email=*]: mailto link with optional text
    294. 

  294. 		$s = preg_replace ( '/\[email(:.*?)\]/', '[email]', $s );
    295. 

  295. 		$s = preg_replace ( '/\[email=(.+?):([^:]+?)\]/', '[email=\\1]', $s );
    296. 

  296. 		$s = preg_replace ( '/\[\/email(:.*?)\]/', '[/email]', $s );
    297. 

  297. 

  298. 		// <a href="*">*</a>: HTML links with optional text
    299. 

  299. 		// TODO: convert urls
    300. 

  300. 		$s = preg_replace ( '/\<a class=\"postlink\" href=\"(.*?)\"\>(.*?)\<\/a\>/', '[url=\\1]\\2[/url]', $s );
    301. 

  301. 		$s = preg_replace ( '/\<a class=\"postlink-local\" href=\"(.*?)\"\>(.*?)\<\/a\>/', '[url=\\1]\\2[/url]', $s );
    302. 

  302. 		$s = preg_replace ( '/\<a href=\"(.*?)\"\>(.*?)\<\/a\>/', '[url=\\1]\\2[/url]', $s );
    303. 

  303. 

  304. 		$s = preg_replace ( '/\<a href=.*?mailto:.*?\>/', '', $s );
    305. 

  305. 

  306. 		// [url], [url=*]: URL links with optional text
    307. 

  307. 		$s = preg_replace ( '/\[url(:.*?)\]/', '[url]', $s );
    308. 

  308. 		$s = preg_replace ( '/\[url=(.+?):([^:]+?)\]/', '[url=\\1]', $s );
    309. 

  309. 		$s = preg_replace ( '/\[\/url(:.*?)\]/', '[/url]', $s );
    310. 

  310. 

  311. 		$s = preg_replace ( '/\<\/a\>/', '', $s );
    312. 

  312. 

  313. 		// [flash]: flash videos
    314. 

  314. 		$s = preg_replace ( '\[flash(.*?)\](.*?)\[\/flash(.*?)\]', '', $s );
    315. 

  315. 

  316. 		// snesfreaks specific
    317. 

  317. 		$s = preg_replace ( '/\[(s|strike)(:.*?)\]/', '[strike]', $s );
    318. 

  318. 		$s = preg_replace ( '/\[\/(s|strike)(:.*?)\]/', '[/strike]', $s );
    319. 

  319. 

  320. 		$s = preg_replace ( '/\[blink(:.*?)\]/', '', $s );
    321. 

  321. 		$s = preg_replace ( '/\[\/blink(:.*?)\]/', '', $s );
    322. 

  322. 

  323. 		$s = preg_replace ( '/\[spoiler(:.*?)\]/', '[spoiler]', $s );
    324. 

  324. 		$s = preg_replace ( '/\[\/spoiler(:.*?)\]/', '[/spoiler]', $s );
    325. 

  325. 

  326. 		// get youtube video id: http://stackoverflow.com/questions/3392993/php-regex-to-get-youtube-video-id
    327. 

  327. 		$s = preg_replace_callback ( '/\[youtube(:.*?)\](.*)\[\/youtube(:.*?)\]/', 
    328. 

  328. 				function($m) {
    329. 

  329. 					$parts = parse_url($m[2]);
    330. 

  330. 					if (isset($parts['query'])) {
    331. 

  331. 						parse_str($parts['query'], $qs);
    332. 

  332. 						if (isset($qs['v'])) {
    333. 

  333. 							$id = $qs['v'];
    334. 

  334. 						} else if($qs['vi']) {
    335. 

  335. 							$id = $qs['vi'];
    336. 

  336. 						}
    337. 

  337. 					}
    338. 

  338. 					if (isset($parts['path'])) {
    339. 

  339. 						$path = explode('/', trim($parts['path'], '/'));
    340. 

  340. 						$id = $path[count($path)-1];
    341. 

  341. 					}
    342. 

  342. 					
    343. 

  343. 					return '[video type="youtube"]' . $id . '[/video]';
    344. 

  344. 				}
    345. 

  345. 				, $s );
    346. 

  346. 	}
    347. 

  347. 

  348. 	/**
    349. 

  349. 	 * Map Joomla user to external user
    350. 

  350. 	 *
    351. 

  351. 	 * @param object $joomlauser StdClass(id, username, email)
    352. 

  352. 	 * @return int External user ID
    353. 

  353. 	 */
    354. 

  354. 	public function mapJoomlaUser($joomlauser) {
    355. 

  355. 		if ($this->login_field) {
    356. 

  356. 			// Use login_name created by SMF to phpBB3 convertor
    357. 

  357. 			$field = 'login_name';
    358. 

  358. 			$username = $joomlauser->username;
    359. 

  359. 		} else {
    360. 

  360. 			$field = 'username_clean';
    361. 

  361. 			$username = utf8_clean_string($joomlauser->username);
    362. 

  362. 		}
    363. 

  363. 		$query = "SELECT user_id
    364. 

  364. 			FROM #__users WHERE {$field}={$this->ext_database->Quote($username)}";
    365. 

    366. 

  366. 		$this->ext_database->setQuery( $query );
    367. 

  367. 		$result = intval($this->ext_database->loadResult());
    368. 

  368. 		return $result;
    369. 

  369. 	}
    370. 

  370. 

  371. 	/**
    372. 

  372. 	 * Count total number of users to be exported
    373. 

  373. 	 */
    374. 

  374. 	public function countUsers() {
    375. 

  375. 		$query = "SELECT COUNT(*) FROM #__users AS u WHERE user_id > 0 AND u.user_type != 2";
    376. 

  376. 		return $this->getCount ( $query );
    377. 

  377. 	}
    378. 

  378. 

  379. 	/**
    380. 

  380. 	 * Export users
    381. 

  381. 	 *
    382. 

  382. 	 * Returns list of user extuser objects containing database fields
    383. 

  383. 	 * to #__kunenaimporter_users.
    384. 

  384. 	 *
    385. 

  385. 	 * @param int $start Pagination start
    386. 

  386. 	 * @param int $limit Pagination limit
    387. 

  387. 	 * @return array
    388. 

  388. 	 */
    389. 

  389. 	public function &exportUsers($start = 0, $limit = 0) {
    390. 

  390. 		// phpbb3 user_type: 0=normal, 1=inactive, 2=ignore, 3=founder (super admin)
    391. 

  391. 

  392. 		$username = $this->login_field ? 'login_name' : 'username';
    393. 

  393. 		$query = "SELECT
    394. 

  394. 			u.user_id AS extid,
    395. 

  395. 			u.username_clean AS extusername,
    396. 

  396. 			u.username AS name,
    397. 

  397. 			u.{$username} AS username,
    398. 

  398. 			u.user_email AS email,
    399. 

  399. 			u.user_password AS password,
    400. 

  400. 			IF(u.user_type=3, 'Administrator', 'Registered') AS usertype,
    401. 

  401. 			IF(b.ban_userid>0 OR u.user_type=1, 1, 0) AS block,
    402. 

  402. 			FROM_UNIXTIME(u.user_regdate) AS registerDate,
    403. 

  403. 			IF(u.user_lastvisit>0, FROM_UNIXTIME(u.user_lastvisit), '0000-00-00 00:00:00') AS lastvisitDate,
    404. 

  404. 			NULL AS params,
    405. 

  405. 			u.user_pass_convert AS password_phpbb2
    406. 

  406. 		FROM #__users AS u
    407. 

  407. 		LEFT JOIN #__banlist AS b ON u.user_id = b.ban_userid
    408. 

  408. 		WHERE user_id > 0 AND u.user_type != 2
    409. 

  409. 		GROUP BY u.user_id
    410. 

  410. 		ORDER BY u.user_id";
    411. 

  411. 		$result = $this->getExportData ( $query, $start, $limit, 'extid' );
    412. 

  412. 		foreach ( $result as &$row ) {
    413. 

  413. 			$this->parseText ( $row->name );
    414. 

  414. 			$this->parseText ( $row->username );
    415. 

  415. 			$this->parseText ( $row->email );
    416. 

  416. 

  417. 			// Password hash check is described in phpBB3/includes/functions.php: phpbb_check_hash(),
    418. 

  418. 			// _hash_crypt_private() and _hash_encode64() if we want to add plugin for phpBB3 authentication.
    419. 

  419. 			// It works for all phpBB3 passwords, but phpBB2 passwords may need some extra work, which is
    420. 

  420. 			// described in phpBB3/includes/auth/auth_db.php. Basically phpBB2 passwords are encoded by using
    421. 

  421. 			// md5(utf8_to_cp1252(addslashes($password))).
    422. 

  422. 			if ($row->password_phpbb2) {
    423. 

  423. 				$row->password = 'phpbb2::'.$row->password;
    424. 

  424. 			} else {
    425. 

  425. 				$row->password = 'phpbb3::'.$row->password;
    426. 

  426. 			}
    427. 

  427. 		}
    428. 

  428. 		return $result;
    429. 

  429. 	}
    430. 

  430. 

  431. 	/**
    432. 

  432. 	 * Count total number of user profiles to be exported
    433. 

  433. 	 */
    434. 

  434. 	public function countUserProfile() {
    435. 

  435. 		$query = "SELECT COUNT(*) FROM #__users AS u WHERE user_id > 0 AND u.user_type != 2";
    436. 

  436. 		return $this->getCount ( $query );
    437. 

  437. 	}
    438. 

  438. 

  439. 	/**
    440. 

  440. 	 * Helper function to get list of all moderators
    441. 

  441. 	 */
    442. 

  442. 	protected function getModerators() {
    443. 

  443. 		static $mods = null;
    444. 

  444. 		if ($mods === null) {
    445. 

  445. 			// Get users in moderator groups
    446. 

  446. 			$query = "SELECT
    447. 

  447. 				u.user_id AS userid,
    448. 

  448. 				ag.forum_id AS catid
    449. 

  449. 			FROM #__acl_roles AS ar
    450. 

  450. 			INNER JOIN #__acl_groups AS ag ON ar.role_id=ag.auth_role_id
    451. 

  451. 			INNER JOIN #__user_group AS ug ON ug.group_id=ag.group_id
    452. 

  452. 			INNER JOIN #__users AS u ON u.user_id=ug.user_id AND u.user_id > 0 AND u.user_type != 2
    453. 

  453. 			WHERE role_type='m_'";
    454. 

  454. 			$result = $this->getExportData ( $query, 0, 10000 );
    455. 

  455. 			$mods = array();
    456. 

  456. 			foreach ($result as $item) {
    457. 

  457. 				$mods[$item->userid][$item->catid] = 1;
    458. 

  458. 			}
    459. 

  459. 

  460. 			// Get individual moderator rights
    461. 

  461. 			$query = "SELECT
    462. 

  462. 				u.user_id AS userid,
    463. 

  463. 				au.forum_id AS catid
    464. 

  464. 			FROM #__acl_roles AS ar
    465. 

  465. 			INNER JOIN #__acl_users AS au ON ar.role_id=au.auth_role_id
    466. 

  466. 			INNER JOIN #__users AS u ON u.user_id=au.user_id AND u.user_id > 0 AND u.user_type != 2
    467. 

  467. 			WHERE role_type='m_'";
    468. 

  468. 			$result = $this->getExportData ( $query, 0, 10000 );
    469. 

  469. 			foreach ($result as $item) {
    470. 

  470. 				$mods[$item->userid][$item->catid] = 1;
    471. 

  471. 			}
    472. 

  472. 		}
    473. 

  473. 		return $mods;
    474. 

  474. 	}
    475. 

  475. 

  476. 	/**
    477. 

  477. 	 * Export user profiles
    478. 

  478. 	 *
    479. 

  479. 	 * Returns list of user profile objects containing database fields
    480. 

  480. 	 * to #__kunena_users.
    481. 

  481. 	 *
    482. 

  482. 	 * @param int $start Pagination start
    483. 

  483. 	 * @param int $limit Pagination limit
    484. 

  484. 	 * @return array
    485. 

  485. 	 */
    486. 

  486. 	public function &exportUserProfile($start = 0, $limit = 0) {
    487. 

  487. 		$query = "SELECT
    488. 

  488. 			u.user_id AS userid,
    489. 

  489. 			'flat' AS view,
    490. 

  490. 			u.user_sig AS signature,
    491. 

  491. 			0 AS moderator,
    492. 

  492. 			NULL AS banned,
    493. 

  493. 			0 AS ordering,
    494. 

  494. 			u.user_posts AS posts,
    495. 

  495. 			u.user_avatar AS avatar,
    496. 

  496. 			0 AS karma,
    497. 

  497. 			0 AS karma_time,
    498. 

  498. 			0 AS uhits,
    499. 

  499. 			NULL AS personalText,
    500. 

  500. 			0 AS gender,
    501. 

  501. 			u.user_birthday AS birthdate,
    502. 

  502. 			u.user_from AS location,
    503. 

  503. 			u.user_icq AS ICQ,
    504. 

  504. 			u.user_aim AS AIM,
    505. 

  505. 			u.user_yim AS YIM,
    506. 

  506. 			u.user_msnm AS MSN,
    507. 

  507. 			NULL AS SKYPE,
    508. 

  508. 			NULL AS TWITTER,
    509. 

  509. 			NULL AS FACEBOOK,
    510. 

  510. 			u.user_jabber AS GTALK,
    511. 

  511. 			NULL AS MYSPACE,
    512. 

  512. 			NULL AS LINKEDIN,
    513. 

  513. 			NULL AS DELICIOUS,
    514. 

  514. 			NULL AS FRIENDFEED,
    515. 

  515. 			NULL AS DIGG,
    516. 

  516. 			NULL AS BLOGSPOT,
    517. 

  517. 			NULL AS FLICKR,
    518. 

  518. 			NULL AS BEBO,
    519. 

  519. 			u.user_website AS websitename,
    520. 

  520. 			u.user_website AS websiteurl,
    521. 

  521. 			0 AS rank,
    522. 

  522. 			(u.user_allow_viewemail=0) AS hideEmail,
    523. 

  523. 			u.user_allow_viewonline AS showOnline,
    524. 

  524. 			u.user_avatar_type AS avatartype
    525. 

  525. 		FROM #__users AS u
    526. 

  526. 		WHERE u.user_id > 0 AND u.user_type != 2
    527. 

  527. 		ORDER BY u.user_id";
    528. 

  528. 		$result = $this->getExportData ( $query, $start, $limit, 'userid' );
    529. 

  529. 		$moderators = $this->getModerators();
    530. 

  530. 

  531. 		$config = $this->getConfig();
    532. 

  532. 		$path = $config['avatar_path']->value;
    533. 

  533. 		$salt = $config['avatar_salt']->value;
    534. 

  534. 		foreach ( $result as &$row ) {
    535. 

  535. 			// Assign global moderator status
    536. 

  536. 			if (!empty($moderators[$row->userid])) $row->moderator = 1;
    537. 

  537. 			// Convert bbcode in signature
    538. 

  538. 			if ($row->avatar) {
    539. 

  539. 				switch ($row->avatartype) {
    540. 

  540. 					case 1:
    541. 

  541. 						// Uploaded
    542. 

  542. 						$filename = (int) $row->avatar;
    543. 

  543. 						$ext = substr(strrchr($row->avatar, '.'), 1);
    544. 

  544. 						$row->avatar = "users/{$row->avatar}";
    545. 

  545. 						$row->copypath = "{$this->basepath}/{$path}/{$salt}_{$filename}.{$ext}";
    546. 

  546. 						break;
    547. 

  547. 					case 2:
    548. 

  548. 						// URL not supported
    549. 

  549. 						$row->avatar = '';
    550. 

  550. 						break;
    551. 

  551. 					case 3:
    552. 

  552. 						// Gallery
    553. 

  553. 						$row->avatar = "gallery/{$row->avatar}";
    554. 

  554. 						break;
    555. 

  555. 					default:
    556. 

  556. 						$row->avatar = '';
    557. 

  557. 				}
    558. 

  558. 			}
    559. 

  559. 

  560. 			$this->parseBBCode ( $row->signature );
    561. 

  561. 			$this->parseText ( $row->location );
    562. 

  562. 			$this->parseText ( $row->AIM );
    563. 

  563. 			$this->parseText ( $row->YIM );
    564. 

  564. 			$this->parseText ( $row->MSN );
    565. 

  565. 			$this->parseText ( $row->GTALK );
    566. 

  566. 			$this->parseText ( $row->websitename );
    567. 

  567. 			$this->parseText ( $row->websiteurl );
    568. 

  568. 		}
    569. 

  569. 		return $result;
    570. 

  570. 	}
    571. 

  571. 

  572. 	/**
    573. 

  573. 	 * Count total number of sessions to be exported
    574. 

  574. 	 */
    575. 

  575. 	public function countSessions() {
    576. 

  576. 		$query = "SELECT COUNT(*) FROM #__users AS u WHERE user_lastvisit>0";
    577. 

  577. 		return $this->getCount ( $query );
    578. 

  578. 	}
    579. 

  579. 

  580. 	/**
    581. 

  581. 	 * Export user session information
    582. 

  582. 	 *
    583. 

  583. 	 * Returns list of session objects containing database fields
    584. 

  584. 	 * to #__kunena_sessions.
    585. 

  585. 	 *
    586. 

  586. 	 * @param int $start Pagination start
    587. 

  587. 	 * @param int $limit Pagination limit
    588. 

  588. 	 * @return array
    589. 

  589. 	 */
    590. 

  590. 	public function &exportSessions($start = 0, $limit = 0) {
    591. 

  591. 		$query = "SELECT
    592. 

  592. 			user_id AS userid,
    593. 

  593. 			NULL AS allowed,
    594. 

  594. 			user_lastmark AS lasttime,
    595. 

  595. 			'na' AS readtopics,
    596. 

  596. 			user_lastvisit AS currvisit
    597. 

  597. 		FROM #__users
    598. 

  598. 		WHERE user_lastvisit>0";
    599. 

  599. 		$result = $this->getExportData ( $query, $start, $limit );
    600. 

  600. 		return $result;
    601. 

  601. 	}
    602. 

  602. 

  603. 	/**
    604. 

  604. 	 * Count total number of categories to be exported
    605. 

  605. 	 */
    606. 

  606. 	public function countCategories() {
    607. 

  607. 		$query = "SELECT COUNT(*) FROM #__forums";
    608. 

  608. 		return $this->getCount ( $query );
    609. 

  609. 	}
    610. 

  610. 

  611. 	/**
    612. 

  612. 	 * Export sections and categories
    613. 

  613. 	 *
    614. 

  614. 	 * Returns list of category objects containing database fields
    615. 

  615. 	 * to #__kunena_categories.
    616. 

  616. 	 * All categories without parent are sections.
    617. 

  617. 	 *
    618. 

  618. 	 * NOTE: it's very important to keep category IDs (containing topics) the same!
    619. 

  619. 	 * If there are two tables for sections and categories, change IDs on sections..
    620. 

  620. 	 *
    621. 

  621. 	 * @param int $start Pagination start
    622. 

  622. 	 * @param int $limit Pagination limit
    623. 

  623. 	 * @return array
    624. 

  624. 	 */
    625. 

  625. 	public function &exportCategories($start = 0, $limit = 0) {
    626. 

  626. 		$query = "SELECT
    627. 

  627. 			forum_id AS id,
    628. 

  628. 			parent_id AS parent_id,
    629. 

  629. 			forum_name AS name,
    630. 

  630. 			forum_name AS alias,
    631. 

  631. 			0 AS icon_id,
    632. 

  632. 			(forum_status=1) AS locked,
    633. 

  633. 			'joomla.level' AS accesstype,
    634. 

  634. 			0 AS access,
    635. 

  635. 			0 AS pub_access,
    636. 

  636. 			1 AS pub_recurse,
    637. 

  637. 			0 AS admin_access,
    638. 

  638. 			1 AS admin_recurse,
    639. 

  639. 			left_id AS ordering,
    640. 

  640. 			1 AS published,
    641. 

  641. 			null AS channels,
    642. 

  642. 			0 AS checked_out,
    643. 

  643. 			'0000-00-00 00:00:00' AS checked_out_time,
    644. 

  644. 			0 AS review,
    645. 

  645. 			0 AS allow_anonymous,
    646. 

  646. 			0 AS post_anonymous,
    647. 

  647. 			0 AS hits,
    648. 

  648. 			forum_desc AS description,
    649. 

  649. 			forum_rules AS headerdesc,
    650. 

  650. 			'' AS class_sfx,
    651. 

  651. 			1 AS allow_polls,
    652. 

  652. 			'' AS topic_ordering,
    653. 

  653. 			forum_posts AS numPosts,
    654. 

  654. 			forum_topics_real AS numTopics,
    655. 

  655. 			0 AS last_topic_id,
    656. 

  656. 			forum_last_post_id AS last_post_id,
    657. 

  657. 			forum_last_post_time AS last_post_time,
    658. 

  658. 			(LENGTH(forum_desc_bitfield)>0) AS bbcode_desc,
    659. 

  659. 			(LENGTH(forum_rules_bitfield)>0) AS bbcode_header,
    660. 

  660. 			'' AS params
    661. 

  661. 		FROM #__forums ORDER BY id";
    662. 

  662. 		$result = $this->getExportData ( $query, $start, $limit, 'id' );
    663. 

  663. 		foreach ( $result as &$row ) {
    664. 

  664. 			$this->parseText ( $row->name );
    665. 

  665. 			// FIXME: joomla level in J2.5
    666. 

  666. 			// FIXME: remove id
    667. 

  667. 			$row->alias = KunenaRoute::stringURLSafe("{$row->id}-{$row->alias}");
    668. 

  668. 			if ($row->bbcode_desc) $this->parseBBCode ( $row->description );
    669. 

  669. 			else $this->parseText ( $row->description );
    670. 

  670. 			if ($row->bbcode_header) $this->parseBBCode ( $row->headerdesc );
    671. 

  671. 			else $this->parseText ( $row->headerdesc );
    672. 

  672. 		}
    673. 

  673. 		return $result;
    674. 

  674. 	}
    675. 

  675. 

  676. 	/**
    677. 

  677. 	 * Count total number of moderator columns to be exported
    678. 

  678. 	 */
    679. 

  679. 	public function countUserCategories_Role() {
    680. 

  680. 		$mods = $this->getModerators();
    681. 

  681. 		$result = 0;
    682. 

  682. 		foreach ($mods as $userid=>$item) {
    683. 

  683. 			foreach ($item as $catid=>$value) {
    684. 

  684. 				$result++;
    685. 

  685. 			}
    686. 

  686. 		}
    687. 

  687. 		return $result;
    688. 

  688. 	}
    689. 

  689. 

  690. 	/**
    691. 

  691. 	 * Export moderator columns
    692. 

  692. 	 *
    693. 

  693. 	 * Returns list of moderator objects containing database fields
    694. 

  694. 	 * to #__kunena_user_categories.
    695. 

  695. 	 *
    696. 

  696. 	 * @param int $start Pagination start
    697. 

  697. 	 * @param int $limit Pagination limit
    698. 

  698. 	 * @return array
    699. 

  699. 	 */
    700. 

  700. 	public function &exportUserCategories_Role($start = 0, $limit = 0) {
    701. 

  701. 		$mods = $this->getModerators();
    702. 

  702. 		$result = array();
    703. 

  703. 		foreach ($mods as $userid=>$item) {
    704. 

  704. 			foreach ($item as $catid=>$value) {
    705. 

  705. 				$mod = new StdClass();
    706. 

  706. 				$mod->user_id = $userid;
    707. 

  707. 				$mod->category_id = $catid;
    708. 

  708. 				$mod->role = 1;
    709. 

  709. 				$result[] = $mod;
    710. 

  710. 			}
    711. 

  711. 		}
    712. 

  712. 		$result = array_slice($result, $start, $limit);
    713. 

  713. 		return $result;
    714. 

  714. 	}
    715. 

  715. 

  716. 	/**
    717. 

  717. 	 * Count total number of all read time columns to be exported
    718. 

  718. 	 */
    719. 

  719. 	public function countUserCategories_Allreadtime() {
    720. 

  720. 		$query = "SELECT COUNT(*) FROM #__forums_track";
    721. 

  721. 		return $this->getCount ( $query );
    722. 

  722. 	}
    723. 

  723. 

  724. 	/**
    725. 

  725. 	 * Export all read time columns
    726. 

  726. 	 *
    727. 

  727. 	 * Returns list of all userCategory objects containing database fields
    728. 

  728. 	 * to #__kunena_user_categories.
    729. 

  729. 	 *
    730. 

  730. 	 * @param int $start Pagination start
    731. 

  731. 	 * @param int $limit Pagination limit
    732. 

  732. 	 * @return array
    733. 

  733. 	 */
    734. 

  734. 	public function &exportUserCategories_Allreadtime($start = 0, $limit = 0) {
    735. 

  735. 		$query = "SELECT
    736. 

  736. 			user_id AS user_id,
    737. 

  737. 			forum_id AS category_id,
    738. 

  738. 			FROM_UNIXTIME(mark_time) AS allreadtime
    739. 

  739. 			FROM #__forums_track";
    740. 

  740. 		return $this->getExportData ( $query, $start, $limit );
    741. 

  741. 	}
    742. 

  742. 

  743. 	/**
    744. 

  744. 	 * Count total number of category subscription columns to be exported
    745. 

  745. 	 */
    746. 

  746. 	public function countUserCategories_Subscribed() {
    747. 

  747. 		$query = "SELECT COUNT(*) FROM #__forums_watch";
    748. 

  748. 		return $this->getCount ( $query );
    749. 

  749. 	}
    750. 

  750. 

  751. 	/**
    752. 

  752. 	 * Export category subscription columns
    753. 

  753. 	 *
    754. 

  754. 	 * Returns list of userCategory objects containing database fields
    755. 

  755. 	 * to #__kunena_user_categories.
    756. 

  756. 	 *
    757. 

  757. 	 * @param int $start Pagination start
    758. 

  758. 	 * @param int $limit Pagination limit
    759. 

  759. 	 * @return array
    760. 

  760. 	 */
    761. 

  761. 	public function &exportUserCategories_Subscribed($start = 0, $limit = 0) {
    762. 

  762. 		$query = "SELECT
    763. 

  763. 			user_id AS user_id,
    764. 

  764. 			forum_id AS category_id,
    765. 

  765. 			(notify_status+1) AS subscribed
    766. 

  766. 			FROM #__forums_watch";
    767. 

  767. 		return $this->getExportData ( $query, $start, $limit );
    768. 

  768. 	}
    769. 

  769. 

  770. 	/**
    771. 

  771. 	 * Count total number of topics to be exported
    772. 

  772. 	 */
    773. 

  773. 	public function countTopics() {
    774. 

  774. 		$query = "SELECT COUNT(*) FROM #__topics";
    775. 

  775. 		$count = $this->getCount ( $query );
    776. 

  776. 		return $count;
    777. 

  777. 	}
    778. 

  778. 

  779. 	/**
    780. 

  780. 	 * Export topics
    781. 

  781. 	 *
    782. 

  782. 	 * Returns list of message objects containing database fields
    783. 

  783. 	 * to #__kunena_topics.
    784. 

  784. 	 *
    785. 

  785. 	 * @param int $start Pagination start
    786. 

  786. 	 * @param int $limit Pagination limit
    787. 

  787. 	 * @return array
    788. 

  788. 	 */
    789. 

  789. 	public function &exportTopics($start = 0, $limit = 0) {
    790. 

  790. 		$query = "SELECT
    791. 

  791. 		topic_id AS id,
    792. 

  792. 		forum_id AS category_id,
    793. 

  793. 		topic_title AS subject,
    794. 

  794. 		icon_id AS icon_id,
    795. 

  795. 		(topic_status=1) AS locked,
    796. 

  796. 		(topic_approved=0) AS hold,
    797. 

  797. 		(topic_type>0) AS ordering,
    798. 

  798. 		(topic_replies+1) AS posts,
    799. 

  799. 		topic_views AS hits,
    800. 

  800. 		topic_attachment AS attachments,
    801. 

  801. 		0 AS poll_id,
    802. 

  802. 		IF(topic_status=1,topic_moved_id,0) AS moved_id,
    803. 

  803. 		topic_first_post_id AS first_post_id,
    804. 

  804. 		0 AS first_post_time,
    805. 

  805. 		0 AS first_post_userid,
    806. 

  806. 		'' AS first_post_message,
    807. 

  807. 		topic_first_poster_name AS first_post_guest_name,
    808. 

  808. 		topic_last_post_id AS last_post_id,
    809. 

  809. 		0 AS last_post_time,
    810. 

  810. 		0 AS last_post_userid,
    811. 

  811. 		'' AS last_post_message,
    812. 

  812. 		topic_last_poster_name AS last_post_guest_name,
    813. 

  813. 		'' AS params
    814. 

  814. 		FROM #__topics";
    815. 

  815. 		// TODO: add support for announcements and global topics
    816. 

  816. 		$result = $this->getExportData ( $query, $start, $limit );
    817. 

  817. 		foreach ( $result as $key => &$row ) {
    818. 

  818. 			$this->parseText ( $row->subject );
    819. 

  819. 			$this->parseText ( $row->first_post_guest_name );
    820. 

  820. 			$this->parseText ( $row->last_post_guest_name );
    821. 

  821. 			$this->parseBBCode ( $row->first_post_message );
    822. 

  822. 			$this->parseBBCode ( $row->last_post_message );
    823. 

  823. 		}
    824. 

  824. 		return $result;
    825. 

  825. 	}
    826. 

  826. 

  827. 	/**
    828. 

  828. 	 * Count total number of messages to be exported
    829. 

  829. 	 */
    830. 

  830. 	public function countMessages() {
    831. 

  831. 		$query = "SELECT COUNT(*) FROM #__posts";
    832. 

  832. 		return $this->getCount ( $query );
    833. 

  833. 	}
    834. 

  834. 

  835. 	/**
    836. 

  836. 	 * Export messages
    837. 

  837. 	 *
    838. 

  838. 	 * Returns list of message objects containing database fields
    839. 

  839. 	 * to #__kunena_messages (and #__kunena_messages_text.message).
    840. 

  840. 	 *
    841. 

  841. 	 * @param int $start Pagination start
    842. 

  842. 	 * @param int $limit Pagination limit
    843. 

  843. 	 * @return array
    844. 

  844. 	 */
    845. 

  845. 	public function &exportMessages($start = 0, $limit = 0) {
    846. 

  846. 		$query = "SELECT
    847. 

  847. 			p.post_id AS id,
    848. 

  848. 			IF(p.post_id=t.topic_first_post_id,0,t.topic_first_post_id) AS parent,
    849. 

  849. 			p.topic_id AS thread,
    850. 

  850. 			p.forum_id AS catid,
    851. 

  851. 			IF(p.post_username, p.post_username, u.username) AS name,
    852. 

  852. 			p.poster_id AS userid,
    853. 

  853. 			u.user_email AS email,
    854. 

  854. 			IF(p.post_subject, p.post_subject, t.topic_title) AS subject,
    855. 

  855. 			p.post_time AS time,
    856. 

  856. 			p.poster_ip AS ip,
    857. 

  857. 			0 AS topic_emoticon,
    858. 

  858. 			(t.topic_status=1 AND p.post_id=t.topic_first_post_id) AS locked,
    859. 

  859. 			(p.post_approved=0) AS hold,
    860. 

  860. 			(t.topic_type>0 AND p.post_id=t.topic_first_post_id) AS ordering,
    861. 

  861. 			IF(p.post_id=t.topic_first_post_id,0,t.topic_views) AS hits,
    862. 

  862. 			t.topic_moved_id AS moved,
    863. 

  863. 			p.post_edit_user AS modified_by,
    864. 

  864. 			p.post_edit_time AS modified_time,
    865. 

  865. 			p.post_edit_reason AS modified_reason,
    866. 

  866. 			p.post_text AS message,
    867. 

  867. 			enable_bbcode
    868. 

  868. 		FROM #__posts AS p
    869. 

  869. 		LEFT JOIN #__topics AS t ON p.topic_id = t.topic_id
    870. 

  870. 		LEFT JOIN #__users AS u ON p.poster_id = u.user_id
    871. 

  871. 		ORDER BY p.post_id";
    872. 

  872. 		$result = $this->getExportData ( $query, $start, $limit, 'id' );
    873. 

  873. 

  874. 		foreach ( $result as &$row ) {
    875. 

  875. 			$this->parseText ( $row->name );
    876. 

  876. 			$this->parseText ( $row->email );
    877. 

  877. 			$this->parseText ( $row->subject );
    878. 

  878. 			if (! $row->modified_time)
    879. 

  879. 				$row->modified_by = 0;
    880. 

  880. 			$this->parseText ( $row->modified_reason );
    881. 

  881. 			if ($row->moved) {
    882. 

  882. 				// TODO: support moved messages (no txt)
    883. 

  883. 				$row->message = "id={$row->moved}";
    884. 

  884. 				$row->moved = 1;
    885. 

  885. 			} else {
    886. 

  886. 				if ($row->enable_bbcode) $this->parseBBcode ( $row->message );
    887. 

  887. 				else $this->parseText ( $row->message );
    888. 

  888. 			}
    889. 

  889. 		}
    890. 

  890. 		return $result;
    891. 

  891. 	}
    892. 

  892. 

  893. 	/**
    894. 

  894. 	 * Count total polls to be exported
    895. 

  895. 	 */
    896. 

  896. 	public function countPolls() {
    897. 

  897. 		$query="SELECT COUNT(*) FROM #__topics WHERE poll_title!=''";
    898. 

  898. 		return $this->getCount($query);
    899. 

  899. 	}
    900. 

  900. 

  901. 	/**
    902. 

  902. 	 * Export polls
    903. 

  903. 	 *
    904. 

  904. 	 * Returns list of poll objects containing database fields
    905. 

  905. 	 * to #__kunena_polls.
    906. 

  906. 	 *
    907. 

  907. 	 * @param int $start Pagination start
    908. 

  908. 	 * @param int $limit Pagination limit
    909. 

  909. 	 * @return array
    910. 

  910. 	 */
    911. 

  911. 	public function &exportPolls($start=0, $limit=0) {
    912. 

  912. 		$query="SELECT
    913. 

  913. 			topic_id AS id,
    914. 

  914. 			poll_title AS title,
    915. 

  915. 			topic_id AS threadid,
    916. 

  916. 			IF(poll_length>0,FROM_UNIXTIME(poll_start+poll_length),'0000-00-00 00:00:00') AS polltimetolive
    917. 

  917. 		FROM #__topics
    918. 

  918. 		WHERE poll_title!=''
    919. 

  919. 		ORDER BY threadid";
    920. 

  920. 		$result = $this->getExportData($query, $start, $limit, 'id');
    921. 

  921. 		return $result;
    922. 

  922. 	}
    923. 

  923. 

  924. 	/**
    925. 

  925. 	 * Count total poll options to be exported
    926. 

  926. 	 */
    927. 

  927. 	public function countPollsOptions() {
    928. 

  928. 		$query="SELECT COUNT(*) FROM #__poll_options AS o INNER JOIN #__topics AS t ON o.topic_id=t.topic_id";
    929. 

  929. 		return $this->getCount($query);
    930. 

  930. 	}
    931. 

  931. 

  932. 	/**
    933. 

  933. 	 * Export poll options
    934. 

  934. 	 *
    935. 

  935. 	 * Returns list of poll options objects containing database fields
    936. 

  936. 	 * to #__kunena_polls_options.
    937. 

  937. 	 *
    938. 

  938. 	 * @param int $start Pagination start
    939. 

  939. 	 * @param int $limit Pagination limit
    940. 

  940. 	 * @return array
    941. 

  941. 	 */
    942. 

  942. 	public function &exportPollsOptions($start=0, $limit=0) {
    943. 

  943. 		$query="SELECT
    944. 

  944. 			0 AS id,
    945. 

  945. 			t.topic_id AS pollid,
    946. 

  946. 			o.poll_option_text AS text,
    947. 

  947. 			o.poll_option_total AS votes
    948. 

  948. 		FROM #__poll_options AS o
    949. 

  949. 		INNER JOIN #__topics AS t ON o.topic_id=t.topic_id
    950. 

  950. 		ORDER BY pollid, o.poll_option_id";
    951. 

  951. 		$result = $this->getExportData($query, $start, $limit);
    952. 

  952. 		return $result;
    953. 

  953. 	}
    954. 

  954. 

  955. 	/**
    956. 

  956. 	 * Count total poll users to be exported
    957. 

  957. 	 */
    958. 

  958. 	public function countPollsUsers() {
    959. 

  959. 		$query="SELECT COUNT(DISTINCT v.vote_user_id) FROM #__poll_votes AS v INNER JOIN #__topics AS t ON v.topic_id=t.topic_id";
    960. 

  960. 		return $this->getCount($query);
    961. 

  961. 	}
    962. 

  962. 

  963. 	/**
    964. 

  964. 	 * Export poll users
    965. 

  965. 	 *
    966. 

  966. 	 * Returns list of poll users objects containing database fields
    967. 

  967. 	 * to #__kunena_polls_users.
    968. 

  968. 	 *
    969. 

  969. 	 * @param int $start Pagination start
    970. 

  970. 	 * @param int $limit Pagination limit
    971. 

  971. 	 * @return array
    972. 

  972. 	 */
    973. 

  973. 	public function &exportPollsUsers($start=0, $limit=0) {
    974. 

  974. 		// WARNING: from unknown reason pollid = threadid!!!
    975. 

  975. 		$query="SELECT
    976. 

  976. 			t.topic_id AS pollid,
    977. 

  977. 			v.vote_user_id AS userid,
    978. 

  978. 			COUNT(*) AS votes,
    979. 

  979. 			'0000-00-00 00:00:00' AS lasttime,
    980. 

  980. 			0 AS lastvote
    981. 

  981. 		FROM #__poll_votes AS v
    982. 

  982. 		INNER JOIN #__topics AS t ON v.topic_id=t.topic_id
    983. 

  983. 		GROUP BY v.vote_user_id";
    984. 

  984. 		$result = $this->getExportData($query, $start, $limit);
    985. 

  985. 		return $result;
    986. 

  986. 	}
    987. 

  987. 

  988. 	/**
    989. 

  989. 	 * Count total number of all read time columns to be exported
    990. 

  990. 	 */
    991. 

  991. 	public function countUserTopics_Allreadtime() {
    992. 

  992. 		$query = "SELECT COUNT(*) FROM #__topics_track";
    993. 

  993. 		return $this->getCount ( $query );
    994. 

  994. 	}
    995. 

  995. 

  996. 	/**
    997. 

  997. 	 * Export mark read information for topics
    998. 

  998. 	 *
    999. 

  999. 	 * Returns list of items containing database fields
    1000. 

  1000. 	 * to #__kunena_user_topics.
    1001. 

  1001. 	 *
    1002. 

  1002. 	 * @param int $start Pagination start
    1003. 

  1003. 	 * @param int $limit Pagination limit
    1004. 

  1004. 	 * @return array
    1005. 

  1005. 	 */
    1006. 

  1006. 	public function &exportUserTopics_Allreadtime($start = 0, $limit = 0) {
    1007. 

  1007. 		$query = "SELECT
    1008. 

  1008. 			user_id AS user_id,
    1009. 

  1009. 			topic_id AS topic_id,
    1010. 

  1010. 			forum_id AS category_id,
    1011. 

  1011. 			0 AS message_id,
    1012. 

  1012. 			mark_time AS time
    1013. 

  1013. 			FROM #__topics_track";
    1014. 

  1014. 		return $this->getExportData ( $query, $start, $limit );
    1015. 

  1015. 	}
    1016. 

  1016. 

  1017. 	/**
    1018. 

  1018. 	 * Count total number of category subscription columns to be exported
    1019. 

  1019. 	 */
    1020. 

  1020. 	public function countUserTopics_Subscribed() {
    1021. 

  1021. 		$query = "SELECT COUNT(*) FROM #__topics_watch";
    1022. 

  1022. 		return $this->getCount ( $query );
    1023. 

  1023. 	}
    1024. 

  1024. 

  1025. 	/**
    1026. 

  1026. 	 * Export category subscriptions
    1027. 

  1027. 	 *
    1028. 

  1028. 	 * Returns list of items containing database fields
    1029. 

  1029. 	 * to #__kunena_user_topics.
    1030. 

  1030. 	 *
    1031. 

  1031. 	 * @param int $start Pagination start
    1032. 

  1032. 	 * @param int $limit Pagination limit
    1033. 

  1033. 	 * @return array
    1034. 

  1034. 	 */
    1035. 

  1035. 	public function &exportUserTopics_Subscribed($start = 0, $limit = 0) {
    1036. 

  1036. 		$query = "SELECT
    1037. 

  1037. 			user_id AS user_id,
    1038. 

  1038. 			topic_id AS topic_id,
    1039. 

  1039. 			(notify_status+1) AS subscribed
    1040. 

  1040. 			FROM #__topics_watch";
    1041. 

  1041. 		return $this->getExportData ( $query, $start, $limit );
    1042. 

  1042. 	}
    1043. 

  1043. 

  1044. 	/**
    1045. 

  1045. 	 * Count total number of attachments to be exported
    1046. 

  1046. 	 */
    1047. 

  1047. 	public function countAttachments() {
    1048. 

  1048. 		$query = "SELECT COUNT(*) FROM #__attachments";
    1049. 

  1049. 		return $this->getCount ( $query );
    1050. 

  1050. 	}
    1051. 

  1051. 

  1052. 	/**
    1053. 

  1053. 	 * Export attachments in messages
    1054. 

  1054. 	 *
    1055. 

  1055. 	 * Returns list of attachment objects containing database fields
    1056. 

  1056. 	 * to #__kunena_attachments.
    1057. 

  1057. 	 * NOTE: copies all files found in $row->copyfile (full path) to Kunena.
    1058. 

  1058. 	 *
    1059. 

  1059. 	 * @param int $start Pagination start
    1060. 

  1060. 	 * @param int $limit Pagination limit
    1061. 

  1061. 	 * @return array
    1062. 

  1062. 	 */
    1063. 

  1063. 	public function &exportAttachments($start = 0, $limit = 0) {
    1064. 

  1064. 		$query = "SELECT
    1065. 

  1065. 			attach_id AS id,
    1066. 

  1066. 			post_msg_id AS mesid,
    1067. 

  1067. 			poster_id AS userid,
    1068. 

  1068. 			NULL AS hash,
    1069. 

  1069. 			filesize AS size,
    1070. 

  1070. 			'phpbb3' AS folder,
    1071. 

  1071. 			IF(LENGTH(mimetype)>0,mimetype,extension) AS filetype,
    1072. 

  1072. 			real_filename AS filename,
    1073. 

  1073. 			physical_filename AS realfile
    1074. 

  1074. 		FROM `#__attachments`
    1075. 

  1075. 		ORDER BY attach_id";
    1076. 

  1076. 		$result = $this->getExportData ( $query, $start, $limit, 'id' );
    1077. 

  1077. 		foreach ( $result as &$row ) {
    1078. 

  1078. 			$row->copypath = "{$this->basepath}/files/{$row->realfile}";
    1079. 

  1079. 			$row->copypaththumb = "{$this->basepath}/files/thumb_{$row->realfile}";
    1080. 

  1080. 		}
    1081. 

  1081. 		return $result;
    1082. 

  1082. 	}
    1083. 

  1083. 

  1084. 	/**
    1085. 

  1085. 	 * Count total number of avatar galleries to be exported
    1086. 

  1086. 	 */
    1087. 

  1087. 	public function countAvatarGalleries() {
    1088. 

  1088. 		return count($this->getAvatarGalleries());
    1089. 

  1089. 	}
    1090. 

  1090. 

  1091. 	/**
    1092. 

  1092. 	 * Export avatar galleries
    1093. 

  1093. 	 *
    1094. 

  1094. 	 * Returns list of folder=>fullpath to be copied, where fullpath points
    1095. 

  1095. 	 * to the directory in the filesystem.
    1096. 

  1096. 	 *
    1097. 

  1097. 	 * @param int $start Pagination start
    1098. 

  1098. 	 * @param int $limit Pagination limit
    1099. 

  1099. 	 * @return array
    1100. 

  1100. 	 */
    1101. 

  1101. 	public function &exportAvatarGalleries($start = 0, $limit = 0) {
    1102. 

  1102. 		$galleries = array_slice($this->getAvatarGalleries(), $start, $limit);
    1103. 

  1103. 		return $galleries;
    1104. 

  1104. 	}
    1105. 

  1105. 

  1106. 	/**
    1107. 

  1107. 	 * Internal function to fetch all avatar galleries
    1108. 

  1108. 	 *
    1109. 

  1109. 	 * @return array (folder=>full path, ...)
    1110. 

  1110. 	 */
    1111. 

  1111. 	protected function &getAvatarGalleries() {
    1112. 

  1112. 		$config = $this->getConfig();
    1113. 

  1113. 		static $galleries = false;
    1114. 

  1114. 		if ($galleries === false) {
    1115. 

  1115. 			$galleries = array();
    1116. 

  1116. 			if (isset($config['avatar_gallery_path'])) {
    1117. 

  1117. 				$path = "{$this->basepath}/{$config['avatar_gallery_path']->value}";
    1118. 

  1118. 				$folders = JFolder::folders($path);
    1119. 

  1119. 				foreach ($folders as $folder) {
    1120. 

  1120. 					$galleries[$folder] = "{$path}/{$folder}";
    1121. 

  1121. 				}
    1122. 

  1122. 			}
    1123. 

  1123. 		}
    1124. 

  1124. 		return $galleries;
    1125. 

  1125. 	}
    1126. 

  1126. 

  1127. 	/**
    1128. 

  1128. 	 * Count global configurations to be exported
    1129. 

  1129. 	 * @return 1
    1130. 

  1130. 	 */
    1131. 

  1131. 	public function countConfig() {
    1132. 

  1132. 		return 1;
    1133. 

  1133. 	}
    1134. 

  1134. 

  1135. 	/**
    1136. 

  1136. 	 * Export global configuration
    1137. 

  1137. 	 *
    1138. 

  1138. 	 * @param int $start Pagination start
    1139. 

  1139. 	 * @param int $limit Pagination limit
    1140. 

  1140. 	 * @return array (1=>(array(option=>value, ...)))
    1141. 

  1141. 	 */
    1142. 

  1142. 	public function &exportConfig($start = 0, $limit = 0) {
    1143. 

  1143. 		$config = array ();
    1144. 

  1144. 		if ($start)
    1145. 

  1145. 			return $config;
    1146. 

  1146. 

  1147. 		$result = $this->getConfig();
    1148. 

  1148. 

  1149. 		// Time delta in seconds from UTC (=JFactory::getDate()->toUnix())
    1150. 

  1150. 		$config['timedelta'] = JFactory::getDate()->toUnix() - time();
    1151. 

  1151. 

  1152. 		$config ['id'] = 1; // $result['config_id']->value;
    1153. 

  1153. 		$config ['board_title'] = $result ['sitename']->value;
    1154. 

  1154. 		$config ['email'] = $result ['board_email']->value;
    1155. 

  1155. 		$config ['board_offline'] = $result ['board_disable']->value;
    1156. 

  1156. 		// $config['offline_message'] = null;
    1157. 

  1157. 		// $config['enablerss'] = null;
    1158. 

  1158. 		// $config['enablepdf'] = null;
    1159. 

  1159. 		$config ['threads_per_page'] = $result ['topics_per_page']->value;
    1160. 

  1160. 		$config ['messages_per_page'] = $result ['posts_per_page']->value;
    1161. 

  1161. 		// $config['messages_per_page_search'] = null;
    1162. 

  1162. 		// $config['showhistory'] = null;
    1163. 

  1163. 		// $config['historylimit'] = null;
    1164. 

  1164. 		// $config['shownew'] = null;
    1165. 

  1165. 		// $config['jmambot'] = null;
    1166. 

  1166. 		$config ['disemoticons'] = $result ['allow_smilies']->value ^ 1;
    1167. 

  1167. 		// $config['template'] = null;
    1168. 

  1168. 		// $config['showannouncement'] = null;
    1169. 

  1169. 		// $config['avataroncat'] = null;
    1170. 

  1170. 		// $config['catimagepath'] = null;
    1171. 

  1171. 		// $config['showchildcaticon'] = null;
    1172. 

  1172. 		// $config['annmodid'] = null;
    1173. 

  1173. 		// $config['rtewidth'] = null;
    1174. 

  1174. 		// $config['rteheight'] = null;
    1175. 

  1175. 		// $config['enableforumjump'] = null;
    1176. 

  1176. 		// $config['reportmsg'] = null;
    1177. 

  1177. 		// $config['username'] = null;
    1178. 

  1178. 		// $config['askemail'] = null;
    1179. 

  1179. 		// $config['showemail'] = null;
    1180. 

  1180. 		// $config['showuserstats'] = null;
    1181. 

  1181. 		// $config['showkarma'] = null;
    1182. 

  1182. 		// $config['useredit'] = null;
    1183. 

  1183. 		// $config['useredittime'] = null;
    1184. 

  1184. 		// $config['useredittimegrace'] = null;
    1185. 

  1185. 		// $config['editmarkup'] = null;
    1186. 

  1186. 		$config ['allowsubscriptions'] = $result ['allow_topic_notify']->value;
    1187. 

  1187. 		// $config['subscriptionschecked'] = null;
    1188. 

  1188. 		// $config['allowfavorites'] = null;
    1189. 

  1189. 		// $config['maxsubject'] = null;
    1190. 

  1190. 		$config ['maxsig'] = $result ['allow_sig']->value ? $result ['max_sig_chars']->value : 0;
    1191. 

  1191. 		// $config['regonly'] = null;
    1192. 

  1192. 		$config ['changename'] = $result ['allow_namechange']->value;
    1193. 

  1193. 		// $config['pubwrite'] = null;
    1194. 

  1194. 		$config ['floodprotection'] = $result ['flood_interval']->value;
    1195. 

  1195. 		// $config['mailmod'] = null;
    1196. 

  1196. 		// $config['mailadmin'] = null;
    1197. 

  1197. 		// $config['captcha'] = null;
    1198. 

  1198. 		// $config['mailfull'] = null;
    1199. 

  1199. 		$config ['allowavatar'] = $result ['allow_avatar_upload']->value || $result ['allow_avatar_local']->value;
    1200. 

  1200. 		$config ['allowavatarupload'] = $result ['allow_avatar_upload']->value;
    1201. 

  1201. 		$config ['allowavatargallery'] = $result ['allow_avatar_local']->value;
    1202. 

  1202. 		// $config['avatarquality'] = null;
    1203. 

  1203. 		$config ['avatarsize'] = ( int ) ($result ['avatar_filesize']->value / 1000);
    1204. 

  1204. 		// $config['allowimageupload'] = null;
    1205. 

  1205. 		// $config['allowimageregupload'] = null;
    1206. 

  1206. 		$config['imageheight'] = $result ['img_max_height']->value;
    1207. 

  1207. 		$config['imagewidth'] = $result ['img_max_width']->value;
    1208. 

  1208. 		// $config['imagesize'] = null;
    1209. 

  1209. 		// $config['allowfileupload'] = null;
    1210. 

  1210. 		// $config['allowfileregupload'] = null;
    1211. 

  1211. 		// $config['filetypes'] = null;
    1212. 

  1212. 		$config ['filesize'] = ( int ) ($result ['max_filesize']->value / 1000);
    1213. 

  1213. 		// $config['showranking'] = null;
    1214. 

  1214. 		// $config['rankimages'] = null;
    1215. 

  1215. 		// $config['avatar_src'] = null;
    1216. 

  1216. 		// $config['pm_component'] = null;
    1217. 

  1217. 		// $config['discussbot'] = null;
    1218. 

  1218. 		// $config['userlist_rows'] = null;
    1219. 

  1219. 		// $config['userlist_online'] = null;
    1220. 

  1220. 		// $config['userlist_avatar'] = null;
    1221. 

  1221. 		// $config['userlist_name'] = null;
    1222. 

  1222. 		// $config['userlist_username'] = null;
    1223. 

  1223. 		// $config['userlist_posts'] = null;
    1224. 

  1224. 		// $config['userlist_karma'] = null;
    1225. 

  1225. 		// $config['userlist_email'] = null;
    1226. 

  1226. 		// $config['userlist_usertype'] = null;
    1227. 

  1227. 		// $config['userlist_joindate'] = null;
    1228. 

  1228. 		// $config['userlist_lastvisitdate'] = null;
    1229. 

  1229. 		// $config['userlist_userhits'] = null;
    1230. 

  1230. 		// $config['latestcategory'] = null;
    1231. 

  1231. 		// $config['showstats'] = null;
    1232. 

  1232. 		// $config['showwhoisonline'] = null;
    1233. 

  1233. 		// $config['showgenstats'] = null;
    1234. 

  1234. 		// $config['showpopuserstats'] = null;
    1235. 

  1235. 		// $config['popusercount'] = null;
    1236. 

  1236. 		// $config['showpopsubjectstats'] = null;
    1237. 

  1237. 		// $config['popsubjectcount'] = null;
    1238. 

  1238. 		// $config['usernamechange'] = null;
    1239. 

  1239. 		// $config['rules_infb'] = null;
    1240. 

  1240. 		// $config['rules_cid'] = null;
    1241. 

  1241. 		// $config['help_infb'] = null;
    1242. 

  1242. 		// $config['help_cid'] = null;
    1243. 

  1243. 		// $config['showspoilertag'] = null;
    1244. 

  1244. 		// $config['showvideotag'] = null;
    1245. 

  1245. 		// $config['showebaytag'] = null;
    1246. 

  1246. 		// $config['trimlongurls'] = null;
    1247. 

  1247. 		// $config['trimlongurlsfront'] = null;
    1248. 

  1248. 		// $config['trimlongurlsback'] = null;
    1249. 

  1249. 		// $config['autoembedyoutube'] = null;
    1250. 

  1250. 		// $config['autoembedebay'] = null;
    1251. 

  1251. 		// $config['ebaylanguagecode'] = null;
    1252. 

  1252. 		$config ['fbsessiontimeout'] = $result ['session_length']->value;
    1253. 

  1253. 		// $config['highlightcode'] = null;
    1254. 

  1254. 		// $config['rss_type'] = null;
    1255. 

  1255. 		// $config['rss_timelimit'] = null;
    1256. 

  1256. 		// $config['rss_limit'] = null;
    1257. 

  1257. 		// $config['rss_included_categories'] = null;
    1258. 

  1258. 		// $config['rss_excluded_categories'] = null;
    1259. 

  1259. 		// $config['rss_specification'] = null;
    1260. 

  1260. 		// $config['rss_allow_html'] = null;
    1261. 

  1261. 		// $config['rss_author_format'] = null;
    1262. 

  1262. 		// $config['rss_author_in_title'] = null;
    1263. 

  1263. 		// $config['rss_word_count'] = null;
    1264. 

  1264. 		// $config['rss_old_titles'] = null;
    1265. 

  1265. 		// $config['rss_cache'] = null;
    1266. 

  1266. 		$config['fbdefaultpage'] = 'categories';
    1267. 

  1267. 		// $config['default_sort'] = null;
    1268. 

  1268. 		// $config['alphauserpointsnumchars'] = null;
    1269. 

  1269. 		// $config['sef'] = null;
    1270. 

  1270. 		// $config['sefcats'] = null;
    1271. 

  1271. 		// $config['sefutf8'] = null;
    1272. 

  1272. 		// $config['showimgforguest'] = null;
    1273. 

  1273. 		// $config['showfileforguest'] = null;
    1274. 

  1274. 		// $config['pollnboptions'] = null;
    1275. 

  1275. 		// $config['pollallowvoteone'] = null;
    1276. 

  1276. 		// $config['pollenabled'] = null;
    1277. 

  1277. 		// $config['poppollscount'] = null;
    1278. 

  1278. 		// $config['showpoppollstats'] = null;
    1279. 

  1279. 		// $config['polltimebtvotes'] = null;
    1280. 

  1280. 		// $config['pollnbvotesbyuser'] = null;
    1281. 

  1281. 		// $config['pollresultsuserslist'] = null;
    1282. 

  1282. 		// $config['maxpersotext'] = null;
    1283. 

  1283. 		// $config['ordering_system'] = null;
    1284. 

  1284. 		// $config['post_dateformat'] = null;
    1285. 

  1285. 		// $config['post_dateformat_hover'] = null;
    1286. 

  1286. 		// $config['hide_ip'] = null;
    1287. 

  1287. 		// $config['js_actstr_integration'] = null;
    1288. 

  1288. 		// $config['imagetypes'] = null;
    1289. 

  1289. 		// $config['checkmimetypes'] = null;
    1290. 

  1290. 		// $config['imagemimetypes'] = null;
    1291. 

  1291. 		// $config['imagequality'] = null;
    1292. 

  1292. 		$config['thumbwidth'] = isset($result ['img_max_thumb_width']->value) ? $result ['img_max_thumb_width']->value : 32;
    1293. 

  1293. 		$config['thumbheight'] = isset($result ['img_max_thumb_height']->value) ? $result ['img_max_thumb_height']->value : $config['thumbwidth'];
    1294. 

  1294. 		// $config['hideuserprofileinfo'] = null;
    1295. 

  1295. 		// $config['integration_access'] = null;
    1296. 

  1296. 		// $config['integration_login'] = null;
    1297. 

  1297. 		// $config['integration_avatar'] = null;
    1298. 

  1298. 		// $config['integration_profile'] = null;
    1299. 

  1299. 		// $config['integration_private'] = null;
    1300. 

  1300. 		// $config['integration_activity'] = null;
    1301. 

  1301. 		// $config['boxghostmessage'] = null;
    1302. 

  1302. 		// $config['userdeletetmessage'] = null;
    1303. 

  1303. 		// $config['latestcategory_in'] = null;
    1304. 

  1304. 		// $config['topicicons'] = null;
    1305. 

  1305. 		// $config['onlineusers'] = null;
    1306. 

  1306. 		// $config['debug'] = null;
    1307. 

  1307. 		// $config['catsautosubscribed'] = null;
    1308. 

  1308. 		// $config['showbannedreason'] = null;
    1309. 

  1309. 		// $config['version_check'] = null;
    1310. 

  1310. 		// $config['showthankyou'] = null;
    1311. 

  1311. 		// $config['showpopthankyoustats'] = null;
    1312. 

  1312. 		// $config['popthankscount'] = null;
    1313. 

  1313. 		// $config['mod_see_deleted'] = null;
    1314. 

  1314. 		// $config['bbcode_img_secure'] = null;
    1315. 

  1315. 		// $config['listcat_show_moderators'] = null;
    1316. 

  1316. 		// $config['lightbox'] = null;
    1317. 

  1317. 		// $config['activity_limit'] = null;
    1318. 

  1318. 		// $config['show_list_time'] = null;
    1319. 

  1319. 		// $config['show_session_type'] = null;
    1320. 

  1320. 		// $config['show_session_starttime'] = null;
    1321. 

  1321. 		// $config['userlist_allowed'] = null;
    1322. 

  1322. 		// $config['userlist_count_users'] = null;
    1323. 

  1323. 		// $config['enable_threaded_layouts'] = null;
    1324. 

  1324. 		// $config['category_subscriptions'] = null;
    1325. 

  1325. 		// $config['topic_subscriptions'] = null;
    1326. 

  1326. 		// $config['pubprofile'] = null;
    1327. 

  1327. 		// $config['thankyou_max'] = null;
    1328. 

  1328. 		$result = array ('1' => $config );
    1329. 

  1329. 		return $result;
    1330. 

  1330. 	}
    1331. 

  1331. }
    1332. 

  1332. 

  1333. if (!function_exists('utf8_clean_string')) {
    1334. 

  1334. 	/**
    1335. 

  1335. 	* This function is used to generate a "clean" version of a string.
    1336. 

  1336. 	* Clean means that it is a case insensitive form (case folding) and that it is normalized (NFC).
    1337. 

  1337. 	* Additionally a homographs of one character are transformed into one specific character (preferably ASCII
    1338. 

  1338. 	* if it is an ASCII character).
    1339. 

  1339. 	*
    1340. 

  1340. 	* Please be aware that if you change something within this function or within
    1341. 

  1341. 	* functions used here you need to rebuild/update the username_clean column in the users table. And all other
    1342. 

  1342. 	* columns that store a clean string otherwise you will break this functionality.
    1343. 

  1343. 	*
    1344. 

  1344. 	* @param	string	$text	An unclean string, mabye user input (has to be valid UTF-8!)
    1345. 

  1345. 	* @return	string			Cleaned up version of the input string
    1346. 

  1346. 	*/
    1347. 

  1347. 	function utf8_clean_string($text)
    1348. 

  1348. 	{
    1349. 

  1349. 		global $phpbb_root_path, $phpEx;
    1350. 

  1350. 

  1351. 		static $homographs = array();
    1352. 

  1352. 		if (empty($homographs)) {
    1353. 

  1353. 			$homographs = include($phpbb_root_path . 'includes/utf/data/confusables.' . $phpEx);
    1354. 

  1354. 		}
    1355. 

  1355. 

  1356. 		$text = utf8_case_fold_nfkc($text);
    1357. 

  1357. 		$text = strtr($text, $homographs);
    1358. 

  1358. 		// Other control characters
    1359. 

  1359. 		$text = preg_replace('#(?:[\x00-\x1F\x7F]+|(?:\xC2[\x80-\x9F])+)#', '', $text);
    1360. 

  1360. 

  1361. 		// we can use trim here as all the other space characters should have been turned
    1362. 

  1362. 		// into normal ASCII spaces by now
    1363. 

  1363. 		return trim($text);
    1364. 

  1364. 	}
    1365. 

  1365. }
    1366. 

  1366. 

  1367. if (!function_exists('utf8_case_fold_nfkc')) {
    1368. 

  1368. 	/**
    1369. 

  1369. 	* Takes the input and does a "special" case fold. It does minor normalization
    1370. 

  1370. 	* and returns NFKC compatable text
    1371. 

  1371. 	*
    1372. 

  1372. 	* @param	string	$text	text to be case folded
    1373. 

  1373. 	* @param	string	$option	determines how we will fold the cases
    1374. 

  1374. 	* @return	string			case folded text
    1375. 

  1375. 	*/
    1376. 

  1376. 	function utf8_case_fold_nfkc($text, $option = 'full')
    1377. 

  1377. 	{
    1378. 

  1378. 		static $fc_nfkc_closure = array(
    1379. 

  1379. 			"\xCD\xBA"	=> "\x20\xCE\xB9",
    1380. 

  1380. 			"\xCF\x92"	=> "\xCF\x85",
    1381. 

  1381. 			"\xCF\x93"	=> "\xCF\x8D",
    1382. 

  1382. 			"\xCF\x94"	=> "\xCF\x8B",
    1383. 

  1383. 			"\xCF\xB2"	=> "\xCF\x83",
    1384. 

  1384. 			"\xCF\xB9"	=> "\xCF\x83",
    1385. 

  1385. 			"\xE1\xB4\xAC"	=> "\x61",
    1386. 

  1386. 			"\xE1\xB4\xAD"	=> "\xC3\xA6",
    1387. 

  1387. 			"\xE1\xB4\xAE"	=> "\x62",
    1388. 

  1388. 			"\xE1\xB4\xB0"	=> "\x64",
    1389. 

  1389. 			"\xE1\xB4\xB1"	=> "\x65",
    1390. 

  1390. 			"\xE1\xB4\xB2"	=> "\xC7\x9D",
    1391. 

  1391. 			"\xE1\xB4\xB3"	=> "\x67",
    1392. 

  1392. 			"\xE1\xB4\xB4"	=> "\x68",
    1393. 

  1393. 			"\xE1\xB4\xB5"	=> "\x69",
    1394. 

  1394. 			"\xE1\xB4\xB6"	=> "\x6A",
    1395. 

  1395. 			"\xE1\xB4\xB7"	=> "\x6B",
    1396. 

  1396. 			"\xE1\xB4\xB8"	=> "\x6C",
    1397. 

  1397. 			"\xE1\xB4\xB9"	=> "\x6D",
    1398. 

  1398. 			"\xE1\xB4\xBA"	=> "\x6E",
    1399. 

  1399. 			"\xE1\xB4\xBC"	=> "\x6F",
    1400. 

  1400. 			"\xE1\xB4\xBD"	=> "\xC8\xA3",
    1401. 

  1401. 			"\xE1\xB4\xBE"	=> "\x70",
    1402. 

  1402. 			"\xE1\xB4\xBF"	=> "\x72",
    1403. 

  1403. 			"\xE1\xB5\x80"	=> "\x74",
    1404. 

  1404. 			"\xE1\xB5\x81"	=> "\x75",
    1405. 

  1405. 			"\xE1\xB5\x82"	=> "\x77",
    1406. 

  1406. 			"\xE2\x82\xA8"	=> "\x72\x73",
    1407. 

  1407. 			"\xE2\x84\x82"	=> "\x63",
    1408. 

  1408. 			"\xE2\x84\x83"	=> "\xC2\xB0\x63",
    1409. 

  1409. 			"\xE2\x84\x87"	=> "\xC9\x9B",
    1410. 

  1410. 			"\xE2\x84\x89"	=> "\xC2\xB0\x66",
    1411. 

  1411. 			"\xE2\x84\x8B"	=> "\x68",
    1412. 

  1412. 			"\xE2\x84\x8C"	=> "\x68",
    1413. 

  1413. 			"\xE2\x84\x8D"	=> "\x68",
    1414. 

  1414. 			"\xE2\x84\x90"	=> "\x69",
    1415. 

  1415. 			"\xE2\x84\x91"	=> "\x69",
    1416. 

  1416. 			"\xE2\x84\x92"	=> "\x6C",
    1417. 

  1417. 			"\xE2\x84\x95"	=> "\x6E",
    1418. 

  1418. 			"\xE2\x84\x96"	=> "\x6E\x6F",
    1419. 

  1419. 			"\xE2\x84\x99"	=> "\x70",
    1420. 

  1420. 			"\xE2\x84\x9A"	=> "\x71",
    1421. 

  1421. 			"\xE2\x84\x9B"	=> "\x72",
    1422. 

  1422. 			"\xE2\x84\x9C"	=> "\x72",
    1423. 

  1423. 			"\xE2\x84\x9D"	=> "\x72",
    1424. 

  1424. 			"\xE2\x84\xA0"	=> "\x73\x6D",
    1425. 

  1425. 			"\xE2\x84\xA1"	=> "\x74\x65\x6C",
    1426. 

  1426. 			"\xE2\x84\xA2"	=> "\x74\x6D",
    1427. 

  1427. 			"\xE2\x84\xA4"	=> "\x7A",
    1428. 

  1428. 			"\xE2\x84\xA8"	=> "\x7A",
    1429. 

  1429. 			"\xE2\x84\xAC"	=> "\x62",
    1430. 

  1430. 			"\xE2\x84\xAD"	=> "\x63",
    1431. 

  1431. 			"\xE2\x84\xB0"	=> "\x65",
    1432. 

  1432. 			"\xE2\x84\xB1"	=> "\x66",
    1433. 

  1433. 			"\xE2\x84\xB3"	=> "\x6D",
    1434. 

  1434. 			"\xE2\x84\xBB"	=> "\x66\x61\x78",
    1435. 

  1435. 			"\xE2\x84\xBE"	=> "\xCE\xB3",
    1436. 

  1436. 			"\xE2\x84\xBF"	=> "\xCF\x80",
    1437. 

  1437. 			"\xE2\x85\x85"	=> "\x64",
    1438. 

  1438. 			"\xE3\x89\x90"	=> "\x70\x74\x65",
    1439. 

  1439. 			"\xE3\x8B\x8C"	=> "\x68\x67",
    1440. 

  1440. 			"\xE3\x8B\x8E"	=> "\x65\x76",
    1441. 

  1441. 			"\xE3\x8B\x8F"	=> "\x6C\x74\x64",
    1442. 

  1442. 			"\xE3\x8D\xB1"	=> "\x68\x70\x61",
    1443. 

  1443. 			"\xE3\x8D\xB3"	=> "\x61\x75",
    1444. 

  1444. 			"\xE3\x8D\xB5"	=> "\x6F\x76",
    1445. 

  1445. 			"\xE3\x8D\xBA"	=> "\x69\x75",
    1446. 

  1446. 			"\xE3\x8E\x80"	=> "\x70\x61",
    1447. 

  1447. 			"\xE3\x8E\x81"	=> "\x6E\x61",
    1448. 

  1448. 			"\xE3\x8E\x82"	=> "\xCE\xBC\x61",
    1449. 

  1449. 			"\xE3\x8E\x83"	=> "\x6D\x61",
    1450. 

  1450. 			"\xE3\x8E\x84"	=> "\x6B\x61",
    1451. 

  1451. 			"\xE3\x8E\x85"	=> "\x6B\x62",
    1452. 

  1452. 			"\xE3\x8E\x86"	=> "\x6D\x62",
    1453. 

  1453. 			"\xE3\x8E\x87"	=> "\x67\x62",
    1454. 

  1454. 			"\xE3\x8E\x8A"	=> "\x70\x66",
    1455. 

  1455. 			"\xE3\x8E\x8B"	=> "\x6E\x66",
    1456. 

  1456. 			"\xE3\x8E\x8C"	=> "\xCE\xBC\x66",
    1457. 

  1457. 			"\xE3\x8E\x90"	=> "\x68\x7A",
    1458. 

  1458. 			"\xE3\x8E\x91"	=> "\x6B\x68\x7A",
    1459. 

  1459. 			"\xE3\x8E\x92"	=> "\x6D\x68\x7A",
    1460. 

  1460. 			"\xE3\x8E\x93"	=> "\x67\x68\x7A",
    1461. 

  1461. 			"\xE3\x8E\x94"	=> "\x74\x68\x7A",
    1462. 

  1462. 			"\xE3\x8E\xA9"	=> "\x70\x61",
    1463. 

  1463. 			"\xE3\x8E\xAA"	=> "\x6B\x70\x61",
    1464. 

  1464. 			"\xE3\x8E\xAB"	=> "\x6D\x70\x61",
    1465. 

  1465. 			"\xE3\x8E\xAC"	=> "\x67\x70\x61",
    1466. 

  1466. 			"\xE3\x8E\xB4"	=> "\x70\x76",
    1467. 

  1467. 			"\xE3\x8E\xB5"	=> "\x6E\x76",
    1468. 

  1468. 			"\xE3\x8E\xB6"	=> "\xCE\xBC\x76",
    1469. 

  1469. 			"\xE3\x8E\xB7"	=> "\x6D\x76",
    1470. 

  1470. 			"\xE3\x8E\xB8"	=> "\x6B\x76",
    1471. 

  1471. 			"\xE3\x8E\xB9"	=> "\x6D\x76",
    1472. 

  1472. 			"\xE3\x8E\xBA"	=> "\x70\x77",
    1473. 

  1473. 			"\xE3\x8E\xBB"	=> "\x6E\x77",
    1474. 

  1474. 			"\xE3\x8E\xBC"	=> "\xCE\xBC\x77",
    1475. 

  1475. 			"\xE3\x8E\xBD"	=> "\x6D\x77",
    1476. 

  1476. 			"\xE3\x8E\xBE"	=> "\x6B\x77",
    1477. 

  1477. 			"\xE3\x8E\xBF"	=> "\x6D\x77",
    1478. 

  1478. 			"\xE3\x8F\x80"	=> "\x6B\xCF\x89",
    1479. 

  1479. 			"\xE3\x8F\x81"	=> "\x6D\xCF\x89",
    1480. 

  1480. 			"\xE3\x8F\x83"	=> "\x62\x71",
    1481. 

  1481. 			"\xE3\x8F\x86"	=> "\x63\xE2\x88\x95\x6B\x67",
    1482. 

  1482. 			"\xE3\x8F\x87"	=> "\x63\x6F\x2E",
    1483. 

  1483. 			"\xE3\x8F\x88"	=> "\x64\x62",
    1484. 

  1484. 			"\xE3\x8F\x89"	=> "\x67\x79",
    1485. 

  1485. 			"\xE3\x8F\x8B"	=> "\x68\x70",
    1486. 

  1486. 			"\xE3\x8F\x8D"	=> "\x6B\x6B",
    1487. 

  1487. 			"\xE3\x8F\x8E"	=> "\x6B\x6D",
    1488. 

  1488. 			"\xE3\x8F\x97"	=> "\x70\x68",
    1489. 

  1489. 			"\xE3\x8F\x99"	=> "\x70\x70\x6D",
    1490. 

  1490. 			"\xE3\x8F\x9A"	=> "\x70\x72",
    1491. 

  1491. 			"\xE3\x8F\x9C"	=> "\x73\x76",
    1492. 

  1492. 			"\xE3\x8F\x9D"	=> "\x77\x62",
    1493. 

  1493. 			"\xE3\x8F\x9E"	=> "\x76\xE2\x88\x95\x6D",
    1494. 

  1494. 			"\xE3\x8F\x9F"	=> "\x61\xE2\x88\x95\x6D",
    1495. 

  1495. 			"\xF0\x9D\x90\x80"	=> "\x61",
    1496. 

  1496. 			"\xF0\x9D\x90\x81"	=> "\x62",
    1497. 

  1497. 			"\xF0\x9D\x90\x82"	=> "\x63",
    1498. 

  1498. 			"\xF0\x9D\x90\x83"	=> "\x64",
    1499. 

  1499. 			"\xF0\x9D\x90\x84"	=> "\x65",
    1500. 

  1500. 			"\xF0\x9D\x90\x85"	=> "\x66",
    1501. 

  1501. 			"\xF0\x9D\x90\x86"	=> "\x67",
    1502. 

  1502. 			"\xF0\x9D\x90\x87"	=> "\x68",
    1503. 

  1503. 			"\xF0\x9D\x90\x88"	=> "\x69",
    1504. 

  1504. 			"\xF0\x9D\x90\x89"	=> "\x6A",
    1505. 

  1505. 			"\xF0\x9D\x90\x8A"	=> "\x6B",
    1506. 

  1506. 			"\xF0\x9D\x90\x8B"	=> "\x6C",
    1507. 

  1507. 			"\xF0\x9D\x90\x8C"	=> "\x6D",
    1508. 

  1508. 			"\xF0\x9D\x90\x8D"	=> "\x6E",
    1509. 

  1509. 			"\xF0\x9D\x90\x8E"	=> "\x6F",
    1510. 

  1510. 			"\xF0\x9D\x90\x8F"	=> "\x70",
    1511. 

  1511. 			"\xF0\x9D\x90\x90"	=> "\x71",
    1512. 

  1512. 			"\xF0\x9D\x90\x91"	=> "\x72",
    1513. 

  1513. 			"\xF0\x9D\x90\x92"	=> "\x73",
    1514. 

  1514. 			"\xF0\x9D\x90\x93"	=> "\x74",
    1515. 

  1515. 			"\xF0\x9D\x90\x94"	=> "\x75",
    1516. 

  1516. 			"\xF0\x9D\x90\x95"	=> "\x76",
    1517. 

  1517. 			"\xF0\x9D\x90\x96"	=> "\x77",
    1518. 

  1518. 			"\xF0\x9D\x90\x97"	=> "\x78",
    1519. 

  1519. 			"\xF0\x9D\x90\x98"	=> "\x79",
    1520. 

  1520. 			"\xF0\x9D\x90\x99"	=> "\x7A",
    1521. 

  1521. 			"\xF0\x9D\x90\xB4"	=> "\x61",
    1522. 

  1522. 			"\xF0\x9D\x90\xB5"	=> "\x62",
    1523. 

  1523. 			"\xF0\x9D\x90\xB6"	=> "\x63",
    1524. 

  1524. 			"\xF0\x9D\x90\xB7"	=> "\x64",
    1525. 

  1525. 			"\xF0\x9D\x90\xB8"	=> "\x65",
    1526. 

  1526. 			"\xF0\x9D\x90\xB9"	=> "\x66",
    1527. 

  1527. 			"\xF0\x9D\x90\xBA"	=> "\x67",
    1528. 

  1528. 			"\xF0\x9D\x90\xBB"	=> "\x68",
    1529. 

  1529. 			"\xF0\x9D\x90\xBC"	=> "\x69",
    1530. 

  1530. 			"\xF0\x9D\x90\xBD"	=> "\x6A",
    1531. 

  1531. 			"\xF0\x9D\x90\xBE"	=> "\x6B",
    1532. 

  1532. 			"\xF0\x9D\x90\xBF"	=> "\x6C",
    1533. 

  1533. 			"\xF0\x9D\x91\x80"	=> "\x6D",
    1534. 

  1534. 			"\xF0\x9D\x91\x81"	=> "\x6E",
    1535. 

  1535. 			"\xF0\x9D\x91\x82"	=> "\x6F",
    1536. 

  1536. 			"\xF0\x9D\x91\x83"	=> "\x70",
    1537. 

  1537. 			"\xF0\x9D\x91\x84"	=> "\x71",
    1538. 

  1538. 			"\xF0\x9D\x91\x85"	=> "\x72",
    1539. 

  1539. 			"\xF0\x9D\x91\x86"	=> "\x73",
    1540. 

  1540. 			"\xF0\x9D\x91\x87"	=> "\x74",
    1541. 

  1541. 			"\xF0\x9D\x91\x88"	=> "\x75",
    1542. 

  1542. 			"\xF0\x9D\x91\x89"	=> "\x76",
    1543. 

  1543. 			"\xF0\x9D\x91\x8A"	=> "\x77",
    1544. 

  1544. 			"\xF0\x9D\x91\x8B"	=> "\x78",
    1545. 

  1545. 			"\xF0\x9D\x91\x8C"	=> "\x79",
    1546. 

  1546. 			"\xF0\x9D\x91\x8D"	=> "\x7A",
    1547. 

  1547. 			"\xF0\x9D\x91\xA8"	=> "\x61",
    1548. 

  1548. 			"\xF0\x9D\x91\xA9"	=> "\x62",
    1549. 

  1549. 			"\xF0\x9D\x91\xAA"	=> "\x63",
    1550. 

  1550. 			"\xF0\x9D\x91\xAB"	=> "\x64",
    1551. 

  1551. 			"\xF0\x9D\x91\xAC"	=> "\x65",
    1552. 

  1552. 			"\xF0\x9D\x91\xAD"	=> "\x66",
    1553. 

  1553. 			"\xF0\x9D\x91\xAE"	=> "\x67",
    1554. 

  1554. 			"\xF0\x9D\x91\xAF"	=> "\x68",
    1555. 

  1555. 			"\xF0\x9D\x91\xB0"	=> "\x69",
    1556. 

  1556. 			"\xF0\x9D\x91\xB1"	=> "\x6A",
    1557. 

  1557. 			"\xF0\x9D\x91\xB2"	=> "\x6B",
    1558. 

  1558. 			"\xF0\x9D\x91\xB3"	=> "\x6C",
    1559. 

  1559. 			"\xF0\x9D\x91\xB4"	=> "\x6D",
    1560. 

  1560. 			"\xF0\x9D\x91\xB5"	=> "\x6E",
    1561. 

  1561. 			"\xF0\x9D\x91\xB6"	=> "\x6F",
    1562. 

  1562. 			"\xF0\x9D\x91\xB7"	=> "\x70",
    1563. 

  1563. 			"\xF0\x9D\x91\xB8"	=> "\x71",
    1564. 

  1564. 			"\xF0\x9D\x91\xB9"	=> "\x72",
    1565. 

  1565. 			"\xF0\x9D\x91\xBA"	=> "\x73",
    1566. 

  1566. 			"\xF0\x9D\x91\xBB"	=> "\x74",
    1567. 

  1567. 			"\xF0\x9D\x91\xBC"	=> "\x75",
    1568. 

  1568. 			"\xF0\x9D\x91\xBD"	=> "\x76",
    1569. 

  1569. 			"\xF0\x9D\x91\xBE"	=> "\x77",
    1570. 

  1570. 			"\xF0\x9D\x91\xBF"	=> "\x78",
    1571. 

  1571. 			"\xF0\x9D\x92\x80"	=> "\x79",
    1572. 

  1572. 			"\xF0\x9D\x92\x81"	=> "\x7A",
    1573. 

  1573. 			"\xF0\x9D\x92\x9C"	=> "\x61",
    1574. 

  1574. 			"\xF0\x9D\x92\x9E"	=> "\x63",
    1575. 

  1575. 			"\xF0\x9D\x92\x9F"	=> "\x64",
    1576. 

  1576. 			"\xF0\x9D\x92\xA2"	=> "\x67",
    1577. 

  1577. 			"\xF0\x9D\x92\xA5"	=> "\x6A",
    1578. 

  1578. 			"\xF0\x9D\x92\xA6"	=> "\x6B",
    1579. 

  1579. 			"\xF0\x9D\x92\xA9"	=> "\x6E",
    1580. 

  1580. 			"\xF0\x9D\x92\xAA"	=> "\x6F",
    1581. 

  1581. 			"\xF0\x9D\x92\xAB"	=> "\x70",
    1582. 

  1582. 			"\xF0\x9D\x92\xAC"	=> "\x71",
    1583. 

  1583. 			"\xF0\x9D\x92\xAE"	=> "\x73",
    1584. 

  1584. 			"\xF0\x9D\x92\xAF"	=> "\x74",
    1585. 

  1585. 			"\xF0\x9D\x92\xB0"	=> "\x75",
    1586. 

  1586. 			"\xF0\x9D\x92\xB1"	=> "\x76",
    1587. 

  1587. 			"\xF0\x9D\x92\xB2"	=> "\x77",
    1588. 

  1588. 			"\xF0\x9D\x92\xB3"	=> "\x78",
    1589. 

  1589. 			"\xF0\x9D\x92\xB4"	=> "\x79",
    1590. 

  1590. 			"\xF0\x9D\x92\xB5"	=> "\x7A",
    1591. 

  1591. 			"\xF0\x9D\x93\x90"	=> "\x61",
    1592. 

  1592. 			"\xF0\x9D\x93\x91"	=> "\x62",
    1593. 

  1593. 			"\xF0\x9D\x93\x92"	=> "\x63",
    1594. 

  1594. 			"\xF0\x9D\x93\x93"	=> "\x64",
    1595. 

  1595. 			"\xF0\x9D\x93\x94"	=> "\x65",
    1596. 

  1596. 			"\xF0\x9D\x93\x95"	=> "\x66",
    1597. 

  1597. 			"\xF0\x9D\x93\x96"	=> "\x67",
    1598. 

  1598. 			"\xF0\x9D\x93\x97"	=> "\x68",
    1599. 

  1599. 			"\xF0\x9D\x93\x98"	=> "\x69",
    1600. 

  1600. 			"\xF0\x9D\x93\x99"	=> "\x6A",
    1601. 

  1601. 			"\xF0\x9D\x93\x9A"	=> "\x6B",
    1602. 

  1602. 			"\xF0\x9D\x93\x9B"	=> "\x6C",
    1603. 

  1603. 			"\xF0\x9D\x93\x9C"	=> "\x6D",
    1604. 

  1604. 			"\xF0\x9D\x93\x9D"	=> "\x6E",
    1605. 

  1605. 			"\xF0\x9D\x93\x9E"	=> "\x6F",
    1606. 

  1606. 			"\xF0\x9D\x93\x9F"	=> "\x70",
    1607. 

  1607. 			"\xF0\x9D\x93\xA0"	=> "\x71",
    1608. 

  1608. 			"\xF0\x9D\x93\xA1"	=> "\x72",
    1609. 

  1609. 			"\xF0\x9D\x93\xA2"	=> "\x73",
    1610. 

  1610. 			"\xF0\x9D\x93\xA3"	=> "\x74",
    1611. 

  1611. 			"\xF0\x9D\x93\xA4"	=> "\x75",
    1612. 

  1612. 			"\xF0\x9D\x93\xA5"	=> "\x76",
    1613. 

  1613. 			"\xF0\x9D\x93\xA6"	=> "\x77",
    1614. 

  1614. 			"\xF0\x9D\x93\xA7"	=> "\x78",
    1615. 

  1615. 			"\xF0\x9D\x93\xA8"	=> "\x79",
    1616. 

  1616. 			"\xF0\x9D\x93\xA9"	=> "\x7A",
    1617. 

  1617. 			"\xF0\x9D\x94\x84"	=> "\x61",
    1618. 

  1618. 			"\xF0\x9D\x94\x85"	=> "\x62",
    1619. 

  1619. 			"\xF0\x9D\x94\x87"	=> "\x64",
    1620. 

  1620. 			"\xF0\x9D\x94\x88"	=> "\x65",
    1621. 

  1621. 			"\xF0\x9D\x94\x89"	=> "\x66",
    1622. 

  1622. 			"\xF0\x9D\x94\x8A"	=> "\x67",
    1623. 

  1623. 			"\xF0\x9D\x94\x8D"	=> "\x6A",
    1624. 

  1624. 			"\xF0\x9D\x94\x8E"	=> "\x6B",
    1625. 

  1625. 			"\xF0\x9D\x94\x8F"	=> "\x6C",
    1626. 

  1626. 			"\xF0\x9D\x94\x90"	=> "\x6D",
    1627. 

  1627. 			"\xF0\x9D\x94\x91"	=> "\x6E",
    1628. 

  1628. 			"\xF0\x9D\x94\x92"	=> "\x6F",
    1629. 

  1629. 			"\xF0\x9D\x94\x93"	=> "\x70",
    1630. 

  1630. 			"\xF0\x9D\x94\x94"	=> "\x71",
    1631. 

  1631. 			"\xF0\x9D\x94\x96"	=> "\x73",
    1632. 

  1632. 			"\xF0\x9D\x94\x97"	=> "\x74",
    1633. 

  1633. 			"\xF0\x9D\x94\x98"	=> "\x75",
    1634. 

  1634. 			"\xF0\x9D\x94\x99"	=> "\x76",
    1635. 

  1635. 			"\xF0\x9D\x94\x9A"	=> "\x77",
    1636. 

  1636. 			"\xF0\x9D\x94\x9B"	=> "\x78",
    1637. 

  1637. 			"\xF0\x9D\x94\x9C"	=> "\x79",
    1638. 

  1638. 			"\xF0\x9D\x94\xB8"	=> "\x61",
    1639. 

  1639. 			"\xF0\x9D\x94\xB9"	=> "\x62",
    1640. 

  1640. 			"\xF0\x9D\x94\xBB"	=> "\x64",
    1641. 

  1641. 			"\xF0\x9D\x94\xBC"	=> "\x65",
    1642. 

  1642. 			"\xF0\x9D\x94\xBD"	=> "\x66",
    1643. 

  1643. 			"\xF0\x9D\x94\xBE"	=> "\x67",
    1644. 

  1644. 			"\xF0\x9D\x95\x80"	=> "\x69",
    1645. 

  1645. 			"\xF0\x9D\x95\x81"	=> "\x6A",
    1646. 

  1646. 			"\xF0\x9D\x95\x82"	=> "\x6B",
    1647. 

  1647. 			"\xF0\x9D\x95\x83"	=> "\x6C",
    1648. 

  1648. 			"\xF0\x9D\x95\x84"	=> "\x6D",
    1649. 

  1649. 			"\xF0\x9D\x95\x86"	=> "\x6F",
    1650. 

  1650. 			"\xF0\x9D\x95\x8A"	=> "\x73",
    1651. 

  1651. 			"\xF0\x9D\x95\x8B"	=> "\x74",
    1652. 

  1652. 			"\xF0\x9D\x95\x8C"	=> "\x75",
    1653. 

  1653. 			"\xF0\x9D\x95\x8D"	=> "\x76",
    1654. 

  1654. 			"\xF0\x9D\x95\x8E"	=> "\x77",
    1655. 

  1655. 			"\xF0\x9D\x95\x8F"	=> "\x78",
    1656. 

  1656. 			"\xF0\x9D\x95\x90"	=> "\x79",
    1657. 

  1657. 			"\xF0\x9D\x95\xAC"	=> "\x61",
    1658. 

  1658. 			"\xF0\x9D\x95\xAD"	=> "\x62",
    1659. 

  1659. 			"\xF0\x9D\x95\xAE"	=> "\x63",
    1660. 

  1660. 			"\xF0\x9D\x95\xAF"	=> "\x64",
    1661. 

  1661. 			"\xF0\x9D\x95\xB0"	=> "\x65",
    1662. 

  1662. 			"\xF0\x9D\x95\xB1"	=> "\x66",
    1663. 

  1663. 			"\xF0\x9D\x95\xB2"	=> "\x67",
    1664. 

  1664. 			"\xF0\x9D\x95\xB3"	=> "\x68",
    1665. 

  1665. 			"\xF0\x9D\x95\xB4"	=> "\x69",
    1666. 

  1666. 			"\xF0\x9D\x95\xB5"	=> "\x6A",
    1667. 

  1667. 			"\xF0\x9D\x95\xB6"	=> "\x6B",
    1668. 

  1668. 			"\xF0\x9D\x95\xB7"	=> "\x6C",
    1669. 

  1669. 			"\xF0\x9D\x95\xB8"	=> "\x6D",
    1670. 

  1670. 			"\xF0\x9D\x95\xB9"	=> "\x6E",
    1671. 

  1671. 			"\xF0\x9D\x95\xBA"	=> "\x6F",
    1672. 

  1672. 			"\xF0\x9D\x95\xBB"	=> "\x70",
    1673. 

  1673. 			"\xF0\x9D\x95\xBC"	=> "\x71",
    1674. 

  1674. 			"\xF0\x9D\x95\xBD"	=> "\x72",
    1675. 

  1675. 			"\xF0\x9D\x95\xBE"	=> "\x73",
    1676. 

  1676. 			"\xF0\x9D\x95\xBF"	=> "\x74",
    1677. 

  1677. 			"\xF0\x9D\x96\x80"	=> "\x75",
    1678. 

  1678. 			"\xF0\x9D\x96\x81"	=> "\x76",
    1679. 

  1679. 			"\xF0\x9D\x96\x82"	=> "\x77",
    1680. 

  1680. 			"\xF0\x9D\x96\x83"	=> "\x78",
    1681. 

  1681. 			"\xF0\x9D\x96\x84"	=> "\x79",
    1682. 

  1682. 			"\xF0\x9D\x96\x85"	=> "\x7A",
    1683. 

  1683. 			"\xF0\x9D\x96\xA0"	=> "\x61",
    1684. 

  1684. 			"\xF0\x9D\x96\xA1"	=> "\x62",
    1685. 

  1685. 			"\xF0\x9D\x96\xA2"	=> "\x63",
    1686. 

  1686. 			"\xF0\x9D\x96\xA3"	=> "\x64",
    1687. 

  1687. 			"\xF0\x9D\x96\xA4"	=> "\x65",
    1688. 

  1688. 			"\xF0\x9D\x96\xA5"	=> "\x66",
    1689. 

  1689. 			"\xF0\x9D\x96\xA6"	=> "\x67",
    1690. 

  1690. 			"\xF0\x9D\x96\xA7"	=> "\x68",
    1691. 

  1691. 			"\xF0\x9D\x96\xA8"	=> "\x69",
    1692. 

  1692. 			"\xF0\x9D\x96\xA9"	=> "\x6A",
    1693. 

  1693. 			"\xF0\x9D\x96\xAA"	=> "\x6B",
    1694. 

  1694. 			"\xF0\x9D\x96\xAB"	=> "\x6C",
    1695. 

  1695. 			"\xF0\x9D\x96\xAC"	=> "\x6D",
    1696. 

  1696. 			"\xF0\x9D\x96\xAD"	=> "\x6E",
    1697. 

  1697. 			"\xF0\x9D\x96\xAE"	=> "\x6F",
    1698. 

  1698. 			"\xF0\x9D\x96\xAF"	=> "\x70",
    1699. 

  1699. 			"\xF0\x9D\x96\xB0"	=> "\x71",
    1700. 

  1700. 			"\xF0\x9D\x96\xB1"	=> "\x72",
    1701. 

  1701. 			"\xF0\x9D\x96\xB2"	=> "\x73",
    1702. 

  1702. 			"\xF0\x9D\x96\xB3"	=> "\x74",
    1703. 

  1703. 			"\xF0\x9D\x96\xB4"	=> "\x75",
    1704. 

  1704. 			"\xF0\x9D\x96\xB5"	=> "\x76",
    1705. 

  1705. 			"\xF0\x9D\x96\xB6"	=> "\x77",
    1706. 

  1706. 			"\xF0\x9D\x96\xB7"	=> "\x78",
    1707. 

  1707. 			"\xF0\x9D\x96\xB8"	=> "\x79",
    1708. 

  1708. 			"\xF0\x9D\x96\xB9"	=> "\x7A",
    1709. 

  1709. 			"\xF0\x9D\x97\x94"	=> "\x61",
    1710. 

  1710. 			"\xF0\x9D\x97\x95"	=> "\x62",
    1711. 

  1711. 			"\xF0\x9D\x97\x96"	=> "\x63",
    1712. 

  1712. 			"\xF0\x9D\x97\x97"	=> "\x64",
    1713. 

  1713. 			"\xF0\x9D\x97\x98"	=> "\x65",
    1714. 

  1714. 			"\xF0\x9D\x97\x99"	=> "\x66",
    1715. 

  1715. 			"\xF0\x9D\x97\x9A"	=> "\x67",
    1716. 

  1716. 			"\xF0\x9D\x97\x9B"	=> "\x68",
    1717. 

  1717. 			"\xF0\x9D\x97\x9C"	=> "\x69",
    1718. 

  1718. 			"\xF0\x9D\x97\x9D"	=> "\x6A",
    1719. 

  1719. 			"\xF0\x9D\x97\x9E"	=> "\x6B",
    1720. 

  1720. 			"\xF0\x9D\x97\x9F"	=> "\x6C",
    1721. 

  1721. 			"\xF0\x9D\x97\xA0"	=> "\x6D",
    1722. 

  1722. 			"\xF0\x9D\x97\xA1"	=> "\x6E",
    1723. 

  1723. 			"\xF0\x9D\x97\xA2"	=> "\x6F",
    1724. 

  1724. 			"\xF0\x9D\x97\xA3"	=> "\x70",
    1725. 

  1725. 			"\xF0\x9D\x97\xA4"	=> "\x71",
    1726. 

  1726. 			"\xF0\x9D\x97\xA5"	=> "\x72",
    1727. 

  1727. 			"\xF0\x9D\x97\xA6"	=> "\x73",
    1728. 

  1728. 			"\xF0\x9D\x97\xA7"	=> "\x74",
    1729. 

  1729. 			"\xF0\x9D\x97\xA8"	=> "\x75",
    1730. 

  1730. 			"\xF0\x9D\x97\xA9"	=> "\x76",
    1731. 

  1731. 			"\xF0\x9D\x97\xAA"	=> "\x77",
    1732. 

  1732. 			"\xF0\x9D\x97\xAB"	=> "\x78",
    1733. 

  1733. 			"\xF0\x9D\x97\xAC"	=> "\x79",
    1734. 

  1734. 			"\xF0\x9D\x97\xAD"	=> "\x7A",
    1735. 

  1735. 			"\xF0\x9D\x98\x88"	=> "\x61",
    1736. 

  1736. 			"\xF0\x9D\x98\x89"	=> "\x62",
    1737. 

  1737. 			"\xF0\x9D\x98\x8A"	=> "\x63",
    1738. 

  1738. 			"\xF0\x9D\x98\x8B"	=> "\x64",
    1739. 

  1739. 			"\xF0\x9D\x98\x8C"	=> "\x65",
    1740. 

  1740. 			"\xF0\x9D\x98\x8D"	=> "\x66",
    1741. 

  1741. 			"\xF0\x9D\x98\x8E"	=> "\x67",
    1742. 

  1742. 			"\xF0\x9D\x98\x8F"	=> "\x68",
    1743. 

  1743. 			"\xF0\x9D\x98\x90"	=> "\x69",
    1744. 

  1744. 			"\xF0\x9D\x98\x91"	=> "\x6A",
    1745. 

  1745. 			"\xF0\x9D\x98\x92"	=> "\x6B",
    1746. 

  1746. 			"\xF0\x9D\x98\x93"	=> "\x6C",
    1747. 

  1747. 			"\xF0\x9D\x98\x94"	=> "\x6D",
    1748. 

  1748. 			"\xF0\x9D\x98\x95"	=> "\x6E",
    1749. 

  1749. 			"\xF0\x9D\x98\x96"	=> "\x6F",
    1750. 

  1750. 			"\xF0\x9D\x98\x97"	=> "\x70",
    1751. 

  1751. 			"\xF0\x9D\x98\x98"	=> "\x71",
    1752. 

  1752. 			"\xF0\x9D\x98\x99"	=> "\x72",
    1753. 

  1753. 			"\xF0\x9D\x98\x9A"	=> "\x73",
    1754. 

  1754. 			"\xF0\x9D\x98\x9B"	=> "\x74",
    1755. 

  1755. 			"\xF0\x9D\x98\x9C"	=> "\x75",
    1756. 

  1756. 			"\xF0\x9D\x98\x9D"	=> "\x76",
    1757. 

  1757. 			"\xF0\x9D\x98\x9E"	=> "\x77",
    1758. 

  1758. 			"\xF0\x9D\x98\x9F"	=> "\x78",
    1759. 

  1759. 			"\xF0\x9D\x98\xA0"	=> "\x79",
    1760. 

  1760. 			"\xF0\x9D\x98\xA1"	=> "\x7A",
    1761. 

  1761. 			"\xF0\x9D\x98\xBC"	=> "\x61",
    1762. 

  1762. 			"\xF0\x9D\x98\xBD"	=> "\x62",
    1763. 

  1763. 			"\xF0\x9D\x98\xBE"	=> "\x63",
    1764. 

  1764. 			"\xF0\x9D\x98\xBF"	=> "\x64",
    1765. 

  1765. 			"\xF0\x9D\x99\x80"	=> "\x65",
    1766. 

  1766. 			"\xF0\x9D\x99\x81"	=> "\x66",
    1767. 

  1767. 			"\xF0\x9D\x99\x82"	=> "\x67",
    1768. 

  1768. 			"\xF0\x9D\x99\x83"	=> "\x68",
    1769. 

  1769. 			"\xF0\x9D\x99\x84"	=> "\x69",
    1770. 

  1770. 			"\xF0\x9D\x99\x85"	=> "\x6A",
    1771. 

  1771. 			"\xF0\x9D\x99\x86"	=> "\x6B",
    1772. 

  1772. 			"\xF0\x9D\x99\x87"	=> "\x6C",
    1773. 

  1773. 			"\xF0\x9D\x99\x88"	=> "\x6D",
    1774. 

  1774. 			"\xF0\x9D\x99\x89"	=> "\x6E",
    1775. 

  1775. 			"\xF0\x9D\x99\x8A"	=> "\x6F",
    1776. 

  1776. 			"\xF0\x9D\x99\x8B"	=> "\x70",
    1777. 

  1777. 			"\xF0\x9D\x99\x8C"	=> "\x71",
    1778. 

  1778. 			"\xF0\x9D\x99\x8D"	=> "\x72",
    1779. 

  1779. 			"\xF0\x9D\x99\x8E"	=> "\x73",
    1780. 

  1780. 			"\xF0\x9D\x99\x8F"	=> "\x74",
    1781. 

  1781. 			"\xF0\x9D\x99\x90"	=> "\x75",
    1782. 

  1782. 			"\xF0\x9D\x99\x91"	=> "\x76",
    1783. 

  1783. 			"\xF0\x9D\x99\x92"	=> "\x77",
    1784. 

  1784. 			"\xF0\x9D\x99\x93"	=> "\x78",
    1785. 

  1785. 			"\xF0\x9D\x99\x94"	=> "\x79",
    1786. 

  1786. 			"\xF0\x9D\x99\x95"	=> "\x7A",
    1787. 

  1787. 			"\xF0\x9D\x99\xB0"	=> "\x61",
    1788. 

  1788. 			"\xF0\x9D\x99\xB1"	=> "\x62",
    1789. 

  1789. 			"\xF0\x9D\x99\xB2"	=> "\x63",
    1790. 

  1790. 			"\xF0\x9D\x99\xB3"	=> "\x64",
    1791. 

  1791. 			"\xF0\x9D\x99\xB4"	=> "\x65",
    1792. 

  1792. 			"\xF0\x9D\x99\xB5"	=> "\x66",
    1793. 

  1793. 			"\xF0\x9D\x99\xB6"	=> "\x67",
    1794. 

  1794. 			"\xF0\x9D\x99\xB7"	=> "\x68",
    1795. 

  1795. 			"\xF0\x9D\x99\xB8"	=> "\x69",
    1796. 

  1796. 			"\xF0\x9D\x99\xB9"	=> "\x6A",
    1797. 

  1797. 			"\xF0\x9D\x99\xBA"	=> "\x6B",
    1798. 

  1798. 			"\xF0\x9D\x99\xBB"	=> "\x6C",
    1799. 

  1799. 			"\xF0\x9D\x99\xBC"	=> "\x6D",
    1800. 

  1800. 			"\xF0\x9D\x99\xBD"	=> "\x6E",
    1801. 

  1801. 			"\xF0\x9D\x99\xBE"	=> "\x6F",
    1802. 

  1802. 			"\xF0\x9D\x99\xBF"	=> "\x70",
    1803. 

  1803. 			"\xF0\x9D\x9A\x80"	=> "\x71",
    1804. 

  1804. 			"\xF0\x9D\x9A\x81"	=> "\x72",
    1805. 

  1805. 			"\xF0\x9D\x9A\x82"	=> "\x73",
    1806. 

  1806. 			"\xF0\x9D\x9A\x83"	=> "\x74",
    1807. 

  1807. 			"\xF0\x9D\x9A\x84"	=> "\x75",
    1808. 

  1808. 			"\xF0\x9D\x9A\x85"	=> "\x76",
    1809. 

  1809. 			"\xF0\x9D\x9A\x86"	=> "\x77",
    1810. 

  1810. 			"\xF0\x9D\x9A\x87"	=> "\x78",
    1811. 

  1811. 			"\xF0\x9D\x9A\x88"	=> "\x79",
    1812. 

  1812. 			"\xF0\x9D\x9A\x89"	=> "\x7A",
    1813. 

  1813. 			"\xF0\x9D\x9A\xA8"	=> "\xCE\xB1",
    1814. 

  1814. 			"\xF0\x9D\x9A\xA9"	=> "\xCE\xB2",
    1815. 

  1815. 			"\xF0\x9D\x9A\xAA"	=> "\xCE\xB3",
    1816. 

  1816. 			"\xF0\x9D\x9A\xAB"	=> "\xCE\xB4",
    1817. 

  1817. 			"\xF0\x9D\x9A\xAC"	=> "\xCE\xB5",
    1818. 

  1818. 			"\xF0\x9D\x9A\xAD"	=> "\xCE\xB6",
    1819. 

  1819. 			"\xF0\x9D\x9A\xAE"	=> "\xCE\xB7",
    1820. 

  1820. 			"\xF0\x9D\x9A\xAF"	=> "\xCE\xB8",
    1821. 

  1821. 			"\xF0\x9D\x9A\xB0"	=> "\xCE\xB9",
    1822. 

  1822. 			"\xF0\x9D\x9A\xB1"	=> "\xCE\xBA",
    1823. 

  1823. 			"\xF0\x9D\x9A\xB2"	=> "\xCE\xBB",
    1824. 

  1824. 			"\xF0\x9D\x9A\xB3"	=> "\xCE\xBC",
    1825. 

  1825. 			"\xF0\x9D\x9A\xB4"	=> "\xCE\xBD",
    1826. 

  1826. 			"\xF0\x9D\x9A\xB5"	=> "\xCE\xBE",
    1827. 

  1827. 			"\xF0\x9D\x9A\xB6"	=> "\xCE\xBF",
    1828. 

  1828. 			"\xF0\x9D\x9A\xB7"	=> "\xCF\x80",
    1829. 

  1829. 			"\xF0\x9D\x9A\xB8"	=> "\xCF\x81",
    1830. 

  1830. 			"\xF0\x9D\x9A\xB9"	=> "\xCE\xB8",
    1831. 

  1831. 			"\xF0\x9D\x9A\xBA"	=> "\xCF\x83",
    1832. 

  1832. 			"\xF0\x9D\x9A\xBB"	=> "\xCF\x84",
    1833. 

  1833. 			"\xF0\x9D\x9A\xBC"	=> "\xCF\x85",
    1834. 

  1834. 			"\xF0\x9D\x9A\xBD"	=> "\xCF\x86",
    1835. 

  1835. 			"\xF0\x9D\x9A\xBE"	=> "\xCF\x87",
    1836. 

  1836. 			"\xF0\x9D\x9A\xBF"	=> "\xCF\x88",
    1837. 

  1837. 			"\xF0\x9D\x9B\x80"	=> "\xCF\x89",
    1838. 

  1838. 			"\xF0\x9D\x9B\x93"	=> "\xCF\x83",
    1839. 

  1839. 			"\xF0\x9D\x9B\xA2"	=> "\xCE\xB1",
    1840. 

  1840. 			"\xF0\x9D\x9B\xA3"	=> "\xCE\xB2",
    1841. 

  1841. 			"\xF0\x9D\x9B\xA4"	=> "\xCE\xB3",
    1842. 

  1842. 			"\xF0\x9D\x9B\xA5"	=> "\xCE\xB4",
    1843. 

  1843. 			"\xF0\x9D\x9B\xA6"	=> "\xCE\xB5",
    1844. 

  1844. 			"\xF0\x9D\x9B\xA7"	=> "\xCE\xB6",
    1845. 

  1845. 			"\xF0\x9D\x9B\xA8"	=> "\xCE\xB7",
    1846. 

  1846. 			"\xF0\x9D\x9B\xA9"	=> "\xCE\xB8",
    1847. 

  1847. 			"\xF0\x9D\x9B\xAA"	=> "\xCE\xB9",
    1848. 

  1848. 			"\xF0\x9D\x9B\xAB"	=> "\xCE\xBA",
    1849. 

  1849. 			"\xF0\x9D\x9B\xAC"	=> "\xCE\xBB",
    1850. 

  1850. 			"\xF0\x9D\x9B\xAD"	=> "\xCE\xBC",
    1851. 

  1851. 			"\xF0\x9D\x9B\xAE"	=> "\xCE\xBD",
    1852. 

  1852. 			"\xF0\x9D\x9B\xAF"	=> "\xCE\xBE",
    1853. 

  1853. 			"\xF0\x9D\x9B\xB0"	=> "\xCE\xBF",
    1854. 

  1854. 			"\xF0\x9D\x9B\xB1"	=> "\xCF\x80",
    1855. 

  1855. 			"\xF0\x9D\x9B\xB2"	=> "\xCF\x81",
    1856. 

  1856. 			"\xF0\x9D\x9B\xB3"	=> "\xCE\xB8",
    1857. 

  1857. 			"\xF0\x9D\x9B\xB4"	=> "\xCF\x83",
    1858. 

  1858. 			"\xF0\x9D\x9B\xB5"	=> "\xCF\x84",
    1859. 

  1859. 			"\xF0\x9D\x9B\xB6"	=> "\xCF\x85",
    1860. 

  1860. 			"\xF0\x9D\x9B\xB7"	=> "\xCF\x86",
    1861. 

  1861. 			"\xF0\x9D\x9B\xB8"	=> "\xCF\x87",
    1862. 

  1862. 			"\xF0\x9D\x9B\xB9"	=> "\xCF\x88",
    1863. 

  1863. 			"\xF0\x9D\x9B\xBA"	=> "\xCF\x89",
    1864. 

  1864. 			"\xF0\x9D\x9C\x8D"	=> "\xCF\x83",
    1865. 

  1865. 			"\xF0\x9D\x9C\x9C"	=> "\xCE\xB1",
    1866. 

  1866. 			"\xF0\x9D\x9C\x9D"	=> "\xCE\xB2",
    1867. 

  1867. 			"\xF0\x9D\x9C\x9E"	=> "\xCE\xB3",
    1868. 

  1868. 			"\xF0\x9D\x9C\x9F"	=> "\xCE\xB4",
    1869. 

  1869. 			"\xF0\x9D\x9C\xA0"	=> "\xCE\xB5",
    1870. 

  1870. 			"\xF0\x9D\x9C\xA1"	=> "\xCE\xB6",
    1871. 

  1871. 			"\xF0\x9D\x9C\xA2"	=> "\xCE\xB7",
    1872. 

  1872. 			"\xF0\x9D\x9C\xA3"	=> "\xCE\xB8",
    1873. 

  1873. 			"\xF0\x9D\x9C\xA4"	=> "\xCE\xB9",
    1874. 

  1874. 			"\xF0\x9D\x9C\xA5"	=> "\xCE\xBA",
    1875. 

  1875. 			"\xF0\x9D\x9C\xA6"	=> "\xCE\xBB",
    1876. 

  1876. 			"\xF0\x9D\x9C\xA7"	=> "\xCE\xBC",
    1877. 

  1877. 			"\xF0\x9D\x9C\xA8"	=> "\xCE\xBD",
    1878. 

  1878. 			"\xF0\x9D\x9C\xA9"	=> "\xCE\xBE",
    1879. 

  1879. 			"\xF0\x9D\x9C\xAA"	=> "\xCE\xBF",
    1880. 

  1880. 			"\xF0\x9D\x9C\xAB"	=> "\xCF\x80",
    1881. 

  1881. 			"\xF0\x9D\x9C\xAC"	=> "\xCF\x81",
    1882. 

  1882. 			"\xF0\x9D\x9C\xAD"	=> "\xCE\xB8",
    1883. 

  1883. 			"\xF0\x9D\x9C\xAE"	=> "\xCF\x83",
    1884. 

  1884. 			"\xF0\x9D\x9C\xAF"	=> "\xCF\x84",
    1885. 

  1885. 			"\xF0\x9D\x9C\xB0"	=> "\xCF\x85",
    1886. 

  1886. 			"\xF0\x9D\x9C\xB1"	=> "\xCF\x86",
    1887. 

  1887. 			"\xF0\x9D\x9C\xB2"	=> "\xCF\x87",
    1888. 

  1888. 			"\xF0\x9D\x9C\xB3"	=> "\xCF\x88",
    1889. 

  1889. 			"\xF0\x9D\x9C\xB4"	=> "\xCF\x89",
    1890. 

  1890. 			"\xF0\x9D\x9D\x87"	=> "\xCF\x83",
    1891. 

  1891. 			"\xF0\x9D\x9D\x96"	=> "\xCE\xB1",
    1892. 

  1892. 			"\xF0\x9D\x9D\x97"	=> "\xCE\xB2",
    1893. 

  1893. 			"\xF0\x9D\x9D\x98"	=> "\xCE\xB3",
    1894. 

  1894. 			"\xF0\x9D\x9D\x99"	=> "\xCE\xB4",
    1895. 

  1895. 			"\xF0\x9D\x9D\x9A"	=> "\xCE\xB5",
    1896. 

  1896. 			"\xF0\x9D\x9D\x9B"	=> "\xCE\xB6",
    1897. 

  1897. 			"\xF0\x9D\x9D\x9C"	=> "\xCE\xB7",
    1898. 

  1898. 			"\xF0\x9D\x9D\x9D"	=> "\xCE\xB8",
    1899. 

  1899. 			"\xF0\x9D\x9D\x9E"	=> "\xCE\xB9",
    1900. 

  1900. 			"\xF0\x9D\x9D\x9F"	=> "\xCE\xBA",
    1901. 

  1901. 			"\xF0\x9D\x9D\xA0"	=> "\xCE\xBB",
    1902. 

  1902. 			"\xF0\x9D\x9D\xA1"	=> "\xCE\xBC",
    1903. 

  1903. 			"\xF0\x9D\x9D\xA2"	=> "\xCE\xBD",
    1904. 

  1904. 			"\xF0\x9D\x9D\xA3"	=> "\xCE\xBE",
    1905. 

  1905. 			"\xF0\x9D\x9D\xA4"	=> "\xCE\xBF",
    1906. 

  1906. 			"\xF0\x9D\x9D\xA5"	=> "\xCF\x80",
    1907. 

  1907. 			"\xF0\x9D\x9D\xA6"	=> "\xCF\x81",
    1908. 

  1908. 			"\xF0\x9D\x9D\xA7"	=> "\xCE\xB8",
    1909. 

  1909. 			"\xF0\x9D\x9D\xA8"	=> "\xCF\x83",
    1910. 

  1910. 			"\xF0\x9D\x9D\xA9"	=> "\xCF\x84",
    1911. 

  1911. 			"\xF0\x9D\x9D\xAA"	=> "\xCF\x85",
    1912. 

  1912. 			"\xF0\x9D\x9D\xAB"	=> "\xCF\x86",
    1913. 

  1913. 			"\xF0\x9D\x9D\xAC"	=> "\xCF\x87",
    1914. 

  1914. 			"\xF0\x9D\x9D\xAD"	=> "\xCF\x88",
    1915. 

  1915. 			"\xF0\x9D\x9D\xAE"	=> "\xCF\x89",
    1916. 

  1916. 			"\xF0\x9D\x9E\x81"	=> "\xCF\x83",
    1917. 

  1917. 			"\xF0\x9D\x9E\x90"	=> "\xCE\xB1",
    1918. 

  1918. 			"\xF0\x9D\x9E\x91"	=> "\xCE\xB2",
    1919. 

  1919. 			"\xF0\x9D\x9E\x92"	=> "\xCE\xB3",
    1920. 

  1920. 			"\xF0\x9D\x9E\x93"	=> "\xCE\xB4",
    1921. 

  1921. 			"\xF0\x9D\x9E\x94"	=> "\xCE\xB5",
    1922. 

  1922. 			"\xF0\x9D\x9E\x95"	=> "\xCE\xB6",
    1923. 

  1923. 			"\xF0\x9D\x9E\x96"	=> "\xCE\xB7",
    1924. 

  1924. 			"\xF0\x9D\x9E\x97"	=> "\xCE\xB8",
    1925. 

  1925. 			"\xF0\x9D\x9E\x98"	=> "\xCE\xB9",
    1926. 

  1926. 			"\xF0\x9D\x9E\x99"	=> "\xCE\xBA",
    1927. 

  1927. 			"\xF0\x9D\x9E\x9A"	=> "\xCE\xBB",
    1928. 

  1928. 			"\xF0\x9D\x9E\x9B"	=> "\xCE\xBC",
    1929. 

  1929. 			"\xF0\x9D\x9E\x9C"	=> "\xCE\xBD",
    1930. 

  1930. 			"\xF0\x9D\x9E\x9D"	=> "\xCE\xBE",
    1931. 

  1931. 			"\xF0\x9D\x9E\x9E"	=> "\xCE\xBF",
    1932. 

  1932. 			"\xF0\x9D\x9E\x9F"	=> "\xCF\x80",
    1933. 

  1933. 			"\xF0\x9D\x9E\xA0"	=> "\xCF\x81",
    1934. 

  1934. 			"\xF0\x9D\x9E\xA1"	=> "\xCE\xB8",
    1935. 

  1935. 			"\xF0\x9D\x9E\xA2"	=> "\xCF\x83",
    1936. 

  1936. 			"\xF0\x9D\x9E\xA3"	=> "\xCF\x84",
    1937. 

  1937. 			"\xF0\x9D\x9E\xA4"	=> "\xCF\x85",
    1938. 

  1938. 			"\xF0\x9D\x9E\xA5"	=> "\xCF\x86",
    1939. 

  1939. 			"\xF0\x9D\x9E\xA6"	=> "\xCF\x87",
    1940. 

  1940. 			"\xF0\x9D\x9E\xA7"	=> "\xCF\x88",
    1941. 

  1941. 			"\xF0\x9D\x9E\xA8"	=> "\xCF\x89",
    1942. 

  1942. 			"\xF0\x9D\x9E\xBB"	=> "\xCF\x83",
    1943. 

  1943. 			"\xF0\x9D\x9F\x8A"	=> "\xCF\x9D",
    1944. 

  1944. 		);
    1945. 

  1945. 		global $phpbb_root_path, $phpEx;
    1946. 

  1946. 

  1947. 		// do the case fold
    1948. 

  1948. 		$text = utf8_case_fold($text, $option);
    1949. 

  1949. 

  1950. 		if (!class_exists('utf_normalizer')) {
    1951. 

  1951. 			global $phpbb_root_path, $phpEx;
    1952. 

  1952. 			include($phpbb_root_path . 'includes/utf/utf_normalizer.' . $phpEx);
    1953. 

  1953. 		}
    1954. 

  1954. 

  1955. 		// convert to NFKC
    1956. 

  1956. 		utf_normalizer::nfkc($text);
    1957. 

  1957. 

  1958. 		// FC_NFKC_Closure, http://www.unicode.org/Public/5.0.0/ucd/DerivedNormalizationProps.txt
    1959. 

  1959. 		$text = strtr($text, $fc_nfkc_closure);
    1960. 

  1960. 

  1961. 		return $text;
    1962. 

  1962. 	}
    1963. 

  1963. }
    1964. 

  1964. 

  1965. if (!function_exists('utf8_case_fold')) {
    1966. 

  1966. 	/**
    1967. 

  1967. 	* Case folds a unicode string as per Unicode 5.0, section 3.13
    1968. 

  1968. 	*
    1969. 

  1969. 	* @param	string	$text	text to be case folded
    1970. 

  1970. 	* @param	string	$option	determines how we will fold the cases
    1971. 

  1971. 	* @return	string			case folded text
    1972. 

  1972. 	*/
    1973. 

  1973. 	function utf8_case_fold($text, $option = 'full')
    1974. 

  1974. 	{
    1975. 

  1975. 		static $uniarray = array();
    1976. 

  1976. 		global $phpbb_root_path, $phpEx;
    1977. 

  1977. 

  1978. 		// common is always set
    1979. 

  1979. 		if (!isset($uniarray['c'])) {
    1980. 

  1980. 			$uniarray['c'] = include($phpbb_root_path . 'includes/utf/data/case_fold_c.' . $phpEx);
    1981. 

  1981. 		}
    1982. 

  1982. 

  1983. 		// only set full if we need to
    1984. 

  1984. 		if ($option === 'full' && !isset($uniarray['f'])) {
    1985. 

  1985. 			$uniarray['f'] = include($phpbb_root_path . 'includes/utf/data/case_fold_f.' . $phpEx);
    1986. 

  1986. 		}
    1987. 

  1987. 

  1988. 		// only set simple if we need to
    1989. 

  1989. 		if ($option !== 'full' && !isset($uniarray['s'])) {
    1990. 

  1990. 			$uniarray['s'] = include($phpbb_root_path . 'includes/utf/data/case_fold_s.' . $phpEx);
    1991. 

  1991. 		}
    1992. 

  1992. 

  1993. 		// common is always replaced
    1994. 

  1994. 		$text = strtr($text, $uniarray['c']);
    1995. 

  1995. 

  1996. 		if ($option === 'full') {
    1997. 

  1997. 			// full replaces a character with multiple characters
    1998. 

  1998. 			$text = strtr($text, $uniarray['f']);
    1999. 

  1999. 		} else {
    2000. 

  2000. 			// simple replaces a character with another character
    2001. 

  2001. 			$text = strtr($text, $uniarray['s']);
    2002. 

  2002. 		}
    2003. 

  2003. 

  2004. 		return $text;
    2005. 

  2005. 	}
    2006. 

  2006. }
    2007. 

  2007.