[mxbb-commits] mx_kb/kb/modules kb_search.php,1.7,1.8

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

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

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

Index: kb_search.php
===================================================================
RCS file: /cvsroot/mxbb/mx_kb/kb/modules/kb_search.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** kb_search.php	1 Aug 2006 21:00:38 -0000	1.7
--- kb_search.php	16 May 2007 19:37:44 -0000	1.8
***************
*** 494,498 ****
  					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, COUNT(cm.comments_id) AS total_comments
! 							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
--- 494,498 ----
  					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, COUNT(cm.comments_id) AS total_comments
! 							FROM " . KB_CATEGORIES_TABLE . " AS c, " . KB_ARTICLES_TABLE . " AS a
  								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