summaryrefslogtreecommitdiff
path: root/plugins
diff options
context:
space:
mode:
authorLester Caine <lester@lsces.co.uk>2007-06-16 18:02:54 +0000
committerLester Caine <lester@lsces.co.uk>2007-06-16 18:02:54 +0000
commit58e143b5cee16860b9c08e42c8247591f037b591 (patch)
tree94af6440f3d3b36987274b9c183e69402d63e11c /plugins
parent1ee8a5f97a3d386d469a9374a8ceb74a0859de87 (diff)
downloadliberty-58e143b5cee16860b9c08e42c8247591f037b591.tar.gz
liberty-58e143b5cee16860b9c08e42c8247591f037b591.tar.bz2
liberty-58e143b5cee16860b9c08e42c8247591f037b591.zip
Roll back picking up content_id - it can't actaully pick the correct one with the current relationships.
Diffstat (limited to 'plugins')
-rw-r--r--plugins/storage.bitfile.php5
1 files changed, 2 insertions, 3 deletions
diff --git a/plugins/storage.bitfile.php b/plugins/storage.bitfile.php
index 25367ba..7ff2f43 100644
--- a/plugins/storage.bitfile.php
+++ b/plugins/storage.bitfile.php
@@ -1,6 +1,6 @@
<?php
/**
- * @version $Revision: 1.33 $
+ * @version $Revision: 1.34 $
* @package liberty
* @subpackage plugins_storage
*/
@@ -98,9 +98,8 @@ function bit_files_load( $pRow ) {
$ret = NULL;
if( !empty( $pRow['foreign_id'] ) && is_numeric( $pRow['foreign_id'] )) {
$query = "
- SELECT la.*, lf.*, lam.`content_id`
+ SELECT *
FROM `".BIT_DB_PREFIX."liberty_attachments` la
- INNER JOIN `".BIT_DB_PREFIX."liberty_attachments_map` lam ON (la.`attachment_id` = lam.`attachment_id`)
INNER JOIN `".BIT_DB_PREFIX."liberty_files` lf ON (lf.`file_id` = la.`foreign_id`)
WHERE la.`foreign_id` = ? AND `attachment_plugin_guid` = ?";
if( $ret = $gBitSystem->mDb->getRow( $query, array( $pRow['foreign_id'], PLUGIN_GUID_BIT_FILES ))) {