searchlisting_joins hook request

[cheesegrits]

Can I request a new searchlisting_joins hook in getAllListings(), so ...:

			$select = $modules->call_hook('searchlistings_select', ''); // Call any module functions
			$sSQL = "SELECT p.id, p.owner, p.title, p.featured, p.section, p.shortDescription, p.description, p.price, p.dateadded, p.expiration, p.display, p.pHighlighted, p.pBold, p.hitcount, p.url, u.state, u.city, u.country ". $select ." FROM ".PREFIX."listings AS p LEFT JOIN ".PREFIX."users AS u ON p.owner = u.id ";

... becomes ...

			$select = $modules->call_hook('searchlistings_select', ''); // Call any module functions
			$joins = $modules->call_hook('searchlistings_joins', ''); // Call any module functions
			$sSQL = "SELECT p.id, p.owner, p.title, p.featured, p.section, p.shortDescription, p.description, p.price, p.dateadded, p.expiration, p.display, p.pHighlighted, p.pBold, p.hitcount, p.url, u.state, u.city, u.country ". $select ." FROM ".PREFIX."listings AS p LEFT JOIN ".PREFIX."users AS u ON p.owner = u.id " . $joins . " ";

Or just set $joins = '' before the existing _select hook, and let that add $joins if need be. Either way.

-- hugh

[Eric Barnes +]

Done. If you need any others please let us know.

[cheesegrits]

I guess my next question is, have you given any thought to allowing licensed users to access SVN?

-- hugh