http://something.something.fr/../../../../../../../courses-lt-marie-chamilo/CDE/document/science.jpg';
$newContent = preg_replace($pathToSearch, $pathToReplace, $contents);
echo $newContent;
exit;*/
$courseSysPath = api_get_path(SYS_COURSE_PATH);
foreach ($courses as $course) {
$courseId = $course['real_id'];
$docsPath = $courseSysPath.$course['directory'].'/document/';
echo "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, $pathToReplace, $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, $pathToReplace, $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, $pathToReplace, $item['description']);
$description = Database::escape_string($description);
$question = preg_replace($pathToSearch, $pathToReplace, $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, $pathToReplace, $item['answer']);
$answer = Database::escape_string($answer);
$comment = preg_replace($pathToSearch, $pathToReplace, $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, $pathToReplace, $item['intro_text']);
$text = Database::escape_string($text);
$sql = "UPDATE c_tool_intro SET
intro_text = '$text'
WHERE iid = $id";
Database::query($sql);
}
// Updating Glossary
$sql = "SELECT iid, description FROM c_glossary WHERE c_id = $courseId";
$result = Database::query($sql);
$items = Database::store_result($result);
foreach ($items as $item) {
$id = $item['iid'];
$gdescription = preg_replace($pathToSearch, $pathToReplace, $item['description']);
$gdescription = Database::escape_string($gdescription);
$sql = "UPDATE c_glossary SET description = '$gdescription' WHERE iid = $id";
Database::query($sql);
}
// Updating forums
$sql = "SELECT iid, forum_comment FROM c_forum_forum WHERE c_id = $courseId";
$result = Database::query($sql);
$items = Database::store_result($result);
foreach ($items as $item) {
$id = $item['iid'];
$text = preg_replace($pathToSearch, $pathToReplace, $item['forum_comment']);
$text = Database::escape_string($text);
$sql = "UPDATE c_forum_forum SET
forum_comment = '$text'
WHERE iid = $id";
Database::query($sql);
}
// Updating posts
$sql = "SELECT iid, post_text FROM c_forum_post WHERE c_id = $courseId";
$result = Database::query($sql);
$items = Database::store_result($result);
foreach ($items as $item) {
$id = $item['iid'];
$text = preg_replace($pathToSearch, $pathToReplace, $item['post_text']);
$text = Database::escape_string($text);
$sql = "UPDATE c_forum_post SET
post_text = '$text'
WHERE iid = $id";
Database::query($sql);
}
// Updating forum cats
$sql = "SELECT iid, cat_comment FROM c_forum_category WHERE c_id = $courseId";
$result = Database::query($sql);
$items = Database::store_result($result);
foreach ($items as $item) {
$id = $item['iid'];
$text = preg_replace($pathToSearch, $pathToReplace, $item['cat_comment']);
$text = Database::escape_string($text);
$sql = "UPDATE c_forum_category SET
cat_comment = '$text'
WHERE iid = $id";
Database::query($sql);
}
} else {
echo "Path doesn't exist
".'
';
}
}