[mxbb-commits] mx_linkdb/linkdb/modules link_search.php,1.13,1.14

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

Update of /cvsroot/mxbb/mx_linkdb/linkdb/modules
In directory sc8-pr-cvs16:/tmp/cvs-serv12400/modules

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

Index: link_search.php
===================================================================
RCS file: /cvsroot/mxbb/mx_linkdb/linkdb/modules/link_search.php,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** link_search.php	13 Aug 2006 19:43:51 -0000	1.13
--- link_search.php	16 May 2007 19:38:07 -0000	1.14
***************
*** 416,420 ****
  					default:
  						$sql = "SELECT f1.*, AVG(r.rate_point) AS rating, COUNT(r.votes_link) AS total_votes, u.user_id, u.username, c.cat_id, c.cat_name
! 							FROM " . LINKS_TABLE . " AS f1, " . LINK_CATEGORIES_TABLE . " AS c
  								LEFT JOIN " . LINK_VOTES_TABLE . " AS r ON f1.link_id = r.votes_link
  								LEFT JOIN " . USERS_TABLE . " AS u ON f1.user_id = u.user_id
--- 416,420 ----
  					default:
  						$sql = "SELECT f1.*, AVG(r.rate_point) AS rating, COUNT(r.votes_link) AS total_votes, u.user_id, u.username, c.cat_id, c.cat_name
! 							FROM " . LINK_CATEGORIES_TABLE . " AS c, " . LINKS_TABLE . " AS f1
  								LEFT JOIN " . LINK_VOTES_TABLE . " AS r ON f1.link_id = r.votes_link
  								LEFT JOIN " . USERS_TABLE . " AS u ON f1.user_id = u.user_id