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;
}
}
