================
-- 怪物刷新间隔
UPDATE Tab_RefNest SET dwDelayTimeMin = 30, dwDelayTimeMax = 30; -- 固定 30 秒刷一次
UPDATE Tab_RefNest SET dwDelayTimeMin = 10, dwDelayTimeMax = 10; -- 固定 10 秒刷一次
================
================
--- 去除长按，敦煌的高级怪
USE [SRO_VT_SHARD];
GO
-- 1) 备份这 8 个巢穴（原样保留所有字段）
IF OBJECT_ID('dbo.Tab_RefNest_Gate8Backup','U') IS NOT NULL
DROP TABLE dbo.Tab_RefNest_Gate8Backup;
GO
SELECT n.* INTO dbo.Tab_RefNest_Gate8Backup FROM Tab_RefNest n
WHERE n.dwNestID IN (77778,77779,77780,77781,77782,77783,77784,77785);
GO
-- 2) 停刷：8 个城门口巢穴 刷怪数量清零
UPDATE n SET n.dwMaxTotalCount = 0 FROM Tab_RefNest n
WHERE n.dwNestID IN (77778,77779,77780,77781,77782,77783,77784,77785);
GO
-- 3) 验证（应显示全部 cnt=0）
SELECT n.dwNestID, n.dwTacticsID, n.nRegionDBID, n.dwMaxTotalCount AS cnt, t.dwObjID, c.CodeName128 AS mob
FROM Tab_RefNest n
JOIN Tab_RefTactics t ON t.dwTacticsID = n.dwTacticsID
LEFT JOIN _RefObjCommon c ON c.ID = t.dwObjID
WHERE n.dwNestID IN (77778,77779,77780,77781,77782,77783,77784,77785)
ORDER BY n.dwNestID;
GO
================
USE [SRO_VT_SHARD];
GO
-- 从备份表写回原刷怪数量
UPDATE n SET n.dwMaxTotalCount = b.dwMaxTotalCount
FROM Tab_RefNest n
JOIN dbo.Tab_RefNest_Gate8Backup b ON b.dwNestID = n.dwNestID;
GO
-- 验证（应恢复为停刷前的原数量）
SELECT n.dwNestID, n.dwTacticsID, n.nRegionDBID, n.dwMaxTotalCount AS cnt, t.dwObjID, c.CodeName128 AS mob
FROM Tab_RefNest n
JOIN Tab_RefTactics t ON t.dwTacticsID = n.dwTacticsID
LEFT JOIN _RefObjCommon c ON c.ID = t.dwObjID
WHERE n.dwNestID IN (77778,77779,77780,77781,77782,77783,77784,77785)
ORDER BY n.dwNestID;
GO
================
================
-- 影响装备爆出
-- 注：ReqOnlineTime 代表角色在线时长（分钟）
-- 0分钟可出：白装
UPDATE _RefDropOptLvlSel SET ReqOnlineTime = 0 WHERE OptLevel = 0;
-- 1~3分钟可出：1~3星魔法装备（蓝装）
UPDATE _RefDropOptLvlSel SET ReqOnlineTime = 0 WHERE OptLevel = 1;
UPDATE _RefDropOptLvlSel SET ReqOnlineTime = 0 WHERE OptLevel = 2;
UPDATE _RefDropOptLvlSel SET ReqOnlineTime = 0 WHERE OptLevel = 3;
-- 4~6分钟可出：1~3星暗金装备（60~80级主力）
UPDATE _RefDropOptLvlSel SET ReqOnlineTime = 0 WHERE OptLevel = 4;
UPDATE _RefDropOptLvlSel SET ReqOnlineTime = 0 WHERE OptLevel = 5;
UPDATE _RefDropOptLvlSel SET ReqOnlineTime = 0 WHERE OptLevel = 6;
-- 7~8分钟可出：1~3星月亮装备（80~100级高阶装备）
UPDATE _RefDropOptLvlSel SET ReqOnlineTime = 0 WHERE OptLevel = 7;
UPDATE _RefDropOptLvlSel SET ReqOnlineTime = 0 WHERE OptLevel = 8;
-- 9~11分钟可出：1~3星太阳装备（100级+ 顶级装备）
UPDATE _RefDropOptLvlSel SET ReqOnlineTime = 0 WHERE OptLevel = 9;
UPDATE _RefDropOptLvlSel SET ReqOnlineTime = 0 WHERE OptLevel = 10;
UPDATE _RefDropOptLvlSel SET ReqOnlineTime = 0 WHERE OptLevel = 11;
-- 12分钟可出：终极/毕业暗金装备（110级版本最强极品）
UPDATE _RefDropOptLvlSel SET ReqOnlineTime = 0 WHERE OptLevel = 12;
================
================
-- 强化修改
-- ====== 备份 =====
DROP TABLE IF EXISTS _RefDropOptLvlSel_BAK;
SELECT * INTO _RefDropOptLvlSel_BAK FROM _RefDropOptLvlSel;
-- ====== 修改（只改 VALUES 里 1~7 的权重数字） ======
WITH rates AS (
SELECT v.OptLevel, v.Rate
FROM (VALUES
(0, 0), -- +0: 权重 0
(1, 10), -- +1: 权重
(2, 10), -- +2: 权重
(3, 10), -- +3: 权重
(4, 10), -- +4: 权重
(5, 10), -- +5: 权重
(6, 10), -- +6: 权重
(7, 10), -- +7: 权重
(8, 0), -- +8: 0
(9, 0), -- +9: 0
(10,0), -- +10: 0
(11,0), -- +11: 0
(12,0) -- +12: 0
) AS v(OptLevel, Rate)
),
norm AS (
SELECT OptLevel, Rate, SUM(Rate) OVER() AS total
FROM rates
)
UPDATE t SET Prob = (SELECT SUM(n2.Rate) FROM norm n2 WHERE n2.OptLevel <= t.OptLevel) / (SELECT MAX(total) FROM norm)
FROM _RefDropOptLvlSel t
WHERE EXISTS (SELECT 1 FROM norm n WHERE n.OptLevel = t.OptLevel);
-- ====== 还原 ======
DELETE FROM _RefDropOptLvlSel;
INSERT INTO _RefDropOptLvlSel SELECT * FROM _RefDropOptLvlSel_BAK;
=================
相关游戏下载：
丝路传说单机版，问题BUG最少的丝路传说单机端服务端
https://www.wangdanyouxi.com/thread-2946-1-1.html
目前本人能找到问题最少的丝路传说单机端
https://www.0du.net/thread-9512-1-1.html