PageRenderTime 43ms CodeModel.GetById 24ms RepoModel.GetById 0ms app.codeStats 1ms

/administrator/components/com_acymailing/extensions/plg_acymailing_tagcontent/tagcontent.php

https://github.com/srgg6701/auction-ruseasons
PHP | 1245 lines | 1101 code | 135 blank | 9 comment | 290 complexity | d003470fe25180509832bfbd121e39dc MD5 | raw file
Possible License(s): GPL-2.0, LGPL-3.0, LGPL-2.1, BSD-3-Clause, JSON 
    

  1. <?php

    2. 

  2. /**

    3. 

  3.  * @package	AcyMailing for Joomla!

    4. 

  4.  * @version	4.1.0

    5. 

  5.  * @author	acyba.com

    6. 

  6.  * @copyright	(C) 2009-2013 ACYBA S.A.R.L. All rights reserved.

    7. 

  7.  * @license	GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html

    8. 

  8.  */

    9. 

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

    10. 

  10. ?><?php defined('_JEXEC') or die('Restricted access'); ?>

    11. 

  11. <?php

    12. 

  12. 

    13. 

  13. class plgAcymailingTagcontent extends JPlugin

    14. 

  14. {

    15. 

  15. 

    16. 

  16. 	function plgAcymailingTagcontent(&$subject, $config){

    17. 

  17. 		parent::__construct($subject, $config);

    18. 

  18. 		if(!isset($this->params)){

    19. 

  19. 			$plugin = JPluginHelper::getPlugin('acymailing', 'tagcontent');

    20. 

  20. 			$this->params = new JParameter( $plugin->params );

    21. 

  21. 		}

    22. 

  22. 	}

    23. 

  23. 

    24. 

  24. 	 function acymailing_getPluginType() {

    25. 

  25. 

    26. 

  26. 		$app = JFactory::getApplication();

    27. 

  27. 	 	if($this->params->get('frontendaccess') == 'none' AND !$app->isAdmin()) return;

    28. 

  28. 

    29. 

  29. 	 	$onePlugin = new stdClass();

    30. 

  30. 	 	$onePlugin->name = JText::_('JOOMLA_CONTENT');

    31. 

  31. 	 	$onePlugin->function = 'acymailingtagcontent_show';

    32. 

  32. 	 	$onePlugin->help = 'plugin-tagcontent';

    33. 

  33. 

    34. 

  34. 	 	return $onePlugin;

    35. 

  35. 	 }

    36. 

  36. 

    37. 

  37. 	 function acymailingtagcontent_show(){

    38. 

  38. 		$app = JFactory::getApplication();

    39. 

  39. 

    40. 

  40. 		$pageInfo = new stdClass();

    41. 

  41. 		$pageInfo->filter = new stdClass();

    42. 

  42. 		$pageInfo->filter->order = new stdClass();

    43. 

  43. 		$pageInfo->limit = new stdClass();

    44. 

  44. 		$pageInfo->elements = new stdClass();

    45. 

  45. 

    46. 

  46. 		$my = JFactory::getUser();

    47. 

  47. 

    48. 

  48. 		$paramBase = ACYMAILING_COMPONENT.'.tagcontent';

    49. 

  49. 		$pageInfo->filter->order->value = $app->getUserStateFromRequest( $paramBase.".filter_order", 'filter_order',	'a.id','cmd' );

    50. 

  50. 		$pageInfo->filter->order->dir	= $app->getUserStateFromRequest( $paramBase.".filter_order_Dir", 'filter_order_Dir',	'desc',	'word' );

    51. 

  51. 		$pageInfo->search = $app->getUserStateFromRequest( $paramBase.".search", 'search', '', 'string' );

    52. 

  52. 		$pageInfo->search = JString::strtolower( $pageInfo->search );

    53. 

  53. 		$pageInfo->filter_cat = $app->getUserStateFromRequest( $paramBase.".filter_cat", 'filter_cat','','int' );

    54. 

  54. 		$pageInfo->contenttype = $app->getUserStateFromRequest( $paramBase.".contenttype", 'contenttype',$this->params->get('default_type','intro'),'string' );

    55. 

  55. 		$pageInfo->author = $app->getUserStateFromRequest( $paramBase.".author", 'author',$this->params->get('default_author','0'),'string' );

    56. 

  56. 		$pageInfo->titlelink = $app->getUserStateFromRequest( $paramBase.".titlelink", 'titlelink',$this->params->get('default_titlelink','link'),'string' );

    57. 

  57. 		$pageInfo->lang = $app->getUserStateFromRequest( $paramBase.".lang", 'lang','','string' );

    58. 

  58. 		$pageInfo->pict = $app->getUserStateFromRequest( $paramBase.".pict", 'pict',$this->params->get('default_pict',1),'string' );

    59. 

  59. 		$pageInfo->pictheight = $app->getUserStateFromRequest( $paramBase.".pictheight", 'pictheight',$this->params->get('maxheight',150),'string' );

    60. 

  60. 		$pageInfo->pictwidth = $app->getUserStateFromRequest( $paramBase.".pictwidth", 'pictwidth',$this->params->get('maxwidth',150),'string' );

    61. 

  61. 

    62. 

  62. 

    63. 

  63. 		$pageInfo->limit->value = $app->getUserStateFromRequest( $paramBase.'.list_limit', 'limit', $app->getCfg('list_limit'), 'int' );

    64. 

  64. 		$pageInfo->limit->start = $app->getUserStateFromRequest( $paramBase.'.limitstart', 'limitstart', 0, 'int' );

    65. 

  65. 

    66. 

  66. 		$picts = array();

    67. 

  67. 		$picts[] = JHTML::_('select.option', "1",JText::_('JOOMEXT_YES'));

    68. 

  68. 		$pictureHelper = acymailing_get('helper.acypict');

    69. 

  69. 		if($pictureHelper->available()) $picts[] = JHTML::_('select.option', "resized",JText::_('RESIZED'));

    70. 

  70. 		$picts[] = JHTML::_('select.option', "0",JText::_('JOOMEXT_NO'));

    71. 

  71. 

    72. 

  72. 		$contenttype = array();

    73. 

  73. 		$contenttype[] = JHTML::_('select.option', "title",JText::_('TITLE_ONLY'));

    74. 

  74. 		$contenttype[] = JHTML::_('select.option', "intro",JText::_('INTRO_ONLY'));

    75. 

  75. 		$contenttype[] = JHTML::_('select.option', "text",JText::_('FIELD_TEXT'));

    76. 

  76. 		$contenttype[] = JHTML::_('select.option', "full",JText::_('FULL_TEXT'));

    77. 

  77. 

    78. 

  78. 		$titlelink = array();

    79. 

  79. 		$titlelink[] = JHTML::_('select.option', "link",JText::_('JOOMEXT_YES'));

    80. 

  80. 		$titlelink[] = JHTML::_('select.option', "0",JText::_('JOOMEXT_NO'));

    81. 

  81. 

    82. 

  82. 		$authorname = array();

    83. 

  83. 		$authorname[] = JHTML::_('select.option', "author",JText::_('JOOMEXT_YES'));

    84. 

  84. 		$authorname[] = JHTML::_('select.option', "0",JText::_('JOOMEXT_NO'));

    85. 

  85. 

    86. 

  86. 		$db = JFactory::getDBO();

    87. 

  87. 

    88. 

  88. 		$searchFields = array('a.id','a.title','a.alias','a.created_by','b.name','b.username');

    89. 

  89. 		if(!empty($pageInfo->search)){

    90. 

  90. 			$searchVal = '\'%'.acymailing_getEscaped($pageInfo->search,true).'%\'';

    91. 

  91. 			$filters[] = implode(" LIKE $searchVal OR ",$searchFields)." LIKE $searchVal";

    92. 

  92. 		}

    93. 

  93. 

    94. 

  94. 		if(!empty($pageInfo->filter_cat)){

    95. 

  95. 			$filters[] = "a.catid = ".$pageInfo->filter_cat;

    96. 

  96. 		}

    97. 

  97. 

    98. 

  98. 		if($this->params->get('displayart','all') == 'onlypub'){

    99. 

  99. 			$filters[] = "a.state = 1";

    100. 

  100. 		}else{

    101. 

  101. 			$filters[] = "a.state != -2";

    102. 

  102. 		}

    103. 

  103. 

    104. 

  104. 		if(!$app->isAdmin()){

    105. 

  105. 			if(!ACYMAILING_J16){

    106. 

  106. 				$filters[] = 'a.`access` <= ' . (int)$my->get('aid');

    107. 

  107. 			}else{

    108. 

  108. 				$groups = implode(',', $my->authorisedLevels());

    109. 

  109. 				$filters[] = 'a.`access` IN ('.$groups.')';

    110. 

  110. 			}

    111. 

  111. 		}

    112. 

  112. 

    113. 

  113. 		if($this->params->get('frontendaccess') == 'author' AND !$app->isAdmin()){

    114. 

  114. 			$filters[] = "a.created_by = ".intval($my->id);

    115. 

  115. 		}

    116. 

  116. 

    117. 

  117. 		$whereQuery = '';

    118. 

  118. 		if(!empty($filters)){

    119. 

  119. 			$whereQuery = ' WHERE ('.implode(') AND (',$filters).')';

    120. 

  120. 		}

    121. 

  121. 

    122. 

  122. 		$query = 'SELECT SQL_CALC_FOUND_ROWS a.*,b.name,b.username,a.created_by FROM '.acymailing_table('content',false).' as a';

    123. 

  123. 		$query .=' LEFT JOIN `#__users` AS b ON b.id = a.created_by';

    124. 

  124. 		if(!empty($whereQuery)) $query.= $whereQuery;

    125. 

  125. 		if(!empty($pageInfo->filter->order->value)){

    126. 

  126. 			$query .= ' ORDER BY '.$pageInfo->filter->order->value.' '.$pageInfo->filter->order->dir;

    127. 

  127. 		}

    128. 

  128. 

    129. 

  129. 		$db->setQuery($query,$pageInfo->limit->start,$pageInfo->limit->value);

    130. 

  130. 		$rows = $db->loadObjectList();

    131. 

  131. 

    132. 

  132. 		if(!empty($pageInfo->search)){

    133. 

  133. 			$rows = acymailing_search($pageInfo->search,$rows);

    134. 

  134. 		}

    135. 

  135. 

    136. 

  136. 		$db->setQuery('SELECT FOUND_ROWS()');

    137. 

  137. 		$pageInfo->elements->total = $db->loadResult();

    138. 

  138. 		$pageInfo->elements->page = count($rows);

    139. 

  139. 

    140. 

  140. 		if(!ACYMAILING_J16){

    141. 

  141. 			$query = 'SELECT a.id, a.id as catid, a.title as category, b.title as section, b.id as secid from #__categories as a ';

    142. 

  142. 			$query .= 'INNER JOIN #__sections as b on a.section = b.id ORDER BY b.ordering,a.ordering';

    143. 

  143. 

    144. 

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

    145. 

  145. 			$categories = $db->loadObjectList('id');

    146. 

  146. 			$categoriesValues = array();

    147. 

  147. 			$categoriesValues[] = JHTML::_('select.option', '',JText::_('ACY_ALL'));

    148. 

  148. 			$currentSec = '';

    149. 

  149. 			foreach($categories as $catid => $oneCategorie){

    150. 

  150. 				if($currentSec != $oneCategorie->section){

    151. 

  151. 					if(!empty($currentSec)) $this->values[] = JHTML::_('select.option', '</OPTGROUP>');

    152. 

  152. 					$categoriesValues[] = JHTML::_('select.option', '<OPTGROUP>',$oneCategorie->section);

    153. 

  153. 					$currentSec = $oneCategorie->section;

    154. 

  154. 				}

    155. 

  155. 				$categoriesValues[] = JHTML::_('select.option', $catid,$oneCategorie->category);

    156. 

  156. 			}

    157. 

  157. 		}else{

    158. 

  158. 			$query = "SELECT * from #__categories WHERE `extension` = 'com_content' ORDER BY lft ASC";

    159. 

  159. 

    160. 

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

    161. 

  161. 			$categories = $db->loadObjectList('id');

    162. 

  162. 			$categoriesValues = array();

    163. 

  163. 			$categoriesValues[] = JHTML::_('select.option', '',JText::_('ACY_ALL'));

    164. 

  164. 			foreach($categories as $catid => $oneCategorie){

    165. 

  165. 				$categories[$catid]->title = str_repeat('- - ',$categories[$catid]->level).$categories[$catid]->title;

    166. 

  166. 				$categoriesValues[] = JHTML::_('select.option', $catid,$categories[$catid]->title);

    167. 

  167. 			}

    168. 

  168. 		}

    169. 

  169. 

    170. 

  170. 		jimport('joomla.html.pagination');

    171. 

  171. 		$pagination = new JPagination( $pageInfo->elements->total, $pageInfo->limit->start, $pageInfo->limit->value );

    172. 

  172. 

    173. 

  173. 		$tabs = acymailing_get('helper.acytabs');

    174. 

  174. 		echo $tabs->startPane( 'joomlacontent_tab');

    175. 

  175. 		echo $tabs->startPanel( JText::_( 'JOOMLA_CONTENT' ), 'joomlacontent_content');

    176. 

  176. 

    177. 

  177. 	?>

    178. 

  178. 		<br style="font-size:1px"/>

    179. 

  179. 		<script language="javascript" type="text/javascript">

    180. 

  180. 		<!--

    181. 

  181. 			var selectedContents = new Array();

    182. 

  182. 			function applyContent(contentid,rowClass){

    183. 

  183. 				if(selectedContents[contentid]){

    184. 

  184. 					window.document.getElementById('content'+contentid).className = rowClass;

    185. 

  185. 					delete selectedContents[contentid];

    186. 

  186. 				}else{

    187. 

  187. 					window.document.getElementById('content'+contentid).className = 'selectedrow';

    188. 

  188. 					selectedContents[contentid] = 'content';

    189. 

  189. 				}

    190. 

  190. 

    191. 

  191. 				updateTag();

    192. 

  192. 			}

    193. 

  193. 

    194. 

  194. 			function updateTag(){

    195. 

  195. 				var tag = '';

    196. 

  196. 				var otherinfo = '';

    197. 

  197. 				for(var i=0; i < document.adminForm.contenttype.length; i++){

    198. 

  198. 					 if (document.adminForm.contenttype[i].checked){ selectedtype = document.adminForm.contenttype[i].value; otherinfo += '|type:'+document.adminForm.contenttype[i].value; }

    199. 

  199. 				}

    200. 

  200. 				for(var i=0; i < document.adminForm.titlelink.length; i++){

    201. 

  201. 					 if (document.adminForm.titlelink[i].checked && document.adminForm.titlelink[i].value.length > 1){ otherinfo += '|'+document.adminForm.titlelink[i].value; }

    202. 

  202. 				}

    203. 

  203. 				if(selectedtype != 'title'){

    204. 

  204. 					for(var i=0; i < document.adminForm.author.length; i++){

    205. 

  205. 						 if (document.adminForm.author[i].checked && document.adminForm.author[i].value.length > 1){otherinfo += '|'+document.adminForm.author[i].value; }

    206. 

  206. 					}

    207. 

  207. 					for(var i=0; i < document.adminForm.pict.length; i++){

    208. 

  208. 						 if (document.adminForm.pict[i].checked){

    209. 

  209. 							otherinfo += '|pict:'+document.adminForm.pict[i].value;

    210. 

  210. 							if(document.adminForm.pict[i].value == 'resized'){

    211. 

  211. 						 		document.getElementById('pictsize').style.display = '';

    212. 

  212. 						 		if(document.adminForm.pictwidth.value) otherinfo += '|maxwidth:'+document.adminForm.pictwidth.value;

    213. 

  213. 						 		if(document.adminForm.pictheight.value) otherinfo += '|maxheight:'+document.adminForm.pictheight.value;

    214. 

  214. 						 	}else{

    215. 

  215. 						 		document.getElementById('pictsize').style.display = 'none';

    216. 

  216. 						 	}

    217. 

  217. 						 }

    218. 

  218. 					}

    219. 

  219. 				}

    220. 

  220. 

    221. 

  221. 				if(window.document.getElementById('jflang')  && window.document.getElementById('jflang').value != ''){

    222. 

  222. 					otherinfo += '|lang:';

    223. 

  223. 					otherinfo += window.document.getElementById('jflang').value;

    224. 

  224. 				}

    225. 

  225. 

    226. 

  226. 				for(var i in selectedContents){

    227. 

  227. 					if(selectedContents[i] == 'content'){

    228. 

  228. 						tag = tag + '{joomlacontent:'+i+otherinfo+'}<br/>';

    229. 

  229. 					}

    230. 

  230. 				}

    231. 

  231. 				setTag(tag);

    232. 

  232. 			}

    233. 

  233. 		//-->

    234. 

  234. 		</script>

    235. 

  235. 		<table width="100%" class="adminform">

    236. 

  236. 			<tr>

    237. 

  237. 				<td>

    238. 

  238. 					<?php echo JText::_('DISPLAY'); ?>

    239. 

  239. 				</td>

    240. 

  240. 				<td colspan="2">

    241. 

  241. 				<?php echo JHTML::_('acyselect.radiolist', $contenttype, 'contenttype' , 'size="1" onclick="updateTag();"', 'value', 'text', $pageInfo->contenttype);?>

    242. 

  242. 				</td>

    243. 

  243. 				<td>

    244. 

  244. 				<?php $jflanguages = acymailing_get('type.jflanguages');

    245. 

  245. 						$jflanguages->onclick = 'onchange="updateTag();"';

    246. 

  246. 						echo $jflanguages->display('lang',$pageInfo->lang); ?>

    247. 

  247. 				</td>

    248. 

  248. 			</tr>

    249. 

  249. 			<tr>

    250. 

  250. 				<td>

    251. 

  251. 				<?php echo JText::_('CLICKABLE_TITLE'); ?>

    252. 

  252. 				 </td>

    253. 

  253. 				 <td>

    254. 

  254. 				 	<?php echo JHTML::_('acyselect.radiolist', $titlelink, 'titlelink' , 'size="1" onclick="updateTag();"', 'value', 'text', $pageInfo->titlelink);?>

    255. 

  255. 				</td>

    256. 

  256. 				<td>

    257. 

  257. 				<?php echo JText::_('AUTHOR_NAME'); ?>

    258. 

  258. 				 </td>

    259. 

  259. 				 <td>

    260. 

  260. 				 	<?php echo JHTML::_('acyselect.radiolist', $authorname, 'author' , 'size="1" onclick="updateTag();"', 'value', 'text', (string) $pageInfo->author); ?>

    261. 

  261. 				</td>

    262. 

  262. 			</tr>

    263. 

  263. 			<tr>

    264. 

  264. 				<td valign="top"><?php echo JText::_('DISPLAY_PICTURES'); ?></td>

    265. 

  265. 				<td valign="top"><?php echo JHTML::_('acyselect.radiolist', $picts, 'pict' , 'size="1" onclick="updateTag();"', 'value', 'text', $pageInfo->pict); ?>

    266. 

  266. 				<span id="pictsize" <?php if($pageInfo->pict != 'resized') echo 'style="display:none;"'; ?>><br/><?php echo JText::_('CAPTCHA_WIDTH') ?>

    267. 

  267. 					<input name="pictwidth" type="text" onchange="updateTag();" value="<?php echo $pageInfo->pictwidth; ?>" style="width:30px;" />

    268. 

  268. 					x <?php echo JText::_('CAPTCHA_HEIGHT') ?>

    269. 

  269. 					<input name="pictheight" type="text" onchange="updateTag();" value="<?php echo $pageInfo->pictheight; ?>" style="width:30px;" />

    270. 

  270. 				</span>

    271. 

  271. 

    272. 

  272. 				</td>

    273. 

  273. 				<td></td>

    274. 

  274. 				<td></td>

    275. 

  275. 			</tr>

    276. 

  276. 		</table>

    277. 

  277. 		<table>

    278. 

  278. 			<tr>

    279. 

  279. 				<td width="100%">

    280. 

  280. 					<?php echo JText::_( 'JOOMEXT_FILTER' ); ?>:

    281. 

  281. 					<input type="text" name="search" id="acymailingsearch" value="<?php echo $pageInfo->search;?>" class="text_area" onchange="document.adminForm.submit();" />

    282. 

  282. 					<button class="btn" onclick="this.form.submit();"><?php echo JText::_( 'JOOMEXT_GO' ); ?></button>

    283. 

  283. 					<button class="btn" onclick="document.getElementById('acymailingsearch').value='';this.form.submit();"><?php echo JText::_( 'JOOMEXT_RESET' ); ?></button>

    284. 

  284. 				</td>

    285. 

  285. 				<td nowrap="nowrap">

    286. 

  286. 					<?php echo JHTML::_('select.genericlist',   $categoriesValues, 'filter_cat', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'value', 'text', (int) $pageInfo->filter_cat ); ?>

    287. 

  287. 				</td>

    288. 

  288. 			</tr>

    289. 

  289. 		</table>

    290. 

  290. 

    291. 

  291. 		<table class="adminlist table table-striped table-hover" cellpadding="1" width="100%">

    292. 

  292. 			<thead>

    293. 

  293. 				<tr>

    294. 

  294. 					<th class="title">

    295. 

  295. 					</th>

    296. 

  296. 					<th class="title">

    297. 

  297. 						<?php echo JHTML::_('grid.sort', JText::_( 'FIELD_TITLE'), 'a.title', $pageInfo->filter->order->dir,$pageInfo->filter->order->value ); ?>

    298. 

  298. 					</th>

    299. 

  299. 					<th class="title">

    300. 

  300. 						<?php echo JHTML::_('grid.sort', JText::_( 'ACY_AUTHOR'), 'b.name', $pageInfo->filter->order->dir,$pageInfo->filter->order->value ); ?>

    301. 

  301. 					</th>

    302. 

  302. 					<th class="title">

    303. 

  303. 						<?php echo JHTML::_('grid.sort',   JText::_( 'ACY_CREATED' ), 'a.created', $pageInfo->filter->order->dir, $pageInfo->filter->order->value ); ?>

    304. 

  304. 					</th>

    305. 

  305. 					<th class="title titleid">

    306. 

  306. 						<?php echo JHTML::_('grid.sort',   JText::_( 'ACY_ID' ), 'a.id', $pageInfo->filter->order->dir, $pageInfo->filter->order->value ); ?>

    307. 

  307. 					</th>

    308. 

  308. 				</tr>

    309. 

  309. 			</thead>

    310. 

  310. 			<tfoot>

    311. 

  311. 				<tr>

    312. 

  312. 					<td colspan="5">

    313. 

  313. 						<?php echo $pagination->getListFooter(); ?>

    314. 

  314. 						<?php echo $pagination->getResultsCounter(); ?>

    315. 

  315. 					</td>

    316. 

  316. 				</tr>

    317. 

  317. 			</tfoot>

    318. 

  318. 			<tbody>

    319. 

  319. 				<?php

    320. 

  320. 					$k = 0;

    321. 

  321. 					for($i = 0,$a = count($rows);$i<$a;$i++){

    322. 

  322. 						$row =& $rows[$i];

    323. 

  323. 				?>

    324. 

  324. 					<tr id="content<?php echo $row->id?>" class="<?php echo "row$k"; ?>" onclick="applyContent(<?php echo $row->id.",'row$k'"?>);" style="cursor:pointer;">

    325. 

  325. 						<td class="acytdcheckbox"></td>

    326. 

  326. 						<td>

    327. 

  327. 						<?php

    328. 

  328. 							$text = '<b>'.JText::_('JOOMEXT_ALIAS').': </b>'.$row->alias;

    329. 

  329. 							echo acymailing_tooltip($text, $row->title, '', $row->title);

    330. 

  330. 						?>

    331. 

  331. 						</td>

    332. 

  332. 						<td>

    333. 

  333. 						<?php

    334. 

  334. 							if(!empty($row->name)){

    335. 

  335. 								$text = '<b>'.JText::_('JOOMEXT_NAME').' : </b>'.$row->name;

    336. 

  336. 								$text .= '<br/><b>'.JText::_('ACY_USERNAME').' : </b>'.$row->username;

    337. 

  337. 								$text .= '<br/><b>'.JText::_('ACY_ID').' : </b>'.$row->created_by;

    338. 

  338. 								echo acymailing_tooltip($text, $row->name, '', $row->name);

    339. 

  339. 							}

    340. 

  340. 						?>

    341. 

  341. 						</td>

    342. 

  342. 						<td align="center">

    343. 

  343. 							<?php echo JHTML::_('date',  $row->created, JText::_('DATE_FORMAT_LC4') ); ?>

    344. 

  344. 						</td>

    345. 

  345. 						<td align="center">

    346. 

  346. 							<?php echo $row->id; ?>

    347. 

  347. 						</td>

    348. 

  348. 					</tr>

    349. 

  349. 				<?php

    350. 

  350. 						$k = 1-$k;

    351. 

  351. 					}

    352. 

  352. 				?>

    353. 

  353. 			</tbody>

    354. 

  354. 		</table>

    355. 

  355. 		<input type="hidden" name="boxchecked" value="0" />

    356. 

  356. 		<input type="hidden" name="filter_order" value="<?php echo $pageInfo->filter->order->value; ?>" />

    357. 

  357. 		<input type="hidden" name="filter_order_Dir" value="<?php echo $pageInfo->filter->order->dir; ?>" />

    358. 

  358. 	<?php

    359. 

  359. 	echo $tabs->endPanel();

    360. 

  360. 	echo $tabs->startPanel( JText::_( 'TAG_CATEGORIES' ), 'joomlacontent_auto');

    361. 

  361. 

    362. 

  362. 		$type = JRequest::getString('type');

    363. 

  363. 

    364. 

  364. 	?>

    365. 

  365. 		<br style="font-size:1px"/>

    366. 

  366. 		<script language="javascript" type="text/javascript">

    367. 

  367. 		<!--

    368. 

  368. 			var selectedCategories = new Array();

    369. 

  369. 		<?php if(!ACYMAILING_J16){ ?>

    370. 

  370. 			function applyAutoContent(secid,catid,rowClass){

    371. 

  371. 				if(selectedCategories[secid] && selectedCategories[secid][catid]){

    372. 

  372. 					window.document.getElementById('content_sec'+secid+'_cat'+catid).className = rowClass;

    373. 

  373. 					delete selectedCategories[secid][catid];

    374. 

  374. 				}else{

    375. 

  375. 					if(!selectedCategories[secid]) selectedCategories[secid] = new Array();

    376. 

  376. 					if(secid == 0){

    377. 

  377. 						for(var isec in selectedCategories){

    378. 

  378. 							for(var icat in selectedCategories[isec]){

    379. 

  379. 								if(selectedCategories[isec][icat] == 'content'){

    380. 

  380. 									window.document.getElementById('content_sec'+isec+'_cat'+icat).className = 'row0';

    381. 

  381. 									delete selectedCategories[isec][icat];

    382. 

  382. 								}

    383. 

  383. 							}

    384. 

  384. 						}

    385. 

  385. 					}else{

    386. 

  386. 						if(selectedCategories[0] && selectedCategories[0][0]){

    387. 

  387. 							window.document.getElementById('content_sec0_cat0').className = 'row0';

    388. 

  388. 							delete selectedCategories[0][0];

    389. 

  389. 						}

    390. 

  390. 

    391. 

  391. 						if(catid == 0){

    392. 

  392. 							for(var icat in selectedCategories[secid]){

    393. 

  393. 								if(selectedCategories[secid][icat] == 'content'){

    394. 

  394. 									window.document.getElementById('content_sec'+secid+'_cat'+icat).className = 'row0';

    395. 

  395. 									delete selectedCategories[secid][icat];

    396. 

  396. 								}

    397. 

  397. 							}

    398. 

  398. 						}else{

    399. 

  399. 							if(selectedCategories[secid][0]){

    400. 

  400. 								window.document.getElementById('content_sec'+secid+'_cat0').className = 'row0';

    401. 

  401. 								delete selectedCategories[secid][0];

    402. 

  402. 							}

    403. 

  403. 						}

    404. 

  404. 					}

    405. 

  405. 

    406. 

  406. 					window.document.getElementById('content_sec'+secid+'_cat'+catid).className = 'selectedrow';

    407. 

  407. 					selectedCategories[secid][catid] = 'content';

    408. 

  408. 				}

    409. 

  409. 

    410. 

  410. 				updateAutoTag();

    411. 

  411. 			}

    412. 

  412. 		<?php }else{ ?>

    413. 

  413. 			function applyAutoContent(catid,rowClass){

    414. 

  414. 				if(selectedCategories[catid]){

    415. 

  415. 					window.document.getElementById('content_cat'+catid).className = rowClass;

    416. 

  416. 					delete selectedCategories[catid];

    417. 

  417. 				}else{

    418. 

  418. 					window.document.getElementById('content_cat'+catid).className = 'selectedrow';

    419. 

  419. 					selectedCategories[catid] = 'content';

    420. 

  420. 				}

    421. 

  421. 

    422. 

  422. 				updateAutoTag();

    423. 

  423. 			}

    424. 

  424. 		<?php } ?>

    425. 

  425. 

    426. 

  426. 			function updateAutoTag(){

    427. 

  427. 				tag = '{autocontent:';

    428. 

  428. 			<?php if(!ACYMAILING_J16){ ?>

    429. 

  429. 				for(var isec in selectedCategories){

    430. 

  430. 					for(var icat in selectedCategories[isec]){

    431. 

  431. 						if(selectedCategories[isec][icat] == 'content'){

    432. 

  432. 							if(icat != 0){

    433. 

  433. 								tag += 'cat'+icat+'-';

    434. 

  434. 							}else{

    435. 

  435. 								tag += 'sec'+isec+'-';

    436. 

  436. 							}

    437. 

  437. 						}

    438. 

  438. 					}

    439. 

  439. 				}

    440. 

  440. 			<?php }else{ ?>

    441. 

  441. 				for(var icat in selectedCategories){

    442. 

  442. 					if(selectedCategories[icat] == 'content'){

    443. 

  443. 						tag += icat+'-';

    444. 

  444. 					}

    445. 

  445. 				}

    446. 

  446. 			<?php } ?>

    447. 

  447. 

    448. 

  448. 				if(document.adminForm.min_article && document.adminForm.min_article.value && document.adminForm.min_article.value!=0){ tag += '|min:'+document.adminForm.min_article.value; }

    449. 

  449. 				if(document.adminForm.max_article.value && document.adminForm.max_article.value!=0){ tag += '|max:'+document.adminForm.max_article.value; }

    450. 

  450. 				if(document.adminForm.contentorder.value){ tag += document.adminForm.contentorder.value; }

    451. 

  451. 				if(document.adminForm.contentfilter && document.adminForm.contentfilter.value){ tag += document.adminForm.contentfilter.value; }

    452. 

  452. 				if(document.adminForm.meta_article && document.adminForm.meta_article.value){ tag += '|meta:'+document.adminForm.meta_article.value; }

    453. 

  453. 

    454. 

  454. 				for(var i=0; i < document.adminForm.contenttypeauto.length; i++){

    455. 

  455. 					 if (document.adminForm.contenttypeauto[i].checked){selectedtype = document.adminForm.contenttypeauto[i].value; tag += '|type:'+document.adminForm.contenttypeauto[i].value; }

    456. 

  456. 				}

    457. 

  457. 				for(var i=0; i < document.adminForm.titlelinkauto.length; i++){

    458. 

  458. 					 if (document.adminForm.titlelinkauto[i].checked && document.adminForm.titlelinkauto[i].value.length>1){ tag += '|'+document.adminForm.titlelinkauto[i].value; }

    459. 

  459. 				}

    460. 

  460. 				if(selectedtype != 'title'){

    461. 

  461. 					for(var i=0; i < document.adminForm.authorauto.length; i++){

    462. 

  462. 						 if (document.adminForm.authorauto[i].checked && document.adminForm.authorauto[i].value.length>1){ tag += '|'+document.adminForm.authorauto[i].value; }

    463. 

  463. 					}

    464. 

  464. 					for(var i=0; i < document.adminForm.pictauto.length; i++){

    465. 

  465. 						 if (document.adminForm.pictauto[i].checked){

    466. 

  466. 						 tag += '|pict:'+document.adminForm.pictauto[i].value;

    467. 

  467. 							 if(document.adminForm.pictauto[i].value == 'resized'){

    468. 

  468. 						 		document.getElementById('pictsizeauto').style.display = '';

    469. 

  469. 						 		if(document.adminForm.pictwidthauto.value) tag += '|maxwidth:'+document.adminForm.pictwidthauto.value;

    470. 

  470. 						 		if(document.adminForm.pictheightauto.value) tag += '|maxheight:'+document.adminForm.pictheightauto.value;

    471. 

  471. 						 	}else{

    472. 

  472. 						 		document.getElementById('pictsizeauto').style.display = 'none';

    473. 

  473. 						 	}

    474. 

  474. 						 }

    475. 

  475. 					}

    476. 

  476. 				}

    477. 

  477. 				if(document.adminForm.cols && document.adminForm.cols.value > 1){ tag += '|cols:'+document.adminForm.cols.value; }

    478. 

  478. 				if(window.document.getElementById('jflangauto')  && window.document.getElementById('jflangauto').value != ''){

    479. 

  479. 					tag += '|lang:';

    480. 

  480. 					tag += window.document.getElementById('jflangauto').value;

    481. 

  481. 				}

    482. 

  482. 

    483. 

  483. 				tag += '}';

    484. 

  484. 

    485. 

  485. 				setTag(tag);

    486. 

  486. 			}

    487. 

  487. 		//-->

    488. 

  488. 		</script>

    489. 

  489. 		<table width="100%" class="adminform">

    490. 

  490. 			<tr>

    491. 

  491. 				<td>

    492. 

  492. 					<?php echo JText::_('DISPLAY');?>

    493. 

  493. 				</td>

    494. 

  494. 				<td colspan="2">

    495. 

  495. 				<?php echo JHTML::_('acyselect.radiolist', $contenttype, 'contenttypeauto' , 'size="1" onclick="updateAutoTag();"', 'value', 'text', $this->params->get('default_type','intro'));?>

    496. 

  496. 				</td>

    497. 

  497. 				<td>

    498. 

  498. 					<?php $jflanguages = acymailing_get('type.jflanguages');

    499. 

  499. 						$jflanguages->onclick = 'onchange="updateAutoTag();"';

    500. 

  500. 						$jflanguages->id = 'jflangauto';

    501. 

  501. 						echo $jflanguages->display('langauto'); ?>

    502. 

  502. 				</td>

    503. 

  503. 			</tr>

    504. 

  504. 			<tr>

    505. 

  505. 				<td>

    506. 

  506. 				<?php echo JText::_('CLICKABLE_TITLE'); ?>

    507. 

  507. 				 </td>

    508. 

  508. 				 <td>

    509. 

  509. 				 	<?php echo JHTML::_('acyselect.radiolist', $titlelink, 'titlelinkauto' , 'size="1" onclick="updateAutoTag();"', 'value', 'text', $this->params->get('default_titlelink','link'));?>

    510. 

  510. 				</td>

    511. 

  511. 				<td>

    512. 

  512. 				<?php echo JText::_('AUTHOR_NAME'); ?>

    513. 

  513. 				 </td>

    514. 

  514. 				 <td>

    515. 

  515. 				 	<?php echo JHTML::_('acyselect.radiolist', $authorname, 'authorauto' , 'size="1" onclick="updateAutoTag();"', 'value', 'text', (string) $this->params->get('default_author','0')); ?>

    516. 

  516. 				</td>

    517. 

  517. 			</tr>

    518. 

  518. 			<tr>

    519. 

  519. 				<td valign="top"><?php echo JText::_('DISPLAY_PICTURES'); ?></td>

    520. 

  520. 				<td valign="top"><?php echo JHTML::_('acyselect.radiolist', $picts, 'pictauto' , 'size="1" onclick="updateAutoTag();"', 'value', 'text', $this->params->get('default_pict','1')); ?>

    521. 

  521. 

    522. 

  522. 				<span id="pictsizeauto" <?php if($this->params->get('default_pict','1') != 'resized') echo 'style="display:none;"'; ?> ><br/><?php echo JText::_('CAPTCHA_WIDTH') ?>

    523. 

  523. 					<input name="pictwidthauto" type="text" onchange="updateAutoTag();" value="<?php echo $this->params->get('maxwidth','150');?>" style="width:30px;" />

    524. 

  524. 					x <?php echo JText::_('CAPTCHA_HEIGHT') ?>

    525. 

  525. 					<input name="pictheightauto" type="text" onchange="updateAutoTag();" value="<?php echo $this->params->get('maxheight','150');?>" style="width:30px;" />

    526. 

  526. 				</span>

    527. 

  527. 				</td>

    528. 

  528. 				<td valign="top"><?php echo JText::_('FIELD_COLUMNS'); ?></td>

    529. 

  529. 				<td valign="top"><input type="text" name="cols" style="width:50px" value="1" onchange="updateAutoTag();"/></td>

    530. 

  530. 			</tr>

    531. 

  531. 			<tr>

    532. 

  532. 				<td>

    533. 

  533. 				<?php echo JText::_('MAX_ARTICLE'); ?>

    534. 

  534. 				 </td>

    535. 

  535. 				 <td>

    536. 

  536. 				 	<input type="text" name="max_article" style="width:50px" value="20" onchange="updateAutoTag();"/>

    537. 

  537. 				</td>

    538. 

  538. 				<td>

    539. 

  539. 				<?php echo JText::_('ACY_ORDER'); ?>

    540. 

  540. 				 </td>

    541. 

  541. 				 <td>

    542. 

  542. 				 	<?php $ordertype = acymailing_get('type.contentorder'); $ordertype->onclick = "updateAutoTag();"; echo $ordertype->display('contentorder','|order:id'); ?>

    543. 

  543. 				</td>

    544. 

  544. 			</tr>

    545. 

  545. 			<?php if($this->params->get('metaselect')){ ?>

    546. 

  546. 				<tr>

    547. 

  547. 					<td>

    548. 

  548. 					<?php echo JText::_('META_KEYWORDS'); ?>

    549. 

  549. 					 </td>

    550. 

  550. 					 <td colspan="3">

    551. 

  551. 					 	<input type="text" name="meta_article" style="width:200px" value="" onchange="updateAutoTag();"/>

    552. 

  552. 					</td>

    553. 

  553. 				</tr>

    554. 

  554. 			<?php } ?>

    555. 

  555. 			<?php if($type == 'autonews') { ?>

    556. 

  556. 			<tr>

    557. 

  557. 				<td>

    558. 

  558. 				<?php 	echo JText::_('MIN_ARTICLE'); ?>

    559. 

  559. 				 </td>

    560. 

  560. 				 <td>

    561. 

  561. 				 <input type="text" name="min_article" style="width:50px" value="1" onchange="updateAutoTag();"/>

    562. 

  562. 				</td>

    563. 

  563. 				<td>

    564. 

  564. 				<?php echo JText::_('JOOMEXT_FILTER'); ?>

    565. 

  565. 				 </td>

    566. 

  566. 				 <td>

    567. 

  567. 				 	<?php $filter = acymailing_get('type.contentfilter'); $filter->onclick = "updateAutoTag();"; echo $filter->display('contentfilter','|filter:created'); ?>

    568. 

  568. 				</td>

    569. 

  569. 			</tr>

    570. 

  570. 			<?php } ?>

    571. 

  571. 		</table>

    572. 

  572. 

    573. 

  573. 		<table class="adminlist table table-striped table-hover" cellpadding="1" width="100%">

    574. 

  574. 			<thead>

    575. 

  575. 				<tr>

    576. 

  576. 					<th class="title"></th>

    577. 

  577. 				<?php if(!ACYMAILING_J16){ ?>

    578. 

  578. 					<th class="title">

    579. 

  579. 						<?php echo JText::_( 'SECTION'); ?>

    580. 

  580. 					</th>

    581. 

  581. 				<?php } ?>

    582. 

  582. 					<th class="title">

    583. 

  583. 						<?php echo JText::_( 'TAG_CATEGORIES'); ?>

    584. 

  584. 					</th>

    585. 

  585. 				</tr>

    586. 

  586. 			</thead>

    587. 

  587. 			<tbody>

    588. 

  588. 				<?php

    589. 

  589. 					$k = 0;

    590. 

  590. 					if(!ACYMAILING_J16){

    591. 

  591. 				?>

    592. 

  592. 					<tr id="content_sec0_cat0" class="<?php echo "row$k"; ?>" onclick="applyAutoContent(0,0,'<?php echo "row$k" ?>');" style="cursor:pointer;">

    593. 

  593. 						<td class="acytdcheckbox"></td>

    594. 

  594. 						<td style="font-weight: bold;">

    595. 

  595. 						<?php

    596. 

  596. 							echo JText::_('ACY_ALL');

    597. 

  597. 						?>

    598. 

  598. 						</td>

    599. 

  599. 						<td style="text-align:center;font-weight: bold;">

    600. 

  600. 						<?php

    601. 

  601. 							echo JText::_('ACY_ALL');

    602. 

  602. 						?>

    603. 

  603. 						</td>

    604. 

  604. 					</tr>

    605. 

  605. 

    606. 

  606. 					<?php

    607. 

  607. 					}

    608. 

  608. 

    609. 

  609. 					$k = 1-$k;

    610. 

  610. 					$currentSection = '';

    611. 

  611. 					foreach($categories as $row){

    612. 

  612. 

    613. 

  613. 					if(!ACYMAILING_J16 AND $currentSection != $row->section){

    614. 

  614. 						?>

    615. 

  615. 						<tr id="content_sec<?php echo $row->secid ?>_cat0" class="<?php echo "row$k"; ?>" onclick="applyAutoContent(<?php echo $row->secid ?>,0,'<?php echo "row$k" ?>');" style="cursor:pointer;">

    616. 

  616. 							<td class="acytdcheckbox"></td>

    617. 

  617. 							<td style="font-weight: bold;">

    618. 

  618. 							<?php

    619. 

  619. 								echo $row->section;

    620. 

  620. 							?>

    621. 

  621. 							</td>

    622. 

  622. 							<td style="text-align:center;font-weight: bold;">

    623. 

  623. 							<?php

    624. 

  624. 								echo JText::_('ACY_ALL');

    625. 

  625. 							?>

    626. 

  626. 							</td>

    627. 

  627. 						</tr>

    628. 

  628. 						<?php

    629. 

  629. 						$k = 1-$k;

    630. 

  630. 						$currentSection = $row->section;

    631. 

  631. 					}

    632. 

  632. 					if(!ACYMAILING_J16){

    633. 

  633. 				?>

    634. 

  634. 					<tr id="content_sec<?php echo $row->secid ?>_cat<?php echo $row->catid?>" class="<?php echo "row$k"; ?>" onclick="applyAutoContent(<?php echo $row->secid ?>,<?php echo $row->catid ?>,'<?php echo "row$k" ?>');" style="cursor:pointer;">

    635. 

  635. 						<td class="acytdcheckbox"></td>

    636. 

  636. 						<td>

    637. 

  637. 						</td>

    638. 

  638. 						<td>

    639. 

  639. 						<?php

    640. 

  640. 							echo $row->category;

    641. 

  641. 						?>

    642. 

  642. 						</td>

    643. 

  643. 					</tr>

    644. 

  644. 				<?php

    645. 

  645. 					}else{ ?>

    646. 

  646. 						<tr id="content_cat<?php echo $row->id ?>" class="<?php echo "row$k"; ?>" onclick="applyAutoContent(<?php echo $row->id ?>,'<?php echo "row$k" ?>');" style="cursor:pointer;">

    647. 

  647. 						<td class="acytdcheckbox"></td>

    648. 

  648. 						<td>

    649. 

  649. 						<?php

    650. 

  650. 							echo $row->title;

    651. 

  651. 						?>

    652. 

  652. 						</td>

    653. 

  653. 					</tr>

    654. 

  654. 					<?php }

    655. 

  655. 						$k = 1-$k;

    656. 

  656. 					}

    657. 

  657. 				?>

    658. 

  658. 			</tbody>

    659. 

  659. 		</table>

    660. 

  660. 	<?php

    661. 

  661. 

    662. 

  662. 		echo $tabs->endPanel();

    663. 

  663. 		echo $tabs->endPane();

    664. 

  664. 	 }

    665. 

  665. 

    666. 

  666. 	 function acymailing_replacetags(&$email,$send = true){

    667. 

  667. 		$this->_replaceAuto($email);

    668. 

  668.  		$this->_replaceArticles($email);

    669. 

  669. 	 }

    670. 

  670. 

    671. 

  671. 	 function _replaceArticles(&$email){

    672. 

  672. 

    673. 

  673. 		$match = '#{joomlacontent:(.*)}#Ui';

    674. 

  674. 		$variables = array('subject','body','altbody');

    675. 

  675. 		$found = false;

    676. 

  676. 		foreach($variables as $var){

    677. 

  677. 			if(empty($email->$var)) continue;

    678. 

  678. 			$found = preg_match_all($match,$email->$var,$results[$var]) || $found;

    679. 

  679. 			if(empty($results[$var][0])) unset($results[$var]);

    680. 

  680. 		}

    681. 

  681. 

    682. 

  682. 		if(!$found) return;

    683. 

  683. 

    684. 

  684. 		$this->currentcatid = -1;

    685. 

  685. 

    686. 

  686. 		require_once JPATH_SITE.DS.'components'.DS.'com_content'.DS.'helpers'.DS.'route.php';

    687. 

  687. 

    688. 

  688. 		if($this->params->get('integration') == 'flexicontent' AND file_exists(JPATH_SITE.DS.'components'.DS.'com_flexicontent'.DS.'helpers'.DS.'route.php')){

    689. 

  689. 			require_once JPATH_SITE.DS.'components'.DS.'com_flexicontent'.DS.'helpers'.DS.'route.php';

    690. 

  690. 		}

    691. 

  691. 

    692. 

  692. 		$mailerHelper = acymailing_get('helper.mailer');

    693. 

  693. 

    694. 

  694. 		$htmlreplace = array();

    695. 

  695. 		$textreplace = array();

    696. 

  696. 		$subjectreplace = array();

    697. 

  697. 		foreach($results as $var => $allresults){

    698. 

  698. 			foreach($allresults[0] as $i => $oneTag){

    699. 

  699. 				if(isset($htmlreplace[$oneTag])) continue;

    700. 

  700. 

    701. 

  701. 				$article = $this->_replaceContent($allresults,$i);

    702. 

  702. 				$htmlreplace[$oneTag] = $article;

    703. 

  703. 				$textreplace[$oneTag] = $mailerHelper->textVersion($article);

    704. 

  704. 				$subjectreplace[$oneTag] = strip_tags($article);

    705. 

  705. 			}

    706. 

  706. 		}

    707. 

  707. 

    708. 

  708. 		$email->body = str_replace(array_keys($htmlreplace),$htmlreplace,$email->body);

    709. 

  709. 		$email->altbody = str_replace(array_keys($textreplace),$textreplace,$email->altbody);

    710. 

  710. 		$email->subject = str_replace(array_keys($subjectreplace),$subjectreplace,$email->subject);

    711. 

  711. 	 }

    712. 

  712. 

    713. 

  713. 	 function _replaceContent(&$results,$i){

    714. 

  714. 	 	$acypluginsHelper = acymailing_get('helper.acyplugins');

    715. 

  715. 		$arguments = explode('|',strip_tags($results[1][$i]));

    716. 

  716. 		$tag = new stdClass();

    717. 

  717. 		$tag->id = (int) $arguments[0];

    718. 

  718. 		for($i=1,$a=count($arguments);$i<$a;$i++){

    719. 

  719. 			$args = explode(':',$arguments[$i]);

    720. 

  720. 			$arg0 = trim($args[0]);

    721. 

  721. 			if(empty($arg0)) continue;

    722. 

  722. 			if(isset($args[1])){

    723. 

  723. 				$tag->$arg0 = $args[1];

    724. 

  724. 			}else{

    725. 

  725. 				$tag->$arg0 = true;

    726. 

  726. 			}

    727. 

  727. 		}

    728. 

  728. 

    729. 

  729. 		if(!ACYMAILING_J16){

    730. 

  730. 			$query = 'SELECT a.*,b.name as authorname, c.alias as catalias, c.title as cattitle, s.alias as secalias, s.title as sectitle FROM '.acymailing_table('content',false).' as a ';

    731. 

  731. 			$query .= 'LEFT JOIN '.acymailing_table('users',false).' as b ON a.created_by = b.id ';

    732. 

  732. 			$query .= ' LEFT JOIN '.acymailing_table('categories',false).' AS c ON c.id = a.catid ';

    733. 

  733. 			$query .= ' LEFT JOIN '.acymailing_table('sections',false).' AS s ON s.id = a.sectionid ';

    734. 

  734. 			$query .= 'WHERE a.id = '.$tag->id.' LIMIT 1';

    735. 

  735. 		}else{

    736. 

  736. 			$query = 'SELECT a.*,b.name as authorname, c.alias as catalias, c.title as cattitle FROM '.acymailing_table('content',false).' as a ';

    737. 

  737. 			$query .= 'LEFT JOIN '.acymailing_table('users',false).' as b ON a.created_by = b.id ';

    738. 

  738. 			$query .= ' LEFT JOIN '.acymailing_table('categories',false).' AS c ON c.id = a.catid ';

    739. 

  739. 			$query .= 'WHERE a.id = '.$tag->id.' LIMIT 1';

    740. 

  740. 		}

    741. 

  741. 

    742. 

  742. 		$db = JFactory::getDBO();

    743. 

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

    744. 

  744. 		$article = $db->loadObject();

    745. 

  745. 

    746. 

  746. 		$result = '';

    747. 

  747. 

    748. 

  748. 		if(empty($article)){

    749. 

  749. 			$app = JFactory::getApplication();

    750. 

  750. 			if($app->isAdmin()){

    751. 

  751. 				$app->enqueueMessage('The article "'.$tag->id.'" could not be loaded','notice');

    752. 

  752. 			}

    753. 

  753. 			return $result;

    754. 

  754. 		}

    755. 

  755. 

    756. 

  756. 		if(!empty($tag->lang)){

    757. 

  757. 			$langid = (int) substr($tag->lang,strpos($tag->lang,',')+1);

    758. 

  758. 			if(!empty($langid)){

    759. 

  759. 				$query = "SELECT reference_field, value FROM `#__jf_content` WHERE `published` = 1 AND `reference_table` = 'content' AND `language_id` = $langid AND `reference_id` = ".$tag->id;

    760. 

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

    761. 

  761. 				$translations = $db->loadObjectList();

    762. 

  762. 				if(!empty($translations)){

    763. 

  763. 					foreach($translations as $oneTranslation){

    764. 

  764. 						if(!empty($oneTranslation->value)){

    765. 

  765. 							$translatedfield =  $oneTranslation->reference_field;

    766. 

  766. 							$article->$translatedfield = $oneTranslation->value;

    767. 

  767. 						}

    768. 

  768. 					}

    769. 

  769. 				}

    770. 

  770. 			}

    771. 

  771. 		}

    772. 

  772. 

    773. 

  773. 		$acypluginsHelper = acymailing_get('helper.acyplugins');

    774. 

  774. 		$acypluginsHelper->cleanHtml($article->introtext);

    775. 

  775. 		$acypluginsHelper->cleanHtml($article->fulltext);

    776. 

  776. 

    777. 

  777. 

    778. 

  778. 		if($this->params->get('integration') == 'jreviews' AND !empty($article->images)){

    779. 

  779. 			$firstpict = explode('|',trim(reset(explode("\n",$article->images))). '|||||||');

    780. 

  780. 			if(!empty($firstpict[0])){

    781. 

  781. 				$picturePath = file_exists(ACYMAILING_ROOT.'images'.DS.'stories'.DS.str_replace('/',DS,$firstpict[0])) ? ACYMAILING_LIVE . 'images/stories/' . $firstpict[0] : ACYMAILING_LIVE . 'images/' . $firstpict[0];

    782. 

  782. 				$myPict = '<img src="'.$picturePath. '" alt="" hspace="5" style="margin:5px" align="left" border="'.intval($firstpict[5]).'" />';

    783. 

  783. 				$article->introtext = $myPict.$article->introtext;

    784. 

  784. 			}

    785. 

  785. 		}

    786. 

  786. 		$completeId = $article->id;

    787. 

  787. 		$completeCat = $article->catid;

    788. 

  788. 

    789. 

  789. 		if(!empty($article->alias)) $completeId.=':'.$article->alias;

    790. 

  790. 		if(!empty($article->catalias)) $completeCat .= ':'.$article->catalias;

    791. 

  791. 

    792. 

  792. 		if(empty($tag->itemid)){

    793. 

  793. 			if(!ACYMAILING_J16){

    794. 

  794. 				$completeSec = $article->sectionid;

    795. 

  795. 				if(!empty($article->secalias)) $completeSec .= ':'.$article->secalias;

    796. 

  796. 				if($this->params->get('integration') == 'flexicontent' && class_exists('FlexicontentHelperRoute')){

    797. 

  797. 					$link = FlexicontentHelperRoute::getItemRoute($completeId,$completeCat,$completeSec);

    798. 

  798. 				}else{

    799. 

  799. 					$link = ContentHelperRoute::getArticleRoute($completeId,$completeCat,$completeSec);

    800. 

  800. 				}

    801. 

  801. 			}else{

    802. 

  802. 				if($this->params->get('integration') == 'flexicontent' && class_exists('FlexicontentHelperRoute')){

    803. 

  803. 					$link = FlexicontentHelperRoute::getItemRoute($completeId,$completeCat);

    804. 

  804. 				}else {

    805. 

  805. 					$link = ContentHelperRoute::getArticleRoute($completeId,$completeCat);

    806. 

  806. 				}

    807. 

  807. 			}

    808. 

  808. 		}else{

    809. 

  809. 			$link = 'index.php?option=com_content&view=article&id='.$completeId.'&catid='.$completeCat;

    810. 

  810. 		}

    811. 

  811. 

    812. 

  812. 

    813. 

  813. 		if($this->params->get('integration') == 'flexicontent' && !class_exists('FlexicontentHelperRoute')){

    814. 

  814. 			$link = 'index.php?option=com_flexicontent&view=items&id='.$completeId;

    815. 

  815. 		}elseif($this->params->get('integration') == 'jaggyblog'){

    816. 

  816. 			$link = 'index.php?option=com_jaggyblog&task=viewpost&id='.$completeId;

    817. 

  817. 		}

    818. 

  818. 

    819. 

  819. 		if(!empty($tag->itemid)) $link .= '&Itemid='.$tag->itemid;

    820. 

  820. 

    821. 

  821. 		if(!empty($tag->lang)) $link.= (strpos($link,'?') ? '&' : '?') . 'lang='.substr($tag->lang, 0,strpos($tag->lang,','));

    822. 

  822. 		if(!empty($tag->autologin)) $link.= (strpos($link,'?') ? '&' : '?') . 'user={usertag:username|urlencode}&passw={usertag:password|urlencode}';

    823. 

  823. 

    824. 

  824. 		$link = acymailing_frontendLink($link);

    825. 

  825. 

    826. 

  826. 		$styleTitle = '';

    827. 

  827. 		$styleTitleEnd = '';

    828. 

  828. 		if($tag->type != "title"){

    829. 

  829. 			$styleTitle = '<h2 class="acymailing_title">';

    830. 

  830. 			$styleTitleEnd = '</h2>';

    831. 

  831. 		}

    832. 

  832. 

    833. 

  833. 		if(empty($tag->notitle)){

    834. 

  834. 			if(!empty($tag->link)){

    835. 

  835. 				$result .= '<a href="'.$link.'" ';

    836. 

  836. 				if($tag->type != "title") $result .= 'style="text-decoration:none" name="content-'.$article->id.'" ';

    837. 

  837. 				$result .= 'target="_blank" >'.$styleTitle.$article->title.$styleTitleEnd.'</a>';

    838. 

  838. 			}else{

    839. 

  839. 				$result .= $styleTitle.$article->title.$styleTitleEnd;

    840. 

  840. 			}

    841. 

  841. 		}

    842. 

  842. 

    843. 

  843. 		if(!empty($tag->author)){

    844. 

  844. 			$authorName = empty($article->created_by_alias) ? $article->authorname : $article->created_by_alias;

    845. 

  845. 			if($tag->type == 'title') $result .= '<br/>';

    846. 

  846. 			$result .= '<span class="authorname">'.$authorName.'</span><br/>';

    847. 

  847. 		}

    848. 

  848. 

    849. 

  849. 		if(!empty($tag->created)){

    850. 

  850. 			if($tag->type == 'title') $result .= '<br/>';

    851. 

  851. 			$dateFormat = empty($tag->dateformat) ? JText::_('DATE_FORMAT_LC2') : $tag->dateformat;

    852. 

  852. 			$result .= '<span class="createddate">'.JHTML::_( 'date', $article->created, $dateFormat).'</span><br/>';

    853. 

  853. 		}

    854. 

  854. 

    855. 

  855. 		if(!isset($tag->pict) AND $tag->type != 'title'){

    856. 

  856. 			if($this->params->get('removepictures','never') == 'always' || ($this->params->get('removepictures','never') == 'intro' AND $tag->type == "intro")){

    857. 

  857. 				$tag->pict = 0;

    858. 

  858. 			}else{

    859. 

  859. 				$tag->pict = 1;

    860. 

  860. 			}

    861. 

  861. 		}

    862. 

  862. 

    863. 

  863. 		if(strpos($article->introtext,'jseblod') !== false AND file_exists(ACYMAILING_ROOT.'plugins'.DS.'content'.DS.'cckjseblod.php')){

    864. 

  864. 			global $mainframe;

    865. 

  865. 			include_once(ACYMAILING_ROOT.'plugins'.DS.'content'.DS.'cckjseblod.php');

    866. 

  866. 			if(function_exists('plgContentCCKjSeblod')){

    867. 

  867. 				$paramsContent = JComponentHelper::getParams('com_content');

    868. 

  868. 				$article->text = $article->introtext.$article->fulltext;

    869. 

  869. 				plgContentCCKjSeblod($article,$paramsContent);

    870. 

  870. 				$article->introtext = $article->text;

    871. 

  871. 				$article->fulltext = '';

    872. 

  872. 			}

    873. 

  873. 		}

    874. 

  874. 

    875. 

  875. 		if($tag->type != "title"){

    876. 

  876. 			$contentText = '';

    877. 

  877. 			if($tag->type == "intro"){

    878. 

  878. 				$forceReadMore = false;

    879. 

  879. 				$wordwrap = $this->params->get('wordwrap',0);

    880. 

  880. 				if(!empty($wordwrap) AND empty($article->fulltext)){

    881. 

  881. 					$newintrotext = strip_tags($article->introtext,'<br><img>');

    882. 

  882. 					$numChar = strlen($newintrotext);

    883. 

  883. 					 if($numChar > $wordwrap){

    884. 

  884. 						 $stop = strlen($newintrotext);

    885. 

  885. 						 for($i=$wordwrap;$i<$numChar;$i++){

    886. 

  886. 							 if($newintrotext[$i] == " "){

    887. 

  887. 								 $stop = $i;

    888. 

  888. 								 $forceReadMore = true;

    889. 

  889. 								 break;

    890. 

  890. 							 }

    891. 

  891. 						 }

    892. 

  892. 						 $article->introtext = substr($newintrotext,0,$stop).'...';

    893. 

  893. 					 }

    894. 

  894. 				 }

    895. 

  895. 			}

    896. 

  896. 

    897. 

  897. 			if(empty($article->fulltext) OR $tag->type != "text"){

    898. 

  898. 				$contentText .= $article->introtext;

    899. 

  899. 			}

    900. 

  900. 

    901. 

  901. 			if($tag->type != "intro" AND !empty($article->fulltext)){

    902. 

  902. 				if( $tag->type != "text" && !empty($article->introtext)){

    903. 

  903. 					$contentText .= '<br />';

    904. 

  904. 				}

    905. 

  905. 				$contentText .= $article->fulltext;

    906. 

  906. 			}

    907. 

  907. 

    908. 

  908. 			if(!empty($tag->wrap)){

    909. 

  909. 				$newtext = strip_tags($contentText,'<br><img>');

    910. 

  910. 				$numChar = strlen($newtext);

    911. 

  911. 				 if($numChar > $tag->wrap){

    912. 

  912. 					 $stop = strlen($newtext);

    913. 

  913. 					 for($i=$tag->wrap;$i<$numChar;$i++){

    914. 

  914. 						 if($newtext[$i] == " "){

    915. 

  915. 							 $stop = $i;

    916. 

  916. 							 $forceReadMore = true;

    917. 

  917. 							 break;

    918. 

  918. 						 }

    919. 

  919. 					 }

    920. 

  920. 					 $contentText = substr($newtext,0,$stop).'...';

    921. 

  921. 				 }

    922. 

  922. 			}

    923. 

  923. 

    924. 

  924. 			if(ACYMAILING_J16 && !empty($article->images) && !empty($tag->pict)){

    925. 

  925. 				$picthtml = '';

    926. 

  926. 				$images = json_decode($article->images);

    927. 

  927. 				$pictVar = ($tag->type=='intro') ? 'image_intro' : 'image_fulltext';

    928. 

  928. 				$floatVar = ($tag->type=='intro') ? 'float_intro' : 'float_fulltext';

    929. 

  929. 				if(!empty($images->$pictVar)){

    930. 

  930. 					if($images->$floatVar != 'right') $images->$floatVar = 'left';

    931. 

  931. 					$style = 'float:'.$images->$floatVar.';padding-'.(($images->$floatVar == 'right') ? 'left':'right').':10px;padding-bottom:10px;';

    932. 

  932. 					if(!empty($tag->link)) $picthtml .= '<a href="'.$link.'" style="text-decoration:none" >';

    933. 

  933. 					$picthtml .= '<img style="'.$style.'" alt="" border="0" src="'.JURI::root().$images->$pictVar.'" />';

    934. 

  934. 					if(!empty($tag->link)) $picthtml .= '</a>';

    935. 

  935. 					$contentText = $picthtml.$contentText;

    936. 

  936. 				}

    937. 

  937. 			}

    938. 

  938. 

    939. 

  939. 			if(!empty($tag->clean)){

    940. 

  940. 				$contentText = strip_tags($contentText,'<p><br><span><ul><li><h1><h2><h3><h4><a>');

    941. 

  941. 			}

    942. 

  942. 

    943. 

  943. 			$result .= $contentText;

    944. 

  944. 

    945. 

  945. 			if($tag->type == "intro"){

    946. 

  946. 				if(empty($tag->noreadmore) AND (!empty($article->fulltext) OR $forceReadMore)){

    947. 

  947. 					$readMoreText = empty($tag->readmore) ? JText::_('JOOMEXT_READ_MORE') : $tag->readmore;

    948. 

  948. 					$result .= '<a style="text-decoration:none;" target="_blank" href="'.$link.'"><span class="acymailing_readmore">'.$readMoreText.'</span></a>';

    949. 

  949. 				}

    950. 

  950. 			}

    951. 

  951. 			$result = '<table cellspacing="0" cellpadding="0" border="0" width="100%"><tr><td class="cat_'.@$article->catid.'" ><div class="acymailing_content" >'.$result.'</div></td></tr></table>';

    952. 

  952. 		}

    953. 

  953. 

    954. 

  954. 		if(!empty($tag->theme)){

    955. 

  955. 			if(preg_match('#<img[^>]*>#Uis',$article->introtext.$article->fulltext,$pregresult)){

    956. 

  956. 				$cleanContent = strip_tags($result,'<p><br><span><ul><li><h1><h2><h3><h4><a>');

    957. 

  957. 				$tdwidth = (empty($tag->maxwidth) ? $this->params->get('maxwidth',150) : $tag->maxwidth) + 20;

    958. 

  958. 				$result = '<div class="acymailing_content"><table cellspacing="0" width="500" cellpadding="0" border="0" ><tr><td class="contentpicture" width="'.$tdwidth.'" valign="top" align="center"><a href="'.$link.'" target="_blank" style="border:0px;text-decoration:none">'.$pregresult[0].'</a></td><td class="contenttext">'.$cleanContent.'</td></tr></table></div>';

    959. 

  959. 			}

    960. 

  960. 		}

    961. 

  961. 

    962. 

  962. 		if(!empty($tag->cattitle) && $this->currentcatid != $article->catid){

    963. 

  963. 			$this->currentcatid = $article->catid;

    964. 

  964. 			$result = '<h3 class="cattitle">'.$article->cattitle.'</h3>'.$result;

    965. 

  965. 		}

    966. 

  966. 

    967. 

  967. 		if(file_exists(ACYMAILING_MEDIA.'plugins'.DS.'tagcontent_html.php')){

    968. 

  968. 			ob_start();

    969. 

  969. 			require(ACYMAILING_MEDIA.'plugins'.DS.'tagcontent_html.php');

    970. 

  970. 			$result = ob_get_clean();

    971. 

  971. 		}elseif(file_exists(ACYMAILING_MEDIA.'plugins'.DS.'tagcontent.php')){

    972. 

  972. 			ob_start();

    973. 

  973. 			require(ACYMAILING_MEDIA.'plugins'.DS.'tagcontent.php');

    974. 

  974. 			$result = ob_get_clean();

    975. 

  975. 		}

    976. 

  976. 

    977. 

  977. 		$result = $acypluginsHelper->removeJS($result);

    978. 

  978. 

    979. 

  979. 		if(isset($tag->pict)){

    980. 

  980. 			$pictureHelper = acymailing_get('helper.acypict');

    981. 

  981. 			$pictureHelper->maxHeight = empty($tag->maxheight) ? $this->params->get('maxheight',150) : $tag->maxheight;

    982. 

  982. 			$pictureHelper->maxWidth = empty($tag->maxwidth) ? $this->params->get('maxwidth',150) : $tag->maxwidth;

    983. 

  983. 			if($tag->pict == '0'){

    984. 

  984. 				$result = $pictureHelper->removePictures($result);

    985. 

  985. 			}elseif($tag->pict == 'resized'){

    986. 

  986. 				if($pictureHelper->available()){

    987. 

  987. 					$result = $pictureHelper->resizePictures($result);

    988. 

  988. 				}elseif($app->isAdmin()){

    989. 

  989. 					$app->enqueueMessage($pictureHelper->error,'notice');

    990. 

  990. 				}

    991. 

  991. 			}

    992. 

  992. 		}

    993. 

  993. 		return $result;

    994. 

  994. 

    995. 

  995. 	}

    996. 

  996. 

    997. 

  997. 	function _replaceAuto(&$email){

    998. 

  998. 		$this->acymailing_generateautonews($email);

    999. 

  999. 

    1000. 

  1000. 		if(!empty($this->tags)){

    1001. 

  1001. 			$email->body = str_replace(array_keys($this->tags),$this->tags,$email->body);

    1002. 

  1002. 			if(!empty($email->altbody)) $email->altbody = str_replace(array_keys($this->tags),$this->tags,$email->altbody);

    1003. 

  1003. 			foreach($this->tags as $tag => $result){

    1004. 

  1004. 				$email->subject = str_replace($tag,strip_tags(preg_replace('#</tr>[^<]*<tr[^>]*>#Uis',' | ',$result)),$email->subject);

    1005. 

  1005. 			}

    1006. 

  1006. 		}

    1007. 

  1007. 	}

    1008. 

  1008. 

    1009. 

  1009. 	function acymailing_generateautonews(&$email){

    1010. 

  1010. 		$acypluginsHelper = acymailing_get('helper.acyplugins');

    1011. 

  1011. 		$return = new stdClass();

    1012. 

  1012. 		$return->status = true;

    1013. 

  1013. 		$return->message = '';

    1014. 

  1014. 

    1015. 

  1015. 		$time = time();

    1016. 

  1016. 

    1017. 

  1017. 

    1018. 

  1018. 		$match = '#{autocontent:(.*)}#Ui';

    1019. 

  1019. 		$variables = array('subject','body','altbody');

    1020. 

  1020. 		$found = false;

    1021. 

  1021. 		foreach($variables as $var){

    1022. 

  1022. 			if(empty($email->$var)) continue;

    1023. 

  1023. 			$found = preg_match_all($match,$email->$var,$results[$var]) || $found;

    1024. 

  1024. 			if(empty($results[$var][0])) unset($results[$var]);

    1025. 

  1025. 		}

    1026. 

  1026. 

    1027. 

  1027. 		if(!$found) return $return;

    1028. 

  1028. 

    1029. 

  1029. 		$this->tags = array();

    1030. 

  1030. 		$db = JFactory::getDBO();

    1031. 

  1031. 

    1032. 

  1032. 		foreach($results as $var => $allresults){

    1033. 

  1033. 			foreach($allresults[0] as $i => $oneTag){

    1034. 

  1034. 				if(isset($this->tags[$oneTag])) continue;

    1035. 

  1035. 

    1036. 

  1036. 				$arguments = explode('|',strip_tags($allresults[1][$i]));

    1037. 

  1037. 				$allcats = explode('-',$arguments[0]);

    1038. 

  1038. 				$parameter = new stdClass();

    1039. 

  1039. 				for($a=1;$a<count($arguments);$a++){

    1040. 

  1040. 					$args = explode(':',$arguments[$a]);

    1041. 

  1041. 					$arg0 = trim($args[0]);

    1042. 

  1042. 					if(empty($arg0)) continue;

    1043. 

  1043. 					if(isset($args[1])){

    1044. 

  1044. 						$parameter->$arg0 = $args[1];

    1045. 

  1045. 					}else{

    1046. 

  1046. 						$parameter->$arg0 = true;

    1047. 

  1047. 					}

    1048. 

  1048. 				}

    1049. 

  1049. 				$selectedArea = array();

    1050. 

  1050. 				foreach($allcats as $oneCat){

    1051. 

  1051. 					if(!ACYMAILING_J16){

    1052. 

  1052. 						$sectype = substr($oneCat,0,3);

    1053. 

  1053. 						$num = substr($oneCat,3);

    1054. 

  1054. 						if(empty($num)) continue;

    1055. 

  1055. 						if($sectype=='cat'){

    1056. 

  1056. 							$selectedArea[] = 'catid = '.(int) $num;

    1057. 

  1057. 						}elseif($sectype=='sec'){

    1058. 

  1058. 							$selectedArea[] = 'sectionid = '.(int) $num;

    1059. 

  1059. 						}

    1060. 

  1060. 					}else{

    1061. 

  1061. 						if(empty($oneCat)) continue;

    1062. 

  1062. 						$selectedArea[] = (int) $oneCat;

    1063. 

  1063. 					}

    1064. 

  1064. 				}

    1065. 

  1065. 				$query = 'SELECT a.id FROM `#__content` as a ';

    1066. 

  1066. 				$where = array();

    1067. 

  1067. 				if(!empty($parameter->featured)){

    1068. 

  1068. 					if(ACYMAILING_J16){

    1069. 

  1069. 						$where[] = 'a.featured = 1';

    1070. 

  1070. 					}else{

    1071. 

  1071. 						$query .= 'JOIN `#__content_frontpage` as b ON a.id = b.content_id ';

    1072. 

  1072. 						$where[] = 'b.content_id IS NOT NULL';

    1073. 

  1073. 					}

    1074. 

  1074. 				}

    1075. 

  1075. 

    1076. 

  1076. 				if(!empty($parameter->nofeatured)){

    1077. 

  1077. 					if(ACYMAILING_J16){

    1078. 

  1078. 						$where[] = 'a.featured = 0';

    1079. 

  1079. 					}else{

    1080. 

  1080. 						$query .= 'LEFT JOIN `#__content_frontpage` as b ON a.id = b.content_id ';

    1081. 

  1081. 						$where[] = 'b.content_id IS NULL';

    1082. 

  1082. 					}

    1083. 

  1083. 				}

    1084. 

  1084. 

    1085. 

  1085. 				if(ACYMAILING_J16 && !empty($parameter->subcats) && !empty($selectedArea)){

    1086. 

  1086. 					$db->setQuery('SELECT lft,rgt FROM #__categories WHERE id IN ('.implode(',',$selectedArea).')');

    1087. 

  1087. 					$catinfos = $db->loadObjectList();

    1088. 

  1088. 					if(!empty($catinfos)){

    1089. 

  1089. 						$whereCats = array();

    1090. 

  1090. 						foreach($catinfos as $onecat){

    1091. 

  1091. 							$whereCats[] = 'lft > '.$onecat->lft.' AND rgt < '.$onecat->rgt;

    1092. 

  1092. 						}

    1093. 

  1093. 						$db->setQuery('SELECT id FROM #__categories WHERE ('.implode(') OR (',$whereCats).')');

    1094. 

  1094. 						$othercats = acymailing_loadResultArray($db);

    1095. 

  1095. 						$selectedArea = array_merge($selectedArea,$othercats);

    1096. 

  1096. 					}

    1097. 

  1097. 				}

    1098. 

  1098. 

    1099. 

  1099. 				if(!empty($selectedArea)){

    1100. 

  1100. 					if(!ACYMAILING_J16){

    1101. 

  1101. 						$where[] = implode(' OR ',$selectedArea);

    1102. 

  1102. 					}else{

    1103. 

  1103. 						$where[] = '`catid` IN ('.implode(',',$selectedArea).')';

    1104. 

  1104. 					}

    1105. 

  1105. 				}

    1106. 

  1106. 

    1107. 

  1107. 				if(!empty($parameter->excludedcats)){

    1108. 

  1108. 					$excludedCats = explode('-',$parameter->excludedcats);

    1109. 

  1109. 					JArrayHelper::toInteger($excludedCats);

    1110. 

  1110. 					$where[] = '`catid` NOT IN ("'.implode('","',$excludedCats).'")';

    1111. 

  1111. 				}

    1112. 

  1112. 

    1113. 

  1113. 				if(!empty($parameter->filter) AND !empty($email->params['lastgenerateddate'])){

    1114. 

  1114. 					$condition = '`publish_up` >\''.date( 'Y-m-d H:i:s',$email->params['lastgenerateddate'] - date('Z')).'\'';

    1115. 

  1115. 					$condition .= ' OR `created` >\''.date( 'Y-m-d H:i:s',$email->params['lastgenerateddate'] - date('Z')).'\'';

    1116. 

  1116. 					if($parameter->filter == 'modify'){

    1117. 

  1117. 						$condition .= ' OR (';

    1118. 

  1118. 						$condition .= ' `modified` > \''.date( 'Y-m-d H:i:s',$email->params['lastgenerateddate'] - date('Z')).'\'';

    1119. 

  1119. 						if(!empty($parameter->maxpublished)) $condition .= ' AND `publish_up` > \''.date( 'Y-m-d H:i:s',time() - date('Z') - ((int)$parameter->maxpublished*60*60*24)).'\'';

    1120. 

  1120. 						$condition .= ')';

    1121. 

  1121. 					}

    1122. 

  1122. 

    1123. 

  1123. 					$where[] = $condition;

    1124. 

  1124. 				}

    1125. 

  1125. 

    1126. 

  1126. 				if(!empty($parameter->maxcreated)){

    1127. 

  1127. 					$date = strtotime($parameter->maxcreated);

    1128. 

  1128. 					if(empty($date)){

    1129. 

  1129. 						acymailing_display('Wrong date format ('.$parameter->maxcreated.' in '.$oneTag.'), please use YYYY-MM-DD','warning');

    1130. 

  1130. 					}

    1131. 

  1131. 					$where[] = 	'`created` < '.$db->Quote(date('Y-m-d H:i:s',$date));

    1132. 

  1132. 				}

    1133. 

  1133. 

    1134. 

  1134. 				if(!empty($parameter->mincreated)){

    1135. 

  1135. 					$date = strtotime($parameter->mincreated);

    1136. 

  1136. 					if(empty($date)){

    1137. 

  1137. 						acymailing_display('Wrong date format ('.$parameter->mincreated.' in '.$oneTag.'), please use YYYY-MM-DD','warning');

    1138. 

  1138. 					}

    1139. 

  1139. 					$where[] = 	'`created` > '.$db->Quote(date('Y-m-d H:i:s',$date));

    1140. 

  1140. 				}

    1141. 

  1141. 

    1142. 

  1142. 

    1143. 

  1143. 				if(!empty($parameter->meta)){

    1144. 

  1144. 					$allMetaTags = explode(',',$parameter->meta);

    1145. 

  1145. 					$metaWhere = array();

    1146. 

  1146. 					foreach($allMetaTags as $oneMeta){

    1147. 

  1147. 						if(empty($oneMeta)) continue;

    1148. 

  1148. 						$metaWhere[] = "`metakey` LIKE '%".acymailing_getEscaped($oneMeta,true)."%'";

    1149. 

  1149. 					}

    1150. 

  1150. 					if(!empty($metaWhere)) $where[] = implode(' OR ',$metaWhere);

    1151. 

  1151. 				}

    1152. 

  1152. 

    1153. 

  1153. 				$where[] = '`publish_up` < \'' .date( 'Y-m-d H:i:s',$time - date('Z')).'\'';

    1154. 

  1154. 				$where[] = '`publish_down` > \''.date( 'Y-m-d H:i:s',$time - date('Z')).'\' OR `publish_down` = 0';

    1155. 

  1155. 				$where[] = 'state = 1';

    1156. 

  1156. 				if(!ACYMAILING_J16){

    1157. 

  1157. 					if(isset($parameter->access)){

    1158. 

  1158. 						$where[] = 'access <= '.intval($parameter->access);

    1159. 

  1159. 					}else{

    1160. 

  1160. 						if($this->params->get('contentaccess','registered') == 'registered') $where[] = 'access <= 1';

    1161. 

  1161. 						elseif($this->params->get('contentaccess','registered') == 'public') $where[] = 'access = 0';

    1162. 

  1162. 					}

    1163. 

  1163. 				}elseif(isset($parameter->access)){

    1164. 

  1164. 					$where[] = 'access = '.intval($parameter->access);

    1165. 

  1165. 				}

    1166. 

  1166. 

    1167. 

  1167. 				if(!empty($parameter->language)){

    1168. 

  1168. 					$allLanguages = explode(',',$parameter->language);

    1169. 

  1169. 					$langWhere = 'language IN (';

    1170. 

  1170. 					foreach($allLanguages as $oneLanguage){

    1171. 

  1171. 						$langWhere .= $db->Quote(trim($oneLanguage)).',';

    1172. 

  1172. 					}

    1173. 

  1173. 					$where[] = trim($langWhere,',').')';

    1174. 

  1174. 				}

    1175. 

  1175. 

    1176. 

  1176. 				$query .= ' WHERE ('.implode(') AND (',$where).')';

    1177. 

  1177. 				if(!empty($parameter->order)){

    1178. 

  1178. 					if($parameter->order == 'rand'){

    1179. 

  1179. 						$query .= ' ORDER BY rand()';

    1180. 

  1180. 					}else{

    1181. 

  1181. 						$ordering = explode(',',$parameter->order);

    1182. 

  1182. 						$query .= ' ORDER BY `'.acymailing_secureField($ordering[0]).'` '.acymailing_secureField($ordering[1]);

    1183. 

  1183. 					}

    1184. 

  1184. 				}

    1185. 

  1185. 

    1186. 

  1186. 				$start = '';

    1187. 

  1187. 				if(!empty($parameter->start)) $start = intval($parameter->start).',';

    1188. 

  1188. 

    1189. 

  1189. 				if(empty($parameter->max)) $parameter->max = 100;

    1190. 

  1190. 

    1191. 

  1191. 				$query .= ' LIMIT '.$start.(int) $parameter->max;

    1192. 

  1192. 

    1193. 

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

    1194. 

  1194. 				$allArticles = acymailing_loadResultArray($db);

    1195. 

  1195. 

    1196. 

  1196. 				if(!empty($parameter->min) AND count($allArticles)< $parameter->min){

    1197. 

  1197. 					$return->status = false;

    1198. 

  1198. 					$return->message = 'Not enough articles for the tag '.$oneTag.' : '.count($allArticles).' / '.$parameter->min.' between '.acymailing_getDate($email->params['lastgenerateddate']).' and '.acymailing_getDate($time);

    1199. 

  1199. 				}

    1200. 

  1200. 

    1201. 

  1201. 				$stringTag = '';

    1202. 

  1202. 				if(!empty($allArticles)){

    1203. 

  1203. 					if(file_exists(ACYMAILING_MEDIA.'plugins'.DS.'autocontent.php')){

    1204. 

  1204. 						ob_start();

    1205. 

  1205. 						require(ACYMAILING_MEDIA.'plugins'.DS.'autocontent.php');

    1206. 

  1206. 						$stringTag = ob_get_clean();

    1207. 

  1207. 					}else{

    1208. 

  1208. 						$arrayElements = array();

    1209. 

  1209. 						$numArticle = 1;

    1210. 

  1210. 						foreach($allArticles as $oneArticleId){

    1211. 

  1211. 							$args = array();

    1212. 

  1212. 							$args[] = 'joomlacontent:'.$oneArticleId;

    1213. 

  1213. 							$args[] = 'num:'.$numArticle++;

    1214. 

  1214. 							if(!empty($parameter->type)) $args[] = 'type:'.$parameter->type;

    1215. 

  1215. 							if(!empty($parameter->link)) $args[] = 'link';

    1216. 

  1216. 							if(!empty($parameter->author)) $args[] = 'author';

    1217. 

  1217. 							if(!empty($parameter->autologin)) $args[] = 'autologin';

    1218. 

  1218. 							if(!empty($parameter->cattitle)) $args[] = 'cattitle';

    1219. 

  1219. 							if(!empty($parameter->lang)) $args[] = 'lang:'.$parameter->lang;

    1220. 

  1220. 							if(!empty($parameter->theme)) $args[] = 'theme';

    1221. 

  1221. 							if(!empty($parameter->clean)) $args[] = 'clean';

    1222. 

  1222. 							if(!empty($parameter->notitle)) $args[] = 'notitle';

    1223. 

  1223. 							if(!empty($parameter->created)) $args[] = 'created';

    1224. 

  1224. 							if(!empty($parameter->itemid)) $args[] = 'itemid:'.$parameter->itemid;

    1225. 

  1225. 							if(!empty($parameter->noreadmore)) $args[] = 'noreadmore';

    1226. 

  1226. 							if(isset($parameter->pict)) $args[] = 'pict:'.$parameter->pict;

    1227. 

  1227. 							if(!empty($parameter->wrap)) $args[] = 'wrap:'.$parameter->wrap;

    1228. 

  1228. 							if(!empty($parameter->maxwidth)) $args[] = 'maxwidth:'.$parameter->maxwidth;

    1229. 

  1229. 							if(!empty($parameter->maxheight)) $args[] = 'maxheight:'.$parameter->maxheight;

    1230. 

  1230. 							if(!empty($parameter->readmore)) $args[] = 'readmore:'.$parameter->readmore;

    1231. 

  1231. 							if(!empty($parameter->dateformat)) $args[] = 'dateformat:'.$parameter->dateformat;

    1232. 

  1232. 							$arrayElements[] = '{'.implode('|',$args).'}';

    1233. 

  1233. 						}

    1234. 

  1234. 						$stringTag = $acypluginsHelper->getFormattedResult($arrayElements,$parameter);

    1235. 

  1235. 					}

    1236. 

  1236. 				}

    1237. 

  1237. 

    1238. 

  1238. 				$this->tags[$oneTag] = $stringTag;

    1239. 

  1239. 			}

    1240. 

  1240. 		}

    1241. 

  1241. 

    1242. 

  1242. 		return $return;

    1243. 

  1243. 	}

    1244. 

  1244. 

    1245. 

  1245. }//endclass

    1246. 

  1246.