evolution-cms / evolution

        $where = "pub_date <= {$timeNow} AND pub_date!=0 AND published=0";

        $result_pub = $this->getDatabase()->select( 'id', '[+prefix+]site_content',  $where);

        $this->getDatabase()->update($field, '[+prefix+]site_content', $where);

        if ($this->getDatabase()->getRecordCount($result_pub) >= 1) { //Event unPublished doc

            while ($row_pub = $this->getDatabase()->getRow($result_pub)) {

                $this->invokeEvent("OnDocUnPublished", array(

                    "docid" => $row_pub['id']

                ));

            }

        }

        // now, check for documents that need un-publishing

        $field = array('published' => 0, 'publishedon' => 0);

        $where = "unpub_date <= {$timeNow} AND unpub_date!=0 AND published=1";

        $result_unpub = $this->getDatabase()->select( 'id', '[+prefix+]site_content',  $where);

        $this->getDatabase()->update($field, '[+prefix+]site_content', $where);

        if ($this->getDatabase()->getRecordCount($result_unpub) >= 1) { //Event unPublished doc

            while ($row_unpub = $this->getDatabase()->getRow($result_unpub)) {

                $this->invokeEvent("OnDocUnPublished", array(

                    "docid" => $row_unpub['id']

                ));

            }

        }

        $this->recentUpdate = $timeNow;