[vhffs-dev] [484] Added missing placeholders which caused groups containing only PG or DNS to be considered as empty .

[subversion@xxxxxxxxx]

Revision: 484
Author:   beuss
Date:     2007-02-19 07:46:33 +0000 (Mon, 19 Feb 2007)

Log Message:
-----------
Added missing placeholders which caused groups containing only PG or DNS to be considered as empty.

Modified Paths:
--------------
    branches/vhffs_4.1/vhffs-api/src/Vhffs/Group.pm


Modified: branches/vhffs_4.1/vhffs-api/src/Vhffs/Group.pm
===================================================================
--- branches/vhffs_4.1/vhffs-api/src/Vhffs/Group.pm	2007-02-18 21:56:56 UTC (rev 483)
+++ branches/vhffs_4.1/vhffs-api/src/Vhffs/Group.pm	2007-02-19 07:46:33 UTC (rev 484)
@@ -398,7 +398,7 @@
 
 	if( $config->use_dns == 1 )
 	{
-		$query ='SELECT COUNT(*) FROM vhffs_dns WHERE owner_gid=';
+		$query ='SELECT COUNT(*) FROM vhffs_dns WHERE owner_gid=?';
 	    $request = $self->{'db'}->prepare( $query );
 	    $request->execute( $self->get_gid );
         ($rows) = $request->fetchrow();
@@ -409,7 +409,7 @@
 
 	if( $config->use_postgres == 1 )
 	{
-		$query ='SELECT COUNT(*) FROM vhffs_pgsql WHERE owner_gid=';
+		$query ='SELECT COUNT(*) FROM vhffs_pgsql WHERE owner_gid=?';
 	    $request = $self->{'db'}->prepare( $query );
 	    $request->execute( $self->get_gid );
         ($rows) = $request->fetchrow();