#2 Fix browsing many members by category

[Rik Nilsson]

When browsing OCOC members by category, the category
gets lost due to url encoding on 2nd and subsequent
pages of listings.

___________________________
4. URGENT :: Correct browsing members by category bug
[File: blocks/busdir.php (approx. line 158)]

Find this code:

// Browsing members
if ($browse == "fullmem")
{
$query = "SELECT * FROM $members
WHERE Biz!=''
ORDER BY Biz ASC";
define(ROWS, 10);
if (empty($offset))
$offset = 0;
echo "<p>&nbsp;</p>";
browse($db, $query, $offset, "fullmem", "");
}

and replace with:

// Browsing members
if ($browse == "fullmem")
{
$keywords = html_entity_decode($_GET["key"],
ENT_QUOTES);
$query = "SELECT m.*, c.Id AS cId, c.Category
FROM $members AS m, $categories AS c
WHERE (m.Cat1=c.Id OR m.Cat2=c.Id OR m.Cat3=c.Id)
AND c.Category LIKE '%$keywords%'
AND m.Biz!=''
ORDER BY Status DESC, Biz ASC";
define(ROWS, 10);
if (empty($offset))
$offset = 0;
echo "<p>&nbsp;</p>";
browse($db, $query, $offset, "fullmem", "");
}