| [vhffs-dev] [1511] Do not forget tag visibility!!! |
[ Thread Index |
Date Index
| More vhffs.org/vhffs-dev Archives
]
Revision: 1511
Author: beuss
Date: 2009-08-04 22:04:25 +0200 (Tue, 04 Aug 2009)
Log Message:
-----------
Do not forget tag visibility!!!
Modified Paths:
--------------
trunk/vhffs-api/src/Vhffs/Panel/Group.pm
Modified: trunk/vhffs-api/src/Vhffs/Panel/Group.pm
===================================================================
--- trunk/vhffs-api/src/Vhffs/Panel/Group.pm 2009-08-04 19:14:15 UTC (rev 1510)
+++ trunk/vhffs-api/src/Vhffs/Panel/Group.pm 2009-08-04 20:04:25 UTC (rev 1511)
@@ -250,13 +250,13 @@
'FROM vhffs_tag t INNER JOIN vhffs_tag_category c ON c.tag_category_id = t.category_id '.
'INNER JOIN vhffs_object_tag ot ON ot.tag_id = t.tag_id '.
'INNER JOIN vhffs_groups g ON g.object_id = ot.object_id '.
- 'WHERE g.gid = ?';
+ 'WHERE g.gid = ? AND c.visibility = ?';
my $tsth = $dbh->prepare($sql);
$sth->execute(@params);
while(my $row = $sth->fetchrow_hashref) {
$usth->execute($row->{gid});
$row->{users} = $usth->fetchall_arrayref({});
- $tsth->execute($row->{gid});
+ $tsth->execute($row->{gid}, Vhffs::Constants::TAG_VISIBILITY_PUBLIC);
$row->{tags} = $tsth->fetchall_arrayref({});
push @groups, $row;
}