局域网配置和外网配置类似,这里只以局域网为例。(外网有用路由器的,必须先设置端口映射或者设置DMZ主机,建议设置DMZ主机。外网没有固定ip的需设置动态域名。)
首先前提,单机版在你的电脑能顺利架设成功。
然后在本地连接内查看你的内网ip地址是多少。
1.修改数据库
打开sql查询分析器,在文本框输入以下代码,按F5执行操作。
代码:
Use Account
update TBL_GMIP
set FLD_IP='127.0.0.1'
from TBL_GMIP
Use Account
update TBL_PUBIPS
set FLD_PUBIP='127.0.0.1'
from TBL_PUBIPS
Use Account
update TBL_SELECTGATEIPS
set FLD_NAME='藏宝湾'
from TBL_SELECTGATEIPS
----只有这个是输入外网IP-----
Use Account
update TBL_SELECTGATEIPS
set FLD_IP='192.168.1.1'
from TBL_SELECTGATEIPS
----只有这个是输入外网IP-----
Use Account
update TBL_SERVERINFO
set FLD_SERVERNAME='藏宝湾'
from TBL_SERVERINFO
Use HeroCommon1
update rareitemsdata
set PassedHours='0'
from rareitemsdata
Use HeroCommon1
update rareitemsdata
set Dropped='1'
from rareitemsdata
Use HeroCommon1
update rareitemsdata
set MissedCount='0'
from rareitemsdata
Use HeroCommon1
update CastleDefine
set ServerName='藏宝湾'
from CastleDefine
Use HeroCommon1
update CastleWars
set servername='藏宝湾'
from CastleWars
Use HeroCommon1
update rareitemsdata
set servername='藏宝湾'
from rareitemsdata
Use HeroCommon1
update rareitems
set UpgProb='6'
from rareitems
2.配置网关
D:\Mud3\Mir3Server\3Gates\3Gates.exe 打开程序设置-系统设置,右侧有红字标有的两个地方: 选人转发、Rungate自动转发,
那2个IP改为为局域网IP,是否开启转发打勾。
D:\Mud3\Mir3Server\DBSvr\DBSvr.exe 点击option-configuration将name修改为你的区名,如图
D:\Mud3\Mir3Server\DBSvr\!serverinfo.txt 第二个IP改为外网的,端口不能变。
D:\mud3\Setup\!setup修改工具.exe 服务器名称修改成你的区名,ip不要改。可以在这里修改下经验和爆率的倍数。怪物倍数建议默认,其他的倍率建议不要大于128。
3.配置登录器
将里面的单机ip改成主机局域网ip,列表区名随意填写,真正区名填写你刚刚修改数据库时的区名,然后点击修改信息按钮即可。
然后将YW-090731.INF文件复制到客户端里覆盖原有文件。
D:\mud3\登陆器\登录器配置\无限KEY生成器.EXE
点击生成key按钮,复制Key.Xq文件到D:\Mud3\Mir3Server\3Gates\覆盖。
按顺序启动服务端,开始你的联机之旅吧。
附数据清档脚本,13技能端通用,在查询分析器内使用。
------------清除帐号数据-------------------
DELETE FROM [Account].[dbo].[TBL_ACCOUNT]
DELETE FROM [Account].[dbo].[TBL_ACCOUNTADD]
DELETE FROM [Account].[dbo].[TBL_CONNECTLOGS]
DELETE FROM [Account].[dbo].[TBL_COUNTLOGS]
DELETE FROM [Account].[dbo].[TBL_USERCOUNT]
------------清除人物数据-------------------
DELETE FROM [Game1].[dbo].[TBL_ABILITY]
DELETE FROM [Game1].[dbo].[TBL_ACCOUNT]
DELETE FROM [Game1].[dbo].[TBL_CHARACTER]
DELETE FROM [Game1].[dbo].[TBL_DHLBOX]
DELETE FROM [Game1].[dbo].[TBL_FACEIMG]
DELETE FROM [Game1].[dbo].[TBL_GIFT]
DELETE FROM [Game1].[dbo].[TBL_ITEM]
DELETE FROM [Game1].[dbo].[TBL_ITEMLIMIT]
DELETE FROM [Game1].[dbo].[TBL_ITEMLOG]
DELETE FROM [Game1].[dbo].[TBL_ITEMMARKET]
DELETE FROM [Game1].[dbo].[TBL_ITEMSTORE]
DELETE FROM [Game1].[dbo].[TBL_JueQingQuest]
DELETE FROM [Game1].[dbo].[TBL_MAGIC]
DELETE FROM [Game1].[dbo].[TBL_QUEST]
DELETE FROM [Game1].[dbo].[TBL_RELATPOINT]
DELETE FROM [Game1].[dbo].[TBL_RELATPOINTLOG]
DELETE FROM [Game1].[dbo].[TBL_SAVEDITEM]
DELETE FROM [Game1].[dbo].[TBL_SinGiSunQuest]
DELETE FROM [Game1].[dbo].[TBL_SnowPlainQuest]
DELETE FROM [Game1].[dbo].[TBL_SUBHUMAN]
DELETE FROM [Game1].[dbo].[TBL_WestDesertQuest]
DELETE FROM [Game1].[dbo].[tmp_1113item]
DELETE FROM [kingforeiserverbasedata].[dbo].[King_Humplus]
DELETE FROM [kingforeiserverbasedata].[dbo].[King_UserJFLog]
- 本文固定链接: https://www.fengshen.cn/2014/03/mir3server局域网配置/gameofwind/
- 转载请注明: fengshen 发表于 Dream of Wind | 一梦风神
