{

use esmith::AccountsDB;
my $a = esmith::AccountsDB->open_ro || die "Couldn't open the accounts database";

foreach my $share ($a->get_all_by_prop(type => 'share')){
  my $version             = $share->prop('PHPVersion') || '';
  my $dynamic             = $share->prop('DynamicContent') || 'disabled';
  my $custom              = $share->prop('PHPCustomPool') || undef;
  next unless ($dynamic eq 'enabled' && $version eq $PHP_VERSION && !$custom);
  my $key                 = $share->key;
  my $pool_name           = 'php' . $version . '-' . $key;
  my $memory_limit        = $share->prop('PHPMemoryLimit')       || '128M';
  my $max_execution_time  = $share->prop('PHPMaxExecutionTime')  || '30';
  my $max_input_time      = $share->prop('PHPMaxInputTime')      || '60';
  my $allow_url_fopen     = $share->prop('PHPAllowUrlFopen')     || 'disabled';
  my $post_max_size       = $share->prop('PHPPostMaxSize')       || '10M';
  my $upload_max_filesize = $share->prop('PHPUploadMaxFilesize') || '10M';
  my $file_upload         = $share->prop('PHPFileUpload')        || 'enabled';
  my $open_basedir        = $share->prop('PHPBaseDir')           || '/home/e-smith/files/shares/' . $key .
                                                                    ':/var/lib/php/' . $key;
  my $disabled_functions  = $share->prop('PHPDisabledFunctions') || 'system,show_source,' .
                                                                    'symlink,exec,dl,shell_exec,' .
                                                                    'passthru,phpinfo,' .
                                                                    'escapeshellarg,escapeshellcmd';
  # Format vars
  $file_upload        = ($file_upload =~ m/^1|yes|on|enabled$/) ?     'on' : 'off';
  $allow_url_fopen    = ($allow_url_fopen =~ m/^1|yes|on|enabled$/) ? 'on' : 'off';
  $disabled_functions = join(', ', split /[,;:]/, $disabled_functions);
  $open_basedir       = join(':',  split(/[,;:]/, $open_basedir));

  $OUT .=<<"_EOF" if ($version eq $PHP_VERSION);

[$pool_name]
user = www
group = www
listen.owner = root
listen.group = www
listen.mode = 0660
listen = /var/run/php-fpm/$pool_name.sock
pm = dynamic
pm.max_children = 15
pm.start_servers = 3
pm.min_spare_servers = 3
pm.max_spare_servers = 4
pm.max_requests = 1000
slowlog = /var/log/php/$key/slow.log
php_admin_value[session.save_path] = /var/lib/php/$key/session
php_admin_value[opcache.file_cache]  = /var/lib/php/$key/opcache
php_admin_value[upload_tmp_dir] = /var/lib/php/$key/tmp
php_admin_value[error_log] = /var/log/php/$key/error.log
php_admin_value[sendmail_path] = /usr/sbin/sendmail -t -i -f php@{ $DomainName }
php_admin_flag[display_errors] = off
php_admin_flag[log_errors] = on
php_admin_value[error_log] = syslog
php_admin_value[memory_limit] = $memory_limit
php_admin_value[max_execution_time] = $max_execution_time
php_admin_value[post_max_size] = $post_max_size
php_admin_value[upload_max_filesize] = $upload_max_filesize
php_admin_value[max_input_time] = $max_input_time
php_admin_value[disable_functions] = $disabled_functions
php_admin_flag[allow_url_fopen] = $allow_url_fopen
php_admin_flag[file_upload] = $file_upload
php_admin_flag[session.cookie_httponly] = on
php_admin_flag[allow_url_include] = off
php_admin_value[session.save_handler] = files
php_admin_value[open_basedir] = $open_basedir

_EOF
}

}
