Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* ---------------- getTags ---------------- */
- if (!function_exists('getTags')) {
- function getTags($cIDs, $tvTags, $days) {
- global $modx, $parent;
- $docTags = array ();
- $baspath= $modx->config["base_path"] . "manager/includes";
- include_once $baspath . "/tmplvars.format.inc.php";
- include_once $baspath . "/tmplvars.commands.inc.php";
- if ($days > 0) {
- $pub_date = mktime() - $days*24*60*60;
- } else {
- $pub_date = 0;
- }
- list($region, $countries) = explode(",", $tvTags);
- $tb1 = $modx->getFullTableName("site_tmplvar_contentvalues");
- $tb2 = $modx->getFullTableName("site_tmplvars");
- $tb_content = $modx->getFullTableName("site_content");
- $query = "SELECT stv.name,stc.tmplvarid,stc.contentid,stv.type,stv.display,stv.display_params,stc.value";
- $query .= " FROM ".$tb1." stc LEFT JOIN ".$tb2." stv ON stv.id=stc.tmplvarid ";
- $query .= " LEFT JOIN $tb_content tb_content ON stc.contentid=tb_content.id ";
- $query .= " WHERE (stv.name='region' AND stc.contentid IN (".implode($cIDs,",").") OR ";
- $query .= " stv.name='countries' AND stc.contentid IN (".implode($cIDs,",").")) ";
- $query .= " AND tb_content.pub_date >= '$pub_date' ";
- $query .= " AND tb_content.published = 1 ";
- $query .= " ORDER BY stc.contentid ASC;";
- $rs = $modx->db->query($query);
- $tot = $modx->db->getRecordCount($rs);
- $resourceArray = array();
- for($i=0;$i<$tot;$i++) {
- $row = @$modx->fetchRow($rs);
- $docTags[$row['contentid']]['tags'] = getTVDisplayFormat($row['name'], $row['value'], $row['display'], $row['display_params'], $row['type'],$row['contentid']);
- }
- if ($tot != count($cIDs)) {
- $query = "SELECT name,type,display,display_params,default_text";
- $query .= " FROM $tb2";
- $query .= " WHERE name='".$region."' OR name= '".$countries."' ";
- $rs = $modx->db->query($query);
- $row = @$modx->fetchRow($rs);
- $defaultOutput = getTVDisplayFormat($row['name'], $row['default_text'], $row['display'], $row['display_params'], $row['type'],$row['contentid']);
- foreach ($cIDs as $id) {
- if (!isset($docTags[$id]['tags'])) {
- $docTags[$id]['tags'] = $defaultOutput;
- }
- }
- }
- return $docTags;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement