[vhffs-dev] [svn] commit: r212 - in /trunk: vhffs-api/src/Vhffs/ vhffs-backend/src/pgsql/ vhffs-backend/tools/

[vhffs-dev@xxxxxxxxx]

Author: soda
Date: Fri Aug 11 15:52:19 2006
New Revision: 212

Log:
 * Delete multiple *.sql files from vhffs-backend, make a unique backend file
 * Fix a bug about description (see bug #182)


Added:
    trunk/vhffs-backend/src/pgsql/initdb.sql
Removed:
    trunk/vhffs-backend/src/pgsql/create_acl.sql
    trunk/vhffs-backend/src/pgsql/create_boxes.sql
    trunk/vhffs-backend/src/pgsql/create_confirmation.sql
    trunk/vhffs-backend/src/pgsql/create_cvs.sql
    trunk/vhffs-backend/src/pgsql/create_database.sql
    trunk/vhffs-backend/src/pgsql/create_dns.sql
    trunk/vhffs-backend/src/pgsql/create_forward.sql
    trunk/vhffs-backend/src/pgsql/create_groups.sql
    trunk/vhffs-backend/src/pgsql/create_groups_info.sql
    trunk/vhffs-backend/src/pgsql/create_httpd.sql
    trunk/vhffs-backend/src/pgsql/create_largefile.sql
    trunk/vhffs-backend/src/pgsql/create_mailings.sql
    trunk/vhffs-backend/src/pgsql/create_ml.sql
    trunk/vhffs-backend/src/pgsql/create_mxdomain.sql
    trunk/vhffs-backend/src/pgsql/create_mysql.sql
    trunk/vhffs-backend/src/pgsql/create_notes.sql
    trunk/vhffs-backend/src/pgsql/create_object.sql
    trunk/vhffs-backend/src/pgsql/create_object_history.sql
    trunk/vhffs-backend/src/pgsql/create_panel_prefs.sql
    trunk/vhffs-backend/src/pgsql/create_passwd_view.sql
    trunk/vhffs-backend/src/pgsql/create_postgresql.sql
    trunk/vhffs-backend/src/pgsql/create_shadow_view.sql
    trunk/vhffs-backend/src/pgsql/create_svn.sql
    trunk/vhffs-backend/src/pgsql/create_user.sql
    trunk/vhffs-backend/src/pgsql/create_user_group.sql
    trunk/vhffs-backend/src/pgsql/create_user_info.sql
    trunk/vhffs-backend/tools/
Modified:
    trunk/vhffs-api/src/Vhffs/Object.pm

Modified: trunk/vhffs-api/src/Vhffs/Object.pm
==============================================================================
--- trunk/vhffs-api/src/Vhffs/Object.pm (original)
+++ trunk/vhffs-api/src/Vhffs/Object.pm Fri Aug 11 15:52:19 2006
@@ -214,9 +214,9 @@
 
 	$self->{description} = quotemeta $self->{description};
 
-    $request = "UPDATE vhffs_object SET state='".$self->{'state'}."', description='".$self->{'description'}."', owner_uid='".$self->{'owner_uid'}."' WHERE object_id='".$self->{'object_id'}."'";
+    $request = "UPDATE vhffs_object SET state=?, description=?, owner_uid=? WHERE object_id=?";
     my $result = $self->{'db'}->{'DB_WRITE'}->prepare($request);
-    $result->execute;
+    $result->execute( $self->{'state'} , $self->{'description'} , $self->{'owner_uid'} , $self->{'object_id'} );;
 
 }
 
@@ -300,6 +300,7 @@
 sub set_description
 {
 	my ($self , $value) = @_;
+	$value =~ s/\?/ \?/g;
 	$self->{'description'} = quotemeta( $value );
 }