public function delete() { if ($this->id == 1) { return false; } $this->clearCache(); // Get children categories $to_delete = array((int) $this->id); $this->recursiveDelete($to_delete, (int) $this->id); $to_delete = array_unique($to_delete); // Delete CMS Category and its child from database $list = count($to_delete) > 1 ? implode(',', $to_delete) : (int) $this->id; //delete blog //get all blog from category ID //$where = '`id_leoblogcat` IN (' . $list . ')'; $result_blog = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('SELECT `id_leoblog_blog` as id FROM `' . _DB_PREFIX_ . 'leoblog_blog` WHERE `id_leoblogcat` IN (' . $list . ')'); foreach ($result_blog as $value) { $blog = new LeoBlogBlog($value['id']); $blog->delete(); } Db::getInstance()->execute('DELETE FROM `' . _DB_PREFIX_ . 'leoblogcat` WHERE `id_leoblogcat` IN (' . $list . ')'); Db::getInstance()->execute('DELETE FROM `' . _DB_PREFIX_ . 'leoblogcat_shop` WHERE `id_leoblogcat` IN (' . $list . ')'); Db::getInstance()->execute('DELETE FROM `' . _DB_PREFIX_ . 'leoblogcat_lang` WHERE `id_leoblogcat` IN (' . $list . ')'); leoblogcat::cleanPositions($this->id_parent); return true; }