PageRenderTime 52ms CodeModel.GetById 23ms RepoModel.GetById 1ms app.codeStats 0ms

/components/com_jfusionplugins/smf2/public.php

http://jfusion.googlecode.com/
PHP | 1041 lines | 782 code | 128 blank | 131 comment | 135 complexity | f65bd41d1690c8aedce2fa12994707d9 MD5 | raw file
Possible License(s): Apache-2.0 
    

  1. <?php

    2. 

  2. 

    3. 

  3. /**

    4. 

  4. * @package JFusion_SMF

    5. 

  5. * @author JFusion development team

    6. 

  6. * @copyright Copyright (C) 2008 JFusion. All rights reserved.

    7. 

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

    8. 

  8. */

    9. 

  9. 

    10. 

  10. // no direct access

    11. 

  11. defined('_JEXEC' ) or die('Restricted access' );

    12. 

  12. 

    13. 

  13. /**

    14. 

  14.  * JFusion Public Class for SMF 1.1.x

    15. 

  15.  * For detailed descriptions on these functions please check the model.abstractpublic.php

    16. 

  16.  * @package JFusion_SMF

    17. 

  17.  */

    18. 

  18. class JFusionPublic_smf2 extends JFusionPublic{

    19. 

  19. 

    20. 

  20. 	var $callbackdata = null;

    21. 

  21. 	var $callbackbypass = null;

    22. 

  22. 

    23. 

  23. 	function getJname()

    24. 

  24. 	{

    25. 

  25. 		return 'smf2';

    26. 

  26. 	}

    27. 

  27. 

    28. 

  28. 	function getRegistrationURL()

    29. 

  29. 	{

    30. 

  30. 		return 'index.php?action=register';

    31. 

  31. 	}

    32. 

  32. 

    33. 

  33. 	function getLostPasswordURL()

    34. 

  34. 	{

    35. 

  35. 		return 'index.php?action=reminder';

    36. 

  36. 	}

    37. 

  37. 

    38. 

  38. 	function getLostUsernameURL()

    39. 

  39. 	{

    40. 

  40. 		return 'index.php?action=reminder';

    41. 

  41. 	}

    42. 

  42. 

    43. 

  43.     function getProfileURL($uid)

    44. 

  44.     {

    45. 

  45.         return  'index.php?action=profile&u='.$uid;

    46. 

  46.     }

    47. 

  47. 

    48. 

  48.     function getPrivateMessageURL()

    49. 

  49.     {

    50. 

  50.         return 'index.php?action=pm';

    51. 

  51.     }

    52. 

  52. 

    53. 

  53.     function getViewNewMessagesURL()

    54. 

  54.     {

    55. 

  55.         return 'index.php?action=unread';

    56. 

  56.     }

    57. 

  57. 

    58. 

  58.     /**

    59. 

  59.      * Prepares text for various areas

    60. 

  60.      *

    61. 

  61.      * @param string  &$text             Text to be modified

    62. 

  62.      * @param string  $for              (optional) Determines how the text should be prepared.

    63. 

  63.      * Options for $for as passed in by JFusion's plugins and modules are:

    64. 

  64.      * joomla (to be displayed in an article; used by discussion bot)

    65. 

  65.      * forum (to be published in a thread or post; used by discussion bot)

    66. 

  66.      * activity (displayed in activity module; used by the activity module)

    67. 

  67.      * search (displayed as search results; used by search plugin)

    68. 

  68.      * @param object  $params           (optional) Joomla parameter object passed in by JFusion's module/plugin

    69. 

  69.      * @param object  $object           (optional) Object with information for the specific element the text is from

    70. 

  70.      *

    71. 

  71.      * @return array  $status           Information passed back to calling script such as limit_applied

    72. 

  72.      */

    73. 

  73.     function prepareText(&$text, $for = 'forum', $params = '', $object = '')

    74. 

  74.     {

    75. 

  75.         $status = array();

    76. 

  76.         if($for == 'forum') {

    77. 

  77.             static $bbcode;

    78. 

  78. 

    79. 

  79.             //first thing is to remove all joomla plugins

    80. 

  80.             preg_match_all('/\{(.*)\}/U',$text,$matches);

    81. 

  81. 

    82. 

  82.             //find each thread by the id

    83. 

  83.             foreach($matches[1] AS $plugin) {

    84. 

  84.                 //replace plugin with nothing

    85. 

  85.                 $text = str_replace('{'.$plugin.'}',"",$text);

    86. 

  86.             }

    87. 

  87.             if(!is_array($bbcode)) {

    88. 

  88.                 $bbcode = array();

    89. 

  89.                 //pattens to run in begening

    90. 

  90.                 $bbcode[0][] = "#<a[^>]*href=['|\"](ftp://)(.*?)['|\"][^>]*>(.*?)</a>#si";

    91. 

  91.                 $bbcode[1][] = "[ftp=$1$2]$3[/ftp]";

    92. 

  92. 

    93. 

  93.                 //pattens to run in end

    94. 

  94.                 $bbcode[2][] = '#<table[^>]*>(.*?)<\/table>#si';

    95. 

  95.                 $bbcode[3][] = '[table]$1[/table]';

    96. 

  96. 

    97. 

  97.                 $bbcode[2][] = '#<tr[^>]*>(.*?)<\/tr>#si';

    98. 

  98.                 $bbcode[3][] = '[tr]$1[/tr]';

    99. 

  99. 

    100. 

  100.                 $bbcode[2][] = '#<td[^>]*>(.*?)<\/td>#si';

    101. 

  101.                 $bbcode[3][] = '[td]$1[/td]';

    102. 

  102. 

    103. 

  103.                 $bbcode[2][] = '#<strong[^>]*>(.*?)<\/strong>#si';

    104. 

  104.                 $bbcode[3][] = '[b]$1[/b]';

    105. 

  105. 

    106. 

  106.                 $bbcode[2][] = '#<(strike|s)>(.*?)<\/\\1>#sim';

    107. 

  107.                 $bbcode[3][] = '[s]$2[/s]';

    108. 

  108.             }

    109. 

  109. 

    110. 

  110.             $options = array();

    111. 

  111.             $options['bbcode_patterns'] = $bbcode;

    112. 

  112.             JFusionFunction::parseCode($text,'bbcode',$options);

    113. 

  113.         } elseif ($for == 'joomla' || ($for == 'activity' && $params->get('parse_text') == 'html')) {

    114. 

  114.             $options = array();

    115. 

  115.             //convert smilies so they show up in Joomla as images

    116. 

  116.             static $custom_smileys;

    117. 

  117.             if (!is_array($custom_smileys)) {

    118. 

  118.                 $custom_smileys = array();

    119. 

  119.                 $db =& JFusionFactory::getDatabase($this->getJname());

    120. 

  120.                 $query = "SELECT value, variable FROM #__settings WHERE variable = 'smileys_url' OR variable = 'smiley_sets_default'";

    121. 

  121.                 $db->setQuery($query);

    122. 

  122.                 $settings = $db->loadObjectList('variable');

    123. 

  123. 

    124. 

  124.                 $query = "SELECT code, filename FROM #__smileys ORDER BY smileyOrder";

    125. 

  125.                 $db->setQuery($query);

    126. 

  126.                 $smilies = $db->loadObjectList();

    127. 

  127. 

    128. 

  128.                 if(!empty($smilies)) {

    129. 

  129.                     foreach($smilies as $s) {

    130. 

  130.                         $custom_smileys[$s->code] = "{$settings['smileys_url']->value}/{$settings['smiley_sets_default']->value}/{$s->filename}";

    131. 

  131.                     }

    132. 

  132.                 }

    133. 

  133.             }

    134. 

  134.             $options['custom_smileys'] = $custom_smileys;

    135. 

  135.             $options['parse_smileys'] = true;

    136. 

  136.             //parse bbcode to html

    137. 

  137.             if (!empty($params) && $params->get('character_limit', false)) {

    138. 

  138.                 $status['limit_applied'] = 1;

    139. 

  139.                 $options['character_limit'] = $params->get('character_limit');

    140. 

  140.             }

    141. 

  141. 

    142. 

  142.             //add smf bbcode rules

    143. 

  143.             $options['html_patterns'] = array();

    144. 

  144.             $options['html_patterns']['li'] = array('simple_start' => "<li>", 'simple_end' => "</li>\n", 'class' => 'listitem', 'allow_in' => array('list'), 'end_tag' => 0, 'before_tag' => "s", 'after_tag' => "s", 'before_endtag' => "sns", 'after_endtag' => "sns", 'plain_start' => "\n * ", 'plain_end' => "\n");

    145. 

  145. 

    146. 

  146.             $bbcodes = array('size', 'glow', 'shadow', 'move', 'pre', 'hr', 'flash', 'ftp', 'table', 'tr', 'td', 'tt', 'abbr', 'anchor', 'black', 'blue', 'green', 'iurl', 'html', 'ltr', 'me', 'nobbc', 'php', 'red', 'rtl', 'time', 'white', 'o', 'O', '0', '@', '*', '=', '@', '+', 'x', '#');

    147. 

  147. 

    148. 

  148.             foreach($bbcodes as $bb) {

    149. 

  149.                 if (in_array($bb, array('ftp', 'iurl'))) {

    150. 

  150.                     $class = 'link';

    151. 

  151.                 } elseif (in_array($bb, array('o', 'O', '0', '@', '*', '=', '@', '+', 'x', '#'))) {

    152. 

  152.                     $class = 'listitem';

    153. 

  153.                 } elseif ($bb == 'table') {

    154. 

  154.                     $class = 'table';

    155. 

  155.                 } else {

    156. 

  156.                     $class = 'inline';

    157. 

  157.                 }

    158. 

  158. 

    159. 

  159.                 if (in_array($bb, array('o', 'O', '0', '@', '*', '=', '@', '+', 'x', '#'))) {

    160. 

  160.                     $allow_in = array('list');

    161. 

  161.                 } elseif (in_array($bb, array('td', 'tr'))) {

    162. 

  162.                     $allow_in = array('table');

    163. 

  163.                 } else {

    164. 

  164.                     $allow_in = array('listitem', 'block', 'columns', 'inline', 'link');

    165. 

  165.                 }

    166. 

  166. 

    167. 

  167.                 $options['html_patterns'][$bb] = array('mode' => 1, 'content' => 0, 'method' => array($this, 'parseCustomBBCode'), 'class' => $class, 'allow_in' => $allow_in);

    168. 

  168.             }

    169. 

  169. 

    170. 

  170.             JFusionFunction::parseCode($text,'html',$options);

    171. 

  171.         } elseif ($for == 'search') {

    172. 

  172.             JFusionFunction::parseCode($text, 'plaintext');

    173. 

  173.         } elseif ($for == 'activity') {

    174. 

  174.             if ($params->get('parse_text') == 'plaintext') {

    175. 

  175.                 $options = array();

    176. 

  176.                 $options['plaintext_line_breaks'] = 'space';

    177. 

  177.                 if ($params->get('character_limit')) {

    178. 

  178.                     $status['limit_applied'] = 1;

    179. 

  179.                     $options['character_limit'] = $params->get('character_limit');

    180. 

  180.                 }

    181. 

  181.                 JFusionFunction::parseCode($text, 'plaintext', $options);

    182. 

  182.             }

    183. 

  183.         }

    184. 

  184. 

    185. 

  185.         return $status;

    186. 

  186.     }

    187. 

  187. 

    188. 

  188. 	function getBuffer(&$data)

    189. 

  189. 	{

    190. 

  190. 		$action = JRequest::getVar('action');

    191. 

  191. 		$params = JFusionFactory::getParams($this->getJname());

    192. 

  192. 		if ($action=='logout') {

    193. 

  193. 			$mainframe = &JFactory::getApplication();

    194. 

  194. 

    195. 

  195. 	        // logout any joomla users

    196. 

  196.         	$mainframe->logout();

    197. 

  197. 

    198. 

  198. 	        // clean up session

    199. 

  199.         	$session =& JFactory::getSession();

    200. 

  200.         	$session->close();

    201. 

  201. 

    202. 

  202. 			JFusionFunction::addCookie($params->get('cookie_name'), '',0,$params->get('cookie_path'),$params->get('cookie_domain'),$params->get('secure'),$params->get('httponly'));

    203. 

  203. 

    204. 

  204. 			$mainframe->redirect(str_replace('&amp;', '&', $data->baseURL));

    205. 

  205.         	exit();

    206. 

  206. 		}

    207. 

  207. 

    208. 

  208. 		// We're going to want a few globals... these are all set later.

    209. 

  209. 		global $time_start, $maintenance, $msubject, $mmessage, $mbname, $language;

    210. 

  210. 		global $boardurl, $boarddir, $sourcedir, $webmaster_email, $cookiename;

    211. 

  211. 		global $db_connection, $db_server, $db_name, $db_user, $db_prefix, $db_persist, $db_error_send, $db_last_error;

    212. 

  212. 		global $modSettings, $context, $sc, $user_info, $topic, $board, $txt;

    213. 

  213. 		global $scripturl, $ID_MEMBER, $func;

    214. 

  214. 

    215. 

  215. 	    global $settings, $options, $board_info, $attachments, $messages_request ,$memberContext, $db_character_set;

    216. 

  216. 

    217. 

  217. 		// new in smf 2

    218. 

  218. 		global $smcFunc, $mysql_set_mode,$cachedir,$db_passwd,$db_type, $ssi_db_user, $ssi_db_passwd,$board_info, $options;

    219. 

  219. 

    220. 

  220. 		// Required to avoid a warning about a license violation even though this is not the case

    221. 

  221. 		global $forum_version;

    222. 

  222. 

    223. 

  223. 		// Get the path

    224. 

  224. 		$source_path = $params->get('source_path');

    225. 

  225. 

    226. 

  226. 		if (substr($source_path, -1) == DS) {

    227. 

  227. 			$index_file = $source_path .'index.php';

    228. 

  228. 		} else {

    229. 

  229. 			$index_file = $source_path .DS.'index.php';

    230. 

  230. 		}

    231. 

  231. 

    232. 

  232. 		if ( ! is_file($index_file) ) {

    233. 

  233. 			JError::raiseWarning(500, 'The path to the SMF index file set in the component preferences does not exist');

    234. 

  234. 			return null;

    235. 

  235. 		}

    236. 

  236. 

    237. 

  237. 		//set the current directory to SMF

    238. 

  238. 		chdir($source_path);

    239. 

  239. 		$this->callbackdata = $data;

    240. 

  240. 		$this->callbackbypass = false;

    241. 

  241. 

    242. 

  242. 		// Get the output

    243. 

  243. 		ob_start(array($this, 'callback'));

    244. 

  244. 		$h = ob_list_handlers();

    245. 

  245. 		$rs = include_once($index_file);

    246. 

  246. 		// die if popup

    247. 

  247. 		if ( $action == 'findmember' || $action == 'helpadmin' || $action == 'spellcheck' || $action == 'requestmembers' || strpos($action ,'xml') !== false ) {

    248. 

  248. 			exit();

    249. 

  249. 		} else {

    250. 

  250. 			$this->callbackbypass = true;

    251. 

  251. 		}

    252. 

  252. 		while( in_array( get_class($this).'::callback' , $h) ) {

    253. 

  253. 			$data->buffer .= ob_get_contents();

    254. 

  254. 			ob_end_clean();

    255. 

  255. 			$h = ob_list_handlers();

    256. 

  256. 		}

    257. 

  257. 

    258. 

  258. 		//change the current directory back to Joomla.

    259. 

  259. 		chdir(JPATH_SITE);

    260. 

  260. 

    261. 

  261. 		// Log an error if we could not include the file

    262. 

  262. 		if (!$rs) {

    263. 

  263. 			JError::raiseWarning(500, 'Could not find SMF in the specified directory');

    264. 

  264. 		}

    265. 

  265. 	}

    266. 

  266. 

    267. 

  267. 	function parseBody(&$data)

    268. 

  268. 	{

    269. 

  269. 		$regex_body		= array();

    270. 

  270. 		$replace_body	= array();

    271. 

  271. 

    272. 

  272. 		//fix for form actions

    273. 

  273. 		$regex_body[]	= '#action="'.$data->integratedURL.'index.php(.*?)"(.*?)>#me';

    274. 

  274. 		$replace_body[]	= '$this->fixAction("index.php$1","$2","' . $data->baseURL .'")';

    275. 

  275. 

    276. 

  276. 		$regex_body[]	= '#href="'.$data->integratedURL.'index.php(.*?)"#Sise';

    277. 

  277. 		$replace_body[] = '\'href="\'.$this->fixUrl("index.php$1","'.$data->baseURL.'","'.$data->fullURL.'").\'"\'';

    278. 

  278. 

    279. 

  279. 		$regex_body[]	= '#href="\#(.*?)"#Sise';

    280. 

  280. 		$replace_body[] = '\'href="\'.$this->fixUrl("#$1","'.$data->baseURL.'","'.$data->fullURL.'").\'"\'';

    281. 

  281. 

    282. 

  282. 		$regex_body[]	= '#sScriptUrl: \'http://joomla.fanno.dk/smf2/index.php\'#mSsi';

    283. 

  283. 		$replace_body[]	= 'sScriptUrl: \''.$data->baseURL.'\'';

    284. 

  284. 

    285. 

  285. 		// Chaptcha fix

    286. 

  286. 		$regex_body[]	= '#\"'.$data->integratedURL.'(index.php\?)(action=verificationcode;vid=register;rand=)(.*?)\"#sie';

    287. 

  287. 		$replace_body[]	= '\'"\'.$this->fixUrl("index.php?$2$3","'.$data->baseURL.'","'.$data->fullURL.'").\'"\'';

    288. 

  288. 

    289. 

  289. 		$data->body = preg_replace($regex_body, $replace_body, $data->body);

    290. 

  290. 	}

    291. 

  291. 

    292. 

  292. 	function parseHeader(&$data)

    293. 

  293. 	{

    294. 

  294. 		static $regex_header, $replace_header;

    295. 

  295. 		if ( ! $regex_header || ! $replace_header )

    296. 

  296. 		{

    297. 

  297. 			$params = JFusionFactory::getParams('joomla_int');

    298. 

  298. 			$joomla_url = $params->get('source_url');

    299. 

  299. 

    300. 

  300. 			$baseURLnoSef = 'index.php?option=com_jfusion&Itemid=' . JRequest::getInt('Itemid');

    301. 

  301. 			if (substr($joomla_url, -1) == '/') $baseURLnoSef = $joomla_url . $baseURLnoSef;

    302. 

  302. 			else $baseURLnoSef = $joomla_url . '/' . $baseURLnoSef;

    303. 

  303. 

    304. 

  304. 			// Define our preg arrays

    305. 

  305. 			$regex_header		= array();

    306. 

  306. 			$replace_header	= array();

    307. 

  307. 

    308. 

  308. 			//convert relative links into absolute links

    309. 

  309. 			$regex_header[]	= '#(href|src)=("./|"/)(.*?)"#mS';

    310. 

  310. 			$replace_header[]	= '$1="'.$data->integratedURL.'$3"';

    311. 

  311. 

    312. 

  312. 			//$regex_header[]	= '#(href|src)="(.*)"#mS';

    313. 

  313. 			//$replace_header[]	= 'href="'.$data->integratedURL.'$2"';

    314. 

  314. 

    315. 

  315. 			//convert relative links into absolute links

    316. 

  316. 			$regex_header[]	= '#(href|src)=("./|"/)(.*?)"#mS';

    317. 

  317. 			$replace_header[]	= '$1="'.$data->integratedURL.'$3"';

    318. 

  318. 

    319. 

  319. 			$regex_header[] = '#var smf_scripturl = ["|\'](.*?)["|\'];#mS';

    320. 

  320. 			$replace_header[] = 'var smf_scripturl = "'.$baseURLnoSef.'&";';

    321. 

  321. 

    322. 

  322.             //fix for URL redirects

    323. 

  323.             $regex_header[] = '#<meta http-equiv="refresh" content="(.*?)"(.*?)>#me';

    324. 

  324.             $replace_header[] = '$this->fixRedirect("$1","' . $data->baseURL . '")';

    325. 

  325. 		}

    326. 

  326. 		$data->header = preg_replace($regex_header, $replace_header, $data->header);

    327. 

  327. 	}

    328. 

  328. 

    329. 

  329. 	function fixUrl($q='',$baseURL,$fullURL)

    330. 

  330. 	{

    331. 

  331.         //SMF uses semi-colons to seperate vars as well. Convert these to normal ampersands

    332. 

  332.         $q = str_replace(';','&amp;',$q);

    333. 

  333. 

    334. 

  334.         if ( strpos($q,'#') === 0 ) return $fullURL.$q;

    335. 

  335. 

    336. 

  336.         if (substr($baseURL, -1) != '/'){

    337. 

  337. 			//non sef URls

    338. 

  338. 			$q = str_replace('?', 	'&amp;', $q);

    339. 

  339. 			$url = $baseURL . '&amp;jfile=' .$q;

    340. 

  340.         } else {

    341. 

  341. 			$params = JFusionFactory::getParams($this->getJname());

    342. 

  342. 			$sefmode = $params->get('sefmode');

    343. 

  343. 			if ($sefmode==1) {

    344. 

  344. 				$url =  JFusionFunction::routeURL($q, JRequest::getInt('Itemid'));

    345. 

  345. 			} else {

    346. 

  346. 				//we can just append both variables

    347. 

  347. 				$url = $baseURL . $q;

    348. 

  348. 			}

    349. 

  349. 		}

    350. 

  350. 		return $url;

    351. 

  351. 	}

    352. 

  352. 

    353. 

  353. 	function fixAction($url, $extra, $baseURL)

    354. 

  354. 	{

    355. 

  355. 		//JError::raiseWarning(500, $url);

    356. 

  356. 		$url = htmlspecialchars_decode($url);

    357. 

  357. 		$Itemid = JRequest::getInt('Itemid');

    358. 

  358. 

    359. 

  359. 		$extra = stripslashes( $extra );

    360. 

  360. 		$url = str_replace(';','&amp;',$url);

    361. 

  361. 		if (substr($baseURL, -1) != '/'){

    362. 

  362. 			//non-SEF mode

    363. 

  363. 		  	$url_details = parse_url($url);

    364. 

  364. 		  	$url_variables = array();

    365. 

  365. 		 	$jfile = basename($url_details['path']);

    366. 

  366. 		 	if ( isset($url_details['query']) ) {

    367. 

  367. 				parse_str($url_details['query'], $url_variables);

    368. 

  368. 				$baseURL .= '&amp;'.$url_details['query'];

    369. 

  369. 		 	}

    370. 

  370. 		  	//set the correct action and close the form tag

    371. 

  371. 			$replacement = 'action="'.$baseURL . '"' . $extra . '>';

    372. 

  372. 			$replacement .= '<input type="hidden" name="jfile" value="'. $jfile . '"/>';

    373. 

  373. 			$replacement .= '<input type="hidden" name="Itemid" value="'.$Itemid . '"/>';

    374. 

  374. 		  	$replacement .= '<input type="hidden" name="option" value="com_jfusion"/>';

    375. 

  375. 		} else {

    376. 

  376. 			//check to see what SEF mode is selected

    377. 

  377. 		    $params = JFusionFactory::getParams($this->getJname());

    378. 

  378. 		    $sefmode = $params->get('sefmode');

    379. 

  379. 		    if ($sefmode==1) {

    380. 

  380. 		    	//extensive SEF parsing was selected

    381. 

  381. 			  	$url =  JFusionFunction::routeURL($url, $Itemid);

    382. 

  382. 				$replacement = 'action="'.$url . '"' . $extra . '>';

    383. 

  383. 				return $replacement;

    384. 

  384. 			} else {

    385. 

  385. 				//simple SEF mode

    386. 

  386. 		      	$url_details = parse_url($url);

    387. 

  387. 			  	$url_variables = array();

    388. 

  388. 		 		$jfile = basename($url_details['path']);

    389. 

  389. 		 		if ( isset($url_details['query']) ) {

    390. 

  390. 		 			parse_str($url_details['query'], $url_variables);

    391. 

  391. 					$jfile .= '?'.$url_details['query'];

    392. 

  392. 		 		}

    393. 

  393. 				$replacement = 'action="'.$baseURL . $jfile.'"' . $extra . '>';

    394. 

  394. 			}

    395. 

  395. 		}

    396. 

  396. 		unset($url_variables['option'],$url_variables['jfile'],$url_variables['Itemid']);

    397. 

  397. 

    398. 

  398. 		//add any other variables

    399. 

  399. /* Commented out because of problems with wrong variables being set

    400. 

  400. 		if(is_array($url_variables)){

    401. 

  401. 	 		foreach ($url_variables as $key => $value){

    402. 

  402. 				$replacement .=  '<input type="hidden" name="'. $key .'" value="'.$value . '"/>';

    403. 

  403.   			}

    404. 

  404. 		}

    405. 

  405. */

    406. 

  406.   		return $replacement;

    407. 

  407. 	}

    408. 

  408. 

    409. 

  409.     function fixRedirect($url, $baseURL) {

    410. 

  410.         //JError::raiseWarning(500, $url);

    411. 

  411.         //split up the timeout from url

    412. 

  412.         $parts = explode(';url=', $url);

    413. 

  413.         $timeout = $parts[0];

    414. 

  414.         $uri = new JURI($parts[1]);

    415. 

  415.         $jfile = $uri->getPath();

    416. 

  416.         $jfile = basename($jfile);

    417. 

  417.         $query = $uri->getQuery(false);

    418. 

  418.         $fragment = $uri->getFragment();

    419. 

  419.         if (substr($baseURL, -1) != '/') {

    420. 

  420.             //non-SEF mode

    421. 

  421.             $redirectURL = $baseURL . '&amp;jfile=' . $jfile;

    422. 

  422.             if (!empty($query)) {

    423. 

  423.                 $redirectURL.= '&amp;' . $query;

    424. 

  424.             }

    425. 

  425.         } else {

    426. 

  426.             //check to see what SEF mode is selected

    427. 

  427.             $params = JFusionFactory::getParams($this->getJname());

    428. 

  428.             $sefmode = $params->get('sefmode');

    429. 

  429.             if ($sefmode == 1) {

    430. 

  430.                 //extensive SEF parsing was selected

    431. 

  431.                 $redirectURL = $jfile;

    432. 

  432.                 if (!empty($query)) {

    433. 

  433.                     $redirectURL.= '?' . $query;

    434. 

  434.                 }

    435. 

  435.                 $redirectURL = JFusionFunction::routeURL($redirectURL, JRequest::getInt('Itemid'));

    436. 

  436.             } else {

    437. 

  437.                 //simple SEF mode, we can just combine both variables

    438. 

  438.                 $redirectURL = $baseURL . $jfile;

    439. 

  439.                 if (!empty($query)) {

    440. 

  440.                     $redirectURL.= '?' . $query;

    441. 

  441.                 }

    442. 

  442.             }

    443. 

  443.         }

    444. 

  444.         if (!empty($fragment)) {

    445. 

  445.             $redirectURL .= "#$fragment";

    446. 

  446.         }

    447. 

  447.         $return = '<meta http-equiv="refresh" content="' . $timeout . ';url=' . $redirectURL . '">';

    448. 

  448.         //JError::raiseWarning(500, htmlentities($return));

    449. 

  449.         return $return;

    450. 

  450.     }

    451. 

  451. 

    452. 

  452. 	function getPathWay()

    453. 

  453. 	{

    454. 

  454. 		$db = JFusionFactory::getDatabase($this->getJname());

    455. 

  455. 		$pathway = array();

    456. 

  456. 

    457. 

  457. 		list ($board_id ) = split  ( '.'  , JRequest::getVar('board'),1 );

    458. 

  458. 		list ($topic_id ) = split  ( '.'  , JRequest::getVar('topic'),1 );

    459. 

  459. 		list ($action ) = split  ( ';'  , JRequest::getVar('action'),1 );

    460. 

  460. 

    461. 

  461. 		$msg = JRequest::getVar('msg');

    462. 

  462. 

    463. 

  463.         $query = 'SELECT id_topic,id_board, subject '.

    464. 

  464.         		'FROM #__messages '.

    465. 

  465.         		'WHERE id_topic = ' . $db->Quote($topic_id);

    466. 

  466.         $db->setQuery($query );

    467. 

  467.         $topic = $db->loadObject();

    468. 

  468. 

    469. 

  469.         if ($topic) {

    470. 

  470. 			$board_id = $topic->id_board;

    471. 

  471.         }

    472. 

  472. 

    473. 

  473. 		if ($board_id) {

    474. 

  474. 			$boards = array();

    475. 

  475. 			// Loop while the parent is non-zero.

    476. 

  476. 			while ($board_id != 0)

    477. 

  477. 			{

    478. 

  478. 		        $query = 'SELECT b.id_parent , b.id_board, b.id_cat, b.name , c.name as catname '.

    479. 

  479. 		        		'FROM #__boards AS b INNER JOIN #__categories AS c ON b.id_cat = c.id_cat '.

    480. 

  480. 		        		'WHERE id_board = ' . $db->Quote($board_id);

    481. 

  481. 		        $db->setQuery($query );

    482. 

  482. 		        $result = $db->loadObject();

    483. 

  483. 

    484. 

  484. 				$board_id = 0;

    485. 

  485. 		 		if ($result) {

    486. 

  486. 		 			$board_id = $result->id_parent;

    487. 

  487. 		 			$boards[] = $result;

    488. 

  488. 				}

    489. 

  489. 			}

    490. 

  490. 			$boards = array_reverse($boards);

    491. 

  491. 			$cat_id = 0;

    492. 

  492. 			foreach($boards as $board) {

    493. 

  493. 				$path = new stdClass();

    494. 

  494. 				if ( $board->id_cat != $cat_id ) {

    495. 

  495. 					$cat_id = $board->id_cat;

    496. 

  496. 					$path->title = $board->catname;

    497. 

  497. 					$path->url = 'index.php#'.$board->id_cat;

    498. 

  498. 					$pathway[] = $path;

    499. 

  499. 

    500. 

  500. 					$path = new stdClass();

    501. 

  501. 					$path->title = $board->name;

    502. 

  502. 					$path->url = 'index.php?board='.$board->id_board.'.0';

    503. 

  503. 				} else {

    504. 

  504. 					$path->title = $board->name;

    505. 

  505. 					$path->url = 'index.php?board='.$board->id_board.'.0';

    506. 

  506. 				}

    507. 

  507. 				$pathway[] = $path;

    508. 

  508. 			}

    509. 

  509. 		}

    510. 

  510. 		switch ($action) {

    511. 

  511. 		    case 'post':

    512. 

  512. 		    	$path = new stdClass();

    513. 

  513. 		    	if ( JRequest::getVar('board') ) {

    514. 

  514. 					$path->title = 'Modify Toppic ( Start new topic )';

    515. 

  515. 					$path->url = 'index.php?action=post&board='.$board_id.'.0';;

    516. 

  516. 		    	} else if ( $msg ) {

    517. 

  517. 					$path->title = 'Modify Toppic ( '.$topic->subject.' )';

    518. 

  518. 					$path->url = 'index.php?action=post&topic='.$topic_id.'.msg'.$msg.'#msg'.$msg;

    519. 

  519. 		    	} else {

    520. 

  520. 					$path->title = 'Post reply ( Re: '.$topic->subject.' )';

    521. 

  521. 					$path->url = 'index.php?action=post&topic='.$topic_id;

    522. 

  522. 		    	}

    523. 

  523. 				$pathway[] = $path;

    524. 

  524. 		        break;

    525. 

  525. 			case 'pm':

    526. 

  526. 				$path = new stdClass();

    527. 

  527. 				$path->title = 'Personal Messages';

    528. 

  528. 				$path->url = 'index.php?action=pm';

    529. 

  529. 				$pathway[] = $path;

    530. 

  530. 

    531. 

  531. 				$path = new stdClass();

    532. 

  532. 				if ( JRequest::getVar('sa')=='send' ) {

    533. 

  533. 					$path->title = 'New Message';

    534. 

  534. 					$path->url = 'index.php?action=pm&sa=send';

    535. 

  535. 					$pathway[] = $path;

    536. 

  536. 				} elseif ( JRequest::getVar('sa')=='search' ) {

    537. 

  537. 					$path->title = 'Search Messages';

    538. 

  538. 					$path->url = 'index.php?action=pm&sa=search';

    539. 

  539. 					$pathway[] = $path;

    540. 

  540. 				} elseif ( JRequest::getVar('sa')=='prune' ) {

    541. 

  541. 					$path->title = 'Prune Messages';

    542. 

  542. 					$path->url = 'index.php?action=pm&sa=prune';

    543. 

  543. 					$pathway[] = $path;

    544. 

  544. 				} elseif ( JRequest::getVar('sa')=='manlabels' ) {

    545. 

  545. 					$path->title = 'Manage Labels';

    546. 

  546. 					$path->url = 'index.php?action=pm&sa=manlabels';

    547. 

  547. 					$pathway[] = $path;

    548. 

  548. 				} elseif ( JRequest::getVar('f')=='outbox' ) {

    549. 

  549. 					$path->title = 'Outbox';

    550. 

  550. 					$path->url = 'index.php?action=pm&f=outbox';

    551. 

  551. 					$pathway[] = $path;

    552. 

  552. 				} else {

    553. 

  553. 					$path->title = 'Inbox';

    554. 

  554. 					$path->url = 'index.php?action=pm';

    555. 

  555. 					$pathway[] = $path;

    556. 

  556. 				}

    557. 

  557. 		        break;

    558. 

  558. 			case 'search2':

    559. 

  559. 				$path = new stdClass();

    560. 

  560. 				$path->title = 'Search';

    561. 

  561. 				$path->url = 'index.php?action=search';

    562. 

  562. 				$pathway[] = $path;

    563. 

  563. 				$path = new stdClass();

    564. 

  564. 				$path->title = 'Search Results';

    565. 

  565. 				$path->url = 'index.php?action=search';

    566. 

  566. 				$pathway[] = $path;

    567. 

  567. 				break;

    568. 

  568. 			case 'search':

    569. 

  569. 				$path = new stdClass();

    570. 

  570. 				$path->title = 'Search';

    571. 

  571. 				$path->url = 'index.php?action=search';

    572. 

  572. 				$pathway[] = $path;

    573. 

  573. 				break;

    574. 

  574. 			case 'unread':

    575. 

  575. 				$path = new stdClass();

    576. 

  576. 				$path->title = 'Recent Unread Topics';

    577. 

  577. 				$path->url = 'index.php?action=unread';

    578. 

  578. 				$pathway[] = $path;

    579. 

  579. 				break;

    580. 

  580. 			case 'unreadreplies':

    581. 

  581. 				$path = new stdClass();

    582. 

  582. 				$path->title = 'Updated Topics';

    583. 

  583. 				$path->url = 'index.php?action=unreadreplies';

    584. 

  584. 				$pathway[] = $path;

    585. 

  585. 				break;

    586. 

  586. 			default:

    587. 

  587. 				if ( $topic_id ) {

    588. 

  588. 					$path = new stdClass();

    589. 

  589. 					$path->title = $topic->subject;

    590. 

  590. 					$path->url = 'index.php?topic='.$topic_id;

    591. 

  591. 					$pathway[] = $path;

    592. 

  592. 				}

    593. 

  593. 		}

    594. 

  594. 		return $pathway;

    595. 

  595. 	}

    596. 

  596. 

    597. 

  597.     function getPrivateMessageCounts($userid)

    598. 

  598.     {

    599. 

  599.         if ($userid) {

    600. 

  600. 

    601. 

  601.             // initialise some objects

    602. 

  602.             $db = JFusionFactory::getDatabase($this->getJname());

    603. 

  603. 

    604. 

  604.             // read unread count

    605. 

  605.             $db->setQuery('SELECT unreadMessages FROM #__members WHERE id_member = '.$userid);

    606. 

  606.             $unreadCount = $db->loadResult();

    607. 

  607. 

    608. 

  608.             // read total pm count

    609. 

  609.             $db->setQuery('SELECT instantMessages FROM #__members WHERE id_member = '.$userid);

    610. 

  610.             $totalCount = $db->loadResult();

    611. 

  611. 

    612. 

  612.             return array('unread' => $unreadCount, 'total' => $totalCount);

    613. 

  613.         }

    614. 

  614.         return array('unread' => 0, 'total' => 0);

    615. 

  615.     }

    616. 

  616. 

    617. 

  617. 	function getAvatar($puser_id)

    618. 

  618.     {

    619. 

  619. 		if ($puser_id) {

    620. 

  620. 			// Get SMF Params and get an instance of the database

    621. 

  621. 			$params = JFusionFactory::getParams($this->getJname());

    622. 

  622. 			$db = JFusionFactory::getDatabase($this->getJname());

    623. 

  623. 			// Load member params from database "mainly to get the avatar"

    624. 

  624. 			$db->setQuery('SELECT * FROM #__members WHERE id_member='.$puser_id);

    625. 

  625. 			$db->query();

    626. 

  626. 			$result = $db->loadObject();

    627. 

  627. 

    628. 

  628. 			if (!empty($result)) {

    629. 

  629. 				$url = '';

    630. 

  630. 				// SMF has a wierd way of holding attachments. Get instance of the attachments table

    631. 

  631. 				$db->setQuery('SELECT * FROM #__attachments WHERE id_member='.$puser_id);

    632. 

  632. 				$db->query();

    633. 

  633. 				$attachment = $db->loadObject();

    634. 

  634. 				// See if the user has a specific attachment ment for an avatar

    635. 

  635. 				if(!empty($attachment) && $attachment->id_thumb == 0 && $attachment->id_msg == 0 && empty($result->avatar)) {

    636. 

  636. 					$url = $params->get('source_url').'index.php?action=dlattach;attach='.$attachment->id_attach.';type=avatar';

    637. 

  637. 				// If user didnt, check to see if the avatar specified in the first query is a url. If so use it.

    638. 

  638. 				} else if(preg_match("/http(s?):\/\//",$result->avatar)){

    639. 

  639. 					$url = $result->avatar;

    640. 

  640. 				} else if($result->avatar) {

    641. 

  641. 					// If the avatar specified in the first query is not a url but is a file name. Make it one

    642. 

  642. 					$db->setQuery('SELECT * FROM #__settings WHERE variable = "avatar_url"');

    643. 

  643. 					$avatarurl = $db->loadObject();

    644. 

  644. 					// Check for trailing slash. If there is one DONT ADD ONE!

    645. 

  645. 					if(substr($avatarurl->value, -1) == DS){

    646. 

  646. 						$url = $avatarurl->value.$result->avatar;

    647. 

  647. 					// I like redundancy. Recheck to see if there isnt a trailing slash. If there isnt one, add one.

    648. 

  648. 					} else if(substr($avatarurl->value, -1) !== DS){

    649. 

  649. 						$url = $avatarurl->value."/".$result->avatar;

    650. 

  650. 					}

    651. 

  651. 				}

    652. 

  652. 

    653. 

  653. 				return $url;

    654. 

  654. 			}

    655. 

  655. 		}

    656. 

  656. 	}

    657. 

  657. 

    658. 

  658. 	/************************************************

    659. 

  659. 	 * For JFusion Search Plugin

    660. 

  660. 	 ***********************************************/

    661. 

  661. 	function getSearchQueryColumns()

    662. 

  662. 	{

    663. 

  663. 		$columns = new stdClass();

    664. 

  664. 		$columns->title = "p.subject";

    665. 

  665. 		$columns->text = "p.body";

    666. 

  666. 		return $columns;

    667. 

  667. 	}

    668. 

  668. 

    669. 

  669. 	function getSearchQuery(&$pluginParam)

    670. 

  670. 	{

    671. 

  671. 		//need to return threadid, postid, title, text, created, section

    672. 

  672. 		$query = 'SELECT p.id_topic, p.id_msg, p.id_board, CASE WHEN p.subject = "" THEN CONCAT("Re: ",fp.subject) ELSE p.subject END AS title, p.body AS text,

    673. 

  673. 					FROM_UNIXTIME(p.poster_time, "%Y-%m-%d %h:%i:%s") AS created,

    674. 

  674. 					CONCAT_WS( "/", f.name, fp.subject ) AS section,

    675. 

  675. 					t.num_views as hits

    676. 

  676. 					FROM #__messages AS p

    677. 

  677. 					INNER JOIN #__topics AS t ON t.id_topic = p.id_topic

    678. 

  678. 					INNER JOIN #__messages AS fp ON fp.id_msg = t.id_first_msg

    679. 

  679. 					INNER JOIN #__boards AS f on f.id_board = p.id_board';

    680. 

  680. 		return $query;

    681. 

  681. 	}

    682. 

  682. 

    683. 

  683. 	/**

    684. 

  684. 	 * Add on a plugin specific clause;

    685. 

  685.      * @param object &$pluginParam custom plugin parameters in search.xml

    686. 

  686. 	 * @param $where reference to where clause already generated by search bot; add on plugin specific criteria

    687. 

  687. 	 */

    688. 

  688. 	function getSearchCriteria(&$where, &$pluginParam, $ordering)

    689. 

  689. 	{

    690. 

  690.         $db = JFusionFactory::getDatabase($this->getJname());

    691. 

  691. 

    692. 

  692. 		$userPlugin = JFusionFactory::getUser($this->getJname());

    693. 

  693. 

    694. 

  694. 		$user =& JFactory::getUser();

    695. 

  695. 		$userid = $user->get('id');

    696. 

  696. 

    697. 

  697. 		if ($userid) {

    698. 

  698. 			$userlookup = JFusionFunction::lookupUser($this->getJname(),$userid,true);

    699. 

  699. 			$existinguser = $userPlugin->getUser($userlookup);

    700. 

  700. 			$group_id = $existinguser->group_id;

    701. 

  701. 		} else {

    702. 

  702. 			$group_id = '-1';

    703. 

  703. 		}

    704. 

  704. 

    705. 

  705.         if ($pluginParam->get('forum_mode', 0)) {

    706. 

  706.             $forumids = $pluginParam->get('selected_forums', array());

    707. 

  707.             $selected_boards = " WHERE id_board IN (" . implode(',', $forumids) . ")";

    708. 

  708.         } else {

    709. 

  709.             $selected_boards = '';

    710. 

  710.         }

    711. 

  711. 

    712. 

  712. 		$query = 'SELECT member_groups, id_board FROM #__boards' . $selected_boards;

    713. 

  713. 		$db->setQuery($query);

    714. 

  714.         $boards = $db->loadObjectList();

    715. 

  715. 

    716. 

  716. 		$list = array();

    717. 

  717. 		foreach( $boards as $key => $value ) {

    718. 

  718. 			$member_groups = explode( ',' , $value->member_groups );

    719. 

  719. 			if ( in_array($group_id, $member_groups) || $group_id == 1) {

    720. 

  720. 				$list[] =  $value->id_board;

    721. 

  721. 			}

    722. 

  722. 		}

    723. 

  723.         //determine how to sort the results which is required for accurate results when a limit is placed

    724. 

  724.         switch ($ordering) {

    725. 

  725.              case 'oldest':

    726. 

  726.                 $sort = 'p.poster_time ASC';

    727. 

  727.                 break;

    728. 

  728.             case 'category':

    729. 

  729.                 $sort = 'section ASC';

    730. 

  730.                 break;

    731. 

  731.             case 'popular':

    732. 

  732.                 $sort = 't.num_views DESC, p.poster_time DESC';

    733. 

  733.             case 'alpha':

    734. 

  734.                 $sort = 'title ASC';

    735. 

  735.                 break;

    736. 

  736.             case 'newest':

    737. 

  737.             default:

    738. 

  738.                 $sort = 'p.poster_time DESC';

    739. 

  739.                 break;

    740. 

  740.         }

    741. 

  741. 		$where .= ' AND p.id_board IN ('.implode(',',$list).') ORDER BY ' . $sort;

    742. 

  742. 	}

    743. 

  743. 

    744. 

  744. 	function filterSearchResults(&$results, &$pluginParam)

    745. 

  745. 	{

    746. 

  746. 		$db =& JFusionFactory::getDatabase($this->getJname());

    747. 

  747. 		$query = "SELECT value FROM #__settings WHERE variable='censor_vulgar'";

    748. 

  748. 		$db->setQuery($query);

    749. 

  749. 		$vulgar = $db->loadResult();

    750. 

  750. 

    751. 

  751. 		$db =& JFusionFactory::getDatabase($this->getJname());

    752. 

  752. 		$query = "SELECT value FROM #__settings WHERE variable='censor_proper'";

    753. 

  753. 		$db->setQuery($query);

    754. 

  754. 		$proper = $db->loadResult();

    755. 

  755. 

    756. 

  756. 		$vulgar = explode  ( ',' , $vulgar );

    757. 

  757. 		$proper = explode  ( ',' , $proper );

    758. 

  758. 

    759. 

  759. 		foreach($results as $rkey => $result) {

    760. 

  760. 			foreach( $vulgar as $key => $value ) {

    761. 

  761. 				$results[$rkey]->subject = preg_replace  ( '#\b'.$value.'\b#is' , $proper[$key]  , $result->subject );

    762. 

  762. 				$results[$rkey]->body = preg_replace  ( '#\b'.$value.'\b#is' , $proper[$key]  , $result->body );

    763. 

  763. 			}

    764. 

  764. 		}

    765. 

  765. 	}

    766. 

  766. 

    767. 

  767. 	function getSearchResultLink($post)

    768. 

  768. 	{

    769. 

  769. 		$forum = JFusionFactory::getForum($this->getJname());

    770. 

  770. 		return $forum->getPostURL($post->id_topic,$post->id_msg);

    771. 

  771. 	}

    772. 

  772. 

    773. 

  773.    /************************************************

    774. 

  774. 	 * Functions For JFusion Who's Online Module

    775. 

  775. 	 ***********************************************/

    776. 

  776. 

    777. 

  777. 	/**

    778. 

  778. 	 * Returns a query to find online users

    779. 

  779. 	 * Make sure columns are named as userid, username, username_clean (if applicable), name (of user), and email

    780. 

  780. 	 **/

    781. 

  781. 	function getOnlineUserQuery($limit, $usergroups = '')

    782. 

  782. 	{

    783. 

  783. 		$usergroup_query = "";

    784. 

  784. 		if($usergroups!='') {

    785. 

  785. 			if(is_array($usergroups)) {

    786. 

  786. 				$usergroups = implode(',',$usergroups);

    787. 

  787. 				$usergroup_query .= "AND (u.id_group IN ($usergroups) OR u.id_post_group IN ($usergroups)";

    788. 

  788. 				foreach($usergroups AS $u) {

    789. 

  789. 					$usergroup_query .= " OR FIND_IN_SET(" . intval($u) . ", u.additional_groups)";

    790. 

  790. 				}

    791. 

  791. 				$usergroup_query .= ")";

    792. 

  792. 			} else {

    793. 

  793. 				$usergroup_query .= "AND (u.id_group = $usergroups OR u.id_post_group = $usergroups OR FIND_IN_SET($usergroups, u.additional_groups))";

    794. 

  794. 			}

    795. 

  795. 		}

    796. 

  796. 

    797. 

  797. 		$limiter = (!empty($limit)) ? "LIMIT 0,$limit" : '';

    798. 

  798. 

    799. 

  799. 		return "SELECT DISTINCT u.id_member AS userid, u.member_name AS username, u.real_name AS name, u.email_address as email FROM #__members AS u INNER JOIN #__log_online AS s ON u.id_member = s.id_member WHERE s.id_member != 0 $usergroup_query $limiter";

    800. 

  800. 	}

    801. 

  801. 

    802. 

  802. 	/**

    803. 

  803. 	 * Returns number of guests

    804. 

  804. 	 * @return int

    805. 

  805. 	 */

    806. 

  806. 	function getNumberOnlineGuests()

    807. 

  807. 	{

    808. 

  808. 		$db =& JFusionFactory::getDatabase($this->getJname());

    809. 

  809. 		$query = "SELECT COUNT(DISTINCT(ip)) FROM #__log_online WHERE id_member = 0";

    810. 

  810. 		$db->setQuery($query);

    811. 

  811. 		return $db->loadResult();

    812. 

  812. 	}

    813. 

  813. 

    814. 

  814. 	/**

    815. 

  815. 	 * Returns number of logged in users

    816. 

  816. 	 * @return int

    817. 

  817. 	 */

    818. 

  818. 	function getNumberOnlineMembers($usergroups = '', $total = 1)

    819. 

  819. 	{

    820. 

  820. 		$usergroup_query = "";

    821. 

  821. 		if($usergroups!='' && empty($total)) {

    822. 

  822. 			if(is_array($usergroups)) {

    823. 

  823. 				$usergroups = implode(',',$usergroups);

    824. 

  824. 				$usergroup_query .= "AND (u.id_group IN ($usergroups) OR u.id_post_group IN ($usergroups)";

    825. 

  825. 				foreach($usergroups AS $u) {

    826. 

  826. 					$usergroup_query .= " OR FIND_IN_SET(" . intval($u) . ", u.additional_groups)";

    827. 

  827. 				}

    828. 

  828. 				$usergroup_query .= ")";

    829. 

  829. 			} else {

    830. 

  830. 				$usergroup_query .= "AND (u.id_group = $usergroups OR u.id_post_group = $usergroups OR FIND_IN_SET($usergroups, u.additional_groups))";

    831. 

  831. 			}

    832. 

  832. 		}

    833. 

  833. 

    834. 

  834. 		$db =& JFusionFactory::getDatabase($this->getJname());

    835. 

  835. 		$query = "SELECT COUNT(DISTINCT(l.ip)) FROM #__log_online AS l JOIN #__members AS u ON l.id_member = u.id_member WHERE l.id_member != 0 $usergroup_query";

    836. 

  836. 

    837. 

  837. 		$db->setQuery($query);

    838. 

  838. 		return $db->loadResult();

    839. 

  839. 	}

    840. 

  840. 

    841. 

  841.     function getActivityQuery($usedforums, $result_order, $result_limit)

    842. 

  842.     {

    843. 

  843.         $db = & JFusionFactory::getDatabase($this->getJname());

    844. 

  844. 

    845. 

  845. 		$userPlugin = & JFusionFactory::getUser($this->getJname());

    846. 

  846. 

    847. 

  847. 		$user =& JFactory::getUser();

    848. 

  848. 		$userid = $user->get('id');

    849. 

  849. 

    850. 

  850. 		if ($userid) {

    851. 

  851. 			$userlookup = JFusionFunction::lookupUser($this->getJname(),$userid,true);

    852. 

  852. 			$existinguser = $userPlugin->getUser($userlookup);

    853. 

  853. 			$group_id = $existinguser->group_id;

    854. 

  854. 		} else {

    855. 

  855. 			$group_id = '-1';

    856. 

  856. 		}

    857. 

  857. 

    858. 

  858. 		$query = 'SELECT member_groups, id_board FROM #__boards';

    859. 

  859. 		$db->setQuery($query);

    860. 

  860.         $boards = $db->loadObjectList();

    861. 

  861. 

    862. 

  862. 		$list = array();

    863. 

  863. 		foreach( $boards as $key => $value ) {

    864. 

  864. 			$member_groups = explode( ',' , $value->member_groups );

    865. 

  865. 			if ( in_array($group_id, $member_groups) || $group_id == 1) {

    866. 

  866. 				$list[] =  $value->id_board;

    867. 

  867. 			}

    868. 

  868. 		}

    869. 

  869. 

    870. 

  870.         $where = (!empty($usedforums)) ? ' WHERE b.id_board IN (' . $usedforums .') AND a.id_board IN ('.implode(',',$list).')' : ' WHERE a.id_board IN ('.implode(',',$list).')';

    871. 

  871. 		$end = $result_order." LIMIT 0,".$result_limit;

    872. 

  872. 

    873. 

  873.         $numargs = func_num_args();

    874. 

  874.         if ($numargs > 3) {

    875. 

  875.             $filters = func_get_args();

    876. 

  876.             $i = 3;

    877. 

  877.             for ($i = 3; $i < $numargs; $i++) {

    878. 

  878.                 if ($filters[$i][0] == 'userid') {

    879. 

  879.                     $where.= ' HAVING userid = ' . $db->Quote($filters[$i][1]);

    880. 

  880.                 }

    881. 

  881.             }

    882. 

  882.         }

    883. 

  883. 

    884. 

  884.         //setup the guest where clause to be used in union query

    885. 

  885.         $guest_where = (empty($where)) ? " WHERE b.id_member = 0" : " AND b.id_member = 0";

    886. 

  886. 

    887. 

  887.         $query = array(

    888. 

  888.         //LAT with first post info

    889. 

  889.         LAT . '0' =>

    890. 

  890.         "(SELECT a.id_topic AS threadid, a.id_last_msg AS postid, b.poster_name AS username, d.real_name AS name, b.id_member AS userid, b.subject AS subject, b.poster_time AS dateline, a.id_board as forumid, c.poster_time as last_post_date

    891. 

  891.             FROM `#__topics` as a

    892. 

  892.                 INNER JOIN `#__messages` as b ON a.id_first_msg = b.id_msg

    893. 

  893.                 INNER JOIN `#__messages` as c ON a.id_last_msg = c.id_msg

    894. 

  894.                 INNER JOIN `#__members`  as d ON b.id_member = d.id_member

    895. 

  895.                 $where)

    896. 

  896.         UNION

    897. 

  897.             (SELECT a.id_topic AS threadid, a.id_last_msg AS postid, b.poster_name AS username, b.poster_name AS name, b.id_member AS userid, b.subject AS subject, b.poster_time AS dateline, a.id_board as forumid, c.poster_time as last_post_date

    898. 

  898.             FROM `#__topics` as a

    899. 

  899.                 INNER JOIN `#__messages` as b ON a.id_first_msg = b.id_msg

    900. 

  900.                 INNER JOIN `#__messages` as c ON a.id_last_msg = c.id_msg

    901. 

  901.                 $where $guest_where)

    902. 

  902.         ORDER BY last_post_date $end",

    903. 

  903.         //LAT with latest post info

    904. 

  904.         LAT . '1' =>

    905. 

  905.         "(SELECT a.id_topic AS threadid, a.id_last_msg AS postid, b.poster_name AS username, d.real_name as name, b.id_member AS userid, c.subject AS subject, b.poster_time AS dateline, a.id_board as forumid, b.poster_time as last_post_date

    906. 

  906.             FROM `#__topics` as a

    907. 

  907.                 INNER JOIN `#__messages` as b ON a.id_last_msg = b.id_msg

    908. 

  908.                 INNER JOIN `#__messages` as c ON a.id_first_msg = c.id_msg

    909. 

  909.                 INNER JOIN `#__members`  as d ON b.id_member = d.id_member

    910. 

  910.                 $where)

    911. 

  911.         UNION

    912. 

  912.             (SELECT a.id_topic AS threadid, a.id_last_msg AS postid, b.poster_name AS username, b.poster_name as name, b.id_member AS userid, c.subject AS subject, b.poster_time AS dateline, a.id_board as forumid, b.poster_time as last_post_date

    913. 

  913.             FROM `#__topics` as a

    914. 

  914.                 INNER JOIN `#__messages` as b ON a.id_last_msg = b.id_msg

    915. 

  915.                 INNER JOIN `#__messages` as c ON a.id_first_msg = c.id_msg

    916. 

  916.                 $where $guest_where)

    917. 

  917.         ORDER BY last_post_date $end",

    918. 

  918.         //LCT

    919. 

  919.         LCT =>

    920. 

  920.         "(SELECT a.id_topic AS threadid, b.id_msg AS postid, b.poster_name AS username, d.real_name as name, b.id_member AS userid, b.subject AS subject, b.body, b.poster_time AS dateline, a.id_board as forumid, b.poster_time as topic_date

    921. 

  921.             FROM `#__topics` as a

    922. 

  922.                 INNER JOIN `#__messages` as b ON a.id_first_msg = b.id_msg

    923. 

  923.                 INNER JOIN `#__messages` as c ON a.id_last_msg = c.id_msg

    924. 

  924.                 INNER JOIN `#__members`  as d ON b.id_member = d.id_member

    925. 

  925.                 $where)

    926. 

  926.        UNION

    927. 

  927.             (SELECT a.id_topic AS threadid, b.id_msg AS postid, b.poster_name AS username, b.poster_name as name, b.id_member AS userid, b.subject AS subject, b.body, b.poster_time AS dateline, a.id_board as forumid, b.poster_time as topic_date

    928. 

  928.             FROM `#__topics` as a

    929. 

  929.                 INNER JOIN `#__messages` as b ON a.id_first_msg = b.id_msg

    930. 

  930.                 INNER JOIN `#__messages` as c ON a.id_last_msg = c.id_msg

    931. 

  931.                 $where $guest_where)

    932. 

  932.         ORDER BY topic_date $end",

    933. 

  933.         //LCP

    934. 

  934.         LCP => "

    935. 

  935.         (SELECT b.id_topic AS threadid, b.id_msg AS postid, b.poster_name AS username, d.real_name as name, b.id_member AS userid, b.subject AS subject, b.body, b.poster_time AS dateline, b.id_board as forumid, b.poster_time as last_post_date

    936. 

  936.             FROM `#__messages` as b

    937. 

  937.                 INNER JOIN `#__members`  as d ON b.id_member = d.id_member

    938. 

  938.                 $where)

    939. 

  939.         UNION

    940. 

  940.             (SELECT b.id_topic AS threadid, b.id_msg AS postid, b.poster_name AS username, b.poster_name as name, b.id_member AS userid, b.subject AS subject, b.body, b.poster_time AS dateline, b.id_board as forumid, b.poster_time as last_post_date

    941. 

  941.             FROM `#__messages` as b

    942. 

  942.                 $where $guest_where)

    943. 

  943.         ORDER BY last_post_date $end");

    944. 

  944. 

    945. 

  945.         return $query;

    946. 

  946.     }

    947. 

  947. 

    948. 

  948. 	/**

    949. 

  949. 	 * Filter forums from a set of results sent in / useful if the plugin needs to restrict the forums visible to a user

    950. 

  950. 	 * @param $results set of results from query

    951. 

  951. 	 * @param $limit int limit results parameter as set in the module's params; used for plugins that cannot limit using a query limiter

    952. 

  952. 	 */

    953. 

  953. 	function filterActivityResults(&$results, $limit=0)

    954. 

  954. 	{

    955. 

  955. 		$db =& JFusionFactory::getDatabase($this->getJname());

    956. 

  956. 		$query = "SELECT value FROM #__settings WHERE variable='censor_vulgar'";

    957. 

  957. 		$db->setQuery($query);

    958. 

  958. 		$vulgar = $db->loadResult();

    959. 

  959. 

    960. 

  960. 		$db =& JFusionFactory::getDatabase($this->getJname());

    961. 

  961. 		$query = "SELECT value FROM #__settings WHERE variable='censor_proper'";

    962. 

  962. 		$db->setQuery($query);

    963. 

  963. 		$proper = $db->loadResult();

    964. 

  964. 

    965. 

  965. 		$vulgar = explode  ( ',' , $vulgar );

    966. 

  966. 		$proper = explode  ( ',' , $proper );

    967. 

  967. 

    968. 

  968. 		foreach($results as $rkey => $result) {

    969. 

  969. 			foreach( $vulgar as $key => $value ) {

    970. 

  970. 				$results[$rkey]->subject = preg_replace  ( '#\b'.$value.'\b#is' , $proper[$key]  , $result->subject );

    971. 

  971.                 if (isset($results[$rkey]->body)) {

    972. 

  972.                     $results[$rkey]->body = preg_replace  ( '#\b'.$value.'\b#is' , $proper[$key]  , $result->body );

    973. 

  973.                 }

    974. 

  974. 			}

    975. 

  975. 		}

    976. 

  976. 	}

    977. 

  977. 

    978. 

  978. 	/**

    979. 

  979. 	 * Function called by sh404sef for url building

    980. 

  980.      * @param array with titles for url

    981. 

  981.      * @param array global pointer to sh404sef remaning $_GET values from the url

    982. 

  982. 	 */

    983. 

  983. 	function sh404sef(&$title,&$get)

    984. 

  984. 	{

    985. 

  985. 		if( isset($get['action'] ) ) {

    986. 

  986. 			$title[] = $get['action'];

    987. 

  987. 			shRemoveFromGETVarsList('action');

    988. 

  988. 		}

    989. 

  989. 

    990. 

  990. 		foreach( $get as $key => $value ) {

    991. 

  991. 			$title[] = $key.$value;

    992. 

  992. 			shRemoveFromGETVarsList($key);

    993. 

  993. 		}

    994. 

  994. 	}

    995. 

  995. 

    996. 

  996. 	function callback($buffer) {

    997. 

  997. 		$data = $this->callbackdata;

    998. 

  998. 		$headers_list = headers_list();

    999. 

  999. 		foreach($headers_list as $key => $value) {

    1000. 

  1000. 			if(stripos($value,'location') === 0 ) {

    1001. 

  1001. 				$regex_location[] = '#Location: '.$data->integratedURL.'index\.php\?(.*?)\z#Sise';

    1002. 

  1002. 				$replace_location[] = '\'Location: \'.$this->fixUrlNoAmp("index.php?$1","'.$data->baseURL.'","'.$data->fullURL.'").\'\'';

    1003. 

  1003. 				$regex_location[] = '#Location: '.$data->integratedURL.'index\.php\z#Sise';

    1004. 

  1004. 				$replace_location[] = '\'Location: \'.$this->fixUrlNoAmp("index.php","'.$data->baseURL.'","'.$data->fullURL.'").\'\'';

    1005. 

  1005. 				$value = preg_replace($regex_location, $replace_location, $value);

    1006. 

  1006. 				header($value);

    1007. 

  1007. 				return $buffer;

    1008. 

  1008. 			} else if (stripos($value, 'Refresh') === 0) {

    1009. 

  1009. 	            $regex_location[] = '#Refresh: (.*?) URL=' . $data->integratedURL . 'index\.php\?(.*?)\z#Sise';

    1010. 

  1010. 	            $replace_location[] = '\'Refresh: $1 \'.$this->fixUrlNoAmp("index.php?$2","' . $data->baseURL . '","' . $data->fullURL . '").\'\'';

    1011. 

  1011. 	            $regex_location[] = '#Refresh: (.*?) URL=' . $data->integratedURL . 'index\.php\z#Sise';

    1012. 

  1012. 	            $replace_location[] = '\'Refresh: $1 \'.$this->fixUrlNoAmp("index.php","' . $data->baseURL . '","' . $data->fullURL . '").\'\'';

    1013. 

  1013. 	            $value = preg_replace($regex_location, $replace_location, $value);

    1014. 

  1014. 	            header($value);

    1015. 

  1015. 	            return $buffer;

    1016. 

  1016. 	        }

    1017. 

  1017. 		}

    1018. 

  1018. 		if ( $this->callbackbypass ) return $buffer;

    1019. 

  1019. 		global $context;

    1020. 

  1020. 

    1021. 

  1021. 		if ( isset($context['get_data']) ) {

    1022. 

  1022. 			if ( $context['get_data'] && strpos( $context['get_data']  , 'jFusion_Route' ) ) {

    1023. 

  1023. 				$buffer = str_replace ($context['get_data'],'?action=admin',$buffer);

    1024. 

  1024. 			}

    1025. 

  1025. 		}

    1026. 

  1026. 

    1027. 

  1027. 		//fix for form actions

    1028. 

  1028. 		$data->buffer = $buffer;

    1029. 

  1029. 		ini_set('pcre.backtrack_limit',strlen($data->buffer)*2);

    1030. 

  1030. 

    1031. 

  1031. 		$this->parseBuffer($data);

    1032. 

  1032. 

    1033. 

  1033. 		if ( !strlen($data->header) || !strlen($data->body) ) {

    1034. 

  1034. 			return $buffer;

    1035. 

  1035. 		} else {

    1036. 

  1036. 			$this->parseHeader($data);

    1037. 

  1037. 			$this->parseBody($data);

    1038. 

  1038. 			return '<html><head>'.$data->header.'</head><body>'.$data->body.'</body></html>';

    1039. 

  1039. 		}

    1040. 

  1040. 	}

    1041. 

  1041. }
    1042.