vpn_based_remote_access_system
Advanced tools
Comparing version 1.0.59 to 1.0.60
{ | ||
"name": "vpn_based_remote_access_system", | ||
"version": "1.0.59", | ||
"version": "1.0.60", | ||
"description": "毕设:基于OpenVPN的远程访问系统", | ||
@@ -5,0 +5,0 @@ "main": "index.js", |
@@ -10,2 +10,25 @@ const sqlite3 = require('sqlite3').verbose(); | ||
// �ڳ���ʼ����ʱ������Ĭ���û��� | ||
function addDefaultGroup() { | ||
const defaultGroupName = 'default'; | ||
const defaultPorts = '5140'; // Ĭ�϶˿ں� | ||
db.run(`INSERT OR IGNORE INTO group_permissions (group_name, allowed_ports) VALUES (?, ?)`, [defaultGroupName, defaultPorts], function (err) { | ||
if (err) { | ||
console.error(err.message); | ||
return; | ||
} | ||
console.log(`Default group '${defaultGroupName}' has been added or already exists.`); | ||
}); | ||
} | ||
function listGroup() { | ||
db.all(`SELECT * from group_permissions`, [], function (err, row) { | ||
if (err) { | ||
console.error(err.message); | ||
return; | ||
} | ||
console.table(row); | ||
}); | ||
} | ||
// �����û��� | ||
@@ -19,3 +42,3 @@ function addGroup(groupName, portsArray) { | ||
} | ||
console.log(`User group named ${groupName} has been added.`); | ||
console.log(`A group named ${groupName} has been added.`); | ||
}); | ||
@@ -57,3 +80,3 @@ } | ||
function deleteUserGroup(groupName) { | ||
if (groupNameToDelete === 'default') { | ||
if (groupName === 'default') { | ||
console.log('The "default" group cannot be deleted.'); | ||
@@ -75,2 +98,3 @@ } else { | ||
// ���û������Ƴ��˿� | ||
function removePortFromUserGroup(groupName, ports) { | ||
@@ -107,2 +131,3 @@ db.get(`SELECT allowed_ports FROM group_permissions WHERE group_name = ?`, [groupName], function (err, row) { | ||
// �г������û��鼰���ʷ�Χ����ʽΪ��group list | ||
listGroup(); | ||
break; | ||
@@ -109,0 +134,0 @@ case 'add': |
@@ -50,5 +50,6 @@ const express = require('express'); | ||
// 用户组名称及相应所允许访问的端口表 | ||
db.run(`CREATE TABLE IF NOT EXISTS group_permissions ( | ||
group_name TEXT PRIMARY KEY, | ||
allowed_ports TEXT DEFAULT '5140' | ||
allowed_ports TEXT | ||
)`); | ||
@@ -55,0 +56,0 @@ |
976
60871
10