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 = '******' 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 = '******' 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) {
$set_active = $reverse == true ? 'n' : 'y';
$set_inactive = $reverse == true ? 'y' : 'n';
$set_sysuser = $sys_userid;
if (array_key_exists('prev_active', $tmp_data) == true && array_key_exists($current, $tmp_data['prev_active']) == true && array_key_exists($item['id'], $tmp_data['prev_active'][$current]) == true && $tmp_data['prev_active'][$current][$item['id']][$active_col] == $set_inactive) {
$set_active = $set_inactive;
}
if (array_key_exists('prev_sysuser', $tmp_data) == true && array_key_exists($current, $tmp_data['prev_sysuser']) == true && array_key_exists($item['id'], $tmp_data['prev_sysuser'][$current]) == true && $tmp_data['prev_sysuser'][$current][$item['id']] != $sys_userid) {
$set_sysuser = $tmp_data['prev_sysuser'][$current][$item['id']];
}
$app->db->datalogUpdate($current, array($active_col => $set_active, 'sys_userid' => $set_sysuser), $keycolumn, $item['id']);
}
}
if (array_key_exists('prev_active', $tmp_data)) {
unset($tmp_data['prev_active']);
}
$app->db->query("UPDATE `client` SET `tmp_data` = '" . $app->db->quote(serialize($tmp_data)) . "' WHERE `client_id` = " . $this->id);
}
unset($tmp_data);
unset($entries);
unset($to_disable);
}
if (!isset($this->dataRecord['canceled'])) {
$this->dataRecord['canceled'] = 'n';
}
if (isset($conf['demo_mode']) && $conf['demo_mode'] != true && $this->dataRecord["canceled"] != $this->oldDataRecord['canceled']) {
if ($this->dataRecord['canceled'] == 'y') {
$sql = "UPDATE sys_user SET active = '0' WHERE client_id = " . $this->id;
$app->db->query($sql);
} elseif ($this->dataRecord['canceled'] == 'n') {
$sql = "UPDATE sys_user SET active = '1' WHERE client_id = " . $this->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);
}
//* 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);
}
//* Client has been moved to another reseller
if ($_SESSION['s']['user']['typ'] == 'admin' && isset($this->dataRecord['parent_client_id']) && $this->dataRecord['parent_client_id'] != $this->oldDataRecord['parent_client_id']) {
//* Get groupid of the client
$tmp = $app->db->queryOneRecord("SELECT groupid FROM sys_group WHERE client_id = " . intval($this->id));
$groupid = $tmp['groupid'];
unset($tmp);
//* Remove sys_user of old reseller from client group
if ($this->oldDataRecord['parent_client_id'] > 0) {
//* get userid of the old reseller remove it from the group of the client
$tmp = $app->db->queryOneRecord("SELECT sys_user.userid FROM sys_user,sys_group WHERE sys_user.default_group = sys_group.groupid AND sys_group.client_id = " . $app->functions->intval($this->oldDataRecord['parent_client_id']));
$app->auth->remove_group_from_user($tmp['userid'], $groupid);
unset($tmp);
}
//* Add sys_user of new reseller to client group
if ($this->dataRecord['parent_client_id'] > 0) {
//* get userid of the reseller and add it to the group of the client
$tmp = $app->db->queryOneRecord("SELECT sys_user.userid, sys_user.default_group FROM sys_user,sys_group WHERE sys_user.default_group = sys_group.groupid AND sys_group.client_id = " . $app->functions->intval($this->dataRecord['parent_client_id']));
$app->auth->add_group_to_user($tmp['userid'], $groupid);
$app->db->query("UPDATE client SET sys_userid = " . $app->functions->intval($tmp['userid']) . ", sys_groupid = " . $app->functions->intval($tmp['default_group']) . ", parent_client_id = " . $app->functions->intval($this->dataRecord['parent_client_id']) . " WHERE client_id = " . $this->id);
unset($tmp);
} else {
//* Client is not assigned to a reseller anymore, so we assign it to the admin
$app->db->query("UPDATE client SET sys_userid = 1, sys_groupid = 1, parent_client_id = 0 WHERE client_id = " . $this->id);
}
}
if (isset($this->dataRecord['template_master'])) {
$app->uses('client_templates');
$app->client_templates->update_client_templates($this->id, $this->_template_additional);
}
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 = '******' 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();
}