Changeset 3445495

Timestamp:

01/23/2026 10:36:00 AM (2 months ago)

Author:

GhozyLab

Message:

Fix emg_get_attachment_id_from_src function

Location:

easy-media-gallery

Files:

• tags/1.3.170/includes/functions/functions.php (modified) (1 diff)
• trunk/includes/functions/functions.php (modified) (1 diff)

easy-media-gallery/tags/1.3.170/includes/functions/functions.php

@@ -456 +456 @@
 /*  Get attachment image id
 /*-------------------------------------------------------------------------------*/
-function emg_get_attachment_id_from_src( $link )
-{
-
+function emg_get_attachment_id_from_src( $url ) {
+    $id = attachment_url_to_postid( $url );
+    if ( $id ) {
+        return $id;
+    }
+
+    // fallback manual
     global $wpdb;
-    $link = preg_replace( '/-\d+x\d+(?=\.(jpg|jpeg|png|gif)$)/i', '', $link );
-
-    return $wpdb->get_var( "SELECT ID FROM {$wpdb->posts} WHERE guid='$link'" );
-
+
+    $path = wp_parse_url( $url, PHP_URL_PATH );
+    $path = preg_replace('/-\d+x\d+(?=\.(jpg|jpeg|png|gif)$)/i', '', $path);
+
+    return $wpdb->get_var(
+        $wpdb->prepare(
+            "SELECT post_id FROM {$wpdb->postmeta}
+             WHERE meta_key = '_wp_attached_file'
+             AND %s LIKE CONCAT('%%', meta_value)
+             LIMIT 1",
+            $path
+        )
+    );
 }
 

easy-media-gallery/trunk/includes/functions/functions.php

@@ -456 +456 @@
 /*  Get attachment image id
 /*-------------------------------------------------------------------------------*/
-function emg_get_attachment_id_from_src( $link )
-{
-
+function emg_get_attachment_id_from_src( $url ) {
+    $id = attachment_url_to_postid( $url );
+    if ( $id ) {
+        return $id;
+    }
+
+    // fallback manual
     global $wpdb;
-    $link = preg_replace( '/-\d+x\d+(?=\.(jpg|jpeg|png|gif)$)/i', '', $link );
-
-    return $wpdb->get_var( "SELECT ID FROM {$wpdb->posts} WHERE guid='$link'" );
-
+
+    $path = wp_parse_url( $url, PHP_URL_PATH );
+    $path = preg_replace('/-\d+x\d+(?=\.(jpg|jpeg|png|gif)$)/i', '', $path);
+
+    return $wpdb->get_var(
+        $wpdb->prepare(
+            "SELECT post_id FROM {$wpdb->postmeta}
+             WHERE meta_key = '_wp_attached_file'
+             AND %s LIKE CONCAT('%%', meta_value)
+             LIMIT 1",
+            $path
+        )
+    );
 }