Need to find replace old picture links

[dzon]

Hi,

This is a little hard to explain so here goes. I have recently moved our moodle site to a new server. I have made the necessary changes in config.php and the site is 95% operational again. The problem I have is that there are around 400 picture links from various topics and course work that still go to the old server. This is because the links were typed in maually when the picture was inserted. Now, I can quite easily turn on editing, break the link and create it again but this would prove to be a very laborious task. Is there a way of using find and replace? I am very new to php and cannot work out where the files are that contain the links. If I call up a page where the link is broken and then choose view > source I can see the code. I then choose find and type in the old url and I find one reference.I can change it and save it but it does nothing. next time i look the old link is back again.

Surely these links must be stored in some file on my server?

Thanks in advance

Dzon

 

[vacunita]

You will have to open the PHP pages straight from wherever they reside in your server, and not through the browser. so you can see the PHP code and find the link there.

There is also the possibility that the links are kept in a database and are put in the webpages dynamically i.e

echo "<img src='" . $link . "'>";

Try opening them using notepad or something similar from the location on the server. i.e from the servers point of view C:\mywebsite\somepage.php and look for the links.

You can use notepads replace option, on the php files themselves.





----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[dzon]

Hi,

Thanks for your reply. The problem is, I cannot find which file the link is in.

here is the url that leeds me to a page a picture is on that is not displayed because it points to an old server:

http://moodletest.domain/moodle/mod/quiz/attempt.php?id=405

I am not sure whether id=405 is relevant.
here is the contents of attempt.php (sorry but its long)


<?php // $Id: attempt.php,v 1.63.2.10 2005/08/26 08:53:13 gustav_delius Exp $
/**
* This page prints a particular instance of quiz
*
* @version $Id: attempt.php,v 1.63.2.10 2005/08/26 08:53:13 gustav_delius Exp $
* @author Martin Dougiamas and many others. This has recently been completely
* rewritten by Alex Smith, Julian Sedding and Gustav Delius as part of
* the Serving Mathematics project
* {@link

http://maths.york.ac.uk/serving_maths}

* @license

http://www.gnu.org/copyleft/gpl.html

GNU Public License
* @package quiz
*/

require_once("../../config.php");
require_once("locallib.php");

$id = optional_param('id', 0, PARAM_INT); // Course Module ID
$q = optional_param('q', 0, PARAM_INT); // or quiz ID
$page = optional_param('page', 0, PARAM_INT);
$questionids = optional_param('questionids', '');
$finishattempt = optional_param('finishattempt', 0, PARAM_BOOL);
$timeup = optional_param('timeup', 0, PARAM_BOOL); // True if form was submitted by timer.
$forcenew = optional_param('forcenew', false, PARAM_BOOL); // Teacher has requested new preview

// remember the current time as the time any responses were submitted
// (so as to make sure students don't get penalized for slow processing on this page)
$timestamp = time();

// We treat automatically closed attempts just like normally closed attempts
if ($timeup) {
$finishattempt = 1;
}

if ($id) {
if (! $cm = get_record("course_modules", "id", $id)) {
error("There is no coursemodule with id $id");
}

if (! $course = get_record("course", "id", $cm->course)) {
error("Course is misconfigured");
}

if (! $quiz = get_record("quiz", "id", $cm->instance)) {
error("The quiz with id $cm->instance corresponding to this coursemodule $id is missing");
}

} else {
if (! $quiz = get_record("quiz", "id", $q)) {
error("There is no quiz with id $q");
}
if (! $course = get_record("course", "id", $quiz->course)) {
error("The course with id $quiz->course that the quiz with id $q belongs to is missing");
}
if (! $cm = get_coursemodule_from_instance("quiz", $quiz->id, $course->id)) {
error("The course module for the quiz with id $q is missing");
}
}

require_login($course->id, false, $cm);
$isteacher = isteacher($course->id);

// Get number for the next or unfinished attempt
if(!$attemptnumber = (int)get_field_sql('SELECT MAX(attempt)+1 FROM ' .
"{$CFG->prefix}quiz_attempts WHERE quiz = '{$quiz->id}' AND " .
"userid = '{$USER->id}' AND timefinish > 0 AND preview != 1")) {
$attemptnumber = 1;
}

$strattemptnum = get_string('attempt', 'quiz', $attemptnumber);
$strquizzes = get_string("modulenameplural", "quiz");
$popup = $isteacher ? 0 : $quiz->popup; // Controls whether this is shown in a javascript-protected window.

/// Print the page header
if (!empty($popup)) {
define('MESSAGE_WINDOW', true); // This prevents the message window coming up
print_header($course->shortname.': '.format_string($quiz->name), '', '', '', '', false, '', '', false, '');
include('protect_js.php');
} else {
$strupdatemodule = isteacheredit($course->id)
? update_module_button($cm->id, $course->id, get_string('modulename', 'quiz'))
: "";
print_header_simple(format_string($quiz->name), "",
"<a href=\"index.php?id=$course->id\">$strquizzes</a> ->
<a href=\"view.php?id=$cm->id\">".format_string($quiz->name)."</a> -> $strattemptnum",
"", "", true, $strupdatemodule);
}

echo '<div id="overDiv" style="position:absolute; visibility:hidden; z-index:1000;"></div>'; // for overlib

/// Print the quiz name heading and tabs for teacher
if ($isteacher) {
$currenttab = 'preview';
include('tabs.php');
} else {
if ($quiz->attempts != 1) {
print_heading(format_string($quiz->name).' - '.$strattemptnum);
} else {
print_heading(format_string($quiz->name));
}
}

/// Check availability
if (isguest()) {
print_heading(get_string('guestsno', 'quiz'));
if (empty($popup)) {
print_footer($course);
}
exit;
}

$numberofpreviousattempts = count_records_select('quiz_attempts', "quiz = '{$quiz->id}' AND " .
"userid = '{$USER->id}' AND timefinish > 0 AND preview != 1");
if ($quiz->attempts and $numberofpreviousattempts >= $quiz->attempts) {
error(get_string('nomoreattempts', 'quiz'), "view.php?id={$cm->id}");
}

/// Check subnet access
if ($quiz->subnet and !address_in_subnet(getremoteaddr(), $quiz->subnet)) {
if ($isteacher) {
notify(get_string('subnetnotice', 'quiz'));
} else {
error(get_string("subneterror", "quiz"), "view.php?id=$cm->id");
}
}

/// Check password access
if ($quiz->password and empty($_POST['q'])) {
if (empty($_POST['quizpassword'])) {

if (trim(strip_tags($quiz->intro))) {
print_simple_box(format_text($quiz->intro), "center");
}
echo "<br />\n";

echo "<form name=\"passwordform\" method=\"post\" action=\"attempt.php?id=$cm->id\">\n";
print_simple_box_start("center");

echo "<div align=\"center\">\n";
print_string("requirepasswordmessage", "quiz");
echo "<br /><br />\n";
echo " <input name=\"quizpassword\" type=\"password\" value=\"\" alt=\"password\" />";
echo " <input type=\"submit\" value=\"".get_string("ok")."\" />\n";
echo "</div>\n";

print_simple_box_end();
echo "</form>\n";

if (empty($popup)) {
print_footer();
}
exit;

} else {
if (strcmp($quiz->password, $_POST['quizpassword']) !== 0) {
error(get_string("passworderror", "quiz"), "view.php?id=$cm->id");
}
}
}

/// Load attempt or create a new attempt if there is no unfinished one

if ($isteacher and $forcenew) { // teacher wants a new preview
// so we set a finish time on the current attempt (if any).
// It will then automatically be deleted below
set_field('quiz_attempts', 'timefinish', $timestamp, 'quiz', $quiz->id, 'userid', $USER->id);
}

$attempt = get_record('quiz_attempts', 'quiz', $quiz->id,
'userid', $USER->id, 'timefinish', 0);

$newattempt = false;
if (!$attempt) {
// Check if this is a preview request from a teacher
// in which case the previous previews should be deleted
if ($isteacher) {
if ($oldattempts = get_records_select('quiz_attempts', "quiz = '$quiz->id'
AND userid = '$USER->id'")) {
delete_records('quiz_attempts', 'quiz', $quiz->id, 'userid', $USER->id);
delete_records('quiz_grades', 'quiz', $quiz->id, 'userid', $USER->id);
foreach ($oldattempts as $oldattempt) {
// there should only be one but we loop just in case
delete_records('quiz_states', 'attempt', $oldattempt->id);
delete_records('quiz_newest_states', 'attemptid', $oldattempt->id);
}
}
}
$newattempt = true;
// Start a new attempt and initialize the question sessions
$attempt = quiz_create_attempt($quiz, $attemptnumber);
// If this is an attempt by a teacher mark it as a preview
if ($isteacher) {
$attempt->preview = 1;
}
// Save the attempt
if (!$attempt->id = insert_record('quiz_attempts', $attempt)) {
error('Could not create new attempt');
}
// make log entries
if ($isteacher) {
add_to_log($course->id, 'quiz', 'preview',
"attempt.php?id=$cm->id",
"$quiz->id", $cm->id);
} else {
add_to_log($course->id, 'quiz', 'attempt',
"review.php?attempt=$attempt->id",
"$quiz->id", $cm->id);
}
} else {
// log continuation of attempt only if some time has lapsed
if (($timestamp - $attempt->timemodified) > 600) { // 10 minutes have elapsed
add_to_log($course->id, 'quiz', 'continue attempt',
"review.php?attempt=$attempt->id",
"$quiz->id", $cm->id);
}
}
if (!$attempt->timestart) { // shouldn't really happen, just for robustness
$attempt->timestart = time();
}

/// Load all the questions and states needed by this script

// list of questions needed by page
$pagelist = quiz_questions_on_page($attempt->layout, $page);

if ($newattempt) {
$questionlist = quiz_questions_in_quiz($attempt->layout);
} else {
$questionlist = $pagelist;
}

// add all questions that are on the submitted form
if ($questionids) {
$questionlist .= ','.$questionids;
}

if (!$questionlist) {
error(get_string('noquestionsfound', 'quiz'), 'view.php?q='.$quiz->id);
}

$sql = "SELECT q.*, i.grade AS maxgrade, i.id AS instance".
" FROM {$CFG->prefix}quiz_questions q,".
" {$CFG->prefix}quiz_question_instances i".
" WHERE i.quiz = '$quiz->id' AND q.id = i.question".
" AND q.id IN ($questionlist)";

// Load the questions
if (!$questions = get_records_sql($sql)) {
error(get_string('noquestionsfound', 'quiz'), 'view.php?q='.$quiz->id);
}

// Load the question type specific information
if (!quiz_get_question_options($questions)) {
error('Could not load question options');
}

// Restore the question sessions to their most recent states
// creating new sessions where required
if (!$states = quiz_restore_question_sessions($questions, $quiz, $attempt)) {
error('Could not restore question sessions');
}

// Save all the newly created states
if ($newattempt) {
foreach ($questions as $i => $question) {
quiz_save_question_session($questions[$i], $states[$i]);
}
}


/// Process form data /////////////////////////////////////////////////

if ($responses = data_submitted() and empty($_POST['quizpassword'])) {

// set the default event. This can be overruled by individual buttons.
$event = (array_key_exists('markall', $responses)) ? QUIZ_EVENTGRADE :
($finishattempt ? QUIZ_EVENTCLOSE : QUIZ_EVENTSAVE);

// Unset any variables we know are not responses
unset($responses->id);
unset($responses->q);
unset($responses->oldpage);
unset($responses->newpage);
unset($responses->review);
unset($responses->questionids);
unset($responses->saveattempt); // responses get saved anway
unset($responses->finishattempt); // same as $finishattempt
unset($responses->markall);
unset($responses->forcenewattempt);

// extract responses
// $actions is an array indexed by the questions ids
$actions = quiz_extract_responses($questions, $responses, $event);

// Process each question in turn

$questionidarray = explode(',', $questionids);
foreach($questionidarray as $i) {
if (!isset($actions[$i])) {
$actions[$i]->responses = array('' => '');
}
$actions[$i]->timestamp = $timestamp;
quiz_process_responses($questions[$i], $states[$i], $actions[$i], $quiz, $attempt);
quiz_save_question_session($questions[$i], $states[$i]);
}

$attempt->timemodified = $timestamp;

// We have now finished processing form data
}


/// Finish attempt if requested
if ($finishattempt) {

// Set the attempt to be finished
$attempt->timefinish = $timestamp;

// Find all the questions for this attempt for which the newest
// state is not also the newest graded state
if ($closequestions = get_records_select('quiz_newest_states',
"attemptid = $attempt->id AND newest != newgraded", '', 'questionid, questionid')) {

// load all the questions
$closequestionlist = implode(',', array_keys($closequestions));
$sql = "SELECT q.*, i.grade AS maxgrade, i.id AS instance".
" FROM {$CFG->prefix}quiz_questions q,".
" {$CFG->prefix}quiz_question_instances i".
" WHERE i.quiz = '$quiz->id' AND q.id = i.question".
" AND q.id IN ($closequestionlist)";
if (!$closequestions = get_records_sql($sql)) {
error('Questions missing');
}

// Load the question type specific information
if (!quiz_get_question_options($closequestions)) {
error('Could not load question options');
}

// Restore the question sessions
if (!$closestates = quiz_restore_question_sessions($closequestions, $quiz, $attempt)) {
error('Could not restore question sessions');
}

foreach($closequestions as $key => $question) {
$action->event = QUIZ_EVENTCLOSE;
$action->responses = $closestates[$key]->responses;
$action->timestamp = $closestates[$key]->timestamp;
quiz_process_responses($question, $closestates[$key], $action, $quiz, $attempt);
quiz_save_question_session($question, $closestates[$key]);
}
}
add_to_log($course->id, 'quiz', 'close attempt',
"review.php?attempt=$attempt->id",
"$quiz->id", $cm->id);
}

/// Update the quiz attempt and the overall grade for the quiz
if ($responses || $finishattempt) {
if (!update_record('quiz_attempts', $attempt)) {
error('Failed to save the current quiz attempt!');
}
if (($attempt->attempt > 1 || $attempt->timefinish > 0) and !$attempt->preview) {
quiz_save_best_grade($quiz);
}
}

/// Check access to quiz page

// check the quiz times
if (($timestamp < $quiz->timeopen || $timestamp > $quiz->timeclose)) {
if ($isteacher) {
notify(get_string('notavailabletostudents', 'quiz'));
} else {
print_continue(get_string('notavailable', 'quiz'), "view.php?id={$cm->id}");
}
}

if ($finishattempt) {
redirect('review.php?attempt='.$attempt->id);
}

/// Print the quiz page ////////////////////////////////////////////////////////

/// Print the preview heading
if ($isteacher) {
print_heading(get_string('previewquiz', 'quiz', format_string($quiz->name)));
unset($buttonoptions);
$buttonoptions['q'] = $quiz->id;
$buttonoptions['forcenew'] = true;
echo '<center>';
print_single_button($CFG->

http://wwwroot.'/mod/quiz/attempt.php',

$buttonoptions, get_string('startagain', 'quiz'));
echo '</center>';
if ($quiz->popup) {
notify(get_string('popupnotice', 'quiz'));
}
}

/// Start the form
if($quiz->timelimit > 0) {
// Make sure javascript is enabled for time limited quizzes
?>
<script language="javascript" type="text/javascript">
<!--
document.write("<form name=\"responseform\" method=\"post\" action=\"attempt.php\">\n");
// -->
</script>
<noscript>
<center><p><strong><?php print_string('noscript', 'quiz'); ?></strong></p></center>
</noscript>
<?php
} else {
echo "<form name=\"responseform\" method=\"post\" action=\"attempt.php\">\n";
}

// Add a hidden field with the quiz id
echo '<input type="hidden" name="q" value="' . s($quiz->id) . "\" />\n";

/// Print the navigation panel if required
$numpages = quiz_number_of_pages($attempt->layout);
if ($numpages > 1) {
?>
<script language="javascript" type="text/javascript">
function navigate(page) {
document.responseform.page.value=page;
document.responseform.submit();
}
</script>
<?php
echo '<input type="hidden" id="page" name="page" value="'.$page."\" />\n";
quiz_print_navigation_panel($page, $numpages);
echo "<br />\n";
}

/// Print all the questions

// Add a hidden field with questionids
echo '<input type="hidden" name="questionids" value="'.$pagelist."\" />\n";

$pagequestions = explode(',', $pagelist);
$number = quiz_first_questionnumber($attempt->layout, $pagelist);
foreach ($pagequestions as $i) {
$options = quiz_get_renderoptions($quiz, $states[$i]);
// Print the question
if ($i > 0) {
echo "<br />\n";
}
quiz_print_quiz_question($questions[$i], $states[$i], $number, $quiz, $options);
quiz_save_question_session($questions[$i], $states[$i]);
$number += $questions[$i]->length;
}

/// Print the submit buttons

$strconfirmattempt = addslashes(get_string("confirmclose", "quiz"));
$onclick = "return confirm('$strconfirmattempt')";
echo "<center>\n";

echo "<input type=\"submit\" name=\"saveattempt\" value=\"".get_string("savenosubmit", "quiz")."\" />\n";
if ($quiz->optionflags & QUIZ_ADAPTIVE) {
echo "<input type=\"submit\" name=\"markall\" value=\"".get_string("markall", "quiz")."\" />\n";
}
echo "<input type=\"submit\" name=\"finishattempt\" value=\"".get_string("finishattempt", "quiz")."\" onclick=\"$onclick\" />\n";
echo '<input type="hidden" name="timeup" value="0" />';

echo "</center>";

// Print the navigation panel if required
if ($numpages > 1) {
echo "<br />\n";
quiz_print_navigation_panel($page, $numpages);
echo '<br />';
}

// Finish the form
echo "</form>\n";


$secondsleft = $quiz->timeclose - time();
// If time limit is set include floating timer.
if ($quiz->timelimit > 0) {

$timesincestart = time() - $attempt->timestart;
$timerstartvalue = min($quiz->timelimit*60 - $timesincestart, $secondsleft);
if ($timerstartvalue <= 0) {
$timerstartvalue = 1;
}

require('jstimer.php');
} else {
// Add the javascript timer in the title bar if the closing time appears close
if ($secondsleft > 0 and $secondsleft < 24*3600) { // less than a day remaining
include('jsclock.php');
}
}

// Finish the page
if (empty($popup)) {
print_footer($course);
}

?>

Any advise is much appreciated.

thanks in advance

Dzon

 

[vacunita]

From what I can tell, The image links are generated dynamically, somewhere else, as there is no trace of an image tag, such as [blue]<img src=...>[/blue].

Either they are generated from a database, or there is another page that has those links. There is nothing here that indicates image links of any kind.

since you are the only one that knows how the webpages are supposed to function, you are the only one that can figure out where the image links are coming from.

If I were you I'd check the config.php and localib.php files that are required at the begining of the page. These might have the links or at least something that can tell you where they are coming from.



----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[dzon]

Hi,

After further research I have found out that the links are stored in the MYSQL DB. They are in the table MDL_Quiz-Questions and the field name is called questiontext. I have managed to dump the table into excel and here is one of the records from the questiontext field.

<p>The figure below shows a speed-time graph.</p><p><img height="254" alt="Graph" hspace="0" src="

http://olddomain.com/moodle/file.php/2/2_Forces/Images/graph.gif"

width="256" align="middle" border="0" /></p><p>What distance (in metres) is travelled in 5 secs ?</p>

There are 2040 of these records and I need to somehow change olddomain.com to new.domain.com in every record.

Is there a way of using find replace in the MYSQL DB?

cheers

 

[vacunita]

You are going to have to issue an Update statement for every row in that table that has the offending links and update them.

I don't think there will be any other way to do it, other than issuing an update statement to the database to modify the fields.

However as the field is a big text string, its going to be difficult to create a statement that can look directly into the field and find and replace the olddomain.com string with the newdomain.com string, without altering the surrounding text.

I'm sure there is a way, but as it is now a MYSQL query question it falls a bit out of the scope of this forum.








----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[dzon]

Thanks for getting me this far.

Cheers,

Dzon

 

[vacunita]

You're very welcome. Saw your other pots, and hope someone at the Mysql forum can give you hand.



----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.