[Gforge-devel] RE: Porn on GForge.org

[Tim Perdue]

Robert Nelson wrote:
> Actually you probably want to add distinct to the query so it becomes:
> 
>  
> 
> select distinct "http://gforge.org/tracker/index.php?func=detail&aid=" 
> || artifact.artifact_id || "&group_id=" ||  group_id || "&atid=" || 
> agl.group_artifact_id from ((artifact_file inner join artifact on 
> artifact_file.artifact_id = artifact.artifact_id) inner join 
> artifact_group_list AS agl on agl.group_artifact_id = 
> artifact.group_artifact_id) where filetype = "text/html"

We probably just need to require a login in order to download anything. 
That would solve the problem of using it as a public file host.

-- 
Tim Perdue,
http://gforgegroup.com

PH 515-554-9520
FAX 504-910-3655