|
From: Jon O. <jon...@us...> - 2007-05-16 19:37:50
|
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 |