*** mod/resource/lib.php 10 Jun 2009 03:07:25 AM
--- mod/resource/lib.php 22 Aug 2011 11:34:09 AM
***************
*** 614,621 ****
--- 614,683 ----
              notify(get_string('warningdisabledrename', 'resource'));
          }
      }
+ //<ouil MDL-2238 extension
+     resource_renamefiles_dbupdate($course, $wdir, $oldname, $name, $move);
+ //>
  }
  
+ //<ouil MDL-2238 extension
+ //Every time we change a file name/location, we must let the DB know...
+ function resource_renamefiles_dbupdate($course, $wdir, $oldname, $name, $move=FALSE)
+ {
+     global $CFG;
+ 
+     $queries = array();
+ 
+     $query->table = 'resource';
+     $query->fields = array('summary', 'alltext');
+     $queries[] = clone $query;
+ 
+     $query->table = 'label';
+     $query->fields = array('content');
+     $queries[] = clone $query;
+ 
+     // TODO: If you would like to add more fixes for other RTEs, add here 
+     // similar $queries with the text fields from specific tables.
+     
+     if ($move)
+     {
+         $old = trim($oldname, '/');
+     }
+     else
+     {
+         $old = trim($wdir.'/'.$oldname, '/');
+     }
+     $new = trim($wdir.'/'.$name, '/');
+ 
+     $like = " LIKE '%{$old}%'";
+ 
+     foreach($queries as $query)
+     {
+         foreach($query->fields as $field)
+         {
+             $select = "SELECT * FROM {$CFG->prefix}";
+             $select.= $query->table;
+             $select.= " WHERE ";
+             $select.= $field;
+             $select.= $like;
+ 
+             $results = get_records_sql($select);
+ 
+             if(!$results)
+                 continue;
+ 
+             foreach($results as $result)
+             {
+                 $result->$field = str_replace($old, $new, $result->$field);
+                 $result->$field = mysql_real_escape_string($result->$field);
+                 set_field($query->table, $field, $result->$field, 'id', $result->id);
+             }
+         }
+     }
+ 
+     rebuild_course_cache($course->id);
+ }
+ //>
+ 
  function resource_delete_warning($course, $files) {
      global $CFG;