$spine->assign('hostsrv', $services);
// Lista kont uzytkownikow w systemie
$q = $dbh->prepare("SELECT id, login, fullname, email FROM sysusers WHERE system_id = " . $_GET['serverid']);
$q->execute();
while ($r = $q->fetch()) {
$sysuser[$r['id']] = array('login' => $r['login'], 'fullname' => $r['fullname'], 'email' => $r['email']);
}
$spine->assign('sysuser', $sysuser);
// lista stron WWW na danym serwerze
$q = $dbh->prepare("SELECT id, ServerName,htpasswd FROM www WHERE system_id = " . $_GET['serverid'] . " AND status = 'A'");
$q->execute();
if ($q->rowCount() == 0) {
$spine->assign('EmptySiteList', 1);
} else {
while ($r = $q->fetch()) {
$access_type = vhostAccessLevel($dbh, $r['id']);
$apacheconf[$r['id']] = array('ServerName' => $r['ServerName'], 'password' => $r['htpasswd'], 'access_type' => $access_type);
}
$spine->assign('websites', $apacheconf);
}
// lista kont htaccess na danym serwerze
$q = $dbh->prepare("SELECT id, login FROM www_users WHERE system_id = " . $_GET['serverid']);
$q->execute();
if ($q->rowCount() == 0) {
$spine->assign('EmptyUserList', 1);
} else {
while ($r = $q->fetch()) {
$htusers[$r['id']] = $r['login'];
}
$spine->assign('htusers', $htusers);
}
$q = $dbh->prepare("DELETE FROM www_access WHERE vhost_id = " . $_GET['edit']);
$q->execute();
$accessList = array_combine($_POST['fromhost'], $_POST['allow']);
foreach ($accessList as $host => $permission) {
$q = $dbh->prepare("INSERT INTO www_access(fromhost,access_permission,vhost_id) " . "VALUES('" . $host . "', " . $permission . ", " . $_GET['edit'] . ")");
$q->execute();
}
$q = $dbh->prepare("DELETE FROM www_users_access WHERE vhost_id = " . $_GET['edit'] . " AND server_id = " . $_POST['serverid']);
$q->execute();
foreach ($_POST['htusers'] as $htuser) {
$q = $dbh->prepare("INSERT INTO www_users_access(user_id, vhost_id, server_id) VALUES(" . $htuser . ", " . $_GET['edit'] . ", " . $_POST['serverid'] . ")");
$q->execute();
}
updateConfigVersion($dbh, $_POST['serverid']);
$vhostid = $_GET['edit'];
$vhostAccess = vhostAccessLevel($dbh, $vhostid);
$q = $dbh->prepare("SELECT ServerName,htpasswd FROM www WHERE id = " . $vhostid);
$q->execute();
$r = $q->fetch();
$json = array('id' => $vhostid, 'ServerName' => $r['ServerName'], 'password_protection' => $r['htpasswd'], 'vhostAccess' => $vhostAccess);
header('Content-Type: application/json');
echo json_encode($json);
}
if (isset($_GET['htusers'])) {
$q = $dbh->prepare("SELECT id, login FROM www_users WHERE system_id = " . $_GET['htusers']);
$q->execute();
while ($r = $q->fetch()) {
$json[$r['id']] = $r['login'];
}
header('Content-Type: application/json');
echo json_encode($json);
