[mxbb-commits] mx_kb/kb/includes functions.php,1.16,1.17

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

Update of /cvsroot/mxbb/mx_kb/kb/includes
In directory sc8-pr-cvs16:/tmp/cvs-serv11969/includes

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

Index: functions.php
===================================================================
RCS file: /cvsroot/mxbb/mx_kb/kb/includes/functions.php,v
retrieving revision 1.16
retrieving revision 1.17
diff -C2 -d -r1.16 -r1.17
*** functions.php	28 Apr 2007 19:59:04 -0000	1.16
--- functions.php	16 May 2007 19:37:44 -0000	1.17
***************
*** 764,779 ****
  
  				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.*, 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
!                      		LEFT JOIN " . KB_CATEGORIES_TABLE . " AS c ON c.category_id = a.article_category_id
                       		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
--- 764,770 ----
  
  				default:
              		$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
!                      		LEFT JOIN " . KB_CATEGORIES_TABLE . " AS c ON a.article_category_id = c.category_id
                       		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