[myexperiment-hackers] [1979] trunk/lib/maintenance/GeneratePublicData.php: Additional bug fix to comments sql statement to include group comments

[noreply]

Revision

1979

Author

drn05r

Date

2008-11-17 13:12:15 -0500 (Mon, 17 Nov 2008)

Log Message

Additional bug fix to comments sql statement to include group comments

Modified Paths

• trunk/lib/maintenance/GeneratePublicData.php

Diff

Modified: trunk/lib/maintenance/GeneratePublicData.php (1978 => 1979)

--- trunk/lib/maintenance/GeneratePublicData.php	2008-11-17 17:45:33 UTC (rev 1978)
+++ trunk/lib/maintenance/GeneratePublicData.php	2008-11-17 18:12:15 UTC (rev 1979)
@@ -472,7 +472,7 @@
 	$publicsql['blobs']="select blobs.* from blobs inner join contributions on contributions.contributable_id=blobs.id inner join policies on contributions.policy_id=policies.id where contributable_type='Blob' and policies.view_public=1";
 	$publicsql['bookmarks']="select bookmarks.* from bookmarks inner join contributions on bookmarks.bookmarkable_id=contributions.contributable_id and bookmarks.bookmarkable_type=contributions.contributable_type inner join policies on contributions.policy_id=policies.id where policies.view_public=1";
 	$publicsql['citations']="select citations.* from citations inner join contributions on citations.workflow_id=contributions.contributable_id and contributions.contributable_type='Workflow' inner join policies on contributions.policy_id=policies.id where policies.view_public=1";        
-	$publicsql['comments']="select comments.* from comments inner join contributions on comments.commentable_id=contributions.contributable_id and comments.commentable_type=contributions.contributable_type inner join policies on contributions.policy_id=policies.id where policies.view_public=1 or comments.commentable_type='Network'";
+	$publicsql['comments']="select comments.* from comments left join contributions on comments.commentable_id=contributions.contributable_id and comments.commentable_type=contributions.contributable_type left join policies on contributions.policy_id=policies.id where (policies.view_public=1 or comments.commentable_type='Network') and comments.commentable_type in ('Workflow','Blob','Pack','Network')";
 	$publicsql['contributions']="select contributions.* from contributions inner join policies on contributions.policy_id=policies.id where policies.view_public=1";
         $publicsql['creditations']="select creditations.* from creditations inner join contributions on creditations.creditable_id=contributions.contributable_id and creditations.creditable_type=contributions.contributable_type inner join policies on contributions.policy_id=policies.id where policies.view_public=1";
         $publicsql['downloads']="select downloads.* from downloads inner join contributions on downloads.contribution_id=contributions.id inner join policies on contributions.policy_id=policies.id where policies.view_public=1";