[mltriebe]

Actually I do seem to be having issues with these 2 lines:

$category_data = func_query_first("SELECT categoryid, lpos, rpos FROM $sql_tbl[categories] USE INDEX (PRIMARY) WHERE categoryid = '$cat'");
if ($category_data)
$result = func_query_hash("SELECT categoryid FROM xcart_categories USE INDEX (pa) WHERE lpos BETWEEN $category_data[lpos] AND $category_data[rpos] AND avail = 'Y'", "categoryid", false, true);

Specifically lpos and rpos do not exist in 4.3.2.

I will keep working at it but any help would be great.

Mike