function wiki_convert_all_wikis() { global $CFG; //get all wikis if ($wikis = get_records_sql('SELECT * FROM ' . $CFG->prefix . 'wiki')) { //get every wiki separately foreach ($wikis as $wiki) { //get the new cm pointing to the new dfwiki and not to the wiki $dfwikiid = wiki_config_course_module($wiki); //get every entry for the current wiki if ($entries = get_records_sql('SELECT * FROM ' . $CFG->prefix . 'wiki_entries WHERE wikiid=\'' . $wiki->id . '\'')) { //get eveery entry separately foreach ($entries as $entry) { //with every entry we get all wiki pages if ($pages = get_records_sql('SELECT * FROM ' . $CFG->prefix . 'wiki_pages WHERE wiki=\'' . $entry->id . '\'')) { //get every wiki page foreach ($pages as $page) { //insert the new page into the new dfwiki wiki_insert_page_from_wiki($page, $dfwikiid, $wiki->htmlmode, $wiki->course, $wiki->name, $wiki->id, $entry->groupid); //delete the wiki page $quer3 = 'DELETE FROM ' . $CFG->prefix . 'wiki_pages WHERE id=\'' . $page->id . '\''; execute_sql($quer3, false); } } //delete entries from DB $quer = 'DELETE FROM ' . $CFG->prefix . 'wiki_entries WHERE id=\'' . $entry->id . '\''; execute_sql($quer, false); } } //delete wiki entry in DB $quer2 = 'DELETE FROM ' . $CFG->prefix . 'wiki WHERE id=\'' . $wiki->id . '\''; execute_sql($quer2, false); $modul = get_record("modules", "name", 'wiki'); $coursemodule = get_record_sql('SELECT * FROM ' . $CFG->prefix . 'course_modules WHERE module=' . $modul->id . ' AND instance=' . $wiki->id); } } @rebuild_course_cache(); return true; }
function wiki_convert_all_dfwikis($course) { global $CFG; //get all dfwikis in the course if ($dfwikis = get_records_sql('SELECT * FROM ' . $CFG->prefix . 'dfwiki WHERE course=' . $course->id)) { //get every dfwiki separately foreach ($dfwikis as $dfw) { //get the new cm pointing to the new wiki and not to the dfwiki $newwiki = wiki_config_course_module($dfw); //with every dfwiki we get all dfwiki pages if ($pages = get_records_sql('SELECT * FROM ' . $CFG->prefix . 'dfwiki_pages WHERE dfwiki=\'' . $dfw->id . '\'')) { //get every dfwiki page foreach ($pages as $page) { //insert the new page into the new wiki wiki_insert_page_from_dfwiki($page, $newwiki); //delete the dfwiki page $quer3 = 'DELETE FROM ' . $CFG->prefix . 'dfwiki_pages WHERE dfwiki=\'' . $dfw->id . '\''; execute_sql($quer3, false); } } //delete dfwiki in DB $quer2 = 'DELETE FROM ' . $CFG->prefix . 'dfwiki WHERE id=\'' . $dfw->id . '\''; execute_sql($quer2, false); } @rebuild_course_cache(); return true; } else { return false; } }