well it's because of the following, when ya have nudity turned OFF you wont get to see the 'softgood' [i.e. products] in the community page, as in:

SQL Query Error: Column: 'nudity' in where clause is ambiguous

Query was:
SELECT
DISTINCT softgood.softgoodid
FROM
softgood, softgood_category
WHERE
softgood.approved = 'Y'
AND
softgood.visible = 'Y'
AND
softgood.warehouse = 'N'

AND
softgood_category.code LIKE '2DATIL%'
AND
softgood_category.softgoodid = softgood.softgoodid

AND
nudity='N'

GROUP BY softgood.softgoodid
ORDER BY softgood.numdownloads_recent DESC
LIMIT 50

and so you see a black square or a white one, the programmers of this site need to take care of...

uhm... if you open properties of one of the products when nudity turned ON, and you paste it in the addressbar, when having nudity OFF, you are able to see the product in question, only on this page of the community you wont be able to see it, when nudity is turned OFF

hope it's clear for the webmasters ;-)

have a nice weekend also

Harmen

Message edited on: 04/30/2005 14:44