Hi
I'm just setting up affiliates and working through all of the pages when I noticed that affiliate_validproducts.php is pulling all products from my database instead of just the one's with an active status.

To fix this, load up affiliate_validproducts.php and go to line 38,
$result = mysql_query("SELECT * FROM products, products_description WHERE products.products_id = products_description.products_id and products_description.language_id = '" . $languages_id . "' ORDER BY products_description.products_name");
and change to:
$result = mysql_query("SELECT * FROM products, products_description WHERE products.products_id = products_description.products_id and products_description.language_id = '" . $languages_id . "' and products_status=1 ORDER BY products_description.products_name");

That will then force the pop up to only show active products.

Cheers

Mark