Most visitors online was 11705 , on 26 Apr 2024
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today![b]atum_LoadStrategyPointSummonRangeTimeInfo[/b]
SELECT StartTime, EndTime, SummonRange, StrategyPointSummonCheck, MaxSummonCountDaily
FROM dbo.td_StrategyPointSummonRangeTimeInfo WITH (NOLOCK)
[b]atum_UpdateStrategyPointSummonInfoByMapIndex[/b]
DELETE dbo.td_StrategyPointSummonInfo
WHERE MapIndex NOT IN (SELECT MapIndex FROM atum2_db_account.dbo.ti_StrategyPointSummonMapIndex)
INSERT INTO dbo.td_StrategyPointSummonInfo
SELECT MapIndex, 0, GetDATE(), NULL
FROM atum2_db_account.dbo.ti_StrategyPointSummonMapIndex
WHERE MapIndex NOT IN (SELECT MapIndex FROM dbo.td_StrategyPointSummonInfo)
[b]atum_UpdateStrategyPointSummonInfoByNewSummonRange[/b]
UPDATE dbo.td_StrategyPointSummonInfo SET SummonCount = SummonCount + 1
DECLARE @tmNewSTime DATETIME
SET @tmNewSTime =
(SELECT EndTime FROM dbo.td_StrategyPointSummonRangeTimeInfo)
DECLARE @tmSummonRange SMALLINT
SET @tmSummonRange =
(SELECT SummonRange FROM atum2_db_account.dbo.td_StrategyPointSummonRange)
DECLARE @tmStrategyPointSummonCheck TINYINT
SET @tmStrategyPointSummonCheck =
(SELECT StrategyPointSummonCheck FROM atum2_db_account.dbo.td_StrategyPointSummonRange)
DECLARE @tmMaxSummonCountDaily TINYINT
SET @tmMaxSummonCountDaily =
(SELECT MaxSummonCountDaily FROM atum2_db_account.dbo.td_StrategyPointSummonRange)
UPDATE dbo.td_StrategyPointSummonRangeTimeInfo
SET StartTime = @tmNewSTime, EndTime = DateAdd(day, @tmSummonRange, EndTime),
SummonRange = @tmSummonRange,
StrategyPointSummonCheck = @tmStrategyPointSummonCheck,
MaxSummonCountDaily = @tmMaxSummonCountDaily
[b]atum_LoadStrategyPointSummonRangeTimeInfo[/b]
SELECT StartTime, EndTime, SummonRange, StrategyPointSummonCheck, MaxSummonCountDaily
FROM dbo.td_StrategyPointSummonRangeTimeInfo WITH (NOLOCK)
[b]atum_LoadStrategyPointSummonInfo[/b]
SELECT MapIndex, SummonCount, SummonTime, SummonAttribute
FROM dbo.td_StrategyPointSummonInfo WITH (NOLOCK)
[b]atum_LoadStrategyPointNotSummonTime[/b]
SELECT DayOfWeek, StartTime, EndTime, CheckSummon
FROM atum2_db_account.dbo.td_StrategyPointNotSummonTime
[b]atum_LoadRenewalStrategyPointSummonTime[/b]
SELECT DayOfWeek, StartTime, EndTime, CountBCU, CountANI
FROM td_RenewalStrategyPointSummonTime WITH(NOLOCK)
[b]atum_LoadStrategyPointMapInfluenceInfo[/b]
SELECT MapIndex, MapName, MapInfluenceType
FROM atum2_db_account.dbo.ti_MapInfo
WHERE MapIndex IN (SELECT MapIndex FROM atum2_db_account.dbo.ti_StrategyPointSummonMapIndex)
[b]atum_LoadStrategyPointSummonInfo[/b]
SELECT MapIndex, SummonCount, SummonTime, SummonAttribute
FROM dbo.td_StrategyPointSummonInfo WITH (NOLOCK)