PageRenderTime 57ms CodeModel.GetById 23ms RepoModel.GetById 0ms app.codeStats 0ms

/components/com_jfusionplugins/smf/public.php

http://jfusion.googlecode.com/
PHP | 1225 lines | 914 code | 163 blank | 148 comment | 146 complexity | 3ce498713b7f48d1dbf4aae85e5faa2d 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_smf 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 'smf';

    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 getViewNewMessagesURL()

    44. 

  44.     {

    45. 

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

    46. 

  46.     }

    47. 

  47. 

    48. 

  48.     function getProfileURL($uid)

    49. 

  49.     {

    50. 

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

    51. 

  51.     }

    52. 

  52. 

    53. 

  53.     function getPrivateMessageURL()

    54. 

  54.     {

    55. 

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

    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. 

    193. 

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

    194. 

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

    195. 

  195. 

    196. 

  196. 	        // logout any joomla users

    197. 

  197.         	$mainframe->logout();

    198. 

  198. 

    199. 

  199. 	        // clean up session

    200. 

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

    201. 

  201.         	$session->close();

    202. 

  202. 

    203. 

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

    204. 

  204. 

    205. 

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

    206. 

  206.         	exit();

    207. 

  207. 		}

    208. 

  208. 

    209. 

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

    210. 

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

    211. 

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

    212. 

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

    213. 

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

    214. 

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

    215. 

  215. 

    216. 

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

    217. 

  217. 

    218. 

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

    219. 

  219. 		global $forum_version;

    220. 

  220. 

    221. 

  221. 		//        require_once(JFUSION_PLUGIN_PATH.DS.$this->getJname().DS.'hooks.php');

    222. 

  222. 

    223. 

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

    224. 

  224. 

    225. 

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

    226. 

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

    227. 

  227. 		} else {

    228. 

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

    229. 

  229. 		}

    230. 

  230. 

    231. 

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

    232. 

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

    233. 

  233. 			return null;

    234. 

  234. 		}

    235. 

  235. 

    236. 

  236. 		//set the current directory to SMF

    237. 

  237. 		chdir($source_path);

    238. 

  238. 		$this->callbackdata = $data;

    239. 

  239. 		$this->callbackbypass = false;

    240. 

  240. 

    241. 

  241. 		// Get the output

    242. 

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

    243. 

  243. 		$h = ob_list_handlers();

    244. 

  244. 		$rs = include_once($index_file);

    245. 

  245. 		// die if popup

    246. 

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

    247. 

  247. 			exit();

    248. 

  248. 		} else {

    249. 

  249. 			$this->callbackbypass = true;

    250. 

  250. 		}

    251. 

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

    252. 

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

    253. 

  253. 			ob_end_clean();

    254. 

  254. 			$h = ob_list_handlers();

    255. 

  255. 		}

    256. 

  256. 

    257. 

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

    258. 

  258. 		chdir(JPATH_SITE);

    259. 

  259. 

    260. 

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

    261. 

  261. 		if (!$rs) {

    262. 

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

    263. 

  263. 		}

    264. 

  264. 		$document = JFactory::getDocument();

    265. 

  265. 		$document->addScript(JFusionFunction::getJoomlaURL().JFUSION_PLUGIN_DIR_URL.'smf/js/script.js');

    266. 

  266. 	}

    267. 

  267. 

    268. 

  268. 	function parseBody(&$data)

    269. 

  269. 	{

    270. 

  270. 		$regex_body		= array();

    271. 

  271. 		$replace_body	= array();

    272. 

  272. 

    273. 

  273. 		//fix for form actions

    274. 

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

    275. 

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

    276. 

  276. 

    277. 

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

    278. 

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

    279. 

  279. 

    280. 

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

    281. 

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

    282. 

  282. 

    283. 

  283. 		//Jump Related fix

    284. 

  284. 		$regex_body[]	= '#<select name="jumpto" id="jumpto".*?">(.*?)</select>#mSsie';

    285. 

  285. 		$replace_body[]	= '$this->fixJump("$1")';

    286. 

  286. 

    287. 

  287. 		$regex_body[] = '#<input (.*?) window.location.href = \'(.*?)\' \+ this.form.jumpto.options(.*?)>#mSsi';

    288. 

  288. 		$replace_body[] = '<input $1 window.location.href = jf_scripturl + this.form.jumpto.options$3>';

    289. 

  289. 

    290. 

  290. 		$regex_body[]	= '#smf_scripturl \+ \"\?action#mSsi';

    291. 

  291. 		$replace_body[]	= 'jf_scripturl + "&action';

    292. 

  292. 

    293. 

  293. 		$regex_body[]	= '#<a (.*?) onclick="doQuote(.*?)>#mSsi';

    294. 

  294. 		$replace_body[]	= '<a $1 onclick="jfusion_doQuote$2>';

    295. 

  295. 

    296. 

  296. 		$regex_body[]	= '#<a (.*?) onclick="modify_msg(.*?)>#mSsi';

    297. 

  297. 		$replace_body[]	= '<a $1 onclick="jfusion_modify_msg$2>';

    298. 

  298. 

    299. 

  299. 		$regex_body[]	= '#modify_save\(#mSsi';

    300. 

  300. 		$replace_body[]	= 'jfusion_modify_save(';

    301. 

  301. 

    302. 

  302. 		// Chaptcha fix

    303. 

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

    304. 

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

    305. 

  305. 

    306. 

  306. 		//Fix auto member search

    307. 

  307. 		$regex_body[]	= '#toComplete\.source = \"'.$data->integratedURL.'(.*?)\"#sie';

    308. 

  308. 		$replace_body[]	= '\'toComplete.source = "\'.$this->fixUrlNoAmp("$1","'.$data->baseURL.'","'.$data->fullURL.'").\'"\'';

    309. 

  309. 		$regex_body[]	= '#bccComplete\.source = \"'.$data->integratedURL.'(.*?)\"#sie';

    310. 

  310. 		$replace_body[]	= '\'bccComplete.source = "\'.$this->fixUrlNoAmp("$1","'.$data->baseURL.'","'.$data->fullURL.'").\'"\'';

    311. 

  311. 

    312. 

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

    313. 

  313. 	}

    314. 

  314. 

    315. 

  315. 	function parseHeader(&$data)

    316. 

  316. 	{

    317. 

  317. 		static $regex_header, $replace_header;

    318. 

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

    319. 

  319. 		{

    320. 

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

    321. 

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

    322. 

  322. 

    323. 

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

    324. 

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

    325. 

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

    326. 

  326. 

    327. 

  327. 			// Define our preg arrays

    328. 

  328. 			$regex_header		= array();

    329. 

  329. 			$replace_header	= array();

    330. 

  330. 

    331. 

  331. 			//convert relative links into absolute links

    332. 

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

    333. 

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

    334. 

  334. 

    335. 

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

    336. 

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

    337. 

  337. 

    338. 

  338. 			//convert relative links into absolute links

    339. 

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

    340. 

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

    341. 

  341. 

    342. 

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

    343. 

  343. 			$replace_header[] = 'var smf_scripturl = "$1"; var jf_scripturl = "'.$baseURLnoSef.'";';

    344. 

  344. 

    345. 

  345.             //fix for URL redirects

    346. 

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

    347. 

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

    348. 

  348. 		}

    349. 

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

    350. 

  350. 	}

    351. 

  351. 

    352. 

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

    353. 

  353. 	{

    354. 

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

    355. 

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

    356. 

  356. 

    357. 

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

    358. 

  358. 

    359. 

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

    360. 

  360. 			//non sef URls

    361. 

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

    362. 

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

    363. 

  363.         } else {

    364. 

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

    365. 

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

    366. 

  366. 			if ($sefmode==1) {

    367. 

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

    368. 

  368. 			} else {

    369. 

  369. 				//we can just append both variables

    370. 

  370. 				$url = $baseURL . $q;

    371. 

  371. 			}

    372. 

  372. 		}

    373. 

  373. 		return $url;

    374. 

  374. 	}

    375. 

  375. 

    376. 

  376.     /**

    377. 

  377.      * Fix url with no amps

    378. 

  378.      *

    379. 

  379.      * @param string $q       start url

    380. 

  380.      * @param string $baseURL base url

    381. 

  381.      * @param string $fullURL full url

    382. 

  382.      *

    383. 

  383.      * @return string url

    384. 

  384.      */

    385. 

  385.     function fixUrlNoAmp($q, $baseURL, $fullURL)

    386. 

  386.     {

    387. 

  387. 		$url = $this->fixUrl($q, $baseURL, $fullURL);

    388. 

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

    389. 

  389.         return $url;

    390. 

  390.     }

    391. 

  391. 

    392. 

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

    393. 

  393. 	{

    394. 

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

    395. 

  395. 		$url = htmlspecialchars_decode($url);

    396. 

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

    397. 

  397. 

    398. 

  398. 		$extra = stripslashes( $extra );

    399. 

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

    400. 

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

    401. 

  401. 			//non-SEF mode

    402. 

  402. 		  	$url_details = parse_url($url);

    403. 

  403. 		  	$url_variables = array();

    404. 

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

    405. 

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

    406. 

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

    407. 

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

    408. 

  408. 		 	}

    409. 

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

    410. 

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

    411. 

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

    412. 

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

    413. 

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

    414. 

  414. 		} else {

    415. 

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

    416. 

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

    417. 

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

    418. 

  418. 		    if ($sefmode==1) {

    419. 

  419. 		    	//extensive SEF parsing was selected

    420. 

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

    421. 

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

    422. 

  422. 				return $replacement;

    423. 

  423. 			} else {

    424. 

  424. 				//simple SEF mode

    425. 

  425. 		      	$url_details = parse_url($url);

    426. 

  426. 			  	$url_variables = array();

    427. 

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

    428. 

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

    429. 

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

    430. 

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

    431. 

  431. 		 		}

    432. 

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

    433. 

  433. 			}

    434. 

  434. 		}

    435. 

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

    436. 

  436. 

    437. 

  437. 		//add any other variables

    438. 

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

    439. 

  439. 		if(is_array($url_variables)){

    440. 

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

    441. 

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

    442. 

  442.   			}

    443. 

  443. 		}

    444. 

  444. */

    445. 

  445.   		return $replacement;

    446. 

  446. 	}

    447. 

  447. 

    448. 

  448. 	function fixJump($content)

    449. 

  449. 	{

    450. 

  450. 	  $find = '#<option value="[?](.*?)">(.*?)</option>#mSsi';

    451. 

  451. 	  $replace = '<option value="&$1">$2</option>';

    452. 

  452. 

    453. 

  453. 	  $content = preg_replace($find, $replace, $content);

    454. 

  454. 

    455. 

  455. 	  return '<select name="jumpto" id="jumpto" onchange="if (this.selectedIndex > 0 && this.options[this.selectedIndex].value && this.options[this.selectedIndex].value.length) window.location.href = jf_scripturl + this.options[this.selectedIndex].value;">'.$content.'</select>';

    456. 

  456. 	}

    457. 

  457. 

    458. 

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

    459. 

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

    460. 

  460.         //split up the timeout from url

    461. 

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

    462. 

  462.         $timeout = $parts[0];

    463. 

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

    464. 

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

    465. 

  465.         $jfile = basename($jfile);

    466. 

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

    467. 

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

    468. 

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

    469. 

  469.             //non-SEF mode

    470. 

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

    471. 

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

    472. 

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

    473. 

  473.             }

    474. 

  474.         } else {

    475. 

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

    476. 

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

    477. 

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

    478. 

  478.             if ($sefmode == 1) {

    479. 

  479.                 //extensive SEF parsing was selected

    480. 

  480.                 $redirectURL = $jfile;

    481. 

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

    482. 

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

    483. 

  483.                 }

    484. 

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

    485. 

  485.             } else {

    486. 

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

    487. 

  487.                 $redirectURL = $baseURL . $jfile;

    488. 

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

    489. 

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

    490. 

  490.                 }

    491. 

  491.             }

    492. 

  492.         }

    493. 

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

    494. 

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

    495. 

  495.         }

    496. 

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

    497. 

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

    498. 

  498.         return $return;

    499. 

  499.     }

    500. 

  500. 

    501. 

  501. 	function getPathWay()

    502. 

  502. 	{

    503. 

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

    504. 

  504. 		$pathway = array();

    505. 

  505. 

    506. 

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

    507. 

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

    508. 

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

    509. 

  509. 

    510. 

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

    511. 

  511. 

    512. 

  512.         $query = 'SELECT ID_TOPIC,ID_BOARD, subject '.

    513. 

  513.         		'FROM #__messages '.

    514. 

  514.         		'WHERE ID_TOPIC = ' . $db->Quote($topic_id);

    515. 

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

    516. 

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

    517. 

  517. 

    518. 

  518.         if ($topic) {

    519. 

  519. 			$board_id = $topic->ID_BOARD;

    520. 

  520.         }

    521. 

  521. 

    522. 

  522. 		if ($board_id) {

    523. 

  523. 			$boards = array();

    524. 

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

    525. 

  525. 			while ($board_id != 0)

    526. 

  526. 			{

    527. 

  527. 		        $query = 'SELECT b.ID_PARENT , b.ID_BOARD, b.ID_CAT, b.name , c.name as catname '.

    528. 

  528. 		        		'FROM #__boards AS b INNER JOIN #__categories AS c ON b.ID_CAT = c.ID_CAT '.

    529. 

  529. 		        		'WHERE ID_BOARD = ' . $db->Quote($board_id);

    530. 

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

    531. 

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

    532. 

  532. 

    533. 

  533. 				$board_id = 0;

    534. 

  534. 		 		if ($result) {

    535. 

  535. 		 			$board_id = $result->ID_PARENT;

    536. 

  536. 		 			$boards[] = $result;

    537. 

  537. 				}

    538. 

  538. 			}

    539. 

  539. 			$boards = array_reverse($boards);

    540. 

  540. 			$cat_id = 0;

    541. 

  541. 			foreach($boards as $board) {

    542. 

  542. 				$path = new stdClass();

    543. 

  543. 				if ( $board->ID_CAT != $cat_id ) {

    544. 

  544. 					$cat_id = $board->ID_CAT;

    545. 

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

    546. 

  546. 					$path->url = 'index.php#'.$board->ID_CAT;

    547. 

  547. 					$pathway[] = $path;

    548. 

  548. 

    549. 

  549. 					$path = new stdClass();

    550. 

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

    551. 

  551. 					$path->url = 'index.php?board='.$board->ID_BOARD.'.0';

    552. 

  552. 				} else {

    553. 

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

    554. 

  554. 					$path->url = 'index.php?board='.$board->ID_BOARD.'.0';

    555. 

  555. 				}

    556. 

  556. 				$pathway[] = $path;

    557. 

  557. 			}

    558. 

  558. 		}

    559. 

  559. 		switch ($action) {

    560. 

  560. 		    case 'post':

    561. 

  561. 		    	$path = new stdClass();

    562. 

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

    563. 

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

    564. 

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

    565. 

  565. 		    	} else if ( $msg ) {

    566. 

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

    567. 

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

    568. 

  568. 		    	} else {

    569. 

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

    570. 

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

    571. 

  571. 		    	}

    572. 

  572. 				$pathway[] = $path;

    573. 

  573. 		        break;

    574. 

  574. 			case 'pm':

    575. 

  575. 				$path = new stdClass();

    576. 

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

    577. 

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

    578. 

  578. 				$pathway[] = $path;

    579. 

  579. 

    580. 

  580. 				$path = new stdClass();

    581. 

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

    582. 

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

    583. 

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

    584. 

  584. 					$pathway[] = $path;

    585. 

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

    586. 

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

    587. 

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

    588. 

  588. 					$pathway[] = $path;

    589. 

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

    590. 

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

    591. 

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

    592. 

  592. 					$pathway[] = $path;

    593. 

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

    594. 

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

    595. 

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

    596. 

  596. 					$pathway[] = $path;

    597. 

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

    598. 

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

    599. 

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

    600. 

  600. 					$pathway[] = $path;

    601. 

  601. 				} else {

    602. 

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

    603. 

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

    604. 

  604. 					$pathway[] = $path;

    605. 

  605. 				}

    606. 

  606. 		        break;

    607. 

  607. 			case 'search2':

    608. 

  608. 				$path = new stdClass();

    609. 

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

    610. 

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

    611. 

  611. 				$pathway[] = $path;

    612. 

  612. 				$path = new stdClass();

    613. 

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

    614. 

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

    615. 

  615. 				$pathway[] = $path;

    616. 

  616. 				break;

    617. 

  617. 			case 'search':

    618. 

  618. 				$path = new stdClass();

    619. 

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

    620. 

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

    621. 

  621. 				$pathway[] = $path;

    622. 

  622. 				break;

    623. 

  623. 			case 'unread':

    624. 

  624. 				$path = new stdClass();

    625. 

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

    626. 

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

    627. 

  627. 				$pathway[] = $path;

    628. 

  628. 				break;

    629. 

  629. 			case 'unreadreplies':

    630. 

  630. 				$path = new stdClass();

    631. 

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

    632. 

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

    633. 

  633. 				$pathway[] = $path;

    634. 

  634. 				break;

    635. 

  635. 			default:

    636. 

  636. 				if ( $topic_id ) {

    637. 

  637. 					$path = new stdClass();

    638. 

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

    639. 

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

    640. 

  640. 					$pathway[] = $path;

    641. 

  641. 				}

    642. 

  642. 		}

    643. 

  643. 		return $pathway;

    644. 

  644. 	}

    645. 

  645. 

    646. 

  646.     function getPrivateMessageCounts($userid)

    647. 

  647.     {

    648. 

  648.         if ($userid) {

    649. 

  649. 

    650. 

  650.             // initialise some objects

    651. 

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

    652. 

  652. 

    653. 

  653.             // read unread count

    654. 

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

    655. 

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

    656. 

  656. 

    657. 

  657.             // read total pm count

    658. 

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

    659. 

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

    660. 

  660. 

    661. 

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

    662. 

  662.         }

    663. 

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

    664. 

  664.     }

    665. 

  665. 

    666. 

  666. 	function getAvatar($puser_id)

    667. 

  667.     {

    668. 

  668. 		if ($puser_id) {

    669. 

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

    670. 

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

    671. 

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

    672. 

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

    673. 

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

    674. 

  674. 			$db->query();

    675. 

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

    676. 

  676. 

    677. 

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

    678. 

  678. 				$url = '';

    679. 

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

    680. 

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

    681. 

  681. 				$db->query();

    682. 

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

    683. 

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

    684. 

  684. 				if(!empty($attachment) && $attachment->ID_THUMB == 0 && $attachment->ID_MSG == 0 && empty($result->avatar)) {

    685. 

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

    686. 

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

    687. 

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

    688. 

  688. 					$url = $result->avatar;

    689. 

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

    690. 

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

    691. 

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

    692. 

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

    693. 

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

    694. 

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

    695. 

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

    696. 

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

    697. 

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

    698. 

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

    699. 

  699. 					}

    700. 

  700. 				}

    701. 

  701. 

    702. 

  702. 				return $url;

    703. 

  703. 			}

    704. 

  704. 		}

    705. 

  705. 	}

    706. 

  706. 

    707. 

  707. 	/************************************************

    708. 

  708. 	 * For JFusion Search Plugin

    709. 

  709. 	 ***********************************************/

    710. 

  710. 	function getSearchQueryColumns()

    711. 

  711. 	{

    712. 

  712. 		$columns = new stdClass();

    713. 

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

    714. 

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

    715. 

  715. 		return $columns;

    716. 

  716. 	}

    717. 

  717. 

    718. 

  718. 	function getSearchQuery(&$pluginParam)

    719. 

  719. 	{

    720. 

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

    721. 

  721. 		$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,

    722. 

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

    723. 

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

    724. 

  724. 					t.numViews AS hits

    725. 

  725. 					FROM #__messages AS p

    726. 

  726. 					INNER JOIN #__topics AS t ON t.ID_TOPIC = p.ID_TOPIC

    727. 

  727. 					INNER JOIN #__messages AS fp ON fp.ID_MSG = t.ID_FIRST_MSG

    728. 

  728. 					INNER JOIN #__boards AS f on f.ID_BOARD = p.ID_BOARD';

    729. 

  729. 		return $query;

    730. 

  730. 	}

    731. 

  731. 

    732. 

  732. 	/**

    733. 

  733. 	 * Add on a plugin specific clause;

    734. 

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

    735. 

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

    736. 

  736. 	 */

    737. 

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

    738. 

  738. 	{

    739. 

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

    740. 

  740. 

    741. 

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

    742. 

  742. 

    743. 

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

    744. 

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

    745. 

  745. 

    746. 

  746. 		if ($userid) {

    747. 

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

    748. 

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

    749. 

  749. 			$group_id = $existinguser->group_id;

    750. 

  750. 		} else {

    751. 

  751. 			$group_id = '-1';

    752. 

  752. 		}

    753. 

  753. 

    754. 

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

    755. 

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

    756. 

  756.             $selected_boards = " WHERE ID_BOARD IN (" . implode(',', $forumids) . ")";

    757. 

  757.         } else {

    758. 

  758.             $selected_boards = '';

    759. 

  759.         }

    760. 

  760. 

    761. 

  761. 		$query = 'SELECT memberGroups, ID_BOARD FROM #__boards' . $selected_boards;

    762. 

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

    763. 

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

    764. 

  764. 

    765. 

  765. 		$list = array();

    766. 

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

    767. 

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

    768. 

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

    769. 

  769. 				$list[] =  $value->ID_BOARD;

    770. 

  770. 			}

    771. 

  771. 		}

    772. 

  772. 

    773. 

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

    774. 

  774.         switch ($ordering) {

    775. 

  775.              case 'oldest':

    776. 

  776.                 $sort = 'p.posterTime ASC';

    777. 

  777.                 break;

    778. 

  778.             case 'category':

    779. 

  779.                 $sort = 'section ASC';

    780. 

  780.                 break;

    781. 

  781.             case 'popular':

    782. 

  782.                 $sort = 't.numViews DESC, p.posterTime DESC';

    783. 

  783.             case 'alpha':

    784. 

  784.                 $sort = 'title ASC';

    785. 

  785.                 break;

    786. 

  786.             case 'newest':

    787. 

  787.             default:

    788. 

  788.                 $sort = 'p.posterTime DESC';

    789. 

  789.                 break;

    790. 

  790.         }

    791. 

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

    792. 

  792. 	}

    793. 

  793. 

    794. 

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

    795. 

  795. 	{

    796. 

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

    797. 

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

    798. 

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

    799. 

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

    800. 

  800. 

    801. 

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

    802. 

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

    803. 

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

    804. 

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

    805. 

  805. 

    806. 

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

    807. 

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

    808. 

  808. 

    809. 

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

    810. 

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

    811. 

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

    812. 

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

    813. 

  813. 			}

    814. 

  814. 		}

    815. 

  815. 	}

    816. 

  816. 

    817. 

  817. 	function getSearchResultLink($post)

    818. 

  818. 	{

    819. 

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

    820. 

  820. 		return $forum->getPostURL($post->ID_TOPIC,$post->ID_MSG);

    821. 

  821. 	}

    822. 

  822. 

    823. 

  823.    /************************************************

    824. 

  824. 	 * Functions For JFusion Who's Online Module

    825. 

  825. 	 ***********************************************/

    826. 

  826. 

    827. 

  827. 	/**

    828. 

  828. 	 * Returns a query to find online users

    829. 

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

    830. 

  830. 	 **/

    831. 

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

    832. 

  832. 	{

    833. 

  833. 		$usergroup_query = "";

    834. 

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

    835. 

  835. 			if(is_array($usergroups)) {

    836. 

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

    837. 

  837. 				$usergroup_query .= "AND (u.ID_GROUP IN ($usergroups) OR u.ID_POST_GROUP IN ($usergroups)";

    838. 

  838. 				foreach($usergroups AS $u) {

    839. 

  839. 					$usergroup_query .= " OR FIND_IN_SET(" . intval($u) . ", u.additionalGroups)";

    840. 

  840. 				}

    841. 

  841. 				$usergroup_query .= ")";

    842. 

  842. 			} else {

    843. 

  843. 				$usergroup_query .= "AND (u.ID_GROUP = $usergroups OR u.ID_POST_GROUP = $usergroups OR FIND_IN_SET($usergroups, u.additionalGroups))";

    844. 

  844. 			}

    845. 

  845. 		}

    846. 

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

    847. 

  847. 

    848. 

  848. 		return "SELECT DISTINCT u.ID_MEMBER AS userid, u.memberName AS username, u.realName AS name, u.emailAddress 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";

    849. 

  849. 	}

    850. 

  850. 

    851. 

  851. 	/**

    852. 

  852. 	 * Returns number of guests

    853. 

  853. 	 * @return int

    854. 

  854. 	 */

    855. 

  855. 	function getNumberOnlineGuests()

    856. 

  856. 	{

    857. 

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

    858. 

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

    859. 

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

    860. 

  860. 		return $db->loadResult();

    861. 

  861. 	}

    862. 

  862. 

    863. 

  863. 	/**

    864. 

  864. 	 * Returns number of logged in users

    865. 

  865. 	 * @return int

    866. 

  866. 	 */

    867. 

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

    868. 

  868. 	{

    869. 

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

    870. 

  870. 

    871. 

  871. 		$usergroup_query = "";

    872. 

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

    873. 

  873. 			if(is_array($usergroups)) {

    874. 

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

    875. 

  875. 				$usergroup_query .= "AND (u.ID_GROUP IN ($usergroups) OR u.ID_POST_GROUP IN ($usergroups)";

    876. 

  876. 				foreach($usergroups AS $u) {

    877. 

  877. 					$usergroup_query .= " OR FIND_IN_SET(" . intval($u) . ", u.additionalGroups)";

    878. 

  878. 				}

    879. 

  879. 				$usergroup_query .= ")";

    880. 

  880. 			} else {

    881. 

  881. 				$usergroup_query .= "AND (u.ID_GROUP = $usergroups OR u.ID_POST_GROUP = $usergroups OR FIND_IN_SET($usergroups, u.additionalGroups))";

    882. 

  882. 			}

    883. 

  883. 		}

    884. 

  884. 

    885. 

  885. 		$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";

    886. 

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

    887. 

  887. 		return $db->loadResult();

    888. 

  888. 	}

    889. 

  889. 

    890. 

  890. 	/************************************************

    891. 

  891. 	 * Functions For JFusion Activity Module

    892. 

  892. 	 ***********************************************/

    893. 

  893. 

    894. 

  894. 	/**

    895. 

  895. 	 * Returns the an array with SQL statements used by the activity module

    896. 

  896. 	 * @return array

    897. 

  897. 	 */

    898. 

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

    899. 

  899. 	{

    900. 

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

    901. 

  901. 

    902. 

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

    903. 

  903. 

    904. 

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

    905. 

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

    906. 

  906. 

    907. 

  907. 		if ($userid) {

    908. 

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

    909. 

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

    910. 

  910. 			$group_id = $existinguser->group_id;

    911. 

  911. 		} else {

    912. 

  912. 			$group_id = '-1';

    913. 

  913. 		}

    914. 

  914. 

    915. 

  915. 		$query = 'SELECT memberGroups, ID_BOARD FROM #__boards';

    916. 

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

    917. 

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

    918. 

  918. 

    919. 

  919. 		$list = array();

    920. 

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

    921. 

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

    922. 

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

    923. 

  923. 				$list[] =  $value->ID_BOARD;

    924. 

  924. 			}

    925. 

  925. 		}

    926. 

  926. 

    927. 

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

    928. 

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

    929. 

  929. 

    930. 

  930.         $numargs = func_num_args();

    931. 

  931.         if ($numargs > 3) {

    932. 

  932.             $filters = func_get_args();

    933. 

  933.             $i = 3;

    934. 

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

    935. 

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

    936. 

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

    937. 

  937.                 }

    938. 

  938.             }

    939. 

  939.         }

    940. 

  940. 

    941. 

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

    942. 

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

    943. 

  943. 

    944. 

  944.         $query = array(

    945. 

  945.         //LAT with first post info

    946. 

  946.         LAT . '0' =>

    947. 

  947.         "(SELECT a.ID_TOPIC AS threadid, a.ID_LAST_MSG AS postid, b.posterName AS username, d.realName AS name, b.ID_MEMBER AS userid, b.subject AS subject, b.posterTime AS dateline, a.ID_BOARD as forumid, c.posterTime as last_post_date

    948. 

  948.             FROM `#__topics` as a

    949. 

  949.                 INNER JOIN `#__messages` as b ON a.ID_FIRST_MSG = b.ID_MSG

    950. 

  950.                 INNER JOIN `#__messages` as c ON a.ID_LAST_MSG = c.ID_MSG

    951. 

  951.                 INNER JOIN `#__members`  as d ON b.ID_MEMBER = d.ID_MEMBER

    952. 

  952.                 $where)

    953. 

  953.         UNION

    954. 

  954.             (SELECT a.ID_TOPIC AS threadid, a.ID_LAST_MSG AS postid, b.posterName AS username, b.posterName AS name, b.ID_MEMBER AS userid, b.subject AS subject, b.posterTime AS dateline, a.ID_BOARD as forumid, c.posterTime as last_post_date

    955. 

  955.             FROM `#__topics` as a

    956. 

  956.                 INNER JOIN `#__messages` as b ON a.ID_FIRST_MSG = b.ID_MSG

    957. 

  957.                 INNER JOIN `#__messages` as c ON a.ID_LAST_MSG = c.ID_MSG

    958. 

  958.                 $where $guest_where)

    959. 

  959.         ORDER BY last_post_date $end",

    960. 

  960.         //LAT with latest post info

    961. 

  961.         LAT . '1' =>

    962. 

  962.         "(SELECT a.ID_TOPIC AS threadid, a.ID_LAST_MSG AS postid, b.posterName AS username, d.realName as name, b.ID_MEMBER AS userid, c.subject AS subject, b.posterTime AS dateline, a.ID_BOARD as forumid, b.posterTime as last_post_date

    963. 

  963.             FROM `#__topics` as a

    964. 

  964.                 INNER JOIN `#__messages` as b ON a.ID_LAST_MSG = b.ID_MSG

    965. 

  965.                 INNER JOIN `#__messages` as c ON a.ID_FIRST_MSG = c.ID_MSG

    966. 

  966.                 INNER JOIN `#__members`  as d ON b.ID_MEMBER = d.ID_MEMBER

    967. 

  967.                 $where)

    968. 

  968.         UNION

    969. 

  969.             (SELECT a.ID_TOPIC AS threadid, a.ID_LAST_MSG AS postid, b.posterName AS username, b.posterName as name, b.ID_MEMBER AS userid, c.subject AS subject, b.posterTime AS dateline, a.ID_BOARD as forumid, b.posterTime as last_post_date

    970. 

  970.             FROM `#__topics` as a

    971. 

  971.                 INNER JOIN `#__messages` as b ON a.ID_LAST_MSG = b.ID_MSG

    972. 

  972.                 INNER JOIN `#__messages` as c ON a.ID_FIRST_MSG = c.ID_MSG

    973. 

  973.                 $where $guest_where)

    974. 

  974.         ORDER BY last_post_date $end",

    975. 

  975.         //LCT

    976. 

  976.         LCT =>

    977. 

  977.         "(SELECT a.ID_TOPIC AS threadid, b.ID_MSG AS postid, b.posterName AS username, d.realName as name, b.ID_MEMBER AS userid, b.subject AS subject, b.body, b.posterTime AS dateline, a.ID_BOARD as forumid, b.posterTime as topic_date

    978. 

  978.             FROM `#__topics` as a

    979. 

  979.                 INNER JOIN `#__messages` as b ON a.ID_FIRST_MSG = b.ID_MSG

    980. 

  980.                 INNER JOIN `#__messages` as c ON a.ID_LAST_MSG = c.ID_MSG

    981. 

  981.                 INNER JOIN `#__members`  as d ON b.ID_MEMBER = d.ID_MEMBER

    982. 

  982.                 $where)

    983. 

  983.        UNION

    984. 

  984.             (SELECT a.ID_TOPIC AS threadid, b.ID_MSG AS postid, b.posterName AS username, b.posterName as name, b.ID_MEMBER AS userid, b.subject AS subject, b.body, b.posterTime AS dateline, a.ID_BOARD as forumid, b.posterTime as topic_date

    985. 

  985.             FROM `#__topics` as a

    986. 

  986.                 INNER JOIN `#__messages` as b ON a.ID_FIRST_MSG = b.ID_MSG

    987. 

  987.                 INNER JOIN `#__messages` as c ON a.ID_LAST_MSG = c.ID_MSG

    988. 

  988.                 $where $guest_where)

    989. 

  989.         ORDER BY topic_date $end",

    990. 

  990.         //LCP

    991. 

  991.         LCP => "

    992. 

  992.         (SELECT b.ID_TOPIC AS threadid, b.ID_MSG AS postid, b.posterName AS username, d.realName as name, b.ID_MEMBER AS userid, b.subject AS subject, b.body, b.posterTime AS dateline, b.ID_BOARD as forumid, b.posterTime as last_post_date

    993. 

  993.             FROM `#__messages` as b

    994. 

  994.                 INNER JOIN `#__members`  as d ON b.ID_MEMBER = d.ID_MEMBER

    995. 

  995.                 $where)

    996. 

  996.         UNION

    997. 

  997.             (SELECT b.ID_TOPIC AS threadid, b.ID_MSG AS postid, b.posterName AS username, b.posterName as name, b.ID_MEMBER AS userid, b.subject AS subject, b.body, b.posterTime AS dateline, b.ID_BOARD as forumid, b.posterTime as last_post_date

    998. 

  998.             FROM `#__messages` as b

    999. 

  999.                 $where $guest_where)

    1000. 

  1000.         ORDER BY last_post_date $end");

    1001. 

  1001. 

    1002. 

  1002.         return $query;

    1003. 

  1003. 	}

    1004. 

  1004. 

    1005. 

  1005. 	/**

    1006. 

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

    1007. 

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

    1008. 

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

    1009. 

  1009. 	 */

    1010. 

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

    1011. 

  1011. 	{

    1012. 

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

    1013. 

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

    1014. 

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

    1015. 

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

    1016. 

  1016. 

    1017. 

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

    1018. 

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

    1019. 

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

    1020. 

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

    1021. 

  1021. 

    1022. 

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

    1023. 

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

    1024. 

  1024. 

    1025. 

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

    1026. 

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

    1027. 

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

    1028. 

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

    1029. 

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

    1030. 

  1030.                 }

    1031. 

  1031. 			}

    1032. 

  1032. 		}

    1033. 

  1033. 	}

    1034. 

  1034. 

    1035. 

  1035. 	/**

    1036. 

  1036. 	 * Function called by sh404sef for url building

    1037. 

  1037.      * @param array with titles for url

    1038. 

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

    1039. 

  1039. 	 */

    1040. 

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

    1041. 

  1041. 	{

    1042. 

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

    1043. 

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

    1044. 

  1044. 			shRemoveFromGETVarsList('action');

    1045. 

  1045. 		}

    1046. 

  1046. 

    1047. 

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

    1048. 

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

    1049. 

  1049. 			shRemoveFromGETVarsList($key);

    1050. 

  1050. 		}

    1051. 

  1051. 	}

    1052. 

  1052. 

    1053. 

  1053. 	function callback($buffer) {

    1054. 

  1054. 		$data = $this->callbackdata;

    1055. 

  1055. 		$headers_list = headers_list();

    1056. 

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

    1057. 

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

    1058. 

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

    1059. 

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

    1060. 

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

    1061. 

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

    1062. 

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

    1063. 

  1063. 				header($value);

    1064. 

  1064. 				return $buffer;

    1065. 

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

    1066. 

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

    1067. 

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

    1068. 

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

    1069. 

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

    1070. 

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

    1071. 

  1071. 	            header($value);

    1072. 

  1072. 	            return $buffer;

    1073. 

  1073. 	        }

    1074. 

  1074. 		}

    1075. 

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

    1076. 

  1076. 		global $context;

    1077. 

  1077. 

    1078. 

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

    1079. 

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

    1080. 

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

    1081. 

  1081. 			}

    1082. 

  1082. 		}

    1083. 

  1083. 

    1084. 

  1084. 		//fix for form actions

    1085. 

  1085. 		$data->buffer = $buffer;

    1086. 

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

    1087. 

  1087. 

    1088. 

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

    1089. 

  1089. 

    1090. 

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

    1091. 

  1091. 			return $buffer;

    1092. 

  1092. 		} else {

    1093. 

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

    1094. 

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

    1095. 

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

    1096. 

  1096. 		}

    1097. 

  1097. 	}

    1098. 

  1098. 

    1099. 

  1099. 	function getCalender( ) {

    1100. 

  1100. 		$out = array();

    1101. 

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

    1102. 

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

    1103. 

  1103. 

    1104. 

  1104. 		$calender_itemid = $params->get('calender_itemid',0);

    1105. 

  1105. 		$show_calender = $params->get('show_calender',0);

    1106. 

  1106. 		$show_calender_holiday = $params->get('show_calender_holiday',0);

    1107. 

  1107. 		$show_birthday = $params->get('show_birthday',0);

    1108. 

  1108. 		$show_joined = $params->get('show_joined',0);

    1109. 

  1109. 

    1110. 

  1110. 		$baseURL = JFusionFunction::getPluginURL($calender_itemid);

    1111. 

  1111. 

    1112. 

  1112. 		if ($show_calender) {

    1113. 

  1113. 	        $query = 'SELECT startDate, endDate, title, subject, c.ID_MEMBER as userid, body '.

    1114. 

  1114. 	        		'FROM #__calendar as c INNER JOIN #__topics as t ON c.ID_TOPIC = t.ID_TOPIC INNER JOIN #__messages as m ON t.ID_FIRST_MSG = m.ID_MSG';

    1115. 

  1115. 

    1116. 

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

    1117. 

  1117. 	        $result = $db->loadObjectList();

    1118. 

  1118. 	        if (is_array($result)) {

    1119. 

  1119. 				foreach($result as $key => $event) {

    1120. 

  1120. 					$start = strtotime($event->startDate);

    1121. 

  1121. 					$end = strtotime($event->endDate)+(3600*24);

    1122. 

  1122. 

    1123. 

  1123. 					$e = new vevent(); // initiate a new EVENT

    1124. 

  1124. 					$e->setProperty( 'categories', 'CALENDER_'.$this->getJname() );

    1125. 

  1125. 					$e->setProperty( 'dtstart',  date("Y",$start), date("m",$start), date("d",$start), 00, 00, 00 );

    1126. 

  1126. 					$e->setProperty( 'dtend',  date("Y",$end), date("m",$end), date("d",$end), 00, 00, 00 );

    1127. 

  1127. 					$e->setProperty( 'description' , $event->body );

    1128. 

  1128. 					$e->setProperty( 'summary' , $event->title );

    1129. 

  1129. 					$e->setProperty( 'status' , 'CONFIRMED' );

    1130. 

  1130. 					$e->setProperty( 'transp' , 'TRANSPARENT' );

    1131. 

  1131. 

    1132. 

  1132. 					$out[] = $e;

    1133. 

  1133. 				}

    1134. 

  1134. 			}

    1135. 

  1135. 		}

    1136. 

  1136. 		if ($show_calender_holiday) {

    1137. 

  1137. 	        $query = 'SELECT eventDate, title '.

    1138. 

  1138. 	        		'FROM #__calendar_holidays ';

    1139. 

  1139. 

    1140. 

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

    1141. 

  1141. 	        $result = $db->loadObjectList();

    1142. 

  1142. 	        if (is_array($result)) {

    1143. 

  1143. 				foreach($result as $key => $event) {

    1144. 

  1144. 					$yearly = false;

    1145. 

  1145. 					if ( strpos($event->eventDate, '0004' ) !== FALSE ) {

    1146. 

  1146. 						$yearly = true;

    1147. 

  1147. 						$event->eventDate = str_replace('0004','1990',$event->eventDate);

    1148. 

  1148. 					}

    1149. 

  1149. 

    1150. 

  1150. 

    1151. 

  1151. 					$start = strtotime($event->eventDate);

    1152. 

  1152. 					$end = $start+(3600*24);

    1153. 

  1153. 					if ($yearly) {

    1154. 

  1154. 						$end = $end-1;

    1155. 

  1155. 					}

    1156. 

  1156. 

    1157. 

  1157. 					$e = new vevent(); // initiate a new EVENT

    1158. 

  1158. 					$e->setProperty( 'categories', 'CALENDER_HOLLIDAY_'.$this->getJname() );

    1159. 

  1159. 					$e->setProperty( 'dtstart',  date("Y",$start), date("m",$start), date("d",$start), 00, 00, 00 );

    1160. 

  1160. 					$e->setProperty( 'dtend',  date("Y",$end), date("m",$end), date("d",$end), 00, 00, 00 );

    1161. 

  1161. 					$e->setProperty( 'summary' , $event->title );

    1162. 

  1162. 					$e->setProperty( 'status' , 'CONFIRMED' );

    1163. 

  1163. 					$e->setProperty( 'transp' , 'TRANSPARENT' );

    1164. 

  1164. 					if ($yearly ) {

    1165. 

  1165. 						$e->setProperty( 'rrule' , array( 'FREQ' => 'YEARLY' ));

    1166. 

  1166. 					}

    1167. 

  1167. 

    1168. 

  1168. 					$out[] = $e;

    1169. 

  1169. 				}

    1170. 

  1170. 	        }

    1171. 

  1171. 		}

    1172. 

  1172. 

    1173. 

  1173. 		if ($show_birthday|| $show_joined) {

    1174. 

  1174. 	        $query = 'SELECT ID_MEMBER , birthdate, memberName, is_activated, dateRegistered '.

    1175. 

  1175. 	        		'FROM #__members '.

    1176. 

  1176. 	        		'WHERE is_activated=1 AND birthdate!='.$db->Quote('0001-01-01');

    1177. 

  1177. 

    1178. 

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

    1179. 

  1179. 	        $result = $db->loadObjectList();

    1180. 

  1180. 	        if (is_array($result)) {

    1181. 

  1181. 				foreach($result as $key => $event) {

    1182. 

  1182. 					if ($show_birthday) {

    1183. 

  1183. 						$start = strtotime($event->birthdate);

    1184. 

  1184. 						$end = $start+(3600*24)-1;

    1185. 

  1185. 						$e = new vevent(); // initiate a new EVENT

    1186. 

  1186. 						$e->setProperty( 'categories', 'CALENDER_BBIRTHDAY_'.$this->getJname() );

    1187. 

  1187. 						$e->setProperty( 'dtstart',  date("Y",$start), date("m",$start), date("d",$start), 00, 00, 00 );

    1188. 

  1188. 						$e->setProperty( 'dtend',  date("Y",$end), date("m",$end), date("d",$end), 00, 00, 00 );

    1189. 

  1189. 						$e->setProperty( 'summary' , 'Birthday: '. $event->memberName );

    1190. 

  1190. 

    1191. 

  1191. 						$url = $this->fixUrl($this->getProfileURL($event->ID_MEMBER),$baseURL,'');

    1192. 

  1192. 

    1193. 

  1193. 						$e->setProperty( 'description' , 'Profile: <a href="'.$url.'">'.$event->memberName.'</a>'  );    // describe the event

    1194. 

  1194. 

    1195. 

  1195. 						$e->setProperty( 'status' , 'CONFIRMED' );

    1196. 

  1196. 						$e->setProperty( 'transp' , 'TRANSPARENT' );

    1197. 

  1197. 						$e->setProperty( 'rrule' , array( 'FREQ' => 'YEARLY' ));

    1198. 

  1198. 

    1199. 

  1199. 						$out[] = $e;

    1200. 

  1200. 					}

    1201. 

  1201. 					if ($show_joined) {

    1202. 

  1202. 						$start = $event->dateRegistered;

    1203. 

  1203. 						$end = $event->dateRegistered+(3600*24);

    1204. 

  1204. 

    1205. 

  1205. 						$e = new vevent(); // initiate a new EVENT

    1206. 

  1206. 						$e->setProperty( 'categories', 'CALENDER_BBIRTHDAY_'.$this->getJname() );

    1207. 

  1207. 						$e->setProperty( 'dtstart',  date("Y",$start), date("m",$start), date("d",$start), 00, 00, 00 );

    1208. 

  1208. 						$e->setProperty( 'dtend',  date("Y",$end), date("m",$end), date("d",$end), 00, 00, 00 );

    1209. 

  1209. 						$e->setProperty( 'summary' , 'Joined: '. $event->memberName );

    1210. 

  1210. 

    1211. 

  1211. 						$url = $this->fixUrl($this->getProfileURL($event->ID_MEMBER),$baseURL,'');

    1212. 

  1212. 

    1213. 

  1213. 						$e->setProperty( 'description' , 'Profile: <a href="'.$url.'">'.$event->memberName.'</a>'  );    // describe the event

    1214. 

  1214. 

    1215. 

  1215. 						$e->setProperty( 'status' , 'CONFIRMED' );

    1216. 

  1216. 						$e->setProperty( 'transp' , 'TRANSPARENT' );

    1217. 

  1217. 

    1218. 

  1218. 						$out[] = $e;

    1219. 

  1219. 					}

    1220. 

  1220. 				}

    1221. 

  1221. 	        }

    1222. 

  1222. 		}

    1223. 

  1223. 		return $out;

    1224. 

  1224. 	}

    1225. 

  1225. }
    1226.