View source for JTableNested/publish

===Source Body===
<source lang="php">
public function publish($pks = null, $state = 1, $userId = 0)
{
        // Initialise variables.
        $k = $this->_tbl_key;

        // Sanitize input.
        JArrayHelper::toInteger($pks);
        $userId = (int) $userId;
        $state  = (int) $state;

        // If there are no primary keys set check to see if the instance key is set.
        if (empty($pks)) {
                if ($this->$k) {
                        $pks = array($this->$k);
                }
                // Nothing to set publishing state on, return false.
                else {
                        $this->setError(JText::_('JERROR_NO_ROWS_SELECTED'));
                        return false;
                }
        }

        // Determine if there is checkout support for the table.
        if (!property_exists($this, 'checked_out') || !property_exists($this, 'checked_out_time')) {
                $checkoutSupport = false;
        } else {
                $checkoutSupport = true;
        }

        // Iterate over the primary keys to execute the publish action if possible.
        foreach ($pks as $pk) {
                // Get the node by primary key.
                if (!$node = $this->_getNode($pk)) {
                        // Error message set in getNode method.
                        return false;
                }

                // If the table has checkout support, verify no children are checked out.
                if ($checkoutSupport) {
                        // Ensure that children are not checked out.
                        $this->_db->setQuery(
                                'SELECT COUNT('.$this->_tbl_key.')' .
                                ' FROM `'.$this->_tbl.'`' .
                                ' WHERE `lft` BETWEEN '.(int) $node->lft.' AND '.(int) $node->rgt .
                                ' AND (checked_out <> 0 AND checked_out <> '.(int) $userId.')'
                        );

                        // Check for checked out children.
                        if ($this->_db->loadResult()) {
                                $this->setError('Child_Rows_Checked_Out');
                                return false;
                        }
                }

                // If any parent nodes have lower published state values, we cannot continue.
                if ($node->parent_id) {
                        // Get any ancestor nodes that have a lower publishing state.
                        $this->_db->setQuery(
                                'SELECT p.'.$k .
                                ' FROM `'.$this->_tbl.'` AS n, `'.$this->_tbl.'` AS p' .
                                ' WHERE n.lft BETWEEN p.lft AND p.rgt' .
                                ' AND n.'.$k.' = '.(int) $pk .
                                ' AND p.parent_id > 0' .
                                ' AND p.published < '.(int) $state .
                                ' ORDER BY p.lft DESC',
                                1, 0
                        );
                        $rows = $this->_db->loadResultArray();

                        // Check for a database error.
                        if ($this->_db->getErrorNum()) {
                                $this->setError($this->_db->getErrorMsg());
                                return false;
                        }

                        if (!empty($rows)) {
                                $this->setError('Ancestor_Nodes_Lower_Published_State');
                                return false;
                        }
                }

                // Update the publishing state.
                $this->_db->setQuery(
                        'UPDATE `'.$this->_tbl.'`' .
                        ' SET `published` = '.(int) $state .
                        ' WHERE `'.$this->_tbl_key.'` = '.(int) $pk
                );
                $this->_db->query();

                // Check for a database error.
                if ($this->_db->getErrorNum()) {
                        $this->setError($this->_db->getErrorMsg());
                        return false;
                }

                // If checkout support exists for the object, check the row in.
                if ($checkoutSupport) {
                        $this->checkin($pk);
                }
        }

        // If the JTable instance value is in the list of primary keys that were set, set the instance.
        if (in_array($this->$k, $pks)) {
                $this->published = $state;
        }

        $this->_errors = array();
        return true;
}
</source>