PHP tform_actions::onAfterUpdate方法代码示例

 function onAfterUpdate()
 {
     global $app;
     // username changed
     if ($conf['demo_mode'] != true && isset($this->dataRecord['username']) && $this->dataRecord['username'] != '' && $this->oldDataRecord['username'] != $this->dataRecord['username']) {
         $username = $app->db->quote($this->dataRecord["username"]);
         $client_id = $this->id;
         $sql = "UPDATE sys_user SET username = '{$username}' WHERE client_id = {$client_id}";
         $app->db->query($sql);
         $tmp = $app->db->queryOneRecord("SELECT * FROM sys_group WHERE client_id = {$client_id}");
         $app->db->datalogUpdate("sys_group", "name = '{$username}'", 'groupid', $tmp['groupid']);
         unset($tmp);
     }
     // password changed
     if ($conf['demo_mode'] != true && isset($this->dataRecord["password"]) && $this->dataRecord["password"] != '') {
         $password = $app->db->quote($this->dataRecord["password"]);
         $salt = "\$1\$";
         $base64_alphabet = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/';
         for ($n = 0; $n < 8; $n++) {
             $salt .= $base64_alphabet[mt_rand(0, 63)];
         }
         $salt .= "\$";
         $password = crypt(stripslashes($password), $salt);
         $client_id = $this->id;
         $sql = "UPDATE sys_user SET passwort = '{$password}' WHERE client_id = {$client_id}";
         $app->db->query($sql);
     }
     // language changed
     if ($conf['demo_mode'] != true && isset($this->dataRecord['language']) && $this->dataRecord['language'] != '' && $this->oldDataRecord['language'] != $this->dataRecord['language']) {
         $language = $app->db->quote($this->dataRecord["language"]);
         $client_id = $this->id;
         $sql = "UPDATE sys_user SET language = '{$language}' WHERE client_id = {$client_id}";
         $app->db->query($sql);
     }
     // reseller status changed
     if (isset($this->dataRecord["limit_client"]) && $this->dataRecord["limit_client"] != $this->oldDataRecord["limit_client"]) {
         $modules = $conf['interface_modules_enabled'];
         if ($this->dataRecord["limit_client"] > 0) {
             $modules .= ',client';
         }
         $modules = $app->db->quote($modules);
         $client_id = $this->id;
         $sql = "UPDATE sys_user SET modules = '{$modules}' WHERE client_id = {$client_id}";
         $app->db->query($sql);
     }
     /*
      *  If there is a client-template, process it */
     applyClientTemplates($this->id);
     parent::onAfterUpdate();
 }

 function onAfterUpdate()
 {
     global $app, $conf;
     // username changed
     if (isset($conf['demo_mode']) && $conf['demo_mode'] != true && isset($this->dataRecord['username']) && $this->dataRecord['username'] != '' && $this->oldDataRecord['username'] != $this->dataRecord['username']) {
         $username = $app->db->quote($this->dataRecord["username"]);
         $client_id = $this->id;
         $sql = "UPDATE sys_user SET username = '{$username}' WHERE client_id = {$client_id}";
         $app->db->query($sql);
         $tmp = $app->db->queryOneRecord("SELECT * FROM sys_group WHERE client_id = {$client_id}");
         $app->db->datalogUpdate("sys_group", "name = '{$username}'", 'groupid', $tmp['groupid']);
         unset($tmp);
     }
     // password changed
     if (isset($conf['demo_mode']) && $conf['demo_mode'] != true && isset($this->dataRecord["password"]) && $this->dataRecord["password"] != '') {
         $password = $app->db->quote($this->dataRecord["password"]);
         $salt = "\$1\$";
         $base64_alphabet = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/';
         for ($n = 0; $n < 8; $n++) {
             $salt .= $base64_alphabet[mt_rand(0, 63)];
         }
         $salt .= "\$";
         $password = crypt(stripslashes($password), $salt);
         $client_id = $this->id;
         $sql = "UPDATE sys_user SET passwort = '{$password}' WHERE client_id = {$client_id}";
         $app->db->query($sql);
     }
     if (!isset($this->dataRecord['locked'])) {
         $this->dataRecord['locked'] = 'n';
     }
     if (isset($conf['demo_mode']) && $conf['demo_mode'] != true && $this->dataRecord["locked"] != $this->oldDataRecord['locked']) {
         /** lock all the things like web, mail etc. - easy to extend */
         // get tmp_data of client
         $client_data = $app->db->queryOneRecord('SELECT `tmp_data` FROM `client` WHERE `client_id` = ' . $this->id);
         if ($client_data['tmp_data'] == '') {
             $tmp_data = array();
         } else {
             $tmp_data = unserialize($client_data['tmp_data']);
         }
         if (!is_array($tmp_data)) {
             $tmp_data = array();
         }
         // database tables with their primary key columns
         $to_disable = array('cron' => 'id', 'ftp_user' => 'ftp_user_id', 'mail_domain' => 'domain_id', 'mail_user' => 'mailuser_id', 'mail_user_smtp' => 'mailuser_id', 'mail_forwarding' => 'forwarding_id', 'mail_get' => 'mailget_id', 'openvz_vm' => 'vm_id', 'shell_user' => 'shell_user_id', 'webdav_user' => 'webdav_user_id', 'web_database' => 'database_id', 'web_domain' => 'domain_id', 'web_folder' => 'web_folder_id', 'web_folder_user' => 'web_folder_user_id');
         $udata = $app->db->queryOneRecord('SELECT `userid` FROM `sys_user` WHERE `client_id` = ' . $this->id);
         $gdata = $app->db->queryOneRecord('SELECT `groupid` FROM `sys_group` WHERE `client_id` = ' . $this->id);
         $sys_groupid = $gdata['groupid'];
         $sys_userid = $udata['userid'];
         $entries = array();
         if ($this->dataRecord['locked'] == 'y') {
             $prev_active = array();
             $prev_sysuser = array();
             foreach ($to_disable as $current => $keycolumn) {
                 $active_col = 'active';
                 $reverse = false;
                 if ($current == 'mail_user') {
                     $active_col = 'postfix';
                 } elseif ($current == 'mail_user_smtp') {
                     $current = 'mail_user';
                     $active_col = 'disablesmtp';
                     $reverse = true;
                 }
                 if (!isset($prev_active[$current])) {
                     $prev_active[$current] = array();
                 }
                 if (!isset($prev_sysuser[$current])) {
                     $prev_sysuser[$current] = array();
                 }
                 $entries = $app->db->queryAllRecords('SELECT `' . $keycolumn . '` as `id`, `sys_userid`, `' . $active_col . '` FROM `' . $current . '` WHERE `sys_groupid` = ' . $sys_groupid);
                 foreach ($entries as $item) {
                     if ($item[$active_col] != 'y' && $reverse == false) {
                         $prev_active[$current][$item['id']][$active_col] = 'n';
                     } elseif ($item[$active_col] == 'y' && $reverse == true) {
                         $prev_active[$current][$item['id']][$active_col] = 'y';
                     }
                     if ($item['sys_userid'] != $sys_userid) {
                         $prev_sysuser[$current][$item['id']] = $item['sys_userid'];
                     }
                     // we don't have to store these if y, as everything without previous state gets enabled later
                     $app->db->datalogUpdate($current, array($active_col => $reverse == true ? 'y' : 'n', 'sys_userid' => $_SESSION["s"]["user"]["userid"]), $keycolumn, $item['id']);
                 }
             }
             $tmp_data['prev_active'] = $prev_active;
             $tmp_data['prev_sys_userid'] = $prev_sysuser;
             $app->db->query("UPDATE `client` SET `tmp_data` = '" . $app->db->quote(serialize($tmp_data)) . "' WHERE `client_id` = " . $this->id);
             unset($prev_active);
             unset($prev_sysuser);
         } elseif ($this->dataRecord['locked'] == 'n') {
             foreach ($to_disable as $current => $keycolumn) {
                 $active_col = 'active';
                 $reverse = false;
                 if ($current == 'mail_user') {
                     $active_col = 'postfix';
                 } elseif ($current == 'mail_user_smtp') {
                     $current = 'mail_user';
                     $active_col = 'disablesmtp';
                     $reverse = true;
                 }
                 $entries = $app->db->queryAllRecords('SELECT `' . $keycolumn . '` as `id` FROM `' . $current . '` WHERE `sys_groupid` = ' . $sys_groupid);
                 foreach ($entries as $item) {
//.........这里部分代码省略.........

 function onAfterUpdate()
 {
     global $app, $conf;
     // username changed
     if (isset($conf['demo_mode']) && $conf['demo_mode'] != true && isset($this->dataRecord['username']) && $this->dataRecord['username'] != '' && $this->oldDataRecord['username'] != $this->dataRecord['username']) {
         $username = $app->db->quote($this->dataRecord["username"]);
         $client_id = $this->id;
         $sql = "UPDATE sys_user SET username = '{$username}' WHERE client_id = {$client_id}";
         $app->db->query($sql);
         $tmp = $app->db->queryOneRecord("SELECT * FROM sys_group WHERE client_id = {$client_id}");
         $app->db->datalogUpdate("sys_group", "name = '{$username}'", 'groupid', $tmp['groupid']);
         unset($tmp);
     }
     // password changed
     if (isset($conf['demo_mode']) && $conf['demo_mode'] != true && isset($this->dataRecord["password"]) && $this->dataRecord["password"] != '') {
         $password = $app->db->quote($this->dataRecord["password"]);
         $client_id = $this->id;
         $salt = "\$1\$";
         $base64_alphabet = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/';
         for ($n = 0; $n < 8; $n++) {
             $salt .= $base64_alphabet[mt_rand(0, 63)];
         }
         $salt .= "\$";
         $password = crypt(stripslashes($password), $salt);
         $sql = "UPDATE sys_user SET passwort = '{$password}' WHERE client_id = {$client_id}";
         $app->db->query($sql);
     }
     // language changed
     if (isset($conf['demo_mode']) && $conf['demo_mode'] != true && isset($this->dataRecord['language']) && $this->dataRecord['language'] != '' && $this->oldDataRecord['language'] != $this->dataRecord['language']) {
         $language = $app->db->quote($this->dataRecord["language"]);
         $client_id = $this->id;
         $sql = "UPDATE sys_user SET language = '{$language}' WHERE client_id = {$client_id}";
         $app->db->query($sql);
     }
     // ensure that a reseller is not converted to a client in demo mode when client_id <= 2
     if (isset($conf['demo_mode']) && $conf['demo_mode'] == true && $this->id <= 2) {
         if (isset($this->dataRecord["limit_client"]) && $this->dataRecord["limit_client"] != -1) {
             $app->db->query('UPDATE client set limit_client = -1 WHERE client_id = ' . $this->id);
         }
     }
     // reseller status changed
     if (isset($this->dataRecord["limit_client"]) && $this->dataRecord["limit_client"] != $this->oldDataRecord["limit_client"]) {
         $modules = $app->db->quote($conf['interface_modules_enabled'] . ',client');
         $modules = $app->db->quote($modules);
         $client_id = $this->id;
         $sql = "UPDATE sys_user SET modules = '{$modules}' WHERE client_id = {$client_id}";
         $app->db->query($sql);
     }
     if (isset($this->dataRecord['template_master'])) {
         $app->uses('client_templates');
         $app->client_templates->update_client_templates($this->id, $this->_template_additional);
     }
     parent::onAfterUpdate();
 }