# cabal-ep8-centos8

**Repository Path**: varchar32/cabal-ep8-centos8

## Basic Information

- **Project Name**: cabal-ep8-centos8
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 3
- **Created**: 2024-09-12
- **Last Updated**: 2024-09-12

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# cabal-ep8-centos8

### 介绍
- 使用一台CentOS 8 Stream配置CABAL服务器
- 使用的配置是4H4G
- 你的电脑需要安装
- [微软官方SSMS数据库管理工具](https://learn.microsoft.com/zh-CN/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16)
- 哔哩哔哩 视频安装过程[BV1bG411e7WY](https://www.bilibili.com/video/BV1bG411e7WY)
- 原帖地址[centos-7-repack-cabal-server](https://forum.ragezone.com/f460/centos-7-repack-cabal-server-1144251/)

### 安装教程
升级 + 安装 git
```bash
yum update && yum install git
```
获取项目
```bash
git clone https://gitee.com/divib/cabal-ep8-centos8.git
```
进入cabal-ep8-centos8目录
```Shell
cd cabal-ep8-centos8
```
赋予install.sh权限
```Shell
chmod +x install.sh
```
运行install.sh开始安装
```Shell
./install.sh
```
安装过程中数据库选择免费社区版[3]
并设置 sa 密码 使用大小写+数字+特殊符号的强密码

将备份数据库移动到`/var/opt/mssql/backup`
```Shell
sudo mv /root/cabal-ep8-centos8/backup /var/opt/mssql/backup
```
进入`/var/opt/mssql/backup`
```Bush
cd /var/opt/mssql/backup
```
解压数据库文件
```Bush
tar xzvf db*
```
给数据库文件权限
```Bush
chmod +rwx *.bak
```
新建数据库
使用SSMS数据库管理工具登录，`新建查询`，然后复制以下代码：
```sql
CREATE DATABASE Account;
CREATE DATABASE Authentication;
CREATE DATABASE CabalCash;
CREATE DATABASE CabalGuild;
CREATE DATABASE EventData;
CREATE DATABASE NetcafeBilling;
CREATE DATABASE Server01;
```
并单击`执行`将创建数据库


`新建查询`，然后复制以下代码：
```sql
USE master;
GO

-- 还原 Account 数据库
RESTORE DATABASE [Account]
FROM DISK = '/var/opt/mssql/backup/Account.bak'
WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 5;
GO

-- 还原 Authentication 数据库
RESTORE DATABASE [Authentication]
FROM DISK = '/var/opt/mssql/backup/Authentication.bak'
WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 5;
GO

-- 还原 CabalCash 数据库
RESTORE DATABASE [CabalCash]
FROM DISK = '/var/opt/mssql/backup/CabalCash.bak'
WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 5;
GO

-- 还原 CabalGuild 数据库
RESTORE DATABASE [CabalGuild]
FROM DISK = '/var/opt/mssql/backup/CabalGuild.bak'
WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 5;
GO

-- 还原 EventData 数据库
RESTORE DATABASE [EventData]
FROM DISK = '/var/opt/mssql/backup/EventData.bak'
WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 5;
GO

-- 还原 Netcafebilling 数据库
RESTORE DATABASE [Netcafebilling]
FROM DISK = '/var/opt/mssql/backup/Netcafebilling.bak'
WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 5;
GO

-- 还原 Server01 数据库
RESTORE DATABASE [Server01]
FROM DISK = '/var/opt/mssql/backup/Server01.bak'
WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 5;
GO
```
---
### 网站架设
- LNMP一键安装包[https://lnmp.org/](https://lnmp.org/)
- 其中PHP 版本选7.1
- 安装完网站环境后还需要安装php扩展pdo_odbc

- 将`pdo_odbc.so`和`pdo_pgsql.so`放入`/usr/local/php/lib/php/extensions/no-debug-non-zts-20160303/`
- `no-debug-non-zts-20160303`文件夹名称可能不一样，按实际的

修改`/usr/local/php/etc/php.ini`在最后添加
```
extension=pdo_odbc.so
extension=pdo_pgsql.so
```
修改`/etc/odbcinst.ini`添加
```
[SQL Server]
Description=Microsoft ODBC Driver 17 for SQL Server
Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.10.so.5.1
UsageCount=1
```
`libmsodbcsql-17.10.so.5.1`名称可能不一样，按实际的

重启lnmp 
```bush
lnmp restart
```

新建MWeb.bak数据库并还原
- `Account`数据库`dbo.cabal_auth_table`设计增加
```sql
ALTER TABLE dbo.cabal_auth_table
ADD
QtHackerSkill int NULL,
Celular bigint NULL,
Nome varchar(50) NULL, 
Chave varchar(50) NULL, 
Ativado char(3) NULL
```
- 修改注册过程`[Account].[dbo].[cabal_tool_registerAccount]`

- `Server01`数据库`dbo.cabal_new_character_data`设计增加
```sql
ALTER TABLE dbo.cabal_new_character_data
ADD
PassiveAbilityData varbinary(512) NULL,
BlendedAbilityData varbinary(256) NULL
```
创建角色时增加符文项
```sql
UPDATE cabal_new_character_data SET PassiveAbilityData = 0x WHERE ClassType = 1
UPDATE cabal_new_character_data SET PassiveAbilityData = 0x WHERE ClassType = 2
UPDATE cabal_new_character_data SET PassiveAbilityData = 0x WHERE ClassType = 3
UPDATE cabal_new_character_data SET PassiveAbilityData = 0x WHERE ClassType = 4
UPDATE cabal_new_character_data SET PassiveAbilityData = 0x WHERE ClassType = 5
UPDATE cabal_new_character_data SET PassiveAbilityData = 0x WHERE ClassType = 6
UPDATE cabal_new_character_data SET BlendedAbilityData = 0x WHERE ClassType = 1
UPDATE cabal_new_character_data SET BlendedAbilityData = 0x WHERE ClassType = 2
UPDATE cabal_new_character_data SET BlendedAbilityData = 0x WHERE ClassType = 3
UPDATE cabal_new_character_data SET BlendedAbilityData = 0x WHERE ClassType = 4
UPDATE cabal_new_character_data SET BlendedAbilityData = 0x WHERE ClassType = 5
UPDATE cabal_new_character_data SET BlendedAbilityData = 0x WHERE ClassType = 6
```
- 修改角色创建`[Server01].[dbo].[cabal_sp_newchar]`
- 修改上线设置`[Server01].[dbo].[cabal_sp_SetCharLoginStt]`
---

### 使用说明

安装完成后创建 / 配置
```javascript
//示例：cabal_create -s 1 [将创建1个服务器]
cabal_create -s 1
```
```javascript
//示例：cabal_create -c 2 1  [将在第1个服务器上创建2个频道]
cabal_create -c 2 1
```
```javascript
//命令cabal_config配置
cabal_config
//Enter MSSQL server IP: 127.0.0.1
//Enter MSSQL server Port(默认1433):1433
//Enter MSSQL server User: sa
//Enter MSSQL server Password: 你的数据库密码
//Enter IP for players to connect: 你的服务器公网IP
```
cabal服务管理指令
```javascript
cabal_start//开启服务
cabal_stop//停止服务
cabal_status//查看运行状态

cabal_reload//重新加载实时服务器上的服务
cabal_restart//重启服务
cabal_restart -d//重新启动服务并删除所有日志*
```

注册账户
选择[Account]数据库，`新建查询`，然后复制以下代码：
```sql
exec dbo.cabal_tool_registerAccount '账号','密码'
```
更改数据库客户端版本+MagicKey
```sql
USE [Account];
UPDATE dbo.cabal_client_version_table
SET Ver = 369, MagicKey = 543957823;
```

重新启动数据库指令
```Shell
systemctl restart mssql-server
```