our %k_re = ( dbi => qr/^(dbi:(Pg|mysql):(?:\w+=[\w\d\.-]+;?)+)$/i,
user => qr/^([\w\d\.-]+)$/i,
password => qr/^(.*)$/i,
- fv_write_path => qr!^([/\w\d\.-]+)$!,
+ fv_write_path => qr!^([/\w\d\.-]*)$!,
template_dir => qr!^([/\w\d\.-]+)$!,
debug => qr/^(on)?$/,
email_media => qr/^([\w\d\.-]+@[\d\w\.-]+)$/,
UPDATE Media
SET LocationId = (SELECT LocationId
FROM Location
- WHERE Location = '$arg->{ach}')
+ WHERE Location = '$arg->{ach}'),
+
+ RecyclePoolId = PoolId
WHERE Media.PoolId = (SELECT PoolId
FROM Pool
WHERE Name = 'Scratch')
- AND LocationId = 0
+ AND (LocationId = 0 OR LocationId IS NULL)
");
}