myexperiment-hackers
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[myexperiment-hackers] [1975] trunk/lib/maintenance/GeneratePublicData.p


From: noreply
Subject: [myexperiment-hackers] [1975] trunk/lib/maintenance/GeneratePublicData.php: Fixed error in sql statement for comments table
Date: Mon, 17 Nov 2008 10:43:59 -0500 (EST)

Revision
1975
Author
drn05r
Date
2008-11-17 10:43:58 -0500 (Mon, 17 Nov 2008)

Log Message

Fixed error in sql statement for comments table

Modified Paths

Diff

Modified: trunk/lib/maintenance/GeneratePublicData.php (1974 => 1975)


--- trunk/lib/maintenance/GeneratePublicData.php	2008-11-17 13:20:56 UTC (rev 1974)
+++ trunk/lib/maintenance/GeneratePublicData.php	2008-11-17 15:43:58 UTC (rev 1975)
@@ -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";
+	$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['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";

reply via email to

[Prev in Thread] Current Thread [Next in Thread]