Course in: $docsPath".'
';
if (is_dir($docsPath)) {
$finder = new \Symfony\Component\Finder\Finder();
$finder->files()->in($docsPath)->name('*.html');
foreach ($finder as $file) {
echo $file->getRealPath().'
';
$contents = file_get_contents($file->getRealPath());
$newContent = preg_replace($pathToSearch, $newUrlAppend.'/courses/${4}', $contents);
file_put_contents($file->getRealPath(), $newContent);
}
// Updating exercises
$sql = "SELECT iid, description FROM c_quiz WHERE c_id = $courseId";
$result = Database::query($sql);
$items = Database::store_result($result);
foreach ($items as $item) {
$id = $item['iid'];
$newContent = preg_replace($pathToSearch, $newUrlAppend.'/courses/${4}', $item['description']);
$newContent = Database::escape_string($newContent);
$sql = "UPDATE c_quiz SET description = '$newContent' WHERE iid = $id";
Database::query($sql);
}
// Updating questions
$sql = "SELECT iid, question, description FROM c_quiz_question WHERE c_id = $courseId";
$result = Database::query($sql);
$items = Database::store_result($result);
foreach ($items as $item) {
$id = $item['iid'];
$description = preg_replace($pathToSearch, $newUrlAppend.'/courses/${4}', $item['description']);
$description = Database::escape_string($description);
$question = preg_replace($pathToSearch, $newUrlAppend.'/courses/${4}', $item['question']);
$question = Database::escape_string($question);
$sql = "UPDATE c_quiz_question SET
description = '$description',
question = '$question'
WHERE iid = $id";
Database::query($sql);
}
// Updating answer
$sql = "SELECT iid, answer, comment FROM c_quiz_answer WHERE c_id = $courseId";
$result = Database::query($sql);
$items = Database::store_result($result);
foreach ($items as $item) {
$id = $item['iid'];
$answer = preg_replace($pathToSearch, $newUrlAppend.'/courses/${4}', $item['answer']);
$answer = Database::escape_string($answer);
$comment = preg_replace($pathToSearch, $newUrlAppend.'/courses/${4}', $item['comment']);
$comment = Database::escape_string($comment);
$sql = "UPDATE c_quiz_answer SET
answer = '$answer',
comment = '$comment'
WHERE iid = $id";
Database::query($sql);
}
// Updating intros
$sql = "SELECT iid, intro_text FROM c_tool_intro WHERE c_id = $courseId";
$result = Database::query($sql);
$items = Database::store_result($result);
foreach ($items as $item) {
$id = $item['iid'];
$text = preg_replace($pathToSearch, $newUrlAppend.'/courses/${4}', $item['intro_text']);
$text = Database::escape_string($text);
$sql = "UPDATE c_tool_intro SET
intro_text = '$text'
WHERE iid = $id";
Database::query($sql);
}
} else {
echo "Path doesn't exist
".'
';
}
}