[mxbb-commits] mx_bugsbt/bugsbt/includes functions.php,1.2,1.3

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/mx_bugsbt/bugsbt/includes
In directory sc8-pr-cvs16:/tmp/cvs-serv11506

Modified Files:
	functions.php 
Log Message:
Wrong LEFT JOIN syntax

Index: functions.php
===================================================================
RCS file: /cvsroot/mxbb/mx_bugsbt/bugsbt/includes/functions.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** functions.php	5 May 2007 20:18:03 -0000	1.2
--- functions.php	16 May 2007 19:36:56 -0000	1.3
***************
*** 569,585 ****
  					break;
  
! 				default:
! 					/* Bug 50
! 					$sql = "SELECT a.*, AVG(r.rate_point) AS rating, COUNT(r.votes_article) AS total_votes, u.user_id, u.username, c.category_id, c.category_name
! 						FROM " . KB_ARTICLES_TABLE . " AS a, " . KB_CATEGORIES_TABLE . " AS c
! 							LEFT JOIN " . KB_VOTES_TABLE . " AS r ON a.article_id = r.votes_article
! 							LEFT JOIN " . USERS_TABLE . " AS u ON a.article_author_id = u.user_id
! 						WHERE c.category_id = a.article_category_id
! 							AND a.article_id = '" . $item_id . "'
! 						GROUP BY a.article_id";
! 					*/
              		$sql = "SELECT a.*, u.user_id, u.username, c.category_id, c.category_name
                    		FROM " . BUGSBT_BUGS_TABLE . " AS a
!                      		LEFT JOIN " . BUGSBT_PRODUCTS_TABLE . " AS c ON c.category_id = a.bug_category_id
                       		LEFT JOIN " . USERS_TABLE . " AS u ON a.bug_author_id = u.user_id
                    		WHERE a.bug_id = '" . $item_id . "'
--- 569,576 ----
  					break;
  
! 				default:s
              		$sql = "SELECT a.*, u.user_id, u.username, c.category_id, c.category_name
                    		FROM " . BUGSBT_BUGS_TABLE . " AS a
!                      		LEFT JOIN " . BUGSBT_PRODUCTS_TABLE . " AS c ON a.bug_category_id = c.category_id
                       		LEFT JOIN " . USERS_TABLE . " AS u ON a.bug_author_id = u.user_id
                    		WHERE a.bug_id = '" . $item_id . "'