function getList(&$params) { global $mainframe; $db =& JFactory::getDBO(); $user = JFactory::getUser(); $userId = (int) $user->get('id'); $count = (int) $params->get('count', 5); $offset = (int) $params->get('offset', 0); $catid = $params->get('catid'); if ($params->get('incsub')) { for ($i = 0; $i <= count($catid) - 1; $i++) { $query = 'SELECT id FROM #__categories WHERE extension = "com_content" AND parent_id = ' . $catid[$i]; $db->setQuery($query); $subs = $db->loadResultArray(); if ($subs) { foreach ($subs as $s) { $catid[count($catid)] = $s; } } } if (is_array($catid)) { $catid = implode(", ", $catid); } } else { if (is_array($catid)) { $catid = implode(", ", $catid); } } $aid = $user->get('access'); $access = !JComponentHelper::getParams('com_content')->get('show_noauth'); $authorised = JAccess::getAuthorisedViewLevels(JFactory::getUser()->get('id')); $aid = 0; foreach ($authorised as $a) { if ($a > $aid) { $aid = $a; } } $nullDate = $db->getNullDate(); $date =& JFactory::getDate(); if (method_exists($date, 'toMySQL')) { $now = $date->toMySQL(); } else { $now = $date->toSQL(); } $cssfields = false; if ($params->get('style') == 1 || $params->get('style') == 2) { $cssfields = true; } /* IMAGE CHECKS - Before activating everything concerning images or categories, make sure you need them! */ $chpos = ' ' . $params->get("pos_head") . ' ' . $params->get("pos_topL") . ' ' . $params->get("pos_topR") . ' ' . $params->get("pos_mainL") . ' ' . $params->get("pos_mainC") . ' ' . $params->get("pos_mainR") . ' ' . $params->get("pos_botL") . ' ' . $params->get("pos_botR") . ' ' . $params->get("pos_foot"); $chimg1 = strrpos($chpos, '[image1]'); $chimg2 = strrpos($chpos, '[image2]'); $chimg3 = strrpos($chpos, '[image3]'); $chcats = strrpos($chpos, '[categories]'); // User Filter $wauth = ''; switch ($params->get('user_id')) { case 'by_me': if ($userId) { $wauth = '(a.created_by = ' . (int) $userId . ' OR a.modified_by = ' . (int) $userId . ')'; } if (!$userId) { $wauth = ' AND (a.created_by = 0)'; } break; case 'not_me': if ($userId) { $wauth = '(created_by <> ' . (int) $userId . ' AND modified_by <> ' . (int) $userId . ')'; } break; case 'sel': if (!$params->get('sauth')) { $authors = $params->get('authors'); if (is_array($authors)) { $authors = implode(",", $authors); } $wauth = "a.created_by IN ( {$authors} )"; } break; } // Options related to the article you're viewing at the moment $nocur = ''; if ($params->get('cco') || $params->get('sauth') || !$params->get('nocur')) { $temp = JRequest::getVar('id'); $cview = JRequest::getCmd('view'); if ($temp) { if ($cview == "article") { // Article View // Articles from the same category if ($params->get('cco')) { $catid = JRequest::getVar('catid'); // Include Subcategories Support if ($params->get('incsub')) { $asd = $catid; $catid = array(); $catid[0] = $asd; for ($i = 0; $i <= count($catid) - 1; $i++) { $query = 'SELECT id FROM #__categories WHERE extension = "com_content" AND parent_id = ' . $catid[$i]; $db->setQuery($query); $subs = $db->loadResultArray(); if ($subs) { foreach ($subs as $s) { $catid[count($catid)] = $s; } } } if (is_array($catid)) { $catid = implode(", ", $catid); } } } // Articles by the same author if ($params->get('sauth')) { $query = 'SELECT created_by FROM #__content WHERE id = ' . $temp; $db->setQuery($query); $sauth = $db->loadResult(); $wauth = " AND a.created_by = " . $sauth . " "; } // Don't Show Current Article if (!$params->get('nocur')) { $nocur = 'a.id <> ' . $temp; } } elseif ($cview == "category") { // Category View // Articles from the same category if ($params->get('cco')) { $catid = $temp; } } else { $temp = ""; } } } // Prepare Comments table and column if ($params->get('ctab') == '3') { $ctable = '#__webeeComment_Comment'; $cartcol = 'articleId'; } elseif ($params->get('ctab') == '5') { $ctable = '#__yvcomment'; $cartcol = 'parentid'; } elseif ($params->get('ctab') == '6') { $ctable = '#__zimbcomment_comment'; $cartcol = 'articleId'; } elseif ($params->get('ctab') == '7') { $ctable = '#__rdbs_comment_comments'; $cartcol = 'refid'; } elseif ($params->get('ctab') == '8') { $ctable = '#__comments'; $cartcol = 'cotid'; } elseif ($params->get('ctab') == '9') { $ctable = '#__jomcomment'; $cartcol = 'contentid'; } elseif ($params->get('ctab') == '10') { $ctable = "#__kunena_messages AS m JOIN #__kunenadiscuss AS d ON m.thread = d.thread_id"; $cartcol = "d.content_id"; } elseif ($params->get('ctab') == '4') { $ctable = '#__jcomments'; $cartcol = 'object_id'; } elseif ($params->get('ctab') == '11') { $ctable = '#__udjacomments'; $cartcol = 'comment_url'; } elseif ($params->get('ctab') == '12') { $ctable = '#__jacomment_items'; $cartcol = 'contentid'; } elseif ($params->get('ctab') == '13') { $ctable = '#__comment'; $cartcol = 'contentid'; } elseif ($params->get('ctab') == '2') { $ctable = $params->get('custab'); $cartcol = $params->get('custart'); } // Last X days $recent = $params->get('recent', 0); $recentwo = $params->get('recentwo', 0); // Related Articles $relatedcond = ''; if ($params->get('related')) { $remp = JRequest::getString('id'); $remp = explode(':', $remp); $id = $remp[0]; if ($id) { if ($params->get('related') == 1) { $query = 'SELECT metakey' . ' FROM #__content' . ' WHERE id = ' . (int) $id; $db->setQuery($query); $metakey = trim($db->loadResult()); if ($metakey) { // explode the meta keys on a comma $keys = explode(',', $metakey); $likes = array(); // assemble any non-blank word(s) $relatedcond = ""; foreach ($keys as $key) { $key = trim($key); if ($key) { $likes[] = ',' . $db->getEscaped($key) . ','; // surround with commas so first and last items have surrounding commas } $glue = "%' OR CONCAT(',', REPLACE(a.metakey,', ',','),',') LIKE '%"; $relatedcond = "\n AND ( CONCAT(',', REPLACE(a.metakey,', ',','),',') LIKE '%" . implode($glue, $likes) . "%' )"; } $relnorepeat = "\n AND a.id <> " . $id; if (empty($relatedcond) && empty($relnorepeat)) { $relatedcond = ""; $relnorepeat = ""; } } else { $relatedcond = "\n AND a.id = 'die'"; $relnorepeat = ""; } } elseif ($params->get('related') == 2) { $query = 'SELECT title' . ' FROM #__content' . ' WHERE id = ' . (int) $id; $db->setQuery($query); $metakey = trim($db->loadResult()); $metakey = preg_replace('/[^a-zA-Z0-9 ]/', '', $metakey); $metakey = preg_replace("/\\b[^\\s]{1,3}\\b/", "", $metakey); $metakey = preg_replace('/\\s+/', ' ', $metakey); $metakey = str_replace(" ", ", ", $metakey); if ($metakey) { // explode the meta keys on a comma $keys = explode(',', $metakey); $likes = array(); // assemble any non-blank word(s) foreach ($keys as $key) { $key = trim($key); if ($key) { $likes[] = ' ' . $db->getEscaped($key) . ' '; // surround with commas so first and last items have surrounding commas } $glue = "%' OR CONCAT(' ', REPLACE(a.title,' ',' '),' ') LIKE '%"; $relatedcond = "( CONCAT(' ', REPLACE(a.title,' ',' '),' ') LIKE '%" . implode($glue, $likes) . "%' )"; } $relnorepeat = "a.id <> " . $id; if (empty($relatedcond) && empty($relnorepeat)) { $relatedcond = ""; $relnorepeat = ""; } } else { $relatedcond = "a.id = 'die'"; $relnorepeat = ""; } } } else { $relatedcond = "a.id = 'die'"; $relnorepeat = ""; } } else { $relatedcond = ""; $relnorepeat = ""; } // Ordering //Order by Comments $oc = ""; //Events Ordering $evcon = ""; if ($params->get("dasc")) { $dasc = "DESC"; } else { $dasc = "ASC"; } if ($params->get("sdasc")) { $sdasc = "DESC"; } else { $sdasc = "ASC"; } /* Primary */ if ($params->get('ordering') == 0) { $ordering = 'a.modified ' . $dasc; } elseif ($params->get('ordering') == 1) { $ordering = 'a.created ' . $dasc; } elseif ($params->get('ordering') == 2) { $ordering = 'a.hits ' . $dasc; } elseif ($params->get('ordering') == 3) { $ordering = 'RAND() '; } elseif ($params->get('ordering') == 11) { $ordering = 'a.publish_up ' . $dasc; } elseif ($params->get('ordering') == 12) { $ordering = 'a.publish_down ' . $dasc; } elseif ($params->get('ordering') == 13) { $ordering = 'a.ordering ' . $dasc; } elseif ($params->get('ordering') == 4) { $ordering = 'a.title ' . $dasc; } elseif ($params->get('ordering') == 5) { $ordering = 'r.rating_sum / r.rating_count ' . $dasc; } elseif ($params->get('ordering') == 6) { $ordering = 'r.rating_count ' . $dasc; } elseif ($params->get('ordering') == 7) { $ordering = 'a.id ' . $dasc; } elseif ($params->get('ordering') == 8) { if ($params->get('ctab') != '0') { if ($params->get('ctab') == '11') { //Udjacomments support $oc = "(SELECT COUNT(*) FROM " . $ctable . " WHERE " . $cartcol . ' = ( "com_content:" + a.id ) AS comen'; } else { $oc = "(SELECT COUNT(*) FROM " . $ctable . " WHERE " . $cartcol . " = a.id ) AS comen"; } $ordering = 'comen ' . $dasc; } else { echo '<span class="aidawarning">' . JText::_('COMORDWARNING') . '</span>'; $ordering = " RAND()"; } } elseif ($params->get('ordering') == 9) { $ordering = 'a.publish_down ASC'; $evcon = "\n AND a.publish_down >= '{$now}' "; } elseif ($params->get('ordering') == 10) { $ordering = 'f.ordering ' . $dasc; } /* Secondary */ if ($params->get('sord') == 20) { $ordering .= ', a.modified ' . $sdasc; } elseif ($params->get('sord') == 1) { $ordering .= ', a.created ' . $sdasc; } elseif ($params->get('sord') == 2) { $ordering .= ', a.hits ' . $sdasc; } elseif ($params->get('sord') == 3) { $ordering .= ', RAND() '; } elseif ($params->get('sord') == 11) { $ordering .= ', a.publish_up ' . $sdasc; } elseif ($params->get('sord') == 12) { $ordering .= ', a.publish_down ' . $sdasc; } elseif ($params->get('sord') == 13) { $ordering .= ', a.ordering ' . $sdasc; } elseif ($params->get('sord') == 4) { $ordering .= ', a.title ' . $sdasc; } elseif ($params->get('sord') == 5) { $ordering .= ', r.rating_sum / r.rating_count ' . $sdasc; } elseif ($params->get('sord') == 6) { $ordering .= ', r.rating_count ' . $sdasc; } elseif ($params->get('sord') == 7) { $ordering .= ', a.id ' . $sdasc; } elseif ($params->get('sord') == 8) { if ($params->get('ctab') != '0') { $oc = "(SELECT COUNT(*) FROM " . $ctable . " AS ordcom WHERE ordcom." . $cartcol . " = a.id ) AS comen"; $ordering .= ", comen " . $sdasc; } else { echo '<span class="aidawarning">' . JText::_('COMORDWARNING') . '</span>'; $ordering = " RAND()"; } } elseif ($params->get('sord') == 10) { $ordering .= ', f.ordering ' . $dasc; } /* ----- SQL QUERIES BEGIN ----- */ if ($params->get('aidaquick')) { // With this option we do more queries than usual, but they should be lighter as we use less joins /* STEP 1: group all the settings you'll need to use */ // STICKY ARTICLES CATEGORIES if ($params->get('aidasticky')) { $stickers = $params->get('stickers'); $stickers = str_replace(" ", '', $stickers); $query = 'SELECT DISTINCT catid' . ' FROM #__content' . ' WHERE id IN (' . $stickers . ')'; $db->setQuery($query); $scats = $db->loadResultArray(); if (is_array($scats)) { $scats = implode($scats, ','); } } else { $scats = ''; } // CATEGORIES if ($catid && $scats) { $catCondition = ' AND cc.id IN (' . $catid . ',' . $scats . ') '; } elseif (!$catid && $scats) { $catCondition = ' AND cc.id IN (' . $scats . ') '; } elseif ($catid && !$scats) { $catCondition = ' AND cc.id IN (' . $catid . ') '; } else { $catCondition = ""; } $query = 'SELECT cc.id, cc.title AS cattle, cc.params AS catparams, cc.alias AS category_alias, ' . ' CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug' . ' FROM #__categories AS cc' . ' WHERE cc.published = 1' . $catCondition; if ($access) { $query .= ' AND cc.access <= ' . $aid; } $query .= ' ORDER BY cc.id'; $db->setQuery($query); $cats = $db->loadObjectList(); if (is_array($cats)) { $test = true; foreach ($cats as $c) { if ($test) { $catlist = $c->id; $test = false; } else { $catlist .= ',' . $c->id; } } } /* STEP 2: Queries */ // Featured Offset $feats = ""; if ($params->get('foffset')) { $foffset = $params->get('foffset'); $query = $db->getQuery(true); $query->select('a.id'); $query->from('#__content AS a')->leftJoin('#__content_rating AS r ON r.content_id = a.id')->innerJoin('#__content_frontpage AS f ON f.content_id = a.id'); $query->where('( a.publish_up = ' . $db->Quote($nullDate) . ' OR a.publish_up <= ' . $db->Quote($now) . ' )')->where('( a.publish_down = ' . $db->Quote($nullDate) . ' OR a.publish_down >= ' . $db->Quote($now) . ' )'); if ($wauth) { $query->where($wauth); } if ($access && $params->get('sua')) { $query->where('a.access <= ' . (int) $aid . ' AND cc.access <= ' . (int) $aid); } if ($recent) { $query->where('DATEDIFF(' . $db->Quote($now) . ', a.created) < ' . $recent); } if ($recentwo) { $query->where('DATEDIFF(' . $db->Quote($now) . ', a.created) >= ' . $recentwo); } if ($relnorepeat) { $query->where($relnorepeat); } if ($relatedcond) { $query->where($relatedcond); } if ($nocur) { $query->where($nocur); } if ($params->get('show_trash') == 1) { $query->where('a.state = 1'); } if ($params->get('show_trash') == 2) { $query->where('a.state <> 1'); } if ($params->get('cco') == 2 && !$temp) { $query->where("a.id = 'die'"); } $query->order($ordering); $db->setQuery($query, $offset, $foffset); $feats = $db->loadResultArray(); $feats = implode(',', $feats); } // Sticky Articles $scount = 0; if ($params->get('aidasticky')) { $stickers = $params->get('stickers'); $stickers = str_replace(" ", '', $stickers); $sticka = explode(",", $stickers); if ($sticka[0]) { $query = $db->getQuery(true); $query->select('a.*')->select('r.rating_count')->select('r.rating_sum'); $query->from('#__content AS a')->leftJoin('#__content_rating AS r ON r.content_id = a.id'); $query->where('a.id IN (' . $stickers . ')'); if ($access && $params->get('sua')) { $query->where('a.access <= ' . (int) $aid . ' AND cc.access <= ' . (int) $aid); } // Ordering $ord = 'case a.id'; for ($w = 0; $w < count($sticka); $w++) { $ord .= " when '" . $sticka[$w] . "' then '" . ($w + 1) . "'"; } $ord .= ' end'; $query->order($ord); $db->setQuery($query, 0, $count); $stickies = $db->loadObjectList(); $scount = count($stickies); $count -= $scount; } } if ($count) { // CATEGORIES if ($catid) { $ids = explode(',', $catid); JArrayHelper::toInteger($ids); $catCondition = '(a.catid = ' . implode(' OR a.catid = ', $ids) . ')'; } else { $catCondition = ""; } // Normal Query $query = $db->getQuery(true); $query->select('a.*')->select('r.rating_count')->select('r.rating_sum'); if ($oc) { $query->select($oc); } $query->from('#__content AS a')->leftJoin('#__content_rating AS r ON r.content_id = a.id'); if ($params->get('show_front')) { if ($params->get('show_front') == 1) { $query->leftJoin('#__content_frontpage AS f ON f.content_id = a.id'); } if ($params->get('show_front') == 2) { $query->innerJoin('#__content_frontpage AS f ON f.content_id = a.id'); } } elseif ($params->get('ordering') == 10 || $params->get('sord') == 10) { $query->leftJoin('#__content_frontpage AS f ON f.content_id = a.id'); } $query->where('( a.publish_up = ' . $db->Quote($nullDate) . ' OR a.publish_up <= ' . $db->Quote($now) . ' )')->where('( a.publish_down = ' . $db->Quote($nullDate) . ' OR a.publish_down >= ' . $db->Quote($now) . ' )'); if ($wauth) { $query->where($wauth); } if ($access && $params->get('sua')) { $query->where('a.access <= ' . (int) $aid . ' AND cc.access <= ' . (int) $aid); } if ($recent) { $query->where('DATEDIFF(' . $db->Quote($now) . ', a.created) < ' . $recent); } if ($recentwo) { $query->where('DATEDIFF(' . $db->Quote($now) . ', a.created) >= ' . $recentwo); } if ($relnorepeat) { $query->where($relnorepeat); } if ($relatedcond) { $query->where($relatedcond); } if ($nocur) { $query->where($nocur); } if ($catid) { $query->where($catCondition); } if ($params->get('show_trash') == 1) { $query->where('a.state = 1'); } if ($params->get('show_trash') == 2) { $query->where('a.state <> 1'); } if ($params->get('cco') == 2 && !$temp) { $query->where("a.id = 'die'"); } if ($params->get('show_front') == 1) { $query->where('f.content_id IS NULL '); } if ($params->get('foffset') && $feats) { $query->where('a.id NOT IN (' . $feats . ')'); } if ($params->get('aidasticky') && $stickers) { $query->where('a.id NOT IN (' . $stickers . ')'); } $query->order($ordering); $db->setQuery($query, $offset, $count); $rows = $db->loadObjectList(); /*if ($params->get('cco') == 2 && !$temp) $query .= " AND a.id = 'die'";;*/ } else { $rows = $stickies; } if ($scount && $count) { $rows = array_merge($stickies, $rows); } //Now we need to merge cats and rows! foreach ($rows as $row) { foreach ($cats as $cat) { if ($row->catid == $cat->id) { $row->catparams = $cat->catparams; $row->cattle = $cat->cattle; $row->category_alias = $cat->category_alias; } } } } else { /* STEP 1: group all the settings you'll need to use */ // CATEGORIES if ($catid) { $ids = explode(',', $catid); JArrayHelper::toInteger($ids); $catCondition = '(cc.id = ' . implode(' OR cc.id = ', $ids) . ')'; } else { $catCondition = ""; } /* STEP 2: Queries */ // Featured Offset $feats = ''; if ($params->get('foffset')) { $foffset = $params->get('foffset'); $query = $db->getQuery(true); $query->select('a.*')->select('r.rating_count')->select('r.rating_sum')->select('cc.params AS catparams')->select('cc.title AS cattle')->select('cc.alias AS category_alias'); if ($oc) { $query->select($oc); } $query->from('#__content AS a')->innerJoin('#__categories AS cc ON cc.id = a.catid')->leftJoin('#__content_rating AS r ON r.content_id = a.id'); $query->innerJoin('#__content_frontpage AS f ON f.content_id = a.id'); $query->where('cc.published = 1')->where('( a.publish_up = ' . $db->Quote($nullDate) . ' OR a.publish_up <= ' . $db->Quote($now) . ' )')->where('( a.publish_down = ' . $db->Quote($nullDate) . ' OR a.publish_down >= ' . $db->Quote($now) . ' )'); if ($wauth) { $query->where($wauth); } if ($catid) { $query->where($catCondition); } if ($params->get('show_front') == 1) { $query->where('f.content_id IS NULL '); } if ($access && $params->get('sua')) { $query->where('a.access <= ' . (int) $aid . ' AND cc.access <= ' . (int) $aid); } if ($recent) { $query->where('DATEDIFF(' . $db->Quote($now) . ', a.created) < ' . $recent); } if ($recentwo) { $query->where('DATEDIFF(' . $db->Quote($now) . ', a.created) >= ' . $recentwo); } if ($relnorepeat) { $query->where($relnorepeat); } if ($relatedcond) { $query->where($relatedcond); } if ($nocur) { $query->where($nocur); } if ($params->get('show_trash') == 1) { $query->where('a.state = 1'); } if ($params->get('show_trash') == 2) { $query->where('a.state <> 1'); } if ($params->get('cco') == 2 && !$temp) { $query->where("a.id = 'die'"); } $query->order($ordering); $db->setQuery($query, $offset, $foffset); $feats = $db->loadResultArray(); $feats = implode(',', $feats); } // Sticky Articles $scount = 0; if ($params->get('aidasticky')) { $stickers = $params->get('stickers'); $stickers = str_replace(" ", '', $stickers); $sticka = explode(",", $stickers); if ($sticka[0]) { $query = $db->getQuery(true); $query->select('a.*')->select('r.rating_count')->select('r.rating_sum')->select('cc.params AS catparams')->select('cc.title AS cattle')->select('cc.alias AS category_alias'); $query->from('#__content AS a')->innerJoin('#__categories AS cc ON cc.id = a.catid')->leftJoin('#__content_rating AS r ON r.content_id = a.id'); $query->where('a.id IN (' . $stickers . ')'); if ($access && $params->get('sua')) { $query->where('a.access <= ' . (int) $aid . ' AND cc.access <= ' . (int) $aid); } // Ordering $ord = 'case a.id'; for ($w = 0; $w < count($sticka); $w++) { $ord .= " when '" . $sticka[$w] . "' then '" . ($w + 1) . "'"; } $ord .= ' end'; $query->order($ord); $db->setQuery($query, 0, $count); $stickies = $db->loadObjectList(); $scount = count($stickies); $count -= $scount; } } if ($count) { // Normal Query $query = $db->getQuery(true); $query->select('a.*')->select('r.rating_count')->select('r.rating_sum')->select('cc.params AS catparams')->select('cc.title AS cattle')->select('cc.alias AS category_alias'); if ($oc) { $query->select($oc); } $query->from('#__content AS a')->innerJoin('#__categories AS cc ON cc.id = a.catid')->leftJoin('#__content_rating AS r ON r.content_id = a.id'); if ($params->get('show_front')) { if ($params->get('show_front') == 1) { $query->leftJoin('#__content_frontpage AS f ON f.content_id = a.id'); } if ($params->get('show_front') == 2) { $query->innerJoin('#__content_frontpage AS f ON f.content_id = a.id'); } } elseif ($params->get('ordering') == 10 || $params->get('sord') == 10) { $query->leftJoin('#__content_frontpage AS f ON f.content_id = a.id'); } $query->where('cc.published = 1')->where('( a.publish_up = ' . $db->Quote($nullDate) . ' OR a.publish_up <= ' . $db->Quote($now) . ' )')->where('( a.publish_down = ' . $db->Quote($nullDate) . ' OR a.publish_down >= ' . $db->Quote($now) . ' )'); if ($wauth) { $query->where($wauth); } if ($catid) { $query->where($catCondition); } if ($params->get('show_front') == 1) { $query->where('f.content_id IS NULL '); } if ($access && $params->get('sua')) { $query->where('a.access <= ' . (int) $aid . ' AND cc.access <= ' . (int) $aid); } if ($recent) { $query->where('DATEDIFF(' . $db->Quote($now) . ', a.created) < ' . $recent); } if ($recentwo) { $query->where('DATEDIFF(' . $db->Quote($now) . ', a.created) >= ' . $recentwo); } if ($relnorepeat) { $query->where($relnorepeat); } if ($relatedcond) { $query->where($relatedcond); } if ($params->get('foffset') && $feats) { $query->where('a.id NOT IN (' . $feats . ')'); } if ($params->get('aidasticky') && $stickers) { $query->where('a.id NOT IN (' . $stickers . ')'); } if ($nocur) { $query->where($nocur); } if ($params->get('show_trash') == 1) { $query->where('a.state = 1'); } if ($params->get('show_trash') == 2) { $query->where('a.state <> 1'); } if ($params->get('cco') == 2 && !$temp) { $query->where("a.id = 'die'"); } $query->order($ordering); $db->setQuery($query, $offset, $count); $rows = $db->loadObjectList(); } else { $rows = $stickies; } if ($scount && $count) { $rows = array_merge($stickies, $rows); } } $i = 0; $lists = array(); /* GET IMAGE PREFERENCE LIST FOR IMAGE 1 */ if ($chimg1) { $pref1 = array(); $pref1[0] = $params->get("img1pref1"); $pref1[1] = $params->get("img1pref2"); $pref1[2] = $params->get("img1pref3"); $pref1[3] = $params->get("img1pref4"); $pref1[4] = $params->get("img1pref5"); modAiDaNews2Helper::imgpreflist_arrange($pref1); } /* GET IMAGE PREFERENCE LIST FOR IMAGE 2 */ if ($chimg2) { $pref2 = array(); $pref2[0] = $params->get("img2pref1"); $pref2[1] = $params->get("img2pref2"); $pref2[2] = $params->get("img2pref3"); $pref2[3] = $params->get("img2pref4"); $pref2[4] = $params->get("img2pref5"); modAiDaNews2Helper::imgpreflist_arrange($pref2); } /* GET IMAGE PREFERENCE LIST FOR IMAGE 3 */ if ($chimg3) { $pref3 = array(); $pref3[0] = $params->get("img3pref1"); $pref3[1] = $params->get("img3pref2"); $pref3[2] = $params->get("img3pref3"); $pref3[3] = $params->get("img3pref4"); $pref3[4] = $params->get("img3pref5"); modAiDaNews2Helper::imgpreflist_arrange($pref3); } /* START WITH ITEMS */ foreach ($rows as $row) { // Prepare some variables for each article... $row->slug = $row->id . ':' . $row->alias; $row->catslug = $row->catid . ':' . $row->category_alias; /* LINKS CREATION */ /* ARTICLE LINK */ $artlink = ContentHelperRoute::getArticleRoute($row->slug, $row->catslug); if ($row->access <= $aid || !$params->get('toglog')) { if ($params->get('omid')) { if (preg_match("'&Itemid=([^<]*)'si", $artlink)) { $artlink = JRoute::_(preg_replace("'&Itemid=([^<]*)'si", '&Itemid=' . $params->get('cmid'), $artlink)); } else { $artlink = JRoute::_($artlink . '&Itemid=' . $params->get('cmid')); } } else { $artlink = JRoute::_($artlink); } } else { $artlink = JRoute::_('index.php?option=com_users&view=login'); } /* CATEGORY LINK */ $catlink = JRoute::_(ContentHelperRoute::getCategoryRoute($row->catid)); /* COMMUNITY BUILDER LINK */ $cblink = JRoute::_('index.php?option=com_comprofiler&task=userProfile&user='******'index.php?option=com_community&view=profile&userid=' . $row->created_by); /* KUNENA LINK */ $kunlink = 'index.php?option=com_kunena&func=profile&userid=' . $row->created_by; /* JSOCIALSUITE LINK */ $jsslink = JRoute::_('index.php?option=com_jsocialsuite&task=profile.view&id=' . $row->created_by); /* ELEMENTS */ /* IMAGE 1 */ if ($chimg1) { $img1url = ""; $img1url = modAiDaNews2Helper::imgpreflist_findlink($pref1, $row->introtext . ' ' . $row->fulltext, $row->catparams, $row->images, $row->created_by, 1, $params->get('basegal')); if ($img1url) { if ($params->get('usethumbs')) { $img1url = modAiDaNews2Helper::creaThumb($img1url, $params, 1, $row->id, $row->alias); if (!$params->get('thumbnocrop')) { $h = $params->get('img1H'); $w = $params->get('img1W'); } else { list($w, $h) = getimagesize($img1url); } $img1url = '<img src="' . $img1url . '" width="' . $w . '" height="' . $h . '" alt="' . $row->alias . '"/>'; } else { $h = $params->get('img1H'); $w = $params->get('img1W'); $img1url = substr($img1url, 0, strrpos($img1url, '-')); $img1url = '<img src="' . $img1url . '"'; if ($w && $w != "auto") { $img1url .= ' width="' . $w . '"'; } if ($h && $h != "auto") { $img1url .= ' height="' . $h . '"'; } $img1url .= ' alt="' . $row->alias . '"/>'; } // CSS Field 1 if ($cssfields && $params->get('cssfield1')) { $style = ' style = "' . $params->get('cssfield1') . '"'; } else { $style = ""; } //Insert Links if ($params->get('img1lnk') == 1) { $img1url = '<a class="aidanews2_img1"' . $style . ' href="' . $artlink . '">' . $img1url . '</a>'; } elseif ($params->get('img1lnk') == 2) { $img1url = '<a class="aidanews2_img1"' . $style . ' href="' . $catlink . '">' . $img1url . '</a>'; } elseif ($params->get('img1lnk') == 4) { $img1url = '<a class="aidanews2_img1"' . $style . ' href="' . $cblink . '">' . $img1url . '</a>'; } elseif ($params->get('img1lnk') == 5) { $img1url = '<a class="aidanews2_img1"' . $style . ' href="' . $jslink . '">' . $img1url . '</a>'; } elseif ($params->get('img1lnk') == 6) { $img1url = '<a class="aidanews2_img1"' . $style . ' href="' . $kunlink . '">' . $img1url . '</a>'; } elseif ($params->get('img1lnk') == 7) { $img1url = '<a class="aidanews2_img1"' . $style . ' href="' . $jsslink . '">' . $img1url . '</a>'; } $lists[$i]->img1 = $img1url; } else { $lists[$i]->img1 = ''; } } else { $lists[$i]->img1 = ''; } /* IMAGE 2 */ if ($chimg2) { $img2url = ""; $img2url = modAiDaNews2Helper::imgpreflist_findlink($pref2, $row->introtext . ' ' . $row->fulltext, $row->catparams, $row->images, $row->created_by, 2, $params->get('basegal')); //Thumbs? if ($img2url) { if ($params->get('usethumbs')) { $img2url = modAiDaNews2Helper::creaThumb($img2url, $params, 2, $row->id, $row->alias); if (!$params->get('thumbnocrop')) { $h = $params->get('img2H'); $w = $params->get('img2W'); } else { list($w, $h) = getimagesize($img2url); } $img2url = '<img src="' . $img2url . '" width="' . $w . '" height="' . $h . '" alt="' . $row->alias . '"/>'; } else { $h = $params->get('img2H'); $w = $params->get('img2W'); $img2url = substr($img2url, 0, strrpos($img2url, '-')); $img2url = '<img src="' . $img2url . '"'; if ($w && $w != "auto") { $img2url .= ' width="' . $w . '"'; } if ($h && $h != "auto") { $img2url .= ' height="' . $h . '"'; } $img2url .= ' alt="' . $row->alias . '"/>'; } // CSS Field 2 if ($cssfields && $params->get('cssfield2')) { $style = ' style = "' . $params->get('cssfield2') . '"'; } else { $style = ""; } //Insert Links if ($params->get('img2lnk') == 1) { $img2url = '<a class="aidanews2_img2"' . $style . ' href="' . $artlink . '">' . $img2url . '</a>'; } elseif ($params->get('img2lnk') == 2) { $img2url = '<a class="aidanews2_img2"' . $style . ' href="' . $catlink . '">' . $img2url . '</a>'; } elseif ($params->get('img2lnk') == 4) { $img2url = '<a class="aidanews2_img2"' . $style . ' href="' . $cblink . '">' . $img2url . '</a>'; } elseif ($params->get('img2lnk') == 5) { $img2url = '<a class="aidanews2_img2"' . $style . ' href="' . $jslink . '">' . $img2url . '</a>'; } elseif ($params->get('img2lnk') == 6) { $img2url = '<a class="aidanews2_img2"' . $style . ' href="' . $kunlink . '">' . $img2url . '</a>'; } elseif ($params->get('img2lnk') == 7) { $img2url = '<a class="aidanews2_img2"' . $style . ' href="' . $jsslink . '">' . $img2url . '</a>'; } $lists[$i]->img2 = $img2url; } else { $lists[$i]->img2 = ''; } } else { $lists[$i]->img2 = ''; } /* IMAGE 3 */ if ($chimg3) { $img3url = ""; $img3url = modAiDaNews2Helper::imgpreflist_findlink($pref3, $row->introtext . ' ' . $row->fulltext, $row->catparams, $row->images, $row->created_by, 3, $params->get('basegal')); //Thumbs? if ($img3url) { if ($params->get('usethumbs')) { $img3url = modAiDaNews2Helper::creaThumb($img3url, $params, 3, $row->id, $row->alias); if (!$params->get('thumbnocrop')) { $h = $params->get('img3H'); $w = $params->get('img3W'); } else { list($w, $h) = getimagesize($img3url); } $img3url = '<img src="' . $img3url . '" width="' . $w . '" height="' . $h . '" alt="' . $row->alias . '"/>'; } else { $h = $params->get('img3H'); $w = $params->get('img3W'); $img3url = substr($img3url, 0, strrpos($img3url, '-')); $img3url = '<img src="' . $img3url . '"'; if ($w && $w != "auto") { $img3url .= ' width="' . $w . '"'; } if ($h && $h != "auto") { $img3url .= ' height="' . $h . '"'; } $img3url .= ' alt="' . $row->alias . '"/>'; } // CSS Field 3 if ($cssfields && $params->get('cssfield3')) { $style = ' style = "' . $params->get('cssfield3') . '"'; } else { $style = ""; } //Insert Links if ($params->get('img3lnk') == 1) { $img3url = '<a class="aidanews2_img3"' . $style . ' href="' . $artlink . '">' . $img3url . '</a>'; } elseif ($params->get('img3lnk') == 2) { $img3url = '<a class="aidanews2_img3"' . $style . ' href="' . $catlink . '">' . $img3url . '</a>'; } elseif ($params->get('img3lnk') == 4) { $img3url = '<a class="aidanews2_img3"' . $style . ' href="' . $cblink . '">' . $img3url . '</a>'; } elseif ($params->get('img3lnk') == 5) { $img3url = '<a class="aidanews2_img3"' . $style . ' href="' . $jslink . '">' . $img3url . '</a>'; } elseif ($params->get('img3lnk') == 6) { $img3url = '<a class="aidanews2_img3"' . $style . ' href="' . $kunlink . '">' . $img3url . '</a>'; } elseif ($params->get('img3lnk') == 7) { $img3url = '<a class="aidanews2_img3"' . $style . ' href="' . $jsslink . '">' . $img3url . '</a>'; } $lists[$i]->img3 = $img3url; } else { $lists[$i]->img3 = ''; } } else { $lists[$i]->img3 = ''; } /* TITLE */ /* GET TITLE */ $tit = str_replace('$', '\\$', htmlspecialchars($row->title)); /* LINK */ $titlinkb = ""; $titlinke = ""; if ($params->get('titnp')) { $titblank = ' target="_blank"'; } else { $titblank = ""; } if ($params->get('lnktit')) { $titlinkb = '<a href="' . $artlink . '"' . $titblank . '>'; $titlinke = '</a>'; } // CSS Field 4 if ($cssfields && $params->get('cssfield4')) { $style = ' style = "' . $params->get('cssfield4') . '"'; } else { $style = ""; } /* H1 H2 H3 Span */ $hspanb = ""; $hspane = ""; if ($params->get('hspan') == 0) { $hspanb = '<span class="aidanews2_title"' . $style . '>'; $hspane = '</span>'; } elseif ($params->get('hspan') == 1) { $hspanb = '<h1 class="aidanews2_title"' . $style . '>'; $hspane = '</h1>'; } elseif ($params->get('hspan') == 2) { $hspanb = '<h2 class="aidanews2_title"' . $style . '>'; $hspane = '</h2>'; } elseif ($params->get('hspan') == 3) { $hspanb = '<h3 class="aidanews2_title"' . $style . '>'; $hspane = '</h3>'; } /* SHORTEN TITLE */ if ($params->get('titnum') && strlen($tit) > $params->get('titnum')) { $tit = modAiDaNews2Helper::shorten($tit, $params->get('titnum'), $params->get('titsh'), $params->get("titend")); } $lists[$i]->title = $hspanb . $titlinkb . $tit . $titlinke . $hspane; /* TEXT */ /* CHOOSE TEXT */ if ($params->get('txtwhat') == 0) { $txt = str_replace('$', '\\$', $row->introtext); } elseif ($params->get('txtwhat') == 1) { $txt = str_replace('$', '\\$', $row->fulltext); } elseif ($params->get('txtwhat') == 2) { $txt = str_replace('$', '\\$', $row->introtext . $row->fulltext); } elseif ($params->get('txtwhat') == 3) { $txt = str_replace('$', '\\$', $row->metadesc); } /* STRIP TAGS */ if ($params->get('txtstrip')) { $txtallow = $params->get('txtallow'); $txt = strip_tags(str_replace("<br/>", " ", $txt), $txtallow); } /* STRIP PLUGINS */ if ($params->get('txtplugs')) { $txt = preg_replace("'{.*?}([^<]*){/.*?}'si", '', $txt); $txt = preg_replace('#\\{.*?\\}#', '', $txt); } /* SHORTEN TEXT */ if ($params->get('txtnum') && strlen($txt) > $params->get('txtnum')) { $txt = modAiDaNews2Helper::shorten($txt, $params->get('txtnum'), $params->get('txtsh'), $params->get("txtend")); } // CSS Field 5 if ($cssfields && $params->get('cssfield5')) { $style = ' style = "' . $params->get('cssfield5') . '"'; } else { $style = ""; } $lists[$i]->text = '<span class="aidanews2_text"' . $style . '>' . $txt . '</span>'; /* URLS */ // URL A if (preg_match("#['|\"]urla['|\"]:['|\"](.*?)['|\"]#i", $row->urls, $matches)) { $urla = $matches[1]; $urla = preg_replace("#\\\\#", '', $urla); } else { $urla = ""; } if ($urla) { if (preg_match("#['|\"]urlatext['|\"]:['|\"](.*?)['|\"]#i", $row->urls, $matches)) { $urlatext = $matches[1]; } else { $urlatext = "Url A"; } $lists[$i]->urla = '<a class="aidanews2_url_a" href="' . $urla . '">' . $urlatext . '</span>'; } else { $lists[$i]->urla = ''; } // URL B if (preg_match("#['|\"]urlb['|\"]:['|\"](.*?)['|\"]#i", $row->urls, $matches)) { $urlb = $matches[1]; $urlb = preg_replace("#\\\\#", '', $urlb); } else { $urlb = ""; } if ($urlb) { if (preg_match("#['|\"]urlbtext['|\"]:['|\"](.*?)['|\"]#i", $row->urls, $matches)) { $urlbtext = $matches[1]; } else { $urlbtext = "Url B"; } $lists[$i]->urlb = '<a class="aidanews2_url_b" href="' . $urlb . '">' . $urlbtext . '</span>'; } else { $lists[$i]->urlb = ''; } // URL C if (preg_match("#['|\"]urlc['|\"]:['|\"](.*?)['|\"]#i", $row->urls, $matches)) { $urlc = $matches[1]; $urlc = preg_replace("#\\\\#", '', $urlc); } else { $urlc = ""; } if ($urlc) { if (preg_match("#['|\"]urlctext['|\"]:['|\"](.*?)['|\"]#i", $row->urls, $matches)) { $urlctext = $matches[1]; } else { $urlctext = "Url C"; } $lists[$i]->urlc = '<a class="aidanews2_url_c" href="' . $urlc . '">' . $urlctext . '</span>'; } else { $lists[$i]->urlc = ''; } /* READ MORE */ // CSS Field 6 if ($cssfields && $params->get('cssfield6')) { $style = ' style = "' . $params->get('cssfield6') . '"'; } else { $style = ""; } if ($params->get('langload')) { $lists[$i]->rm = '<a href="' . $artlink . '" class="readon"' . $style . '><span class="aidanews2_readmore">' . JText::_('AIDAREADMORE') . '</span></a>'; } else { $lists[$i]->rm = '<a href="' . $artlink . '" class="readon"' . $style . '><span class="aidanews2_readmore">' . $params->get('readmore') . '</span></a>'; } /* HITS */ // CSS Field 7 if ($cssfields && $params->get('cssfield7')) { $style = ' style = "' . $params->get('cssfield7') . '"'; } else { $style = ""; } $lists[$i]->hits = '<span class="aidanews2_hits"' . $style . '>' . $row->hits . '</span>'; /* RATING */ // CSS Field 8 if ($cssfields && $params->get('cssfield8')) { $style = ' style = "' . $params->get('cssfield8') . '"'; } else { $style = ""; } if ($params->get('rnum')) { $lists[$i]->rating = '<span class="aidanews2_rating"' . $style . '>' . $row->rating_count . '</span>'; } else { if ($row->rating_count == 0) { $row->rating_count = 1; } if ($params->get('rstars') == 1) { $rate = round($row->rating_sum / $row->rating_count, 0); $lists[$i]->rating = '<div class="aidanews2_stars_rating"' . $style . '>'; for ($rr = 0; $rr < 5; $rr++) { if ($rr < $rate) { $lists[$i]->rating .= '<img src="modules/mod_aidanews2/img/default/rating.png" alt="' . $rate . '" title="' . $rate . '" width="16" height="16"/>'; } else { $lists[$i]->rating .= '<img src="modules/mod_aidanews2/img/default/no-rating.png" alt="' . $rate . '" title="' . $rate . '" width="16" height="16"/>'; } } $lists[$i]->rating .= '</div>'; } elseif ($params->get('rstars') == 2) { $rate = round($row->rating_sum / $row->rating_count, 0); $lists[$i]->rating = '<div class="aidanews2_stars_rating"' . $style . '>'; for ($rr = 5; $rr > 0; $rr--) { if ($rr - 1 < $rate) { $lists[$i]->rating .= '<img src="modules/mod_aidanews2/img/default/rating.png" alt="' . $rate . '" title="' . $rate . '" width="16" height="16"/>'; } else { $lists[$i]->rating .= '<img src="modules/mod_aidanews2/img/default/no-rating.png" alt="' . $rate . '" title="' . $rate . '" width="16" height="16"/>'; } } $lists[$i]->rating .= '</div>'; } else { $lists[$i]->rating = '<span class="aidanews2_rating"' . $style . '>' . round($row->rating_sum / $row->rating_count, $params->get('rround')) . '</span>'; } } /* CATEGORY */ // CSS Field 9 if ($cssfields && $params->get('cssfield9')) { $style = ' style = "' . $params->get('cssfield9') . '"'; } else { $style = ""; } if ($params->get('caturl')) { $lists[$i]->category = '<span class="aidanews2_category aidacat_' . $row->catid . '"' . $style . '><a href="' . $catlink . '">' . $row->cattle . '</a></span>'; } else { $lists[$i]->category = '<span class="aidanews2_category aidacat_' . $row->catid . '"' . $style . '>' . $row->cattle . '</span>'; } /* CATEGORY SUFFIX (CSS) */ $lists[$i]->catcss = 'aidacat_' . $row->catid . ' '; /* ID SUFFIX (CSS) */ $lists[$i]->idcss = 'aidaid_' . $row->id . ' '; /* STICKY SUFFIX (CSS) */ if ($i < $scount) { $lists[$i]->sticky = 'aidasticky '; } else { $lists[$i]->sticky = ''; } /* CATEGORIES */ // CSS Field 10 if ($cssfields && $params->get('cssfield10')) { $style = ' style = "' . $params->get('cssfield10') . '"'; } else { $style = ""; } if ($chcats) { $catp = $row->catid; $divi = '<span class="aidacats_div">' . $params->get('catsdiv') . '</span>'; $categories = ""; while ($catp != 1) { $query = 'SELECT id, parent_id, title FROM #__categories WHERE id = ' . $catp . ' AND extension = "com_content"'; $db->setQuery($query); $ccc = $db->loadObject(); if ($params->get('catsurl')) { $categories = '<span class="aidanews2_category aidacat_' . $catp . '"><a href="' . JRoute::_(ContentHelperRoute::getCategoryRoute($ccc->id)) . '">' . $ccc->title . '</a></span> ' . ($categories ? $divi : '') . ' ' . $categories; } else { $categories = '<span class="aidanews2_category aidacat_' . $catp . '">' . $ccc->title . '</span> ' . ($categories ? $divi : '') . ' ' . $categories; } $catp = $ccc->parent_id; } $lists[$i]->categories = '<span class="aidanews2_categories"' . $style . '>' . $categories . '</span>'; } else { $lists[$i]->categories = ''; } /* DATE */ $dto = $params->get('dto'); $dst = false; $dnd = 0; if (strpos($dto, "[st]") !== false) { $dst = true; } if ($params->get('wdate') == 0) { $date = JHTML::_('date', $row->created, $dto); if ($dst) { $dnd = JHTML::_('date', $row->created, "%d"); } $today = JHTML::_('date', $row->created, "%d-%b-%Y"); } elseif ($params->get('wdate') == 1) { $date = JHTML::_('date', $row->modified, $dto); if ($dst) { $dnd = JHTML::_('date', $row->modified, "%d"); } $today = JHTML::_('date', $row->modified, "%d-%b-%Y"); } elseif ($params->get('wdate') == 2) { $date = JHTML::_('date', $row->publish_up, $dto); if ($dst) { $dnd = JHTML::_('date', $row->publish_up, "%d"); } $today = JHTML::_('date', $row->publish_up, "%d-%b-%Y"); } elseif ($params->get('wdate') == 3) { $date = JHTML::_('date', $row->publish_down, $dto); if ($dst) { $dnd = JHTML::_('date', $row->publish_down, "%d"); } $today = JHTML::_('date', $row->publish_down, "%d-%b-%Y"); } // Today CSS Class $todayc = JHTML::_('date', $now, "%d-%b-%Y"); if ($todayc == $today) { $lists[$i]->today = 'aidatoday '; } else { $lists[$i]->today = ''; } if ($dnd) { if ($dnd == 1) { $date = str_replace('[st]', "st", $date); } elseif ($dnd == 2) { $date = str_replace('[st]', "nd", $date); } elseif ($dnd == 3) { $date = str_replace('[st]', "rd", $date); } elseif ($dnd == 21) { $date = str_replace('[st]', "st", $date); } elseif ($dnd == 22) { $date = str_replace('[st]', "nd", $date); } elseif ($dnd == 23) { $date = str_replace('[st]', "rd", $date); } elseif ($dnd == 31) { $date = str_replace('[st]', "st", $date); } else { $date = str_replace('[st]', "th", $date); } } // CSS Field 11 if ($cssfields && $params->get('cssfield11')) { $style = ' style = "' . $params->get('cssfield11') . '"'; } else { $style = ""; } $lists[$i]->date = '<span class="aidanews2_date"' . $style . '>' . $date . '</span>'; /* DATE 2 */ $dto = $params->get('dto2'); $dst = false; $dnd = 0; if (strpos($dto, "[st]") !== false) { $dst = true; } if ($params->get('wdate2') == 0) { $date = JHTML::_('date', $row->created, $dto); if ($dst) { $dnd = JHTML::_('date', $row->created, "%d"); } $today = JHTML::_('date', $row->created, "%d-%b-%Y"); } elseif ($params->get('wdate2') == 1) { $date = JHTML::_('date', $row->modified, $dto); if ($dst) { $dnd = JHTML::_('date', $row->modified, "%d"); } $today = JHTML::_('date', $row->modified, "%d-%b-%Y"); } elseif ($params->get('wdate2') == 2) { $date = JHTML::_('date', $row->publish_up, $dto); if ($dst) { $dnd = JHTML::_('date', $row->publish_up, "%d"); } $today = JHTML::_('date', $row->publish_up, "%d-%b-%Y"); } elseif ($params->get('wdate2') == 3) { $date = JHTML::_('date', $row->publish_down, $dto); if ($dst) { $dnd = JHTML::_('date', $row->publish_down, "%d"); } $today = JHTML::_('date', $row->publish_down, "%d-%b-%Y"); } if ($dnd) { if ($dnd == 1) { $date = str_replace('[st]', "st", $date); } elseif ($dnd == 2) { $date = str_replace('[st]', "nd", $date); } elseif ($dnd == 3) { $date = str_replace('[st]', "rd", $date); } elseif ($dnd == 21) { $date = str_replace('[st]', "st", $date); } elseif ($dnd == 22) { $date = str_replace('[st]', "nd", $date); } elseif ($dnd == 23) { $date = str_replace('[st]', "rd", $date); } elseif ($dnd == 31) { $date = str_replace('[st]', "st", $date); } else { $date = str_replace('[st]', "th", $date); } } // CSS Field 14 if ($cssfields && $params->get('cssfield14')) { $style = ' style = "' . $params->get('cssfield14') . '"'; } else { $style = ""; } $lists[$i]->date2 = '<span class="aidanews2_date_2"' . $style . '>' . $date . '</span>'; /* AUTHOR */ /* GET NAME OR USERNAME */ $auth = ""; $alias = ""; if ($params->get('authtype') == 0) { $query = 'SELECT name FROM #__users WHERE id = ' . $row->created_by; $db->setQuery($query); $auth = $db->loadResult(); } elseif ($params->get('authtype') == 1) { $query = 'SELECT username FROM #__users WHERE id = ' . $row->created_by; $db->setQuery($query); $auth = $db->loadResult(); } elseif ($params->get('authtype') == 2) { if ($row->created_by_alias) { $alias = $row->created_by_alias; } else { $query = 'SELECT name FROM #__users WHERE id = ' . $row->created_by; $db->setQuery($query); $auth = $db->loadResult(); } } elseif ($params->get('authtype') == 3) { if ($row->created_by_alias) { $alias = $row->created_by_alias; } else { $query = 'SELECT username FROM #__users WHERE id = ' . $row->created_by; $db->setQuery($query); $auth = $db->loadResult(); } } /* LINK AUTHOR */ if ($alias) { $aut = $alias; } else { if ($params->get('authlnk') == 1) { $aut = '<a href="' . $cblink . '">' . $auth . '</a>'; } elseif ($params->get('authlnk') == 2) { $aut = '<a href="' . $jslink . '">' . $auth . '</a>'; } elseif ($params->get('authlnk') == 3) { $aut = '<a href="' . $jsslink . '">' . $auth . '</a>'; } else { $aut = $auth; } } // CSS Field 12 if ($cssfields && $params->get('cssfield12')) { $style = ' style = "' . $params->get('cssfield12') . '"'; } else { $style = ""; } $lists[$i]->author = '<span class="aidanews2_author"' . $style . '>' . $aut . '</span>'; /* COMMENTS */ if ($params->get('ctab') != '0') { if ($params->get('ctab') == '11') { //Udjacomments support $query = 'SELECT COUNT(*) FROM ' . $ctable . ' WHERE ' . $cartcol . ' = "com_content:' . $row->id . '"'; $db->setQuery($query); $comments = $db->loadResult(); } else { $query = 'SELECT COUNT(*) FROM ' . $ctable . ' WHERE ' . $cartcol . ' = ' . $row->id; $db->setQuery($query); $comments = $db->loadResult(); } if ($params->get('ctab') == '10' && $comments) { $comments -= 1; } // CSS Field 13 if ($cssfields && $params->get('cssfield13')) { $style = ' style = "' . $params->get('cssfield13') . '"'; } else { $style = ""; } $lists[$i]->comments = '<span class="aidanews2_comments"' . $style . '>' . $comments . '</span>'; } else { $lists[$i]->comments = ''; } /* TOOLTIPS */ if ($params->get('tol_title') || $params->get('tol_img1') || $params->get('tol_img2') || $params->get('tol_img3')) { /* TAGS THAT CAN BE INSERTED IN THE TOOLTIPS */ /* Refresh patterns for every item */ $patterns = array('/\\[title\\]/', '/\\[text\\]/', '/\\[empty\\]/', '/\\[author\\]/', '/\\[date\\]/', '/\\[category\\]/'); $replace = array($tit, $txt, '', $aut, $date, $row->cattle); /* EXCHANGE TAGS AND ADD TOOLTIPS TO ELEMENTS */ $toltit = $params->get('tol_title'); if ($toltit && $toltit != '[empty]') { $lists[$i]->title = '<span class="hasTip" title="' . preg_replace($patterns, $replace, $toltit) . '">' . $lists[$i]->title . '</span>'; } $tolimg1 = $params->get('tol_img1'); if ($tolimg1 && $tolimg1 != '[empty]') { $lists[$i]->img1 = '<span class="hasTip" title="' . preg_replace($patterns, $replace, $tolimg1) . '">' . $lists[$i]->img1 . '</span>'; } $tolimg2 = $params->get('tol_img2'); if ($tolimg2 && $tolimg2 != '[empty]') { $lists[$i]->img2 = '<span class="hasTip" title="' . preg_replace($patterns, $replace, $tolimg2) . '">' . $lists[$i]->img2 . '</span>'; } $tolimg3 = $params->get('tol_img3'); if ($tolimg3 && $tolimg3 != '[empty]') { $lists[$i]->img3 = '<span class="hasTip" title="' . preg_replace($patterns, $replace, $tolimg3) . '">' . $lists[$i]->img3 . '</span>'; } } /* NOTIFIERS */ $notify = ''; // New $todays_date = date("Y-m-d"); $distance = strtotime($todays_date) - strtotime($row->created); if ($params->get('nactnew') && $distance < $params->get('nnewdays') * 86400) { if ($params->get('nuseimg')) { $notify .= '<img class="aidanotifier_new" src="modules/mod_aidanews2/img/notifiers/new.png"/>'; } else { if ($params->get('langload')) { $notify .= '<span class="aidanotifier_new">' . JText::_('NNEW') . '</span>'; } else { $notify .= '<span class="aidanotifier_new">' . $params->get('nwnew') . '</span>'; } } } // Featured if ($params->get('nactfeat') && $row->featured) { if ($params->get('nuseimg')) { $notify .= '<img class="aidanotifier_feat" src="modules/mod_aidanews2/img/notifiers/feat.png"/>'; } else { if ($params->get('langload')) { $notify .= '<span class="aidanotifier_feat">' . JText::_('NFEAT') . '</span>'; } else { $notify .= '<span class="aidanotifier_feat">' . $params->get('nwfeat') . '</span>'; } } } // Updated $distance = strtotime($todays_date) - strtotime($row->modified); if ($params->get('nactupd') && $distance < $params->get('nupddays') * 86400) { if ($params->get('nuseimg')) { $notify .= '<img class="aidanotifier_upd" src="modules/mod_aidanews2/img/notifiers/upd.png"/>'; } else { if ($params->get('langload')) { $notify .= '<span class="aidanotifier_upd">' . JText::_('NUPD') . '</span>'; } else { $notify .= '<span class="aidanotifier_upd">' . $params->get('nwupd') . '</span>'; } } } // Registered Only if ($params->get('nactreg') && $row->access > 1) { if ($params->get('nuseimg')) { $notify .= '<img class="aidanotifier_reg" src="modules/mod_aidanews2/img/notifiers/reg.png"/>'; } else { if ($params->get('langload')) { $notify .= '<span class="aidanotifier_reg">' . JText::_('NREG') . '</span>'; } else { $notify .= '<span class="aidanotifier_reg">' . $params->get('nwreg') . '</span>'; } } } $lists[$i]->notifiers = $notify; /* ...NEXT! */ $i++; } return $lists; }