$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);