public function publish(&$pks, $value = 1) { $published = parent::publish($pks, $value); if (!$published) { return false; } // mark to recalculate $query = ' UPDATE #__djrevs_reviews AS r ' . ' INNER JOIN #__djrevs_reviews_items as ri ON ri.review_id = r.id AND ri.field_id IN (' . implode(',', $pks) . ')' . ' SET r.recalculate = 1 '; $this->_db->setQuery($query); $this->_db->query(); return true; }
public function publish(&$pks, $value = 1) { $published = parent::publish($pks, $value); if (!$published) { return false; } // mark to recalculate if (count($pks)) { $query = ' UPDATE #__djrevs_reviews ' . ' SET recalculate = 2 ' . ' WHERE id IN (' . implode(',', $pks) . ')'; $this->_db->setQuery($query); $this->_db->query(); } return true; }