$o1 = new sotf_NodeObject("sotf_genres"); $o1->set('genre_id', $id); $o1->set('language', 'en'); $o1->set('name', $english); $o1->create(); } createGenre(1, 'Actuality'); createGenre(2, 'Advert'); createGenre(3, 'Announcement'); createGenre(4, 'Call-in show'); createGenre(5, 'Children / youth'); createGenre(6, 'Comedy'); createGenre(7, 'Dance'); createGenre(8, 'Documentary'); createGenre(9, 'Drama'); createGenre(10, 'Education'); createGenre(11, 'Feature / spot'); createGenre(12, 'Game show'); createGenre(13, 'Interview'); createGenre(14, 'Jingle'); createGenre(15, 'Magazine'); createGenre(16, 'Mocroprogramme'); createGenre(17, 'Music'); createGenre(18, 'News'); createGenre(19, 'Oral history / storytelling'); createGenre(20, 'Talk show / discussion'); createGenre(21, 'Training'); ?> <h2>initialized genres</h2>
createGenre(7, 'Dance'); createGenre(8, 'Documentary'); createGenre(9, 'Drama'); createGenre(10, 'Education'); createGenre(11, 'Feature'); createGenre(12, 'Game show'); createGenre(13, 'Interview'); //createGenre( 14, 'Jingle'); createGenre(15, 'Magazine'); //createGenre( 16, 'Mocroprogramme'); createGenre(17, 'Music'); createGenre(18, 'News'); createGenre(19, 'Oral history / storytelling'); createGenre(20, 'Talk show / discussion'); createGenre(21, 'Training'); createGenre(22, 'Community media'); // delete topics $result = $db->query("DELETE FROM sotf_node_objects WHERE id LIKE '%tt%'"); $result = $db->query("DELETE FROM sotf_node_objects WHERE id LIKE '%td%'"); $result = $db->query("DELETE FROM sotf_node_objects WHERE id LIKE '%to%'"); $result = $db->query("SELECT setval('sotf_topics_seq', 1, false)"); $result = $db->query("SELECT setval('sotf_topic_trees_seq', 1, false)"); $result = $db->query("SELECT setval('sotf_topic_tree_defs_seq', 1, false)"); /* $sql = "DELETE FROM sotf_topic_tree_defs"; $result = pg_exec($conn, $sql); $sql = "DELETE FROM sotf_topic_trees"; $result = pg_exec($conn, $sql); $sql = "DELETE FROM sotf_topics"; $result = pg_exec($conn, $sql); */