PageRenderTime 28ms CodeModel.GetById 20ms RepoModel.GetById 1ms app.codeStats 0ms

/core/gw_includes/core_engine_utils.php

http://glossword.googlecode.com/
PHP | 938 lines | 647 code | 109 blank | 182 comment | 65 complexity | 74072910702ceec179c231714ee52732 MD5 | raw file
    

  1. <?php

    2. 

  2. /**

    3. 

  3.  * @version		$Id$

    4. 

  4.  * @package		Glossword 1.9

    5. 

  5.  * @copyright	Š Dmitry N. Shilnikov, 2002-2010

    6. 

  6.  * @license		GNU/GPL, see http://code.google.com/p/glossword/

    7. 

  7.  */

    8. 

  8. if (!defined('IS_CLASS_GW_UTILS')) { define('IS_CLASS_GW_UTILS', 1);

    9. 

  9. class site_engine_utils extends site_engine {

    10. 

  10. 

    11. 

  11. 	public $rm_specials_patterns, $uri_patterns, $az_order_patterns;

    12. 

  12. 

    13. 

  13. 

    14. 

  14. 	/* Returns HTML-code for a search form (web) */

    15. 

  15. 	public function get_search_form()

    16. 

  16. 	{

    17. 

  17. 		$s = '';

    18. 

  18. 		/* */

    19. 

  19. 		$s .= '<form action="'. $this->V->server_dir.'/'.$this->V->file_index.'" enctype="application/x-www-form-urlencoded" accept-charset="utf-8" method="post">';

    20. 

  20. 		$s .= '<div class="gw-search-form">';

    21. 

  21. 		$s .= '<input style="width:10em" type="text" name="searchword" value="" />';

    22. 

  22. 		/* Trick for Router */

    23. 

  23. 		$s .= '<select name="areas[0]">';

    24. 

  24. 		$s .= '<option value="term" selected="selected">in terms</option>';

    25. 

  25. 		$s .= '<option value="defn">in definitions</option>';

    26. 

  26. 		$s .= '</select>';

    27. 

  27. 		$s .= '<input style="cursor:pointer" type="submit" value="'. $this->oTkit->_( 1175 ). '" />';

    28. 

  28. 		$s .= '<input name="option" value="com_search" type="hidden" />';

    29. 

  29. 		$s .= '<input name="task" value="search" type="hidden" />';

    30. 

  30. 		$s .= '<input name="areas[]" value="gw_search" type="hidden" />';

    31. 

  31. 		$s .= '</form></div>';

    32. 

  32. 		

    33. 

  33. 		return $s;

    34. 

  34. 	}

    35. 

  35. 	/* Counts the number of words, approximately */

    36. 

  36. 	public function count_words( $s )

    37. 

  37. 	{

    38. 

  38. 		if ( $s == '' ) { return 0; }

    39. 

  39. 		return sizeof( explode( ' ', $s ) );

    40. 

  40. 	}

    41. 

  41. 

    42. 

  42. 	/* */

    43. 

  43. 	public function items__filter( $s )

    44. 

  44. 	{

    45. 

  45. 		$s = $this->rm_specials( $s );

    46. 

  46. 		$s = $this->str_normalize( $s );

    47. 

  47. 		return $s;

    48. 

  48. 	}

    49. 

  49. 

    50. 

  50. 	/* */

    51. 

  51. 	public function get_az_order( $id_lang )

    52. 

  52. 	{

    53. 

  53. 		$this->oDb->select( 'uc, lc');

    54. 

  54. 		$this->oDb->from( array( 'az_letters az' ) );

    55. 

  55. 		$this->oDb->where( array( 'az.id_lang' => $id_lang ) );

    56. 

  56. 		$this->oDb->order_by( 'az.int_sort' );

    57. 

  57. 		$ar_sql = $this->oDb->get()->result_array();

    58. 

  58. 		$ar = array();

    59. 

  59. 		foreach ($ar_sql as $ar_v )

    60. 

  60. 		{

    61. 

  61. 			$ar[urldecode( $ar_v['lc'] )] = urldecode( $ar_v['uc'] );

    62. 

  62. 		}

    63. 

  63. 		return $ar;

    64. 

  64. 	}

    65. 

  65. 		

    66. 

  66. 	/* Unicode normalization. Used for Search Index and Alphabetic Order */

    67. 

  67. 	public function str_normalize( $s )

    68. 

  68. 	{

    69. 

  69. 		$s = $this->oCase->lc( $s );

    70. 

  70. 		

    71. 

  71. 		/* Use PECL extension */

    72. 

  72. 		if ( class_exists( 'Normalizer' ) )

    73. 

  73. 		{

    74. 

  74. 			return Normalizer::normalize( $s, Normalizer::FORM_C );

    75. 

  75. 		}

    76. 

  76. 		/* */

    77. 

  77. 		preg_match_all( "/./u", $s, $ar );

    78. 

  78. 		$ar = $ar[0];

    79. 

  79. 		$ar_c_crc = array();

    80. 

  80. 		/* For each character */

    81. 

  81. 		foreach ($ar AS $k => &$v )

    82. 

  82. 		{

    83. 

  83. 			/* Use values as key */

    84. 

  84. 			/* PHP-bug: sometimes a string keys becomes interger */

    85. 

  85. 			$ar_c_crc[$v] = sprintf( "%u", crc32( $v ) );

    86. 

  86. 		}

    87. 

  87. 		unset( $v );

    88. 

  88. 		if ( empty( $ar_c_crc ) ){ return $s; }

    89. 

  89. 		/* */

    90. 

  90. 		$is_debug_q = $this->oDb->is_debug_q;

    91. 

  91. 		$this->oDb->is_debug_q = false;

    92. 

  92. 		$this->oDb->select( 'str_from, str_to' );

    93. 

  93. 		$this->oDb->from( 'unicode_normalization' );

    94. 

  94. 		$this->oDb->where_in( 'crc32u', array_values( $ar_c_crc ) );

    95. 

  95. 		$ar_sql = $this->oDb->get()->result_array();

    96. 

  96. 		$this->oDb->is_debug_q = $is_debug_q;

    97. 

  97. 		/* Normalize text */

    98. 

  98. 		foreach ($ar_sql AS $k => &$v )

    99. 

  99. 		{

    100. 

  100. 			$s = str_replace( urldecode( $v['str_from'] ), urldecode( $v['str_to'] ), $s );

    101. 

  101. 			unset( $ar_sql[$k] );

    102. 

  102. 		}

    103. 

  103. 		unset( $v );

    104. 

  104. 

    105. 

  105. 		return $s;

    106. 

  106. 	}

    107. 

  107. 

    108. 

  108. 

    109. 

  109. 	/* Normalized value, Source value, Language ID */

    110. 

  110. 	public function get_az_index( $s, $s_src, $id_lang )

    111. 

  111. 	{

    112. 

  112. 		if ( !isset( $this->az_order_patterns[$id_lang] ) )

    113. 

  113. 		{

    114. 

  114. 			$this->az_order_patterns[$id_lang] = $this->get_az_order( $id_lang );

    115. 

  115. 		}

    116. 

  116. 		

    117. 

  117. 		$ar_q = array();

    118. 

  118. 		$ar_q['_si'] = $s; /* Temporary, used for Search Index */

    119. 

  119. 		

    120. 

  120. 		/** Prepare Sorting Order **/

    121. 

  121. 		$s_src = $this->oCase->lc( $s_src );

    122. 

  122. 		$s_src = trim( strip_tags( $s_src ) );

    123. 

  123. 		$s_src = $this->oFunc->mb_substr( $s_src, 0, 16 );

    124. 

  124. 		$str_az_order = str_replace( 

    125. 

  125. 			array_keys( $this->az_order_patterns[$id_lang] ), 

    126. 

  126. 			array_values( $this->az_order_patterns[$id_lang] ), 

    127. 

  127. 			$s_src

    128. 

  128. 		);

    129. 

  129. 		$str_az_order = $this->oCase->uc( $str_az_order );

    130. 

  130. 		preg_match_all( "/./u", $str_az_order, $ar );

    131. 

  131. 		for ( $i = 1; $i <= 8; $i++ )

    132. 

  132. 		{

    133. 

  133. 			$ar_q['contents_'.$i] = isset( $ar[0][$i-1] ) ? sprintf( "%u", crc32( $ar[0][$i-1] ) ) : 0;

    134. 

  134. 		}

    135. 

  135. 		$ar_q['contents_so'] = $str_az_order;

    136. 

  136. 

    137. 

  137. 		/** Prepare Alphabetic Order **/

    138. 

  138. 		$ar_q['contents_a'] = isset( $ar[0][0] ) ? $ar[0][0] : '';

    139. 

  139. 		$ar_q['contents_b'] = isset( $ar[0][1] ) ? $ar[0][1] : '';

    140. 

  140. 		#$s = $this->oCase->uc( trim( $s ) );

    141. 

  141. 		#$ar_q['contents_a'] = $this->oFunc->mb_substr( $s, 0, 1 );

    142. 

  142. 		#$ar_q['contents_b'] = $this->oFunc->mb_substr( $s, 1, 1 );

    143. 

  143. 		

    144. 

  144. 		/* String is empty or consists of special characters only */

    145. 

  145. 		if ( $ar_q['contents_a'] == '' ){ $ar_q['contents_a'] = '#'; }

    146. 

  146. 		

    147. 

  147. 		/* */

    148. 

  148. 		#$ar_q['contents_1'] = sprintf( "%u", crc32( $ar_q['contents_a'] ) );

    149. 

  149. 

    150. 

  150. #prn_r( $ar_q );

    151. 

  151. #exit;

    152. 

  152. 		return $ar_q;

    153. 

  153. 	}

    154. 

  154. 

    155. 

  155. 

    156. 

  156. 	/* Removes a special characters !#$%... 264 symbols */

    157. 

  157. 	public function rm_specials( $s, $newchar = ' ' )

    158. 

  158. 	{

    159. 

  159. 		/* Always remove `.` */

    160. 

  160. 		$s = str_replace( '.', ' ', $s );

    161. 

  161. 		

    162. 

  162. 		/* Remove lines feeds */

    163. 

  163. 		$s = $this->oCase->rm_crlf( $s );

    164. 

  164. 		

    165. 

  165. 		/* Add space to HTML-tags */

    166. 

  166. 		$s = str_replace('><', '> <', $s );

    167. 

  167. 		$s = str_replace('<'.'?'.'php', '', $s );

    168. 

  168. 		$s = strip_tags( $s );

    169. 

  169. 		

    170. 

  170. 		/* remove {TEMPLATES}, {%TEMPLATES%} */

    171. 

  171. 		#$s = preg_replace( "/{(%)?([A-Za-z0-9:\-_]+)(%)?}/", '', $s );

    172. 

  172. 		$s = $this->oCase->rm_entity( $s );

    173. 

  173. 

    174. 

  174. 		$newchar_encd = urlencode( $newchar );

    175. 

  175. 		

    176. 

  176. 		/* Cache patterns using memory */

    177. 

  177. 		if ( !isset( $this->rm_specials_patterns[$newchar_encd] ) )

    178. 

  178. 		{

    179. 

  179. 			/* Construct filename with cached replacement patterns */

    180. 

  180. 			$filename = $this->V->path_temp.'/gw_translit_1_'.$newchar_encd.'.tmp';

    181. 

  181. 			

    182. 

  182. 			/* Cache patterns using files */

    183. 

  183. 			if ( file_exists( $filename ) )

    184. 

  184. 			{

    185. 

  185. 				$this->rm_specials_patterns[$newchar_encd] = unserialize( implode( '', file( $filename ) ) );

    186. 

  186. 			}

    187. 

  187. 			else

    188. 

  188. 			{

    189. 

  189. 				/* Read patterns from database */

    190. 

  190. 				$this->oDb->select( 'str_from, str_to' );

    191. 

  191. 				$this->oDb->from( 'translit' );

    192. 

  192. 				$this->oDb->where( array( 'id_profile' => '1' ) );

    193. 

  193. 				$ar_sql = $this->oDb->get()->result_array();

    194. 

  194. 				$ar_lines = array();

    195. 

  195. 				foreach ( $ar_sql as $ar_v ) 

    196. 

  196. 				{

    197. 

  197. 					$this->rm_specials_patterns[$newchar_encd][urldecode($ar_v['str_from'])] = ( $newchar != '' && $ar_v['str_to'] != '+' ) 

    198. 

  198. 						? urldecode( $ar_v['str_to'] ) 

    199. 

  199. 						: $newchar;

    200. 

  200. 				}

    201. 

  201. 				$this->oFunc->file_put_contents( $filename, serialize( $this->rm_specials_patterns[$newchar_encd] ) );

    202. 

  202. 			}

    203. 

  203. 		}

    204. 

  204. 		

    205. 

  205. 		/* */

    206. 

  206. 		$s = str_replace( 

    207. 

  207. 			array_keys( $this->rm_specials_patterns[$newchar_encd] ), 

    208. 

  208. 			array_values( $this->rm_specials_patterns[$newchar_encd] ), 

    209. 

  209. 			$s

    210. 

  210. 		);

    211. 

  211. 

    212. 

  212. 		/* Leave one character only */

    213. 

  213. 		if ( $newchar != '' )

    214. 

  214. 		{

    215. 

  215. 			/*

    216. 

  216. 			 0.000395 - preg_replace

    217. 

  217. 			 0.000031 - str_replace

    218. 

  218. 			*/

    219. 

  219. 			$cnt_replace = 1;

    220. 

  220. 			while ( $cnt_replace )

    221. 

  221. 			{

    222. 

  222. 				$s = str_replace( $newchar.$newchar, $newchar, $s, $cnt_replace ); 

    223. 

  223. 			}

    224. 

  224. 		}

    225. 

  225. 

    226. 

  226. 		return $s;

    227. 

  227. 	}

    228. 

  228. 	

    229. 

  229. 	

    230. 

  230. 	/* */

    231. 

  231. 	public function strord( $s )

    232. 

  232. 	{

    233. 

  233. 		preg_match_all( "/./u", $s, $ar_letters );

    234. 

  234. 		$ar_ord = array();

    235. 

  235. 		for ($i = 1; $i <= 8; $i++)

    236. 

  236. 		{

    237. 

  237. 			$ar_ord[$i] = isset( $ar_letters[0][$i] ) ? implode('', unpack( "C*", $ar_letters[0][$i] ) ) : 0;

    238. 

  238. 		}

    239. 

  239. 		return $ar_ord;

    240. 

  240. 	}

    241. 

  241. 

    242. 

  242. 	/* Generates URI for an Item */

    243. 

  243. 	public function items__uri( $s, $id_item = '' )

    244. 

  244. 	{

    245. 

  245. 		/* 327 symbols */

    246. 

  246. 		/* 0.26, 110 Queries */

    247. 

  247. 		/* 0.09, 10 Queries */

    248. 

  248. 		

    249. 

  249. 		/* Construct filename with cached replacement patterns */

    250. 

  250. 		$filename = $this->V->path_temp.'/gw_translit_2.tmp';

    251. 

  251. 

    252. 

  252. 		/* Cache patterns using memory */

    253. 

  253. 		if ( !$this->uri_patterns )

    254. 

  254. 		{

    255. 

  255. 			/* Cache patterns using files */

    256. 

  256. 			if ( file_exists( $filename ) )

    257. 

  257. 			{

    258. 

  258. 				$this->uri_patterns = unserialize( implode( '', file( $filename ) ) );

    259. 

  259. 			}

    260. 

  260. 			else

    261. 

  261. 			{

    262. 

  262. 				/* Read patterns from database */

    263. 

  263. 				$this->oDb->select( 'str_from, str_to' );

    264. 

  264. 				$this->oDb->from( 'translit' );

    265. 

  265. 				$this->oDb->where( array( 'id_profile' => '2' ) );

    266. 

  266. 				$ar_sql = $this->oDb->get()->result_array();

    267. 

  267. 				$ar_lines = array();

    268. 

  268. 				foreach ( $ar_sql as $ar_v ) 

    269. 

  269. 				{

    270. 

  270. 					$this->uri_patterns[urldecode($ar_v['str_from'])] = urldecode( $ar_v['str_to'] );

    271. 

  271. 				}

    272. 

  272. 				$this->oFunc->file_put_contents( $filename, serialize( $this->uri_patterns ) );

    273. 

  273. 			}

    274. 

  274. 		}

    275. 

  275. 

    276. 

  276. 		/* */

    277. 

  277. 		$s = str_replace( array_keys( $this->uri_patterns ), array_values( $this->uri_patterns ), $s );

    278. 

  278. 

    279. 

  279. 		/* Keep alphanumeric only characters */

    280. 

  280. 		$s = preg_replace( '/[^0-9A-Za-z_-]/', '-', $s );

    281. 

  281. 

    282. 

  282. 		/* Remove repeated `-` */

    283. 

  283. 		$cnt_replace = 1;

    284. 

  284. 		while ( $cnt_replace )

    285. 

  285. 		{

    286. 

  286. 			$s = str_replace( '--', '-', $s, $cnt_replace ); 

    287. 

  287. 		}

    288. 

  288. 		$s = rtrim( $s, '-' );

    289. 

  289. 		

    290. 

  290. 		/* No alphanumeric characters found, use Item ID */

    291. 

  291. 		if ( $s == '' )

    292. 

  292. 		{

    293. 

  293. 			$s = $id_item;

    294. 

  294. 		}

    295. 

  295. 

    296. 

  296. 		/* Limit length */

    297. 

  297. 		$s = substr( $s, 0, 200 );

    298. 

  298. 

    299. 

  299. 		return $s;

    300. 

  300. 	}

    301. 

  301. 	

    302. 

  302. 	/* */

    303. 

  303. 	public function notice_onsubmit( $phrase, $is_success = true )

    304. 

  304. 	{

    305. 

  305. 		$this->oOutput->append_html( '<div><div class="'.GW_COLOR_TRUE.' updated" id="status-onsumbit">' );

    306. 

  306. 		$this->oOutput->append_html( '<a onclick="jsF.destroy_el(\'status-onsumbit\');" style="margin:-1em -1em;font-size:80%;" class="btn remove floatright" href="#" title="'. $this->oTkit->_( 1154 ) .'">'. $this->oTkit->_( 1154 ) .'<span class="icon-rm"></span></a>' );

    307. 

  307. 		$this->oOutput->append_html( $phrase );

    308. 

  308. 		$this->oOutput->append_html( '</div></div>' );

    309. 

  309. 		/* Automatically close window */

    310. 

  310. 		$this->oOutput->append_js( 'setTimeout( function(){ jsF.FX_fade_out(\'status-onsumbit\'); }, 4000 );' );

    311. 

  311. 	}

    312. 

  312. 	

    313. 

  313. 	/* */

    314. 

  314. 	public function langs__get_installed()

    315. 

  315. 	{

    316. 

  316. 		$ar = array();

    317. 

  317. 		foreach ( $this->oTkit->ar_lang_list as $ar_v )

    318. 

  318. 		{

    319. 

  319. 			$ar[$ar_v['id_lang']] = $ar_v['lang_name'].' - '.$ar_v['lang_native'];

    320. 

  320. 		}

    321. 

  321. 		/* @todo: put in cache */

    322. 

  322. 		return $ar;

    323. 

  323. 	}

    324. 

  324. 	/* */

    325. 

  325. 	public function langs__get_locale_codes()

    326. 

  326. 	{

    327. 

  327. 		$ar = array();

    328. 

  328. 		foreach ( $this->oTkit->ar_lang_list as $ar_v )

    329. 

  329. 		{

    330. 

  330. 			$ar[$ar_v['isocode1'].'_'.$ar_v['region']] = $ar_v['id_lang'];

    331. 

  331. 		}

    332. 

  332. 		/* @todo: put in cache */

    333. 

  333. 		return $ar;

    334. 

  334. 	}

    335. 

  335. 	

    336. 

  336. 	

    337. 

  337. 	/**

    338. 

  338. 	 * Constructs alphabetic order and returns HTML for navigation.

    339. 

  339. 	 *

    340. 

  340. 	 * @uses $oDb, $oHtml, $oCache.

    341. 

  341. 	 * @return array [ az, aazz ]

    342. 

  342. 	 */

    343. 

  343. 	public function items__get_az()

    344. 

  344. 	{

    345. 

  345. 		$ar_az = $ar_aazz = array();

    346. 

  346. 		

    347. 

  347. 		/* Reduce cache time for admin area */

    348. 

  348. 		$time_cache_az = ( SITE_ADMIN_MODE ) ? 60 * 2 : $this->V->time_cache_az;

    349. 

  349. 

    350. 

  350. 		/* A-Z */

    351. 

  351. 

    352. 

  352. #$oTimer = new tkit_timer('az-sql');

    353. 

  353. 

    354. 

  354. 		/**

    355. 

  355. 		 * Use DB-based cache.

    356. 

  356. 		 * Cache off: 0.003457 az sql + 0.007476 az html = 0.010933

    357. 

  357. 		 * Cache on:  0.002011 az html

    358. 

  358. 		*/

    359. 

  359. 

    360. 

  360. 		$cache_key = 'az-' . $this->gv['il'] . $this->V->is_sef . 

    361. 

  361. 			( isset( $this->gv['area']['a1'] ) ? $this->gv['area']['a1'] : '-' ) . 

    362. 

  362. 			( isset( $this->gv['area']['lc'] ) ? $this->gv['area']['lc'] : '-' ) . 

    363. 

  363. 			$this->V->id_field_root . SITE_ADMIN_MODE . SITE_WEB_MODE;

    364. 

  364. 		if ( $this->V->is_cache_az && $this->oCache->in_cache( $cache_key, 'items-az', $time_cache_az ) )

    365. 

  365. 		{

    366. 

  366. 			$ar_az = $this->oCache->load();

    367. 

  367. 		}

    368. 

  368. 		else

    369. 

  369. 		{

    370. 

  370. 			/* Basic Multilingual Plane: */

    371. 

  371. 			/* http://www.unicode.org/roadmaps/bmp/ */

    372. 

  372. 			/* Break alphabetic toolbar per every set of characters */

    373. 

  373. 			$ar_unicode_map = array(

    374. 

  374. 				#array( '20', 'Basic Latin Digits' ),

    375. 

  375. 				#array( '41', 'Basic Latin' ),

    376. 

  376. 				array( '20', 'Basic Latin && Basic Latin Digits' ),

    377. 

  377. 				array( 'c280', 'Latin Extended' ),

    378. 

  378. 				array( 'c990', 'IPA Extensions' ),

    379. 

  379. 				array( 'cab0', 'Spacing Modifiers' ),

    380. 

  380. 				array( 'cc80', 'Combining Diacritics' ),

    381. 

  381. 				array( 'cdb0', 'Greek' ),

    382. 

  382. 				array( 'd080', 'Cyrillic, Cyrillic Supplement' ),

    383. 

  383. 				array( 'd4b0', 'Armenian' )

    384. 

  384. 			);

    385. 

  385. 			$ar_tb_last = end( $ar_unicode_map );

    386. 

  386. 			$int_tb_last = hexdec( $ar_tb_last[0] );

    387. 

  387. 			

    388. 

  388. 			/* Select first letters and Language ID */

    389. 

  389. #			$this->oDb->select( 'c.contents_a, az1.id_lang, CONCAT( l.isocode1,"_", l.region ) locale', false );

    390. 

  390. #			$this->oDb->from( array( 'items i', 'contents c', 'languages l' ) );

    391. 

  391. #			$this->oDb->where( array( 

    392. 

  392. #				'i.id_item = c.id_item' => NULL,

    393. 

  393. #				'l.id_lang = c.id_lang' => NULL, 

    394. 

  394. #				'c.id_field' => (string) $this->V->id_field_root, 

    395. 

  395. #				'i.is_active' => '1' 

    396. 

  396. #			) );

    397. 

  397. #			$this->oDb->group_by( 'az1.id_lang, c.contents_a' );

    398. 

  398. #			$this->oDb->order_by( 'c.id_lang' );

    399. 

  399. 

    400. 

  400. 			/* 1.9.3: Custom alphabetic order */

    401. 

  401. #			$this->oDb->join( 'az_letters az1', 'az1.uc_crc32u = c.contents_1 AND c.id_lang = az1.id_lang', 'left', false );

    402. 

  402. #			$this->oDb->order_by( 'az1.int_sort' );

    403. 

  403. #			$this->oDb->order_by( 'c.contents_so' );

    404. 

  404. 			

    405. 

  405. 			$this->oDb->select( 'it.contents_a, it.id_lang_1 id_lang, CONCAT( l.isocode1,"_", l.region ) locale', false );

    406. 

  406. 			$this->oDb->from( array( 'items_tmp it' ) );

    407. 

  407. 			$this->oDb->join( 'languages l', 'it.id_lang_1 = l.id_lang', 'left' );

    408. 

  408. 			$this->oDb->where( array( 'it.is_active' => '1'  ) );

    409. 

  409. 			$this->oDb->group_by( 'it.id_lang_1, it.contents_a' );

    410. 

  410. 			$this->oDb->order_by( 'it.int_sort_1, it.contents_so' );

    411. 

  411. 

    412. 

  412. 			$ar_sql = $this->oDb->get()->result_array();

    413. 

  413. 

    414. 

  414. 

    415. 

  415. 			

    416. 

  416. 	#print $oTimer->endp('az sql');

    417. 

  417. 	#$oTimer = new tkit_timer('az-html');

    418. 

  418. 			

    419. 

  419. 			$oHref = $this->oHtml->oHref();

    420. 

  420. 			foreach ( $ar_sql as $ar_v )

    421. 

  421. 			{

    422. 

  422. 				$ar_v['contents_a'] = str_replace( "\0", '', $ar_v['contents_a'] );

    423. 

  423. 				/* For each letter */

    424. 

  424. 				$oHref = $this->oHtml->oHref();

    425. 

  425. 				$oHref->set( 'a1', urlencode( $ar_v['contents_a'] ) );

    426. 

  426. 				/* 1.9.3: Locale code */

    427. 

  427. 				$oHref->set( 'lc', $ar_v['locale'] );

    428. 

  428. 

    429. 

  429. 				$class_name = '';

    430. 

  430. 				if ( isset( $this->gv['area']['a1'] ) && isset( $this->gv['area']['lc'] )

    431. 

  431. 					&& $ar_v['contents_a'] == $this->gv['area']['a1'] 

    432. 

  432. 					&& $ar_v['locale'] == $this->gv['area']['lc'] 

    433. 

  433. 				)

    434. 

  434. 				{

    435. 

  435. 					$class_name = 'highlight';

    436. 

  436. 				}

    437. 

  437. 				

    438. 

  438. 				/* 1.9.3: Group Alphabetic Order using Language ID */

    439. 

  439. 				if ( SITE_ADMIN_MODE )

    440. 

  440. 				{

    441. 

  441. 					$oHref->set( 't', 'items' );

    442. 

  442. 					$oHref->set( 'a', 'manage' );

    443. 

  443. 					$ar_az[$ar_v['id_lang']][] = $this->oHtmlAdm->a_href( 

    444. 

  444. 								array( $this->V->file_index, '#area' => $oHref->get() ), 

    445. 

  445. 								array( 'class' => $class_name, 'title' => $ar_v['contents_a'] ), $ar_v['contents_a'] 

    446. 

  446. 					);

    447. 

  447. 				}

    448. 

  448. 				else

    449. 

  449. 				{

    450. 

  450. 					$ar_az[$ar_v['id_lang']][] = $this->oHtml->a_href( 

    451. 

  451. 								array( $this->V->file_index, '#area' => $oHref->get() ), 

    452. 

  452. 								array( 'class' => $class_name, 'title' => $ar_v['contents_a'] ), $ar_v['contents_a']

    453. 

  453. 					);

    454. 

  454. 				}

    455. 

  455. 			}

    456. 

  456. 				

    457. 

  457. 			/* Re-arrange */

    458. 

  458. 			foreach ( $ar_az as $az_k => $az_v )

    459. 

  459. 			{

    460. 

  460. 				unset( $ar_az[$az_k] );

    461. 

  461. 				$ar_az[] = '<div>';

    462. 

  462. 				foreach ( $az_v as $k_tb => $v_tb )

    463. 

  463. 				{

    464. 

  464. 					$ar_az[] = $v_tb;

    465. 

  465. 				}

    466. 

  466. 				$ar_az[] = '</div>';

    467. 

  467. 			}

    468. 

  468. 			

    469. 

  469. 			# prn_r( $ar_az );

    470. 

  470. 

    471. 

  471. 			/* Show all */

    472. 

  472. 			$oHref->set( 'a1' );

    473. 

  473. 			$oHref->set( 'a2' );

    474. 

  474. 			$oHref->set( 'lc' );

    475. 

  475. 			if ( SITE_ADMIN_MODE )

    476. 

  476. 			{

    477. 

  477. 				$ar_az[-1] = $this->oHtmlAdm->a_href(

    478. 

  478. 							array( $this->V->file_index, '#area' => $oHref->get() ),

    479. 

  479. 							array( 'class' => ( !isset( $this->gv['area']['a1'] ) || ( isset( $this->gv['area']['a1'] ) && $this->gv['area']['a1'] ) == '' ? 'highlight' : '' ) ),

    480. 

  480. 							$this->oTkit->_( 1044 )

    481. 

  481. 				);

    482. 

  482. 			}

    483. 

  483. 			else

    484. 

  484. 			{

    485. 

  485. 				/* 1.9.3: Added `showall` classname */

    486. 

  486. 				$ar_az[-1] = $this->oHtml->a_href(

    487. 

  487. 							array( $this->V->file_index, '#area' => $oHref->get() ),

    488. 

  488. 							array(

    489. 

  489. 								'title' => $this->oTkit->_( 1044 ), 

    490. 

  490. 								'class' => 'showall' . ( !isset( $this->gv['area']['a1'] ) || ( isset( $this->gv['area']['a1'] ) && $this->gv['area']['a1'] != '' ) == '' ? ' highlight' : '' ) ),

    491. 

  491. 							$this->oTkit->_( 1044 )

    492. 

  492. 				);

    493. 

  493. 			}

    494. 

  494. 			/* Cached Units: Save */

    495. 

  495. 			if ( $this->V->is_cache_az )

    496. 

  496. 			{

    497. 

  497. 				 $ar_az = $this->oCache->save( $ar_az );

    498. 

  498. 			}

    499. 

  499. 		}

    500. 

  500. 

    501. 

  501. #print $oTimer->endp('az html');

    502. 

  502. 

    503. 

  503. 		/* AA-ZZ */

    504. 

  504. 		/* 1.9.3: disabled */

    505. 

  505. 		if ( 0 && isset( $this->gv['area']['a1'] ) && $this->gv['area']['a1'] != '' )

    506. 

  506. 		{

    507. 

  507. 

    508. 

  508. #$oTimer = new tkit_timer('aazz-sql');

    509. 

  509. 

    510. 

  510. 			$cache_key = 'aazz-' . $this->gv['il'] . $this->V->is_sef . ( isset( $this->gv['area']['a1'] ) ? $this->gv['area']['a1'] : '' ) .

    511. 

  511. 				( isset( $this->gv['area']['a2'] ) ? $this->gv['area']['a2'] : '' ) .

    512. 

  512. 				$this->V->id_field_root . SITE_ADMIN_MODE . SITE_WEB_MODE;

    513. 

  513. 			if ( $this->oCache->in_cache( $cache_key, 'items-az', $time_cache_az ) )

    514. 

  514. 			{

    515. 

  515. 				$ar_aazz = $this->oCache->load();

    516. 

  516. 			}

    517. 

  517. 			else

    518. 

  518. 			{

    519. 

  519. 

    520. 

  520. 				$this->oDb->select( 'c.contents_b' );

    521. 

  521. 				$this->oDb->from( array( 'items i', 'contents c' ) );

    522. 

  522. 				$this->oDb->where( array( 'i.id_item = c.id_item' => NULL, 'i.is_active' => 1, 'c.id_field' => $this->V->id_field_root, 'c.contents_a' => $this->gv['area']['a1']  ) );

    523. 

  523. 				$this->oDb->group_by( 'c.contents_b' );

    524. 

  524. 				$ar_sql = $this->oDb->get()->result_array();

    525. 

  525. 

    526. 

  526. #	print $oTimer->endp('aazz sql');

    527. 

  527. #	$oTimer = new tkit_timer('aazz-html');

    528. 

  528. 				

    529. 

  529. 				foreach ( $ar_sql as $ar_v )

    530. 

  530. 				{

    531. 

  531. 					$oHref = $this->oHtml->oHref();

    532. 

  532. 					$oHref->set( 'a1', urlencode( $this->gv['area']['a1'] ) );

    533. 

  533. 					$oHref->set( 'a2', urlencode( $ar_v['contents_b'] ) );

    534. 

  534. 

    535. 

  535. 					$class_name = '';

    536. 

  536. 					if ( isset( $this->gv['area']['a2'] ) && $ar_v['contents_b'] == $this->gv['area']['a2'] )

    537. 

  537. 					{

    538. 

  538. 						$class_name = 'highlight';

    539. 

  539. 					}

    540. 

  540. 					

    541. 

  541. 					if ( SITE_ADMIN_MODE )

    542. 

  542. 					{

    543. 

  543. 						$oHref->set( 't', $this->gv['area']['t'] );

    544. 

  544. 						$oHref->set( 'a', $this->gv['area']['a'] );

    545. 

  545. 						$ar_aazz[] = $this->oHtmlAdm->a_href(

    546. 

  546. 										array( $this->V->file_index, '#area' => $oHref->get() ),

    547. 

  547. 										array( 'class' => $class_name ),

    548. 

  548. 										$this->gv['area']['a1'].$ar_v['contents_b']

    549. 

  549. 						);

    550. 

  550. 					}

    551. 

  551. 					else

    552. 

  552. 					{

    553. 

  553. 						$ar_aazz[] = $this->oHtml->a_href(

    554. 

  554. 										array( $this->V->file_index, '#area' => $oHref->get() ),

    555. 

  555. 										array( 'class' => $class_name ),

    556. 

  556. 										$this->gv['area']['a1'].$ar_v['contents_b']

    557. 

  557. 						);

    558. 

  558. 					}

    559. 

  559. 				}

    560. 

  560. 				/* Cached Units: Save */

    561. 

  561. 				$ar_aazz = $this->oCache->save( $ar_aazz );

    562. 

  562. 			}

    563. 

  563. #print $oTimer->endp('aazz html');

    564. 

  564. 		}

    565. 

  565. 		return array( $ar_az, $ar_aazz );

    566. 

  566. 	}

    567. 

  567. 

    568. 

  568. 	/**

    569. 

  569. 	 * Generates CAPTCHA image.

    570. 

  570. 	 * 

    571. 

  571. 	 * @uses $oDb, $oFunc, str_random().

    572. 

  572. 	 */

    573. 

  573. 	public function make_captcha()

    574. 

  574. 	{

    575. 

  575. 		if (file_exists($this->V->path_includes.'/func_make_captcha.php'))

    576. 

  576. 		{

    577. 

  577. 			include_once($this->V->path_includes.'/func_make_captcha.php');

    578. 

  578. 			return array($this->V->server_dir.'/'.$filename);

    579. 

  579. 		}

    580. 

  580. 	}

    581. 

  581. 	/**

    582. 

  582. 	 * Generates a random string.

    583. 

  583. 	 */

    584. 

  584. 	static function str_random($alphabet, $maxchar = 8)

    585. 

  585. 	{

    586. 

  586. 		$str = '';

    587. 

  587. 		$alphabet = ($alphabet) ? $alphabet : '23456789bdghkmnqsuvxyz';

    588. 

  588. 		$alphabet = str_shuffle($alphabet);

    589. 

  589. 		$len = strlen($alphabet);

    590. 

  590. 		for ($i = 0; $i < $maxchar; $i++)

    591. 

  591. 		{

    592. 

  592. 			$sed = mt_rand(0, $len-1);

    593. 

  593. 			$str .= $alphabet[$sed];

    594. 

  594. 		}

    595. 

  595. 		return $str;

    596. 

  596. 	}

    597. 

  597. 	

    598. 

  598. 

    599. 

  599. 

    600. 

  600. 	/* */

    601. 

  601. 	public function create_navbar()

    602. 

  602. 	{

    603. 

  603. 		if ( defined('SITE_THIS_SCRIPT') && SITE_THIS_SCRIPT == $this->V->file_index )

    604. 

  604. 		{

    605. 

  605. 			return;

    606. 

  606. 		}

    607. 

  607. 		#$ar_menu[$this->oTkit->_( '1000' )][] = '';

    608. 

  608. 		

    609. 

  609. 		$ar_menu[$this->oTkit->_( '1000' )][] =  $this->oHtmlAdm->a_href(

    610. 

  610. 				array( $this->V->file_index, 'arg[area]' => '' ),

    611. 

  611. 				array( 'title' => $this->oTkit->_( '1152' ) ),

    612. 

  612. 				$this->oTkit->_( '1152' )

    613. 

  613. 		);

    614. 

  614. 		/* Add */

    615. 

  615. 		$ar_menu[$this->oTkit->_( '1001' )][] =  $this->oHtmlAdm->a_href(

    616. 

  616. 				array( $this->V->file_index, 'arg[area]' => 'a.add,t.items' ),

    617. 

  617. 				array(),

    618. 

  618. 				$this->oTkit->_( '1003' )

    619. 

  619. 		);

    620. 

  620. 		$ar_menu[$this->oTkit->_( '1001' )][] =  $this->oHtmlAdm->a_href(

    621. 

  621. 				array( $this->V->file_index, 'arg[area]' => 'a.add,t.infoblocks' ),

    622. 

  622. 				array( 'title' => $this->oTkit->_( '1054' ) ),

    623. 

  623. 				$this->oTkit->_( '1054' )

    624. 

  624. 		);

    625. 

  625. 		/* Manage */

    626. 

  626. 		$ar_menu[$this->oTkit->_( '1006' )][] =  $this->oHtmlAdm->a_href(

    627. 

  627. 				array( $this->V->file_index, 'arg[area]' => 'a.manage,t.items' ),

    628. 

  628. 				array( 'title' => $this->oTkit->_( '1003' ) ),

    629. 

  629. 				$this->oTkit->_( '1003' )

    630. 

  630. 		);

    631. 

  631. 		$ar_menu[$this->oTkit->_( '1006' )][] =  $this->oHtmlAdm->a_href(

    632. 

  632. 				array( $this->V->file_index, 'arg[area]' => 'a.manage,t.fields' ),

    633. 

  633. 				array( 'title' => $this->oTkit->_( '1020' ) ),

    634. 

  634. 				$this->oTkit->_( '1020' )

    635. 

  635. 		);

    636. 

  636. 		$ar_menu[$this->oTkit->_( '1006' )][] =  $this->oHtmlAdm->a_href(

    637. 

  637. 				array( $this->V->file_index, 'arg[area]' => 'a.manage,t.infoblocks' ),

    638. 

  638. 				array( 'title' => $this->oTkit->_( '1054' ) ),

    639. 

  639. 				$this->oTkit->_( '1054' )

    640. 

  640. 		);

    641. 

  641. 		$ar_menu[$this->oTkit->_( '1006' )][] =  $this->oHtmlAdm->a_href(

    642. 

  642. 				array( $this->V->file_index, 'arg[area]' => 'a.manage,t.az' ),

    643. 

  643. 				array( 'title' => $this->oTkit->_( 1209 ) ),

    644. 

  644. 				$this->oTkit->_( 1209  )

    645. 

  645. 		);

    646. 

  646. 		$ar_menu[$this->oTkit->_( '1006' )][] =  $this->oHtmlAdm->a_href(

    647. 

  647. 				array( $this->V->file_index, 'arg[area]' => 'a.manage,t.translations' ),

    648. 

  648. 				array( 'title' => $this->oTkit->_( 1190 ) ),

    649. 

  649. 				$this->oTkit->_( 1190 )

    650. 

  650. 		);

    651. 

  651. 

    652. 

  652. 

    653. 

  653. 		/* Setup */

    654. 

  654. 		$ar_menu[$this->oTkit->_( 1007 )][] =  $this->oHtmlAdm->a_href(

    655. 

  655. 				array( $this->V->file_index, 'arg[area]' => 'a.setup,t.systemsettings' ), 

    656. 

  656. 				array( 'title' => $this->oTkit->_( 1040 ) ),

    657. 

  657. 				$this->oTkit->_( 1040 )

    658. 

  658. 		);

    659. 

  659. 		

    660. 

  660. 		/* Service */

    661. 

  661. 		/* Service - Maintenance */

    662. 

  662. 		$ar_menu[$this->oTkit->_( 1008 )][] =  $this->oHtmlAdm->a_href(

    663. 

  663. 				array( $this->V->file_index, 'arg[area]' => 'a.mnt,t.service' ), 

    664. 

  664. 				array( 'title' => $this->oTkit->_( 1110 ) ),

    665. 

  665. 				$this->oTkit->_( 1110 )

    666. 

  666. 		);

    667. 

  667. 		/* Service - Localization */

    668. 

  668. 		$oJsMenu = new site_jsMenu();

    669. 

  669. 		$oJsMenu->icon = $this->oTkit->_( 1183 ).$this->V->str_class_dropdown;

    670. 

  670. 		$oJsMenu->event = 'onmouseover';

    671. 

  671. 		$oJsMenu->classname = '';

    672. 

  672. 		$oJsMenu->append( $this->oHtmlAdm->url_normalize( $this->V->file_index.'?#area=a.manage'."\x01\x01".'t.langs' ), $this->oTkit->_( 1181 ) );

    673. 

  673. 		$oJsMenu->append( $this->oHtmlAdm->url_normalize( $this->V->file_index.'?#area=a.manage'."\x01\x01".'t.tvs' ), $this->oTkit->_( 1182 ) );

    674. 

  674. 		$oJsMenu->append( $this->oHtmlAdm->url_normalize( $this->V->file_index.'?#area=a.manage'."\x01\x01".'t.translations' ), $this->oTkit->_( 1190 ) );

    675. 

  675.  		$ar_menu[$this->oTkit->_( 1008 )][] = $oJsMenu->get_html();

    676. 

  676. 

    677. 

  677. 		/* Exchange - Export */

    678. 

  678. 		$oJsMenu = new site_jsMenu();

    679. 

  679. 		$oJsMenu->icon = $this->oTkit->_( 1079 ).$this->V->str_class_dropdown;

    680. 

  680. 		$oJsMenu->event = 'onmouseover';

    681. 

  681. 		$oJsMenu->classname = '';

    682. 

  682. 		$oJsMenu->append( $this->oHtmlAdm->url_normalize( $this->V->file_index.'?#area=a.export'."\x01\x01".'t.items' ), $this->oTkit->_( 1003 ) );

    683. 

  683. 		$oJsMenu->append( $this->oHtmlAdm->url_normalize( $this->V->file_index.'?#area=a.export'."\x01\x01".'t.infoblocks' ), $this->oTkit->_( 1054 ) );

    684. 

  684. 		$oJsMenu->append( $this->oHtmlAdm->url_normalize( $this->V->file_index.'?#area=a.export'."\x01\x01".'t.langs' ), $this->oTkit->_( 1181 ) );

    685. 

  685. 		$oJsMenu->append( $this->oHtmlAdm->url_normalize( $this->V->file_index.'?#area=a.export'."\x01\x01".'t.tvs' ), $this->oTkit->_( 1182 ) );

    686. 

  686. 		$oJsMenu->append( $this->oHtmlAdm->url_normalize( $this->V->file_index.'?#area=a.export'."\x01\x01".'t.az' ), $this->oTkit->_( 1209 ) );

    687. 

  687.  		$ar_menu[$this->oTkit->_( 1009 )][] = $oJsMenu->get_html();

    688. 

  688. 		

    689. 

  689. 		/* Exchange - Import */

    690. 

  690. 		$oJsMenu = new site_jsMenu();

    691. 

  691. 		$oJsMenu->icon = $this->oTkit->_( 1077 ).$this->V->str_class_dropdown;

    692. 

  692. 		$oJsMenu->event = 'onmouseover';

    693. 

  693. 		$oJsMenu->classname = '';

    694. 

  694. 		$oJsMenu->append( $this->oHtmlAdm->url_normalize( $this->V->file_index.'?#area=a.import'."\x01\x01".'t.items' ), $this->oTkit->_( 1003 ) );

    695. 

  695. 		$oJsMenu->append( $this->oHtmlAdm->url_normalize( $this->V->file_index.'?#area=a.import'."\x01\x01".'t.infoblocks' ), $this->oTkit->_( 1054 ) );

    696. 

  696. 		$oJsMenu->append( $this->oHtmlAdm->url_normalize( $this->V->file_index.'?#area=a.import'."\x01\x01".'t.langs' ), $this->oTkit->_( 1181 ) );

    697. 

  697. 		$oJsMenu->append( $this->oHtmlAdm->url_normalize( $this->V->file_index.'?#area=a.import'."\x01\x01".'t.tvs' ), $this->oTkit->_( 1182 ) );

    698. 

  698. 		$oJsMenu->append( $this->oHtmlAdm->url_normalize( $this->V->file_index.'?#area=a.import'."\x01\x01".'t.az' ), $this->oTkit->_( 1209 ) );

    699. 

  699. 		$ar_menu[$this->oTkit->_( 1009 )][] = $oJsMenu->get_html();

    700. 

  700.  			

    701. 

  701. 

    702. 

  702. 		/* Right-side menu*/

    703. 

  703. 		$ar_menu_right[$this->oTkit->_( '1011' )][] =  $this->oHtmlAdm->a_href(

    704. 

  704. 				array( $this->V->file_index, 'arg[area]' => 't.user,a.edit,s.pass'  ),

    705. 

  705. 				array( 'title' => $this->oTkit->_( '1012' ) ),

    706. 

  706. 				$this->oTkit->_( '1012' )

    707. 

  707. 		);

    708. 

  708. 		$ar_menu_right[$this->oTkit->_( '1011' )][] =  $this->oHtmlAdm->a_href(

    709. 

  709. 				array( $this->V->file_index, 'arg[area]' => 't.user,a.edit,s.profile'  ),

    710. 

  710. 				array( 'title' => $this->oTkit->_( '1013' ) ),

    711. 

  711. 				$this->oTkit->_( '1013' )

    712. 

  712. 		);

    713. 

  713. 		/* */

    714. 

  714. 		$ar_str = $ar_js_menublocks = array();

    715. 

  715. 		$ar_str[] = '<ul>';

    716. 

  716. 		$ar_str[] = '<li><p></p></li>';

    717. 

  717. 		$cnt = 1;

    718. 

  718. 		$cnt_current = 0;

    719. 

  719. 		$ar_str_sub = array();

    720. 

  720. 		foreach ($ar_menu as $str_menu => $ar_a)

    721. 

  721. 		{

    722. 

  722. 			/* @temp Indicators */

    723. 

  723. 			foreach ( $ar_a as $sub_k => $sub_v )

    724. 

  724. 			{

    725. 

  725. 				

    726. 

  726. 				$cmp_1 = preg_replace( '/href="(.*?)"(.*)/', "\\1", $sub_v );

    727. 

  727. 				if ( strlen($this->gv['_area']) > 1 && strpos( $cmp_1, '='.$this->gv['_area'] ) !== false )

    728. 

  728. 				{

    729. 

  729. 					$ar_a[$sub_k] = str_replace( 'href=', 'class="on" href=', $sub_v );

    730. 

  730. 					$cnt_current = $cnt;

    731. 

  731. 				}

    732. 

  732. 			}

    733. 

  733. 			$ar_str[] = '<li>'.$this->oHtmlAdm->a_href(

    734. 

  734. 				array( 'javascript:void(0)'  ),

    735. 

  735. 				array( 'title' => $str_menu, 'onclick' => 'oGwNavbar.sub(this)', 'id' => 'a-'.$cnt ),

    736. 

  736. 				$str_menu

    737. 

  737. 			).'</li>';

    738. 

  738. 			$ar_str_sub[] = '<div id="ch-'.$cnt.'" class="gw-navbar-sub hidden"><ul><li>'.implode( '</li><li>', $ar_a ).'</li></ul></div>';

    739. 

  739. 			$ar_js_menublocks[] = $cnt;

    740. 

  740. 			++$cnt;

    741. 

  741. 		}

    742. 

  742. 		

    743. 

  743. 		$ar_str[] = '<li class="navbar-right"><p></p></li>';

    744. 

  744. 		foreach ($ar_menu_right as $str_menu => $ar_a)

    745. 

  745. 		{

    746. 

  746. 			/* Indicators */

    747. 

  747. 			/* @temp */

    748. 

  748. 			foreach ( $ar_a as $sub_k => $sub_v )

    749. 

  749. 			{

    750. 

  750. 				if ( strlen($this->gv['_area']) > 1 && strpos($sub_v, '='.$this->gv['_area'] ) !== false )

    751. 

  751. 				{

    752. 

  752. 					$ar_a[$sub_k] = str_replace( 'href=', 'class="on" href=', $sub_v );

    753. 

  753. 					$cnt_current = $cnt;

    754. 

  754. 				}

    755. 

  755. 			}

    756. 

  756. 			$ar_str[] = '<li class="navbar-right">'.$this->oHtmlAdm->a_href(

    757. 

  757. 				array( 'javascript:void(0)'  ),

    758. 

  758. 				array( 'title' => $str_menu, 'onclick' => 'oGwNavbar.sub(this)', 'id' => 'a-'.$cnt ),

    759. 

  759. 				$str_menu

    760. 

  760. 			).'</li>';

    761. 

  761. 			$ar_str_sub[] = '<div id="ch-'.$cnt.'" class="navbar-right gw-navbar-sub hidden"><ul><li>'.implode( '</li><li>', $ar_a ).'</li></ul></div>';

    762. 

  762. 			$ar_js_menublocks[] = $cnt;

    763. 

  763. 			++$cnt;

    764. 

  764. 		}

    765. 

  765. 		

    766. 

  766. 		$this->oOutput->append_js( 'jsF.Set( "menublocks", "['.implode( ',', $ar_js_menublocks ).']" );' );

    767. 

  767. 		

    768. 

  768. 		/* Highlight the current section */

    769. 

  769. 		if ( $cnt_current )

    770. 

  770. 		{

    771. 

  771. 			$this->oOutput->append_js( ' oGwNavbar.sub( fn_getElementById(\'a-'.$cnt_current.'\') ); ' );

    772. 

  772. 		}

    773. 

  773. 		else

    774. 

  774. 		{

    775. 

  775. 			$this->oOutput->append_js( ' oGwNavbar.sub( fn_getElementById(\'a-1\') ); ' );

    776. 

  776. 		}

    777. 

  777. 		

    778. 

  778. 		$ar_str[] = '</ul>';

    779. 

  779. 

    780. 

  780. #		prn_r( $ar_str );

    781. 

  781. 		#prn_r( $ar_str_sub );

    782. 

  782. 		

    783. 

  783. 		return implode( '', $ar_str ).implode( '', $ar_str_sub );

    784. 

  784. 		

    785. 

  785. 	}

    786. 

  786. 	

    787. 

  787. 	/** 

    788. 

  788. 	 * Generates sidebar for user.

    789. 

  789. 	 * 

    790. 

  790. 	 * A temporary version.

    791. 

  791. 	 */

    792. 

  792. 	public function create_sidebar_menu()

    793. 

  793. 	{

    794. 

  794. 		$s = '';

    795. 

  795. 

    796. 

  796. 

    797. 

  797. 

    798. 

  798. 		return $s;

    799. 

  799. 	}

    800. 

  800. 	

    801. 

  801. 

    802. 

  802. 

    803. 

  803. 	/**

    804. 

  804. 	 * Update some user stats.

    805. 

  805. 	 */

    806. 

  806. 	public function stat_user_rebuild($id_user)

    807. 

  807. 	{

    808. 

  808. 		$q__users['cnt_bytes'] = $this->stat_items_bytes($id_user);

    809. 

  809. 		$q__users['cnt_terms'] = $this->stat_items_num($id_user);

    810. 

  810. 		$this->oDb->update( $this->V->db_table_users, $q__users, array('id_user' => $id_user) );

    811. 

  811. 	}

    812. 

  812. 	/**

    813. 

  813. 	 * Calculate total number of bytes.

    814. 

  814. 	 */

    815. 

  815. 	public function stat_items_bytes($id_user)

    816. 

  816. 	{

    817. 

  817. 		$this->oDb->select( 'SUM(cnt_bytes) as sum_bytes' );

    818. 

  818. 		$this->oDb->from( array('contents') );

    819. 

  819. 		$this->oDb->where( array('id_user_created' => $id_user) );

    820. 

  820. 		$ar_sql = $this->oDb->get()->result_array();

    821. 

  821. 		return isset($ar_sql[0]['sum_bytes']) ? $ar_sql[0]['sum_bytes'] : 0;

    822. 

  822. 	}

    823. 

  823. 	/**

    824. 

  824. 	 * Calculate total number of items.

    825. 

  825. 	 */

    826. 

  826. 	public function stat_items_num($id_user)

    827. 

  827. 	{

    828. 

  828. 		$this->oDb->select( 'COUNT(*) as cnt_items' );

    829. 

  829. 		$this->oDb->from( array('items') );

    830. 

  830. 		$this->oDb->where( array('item_id_user_created' => $id_user) );

    831. 

  831. 		$ar_sql = $this->oDb->get()->result_array();

    832. 

  832. 		return isset($ar_sql[0]['cnt_items']) ? $ar_sql[0]['cnt_items'] : 0;

    833. 

  833. 	}

    834. 

  834. 	

    835. 

  835. 	

    836. 

  836. 	/**

    837. 

  837. 	 * HTML-code for Meta Refresh

    838. 

  838. 	 */

    839. 

  839. 	public static function gethtml_meta_refresh($url, $delay = 1)

    840. 

  840. 	{

    841. 

  841. 		return '<meta http-equiv="refresh" content="'.$delay.';url='.$url.'" />';

    842. 

  842. 	}

    843. 

  843. 	/**

    844. 

  844. 	 * "Soft" redirect to another location.

    845. 

  845. 	 */

    846. 

  846. 	public function soft_redirect($text = '', $url, $classname = '')

    847. 

  847. 	{

    848. 

  848. 		if ($classname == GW_COLOR_FALSE)

    849. 

  849. 		{

    850. 

  850. 			$classname = GW_COLOR_FALSE.' error';

    851. 

  851. 		}

    852. 

  852. 		else

    853. 

  853. 		{

    854. 

  854. 			$this->oTpl->assign( 'v:meta_refresh', $this->gethtml_meta_refresh($url, $this->V->time_refresh) );

    855. 

  855. 			$classname = $classname.' updated';

    856. 

  856. 		}

    857. 

  857. 		return '<div class="'.$classname.'" id="status">'.$text.

    858. 

  858. 		'<p><a href="'.$url.'">'.$this->oTkit->_(1050).'</a></p></div>';

    859. 

  859. 	}

    860. 

  860. 

    861. 

  861. 

    862. 

  862. 

    863. 

  863. 	

    864. 

  864. 	/* */

    865. 

  865. 	public function get_perm_map()

    866. 

  866. 	{

    867. 

  867. 		$ar_perms_map = array();

    868. 

  868. 		$ar_perms_map[$this->oTkit->_(1211)]['sys-settings'] = $this->oTkit->_( );

    869. 

  869. 		$ar_perms_map[$this->oTkit->_(1211)]['sys-mnt'] = $this->oTkit->_( );

    870. 

  870. 		$ar_perms_map[$this->oTkit->_(1211)]['users'] = $this->oTkit->_( );

    871. 

  871. 		$ar_perms_map[$this->oTkit->_(1312)]['items'] = $this->oTkit->_( );

    872. 

  872. 		$ar_perms_map[$this->oTkit->_(1312)]['items-own'] = $this->oTkit->_( );

    873. 

  873. 		$ar_perms_map[$this->oTkit->_(1145)]['email'] = $this->oTkit->_( );

    874. 

  874. 		$ar_perms_map[$this->oTkit->_(1145)]['login'] = $this->oTkit->_( );

    875. 

  875. 		$ar_perms_map[$this->oTkit->_(1145)]['password'] = $this->oTkit->_( );

    876. 

  876. 		$ar_perms_map[$this->oTkit->_(1145)]['profile'] = $this->oTkit->_( );

    877. 

  877. 		$ar_perms_map[$this->oTkit->_(1145)]['pm'] = $this->oTkit->_( );

    878. 

  878. 		$ar_perms_map[$this->oTkit->_(1313)]['comments'] = $this->oTkit->_( );

    879. 

  879. 		$ar_perms_map[$this->oTkit->_(1313)]['comments-own'] = $this->oTkit->_( );

    880. 

  880. 		return $ar_perms_map;

    881. 

  881. 	}

    882. 

  882. 	

    883. 

  883. 	/** 

    884. 

  884. 	 * Draws progressbar in HTML+CSS 

    885. 

  885. 	 *

    886. 

  886. 	 * @param	int	$percent

    887. 

  887. 	 * @param	text	$color_txt Progress bar text color

    888. 

  888. 	 * @param	text	$color_bg Progress bar Background color

    889. 

  889. 	 * @return	text	HTML-code

    890. 

  890. 	 */

    891. 

  891. 	public static function text_progressbar($percent = 100, $color_txt = '#000', $color_bg = '#6C3')

    892. 

  892. 	{

    893. 

  893. 		if ($percent > 100){ $percent = 100; }

    894. 

  894. 		return '<div style="text-align:center;background:#F6F6F6;margin:1px 0;width:100%;border:1px solid #CCC"><div style="font:90% sans-serif;color:'.$color_txt.';background:'.$color_bg.';width:'.$percent.'%">'.$percent.'%</div></div>';

    895. 

  895. 	}

    896. 

  896. 	

    897. 

  897. 	

    898. 

  898. 	/**

    899. 

  899. 	 * ----------------------------------------------

    900. 

  900. 	 * Cron functions. Called on /cron.php

    901. 

  901. 	 * ----------------------------------------------

    902. 

  902. 	 */

    903. 

  903. 	public function cron__()

    904. 

  904. 	{

    905. 

  905. 		if ( (mt_rand() % 100) < $this->V->prbblty_tasks )

    906. 

  906. 		{

    907. 

  907. 			$this->cron__user_stats();

    908. 

  908. 		}

    909. 

  909. 		if ( (mt_rand() % 100) < $this->V->prbblty_tasks )

    910. 

  910. 		{

    911. 

  911. 			$this->cron__user_clean_sessions();

    912. 

  912. 		}

    913. 

  913. 	}

    914. 

  914. 	/* Recounts user stats */

    915. 

  915. 	public function cron__user_stats()

    916. 

  916. 	{

    917. 

  917. 		$this->oDb->select('id_user', false);

    918. 

  918. 		$this->oDb->from( array( $this->V->db_table_sessions ) );

    919. 

  919. 		$this->oDb->where( array( 'mdate >' => @date($this->sdf, $this->V->time_gmt - $this->V->time_sec_h)) );

    920. 

  920. 		$this->oDb->group_by('id_user');

    921. 

  921. 		$this->oDb->limit( 100 );

    922. 

  922. 		$ar_sql = $this->oDb->get()->result_array();

    923. 

  923. 

    924. 

  924. 		foreach ($ar_sql as $ar_v)

    925. 

  925. 		{

    926. 

  926. 			$this->stat_user_rebuild($ar_v['id_user']);

    927. 

  927. 		}

    928. 

  928. 	}

    929. 

  929. 	/* Cleans old user sessions */

    930. 

  930. 	public function cron__user_clean_sessions()

    931. 

  931. 	{

    932. 

  932. 		# $this->oDb->delete( $this->V->db_table_sessions, array( 'mdate <' => @date($this->sdf, $this->V->time_gmt - $this->V->time_sec_w), 'is_remember' => '0' ) );

    933. 

  933. 		$this->oDb->delete( $this->V->db_table_sessions, array( 'mdate <' => @date($this->sdf, $this->V->time_gmt - $this->V->time_sec_w) ) );

    934. 

  934. 	}

    935. 

  935. 

    936. 

  936. }}

    937. 

  937. 

    938. 

  938. ?>
    939.