id) // | // | // | // chat_messages // (UL,pk->id, fk->chatid) // // Meaning: pk->primary key field of the table // fk->foreign key to link with parent // nt->nested field (recursive data) // CL->course level info // UL->user level info // files->table may have files) // //----------------------------------------------------------- //This function executes all the restore procedure about this mod function chat_restore_mods($mod,$restore) { global $CFG; $status = true; //Get record from backup_ids $data = backup_getid($restore->backup_unique_code,$mod->modtype,$mod->id); if ($data) { //Now get completed xmlized object $info = $data->info; //traverse_xmlize($info); //Debug //print_object ($GLOBALS['traverse_array']); //Debug //$GLOBALS['traverse_array']=""; //Debug // if necessary, write to restorelog and adjust date/time fields if ($restore->course_startdateoffset) { restore_log_date_changes('Chat', $restore, $info['MOD']['#'], array('CHATTIME')); } //Now, build the CHAT record structure $chat->course = $restore->course_id; $chat->name = backup_todb($info['MOD']['#']['NAME']['0']['#']); $chat->intro = backup_todb($info['MOD']['#']['INTRO']['0']['#']); $chat->keepdays = backup_todb($info['MOD']['#']['KEEPDAYS']['0']['#']); $chat->studentlogs = backup_todb($info['MOD']['#']['STUDENTLOGS']['0']['#']); $chat->schedule = backup_todb($info['MOD']['#']['SCHEDULE']['0']['#']); $chat->chattime = backup_todb($info['MOD']['#']['CHATTIME']['0']['#']); $chat->timemodified = backup_todb($info['MOD']['#']['TIMEMODIFIED']['0']['#']); //The structure is equal to the db, so insert the chat $newid = insert_record ("chat",$chat); //Do some output if (!defined('RESTORE_SILENTLY')) { echo "
  • ".get_string("modulename","chat")." \"".format_string(stripslashes($chat->name),true)."\"
  • "; } backup_flush(300); if ($newid) { //We have the newid, update backup_ids backup_putid($restore->backup_unique_code,$mod->modtype, $mod->id, $newid); //Now check if want to restore user data and do it. if (restore_userdata_selected($restore,'chat',$mod->id)) { //Restore chat_messages $status = chat_messages_restore_mods ($mod->id, $newid,$info,$restore); } } else { $status = false; } } else { $status = false; } return $status; } //This function restores the chat_messages function chat_messages_restore_mods($old_chat_id, $new_chat_id,$info,$restore) { global $CFG; $status = true; //Get the messages array $messages = $info['MOD']['#']['MESSAGES']['0']['#']['MESSAGE']; //Iterate over messages for($i = 0; $i < sizeof($messages); $i++) { $mes_info = $messages[$i]; //traverse_xmlize($mes_info); //Debug //print_object ($GLOBALS['traverse_array']); //Debug //$GLOBALS['traverse_array']=""; //Debug //We'll need this later!! $oldid = backup_todb($mes_info['#']['ID']['0']['#']); $olduserid = backup_todb($mes_info['#']['USERID']['0']['#']); //Now, build the CHAT_MESSAGES record structure $message = new object(); $message->chatid = $new_chat_id; $message->userid = backup_todb($mes_info['#']['USERID']['0']['#']); $message->groupid = backup_todb($mes_info['#']['GROUPID']['0']['#']); $message->system = backup_todb($mes_info['#']['SYSTEM']['0']['#']); $message->message = backup_todb($mes_info['#']['MESSAGE_TEXT']['0']['#']); $message->timestamp = backup_todb($mes_info['#']['TIMESTAMP']['0']['#']); //We have to recode the userid field $user = backup_getid($restore->backup_unique_code,"user",$message->userid); if ($user) { $message->userid = $user->new_id; } //We have to recode the groupid field $group = restore_group_getid($restore, $message->groupid); if ($group) { $message->groupid = $group->new_id; } //The structure is equal to the db, so insert the chat_message $newid = insert_record ("chat_messages",$message); //Do some output if (($i+1) % 50 == 0) { if (!defined('RESTORE_SILENTLY')) { echo "."; if (($i+1) % 1000 == 0) { echo "
    "; } } backup_flush(300); } } return $status; } //Return a content decoded to support interactivities linking. Every module //should have its own. They are called automatically from //chat_decode_content_links_caller() function in each module //in the restore process function chat_decode_content_links ($content,$restore) { global $CFG; $result = $content; //Link to the list of chats $searchstring='/\$@(CHATINDEX)\*([0-9]+)@\$/'; //We look for it preg_match_all($searchstring,$content,$foundset); //If found, then we are going to look for its new id (in backup tables) if ($foundset[0]) { //print_object($foundset); //Debug //Iterate over foundset[2]. They are the old_ids foreach($foundset[2] as $old_id) { //We get the needed variables here (course id) $rec = backup_getid($restore->backup_unique_code,"course",$old_id); //Personalize the searchstring $searchstring='/\$@(CHATINDEX)\*('.$old_id.')@\$/'; //If it is a link to this course, update the link to its new location if($rec->new_id) { //Now replace it $result= preg_replace($searchstring,$CFG->wwwroot.'/mod/chat/index.php?id='.$rec->new_id,$result); } else { //It's a foreign link so leave it as original $result= preg_replace($searchstring,$restore->original_wwwroot.'/mod/chat/index.php?id='.$old_id,$result); } } } //Link to chat view by moduleid $searchstring='/\$@(CHATVIEWBYID)\*([0-9]+)@\$/'; //We look for it preg_match_all($searchstring,$result,$foundset); //If found, then we are going to look for its new id (in backup tables) if ($foundset[0]) { //print_object($foundset); //Debug //Iterate over foundset[2]. They are the old_ids foreach($foundset[2] as $old_id) { //We get the needed variables here (course_modules id) $rec = backup_getid($restore->backup_unique_code,"course_modules",$old_id); //Personalize the searchstring $searchstring='/\$@(CHATVIEWBYID)\*('.$old_id.')@\$/'; //If it is a link to this course, update the link to its new location if($rec->new_id) { //Now replace it $result= preg_replace($searchstring,$CFG->wwwroot.'/mod/chat/view.php?id='.$rec->new_id,$result); } else { //It's a foreign link so leave it as original $result= preg_replace($searchstring,$restore->original_wwwroot.'/mod/chat/view.php?id='.$old_id,$result); } } } return $result; } //This function makes all the necessary calls to xxxx_decode_content_links() //function in each module, passing them the desired contents to be decoded //from backup format to destination site/course in order to mantain inter-activities //working in the backup/restore process. It's called from restore_decode_content_links() //function in restore process function chat_decode_content_links_caller($restore) { global $CFG; $status = true; if ($chats = get_records_sql ("SELECT c.id, c.intro FROM {$CFG->prefix}chat c WHERE c.course = $restore->course_id")) { //Iterate over each chat->intro $i = 0; //Counter to send some output to the browser to avoid timeouts foreach ($chats as $chat) { //Increment counter $i++; $content = $chat->intro; $result = restore_decode_content_links_worker($content,$restore); if ($result != $content) { //Update record $chat->intro = addslashes($result); $status = update_record("chat",$chat); if (debugging()) { if (!defined('RESTORE_SILENTLY')) { echo '

    '.s($content).'
    changed to
    '.s($result).'

    '; } } } //Do some output if (($i+1) % 5 == 0) { if (!defined('RESTORE_SILENTLY')) { echo "."; if (($i+1) % 100 == 0) { echo "
    "; } } backup_flush(300); } } } return $status; } //This function returns a log record with all the necessay transformations //done. It's used by restore_log_module() to restore modules log. function chat_restore_logs($restore,$log) { $status = false; //Depending of the action, we recode different things switch ($log->action) { case "add": if ($log->cmid) { //Get the new_id of the module (to recode the info field) $mod = backup_getid($restore->backup_unique_code,$log->module,$log->info); if ($mod) { $log->url = "view.php?id=".$log->cmid; $log->info = $mod->new_id; $status = true; } } break; case "update": if ($log->cmid) { //Get the new_id of the module (to recode the info field) $mod = backup_getid($restore->backup_unique_code,$log->module,$log->info); if ($mod) { $log->url = "view.php?id=".$log->cmid; $log->info = $mod->new_id; $status = true; } } break; case "talk": if ($log->cmid) { //Get the new_id of the module (to recode the info field) $mod = backup_getid($restore->backup_unique_code,$log->module,$log->info); if ($mod) { $log->url = "view.php?id=".$log->cmid; $log->info = $mod->new_id; $status = true; } } break; case "view": if ($log->cmid) { //Get the new_id of the module (to recode the info field) $mod = backup_getid($restore->backup_unique_code,$log->module,$log->info); if ($mod) { $log->url = "view.php?id=".$log->cmid; $log->info = $mod->new_id; $status = true; } } break; case "view all": $log->url = "index.php?id=".$log->course; $status = true; break; case "report": if ($log->cmid) { //Get the new_id of the module (to recode the info field) $mod = backup_getid($restore->backup_unique_code,$log->module,$log->info); if ($mod) { $log->url = "report.php?id=".$log->cmid; $log->info = $mod->new_id; $status = true; } } break; default: if (!defined('RESTORE_SILENTLY')) { echo "action (".$log->module."-".$log->action.") unknown. Not restored
    "; //Debug } break; } if ($status) { $status = $log; } return $status; } ?>