public static function deleteCategory($id)
{
$id = (int) $id;
$db = BackendModel::getContainer()->get('database');
// get item
$item = self::getCategory($id);
if (!empty($item)) {
// delete meta
$db->delete('meta', 'id = ?', array($item['meta_id']));
// delete category
$db->delete('blog_categories', 'id = ?', array($id));
// update category for the posts that might be in this category
$db->update('blog_posts', array('category_id' => null), 'category_id = ?', array($id));
}
}