private function upgrade_db_post_3749() { $type_id = Vocabulary::object_type_id('post'); $vocabulary = Vocabulary::create(array('name' => 'tags', 'description' => 'Habari\'s tags implementation', 'features' => array('multiple', 'free'))); $new_tag = null; $post_ids = array(); $prefix = Config::get('db_connection')->prefix; $results = DB::get_results("SELECT id, tag_text, tag_slug from {$prefix}tags"); foreach ($results as $tag) { $new_tag = $vocabulary->add_term($tag->tag_text); $post_ids = DB::get_column("SELECT post_id FROM {$prefix}tag2post WHERE tag_id = ?", array($tag->id)); foreach ($post_ids as $id) { DB::insert("{object_terms}", array('term_id' => $new_tag->id, 'object_id' => $id, 'object_type_id' => $type_id)); } } }