X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=dbscripts%2Fpg_imageimport.pl;h=d87e15afadce56b141f7e91761fa68c62343dc6b;hb=7c80d17f1e90ee0072d6c6273e0cb80ebfb41dac;hp=32088e5ea15123769075096d355f7ec0b18e4857;hpb=0f1d06080db7839f70140e6aead274dcabfe8fc3;p=mir.git diff --git a/dbscripts/pg_imageimport.pl b/dbscripts/pg_imageimport.pl index 32088e5e..d87e15af 100755 --- a/dbscripts/pg_imageimport.pl +++ b/dbscripts/pg_imageimport.pl @@ -8,7 +8,7 @@ if (!defined($ARGV[0])) { $dump="$ARGV[0]"; -my $conn = Pg::connectdb("dbname=nadiraktuell user=postgres host=192.168.4.8"); +my $conn = Pg::connectdb("dbname=indy user=indy host=192.168.4.8"); ( PGRES_CONNECTION_OK eq $conn->status ) and print "Pg::connectdb ........... ok\n" or die "Pg::connectdb ........... not ok: ", $conn->errorMessage; @@ -53,7 +53,7 @@ while() { print $conn->errorMessage."\n"; $sql="INSERT INTO images (title,date,place,author,to_img_layout,to_img_type,is_classified,to_media_folder,to_img_color,comment,webdb_create,img_width,img_height,image_data,icon_data) ". "VALUES ('".$titel."','20010109','".$ort. - "','Castor X4','".$layout."','1','0','3','2','".$comment."',now(),'".$img_width."','".$img_height. + "','huh','".$layout."','1','0','3','2','".$comment."',now(),'".$img_width."','".$img_height. "','".$oid."','".$ioid."')"; print $sql."\n"; $conn->exec( $sql );