From 6c53eb65c30352001e9916b8fc336f4c6d9cd8b5 Mon Sep 17 00:00:00 2001 From: Lester Caine Date: Sun, 29 Jan 2006 19:04:16 +0000 Subject: Restore reserved word fix ;) --- BitArticle.php | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'BitArticle.php') diff --git a/BitArticle.php b/BitArticle.php index b4a8027..2951655 100644 --- a/BitArticle.php +++ b/BitArticle.php @@ -1,6 +1,6 @@ - * @version $Revision: 1.49 $ $Date: 2006/01/26 14:56:29 $ $Author: squareing $ + * @version $Revision: 1.50 $ $Date: 2006/01/29 19:04:16 $ $Author: lsces $ */ /** @@ -642,13 +642,13 @@ class BitArticle extends LibertyAttachable { $bindvars[] = ( int )$timestamp; } - $query = "SELECT ta.*, tc.*, top.*, type.*, tas.`status_name`, + $query = "SELECT ta.*, tc.*, top.*, tatype.*, tas.`status_name`, tf.`storage_path` as `image_storage_path` FROM `".BIT_DB_PREFIX."tiki_articles` ta INNER JOIN `".BIT_DB_PREFIX."tiki_content` tc ON( tc.`content_id` = ta.`content_id` ) INNER JOIN `".BIT_DB_PREFIX."tiki_article_status` tas ON( tas.`status_id` = ta.`status_id` ) LEFT OUTER JOIN `".BIT_DB_PREFIX."tiki_article_topics` top ON( top.`topic_id` = ta.`topic_id` ) - LEFT OUTER JOIN `".BIT_DB_PREFIX."tiki_article_types` type ON( type.`article_type_id` = ta.`article_type_id` ) + LEFT OUTER JOIN `".BIT_DB_PREFIX."tiki_article_types` tatype ON( tatype.`article_type_id` = ta.`article_type_id` ) LEFT OUTER JOIN `".BIT_DB_PREFIX."tiki_attachments` tat ON( tat.`attachment_id` = ta.`image_attachment_id` ) LEFT OUTER JOIN `".BIT_DB_PREFIX."tiki_files` tf ON( tf.`file_id` = tat.`foreign_id` ) ".( !empty( $mid ) ? $mid.' AND ' : ' WHERE ' )." tc.`content_type_guid` = '".BITARTICLE_CONTENT_TYPE_GUID."' -- cgit v1.3