Enable Media Replace - Version 2.9.5

Version Description

  • Bug fix for the short code displaying the modification date of a file
  • Updated all database queries in preparation for WP 3.9
Download this release

Release Info

Developer MungoBBQ
Plugin Icon 128x128 Enable Media Replace
Version 2.9.5
Comparing to
See all releases

Code changes from version 2.9.4 to 2.9.5

Files changed (4) hide show
  1. enable-media-replace.php +3 -3
  2. popup.php +1 -1
  3. readme.txt +4 -0
  4. upload.php +9 -7
enable-media-replace.php CHANGED
@@ -3,7 +3,7 @@
3
Plugin Name: Enable Media Replace
4
Plugin URI: http://www.mansjonasson.se/enable-media-replace
5
Description: Enable replacing media files by uploading a new file in the "Edit Media" section of the WordPress Media Library.
6
- Version: 2.9.4
7
Author: Måns Jonasson
8
Author URI: http://www.mansjonasson.se
9
@@ -144,8 +144,8 @@ function emr_get_modified_date($atts) {
144
$filetime = filemtime($current_file);
145
146
// do date conversion
147
- $content = date($format, current_time($filetime));
148
-
149
return $content;
150
151
}
3
Plugin Name: Enable Media Replace
4
Plugin URI: http://www.mansjonasson.se/enable-media-replace
5
Description: Enable replacing media files by uploading a new file in the "Edit Media" section of the WordPress Media Library.
6
+ Version: 2.9.5
7
Author: Måns Jonasson
8
Author URI: http://www.mansjonasson.se
9
144
$filetime = filemtime($current_file);
145
146
// do date conversion
147
+ $content = date($format, $filetime);
148
+
149
return $content;
150
151
}
popup.php CHANGED
@@ -19,7 +19,7 @@ $table_name = $wpdb->prefix . "posts";
19
20
$sql = "SELECT guid, post_mime_type FROM $table_name WHERE ID = " . (int) $_GET["attachment_id"];
21
22
- list($current_filename, $current_filetype) = mysql_fetch_array(mysql_query($sql));
23
24
$current_filename = substr($current_filename, (strrpos($current_filename, "/") + 1));
25
19
20
$sql = "SELECT guid, post_mime_type FROM $table_name WHERE ID = " . (int) $_GET["attachment_id"];
21
22
+ list($current_filename, $current_filetype) = $wpdb->get_row($sql, ARRAY_N);
23
24
$current_filename = substr($current_filename, (strrpos($current_filename, "/") + 1));
25
readme.txt CHANGED
@@ -37,6 +37,10 @@ If you want more control over the format used to display the time, you can use t
37
38
== Changelog ==
39
40
= 2.9.4 =
41
* Bug fix for timezone changes in WordPress
42
* Minor UI change to inform the user about what actually happens when replacing an image and using a new file name
37
38
== Changelog ==
39
40
+ = 2.9.5 =
41
+ * Bug fix for the short code displaying the modification date of a file
42
+ * Updated all database queries in preparation for WP 3.9
43
+
44
= 2.9.4 =
45
* Bug fix for timezone changes in WordPress
46
* Minor UI change to inform the user about what actually happens when replacing an image and using a new file name
upload.php CHANGED
@@ -61,7 +61,7 @@ function emr_delete_current_files($current_file) {
61
62
// Get old guid and filetype from DB
63
$sql = "SELECT guid, post_mime_type FROM $table_name WHERE ID = '" . (int) $_POST["ID"] . "'";
64
- list($current_filename, $current_filetype) = mysql_fetch_array(mysql_query($sql));
65
66
// Massage a bunch of vars
67
$current_guid = $current_filename;
@@ -128,32 +128,34 @@ if (is_uploaded_file($_FILES["userfile"]["tmp_name"])) {
128
$new_guid = str_replace($current_filename, $new_filename, $current_guid);
129
130
// Update database file name
131
- mysql_query("UPDATE $table_name SET post_title = '$new_filetitle', post_name = '$new_filetitle', guid = '$new_guid', post_mime_type = '$new_filetype' WHERE ID = '" . (int) $_POST["ID"] . "'");
132
133
// Update the postmeta file name
134
135
// Get old postmeta _wp_attached_file
136
$sql = "SELECT meta_value FROM $postmeta_table_name WHERE meta_key = '_wp_attached_file' AND post_id = '" . (int) $_POST["ID"] . "'";
137
- $old_meta_name = mysql_result(mysql_query($sql),0);
138
139
// Make new postmeta _wp_attached_file
140
$new_meta_name = str_replace($current_filename, $new_filename, $old_meta_name);
141
- mysql_query("UPDATE $postmeta_table_name SET meta_value = '$new_meta_name' WHERE meta_key = '_wp_attached_file' AND post_id = '" . (int) $_POST["ID"] . "'");
142
143
// Make thumb and/or update metadata
144
wp_update_attachment_metadata( (int) $_POST["ID"], wp_generate_attachment_metadata( (int) $_POST["ID"], $new_file) );
145
146
// Search-and-replace filename in post database
147
$sql = "SELECT ID, post_content FROM $table_name WHERE post_content LIKE '%$current_guid%'";
148
- $rs = mysql_query($sql);
149
150
- while($rows = mysql_fetch_assoc($rs)) {
151
152
// replace old guid with new guid
153
$post_content = $rows["post_content"];
154
$post_content = addslashes(str_replace($current_guid, $new_guid, $post_content));
155
156
- mysql_query("UPDATE $table_name SET post_content = '$post_content' WHERE ID = {$rows["ID"]}");
157
}
158
159
// Trigger possible updates on CDN and other plugins
61
62
// Get old guid and filetype from DB
63
$sql = "SELECT guid, post_mime_type FROM $table_name WHERE ID = '" . (int) $_POST["ID"] . "'";
64
+ list($current_filename, $current_filetype) = $wpdb->get_row($sql, ARRAY_N);
65
66
// Massage a bunch of vars
67
$current_guid = $current_filename;
128
$new_guid = str_replace($current_filename, $new_filename, $current_guid);
129
130
// Update database file name
131
+ $wpdb->query("UPDATE $table_name SET post_title = '$new_filetitle', post_name = '$new_filetitle', guid = '$new_guid', post_mime_type = '$new_filetype' WHERE ID = '" . (int) $_POST["ID"] . "'");
132
133
// Update the postmeta file name
134
135
// Get old postmeta _wp_attached_file
136
$sql = "SELECT meta_value FROM $postmeta_table_name WHERE meta_key = '_wp_attached_file' AND post_id = '" . (int) $_POST["ID"] . "'";
137
+ $old_meta_name = $wpdb->get_row($sql, ARRAY_A);
138
+ $old_meta_name = $old_meta_name["meta_value"];
139
140
// Make new postmeta _wp_attached_file
141
$new_meta_name = str_replace($current_filename, $new_filename, $old_meta_name);
142
+ $wpdb->query("UPDATE $postmeta_table_name SET meta_value = '$new_meta_name' WHERE meta_key = '_wp_attached_file' AND post_id = '" . (int) $_POST["ID"] . "'");
143
144
// Make thumb and/or update metadata
145
wp_update_attachment_metadata( (int) $_POST["ID"], wp_generate_attachment_metadata( (int) $_POST["ID"], $new_file) );
146
147
// Search-and-replace filename in post database
148
$sql = "SELECT ID, post_content FROM $table_name WHERE post_content LIKE '%$current_guid%'";
149
150
+ $rs = $wpdb->get_results($sql, ARRAY_A);
151
+
152
+ foreach($rs AS $rows) {
153
154
// replace old guid with new guid
155
$post_content = $rows["post_content"];
156
$post_content = addslashes(str_replace($current_guid, $new_guid, $post_content));
157
158
+ $wpdb->query("UPDATE $table_name SET post_content = '$post_content' WHERE ID = {$rows["ID"]}");
159
}
160
161
// Trigger possible updates on CDN and other plugins