Changeset 528 for trunk

Timestamp:

04/22/08 12:48:00 (7 months ago)

Author:

sidtheduck

Message:

Fix for ticket #96 - Removing filename extensions from cruft-free URLs using RLIKE (regular expressions) in the MySQL query. Hopefully this fixes the image hotlink issues people have been having.

Files:

• trunk/plog-functions.php (modified) (3 diffs)

trunk/plog-functions.php

@@ -991 +991 @@
                         $sql = "SELECT *
                                 FROM `".TABLE_PREFIX."pictures`
-                                WHERE `path`='" . mysql_real_escape_string($filepath)."'
+                                WHERE `path` RLIKE '^" . mysql_real_escape_string($filepath)."\..{3}$'
                                         AND `parent_album`=".intval($album["id"]);
                         $result = run_query($sql);
@@ -1090 +1090 @@
                         $pic = get_picture_by_id($id);
                         $album = $pic["parent_album"];
-                        $rv = $config["baseurl"].$pic["path"];
+                        $rv = $config["baseurl"].substr($pic['path'], 0, -4);
                 }
         } else {
@@ -2046 +2046 @@
 function plogger_get_source_picture_url() {
         global $config;
-        return (!empty($config['allow_fullpic'])) ? $config['galleryurl'].'images/'.SmartStripSlashes($GLOBALS["current_picture"]["path"]) : "#";
+        return (!empty($config['allow_fullpic'])) ? $config['gallery_url'].'images/'.SmartStripSlashes($GLOBALS["current_picture"]["path"]) : "#";
 }