PHP tpl::setVar方法代码示例

 function update($event_name, $data)
 {
     global $app, $conf;
     // load the server configuration options
     $app->uses("getconf");
     $mail_config = $app->getconf->get_server_config($conf["server_id"], 'mail');
     if (substr($mail_config["homedir_path"], -1) == '/') {
         $mail_config["homedir_path"] = substr($mail_config["homedir_path"], 0, -1);
     }
     if (isset($data["new"]["email"])) {
         $email_parts = explode("@", $data["new"]["email"]);
     } else {
         $email_parts = explode("@", $data["old"]["email"]);
     }
     // Write the custom mailfilter script, if mailfilter recipe has changed
     if ($data["old"]["custom_mailfilter"] != $data["new"]["custom_mailfilter"] or $data["old"]["move_junk"] != $data["new"]["move_junk"] or $data["old"]["autoresponder_text"] != $data["new"]["autoresponder_text"] or $data["old"]["autoresponder"] != $data["new"]["autoresponder"] or isset($data["new"]["email"]) and $data["old"]["email"] != $data["new"]["email"] or $data["old"]["autoresponder_start_date"] != $data["new"]["autoresponder_start_date"] or $data["old"]["autoresponder_end_date"] != $data["new"]["autoresponder_end_date"] or $data["old"]["cc"] != $data["new"]["cc"]) {
         $app->log("Mailfilter config has been changed", LOGLEVEL_DEBUG);
         $sieve_file = $data["new"]["maildir"] . '/.sieve';
         if (is_file($sieve_file)) {
             unlink($sieve_file) or $app->log("Unable to delete file: {$sieve_file}", LOGLEVEL_WARN);
         }
         $app->load('tpl');
         $tpl = new tpl();
         $tpl->newTemplate("sieve_filter.master");
         // cc Field
         $tpl->setVar('cc', $data["new"]["cc"]);
         // Custom filters
         $tpl->setVar('custom_mailfilter', $data["new"]["custom_mailfilter"]);
         // Move junk
         $tpl->setVar('move_junk', $data["new"]["move_junk"]);
         // Set autoresponder start date
         $tpl->setVar('start_date', $data["new"]["autoresponder_start_date"]);
         // Set autoresponder end date
         $tpl->setVar('end_date', $data["new"]["autoresponder_end_date"]);
         // Autoresponder
         $tpl->setVar('autoresponder', $data["new"]["autoresponder"]);
         $data["new"]["autoresponder_text"] = str_replace("\"", "'", $data["new"]["autoresponder_text"]);
         $tpl->setVar('autoresponder_text', $data["new"]["autoresponder_text"]);
         //* Set alias addresses for autoresponder
         $sql = "SELECT * FROM mail_forwarding WHERE type = 'alias' AND destination = '" . $app->db->quote($data["new"]["email"]) . "'";
         $records = $app->db->queryAllRecords($sql);
         $addresses = '';
         if (is_array($records) && count($records) > 0) {
             $addresses .= ':addresses ["' . $data["new"]["email"] . '",';
             foreach ($records as $rec) {
                 $addresses .= '"' . $rec['source'] . '",';
             }
             $addresses = substr($addresses, 0, -1);
             $addresses .= ']';
         }
         $tpl->setVar('addresses', $addresses);
         file_put_contents($sieve_file, $tpl->grab());
         unset($tpl);
     }
 }

 function soa_update($event_name, $data)
 {
     global $app, $conf;
     //* Load libraries
     $app->uses("getconf,tpl");
     //* load the server configuration options
     $dns_config = $app->getconf->get_server_config($conf["server_id"], 'dns');
     //* Write the domain file
     if (!empty($data['new']['id'])) {
         $tpl = new tpl();
         $tpl->newTemplate("bind_pri.domain.master");
         $zone = $data['new'];
         $tpl->setVar($zone);
         $records = $app->db->queryAllRecords("SELECT * FROM dns_rr WHERE zone = " . $zone['id'] . " AND active = 'Y'");
         $tpl->setLoop('zones', $records);
         //TODO : change this when distribution information has been integrated into server record
         if (file_exists('/etc/gentoo-release')) {
             $filename = escapeshellcmd($dns_config['bind_zonefiles_dir'] . '/pri/' . substr($zone['origin'], 0, -1));
         } else {
             $filename = escapeshellcmd($dns_config['bind_zonefiles_dir'] . '/pri.' . substr($zone['origin'], 0, -1));
         }
         $app->log("Writing BIND domain file: " . $filename, LOGLEVEL_DEBUG);
         file_put_contents($filename, $tpl->grab());
         chown($filename, escapeshellcmd($dns_config['bind_user']));
         chgrp($filename, escapeshellcmd($dns_config['bind_group']));
         unset($tpl);
         unset($records);
         unset($records_out);
         unset($zone);
     }
     //* rebuild the named.conf file if the origin has changed or when the origin is inserted.
     //if($this->action == 'insert' || $data['old']['origin'] != $data['new']['origin']) {
     $this->write_named_conf($data, $dns_config);
     //}
     //* Delete old domain file, if domain name has been changed
     if ($data['old']['origin'] != $data['new']['origin']) {
         //TODO : change this when distribution information has been integrated into server record
         if (file_exists('/etc/gentoo-release')) {
             $filename = $dns_config['bind_zonefiles_dir'] . '/pri/' . substr($data['old']['origin'], 0, -1);
         } else {
             $filename = $dns_config['bind_zonefiles_dir'] . '/pri.' . substr($data['old']['origin'], 0, -1);
         }
         if (is_file($filename)) {
             unset($filename);
         }
     }
     //* Reload bind nameserver
     $app->services->restartServiceDelayed('bind', 'reload');
 }

 function show()
 {
     global $app, $conf;
     //* Loading Template
     $app->uses('tpl');
     $tpl = new tpl();
     $tpl->newTemplate("dashlets/templates/modules.htm");
     $wb = array();
     $lng_file = 'lib/lang/' . $_SESSION['s']['language'] . '_dashlet_modules.lng';
     if (is_file($lng_file)) {
         include $lng_file;
     }
     $tpl->setVar($wb);
     /*
      * Show all modules, the user is allowed to use
      */
     $modules = explode(',', $_SESSION['s']['user']['modules']);
     $mod = array();
     if (is_array($modules)) {
         foreach ($modules as $mt) {
             if (is_file('../' . $mt . '/lib/module.conf.php')) {
                 if (!preg_match("/^[a-z]{2,20}\$/i", $mt)) {
                     die('module name contains unallowed chars.');
                 }
                 include_once '../' . $mt . '/lib/module.conf.php';
                 /* We don't want to show the dashboard */
                 if ($mt != 'dashboard') {
                     $module_title = $app->lng($module['title']);
                     if (function_exists('mb_strlen')) {
                         if (mb_strlen($module_title, "UTF-8") > 8) {
                             $module_title = mb_substr($module_title, 0, 7, "UTF-8") . '..';
                         }
                     } else {
                         if (strlen($module_title) > 8) {
                             $module_title = substr($module_title, 0, 7) . '..';
                         }
                     }
                     $mod[] = array('modules_title' => $module_title, 'modules_startpage' => $module['startpage'], 'modules_name' => $module['name']);
                 }
             }
         }
         $tpl->setloop('modules', $mod);
     }
     return $tpl->grab();
 }

//.........这里部分代码省略.........
     if (is_dir($install_dir . '/interface/invoices')) {
         exec('chmod -R 770 ' . escapeshellarg($install_dir . '/interface/invoices'));
         exec('chown -R ispconfig:ispconfig ' . escapeshellarg($install_dir . '/interface/invoices'));
     }
     exec('chown -R root:root /usr/local/ispconfig/interface/ssl');
     // TODO: FIXME: add the www-data user to the ispconfig group. This is just for testing
     // and must be fixed as this will allow the apache user to read the ispconfig files.
     // Later this must run as own apache server or via suexec!
     if ($conf['apache']['installed'] == true) {
         $command = 'adduser ' . $conf['apache']['user'] . ' ispconfig';
         caselog($command . ' &> /dev/null', __FILE__, __LINE__, "EXECUTED: {$command}", "Failed to execute the command {$command}");
         if (is_group('ispapps')) {
             $command = 'adduser ' . $conf['apache']['user'] . ' ispapps';
             caselog($command . ' &> /dev/null', __FILE__, __LINE__, "EXECUTED: {$command}", "Failed to execute the command {$command}");
         }
     }
     if ($conf['nginx']['installed'] == true) {
         $command = 'adduser ' . $conf['nginx']['user'] . ' ispconfig';
         caselog($command . ' &> /dev/null', __FILE__, __LINE__, "EXECUTED: {$command}", "Failed to execute the command {$command}");
         if (is_group('ispapps')) {
             $command = 'adduser ' . $conf['nginx']['user'] . ' ispapps';
             caselog($command . ' &> /dev/null', __FILE__, __LINE__, "EXECUTED: {$command}", "Failed to execute the command {$command}");
         }
     }
     //* Make the shell scripts executable
     $command = "chmod +x {$install_dir}/server/scripts/*.sh";
     caselog($command . ' &> /dev/null', __FILE__, __LINE__, "EXECUTED: {$command}", "Failed to execute the command {$command}");
     if ($conf['apache']['installed'] == true && $this->install_ispconfig_interface == true) {
         //* Copy the ISPConfig vhost for the controlpanel
         $vhost_conf_dir = $conf['apache']['vhost_conf_dir'];
         $vhost_conf_enabled_dir = $conf['apache']['vhost_conf_enabled_dir'];
         // Dont just copy over the virtualhost template but add some custom settings
         $tpl = new tpl('apache_ispconfig.vhost.master');
         $tpl->setVar('vhost_port', $conf['apache']['vhost_port']);
         // comment out the listen directive if port is 80 or 8443
         if ($conf['apache']['vhost_port'] == 80 or $conf['apache']['vhost_port'] == 8443) {
             $tpl->setVar('vhost_port_listen', '#');
         } else {
             $tpl->setVar('vhost_port_listen', '');
         }
         if (is_file($install_dir . '/interface/ssl/ispserver.crt') && is_file($install_dir . '/interface/ssl/ispserver.key')) {
             $tpl->setVar('ssl_comment', '');
         } else {
             $tpl->setVar('ssl_comment', '#');
         }
         if (is_file($install_dir . '/interface/ssl/ispserver.crt') && is_file($install_dir . '/interface/ssl/ispserver.key') && is_file($install_dir . '/interface/ssl/ispserver.bundle')) {
             $tpl->setVar('ssl_bundle_comment', '');
         } else {
             $tpl->setVar('ssl_bundle_comment', '#');
         }
         $tpl->setVar('apache_version', getapacheversion());
         wf($vhost_conf_dir . '/ispconfig.vhost', $tpl->grab());
         //* and create the symlink
         if ($this->is_update == false) {
             if (@is_link($vhost_conf_enabled_dir . '/ispconfig.vhost')) {
                 unlink($vhost_conf_enabled_dir . '/ispconfig.vhost');
             }
             if (!@is_link($vhost_conf_enabled_dir . '/000-ispconfig.vhost')) {
                 symlink($vhost_conf_dir . '/ispconfig.vhost', $vhost_conf_enabled_dir . '/000-ispconfig.vhost');
             }
         }
         //if(!is_file('/home/www/php-fcgi-scripts/ispconfig/.php-fcgi-starter')) {
         $content = rfsel($conf['ispconfig_install_dir'] . '/server/conf-custom/install/apache_ispconfig_fcgi_starter.master', 'tpl/apache_ispconfig_fcgi_starter.master');
         $content = str_replace('{fastcgi_bin}', $conf['fastcgi']['fastcgi_bin'], $content);
         $content = str_replace('{fastcgi_phpini_path}', $conf['fastcgi']['fastcgi_phpini_path'], $content);
         @mkdir('/home/www/php-fcgi-scripts/ispconfig', 0755, true);

 function show()
 {
     global $app, $conf;
     $limits = array();
     /* Limits to be shown*/
     $limits[] = array('field' => 'limit_maildomain', 'db_table' => 'mail_domain', 'db_where' => '');
     $limits[] = array('field' => 'limit_mailmailinglist', 'db_table' => 'mail_mailinglist', 'db_where' => '');
     $limits[] = array('field' => 'limit_mailbox', 'db_table' => 'mail_user', 'db_where' => '');
     $limits[] = array('field' => 'limit_mailalias', 'db_table' => 'mail_forwarding', 'db_where' => "type = 'alias'");
     $limits[] = array('field' => 'limit_mailaliasdomain', 'db_table' => 'mail_forwarding', 'db_where' => "type = 'aliasdomain'");
     $limits[] = array('field' => 'limit_mailforward', 'db_table' => 'mail_forwarding', 'db_where' => "type = 'forward'");
     $limits[] = array('field' => 'limit_mailcatchall', 'db_table' => 'mail_forwarding', 'db_where' => "type = 'catchall'");
     $limits[] = array('field' => 'limit_mailrouting', 'db_table' => 'mail_transport', 'db_where' => "");
     $limits[] = array('field' => 'limit_mailfilter', 'db_table' => 'mail_user_filter', 'db_where' => "");
     $limits[] = array('field' => 'limit_fetchmail', 'db_table' => 'mail_get', 'db_where' => "");
     $limits[] = array('field' => 'limit_spamfilter_wblist', 'db_table' => 'spamfilter_wblist', 'db_where' => "");
     $limits[] = array('field' => 'limit_spamfilter_user', 'db_table' => 'spamfilter_users', 'db_where' => "");
     $limits[] = array('field' => 'limit_spamfilter_policy', 'db_table' => 'spamfilter_policy', 'db_where' => "");
     $limits[] = array('field' => 'limit_web_domain', 'db_table' => 'web_domain', 'db_where' => "type = 'vhost'");
     $limits[] = array('field' => 'limit_web_subdomain', 'db_table' => 'web_domain', 'db_where' => "(type = 'subdomain' OR type = 'vhostsubdomain')");
     $limits[] = array('field' => 'limit_web_aliasdomain', 'db_table' => 'web_domain', 'db_where' => "type = 'alias'");
     $limits[] = array('field' => 'limit_ftp_user', 'db_table' => 'ftp_user', 'db_where' => "");
     $limits[] = array('field' => 'limit_shell_user', 'db_table' => 'shell_user', 'db_where' => "");
     $limits[] = array('field' => 'limit_dns_zone', 'db_table' => 'dns_soa', 'db_where' => "");
     $limits[] = array('field' => 'limit_dns_slave_zone', 'db_table' => 'dns_slave', 'db_where' => "");
     $limits[] = array('field' => 'limit_dns_record', 'db_table' => 'dns_rr', 'db_where' => "");
     $limits[] = array('field' => 'limit_database', 'db_table' => 'web_database', 'db_where' => "");
     $limits[] = array('field' => 'limit_cron', 'db_table' => 'cron', 'db_where' => "");
     $limits[] = array('field' => 'limit_client', 'db_table' => 'client', 'db_where' => "");
     //* Loading Template
     $app->uses('tpl,tform');
     $tpl = new tpl();
     $tpl->newTemplate("dashlets/templates/limits.htm");
     $wb = array();
     $lng_file = 'lib/lang/' . $_SESSION['s']['language'] . '_dashlet_limits.lng';
     if (is_file($lng_file)) {
         include $lng_file;
     }
     $tpl->setVar($wb);
     if ($app->auth->is_admin()) {
         $user_is_admin = true;
     } else {
         $user_is_admin = false;
     }
     $tpl->setVar('is_admin', $user_is_admin);
     if ($user_is_admin == false) {
         $client_group_id = $_SESSION["s"]["user"]["default_group"];
         $client = $app->db->queryOneRecord("SELECT * FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = {$client_group_id}");
     }
     $rows = array();
     foreach ($limits as $limit) {
         $field = $limit['field'];
         if ($user_is_admin) {
             $value = $wb['unlimited_txt'];
         } else {
             $value = $client[$field];
         }
         if ($value != 0 || $value == $wb['unlimited_txt']) {
             $value_formatted = $value == '-1' ? $wb['unlimited_txt'] : $value;
             $rows[] = array('field' => $field, 'field_txt' => $wb[$field . '_txt'], 'value' => $value_formatted, 'usage' => $this->_get_limit_usage($limit));
         }
     }
     $tpl->setLoop('rows', $rows);
     return $tpl->grab();
 }

 function update($event_name, $data)
 {
     global $app, $conf;
     /*
      * If $action is not 'insert', let's set it to update
      */
     if ($this->action != 'insert') {
         $this->action = 'update';
     }
     /*
      * load the server configuration options
      */
     $app->uses('getconf');
     $web_config = $app->getconf->get_server_config($conf['server_id'], 'web');
     /*
      * We load the global template engine
      */
     $app->load('tpl');
     /*
      * Create a new template and choose which master template to take
      * the file is located within /usr/local/ispconfig/server/conf/
      */
     $tpl = new tpl();
     $tpl->newTemplate('apache2_userdir_plugin.conf.master');
     /*
      * Write some values from the array to single variables
      */
     $vhost_data = $data['new'];
     /*
      * To have a better overview we split our update function into several parts,
      * for sites, aliases and subdomains
      * -> vhost
      */
     if ($data['new']['type'] == 'vhost') {
         /*
          * We have collected all data in the $vhost_data array
          * so we can pass it to the template engine
          */
         $tpl->setVar($vhost_data);
         /*
          * if this is an 'insert', we have to create the vhost file
          */
         if ($this->action == 'insert') {
             $this->vhost('insert', $data, $tpl->grab());
         }
         /*
          * if this is an 'update', we have to update the vhost file
          */
         if ($this->action == 'update') {
             $vhost_backup = $this->vhost('update', $data, $tpl->grab());
         }
     }
     /*
      * reload the apache2 webserver to apply changes
      */
     $app->services->restartServiceDelayed('httpd', 'reload');
     /*
      * everything went hopefully well, so we can now
      * delete the vhosts backup
      */
     if (isset($vhost_backup)) {
         unlink($vhost_backup['file_new'] . '~');
     }
     unset($vhost_backup);
     /*
      * Unset 'action' to clean it for next processed vhost
      */
     $this->action = '';
 }

 function update($event_name, $data)
 {
     global $app, $conf;
     // load the server configuration options
     $app->uses("getconf");
     $mail_config = $app->getconf->get_server_config($conf["server_id"], 'mail');
     if (substr($mail_config["homedir_path"], -1) == '/') {
         $mail_config["homedir_path"] = substr($mail_config["homedir_path"], 0, -1);
     }
     if (isset($data["new"]["email"])) {
         $email_parts = explode("@", $data["new"]["email"]);
     } else {
         $email_parts = explode("@", $data["old"]["email"]);
     }
     // Write the custom mailfilter script, if mailfilter recipe has changed
     if ($data["old"]["custom_mailfilter"] != $data["new"]["custom_mailfilter"] or $data["old"]["move_junk"] != $data["new"]["move_junk"] or $data["old"]["autoresponder_subject"] != $data["new"]["autoresponder_subject"] or $data["old"]["autoresponder_text"] != $data["new"]["autoresponder_text"] or $data["old"]["autoresponder"] != $data["new"]["autoresponder"] or isset($data["new"]["email"]) and $data["old"]["email"] != $data["new"]["email"] or $data["old"]["autoresponder_start_date"] != $data["new"]["autoresponder_start_date"] or $data["old"]["autoresponder_end_date"] != $data["new"]["autoresponder_end_date"] or $data["old"]["cc"] != $data["new"]["cc"]) {
         $app->log("Mailfilter config has been changed", LOGLEVEL_DEBUG);
         $sieve_file = $data["new"]["maildir"] . '/.sieve';
         if (is_file($sieve_file)) {
             unlink($sieve_file) or $app->log("Unable to delete file: {$sieve_file}", LOGLEVEL_WARN);
         }
         $app->load('tpl');
         //* Select sieve filter file for dovecot version
         exec('dovecot --version', $tmp);
         if (substr($tmp[0], 0, 3) == '1.0') {
             $filter_file_template = "sieve_filter.master";
         } elseif (substr($tmp[0], 0, 3) == '1.2') {
             $filter_file_template = "sieve_filter_1.2.master";
         } elseif (substr($tmp[0], 0, 1) == '2') {
             $filter_file_template = "sieve_filter_1.2.master";
         } else {
             $filter_file_template = "sieve_filter.master";
         }
         unset($tmp);
         //* Create new filter file based on template
         $tpl = new tpl();
         $tpl->newTemplate($filter_file_template);
         // cc Field
         $tmp_mails_arr = explode(',', $data["new"]["cc"]);
         $tmp_addresses_arr = array();
         foreach ($tmp_mails_arr as $address) {
             if (trim($address) != '') {
                 $tmp_addresses_arr[] = array('address' => trim($address));
             }
         }
         $tpl->setVar('cc', $data["new"]["cc"]);
         $tpl->setLoop('ccloop', $tmp_addresses_arr);
         // Custom filters
         if ($data["new"]["custom_mailfilter"] == 'NULL') {
             $data["new"]["custom_mailfilter"] = '';
         }
         $tpl->setVar('custom_mailfilter', $data["new"]["custom_mailfilter"]);
         // Move junk
         $tpl->setVar('move_junk', $data["new"]["move_junk"]);
         // Check autoresponder dates
         if ($data["new"]["autoresponder_start_date"] == '0000-00-00 00:00:00' && $data["new"]["autoresponder_end_date"] == '0000-00-00 00:00:00') {
             $tpl->setVar('autoresponder_date_limit', 0);
         } else {
             $tpl->setVar('autoresponder_date_limit', 1);
         }
         // Set autoresponder start date
         $data["new"]["autoresponder_start_date"] = str_replace(" ", "T", $data["new"]["autoresponder_start_date"]);
         $tpl->setVar('start_date', $data["new"]["autoresponder_start_date"]);
         // Set autoresponder end date
         $data["new"]["autoresponder_end_date"] = str_replace(" ", "T", $data["new"]["autoresponder_end_date"]);
         $tpl->setVar('end_date', $data["new"]["autoresponder_end_date"]);
         // Autoresponder
         $tpl->setVar('autoresponder', $data["new"]["autoresponder"]);
         // Autoresponder Subject
         $data["new"]["autoresponder_subject"] = str_replace("\"", "'", $data["new"]["autoresponder_subject"]);
         $tpl->setVar('autoresponder_subject', $data["new"]["autoresponder_subject"]);
         // Autoresponder Text
         $data["new"]["autoresponder_text"] = str_replace("\"", "'", $data["new"]["autoresponder_text"]);
         $tpl->setVar('autoresponder_text', $data["new"]["autoresponder_text"]);
         //* Set alias addresses for autoresponder
         $sql = "SELECT * FROM mail_forwarding WHERE type = 'alias' AND destination = '" . $app->db->quote($data["new"]["email"]) . "'";
         $records = $app->db->queryAllRecords($sql);
         $addresses = array();
         $addresses[] = $data["new"]["email"];
         if (is_array($records) && count($records) > 0) {
             foreach ($records as $rec) {
                 $addresses[] = $rec['source'];
             }
         }
         $app->log("Found " . count($addresses) . " addresses.", LOGLEVEL_DEBUG);
         $alias_addresses = array();
         $email_parts = explode('@', $data["new"]["email"]);
         $sql = "SELECT * FROM mail_forwarding WHERE type = 'aliasdomain' AND destination = '@" . $app->db->quote($email_parts[1]) . "'";
         $records = $app->db->queryAllRecords($sql);
         if (is_array($records) && count($records) > 0) {
             $app->log("Found " . count($records) . " records (aliasdomains).", LOGLEVEL_DEBUG);
             foreach ($records as $rec) {
                 $aliasdomain = substr($rec['source'], 1);
                 foreach ($addresses as $email) {
                     $email_parts = explode('@', $email);
                     $alias_addresses[] = $email_parts[0] . '@' . $aliasdomain;
                 }
             }
         }
         $app->log("Found " . count($addresses) . " addresses at all.", LOGLEVEL_DEBUG);
//.........这里部分代码省略.........

 function onShow()
 {
     global $app;
     $listTpl = new tpl();
     $listTpl->newTemplate('templates/web_backup_list.htm');
     //* Loading language file
     $lng_file = "lib/lang/" . $_SESSION["s"]["language"] . "_web_backup_list.lng";
     include $lng_file;
     $listTpl->setVar($wb);
     $message = '';
     $error = '';
     if (isset($_GET['backup_action'])) {
         $backup_id = $app->functions->intval($_GET['backup_id']);
         //* check if the user is  owner of the parent domain
         $domain_backup = $app->db->queryOneRecord("SELECT parent_domain_id FROM web_backup WHERE backup_id = " . $backup_id);
         $check_perm = 'u';
         if ($_GET['backup_action'] == 'download') {
             $check_perm = 'r';
         }
         // only check read permissions on download, not update permissions
         $get_domain = $app->db->queryOneRecord("SELECT domain_id FROM web_domain WHERE domain_id = " . $app->functions->intval($domain_backup["parent_domain_id"]) . " AND " . $app->tform->getAuthSQL($check_perm));
         if (empty($get_domain) || !$get_domain) {
             $app->error($app->tform->lng('no_domain_perm'));
         }
         if ($_GET['backup_action'] == 'download' && $backup_id > 0) {
             $server_id = $this->form->dataRecord['server_id'];
             $backup = $app->db->queryOneRecord("SELECT * FROM web_backup WHERE backup_id = " . $backup_id);
             if ($backup['server_id'] > 0) {
                 $server_id = $backup['server_id'];
             }
             $sql = "SELECT count(action_id) as number FROM sys_remoteaction WHERE action_state = 'pending' AND action_type = 'backup_download' AND action_param = '{$backup_id}'";
             $tmp = $app->db->queryOneRecord($sql);
             if ($tmp['number'] == 0) {
                 $message .= $wb['download_info_txt'];
                 $sql = "INSERT INTO sys_remoteaction (server_id, tstamp, action_type, action_param, action_state, response) " . "VALUES (" . (int) $server_id . ", " . time() . ", " . "'backup_download', " . "'" . $backup_id . "', " . "'pending', " . "''" . ")";
                 $app->db->query($sql);
             } else {
                 $error .= $wb['download_pending_txt'];
             }
         }
         if ($_GET['backup_action'] == 'restore' && $backup_id > 0) {
             $server_id = $this->form->dataRecord['server_id'];
             $backup = $app->db->queryOneRecord("SELECT * FROM web_backup WHERE backup_id = " . $backup_id);
             if ($backup['server_id'] > 0) {
                 $server_id = $backup['server_id'];
             }
             $sql = "SELECT count(action_id) as number FROM sys_remoteaction WHERE action_state = 'pending' AND action_type = 'backup_restore' AND action_param = '{$backup_id}'";
             $tmp = $app->db->queryOneRecord($sql);
             if ($tmp['number'] == 0) {
                 $message .= $wb['restore_info_txt'];
                 $sql = "INSERT INTO sys_remoteaction (server_id, tstamp, action_type, action_param, action_state, response) " . "VALUES (" . (int) $server_id . ", " . time() . ", " . "'backup_restore', " . "'" . $backup_id . "', " . "'pending', " . "''" . ")";
                 $app->db->query($sql);
             } else {
                 $error .= $wb['restore_pending_txt'];
             }
         }
     }
     //* Get the data
     $server_ids = array();
     $web = $app->db->queryOneRecord("SELECT server_id FROM web_domain WHERE domain_id = " . $app->functions->intval($this->form->id));
     $databases = $app->db->queryAllRecords("SELECT server_id FROM web_database WHERE parent_domain_id = " . $app->functions->intval($this->form->id));
     if ($app->functions->intval($web['server_id']) > 0) {
         $server_ids[] = $app->functions->intval($web['server_id']);
     }
     if (is_array($databases) && !empty($databases)) {
         foreach ($databases as $database) {
             if ($app->functions->intval($database['server_id']) > 0) {
                 $server_ids[] = $app->functions->intval($database['server_id']);
             }
         }
     }
     $server_ids = array_unique($server_ids);
     $sql = "SELECT * FROM web_backup WHERE parent_domain_id = " . $app->functions->intval($this->form->id) . " AND server_id IN (" . implode(',', $server_ids) . ") ORDER BY tstamp DESC, backup_type ASC";
     $records = $app->db->queryAllRecords($sql);
     $bgcolor = "#FFFFFF";
     if (is_array($records)) {
         foreach ($records as $rec) {
             // Change of color
             $bgcolor = $bgcolor == "#FFFFFF" ? "#EEEEEE" : "#FFFFFF";
             $rec["bgcolor"] = $bgcolor;
             $rec['date'] = date($app->lng('conf_format_datetime'), $rec['tstamp']);
             $rec['backup_type'] = $wb['backup_type_' . $rec['backup_type']];
             $rec['download_available'] = true;
             if ($rec['server_id'] != $web['server_id']) {
                 $rec['download_available'] = false;
             }
             $records_new[] = $rec;
         }
     }
     $listTpl->setLoop('records', @$records_new);
     $listTpl->setVar('parent_id', $this->form->id);
     $listTpl->setVar('msg', $message);
     $listTpl->setVar('error', $error);
     // Setting Returnto information in the session
     $list_name = 'backup_list';
     // $_SESSION["s"]["list"][$list_name]["parent_id"] = $app->tform_actions->id;
     $_SESSION["s"]["list"][$list_name]["parent_id"] = $this->form->id;
     $_SESSION["s"]["list"][$list_name]["parent_name"] = $app->tform->formDef["name"];
     $_SESSION["s"]["list"][$list_name]["parent_tab"] = $_SESSION["s"]["form"]["tab"];
     $_SESSION["s"]["list"][$list_name]["parent_script"] = $app->tform->formDef["action"];
//.........这里部分代码省略.........

 function show()
 {
     global $app, $conf;
     //* Loading Template
     $app->uses('tpl');
     $tpl = new tpl();
     $tpl->newTemplate("dashlets/templates/quota.htm");
     $wb = array();
     $lng_file = 'lib/lang/' . $_SESSION['s']['language'] . '_dashlet_quota.lng';
     if (is_file($lng_file)) {
         include $lng_file;
     }
     $tpl->setVar($wb);
     $tmp_rec = $app->db->queryAllRecords("SELECT data from monitor_data WHERE type = 'harddisk_quota' ORDER BY created DESC");
     $monitor_data = array();
     if (is_array($tmp_rec)) {
         foreach ($tmp_rec as $tmp_mon) {
             $monitor_data = array_merge_recursive($monitor_data, unserialize($app->db->unquote($tmp_mon['data'])));
         }
     }
     //print_r($monitor_data);
     if ($_SESSION["s"]["user"]["typ"] != 'admin') {
         $sql_where = " AND sys_groupid = " . $app->functions->intval($_SESSION['s']['user']['default_group']);
     }
     $has_quota = false;
     // select websites belonging to client
     $sites = $app->db->queryAllRecords("SELECT * FROM web_domain WHERE active = 'y' AND type = 'vhost'" . $sql_where);
     //print_r($sites);
     if (is_array($sites) && !empty($sites)) {
         for ($i = 0; $i < sizeof($sites); $i++) {
             $username = $sites[$i]['system_user'];
             $sites[$i]['used'] = $monitor_data['user'][$username]['used'];
             $sites[$i]['soft'] = $monitor_data['user'][$username]['soft'];
             $sites[$i]['hard'] = $monitor_data['user'][$username]['hard'];
             $sites[$i]['files'] = $monitor_data['user'][$username]['files'];
             if (!is_numeric($sites[$i]['used'])) {
                 if ($sites[$i]['used'][0] > $sites[$i]['used'][1]) {
                     $sites[$i]['used'] = $sites[$i]['used'][0];
                 } else {
                     $sites[$i]['used'] = $sites[$i]['used'][1];
                 }
             }
             if (!is_numeric($sites[$i]['soft'])) {
                 $sites[$i]['soft'] = $sites[$i]['soft'][1];
             }
             if (!is_numeric($sites[$i]['hard'])) {
                 $sites[$i]['hard'] = $sites[$i]['hard'][1];
             }
             if (!is_numeric($sites[$i]['files'])) {
                 $sites[$i]['files'] = $sites[$i]['files'][1];
             }
             // colours
             $sites[$i]['display_colour'] = '#000000';
             if ($sites[$i]['soft'] > 0) {
                 $used_ratio = $sites[$i]['used'] / $sites[$i]['soft'];
             } else {
                 $used_ratio = 0;
             }
             if ($used_ratio >= 0.8) {
                 $sites[$i]['display_colour'] = '#fd934f';
             }
             if ($used_ratio >= 1) {
                 $sites[$i]['display_colour'] = '#cc0000';
             }
             if ($sites[$i]['used'] > 1024) {
                 $sites[$i]['used'] = round($sites[$i]['used'] / 1024, 2) . ' MB';
             } else {
                 if ($sites[$i]['used'] != '') {
                     $sites[$i]['used'] .= ' KB';
                 }
             }
             if ($sites[$i]['soft'] > 1024) {
                 $sites[$i]['soft'] = round($sites[$i]['soft'] / 1024, 2) . ' MB';
             } else {
                 $sites[$i]['soft'] .= ' KB';
             }
             if ($sites[$i]['hard'] > 1024) {
                 $sites[$i]['hard'] = round($sites[$i]['hard'] / 1024, 2) . ' MB';
             } else {
                 $sites[$i]['hard'] .= ' KB';
             }
             if ($sites[$i]['soft'] == " KB") {
                 $sites[$i]['soft'] = $app->lng('unlimited');
             }
             if ($sites[$i]['hard'] == " KB") {
                 $sites[$i]['hard'] = $app->lng('unlimited');
             }
             /*
             if(!strstr($sites[$i]['used'],'M') && !strstr($sites[$i]['used'],'K')) $sites[$i]['used'].= ' B';
             if(!strstr($sites[$i]['soft'],'M') && !strstr($sites[$i]['soft'],'K')) $sites[$i]['soft'].= ' B';
             if(!strstr($sites[$i]['hard'],'M') && !strstr($sites[$i]['hard'],'K')) $sites[$i]['hard'].= ' B';
             */
             if ($sites[$i]['soft'] == '0 B' || $sites[$i]['soft'] == '0 KB' || $sites[$i]['soft'] == '0') {
                 $sites[$i]['soft'] = $app->lng('unlimited');
             }
             if ($sites[$i]['hard'] == '0 B' || $sites[$i]['hard'] == '0 KB' || $sites[$i]['hard'] == '0') {
                 $sites[$i]['hard'] = $app->lng('unlimited');
             }
         }
         $has_quota = true;
//.........这里部分代码省略.........

 /**
  * ISPConfig update hook.
  *
  * Called every time a site gets updated from within ISPConfig.
  *
  * @see insert()
  * @see delete()
  *
  * @param string $event_name the event/action name
  * @param array  $data       the vhost data
  */
 function update($event_name, $data)
 {
     global $app, $conf;
     //* $VAR: command to run after vhost insert/update/delete
     $final_command = '/etc/init.d/nginx reload';
     if ($this->action != 'insert') {
         $this->action = 'update';
     }
     $app->uses('getconf');
     $app->uses('system');
     $web_config = $app->getconf->get_server_config($conf['server_id'], 'web');
     $app->load('tpl');
     $tpl = new tpl();
     $tpl->newTemplate('nginx_reverse_proxy_plugin.vhost.conf.master');
     $web_folder = 'web';
     if ($data['new']['type'] == 'vhostsubdomain') {
         $tmp = $app->db->queryOneRecord('SELECT `domain` FROM web_domain WHERE domain_id = ' . intval($data['new']['parent_domain_id']));
         $subdomain_host = preg_replace('/^(.*)\\.' . preg_quote($tmp['domain'], '/') . '$/', '$1', $data['new']['domain']);
         if ($subdomain_host == '') {
             $subdomain_host = 'web' . $data['new']['domain_id'];
         }
         $web_folder = $data['new']['web_folder'];
         unset($tmp);
     }
     $vhost_data = $data['new'];
     $vhost_data['web_document_root'] = $data['new']['document_root'] . '/' . $web_folder;
     $vhost_data['web_document_root_www'] = $web_config['website_basedir'] . '/' . $data['new']['domain'] . '/' . $web_folder;
     $vhost_data['web_basedir'] = $web_config['website_basedir'];
     $vhost_data['ssl_domain'] = $data['new']['ssl_domain'];
     /* __ VHOST & VHOSTSUBDOMAIN - section for vhosts and vhostsubdomains //////////////*/
     if ($data['new']['type'] == 'vhost' || $data['new']['type'] == 'vhostsubdomain') {
         if ($data['new']['ipv6_address'] != '') {
             $tpl->setVar('ipv6_enabled', 1);
         }
         $server_alias = array();
         switch ($data['new']['subdomain']) {
             case 'www':
                 // if seo-redirect is enabled, this should be placed in separate server block
                 // to prevent if statement in server/request!
                 $server_alias[] .= 'www.' . $data['new']['domain'] . ' ';
                 break;
             case '*':
                 $server_alias[] .= '*.' . $data['new']['domain'] . ' ';
                 break;
         }
         $alias_result = array();
         $alias_result = $app->dbmaster->queryAllRecords('SELECT * FROM web_domain WHERE parent_domain_id = ' . $data['new']['domain_id'] . " AND active = 'y' AND type != 'vhostsubdomain'");
         if (count($alias_result) > 0) {
             // if alias is redirect type, put in server block with seo-redirect to prevent
             // if statement in server/request!
             foreach ($alias_result as $alias) {
                 switch ($alias['subdomain']) {
                     case 'www':
                         $server_alias[] .= 'www.' . $alias['domain'] . ' ' . $alias['domain'] . ' ';
                         break;
                     case '*':
                         $server_alias[] .= '*.' . $alias['domain'] . ' ' . $alias['domain'] . ' ';
                         break;
                     default:
                         $server_alias[] .= $alias['domain'] . ' ';
                 }
                 $app->log('Add server alias: ' . $alias['domain'], LOGLEVEL_DEBUG);
             }
             unset($alias);
         }
         if (count($server_alias) > 0) {
             $server_alias_str = '';
             foreach ($server_alias as $tmp_alias) {
                 $server_alias_str .= $tmp_alias;
             }
             unset($tmp_alias);
             $tpl->setVar('alias', $server_alias_str);
         } else {
             $tpl->setVar('alias', '');
         }
         if (!isset($rewrite_rules)) {
             $rewrite_rules = array();
         }
         if ($data['new']['redirect_type'] != '' && $data['new']['redirect_path'] != '') {
             if (substr($data['new']['redirect_path'], -1) != '/') {
                 $data['new']['redirect_path'] .= '/';
             }
             if (substr($data['new']['redirect_path'], 0, 8) == '[scheme]') {
                 $rewrite_target = 'http' . substr($data['new']['redirect_path'], 8);
                 $rewrite_target_ssl = 'https' . substr($data['new']['redirect_path'], 8);
             } else {
                 $rewrite_target = $data['new']['redirect_path'];
                 $rewrite_target_ssl = $data['new']['redirect_path'];
             }
//.........这里部分代码省略.........

 function update($event_name, $data)
 {
     global $app, $conf;
     // get the config
     $app->uses('getconf');
     $server_config = $app->getconf->get_server_config($conf['server_id'], 'server');
     //* Configure the debian network card settings.
     //* Dont configure
     if ($server_config['auto_network_configuration'] == 'y' && $data['mirrored'] == false && $server_config['ip_address'] != '0.0.0.0' && $server_config['gateway'] != '0.0.0.0') {
         if (is_file('/etc/debian_version')) {
             copy('/etc/network/interfaces', '/etc/network/interfaces~');
             $app->load('tpl');
             $network_tpl = new tpl();
             $network_tpl->newTemplate('debian_network_interfaces.master');
             $network_tpl->setVar('ip_address', $server_config['ip_address']);
             $network_tpl->setVar('netmask', $server_config['netmask']);
             $network_tpl->setVar('gateway', $server_config['gateway']);
             $network_tpl->setVar('broadcast', $this->broadcast($server_config['ip_address'], $server_config['netmask']));
             $network_tpl->setVar('network', $this->network($server_config['ip_address'], $server_config['netmask']));
             $records = $app->db->queryAllRecords("SELECT ip_address FROM server_ip WHERE server_id = " . intval($conf['server_id']) . ' ORDER BY server_ip_id ASC');
             $ip_records = array();
             $additionl_ip_records = 0;
             $n = 0;
             if (is_array($records)) {
                 foreach ($records as $rec) {
                     /*
                      * don't insert the main-ip again!
                      */
                     if ($rec['ip_address'] != $server_config['ip_address']) {
                         $ip_records[$n] = array('id' => $n, 'ip_address' => $rec['ip_address'], 'netmask' => $server_config['netmask'], 'gateway' => $server_config['gateway'], 'broadcast' => $this->broadcast($rec['ip_address'], $server_config['netmask']), 'network' => $this->network($rec['ip_address'], $server_config['netmask']));
                         $additionl_ip_records = 1;
                         $n++;
                     }
                 }
             }
             /*
              * If we have more than 1 IP we have to add the main-ip at the end
              * of the network-ip-list. If we don't do so, there may be problems
              * in multi-server-settings (with the acces from other server to the
              * main-server) because the LAST IP in the list is the IP mysql uses
              * to determine the host, the user is logging in from.
              */
             /*
             // Disabled this part as it causes problems on multiserver setups
             if ($additionl_ip_records != 0)
             {
             	$swap['ip_address'] = $ip_records[$n-1]['ip_address'];
             	$swap['netmask'] = $ip_records[$n-1]['netmask'];
             	$swap['gateway'] = $ip_records[$n-1]['gateway'];
             
             	$ip_records[$n-1] = array(
             		'id' => $n-1,
             		'ip_address' => $server_config['ip_address'],
             		'netmask' => $server_config['netmask'],
             		'gateway' => $server_config['gateway'],
             		'broadcast' => $this->broadcast($server_config['ip_address'],$server_config['netmask']),
             		'network' => $this->network($server_config['ip_address'],$server_config['netmask'])
             	);
             	$network_tpl->setVar('ip_address',$swap['ip_address']);
             	$network_tpl->setVar('netmask',$swap['netmask']);
             	$network_tpl->setVar('gateway',$swap['gateway']);
             	$network_tpl->setVar('broadcast',$this->broadcast($swap['ip_address'],$swap['netmask']));
             	$network_tpl->setVar('network',$this->network($swap['ip_address'],$swap['netmask']));
             }
             */
             $network_tpl->setVar('additionl_ip_records', $additionl_ip_records);
             $network_tpl->setLoop('interfaces', $ip_records);
             file_put_contents('/etc/network/interfaces', $network_tpl->grab());
             unset($network_tpl);
             $app->log('Changed Network settings', LOGLEVEL_DEBUG);
             exec($conf['init_scripts'] . '/' . 'networking force-reload');
         } elseif (is_file('/etc/gentoo-release')) {
             copy('/etc/conf.d/net', '/etc/conf.d/net~');
             $app->load('tpl');
             $network_tpl = new tpl();
             $network_tpl->newTemplate('gentoo_network_interfaces.master');
             $network_tpl->setVar('ip_address', $server_config['ip_address']);
             $network_tpl->setVar('netmask', $server_config['netmask']);
             $network_tpl->setVar('gateway', $server_config['gateway']);
             $network_tpl->setVar('broadcast', $this->broadcast($server_config['ip_address'], $server_config['netmask']));
             $records = $app->db->queryAllRecords("SELECT ip_address FROM server_ip WHERE server_id = " . intval($conf['server_id']) . " order by ip_address");
             $ip_records = array();
             $additionl_ip_records = 0;
             $n = 0;
             if (is_array($records)) {
                 foreach ($records as $rec) {
                     /*
                      * don't insert the main-ip again!
                      */
                     if ($rec['ip_address'] != $server_config['ip_address']) {
                         $ip_records[$n] = array('id' => $n, 'ip_address' => $rec['ip_address'], 'netmask' => $server_config['netmask'], 'gateway' => $server_config['gateway'], 'broadcast' => $this->broadcast($rec['ip_address'], $server_config['netmask']));
                         $additionl_ip_records = 1;
                         $n++;
                     }
                 }
             }
             /*
              * If we have more than 1 IP we have to add the main-ip at the end
              * of the network-ip-list. If we don't do so, there may be problems
              * in multi-server-settings (with the acces from other server to the
//.........这里部分代码省略.........

 private function bastille_update($event_name, $data)
 {
     global $app, $conf;
     $app->uses('system');
     $tcp_ports = $this->clean_ports($data['new']['tcp_port'], ' ');
     $udp_ports = $this->clean_ports($data['new']['udp_port'], ' ');
     $app->load('tpl');
     $tpl = new tpl();
     $tpl->newTemplate('bastille-firewall.cfg.master');
     $tpl->setVar('TCP_PUBLIC_SERVICES', $tcp_ports);
     $tpl->setVar('UDP_PUBLIC_SERVICES', $udp_ports);
     file_put_contents('/etc/Bastille/bastille-firewall.cfg', $tpl->grab());
     $app->log('Writing firewall configuration /etc/Bastille/bastille-firewall.cfg', LOGLEVEL_DEBUG);
     unset($tpl);
     if ($data['new']['active'] == 'y') {
         //* ensure that ufw firewall is disabled in case both firewalls are installed
         if ($app->system->is_installed('ufw')) {
             exec('ufw disable');
         }
         exec($conf['init_scripts'] . '/' . 'bastille-firewall restart 2>/dev/null');
         if (@is_file('/etc/debian_version')) {
             exec('update-rc.d bastille-firewall defaults');
         }
         $app->log('Restarting the firewall', LOGLEVEL_DEBUG);
     } else {
         exec($conf['init_scripts'] . '/' . 'bastille-firewall stop 2>/dev/null');
         if (@is_file('/etc/debian_version')) {
             exec('update-rc.d -f bastille-firewall remove');
         }
         $app->log('Stopping the firewall', LOGLEVEL_DEBUG);
     }
 }

 private function php_fpm_pool_update($data, $web_config, $pool_dir, $pool_name, $socket_dir)
 {
     global $app, $conf;
     //$reload = false;
     if ($data['new']['php'] == 'no') {
         if (@is_file($pool_dir . $pool_name . '.conf')) {
             unlink($pool_dir . $pool_name . '.conf');
             //$reload = true;
         }
         //if($reload == true) $app->services->restartService('php-fpm','reload');
         return;
     }
     $app->uses("getconf");
     $web_config = $app->getconf->get_server_config($conf["server_id"], 'web');
     $app->load('tpl');
     $tpl = new tpl();
     $tpl->newTemplate('php_fpm_pool.conf.master');
     if ($data['new']['php_fpm_use_socket'] == 'y') {
         $use_tcp = 0;
         $use_socket = 1;
         if (!is_dir($socket_dir)) {
             exec('mkdir -p ' . $socket_dir);
         }
     } else {
         $use_tcp = 1;
         $use_socket = 0;
     }
     $tpl->setVar('use_tcp', $use_tcp);
     $tpl->setVar('use_socket', $use_socket);
     $fpm_socket = $socket_dir . $pool_name . '.sock';
     $tpl->setVar('fpm_socket', $fpm_socket);
     $tpl->setVar('fpm_pool', $pool_name);
     $tpl->setVar('fpm_port', $web_config['php_fpm_start_port'] + $data['new']['domain_id'] - 1);
     $tpl->setVar('fpm_user', $data['new']['system_user']);
     $tpl->setVar('fpm_group', $data['new']['system_group']);
     $tpl->setVar('pm_max_children', $data['new']['pm_max_children']);
     $tpl->setVar('pm_start_servers', $data['new']['pm_start_servers']);
     $tpl->setVar('pm_min_spare_servers', $data['new']['pm_min_spare_servers']);
     $tpl->setVar('pm_max_spare_servers', $data['new']['pm_max_spare_servers']);
     $tpl->setVar('document_root', $data['new']['document_root']);
     $tpl->setVar('security_level', $web_config['security_level']);
     $php_open_basedir = $data['new']['php_open_basedir'] == '' ? escapeshellcmd($data['new']['document_root']) : escapeshellcmd($data['new']['php_open_basedir']);
     $tpl->setVar('php_open_basedir', $php_open_basedir);
     if ($php_open_basedir != '') {
         $tpl->setVar('enable_php_open_basedir', '');
     } else {
         $tpl->setVar('enable_php_open_basedir', ';');
     }
     // Custom php.ini settings
     $final_php_ini_settings = array();
     $custom_php_ini_settings = trim($data['new']['custom_php_ini']);
     if ($custom_php_ini_settings != '') {
         // Make sure we only have Unix linebreaks
         $custom_php_ini_settings = str_replace("\r\n", "\n", $custom_php_ini_settings);
         $custom_php_ini_settings = str_replace("\r", "\n", $custom_php_ini_settings);
         $ini_settings = explode("\n", $custom_php_ini_settings);
         if (is_array($ini_settings) && !empty($ini_settings)) {
             foreach ($ini_settings as $ini_setting) {
                 list($key, $value) = explode('=', $ini_setting);
                 if ($value) {
                     $value = escapeshellcmd(trim($value));
                     $key = escapeshellcmd(trim($key));
                     switch (strtolower($value)) {
                         case 'on':
                         case 'off':
                         case '1':
                         case '0':
                             // PHP-FPM might complain about invalid boolean value if you use 0
                             $value = 'off';
                         case 'true':
                         case 'false':
                         case 'yes':
                         case 'no':
                             $final_php_ini_settings[] = array('ini_setting' => 'php_admin_flag[' . $key . '] = ' . $value);
                             break;
                         default:
                             $final_php_ini_settings[] = array('ini_setting' => 'php_admin_value[' . $key . '] = ' . $value);
                     }
                 }
             }
         }
     }
     $tpl->setLoop('custom_php_ini_settings', $final_php_ini_settings);
     file_put_contents($pool_dir . $pool_name . '.conf', $tpl->grab());
     $app->log('Writing the PHP-FPM config file: ' . $pool_dir . $pool_name . '.conf', LOGLEVEL_DEBUG);
     unset($tpl);
     //$reload = true;
     //if($reload == true) $app->services->restartService('php-fpm','reload');
 }

 function onShow()
 {
     global $app;
     $app->uses('listform');
     $app->listform->loadListDef($this->options["listdef"]);
     //$app->listform->SQLExtWhere = "type = 'alias'";
     $listTpl = new tpl();
     $listTpl->newTemplate('templates/' . $app->listform->listDef["name"] . '_list.htm');
     //die(print_r($app->tform_actions));
     // Changing some of the list values to reflect that the list is called within a tform page
     $app->listform->listDef["file"] = $app->tform->formDef["action"];
     // $app->listform->listDef["page_params"] = "&id=".$app->tform_actions->id."&next_tab=".$_SESSION["s"]["form"]["tab"];
     $app->listform->listDef["page_params"] = "&id=" . $this->form->id . "&next_tab=" . $_SESSION["s"]["form"]["tab"];
     $listTpl->setVar('parent_id', $this->form->id);
     $listTpl->setVar('theme', $_SESSION['s']['theme']);
     // Generate the SQL for searching
     $sql_where = "";
     if ($app->listform->listDef["auth"] != 'no') {
         if ($_SESSION["s"]["user"]["typ"] != "admin") {
             $sql_where = $app->tform->getAuthSQL('r') . " and";
         }
     }
     if ($this->options["sqlextwhere"] != '') {
         $sql_where .= " " . $this->options["sqlextwhere"] . " and";
     }
     $sql_where = $app->listform->getSearchSQL($sql_where);
     $listTpl->setVar($app->listform->searchValues);
     // Generate SQL for paging
     $limit_sql = $app->listform->getPagingSQL($sql_where);
     $listTpl->setVar("paging", $app->listform->pagingHTML);
     $sql_order_by = '';
     if (isset($this->options["sql_order_by"])) {
         $sql_order_by = $this->options["sql_order_by"];
     }
     //* Limit each page
     $limits = array('5' => '5', '15' => '15', '25' => '25', '50' => '50', '100' => '100', '999999999' => 'all');
     //* create options and set selected, if default -> 15 is selected
     $options = '';
     foreach ($limits as $key => $val) {
         $options .= '<option value="' . $key . '" ' . (isset($_SESSION['search']['limit']) && $_SESSION['search']['limit'] == $key ? 'selected="selected"' : '') . (!isset($_SESSION['search']['limit']) && $key == '15' ? 'selected="selected"' : '') . '>' . $val . '</option>';
     }
     $listTpl->setVar('search_limit', '<select name="search_limit" style="width:50px">' . $options . '</select>');
     //Sorting
     if (!isset($_SESSION['search'][$app->listform->listDef["name"]]['order'])) {
         $_SESSION['search'][$app->listform->listDef["name"]]['order'] = '';
     }
     if (!empty($_GET['orderby'])) {
         $order = str_replace('tbl_col_', '', $_GET['orderby']);
         //* Check the css class submited value
         if (preg_match("/^[a-z\\_]{1,}\$/", $order)) {
             if ($_SESSION['search'][$app->listform->listDef["name"]]['order'] == $order) {
                 $_SESSION['search'][$app->listform->listDef["name"]]['order'] = $order . ' DESC';
             } else {
                 $_SESSION['search'][$app->listform->listDef["name"]]['order'] = $order;
             }
         }
     }
     // If a manuel oder by like customers isset the sorting will be infront
     if (!empty($_SESSION['search'][$app->listform->listDef["name"]]['order'])) {
         if (empty($sql_order_by)) {
             $sql_order_by = "ORDER BY " . $_SESSION['search'][$app->listform->listDef["name"]]['order'];
         } else {
             $sql_order_by = str_replace("ORDER BY ", "ORDER BY " . $_SESSION['search'][$app->listform->listDef["name"]]['order'] . ', ', $sql_order_by);
         }
     }
     // Loading language field
     $lng_file = "lib/lang/" . $_SESSION["s"]["language"] . "_" . $app->listform->listDef['name'] . "_list.lng";
     include $lng_file;
     $listTpl->setVar($wb);
     // Get the data
     $records = $app->db->queryAllRecords("SELECT * FROM " . $app->listform->listDef["table"] . " WHERE {$sql_where} {$sql_order_by} {$limit_sql}");
     $bgcolor = "#FFFFFF";
     if (is_array($records)) {
         $idx_key = $app->listform->listDef["table_idx"];
         foreach ($records as $rec) {
             $rec = $app->listform->decode($rec);
             // Change of color
             $bgcolor = $bgcolor == "#FFFFFF" ? "#EEEEEE" : "#FFFFFF";
             $rec["bgcolor"] = $bgcolor;
             // substitute value for select fields
             foreach ($app->listform->listDef["item"] as $field) {
                 $key = $field["field"];
                 if ($field['formtype'] == "SELECT") {
                     if (strtolower($rec[$key]) == 'y' or strtolower($rec[$key]) == 'n') {
                         // Set a additional image variable for bolean fields
                         $rec['_' . $key . '_'] = strtolower($rec[$key]) == 'y' ? 'x16/tick_circle.png' : 'x16/cross_circle.png';
                     }
                     //* substitute value for select field
                     @($rec[$key] = $field['value'][$rec[$key]]);
                 }
                 // Create a lowercase version of every item
                 $rec[$key . '_lowercase'] = strtolower($rec[$key]);
             }
             // The variable "id" contains always the index field
             $rec["id"] = $rec[$idx_key];
             $rec["delete_confirmation"] = $wb['delete_confirmation'];
             $records_new[] = $rec;
         }
     }
     $listTpl->setLoop('records', @$records_new);
//.........这里部分代码省略.........

 function onShow()
 {
     global $app;
     $app->uses('listform');
     $app->listform->loadListDef($this->options["listdef"]);
     //$app->listform->SQLExtWhere = "type = 'alias'";
     $listTpl = new tpl();
     $listTpl->newTemplate('templates/' . $app->listform->listDef["name"] . '_list.htm');
     //die(print_r($app->tform_actions));
     // Changing some of the list values to reflect that the list is called within a tform page
     $app->listform->listDef["file"] = $app->tform->formDef["action"];
     // $app->listform->listDef["page_params"] = "&id=".$app->tform_actions->id."&next_tab=".$_SESSION["s"]["form"]["tab"];
     $app->listform->listDef["page_params"] = "&id=" . $this->form->id . "&next_tab=" . $_SESSION["s"]["form"]["tab"];
     $listTpl->setVar('parent_id', $this->form->id);
     $listTpl->setVar('theme', $_SESSION['s']['theme']);
     // Generate the SQL for searching
     if ($app->listform->listDef["auth"] != 'no') {
         if ($_SESSION["s"]["user"]["typ"] == "admin") {
             $sql_where = "";
         } else {
             $sql_where = $app->tform->getAuthSQL('r') . " and";
         }
     }
     if ($this->options["sqlextwhere"] != '') {
         $sql_where .= " " . $this->options["sqlextwhere"] . " and";
     }
     $sql_where = $app->listform->getSearchSQL($sql_where);
     $listTpl->setVar($app->listform->searchValues);
     // Generate SQL for paging
     $limit_sql = $app->listform->getPagingSQL($sql_where);
     $listTpl->setVar("paging", $app->listform->pagingHTML);
     $sql_order_by = '';
     if (isset($this->options["sql_order_by"])) {
         $sql_order_by = $this->options["sql_order_by"];
     }
     // Loading language field
     $lng_file = "lib/lang/" . $_SESSION["s"]["language"] . "_" . $app->listform->listDef['name'] . "_list.lng";
     include $lng_file;
     $listTpl->setVar($wb);
     // Get the data
     $records = $app->db->queryAllRecords("SELECT * FROM " . $app->listform->listDef["table"] . " WHERE {$sql_where} {$sql_order_by} {$limit_sql}");
     $bgcolor = "#FFFFFF";
     if (is_array($records)) {
         $idx_key = $app->listform->listDef["table_idx"];
         foreach ($records as $rec) {
             $rec = $app->listform->decode($rec);
             // Change of color
             $bgcolor = $bgcolor == "#FFFFFF" ? "#EEEEEE" : "#FFFFFF";
             $rec["bgcolor"] = $bgcolor;
             // substitute value for select fields
             foreach ($app->listform->listDef["item"] as $field) {
                 $key = $field["field"];
                 if ($field['formtype'] == "SELECT") {
                     if (strtolower($rec[$key]) == 'y' or strtolower($rec[$key]) == 'n') {
                         // Set a additional image variable for bolean fields
                         $rec['_' . $key . '_'] = strtolower($rec[$key]) == 'y' ? 'x16/tick_circle.png' : 'x16/cross_circle.png';
                     }
                     //* substitute value for select field
                     @($rec[$key] = $field['value'][$rec[$key]]);
                 }
                 // Create a lowercase version of every item
                 $rec[$key . '_lowercase'] = strtolower($rec[$key]);
             }
             // The variable "id" contains always the index field
             $rec["id"] = $rec[$idx_key];
             $rec["delete_confirmation"] = $wb['delete_confirmation'];
             $records_new[] = $rec;
         }
     }
     $listTpl->setLoop('records', @$records_new);
     // Setting Returnto information in the session
     $list_name = $app->listform->listDef["name"];
     // $_SESSION["s"]["list"][$list_name]["parent_id"] = $app->tform_actions->id;
     $_SESSION["s"]["list"][$list_name]["parent_id"] = $this->form->id;
     $_SESSION["s"]["list"][$list_name]["parent_name"] = $app->tform->formDef["name"];
     $_SESSION["s"]["list"][$list_name]["parent_tab"] = $_SESSION["s"]["form"]["tab"];
     $_SESSION["s"]["list"][$list_name]["parent_script"] = $app->tform->formDef["action"];
     $_SESSION["s"]["form"]["return_to"] = $list_name;
     //die(print_r($_SESSION["s"]["list"][$list_name]));
     return $listTpl->grab();
 }